Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1874 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1874 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1874 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

241,247+ Albany Avenue
Babylon, NY 11701
Richard Matt Shane with All Island Estates Realty Corp, original listing - (516) 783-5600

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,188,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: All Island Estates Realty Corp
Agency Phone: (516) 783-5600

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Commercial Sale-Mixed Use
Year Built: --
Notes: Calling All Investors, Developers & End-Users!!! 92,930+ Sqft. Development Site Just Off Sunrise Highway For Sale!!! The Buildings Feature Great Exposure, Excellent Signage, 8 Lots, 184 Parking Spaces, High Ceilings, Strategically Placed Curb Cuts, A/C, All New LED Lighting, 200 Amp Power, +++!!! The Properties Have 300+ Feet Of Frontage On Albany Ave.!!! Neighbors Include Starbucks, Mercedes-Benz, Kia, Nissan, 7-Eleven, Northwell Health, Target, The Home Depot, QuickChek, Extra Space Storage, Dunkin', Walgreens, CityMD, Valero, Taco Bell, McDonald's, Checkers, KFC, Burger King, Red Lobster, Dollar Tree, +++!!! The Entire Property Can Be Delivered Vacant If Need Be. This Property Offers HUGE Upside Potential!!! This Could Be Your Next Development Site Or The Next Home For Your Business!!! Income: 241-243: 3 Unit Mixed-Use Building Barbershop: $19,800 Ann. M-M (Delivered Vacant) Salon: $20,400 Ann. M-M (Delivered Vacant) 1 Br Apartment: $26,400 Ann. M-M (Delivered Vacant) 249: 8 Br., 2 Bath House: $72,000 Ann. M-M (Delivered Vacant) 251: Legal 2 Family House 1st Floor 3 Br Apt.: $42,000 Ann. (Delivered Vacant) 2nd Floor 2 Br Apt. $33,600 Ann. (Delivered Vacant) 253: Vacant Lot: $48,000 (Delivered Vacant) 261: Legal 2 Family House 1st Floor (2 Br. Apt.): $30,000 Ann. M-M (Delivered Vacant) 2nd Floor (2 Br. Apt.): $30,000 Ann. M-M (Delivered Vacant) 267: Parking for Various Trucks: $24,000 Ann. M-M. (Delivered Vacant) Pro Forma Gross Income: $346,200 Ann. Expenses: Gas: $0 Electric: $0 Insurance: $2,842 Ann. Taxes: $40,777 Ann. Total Expenses: $43,619 Ann. Net Operating Income (NOI): $302,581 Ann. (Pro Forma 13.83 Cap!!!) , or
MlsNumber: --
ListingId: L3590743


Listing Provided By: All Island Estates Realty Corp, original listing
Phone: (516) 279-8828
Office Phone: (516) 783-5600
Agent Name: Richard Matt Shane
Disclaimer: Copyright © 2024 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1874 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Darlene Corrigan
Darlene Corrigan
ASCIICentury 21 AA Realty
Call Today!: (516) 978-8354

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App