grar-logo
  • Buy
  • Rent
  • Commercial
  • Find a REALTOR®
    Price range
    $
    $
    Bedrooms
    Bathrooms
    Home type
    Square feet
    Lot size
    Heating
    Cooling
    Parking spots
    Garage
    Basement
    Year built
    Max HOA
    Tours
    1 home
      1 home available
      5274 Columbia Avenue, Hamburg, NY 14075
      Pending
      5274 Columbia Avenue, Hamburg, NY 14075
      $579,900
      5beds
      2.5bath
      2,945sqft
      0.43acres
      House for Sale

      5274 Columbia Avenue, Hamburg, NY 14075

      Listing by: Keller Williams Realty WNY
      1 - 1 of 1 results
      © 2025 Greater Rochester Association of REALTORS®. All Rights Reserved.
      Display of MLS Data is usually deemed reliable but is NOT guaranteed accurate by the MLS. Buyers are responsible for verifying the accuracy of all information and should investigate the data themselves or retain appropriate professionals.
      Equal opportunity
      Membio
      grar-logo
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      5274 Columbia Avenue, Hamburg, NY 14075
      Pending
      $579,900
      5beds
      2full,1half bath
      2,945sqft
      0.43acres

      5274 Columbia Avenue, Hamburg, NY 14075

      City/Town:Hamburg   Post Office: Hamburg     

      House for Sale by Joshua JamesKeller Williams Realty WNY.

      Data checked -. Listing last updated 38 days ago.
      1. Overview
      2. Details
      3. More 

      Welcome to 5274 Columbia; a luxury colonial situated on one of the most preeminent streets in Hamburg, steps from backing to Wanakah Country Club with private & deeded waterfront beach access to Lake Erie with incredible views off Beach Drive; your private 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 wood built-in bookshelves & gorgeous hardwood throughout the first floor. This exquisite home features a luxuriously designed kitchen with high-end, 36” custom Cherry cabinetry w/frosted glass, Granite counters w/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. First floor bedroom makes for ease of living with 4 more bedrooms upstairs, extra wide hallway, an additional two bathrooms & 2nd floor laundry is ideal. Step out the eat-in kitchen area w/heated floors to the beautifully redone, 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 the lakeview paradise with no expense spared on updates including pool, FP, 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 starting 2/11/26.

      Internet Serviceability
      Details
        Property type
      Residential
        Year built
      1914
        Heating
      Gas, Forced Air, Radiant Floor
        Cooling
      Central Air
        Total rooms
      14
        Garage
      Yes (2 space)
        City/Town
      Hamburg
        Post Office
      Hamburg
        Parking spots
      -
      B1660978
      MLS ID
      Pending
      Status
      02-06-2026
      On market date
      Levels  Levels
      Two
        Roof
      Architectural,Shingle
        Laundry features
      Upper Level
        Fireplace
      Yes
        Pets allowed
        Architectural Style
      Colonial, Two Story, Traditional
        Basement
      Full, Sump Pump
      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
      Exterior features
      Blacktop Driveway, Fully Fenced, Hot Tub Spa, Pool
      Lot features
      On Golf Course, Rectangular, Rectangular Lot, Residential Lot
      Appliances included
      Appliances Negotiable, Dryer, Dishwasher, Gas Oven, Gas Range, Gas Water Heater, Refrigerator, Washer
      Construction materials
      Vinyl Siding, Copper Plumbing
      Flooring
      Hardwood, Tile, Varies
      Utilities
      Water source
      Parking features
      Monthly taxes
      $846
      Yearly taxes
      $10,153
      School district
      Frontier
      Schools
      Frontier Middle, Frontier Senior High
      Senior community
      No
      HOA
      -
      HOA Amentities
      Open Houses
      In-Person
      No upcoming in-person open houses
      Virtual
      No upcoming virtual open houses
      Contact Agent
      Joshua James
      Joshua James
      NY Licensed Assoc. R.E. Broker, Keller Williams Realty WNY
       
       
      Location
      Take Lake Shore Road going south. Turn left onto Columbia Avenue. House will be on the right.
      For Sale Nearby
      No nearby homes are For Sale Nearby.
      Recently Sold
      No nearby homes have been Recently Sold.
      5274 Columbia Avenue, Hamburg, NY 14075, is a 5 bedroom, 2 bathroom, 2945 sqft. Single Family Residence built in 1914. This property is currently available for sale and was listed on Greater Rochester Association of REALTORS® on 2-5-2026. The MLS# for this Single Family Residence is MLS# B1660978.
      Display of MLS Data is usually deemed reliable but is NOT guaranteed accurate by the MLS. Buyers are responsible for verifying the accuracy of all information and should investigate the data themselves or retain appropriate professionals.
      Copyright ©2026 Greater Rochester Association of REALTORS®