486 100, Tremonton, UT 84337
5BD/—BA Residential in Tremonton, UT 84337. 6,012 sqft. Built 2006. Listed at $1,100,000. MLS #2152095.
5BD/—BA Residential in Tremonton, UT 84337. 6,012 sqft. Built 2006. Listed at $1,100,000. MLS #2152095.
Welcome to this exquisite custom-designed residence nestled in a premier, high-end neighborhood, where thoughtful craftsmanship and timeless elegance meet everyday comfort. From the moment you arrive, the home's striking curb appeal, mature landscaping, and quiet cul-de-sac setting create a warm and inviting first impression. Inside, you'll find a beautifully curated floor plan designed with both functionality and grandeur in mind. Expansive vaulted ceilings and a stunning central fireplace anchor the main living space, while large windows invite in natural light and showcase the seamless indoor-outdoor connection. The chef's kitchen is a true centerpiece, featuring granite countertops, double wall ovens, and a commercial-size refrigerator/freezer-perfect for both daily living and entertaining. Main-level living offers convenience and ease, highlighted by spacious bedrooms, generously sized bathrooms, and a large, well-appointed laundry room. Just off the garage, a versatile storage room provides the perfect space for organization or even recreational gear. The attached shop adds exceptional flexibility for hobbies, projects, or additional workspace. The fully finished basement is designed for entertaining and relaxation, complete with a stylish wet bar and a dedicated theater room featuring seating, projector, screen, and components included. A walk-out basement provides direct exterior access and enhances the home's open, flowing layout. Step outside to enjoy a large covered patio, ideal for year-round gatherings, overlooking a fully fenced backyard with lush, mature landscaping-offering both privacy and beauty. Additional features include dual HVAC systems for improved efficiency, pre-plumbing for central vacuum, and electrical readiness for a backup generator-reflecting the careful planning and quality invested throughout. This home is a rare blend of sophistication, comfort, and thoughtful design-truly a standout property in an exceptional location. Buyer to verify all information. Be sure to click on the 3D tour for the interior floor plan and video tour. Property shown to pre-approved and qualified buyers only. 24 Hour notice for all showings.
Property Type
Residential
Property Style
Single Family Residence
Architectural Style
Stories: 2
Stories
3
Subdivision
HOLMGREN ESTATE
County
Box Elder
Zoning
Single-Family
Construction
Stone,Stucco
Lot Size
0.45 sq ft
Above Grade Area
3,991 sq ft
Condition
Blt./Standing
MLS #
2152095
Property Type
Residential
Property Style
Single Family Residence
Architectural Style
Stories: 2
Stories
3
Subdivision
HOLMGREN ESTATE
County
Box Elder
Zoning
Single-Family
Construction
Stone,Stucco
Lot Size
0.45 sq ft
Above Grade Area
3,991 sq ft
Condition
Blt./Standing
MLS #
2152095
List Price
$1,100,000
Annual Taxes
$5,765
Home Warranty
Yes
List Price
$1,100,000
Annual Taxes
$5,765
Home Warranty
Yes
Heating
Forced Air,Gas: Central
Cooling
Central Air
Roof
Asphalt
Flooring
Carpet,Slate,Travertine,Concrete
Basement
Full,Walk-Out Access
Materials
Stone,Stucco
Appliances
Ceiling Fan,Range Hood,Refrigerator,Water Softener Owned
Laundry
Electric Dryer Hookup,Gas Dryer Hookup
Patio & Porch
Covered,Patio: Open
Water Source
Culinary
Sewer
Sewer: Connected,Sewer: Public
View
Mountain(s),Valley
Heating
Forced Air,Gas: Central
Cooling
Central Air
Roof
Asphalt
Flooring
Carpet,Slate,Travertine,Concrete
Basement
Full,Walk-Out Access
Materials
Stone,Stucco
Appliances
Ceiling Fan,Range Hood,Refrigerator,Water Softener Owned
Laundry
Electric Dryer Hookup,Gas Dryer Hookup
Patio & Porch
Covered,Patio: Open
Water Source
Culinary
Sewer
Sewer: Connected,Sewer: Public
View
Mountain(s),Valley
Garage Spaces
3
Covered Spaces
3
Total Parking
9
Garage Spaces
3
Covered Spaces
3
Total Parking
9
Why this is a deal
Classification
Standard
Deal Score
90/100
vs Similar Homes
125% above
vs Market Median
25% above
Area Growth (YoY)
10.8%
Deal Score Breakdown
90/100 · 1 qualifying signal
10.8% year-over-year ZHVI growth in this area
Priced 125% above the median of similar listings
Priced 25% above the per-subtype city median
STR net cashflow -$5,072/mo (-68.3% 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.
Why this classification
Est. Annual Revenue
$40,393/yr
$109/night · 51% occupancy · $61/bedroom · $0.13/sqft
Net Monthly Cash Flow
−$5,071 /mo (−$60,857/yr)
Monthly STR income
Monthly ownership cost
Coverage
45%
Net /mo
−$5,072
DSCR
0.43
$383,000
+187% vs median
77 days
72
$229,900 – $1,100,000
$5,765
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.
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