OFF MARKET

Off market dec 2020 for $1.4M

$2,179,189

Est. refi paymentEst. refi $9,073/mo

•

18,000

sq ft

5520 State Farm Rd, Voorheesville, NY 12186

About this home

Stately stone mansion offering total privacy while being convenient to everything. Breathtaking, elegant foyer with curved cherry double staircase and domed skylight. Master craftsmanship of built-ins, woodwork and molding is evident throughout. Gorgeous custom kitchen with a gas fireplace in the incomparable eating space surrounded by grand windows that offer a sweeping view of the city beyond the trees. The master suite is a private sanctuary with a luxurious master bath. The second floor offers an office with french doors, 4 additional BR's including a lovely guest suite, and unique lofts that are accessed from the surprisingly spacious third floor. Full-sized, fenced basketball court. The beauty, comfort and privacy of this home must be seen to be appreciated. Superior Condition, Custom Kitchen Feature

Single-familyProperty Type

1986Year Built

11 acresLot Size

$121Est. Price/Sq.Ft.

7 garage spacesParking

Listing by Nancy Klopfer • Coldwell Banker Prime Properties

Bought with non-member non member • NON MLS OFFICE

Redfin checked: 3 minutes ago

•Source:Global MLS #202010006

Listing provided courtesy of Global Multiple Listing Service, Inc.

Redfin Estimate

$2,179,189

$759K since sold in December 2020$38K since September

Recently sold homes
Estimate history
Homes for sale

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

SOLD JUN 23, 2026
$475,000
A
4 beds2.5 baths2,377 sq ft
25 Kling Ter, Voorheesville, NY 12186
Listing by Wolf River Real Estate, LLC
SOLD SEP 18, 2026
$659,900
B
5 beds4 baths3,810 sq ft
573 Jefferson Ct, Guilderland, NY 12084
Listing by Salisbury Real Estate Services
SOLD SEP 21, 2026
$770,000
C
4 beds2.5 baths3,098 sq ft
218 Swift Rd, Voorheesville, NY 12186
Listing by Howard Hanna Capital Inc
SOLD MAY 29, 2026
$709,000
D
5 beds3 baths3,300 sq ft
136 Wormer Rd, Voorheesville, NY 12186
Listing by KW Platform
SOLD AUG 14, 2026
$900,000
E
4 beds3 baths2,906 sq ft
164 Kennewyck Cir, Slingerlands, NY 12159
Listing by Signature One Realty Group LLC
SOLD AUG 25, 2026
$750,000
F
4 beds3 baths3,226 sq ft
22 E Claremont Dr, Voorheesville, NY 12186
Listing by Venture Fox Realty Group 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

$4,500/mo

Redfin rental estimate

List your home for rent

Market trends in 12186, NY

Last updated September 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

103.6%

+0.4% MoM

Median sale price

$475K

$59K MoM

Avg. days on market

4 days MoM

Recently sold homes

2 MoM

New listings for sale

NEW 24 HRS AGO
$275,000
5 beds3 baths1,674 sq ft
411 Gulf Hill Rd, Voorheesville, NY 12186
Listing by eXp Realty
3D WALKTHROUGH
$724,900
4 beds2.5 baths3,344 sq ft
37 Forest Dr, Voorheesville, NY 12186
Listing by Coldwell Banker Prime Properties
$549,800
2 beds2 baths1,819 sq ft
376 New Salem Rd, Voorheesville, NY 12186
Listing by Gabler Realty LLC
$449,900
4 beds2 baths1,968 sq ft
144 Stonington Hill Rd, Voorheesville, NY 12186
Listing by Carrow Real Estate Services LLC
$575,000
5 beds4 baths2,400 sq ft
748 Dunbar Hollow Rd, Voorheesville, NY 12186
Listing by Gabler Realty LLC
3D WALKTHROUGH
$999,900
4 beds3.5 baths3,476 sq ft
248 Indian Ledge Rd, Voorheesville, NY 12186
Listing by Coldwell Banker Prime Properties
See all

Provided by Redfin

Sale history for 5520 State Farm Rd

Date

Event

Price

Global MLS #202010006

Dec 16, 2020

Sold

$1,420,000

$79/sq ft

Nov 27, 2020

Pending

—

Aug 17, 2020

Price Changed

$1,699,000

$94/sq ft

Dec 31, 2019

Listed

$1,999,000

$111/sq ft

Global MLS #24113217

Mar 30, 2005

Sold

$1,350,000

$75/sq ft

Feb 2, 2005

Listing Removed

—

Aug 8, 2004

Listed

$1,750,000

$97/sq ft

Elegant architectural details & appointments are incorporated into every aspect of this home. Exquisite foyer with a curved cherry staircase lighted by glass dome. Magnificent custom made cherry trim & built-ins throughout. luxurious master suite, fabulous private guest suite. sixth fireplace in walkout basement, possible au pair quarters w/separate entrance, Private setting on 11 acres. this house has it all - call for details -- Superior Condition

Year

Property tax

Land + Additions

Assessment*

2026

$43,522

$350,000 + $1,200,000

$1,550,000

2025

