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

758 Larchmont Street
Simi Valley, CA 93065

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,799,000
Beds: 5
Baths: 4
Status: Pending
SqFt: 3404
Agency: Keller Williams Realty - Exclusive Properties

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1993
Notes: One of the loveliest homes in Wood Ranch's premier neighborhood of The Legacy Collection is ready for its new owners. From the moment you drive up to this exquisite 3,400 square foot residence on a huge 15,000 square foot lot (5 bedrooms / 4 full baths; DOWNSTAIRS bedroom 5 is currently used as an office with a full bath located just around the corner) you will be astounded at every turn. From the stunning double-door entry with gorgeous wrought-iron scrollwork detail to the formal foyer that guides you to the expansive step-down living room with dramatically high ceilings, crown mouldings, decor lighting fixtures and more, you will want to make this residence your own. Modern luxe flooring throughout the downstairs, decor wall finishes, plantation shutters, many built-ins, sumptuous architectural details, soaring floor-to-ceiling windows, discerning touches throughout and so much more! The beautiful gourmet center-island (with gas cooktop) kitchen replete with double-oven, built-in refrigerator, wine chiller, walk-in pantry, greenhouse window that looks out to the resort-inspired rear yard and opens to the informal eating area & huge family room with adjoining wet bar is the heart of this welcoming home & will be where all your friends & family gather. Additionally, downstairs is a huge laundry room with sink & all the cabinet space you could ever want as well as a door to the rear yard! The semi-circular staircase leading upstairs is beautiful & the spacious landing has tons of linen cabinet space & a lovely overlook to the living room. The primary suite is beyond generously sized with double-door entry, sitting area, fireplace, crown & decorative moulding as well as a lighted art niche. The recently remodeled primary bath is exquisite in the extreme with custom cabinetry, soaking tub, oversized shower with seat & mosaic tile accents. One large upstairs bedroom is an en-suite with a recently remodeled quartz bath with an oversized shower with seat, decor plumbing & lighting fixtures & newer cabinetry, the other two spacious upstairs bedrooms (one with adjoining balcony & the other with extensive built-in cabinetry/cupboards) share the recently remodeled hall bath that is decor perfect in quartz & tile! Outside, you will find an amazing resort-styled rear yard that will make you never want to leave home!! From the beach-entry Pool to the always-inviting Spa, stamped concrete covered patio, strategically-placed lighting, waterfalls to the pergola-sheltered BBQ Center with mini-fridge, numerous & varied palm trees & other plantings, flagstone accents & coping, spacious grassy areas, this rear yard will always be your happy place & will never disappoint!!! And don't forget about the fabulous 4-car pull-through garage that has a Door-To-The-Rear-Yard for all those water toys, jet skis, golf carts, etc as well as extensive overhead storage in one of the garages & the OWNED SOLAR SYSTEM & whole house fan! This is an exceptional residence & deserves to be YOUR new home!!
MlsNumber: 224001419


Listing Provided By: Keller Williams Realty - Exclusive Properties, original listing
Name: Keller Williams Realty - Exclusive Properties
Phone: (805) 777-7117
Office Name: Keller Williams Exclusive Properties
Office Phone: (805) 777-7117
Agent Name: Robert Harris
Disclaimer: Copyright © 2024 Conejo Simi Moorpark Association of REALTORS. 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 = 243 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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 Kelly Bond Ostrander
Kelly Bond Ostrander
ASCIIKeller Williams Westlake Village
Call Today!: (805) 795-3386

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App