• buy
  • rent
  • sell
  • agents
new developmentWORLD OF ELLIMAN
The latest in luxury property, lifestyle & culture, curated just for you.

company

  • about us
  • leadership
  • offices
  • press & news
  • elliman cares
  • join as an agent
  • careers
  • INTERNATIONAL PARTNERSHIP
  • investors

resources

  • WORLD OF ELLIMAN
  • elliman insider
  • magazines
  • market reports
  • research reports
  • Elliman Exclusives
  • Featured Cities
  • guides to buying & selling

brand portfolio

  • new development
  • commercial
  • relocation
  • property management
  • sports & entertainment
  • farm & ranch
  • building broker specialists
  • title services
  • master trust & probate

  • California
  • Colorado
  • Connecticut
  • Florida
  • Massachusetts
  • Mid-Atlantic
  • Nevada
  • New Jersey
  • New York
  • New York City
  • Texas
  • Vermont
  • SITE MAP
  • TERMS
  • PRIVACY
  • COOKIE PREFERENCES
  • DO NOT SELL OR SHARE MY PERSONAL INFORMATION
  • NYS Housing Discrimination Disclosure Notice & Form
  • NYS Standard Operating Procedure
  • NYS Tenants' Rights to Reasonable Accommodations for persons with disabilities
  • California Consumer Privacy Act Notice
  • Texas Consumer Protection Notice
  • Texas Real Estate Commission Information About Brokerage Services
  • text of new york city human rights law
  • new york city commission on human rights
  • nyc source of income discrimination information
  • nyc source of income discrimination tenant faqs

THE SOURCE OF THE DISPLAYED DATA IS EITHER THE PROPERTY OWNER OR PUBLIC RECORD PROVIDED BY NON-GOVERNMENTAL THIRD PARTIES. IT IS BELIEVED TO BE RELIABLE BUT NOT GUARANTEED. FOR COLORADO VIEWERS, INFORMATION ABOUT NON-COMMERCIAL PROPERTIES IS PROVIDED EXCLUSIVELY FOR YOUR PERSONAL, NON-COMMERCIAL USE.

575 MADISON AVENUE, NEW YORK, NY 10022. 212.891.7000 © 2025 DOUGLAS ELLIMAN REAL ESTATE. EQUAL EMPLOYMENT OPPORTUNITY PROVIDER. ALL MATERIAL PRESENTED HEREIN IS INTENDED FOR INFORMATION PURPOSES ONLY. WHILE THIS INFORMATION IS BELIEVED TO BE CORRECT, IT IS REPRESENTED SUBJECT TO ERRORS, OMISSIONS, CHANGES, OR WITHDRAWAL WITHOUT NOTICE. ALL PROPERTY INFORMATION, INCLUDING, BUT NOT LIMITED TO SQUARE FOOTAGE, ROOM COUNT, NUMBER OF BEDROOMS, AND THE SCHOOL DISTRICT IN PROPERTY LISTINGS SHOULD BE VERIFIED BY YOUR OWN ATTORNEY, ARCHITECT, OR ZONING EXPERT. EQUAL HOUSING OPPORTUNITY.LISTING DATA REFRESHED ON AUG 15 2025 AT 8:29 PM.

DOUGLAS ELLIMAN IS A LICENSED REAL ESTATE BROKER IN CALIFORNIA WITH LICENSE # 01947727, COLORADO WITH LICENSE # EC100053892, CONNECTICUT WITH LICENSE # REB.0314827, THE DISTRICT OF COLUMBIA WITH LICENSE # REO40000160, FLORIDA WITH LICENSE # CQ1020232, MARYLAND WITH LICENSE # 645270, MASSACHUSETTS WITH LICENSE # 422764, NEVADA WITH LICENSE # 1454643, NEW JERSEY WITH LICENSE # 0572105, NEW YORK WITH LICENSE # 10991211812, TEXAS WITH LICENSE # 9008706, AND VIRGINIA WITH LICENSE # 0226035659.

POWERED BY PURLIN.AI

647 Union Ave

holtsville, NY 11742

$549,990

  • 4 BR
    2 BA, 1 HALF BA
    APPROX. 1,904 SF
  • logodouglas elliman exclusive
    contract signed

GET IN TOUCH WITH OUR AGENTS

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!

Details

1,904 Sq Ft

0.68 Private Acres Exterior Space

Single Family Home

$7,203 Annual Tax

Built in 1955

MLS/Listing ID 887130

Amenities & Features

Range

Refrigerator

Stainless Steel Appliance(s)

Washer

Dryer

Pool - Above Ground

Terrace

Lot - Corner Lot

In Basement

Master Downstairs

Eat-in Kitchen

Heating - Oil

Heating - Baseboard

Natural Wood

Cooling - Wall/window unit(s)

Construction - Frame

Construction - Brick

Style - Expanded Cape Cod

Listing Courtesy of DOUGLAS ELLIMAN REAL ESTATE, LINA LOPES - 631-363-5462

ONEKEY

Source of Data: ONEKEY MLS

Interested in 647 Union Ave?