x
Showing 1 of 0
X
Save

247 N Columbus Avenue
Freeport NY 11520 US

$685,000

Active Listing ID 925282
bed icon
4 bed
bath icon
3.00 Bath (3 Full)
lot icon
Lot: 0.15 Acres
home icon
Single Family Residence

$685,000

Active Listing ID 925282
Save

247 N Columbus Avenue Don't miss out on this fantastic opportunity!!! Beautifully maintained 4-bedroom, 3-bathroom cape located in Freeport, NY. A finished basement. LARGE backyard, long expanded driveway to a 2 car detached garage. This is what we call a "sleeper!" A very deceiving front view with So much more to offer and endless opportunities!

Collapse all

Property Features

  • Facts
  • Lot Size: 0.15 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 3
  • Heating Fuels: Baseboard

School Information

  • School
  • Columbus Avenue School(Elementary)
  • John W Dodd Middle School(MiddleSchool)
  • Freeport High School(HighSchool)

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 685000
  • unparsedaddress: 247 N Columbus Avenue
  • postalcity: Freeport
  • stateorprovince: NY
  • country: US
  • postalcode: 11520
  • bathroomsfull: 3
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.1506
  • lotsizeunits: Acres
  • lotsizearea: 0.1506
  • livingarea: 1613
  • livingareaunits: Square Feet
  • latitude: 40.666585
  • longitude: -73.579776
  • listagentfullname: Sandra Clough
  • listagentemail: sanditherealest@gmail.com
  • listagentkey: 3yd-MLSLINY-192864
  • listagentmlsid: 192864
  • listagentpreferredphone: 6465095199
  • listofficekey: 3yd-MLSLINY-QLTY01
  • listofficemlsid: QLTY01
  • disclaimer: Copyright © 2026 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: MLSLINY
  • yearbuilt: 1940
  • listingcontractdate: 2025-10-15
  • listagentfax: 5168673901
  • listagenturl: http://www.qualityhomesrealty.com
  • countyorparish: Nassau County
  • parcelnumber: 2009-55-361-00-1118-0
  • elementaryschool: Columbus Avenue School
  • highschool: Freeport High School
  • elementaryschooldistrict: Freeport
  • middleorjuniorschooldistrict: Freeport
  • highschooldistrict: Freeport
  • appliances: Refrigerator
  • constructionmaterials: Frame
  • heating: Baseboard
  • fireplaceyn: False
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 0
  • parkingfeatures: Driveway
  • waterfrontyn: False
  • franchiseaffiliation: None
  • interiorfeatures: First Floor Bedroom
  • architecturalstyle: Cape Cod
  • rooms: Bedroom 1, Bedroom 4, Bathroom 1, Bedroom 3, Bathroom 3, Bathroom 2, Bedroom 2
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -73.57977, 40.666584
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Weichert Realtors Quality Homes", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"sanditherealest@gmail.com", "ListBrokerageCity":"Baldwin", "ListBrokerageCountry":"US", "ListBrokerageEmail":"qhrrealty@aol.com", "ListBrokerageLogoUrl":null, "ListBrokerageName":"Weichert Realtors Quality Homes", "ListBrokeragePhone":"516-867-3508", "ListBrokeragePostalCode":"11510", "ListBrokerageStateOrProvince":null, "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"1860 Grand Ave", "ListBrokerageWebsiteUrl":"http://www.qualityhomesrealty.com", "ListOfficeAddress1":"2065 Grand Ave ", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"QLTY01", "ListOfficeCity":"Baldwin", "ListOfficeCountry":"USA", "ListOfficeEmail":"qhrrealty@aol.com", "ListOfficePostalCode":"11510", "ListOfficeStateOrProvince":"NY", "ListPriceCurrencyType":"USD", "ListingTitle":"SINGLE_FAMILY - Cape Cod - Freeport, NY", "ListingURL":null, "MLSModificationTimestamp":"2025-11-23 20:09:44", "Neighborhoods":[], "PostalCode":null, "RoomCount":7, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":9828, "TaxDescription":null, "TaxYear":"2025"}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 1/8/2026 6:53:05 PM GMT
Source Updated Date: 1/12/2026 6:48:09 PM GMT

Courtesy of: Sandra Clough, Weichert REALTORS Quality Home, sanditherealest@gmail.com

Copyright © 2026 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.