
Member Features
Find Real Estate Bargain!
Full foreclosure details
Home value, equity and ownership info
Find homes priced below market
Get full access with a FREE Account
Already a member?
$549,990
Listing Price4beds
3baths
1,904sqft
29,621sqft lot
647 Union Ave, Holtsville, NY 11742
Member Features
Find Real Estate Bargain!
Full foreclosure details
Home value, equity and ownership info
Find homes priced below market
Get full access with a FREE Account
Already a member?
For Sale
Off Market
Home type
Price / sqft
Year built
Home Details
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.nnUpstairs, youll 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. nnOutside youll be captivated by the lush, professionally landscaped gardens, complete with walkways that meander around colorful blooms and greenery. Whether youre 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. nnWith 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 exciti
Interior Details
1904
4
3
Has Heating:
Yes
Heating Type:
Radiant
Has Cooling:
No
Cooling Type:
N/A
Has Fuel:
No
Fuel Type:
N/A
Has Basement:
No
Basement Type:
Finished
Has Flooring:
No
Flooring Type:
N/A
Has Fireplace:
Yes
Fireplace Type:
N/A
Property Details
29621
No
No
Type:
N/A
Location:
N/A
Status:
N/A
Number of Spaces:
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
Construction Details
Cape Cod
Brick
N/A
N/A
N/A
Tax History
Year
Amount
Land
Improvement
Percent Change
Assessment
2020
$4,659
$330
$1,500
--%
$1,830
2018
$5,194
$330
$1,500
--%
$1,830
2017
$5,014
$330
$1,500
--%
$1,830
2016
$5,006
$330
$1,500
--%
$1,830
2015
$4,851
$330
$1,500
--%
$1,830
2014
$5,531
$330
$1,500
--%
$1,830
2013
$4,644
$330
$1,500
--%
$1,830
Average Home Price in 11742
Nearby Properties
Zip Code
Price
Bed
Bath
Sqft
Lot
Sold Date
$549,990
$549,990
4 Beds
3 Baths
1,904 Sqft
29,621 Lot (sqft)
Sold 09/29/2026
$723,772
$723,772
3 Beds
2.5 Baths
1,812 Sqft
2,178 Lot (sqft)
Sold 10/05/2026
$757,495
3 Beds
3 Baths
2,080 Sqft
20,038 Lot (sqft)
Sold NaN/NaN/NaN
$695,650
3 Beds
1 Baths
1,791 Sqft
10,454 Lot (sqft)
Sold 10/06/2026






