924 COLLEGE, Millcreek, UT 84117
5BD/—BA Residential in Millcreek, UT 84117. 5,468 sqft. Built 2001. Listed at $1,595,000. MLS #2159247.
5BD/—BA Residential in Millcreek, UT 84117. 5,468 sqft. Built 2001. Listed at $1,595,000. MLS #2159247.
Fantastic Home or Cash-flowing Investment! Instant Equity! Being sold with all furnishings and dcor. Turnkey property management, solid 17 yr rental history, grossing $150-185k/yr. Perfect primary or 2nd Home-currently an Airbnb so showings are only available in between rentals. This centrally located estate offers an open floorplan with custom finishes inside and out. Enjoy the convenience of your own water well, providing free water for the entire home. The beautiful mature landscaped .43 acre yard is fully fenced & easy to maintain. Enjoy radiant heating thru-out the entire home & under the driveway say goodbye to snow! 10-foot ceilings on both levels, a spacious and elegant home theater, and ample storage. The chef's kitchen boasts stainless steel appliances and maple cabinets, perfect for culinary creations. The master suite is a sanctuary with a large bedroom, walk-in closet, and an amazing master bathroom with a separate HUGE jetted tub and shower. Custom lighting illuminates every corner, while the downstairs game room offers a vast, open space for entertainment. Stay comfortable year round with a brand-new AC unit for upstairs & four separate AC and heat wall units for downstairs. Luxurious travertine flooring graces both the main and basement levels, adding a touch of elegance. Outside, enjoy a new hot tub in the shaded backyard, perfect for relaxation. With plenty of parking, including RV parking, this home is ideal for gatherings. Located centrally, you'll be close to everything Salt Lake has to offer. This property also has a proven track record as a successful short and long-term rental for 15 years, making it a fantastic investment opportunity with management in place & Turnkey! Don't miss out on this luxury estate with a private gate, offering the ultimate blend of comfort, convenience, and sophistication.
Property Type
Residential
Property Style
Single Family Residence
Architectural Style
Rambler/Ranch
Stories
2
County
Salt Lake
Zoning
Single-Family
Construction
Stone,Stucco
Lot Size
0.43 sq ft
Above Grade Area
2,734 sq ft
Condition
Blt./Standing
MLS #
2159247
Property Type
Residential
Property Style
Single Family Residence
Architectural Style
Rambler/Ranch
Stories
2
County
Salt Lake
Zoning
Single-Family
Construction
Stone,Stucco
Lot Size
0.43 sq ft
Above Grade Area
2,734 sq ft
Condition
Blt./Standing
MLS #
2159247
List Price
$1,595,000
Annual Taxes
$6,597
Home Warranty
No
List Price
$1,595,000
Annual Taxes
$6,597
Home Warranty
No
Heating
Gas: Radiant,Wall Furnace,Radiant Floor
Cooling
Central Air
Roof
Asphalt
Flooring
Carpet,Tile,Travertine
Basement
Daylight,Full
Materials
Stone,Stucco
Laundry
Electric Dryer Hookup,Gas Dryer Hookup
Patio & Porch
Covered,Patio: Open
Water Source
Private,Shares,Well
Sewer
Sewer: Available,Sewer: Connected,Sewer: Public
View
Mountain(s)
Heating
Gas: Radiant,Wall Furnace,Radiant Floor
Cooling
Central Air
Roof
Asphalt
Flooring
Carpet,Tile,Travertine
Basement
Daylight,Full
Materials
Stone,Stucco
Laundry
Electric Dryer Hookup,Gas Dryer Hookup
Patio & Porch
Covered,Patio: Open
Water Source
Private,Shares,Well
Sewer
Sewer: Available,Sewer: Connected,Sewer: Public
View
Mountain(s)
Garage Spaces
4
Covered Spaces
4
Total Parking
12
Garage Spaces
4
Covered Spaces
4
Total Parking
12
Classification
Standard
Deal Score
30/100
vs Market Median
7% above
Area Growth (YoY)
2.5%
Deal Score Breakdown
30/100
Priced 7% above the per-subtype city median
2.5% year-over-year ZHVI growth in this area
LT net cashflow -$1,190/mo (-11.2% return on ownership cost) · STR net cashflow -$6,780/mo (-63.8% return). Uses the better of LT or STR against total monthly ownership cost (P&I, tax, insurance, HOA, maintenance).
No price reduction from original list
Not enough comparable listings
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
$10,721/mo
Range: $8,493 – $12,949
Net Monthly Cash Flow
−$1,190 /mo (−$14,286/yr)
Monthly rental income
Monthly ownership cost
Coverage
101%
Net /mo
−$1,190
DSCR
1.19
Est. Annual Revenue
$65,897/yr
$395/night · 39% occupancy · $131/bedroom · $0.43/sqft
Net Monthly Cash Flow
−$6,781 /mo (−$81,373/yr)
Monthly STR income
Monthly ownership cost
Coverage
52%
Net /mo
−$6,780
DSCR
0.48
Elementary
Hill ViewMiddle School
BonnevilleHigh School
CottonwoodSchool District
Granite
Best Download
10 Gbps
Best Upload
10 Gbps
Fiber Available
Yes
Providers
13
Available Providers
$632,700
+152% vs median
52 days
105
$230,000 – $5,295,000
$6,597
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