5520 State Farm Road
Description
- Listed by: Nancy Klopfer 518.439.9600 kirsten.blanchard@coldwellbankerprime.com • Coldwell Banker Prime Prop.
Recent comparable sales
Median sold price
$955,000
Avg days on market
59
Sale-to-list ratio
97.3%
Guilderland, NY
9 comparable properties found
$1,700,000
Sold 10/18/24
- 6
- Bedrooms
- 7
- Bathrooms
- 7,800
- Square Feet
- 1.01
- Acres
$975,000
Sold 08/21/25
- 5
- Bedrooms
- 6
- Bathrooms
- 4,080
- Square Feet
- 0.7
- Acres
$995,000
Sold 01/28/25
- 4
- Bedrooms
- 3
- Bathrooms
- 3,437
- Square Feet
- 0.65
- Acres
$900,000
Sold 08/14/26
- 4
- Bedrooms
- 4
- Bathrooms
- 2,906
- Square Feet
- 0.49
- Acres
$955,000
Sold 07/17/26
- 4
- Bedrooms
- 4
- Bathrooms
- 3,183
- Square Feet
- 0.74
- Acres
$709,000
Sold 05/29/26
- 5
- Bedrooms
- 3
- Bathrooms
- 3,300
- Square Feet
- 2.3
- Acres
$400,000
Sold 04/18/25
- 2
- Bedrooms
- 3
- Bathrooms
- 1,481
- Square Feet
- 0.06
- Acres
$570,000
Sold 04/04/25
- 4
- Bedrooms
- 4
- Bathrooms
- 2,942
- Square Feet
- 0.54
- Acres
Location
Sold By NON MLS OFFICE
Payment Calculator
$11,027 per month
30 year fixed, 6.55% Interest
$7,218
$3,809
$0
Know your buying power with a preapproval and custom rate in minutes
1Property Information for 5520 State Farm Road
- Taxes: $45,708 / year
- MLS Type: Residential / Single Family Residence
- County: Albany County
- Architectural Style: Mansion
- Waterfront: No
- Parking Total: 20.00
- Year Built: 1986
- Lot Size: 11.00 AC / 479,160 SF
- 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
- 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
- GarageSpaces: 7.00
- Attached Garage: Yes
- Parking Features: Off Street, Attached, Circular Driveway
- School District: Voorheesville
- Property Type: Residential,Single Family Residence
- Property Type Label: Residential
- 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
- Living Area: 12565.0
- Water Source: Public
- Utilities: Cable Available
- 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: 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
- Rooms Total: 12
- Room Type: Primary Bedroom, Living Room, Dining Room, Kitchen, Family Room, Library, Office, Bedroom, Primary Bathroom, Full Bathroom, Half Bathroom
- Bathrooms Total Integer: 8
- Bathrooms Total Decimal: 6.00
- Bathrooms Total Notational: 4.40
- Bedrooms Total: 9
- Bathrooms Full: 4
- Bathrooms Half: 4
- Kitchen Features : Eat-in Kitchen: Yes
- Kitchen Features : Gourmet Kitchen: Yes
- Kitchen Features : Kitchen Island: Yes
- Kitchen Features : Modern Kitchen: Yes
- RoomType: Primary Bedroom
- RoomLevel: Second
- RoomType: Living Room
- RoomLevel: First
- RoomType: Dining Room
- RoomLevel: First
- RoomType: Kitchen
- RoomLevel: First
- RoomType: Family Room
- RoomLevel: First
- RoomType: Library
- RoomLevel: First
- RoomType: Office
- RoomLevel: Second
- RoomType: Bedroom
- RoomLevel: Third
- RoomType: Primary Bathroom
- RoomLevel: Second
- RoomType: Full Bathroom
- RoomLevel: Second
- RoomType: Half Bathroom
- RoomLevel: Second
- RoomType: Half Bathroom
- RoomLevel: First
- Unit Detail : Kitchen: True
Property History for 5520 State Farm Road
| Date | Event & Source | Price | Appreciation |
|---|---|---|---|
| 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 | — |
| Mar 30, 2005 | Sold GLOBAL MLS #24113217 | $1,350,000 | — |
| Mar 29, 2005 | Sold (Public Record) Public Record #236684242 | $1,350,000 | — |
| Feb 2, 2005 | Pending GLOBAL MLS #24113217 | — | |
| Aug 8, 2004 | Listed (Active) GLOBAL MLS #24113217 | $1,750,000 | — |
| Date | Event & Source | Price |
|---|---|---|
| 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 |
| 03/30/2005 | Sold GLOBAL MLS #24113217 | $1,350,000 |
| 03/29/2005 | Sold (Public Record) Public Record #236684242 | $1,350,000 |
| 02/02/2005 | Pending GLOBAL MLS #24113217 | — |
| 08/08/2004 | Listed (Active) GLOBAL MLS #24113217 | $1,750,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
Schools near 5520 State Farm Road
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
$39,500
- Unavailable
- Bedrooms
- Unavailable
- Bathrooms
- Unavailable
- Square Feet
- 0.18
- Acres
$420,000
- 4
- Bedrooms
- 2
- Bathrooms
- 2,112
- Square Feet
- 0.39
- Acres
Nearby home values
| Address | Sold price | Beds | Baths | Sqft | Lot (Sqft) |
|---|---|---|---|---|---|
This home: 5520 State Farm Road, Guilderland, NY 12186 | $1,420,000 | 9 | 8 | 12,565 | 479,160 |
$439,000 | 3 | 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 | 2 | 1,139 | 26,136 | |
– | – | – | – | 48,352 | |
– | – | – | – | 47,916 | |
$235,900 | 2 | 3 | 1,566 | 3,513 | |
$95,000 | 4 | 2 | 1,700 | 40,300 | |
$195,000 | 3 | 3 | – | – | |
– | 3 | 1 | 882 | 36,815 | |
$166,905 | 2 | 4 | – | – | |
$166,300 | 2 | – | – | – | |
$169,900 | 2 | 3 | – | – | |
$140,000 | 3 | 3 | 3,291 | 47,916 |
Explore Nearby Homes
- Knox Homes for Sale
- New Scotland Homes for Sale
- Westmere Homes for Sale
- Dunes Homes for Sale
- Normanskill Homes for Sale
- Campus Area Homes for Sale
- Colonie Village Homes for Sale
- Eagle Hill Homes for Sale
- Rotterdam Center Homes for Sale
- Roessleville Homes for Sale
- Buckingham Lake-Crestwood Homes for Sale
- Woodlawn Homes for Sale
- Princetown Homes for Sale
- Elsmere Homes for Sale
- Upper Washington Avenue Homes for Sale
- Westerlo Homes for Sale
- Voorheesville Homes for Sale
- Guilderland Homes for Sale
- Clarksville Homes for Sale
- Berne Homes for Sale
- Coeymans Homes for Sale
- Slingerlands Homes for Sale
- East Berne Homes for Sale
- Altamont Homes for Sale
- Guilderland Center Homes for Sale
- Bethlehem Homes for Sale
- Albany Homes for Sale
- Delmar Homes for Sale
- Feura Bush Homes for Sale
- Colonie Homes for Sale
- 12193 Homes for Sale
- 12009 Homes for Sale
- 12041 Homes for Sale
- 12054 Homes for Sale
- 12059 Homes for Sale
- 12067 Homes for Sale
- 12084 Homes for Sale
- 12159 Homes for Sale
- 12203 Homes for Sale
- 12303 Homes for Sale
- 12085 Homes for Sale
- 12046 Homes for Sale
- 12007 Homes for Sale
- 12306 Homes for Sale
- 12158 Homes for Sale
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.
