Off market aug 2025 for $560K

$591,416

Est. refi paymentEst. refi $4,362/mo

•

1,008

sq ft

152 Frank Rd, Hamilton, NY 13346

About this home

WATERFRONT home on beautiful Lake Moraine, town of Madison, Hamilton School, minutes from village of Hamilton and college town of Colgate University. Once a summer cottage, this sweet lake house was remodeled six years ago and now offers YEAR ROUND living at its finest. First impression will be - WOW! - what a view!! Bank of windows in the GREAT ROOM overlook the lake, deck and "front" yard. Thoughtful kitchen design with large breakfast bar, stunning cabinetry/good storage opens up to living room-dining room combo, corner stone gas fireplace, wood floors, vaulted ceiling, big windows! In addition, first floor offers two bedrooms, nicely tiled full bath, entry foyer/laundry room. Step downstairs into the 3rd bedroom with full bath or make this your comfortable home office-exercise room with a sliding door to the lakefront. Spacious deck overlooks the lake. Includes dock, kayak rack. 2 car garage. This gorgeous home is in MOVE-IN CONDITION!

Single-familyProperty Type

1954Year Built

0.31 acresLot Size

$587Est. Price/Sq.Ft.

2 car garageParking

Listing by Suzanne Martin • Suzanne L. Martin R.E., LLC

•315-824-2203 (broker)

•suzanne@martinre.com (broker)

Bought with John Sageer • River Hills Properties LLC Ut

•315-864-3671 (broker)

•realestatebyrobin@gmail.com (broker)

Redfin checked: 3 minutes ago

•Source:CNYIS #S1615470

Redfin Estimate

$591,416

$31K since sold in August 2025$5,000 since September

Recently sold homes
Estimate history
Homes for sale

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

SOLD JUN 26, 2026
$289,000
A
3 beds1 bath1,025 sq ft
98 Eaton St, Hamilton, NY 13346
Listing by Hamilton Village R.E., LLC
SOLD AUG 10, 2026
$250,000
B
3 beds2 baths1,054 sq ft
92 Cedar St, Morrisville, NY 13408
Listing by Howard Hanna Real Estate
SOLD AUG 6, 2026
$148,000
C
3 beds1 bath1,004 sq ft
13 Cedar St, Morrisville, NY 13408
Listing by Coldwell Banker Faith Properties R
SOLD JUL 28, 2026
$180,000
D
3 beds2 baths1,512 sq ft
43 South St, Morrisville, NY 13408
Listing by Howard Hanna Real Estate
SOLD SEP 16, 2026
$100,000
E
3 beds2 baths1,347 sq ft
41 S Main St, Earlville, NY 13332
Listing by Hamilton Village R.E., LLC
SOLD MAY 29, 2026
$372,500
F
Land— sq ft
924 Taylor Grove Rd, Madison, NY 13346
Listing by Suzanne L. Martin R.E., LLC

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

Earn from this home

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$1,855/mo

Redfin rental estimate

List your home for rent

Market trends in 13346, NY

Last updated September 2026

Buyer's Market

Seller's Market

Balanced market

Sale-to-List Price

97.3%

0.9% MoM

Median sale price

$400K

$8K MoM

Avg. days on market

54d

12 days MoM

Recently sold homes

1 MoM

New listings for sale

$429,000
4 beds2.5 baths1,700 sq ft
507 Chenango Hill Dr, Hamilton, NY 13346
Listing by Hamilton Village R.E., LLC, (315) 824-0800
$189,000
2 beds2 baths980 sq ft
5912 Geer Rd, Hamilton, NY 13346
Listing by Belfield Realty LLC, (315) 404-8232
3D WALKTHROUGH
$489,900
4 beds2 baths2,575 sq ft
9 E Pleasant St, Hamilton, NY 13346
Listing by Howard Hanna Real Estate, (315) 682-9500
See all

Provided by Redfin

Sale history for 152 Frank Rd

Year

Property tax

Land + Additions

Assessment*

2026

$8,272

$56,300 + $98,700

$155,000

2025

$8,272 (+7.3%)

$56,300 + $98,700

$155,000

2024

$7,710 (+2.3%)

$56,300 + $98,700

$155,000

2023

$7,533 (+6.5%)

$56,300 + $98,700

$155,000

2022

$7,076 (+1.4%)

$56,300 + $98,700

