Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$1,299,000

  • For Sale
  • Active
  • Single Family
  • 6 Beds
  • 3 Full Baths
  • 1 Partial Bath
  • 4,208 Sq. Ft.
  • 4 Car Garage
See This Home
Save This Home
See This Home
Save This Home
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!

Full Property Details for 588 W 1175 N

General

  • Price: $1,299,000
  • Taxes: $3,548
  • Status: Active
  • Type: Single Family
  • Source: WFR
  • MLS ID: 2101648
  • Updated: 11/24/2025
  • Added to Site: 171 day(s) ago

Interior

  • Interior Features: Alarm: Fire, Alarm: Security, Basement Apartment, Bath: Primary, Bath: Sep. Tub/Shower, Closet: Walk-In, Den/Office, Disposal, Floor Drains, Great Room, Jetted Tub, Kitchen: Second, Mother-in-Law Apt., Oven: Gas, Range/Oven: Free Stdng., Vaulted Ceilings, Granite Countertops, Video Door Bell(s), Video Camera(s)
  • Fireplace: Yes
  • Number of Fireplaces: 1
  • Appliances: Microwave, Range Hood, Refrigerator, Water Softener Owned
  • Flooring: Carpet, Tile

Rooms

Bathrooms

  • Total Bathrooms: 4
  • Full Bathrooms: 3
  • Half Bathrooms: 1

Bedrooms

  • Total Bedrooms: 6

Other Rooms

  • Laundry: Electric Dryer Hookup

Additional Information

  • Equipment: Alarm System, Window Coverings

Exterior

  • Exterior Features: Basement Entrance, Double Pane Windows, Lighting, Patio: Covered, Sliding Glass Doors, Walkout
  • Porch/Patio/Deck: Covered

Parking

  • Garage: Yes
  • Attached garage: Yes
  • Garage Spaces: 4
  • Covered Spaces: 4
  • Total Spaces: 4
  • Parking Features: Rv Parking

Location

  • Area: Bntfl; NSL; Cntrvl; WdX; Frmtn
  • County: Davis
  • Subdivision: FARMINGTON MANORS
  • Cross Streets: 1175
  • Direction Faces: South

School Information

  • Elem School District: Davis
  • Midd School District: Davis
  • High School District: Davis
  • Elementary School: Knowlton
  • Middle School: Farmington
  • High School: Davis

Heating & Cooling

  • Central air: Yes
  • Air Conditioning: Yes
  • Cooling Type: Central Air, Heat Pump, Active Solar
  • Heating Type: Forced Air, Gas: Central, Heat Pump

Utilities

  • Sewer: Sewer: Connected
  • Water: Culinary, Secondary
  • Utility Description: Natural Gas Connected, Electricity Connected, Sewer Connected, Water Connected

Structural Information

  • Architectural Style: Rambler/Ranch
  • Construction: Asphalt, Brick
  • Exterior Const.: Asphalt, Brick
  • Basement Desc.: Daylight, Full, Walk-Out Access
  • Roof: Asphalt
  • Windows: Blinds, Drapes
  • Disability Access: Accessible Hallway(s), Accessible Electrical and Environmental Controls
  • Stories/Levels: 3
  • Square Feet: 4,208
  • Living Area: 4,208 Sq. Ft.
  • Current Bldg. Use: Single Family
  • Year Built: 2014
  • Property Condition: Blt./Standing

Lot Features

  • Property View: Mountain(s)
  • Lot Size (Acres): 0.27
  • Lot Size (Sq. Ft.): 11,761.2
  • Lot Size: .27
  • Landscape: Landscaping: Full, Mature Trees, Pines
  • Topography: Cul-de-Sac, Fenced: Full, Road: Paved, Sprinkler: Auto-Full, View: Mountain, Drip Irrigation: Auto-Full, Private
  • Lot Features: Cul-De-Sac, Fenced: Full, Road: Paved, Sprinkler: Auto-Full, View: Mountain, Drip Irrigation: Auto-Full, Private
  • Trees/Vegetation: Landscaping: Full, Mature Trees, Pines
  • Zoning: LR

Green Features

  • Energy Generation: Solar

Financial Considerations

  • Tax Amount: $3,548
  • Terms: Cash, Conventional

Disclosures and Reports

  • Exclusions: Dryer, Washer
  • Inclusions: Alarm System, Microwave, Range, Range Hood, Refrigerator, Water Softener: Own, Window Coverings, Video Door Bell(s), Video Camera(s), Smart Thermostat(s)
  • Property ID: 08-424-0003

Listed by Berkshire Hathaway HomeServices Utah Properties (Salt Lake)

Quickly Find Out More

* Indicates a required field

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Listing agent

— 588 W 1175 N —

  • Berkshire Hathaway HomeServices Utah Properties (Salt Lake)

801-990-0400

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 588 W 1175 N

School District:Davis School District
NameGradesDistance
Knowlton School
801 Shepard Lane, Farmington, UT 84025
K-60.3 mi
Farmington Jr High School
150 South 200 West, Farmington, UT 84025
7-91.5 mi
Farmington High
548 West Glovers Lane, Farmington, UT 84025
10-122.3 mi
Disclaimer: School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 588 W 1175 N Get Price Alerts and Save Property

