What are the the likely resident segments at The Bend at Highland Meadows today? Build a tenant-profile segmentation using household income, age, household type, commute patterns, and likely employment drivers. Explain which amenities and unit types appeal to each segment.
cat << 'EOF' > /vercel/sandbox/segment_calc.py
import json
# Loveland submarket household income distribution (from datamart, mf_tenant_profile at property level was null/insufficient sample -> submarket used)
income_dist = {
"<10k": 0.003518, "10-15k": 0.0, "15-25k": 0.002833, "25-35k": 0.027228,
"35-50k": 0.069724, "50-75k": 0.174662, "75-100k": 0.162607,
"100-150k": 0.226513, "150-200k": 0.038617, "200-350k": 0.144962,
"350-500k": 0.115852, "500k+": 0.033484
}
total = sum(income_dist.values())
print("sum check:", round(total,4))
# Property asking rents by unit type
rents = {"1bd": 1648.33, "2bd": 2265.00, "3bd": 2701.00}
annual = {k: v*12 for k,v in rents.items()}
# standard affordability underwriting rule: qualifying income = rent*12/0.30 (30% rent-to-income threshold)
qualifying_income = {k: round(v/0.30) for k,v in annual.items()}
print("Annual rent:", {k: round(v) for k,v in annual.items()})
print("Qualifying income (30% RTI):", qualifying_income)
# Also compute rent-to-income ratio for submarket median income vs property in-place rent
submarket_hhi_median = 122561
property_avg_inplace_rent = 2173.67
rti_submarket_income = round(property_avg_inplace_rent*12/submarket_hhi_median*100,1)
print("Property avg in-place rent annualized as % of submarket median HHI:", rti_submarket_income, "%")
# household composition context
avg_hh_size_adults = 1.9124
children_per_hh = 0.4075
median_age = 37.5
married_pct = 0.6242
owner_occ_pct = 0.6343
renter_occ_pct = 0.3657
print("num_adults_per_household:", avg_hh_size_adults, "children_per_hh:", children_per_hh)
# occupation mix (submarket, ACS)
occ = {"professional_creative":0.5187, "sales":0.1642, "service":0.1557, "logistics":0.0864, "maintenance":0.075}
print("occupation mix:", occ)
# industry mix top 3
ind = {"healthcare":0.2491, "admin_support":0.1571, "arts_entertainment":0.1006, "retail":0.0897, "manufacturing":0.0809, "construction":0.0829}
sorted_ind = sorted(ind.items(), key=lambda x:-x[1])
print("top industries:", sorted_ind)
EOF
python3 /vercel/sandbox/segment_calc.pyThe Bend at Highland Meadows draws three distinct renter segments off Loveland's healthcare, advanced-manufacturing, and CSU/Fort Collins spillover economy — with the 2-bedroom, dual-income household as the anchor.
Property-level tenant credit/demographic data returned empty for this 198-unit community — likely below the ZIP+4 anonymization threshold — so this segmentation is built from Loveland submarket demographics blended with the property's own unit mix, rents, and amenity set , which are asset-specific and reliable.
| Segment | Unit Type | Qualifying Income | Age/HH Type | Employment Driver | Commute Pattern |
|---|---|---|---|---|---|
| Dual-Income Professional Household | 2BR | $90,6001 | Age 30-45, Married/Partnered | Healthcare & Advanced Manufacturing/Tech (Medical Center of the Rockies, Hach, Advanced Energy, Woodward) | 10-20 min to Centerra/Loveland employers; 20 min to Fort Collins via US-34/I-25 |
| Hybrid-Work Young Professional | 1BR | $65,9001 | Age 24-32, Single or Couple, No Kids | Sales/Admin/Service Occupations; WFH 2-3 Days/Week | Short commute within Loveland; Bus/FLEX to Fort Collins |
| Established Family / Renter-by-Choice | 3BR | $108,0001 | Age 35-50, Married with 1-2 Kids | Professional/Managerial Occupations; Possible Relocation from Denver Metro | Up to 45 min via I-25 to Denver; 20 min to Fort Collins |
Who's here, and why. Loveland's median household income of $122.6K sits at the national 66th percentile but only the submarket-average 33rd percentile within Fort Collins MSA — a market where money goes further than in Fort Collins or Boulder proper. The income distribution is barbell-shaped: 22.7% of households sit in the $100-150K band and another 26% above $200K, while a real tranche (16.3%) sits in $75-100K . That spread maps cleanly onto this property's rent ladder — $1,648 average asking on 1-beds, $2,265 on 2-beds, $2,701 on 3-beds — which is precisely why the 2-bedroom (implying a ~$90.6K qualifying income) is the volume unit: it's the rent point the largest income bracket in the trade area can comfortably clear.
Employment drivers. Healthcare is the single largest local industry (24.9% of workers) , anchored by UCHealth Medical Center of the Rockies and Banner/McKee — a workforce that skews dual-income, shift-based, and values proximity over downtown amenities. Advanced manufacturing and tech (Hach, Advanced Energy, Woodward, Agilent) supply a second, higher-income professional tier, and Colorado State University in Fort Collins (12 miles, ~20-minute drive) pulls a steady commuter flow of faculty, staff, and grad-adjacent renters . Occupationally, over half of area workers (51.9%) fall into professional/creative roles, with sales (16.4%) and service (15.6%) rounding out the base — consistent with a hybrid-work-friendly renter base: the market's own top consumer-behavior signal is "looking for hybrid work" .
Commute patterns. Highland Meadows sits inside Loveland's Centerra growth corridor at the I-25/US-34 interchange — the best-connected node in Northern Colorado, with direct highway access to Fort Collins (12 miles / ~20 min), Denver and its airport (46 miles / ~50 min), and a new Centerra Mobility Hub running rapid-transit bus service to both downtown Fort Collins and Denver's Union Station . That combination — short local commute for Loveland-based healthcare/manufacturing workers, viable regional commute for Denver or CSU-tied households — is what lets this property serve both a live-near-work segment and a live-here-commute-out segment simultaneously.
| Amenity | Segment(s) It Appeals To | Why |
|---|---|---|
| Community Amenities | ||
| Fitness Center | Hybrid-Work Young Professional; Dual-Income Professional Household | Lifestyle and convenience alternative to an off-site gym membership, valued by time-conscious renters |
| Dog Park + Pet Wash Station | Dual-Income Professional Household; Established Family | Supports pet ownership common among these households and reduces off-site pet care trips |
| Business Center | Hybrid-Work Young Professional | Provides a dedicated workspace for remote/WFH days outside the unit |
| Garage / Parking Lot | All Segments (especially Dual-Income Professional Household) | Accommodates two-vehicle households; garage adds security and weather protection valued by dual earners |
| Package Room | Hybrid-Work Young Professional; Dual-Income Professional Household | Secures frequent deliveries for time-poor renters who are often away from home during the day |
| Outdoor Pool | Hybrid-Work Young Professional; Dual-Income Professional Household | On-site recreation and lifestyle amenity that substitutes for off-site leisure spending |
| BBQ / Social Areas | Dual-Income Professional Household; Established Family | Supports outdoor family time and social gatherings close to home |
| Keycard Secure Access | All Segments (especially Dual-Income Professional Household) | Security reassurance for time-poor dual earners and families away from the unit during work hours |
| Unit Amenities | ||
| In-Unit Washer/Dryer | Hybrid-Work Young Professional; Dual-Income Professional Household | Saves time versus shared or off-site laundry, valued by busy working households |
| Private Balcony/Patio | Dual-Income Professional Household; Established Family | Extends living space outdoors for family time and pet use alongside the dog park and BBQ areas |
| Modern Kitchen (Island, Stone Counters) | Established Family; Renter-by-Choice | Higher-touch finishes and added space that help justify the premium on larger 3BR units |
| Smart Thermostat/Locks | Established Family; Renter-by-Choice | Modern convenience and security features that support a higher-touch, upgraded rental experience |
| Walk-In Closets | Established Family; Renter-by-Choice | Added storage space needed for larger households choosing to rent rather than own |
| Central AC | All Segments | Baseline comfort and climate control expected across all resident types |
| Internet Included | Hybrid-Work Young Professional | Bundled high-speed connectivity directly supports remote/WFH days |
Unit-type fit. The 1-bedrooms ($1,648 asking, $2.24/sqft — the highest per-foot rent in the building) are priced for a single renter or couple prioritizing the internet-included, business-center, keycard-secure package over square footage — classic hybrid-work-professional pricing power. The 2-bedrooms are the value anchor at $1.86/sqft, sized for a dual-income couple or small family who wants the in-unit laundry, private patio, and dog park without paying 3-bedroom rent. The 3-bedrooms ($2,701, $1.75/sqft — the property's best per-foot value) target the established-family segment that's outgrown a 2-bed but is choosing to rent rather than buy in a market where the median home is still expensive relative to a $108K household income — the walk-in closets and built-in storage read directly to that renter's "why."
One thing worth flagging: the property's 37.4% trailing retention rate is well below the Loveland submarket's 67.8% , and average in-place rent annualizes to just 21.3% of submarket median income — unusually affordable, suggesting this asset may be under-pricing the segments described here or losing them to churn faster than the market. That's a pricing/retention question the segmentation here sizes the opportunity for, but doesn't answer — happy to dig into lease-level tradeout and turnover drivers next if useful.
This is a read-only snapshot of a RealAI analysis.