• 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 1 APR 2026 AT 1:59 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

7662 174th St

queens, NY 11366

US$2,198,000

  • 5 BR
    5 BA
    approx. 2,914 SF

Interested? Let's Connect

Welcome to your dream home in the heart of Fresh Meadows! This stunning new colonial was completed in 2025, offers exceptional craftsmanship, luxury finishes, and a thoughtfully designed layout perfect for modern living. Step into a grand entryway that flows into a bright, open concept living space featuring a fireplace and radiant heated floors throughout. The beautiful designer kitchen boasts a quartz island, high-end stainless-steel appliances, two dishwashers, and direct access to the terrace. The first floor includes two spacious bedrooms, two full bathrooms, a separate sink vanity for added comfort, and an additional office room, perfect for remote work or study. The second floor offers three more generously sized bedrooms and two full bathrooms, providing ample space. A fully finished basement adds even more versatility, featuring an open recreation room, heated floors, a full bathroom, a laundry room, and a separate entrance. Additional highlights include a beautifully crafted wood staircase and a professionally paved outdoor area that enhances the home’s curb appeal. This exquisite residence blends timeless craftsmanship with today’s most desirable amenities—all in a prime Fresh Meadows location. Conveniently situated near houses of worship, top-rated schools, St. John’s University, restaurants, supermarkets, major highways, and express buses to Manhattan.

Details

2,914 Sq Ft

4,750 Sq Ft Lot Size

single family home

US$11,419 Annual Tax

Built in 2002

MLS/Listing ID 935815

Amenities & Features

Lot - Private

Lot - Paved

Lot - Near Public Transit

Lot - Level

Lot - Landscaped

Lot - Garden

Lot - Front Yard

Parking - Private

Parking - Parking Lot

Parking - Open

Parking - On Street

Parking - Off Street

Parking - Driveway

Porch

Patio

ENERGY STAR Qualified Appliances

Stainless Steel Appliance(s)

Chef's Kitchen

Open kitchen

Walk-through Kitchen

Washer/Dryer Hookup

Lot - Back Yard

Lot - Near School

Construction - Stucco

Construction - Brick

Cooling - Central Air

Community - Park

Community - Sidewalks

Lighting

Vinyl

Lot - Views

Gas Dryer Hookup

In Basement

Breakfast Bar

Crown Molding

Eat-in Kitchen

Front Yard

Fenced

Backyard

Gas Fireplace

Family Room Fireplace

Hardwood

Ceramic Tile

Heating - Radiant Floor

Heating - Natural Gas

Storage

Smart Thermostat

Recessed Lighting

Open Floor Plan

Natural Woodwork

Kitchen Island

Granite Countertops

Entrance Foyer

Washer

Tankless Water Heater

Refrigerator

Gas Water Heater

Dryer

Dishwasher

Style - Colonial

Estimate my mortgage

TOTAL MONTHLY COST

US$0

  • PRINCIPAL & INTEREST

    US$0

  • PROPERTY TAXES

    US$0

  • Common Charges

    US$0

HOME PRICE
DOWN PAYMENT
TERM
INTEREST

Interested In 7662 174th St?