Loading listing
Sold · Sep 2026 · $1,525,000
This home has closed. Own one like it? Sharon will tell you what it is worth today from real comparable sales, not an algorithm. Similar homes still for sale are further down the page.
Sold
Sold · Sep 2026 · $1,525,000
This home has closed. Own one like it? Sharon will tell you what it is worth today from real comparable sales, not an algorithm. Similar homes still for sale are further down the page.
$1,525,000
Sold · listed at $1,650,000
394 Orchard Street
Delmar, NY 12054 · Albany County
6Beds
5Baths
6,146Sq Ft
3.10acres lot
2006Year Built
$248Per Sq Ft
MLS# 202613017 Updated 1 week ago
Sharon’s Take
This is a custom single family home built in 2006 on 3.10 acres in Bethlehem, within the Bethlehem Central school district, with 6 bedrooms, 5 baths and about 6,146 square feet. The remarks describe a chef's kitchen connecting to the family room with a wine and beverage wet bar, plus a formal dining room, living room, home office, and sitting room. The primary suite has a large walk-in closet, and the lower level adds a bath, bedroom, and flexible space. Outside there is a heated saltwater pool with covered decking and a BBQ area. No HOA; reduced from $1,900,000.
Sharon Fronk · Howard Hanna Capital Region
About this property
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.
Property details
24 facts pulled straight from the MLS listing.
Overview
Property TypeSingle Family
Sub-TypeSingle Family Residence
Year Built2006
Days on Market178
StatusSold
MLS Number202613017
ListedMarch 9, 2026
Interior
Bedrooms6
Bathrooms4 full, 2 half
Living Area6,146 sq ft
Interior Features
Full Finished Unfinished Walk-Out Access Interior Entry Exterior Entry BasementHigh Speed InternetPaddle FanTray Ceiling(s)Walk-In Closet(s)Wet BarWired for SoundBuilt-in FeaturesCentral VacuumCeramic Tile BathChair RailCrown MoldingEat-in KitchenKitchen IslandCentral AirBaseboardPropanePropane Tank OwnedWoodCeramic TileHeatedFamily Room
Exterior & Lot
Lot Size3.10 acres
Exterior Features
Drive-PavedGardenGas GrillLightingOutdoor BarOutdoor KitchenPoolIn GroundSalt WaterTrees/WoodsGarage3 Car GarageOff StreetPavedAttachedCircular DrivewayDrivewayGarage Door Opener
Building & Construction
Construction
Wood Siding
Utilities
Cable Connected
Financial
Sold Price$1,525,000
Originally Listed$1,650,000
Price per Sq Ft$268
Location
CountyAlbany
High School DistrictBethlehem Central
Elementary DistrictSlingerlands
Listing Details
Listed ByJanet Shaye of Howard Hanna Capital Inc
Data SourceSpark Platform / Global MLS
Last UpdatedSep 4, 2026
What's nearby
Google Maps view. Pan, zoom, click a pin to read about a business or place.
Commute Planner
Plan a multi-stop route from this address: drop-off the kid, hit the office, head home. Live traffic from Google.
- Start394 Orchard Street, Delmar, NY 12054
Try a preset
Schools
The district this address is assigned to. Ratings and reviews are hosted on GreatSchools.
Bethlehem Central
Assigned high school district
Slingerlands
Assigned elementary district
Assigned districts can change and are not guaranteed. Confirm enrollment boundaries with the district directly before relying on them.
About Delmar, NY
Delmar is in Albany County, NY. There are currently 55 active listings here, ranging from $39,900 to $1,875,000. Listings in this address fall under the Bethlehem school district.
Listed by
Who holds this listing, and where the data comes from.
- Listing agent
- Janet Shaye
- Listing office
- Howard Hanna Capital Inc
- Office phone
- 518-339-2200
- MLS number
- 202613017
- Source
- Global MLS
- Listed on
- March 9, 2026
You might also like
Sharon represents buyers for this property. Your tour, offer, and inquiries go through her, not the listing brokerage.
Howard Hanna Capital Inc · Listed by Janet Shaye (2885)
Contact: 518-339-2200
MLS #202613017 · Source: Global MLS, Inc.
IDX information is provided exclusively for consumers' personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the MLS. Sharon Fronk Real Estate is committed to compliance with the Fair Housing Act and provides equal opportunity in housing.