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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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;

3714 Eliberis
San Antonio, TX 78261

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $570,965
Beds: 3
Baths: 2
Status: Active
SqFt: --
Agency: CastleRock Communities (Corporation)

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Other
Year Built: --
Notes: If you value a large, open-concept space, then the Ventura floor plan is for you.. Upon entry, this three-bedroom, two-bathroom home boasts a secluded study room, entry to your secondary and third bedrooms with walk-in closets, and a full secondary bathroom. Beside your study resides an inviting formal dining room, a gorgeous fireplace within the family room, and a covered patio right off the family room. If you are a fan of entertaining large gatherings or hosting your whole family for the holidays, you can opt to extend your family room, giving you the maximum amount of space. You will love the huge walk-in utility room that grants you access to your two-car tandem garage. In the garage, you can opt for a two or three-car side load garage with tandem instead. Opening up to the family room is your spacious kitchen with an elegant island, granite countertops, a large walk-in pantry, and industry-leading appliances. Completing this beautiful home is your private master suite that gives you the option of including a bay window to let all the natural light you desire stream in. Your master bathroom consists of dual vanities, a large soaker tub, a separate shower, and a sizable walk-in closet. With the Ventura plan, there are plenty of options for you to customize the home to your family's wants and needs. In the master bathroom, you can opt for double master closets if you are needing additional storage space. Additionally, you can include a fourth bedroom with an attached bathroom in lieu of the tandem garage, or replace your secondary bathroom by opting for two private bathrooms for your bedrooms. Lastly, you can choose to include super showers in the second and third bathrooms to add extra flair and level of comfort for your guest bathrooms. The Ventura home offers something for the entire family to enjoy. Don't worry about compromising any space. With amazing features and variety of options like these, you will not regret choosing the Ventura floor plan.
MlsNumber: 2502387


Listing Provided By: CastleRock Communities (Corporation), original listing
Name: CastleRock Communities (Corporation)
Office Name: CR TX San Antonio
Agent Name: Cindy Zarate
Disclaimer: Copyright © 2024 DRB Group (BDX). 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