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
$620,100 Zestimate®
$257/sqft
$2,959 Estimated rent
Home value
$620,100
$589,000 - $651,000
$2,959/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: 23 hours ago
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.