• 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
  • Elliman Yachts

  • 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 JUN 28 2026 AT 2:50 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.

This website has been translated using automated software for convenience. While reasonable efforts have been made to ensure accuracy, machine translation may contain errors and is not a substitute for human translation. Translations are provided “as is,” without any express or implied warranty regarding their accuracy, reliability, or completeness. Some content (including images or videos) may not be translated accurately. The official version of this website is the English version. Any discrepancies in translation are not binding and have no legal effect; the English version controls.

POWERED BY PURLIN.AI

18710 Aberdeen Rd

queens, NY 11432

$5,795,000

  • 6 BR
    4 BA, 1 HALF BA
    approx. 8,600 SF

Interested? Let's Connect

Rarely does a residence of this magnitude come to market. Conceived without compromise and executed with meticulous craftsmanship, every inch of this all-brick manor reflects the vision of an owner who demanded nothing less than perfection.
Arrival sets the tone immediately. A sweeping, oversized front porch welcomes you with the kind of gracious presence rarely found in the borough — an architectural statement as much as a functional space, perfectly suited for morning coffee, evening gatherings, or simply enjoying the quiet prestige of the neighborhood. Step through the front door and you are met by a grand entry foyer crowned with soaring cathedral ceilings, where the scale and quality of the home announce themselves instantly.
Spanning four breathtaking levels connected by a private four-stop elevator, the residence commands its surroundings with dramatic 11-foot ceilings that lend every room an air of grandeur and openness. The principal floor is designed for living and entertaining at the highest level. A large, sun-filled living room anchored by an elegant fireplace creates an atmosphere of warmth and sophistication — the natural gathering place of the home, equally suited to intimate evenings and grand receptions.
The formal dining room is a room of genuine distinction. Generously proportioned and finished to an exacting standard, it is a space designed to impress — ideal for formal dinner parties, holiday celebrations, and the kind of entertaining that creates lasting memories. Adjacent, a sunlit breakfast room offers a more relaxed counterpart for everyday dining, while the large eat-in kitchen opens directly onto a spacious rear porch — extending the living space seamlessly to the outdoors and creating an effortless flow between cooking, dining, and entertaining.
Six large, beautifully appointed bedrooms provide an abundance of space for rest, privacy, and personal retreat. Each bedroom is generously sized with thoughtful layouts, premium finishes, and exceptional natural light. The primary suite is a sanctuary of its own — expansive in scale, refined in detail, and designed to provide the ultimate in comfort and privacy. The remaining five bedrooms are equally well-considered, offering versatility for guests, family, or dedicated home office use. he fully finished lower level is a destination in its own right — a private world of wellness, recreation, and comfort that sets this property apart from anything else on the market. Designed for those who expect the extraordinary, it encompasses dedicated maid's quarters, a professional-caliber gym, a generous entertainment area, a dry sauna, and a private hot tub — all finished to the same exacting standard as the floors above. The in-ground Gunite heated pool anchors the private rear grounds — a resort-caliber amenity that transforms the backyard into a personal oasis. This is resort living, without ever leaving home.

Details

8,600 Sq Ft

7,560 Sq Ft Lot Size

single family home

$1,791 Monthly Tax

Built in 2012

MLS/Listing ID 1015756

Amenities & Features

Entrance Foyer

Elevator

Eat-in Kitchen

Crown Molding

Chandelier

Cathedral Ceilings

Breakfast Bar

Laundry Room

Washer

Refrigerator

Range

Microwave

Dryer

Dishwasher

Style - Colonial

Construction - Stone

Construction - Brick

Construction - Block

In Basement

Parking - Driveway

Pool - Tile

Pool - Salt Water

Pool - Outdoor

Pool - Inground

Construction - Blown-In Insulation

Chef's Kitchen

Tilt Turn Windows

High Ceilings

High Speed Internet

Kitchen Island

Sauna

Walk-in Closets

Heating - Natural Gas

Heating - Radiant

Heating - Radiant Floor

Combination

Hardwood

Tile

Cooling - Central Air

Cooling - Ductless

Public Water

Public Sewer

Estimate my mortgage

TOTAL MONTHLY COST

$0

  • PRINCIPAL & INTEREST

    $0

  • PROPERTY TAXES

    $0

  • Common Charges

    $0

HOME PRICE
DOWN PAYMENT
TERM
INTEREST

Interested In 18710 Aberdeen Rd?