BuySellBlogBrowse Listings

174 Delaware AvenueFreeport, NY 11520

For Sale

$1,089,000

Smart Buyer Rebate $10,890

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!

Listed by Melinda A. Beauchamp

·

Douglas Elliman Real Estate

·

516-669-3700

Listed by Thomas McKenna MRP

·

Douglas Elliman Real Estate

Last updated October 12, 2025

·

Source: OneKey #915915

Listing Facts

  • TypeSingle-family
  • NeighborhoodFreeport
  • Bedrooms5
  • Bathrooms5
  • Days on Prevu21
  • Taxes$19,020/year
  • Size3,800 sqft
  • Price per sqft$287

Amenities

  • Washer/Dryer
  • Air Conditioning
  • Parking

Location

Mortgage Calculator

Listing History

09/30/2025
Listed by Douglas Elliman Real Estate
$1,089,000

Property Details for 174 Delaware Avenue

Exterior

Construction

  • Property Condition: Updated/Remodeled
  • Year Built: 1954
  • Architectural Style: Colonial
  • Construction Materials: Brick, Vinyl Siding

Features

  • Direction Faces: West
  • Fencing: Back Yard

Measurements

  • Building Area Total: 3,738
  • Building Area Units: Square Feet
  • Lot Features: Back Yard, Front Yard, Near School, Near Shops, Paved, Sprinklers In Front
  • Lot Size Acres: 0.20
  • Lot Size Square Feet: 9,000

Financial

Taxes

  • Parcel Number: 2009-36-521-00-0019-0
  • Tax Annual Amount: $19,020.00
  • Tax Year: 2025

Interior

Features

  • Appliances: Dryer, ENERGY STAR Qualified Appliances, Microwave, Stainless Steel Appliance(s)
  • Fireplace Features: Wood Burning
  • Fireplace: Yes
  • Fireplaces Total: 1
  • Flooring: Combination, Hardwood
  • Interior Features: First Floor Bedroom, First Floor Full Bath, Ceiling Fan(s), Double Vanity, Eat-in Kitchen, Entrance Foyer, Formal Dining, High Ceilings, Pantry, Primary Bathroom, Master Downstairs, Storage, Walk Through Kitchen, Washer/Dryer Hookup

Measurements

  • Living Area: 3,800
  • Living Area Source: Other

Rooms

  • Basement: Full, Walk-Out Access
  • Has Basement: Yes
  • Bathrooms Full: 4
  • Bathrooms Half: 1
  • Bathrooms Total Integer: 5
  • Bedrooms Total: 5
  • Rooms Total: 12

Other

Location

  • Subdivision Name: Stearns Park

Parking

Parking

  • Garage Spaces: 2
  • Garage: Yes
  • Parking Features: Electric Vehicle Charging Station(s), Garage
  • Parking Total: 4

Schools

Elementary School

  • Elementary School: Brookside Elementary School
  • Elementary School District: Baldwin

High School

  • High School: Baldwin Senior High School
  • High School District: Baldwin

Middle or Junior School

  • Middle Or Junior School: Baldwin Middle School
  • Middle Or Junior School District: Baldwin

Utilities

Equipment

  • Cooling: Central Air
  • Heating: Baseboard
  • Laundry Features: In Basement
  • Sewer: Public Sewer
  • Utilities: Cable Connected, Electricity Connected, Natural Gas Connected, Sewer Connected, Trash Collection Public, Water Connected
  • Water Source: Other

The data relating to real estate for sale on this website comes in part from the IDX Program of OneKey™ MLS. 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. This information is provided exclusively for consumers’ personal, non-commercial use. Information Copyright 2025, OneKey™ MLS. All Rights Reserved.

Full MLS Disclaimers

Rebate estimate is indicative only and based on listing price and estimated buyer's agent commission paid by owner, if applicable. Final rebates are subject to Terms of Use and may vary due to final negotiated transaction terms.