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;

340 Le Grande Cir
Santa Clara, UT 84765

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,875,000
Beds: 7
Baths: 7
Status: Pending
SqFt: 6071
Agency: Realtypath St George

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2003
Notes: Indulge in the epitome of luxury living with this Tuscan-style masterpiece nestled in the prestigious Vineyards neighborhood of Santa Clara. Located in a serene cul-de-sac, this opulent residence boasts 7 bedrooms and 7.5 bathrooms, providing an expansive and lavish retreat for you and your family.<br /> <br /> Step into a world of elegance as you enter this meticulously designed home. Every detail exudes sophistication, from the solid wood doors to the brand new plush carpeting that graces the floors. The Tuscan-inspired architecture adds a timeless and majestic quality, making it a standout in this upscale community. Buyers financing fell through, don't miss out on your opportunity. The heart of this residence is the half-acre backyard, a veritable oasis with an incredible pool, inviting you to cool off on warm summer days. Gather around the 6ft outdoor fireplace for cozy evenings under the stars or engage in friendly competition on the basketball and pickleball courts. The pool house and casita add to the allure, providing additional space for relaxation and entertaining guests.<br /> <br /> The interior is a testament to refined taste and modern comfort. With 7 spacious bedrooms, each with walk-in closets & bathroom access, everyone can enjoy their own private haven. The grandeur of this home is evident in every room, creating a sense of unparalleled comfort and style.<br /> <br /> You can immerse yourself in the refined world of literature and sophistication within the confines of this beautiful custom library by adding your own collection, an exquisite haven nestled within the heart of this home. The library is not merely a room; it's a sanctuary for literary enthusiasts and a testament to the artistry of fine craftsmanship. Every detail, from the intricate shelving to the tasteful decor accents, contributes to an environment that encourages both intellectual exploration and relaxation. <br /> <br /> The office is an executive oasis of productivity and sophistication within this meticulously designed office space, adorned with seamless built-ins that elevate both form and function. The ambiance is one of refined professionalism, with a perfect blend of contemporary design and timeless elegance.<br /> <br /> The bonus room, an enchanting space, has a built-in cottage, a whimsical nook where young imaginations can run wild. The cottage is adorned with charming details, from miniature windows to a pint-sized door that invites little ones to step into their own fairy tale world. The cottage's interior is a cozy haven, complete with a comfortable reading corner or play area, providing a magical escape within the room. <br /> <br /> This residence is not just a home; it's a lifestyle. Imagine hosting gatherings in this remarkable space, where the seamless transition from indoor to outdoor living allows for unforgettable experiences. The Tuscan ambiance carries through the entire property, creating a cohesive and inviting atmosphere.<br /> <br /> Embrace the allure of Vineyards living, where luxury meets tranquility. This Tuscan-style home is not just a residence; it's a statement of refined living in one of Santa Clara's most sought-after neighborhoods.
MlsNumber: 24-248224


Listing Provided By: Realtypath St George, original listing
Name: Realtypath St George
Phone: (435) 218-7120
Office Name: REALTYPATH ST GEORGE
Office Phone: (435) 218-7120
Agent Name: KAREY MANISCALCO
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