$155,000

2021

$6,977 (−1.5%)

$56,300 + $98,700

$155,000

2020

$7,085 (+4.7%)

$56,300 + $98,700

$155,000

2019

$6,768 (+8.2%)

$56,300 + $98,700

$155,000

2018

$6,255 (+3.1%)

$56,300 + $98,700

$155,000

2017

$6,066 (+136.8%)

$56,300 + $88,700

$145,000

2016

$2,561 (−46.9%)

$56,300 + $88,700

$145,000

2015

$4,827 (+5.4%)

$56,300 + $88,700

$145,000

2014

$4,578

$56,300 + $88,700

$145,000

Tax history for 152 Frank Rd

Year

Property tax

Land + Additions

Assessment*

2026

$8,272

$56,300 + $98,700

$155,000

2025

$8,272 (+7.3%)

$56,300 + $98,700

$155,000

2024

$7,710 (+2.3%)

$56,300 + $98,700

$155,000

2023

$7,533 (+6.5%)

$56,300 + $98,700

$155,000

2022

$7,076 (+1.4%)

$56,300 + $98,700

$155,000

2021

$6,977 (−1.5%)

$56,300 + $98,700

$155,000

2020

$7,085 (+4.7%)

$56,300 + $98,700

$155,000

2019

$6,768 (+8.2%)

$56,300 + $98,700

$155,000

2018

$6,255 (+3.1%)

$56,300 + $98,700

$155,000

2017

$6,066 (+136.8%)

$56,300 + $88,700

$145,000

2016

$2,561 (−46.9%)

$56,300 + $88,700

$145,000

2015

$4,827 (+5.4%)

$56,300 + $88,700

$145,000

2014

$4,578

$56,300 + $88,700

$145,000

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

Public record

Beds

Baths

Stories

Lot width

—

Lot depth

—

Lot size

0.31 Acres

Year renovated

—

Sq. Ft.

1,008

Year built

1954

Style

Single Family Residential

County

Madison County

APN

254089A13801800010500000000

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Oct 8, 2026.

Property details

Parking

Garage/Carport Information
Has Garage
# of Garage Spaces: 2

Parking
Features: Detached, Electricity, Garage, Garage Door Opener

Interior

Virtual Tour

Bedroom Information
# of Main Level Bedrooms: 2

Bathroom Information
# of Full Bathrooms: 2
# of Main Level Bathrooms: 1

Room Information
# of Rooms (Total): 5
Room Types: Bedroom, Great Room, Laundry, Entry Foyer
Has Basement
Basement Information: Crawl Space, Partially Finished, Walk-Out Access

Laundry Information
Features: Main Level

Fireplace Information
Has Fireplace
# of Fireplaces: 1

Equipment
Appliances: Dryer, Dishwasher, Electric Oven, Electric Range, Microwave, Propane Water Heater, Refrigerator, Wine Cooler, Washer

Interior Features
Door Features: Sliding Doors
Flooring: Hardwood, Laminate, Tile, Varies
Other Features: Breakfast Bar, Entrance Foyer, Granite Counters, Great Room, Kitchen/Family Room Combo, Living/Dining Room, Quartz Counters, Sliding Glass Door(s), Bedroom on Main Level

Exterior

Building Information
Stories: 1
Stories (Total): 1
Year Built Details: Existing
Roof Details: Shingle
Construction Details: Frame, Vinyl Siding

Exterior Features
Exterior Features: Deck, Dock, Gravel Driveway, See Remarks, Propane Tank - Leased
Patio And Porch Features: Deck

Lot Information
Lot Size Area: 0.31
Lot Size Acres: 0.31
Lot Size Dimensions: 60X245
Lot Features: Irregular Lot
Road Frontage Type: Private Road
Is Waterfront
Water Body Name: Lake Moraine
Waterfront Features: Beach Access, Dock Access, Lake
Frontage Length: 60
Frontage Length Remarks: 60

Property Information
Has View
Foundation Details: Block
Resale

Financial

Assessments and Fees
Assessed Value: $155,000

Tax Information
Annual Tax Amount: $7,710

Utilities

Utility Information
Utilities: Cable Available, Electricity Connected, High Speed Internet Available
Electric: Circuit Breakers
Sewer: Septic Tank
Water Source: Well

Heating & Cooling
Has Cooling
Cooling: Central Air
Has Heating
Heating: Propane, Forced Air

