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 = 3132 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 = 3132 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 = 3132 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;

10515 Branscomb Street
Norwalk, CA 90650
Karen Wilson with Newport Financial Associates, original listing - (949) 851-2200

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $950,000
Beds: 4
Baths: Full: 1, ¾: 1
Status: Active
SqFt: 2228 Square Feet
Agency: Newport Financial Associates
Agency Phone: (949) 851-2200

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1954
Notes: WELCOME HOME!! Large home on quiet a cul de sac featuring 3 bedrooms and 1 bath downstairs, Master Bedroom and bath upstairs. Master bedroom has a sliding glass door leading to the balcony, a large walk in closet with mirrored doors. Hardwood floors in entryway, hall and 2 downstairs bedrooms. Carpet in 1 downstairs bedroom, dining room, living room, stairs and master bedroom. Large family style kitchen has a garden window overlooking the side yard, generous counter space and cabinets. Back porch has washer hook up, deep sink, plenty of storage space, backdoor leads to the side yard. Dining room has an alcove, a skylight and 2 access doors to the kitchen. Extra Large livingroom has a fireplace, wet bar, and 2 sliding glass doors leading to backyard. Wet bar has a sink, wine storage, cabinets, storage and refrigerator hook up. Storage underneath the stairs. Main water heater for downstairs is in the back yard near the bathroom. Master Bath has it own 5 gallon water heater. Pull down stairs leading to the attic with storage. Back yard has a large deck and gazebo. Fruit producing Fuji apple tree in front yard, Meyer lemon and lime trees in back yard. Automatic watering system in front, back and side yards. 2 car garage has a work bench, storage and a automatic door opener, Dryer hook up is in the garage. Washer hookup in the Kitchen Dusk to dawn lights above the garage door.<br /> Close to 105, 5, 91 and 605 freeways, biking and walking trails, schools, shopping and restaurants. Friendly neighborhood
MlsNumber: --
ListingId: PW24154775


Listing Provided By: Newport Financial Associates, original listing
Phone: (949) 285-0005
Office Phone: (949) 851-2200
Agent Name: Karen Wilson
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App