$1,299,000
Niskayuna, NY 12309
MLS# 202622935
4 beds | 5 baths

1 / 81
Property Description
Designed and built by renowned builder Peter Sotile, this one-of-a-kind custom contemporary offers nearly 6,000 square feet of thoughtfully designed living space, which includes an exceptional finished lower level. Expansive windows (126 of them!) and skylights fill the home with natural light while bringing the beauty and serenity of the surrounding landscape indoors. The private primary suite is tucked away on its own wing and features two unique balconies--one overlooking the dramatic sunken living room and another accessed through sliding glass doors, where you can enjoy peaceful treetop views of the surrounding forest. A separate bedroom wing offers outstanding flexibility, featuring a shared living area, three spacious bedrooms, and two full bathrooms--ideal for family, guests, or multigenerational living. The oversized second-floor loft overlooks the grand foyer, family room, and kitchen, creating an open and airy atmosphere. The inviting library is introduced through beautifully etched double doors, while the formal dining room showcases elegant inlaid hardwood flooring and sliding glass doors leading to a screened porch. Recent updates provide peace of mind and modern comfort, including two approximately five-year-old heating and air conditioning systems, a newer roof, and an on-demand hot water system. The expansive finished lower level features an oversized recreation room perfect for entertaining, game nights, celebrations, or hosting large gatherings. This exceptional Baldwin Farms residence combines distinctive architecture, generous living spaces, and a tranquil natural setting to create a truly remarkable place to call home. All in the award winning Niskayuna School District!
Details
Maps
Documents
Contract Information
Original List Price: 1299000
List Price/SqFt: 257.94
List Price/Acres: 534567.9
Status: Active
Current Price: $1,299,000
List Price: $1,299,000
Listing Contract Date: 2026-07-30
Property Sub Type: Single Family Residence
Location
Postal Code +4: 1323
City/Town (Mail): Niskayuna
Cross Street: River Road
Street Number: 37
Street Name: Covington
Street Suffix: Court
County: Schenectady
State/Province: NY
Postal Code: 12309
Subdivision: Baldwin Farms
Geo Lat: 42.800356
Geo Lon: -73.851878
Property Detail
Rooms Total: 15
Bathrooms Half: 1
Garage Spaces: 3
Above Grade Finished Area: 5036
Above Grade Finished Area Source: CRS
Parking Y/N: Yes
Below Grade Finished Area: 1000
Below Grade Finished Area Source: Plans
Living Area: 5036
Total Finished Area: 6036
Fireplaces Total: 2
Lot Size Dimensions: 61 x 417 x 49 x 310 x 520
Lot Size Acres: 2.43
Main Road Frontage: 61
Waterfront Y/N: No
Enhanced Accessible Y/N: No
Bedrooms Total: 4
Bathrooms Full: 4
Bathrooms Total: 5
Year Built: 1992
Parcel, Tax, HOA
New Construction Y/N: No
Parcel Number: 422400 51.10-1-11
Tax Annual Amount: 23504.79
Tax Section: 51.10
Total Taxes Description: Actual
Tax Block: 1
Tax Lot: 11.000
Tax Section See Remarks: No
School District: Niskayuna
High School: Niskayuna
Association Y/N: No
Directions & Remarks
Directions: From Rosendale Rd. or Balltown Road to River Road. Off River Road near Niskayuna family park.
Public Remarks: Designed and built by renowned builder Peter Sotile, this one-of-a-kind custom contemporary offers nearly 6,000 square feet of thoughtfully designed living space, which includes an exceptional finished lower level. Expansive windows (126 of them!) and skylights fill the home with natural light while bringing the beauty and serenity of the surrounding landscape indoors.
The private primary suite is tucked away on its own wing and features two unique balconies--one overlooking the dramatic sunken living room and another accessed through sliding glass doors, where you can enjoy peaceful treetop views of the surrounding forest.
A separate bedroom wing offers outstanding flexibility, featuring a shared living area, three spacious bedrooms, and two full bathrooms--ideal for family, guests, or multigenerational living.
The oversized second-floor loft overlooks the grand foyer, family room, and kitchen, creating an open and airy atmosphere. The inviting library is introduced through beautifully etched double doors, while the formal dining room showcases elegant inlaid hardwood flooring and sliding glass doors leading to a screened porch.
Recent updates provide peace of mind and modern comfort, including two approximately five-year-old heating and air conditioning systems, a newer roof, and an on-demand hot water system.
The expansive finished lower level features an oversized recreation room perfect for entertaining, game nights, celebrations, or hosting large gatherings. This exceptional Baldwin Farms residence combines distinctive architecture, generous living spaces, and a tranquil natural setting to create a truly remarkable place to call home. All in the award winning Niskayuna School District!
Sewer
Public Sewer: 1
Appliances
Built-In Electric Oven: 1
Dishwasher: 1
Disposal: 1
Dryer: 1
Electric Oven: 1
Gas Cooktop: 1
Microwave: 1
Refrigerator: 1
Tankless Water Heater: 1
Washer: 1
Architectural Style
Contemporary: 1
Custom: 1
Electric
200+ Amp Service: 1
Financial Details
General Taxes: 7953.48
General Taxes Description: Actual
School Taxes: 15551.31
School Taxes Description: Actual
Attic Features
Hatch: 1
Cooling
Central Air: 1
Basement
Finished: 1
Full: 1
Interior Entry: 1
Other: 1
Bath Levels
Full Bath 1: 2nd
Full Bath 2: 2nd
Full Bath 3: 2nd
Full Bath 4: Basement
Half Bath 1: 1st
Dining Room Type
Formal Dining Room: 1
Lot Features
Cul-De-Sac: 1
Secluded: 1
Wooded: 1
Construction Materials
Brick: 1
Cedar: 1
Door Features
Sliding Doors: 1
Photos - the contractual owner of the photos
Photo Owner: Combination Ownership
Possession
At Closing: 1
Exterior Features
Lighting: 1
Fireplace Features
Family Room: 1
Gas: 1
Living Room: 1
Wood Burning: 1
Flooring
Carpet: 1
Ceramic Tile: 1
Hardwood: 1
Marble: 1
Parquet: 1
Showing Requirements
Agent to Accompany: 1
Occupied: 1
Special Listing Conditions
Standard: 1
Roof
Asphalt: 1
Water Source
Public: 1
Heating
Forced Air: 1
Natural Gas: 1
Interior Features
Built-in Features: 1
Central Vacuum: 1
Ceramic Tile Bath: 1
Grinder Pump: 1
High Speed Internet: 1
Jet Tub: 1
Open Floorplan: 1
Paddle Fan: 1
Stone Countertops: 1
Vaulted Ceiling(s): 1
Walk-In Closet(s): 1
Wet Bar: 1
Kitchen Features
Built-in Features: 1
Eat-in Kitchen: 1
Kitchen Island: 1
Prep Sink: 1
Laundry Features
Laundry Room: 1
Main Level: 1
Other Equipment
Grinder Pump: 1
Parking Features
Parking Total: 15
Attached: 1
Driveway: 1
Garage: 1
Off Street: 1
Patio And Porch Features
Deck: 1
Enclosed: 1
Screened: 1
Levels
Two: 1
Security Features
Carbon Monoxide Detector(s): 1
Security System Owned: 1
Smoke Detector(s): 1
Rooms
Primary Bath: 1
Primary Bath Level: Second
Full Bathroom: 1
Full Bathroom Level: Second
Half Bathroom: 1
Half Bathroom Level: First
Foyer: 1
Foyer Level: First
Bedroom: 1
Bedroom Level: Second
Other Room: 1
Other Room Level: First
Dining Room: 1
Dining Room Level: First
Family Room: 1
Family Room Level: First
Kitchen: 1
Kitchen Level: First
Living Room: 1
Living Room Level: First
Laundry Room: 1
Laundry Room Level: First
Library: 1
Library Level: First
Loft: 1
Loft Level: Second
Window Features
Double Pane Windows: 1
Skylight(s): 1
Status Change Info
Status Change Date: 2026-07-30
Property Features
Appliances: Built-In Electric Oven; Dishwasher; Disposal; Dryer; Electric Oven; Gas Cooktop; Microwave; Refrigerator; Tankless Water Heater; Washer
Architectural Style: Contemporary; Custom
Attic Features: Hatch
Basement: Finished; Full; Interior Entry; Other
Construction Materials: Brick; Cedar
Cooling: Central Air
Dining Room Type: Formal Dining Room
Door Features: Sliding Doors
Electric: 200+ Amp Service
Exterior Features: Lighting
Fireplace Features: Family Room; Gas; Living Room; Wood Burning
Flooring: Carpet; Ceramic Tile; Hardwood; Marble; Parquet
Heating: Forced Air; Natural Gas
Interior Features: Built-in Features; Central Vacuum; Ceramic Tile Bath; Grinder Pump; High Speed Internet; Jet Tub; Open Floorplan; Paddle Fan; Stone Countertops; Vaulted Ceiling(s); Walk-In Closet(s); Wet Bar
Kitchen Features: Built-in Features; Eat-in Kitchen; Kitchen Island; Prep Sink
Laundry Features: Laundry Room; Main Level
Levels: Two
Lot Features: Cul-De-Sac; Secluded; Wooded
Other Equipment: Grinder Pump
Parking Features: Attached; Driveway; Garage; Off Street
Patio And Porch Features: Deck; Enclosed; Screened
Possession: At Closing
Roof: Asphalt
Rooms: Primary Bath; Full Bathroom; Half Bathroom; Foyer; Bedroom; Other Room; Dining Room; Family Room; Kitchen; Living Room; Laundry Room; Library; Loft
Security Features: Carbon Monoxide Detector(s); Security System Owned; Smoke Detector(s)
Sewer: Public Sewer
Showing Requirements: Agent to Accompany; Occupied
Special Listing Conditions: Standard
Water Source: Public
Window Features: Double Pane Windows; Skylight(s)
Room Information
| Room Name | Level | Length | Width | Remarks |
| Foyer | First | 22.33 | 15.00 | Marble tile; open to balcony above |
| Living Room | First | 15.75 | 27.58 | Hardwood floor; wood burning fireplace |
| Library | First | 16.17 | 15.17 | Office built-in bookcases |
| Dining Room | First | 22.50 | 15.42 | Hardwood (inlay) floors |
| Family Room | First | 28.75 | 11.75 | Vaulted ceiling, gas fireplace |
| Kitchen | First | 18.17 | 25.08 | Prep sink; granite counter |
| Other | First | 11.75 | 14.90 | Dinette/Breakfast area |
| Other | First | 14.50 | 8.67 | Exercise room |
| Laundry | First | 16.42 | 9.33 | Washer & dryer included |
| Half Bathroom | First | 7.25 | 4.58 | Granite counter, ceramic tile flr |
| Primary Bathroom | Second | 26.67 | 21.50 | 2 balconies, walk-in closets, carpet |
| Primary Bathroom | Second | Jet tub, marble counters, tiled flr | ||
| Loft | Second | 23.33 | 23.33 | Open to FR & foyer below |
| Family Room | Second | 17.25 | 16.42 | Private for 3 of the 2nd flr. bedrooms |
| Bedroom | Second | 12.50 | 10.90 | Carpet |
| Bedroom | Second | 12.00 | 10.90 | Carpet |
| Bedroom | Second | 11.42 | 11.42 | Carpet |
| Full Bathroom | Second | 9.33 | 7.17 | Skylight, ceramic tile, shower |
| Full Bathroom | Second | 9.33 | 8.83 | Skylight, ceramic tile, tub |
| Other | Basement | 83.83 | 26.00 | Game room, Full bath, Storage |
Listing Courtesy of Staged Nest Real Estate LLC
Listing Agent: Barbara A Walton
518-527-5800 | bwalton853@gmail.com
518-527-5800 | bwalton853@gmail.com


Deed