646 HIDDEN FARM, Farmington, UT 84025
6BD/—BA Residential in Farmington, UT 84025. 7,335 sqft. Built 2026. Listed at $3,499,900. MLS #2170067.
6BD/—BA Residential in Farmington, UT 84025. 7,335 sqft. Built 2026. Listed at $3,499,900. MLS #2170067.
Welcome to over 7,300 square feet of extraordinary craftsmanship in the heart of Farmington in a quiet cul-de-sac. This stunning modified 'Timpani' plan from local renowned builder has a lot of "wow" factor, starting with the curb appeal and address marquee/water feature. Soaring two-story ceiling with a wood beam grid ceiling, a dramatic floor-to-ceiling fireplace wall, and a chef's kitchen create an entertainer's dream on the main level. Kitchen boasts top-of-the-line appliances, a second island bar, and a butler's pantry/prep kitchen complete with a sink, dishwasher, and 2nd fridge. Custom "pocket office" adjacent to the greatroom. Main level owner's suite on one wing of the home has a spa-like bathroom with his-and-her vanities, a freestanding soaking tub, oversized custom digital shower, and in-suite laundry in the wardrobe room that feels more like a boutique. Every one of the six bedrooms enjoys its own private ensuite bath and a walk-in closet. The upper floor offers three bedrooms with ensuites and a dedicated laundry room. The lower level delivers two additional ensuite bedrooms, a third laundry room, full kitchenette, home theater, and private gym. Adjacent to the finished and heated three-car garage, a private golf simulator lounge with wet bar and sophisticated finishes brings the course home in style. Step outside to a covered outdoor kitchen, fire pit seating area, pickleball court, and custom storage shed to match the home - all set against Utah's stunning mountain backdrop. Built by Symphony Homes - Utah's premier semi-custom builder with over 30 years of award-winning craftsmanship. This is not just a home. It is the life you have been building toward.
Property Type
Residential
Property Style
Single Family Residence
Architectural Style
Stories: 2
Stories
3
Subdivision
HIDDEN FARM ESTATES
County
Davis
Zoning
Single-Family
Construction
Stone,Stucco,Cement Siding
Lot Size
0.43 sq ft
Above Grade Area
4,505 sq ft
Condition
Blt./Standing
MLS #
2170067
Property Type
Residential
Property Style
Single Family Residence
Architectural Style
Stories: 2
Stories
3
Subdivision
HIDDEN FARM ESTATES
County
Davis
Zoning
Single-Family
Construction
Stone,Stucco,Cement Siding
Lot Size
0.43 sq ft
Above Grade Area
4,505 sq ft
Condition
Blt./Standing
MLS #
2170067
List Price
$3,499,900
Annual Taxes
$1
Home Warranty
Yes
List Price
$3,499,900
Annual Taxes
$1
Home Warranty
Yes
Heating
Forced Air,Gas: Central,>= 95% efficiency
Cooling
Central Air
Roof
Asphalt
Flooring
Carpet,Hardwood,Tile
Basement
Full
Materials
Stone,Stucco,Cement Siding
Appliances
Ceiling Fan,Freezer,Microwave,Range Hood,Refrigerator
Laundry
Electric Dryer Hookup
Patio & Porch
Covered,Porch: Open,Patio: Open
Water Source
Culinary,Secondary
Sewer
Sewer: Connected,Sewer: Public
View
Mountain(s)
Heating
Forced Air,Gas: Central,>= 95% efficiency
Cooling
Central Air
Roof
Asphalt
Flooring
Carpet,Hardwood,Tile
Basement
Full
Materials
Stone,Stucco,Cement Siding
Appliances
Ceiling Fan,Freezer,Microwave,Range Hood,Refrigerator
Laundry
Electric Dryer Hookup
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
Classification
Standard
Deal Score
45/100
vs Market Median
39% above
Area Growth (YoY)
4.0%
Deal Score Breakdown
45/100
4.0% year-over-year ZHVI growth in this area
Priced 39% above the per-subtype city median
LT net cashflow -$10,044/mo (-45.2% return on ownership cost) · STR net cashflow -$18,121/mo (-81.5% 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.
Why this classification
Monthly Rent
$13,854/mo
Range: $13,447 – $14,262
Net Monthly Cash Flow
−$10,043 /mo (−$120,520/yr)
Monthly rental income
Monthly ownership cost
Coverage
62%
Net /mo
−$10,044
DSCR
0.69
Est. Annual Revenue
$70,530/yr
$358/night · 41% occupancy · $123/bedroom · $0.38/sqft
Net Monthly Cash Flow
−$18,122 /mo (−$217,462/yr)
Monthly STR income
Monthly ownership cost
Coverage
26%
Net /mo
−$18,121
DSCR
0.23
Best Download
8 Gbps
Best Upload
8 Gbps
Fiber Available
Yes
Providers
12
Available Providers
$725,000
+383% vs median
55 days
70
$299,990 – $3,699,000
$1
Low Crime
4.9
per 1,000
18.6
per 1,000
9.7
per 1,000
33.3
per 1,000
National rates use FBI UCR Index Crimes. Local rates use NIBRS which may include additional offense categories.
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