REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your advisor will contact you to discuss available opportunities.

In-PersonVirtual Tour

Mon

Jan

Tue

Jan

Wed

Jan

Listed by Jared A George • Tri Capital Realty LLC

$ 625,000

Est. payment -/mo

Save

New

5987 State Farm Road Guilderland, NY 12084

4 Beds

3 Baths

2,332 SqFt

UPDATED:

Key Details

Property Type Single Family Home

Sub Type Single Family Residence

Listing Status Active

Purchase Type For Sale

Square Footage 2,332 sqft

Price per Sqft $268

MLS Listing ID 202610778

Bedrooms 4

Full Baths 2

Half Baths 1

HOA Y/N No

Year Built 2026

Lot Size 0.740 Acres

Acres 0.74

Lot Dimensions 104' x 412'

Property Sub-Type Single Family Residence

Source Global MLS

Property Description

Welcome to this brand-new Colonial, to be completed late Summer 2026, offering refined craftsmanship and modern design in the award-winning Guilderland School District. This 4-bedroom, 2.5-bath home features 9-foot first-floor ceilings, an open-concept layout, and abundant natural light. Enjoy luxury vinyl flooring, quartz countertops throughout, a gas fireplace, first-floor den, walk-in pantry, mudroom, and convenient second-floor laundry. The spacious primary suite includes dual walk-in closets. Additional highlights include tiled baths, a covered front porch, landscaping package, public utilities, an open basement ready for future finishing, and a two-car garage. Situated on a private lot with ambiance on a .74-acre lot that offers over 400' of depth and a picturesque babbling brook. Broker/owner. Photos shown are from prior builds.

Location

State NY

County Albany

Direction State Farm Road (Route 155), near Nott Road.

Interior

Interior Features High Speed Internet, Walk-In Closet(s), Ceramic Tile Bath, Eat-in Kitchen, Kitchen Island

Heating Natural Gas

Flooring Vinyl, Carpet, Ceramic Tile

Fireplaces Number 1

Fireplaces Type Family Room

Fireplace Yes

Window Features Screens,Egress Window,ENERGY STAR Qualified Windows,Insulated Windows

Exterior

Exterior Feature Drive-Paved, Lighting

Parking Features Off Street, Paved, Attached, Driveway, Garage Door Opener

Garage Spaces 2.0

Utilities Available Cable Available, Underground Utilities

Waterfront Description Stream

Roof Type Asphalt

Porch Covered, Front Porch

Garage Yes

Building

Lot Description Secluded, Level, Private, Road Frontage, Wooded

Sewer Public Sewer

Water Public

Architectural Style Colonial

New Construction Yes

Schools

School District Guilderland

Others

Tax ID 51-2-5.85

Special Listing Condition Standard

Inglenook Realty, Inc.

Broker | License ID: 109931319

+1(518) 882-6236

GET MORE INFORMATION

Name

Email*

Phone*

Message

By creating an account, you acknowledge & agree that your activity on our site will be saved to your profile & accessible to Inglenook Realty, Inc. You consent to receive property alerts & marketing communications, including emails, text messages, phone calls, video updates, auto-dialed calls & text messages, and prerecorded videos/voice messages. You may opt-out at any time.

Homes For Sale Quick Search