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 = 106 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 = 106 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 = 106 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;

5754 Primrose Avenue
Temple City, CA 91780

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,700,000
Beds: 5
Baths: 6
Status: Pending
SqFt: 2440
Agency: RE/MAX Premier Properties

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6,728 sqft
Property Type: Residential
Year Built: 2004
Notes: Gorgeous custom home built in 2004. Located in a prime Temple City area within the acclaimed Temple City School District. Features 5 bedrooms and 4.5 bathrooms within 2,440 sq. ft. of living space on a 6,728 sq. ft. rectangular lot. As you enter the double doors into this stunning home you are greeted by a foyer with high ceilings and beautiful tile floors as well as a formal living room, with large windows, vaulted ceiling, a chandelier and views to the front garden. The sun filled family room is warm and inviting with a beautiful fireplace and double French doors leading to the resort like backyard with beautiful palm trees and a black bottom pool — creating the perfect space for ultimate indoor/outdoor entertaining, accommodating large parties as well as intimate family gatherings. The gourmet kitchen is equipped with custom cabinets and granite countertops. In addition to an ample sized downstairs en-suite, the upstairs features a spacious primary en-suite, with a soaking tub, separate shower, and a walk-in closet. A perfect spot to unwind and enjoy luxurious baths and pool views. Three additional bedrooms are also featured on the upper level. Other home details are beautiful coved ceilings featuring crown moldings, recessed lighting, hardwood flooring on the upper floor, security cameras, multiple chandeliers, a double gated driveway, and an attached 3 car garage. One of the garages has been converted to a bonus room and is adjacent to the pool bath. A pristine pool and spa are center stage, inviting you to cool off on a warm summer afternoon with a refreshing beverage in hand while enjoying your own private paradise. This is a beautiful newer home construction in a very nice area — not to be missed. Walking distance to business strip, and city hall park. Convenient to schools, a library, restaurants, shopping, entertainment, and transportation.
MlsNumber: AR24052969


Listing Provided By: RE/MAX Premier Properties, original listing
Name: RE/MAX Premier Properties
Phone: (626) 229-2200
Office Name: Re/Max Premier Prop Arcadia
Office Phone: (626) 229-2200
Agent Name: Pauline Cheng
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