A rare opportunity to own a truly custom, never-lived-in modern ranch, thoughtfully designed and masterfully built as a forever home. Completed in 2025, this sprawling residence blends timeless materials with high-performance systems, offering coveted single-level living on just over five acres in Westerlo's picturesque countryside, surrounded by open land and Catskill Mountain scenery.
Despite being newly constructed, the home carries a sense of warmth and permanence, feeling exceptionally quiet and filled with natural light. This modern farmhouse-inspired executive ranch balances open flow with intuitive, comfortable living.
Features include geothermal HVAC, commercial-grade mechanical systems, smart home functionality, wide-plank white oak flooring with natural pine trim and finishes, a gourmet kitchen, a custom stone fireplace, a walk-in butler's pantry, and a beautifully appointed formal laundry room with cabinetry. The primary suite is thoughtfully connected to an oversized walk-in closet with island. Four bedrooms (including a flexible office or guest space) and 2.5 baths complete the main level.
The full basement offers approximately 9-foot ceilings with dual access from the garage and rear patio, presenting exceptional potential for future finished living space. Additional highlights include a three-car attached garage with 13-foot ceilings, new well and septic, and nearly every major component of the home carrying a one-time transferable warranty, providing outstanding peace of mind.
Located approximately 30 minutes from downtown Albany and the New York State Thruway, under 40 minutes to Hunter Mountain, and about an hour to Saratoga Springs, this home offers both privacy and accessibility.
From its quiet strength and natural light to its thoughtful design and enduring materials, this home delivers a rare sense of comfort, permanence, and ease.
Active
$1,300,000
160 County Route 403, Westerlo, NY 12193
4beds
3,020sqft
Single Family Residence, Residential
Built in 2023
5.37 Acres Lot
$1,238,200 Zestimate®
$430/sqft
$-- HOA
What's special
Single-level livingCommercial-grade mechanical systemsModern farmhouse-inspired executive ranchSmart home functionalityGeothermal hvacCustom stone fireplaceGourmet kitchen
- 172 days |
- 315 |
- 8 |
Zillow last checked:
Listing updated:
Listed by:
Coldwell Banker Prime Properties 518-427-9000,
Amanda Penrose 518-760-1050
Source: Global MLS,MLS#: 202610652
Loading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- 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
Kitchen
- Level: First
Laundry
- Level: First
Living room
- Level: First
Office
- Level: First
Heating
- Fireplace Insert, Geothermal, Heat Pump
Cooling
- Geothermal
Appliances
- Included: Cooktop, Dishwasher, Electric Oven, Electric Water Heater, Microwave, Range, Range Hood, Refrigerator
- Laundry: Electric Dryer Hookup, Laundry Room, Washer Hookup
Features
- Ceiling Fan(s), Vaulted Ceiling(s), Walk-In Closet(s), Cathedral Ceiling(s), Ceramic Tile Bath, Eat-in Kitchen, Kitchen Island, Built-in Features
- Flooring: Other, Wood, Ceramic Tile, Laminate
- Doors: ENERGY STAR Qualified Doors, Sliding Doors
- Windows: Wood Frames, ENERGY STAR Qualified Windows
- Basement: Exterior Entry,Full,Interior Entry,Unfinished
- Number of fireplaces: 1
- Fireplace features: Insert
Interior area
- Total structure area: 3,020
- Total interior livable area: 3,020 sqft
- Finished area above ground: 3,020
- Finished area below ground: 0
Video & virtual tour
Property
Parking
- Total spaces: 20
- Parking features: Stone, Attached, Driveway, Garage Door Opener
- Garage spaces: 3
- Has uncovered spaces: Yes
Features
- Patio & porch: Rear Porch, Covered, Front Porch, Patio
- Exterior features: None
- Has spa: Yes
- Spa features: Bath
- Has view: Yes
- View description: Trees/Woods, Forest
Lot
- Size: 5.37 Acres
- Features: Wooded, Cleared
Details
- Parcel number: 175.144.1
- Zoning description: Rural
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Custom,Ranch
- Property subtype: Single Family Residence, Residential
Materials
- Fiber Cement
- Foundation: Concrete Perimeter
- Roof: Other,Metal
Condition
- New construction: No
- Year built: 2023
Utilities & green energy
- Sewer: Septic Tank
- Utilities for property: Underground Utilities
Green energy
- Energy efficient items: HVAC, Insulation, Water Heater
- Indoor air quality: Moisture Control, Ventilation
Community & HOA
Community
- Security: Smoke Detector(s), Security System, Security System Owned, Carbon Monoxide Detector(s)
HOA
- Has HOA: No
Location
- Region: Westerlo
Financial & listing details
- Price per square foot: $430/sqft
- Annual tax amount: $7,330
- Date on market: 1/15/2026
Estimated market value
$1,238,200
$1.18M - $1.30M
$4,040/mo
Price history
| Date | Event | Price |
|---|---|---|
| 1/15/2026 | Listed for sale | $1,300,000$430/sqft |
Source:  Global MLS #202610652 Report a problem | ||
Public tax history
Tax history is unavailable.
Monthly payment
Estimated monthly payment$1,822
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 12193
Nearby schools
GreatSchools rating
- 6/10Scott M Ellis Elementary SchoolGrades: PK-5Distance: 2 mi
- 3/10Greenville Middle SchoolGrades: 6-8Distance: 1.8 mi
- 5/10Greenville High SchoolGrades: 9-12Distance: 1.8 mi
A local agent can set up tours, give advice and negotiate with sellers.
- New York
- Albany County
- Greenville
- 12193
- 160 County Route 403
Nearby cities
Nearby zip codes
Other Greenville Topics
