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;

3430 Viewfield Avenue
Hacienda Heights, CA 91745
RUDY LIRA KUSUMA with Your Home Sold Guaranteed Rlty, original listing - (626) 789-0159

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,499,999
Beds: 6
Baths: Full: 6, ½: 1
Status: Active
SqFt: 9320 Square Feet
Agency: Your Home Sold Guaranteed Rlty
Agency Phone: (626) 789-0159

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: Exquisite Luxury Estate with Panoramic Views<br /> <br /> Welcome to a one-of-a-kind luxury estate offering the ultimate blend of elegance, comfort, and breathtaking vistas. Nestled on a sprawling 1.15-acre lot, this exceptional property boasts 9,320 square feet of meticulously designed living space, featuring 6 bedrooms and 6.5 baths.<br /> <br /> Step into a world of sophistication with an open floor plan that seamlessly blends indoor and outdoor living. High-end finishes and custom craftsmanship grace every corner of this home, from the gourmet chef’s kitchen to the opulent master suite. Expansive windows and sliding glass doors flood the space with natural light, showcasing the stunning panoramic views of city lights and rolling hills.<br /> <br /> Entertain in style with an infinity pool that appears to spill into the horizon, creating a serene ambiance perfect for relaxing or hosting guests. The expansive lot provides endless opportunities for outdoor living, with space for lush landscaping, a garden, or even a private retreat.<br /> <br /> Located in the heart of Hacienda Heights, this estate offers privacy, luxury, and convenience, with easy access to top-rated schools, dining, and shopping.<br /> Don’t miss this rare opportunity to own a masterpiece that redefines luxury living. <br /> <br /> Schedule your private tour today!
MlsNumber: --
ListingId: WS25007963


Listing Provided By: Your Home Sold Guaranteed Rlty, original listing
Phone: (626) 789-0159
Office Phone: (626) 789-0159
Agent Name: RUDY LIRA KUSUMA
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