Sold
Last Sold Price
9 beds12,565 sqft
5520 State Farm Rd, Voorheesville, NY 12186
Single FamilyProperty Type
11 acresLot Size
1986Year Built
$113/sq ftPrice per sq ft
20 carsParking Spaces

Description

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...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
  • Listed by: Nancy Klopfer 518.439.9600 kirsten.blanchard@coldwellbankerprime.com • Coldwell Banker Prime Prop.
Listing closed: 12/16/2020 12:00 AM • Source: GLOBAL MLS, MLS#: 202010006

See It First™ on Compass

Find homes before they're listed on other real estate sites.

Start your search

Recent comparable sales

Median sold price

$410,000

Avg days on market

5

Sale-to-list ratio

101.7%

Voorheesville, NY

9 comparable properties found

$1,250,000 | 21 East Claremont Drive, Voorheesville, NY 12186
1/50
1

$1,250,000

Sold 08/04/25

5
Bedrooms
3,999
Square Feet
6.21
Acres
$235,000 | 23 North Grandview Terrace, Voorheesville, NY 12186
1/19
2

$235,000

Sold 01/14/26

9
Bedrooms
2,384
Square Feet
2.2
Acres
$330,600 | 39 Wormer Road, Voorheesville, NY 12186
1/26
3

$330,600

Sold 07/16/25

3
Bedrooms
1,300
Square Feet
0.34
Acres
$400,000 | 3 Wesley Place, Voorheesville, NY 12186
1/54
4

$400,000

Sold 04/18/25

2
Bedrooms
1,481
Square Feet
0.06
Acres
$410,000 | 13 Chesterfield Drive, Voorheesville, NY 12186
1/2
5

$410,000

Sold 12/05/25

3
Bedrooms
1,919
Square Feet
0.21
Acres
$570,000 | 202 Wormer Road, Voorheesville, NY 12186
1/64
6

$570,000

Sold 04/04/25

4
Bedrooms
2,942
Square Feet
0.54
Acres
$510,000 | 26 Chesterfield Drive, Voorheesville, NY 12186
1/2
7

$510,000

Sold 09/08/25

3
Bedrooms
1,800
Square Feet
0.18
Acres
$390,000 | 7 Ridgefield Drive, Voorheesville, NY 12186
1/51
8

$390,000

Sold 08/06/25

3
Bedrooms
2,082
Square Feet
0.29
Acres
$492,000 | 4 Wedgewood Lane, Voorheesville, NY 12186
1/44
9

$492,000

Sold 06/04/25

3
Bedrooms
1,918
Square Feet
0.26
Acres

Location

Listing Courtesy of Coldwell Banker Prime Prop.

Sold By NON MLS OFFICE

Add your commute

Payment Calculator

$11,390 per month

30 year fixed, 7.03% Interest

Principal and Interest

$7,581

Property Taxes

$3,809

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 5520 State Farm Road

Property Details
  • Taxes: $45,708 / year
  • MLS Type: Residential / Single Family Residence
  • Architectural Style: Mansion
  • Waterfront: No
  • Parking Total: 20.00
Building Information
  • Year Built: 1986
  • Lot Size: 11.00 AC / 479,160 SF
Summary
Location and General Information
  • Postal City: Voorheesville
  • Directions: From Rt 20, State Farm Rd (Rt 155) toward Voorheesville, left into driveway approx. 100 yards past Wormer Rd.
  • City: Guilderland
  • State Or Province: NY
  • Postal Code: 12186
  • County Or Parish: Albany
  • Latitude: 42.67
  • Longitude: -73.91
Taxes and HOA
  • Association Fee: $.00
  • Association: No
  • Tax Lot: 3
  • Tax Block: 1
  • Parcel Number: 013089 62.00-1-3
  • Tax Tract: 62.00
  • Tax Annual Amount: $45,708.00
  • Contract Information : Plot Map Y/N: No
Parking
  • GarageSpaces: 7.00
  • Attached Garage: Yes
  • Parking Features: Off Street, Attached, Circular Driveway
