Off market oct 2025 for $2M

$2,087,819

Est. refi paymentEst. refi $14,045/mo

•

2,006

sq ft

123 Cliff Rd W, Wading River, NY 11792

About this home

Absolutely Stunning Sound front Mid-Century Modern Home on 2.5 Private, Gated Acres. Enjoy dramatic water views and sensational sunsets from this beautifully renovated retreat. Designed for both relaxation and entertaining, this home features a heated saltwater gunite infinity-edge pool with hot tub and waterfall, an expansive stone patio, and a fully equipped outdoor kitchen with grill, refrigerator, sink, and a new firepit. Inside, you'll find, two fireplaces, gorgeous wood floors throughout, A modern gourmet kitchen with high end appliances and stylish baths. Then entire home was gut-renovated to the studs in 1999, with major renovations from 2020-2022 and a new roof in 2024 and new Mahogony waterside deck. The home is equipped with Smart home technology and a state-of-the-art Sonos sound system (indoor & outdoor). The property is fully fenced with automatic security gate, and features landscape lighting, mature plantings, and a full irrigation system. Also included is Deeded access to a private neighborhood beach. This is truly an entertainer's paradise blending modern luxury with timeless design and unbeatable views.

Single-familyProperty Type

1963Year Built

2.5 acresLot Size

$1,041Est. Price/Sq.Ft.

1 car garageParking

Listing by Kristy Naddell • Douglas Elliman Real Estate

Contact: 631-354-8100

Bought with Sheri Winter Parker • Corcoran

Redfin checked: 2 minutes ago

•Source:OneKey® MLS as Distributed by MLS Grid #886669

Redfin Estimate

$2,087,819

$13K since sold in October 2025$16K since September

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 170% higher than the average sale price ($773K) of 6 comparable homes.

SOLD AUG 12, 2026
$650,000
A
4 beds2 baths1,638 sq ft
248 Dogwood Dr, Wading River, NY 11792
Listing by Coldwell Banker American Homes
SOLD SEP 22, 2026
$685,000
B
4 beds3 baths2,322 sq ft
11 Oakwood Dr, Wading River, NY 11792
Listing by BH&G R E Realty Connect
SOLD OCT 1, 2026
$695,000
C
4 beds2 baths2,050 sq ft
47 Fox Ln, Shoreham, NY 11786
Listing by Signature Premier Properties
SOLD SEP 11, 2026
$725,000
D
4 beds2 baths1,952 sq ft
16 Valentine Rd, Shoreham, NY 11786
Listing by MYNY Residential
SOLD SEP 2, 2026
$1,085,000
E
4 beds2 baths1,546 sq ft
3 Summit Dr, Calverton, NY 11933
Listing by Douglas Elliman Real Estate
SOLD JAN 29, 2026
$799,000
F
4 beds2.5 baths1,954 sq ft
73 Farm Rd N, Wading River, NY 11792
Listing by Daniel Gale Sothebys Intl Rlty

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$332,893

Est. take-home

List your home with Redfin and save $20,878

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$3,425/mo

Redfin rental estimate

List your home for rent

Market trends in 11792, NY

Last updated September 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

102.1%

+0.1% MoM

Median sale price

$773K

$23K MoM

Avg. days on market

30d

2 days MoM

Recently sold homes

3 MoM

New listings for sale

NEW 23 HRS AGO
$1,200,000
5 beds2.5 baths3,445 sq ft
15 Woodland Ct, Wading River, NY 11792
Listing by Signature Premier Properties
OPEN SAT, 10AM TO 11:30AM
$715,000
4 beds1.5 baths1,808 sq ft
82 Oakwood Dr, Wading River, NY 11792
Listing by Daniel Gale Sothebys Intl Rlty
$899,000
3 beds2.5 baths2,200 sq ft
61 Hill St E, Wading River, NY 11792
Listing by Douglas Elliman Real Estate
$699,000
6 beds5 baths2,280 sq ft
2939 N Wading River Rd, Wading River, NY 11792
Listing by Blue Shark Realty Group Inc
OPEN SUN, 11AM TO 1PM
$799,990
4 beds3 baths2,351 sq ft
30 Long Pond Rd, Wading River, NY 11792
Listing by Coldwell Banker M&D Good Life
See all

