- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around





Street View
$899,000
Monthly Est:$4,475
5 Beds
- 4 Baths
4 full baths
2,191sqft
74 W Hoffman Ave, Babylon, NY 11757
$899,000
$4,475/moEst:
Get Pre-Approved
Duplex
Built in 1940
$-- HOA
5,000 sqft lot
$410/sq.ft
Description
Rare Lindenhurst Mixed-Use Opportunity — Residential, Commercial & Income Potential
Seeing is believing! Properties with this combination of space, versatility, zoning, and location are exceptionally rare. This unique Lindenhurst property offers an incredible opportunity for an owner-occupant, investor, business owner, or anyone looking to create multiple income streams under one roof.
The legal (2 Family) duplex offers two distinct residential living spaces:
First Floor: Spacious kitchen, living room, dining room, 2 bedrooms, and a full bath, with an unfinished basement offering additional storage and future possibilities.
Second Floor: An impressive layout featuring 3 bedrooms, an office, kitchen/eating area, living room, and 2 full baths — providing exceptional flexibility for extended living, rental income, or multi-generational use.
And then comes the unbelievable surprise in the rear!
Behind the residential portion is approximately 1,100 square feet per floor across two floors, creating roughly 2,200 additional square feet of warehouse/office-type space. Whether you're envisioning offices, a workshop, storage, studio space, a business operation, additional income-producing space, or another permitted use, the possibilities are extensive.
Zoned for both residential and commercial use, this is the kind of property that gives you options that simply aren't available with an ordinary home or traditional commercial building.
* Being Sold As Is *
- Houzeo last checked: 12 minutes ago
- Listing updated: October 17, 2026 at 6:39 pm
- Listing Provided by: Viola Schineller (516) 808-1457 | BH&G R E Realty Connect (516) 799-7999
- Source: OneKey MLS-NY as distributed by MLS GRID | MLS#: 1047312

Property Details
Status
Active
Type
Multi Family
No. of Stories
-
County
City
Neighborhood
--
Year Built
1940
HOA Fees
-
Finished Area
2,191 sqft
Lot Size
5,000 sqft lot
Basement Area
- sqft
MLS Name
OneKey MLS
MLS Number
1047312
MLS Status
Active
Days on Market
70
Cumulative Days on Market
39

Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 5
Bathrooms: 4
Interior
Cooling
None
Interior Features
First Floor Bedroom, First Floor Full Bath, Eat In Kitchen
Sewer
Public Sewer
Heating
Baseboard
Construction
Year Built
Year Built: 1940
Home type
Duplex
Architectural Style
Colonial
Construction Materials
Aluminum Siding
Utilities & Energy
Water Source
Public
Basement
Full, Unfinished
Parking Features
Driveway, On Street
Utilities
Electricity Connected, Natural Gas Connected, Water Connected
Price History
| Date | Event | Price |
|---|---|---|
09/28/2026 Source: | Price Decreased | $899,000 -5.27% $410/sqft |
09/08/2026 Source: | Listed for Sale | $949,000 $433/sqft |
09/08/2026 Source: | Price Increased | $949,000 +39441.67% $433/sqft |
08/26/2025 Source: | Listing Removed | $2,400 $1/sqft |
08/16/2025 Source: | Listed for Sale | $2,400 $1/sqft |
Show more
Find Homes by Property Features in Babylon, NY
Based on information from OneKey MLS® through Nov 18, 2026, 03:46AM as submitted to and distributed by MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. IDX information is provided exclusively for consumers’ personal non-commercial use. It may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed by MLS GRID. The use of the MLS GRID Data may be subject to an end-user license agreement prescribed by the Member Participant’s applicable MLS, if any, and as amended from time to time. © 2026 OneKey MLS. All rights reserved.
Advertising Broker: Derek Greene | The Greene Realty Group
