• Buy
  • Rent
  • Sell
  • Agents
New DevelopmentWorld of Elliman
The latest in luxury property, lifestyle & culture, curated just for you.

Company

  • About Us
  • Leadership
  • Offices
  • Press & News
  • Elliman Cares
  • Join as an Agent
  • Careers
  • Elliman Global
  • Investors

Resources

  • World of Elliman
  • Elliman Insider
  • Magazines
  • Market Reports
  • Research Reports
  • Elliman Private Listings
  • New Elliman Exclusives
  • Featured Cities
  • Guides to Buying & Selling

Brand Portfolio

  • New Development
  • Commercial
  • Relocation
  • Sports & Entertainment
  • Farm & Ranch
  • Building Broker Specialists
  • Title Services
  • Estate, Trust & Probate

  • California
  • Colorado
  • Connecticut
  • Florida
  • Massachusetts
  • Mid-Atlantic
  • Nevada
  • New Jersey
  • New York
  • New York City
  • Texas
  • Vermont
  • Site Map
  • Terms
  • Privacy
  • Cookie Preferences
  • Do Not Sell or Share My Personal Information
  • NYS Housing Discrimination Disclosure Notice & Form
  • NYS Standard Operating Procedure
  • NYS Tenants' Rights to Reasonable Accommodations for persons with disabilities
  • California Consumer Privacy Act Notice
  • Texas Consumer Protection Notice
  • Texas Real Estate Commission Information About Brokerage Services
  • Text of NYC Human Rights Law
  • New York City Commission on Human Rights
  • NYC Source of Income Discrimination Information
  • NYC Source of Income Discrimination Tenant FAQs

THE SOURCE OF THE DISPLAYED DATA IS EITHER THE PROPERTY OWNER OR PUBLIC RECORD PROVIDED BY NON-GOVERNMENTAL THIRD PARTIES. IT IS BELIEVED TO BE RELIABLE BUT NOT GUARANTEED. FOR COLORADO VIEWERS, INFORMATION ABOUT NON-COMMERCIAL PROPERTIES IS PROVIDED EXCLUSIVELY FOR YOUR PERSONAL, NON-COMMERCIAL USE.

575 MADISON AVENUE, NEW YORK, NY 10022. 212.891.7000 © 2026 DOUGLAS ELLIMAN REAL ESTATE. EQUAL EMPLOYMENT OPPORTUNITY PROVIDER. ALL MATERIAL PRESENTED HEREIN IS INTENDED FOR INFORMATION PURPOSES ONLY. WHILE THIS INFORMATION IS BELIEVED TO BE CORRECT, IT IS REPRESENTED SUBJECT TO ERRORS, OMISSIONS, CHANGES, OR WITHDRAWAL WITHOUT NOTICE. ALL PROPERTY INFORMATION, INCLUDING, BUT NOT LIMITED TO SQUARE FOOTAGE, ROOM COUNT, NUMBER OF BEDROOMS, AND THE SCHOOL DISTRICT IN PROPERTY LISTINGS SHOULD BE VERIFIED BY YOUR OWN ATTORNEY, ARCHITECT, OR ZONING EXPERT. EQUAL HOUSING OPPORTUNITY. LISTING DATA REFRESHED ON MAR 19 2026 AT 7:06 AM.

DOUGLAS ELLIMAN IS A LICENSED REAL ESTATE BROKER IN CALIFORNIA WITH LICENSE # 01947727, COLORADO WITH LICENSE # EC100053892, CONNECTICUT WITH LICENSE # REB.0314827, THE DISTRICT OF COLUMBIA WITH LICENSE # REO40000160, FLORIDA WITH LICENSE # CQ1020232, MARYLAND WITH LICENSE # 645270, MASSACHUSETTS WITH LICENSE # 422764, NEVADA WITH LICENSE # 1454643, NEW JERSEY WITH LICENSE # 0572105, NEW YORK WITH LICENSE # 10991211812, TEXAS WITH LICENSE # 9008706, AND VIRGINIA WITH LICENSE # 0226035659.

