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.
Closed
$1,525,000
394 Orchard Street, Delmar, NY 12054
6beds
6,146sqft
Single Family Residence, Residential
Built in 2006
3.1 Acres Lot
$1,526,000 Zestimate®
$248/sqft
$6,894 Estimated rent
Home value
$1,526,000
$1.45M - $1.62M
$6,894/mo
Zestimate® history
Owner options
List your home for rent
$6,894/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$6,894/mo
Rent Zestimate®
Refinance and save
$10,926/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$10,926/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Backyard oasisHome officeSpa-like bathroomPowder roomsFormal dining roomPrivate retreat spaceSitting room
Zillow last checked:
Listing updated:
Listed by:
Janet Shaye 518-339-2200,
Howard Hanna Capital Inc
Bought with:
Janet Shaye, 40SH0782490
Howard Hanna Capital Inc
Source: Global MLS,MLS#: 202613017
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 6
- Full bathrooms: 4
- 1/2 bathrooms: 2
Primary bedroom
- Level: Second
Bedroom
- Level: Second
Bedroom
- Level: Second
Bedroom
- Level: Second
Bedroom
- Level: Second
Bedroom
- Level: Basement
Half bathroom
- Level: First
Half bathroom
- Level: First
Full bathroom
- Level: Basement
Dining room
- Level: First
Family room
- Level: First
Family room
- Level: Second
Kitchen
- Level: First
Laundry
- Level: Second
Living room
- Level: First
Mud room
- Level: First
Office
- Level: First
Office
- Level: Second
Other
- Level: First
Other
- Level: First
Heating
- Baseboard, Propane, Propane Tank Owned
Cooling
- Central Air
Appliances
- Included: Cooktop, Dishwasher, Disposal, Double Oven, Microwave, Range Hood, Refrigerator, Washer/Dryer, Wine Cooler
- Laundry: Laundry Room, Upper Level
Features
- High Speed Internet, Ceiling Fan(s), Tray Ceiling(s), Walk-In Closet(s), Wet Bar, Wired for Sound, Built-in Features, Central Vacuum, Ceramic Tile Bath, Chair Rail, Crown Molding, Eat-in Kitchen, Kitchen Island
- Flooring: Wood, Ceramic Tile
- Windows: Screens, Window Treatments, Blinds, Curtain Rods, Drapes
- Basement: Exterior Entry,Finished,Full,Heated,Interior Entry,Unfinished,Walk-Out Access
- Number of fireplaces: 1
- Fireplace features: Family Room
Interior area
- Total structure area: 6,146
- Total interior livable area: 6,146 sqft
- Finished area above ground: 6,146
- Finished area below ground: 0
Property
Parking
- Total spaces: 8
- Parking features: Off Street, Paved, Attached, Circular Driveway, Driveway, Garage Door Opener
- Attached garage spaces: 3
- Has uncovered spaces: Yes
Features
- Patio & porch: Composite Deck, Covered, Deck, Front Porch, Patio
- Exterior features: Garden, Gas Grill, Lighting, Outdoor Bar, Outdoor Kitchen
- Pool features: In Ground, Salt Water
- Fencing: Wrought Iron,Back Yard,Fenced,Invisible,Perimeter
- Has view: Yes
- View description: Trees/Woods, Garden
Lot
- Size: 3.1 Acres
- Features: Secluded, Level, Private, Road Frontage, Sprinklers In Front, Sprinklers In Rear, Wooded, Cleared, Garden, Landscaped
Details
- Additional structures: Gazebo, Outdoor Kitchen
- Parcel number: 012200 95.00446
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Custom
- Property subtype: Single Family Residence, Residential
Materials
- Wood Siding
- Foundation: Block
- Roof: Asphalt
Condition
- Updated/Remodeled
- New construction: No
- Year built: 2006
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Connected
Community & HOA
Community
- Security: Smoke Detector(s), Carbon Monoxide Detector(s)
HOA
- Has HOA: No
Location
- Region: Delmar
Financial & listing details
- Price per square foot: $248/sqft
- Tax assessed value: $1,406,250
- Annual tax amount: $29,687
- Date on market: 3/9/2026
- Ownership: On File
Price history
| Date | Event | Price |
|---|---|---|
| 9/4/2026 | Sold | $1,525,000-7.6%$248/sqft |
Source:  Global MLS #202613017 Report a problem | ||
| 6/18/2026 | Pending sale | $1,650,000$268/sqft |
Source: Global MLS #202613017 Report a problem | ||
| 5/1/2026 | Price change | $1,650,000-13.2%$268/sqft |
Source: Global MLS #202613017 Report a problem | ||
| 3/9/2026 | Listed for sale | $1,900,000+1051.5%$309/sqft |
Source: Global MLS #202613017 Report a problem | ||
| 8/30/2005 | Sold | $165,000+94.1%$27/sqft |
Source: Public Record Report a problem | ||
| 9/18/2002 | Sold | $85,000$14/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $900,000 |
| 2024 | -- | $900,000 |
| 2023 | -- | $900,000 |
| 2022 | -- | $900,000 |
| 2021 | -- | $900,000 |
| 2020 | -- | $900,000 |
| 2019 | -- | $900,000 |
| 2018 | -- | $900,000 |
| 2017 | $27,260 | $900,000 |
| 2016 | -- | $900,000 |
| 2015 | -- | $900,000 |
| 2014 | -- | $900,000 |
| 2013 | -- | $900,000 |
| 2012 | -- | $900,000 |
| 2011 | -- | $900,000 |
| 2010 | -- | $900,000 |
| 2009 | -- | $900,000 -9.1% |
| 2008 | -- | $990,000 -0.5% |
| 2007 | -- | $995,000 +510.4% |
| 2006 | -- | $163,000 +427.5% |
| 2005 | -- | $30,900 |
| 2004 | -- | $30,900 |
| 2003 | -- | $30,900 |
| 2002 | -- | $30,900 |
| 2001 | -- | $30,900 |
| 2000 | -- | $30,900 |
Find assessor info on the county website
Neighborhood: 12054
Nearby homes
- $1,602,9005 bd5 ba6.2k sqft394 Orchard St, Delmar, NY 99999Off Market
- $1,200,0005 bd6 ba4.3k sqft386 Orchard St, Delmar, NY 12054Sold
- $830,0004 bd3 ba3.6k sqft380 Orchard St, Delmar, NY 12054Off Market
- $195,313-- bd-- ba-- sqft8 Capricorn Ln, Slingerlands, NY 12159Off Market
- $1,175,7812 acres10 Capricorn Ln, Bethlehem, NY 12159Off Market
- $1,543,1005 bd4 ba5.7k sqft430 Orchard St, Delmar, NY 12054Off Market
- $743,3004 bd2 ba2.4k sqft421 Orchard St, Delmar, NY 12054Off Market
- $--2.1 acres9 Capricorn Ln, Delmar, NY 12054Off Market
Nearby schools
GreatSchools rating
- 7/10Slingerlands Elementary SchoolGrades: K-5Distance: 1.5 mi
- 7/10Bethlehem Central Middle SchoolGrades: 5-8Distance: 2.9 mi
- 10/10Bethlehem Central Senior High SchoolGrades: 9-12Distance: 1.3 mi
Schools provided by the listing agent
- Elementary: Slingerlands
- High: Bethlehem Central
Source: Global MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- New York
- Albany County
- Delmar
- 12054
- 394 Orchard Street
