Property Attributes
- MLS#B1715711
- TypeSingle Family
- Listing Status Active
- CountyERIE
- CityHamburg
- AreaHamburg
- NeighborhoodHolland Land Companys Su
- Zip14075
- StyleColonial
- Year Built1990
- Taxes$ 11722
- Price$ 549,900
- Bedrooms3
- Full Bathrooms2
- Half Bathrooms1
- Sqr Footage2529
- Lot Size0.3238 Acres
Data Source:
Central New York Information Services (CNYIS)
Property Description
Offering timeless curb appeal this brick and vinyl home has an inviting front porch, lush mature landscaping, with an impressive 2529 sq feet of luxury living space! Enter into front foyer that leads to a great room with romantic brick gas fireplace, elegant dining room both with gleaming hardwood floors - the double French doors lead into a perfect home office/den! Lots of architectural details with skylights, tray ceilings, large picture windows. Kitchen is fully appointed with KITCHENAID stainless appliances /work island - convenient first floor laundry and nearby half bath! Upstairs are three generous size bedrooms each having its own walk in closets -the primary bedroom has a private glamour bath consisting of jetted tub plus walk in shower /linen closet. Another full bath off hall has large vanity and another walk in shower! Huge deck off kitchen is done in TREX materials plus an area is covered with a striped canvas awning to offer wonderful entertaining space overlooking a scenic backyard! Showings start immediately and seller desires highest and best offers - no escalation clauses.
| Middle School | High School |
|---|---|
| Frontier Middle | Frontier Senior High |
| Price History | |
|---|---|
| 9/17/2026 | Listed $549,900 |
General Features
| Sewer | Connected |
|---|---|
| Heating | Gas,ForcedAir |
| Cooling | CentralAir |
| Utilities | CableAvailable,ElectricityConnected,SewerConnected,WaterConnected |
| Possession | CloseOfEscrow |
| Roof | Asphalt,Shingle |
| Appliances | Dryer,Dishwasher,ElectricCooktop,GasWaterHeater,Microwave,Refrigerator,Washer |
| HOA Fee | 210.0 |
| Garage Spaces | 2.0 |
| Patio/Porch Features | Deck,Open,Porch |
| Architectural Style | Colonial |
| Construction Materials | Brick,VinylSiding |
| School District | Frontier |
| Year Built | 1990 |
| Electric | CircuitBreakers |
| Stories Count | 2 |
| Township | Not Applicable |
| Levels | Two |
| Property Subtype | SingleFamilyResidence |
| Assoc Fee Paid Per | Annually |
| County | Erie |
| Property Type | Residential |
| Association Amenities | Other,SeeRemarks |
| Attached Garage | Yes |
| Subdivision Name | Holland Land Company's Su |
| Garage Y/N | Yes |
| Total Rooms | 8 |
| Full Baths | 2 |
| Status | Active |
| Directions | Amsdell Road to Country Club Lane - between Rt 20 and Rt 5. |
| High School | Frontier Senior High |
| City | Hamburg |
| Senior Community Y/N | No |
| High School District | Frontier |
| MLS Area | Hamburg-144889 |
| Lot Size Units | Acres |
| Lot Size Square Feet | 14104.0 |
| Year Built Details | Existing |
| Tax Annual Amount | 11722.0 |
| Middle/Junior High School | Frontier Middle |
| Property Condition | Resale |
| Standard Status | Active |
| Middle/Junior School District | Frontier |
| Elementary School District | Frontier |
| Tax Assessed Value | 180000 |
| TaxOtherAnnualAssessmentAmount | 0.0 |
| Tax Lot | 37 |
Interior Features
| Interior Amenities | CeilingFans,EntranceFoyer,EatInKitchen,GreatRoom,KitchenIsland,Pantry,SlidingGlassDoors,NaturalWoodwork |
|---|---|
| Basement | Full,SumpPump |
| Flooring | Carpet,CeramicTile,Hardwood,Varies |
| Total Fireplaces | 1 |
| Total Stories | 2 |
| Basement (Y/N) | Yes |
| Air Conditioning Y/N | Yes |
| Heating Y/N | Yes |
| Fireplace Y/N | Yes |
| Half Baths | 1 |
| Laundry Features | MainLevel |
| Total Bedrooms | 3 |
| Main Level Bathrooms | 1 |
| Total Baths | 3 |
Exterior Features
| Exterior Amenities | Awnings,ConcreteDriveway,Deck |
|---|---|
| Parking Features | Attached,Garage,GarageDoorOpener |
| Lot Features | Rectangular,RectangularLot,ResidentialLot |
| Water Source | Connected,Public |
| Lot Size Area | 0.3238 |
| Foundation Details | Poured |
| Building Area Total | 2529.0 |
| Lot Dimensions | 62X224 |
| Lot Size Acres | 0.3238 |
| Waterfront Y/N | No |
| Door Features | SlidingDoors |
| Road Frontage Type | CityStreet |
| Other Equipment | Generator |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
Property vs Single Family Average in 14075
In The Neighborhood
Newstead
$ 1,100,000
- Type
- Single Family
- Size
- 3,880 SqFt
- Rooms
- 5 Beds + 5.5 Baths
Cheektowaga
$ 249,900
- Type
- Single Family
- Size
- 1,288 SqFt
- Rooms
- 3 Beds + 1 Baths
Amherst
$ 844,900
- Type
- Single Family
- Size
- 3,360 SqFt
- Rooms
- 4 Beds + 2.5 Baths
Tonawanda
$ 469,700
- Type
- Single Family
- Size
- 1,762 SqFt
- Rooms
- 3 Beds + 2 Baths
Amherst
$ 244,900
- Type
- Single Family
- Size
- 1,008 SqFt
- Rooms
- 3 Beds + 1 Baths
Buffalo
$ 189,900
- Type
- Single Family
- Size
- 1,152 SqFt
- Rooms
- 3 Beds + 1 Baths
Cheektowaga
$ 249,900
- Type
- Single Family
- Size
- 1,037 SqFt
- Rooms
- 3 Beds + 1 Baths
Buffalo
$ 199,900
- Type
- Single Family
- Size
- 1,420 SqFt
- Rooms
- 4 Beds + 2 Baths
Lancaster
$ 554,900
- Type
- Single Family
- Size
- 2,050 SqFt
- Rooms
- 4 Beds + 2.5 Baths
Evans
$ 289,900
- Type
- Single Family
- Size
- 1,068 SqFt
- Rooms
- 3 Beds + 1 Baths
Tonawanda
$ 224,900
- Type
- Single Family
- Size
- 1,080 SqFt
- Rooms
- 3 Beds + 1 Baths
Cheektowaga
$ 249,900
- Type
- Single Family
- Size
- 1,445 SqFt
- Rooms
- 3 Beds + 1.5 Baths
The Greater Syracuse Association of REALTORS ®: The data relating to real estate on this web site comes in part from the Internet Data Exchange (IDX) Program of the CNYIS, powered by CNYIS. Real estate listings held by firms other than WNY Metro Roberts Realty, are marked with the IDX logo and detailed information about them includes the Listing Broker's Firm Name. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale,
The data relating to real estate on this web site comes in part from the Internet Data Exchange (IDX) Program of NYSAMLS. Real estate listings held by firms other than WNY Metro Roberts Realty, are marked with the IDX logo and detailed information about them includes the Listing Brokers Firm Name.
Disclaimer: All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. Neither the listing broker(s) nor