1034 9150, Huntsville, UT 84317
6BD/—BA Residential in Huntsville, UT 84317. 9,107 sqft. Built 2019. Listed at $5,500,000. MLS #2154352.
6BD/—BA Residential in Huntsville, UT 84317. 9,107 sqft. Built 2019. Listed at $5,500,000. MLS #2154352.
BEING OFFERED FULLY FURNISHED! Where mountain mornings meet lakeside afternoons, this private mountain retreat represents one of the highest levels of quality and design in Ogden Valley. Set on over three private acres with a river running along the backyard, the property offers rare seclusion while remaining just minutes from Snowbasin, Powder Mountain, and Pineview Reservoir. Exceptional craftsmanship is evident throughout, including radiant heated floors, en-suite baths, and thoughtfully designed spaces that balance comfort with architectural presence. The main level features a chef's kitchen with Wolf appliances and butler's pantry, expansive gathering areas, a private primary suite, and dedicated office. Designed for hosting at every scale, the lower level includes a secondary kitchen, bar, lounge, golf simulator, and guest accommodations. Outdoor living extends to covered terraces with fireplaces, a lighted pickleball court, and open acreage. A rare opportunity to own a private mountain retreat in one of Northern Utah's most sought after communities. All property information, boundaries and documents to be verified by buyer.
Property Type
Residential
Property Style
Single Family Residence
Architectural Style
Stories: 2
Stories
3
Subdivision
SILVER SUMMIT ESTATES
County
Weber
Zoning
Single-Family
Construction
Stone,Other
Lot Size
3.1 sq ft
Above Grade Area
4,793 sq ft
Condition
Blt./Standing
MLS #
2154352
Property Type
Residential
Property Style
Single Family Residence
Architectural Style
Stories: 2
Stories
3
Subdivision
SILVER SUMMIT ESTATES
County
Weber
Zoning
Single-Family
Construction
Stone,Other
Lot Size
3.1 sq ft
Above Grade Area
4,793 sq ft
Condition
Blt./Standing
MLS #
2154352
List Price
$5,500,000
Annual Taxes
$16,647
Home Warranty
No
List Price
$5,500,000
Annual Taxes
$16,647
Home Warranty
No
Heating
Forced Air,Gas: Central,Radiant Floor
Cooling
Central Air
Roof
Asphalt
Flooring
Carpet,Tile
Basement
Full
Materials
Stone,Other
Appliances
Ceiling Fan,Dryer,Freezer,Microwave,Range Hood,Refrigerator,Washer,Water Softener Owned
Laundry
Electric Dryer Hookup
Patio & Porch
Covered
Water Source
Well
Sewer
Septic Tank
View
Mountain(s)
Heating
Forced Air,Gas: Central,Radiant Floor
Cooling
Central Air
Roof
Asphalt
Flooring
Carpet,Tile
Basement
Full
Materials
Stone,Other
Appliances
Ceiling Fan,Dryer,Freezer,Microwave,Range Hood,Refrigerator,Washer,Water Softener Owned
Laundry
Electric Dryer Hookup
Patio & Porch
Covered
Water Source
Well
Sewer
Septic Tank
View
Mountain(s)
Garage Spaces
6
Covered Spaces
6
Total Parking
6
Garage Spaces
6
Covered Spaces
6
Total Parking
6
Classification
Standard
Deal Score
10/100
vs Market Median
27% above
Area Growth (YoY)
-1.9%
Deal Score Breakdown
10/100
Priced 27% above the per-subtype city median
-1.9% year-over-year ZHVI growth in this area
LT net cashflow -$22,634/mo (-62.3% return on ownership cost) · STR net cashflow -$31,939/mo (-87.9% 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.
Monthly Rent
$15,563/mo
Range: $8,997 – $22,128
Net Monthly Cash Flow
−$22,634 /mo (−$271,612/yr)
Monthly rental income
Monthly ownership cost
Coverage
43%
Net /mo
−$22,634
DSCR
0.50
Est. Annual Revenue
$75,260/yr
$358/night · 41% occupancy · $123/bedroom · $0.38/sqft
Net Monthly Cash Flow
−$31,939 /mo (−$383,264/yr)
Monthly STR income
Monthly ownership cost
Coverage
17%
Net /mo
−$31,939
DSCR
0.16
Best Download
2 Gbps
Best Upload
2 Gbps
Fiber Available
Yes
Providers
11
Available Providers
$1,000,000
+450% vs median
105 days
37
$495,000 – $14,950,000
$16,647
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