Welcome to this three-bedroom, one-bath colonial set deep within the quiet, peaceful community of Hamilton Beach. The first floor offers a foyer, eat-in kitchen, updated bathroom, spacious living room, and a flexible bedroom/den space. Upstairs you’ll find two additional bedrooms and a very generous walk-up attic with endless possibilities. While the home could use some finishing touches and handyman updates, the kitchen and bathroom were modernized a little over ten years ago, giving you a strong head start. Limited interior photos are available, but with some clean-up and vision this home can truly shine. A wonderful opportunity to create your dream waterfront retreat in one of Howard Beach’s most serene neighborhoods.
All agent remarks deemed reliable, but to be independently verified by buyers.
Listed by Brina Ciaramella
·
Esquire Realty Ciaramella & Co
·
917-257-1584
Last updated October 23, 2025
·
Source: OneKey #920712
Listing Facts
TypeSingle-family
NeighborhoodHoward Beach
Bedrooms3
Bathrooms1
Days on Prevu21
Taxes$2,172/year
Size1,000 sqft
Price per sqft$459
Location
Mortgage Calculator
Listing History
10/03/2025
Listed by Esquire Realty Ciaramella & Co
$459,000
Estimated Closing Costs
Total
$18,175
Attorney Fees
$4,000
Title Insurance
$2,066
Bank Attorney
$1,500
Mortgage Recording Tax
$6,609
Other Closing Costs
$4,000
Estimated closing costs are based on the list price of $459,000 and a 20% downpayment. These estimates are for indicative purposes only. Actual closing costs may vary for each transaction. See the Closing Costs Calculator for calculations specific to your situation.
Property Details for 5 Bayview Avenue
Exterior
Construction
Year Built: 1920
Architectural Style: Colonial
Construction Materials: Vinyl Siding
Features
Waterfront Features: Bulkhead, Canal Access
Waterfront: Yes
Measurements
Building Area Total: 1,000
Building Area Units: Square Feet
Lot Size Acres: 0.03
Lot Size Square Feet: 1,600
Financial
Taxes
Parcel Number: 14228-0752
Tax Annual Amount: $2,172.00
Tax Year: 2025
Interior
Features
Appliances: Oven, Refrigerator
Interior Features: First Floor Bedroom
Measurements
Living Area: 1,000
Living Area Source: Other
Rooms
Bathrooms Full: 1
Bathrooms Total Integer: 1
Bedrooms Total: 3
Rooms Total: 7
Other
Location
Tax Block: 14228
Tax Lot: 752
Parking
Parking
Parking Features: On Street
Schools
Elementary School
Elementary School: Ps 146 Howard Beach
Elementary School District: Queens 27
High School
High School: John Adams High School
High School District: Queens 27
Middle or Junior School
Middle Or Junior School: Jhs 202 Robert H Goddard
Middle Or Junior School District: Queens 27
Utilities
Equipment
Cooling: Wall/Window Unit(s)
Heating: Baseboard
Sewer: Public Sewer
Utilities: Electricity Connected, Natural Gas Connected
Water Source: Public
The data relating to real estate for sale on this website comes in part from the IDX
Program of OneKey™ MLS. 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. This information is provided exclusively for consumers’ personal,
non-commercial use. Information Copyright 2025, OneKey™ MLS. All Rights Reserved.
Rebate estimate is indicative only and based on listing price and estimated buyer's agent commission paid by owner, if applicable. Final rebates are subject to Terms of Use and may vary due to final negotiated transaction terms.
