1246 4500, Millcreek, UT 84117
5BD/—BA Residential in Millcreek, UT 84117. 2,806 sqft. Built 2012. Listed at $675,000. MLS #2155204.
5BD/—BA Residential in Millcreek, UT 84117. 2,806 sqft. Built 2012. Listed at $675,000. MLS #2155204.
This Millcreek end-unit townhome stands out with space and flexibility you don't typically find. Sitting on a rare 0.17-acre lot, it offers 5 bedrooms, 2 bonus rooms, and 2.25 bathrooms, giving you room to live, work, and grow without feeling boxed in. The end-unit location brings added privacy and natural light, while the layout provides options for home offices, gym space, or additional living areas. New carpet upstairs adds a fresh touch and move-in-ready feel to the home. Located just off 4500 South with quick freeway access, you get both convenience and a central Millcreek location. Square footage figures are provided as a courtesy estimate only and were obtained from County Records . Buyer is advised to obtain an independent measurement.
Property Type
Residential
Property Style
Townhouse
Architectural Style
Townhouse; Row-end
Stories
2
Subdivision
AUBURN COURT
County
Salt Lake
Zoning
Single-Family
Construction
Frame,Stucco
Lot Size
0.17 sq ft
Above Grade Area
1,403 sq ft
Condition
Blt./Standing
MLS #
2155204
Property Type
Residential
Property Style
Townhouse
Architectural Style
Townhouse; Row-end
Stories
2
Subdivision
AUBURN COURT
County
Salt Lake
Zoning
Single-Family
Construction
Frame,Stucco
Lot Size
0.17 sq ft
Above Grade Area
1,403 sq ft
Condition
Blt./Standing
MLS #
2155204
List Price
$675,000
HOA Fees
$800 / Quarterly
Annual Taxes
$4,411
Home Warranty
No
List Price
$675,000
HOA Fees
$800 / Quarterly
Annual Taxes
$4,411
Home Warranty
No
Heating
Gas: Central
Cooling
Central Air
Roof
Asphalt
Flooring
Carpet,Tile
Basement
Full
Materials
Frame,Stucco
Appliances
Ceiling Fan,Dryer,Microwave,Refrigerator,Washer
Laundry
Electric Dryer Hookup
Water Source
Culinary,Irrigation
Sewer
Sewer: Connected
Heating
Gas: Central
Cooling
Central Air
Roof
Asphalt
Flooring
Carpet,Tile
Basement
Full
Materials
Frame,Stucco
Appliances
Ceiling Fan,Dryer,Microwave,Refrigerator,Washer
Laundry
Electric Dryer Hookup
Water Source
Culinary,Irrigation
Sewer
Sewer: Connected
Garage Spaces
2
Covered Spaces
3
Total Parking
3
Garage Spaces
2
Covered Spaces
3
Total Parking
3
Why this is a deal
Classification
Strong Cash FlowDeal Score
65/100
vs Similar Homes
5% above
vs Market Median
8% above
Area Growth (YoY)
2.5%
Deal Score Breakdown
65/100 · 1 qualifying signal
LT net cashflow +$246/mo (+5.0% return on ownership cost) · STR net cashflow -$1,416/mo (-28.9% return). Uses the better of LT or STR against total monthly ownership cost (P&I, tax, insurance, HOA, maintenance).
Priced 8% above the per-subtype city median
2.5% year-over-year ZHVI growth in this area
Priced 5% above the median of similar listings
No price reduction from original list
Ensemble scoring: the best single signal sets the floor, secondary qualifying signals (≥60) each add 5 points up to +20. A home that strongly wins on one dimension is already a great deal — it doesn't need to tick every box.
Why this classification
Monthly Rent
$5,845/mo
Range: $5,038 – $6,653
Net Monthly Cash Flow
+$246 /mo (+$2,954/yr)
Monthly rental income
Monthly ownership cost
Coverage
119%
Net /mo
+$246
DSCR
1.53
Est. Annual Revenue
$59,690/yr
$395/night · 39% occupancy · $131/bedroom · $0.43/sqft
Net Monthly Cash Flow
−$1,416 /mo (−$16,988/yr)
Monthly STR income
Monthly ownership cost
Coverage
102%
Net /mo
−$1,416
DSCR
1.04
Best Download
10 Gbps
Best Upload
10 Gbps
Fiber Available
Yes
Providers
13
Available Providers
$632,700
+7% vs median
52 days
105
$230,000 – $5,295,000
$4,411
$800/quarterly
Select agents you’d like to hear from. They’ll be notified of your interest — your contact details stay private until you choose to respond.

Salt Lake City Real Estate Broker Focused on Pricing, Positioning, and Results

Daryn Edmunds - High Road Properties

Devin Tanner - Utah Realtor
Your inquiry goes to the listing agent.
Fast Response
Typically within 2 hours during business hours
Built with AI to help you find your perfect home
Powered by AI • Secured by Supabase • Trusted by Agents