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

235 San Miguel Rd
Pasadena, CA 91105

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,855,000
Beds: 5
Baths: 7
Status: Active
SqFt: 4057
Agency: Keller Williams Larchmont

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1925
Notes: Welcome to your own private & gated mini estate; meticulously crafted over the course of a three year build! This exquisite English Modern home, nestled in the coveted and picturesque San Rafael flats of Pasadena, has been expanded and enhanced to exceed modern expectations. Upon entry, you're welcomed into the spacious living room, illuminated by large wood framed windows that flood the space with natural light, accentuating the historic barreled ceiling and inviting ambiance of the wood burning fireplace. The home's allure extends to every corner, boasting elegant English Modern design & architecture and exacting attention to detail. When you descend one of the two staircases, you enter into the most charming of kitchens, featuring dark burgundy cabinets, white marble worktops, a large island, and a Thermador suite of appliances. The large refrigerator and freezer are separated by a 92 bottle wine cooler. The kitchen is complemented by a walk-in pantry and attached living space, perfect for everyday meals and relaxing or entertaining with family and friends. The entire back wall is made up of French doors and windows that floods the space with light, providing a picturesque view of the rear garden. The outdoor space is complete with an outdoor kitchen, beckons for leisurely afternoons and memorable evenings under the stars, with ample space to accommodate a new pool & spa. Upstairs, the primary bedroom, accessed via a private staircase, offers a secluded sanctuary with vaulted beamed ceilings and a lavish en-suite bath featuring an antique double vanity, marble topped soaking tub, large shower, walk-in closet, and a second closet for extra storage. For those seeking a first-floor primary or in-laws suite, an en-suite light-filled bedroom is located on the first floor near the front of the home, providing convenience and accessibility. Noteworthy features of this exceptional home include a beautiful library with built-in bookshelves, and a spacious dining room, perfect for hosting formal occasions. Up a second staircase, you will find two additional en-suite bedrooms, offering privacy and comfort for family members or guests. This arrangement is ideal for families who want to be close to an infant or have older children seeking their own space. This enchanting English Modern residence offers an unparalleled lifestyle. The main house boasts 3,625 sq. ft. of living space. Additionally, the permitted ADU, comprising 432 sq. ft. features a wall of bi-folding French doors, large full bath, and is plumbed for a kitchen, providing versatile living options for guests or extended family or other opportunities like a gym, home office, workshop or art studio. Conveniently located near shops, restaurants, parks, and schools but far enough away to enjoy peace and tranquility. Don't miss this rare opportunity to make this one of a kind home your own!
MlsNumber: 24-382511


Listing Provided By: Keller Williams Larchmont, original listing
Name: Keller Williams Larchmont
Phone: (323) 762-2600
Office Name: Keller Williams Larchmont
Office Phone: (323) 762-2600
Agent Name: Marisa Tranquilli
Disclaimer: Copyright © 2024 TheMLSCLAW. 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','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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 Elie Ghattas
Elie Ghattas
ASCIIeXp Realty
Call Today!: (424) 471-2640

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App