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 = 2802 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 = 2802 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 = 2802 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;

354 W Centerfield Cir
Washington, UT 84780

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,299,000
Beds: 7
Baths: 6
Status: Active
SqFt: 7396
Agency: MARKETPRO REAL ESTATE PLLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2023
Notes: Experience luxury living near the Red Cliffs temple in Washington, UT. This stunning 6 bed, 6.5 bath home on almost an acre lot, features real rock exterior, solid wood white oak floors, gourmet kitchen, and upscale features like quartzite and granite countertops and Thermador appliances.Separate entrance private office, private casita with full kitchen. Enjoy entertaining with an indoor pizza oven. Audio system, and security with 12 cameras. eco-friendly amenities like an EV charger and RV clean out. Custom home with quality build. Don't miss out on this exceptional opportunity! House features:<br /> o Real Rock<br /> o Solid white oak wood floors<br /> o Electric Vehicle charger<br /> o RV clean out<br /> o Pizza Oven (indoor) with Vamporosa Automatic gas burner and/or wood burning<br /> o Aqua-Air wet/dry central vacuum system <br /> o Audio Speaker system throughout home, wired for backyard audio <br /> o Security: 12 cameras and security panels<br /> o Ubiquity wifi system throughout entire home<br /> o Foam insulation in roof<br /> o Separate office with exterior entrance, full bathroom<br /> o Casita with full kitchen, Granite Countertops, walk in shower and washer and dryer <br /> o Laundry in Master closet<br /> o Water softener<br /> o Hot water re-circulator for near instant hot water anywhere in home<br /> o Dedicated freezer plug in garage<br /> o Granite and Quartzite counter tops on all surfaces in home, office and Casita.<br /> o Thermador appliances <br /> o Vermont Castings wood burning stove, can convert to gas fireplace<br /> o Gas to backyard for fire pit and pool<br /> o Smart thermostats<br /> o Drinking fountain<br /> o Gas for pool and fire pit<br /> o Gas behind wood burning stove<br /> o 2 dishwashers <br /> o Under Eave Christmas light power and switch<br /> o Casement windows<br /> Newly built home, Foam in ceiling protects from outside heat and noise. Contractor will assist buyer in getting pool etc. installed if desired. <br /> Can't beat this view of Red Cliffs Temple with .79 lot! Just North of the Red Cliffs Temple. Still has builder warranty.
MlsNumber: 24-250160


Listing Provided By: MARKETPRO REAL ESTATE PLLC, original listing
Name: MARKETPRO REAL ESTATE PLLC
Phone: (435) 703-3770
Office Name: MARKETPRO REAL ESTATE PLLC
Office Phone: (435) 703-3770
Agent Name: LEANNE HOOPES
Disclaimer: Copyright © 2024 Washington County Board of Realtors. 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 = 2802 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;
Tim Andrus
ASCIIERA Brokers Real Estate Consolidated
Call Today!: (435) 574-4663

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App