# 415 Columbia Avenue, Depew, NY 14043 > **TL;DR:** 3bd/2ba single family, $280,000 ($205/sqft), built 1990, 1,366 sqft. > A/C, 2-car garage. Est. $1,498/mo. Listed 27 days. ## Property at a Glance | Attribute | Value | |-----------|-------| | Price | $280,000 | | Price/sqft | $205 | | Bedrooms | 3 | | Bathrooms | 2 full | | Square Feet | 1,366 | | Year Built | 1990 | | Lot Size | 13,173 sqft (0.30 acres) | | Stories | 1 | | Garage | 2-car | | Property Type | Single Family (Single Family Residence) | | Status | Pending | | Days on Market | 27 | ## Estimated Monthly Costs | Category | Amount | |----------|--------| | Principal & Interest (20% down, 30-year at 6.5%) | $1,416 | | Estimated Insurance | $82 | | **Total** | **$1,498** | ## Key Amenities - A/C - 2-car garage ## Property Highlights - Built in 1990 - 0.30 acre lot ## Description ### Agent Description Welcome to 415 Columbia Ave! This beautifully maintained three-bedroom, two full bath ranch offers comfortable one-level living and an impressive list of updates! The eat-in kitchen features quartz countertops, luxury vinyl flooring, and a huge eating area, perfect for everyday meals and entertaining. Sliding glass doors open to a spacious, low-maintenance vinyl rear deck that overlooks the huge, fully fenced yard. The home offers a finished basement for additional living space. Central air, a two-car garage, vinyl sided shed, glass block windows, central vacuum, and all the appliances are included! Recent improvements include a whole-house Generac generator (2023), Sunsetter awning (2022), and new garage door opener (2022). With brick & vinyl siding, a spacious yard, and plenty of desirable features, this ranch is move-in ready and offers both comfort and peace of mind. The sale includes three parcels that total .47 acre. Deadline set for offers. No escalation clauses will be considered. Offers must be received by 11am on Tuesday 10/13. ## Location - **Address:** 415 Columbia Avenue, Depew, NY 14043 - **County:** Erie - **Coordinates:** 42.920214, -78.68297 - **Google Maps:** https://www.google.com/maps?q=42.920214,-78.68297 ## Listing Agent - **Name:** Julie L Erler · **License:** 10401203347 - **Brokerage:** WNY METRO ROBERTS REALTY - **Broker Phone:** (716) 891-1710 - **Listing URL:** [View original listing](https://www.realtor.com/realestateandhomes-detail/415-Columbia-Ave_Depew_NY_14043_M34486-11579?f=listhub&s=BNARNY&m=B1720513&c=propsimple) ## Photos ![415 Columbia Avenue - Photo 1](http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f2243529176r.jpg) ![415 Columbia Avenue - Photo 2](http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f4062940310r.jpg) ![415 Columbia Avenue - Photo 3](http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f749392797r.jpg) ![415 Columbia Avenue - Photo 4](http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f2649100837r.jpg) ![415 Columbia Avenue - Photo 5](http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f3754154904r.jpg) ![415 Columbia Avenue - Photo 6](http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f2383207540r.jpg) ![415 Columbia Avenue - Photo 7](http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f682051181r.jpg) ![415 Columbia Avenue - Photo 8](http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f3651202301r.jpg) ![415 Columbia Avenue - Photo 9](http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1005110567r.jpg) ![415 Columbia Avenue - Photo 10](http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1504789910r.jpg) ![415 Columbia Avenue - Photo 11](http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f3486272380r.jpg) ![415 Columbia Avenue - Photo 12](http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1623495730r.jpg) ![415 Columbia Avenue - Photo 13](http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1459135594r.jpg) ![415 Columbia Avenue - Photo 14](http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1845533376r.jpg) ![415 Columbia Avenue - Photo 15](http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1141446544r.jpg) ![415 Columbia Avenue - Photo 16](http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f2572491034r.jpg) ![415 Columbia Avenue - Photo 17](http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1864874315r.jpg) ![415 Columbia Avenue - Photo 18](http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f3717690277r.jpg) ![415 Columbia Avenue - Photo 19](http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f2023051441r.jpg) ![415 Columbia Avenue - Photo 20](http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f15178014r.jpg) ![415 Columbia Avenue - Photo 21](http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f636228516r.jpg) ![415 Columbia Avenue - Photo 22](http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1715750611r.jpg) --- **MLS#:** B1720513 | **Updated:** 2026-11-01 **Source:** listhub *Copyright © 2026 New York State Alliance of MLSs, LLC. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.* [View on PropertySimple](https://www.propertysimple.ai/listing/415-columbia-avenue-depew-ny-14043-261fa708c4754ed2a6752ae9497e12e1) --- ## Structured Data ```json { "@context": "https://schema.org", "@type": "RealEstateListing", "@id": "https://www.propertysimple.ai/listing/415-columbia-avenue-depew-ny-14043-261fa708c4754ed2a6752ae9497e12e1#listing", "url": "https://www.propertysimple.ai/listing/415-columbia-avenue-depew-ny-14043-261fa708c4754ed2a6752ae9497e12e1", "name": "415 Columbia Avenue, Depew, NY 14043", "description": "Welcome to 415 Columbia Ave! This beautifully maintained three-bedroom, two full bath ranch offers comfortable one-level living and an impressive list of updates! The eat-in kitchen features quartz countertops, luxury vinyl flooring, and a huge eating area, perfect for everyday meals and entertaining. Sliding glass doors open to a spacious, low-maintenance vinyl rear deck that overlooks the huge, fully fenced yard. The home offers a finished basement for additional living space. Central air, a two-car garage, vinyl sided shed, glass block windows, central vacuum, and all the appliances are included! Recent improvements include a whole-house Generac generator (2023), Sunsetter awning (2022), and new garage door opener (2022). With brick & vinyl siding, a spacious yard, and plenty of desirable features, this ranch is move-in ready and offers both comfort and peace of mind. The sale includes three parcels that total .47 acre. Deadline set for offers. No escalation clauses will be considered. Offers must be received by 11am on Tuesday 10/13.", "image": [ "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f2243529176r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f4062940310r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f749392797r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f2649100837r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f3754154904r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f2383207540r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f682051181r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f3651202301r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1005110567r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1504789910r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f3486272380r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1623495730r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1459135594r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1845533376r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1141446544r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f2572491034r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1864874315r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f3717690277r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f2023051441r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f15178014r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f636228516r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1715750611r.jpg" ], "primaryImageOfPage": { "@type": "ImageObject", "url": "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f2243529176r.jpg", "caption": "415 Columbia Avenue - Depew, NY" }, "datePosted": "2026-10-07", "dateModified": "2026-11-01T12:21:10.678Z", "mainEntity": { "@type": "Accommodation", "@id": "https://www.propertysimple.ai/listing/415-columbia-avenue-depew-ny-14043-261fa708c4754ed2a6752ae9497e12e1#property", "name": "415 Columbia Avenue, Depew, NY 14043", "address": { "@type": "PostalAddress", "streetAddress": "415 Columbia Avenue", "addressLocality": "Depew", "addressRegion": "NY", "postalCode": "14043", "addressCountry": "US" }, "geo": { "@type": "GeoCoordinates", "latitude": 42.920214, "longitude": -78.68297 }, "image": [ "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f2243529176r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f4062940310r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f749392797r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f2649100837r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f3754154904r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f2383207540r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f682051181r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f3651202301r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1005110567r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1504789910r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f3486272380r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1623495730r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1459135594r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1845533376r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1141446544r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f2572491034r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1864874315r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f3717690277r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f2023051441r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f15178014r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f636228516r.jpg", "http://lh.rdcpix.com/b83469aff938c4722a18041e4408c331l-f1715750611r.jpg" ], "identifier": { "@type": "PropertyValue", "propertyID": "MLS", "value": "B1720513" }, "accommodationCategory": "Single Family Residence", "numberOfBedrooms": 3, "numberOfBathroomsTotal": 2, "numberOfFullBathrooms": 2, "floorSize": { "@type": "QuantitativeValue", "value": 1366, "unitCode": "FTK", "unitText": "square feet" }, "yearBuilt": 1990, "amenityFeature": [ { "@type": "LocationFeatureSpecification", "name": "Heating", "value": "Forced Air, Natural Gas" }, { "@type": "LocationFeatureSpecification", "name": "Cooling", "value": "Central Air" }, { "@type": "LocationFeatureSpecification", "name": "Appliances", "value": "Dryer, ExhaustFan, GasOven, GasRange, GasWaterHeater, Refrigerator, RangeHood, Washer" }, { "@type": "LocationFeatureSpecification", "name": "Flooring", "value": "Vinyl, Varies, Carpet" }, { "@type": "LocationFeatureSpecification", "name": "Construction Materials", "value": "Brick, VinylSiding" }, { "@type": "LocationFeatureSpecification", "name": "Parking Features", "value": "Driveway, Garage" }, { "@type": "LocationFeatureSpecification", "name": "Air Conditioning", "value": true } ], "additionalProperty": [ { "@type": "PropertyValue", "name": "Lot Size", "value": "0.30 acres" }, { "@type": "PropertyValue", "name": "Stories", "value": 1 }, { "@type": "PropertyValue", "name": "Garage Spaces", "value": 2 }, { "@type": "PropertyValue", "name": "Property Subtype", "value": "Single Family Residence" } ] }, "offers": { "@type": "Offer", "@id": "https://www.propertysimple.ai/listing/415-columbia-avenue-depew-ny-14043-261fa708c4754ed2a6752ae9497e12e1#offer", "url": "https://www.propertysimple.ai/listing/415-columbia-avenue-depew-ny-14043-261fa708c4754ed2a6752ae9497e12e1", "price": 280000, "priceCurrency": "USD", "businessFunction": "http://purl.org/goodrelations/v1#Sell", "availability": "https://schema.org/LimitedAvailability", "seller": { "@id": "https://www.propertysimple.ai/listing/415-columbia-avenue-depew-ny-14043-261fa708c4754ed2a6752ae9497e12e1#agent" } }, "provider": { "@type": "Person", "@id": "https://www.propertysimple.ai/listing/415-columbia-avenue-depew-ny-14043-261fa708c4754ed2a6752ae9497e12e1#agent", "name": "Julie L Erler", "worksFor": { "@type": "Organization", "@id": "https://www.propertysimple.ai/listing/415-columbia-avenue-depew-ny-14043-261fa708c4754ed2a6752ae9497e12e1#brokerage", "name": "WNY METRO ROBERTS REALTY", "telephone": "(716) 891-1710", "logo": { "@type": "ImageObject", "url": "http://lh.rdcpix.com/ff808081198602f70119872cf10102c3k-c3243341771r.jpg" } } } } ```