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

113 James St
Brackettville, TX 78832
Brittany Wylie with Real, original listing - (855) 450-0442

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $543,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2308 Square Feet
Agency: Real
Agency Phone: (855) 450-0442

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: This luxurious home is a beautifully completed historic restoration/remodel featuring impeccable detail, reclaimed materials sourced from historic buildings, and custom high-end finishes throughout. The upgraded features of this home are many and include spacious rooms with 11' 5" ceilings and 8' interior doors, beautiful longleaf pine wood floors, battens, and bead board work, 5 wood-burning fireplaces, custom cabinetry, 3 bedrooms total (each with its own fireplace), 2 full bathrooms tiled with custom dual-head showers and separate tubs, and a separate half-bath for guests. The chef's kitchen boasts gorgeous granite countertops in a leather finish, appliances, two sinks, a gas stove with dual ovens, and custom cabinetry. The open concept living, dining, kitchen area transitions out the back door onto a large covered deck with custom bar, outdoor kitchen, and entertaining space overlooking the back courtyard and mature trees. The outdoor living area is a must-see feature of this home! A second living area inside the home adjacent to the main living room could be used as an office, formal dining room, or a second living room. The stately master bedroom has its own wood-burning fireplace as well as an on-suite bathroom with travertine stone tile, custom dual-head shower, private toilet closet, separate vanities, and a jetted tub with a direct line of site to the bathroom's dedicated flat screen TV. Adding to the uniqueness of this property, the home boasts a quiet location in town, sitting on a corner double-lot with two churches as nearby neighbors. Also offered with the sale of the home is an additional nearby vacant lot to further buffer the home-site from neighbors. This unique property is full of possibilities and would make an amazing residence, commercial office, short-term vacation rental, or wedding/event venue.
MlsNumber: --
ListingId: 1861945


Listing Provided By: Real, original listing
Phone: (830) 305-4426
Office Phone: (855) 450-0442
Agent Name: Brittany Wylie
Disclaimer: Copyright © 2025 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