Skip main navigation
Sold for $999,000
  • $999,000

    174 Delaware Avenue, Freeport, NY 11520

    5beds
    3,800sqft
    Single Family Residence, Residential
    Built in 1954
    9,000 Square Feet Lot
    $1,036,100 Zestimate®
    $263/sqft
    $6,044 Estimated rent

    Home value

    $1,036,100

    $932,000 - $1.15M

    $6,044/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $6,044/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $6,044/mo

    Rent Zestimate®

    Refinance and save

    $6,627/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $6,627/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Generously sized bedroomsFirst-floor primary bedroomHalf bathLaundry facilitiesUtility roomSpacious walk-in closetIn-ground sprinklers
    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!

    Zillow last checked:

    Listing updated:

    Listed by:

    Melinda A. Beauchamp 516-721-7805,

    Douglas Elliman Real Estate 516-669-3700,

    Thomas McKenna MRP 917-378-4221,

    Douglas Elliman Real Estate

    Bought with:

    Gloria Mitchell, 10401359253

    Aventus Real Estate Corp

    Source: OneKey® MLS as distributed by MLS GRID,MLS#: 915915MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 5
    • Full bathrooms: 4
    • 1/2 bathrooms: 1
    Heating
    • Baseboard
    Cooling
    • Central Air
    Appliances
    • Included: Dryer, ENERGY STAR Qualified Appliances, Microwave, Stainless Steel Appliance(s)
    • Laundry: Washer/Dryer Hookup, In Basement
    Features
    • First Floor Bedroom, First Floor Full Bath, Ceiling Fan(s), Double Vanity, Eat-in Kitchen, Entrance Foyer, Formal Dining, Pantry, Primary Bathroom, Master Downstairs, Storage, Walk Through Kitchen
    • Flooring: Combination, Hardwood
    • Basement: Full,Walk-Out Access
    • Attic: Pull Stairs,Unfinished
    • Number of fireplaces: 1
    • Fireplace features: Wood Burning
    Interior area
    • Total structure area: 3,738
    • Total interior livable area: 3,800 sqft

    Property

    Parking
    • Total spaces: 4
    • Parking features: Electric Vehicle Charging Station(s), Garage
    • Garage spaces: 2
    Features
    • Fencing: Back Yard
    Lot
    • Size: 9,000 sqft
    • Features: Back Yard, Front Yard, Near School, Near Shops, Paved, Sprinklers In Front
    Details
    • Parcel number: 2009365210000190
    • Special conditions: None

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    • Property subtype: Single Family Residence, Residential
    Materials
    • Brick, Vinyl Siding
    Condition
    • Updated/Remodeled
    • Year built: 1954

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Other
    • Utilities for property: Cable Connected, Electricity Connected, Natural Gas Connected, Sewer Connected, Trash Collection Public, Water Connected

    Community & neighborhood

    Location
    • Region: Freeport
    • Subdivision: Stearns Park

    Other

    Other facts
    • Listing agreement: Exclusive Right To Sell

    Price history

    DateEventPrice
    2/4/2026Sold$999,000-8.3%$263/sqft
    Source: OneKey® MLS as distributed by MLS GRID #915915 Report a problem
    11/7/2025Pending sale$1,089,000$287/sqft
    Source: OneKey® MLS as distributed by MLS GRID #915915 Report a problem
    9/30/2025Listed for sale$1,089,000+11.2%$287/sqft
    Source: OneKey® MLS as distributed by MLS GRID #915915 Report a problem
    8/7/2025Listing removed$979,000$258/sqft
    Source: OneKey® MLS as distributed by MLS GRID #846322 Report a problem
    5/6/2025Pending sale$979,000$258/sqft
    Source: OneKey® MLS as distributed by MLS GRID #846322 Report a problem
    4/9/2025Listed for sale$979,000+46.1%$258/sqft
    Source: OneKey® MLS as distributed by MLS GRID #846322 Report a problem
    12/23/2020Sold$670,000-1.3%$176/sqft
    Source: OneKey® MLS as distributed by MLS GRID #L3242837 Report a problem
    9/20/2020Price change$679,000-2.9%$179/sqft
    Source: LA Rosa Realty New York LLC #3242837 Report a problem
    8/14/2020Listed for sale$699,000+40.1%$184/sqft
    Source: LA Rosa Realty New York LLC #3242837 Report a problem
    12/3/2019Listing removed$499,000$131/sqft
    Source: LA Rosa Realty New York LLC #3165480 Report a problem
    9/18/2019Listed for sale$499,000+49%$131/sqft
    Source: LA Rosa Realty New York LLC #3165480 Report a problem
    8/8/2019Sold$334,950-12.2%$88/sqft
    Source: Public Record Report a problem
    3/4/2019Pending sale$381,500$100/sqft
    Source: OWNERS.COM #10576139 Report a problem
    2/9/2019Listed for sale$381,500-2.6%$100/sqft
    Source: OWNERS.COM #10576139 Report a problem
    12/18/2018Listing removed$391,700$103/sqft
    Source: REALHome Services and Solutions Report a problem
    12/11/2018Listed for sale$391,700$103/sqft
    Source: REALHome Services and Solutions Report a problem
    11/9/2018Listing removed$391,700$103/sqft
    Source: REALHome Services and Solutions Report a problem
    11/3/2018Price change$391,700-4.8%$103/sqft
    Source: REALHome Services and Solutions Report a problem
    10/5/2018Price change$411,600-4.5%$108/sqft
    Source: REALHome Services and Solutions Report a problem
    9/6/2018Price change$431,200-0.6%$113/sqft
    Source: REALHome Services and Solutions Report a problem
    8/4/2018Price change$433,700-5.5%$114/sqft
    Source: REALHome Services and Solutions Report a problem
    7/20/2018Price change$459,000-10.5%$121/sqft
    Source: REALHome Services and Solutions Report a problem
    7/5/2018Listed for sale$513,040-85.9%$135/sqft
    Source: REALHome Services and Solutions Report a problem
    6/19/2018Sold$3,644,118+659.2%$959/sqft
    Source: Public Record Report a problem
    1/18/2006Sold$480,000+108.7%$126/sqft
    Source: Public Record Report a problem
    3/15/1996Sold$230,000$61/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2024-- $539 -1.1%
    2023-- $545 -3.9%
    2022-- $567
    2021$19,769 -4%--
    2020$20,583 +9.7%$1,304
    2019$18,760 $1,304
    2018$18,760 +6.3%$1,304
    2017$17,653 +2%$1,304
    2016$17,303 +818.5%$1,304
    2015$1,884 +5.8%$1,304
    2013$1,780 +12%$1,304
    2012$1,589 -86.8%$1,304 -2%
    2011$12,037 +2.8%$1,331 -8.1%
    2010$11,714 $1,448 -15.4%
    2009-- $1,711 +4.3%
    2008-- $1,641 +9.5%
    2006-- $1,499 -29.9%
    2005-- $2,138 -40%
    2004-- $3,564 -12.7%
    2003-- $4,084 -39.4%
    2002-- $6,740
    2001-- $6,740
    2000-- $6,740

    Find assessor info on the county website

    Neighborhood: 11520

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Brookside Elementary School
    • Middle: Baldwin Middle School
    • High: Baldwin Senior High School

    Source: OneKey® MLS as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $1,036,100
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $1,036,100