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

7028 Lurline Avenue
Winnetka, CA 91306

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $899,999
Beds: 4
Baths: 4
Status: Active
SqFt: 2102
Agency: Management Systems, Corporation

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7,704 sqft
Property Type: Residential
Year Built: 1954
Notes: 2 PRIMARY BEDROOMS PLUS A GUEST UNIT! The living room is bathed in natural light from a multitude of windows and is enhanced by recessed lights and custom tiled floors. Updated kitchen with it recessed lights, rich solid oak wood cabinetry, oversized pantry with pull-outs, marble countertops, dual basin sink, stainless steel appliances which includes Maytag gas range with convection feature, Maytag microwave and LG dishwasher, portable complementary oak island with granite counter top, oak bar with additional storage front and back, and custom tiled floors. Plus, an oversized breakfast nook/informal dining area with elegant crown molding and custom tiled floors. The formal dining room fittingly adjoins the kitchen and with its sparkling window, drop down lighting and custom tiled floors it is perfect for any occasion. The expansive step-down family room with recessed lights, modern lighted ceiling fan, glistening window, sliding doors that lead to the backyard and wall-to-wall carpet is perfect for quiet relaxation or family gathering. Guest bathroom with pedestal sink, large dressing mirror, designer lighting, frameless glass-enclosed custom tiled step-in shower, Washlet commode (integrated bidet system), custom tiled floors and walls and privacy window. Expansive primary suite drenched in natural light and enhanced by a lighted ceiling fan, mirrored wardrobe doors, built-in niche for linens and wall-to-wall carpet; plus, a private en suite bathroom with a white vanity, tiled countertops, dressing mirror, built-in niche for sundries, a custom tiled glass enclosed step-in shower and custom tiled walls, ceiling and floors. Two additional bright and airy bedrooms (one of which is a second primary bedroom) with various amenities such as recessed lights, lighted ceiling fans, mirrored wardrobe doors and wall-to-wall carpet. Additional guest bathroom with modern vanity, dressing mirror, designer lighting, linen storage, glass-enclosed custom tiled tub/shower, and custom tiled walls and floor. BONUS: DETACHED GUEST UNIT with covered patio, entry door with fanned glass insert, sparkling windows, recessed lights, wired for surround sound, built-in media niche, space for a small kitchenette, A/C wall unit, 1 bedroom with closet, mirrored wardrobe doors, half bath with single vanity, framed dressing mirror. commode and custom tiled floors. Backyard with artificial grass, open patio, colorful planters, shade and fig trees and huge storage shed.
MlsNumber: SR24080889


Listing Provided By: Management Systems, Corporation, original listing
Name: Management Systems, Corporation
Phone: (818) 363-6116
Office Name: Park Regency Realty
Office Phone: (818) 363-6116
Agent Name: Jim Sandoval
Disclaimer: Copyright © 2024 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 = 201 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 Carlo Panosian
Carlo Panosian
ASCIIPreferred Real Estate Expert
Call Today!: (818) 926-5751

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App