• 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
  • elliman global
  • investors

resources

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

brand portfolio

  • new development
  • commercial
  • relocation
  • sports & entertainment
  • farm & ranch
  • building broker specialists
  • title services
  • estate, 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 DEC 15 2025 AT 5:58 AM.

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.

SCAMMERS ARE IMPERSONATING REAL ESTATE AGENTS AND USING ACTIVE LISTINGS TO REQUEST FAKE DEPOSITS. SHOULD YOU HAVE A QUESTION ABOUT THE LEGITIMACY OF A DOUGLAS ELLIMAN AGENT OR LISTING, PLEASE CONTACT THE AGENT DIRECTLY VIA THE “AGENTS” LINK IN THE TOP MENU. DOUGLAS ELLIMAN WILL NEVER ASK FOR ANY PAYMENT TO RESERVE, HOLD, OR VIEW A PROPERTY. THESE CHARGES ARE PROHIBITED UNDER NEW YORK LAW. IF YOU RECEIVE A SUSPICIOUS REQUEST FOR MONEY, DO NOT SEND FUNDS. REPORT IT TO THE NYS DEPARTMENT OF STATE AND NOTIFY DOUGLAS ELLIMAN. YOU CAN READ THE NEW YORK STATE DEPARTMENT OF STATE'S CONSUMER ALERT HERE.

POWERED BY PURLIN.AI

174 Delaware Ave

freeport, NY 11520

$1,089,000

  • 5 BR
    4 BA, 1 HALF BA
    APPROX. 3,800 SF
  • logodouglas elliman exclusive
    contract signed

INTERESTED? LET'S CONNECT

Get ready to Fall in Love with this renovated 5 bedroom and 4.5 bath colonial home situated on a 90x100 lot in the prestigious Stearns Park section of Freeport, within the Baldwin School District. This expansive 3800+ interior square foot home has been thoughtfully designed and the flow for effortless entertaining and stylish and comfortable family living. Enter into the Formal Living Room with a wood-burning fireplace, readied to be converted to gas, leads to formal dining room, Spacious Eat-In Kitchen with stainless steel appliance and sun-drenched bonus room with access the backyard patio, gazebo and deck. A versatile first-floor Primary Bedroom with full bathroom en-suite and additional bedroom and full bathroom offer the potential for a private office or guest suite.

Upstairs, the second primary bedroom suite awaits, with spacious walk-in closet and two additional generously sized bedrooms, two additional full bathrooms and plenty of storage complete the second level. The oversized recently finished (2023) lower-level provides additional space for entertaining, half bath, utility room, and laundry facilities. Outside gazebo, patio and deck are all perfect for your outdoor entertaining needs. Additional notable features include over 3,800+ sq ft of interior living space, Roof (2023); Boiler (2022); Deck (2020), both 3-zone heating and 2 zone Central Air both less than 3 years old, in-ground sprinklers and a 2-car garage with electric vehicle charger.

Freeport is celebrated for its vibrant Nautical Mile waterfront dining, close proximity to world class beaches, numerous parks and recreation options, and a convenient 40-minute LIRR commute to NYC. Don't miss this exceptional opportunity to experience the best of suburban living – schedule your private tour today!

Details

3,800 Sq Ft

0.2066 Private Acres Lot Size

Single Family Home

$19,020 Annual Tax

Built in 1954

MLS/Listing ID 915915

Amenities & Features

Master Downstairs

Storage

Walk-through Kitchen

Washer/Dryer Hookup

In Basement

Lot - Back Yard

Lot - Front Yard

Lot - Near School

Lot - Paved

Lot - Sprinklers in Front

Parking - EV Charging Station

Parking - Garage

Pantry

Dryer

ENERGY STAR Qualified Appliances

Microwave

Stainless Steel Appliance(s)

Style - Colonial

High Ceilings

Entrance Foyer

Eat-in Kitchen

Double Vanity

Ceiling Fans

Heating - Baseboard

Hardwood

Combination

Wood Burning Fireplace

Backyard

Cooling - Central Air

Construction - Vinyl Siding

Construction - Brick

ONEKEY

Interested in 174 Delaware Ave?