NEW CONSTRUCTION
For sale
$635,000
Est. $3,600/mo —
4
bd
•
2.5 ba
•
2,332
sq ft

5987 State Farm Rd, Guilderland, NY 12084

map-entry
Home in motion
Guilderland is a hot market
38% of homes accept an offer within a week. Tour it before it's gone!

About this home

Single-familyProperty Type
0.74 acresLot Size
$272Price/Sq.Ft.
2 garage spacesParking
Listing by Jared George • Tri Capital Realty LLC
•518-858-2637 (agent)
Listing updated:
Redfin checked: 2 minutes ago
•Source:Global MLS #202610778
Listing provided courtesy of Global Multiple Listing Service, Inc.
285 days on Redfin • 1,264 views • 31 favorites

Payment calculator

$3,600 per month

Principal and interest$3,465
Property taxes
HOA dues
Home insurance
Utilities
Down payment
20% ($127,000)
Home price
$635,000
Loan details
30-yr fixed, 7.25%
5 minutes to get started. No credit impact. 

See this home in person

We'll connect you with a local agent to show you this home, answer your questions, and assist you on your buying journey.
Next available tour time: Sunday
Open houses
No upcoming open houses.

Interested in buying?

Make a winning offer with the help of a local agent

Around this home

Schools

Guilderland Elementary School

Public K-5 • Assigned • 0.9mi

7/10
Farnsworth Middle School

Public 6-8 • Assigned • 0.3mi

7/10
Guilderland High School

Public 9-12 • Assigned • 3.3mi

8/10
Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Market insights

5987 State Farm Rd · $635,000
DAYS ON MARKET
286 days
The average home goes pending in 11 days.
SALE-TO-LIST
101.7%
Most homes are selling 2% above list price.
LIST PRICE
$635,000
Median list price in this area is $359,450. (43% lower than this home)
PRICE DROP
0 price drops
22% of homes in this area have had a price drop in the past month.

Property details

Kitchen

Kitchen

Bathroom

Bathroom

Bedroom

Bedroom

Living

Living

  • Interior features
  • High-speed internet available
  • Walk-in closets
  • Ceramic tile baths
  • Sliding doors
  • ENERGY STAR qualified and insulated windows with screens
  • Egress window
  • Bedrooms
  • Primary bedroom (second level)
  • Additional bedrooms (second level)
  • Bathrooms
  • Two full bathrooms (second level)
  • One half bathroom (first level)
  • Kitchen
  • Dishwasher
  • Range
  • Microwave
  • Electric water heater
  • Laundry & utility
  • Laundry room (upper level)
  • Washer hookup
  • Electric dryer hookup
  • Flooring
  • Vinyl
  • Carpet
  • Ceramic tile
  • Heating & cooling
  • Natural gas heating
  • Central air conditioning
  • Has heating and cooling

Sale and tax history for 5987 State Farm Rd

Public record

Beds
—
Baths
—
Stories
—
Lot width
560 ft.
Lot depth
—
Lot size
0.74 Acres
Year renovated
—
Finished Sq. Ft.
—
Unfinished Sq. Ft.
—
Total Sq. Ft.
—
Year built
—
Style
Vacant Land
County
Albany County
APN
013089A05100000020050850000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 14, 2026.

Climate risks

3/10 Flood Factor

Estimated 10-14% chance 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, 16 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

Guilderland, NY • 12084
Average low and high temperatures (°F)
30
17
33
17
50
29
60
39
68
49
80
59
84
65
80
58
75
53
64
43
49
33
35
21
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec

Sun exposure

97/ 100

Exceptional sunlight

Sunscore

This home ranks in the top 20% for direct sun exposure in Guilderland. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.

9.7 hrs
6.1 hrs
JuneDecember
Provided by Shadowmap

Redfin Estimate for 5987 State Farm Rd

$636,398
$1,398 over list price of $635K
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $435K to $660K.

More resources

Rental earnings

Est. $3,209 per month, based on comparable rentals

Tour for free, no strings attached

Instant answers, or connect with a local agent

Nearby similar homes

OPEN SUN, 11AM TO 1PM
$379,000
3 beds2 baths2,240 sq ft
5873 Veeder Rd, Slingerlands, NY 12159
Three season room • Full basement • Enclosed breezeway
Listing by Howard Hanna Capital Inc
$899,000
5 beds4 baths4,106 sq ft
3275 E Lydius St, Schenectady, NY 12303
Manicured lawns • Entertainment lounge • Custom cabinetry
Listing by Howard Hanna Capital Inc
OPEN SUN, 1PM TO 3PM
$775,000
4 beds4 baths3,046 sq ft
827 Creek Ct, Slingerlands, NY 12159
Private cul-de-sac • Expansive deck • Walk in closet
Listing by Gabler Realty LLC
$379,900
4 beds2 baths1,850 sq ft
618 Via Ponderosa, Schenectady, NY 12303
Three season room • 0.4 acre lot • Garage
Listing by Howard Hanna Capital Inc
$369,000
3 beds1 bath1,584 sq ft
6311 Frenchs Hollow Rd, Altamont, NY 12009
1.3 acres • Sunroom • Completely remodeled
Listing by Crystal Coleman Realty LLC
3D WALKTHROUGH
$820,000
4 beds3.5 baths3,403 sq ft
219 Forest Haven Dr, Slingerlands, NY 12159
Custom built homes • High ceilings • Skylights
Listing by McSharry and Associates Realty LLC

New listings for sale in 12084

$500,000
3 beds2 baths1,938 sq ft
6 Pine Ridge Dr, Guilderland, NY 12084
Hardwood floors • Oversized fireplace • Exposed wooden beams
Listing by Miuccio Real Estate Group
$490,000
4 beds2.5 baths1,926 sq ft
8 Bonnie Dr, Guilderland, NY 12084
Hardwood floors • Updated kitchen • Finished basement
Listing by KW Platform
Details provided by Global MLS and may not match the public record. Learn more.

More real estate resources

Mont Pleasant homes for sale
Woodlawn homes for sale
Bellevue homes for sale
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

Download the Redfin App on the Apple App Store
Download the Redfin App from the Google Play Store

About us

Why Redfin?
Community Impact
Inclusion
Culture
Press
Investors
Blog
Real Estate News

Find us

Contact Us
Help Center
Advertise

Subsidiaries

Rent.
ApartmentGuide

Affiliated Business

Rocket Close
Rocket Mortgage

Countries

US flagUnited States

Canadian flagCanada

Copyright: © 2026 Redfin. All rights reserved.

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.