$43,522 (+4.5%)

$350,000 + $1,200,000

$1,550,000

2024

$41,628 (+1.1%)

$350,000 + $1,200,000

$1,550,000

2023

$41,180 (+0.2%)

$350,000 + $1,200,000

$1,550,000

2022

$41,101 (+0.2%)

$350,000 + $1,200,000

$1,550,000

2021

$41,028 (−10.6%)

$350,000 + $1,200,000

$1,550,000

2020

$45,886 (−44.1%)

$350,000 + $1,400,000

$1,750,000

2019

$82,054 (+206.6%)

$350,000 + $1,400,000

$1,750,000

2018

$26,763 (+85.1%)

$350,000 + $1,400,000

$1,750,000

2017

$14,460 (−69.9%)

$180,900 + $1,289,100

$1,470,000

2016

$47,996 (−0.1%)

$180,900 + $1,289,100

$1,470,000

2015

$48,058 (+2.0%)

$180,900 + $1,289,100

$1,470,000

2014

$47,100

$180,900 + $1,289,100

$1,470,000

Tax history for 5520 State Farm Rd

Year

Property tax

Land + Additions

Assessment*

2026

$43,522

$350,000 + $1,200,000

$1,550,000

2025

$43,522 (+4.5%)

$350,000 + $1,200,000

$1,550,000

2024

$41,628 (+1.1%)

$350,000 + $1,200,000

$1,550,000

2023

$41,180 (+0.2%)

$350,000 + $1,200,000

$1,550,000

2022

$41,101 (+0.2%)

$350,000 + $1,200,000

$1,550,000

2021

$41,028 (−10.6%)

$350,000 + $1,200,000

$1,550,000

2020

$45,886 (−44.1%)

$350,000 + $1,400,000

$1,750,000

2019

$82,054 (+206.6%)

$350,000 + $1,400,000

$1,750,000

2018

$26,763 (+85.1%)

$350,000 + $1,400,000

$1,750,000

2017

$14,460 (−69.9%)

$180,900 + $1,289,100

$1,470,000

2016

$47,996 (−0.1%)

$180,900 + $1,289,100

$1,470,000

2015

$48,058 (+2.0%)

$180,900 + $1,289,100

$1,470,000

2014

$47,100

$180,900 + $1,289,100

$1,470,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

7.5

Stories

Lot width

—

Lot depth

—

Lot size

479,160

Year renovated

—

Sq. Ft.

18,000

Year built

1986

Style

Single Family Residential

County

Albany County

APN

013089A06200000010330000000

Parking Spaces

Basement

Yes

Accessible

HOA Dues

—

Garage

Yes

Features

Views

Last updated by owner on Sep 8, 2026.

Property details

Parking

Parking Information
Has Garage
Attached Garage YN: Yes
# of Garage Spaces: 7
# of Parking Total: 20
Parking Features: Off Street, Attached, Circular Driveway

Interior

Bathroom Information
# of Bathrooms (Full): 4
# of Bathrooms (Half): 4
# of Bathrooms (Total Integer): 8

Room 1 Information
Type: Primary Bedroom
Level: Second

Room 2 Information
Type: Living Room
Level: First

Room 3 Information
Type: Dining Room
Level: First

Room 4 Information
Type: Kitchen
Level: First

Room 5 Information
Type: Family Room
Level: First

Room 6 Information
Type: Library
Level: First

Room 7 Information
Type: Office
Level: Second

Room 8 Information
Type: Bedroom
Level: Third

Room 9 Information
Type: Primary Bathroom
Level: Second

Room 10 Information
Type: Full Bathroom
Level: Second

Room 11 Information
Type: Half Bathroom
Level: Second

Room 12 Information
Type: Half Bathroom
Level: First

Basement Information
Basement: Finished, Full, Heated, Walk-Out Access

Laundry Features
Laundry Features: Laundry Room, Main Level

Fireplace Information
Has Fireplace
# of Fireplaces Total: 6
Fireplace Features: Other, Basement, Bedroom, Family Room, Gas, Living Room, Wood Burning

Interior Features
# of Rooms Total: 12
Interior Features: High Speed Internet, Solid Surface Counters, Tray Ceiling(s), Vaulted Ceiling(s), Walk-In Closet(s), See Remarks, Built-in Features, Cathedral Ceiling(s), Ceramic Tile Bath
Appliances: Dishwasher, Disposal, Double Oven, Freezer, Indoor Grill, Microwave, Range Hood, Refrigerator
Flooring: Ceramic Tile, Hardwood, Marble, Parquet
Door Features: Atrium Door, French Doors
Window Features: Skylight(s)

Exterior

Exterior Features
Patio And Porch Features: Patio, Porch
Roof: Asphalt
Exterior Features: Gas Grill, Lighting

Property Information
Property Sub Type: Single Family Residence
Living Area: 12,565
Construction Materials: Stone
Security Features: Security System

Lot Information
Lot Size Acres: 11
Lot Size Square Feet: 479,160
Lot Size Dimensions: 11 acres
Lot Features: Secluded, Level, Private, Wooded, Landscaped
Main Road Frontage: 953

