152 8750, Huntsville, UT 84317
5BD/—BA Residential in Huntsville, UT 84317. 3,783 sqft. Built 2018. Listed at $2,350,000. MLS #2136212.
5BD/—BA Residential in Huntsville, UT 84317. 3,783 sqft. Built 2018. Listed at $2,350,000. MLS #2136212.
Recently appraised at $2.4M, this custom 5-bedroom, 4-bathroom estate delivers luxury mountain living and a turnkey equestrian setup on 2.5 manicured acres with sweeping views of the Ogden Valley. Inside, soaring ceilings, exposed wood beams, and a floor-to-ceiling stone fireplace set the tone for a home that feels both elevated and lived-in. The gourmet kitchen anchors an open great room built for gathering with custom cabinetry, granite countertops, high-end appliances, and an island that actually fits a crowd. The primary suite is a proper retreat with dual copper sinks, granite finishes, and a walk-in closet worth talking about. Five bedrooms, four bathrooms, a dedicated office, and 3,875 square feet that lives comfortably. Outside is where this property separates itself. Three established paddocks with secondary water for pastures and landscaping, forever fencing with cross-fencing throughout, and a drive-through barn with culinary water run directly to the stalls. Built by someone who actually understands horses, not just someone who wanted the aesthetic. The covered patio and pristine landscaping frame views that don't get old. Minutes from Powder Mountain, Snowbasin, and Wolf Creek. World-class skiing, hiking, and riding practically out your back door. Properties that check every box at this level don't come around often, and this one has already been validated by the market.
Property Type
Residential
Property Style
Single Family Residence
Architectural Style
Stories: 2
Stories
2
County
Weber
Zoning
Single-Family
Construction
Stone,Cement Siding,Other
Lot Size
2.5 sq ft
Above Grade Area
3,783 sq ft
Condition
Blt./Standing
MLS #
2136212
Property Type
Residential
Property Style
Single Family Residence
Architectural Style
Stories: 2
Stories
2
County
Weber
Zoning
Single-Family
Construction
Stone,Cement Siding,Other
Lot Size
2.5 sq ft
Above Grade Area
3,783 sq ft
Condition
Blt./Standing
MLS #
2136212
List Price
$2,350,000
Original Price
$2,700,000
HOA Fees
$250 / Annually
Annual Taxes
$9,585
Home Warranty
No
List Price
$2,350,000
Original Price
$2,700,000
HOA Fees
$250 / Annually
Annual Taxes
$9,585
Home Warranty
No
Heating
Electric,Forced Air,Gas: Central,Heat Pump,Radiant Floor
Cooling
Central Air,Heat Pump
Roof
Asphalt,Pitched
Flooring
Laminate,Tile
Basement
None
Materials
Stone,Cement Siding,Other
Appliances
Ceiling Fan,Microwave,Range Hood
Patio & Porch
Covered,Porch: Open
Water Source
Culinary,Irrigation: Pressure,Secondary,Well
Sewer
Septic Tank
View
Mountain(s)
Heating
Electric,Forced Air,Gas: Central,Heat Pump,Radiant Floor
Cooling
Central Air,Heat Pump
Roof
Asphalt,Pitched
Flooring
Laminate,Tile
Basement
None
Materials
Stone,Cement Siding,Other
Appliances
Ceiling Fan,Microwave,Range Hood
Patio & Porch
Covered,Porch: Open
Water Source
Culinary,Irrigation: Pressure,Secondary,Well
Sewer
Septic Tank
View
Mountain(s)
Garage Spaces
4
Covered Spaces
4
Total Parking
4
Garage Spaces
4
Covered Spaces
4
Total Parking
4
Why this is a deal
Classification
Standard
Deal Score
78/100
vs Similar Homes
1% above
vs Market Median
12% above
Price Reduced
13.0%
Area Growth (YoY)
-0.0%
Deal Score Breakdown
78/100 · 1 qualifying signal
13% price reduction from original list — seller may be motivated
Priced 1% above the median of similar listings
Priced 12% above the per-subtype city median
-0.0% year-over-year ZHVI growth in this area
LT net cashflow -$10,442/mo (-66.3% return on ownership cost) · STR net cashflow -$13,715/mo (-87.1% return). Uses the better of LT or STR against total monthly ownership cost (P&I, tax, insurance, HOA, maintenance).
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
$6,031/mo
Range: $2,316 – $9,745
Net Monthly Cash Flow
−$10,442 /mo (−$125,309/yr)
Monthly rental income
Monthly ownership cost
Coverage
38%
Net /mo
−$10,442
DSCR
0.45
Est. Annual Revenue
$34,880/yr
$160/night · 57% occupancy · $64/bedroom · $0.11/sqft
Net Monthly Cash Flow
−$13,715 /mo (−$164,577/yr)
Monthly STR income
Monthly ownership cost
Coverage
19%
Net /mo
−$13,715
DSCR
0.17
$1,000,000
+135% vs median
105 days
37
$495,000 – $14,950,000
$9,585
$250/annually
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