Public facts

Beds: 2
Baths: 1.0
Sq. Ft.: 1,008
Stories: 1.0
Lot Size: 0.31 acres
Style: Single Family Residential
Year Built: 1954
Year Renovated: —
County: Madison County
APN: 254089A13801800010500000000

Home facts updated by county records on Oct 8, 2026

Around this home

Schools

Hamilton Elementary School

Public PreK-5 • Assigned • 2.3mi

5/10

Hamilton Junior Senior High School

Public 6-12 • Assigned • 2.3mi

7/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

3/10 Fire Factor

0.31% chance of being in a wildfire in next 30 years

2/10 Heat Factor

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

2/10 Wind Factor

1% chance of strong winds in next 30 years

1/10 Air Factor

0 unhealthy days expected this year, 0 days in 30 years

Provided by First Street

Historical weather

Hamilton, NY • 13346

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.6 hours in June and 2.4 hours in December, placing it below the U.S. average for solar exposure.

8.6 hrs

2.4 hrs

JuneDecember

Provided by Shadowmap

Is this your home?

Track this home’s value and nearby sales activity

Nearby similar homes

$350,000

3 beds2 baths1,844 sq ft

2846 W Hill Rd, Hamilton, NY 13346

Listing by Suzanne L. Martin R.E., LLC, (315) 824-2203

$405,000

3 beds2.5 baths2,006 sq ft

3985 Williams Corners Rd, Morrisville, NY 13408

Listing by Hunt Real Estate ERA, (315) 682-7197

$419,900

3 beds2.5 baths1,792 sq ft

4881 Goff Rd, Morrisville, NY 13408

Listing by Kay Real Estate, (315) 363-9191

$394,900

2 beds2 baths1,596 sq ft

2255 Church Rd, Hamilton, NY 13346

Listing by Integrated Real Estate Ser LLC, (315) 522-3194

$250,000

4 beds2 baths1,979 sq ft

1836 Preston Hill Rd Rd, Hamilton, NY 13346

Listing by Suzanne L. Martin R.E., LLC, (315) 824-2203

$680,000

4 beds3 baths3,584 sq ft

1474 Alabam Rd, Oriskany Falls, NY 13425

Listing by Coldwell Banker Sexton Real Estate, (315) 853-3535

New listings for sale in 13346

$429,000

4 beds2.5 baths1,700 sq ft

507 Chenango Hill Dr, Hamilton, NY 13346

Listing by Hamilton Village R.E., LLC, (315) 824-0800

$189,000

2 beds2 baths980 sq ft

5912 Geer Rd, Hamilton, NY 13346

Listing by Belfield Realty LLC, (315) 404-8232

3D WALKTHROUGH

$489,900

4 beds2 baths2,575 sq ft

9 E Pleasant St, Hamilton, NY 13346

Listing by Howard Hanna Real Estate, (315) 682-9500

Home values near 152 Frank Rd

Data from public records.

Address	Redfin Estimate
328 Frank Road, Hamilton, NY 3 Beds \| 2 Baths \| 2688 Sq. Ft.	$554,554
324 Frank Road, Hamilton, NY 2 Beds \| 1 Baths \| 868 Sq. Ft.	$235,158

Address	Redfin Estimate
332 Frank Road, Hamilton, NY 4 Beds \| 3 Baths \| 3572 Sq. Ft.	$593,957
136 Frank Road, Hamilton, NY 4 Beds \| 2.5 Baths \| 2200 Sq. Ft.	$573,396

Address	Redfin Estimate
320 Frank Road, Hamilton, NY 3 Beds \| 3 Baths \| 1210 Sq. Ft.	$422,666
148 Frank Road, Hamilton, NY 2 Beds \| 1 Baths \| 936 Sq. Ft.	$311,153

Property information provided by CNYIS when last listed in 2025. This data may not match . Learn more.

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 Madison	Agents near me	White Plains, NY homes for sale	Madison 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	Madison Property Records
Condos for sale near me	Buffalo, NY homes for sale	NY New Listings

Rome homes for sale
Cazenovia homes for sale
Utica homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 13346, NY

Sale history for 152 Frank Rd

Tax history for 152 Frank Rd

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Is this your home?

Nearby similar homes

New listings for sale in 13346

Home values near 152 Frank Rd

More real estate resources