Stunning Country Colonial decorated by noted designer. Over 5000 square feet of exceptionally appointed living space with high ceilings, substantial millwork, wide plank floors, French doors, intricate faux painting and custom wall treatments. Dramatic two-story Entrance Hall. Graciously proportioned Living Room with stone-clad fireplace. Formal Dining Room. Country Kitchen. Impressive Great Room with vaulted Ceiling, wet bar and floor-to-ceiling stone fireplace. Opulent Master Suite with fireplace. Luxurious Master Bath with stone floor, radiant heat and Waterworks soaking tub. Office with built-ins. Four additional Bedrooms. Incredible rear terrace with pergola-covered dining area and barbecue. Three gorgeous acres with incredible flowering trees. Gunite Pool and Spa surrounded by ornamental grasses. Lovely latticed garden space, perfect for vegetables or perennials with espaliered apple trees and climbing grape vines. Antique Barn and Tree House. Truly Exceptional! Additional Information: HeatingFuel:Oil Above Ground,ParkingFeatures:3 Car Attached,
Single-familyProperty Type
2000Year Built
3 acresLot Size
$482Est. Price/Sq.Ft.
3 spacesParking
Listing by Christine Byrne• Ginnel Real Estate
Bought with Mary Palmerton• Houlihan Lawrence Inc.
Claim this home to receive a free report every month with insights on the changing estimate.
Earn from this home
Sell
$1,285,799
Est. take-home
List your home with Redfin and save $25,588
Rent
$4,298/mo
Redfin rental estimate
List your home for rent
Market trends in 10576, NY
Last updated October 2026
Buyer's Market
Seller's Market
Seller's market
Sale-to-list price
103.0%
2.2% MoM
Median sale price
$1.6M
$93K MoM
Avg. days on market
23d
4 days MoM
Recently sold homes
29
2 MoM
Provided by Redfin
Sale history for 474 Long Ridge Rd
Date
Event
Price
OneKey® MLS as Distributed by MLS Grid #H4933792
Nov 2, 2020
Sold
$1,595,000
$301/sq ft
Mar 11, 2020
Price Changed
$1,595,000
$301/sq ft
Feb 3, 2020
Price Changed
$1,699,000
$320/sq ft
Nov 1, 2019
Price Changed
$1,875,000
$353/sq ft
May 15, 2019
Listed
$1,995,000
$376/sq ft
OneKey® MLS as Distributed by MLS Grid #H4818985
Nov 6, 2018
Listing Removed
—
May 23, 2018
Listed
$2,495,000
$470/sq ft
OneKey® MLS as Distributed by MLS Grid #H4527128
Aug 17, 2015
Sold
$2,287,500
$431/sq ft
Jun 10, 2015
Listed
$2,395,000
$451/sq ft
Built in 2000 this home has been meticulously renovated. Decorated by world renowned designer, Jeffrey Bilhuber, the interior spaces are sophisticated & elegant. Stunning Great Room with floor to ceiling stone fireplace. Fabulous Master Suite with vaulted ceiling, exposed beams and fireplace. Luxurious Master Bath with stone floor, radiant heat & Waterworks soaking tub. Charming Gallery for family pictures or artwork. Beautifully landscaped property with flowering trees, Gunite Pool & spa surrounded by ornamental grasses. Lovely latticed vegetable and flower garden with espalier apple trees and climbing grape vines. Antique Barn, stone Terrace with covered Pergola, and Tree house! Additional Information: HeatingFuel:Oil Above Ground,ParkingFeatures:3 Car Attached,
As the MLS and public records start to fill up, we'll list the details here.