260 7900, Huntsville, UT 84317
5BD/—BA Residential in Huntsville, UT 84317. 4,403 sqft. Built 2025. Listed at $2,325,000. MLS #2164043.
5BD/—BA Residential in Huntsville, UT 84317. 4,403 sqft. Built 2025. Listed at $2,325,000. MLS #2164043.
Experience refined mountain living in this stunning home at SAGE, now move-in ready. Set on a private 3-acre lot, this 4-bedroom + bunk suite, 5.5-bath residence spans over 4,400 square feet of thoughtfully designed luxury and craftsmanship. Every detail reflects elevated taste-from the Brizo polished nickel and luxe gold fixtures to the dark oak cabinetry paired with aged brass hardware. The chef's kitchen features a full Signature Kitchen Suite appliance package, including a 48" six-burner gas range, fridge/freezer columns, and Scotsman ice maker. Elegant quartz countertops, glossy ceramic backsplash, and soft brass pendants create a warm and timeless atmosphere. The primary suite is a retreat of its own, offering a spa-like bath with matte porcelain floors, soaking tub, and custom gray-brown cabinetry. Upstairs, a bunk room and four additional bedroom suites each feature designer tile, Delta and Brizo plumbing, and curated lighting finishes. Enjoy the seamless connection between the great room, dining, and covered outdoor living spaces-perfect for entertaining or taking in the surrounding views. A four-car garage, expansive mudroom with custom built-ins, and walk-in pantry complete this one-of-a-kind residence. Discover where craftsmanship meets comfort at SAGE Lot 3-ready for immediate occupancy.
Property Type
Residential
Property Style
Single Family Residence
Architectural Style
Stories: 2
Stories
2
Subdivision
SAGE
County
Weber
Construction
Asphalt,Stone,Cement Siding
Lot Size
3.01 sq ft
Above Grade Area
4,403 sq ft
Condition
Blt./Standing
MLS #
2164043
Property Type
Residential
Property Style
Single Family Residence
Architectural Style
Stories: 2
Stories
2
Subdivision
SAGE
County
Weber
Construction
Asphalt,Stone,Cement Siding
Lot Size
3.01 sq ft
Above Grade Area
4,403 sq ft
Condition
Blt./Standing
MLS #
2164043
List Price
$2,325,000
HOA Fees
$205 / Monthly
Annual Taxes
$1
Home Warranty
No
List Price
$2,325,000
HOA Fees
$205 / Monthly
Annual Taxes
$1
Home Warranty
No
Heating
Forced Air,Gas: Central,>= 95% efficiency
Cooling
Central Air
Roof
Asphalt
Flooring
Carpet,Laminate,Tile
Basement
None
Materials
Asphalt,Stone,Cement Siding
Patio & Porch
Covered
Sewer
Sewer: Connected
View
Mountain(s)
Heating
Forced Air,Gas: Central,>= 95% efficiency
Cooling
Central Air
Roof
Asphalt
Flooring
Carpet,Laminate,Tile
Basement
None
Materials
Asphalt,Stone,Cement Siding
Patio & Porch
Covered
Sewer
Sewer: Connected
View
Mountain(s)
Garage Spaces
4
Covered Spaces
4
Total Parking
4
Garage Spaces
4
Covered Spaces
4
Total Parking
4
Classification
Standard
Deal Score
50/100
vs Similar Homes
1% below
vs Market Median
0% above
Area Growth (YoY)
-2.9%
Deal Score Breakdown
50/100
Priced 1% below the median of similar listings
Priced 0% above the per-subtype city median
-2.9% year-over-year ZHVI growth in this area
LT net cashflow -$8,710/mo (-58.2% return on ownership cost) · STR net cashflow -$11,694/mo (-78.1% 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
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.
Monthly Rent
$7,120/mo
Range: $4,116 – $10,124
Net Monthly Cash Flow
−$8,710 /mo (−$104,521/yr)
Monthly rental income
Monthly ownership cost
Coverage
48%
Net /mo
−$8,710
DSCR
0.54
Est. Annual Revenue
$56,261/yr
$358/night · 41% occupancy · $123/bedroom · $0.38/sqft
Net Monthly Cash Flow
−$11,694 /mo (−$140,324/yr)
Monthly STR income
Monthly ownership cost
Coverage
31%
Net /mo
−$11,694
DSCR
0.28
Best Download
8 Gbps
Best Upload
8 Gbps
Fiber Available
Yes
Providers
10
Available Providers
$1,000,000
+133% vs median
105 days
37
$495,000 – $14,950,000
$1
$205/monthly
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

Devin Tanner - Utah Realtor

Salt Lake City Specialist Driving Smart Home Deals
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