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

913 Sherlock Drive
Burbank, CA 91501
Grace Miranda with Keller Williams Realty World Media Center, original listing - (818) 239-3500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,800,000
Beds: 4
Baths: Full: 2, ¾: 1
Status: Active
SqFt: 2656 Square Feet
Agency: Keller Williams Realty World Media Center
Agency Phone: (818) 239-3500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1969
Notes: A Hidden Georgian Masterpiece with Breathtaking Views. Tucked away at the end of a newly resurfaced private driveway, this extraordinary two-story view estate offers unparalleled privacy and timeless elegance. A stunning example of Georgian architecture, the home showcases exquisite corbels, quoins, and Juliet balconies, embodying classic sophistication. A spacious parking pad accommodates multiple vehicles, leading to a two-car garage with a sleek poly floor finish. A newly installed wrought iron gate and fence enhance both security and privacy, further reinforced by a surveillance system from Access Masters. Meticulously upgraded and maintained, the home boasts all-new windows and sliding doors by California Deluxe Windows, a stately new front door from Pinky's Doors, and a fully updated electrical panel. Copper plumbing throughout is complemented by two new tankless water heaters and a premium water softener system. The living room’s newly heated tile floors add an extra layer of comfort, while two upgraded gas fireplaces create inviting spaces for relaxation and entertaining. The chef’s kitchen seamlessly blends luxury and functionality, featuring a new Sub-Zero refrigerator/freezer and wine fridge, along with new JennAir oven, range, dishwasher, and hood. Restored cabinetry and new tile floors accentuate the black granite countertops, offering a refined aesthetic. Designed to maximize breathtaking city and valley views, the upper level boasts a bright, open-concept kitchen, dining room, and family room, all opening to a spacious balcony—ideal for alfresco dining and sunset gatherings. A formal living room with all new hardwood floors provides an elegant welcome, while the first level includes two additional bedrooms (one currently used as an office) and a stylish ¾ bath. Set on a meticulously curated 9,000 SF lot, the outdoor space is a private oasis fully showcased by a brand new pool and spa custom designed and built by the pros at Pacific Outdoor. A resort-like ambience is created from the dramatic copper fire bowls adorning both sides of the pool along with the tasteful landscaping and lighting. The outdoor kitchen is fully equipped with a new built-in Lynx grill, Zephyr fridge and ample storage. A new patio and fire pit offer the perfect setting for intimate gatherings, while high-end artificial grass ensures a lush, low-maintenance landscape. An advanced drainage system optimizes water management, completing this exceptional outdoor retreat.
MlsNumber: --
ListingId: BB25052548


Listing Provided By: Keller Williams Realty World Media Center, original listing
Phone: (818) 239-3500
Office Phone: (818) 239-3500
Agent Name: Grace Miranda
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','mdhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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