$1,650,000
Bethlehem, NY 12054
MLS# 202613017
Status: Pending
6 beds | 6 baths

1 / 85
Property Description
Welcome to 394 Orchard Street. Custom built in 2006 by Hanifin Home Builders, set on 3.1 acres offering space, privacy and a beautiful natural setting within the town of Bethlehem. Thoughtfully designed for family, multi-generational and au pair lifestyles. The gourmet chef's kitchen is the heart of this home, seamlessly connecting to the family room, accented by wine/beverage wet bar and flowing into the formal dining room. The adjoining living room, home office, sitting room, powder rooms, and built-in bench and cubby area complete the main level. The primary suite features a large walk-in closet spa-like bathroom, and private retreat space. Four additional bedrooms are anchored by Jack and Jill bathrooms, and the spacious laundry room includes and ironing board and sink. The lower level offers a full bath, bedroom and flexible workout or playroom space. Outside, a stunning heated saltwater pool with covered decking and BBQ entertainment area sets the stage for effortless entertaining. A Zen-inspired koi pond with a water feature completes this backyard oasis.
Details
Maps
Contract Information
Original List Price: 1900000
List Price/SqFt: 268.47
List Price/Acres: 532258.06
Status: Pending
Current Price: $1,650,000
List Price: $1,650,000
Listing Contract Date: 2026-03-09
Property Sub Type: Single Family Residence
Location
City/Town (Mail): Delmar
Street Number: 394
Street Name: Orchard
Street Suffix: Street
County: Albany
State/Province: NY
Postal Code: 12054
Geo Lat: 42.611015
Geo Lon: -73.882118
Property Detail
Rooms Total: 16
Bathrooms Half: 2
Garage Spaces: 3
Above Grade Finished Area: 6146
Above Grade Finished Area Source: Public Records
Parking Y/N: Yes
Below Grade Finished Area: 0
Below Grade Finished Area Source: Public Records
Living Area: 6146
Total Finished Area: 6146
Fireplaces Total: 1
Lot Size Acres: 3.1
Waterfront Y/N: No
Enhanced Accessible Y/N: No
Survey Y/N: Yes
Bedrooms Total: 6
Bathrooms Full: 4
Bathrooms Total: 6
Year Built: 2006
Status Change Info
Proposed Closing Date: 2026-08-31
Status Change Date: 2026-06-18
Under Contract Date: 2026-06-18
Parcel, Tax, HOA
New Construction Y/N: No
Parcel Number: 012200 95.00-4-46
Tax Annual Amount: 29687.23
Tax Section: 95.00
Total Taxes Description: Estimated
Tax Block: 4
Tax Lot: 46.000
School District: Bethlehem
Elementary School: Slingerlands
High School: Bethlehem Central
Association Y/N: No
Directions & Remarks
Directions: Orchard Street
Public Remarks: Welcome to 394 Orchard Street. Custom built in 2006 by Hanifin Home Builders, set on 3.1 acres offering space, privacy and a beautiful natural setting within the town of Bethlehem. Thoughtfully designed for family, multi-generational and au pair lifestyles. The gourmet chef's kitchen is the heart of this home, seamlessly connecting to the family room, accented by wine/beverage wet bar and flowing into the formal dining room. The adjoining living room, home office, sitting room, powder rooms, and built-in bench and cubby area complete the main level. The primary suite features a large walk-in closet spa-like bathroom, and private retreat space. Four additional bedrooms are anchored by Jack and Jill bathrooms, and the spacious laundry room includes and ironing board and sink. The lower level offers a full bath, bedroom and flexible workout or playroom space. Outside, a stunning heated saltwater pool with covered decking and BBQ entertainment area sets the stage for effortless entertaining. A Zen-inspired koi pond with a water feature completes this backyard oasis.
Sewer
Public Sewer: 1
Appliances
Cooktop: 1
Dishwasher: 1
Disposal: 1
Double Oven: 1
Microwave: 1
Range Hood: 1
Refrigerator: 1
Washer/Dryer: 1
Wine Cooler: 1
Architectural Style
Custom: 1
Electric
200+ Amp Service: 1
Fencing
Back Yard: 1
Fenced: 1
Invisible: 1
Perimeter: 1
Wrought Iron: 1
Attic Features
Dormer: 1
Cooling
Central Air: 1
Basement
Exterior Entry: 1
Finished: 1
Full: 1
Heated: 1
Interior Entry: 1
Unfinished: 1
Walk-Out Access: 1
Bath Levels
Full Bath 1: 2nd
Full Bath 2: 2nd
Full Bath 3: 2nd
Full Bath 4: Basement
Half Bath 1: 1st
Half Bath 2: 1st
Dining Room Type
Formal Dining Room: 1
Lot Features
Cleared: 1
Garden: 1
Landscaped: 1
Level: 1
Private: 1
Road Frontage: 1
Secluded: 1
Sprinklers In Front: 1
Sprinklers In Rear: 1
Wooded: 1
Construction Materials
Wood Siding: 1
Other Structures
Gazebo: 1
Outdoor Kitchen: 1
Photos - the contractual owner of the photos
Photo Owner: Combination Ownership
Possession
At Closing: 1
Exterior Features
Drive-Paved: 1
Garden: 1
Gas Grill: 1
Lighting: 1
Outdoor Bar: 1
Outdoor Kitchen: 1
Fireplace Features
Family Room: 1
Gas Stove: 1
Flooring
Ceramic Tile: 1
Wood: 1
Showing Requirements
24 Hour Notice: 1
Agent to Accompany: 1
Showing Service: 1
Sign on Property: 1
Special Listing Conditions
Ownership: On File
Utilities
Cable Connected: 1
Roof
Asphalt: 1
View
Garden: 1
Trees/Woods: 1
Water Source
Public: 1
Foundation Details
Block: 1
Heating
Baseboard: 1
Propane: 1
Propane Tank Owned: 1
Interior Features
Built-in Features: 1
Central Vacuum: 1
Ceramic Tile Bath: 1
Chair Rail: 1
Crown Molding: 1
High Speed Internet: 1
Open Floorplan: 1
Paddle Fan: 1
Stone Countertops: 1
Tray Ceiling(s): 1
Walk-In Closet(s): 1
Wet Bar: 1
Wired for Sound: 1
Kitchen Features
Built-in Features: 1
Eat-in Kitchen: 1
Gourmet Kitchen: 1
Kitchen Island: 1
Modern Kitchen: 1
Laundry Features
Laundry Room: 1
Upper Level: 1
Parking Features
Parking Total: 8
Attached: 1
Circular Driveway: 1
Driveway: 1
Garage: 1
Garage Door Opener: 1
Off Street: 1
Paved: 1
Patio And Porch Features
Composite Deck: 1
Covered: 1
Deck: 1
Front Porch: 1
Patio: 1
Pool Features
In Ground: 1
Salt Water: 1
Levels
Three Or More: 1
Security Features
Carbon Monoxide Detector(s): 1
Smoke Detector(s): 1
Property Condition
Updated/Remodeled: 1
Rooms
Full Bathroom: 1
Half Bathroom: 1
Half Bathroom Level: First
Bedroom: 1
Bedroom Level: Second
Primary Bedroom: 1
Primary 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
Office: 1
Office Level: First
Laundry Room: 1
Laundry Room Level: Second
Mud Room: 1
Mud Room Level: First
Window Features
Blinds: 1
Curtain Rods: 1
Drapes: 1
Screens: 1
Window Treatments: 1
Property Features
Appliances: Cooktop; Dishwasher; Disposal; Double Oven; Microwave; Range Hood; Refrigerator; Washer/Dryer; Wine Cooler
Architectural Style: Custom
Attic Features: Dormer
Basement: Exterior Entry; Finished; Full; Heated; Interior Entry; Unfinished; Walk-Out Access
Construction Materials: Wood Siding
Cooling: Central Air
Dining Room Type: Formal Dining Room
Electric: 200+ Amp Service
Exterior Features: Drive-Paved; Garden; Gas Grill; Lighting; Outdoor Bar; Outdoor Kitchen
Fencing: Back Yard; Fenced; Invisible; Perimeter; Wrought Iron
Fireplace Features: Family Room; Gas Stove
Flooring: Ceramic Tile; Wood
Foundation Details: Block
Heating: Baseboard; Propane; Propane Tank Owned
Interior Features: Built-in Features; Central Vacuum; Ceramic Tile Bath; Chair Rail; Crown Molding; High Speed Internet; Open Floorplan; Paddle Fan; Stone Countertops; Tray Ceiling(s); Walk-In Closet(s); Wet Bar; Wired for Sound
Kitchen Features: Built-in Features; Eat-in Kitchen; Gourmet Kitchen; Kitchen Island; Modern Kitchen
Laundry Features: Laundry Room; Upper Level
Levels: Three Or More
Lot Features: Cleared; Garden; Landscaped; Level; Private; Road Frontage; Secluded; Sprinklers In Front; Sprinklers In Rear; Wooded
Other Structures: Gazebo; Outdoor Kitchen
Parking Features: Attached; Circular Driveway; Driveway; Garage; Garage Door Opener; Off Street; Paved
Patio And Porch Features: Composite Deck; Covered; Deck; Front Porch; Patio
Pool Features: In Ground; Salt Water
Possession: At Closing
Property Condition: Updated/Remodeled
Roof: Asphalt
Rooms: Full Bathroom; Half Bathroom; Bedroom; Primary Bedroom; Other Room; Dining Room; Family Room; Kitchen; Living Room; Office; Laundry Room; Mud Room
Security Features: Carbon Monoxide Detector(s); Smoke Detector(s)
Sewer: Public Sewer
Showing Requirements: 24 Hour Notice; Agent to Accompany; Showing Service; Sign on Property
Utilities: Cable Connected
View: Garden; Trees/Woods
Water Source: Public
Window Features: Blinds; Curtain Rods; Drapes; Screens; Window Treatments
Room Information
| Room Name | Level |
| Living Room | First |
| Dining Room | First |
| Office | First |
| Other | First |
| Kitchen | First |
| Family Room | First |
| Mud Room | First |
| Other | First |
| Half Bathroom | First |
| Half Bathroom | First |
| Primary Bedroom | Second |
| Office | Second |
| Bedroom | Second |
| Bedroom | Second |
| Bedroom | Second |
| Bedroom | Second |
| Family Room | Second |
| Laundry | Second |
| Bedroom | Basement |
| Full Bathroom | Basement |
Listing Courtesy of Howard Hanna Capital Inc
Listing Agent: Janet Shaye
518-339-2200 | janetshaye@howardhanna.com
518-339-2200 | janetshaye@howardhanna.com

