- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes
$489,900
Monthly Est:$2,438
3 Beds
3 Baths2 full baths + 1 half bath
2,938sqft
5222 Columbia Ave, Hamburg, NY 14075
$489,900
$2,438/moEst:
Get Pre-Approved
Single Family Residence
Built in 1911
$-- HOA
0.77 acre lot
$167/sq.ft
Description
Welcome to this exceptional residence where timeless elegance meets modern comfort! From the moment you enter you'll be captivated by the nearly 3000 Sq Ft of architectural details. Gleaming hardwood floors throughout 1st Floor-custom windows-crafted trim work-built in cabinetry. The remodeled kitchen showcases exotic granite counters, generous size breakfast bar plus island and all appliances stay! Stylish glass door accents-wine chiller-cool trendy lights and fans!
Open concept family room has a contemporary feel - w/ gas fireplace w/granite hearth-entertaining continues in formal dining room w/custom paint & texture treatment applied to walls-adjacent is a luxurious covered "pillared" veranda bordered by lush ferns and a privacy fence. The 30x15 front living room has a newer stunning "picture" window, gas fireplace and features a grand entrance coming from front concrete porch. Three lovely bdrms on second floor with a convenient 2nd floor laundry. The primary suite has its own bath and incredible home office. The office has a panoramic view of picturesque backyard! This yard is an outdoor retreat with a large patio - outdoor fireplace and a fun filled hot tub! Party size concrete drive parks 20+ cars! Garage has newer overhead doors. Deeded beach rights! Seller desires highest and best, no escalation clauses.
Sellers offering a one year home warranty giving you "Peace of Mind" against unexpected cost.
- Houzeo last checked: 3 minutes ago
- Listing updated: October 13, 2026 at 4:40 pm
- Listing Provided by: Patricia Manns (716) 870-2426 DRE #40MA0761139 | HUNT Real Estate ERA (716) 648-2300
- Source: New York State Alliance of MLSs, Buffalo-NY | MLS#: B1693450
Property Details
Status
Pending
Type
Single Family Residence
No. of Stories
2
County
City
Neighborhood
--
Year Built
1911
HOA Fees
-
Finished Area
2,938 sqft
Lot Size
0.77 acre lot
Basement Area
- sqft
MLS Name
New York State Alliance of MLSs, Buffalo
MLS Number
B1693450
MLS Status
Pending
Days on Market
132
Cumulative Days on Market
104
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 3
Bathrooms: 3
MediaRoom
Level: Second
Area: 176.00 Square Feet
Dimensions: 16.00 x 11.00
LivingRoom
Level: First
Area: 450.00 Square Feet
Dimensions: 30.00 x 15.00
Laundry
Level: Second
Area: 80.00 Square Feet
Dimensions: 10.00 x 8.00
FamilyRoom
Level: First
Area: 240.00 Square Feet
Dimensions: 16.00 x 15.00
DiningRoom
Level: First
Area: 168.00 Square Feet
Dimensions: 14.00 x 12.00
Bedroom3
Level: Second
Area: 210.00 Square Feet
Dimensions: 15.00 x 14.00
Bedroom2
Level: Second
Area: 264.00 Square Feet
Dimensions: 22.00 x 12.00
Bedroom1
Level: Second
Area: 242.00 Square Feet
Dimensions: 22.00 x 11.00
Interior
Appliances
Dishwasher, Free Standing Range, Gas Water Heater, Microwave, Oven, Refrigerator
Exterior Features
Concrete Driveway, Hot Tub Spa, Patio
Interior Features
Breakfast Bar, Separate Formal Dining Room, Entrance Foyer, Eat In Kitchen, Separate Formal Living Room, Home Office, Country Kitchen, Pull Down Attic Stairs, Sliding Glass Doors
Flooring
Carpet, Hardwood, Varies
Cooling
Central Air
Heating
Gas, Forced Air
Sewer
Connected
Construction
Year Built
Year Built: 1911
Home type
Single Family Residence
Architectural Style
Colonial, Two Story, Traditional, Transitional
Construction Materials
Other, Vinyl Siding
Roof
Asphalt
Foundation Details
Other, See Remarks
Property Condition
Resale
Utilities & Energy
Utilities
Cable Available, Electricity Connected, Sewer Connected, Water Connected
Parking Features
Detached, Garage, Driveway
Basement
Partial
Laundry Features
Upper Level
Electric
Circuit Breakers
Water Source
Connected, Public
Other Features
Patio And Porch Features
Covered, Open, Patio, Porch
Lot Features
Rectangular, Rectangular Lot, Residential Lot, Wooded
Price History
| Date | Event | Price |
|---|---|---|
10/13/2026 Source: | Pending | $489,900 $167/sqft |
10/05/2026 Source: | Listed for Sale | $489,900 -16.24% $167/sqft |
09/17/2026 Source: | Off Market | $584,900 -2.50% $199/sqft |
07/20/2026 Source: | Price Decreased | $599,900 -7.69% $204/sqft |
07/13/2026 Source: | Listed for Sale | $649,900 $221/sqft |
Show more
Nearby Homes
Find Homes by Property Features in Hamburg, NY
Nearby New Homes For Sale
Based on data from the New York State Alliance of MLSs (CNYIS, Inc., UNYREIS and WNYREIS) through Nov 04, 2026, 06:45AM.. All information is provided exclusively for consumers’ personal, non-commercial use. It may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable by is not guaranteed accurate by the MLS. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. All information provided is deemed reliable but is not guaranteed and should be independently verified. © 2026 the New York State Alliance of MLSs. All Rights Reserved.
Advertising Broker: Derek Greene | The Greene Realty Group