Financial

Tax Information
Tax Annual Amount: $45,708
Tax Annual Amount: $45,708

Utilities

Heating & Cooling
Has Heating
Heating: Forced Air, Hot Water, Natural Gas, Radiant
Has Cooling
Cooling: Central Air

Utility Information
Sewer: Public Sewer
Utilities: Cable Available
Water Source: Public

Location

School Information
School District: Voorheesville

Location Information
Directions: From Rt 20, State Farm Rd (Rt 155) toward Voorheesville, left into driveway approx. 100 yards past Wormer Rd.

Public facts

Beds: 10
Baths: 7.5
Sq. Ft.: 18,000
Stories: 2.5
Parking Spaces: 27
Basement: Yes
Accessible: No
Lot Size: 11 acres
Style: Single Family Residential
Year Built: 1986
Year Renovated: —
County: Albany County
APN: 013089A06200000010330000000
HOA Dues: —
Garage: Yes
Features: Views

Home facts updated by owner on Sep 8, 2026

Around this home

Schools

Voorheesville Elementary School

Public K-5 • Assigned • 1.9mi

6/10

Voorheesville Middle School

Public 6-8 • Assigned • 3.3mi

6/10

Clayton A Bouton High School

Public 9-12 • Assigned • 3.3mi

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

3/10 Heat Factor

7 days above 96° expected this year, 15 days in 30 years

3/10 Wind Factor

6% 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

Voorheesville, NY • 12186

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

8.6 hrs

3.4 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$2.07M – $2.51M

Sell confidently with a local market expert in Voorheesville. 3 minutes to get started.

Nearby similar homes

$267,000

3 beds2 baths1,344 sq ft

462 State Route 146, Altamont, NY 12009

Listing by Miranda Real Estate Group Inc

$450,000

4 beds3 baths2,321 sq ft

10 Kaine Dr, Albany, NY 12203

Listing by Miranda Real Estate Group Inc

$799,000

4 beds3.5 baths2,585 sq ft

8 Fairway Ct, Voorheesville, NY 12186

Listing by Gabler Realty LLC

$449,900

4 beds2 baths1,968 sq ft

144 Stonington Hill Rd, Voorheesville, NY 12186

Listing by Carrow Real Estate Services LLC

$412,500

4 beds2 baths1,702 sq ft

2 Janet Ln, Albany, NY 12203

Listing by Newcomb Realty Group LLC

$699,000

4 beds3.5 baths3,550 sq ft

450 State Route 146, Guilderlan, NY 12009

Listing by KW Platform

New listings for sale in 12186

NEW 24 HRS AGO

$275,000

5 beds3 baths1,674 sq ft

411 Gulf Hill Rd, Voorheesville, NY 12186

Listing by eXp Realty

3D WALKTHROUGH

$724,900

4 beds2.5 baths3,344 sq ft

37 Forest Dr, Voorheesville, NY 12186

Listing by Coldwell Banker Prime Properties

$549,800

2 beds2 baths1,819 sq ft

376 New Salem Rd, Voorheesville, NY 12186

Listing by Gabler Realty LLC

$449,900

4 beds2 baths1,968 sq ft

144 Stonington Hill Rd, Voorheesville, NY 12186

Listing by Carrow Real Estate Services LLC

$575,000

5 beds4 baths2,400 sq ft

748 Dunbar Hollow Rd, Voorheesville, NY 12186

Listing by Gabler Realty LLC

3D WALKTHROUGH

$999,900

4 beds3.5 baths3,476 sq ft

248 Indian Ledge Rd, Voorheesville, NY 12186

Listing by Coldwell Banker Prime Properties

Home values near 5520 State Farm Rd

Data from public records.

Address	Redfin Estimate
238 State Farm Road, Voorheesville, NY 3 Beds \| 1.5 Baths \| 2240 Sq. Ft.	$390,785
147 Wormer Road, Voorheesville, NY 2 Beds \| 1 Baths \| 1140 Sq. Ft.	$255,245

Address	Redfin Estimate
5590 State Farm Road, Guilderland, NY 3 Beds \| 1.5 Baths \| 1196 Sq. Ft.	$233,430
123 Wormer Road, Voorheesville, NY 2 Beds \| 2 Baths \| 1840 Sq. Ft.	$423,038

Address	Redfin Estimate
246 State Farm Road, Voorheesville, NY 4 Beds \| 1.5 Baths \| 1700 Sq. Ft.	$328,616
20 Devon Court, Voorheesville, NY 3 Beds \| 2.5 Baths \| - Sq. Ft.	$423,192

Property information provided by Global MLS when last listed in 2019. This data may not show owner updates. 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.

12054 homes for sale
12205 homes for sale
12303 homes for sale
12304 homes for sale
12309 homes for sale

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

Mont Pleasant homes for sale
Woodlawn homes for sale
Bellevue homes for sale

Albany homes for sale
Troy homes for sale
Saratoga Springs homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 12186, NY

Sale history for 5520 State Farm Rd

Tax history for 5520 State Farm Rd

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 12186

Home values near 5520 State Farm Rd

More real estate resources