• 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 16 2026 AT 8:24 PM.

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

5464 Crestwood Rd

ellery, NY 14712

$759,000

  • 5 BR
    3 BA, 1 HALF BA
    approx. 4,300 SF

Interested? Let's Connect

Nestled on a private lot with breathtaking panoramic views of CHQ Lake, this stunning home is a masterpiece of design and comfort with over 4,300 sq ft. Boasting soaring ceilings and dramatic floor-to-ceiling windows, this home offers an abundance of natural light and seamless indoor-outdoor living, making it the perfect retreat for those who appreciate the beauty of the lake. The expansive deck provides the ideal vantage point for savoring vibrant sunsets over the water, while the Deeded Lake Rights and boat slip ensure easy access to endless days of boating and recreation. Inside, the thoughtfully designed floor plan features five spacious bedrooms spread across three levels. The primary suite is a luscious haven, offering serene lake views, and an elegant en-suite bath. The walk out lower level adds versatility, offering additional living space complete with two more bedrooms, full bath, family room, wet bar area, and direct access to to the expansive yard making it perfect for entertaining and hosting guests. A rare combination of privacy, luxury, and lakefront convenience, this CHQ Lake retreat is the ultimate escape for those who crave the perfect blend of a private neighborhood along with adventure. Don't miss the opportunity to own this extraordinary CHQ sanctuary!

Details

4,300 Sq Ft

0.45 Private Acres Lot Size

single family home

$590 Annually Maintenance/CC

$8,077 Annual Tax

Built in 1990

MLS/Listing ID R1595978

2 Stories

Amenities & Features

Hardwood

Cooling - Central Air

Construction - Vinyl Siding

Style - Two Story

Electric Water Heater

Exhaust Fan

Gas Oven

Gas Range

Range Hood

Refrigerator

Dock Access

Parking - Attached

Parking - Circular Driveway

Parking - Garage

Lot - Rectangular Lot

Bar

Den

Eat-in Kitchen

Granite Countertops

Kitchen Family Room Combo

Kitchen Island

Living Dining Room

Main Level Primary

Heating - Forced Air

Heating - Gas

Carpet

Lake

Beach Access

Deeded Access

Estimate my mortgage

TOTAL MONTHLY COST

$0

  • PRINCIPAL & INTEREST

    $0

  • PROPERTY TAXES

    $0

  • Common Charges

    $0

HOME PRICE
DOWN PAYMENT
TERM
INTEREST

Interested In 5464 Crestwood Rd?