School Information
  • School District: Voorheesville
Property
Property and Assessments
  • Property Type: Residential,Single Family Residence
  • Property Type Label: Residential
Lot Information
  • Lot Features: Secluded, Level, Private, Wooded, Landscaped
  • Year Built: 1986
  • Lot Size Dimensions: 11 acres
  • New Construction: No
  • Above Grade Finished Area: 12565.0
  • Lot Size Acres: 11.0
  • Lot Size Area: 11.0
  • Lot Size Units: Acres
  • Lot Size Square Feet: 479160.0
Building Information
  • Living Area: 12565.0
Utilities
  • Water Source: Public
  • Utilities: Cable Available
Interior and Exterior Features
Exterior Features
  • Security Features: Security System
  • Window Features: Skylight(s)
  • Patio And Porch Features: Patio, Porch
  • Exterior Features: Gas Grill, Lighting
  • Laundry Features: Laundry Room, Main Level, Other
Interior Features
  • Interior Features: High Speed Internet, Jet Tub, Solid Surface Counters, Tray Ceiling(s), Vaulted Ceiling(s), Walk-In Closet(s), See Remarks, Built-in Features, Cathedral Ceiling(s), Ceramic Tile Bath, Eat-in Kitchen, Kitchen Island
  • Heating: Forced Air, Hot Water, Natural Gas, Radiant
  • Roof: Asphalt
  • Flooring: Ceramic Tile, Hardwood, Marble, Parquet
  • Basement: True
  • Construction Materials: Stone
  • Cooling: Central Air
  • Door Features: Atrium Door, French Doors
  • Cooling: Yes
  • Heating: Yes
  • Fireplace: Yes
  • Appliances: Dishwasher, Disposal, Double Oven, Freezer, Indoor Grill, Microwave, Range Hood, Refrigerator
  • Fireplace Features: Other, Basement, Bedroom, Family Room, Gas, Living Room, Wood Burning
  • Fireplaces Total: 6
  • Attic Features : Finished: Yes
  • Attic Features : Storage: Yes
  • Attic Features : Walk-Up: Yes
  • Dining Room Type : Formal Dining Room: Yes
Room Information
Room Information
  • Rooms Total: 12
  • Room Type: Primary Bedroom, Living Room, Dining Room, Kitchen, Family Room, Library, Office, Bedroom, Primary Bathroom, Full Bathroom, Half Bathroom
Bathrooms
  • Bathrooms Total Integer: 8
  • Bathrooms Total Decimal: 6.00
  • Bathrooms Total Notational: 4.40
  • Bedrooms Total: 9
  • Bathrooms Full: 4
  • Bathrooms Half: 4
Kitchen
  • Kitchen Features : Eat-in Kitchen: Yes
  • Kitchen Features : Gourmet Kitchen: Yes
  • Kitchen Features : Kitchen Island: Yes
  • Kitchen Features : Modern Kitchen: Yes
Room 1
  • RoomType: Primary Bedroom
  • RoomLevel: Second
Room 2
  • RoomType: Living Room
  • RoomLevel: First
Room 3
  • RoomType: Dining Room
  • RoomLevel: First
Room 4
  • RoomType: Kitchen
  • RoomLevel: First
Room 5
  • RoomType: Family Room
  • RoomLevel: First
Room 6
  • RoomType: Library
  • RoomLevel: First
Room 7
  • RoomType: Office
  • RoomLevel: Second
Room 8
  • RoomType: Bedroom
  • RoomLevel: Third
Room 9
  • RoomType: Primary Bathroom
  • RoomLevel: Second
Room 10
  • RoomType: Full Bathroom
  • RoomLevel: Second
Room 11
  • RoomType: Half Bathroom
  • RoomLevel: Second
Room 12
  • RoomType: Half Bathroom
  • RoomLevel: First
Unit Information
Unit 1
  • Unit Detail : Kitchen: True

Property History for 5520 State Farm Road