Date
Details
Price
Change
Source
8/25/2025
Price Reduced
$1,299,000
-13.34%
MLS
7/29/2025
Listed
$1,499,000
—
MLS
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 588 W 1175 N

$
Down Payment
%
$
%

$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by Berkshire Hathaway HomeServices Utah Properties (Salt Lake)

Similar Properties near 588 W 1175 N

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

186 N Mountain Vistas Rd, Kaysville, UT 84037 - Photo 1
$1,300,000

186 N Mountain Vistas Rd  Kaysville, UT 84037

  • Single Family
  • Active
  • Updated 10 days ago
  • 6
    Beds
  • 5
    Total Baths
  • 5,075
    Sq. Ft.
Listed by RE/MAX Associates
557 E Warm Springs Dr, Kaysville, UT 84037 - Photo 1
$1,249,000
Open House

557 E Warm Springs Dr  Kaysville, UT 84037

  • Single Family
  • Active
  • Updated 9 days ago
  • 5
    Beds
  • 4
    Total Baths
  • 4,299
    Sq. Ft.
Listed by EXP Realty, LLC
19 E 1500 S, Farmington, UT 84025 - Photo 1
$1,386,900

19 E 1500 S  Farmington, UT 84025

  • Single Family
  • Active
  • 5
    Beds
  • 4
    Total Baths
  • 4,283
    Sq. Ft.
Listed by Bravo Realty Services, LLC
1539 W Misty Breeze Circle, Kaysville, UT 84037 - Photo 1
$1,350,000

1539 W Misty Breeze Circle  Kaysville, UT 84037

  • Single Family
  • Active
  • 7
    Beds
  • 5
    Total Baths
  • 5,101
    Sq. Ft.
Listed by Equity Real Estate

Just Listed near 588 W 1175 N

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

1579 W Pheasant Dr, Kaysville, UT 84037 - Photo 1 Just Listed
$1,875,000

1579 W Pheasant Dr  Kaysville, UT 84037

  • Single Family
  • Active
  • Updated 4 days ago
  • 6
    Beds
  • 5
    Total Baths
  • 5,887
    Sq. Ft.
Listed by Kim Chatterton (801) 860-5520
582 W 1950 N, Centerville, UT 84014 - Photo 1 Just Listed
$320,000
Open House

582 W 1950 N  Centerville, UT 84014

  • Townhouse
  • Active
  • Updated 1 day ago
  • 2
    Beds
  • 2
    Total Baths
  • 952
    Sq. Ft.
Listed by Real Broker, LLC
680 N Main St, Kaysville, UT 84037 - Photo 1 Just Listed
$55,000

680 N Main St  #B13  Kaysville, UT 84037

  • Mobile Home
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 924
    Sq. Ft.
Listed by Utah's Wise Choice Real Estate
975 E 1175 S, Kaysville, UT 84037 - Photo 1 Just Listed
$45,000

975 E 1175 S  #42  Kaysville, UT 84037

  • Mobile Home
  • Active
  • Updated 1 day ago
  • 2
    Beds
  • 2
    Total Baths
  • 690
    Sq. Ft.
Listed by Real Broker, LLC

Price Reduced near 588 W 1175 N

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

22 Creekside Ln, Centerville, UT 84014 - Photo 1 Price Reduced
-$10,500 (-2.56%)
$399,500

22 Creekside Ln  Centerville, UT 84014

  • Townhouse
  • Active
  • Updated 3 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,644
    Sq. Ft.
Listed by Jill Allsop (801) 573-1937
203 S 350, Kaysville, UT 84037 - Photo 1 Price Reduced
-$9,500 (-2.16%)
$429,990

203 S 350  Kaysville, UT 84037

  • Single Family
  • Active
  • Updated 4 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,404
    Sq. Ft.
772 N Crimson Ct, Kaysville, UT 84037 - Photo 1 Price Reduced
-$7,000 (-1.85%)
$372,000

772 N Crimson Ct  Kaysville, UT 84037

  • Townhouse
  • Active
  • Updated 2 days ago
  • 2
    Beds
  • 3
    Total Baths
  • 1,276
    Sq. Ft.
Listed by Windermere Real Estate (Layton Branch)
203 W 350 S, Kaysville, UT 84037 - Photo 1 Price Reduced
-$4,500 (-1.04%)
$429,990

203 W 350 S  Kaysville, UT 84037

  • Single Family
  • Active
  • Updated 4 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,404
    Sq. Ft.
Listed by Bureau Real Estate

588 W 1175 N, Farmington, UT 84025 (MLS# 2101648) is a Single Family property with 6 bedrooms, 3 full bathrooms and 1 partial bathroom. 588 W 1175 N is currently listed for $1,299,000 and was received on July 29, 2025. Want to learn more about 588 W 1175 N? Do you have questions about finding other Single Family real estate for sale in Farmington? You can browse all Farmington real estate or contact a Coldwell Banker agent to request more information.

Tour this property