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

108 Santa Gertrudis Dr
Sutherland Springs, TX 78161-9706
Gary Bisha with My Castle Realty Inc., original listing - (713) 683-0054

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $735,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2452 Square Feet
Agency: My Castle Realty Inc.
Agency Phone: (713) 683-0054

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2015
Notes: 2452 sq ft Ranch style custom home. With and extra 1516 covered sq ft that consists of a two vehicle carport with porches extending the whole front and back of the home for those afternoon sunsets. 3 bedroom optional 4th bedroom/recreational/media room and a office. Home has 2.5 baths that consist of a large master bath with custom bathroom cabinet and large jacuzzi tub with a large window for those long baths while watching thunderstorms. Master bedroom has double doors to with large windows for access to the back yard. Large master bedroom closet. Front door opens up to a barn wood accent wall entry way with sliding glass door leading into an office with an amazing view. Entry way leads into a large open living space for entertaining with a massive butcher block kitchen island with seating for those afternoon lunches. The kitchen consists of all stainless-steel appliances with a double oven and custom cabinetry with pull out lower drawers for easy access. Adjoining pantry consists of custom shelving with heavy metal and wood look. Home has zoning a/c which allows for individual climate control throughout the house. A/C has been recently serviced with transferable 10year warranty on parts. Home has private water well and electricity. The home sits on top of a hill that oversees the whole property with an abundance amount of wildlife, whitetail deer, wild turkeys, bob white quail, and the occasional grey fox have been seen on the property. Property has large mature oak trees and plenty of field for grazing livestock making it perfect for anyone wanting to make a garden are turning property in to a beautiful homestead. Conex currently located on the property is being relocated prior to the sale of the home.
MlsNumber: --
ListingId: 1804221


Listing Provided By: My Castle Realty Inc., original listing
Phone: (713) 683-0054
Office Phone: (713) 683-0054
Agent Name: Gary Bisha
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