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;

3195 County Road 676
Devine, TX 78016-4652
Hilary Barras with Keller Williams Heritage, original listing - (210) 493-3030

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $630,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1144 Square Feet
Agency: Keller Williams Heritage
Agency Phone: (210) 493-3030

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 19 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2000
Notes: Home on the range! This property is the Texas dream! 19.79 acres with an adorable 1140 square foot 2bd/2ba home that was completely remodeled in 2014. Fabulous open floor plan with gourmet kitchen, high ceilings, custom cabinetry throughout, laundry room and a really cool vibe. Large master suite, multiple walk-in closets and a spa like bathroom with double vanity, walk in shower and a 2 person jacuzzi tub. Master has outdoor access to the covered porch. Almost 20 acres with an amazing stock pond that is 15' deep in center & stocked with catfish, perch, and sterile carp registered with TPWD. Sit by the pond and soak up the gorgeous sunsets. There are 2 wells, one that is connected and supplies the home and stocked tank and one that is capped. Horse lovers will adore the metal barn that was built in 2015 & has one large room finished out that could serve as a guest room or a home office, and one rough-finished used as a tack room. Big metal shop and several covered areas to park equipment, etc. Pastures are fenced and cross fenced. 50 amp RV service and plenty of room for parking. There is approx 13 acres +/- of coastal that produces approx 200 square bales per yr without irrigating. BMA main canal runs on 3 sides of property. Home and one acre with homestead exemption, remaining acreage has ag-exemption for hay production. Property is fully fenced, cross fenced and has gated entry with gate opener. No restrictions, no HOA. Don't delay, country living is ready for you! Bring the horses, chickens, cows, goats and start your homestead lifestyle today!!
MlsNumber: --
ListingId: 1814508


Listing Provided By: Keller Williams Heritage, original listing
Phone: (951) 377-0398
Office Phone: (210) 493-3030
Agent Name: Hilary Barras
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