Last Sold Price
9 beds12,565 sqft$113/sqft
5520 State Farm Rd, Guilderland, NY 12186

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
LISTING CLOSED: 12/16/2020 12:00 AM

  1. Listed by Nancy Klopfer • Coldwell Banker Prime Prop.
    P: (518) 439-9600 kirsten.blanchard@coldwellbankerprime.com

Property Details for 5520 State Farm Road

Status
MLS #
202010006
Days on Market
332
Taxes
$45,708 / year
HOA Fees
-
Condo/Co-op Fees
-
Property Type
MLS Type
Residential / Single Family Residence
Year Built
1986
Lot Size
11.00 AC / 479,160 SF
Architectural Style
Mansion
Waterfront
No
Parking Total
20.00

Recent comparable sales

Median sold price

$955,000

Avg days on market

60

Sale-to-list ratio

96.6%

[Guilderland, NY]

9 comparable properties found

$1,700,000 | 333 Torquay Boulevard, Guilderland, NY 12203
1/2
1

$1,700,000

Sold 10/18/24

6
Bedrooms
7,800
Square Feet
1.01
Acres
$975,000 | 779 Waldens Pond Road, Guilderland, NY 12159
1/111
2

$975,000

Sold 08/21/25

5
Bedrooms
4,080
Square Feet
0.7
Acres
$995,000 | 815 Waldens Pond Road, Guilderland, NY 12203
1/68
3

$995,000

Sold 01/28/25

4
Bedrooms
3,437
Square Feet
0.65
Acres
$975,000 | 7 Nott Road, Guilderland, NY 12084
1/81
4

$975,000

Sold 12/16/25

3
Bedrooms
3,240
Square Feet
0.92
Acres
$955,000 | 709 Waldens Pond Road, Guilderland, NY 12203
1/50
5

$955,000

Sold 07/17/26

4
Bedrooms
3,183
Square Feet
0.74
Acres
$709,000 | 136 Wormer Road, Guilderland, NY 12186
1/46
6

$709,000

Sold 05/29/26

5
Bedrooms
3,300
Square Feet
2.3
Acres
$400,000 | 3 Wesley Place, Guilderland, NY 12186
1/54
7

$400,000

Sold 04/18/25

2
Bedrooms
1,481
Square Feet
0.06
Acres
$570,000 | 202 Wormer Road, Guilderland, NY 12186
1/64
8

$570,000

Sold 04/04/25

4
Bedrooms
2,942
Square Feet
0.54
Acres
$495,000 | 10 Dutch Hill Terrace, Guilderland, NY 12186
1/50
9

$495,000

Sold 01/31/25

3
Bedrooms
2,712
Square Feet
0.55
Acres

Location

Listing Courtesy of Coldwell Banker Prime Prop.

Sold By NON MLS OFFICE

Add your commute

Building Information for 5520 State Farm Road

Stories-Year Built1986Building Size-Lot Size11.00 AC / 479,160 SF

Payment Calculator

$11,027 per month

30 year fixed, 6.55% Interest

Principal and Interest

$7,218

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

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 Record2025$11,584 ($965 / 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

$399,000 | 11 Evergreen Drive, Voorheesville, NY 12186
1/46
Open: 8/16 11:00AM - 01:00PM

$399,000

Unavailable
Bedrooms
2
Bathrooms
1,508
Square Feet
0.22
Acres
$289,000 | 31 Pleasant Street, Voorheesville, NY 12186
1/48

$289,000

Unavailable
Bedrooms
2
Bathrooms
1,504
Square Feet
0.17
Acres
$410,000 | 42 Greystone Drive, Guilderland, NY 12186
1/35
Open: 8/16 11:00AM - 01:00PM

$410,000

Unavailable
Bedrooms
3
Bathrooms
1,901
Square Feet
0.1
Acres
$849,000 | 8 Fairway Court, New Scotland, NY 12186
1/41

$849,000

Unavailable
Bedrooms
4
Bathrooms
2,585
Square Feet
1.23
Acres
$412,000 | 14 Wedgewood Lane, Guilderland, NY 12186
1/35

$412,000

Unavailable
Bedrooms
3
Bathrooms
1,901
Square Feet
0.09
Acres
$670,000 | 16 Quail Run, Voorheesville, NY 12186
1/17

$670,000

Unavailable
Bedrooms
2
Bathrooms
1,794
Square Feet
0.19
Acres
$39,500 | 1 Prospect Street, Voorheesville, NY 12186
1/4

$39,500

Unavailable
Bedrooms
Unavailable
Bathrooms
Unavailable
Square Feet
0.18
Acres
$420,000 | 40 Voorheesville Avenue, Voorheesville, NY 12186
1/48

$420,000

4
Bedrooms
2,112
Square Feet
0.39
Acres

Nearby home values

AddressSold priceBedsBathsSqftLot (Sqft)
This home: 5520 State Farm Road, Guilderland, NY 12186
$1,420,000
9
12,565
479,160
$439,000
3
2,130
48,787
$65,500
39,204
4
2.5
2,537
60,984
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.