588 W 1175 N, Farmington, UT 84025

• 6 beds |
• 4 baths |
• 4,208 sqft

Property Description

Step into this stunning Farmington luxury home featuring a beautifully upgraded mother-in-law apartment-currently rented for $3,000/month! Truly better than new, this immaculate residence welcomes you with soaring two-story ceilings in the entry and family room that will take your breath away. The main floor boasts a gorgeous primary suite with a spa-like executive bath, plus two additional spacious bedrooms. A versatile loft provides the perfect space for an office, playroom, or second family room. The gourmet kitchen is a chef's dream-bright, open, and ideal for entertaining. The private mother-in-law apartment mirrors the same level of quality, offering abundant natural light, three spacious bedrooms, a stunning kitchen/family room, and its own private entrances. Outdoors, you'll love the manicured grounds, colorful landscaping, and a private covered patio-perfect for gatherings or quiet relaxation. A spacious four-car garage with built-in shelving provides plenty of room for cars, toys, and storage. Tucked away on a peaceful cul-de-sac surrounded by beautiful neighboring homes, this property feels serene yet is just minutes from shopping, freeway access, Salt Lake City, Ogden, and the airport. Lovingly cared for by its original owner, this home checks every box-luxury, functionality, and value. Motivated sellers-don't miss this dream home!

Listing Status:

Active

Date Added:

June 12, 2026

Data Last Updated:

June 26, 2026 at 2:42AM

Listing Office:

Berkshire Hathaway HomeServices Utah Properties (Salt Lake) : 801-990-0400

Listing Agent:

Joan Pate : 801-990-9531

MLS ID:

2165010

Interior

• General: Alarm: FireAlarm: SecurityBasement ApartmentBath: PrimaryBath: Sep. Tub/ShowerCloset: Walk-InDen/OfficeDisposalFloor DrainsGreat RoomJetted TubKitchen: SecondMother-in-Law Apt.Oven: GasRange/Oven: Free Stdng.Vaulted CeilingsGranite CountertopsVideo Door Bell(s)Video Camera(s)
• Laundry: Electric Dryer Hookup
• Basement: DaylightFullWalk-Out Access
• Flooring: CarpetTile
• A/C: Central AirHeat PumpActive Solar
• Heating: Forced AirGas: CentralHeat Pump
• Fireplace: FireplaceFireplaces: 1
• Disability Feature: Accessible Hallway(s)Accessible Electrical and Environmental Controls
• Eco/Green Feature: Solar

Exterior

• General: Basement EntranceDouble Pane WindowsLightingPatio: CoveredSliding Glass DoorsWalkout
• Style: Rambler/Ranch
• Parking: Rv ParkingParking spaces: 4

Construction

• Roofing: Asphalt
• Windows: BlindsDrapes
• General: Blt./Standing

Location

• Originating MLS: UtahRealEstate.com
• School District: Davis
• County: Davis

Lot

• Topography: Cul-de-SacFenced: FullRoad: PavedSprinkler: Auto-FullView: MountainDrip Irrigation: Auto-FullPrivate
• Landscaping: Landscaping: FullMature TreesPines
• Zoning: Single-Family08-424-0003
• View: Mountain(s)View
• Current Use: Single Family

Utilities

• Utilities: Natural Gas ConnectedElectricity ConnectedSewer ConnectedWater Connected
• Water: CulinarySecondary
• Sewer: Sewer: Connected

Financial

• Source: UtahRealEstate.com