SCAMMERS ARE IMPERSONATING REAL ESTATE AGENTS AND USING ACTIVE LISTINGS TO REQUEST FAKE DEPOSITS. SHOULD YOU HAVE A QUESTION ABOUT THE LEGITIMACY OF A DOUGLAS ELLIMAN AGENT OR LISTING, PLEASE CONTACT THE AGENT DIRECTLY VIA THE “AGENTS” LINK IN THE TOP MENU. DOUGLAS ELLIMAN WILL NEVER ASK FOR ANY PAYMENT TO RESERVE, HOLD, OR VIEW A PROPERTY. THESE CHARGES ARE PROHIBITED UNDER NEW YORK LAW. IF YOU RECEIVE A SUSPICIOUS REQUEST FOR MONEY, DO NOT SEND FUNDS. REPORT IT TO THE NYS DEPARTMENT OF STATE AND NOTIFY DOUGLAS ELLIMAN. YOU CAN READ THE NEW YORK STATE DEPARTMENT OF STATE'S CONSUMER ALERT HERE.

POWERED BY PURLIN.AI

24 Miramar Heights Cir

sugar land, TX 77479

$2,999,999

  • 5 BR
    5 BA, 2 HALF BA
    approx. 7,792 SF

Interested? Let's Connect

UNBELIEVABLE OPPORTUNITY to own a MAGNIFICENT, ONE OF A KIND estate that sits on one of the BEST WATERFRONT lots and is situated on of Riverstone's ULTRA EXCLUSIVE GATED communities! This FORMER MODEL HOME was built by renowned builder Chris Sims and features unparalleled craftsmanship and construction! Showstopper kitchen came straight out of a magazine with marble counter tops, 2 islands - one with a reclaimed wood counter top, custom furniture like cabinetry and ultra- high end appliance including oversized fridge! Luxurious primary suite with reclaimed wood floors, spa-like bath w/steam shower and 2 closets. Multiple living areas including a game rm + media downstairs with cathedral style ceilings & wet bar with onyx counter tops that flows right into the large outdoor living area that features a stone fireplace & outdoor kitchen plus magnificent lake views! If you are looking for ultra- high end finishes plus water front living this is it! Call the Aida Younis Team today!

Details

7,792 Sq Ft

0.6371 Private Acres Lot Size

single family home

$2,300 Annually Maintenance/CC

$53,735 Annual Tax

Built in 2008

MLS/Listing ID 12503932

2 Stories

Amenities & Features

Disposal

Dishwasher

Style - Traditional

Style - French

Construction - Wood Siding

Construction - Stone

Cooling - Ceiling Fans

Cooling - Electric

Cooling - Zoned

Construction - Brick

Construction - Spray Foam Insulation

Slate

Patio/Deck

Double Oven

Microwave

Wine Refrigerator

Walk-in Closets

Wet Bar

Wired for Sound

HVAC

Thermostat

Heating - Natural Gas

Heating - Zoned

Slab

Carpet

Tile

Natural Wood

Gas Fireplace

Outside Fireplace

Backyard

Balcony

Outdoor Kitchen

Sprinkler Irrigation

Split Plan

Primary Bedroom - 1st Floor

Formal Entrance Foyer

2 Staircases

HVAC 13+ SEER

Side Yard

Back Green Space

Community - Subdivision Tennis Court

Travertine

Window Coverings

Lake Front

Lake View

Water View

Pool - Inground

Covered

Porch

Parking - Attached

Lot - Cul-de-sac

Lot - Waterfront

Electric Dryer Hookup

Gas Dryer Hookup

Washer Hookup

Crown Molding

Dry Bar

High Ceilings

Lot - Back Yard

Estimate my mortgage

TOTAL MONTHLY COST

$0

  • PRINCIPAL & INTEREST

    $0

  • PROPERTY TAXES

    $0

  • Common Charges

    $0

HOME PRICE
DOWN PAYMENT
TERM
INTEREST

Interested In 24 Miramar Heights Cir?