Title Page Background
DEBUG FN args: Array ( [0] => 3132 [1] => [2] => [3] => agent ) BEFORE: Site: 3132 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3132 Igate: njhud LocID: 3132 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('mihud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3132 [1] => [2] => [3] => lender ) BEFORE: Site: 3132 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3132 Igate: njhud LocID: 3132 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('mihud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3132 [1] => [2] => [3] => other ) BEFORE: Site: 3132 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3132 Igate: njhud LocID: 3132 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('mihud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

15541 Olive Branch Drive
La Mirada, CA 90638
Denise Tash with First Team Real Estate, original listing - (949) 539-0824

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,499,000
Beds: 5
Baths: Full: 2, ¾: 2
Status: Active
SqFt: 2973 Square Feet
Agency: First Team Real Estate
Agency Phone: (949) 539-0824

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1974
Notes: Located in the desirable Creek Park Community, this spacious 5-bedroom + office, 4-bath pool home offers nearly 3,000 sq. ft. of living space on a 14,000+ sq. ft. lot. With a 3-car garage and an extended driveway that can accommodate up to 10 vehicles, there’s no shortage of parking for guests or toys. Designed for comfort and entertaining, this home features a wraparound deck with views of gardens, trees and hills, three separate yard areas, a private 16x40 foot pool and spa, sport court, outdoor shower, and a storage shed. Inside, the upgraded kitchen (2018) boasts quartz countertops, white shaker cabinets, stainless steel appliances, new dishwasher was recently installed, tile backsplash, recessed lighting, and a walk-in pantry. The kitchen and family room are in an open concept configuration with a custom Quartz counter between them that seats up to nine people. The inviting living room includes a cozy brick fireplace, while two main floor bedrooms/office offer flexibility—perfect for multi-generational living with separate access. Upstairs, the primary suite impresses with vaulted ceilings, a private balcony, two mirrored closets and a luxurious en-suite bath complete with a Jacuzzi soaking tub and overhead shower. Additional features include a 3-year Boral tile roof, recessed lighting and crown molding throughout, dual-pane vinyl windows, fresh interior paint, and durable laminate flooring (2021-2022). All bathrooms have ceramic tile, wood cabinets, granite tops with upgraded faucets and lighting added in 2025. The central air boasts two new state of the art furnaces (2022) with an upgraded air compressor (2022). The pool also has a new heater (2024), a new electrical panel (2025) and was recently acid-washed and glass bead blasted with new Deck-O-Seal installed (2025). The upstairs water-proof deck above the garage and the subsurface drain from the pool area were recently replaced (2025). The upgraded outdoor lighting and fencing around the exterior of the house provide a safe haven for children and pets. Low HOA, $140 per month, includes access to tennis courts, swimming pools, a clubhouse and scenic walking trails. Minutes from La Mirada Golf Course, La Mirada Splash and La Mirada Civic Theater. Located just a short walk to a running track at Biola University and Creek Park, known for its lush greenery and annual community events and five minutes by car to dozens of trails. This is Southern California living at its best!
MlsNumber: --
ListingId: PW25100634


Listing Provided By: First Team Real Estate, original listing
Phone: (949) 539-0824
Office Phone: (949) 539-0824
Agent Name: Denise Tash
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App