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

103 River Mountain Dr
Boerne, TX 78006

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,530,000
Beds: 4
Baths: 4
Status: Active
SqFt: 3557
Agency: Niemeyer & Associates REALTORS®

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential
Year Built: 2023
Notes: **Open House May 5th, 2024 1pm-4pm**Another amazing custom home build by Odom Heritage Homes. This plan has so much to offer starting with the master split from rest of house with access to the oversized patio to enjoy the privacy of the backyard. The master bath offers that WOW factor with designer subway tile spanning across an entire wall accenting both freestanding tub and enclosed shower. His and her vanities to top it off with front and backlighted mirrors and antifog feature. Across the house and also split from the other bedrooms is the mother-in-law suite with oversized shower. Quartz counters throughout as well as wood flooring, brick and ceramic Tile floors with no carpet. This home sits on a very wide 4.199 acres located on corner with plenty of space for pool, shop, garden or combination of all the above and so much more. House was built with tankless gas water heaters, spray foam insulation, pre-plumbed for water softener, and metal roof. Lots of designer grade lighting, plumbing fixtures and stainless-steel cafe appliances. This one truly flaunts an exquisite floorplan and design making it an Entertainers dream! You will have a unique experience the moment you follow the driveway through two large oaks as it wraps around to 3 car garage. Few other extras to note is a full in-house built-in speaker system, open floor plan, private office, iron doors, stained tongue and groove accents for porch ceilings and custom-made mantle that overhangs large corner fireplace. Sprinkler system was also put in to help grow and maintain landscaping. Many more features to come check out for yourself.
MlsNumber: 1741665


Listing Provided By: Niemeyer & Associates REALTORS®, original listing
Name: Niemeyer & Associates REALTORS®
Phone: (210) 831-8243
Office Name: Niemeyer & Associates, REALTORS
Office Phone: (210) 831-8243
Agent Name: Misty Niemeyer
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