171 Holland Ave – Opportunity Awaits Near UBS Arena! If you’ve been waiting for the right opportunity to buy below market value and create the home you’ve always wanted, 171 Holland Ave might just be your moment. This 3-bedroom, 2-bath single-family home with a full walkout basement offers far more potential than meets the eye. The lower level already includes another bedroom and full bath setup — perfect for guests, extended family, or future income potential. At roughly 950 square feet on the main level, it’s the perfect size to manage while still offering the space you need to grow. Yes — this one needs work but with vision, patience, and the right financing (a 203k renovation loan is ideal) you’ll have something truly special — a home you designed, in a location that’s hard to beat. Sitting on a double lot, the second parcel currently serves as convenient parking, and there’s even an unfinished pool area ready for your imagination to take over next summer. And the best part? You’re just minutes from UBS Arena — offering world-class entertainment, concerts, and Islanders hockey practically in your backyard, plus easy access to major roadways and transit. Homes in this area rarely come along at this kind of price point — especially ones where you control the upside. Bring your contractor, your ideas, and start building equity from day one.
Listed by James P. Acierno
·
Real Broker NY LLC
·
855-440-0442
Last updated October 21, 2025
·
Source: OneKey #926380
Listing Facts
TypeSingle-family
NeighborhoodElmont
Bedrooms4
Bathrooms3
Days on Prevu4
Taxes$9,463.89/year
Size950 sqft
Price per sqft$579
Amenities
Parking
Swimming Pool
Location
Mortgage Calculator
Listing History
10/20/2025
Listed by Real Broker NY LLC
$550,000
Property Details for 171 Holland Avenue
Exterior
Construction
Property Condition: Fixer
Year Built: 1923
Architectural Style: Bungalow
Construction Materials: Frame
Features
Pool Features: Other
Measurements
Building Area Total: 950
Building Area Units: Square Feet
Lot Size Acres: 0.12
Lot Size Square Feet: 5,200
Financial
Taxes
Parcel Number: 2089-32-438-00-0112-0
Tax Annual Amount: $9,463.89
Tax Assessed Value: $366.00
Tax Year: 2024
Interior
Features
Appliances: Gas Oven
Interior Features: First Floor Bedroom, First Floor Full Bath
Measurements
Living Area: 950
Living Area Source: Other
Rooms
Basement: Full, Walk-Out Access
Has Basement: Yes
Bathrooms Full: 3
Bathrooms Total Integer: 3
Bedrooms Total: 4
Rooms Total: 5
Parking
Parking
Parking Features: Driveway
Schools
Elementary School
Elementary School: Gotham Avenue School
Elementary School District: Elmont
High School
High School: Elmont Memorial High School
High School District: Sewanhaka Central
Middle or Junior School
Middle Or Junior School: Elmont Memorial High School
Middle Or Junior School District: Sewanhaka Central
Utilities
Equipment
Heating: Natural Gas
Sewer: Public Sewer
Utilities: Electricity Connected, Natural Gas Connected, Sewer 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.