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 = 3132 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 = 3132 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 = 3132 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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;

3101 E Pacific Coast
Signal Hill, CA 90755
Naush Lalani with Naush Lalani, Broker, original listing - (562) 598-7959

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,800,000
Beds: --
Baths: --
Status: Active
SqFt: 5038 Square Feet
Agency: Naush Lalani, Broker
Agency Phone: (562) 598-7959

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Commercial Sale-Other
Year Built: 1950
Notes: COMPLETELY REMODELED 16 UNIT MOTEL LOCATED IN SIGNAL HILL, BORDERING TO LONG BEACH WITH A WIDE VARIETY OF ACTIVITIES AND FESTIVALS, 15 MINUTES DRIVE TO THE BEACH, LONG BEACH CONVENTION CENTER, LONG BEACH AIRPORT, GOLF COURSES, ANNUALE GRAND PRE, SHORT DISTANCE TO DISNEYLAND, AND LOS ANGELES DOWNTOWN.<br /> ALL ROOMS HAVE BEEN REMODELED, NEW EXTERIOR PAINT, MOTEL SIGN, REPAVED PARKING LOT, SECURITY LIGHTS, NEW UPGRADED SERVICE PANELS, ROOF, RAIN GUTTERS, NEWER FURNITURE, ALL NEW HARDWOOD FLOORS, PLENTY OF PARKING FOR GUESTS, CLOSE TO RESTAURANTS, ENTERTAINMENT AND FREEWAYS. <br /> PRIVATE MOTEL MANAGER QUARTERS WITH BEDROOM, BATH, LIVING ROOM, KITCHEN, DINING AREA, SECURED CHECK IN AREA, PRIVATE LAUNDRY AREA FOR MANAGERS, ATM MACHINE AND SOFT DRINK MACHINE, LOCATED RIGHT ON PACIFIC COAST HIGHWAY VERY HIGHLY VISIBLE LOCATION. <br /> MOTEL IS TURN KEY, LOCATED ON A LARGE LOT 11,000 SQ FT IDEAL FOR FUTURE DEVELOPMENT FOR HOUSING OR COMMERCIAL. OTHER MOTELS IN SIGNAL HILL HAVE BEEN SOLD AND DEVELOPED INTO HOUSING UNITS GREAT INVESTMENT OPPORTUNITY.<br /> 4 ROOMS HAVE 2 BEDROOMS WITH TWO BEDS, 4 ROOMS ARE KING SIZE BEDS REST ARE QUEEN SIZE
MlsNumber: --
ListingId: PW23055855


Listing Provided By: Naush Lalani, Broker, original listing
Phone: (562) 900-1891
Office Phone: (562) 598-7959
Agent Name: Naush Lalani
Disclaimer: Copyright © 2024 California Regional Multiple Listing Service, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App