A very special home hits the market - this stunning Weber-built Executive Ranch is ideally located at the end of a cul-de-sac in Briarhill, one of Delmar's loveliest neighborhoods. With over 3000 sq. ft., the fabulous floor plan has it all w/ formal living & dining rooms, an expansive eat-in kitchen open to family room, sunroom and huge laundry/mud room. The Bedroom Wing offers a Jack & Jill bath btwn 2 BRs, a guest powder room & a true Primary Suite w/ walk-in closet, generous bath & attached sitting room/office. The many highlights of this home include 9ft. vaulted ceilings, gorgeous arched and transom windows, h/w floors & beautiful b/in bookcases. The house sits on a generous 2-acre lot w/ a fantastic backyard, decking, patio & salt water pool.
Closed
$825,000
30 Haswell Greene Road, Delmar, NY 12054
3beds
3,004sqft
Single Family Residence, Residential
Built in 1990
2.1 Acres Lot
$835,600 Zestimate®
$275/sqft
$3,851 Estimated rent
Home value
$835,600
$744,000 - $944,000
$3,851/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: June 27, 2025 at 06:16am
Listed by:
Cathy B Griffin 518-331-1412,
KW Platform
Bought with:
John A Mainello, 40MA1036191
Heer Realty, Inc.
Source: Global MLS,MLS#: 202517431
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Level: First
Bedroom
- Level: First
Bedroom
- Level: First
Primary bathroom
- Level: First
Half bathroom
- Level: First
Full bathroom
- Level: First
Dining room
- Level: First
Family room
- Level: First
Kitchen
- Level: First
Living room
- Level: First
Mud room
- Level: First
Office
- Level: First
Sun room
- Level: First
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Dishwasher, Gas Water Heater, Microwave, Oven, Refrigerator, Washer/Dryer
- Laundry: Laundry Room, Main Level
Features
- High Speed Internet, Ceiling Fan(s), Solid Surface Counters, Vaulted Ceiling(s), Walk-In Closet(s), Built-in Features, Ceramic Tile Bath, Chair Rail, Crown Molding, Eat-in Kitchen, Kitchen Island
- Flooring: Tile, Hardwood
- Doors: Atrium Door, French Doors, Sliding Doors
- Windows: Screens, Window Coverings, Blinds
- Basement: Full
- Number of fireplaces: 1
- Fireplace features: Family Room, Gas
Interior area
- Total structure area: 3,004
- Total interior livable area: 3,004 sqft
- Finished area above ground: 3,004
- Finished area below ground: 0
Property
Parking
- Total spaces: 4
- Parking features: Off Street, Paved, Attached, Driveway, Garage Door Opener
- Garage spaces: 2
- Has uncovered spaces: Yes
Features
- Patio & porch: Deck, Patio
- Exterior features: Other, Lighting
- Pool features: In Ground, Outdoor Pool, Salt Water
- Has spa: Yes
- Spa features: Bath
- Fencing: Wrought Iron,Chain Link,Fenced
Lot
- Size: 2.10 Acres
- Features: Level, Sprinklers In Front, Cul-De-Sac, Landscaped
Details
- Parcel number: 012200 97.09413
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence, Residential
Materials
- Cedar
- Roof: Shingle,Asphalt
Condition
- New construction: No
- Year built: 1990
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Available
Community & neighborhood
Location
- Region: Delmar
Price history
| Date | Event | Price |
|---|---|---|
| 6/25/2025 | Sold | $825,000+10%$275/sqft |
Source:  Global MLS #202517431 Report a problem | ||
| 5/20/2025 | Pending sale | $750,000$250/sqft |
Source: Global MLS #202517431 Report a problem | ||
| 5/15/2025 | Listed for sale | $750,000$250/sqft |
Source: Global MLS #202517431 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | -- | $529,000 |
| 2023 | -- | $529,000 |
| 2022 | -- | $529,000 |
Find assessor info on the county website
Neighborhood: 12054
Nearby schools
GreatSchools rating
- 7/10Eagle Elementary SchoolGrades: K-5Distance: 2 mi
- 7/10Bethlehem Central Middle SchoolGrades: 6-8Distance: 1.3 mi
- 10/10Bethlehem Central Senior High SchoolGrades: 9-12Distance: 1.9 mi
Schools provided by the listing agent
- Elementary: Eagle
- High: Bethlehem Central
Source: Global MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.