Welcome to 647 Union Ave — As per Town of Brookhaven - Planning & Environmental, this property is zoned L1 Industrial, perfect for Landscapers, contractors or Nature lovers! This beautifully maintained 4-bedroom, 2.5-bath residence is nestled on an oversized corner lot spanning over half an acre with so many possibilities with the location and oversized driveway. This unique home offers a spacious and flexible layout perfect for both everyday living and entertaining. The main level features two generously sized bedrooms, including the primary bedroom, a full bath, and a large eat-in kitchen complete with stainless steel appliances and dining area.
Upstairs, you'll find additional bedrooms — one of which offers the option to be used as a den — and opens to a private terrace for your morning coffee or evening unwind. The fully finished basement has a den, full bathroom, laundry area, utilities, storage, and a private outside entrance.
Outside you’ll be captivated by the lush, professionally landscaped gardens, complete with walkways that meander around colorful blooms and greenery. Whether you're entertaining poolside, relaxing on the terrace, or enjoying the tranquility of the garden, the outdoor space is truly a private retreat. The property also features an above-ground pool, an extended driveway with ample parking.
With incredibly low taxes just over $7,000, and a Land Use designation of Commercial Lot per public records, this property presents both residential charm and exciting potential.
Don’t miss this rare opportunity to own a home that offers space, beauty, and versatility — both inside and out!
Pending
$549,990
647 Union Avenue, Holtsville, NY 11742
4beds
1,904sqft
Single Family Residence, Residential
Built in 1955
0.68 Acres Lot
$-- Zestimate®
$289/sqft
$-- HOA
What's special
Private terraceColorful blooms and greeneryAbove-ground poolStainless steel appliancesCorner lotOversized drivewayExtended driveway
- 37 days
- on Zillow |
- 1,344 |
- 118 |
Likely to sell faster than
Zillow last checked: 7 hours ago
Listing updated: July 28, 2025 at 09:05am
Listing by:
Douglas Elliman Real Estate 631-758-2552,
Lina Lopes 631-487-3113
Source: OneKey® MLS,MLS#: 887130

Travel times
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Other
- Description: Den, Bathroom, Storage, Outside Entrance, Utilities, Laundry
- Level: Basement
Other
- Description: Primary Bedroom, Bedroom, Living Room, Large Eat-In Kitchen with Dining Area, Full Bathroom
- Level: First
Other
- Description: 2 Bedroom (one can be used as a Den), Half Bathroom, Terrace
- Level: Second
Heating
- Baseboard, Oil
Cooling
- Wall/Window Unit(s)
Appliances
- Included: Dryer, Range, Refrigerator, Stainless Steel Appliance(s), Washer
- Laundry: In Basement
Features
- First Floor Bedroom, Eat-in Kitchen, Master Downstairs
- Flooring: Wood
- Basement: Finished,Full,Walk-Out Access
- Attic: Partial
- Has fireplace: No
Interior area
- Total structure area: 1,904
- Total interior livable area: 1,904 sqft
Video & virtual tour
Property
Parking
- Total spaces: 1
- Parking features: Garage
- Garage spaces: 1
Features
- Levels: Two
- Patio & porch: Terrace
- Has private pool: Yes
- Pool features: Above Ground
Lot
- Size: 0.68 Acres
- Features: Corner Lot
Details
- Parcel number: 0200766000200008000
- Special conditions: None
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Exp Cape
- Property subtype: Single Family Residence, Residential
Materials
- Brick
Condition
- Year built: 1955
Utilities & green energy
- Sewer: Cesspool
- Water: Public
- Utilities for property: Electricity Connected, Water Connected
Community & HOA
HOA
- Has HOA: No
Location
- Region: Holtsville
Financial & listing details
- Price per square foot: $289/sqft
- Tax assessed value: $345,283
- Annual tax amount: $7,203
- Date on market: 7/9/2025
- Listing agreement: Exclusive Right To Sell
- Electric utility on property: Yes
- Loading