HOMESFARMSANDLAND
BuySell
    • Featured Properties
    • Property Showcases
    • Latest Blogs
      • Overview
      • Explore Open Houses
      • Discover Rental Living
      • Escape to Cabin Life
      • Unlock Multi-Family Living
      • Your Perfect Land Awaits
      • Embrace Farm Life
      • Overview
      • Find Rentals
      • Find Cabins
      • Browse Homes
      • Browse Farms
      • Browse Lands
    • Saved Properties
    • Overview
    • Buying Form
    • Buying Process
    • Mortgage Calculator
    • Overview
    • Selling Form
    • Selling Process
    • Free Home Evaluation
      • All of Otsego
      • Cooperstown
      • Oneonta
      • West Oneonta
      • Milford
      • Hartwick
      • Worcester
      • Unadilla
      • Laurens
      • Richfield Springs
      • All of Schoharie
      • Cobleskill
      • Middleburgh
      • Schoharie
      • Sharon Springs
      • Summit
      • Richmondville
      • Esperance
      • All of Chenango
      • Norwich
      • Oxford
      • Greene
      • Bainbridge
      • Sherburne
      • All of Delaware
      • Delhi
      • Stamford
      • Andes
      • Walton
      • Margaretville
      • Roxbury
      • Sidney
      • All of Greene
      • Catskill
      • Windham
      • Hunter
      • Cairo
      • Coxsackie
      • Athens
      • All of Broome
      • Binghamton
      • Vestal
      • Endicott
      • All of Oneida
      • New Hartford
      • Utica
      • Marcy
      • Clinton
      • All of Montgomery
      • Amsterdam
      • Fort Plain
      • Canajoharie
      • Fonda
      • All of Ulster
      • Kingston
      • New Paltz
      • Saugerties
      • Woodstock
      • Marlborough
    • Overview
    • Free Vendor List
    • Practical Guides
    • Need Funding?
    • Property Inspector
    • Down Payment Eligibility
    • Location Sharing?
      • Overview
      • Standard Operating Procedure
      • NYS Buyer-Seller
      • NYS Landlord-Tenant
      • Tenant Rights Notice
      • Fair Housing Notice
      • Privacy Policy
      • Location Services
      • Properties Preferences
      • Map Data Attribution
    • Who We Are
    • Meet the Team
Featured
Featured Properties
Property Showcases
Latest Blogs
Search
Advanced Search
Explore Open Houses
Discover Rental Living
Escape to Cabin Life
Unlock Multi-Family Living
Your Perfect Land Awaits
Embrace Farm Life
Search by Map
Find Rentals
Find Cabins
Browse Homes
Browse Farms
Browse Lands
Saved Properties
Buy
Buying Form
Buying Process
Mortgage Calculator
Sell
Selling Form
Selling Process
Free Home Evaluation
HOMESFARMSANDLAND
  • Otsego
  • Schoharie
  • Chenango
  • Delaware
  • Greene
  • Broome
  • Oneida
  • Montgomery
  • Ulster

Select a county to see cities

Resources
Free Vendor List
Practical Guides
Need Funding?
Property Inspector
Down Payment Eligibility
Location Sharing?
Disclosures
Standard Operating Procedure
NYS Buyer-Seller
NYS Landlord-Tenant
Tenant Rights Notice
Fair Housing Notice
Privacy Policy
Location Services
Properties Preferences
Map Data Attribution
About
Who We Are
Meet the Team

Let's Find Your Next Property.

HOMESFARMSANDLAND.COM

Kevin Lucero

Lic. Real Estate Salesperson

a Charlotteville Realty Team

Independently Owned & Operated

607-282-6242kevin@homesfarmsandland.com

Buying

  • Buying Form
  • Buying Process
  • Mortgage Calculator

Selling

  • Selling Form
  • Selling Process
  • Free Home Evaluation

About Us

  • Who We are
  • Meet the Team

Resources

  • Latest Blogs
  • Free Vendor List
  • PracticalGuides
  • Need Funding?
  • Property Inspector
  • Down Payment Eligibility

Communities

  • Otsego County
  • Schoharie County
  • Chenango County
  • Delaware County
  • Greene County
  • Broome County
  • Oneida County
  • Montgomery County
  • Ulster County

Disclosures

  • Standard Operating Procedure
  • NYS Buyer-Seller
  • NYS Landlord-Tenant
  • Tenant Rights Notice
  • Fair Housing Notice
  • Privacy Policy
  • Location Services
  • Properties Preferences
  • Map Data Attribution

© 2026 Homes, Farms & Land. All rights reserved.

Property at 5222 Columbia Avenue, Hamburg, NY 14075
ACTIVE
0
$699,900

5222 Columbia AvenueHamburg, NY, 14075

3 Beds2.5 Baths2,938 SqFt0.7735 Acres
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 - Offers due Monday 7/6/26 @ 5pm. Seller cannot close before 9/1/26.
1 / 43

Est. Monthly

$3,318/MO

$699,900

5222 Columbia Avenue, Hamburg, NY

3 Beds2.5 Baths2,938 SqFt0.7735 Acres

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 - Offers due Monday 7/6/26 @ 5pm. Seller cannot close before 9/1/26.

StatusActive
Property TypeResidential
Property SubtypeSingle Family Residence
Year Built1911
Total Rooms8 rooms

Est. Monthly Payment

$3,317.51

%
%
yr

Private Mortgage Insurance

Not required

Affordability Checkoptional
$

Enter your annual income to check affordability

Property Details

Property Information

