• Sign Up
  • Log In
Ade Ogunbomehin
Ade Ogunbomehin
(312) 933-6588bomehin@gmail.com
    • About
      • Meet Ade
      • Testimonials
    • Properties
      • Search for Homes
      • Search by Area
      • Mortgage Calculator
      • Featured Listings
    • Sell
    • Contact
    • Ade Ogunbomehin(312) 933-6588
      bomehin@gmail.com
      Copy Email
    • IH-10 REALTY
      8647 Wurzbach Road
      San Antonio, TX 78240
      3129336588
      bomehin@gmail.com

    About

    • Home
    • About
    • Contact

    Search

    • Search Properties
    Ade Ogunbomehin - Footer Logo
    • Texas Real Estate Commission Consumer Protection Notice
    • Privacy
    • Terms
    • DMCA
    • Accessibility
    • Fair Housing
    © 2026 IH-10 Realty. All rights reserved.
    Website built by CloseHack.
    LERA MLS

    Information provided Courtesy of LERA MLS - Local Expertise Regional Access. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is believed to be accurate but not guaranteed. Provided courtesy of the San Antonio Board of Realtors. Copyright 2025 LERA MLS, All Rights Reserved.

    $1,795,000
    For Sale

    251 Lismore

    San Antonio, TX 78260
    5102 sqft | 4 beds | 4.5 baths | 1.20 acres | #1934694
    • Save
    • Contact
    • Share
    • Price Change Alerts
    251 Lismore
    59 photos
    Type:Purchase
    Structure:House
    Zone:Residential

    Description

    Nestled within the prestigious Waterford Heights neighborhood of Stone Oak, this exclusive double-gated community offers exceptional privacy and security. At the end of a sweeping circular drive sits this Gorgeous Burdick custom home, a sprawling single-story estate that blends refined luxury with everyday comfort on a beautifully manicured 1.2-acre lot. Thoughtfully designed at 5,102 sq ft, this residence offers 4 spacious bedrooms and 4.5 baths that are complemented by a dedicated office, private gym, and a true media room, creating space for work, wellness, and entertainment under one roof. High ceilings, intentional sightlines, and an open yet elegant layout make the home feel both grand and inviting. Step outside to a resort-style pool, expansive patio areas, and a private basketball sport court, ideal for hosting, relaxing, or making memories with family and friends. This is more than a home, it's a lifestyle property. One-story living, custom craftsmanship, generous acreage, and amenities rarely found together make this Burdick Custom Home a truly special offering.

    • Property Details
        • StyleOne Story, Spanish, Traditional, Mediterranean
        • Property SubtypeSingle Family Detached
        • School DistrictNORTH EAST I.S.D.
        • Elementary SchoolCall District
        • Middle SchoolCall District
        • High SchoolCall District
        • Property TypePurchase
        • MLS #1934694
        • Cost1795000
        • MLS #1934694
        • Acres1.204
        • Square Feet5102
        • Year Built2004
        • Bathrooms4.5
        • Bedrooms4
        • Full Baths4
        • Half Baths1
        • Pool1

    Location

    Legal

    Information provided Courtesy of LERA MLS - Local Expertise Regional Access. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is believed to be accurate but not guaranteed. Provided courtesy of the San Antonio Board of Realtors. Copyright 2025 LERA MLS, All Rights Reserved.

    Last Updated: Today at 4:43 PM. Source: LERAMLS

    Provided By
    Listing Agent: Tiffany Alvarez (#9754), Phone: (210) 789-2616, Email: tiffanyalvarez74@gmail.com
    Listing Office: Keller Williams Legacy (#LEGY00)

    Ade OgunbomehinReal Estate Group
    Facebook
    Google
    OR

    Interested in Purchasing 251 Lismore?

    Get an estimate on monthly payments on this property.

    Note: The results shown are estimates only and do not include all factors. Speak with a licensed agent or loan provider for exact details. This tool is sourced from CloseHack.

    Estimated Monthly Payment
    $0.00
    Loan Amount
    $0.00

    Nearby Listings in 78260

    No resultsMore Listings
      $
      years

      Down Payment

      $
      %
      10.0%

      Interest Rate

      %
      6.0%

      Tax Rate

      %
      2.6%
      $
      $
      annually
      $
      monthly