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.
Pending
$639,900
5995 State Farm Road, Guilderland, NY 12084
4beds
2,332sqft
Single Family Residence, Residential
Built in ----
1.2 Acres Lot
$617,200 Zestimate®
$274/sqft
$-- HOA
What's special
Gas fireplaceCovered front porchSecond-floor laundryOpen-concept designLandscaping packageTwo-car side load garageFirst-floor den
- 136 days |
- 40 |
- 0 |
Zillow last checked: 8 hours ago
Listing updated: October 02, 2025 at 09:05am
Listing by:
Tri Capital Realty LLC 518-858-2637,
Jared A George 518-858-2637
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.2 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
Utilities & green energy
- Electric: Underground
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Available, Underground Utilities
Community & HOA
Community
- Security: Smoke Detector(s), Carbon Monoxide Detector(s), Fire Alarm
HOA
- Has HOA: No
Location
- Region: Guilderland
Financial & listing details
- Price per square foot: $274/sqft
- Date on market: 8/13/2025
- Listing terms: Other
Estimated market value
$617,200
$586,000 - $648,000
$2,950/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 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
Public tax history
Tax history is unavailable.BuyAbility℠ payment
Estimated monthly payment
Boost your down payment with 6% savings match
Earn up to a 6% match & get a competitive APY with a *. Zillow has partnered with to help get you home faster.
Learn more*Terms apply. Match provided by Foyer. Account offered by Pacific West Bank, Member FDIC.Climate risks
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.
- Loading