Provided by Redfin

Sale history for 123 Cliff Rd W

Date

Event

Price

Public Records

Dec 19, 2025

Sold

$2,075,000

$1,034/sq ft

OneKey® MLS as Distributed by MLS Grid #886669

Oct 25, 2025

Sold

$2,075,000

$1,034/sq ft

Aug 15, 2025

Pending

—

Jul 14, 2025

Listed

$2,250,000

$1,122/sq ft

Public Records

Apr 18, 2019

Sold

$1,267,500

$632/sq ft

OneKey® MLS as Distributed by MLS Grid #L3074085

Mar 25, 2019

Sold

$1,276,000

$636/sq ft

Feb 21, 2019

Pending

—

Oct 16, 2018

Listed

$1,295,000

$646/sq ft

Own This One Of A Kind Private Oasis ! If You Have An Eye For Art Or Architecture Your Going To Want To Preview This One . This Home Was Rebuilt Down To The Studs In 1999 .With Beach Access Just A Few Feet From Your Front Door This Is Thee Home That You Are Going To Want To Entertain In . ( Additional 1/2 Acre Lot May Also Be Purchased To Make T A 3 Acres In Total ), Additional information: Appearance:Diamond,Interior Features:Lr/Dr,Separate Hotwater Heater:Yes

Year

Property tax

Land + Additions

Assessment*

2026

$26,401

$35,000 + $81,500

$116,500

2025

$26,401 (+3.5%)

$35,000 + $81,500

$116,500

2024

$25,516 (+8.0%)

$35,000 + $81,500

$116,500

2023

$23,628 (+1.9%)

$35,000 + $81,500

$116,500

2022

$23,186

$35,000 + $81,500

$116,500

2021

$23,186 (+2.4%)

$35,000 + $81,500

$116,500

2020

$22,636 (+6.6%)

$35,000 + $81,500

$116,500

2019

$21,244 (+0.2%)

$35,000 + $81,500

$116,500

2018

$21,208 (+3.1%)

$35,000 + $81,500

$116,500

2017

$20,564 (+4.3%)

$35,000 + $81,500

$116,500

2016

$19,724 (+4.7%)

$35,000 + $81,500

$116,500

2015

$18,837

$35,000 + $81,500

$116,500

2014

$18,851 (+3.8%)

$35,000 + $81,500

$116,500

2013

$18,166 (+1.7%)

$35,000 + $81,500

$116,500

2012

$17,867 (+3.7%)

$35,000 + $81,500

$116,500

2011

$17,227 (+0.5%)

$35,000 + $81,500

$116,500

2010

$17,138 (+1.5%)

$35,000 + $81,500

$116,500

2009

$16,885

$35,000 + $81,500

$116,500

Tax history for 123 Cliff Rd W

Year

Property tax

Land + Additions

Assessment*

2026

$26,401

$35,000 + $81,500

$116,500

2025

$26,401 (+3.5%)

$35,000 + $81,500

$116,500

2024

$25,516 (+8.0%)

$35,000 + $81,500

$116,500

2023

$23,628 (+1.9%)

$35,000 + $81,500

$116,500

2022

$23,186

$35,000 + $81,500

$116,500

2021

$23,186 (+2.4%)

$35,000 + $81,500

$116,500

2020

$22,636 (+6.6%)

$35,000 + $81,500

$116,500

2019

$21,244 (+0.2%)

$35,000 + $81,500

$116,500

2018

$21,208 (+3.1%)

$35,000 + $81,500

$116,500

2017

$20,564 (+4.3%)

$35,000 + $81,500

$116,500

2016

$19,724 (+4.7%)

$35,000 + $81,500

$116,500

2015

$18,837

$35,000 + $81,500

$116,500

2014

$18,851 (+3.8%)

$35,000 + $81,500

$116,500

2013

$18,166 (+1.7%)

$35,000 + $81,500

$116,500

2012

