Coldwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Phillips
Property view
Listing view 2
Listing view 3

647 Union Avenue, 
Holtsville, NY 11742

$549,990


4

Beds


3

Baths


1,904

Sq Ft


Single Family


Virtual Tour

Active

Listed by

Lina Lopes

Douglas Elliman Real Estate

Last updated:

July 14, 2025, 03:18 PM

MLS#

887130

Source:

One Key MLS

About This Home

647 Union Avenue

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!

Home Facts

Single Family

3 Baths

4 Bedrooms

Built in 1955

Price Summary

549,990

$288 per Sq. Ft.

MLS #:

887130

Last Updated:

July 14, 2025, 03:18 PM

Added:

9 day(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

4

Bathrooms

Total Bathrooms:

3

Full Bathrooms:

2

Interior

Living Area:

1,904 Sq. Ft.


Structure

Structure

Architectural Style:

Exp Cape

Building Area:

1,904 Sq. Ft.

Year Built:

1955


Lot

Lot Size (Sq. Ft):

29,621


Finances & Disclosures

Finances

Price:

$549,990

Price per Sq. Ft:

$288 per Sq. Ft.

Source:One Key MLS
Copyright 2025 OneKey MLS. All rights reserved. OneKey MLS provides content displayed here (“provided content”) on an “as is” basis and makes no representations or warranties regarding the provided content, including, but not limited to those of non-infringement, timeliness, accuracy, or completeness. Individuals and companies using information presented are responsible for verification and validation of information they utilize and present to their customers and clients. OneKey MLS will not be liable for any damage or loss resulting from use of the provided content or the products available through Portals, IDX, VOW, and/or Syndication. Recipients of this information shall not resell, redistribute, reproduce, modify, or otherwise copy any portion thereof without the expressed written consent of OneKey MLS.

Contact an Agent

Yes, I would like more information from Coldwell Banker. Please use and/or share my information with a Coldwell Banker agent to contact me about my real estate needs.

By clicking Contact I agree a Coldwell Banker Agent may contact me by phone or text message including by automated means and prerecorded messages about real estate services, and that I can access real estate services without providing my phone number. I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

 

Contact an Agent

Yes, I would like more information from Coldwell Banker. Please use and/or share my information with a Coldwell Banker agent to contact me about my real estate needs.

By clicking Contact I agree a Coldwell Banker Agent may contact me by phone or text message including by automated means and prerecorded messages about real estate services, and that I can access real estate services without providing my phone number. I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.