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

345 Figueroa Drive
Altadena, CA 91001
Jessica Romero with Keller Williams Realty, original listing - (626) 204-3300

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,649,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 2156 Square Feet
Agency: Keller Williams Realty
Agency Phone: (626) 204-3300

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1988
Notes: Nestled in the heart of an amazing NW Altadena & backed by the picturesque San Gabriel Mountains a true modern dream home awaits its next chapter! This is one of those rare gems that makes your heart skip a beat when you finally find it! This 3-bed, 3-bath beauty (PLUS attached guest suite / ADU!) has had every inch painstakingly upgraded & customized w/ exquisite attention to detail & pristine execution. You can feel the thoughtfulness & beautiful craftsmanship that went into every detail & the space also emits a tranquil / joyful energy right away. You'll also find special upgrades that you just don't see everyday have been tastefully incorporated into each space. As you enter through the large gated driveway surrounded by lush landscape & hardscape a dramatic oversized pivot door & swanky exterior mood lighting welcomes you in. Once inside you're met by a bright open great room featuring handcrafted wood accents & warm white oak flooring throughout. This space is overlooked by a stunning chef’s kitchen w/ no detail spared. Top of the line cafe' brand appliances, a large custom-built island, custom cabinetry & backyard access! Also, don't miss the deep walk-in pantry, w/ wine / beverage storage & a custom built-in kegerator! (that could also be customized for cold brew coffee or carbonated beverages etc). Down the hallway you'll find an ultra private & romantic primary suite that truly feels like an actual retreat. From the private seating deck for morning coffee to the spa-like ensuite bath, complete w/ an infrared sauna, walk-in shower & deep soaking tub, you will have your own tranquil spa right at home! Additionally there's another spacious bedroom, beautiful hall bath & an ensuite bedroom that leads to a large covered patio that feels like another living room- an absurdly perfect setting for family gatherings, summer BBQ's & beyond! The expansive lot features multiple lounge, dining & play areas including built-in seating around a fire pit that feels like a resort right in your own backyard. In addition to all of this, a separate side entrance leads to a ridiculously adorable 1-bedroom, 1-bathroom guest suite w/ a gorgeous attached bath & kitchenette—ideal for whatever your needs are (an awesome home office, In-Law suite, or passive rental income?) Not far from hiking trails, JPL or the charming hidden gem shops on nearby Lincoln Ave you'll be surrounded by a beautiful, vibrant & resilient community! This one is truly special in every way!
MlsNumber: --
ListingId: AR25061630


Listing Provided By: Keller Williams Realty, original listing
Phone: (626) 414-7464
Office Phone: (626) 204-3300
Agent Name: Jessica Romero
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.


Local Real Estate Expert

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 = 203 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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;
Real Estate Expert Photo for Ken Sisson
Ken Sisson
ASCIIColdwell Banker Realty Studio City
Call Today!: (310) 308-8672

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App