DateEvent & SourcePriceAppreciation
Dec 16, 2020

Sold

GLOBAL MLS #202010006

$1,420,000—
Nov 27, 2020

Pending

GLOBAL MLS #202010006

—
Dec 31, 2019

Listed (Active)

GLOBAL MLS #202010006

$1,699,000—
DateEvent & SourcePrice
12/16/2020

Sold

GLOBAL MLS #202010006

$1,420,000
11/27/2020

Pending

GLOBAL MLS #202010006

—
12/31/2019

Listed (Active)

GLOBAL MLS #202010006

$1,699,000

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 5520 State Farm Road

Taxable ValueLand$350,000Additions$1,200,000Total$1,550,000
Tax Record2026$43,522 ($3,627 / month)
Home Facts
Beds6Baths5.5Total Finished SqFt11,557 SqFtAbove Grade Finished SqFt11,557 SqFtStories2Lot Size352,836 SqFtStyleSingle Family ResidenceYear Built1986Year Renovated1986ZoningAGRCountyALBANYAPN013089 62.00-1-33

Schools near 5520 State Farm Road

This home is within Voorheesville Central School District.
Rating
School
Type
Grades
Distance
Public - K to 5
Public - 6 to 8
Public - 9 to 12
Rating
School
Distance
Voorheesville Elementary School
PublicK to 5

Voorheesville Middle School
Public6 to 8

Clayton A Bouton High School
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

New listings in 12186

$575,000 | 748 Dunbar Hollow Road, New Scotland, NY 12186
1/67

$575,000

5
Bedrooms
4
Bathrooms
2,400
Square Feet
4.8
Acres
$389,900 | 201 Deerfield Court, Voorheesville, NY 12186
1/38

$389,900

4
Bedrooms
2
Bathrooms
1,714
Square Feet
0.23
Acres
$999,900 | 248 Indian Ledge Road, New Scotland, NY 12186
1/105

$999,900

4
Bedrooms
4
Bathrooms
3,476
Square Feet
25
Acres
$260,000 | 151 Beaver Dam Road, New Scotland, NY 12186
1/38

$260,000

3
Bedrooms
1
Bathrooms
1,596
Square Feet
3.7
Acres
$425,000 | 304 New Salem Road, New Scotland, NY 12186
1/20
Contingent - Continue To Show

$425,000

4
Bedrooms
2
Bathrooms
2,370
Square Feet
10
Acres
$315,000 | 1 South Main Street, Voorheesville, NY 12186
1/59

$315,000

6
Bedrooms
4
Bathrooms
3,648
Square Feet
0.21
Acres
$400,000 | 42 Greystone Drive, Guilderland, NY 12186
1/35

$400,000

2
Bedrooms
3
Bathrooms
1,901
Square Feet
0.1
Acres
$799,000 | 8 Fairway Court, New Scotland, NY 12186
1/44

$799,000

4
Bedrooms
4
Bathrooms
2,585
Square Feet
1.23
Acres
$399,900 | 14 Wedgewood Lane, Guilderland, NY 12186
1/35
Contingent - Continue To Show

$399,900

2
Bedrooms
3
Bathrooms
1,901
Square Feet
0.09
Acres

Nearby home values

AddressSold priceBedsBathsSqftLot (Sqft)
This home: 5520 State Farm Road, Voorheesville, NY 12186
$1,420,000
9
12,565
479,160
$439,000
3
2,130
48,787
$65,500
–
–
–
39,204
–
–
–
–
48,352
–
2
1
1,140
69,696
$203,940
3
1,139
26,136

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Coldwell Banker Prime Prop.

©2026 Global Multiple Listing Service, Inc. The data relating to real estate on this website comes in part from the Internet Data Exchange program of the GMLS. All information is deemed reliable but not guaranteed and should be independently verified. All properties subject to prior sale, change, or withdrawal. Neither listing broker(s), GMLS shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless from any damages arising from reliance upon these data. IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties they may be interested in purchasing.