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 = 2684 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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 = 2684 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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 = 2684 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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;

451 Stone Loop
Castroville, TX 78009

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $890,000
Beds: 3
Baths: 4
Status: Active
SqFt: 3316
Agency: Champions Real Estate Group, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2022
Notes: Beautiful custom home in the highly desired Potranco Acres! Why wait for a home to be built when you can move in to this beautiful, 2 year old home right away! 7+ years left on builder structural warranty, transferable to new buyer. Gorgeous! Complete with high end finishes throughout, including Michael Edwards cabinets, Quartz countertops, oversized wood grain tile floors, coffered ceiling detail in office and dining room, beautiful custom lighting throughout! Window coverings already in place and stay with the house. This welcoming open floorplan is perfect for gatherings and entertaining or just hanging out. Enjoy the openness of the Texas sized kitchen, dining and living room. Be glorified by the stone fireplace that touches the cathedral ceiling, making it your statement piece! Bring your big screen TV to mount above the rough sawn mantle waiting for your decor. Already wired for surround sound, ready for your entertainment system! Extra large, king sized bedrooms, each come with en-suite bathrooms. The primary bedroom has a huge bathroom with a luxurious soaking tub and a magnificent, unique ROTUNDA shower! The large walk in closet conveniently leads to the oversized laundry room. And let's not forget to mention there is a large office and ALSO a den/game/movie/flex room! As you step out back you will enjoy the huge covered back patio (also pre-wired for surround sound) with a fireplace, a private backyard that is cleared and waiting for your vision and creativity. Get your hot tub ready because this home is ready and wired for one! While you're tubbing you can also enjoy the peace and quiet of this private, ONE ACRE greenbelt lot (Lot measurements: 175.98' x 249.98') You'll experience the wildlife in this small gated community of only 93 homes. The 3 car attached garage allows ample space for your vehicles and even has a mini split to keep them comfy! Besides being a gated community, you'll have added security with the local fire department and police sub station just outside the gate. Along with the home's Simplysafe Security System which stays with the house. Go to Potranco Acres website to view governing docs, PID info and plat map. ***COME AND TOUR THIS HOME, FALL IN LOVE, MAKE AN OFFER!***
MlsNumber: 1766800


Listing Provided By: Champions Real Estate Group, LLC, original listing
Name: Champions Real Estate Group, LLC
Phone: (713) 785-6666
Office Name: HomeSmart
Office Phone: (713) 785-6666
Agent Name: Sarra Guck
Disclaimer: Copyright © 2024 San Antonio 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App