Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2781 AND i.igate IN ('usahud','uthud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'uthud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2781 AND i.igate IN ('usahud','uthud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'uthud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2781 AND i.igate IN ('usahud','uthud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'uthud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

641 S 1475 W
Farmington, UT 84025
Ryan Ivie with RE/MAX Associates (Layton), original listing - (801) 774-1617

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,000,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: --
Agency: RE/MAX Associates (Layton)
Agency Phone: (801) 774-1617

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Discover the rare chance to own a stunning custom home on over half an acre in West Farmington. This exceptional estate seamlessly combines luxury and entertainment, crafted by one of Davis County's premier luxury builders. From the magnificent oversized custom steel entry door to the exquisite wood flooring throughout the main level, every detail showcases premium upgrades. Custom woodwork enhances the charm of every room, including elegant built-in bookcases in the family area. Designer lighting fixtures add a sophisticated touch, while floor-to-ceiling windows in the family room frame breathtaking views of the Wasatch Mountains. Most windows feature motorized shades. Retreat to the owner's suite, a personal oasis featuring dual vanities, a standalone tub, an oversized shower, and a spacious walk-in closet equipped with its own stackable washer and dryer. The gourmet kitchen is a chef's dream, boasting a large island with quartz countertops and a stylish backsplash, complemented by custom cabinetry and a hidden pantry. With dual dishwashers and double ovens, it's perfect for culinary enthusiasts. The expansive basement with 9 ft ceilings is designed for entertainment, featuring a generous family room with a kitchenette and eating counter perfece for movie nights. Plenty of space left for arcade games and pool table. A commercial-grade home gym adds to the allure, while the large walkout basement provides room for a future Hot Tub. Step outside to an entertainer's paradise, complete with an installed pickleball/basketball court, a cozy fire pit, in-ground trampoline and sufficient space for a future pool. The unobstructed mountain views are truly a highlight of this property. Relax in the evenings on the spacious covered deck, and enjoy the convenience of a private pet area with direct access to the laundry room. Additionally, an extended RV pad provides ample space for all your outdoor toys. Garage is wired for your electric vehicles. Located in one of Farmington's upscale communities, on a quiet cul-de-sac lot. This estate is conveniently located to schools, Station Park shopping center, and easy freeway access. With its elegant finishes and remarkable upgrades, this home is a rare find. Skip the lengthy 16-month building process and move into this exquisite designer home, that still looks and feels brand new!
MlsNumber: --
ListingId: 2066812


Listing Provided By: RE/MAX Associates (Layton), original listing
Phone: (801) 774-1617
Office Phone: (801) 774-1617
Agent Name: Ryan Ivie
Disclaimer: Copyright © 2025 UtahRealEstate.com. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2781 AND i.igate IN ('usahud','uthud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'uthud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Braden Boyson
ASCIIPinpoint Real Estate
Call Today!: (801) 391-1414

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App