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.
Pending
$280,000
415 Columbia Ave, Depew, NY 14043
3beds
1,366sqft
Single Family Residence
Built in 1990
0.3 Acres Lot
$-- Zestimate®
$205/sqft
$-- HOA
What's special
Brick and vinyl sidingSpacious yardCentral airVinyl sided shedHuge fully fenced yardCentral vacuumComfortable one-level living
- 11 days
- 1,813
- 105
Zillow last checked:
Listing updated:
Listed by:
WNY Metro Roberts Realty 716-646-6400,
Julie L Erler 716-646-6400
Source: NYSAMLSs,MLS#: B1720513
Originating MLS: Buffalo
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
- Main level bathrooms: 2
- Main level bedrooms: 3
Bedroom 1
- Level: First
- Dimensions: 12.00 x 12.00
Bedroom 2
- Level: First
- Dimensions: 12.60 x 10.60
Bedroom 3
- Level: First
- Dimensions: 12.00 x 10.00
Kitchen
- Level: First
- Dimensions: 25.60 x 12.00
Living room
- Level: First
- Dimensions: 25.00 x 12.00
Heating
- Gas, Forced Air
Cooling
- Central Air
Appliances
- Included: Dryer, Exhaust Fan, Gas Oven, Gas Range, Gas Water Heater, Refrigerator, Range Hood, Washer
- Laundry: In Basement
Features
- Ceiling Fan(s), Central Vacuum, Separate/Formal Living Room, Pantry, Pull Down Attic Stairs, Quartz Counters, Sliding Glass Door(s), Bedroom on Main Level, Bath in Primary Bedroom, Main Level Primary
- Flooring: Carpet, Luxury Vinyl, Varies
- Doors: Sliding Doors
- Basement: Full,Partially Finished,Sump Pump
- Attic: Pull Down Stairs
- Has fireplace: No
Interior area
- Total structure area: 1,366
- Total interior livable area: 1,366 sqft
Property
Parking
- Total spaces: 2
- Parking features: Attached, Garage, Driveway
- Attached garage spaces: 2
Features
- Levels: One
- Stories: 1
- Exterior features: Concrete Driveway
Lot
- Size: 0.3 Acres
- Dimensions: 92 x 142
- Features: Rectangular, Rectangular Lot
Details
- Additional parcels included: 1452011042400003023100
- Parcel number: 1452011042400003001000
- Special conditions: Standard
- Other equipment: Generator
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Brick, Vinyl Siding
- Foundation: Poured
- Roof: Architectural,Shingle
Condition
- Resale
- Year built: 1990
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Connected
- Water: Connected, Public
- Utilities for property: Electricity Connected, High Speed Internet Available, Sewer Connected, Water Connected
Community & HOA
Location
- Region: Depew
Financial & listing details
- Price per square foot: $205/sqft
- Tax assessed value: $170,000
- Annual tax amount: $8,039
- Date on market: 10/7/2026
- Cumulative days on market: 6 days
- Listing terms: Cash,Conventional,FHA,VA Loan
Estimated market value
Not available
Estimated sales range
Not available
$2,145/mo
Price history
| Date | Event | Price |
|---|---|---|
| 10/14/2026 | Pending sale | $280,000$205/sqft |
Source: | ||
| 10/8/2026 | Listed for sale | $280,000+24944.7%$205/sqft |
Source: | ||
| 10/14/2010 | Sold | $1,118$1/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $170,000 |
| 2024 | -- | $170,000 |
| 2023 | -- | $170,000 |
| 2022 | -- | $170,000 |
| 2021 | -- | $170,000 |
| 2020 | -- | $170,000 +26.9% |
| 2019 | -- | $134,000 |
| 2018 | -- | $134,000 |
| 2017 | $2,958 +125.9% | $134,000 |
| 2016 | $1,310 | $134,000 |
| 2015 | -- | $134,000 |
| 2014 | -- | $134,000 |
| 2013 | -- | $134,000 |
| 2012 | -- | $134,000 |
| 2011 | -- | $134,000 |
| 2010 | -- | $134,000 -2.9% |
| 2009 | -- | $138,000 |
| 2008 | -- | $138,000 |
| 2007 | -- | $138,000 |
| 2006 | -- | $138,000 +14% |
| 2005 | -- | $121,000 +27.4% |
| 2004 | -- | $95,000 |
| 2003 | -- | $95,000 |
| 2002 | -- | $95,000 |
| 2001 | -- | $95,000 |
| 2000 | -- | $95,000 |
Find assessor info on the county website
Monthly payment
Climate risks
Neighborhood: 14043
Nearby schools
Schools provided by the listing agent
- District: Depew
Source: NYSAMLSs. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.