$17,867 (+3.7%)

$35,000 + $81,500

$116,500

2011

$17,227 (+0.5%)

$35,000 + $81,500

$116,500

2010

$17,138 (+1.5%)

$35,000 + $81,500

$116,500

2009

$16,885

$35,000 + $81,500

$116,500

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Public record
Zoning

Beds

Baths

Stories

Lot width

—

Lot depth

—

Lot size

2.5 Acres

Year renovated

—

Sq. Ft.

3,354

Year built

1963

Style

Single Family Residential

County

Suffolk County

APN

0600026000100001000

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Aug 31, 2026.

RB80

Residence B-80 Zoning Use District

The intent of the Residence B-80 (RB-80) Zoning Use District is to allow for low density single-family residential development and encourage protection of prime agricultural soils where appropriate.

Permitted uses

Include but are not limited to:

Agriculture
Equestrian facility
Greenhouse / nursery
Livestock production
Housing-Single unit
Agriculture-Cropland
Agriculture-Grove / orchard

Property details

Parking

Parking Information
Carport YN: No
Parking Features: Attached, Private

Garage Information
Garage Spaces: 1
Has Garage

Interior

Fireplace Information
Has Fireplace
Fireplaces Total: 2

Heating & Cooling
Cooling: Central Air
Heating: Forced Air, Oil, Radiant

Interior Features
Interior Features: First Floor Bedroom,First Floor Full Bath,Breakfast Bar,Built-in Features,Eat-in Kitchen,Entrance Foyer,Galley Type Kitchen,Kitchen Island,Open Floorplan,Pantry,Master Downstairs,Sound System,Speakers,Whole House Entertainment System
Window Features: Skylight(s)
Appliances: Dishwasher, Dryer, Refrigerator, Washer
Flooring: Hardwood
Levels: Two
Patio And Porch Features: Deck, Patio

Room Information
Basement YN: No
Attic: None
Rooms Total: 10

Bathroom Information
Bathrooms Full: 2

Exterior

Exterior Features
Construction Materials: Frame
Waterfront YN: Yes

Pool Information
Has Private Pool
Pool Features: In Ground
Has Spa

Lot Information
Additional Parcels YN: No
Lot Features: Cul-De-Sac, Sprinklers In Front, Sprinklers In Rear

Property Information
Living Area Source: Plans
Living Area (Sq. Ft.): 2006.00
Property Sub Type: Single Family Residence

Financial

Tax Information
Tax Year: 2024
Tax Source: Municipality
Tax Annual Amount: $25,516.02

Financial Information
Buyer Financing: Conventional

Utilities

Utility Information
Sewer: Cesspool
Utilities: Propane, Water Connected

Location

HOA Information
Has Association
Association Amenities: Gated
Association Fee: $110
Association Fee Frequency: Annually
Association Fee Includes: Other

School Information
Elementary School: Roanoke Avenue School
Elementary School District: Riverhead
Middle Or Junior School: Riverhead Middle School
Middle Or Junior School District: Riverhead
High School: Riverhead Senior High School
High School District: Riverhead

Location Information
County Or Parish: Suffolk County

Public facts

Beds: 4
Baths: 2.0
Sq. Ft.: 3,354
Stories: 1.0
Lot Size: 2.5 acres
Style: Single Family Residential
Year Built: 1963
Year Renovated: —
County: Suffolk County
APN: 0600026000100001000

Home facts updated by county records on Aug 31, 2026

Around this home

Schools

Riley Avenue School

Public PreK-4 • Assigned • 5.3mi

2/10

Riverhead Middle School

Public 6-8 • Assigned • 8.8mi

3/10

Riverhead Senior High School

Public 9-12 • Assigned • 8.7mi

3/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

4/10 Heat Factor

7 days above 93° expected this year, 18 days in 30 years

8/10 Wind Factor

80% chance of strong winds in next 30 years

3/10 Air Factor

2 unhealthy days expected this year, 3 days in 30 years

Provided by First Street

Historical weather

Wading River, NY • 11792

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 8.9 hours in June and 4.6 hours in December, which is comparable to the U.S. average for solar exposure.

