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;

16914 Harvest Avenue
Cerritos, CA 90703
Ellis Younger with T.N.G. Real Estate Consultants, original listing - (714) 987-3310

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,475,000
Beds: 5
Baths: Full: 3
Status: Active Under Contract
SqFt: 2649 Square Feet
Agency: T.N.G. Real Estate Consultants
Agency Phone: (714) 987-3310

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1967
Notes: Beautifully and thoughtfully re-imagined pool home in one of Cerritos' most sought after neighborhoods is now ready for its new owners. Are you ready for A LOT of house? Elegance and sophistication embodies this large and charming home with 5 bedrooms 2.5 bathrooms. As you step through the front door, you'll notice the bright, open, and airy layout with an abundance of natural light. The brand new chef's kitchen has been updated with modern oak and white shaker cabinets, beautiful quartz counter tops, new stainless steel appliances and a great breakfast bar. The bathrooms have been revamped with sleek modern fixtures and designer amenities. All of the bedrooms are good size with ample closet space. Some of the other features of the home include all new waterproof luxury vinyl flooring, new dual pane windows, and all new lighting fixtures and ceiling fans. There is a new central air and heat system with all new ducting and a NEST thermostat, and a remodeled decorative fireplace in the living room. There is an attached 3 car garage with direct access to the house. The back yard is exactly the vibe you are looking to with a refreshing heated pool and spa that have been freshly re-plastered with new surround tile and a new light, filter and pump making this back yard your own private lush oasis! The front and back yards have new sod (grass), new mulch and plants with a new sprinkler system on an automatic timer. Perfect for family life or entertaining this home is located in a prime location near great shopping, award winning schools, restaurants, public transportation and quick access to the freeways. This home also includes section 1 termite clearance! There is just too much to mention, you have to see it for yourself! Come take a look before its too late!
MlsNumber: --
ListingId: PW25030873


Listing Provided By: T.N.G. Real Estate Consultants, original listing
Phone: (562) 882-4404
Office Phone: (714) 987-3310
Agent Name: Ellis Younger
Disclaimer: Copyright © 2025 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