Rare Opportunity: **Private Two-Residence Estate on Two Acres**. Discover an exceptional opportunity to own a private **two-home estate** on two beautifully landscaped acres. Ideal for **multi-generational living**, extended family, a **guest house**, **in-law residence**, home business, caretaker quarters, or potential rental income, this unique property offers flexibility rarely found in today's market. Located in a gated neighborhood, the property is fully enclosed with elegant wrought iron and stucco fencing surrounding both the front and back yards. Inside the main residence you'll find beautiful travertine and hardwood flooring, a luxurious kitchen featuring premium granite countertops-including stunning leather-finished granite-a copper farmhouse sink, Viking downdraft cooktop, refaced cabinetry, and exceptional craftsmanship throughout. The adjoining wet bar offers a second copper sink and built-in wine storage for effortless entertaining. The spacious primary suite is conveniently located downstairs with soaring ceilings and multiple walk-in closets. Bedroom four is currently configured as a hobby room but easily serves as a bedroom, office, or flex space. Step outside to your own private retreat featuring a spectacular flagstone and Trex deck patio, majestic live oak trees, fire pit, raised garden areas, and peaceful views across the two-acre property. The resort-style pool includes waterfalls and a large tanning shelf, creating an ideal setting for relaxing or entertaining. The detached residence is much more than guest quarters-it could easily function as a **second home** or **casita**. It features a spacious living room with fireplace, surround sound, and dramatic walls of glass overlooking the grounds. Additional spaces include a large exercise room, a private office with separate exterior entrance that could also serve as a wine room, a full bath with an oversized steam shower, and a loft opening onto an extended balcony. There's even a hidden room waiting to be discovered. Car enthusiasts, hobbyists, or those needing additional workspace will appreciate the additional two-car garage with dedicated workshop area. Properties offering **two residences on one property**, **dual living arrangements**, and this level of privacy, quality, and flexibility are extraordinarily rare. Whether you're searching for a family compound, luxury estate, executive retreat, or a property that accommodates multiple generations under one address, this remarkable home delivers possibilities that are difficult to duplicate.
For sale
$1,400,000
25052 Whistling Wind, San Antonio, TX 78257
4beds
3,080sqft
Single Family Residence
Built in 1997
2.16 Acres Lot
$1,330,800 Zestimate®
$455/sqft
$100/mo HOA
What's special
Gated neighborhoodHidden roomMajestic live oak treesExceptional craftsmanship throughoutRaised garden areasCopper farmhouse sinkLarge exercise room
- 58 days
- 542
- 32
Zillow last checked:
Listing updated:
Listed by:
Thomas Fentress TREC #350944 (210) 861-9119,
All City Real Estate
Source: LERA MLS,MLS#: 1996731
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Primary bedroom
- Features: Split, Walk-In Closet(s), Multi-Closets, Full Bath
- Area: 255
- Dimensions: 17 x 15
Bedroom 2
- Area: 144
- Dimensions: 12 x 12
Bedroom 3
- Area: 144
- Dimensions: 12 x 12
Bedroom 4
- Area: 121
- Dimensions: 11 x 11
Primary bathroom
- Features: Tub/Shower Separate, Double Vanity, Soaking Tub
- Area: 165
- Dimensions: 15 x 11
Dining room
- Area: 156
- Dimensions: 13 x 12
Family room
- Area: 360
- Dimensions: 20 x 18
Kitchen
- Area: 224
- Dimensions: 16 x 14
Heating
- Central, Electric
Cooling
- Ceiling Fan(s), Three+ Central
Appliances
- Included: Cooktop, Built-In Oven, Self Cleaning Oven, Microwave, Disposal, Dishwasher, Plumbed For Ice Maker, Water Softener Owned, Vented Exhaust Fan, Electric Water Heater, Plumb for Water Softener, Electric Cooktop, Down Draft, 2+ Water Heater Units
- Laundry: Main Level, Washer Hookup, Dryer Connection
Features
- One Living Area, Separate Dining Room, Eat-in Kitchen, Two Eating Areas, Kitchen Island, Breakfast Bar, Pantry, Game Room, Utility Room Inside, High Ceilings, Open Floorplan, High Speed Internet, Walk-In Closet(s), Master Downstairs, Ceiling Fan(s), Wet Bar, Solid Counter Tops, Custom Cabinets, Programmable Thermostat
- Flooring: Carpet, Ceramic Tile, Wood, Other
- Windows: Double Pane Windows, Window Coverings
- Has basement: No
- Has fireplace: Yes
- Fireplace features: Three+, Family Room, Wood Burning, Other
Interior area
- Total interior livable area: 3,080 sqft
Property
Parking
- Total spaces: 4
- Parking features: Four or More Car Garage, Attached, Garage Faces Side, Garage Apartment, Garage Door Opener
- Attached garage spaces: 4
Features
- Levels: Two
- Stories: 2
- Patio & porch: Patio, Covered, Deck
- Exterior features: Sprinkler System, Rain Gutters, Lighting
- Has private pool: Yes
- Pool features: In Ground, Pool/Spa Combo, Heated, Pool Sweep
- Has spa: Yes
- Spa features: Bath
- Fencing: Wrought Iron,Stone/Masonry Fence
Lot
- Size: 2.16 Acres
- Features: Irregular Lot, 2 - 5 Acres, Rolling Slope
- Residential vegetation: Mature Trees, Mature Trees (ext feat)
Details
- Additional structures: Shed(s), Detached Quarters, Second Residence, Kennel/Dog Run
- Parcel number: 163860030400
- Other equipment: Satellite Dish
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- 4 Sides Masonry, Stucco
- Foundation: Slab
- Roof: Metal
Condition
- Pre-Owned
- New construction: No
- Year built: 1997
Details
- Builder name: UNKNWN
Utilities & green energy
- Sewer: Septic
- Water: Water System
Community & HOA
Community
- Security: Smoke Detector(s), Security System Owned, Controlled Access
- Subdivision: Hidden Springs Estat
HOA
- Has HOA: Yes
- HOA fee: $600 semi-annually
- HOA name: CIA
Location
- Region: San Antonio
Financial & listing details
- Price per square foot: $455/sqft
- Tax assessed value: $1,112,980
- Annual tax amount: $25,490
- Price range: $1.4M - $1.4M
- Date on market: 7/1/2026
- Cumulative days on market: 59 days
- Listing terms: Conventional,VA Loan,Cash
Estimated market value
$1,330,800
$1.26M - $1.40M
$5,482/mo
Price history
| Date | Event | Price |
|---|---|---|
| 7/1/2026 | Listed for sale | $1,400,000-6.7%$455/sqft |
Source: | ||
| 11/1/2025 | Listing removed | $1,500,000$487/sqft |
Source: | ||
| 7/6/2025 | Price change | $1,500,000-14.3%$487/sqft |
Source: | ||
| 3/29/2025 | Listed for sale | $1,750,000$568/sqft |
Source: | ||
| 2/28/2006 | Sold | -- |
Source: | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $21,569 -0.5% | $1,112,980 +1.2% |
| 2024 | $21,668 +7.7% | $1,100,000 +10% |
| 2023 | $20,111 -12.9% | $1,000,000 +0.2% |
| 2022 | $23,082 +8.4% | $998,000 +8.5% |
| 2021 | $21,293 | $919,600 +10% |
| 2020 | $21,293 +9.4% | $836,000 +10% |
| 2019 | $19,471 | $760,000 +4.4% |
| 2018 | $19,471 +5.7% | $728,000 +4% |
| 2017 | $18,419 -4.8% | $700,000 -4.5% |
| 2016 | $19,339 +15.3% | $733,000 +5.9% |
| 2015 | $16,769 | $692,021 +10% |
| 2014 | $16,769 | $629,110 -6.5% |
| 2013 | -- | $673,130 0% |
| 2012 | -- | $673,200 +23.3% |
| 2011 | -- | $546,110 +5.2% |
| 2010 | -- | $519,190 +4% |
| 2009 | -- | $499,060 -0.9% |
| 2008 | -- | $503,380 +0.5% |
| 2007 | -- | $500,680 +39% |
| 2006 | -- | $360,120 +6.1% |
| 2005 | -- | $339,470 |
| 2004 | -- | -- |
| 2003 | -- | -- |
| 2002 | -- | -- |
| 2001 | -- | -- |
| 2000 | -- | -- |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 78257
Nearby schools
Schools provided by the listing agent
- Elementary: Leon Springs
- Middle: Rawlinson
- High: Clark
- District: Northside
Source: LERA MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.





