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.
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.