Map the resident demand drivers around The Bend at Highland Meadows, covering major employers, schools, healthcare access, retail, recreation, and commuting corridors within the trade area. My primary use for this analysis is leasing and marketing strategy. Identify which demand drivers are strongest in this submarket, which resident cohorts are most sensitive to each, and flag any drivers that are underleveraged in current positioning or marketing.
cat << 'EOF' > distances.py
import math
def haversine(lat1, lon1, lat2, lon2):
R = 3958.8 # miles
phi1, phi2 = math.radians(lat1), math.radians(lat2)
dphi = math.radians(lat2-lat1)
dlambda = math.radians(lon2-lon1)
a = math.sin(dphi/2)**2 + math.cos(phi1)*math.cos(phi2)*math.sin(dlambda/2)**2
return 2*R*math.asin(math.sqrt(a))
subject = (40.464006364345636, -104.98461663722992)
points = {
"UCHealth Medical Center of the Rockies": (40.4155105, -104.9978679),
"UCHealth Emergency Care (MCR campus)": (40.416223, -104.9968725),
"Promenade Shops at Centerra": (40.4167891, -104.9896664),
"Centerra Marketplace": (40.4081347, -105.0073751),
"Amazon DDE8 Fulfillment Center": (40.4314749, -105.0098267),
"Foxtrail Office Park": (40.4089539, -104.9997578),
"Bamford Elementary School": (40.46233, -104.985085),
"Loveland Sports Park": (40.4019301, -105.0192148),
"I-25 / US-34 Interchange (approx)": (40.4083, -105.0100),
}
for name, (lat, lon) in points.items():
d = haversine(*subject, lat, lon)
print(f"{name}: {d:.2f} mi")
EOF
python3 distances.pycat << 'EOF' >> distances.py
extra = {
"King Soopers (29th St)": (40.4250478, -105.0755811),
"Front Range Business Centers": (40.4097787, -105.0007876),
}
print("---extra---")
for name, (lat, lon) in extra.items():
d = haversine(*subject, lat, lon)
print(f"{name}: {d:.2f} mi")
EOF
python3 distances.pyThe Bend at Highland Meadows sits on strong demand fundamentals — a top-tier regional hospital, a lifestyle retail hub, and the region's primary interstate interchange, all within a 3-4 mile radius — but the property isn't capturing that demand. Retention is 37% against a 68% submarket average, occupancy has fallen 350bps in a year, and new leases are trading down 5%. This is a marketing and positioning gap, not a market gap.
Demand driver scorecard
| Driver | Distance/Proximity | Strength | Most-Sensitive Resident Cohort | Currently Leveraged in Positioning? |
|---|---|---|---|---|
| UCHealth Medical Center of the Rockies + Emergency Care campus | 3.3-3.4 mi1 | Strong2 | Healthcare shift workers & clinical staff | No |
| I-25/US-34 interchange & regional commuter access (incl. Bustang regional bus) | ~4 mi | Strong | Fort Collins/Denver/Boulder commuters seeking lower cost than in-market housing | Partial |
| Promenade Shops at Centerra + Centerra Marketplace (retail/lifestyle center) | 3.3-4.0 mi | Moderate-Strong | Dual-income professionals and retirees valuing convenience retail | Partial |
| Employment base — Amazon DDE8 fulfillment center, Foxtrail Office Park, Front Range Business Centers | 2.6-3.9 mi | Moderate | Logistics/warehouse and office/admin workers | No |
| Recreation — Boyd Lake State Park, Loveland Sports Park, Centerra trail network | 4-5 mi | Moderate | Active/outdoor lifestyle renters, families | No |
| Schools — Bamford Elementary (rated 7/10, Above Average) | 0.1 mi; no middle/high school within 3 mi | Weak-Moderate (bifurcated) | Young families with only pre-teen children | No |
| Walkability/bikeability | Walk Score 13 (Car-Dependent), Bike Score 27 | Weak | N/A — signals a fully car-dependent renter base | N/A |
The three strongest drivers, and who they pull
Healthcare employment — the biggest under-messaged asset. Healthcare is the single largest employment sector in the zip code at 20% of workers , anchored by UCHealth Medical Center of the Rockies and its adjoining Emergency Care campus 3.3 miles away — a round-the-clock, shift-based employer generating exactly the renter profile (nurses, techs, night-shift staff) that prizes a short, reliable commute over neighborhood walkability. Nothing in the property's listed amenity set (pool, fitness center, business center, dog park) speaks to that cohort's real pain point: odd-hour commute reliability and secure package/parking access for irregular schedules.
The I-25/US-34 interchange — the region's commuting backbone. The interchange sits roughly 4 miles from the property and is the primary artery for Fort Collins (CSU, a ~20-minute commute) and Denver/Boulder commuters, with a regional Bustang express-bus stop at nearby Centerra Loveland Station providing an alternative for cost-conscious, longer-haul commuters . This is the value arbitrage play: renters priced out of Fort Collins or Denver-adjacent submarkets but unwilling to give up job access. Given local public-transit usage is under 1% and 92%+ of households own a vehicle — consistent with the property's own Walk Score of 13 ("Car-Dependent") — this cohort commutes almost entirely by car, so drive-time-to-employer messaging (not walkability) is what will resonate.
Retail and lifestyle anchor at Centerra. The Promenade Shops at Centerra and Centerra Marketplace sit 3.3-4.0 miles away and give the trade area a genuine lifestyle-retail identity — grocery, dining, entertainment — that pairs naturally with the zip's consumer profile: residents here over-index on DoorDash ordering, craft beer, amusement-park outings, and pet adoption relative to national baseline . That skews toward young professionals and empty-nesters (23% of the zip's population is retirees) who want convenience without full urban density.
Where the cohort mismatch shows up
The zip's median household income is $96,350 (renter median $70,169) , and in-migrants arrive with roughly $5,700 more household income than out-migrants leave with — a mild wealth-upgrade signal that should support the property's $2,174 average in-place rent, an 18.5% premium to the Loveland submarket's $1,835 average . The rent basis is defensible. The performance gap sits elsewhere: 37.4% retention against 67.8% for the Loveland submarket, and new leases signing 80 median days on market versus 49 submarket-wide — residents are leaving faster than the market norm and replacements are taking 60% longer to find, and even then trading down 5% on the new lease .
Underleveraged drivers — three fixes for marketing
The school picture is a real, if narrower, constraint worth flagging rather than fixing through marketing: Bamford Elementary is excellent and steps away, but no middle or high school falls within 3 miles — family renters with school-age kids beyond elementary will factor that commute into their decision regardless of how the property is marketed.
Bottom line for leasing: don't chase a demand problem — the trade area has three legitimate, underused hooks (hospital shift workers, interstate commuters, active/lake lifestyle). Redirect creative and outreach toward those cohorts specifically, and pair it with a retention-focused push (the 37% figure is the more urgent fire) since a property that can't hold residents will keep bleeding leasing costs no matter how sharp the acquisition marketing gets.
This is a read-only snapshot of a RealAI analysis.