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

1335 E Appleton Street E
Long Beach, CA 90802

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $585,000
Beds: 2
Baths: 2
Status: Active
SqFt: 1062
Agency: RE/MAX College Park Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8,270 sqft
Property Type: Residential
Year Built: 1956
Notes: Very cute upstairs 1 bed, 1 bath condo!! This location is amazing - 2 blocks from the beach and walking distance to so many restaurants and shopping! Easy walking/cycling access to everything Downtown has to offer with a much quieter, cleaner community feel. A short walk to 4th St 'Retro Row' with it's diverse boutiques and vintage stores, live music bars and amazing food scene offering everything from Peruvian to falafel to gourmet French cheese not least including Little Coyote rated in the top 5 pizzas in LA, and Gusto Bread also rated in the best bakeries in LA. Also within an easy walk or cycle you'll find sea-view restaurants, the amazing amenities of downtown Belmont Shore including open air beachfront swimming pool and beach sports facilities, upmarket bars and fine dining restaurants. A little further drive on and you will find top of the line shopping and dining with the brand new 2nd & PCH mall featuring the hot new Bungalow Kitchen and legendary sunset sea-view from the amazing Ballast Point Brewery. Your new home has recessed lighting, oak hardwood flooring throughout most of the condo with tile flooring in kitchen and bath. There are granite counters in the kitchen and bath and new ceiling fans in the bedroom and dining area. You won't believe the amount of storage in this condo!! The proximity to the beach has ocean breezes all day but you also have a wall unit AC in the living room and bedroom. Your neighbors in this complex are great too! There is a patio area with table and chairs and everyone has personalized it with plants too. Yes, 2 blocks to the beach and located right between Belmont Shore and Downtown Long Beach - great bike rides! Plenty of street parking but there is also parking about 2 blocks away for a small monthly fee. Community laundry has new washers and dryers!! Refrigerator stays and furnishings are negotiable - so it's really ready to move in now!!
MlsNumber: PW24074546


Listing Provided By: RE/MAX College Park Realty, original listing
Name: RE/MAX College Park Realty
Phone: (888) 920-1993
Office Name: RE/MAX College Park Realty
Office Phone: (562) 982-0300
Agent Name: Kevin Poi
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