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

1 / 87
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 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! The dining room light fixture is excluded.
Details
Maps
Documents
Contract Information
Status: Active
Current Price: $1,299,000
Original List Price: 1299000
List Price: $1,299,000
Listing Contract Date: 2026-07-30
Property Sub Type: Single Family Residence
List Price/SqFt: 257.94
List Price/Acres: 534567.9
Location
Street Number: 37
Street Name: Covington
Street Suffix: Court
County: Schenectady
State/Province: NY
Postal Code: 12309
Postal Code +4: 1323
City/Town (Mail): Niskayuna
Subdivision: Baldwin Farms
Cross Street: River Road
Geo Lat: 42.800356
Geo Lon: -73.851878
Property Detail
Rooms Total: 15
Bedrooms Total: 4
Bathrooms Full: 4
Bathrooms Half: 1
Bathrooms Total: 5
Year Built: 1992
Above Grade Finished Area: 5036
Above Grade Finished Area Source: CRS
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
Main Road Frontage: 61
Lot Size Acres: 2.43
Waterfront Y/N: No
Enhanced Accessible Y/N: No
Parking Y/N: Yes
Garage Spaces: 3
Financial Details
General Taxes: 7953.48
General Taxes Description: Actual
School Taxes: 15551.31
School Taxes Description: Actual
Bath Levels
Full Bath 1: 2nd
Full Bath 2: 2nd
Full Bath 3: 2nd
Full Bath 4: Basement
Half Bath 1: 1st
Photos - the contractual owner of the photos
Photo Owner: Combination Ownership
Parking Features
Parking Total: 15
Rooms
Primary Bath Level: Second
Full Bathroom Level: Second
Half Bathroom Level: First
Foyer Level: First
Bedroom Level: Second
Other Room Level: First
Dining Room Level: First
Family Room Level: First
Kitchen Level: First
Living Room Level: First
Laundry Room Level: First
Library Level: First
Loft Level: Second
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