• buy
  • rent
  • sell
  • agents
new developmentWORLD OF ELLIMAN
The latest in luxury property, lifestyle & culture, curated just for you.

company

  • about us
  • leadership
  • offices
  • press & news
  • elliman cares
  • join as an agent
  • careers
  • INTERNATIONAL PARTNERSHIP
  • investors

resources

  • WORLD OF ELLIMAN
  • elliman insider
  • magazines
  • market reports
  • research reports
  • Elliman Exclusives
  • Featured Cities
  • guides to buying & selling

brand portfolio

  • new development
  • commercial
  • relocation
  • property management
  • sports & entertainment
  • farm & ranch
  • building broker specialists
  • title services
  • master trust & probate

  • California
  • Colorado
  • Connecticut
  • Florida
  • Massachusetts
  • Mid-Atlantic
  • Nevada
  • New Jersey
  • New York
  • New York City
  • Texas
  • Vermont
  • SITE MAP
  • TERMS
  • PRIVACY
  • COOKIE PREFERENCES
  • DO NOT SELL OR SHARE MY PERSONAL INFORMATION
  • NYS Housing Discrimination Disclosure Notice & Form
  • NYS Standard Operating Procedure
  • NYS Tenants' Rights to Reasonable Accommodations for persons with disabilities
  • California Consumer Privacy Act Notice
  • Texas Consumer Protection Notice
  • Texas Real Estate Commission Information About Brokerage Services
  • text of new york city human rights law
  • new york city commission on human rights
  • nyc source of income discrimination information
  • nyc source of income discrimination tenant faqs

THE SOURCE OF THE DISPLAYED DATA IS EITHER THE PROPERTY OWNER OR PUBLIC RECORD PROVIDED BY NON-GOVERNMENTAL THIRD PARTIES. IT IS BELIEVED TO BE RELIABLE BUT NOT GUARANTEED. FOR COLORADO VIEWERS, INFORMATION ABOUT NON-COMMERCIAL PROPERTIES IS PROVIDED EXCLUSIVELY FOR YOUR PERSONAL, NON-COMMERCIAL USE.

575 MADISON AVENUE, NEW YORK, NY 10022. 212.891.7000 © 2025 DOUGLAS ELLIMAN REAL ESTATE. EQUAL EMPLOYMENT OPPORTUNITY PROVIDER. ALL MATERIAL PRESENTED HEREIN IS INTENDED FOR INFORMATION PURPOSES ONLY. WHILE THIS INFORMATION IS BELIEVED TO BE CORRECT, IT IS REPRESENTED SUBJECT TO ERRORS, OMISSIONS, CHANGES, OR WITHDRAWAL WITHOUT NOTICE. ALL PROPERTY INFORMATION, INCLUDING, BUT NOT LIMITED TO SQUARE FOOTAGE, ROOM COUNT, NUMBER OF BEDROOMS, AND THE SCHOOL DISTRICT IN PROPERTY LISTINGS SHOULD BE VERIFIED BY YOUR OWN ATTORNEY, ARCHITECT, OR ZONING EXPERT. EQUAL HOUSING OPPORTUNITY.LISTING DATA REFRESHED ON JUL 21 2025 AT 5:41 AM.

DOUGLAS ELLIMAN IS A LICENSED REAL ESTATE BROKER IN CALIFORNIA WITH LICENSE # 01947727, COLORADO WITH LICENSE # EC100053892, CONNECTICUT WITH LICENSE # REB.0314827, THE DISTRICT OF COLUMBIA WITH LICENSE # REO40000160, FLORIDA WITH LICENSE # CQ1020232, MARYLAND WITH LICENSE # 645270, MASSACHUSETTS WITH LICENSE # 422764, NEVADA WITH LICENSE # 1454643, NEW JERSEY WITH LICENSE # 0572105, NEW YORK WITH LICENSE # 10991211812, TEXAS WITH LICENSE # 9008706, AND VIRGINIA WITH LICENSE # 0226035659.

POWERED BY PURLIN.AI

3747 Columbia St

hamburg, NY 14075

$247,000

  • 3 BR
    2 BA
    APPROX. 1,480 SF
  • sold

INTERESTED? LET'S CONNECT

CHARMING SPLIT-LEVEL HOME ON SPACIOUS LOT IN FRONTIER SCHOOL DISTRICT!
Welcome to this Well-Maintained Split-Level Home, offering a perfect blend of comfort and convenience in the highly sought-after Frontier School District. Situated on a spacious corner lot, this home features three generous bedrooms on the upper level, along with a full bath for added convenience. The eat-in kitchen comes fully equipped with all appliances included, making meal prep a breeze. The huge lower level boasts stunning laminate flooring, providing a versatile space for a family room, home office, or entertainment area. A second full bath on this level adds functionality and convenience. Enjoy outdoor living with plenty of yard space, perfect for gardening, entertaining, or simply relaxing. Updates include: New Vinyl Siding & Trim 2024, Family Room Laminate Floor 2020, New Sump Pump w/Battery Backup 2024, Washer, Dryer & Refrigerator 2020, Dishwasher 2022, Screen Door 2023. Some photos virtually staged to showcase potential. With its convenient location, ample living space, and move-in-ready condition, this home is a must-see! Don’t miss your chance—schedule an appointment today!

Details

1,480 Sq Ft

7,705 Sq Ft Exterior Space

Single Family Home

$5,123 Annual Tax

Built in 1964

MLS/Listing ID B1592956

1 Stories

Amenities & Features

Shingle

Drapes

Patio

Parking - Attached

Parking - Driveway

Parking - Garage

Parking - Garage Door Opener

Lot - Near Public Transit

In Basement

Eat-in Kitchen

Pantry

Programmable Thermostat

Window Treatments

Blown-in Insulation

Heating - Baseboard

Heating - Gas

Heating - Zoned

Ceramic Tile

Hardwood

Laminate

Cooling - Zoned

Construction - Attic Crawl Hatchways Insulated

Construction - Brick

Construction - Copper Plumbing

Construction - Vinyl Siding

Style - Split Level

Dishwasher

Double Oven

Dryer

Gas Cooktop

Gas Water Heater

Refrigerator

Washer

Low Threshold Shower

DEBORAH A SCOTT - 716-316-4285

NYS

Source of Data: NEW YORK STATE MLS

Interested in 3747 Columbia St?