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

83 W Woodruff Avenue
Arcadia, CA 91007

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,180,000
Beds: 4
Baths: 5
Status: Pending
SqFt: 4177
Agency: RE/MAX Premier Properties

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 9,379 sqft
Property Type: Residential
Year Built: 2024
Notes: Welcome to this brand new South-facing Luxury Home, an architectural dream nestled in the heart of Arcadia. Designed by the local designer, this modern masterpiece sits on a picturesque, tree-lined street just minutes away from the popular Santa Anita Mall, Race Track, Golf Court, Arcadia Schools, etc. This sophisticated new home spans 2 levels encompassing almost 4,200 square feet of Living space with 4 en-suite Bedrooms. A beautiful double entry door greets visitors upon walking through the lush front yard. On the interior, the home has been thoughtfully designed with a natural and convenient flow, sporting finishes of absolute top quality throughout. Mable look Porcelain flooring on the main floor with built-in cabinetry make daily life a luxurious experience. In the kitchen, appliances with Professional Style and a beautiful gas cooktop built into the quartzite countertops are sure to please the chef of the household. The same level of care and attention is brought to the upper level of the main house, with en-suite bathrooms accompanying each bedroom. The Master Suite consists of sitting area for your quiet relaxing time, Walk-in closet with organizer, double Vanity Bathroom with private Sauna, Steamer Shower, and Balcony with sitting area to enjoy the stunning backyard view. The meticulous landscaped Backyard with a cover patio for family and friends’ outdoor entertainment. Don't miss the opportunity to make this your own and enjoy the best of your life.
MlsNumber: AR24103326


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