8.9 hrs

4.6 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$1.98M – $2.40M

Reach more buyers when you sell with Redfin. Save up to $20,878 in fees. 3 minutes to get started.

Need the cash from your home fast? Sell to .

Nearby similar homes

NEW 23 HRS AGO

$1,200,000

5 beds2.5 baths3,445 sq ft

15 Woodland Ct, Wading River, NY 11792

Listing by Signature Premier Properties

$699,000

1 bed1 bath1,170 sq ft

5 Oakwood Dr, Wading River, NY 11792

Listing by Marie Claire Realty LLC

$599,999

3 beds3 baths1,736 sq ft

4 Thunderbird Ct, Shoreham, NY 11786

Listing by Bizzy Bee Realty

OPEN SAT, 1PM TO 2:30PM

$558,999

3 beds2 baths1,392 sq ft

86 Hulse Ave, Wading River, NY 11792

Listing by Netter Real Estate Inc

$715,000

3 beds1 bath1,376 sq ft

1029 Wading River Manor Rd, Manorville, NY 11949

Listing by Brookhampton Realty

FOR SALE BY OWNER

$1,000,000

4 beds4 baths2,421 sq ft

172 Michaels Ln, Wading River, NY 11792

New listings for sale in 11792

NEW 23 HRS AGO

$1,200,000

5 beds2.5 baths3,445 sq ft

15 Woodland Ct, Wading River, NY 11792

Listing by Signature Premier Properties

OPEN SAT, 10AM TO 11:30AM

$715,000

4 beds1.5 baths1,808 sq ft

82 Oakwood Dr, Wading River, NY 11792

Listing by Daniel Gale Sothebys Intl Rlty

$899,000

3 beds2.5 baths2,200 sq ft

61 Hill St E, Wading River, NY 11792

Listing by Douglas Elliman Real Estate

$699,000

6 beds5 baths2,280 sq ft

2939 N Wading River Rd, Wading River, NY 11792

Listing by Blue Shark Realty Group Inc

OPEN SUN, 11AM TO 1PM

$799,990

4 beds3 baths2,351 sq ft

30 Long Pond Rd, Wading River, NY 11792

Listing by Coldwell Banker M&D Good Life

Home values near 123 Cliff Rd W

Data from public records.

Address	Redfin Estimate
177 Cliff Road West, Wading River, NY 3 Beds \| 1 Baths \| 984 Sq. Ft.	$554,502
178 Cliff Road West, Wading River, NY 3 Beds \| 1.5 Baths \| 1391 Sq. Ft.	$693,790

Address	Redfin Estimate
218 Cliff Road West, Wading River, NY 3 Beds \| 2 Baths \| 2657 Sq. Ft.	$789,958
209 Cliff Road West, Wading River, NY 4 Beds \| 2.5 Baths \| 1790 Sq. Ft.	$732,418

Address	Redfin Estimate
188 Cliff Road West, Wading River, NY 5 Beds \| 3 Baths \| 2566 Sq. Ft.	$703,175
185 Cliff Road West, Wading River, NY 3 Beds \| 1 Baths \| 969 Sq. Ft.	$601,203

Property information provided by OneKey® MLS as Distributed by MLS Grid when last listed in 2025. This data may not match . Learn more.

More real estate resources

Zip Codes
Neighborhoods
Cities
Minor Civil Divisions
Popular Searches

11949 homes for sale
11792 homes for sale
11933 homes for sale
11786 homes for sale
11961 homes for sale

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

Houses for rent in Wading River	Agents near me	White Plains, NY homes for sale	Wading River Housing Market
Houses for sale near me	New York, NY homes for sale	Yonkers, NY homes for sale
Land for sale near me	Manhattan, NY homes for sale	Scarsdale, NY homes for sale
Open Houses near me	Rochester, NY homes for sale	Wading River Property Records
Condos for sale near me	Buffalo, NY homes for sale	NY New Listings

Sayville homes for sale
Milford homes for sale
Ronkonkoma homes for sale

Guilford homes for sale
Madison homes for sale
Branford homes for sale