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

333 N Poinsettia Pl
Los Angeles, CA 90036

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,189,000
Beds: 3
Baths: 4
Status: Active
SqFt: 3204
Agency: Coldwell Banker Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1937
Notes: A Luxurious Custom Mediterranean Home in the Heart of Miracle Mile and Beverly Grove. Imagine a home where luxury meets comfort, nestled in one of the most coveted areas. This exquisite custom Mediterranean home is just a leisurely stroll away from the famed Grove, high-end restaurants, and trendy boutiques lining Beverly Blvd and La Brea. As you approach this architectural marvel, a private mesmerizing garden greets you. A serpentine travertine path weaves through the lush greenery, offering an aura of seclusion. This path culminates at a magnificent home fronted by a custom mahogany wood door encased in glass, a promise of the grandeur that lies within. Upon entering, you are welcomed by a breathtaking two-story foyer adorned with travertine floors and filtered light. The separate living room, featuring a decorative fireplace. Beautiful custom drapery designed especially for this room. French custom windows radiate light and elegance of this special room. The separate dining room, framed by custom French windows and stunning drapery, is the perfect setting for formal dinners inspired by your favorite recipes. A tastefully designed powder room for guests, equipped with Italian Murano sconces and Duravit sink adds a touch of opulence. At the heart of the home is the awe-inspiring, expansive gourmet custom kitchen. It boasts custom cabinetry, glass leaded doors, copper hardware, and a special chef's Thermador cooktop with a custom Venta Hood and pasta pot filler fixture. The kitchen also features GE Monogram Chef's convection oversized ovens. The island is expansive and is perfect for that gathering around, eating, preparing your favorite impromptu eating experiences. The island also features a special plug in for charging your phone and iPad. No expenses were spared in this beautiful one of a kind kitchen. Then walk into the most fabulous huge Family Room with floor to ceiling windows abound for a view of your luscious green grass carpeted oasis. This room is bright open and airy. Custom beautiful paint with a stunning decorative fireplace. This room is perfect for family get togethers, hanging out or just watching your fave programs. The home features a downstairs bedroom with its own bathroom and walk in shower. Upstairs, another bedroom awaits, complete with its own bathroom featuring custom cabinetry, glass doors, and ample storage. Stone counter and floor with Brizo faucet and spacious tub. Then walk into the expansive master bedroom suite, adorned with custom windows and walls painted with hues from Restoration Hardware, serves as your personal sanctuary. The large master bath features a walk-in shower with a beautiful Brizo shower head and fixtures, a huge soaking tub, cabinetry and 2 sinks for each of you getting ready in the morning. The home is further enhanced by the gorgeous walnut wood floors that span throughout the house. Its strategic location provides seamless access to Beverly Hills, Hancock Park, downtown and to places of worship. Outside, the long driveway leads to a beautiful open patio area where you can unwind and admire your rare David Austin Roses and breathtaking Camellia's . The expansive backyard, carpeted with lush green velvet grass, has room for an ADU and the swimming pool of your dreams. Dreams do come true, and it's all waiting for you in this beautiful custom Mediterranean home. Buyer is advised to independently verify accuracy of lot size, lot line, square footage. Buyer is advised to independently verify the accuracy of all information through personal inspection and with appropriate professionals.
MlsNumber: 24-369983


Listing Provided By: Coldwell Banker Realty, original listing
Name: Coldwell Banker Realty
Phone: (800) 500-4053
Office Name: Coldwell Banker Realty
Office Phone: (818) 995-2424
Agent Name: Michael Gola
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 = 3239 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 Bambi Norman
Bambi Norman
ASCIIR A Wilkes Real Estate LLC
Call Today!: (315) 225-5181

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App