Active
5274 Columbia Avenue, Hamburg NY 14075
MLS# B1705787
$569,900
Price
5
Beds
3
Baths
2,945
Living Area (Sq.Ft.)
0.429
Lot Area (Acres)
$569,900
Price
5
Beds
3
Baths
2,945
Living Area (Sq.Ft.)
0.429
Lot Area (Acres)
Welcome to 5274 Columbia; a luxury colonial situated on one of the most preeminent streets in Hamburg, steps from Wanakah Country Club with private & deeded waterfront beach access to Lake Erie and incredible views off Beach Drive; your personal and serene oasis. Step out of the cold into the warm vestibule with honeycomb tile & chair rail through French doors into the grand living room with a new brick-surround wood-burning fireplace, custom built-in bookshelves & gorgeous hardwood throughout the first floor. This exquisite home features a luxuriously designed kitchen with high-end, 36” custom Cherry cabinetry with frosted glass accents, Granite counters with an ornate backsplash, Fisher & Paykel chef’s kitchen oven and distinct tile flooring opening to the dining area adorned with windows for an abundance of natural light and three season rm with vaulted ceilings, perfect for sipping your morning coffee. The first floor bedroom makes for ease of living with 4 more bedrooms upstairs, an extra wide hallway, while the additional two bathrooms & 2nd floor laundry is ideal. Step out of the dining nook area that has heated floors to the beautifully refinished, three-tiered wood deck with hot tub & Gazebo, leading down to a brand new, distinctive inground heated pool. Incredible period woodwork & trim accentuate the beauty and craftsmanship of this stunning home & enjoy the newer built, attractive two-car garage and fully-fenced backyard for entertaining. Mere minutes walk to enjoy stunning views of a lakeview paradise with no expense spared on updates including in-ground pool, firepalce, seamless gutters & interior paint 2025, all new gas lines, HWT, Lennox furnace & A/C in 2024, Lorex security system & some electric 2023, tear-off roof 2013 and more. Beautifully appointed & meticulously manicured with showings beginning immediately.
Status
Active
Property Type
Residential
Property Sub Type
SingleFamilyResidence
Year Built
1914
Parcel Number
144889-181-060-0002-020-100
Unit Number
--
Subdivision Name
Holland Land Company's Su
Lot Features
Rectangular, Rectangular Lot, Residential Lot
Levels
Two
Lot Size Dimensions
110X170
Stories
2
Bath Rooms Full
2
Bath Rooms Half
1
Main Level Bathrooms
1
Main Level Bedrooms
1
Property Condition
Resale
Elementary School District
Frontier
Middle Or Junior School
Frontier Middle
Middle Or Junior School District
Frontier
High School
Frontier Senior High
High School District
Frontier
Location
Listing Agent
Joshua James
Listing Office
Keller Williams Realty WNY
Owner Name
--
Owner Phone
--
Possession
CloseOfEscrow
Special Listing Conditions
Standard
Listing Terms
Cash, Conventional, F H A, Va Loan
Listing Agreement
ExclusiveRightToSell
Listing Contract Date
2026-08-12
Fire Places Total
1
Interior Features
Breakfast Bar, Ceiling Fans, Dry Bar, Separate Formal Dining Room, Entrance Foyer, Eat In Kitchen, Separate Formal Living Room, Granite Counters, Natural Woodwork, Bedroom On Main Level, Bath In Primary Bedroom, Main Level Primary, Primary Suite, Programmable Thermostat
Flooring
Hardwood, Tile, Varies
Laundry Features
Upper Level
Fire Place
true
Cooling
true
Cooling Features
CentralAir
Heating
true
Heating Features
Gas, Forced Air, Radiant Floor
Appliances
Appliances Negotiable, Dryer, Dishwasher, Gas Oven, Gas Range, Gas Water Heater, Refrigerator, Washer
Electric
Circuit Breakers
Garage
true
Garage Spaces
2
Architectural Style
Colonial, Two Story, Traditional
Exterior Features
Blacktop Driveway, Fully Fenced, Hot Tub Spa, Pool
Water Source
Connected, Public
Sewer
Connected
Pool Features
InGround
Roof
Architectural, Shingle
Other Structures
PoolHouse
Utilities
Cable Available, Electricity Connected, High Speed Internet Available, Sewer Connected, Water Connected
Parking Features
Detached, Garage, Circular Driveway, Garage Door Opener, Other
Foundation Details
Block
Basement
Full, Sump Pump
Construction Materials
Vinyl Siding, Copper Plumbing
Fencing
Full
Patio And Porch Features
Open, Porch
Spa
true
Information deemed reliable but not guaranteed. IDX data © 2019 REIS MLS. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the REIS MLS. Real estate listings held by brokerage firms and are marked with the Broker Reciprocity logo or the Broker Reciprocity thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Realoq is not a Multiple Listing Service, nor does it offer MLS access. This website is a service of Realoq, a service company Participant of the REIS MLS. Information deemed reliable but not guaranteed. Data updated daily; data last updated .
Digital Millennium Copyright Act (DMCA) Notice
The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA"), provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices and counter-notices should be sent in writing by mail to DMCA Designated Agent.
The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and e-mail address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.
Listed By
Information deemed reliable but not guaranteed. IDX data © 2019 REIS MLS. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the REIS MLS. Real estate listings held by brokerage firms and are marked with the Broker Reciprocity logo or the Broker Reciprocity thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Realoq is not a Multiple Listing Service, nor does it offer MLS access. This website is a service of Realoq, a service company Participant of the REIS MLS. Information deemed reliable but not guaranteed. Data updated daily; data last updated .
Digital Millennium Copyright Act (DMCA) Notice
The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA"), provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices and counter-notices should be sent in writing by mail to DMCA Designated Agent.
The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and e-mail address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.