NEW CONSTRUCTION
For sale
$635,000
Est. $3,557/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
32% 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: a few seconds ago
•Source:Global MLS #202610778
Listing provided courtesy of Global Multiple Listing Service, Inc.
238 days on Redfin • 1,217 views • 30 favorites

Payment calculator

$3,557 per month

Principal and interest$3,422
Property taxes
HOA dues
Home insurance
Utilities
Down payment
20% ($127,000)
Home price
$635,000
Loan details
30-yr fixed, 7.13%
5 minutes to get started. No credit impact. 
Discover your buying power
Find out if this home is within budget
Down payment assistance

View down payment assistance programs for this home

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: Tuesday
Open houses
No upcoming open houses.

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
239 days
The average home goes pending in 8 days.
SALE-TO-LIST
103.9%
Most homes are selling 4% above list price.
LIST PRICE
$635,000
Median list price in this area is $355,304. (44% lower than this home)
PRICE DROP
0 price drops
20% 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
85
66
80
58
76
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

$631,925
$3,075 under list price of $635K
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $395K to $783K.

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

$49,000
Land— sq ft
11 Lenann, Altamont, NY 12009
Listing by Field Realty
$725,000
4 beds3.5 baths3,550 sq ft
450 State Route 146, Guilderlan, NY 12009
Listing by KW Platform
$265,000
3 beds2 baths1,409 sq ft
34 Hamilton St, Guilderland, NY 12084
Listing by Howard Hanna Capital Inc
$799,000
4 beds3.5 baths2,622 sq ft
302 Quidor Ct, Slingerlands, NY 12159
Listing by Miranda Real Estate Group Inc
$499,900
4 beds3 baths2,468 sq ft
25 Tice Rd, Albany, NY 12203
Listing by Howard Hanna Capital Inc
$354,900
3 beds2 baths1,560 sq ft
3 Hillview Ter, Guilderland, NY 12084
Listing by Whipple City Realty Group Inc

New listings for sale in 12084

NEW 25 HRS AGO
$345,000
3 beds1 bath1,350 sq ft
77 Willow St, Guilderland, NY 12084
Listing by Re Max Capital
Details provided by Global MLS and may not match the public record. Learn more.

More real estate resources

12054 homes for sale
12203 homes for sale
12205 homes for sale
12304 homes for sale
12309 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.