BEDS3
BATHS2 full 1 partial
SQUARE FEET2,938
MLS#B1693450
STATUSActive
PROPERTY TYPEResidential - Single Family
SCHOOLFrontier
Property 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.
Property Features
Property Type: Residential - Single Family
Basement: Partial
Cooling: Central Air
Fireplaces: 2
Garage: 2
Heating: Gas, Forced Air
Home Style: Colonial, Two Story, Traditional, Transitional
Lot Size: 0.77 Acres
Roof Type: Asphalt
Stories: 2.0
Taxes: $10,300
Year Built: 1911
Amenities
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 Door(s)
Concrete Driveway
Hot Tub/Spa
Patio
Feature Descriptions
Appliances: Dishwasher, Free-Standing Range, Gas Water Heater, Microwave, Oven, Refrigerator
Days on Site: 31
Door Features: Sliding Doors
Exterior: Other, Vinyl Siding
Flooring: Carpet, Hardwood, Varies
Hot Tub: Yes
Laundry: Upper Level
Lot: Rectangular, Rectangular Lot, Residential Lot, Wooded
Lot Dimensions: 100X336
Parcel#: 144889-181-060-0002-017-000
Parking: Detached, Garage, Driveway
Parking Notes: Detached, Garage, Driveway
Patio/Porch: Covered, Open, Patio, Porch
Sewer: Connected
Spa: Yes
Utilities: Cable Available, Electricity Connected, Sewer Connected, Water Connected
Water: Connected, Public
Local Schools
High School: Frontier Senior High
Middle School: Frontier Middle
Elementary School: Pinehurst Elementary
School District: Frontier
Listed By / Shown By
Listing By
Agency Name: HUNT Real Estate Corporation
Agency Contact: 716-870-2426
Shown By
Agency Title: Coldwell Banker Choice Properties
Agency Phone: 833-88-CHOICE (2-4642)
Estimate Your Payment
Estimated Payment
$ 2,368.42 per month $1,335.12 Principal & Interest $858.33 Property Tax $174.97 Homeowner's InsuranceChange Payment Information
Broker Headquarters, 621 Columbia St. Suite 800, Cohoes, NY 12047
Disclaimer:
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 07/25/2026. The listing information on this page last changed on 07/25/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of SMART MLS (last updated Fri 07/24/2026 10:58:46 PM EST) or New York State Alliance MLS (last updated Sat 07/25/2026 12:07:03 AM EST) or Hudson Valley Catskill Region MLS (last updated Sat 07/25/2026 12:01:14 AM EST) or My State MLS (last updated Fri 07/24/2026 11:30:10 PM EST) or Berkshire MLS (last updated Fri 07/24/2026 8:13:08 PM EST) or OneKey MLS (last updated Sat 07/25/2026 12:07:30 AM EST) or (last updated Sat 07/25/2026 12:09:13 AM EST). Real estate listings held by brokerage firms other than Coldwell Banker Choice Properties may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.
Privacy Policy / DMCA Notice / ADA Accessibility
Privacy Policy / DMCA Notice / ADA Accessibility
This site is hosted, designed and copyright
© 1994 - 2026 by
Delta Media Group, Inc. -- Patent Pending --
Coldwell Banker® and the Coldwell Banker Logo are registered service marks owned by Coldwell Banker Real Estate LLC. C.B. Choice Properties, INC. fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Each franchise is independently owned and operated. Any services or products provided by independently owned and operated franchisees are not provided by, affiliated with or related to Coldwell Banker Real Estate LLC nor any of its affiliated companies.
5222 Columbia Avenue | MLS# B1693450
This single family home located at 5222 Columbia Avenue, Hamburg, NY 14075 is currently listed for sale with an asking price of $599,900. This property was built in 1911 and has 3 bedrooms and 2 full and 1 partial baths with 2938 sq. ft. Columbia Avenue is located within the Frontier school district. Search Hamburg real estate on www.coldwellbankerchoice.com today.