Brand New Colonial-November 2025 completion. Featuring 4 bedrooms, 2.5 baths & 9' ceilings on first floor. Located in the award-winning Guilderland schools, it boasts a first-floor den, luxury vinyl flooring, quartz countertops in the kitchen & baths, a gas fireplace, large walk-in pantry, mudroom, second-floor laundry, and spacious bedrooms with dual walk-in closets and tray ceiling in the main bedroom. The tiled baths, covered front porch, landscaping package, public utilities, two-car side load garage, and an open basement ready to finish. The open-concept design offers ample storage and a spacious ambiance on a 1.2 acre lot that offers over 400' of rear yard and a picturesque babbling brook. Broker/owner. Images from previous builds, artistic renderings & 29 Sylvan Ave Delmar.
Closed
$600,000
5995 State Farm Road, Guilderland, NY 12084
4beds
2,332sqft
Single Family Residence, Residential
Built in 2025
1.2 Acres Lot
$604,400 Zestimate®
$257/sqft
$3,303 Estimated rent
Home value
$604,400
$568,000 - $647,000
$3,303/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$3,303/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
Learn more$3,303/mo
Rent Zestimate®
Refinance and save
$3,974/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
See today's rates$3,974/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked: 7 hours ago
Listing updated: January 12, 2026 at 08:45am
Listed by:
Jared A George 518-858-2637,
Tri Capital Realty LLC
Bought with:
Jared A George, 10491201246
Tri Capital Realty LLC
Source: Global MLS,MLS#: 202523719
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Bedroom
- Level: Second
Bedroom
- Level: Second
Bedroom
- Level: Second
Primary bathroom
- Level: Second
Half bathroom
- Level: First
Full bathroom
- Level: Second
Den
- Level: First
Foyer
- Level: First
Great room
- Level: First
Kitchen
- Level: First
Laundry
- Level: Second
Heating
- Forced Air, Natural Gas
Cooling
- Central Air
Appliances
- Included: Dishwasher, Electric Water Heater, Microwave, Range
- Laundry: Laundry Closet, Laundry Room, Upper Level
Features
- High Speed Internet, Tray Ceiling(s), Walk-In Closet(s), Ceramic Tile Bath, Eat-in Kitchen, Kitchen Island
- Flooring: Tile, Vinyl, Carpet
- Doors: Sliding Doors
- Windows: Screens, Double Pane Windows, Egress Window, ENERGY STAR Qualified Windows, Insulated Windows
- Basement: Exterior Entry,Full,Interior Entry,Sump Pump
- Number of fireplaces: 1
- Fireplace features: Family Room, Gas
Interior area
- Total structure area: 2,332
- Total interior livable area: 2,332 sqft
- Finished area above ground: 2,332
- Finished area below ground: 0
Property
Parking
- Total spaces: 8
- Parking features: Off Street, Paved, Attached, Driveway, Garage Door Opener
- Garage spaces: 2
- Has uncovered spaces: Yes
Features
- Patio & porch: Covered, Front Porch
- Exterior features: Lighting
- Has view: Yes
- View description: Creek/Stream, Forest
- Has water view: Yes
- Water view: Creek/Stream
- Waterfront features: Creek
Lot
- Size: 1.20 Acres
- Features: Other, Level, Meadow, Private, Wooded
Details
- Parcel number: 51.0025.83
- Special conditions: Other
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence, Residential
Materials
- Other, Drywall, Vinyl Siding
- Foundation: Concrete Perimeter
- Roof: Asphalt
Condition
- New construction: Yes
- Year built: 2025
Utilities & green energy
- Electric: Underground
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Available, Underground Utilities
Community & neighborhood
Security
- Security features: Smoke Detector(s), Carbon Monoxide Detector(s), Fire Alarm
Location
- Region: Guilderland
Other
Other facts
- Listing terms: Other
Price history
| Date | Event | Price |
|---|---|---|
| 12/22/2025 | Sold | $600,000-6.2%$257/sqft |
Source:  Global MLS #202523719 Report a problem | ||
| 10/2/2025 | Pending sale | $639,900$274/sqft |
Source: Global MLS #202523719 Report a problem | ||
| 8/13/2025 | Listed for sale | $639,900+0.1%$274/sqft |
Source: Global MLS #202523719 Report a problem | ||
| 6/2/2025 | Listing removed | $639,000$274/sqft |
Source: Global MLS #202515330 Report a problem | ||
| 4/16/2025 | Listed for sale | $639,000$274/sqft |
Source: Global MLS #202515330 Report a problem | ||
Public tax history
Tax history is unavailable.
Neighborhood: 12084
Nearby schools
GreatSchools rating
- 6/10Guilderland Elementary SchoolGrades: K-5Distance: 0.9 mi
- 6/10Farnsworth Middle SchoolGrades: 6-8Distance: 0.3 mi
- 9/10Guilderland High SchoolGrades: 9-12Distance: 3.4 mi
Schools provided by the listing agent
- High: Guilderland
Source: Global MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- New York
- Albany County
- Guilderland
- 12084
- 5995 State Farm Road