Live the lifestyle you've always dreamed of-right here in this expansive, inviting retreat designed for comfort, connection, and unforgettable memories. With 7 spacious bedrooms and 4 full bathrooms, this home is perfect for growing or multigenerational families, offering everyone their own space while still enjoying togetherness. Step outside to your covered patio or upper balcony, the perfect setting for morning coffee or evening wine as the sun sets. There's space for every season of life-from play to productivity. The detached guest house is ideal for extended family, guests, or even rental potential, complete with its own kitchen, bath, and living area-giving everyone privacy and independence. Have toys? The large workshop and shop space are perfect for your boat, RV, trailer, or weekend hobbies. There's ample parking and storage for all your gear, plus a game room that's ready to host unforgettable nights of fun and laughter. Sitting on just under an acre, there's room to roam, garden, play, and dream. The treehouse needs a little TLC, but it holds the potential for magic and adventure for the kids (or the young at heart). Best of all, you're just a short commute to San Antonio, giving you the peace of country-style living with the convenience of city access.
For sale
Price cut: $15K (6/27)
$335,000
23127 Opportunity, Elmendorf, TX 78112
7beds
3,100sqft
Est.:
Single Family Residence
Built in 2018
0.78 Acres Lot
$326,800 Zestimate®
$108/sqft
$-- HOA
What's special
Upper balconyJust under an acreCovered patioGame room
- 90 days
- on Zillow |
- 712 |
- 49 |
Zillow last checked: 8 hours ago
Listing updated: July 08, 2025 at 12:07am
Listed by:
Shannan Albrecht TREC #488042 (210) 573-2580,
Keller Williams Heritage
Source: SABOR,MLS#: 1865918

Travel times
Tour with a buyer's agent
Tour with a buyer's agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 7
- Bathrooms: 4
- Full bathrooms: 4
Primary bedroom
- Features: Split, Walk-In Closet(s), Ceiling Fan(s), Full Bath
- Area: 196
- Dimensions: 14 x 14
Bedroom 2
- Area: 110
- Dimensions: 11 x 10
Bedroom 3
- Area: 99
- Dimensions: 11 x 9
Bedroom 4
- Area: 154
- Dimensions: 14 x 11
Bedroom 5
- Area: 143
- Dimensions: 13 x 11
Primary bathroom
- Features: Tub/Shower Combo
- Area: 60
- Dimensions: 12 x 5
Dining room
- Area: 196
- Dimensions: 14 x 14
Kitchen
- Area: 140
- Dimensions: 14 x 10
Living room
- Area: 319
- Dimensions: 29 x 11
Heating
- Central, Electric
Cooling
- Central Air
Features
- Two Living Area, Liv/Din Combo, Eat-in Kitchen, Study/Library, Game Room, Utility Room Inside, Secondary Bedroom Down, 1st Floor Lvl/No Steps, Maid's Quarters, Master Downstairs, Ceiling Fan(s), Programmable Thermostat
- Flooring: Ceramic Tile
- Has basement: No
- Has fireplace: No
- Fireplace features: Not Applicable
Interior area
- Total structure area: 3,100
- Total interior livable area: 3,100 sqft
Property
Parking
- Total spaces: 5
- Parking features: Two Car Garage, Garage Apartment, Three Car Carport, RV/Boat Parking, Bus/RV Garage, Open
- Garage spaces: 2
- Carport spaces: 3
- Covered spaces: 5
Features
- Levels: Two
- Stories: 2
- Patio & porch: Covered
- Pool features: None
- Has view: Yes
- View description: County VIew
Lot
- Size: 0.78 Acres
- Features: 1/2-1 Acre, Level
Details
- Additional structures: Shed(s), Detached Quarters, Second Residence, Workshop
- Parcel number: 041310850110
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Wood Siding
- Foundation: Slab
- Roof: Composition
Condition
- Pre-Owned
- New construction: No
- Year built: 2018
Utilities & green energy
- Sewer: Septic
Community & HOA
Community
- Features: None
- Subdivision: Waterwood
Location
- Region: Elmendorf
Financial & listing details
- Price per square foot: $108/sqft
- Tax assessed value: $309,590
- Annual tax amount: $7,050
- Price range: $335K - $335K
- Date on market: 5/12/2025
- Listing terms: Conventional,FHA,VA Loan,Cash
- Road surface type: Paved
- Loading
- Loading