5222 Columbia Avenue

Hamburg, NY 14075 • Erie
3
Beds
2.5
Baths
2,938
SqFt
0.7735
Acres
Status
Active
Property Type
Residential
Property Subtype
Single Family Residence
Year Built
1911115 years ago
Total Rooms
8 rooms
Tax History
Estimated values, may not reflect current amounts.
  • Annual Tax Amount
    $10,300
Property History
  • Listed for sale
    Jun 24, 2026 • NYSAMLS • B1693450
    $699,900
Mortgage Calculator
Estimated monthly payment for this property
$3,317.51
Down Payment
Interest Rate
Loan Term
%
%
yearsyrs.
Affordability Checkoptional
$

Enter your annual income to see if this home fits your budget

Private Mortgage Insurance

Not required — down payment above 20%
MLS Information
  • Source
    NYSAMLS
  • MLS#
    B1693450
  • Listing Office
    HUNT Real Estate Corporation
  • Last Updated
    1 hour ago

Appliances

  • Appliances
    • Dishwasher
    • Free Standing Range
    • Gas Water Heater
    • Microwave
    • Oven
    • Refrigerator

Climate & Systems

  • Heating
    • Gas
    • Forced Air

Interior Features

  • Flooring
    • Carpet
    • Hardwood
    • Varies
  • Doors
    Sliding Doors
  • Basement
    Partial
  • 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

Parking

  • Parking Features
    • Detached
    • Garage
    • Driveway
  • Garage Spaces
    2

Lot & Grounds

  • Lot Size
    0.7735 acres
  • Lot Features
    • Rectangular
    • Rectangular Lot
    • Residential Lot
    • Wooded
  • Patio & Porch
    • Covered
    • Open
    • Patio
    • Porch
  • Exterior Features
    • Concrete Driveway
    • Hot Tub Spa
    • Patio

Type

  • Property Type
    Residential
  • Property Subtype
    Single Family Residence
  • Architectural Style
    • Colonial
    • Two Story
    • Traditional
    • Transitional

Structure

  • Construction
    • Other
    • Vinyl Siding
  • Roof
    Asphalt
  • Foundation
    • Other
    • See Remarks

Condition

  • Year Built
    1911
  • Condition
    Resale
  • Water
    Connected
  • Sewer
    Connected
  • Electric
    Circuit Breakers
  • Utilities
    • Cable Available
    • Electricity Connected
    • Sewer Connected
    • Water Connected

607-282-6242, (607) 282-6242, or +1 607 282 6242

Kevin Lucero

Kevin Lucero

Lic. Real Estate Salesperson

CallEmail
Picked for you

Similar Properties

Handpicked listings that match what you're looking at

View all →
  • 11331 Mckoon Street, Forestport, NY 13338ACTIVE$629,999

    11331 Mckoon Street, Forestport, NY 13338

    5 Beds3 Baths1,718 SqFt0.2879 Acres

    LISTING BY BERKSHIRE HATHAWAY CNY REALTY

  • 38 Hemlock Lane, Erwin, NY 14870ACTIVE$630,000

    38 Hemlock Lane, Erwin, NY 14870

    5 Beds3.5 Baths4,636 SqFt0.77 Acres

    LISTING BY HOWARD HANNA CORNING

  • 53921 State Highway 30, Roxbury, NY 12474ACTIVE$630,000

    53921 State Highway 30, Roxbury, NY 12474

    4 Beds3 Baths2,974 SqFt0.35 Acres

    LISTING BY THE HOLSCHER GROUP

  • 14479 Grossman, Clayton, NY 13624ACTIVE$630,000

    14479 Grossman, Clayton, NY 13624

    4 Beds2 Baths1,416 SqFt2.3 Acres

    LISTING BY FOUR SEASONS SOTHEBY'S INTER.

  • 2 Sunny Knoll Road, Dryden, NY 14850ACTIVE$630,000

    2 Sunny Knoll Road, Dryden, NY 14850

    4 Beds3.5 Baths3,400 SqFt1.61 Acres

    LISTING BY WARREN REAL ESTATE OF ITHACA INC. (DOWNTOWN)

  • 1914 Settle Road, Newark Valley, NY 13811ACTIVE$630,000

    1914 Settle Road, Newark Valley, NY 13811

    5 Beds3.5 Baths2,247,696 SqFt51.6 Acres

    LISTING BY FIRST TIOGA REALTY

  • 2160 Sandridge Road, Alden, NY 14004ACTIVE$631,000

    2160 Sandridge Road, Alden, NY 14004

    3 Beds2.5 Baths1,924 SqFt1.53 Acres

    LISTING BY KELLER WILLIAMS REALTY WNY

  • 16 Katharine Court, Ballston, NY 12019ACTIVE$633,800

    16 Katharine Court, Ballston, NY 12019

    4 Beds2.5 Baths2,399 SqFt0.17 Acres

    LISTING BY ROB MAR REALTY INC

  • 00 Bay Leaf Circle, Lot #107, Ogden, NY 14559ACTIVE$635,000

    00 Bay Leaf Circle, Lot #107, Ogden, NY 14559

    3 Beds2.5 Baths2,151 SqFt0.63 Acres

    LISTING BY HOWARD HANNA

  • 311 Saint Catherines Circle, Ithaca Town, NY 14850ACTIVE$635,000

    311 Saint Catherines Circle, Ithaca Town, NY 14850

    4 Beds3.5 Baths2,730 SqFt0.42 Acres

    LISTING BY WARREN REAL ESTATE OF ITHACA INC.