4148 MESQUITE, Cedar Hills, UT 84062
5BD/—BA Residential in Cedar Hills, UT 84062. 5,311 sqft. Built 2006. Listed at $1,075,000. MLS #2163688.
5BD/—BA Residential in Cedar Hills, UT 84062. 5,311 sqft. Built 2006. Listed at $1,075,000. MLS #2163688.
Beautiful Cedar Hills home with stunning mountain views, spacious living areas, and vaulted ceilings throughout. The thoughtfully designed floor plan features a dedicated office and formal dining room on the main level, along with two main-floor primary suites-a rare and highly desirable feature that provides comfort, privacy, and convenience. The luxurious primary suite includes a fireplace, large walk-in closet, jetted tub, and French doors leading to a private patio. The finished basement includes a separate entrance and a wet bar that can be easily converted to a full kitchen, creating excellent potential for a future mother-in-law apartment or rental income opportunity. Solar panels will be paid off at closing, significantly reducing energy costs. Outside, enjoy a large, well-maintained yard with two patios, a putting green, gardening grow boxes, and amazing views. Whether entertaining guests or relaxing at home, this property offers the perfect blend of comfort, versatility, and exceptional outdoor living in one of Cedar Hills most desirable locations.
Property Type
Residential
Property Style
Single Family Residence
Architectural Style
Rambler/Ranch
Stories
2
Subdivision
JUNIPER HEIGHTS
County
Utah
Zoning
Single-Family
Construction
Stone,Stucco
Lot Size
0.39 sq ft
Above Grade Area
2,594 sq ft
Condition
Blt./Standing
MLS #
2163688
Property Type
Residential
Property Style
Single Family Residence
Architectural Style
Rambler/Ranch
Stories
2
Subdivision
JUNIPER HEIGHTS
County
Utah
Zoning
Single-Family
Construction
Stone,Stucco
Lot Size
0.39 sq ft
Above Grade Area
2,594 sq ft
Condition
Blt./Standing
MLS #
2163688
List Price
$1,075,000
Annual Taxes
$4,626
Home Warranty
No
List Price
$1,075,000
Annual Taxes
$4,626
Home Warranty
No
Heating
Forced Air,Gas: Central
Cooling
Central Air
Roof
Asphalt
Flooring
Carpet,Tile
Basement
Full
Materials
Stone,Stucco
Appliances
Ceiling Fan,Trash Compactor,Microwave,Water Softener Owned
Patio & Porch
Covered,Porch: Open,Patio: Open
Water Source
Culinary,Secondary
Sewer
Sewer: Connected,Sewer: Public
View
Mountain(s)
Heating
Forced Air,Gas: Central
Cooling
Central Air
Roof
Asphalt
Flooring
Carpet,Tile
Basement
Full
Materials
Stone,Stucco
Appliances
Ceiling Fan,Trash Compactor,Microwave,Water Softener Owned
Patio & Porch
Covered,Porch: Open,Patio: Open
Water Source
Culinary,Secondary
Sewer
Sewer: Connected,Sewer: Public
View
Mountain(s)
Garage Spaces
3
Covered Spaces
3
Total Parking
3
Garage Spaces
3
Covered Spaces
3
Total Parking
3
Why this is a deal
Classification
Standard
Deal Score
62/100
vs Similar Homes
12% above
vs Market Median
9% above
Area Growth (YoY)
5.2%
Deal Score Breakdown
62/100 · 1 qualifying signal
5.2% year-over-year ZHVI growth in this area
Priced 9% above the per-subtype city median
Priced 12% above the median of similar listings
LT net cashflow -$1,909/mo (-26.5% return on ownership cost) · STR net cashflow -$3,743/mo (-51.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
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,030/mo
Range: $5,341 – $6,719
Net Monthly Cash Flow
−$1,909 /mo (−$22,909/yr)
Monthly rental income
Monthly ownership cost
Coverage
84%
Net /mo
−$1,909
DSCR
0.98
Est. Annual Revenue
$59,516/yr
$358/night · 41% occupancy · $123/bedroom · $0.38/sqft
Net Monthly Cash Flow
−$3,743 /mo (−$44,921/yr)
Monthly STR income
Monthly ownership cost
Coverage
69%
Net /mo
−$3,743
DSCR
0.64
Elementary
Cedar RidgeMiddle School
Mt RidgeHigh School
Lone PeakSchool District
Alpine
Best Download
10 Gbps
Best Upload
10 Gbps
Fiber Available
Yes
Providers
13
Available Providers
$699,000
+54% vs median
57 days
21
$419,000 – $2,500,000
$4,626
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