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

9549 La Amapola Avenue
Fountain Valley, CA 92708
Lily Campbell with First Team Real Estate, original listing - (949) 539-0824

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,990,000
Beds: 5
Baths: Full: 4, ½: 2
Status: Active
SqFt: 4653 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: 2006
Notes: Discover an unparalleled living experience in this one-of-a-kind palatial estate designed for multi-generational living. Nestled at the end of a cul-de-sac, less than 4 miles from the beach, this custom-built masterpiece is one of only five that were built in this exclusive enclave. Crafted in 2006, this 4,653 SF home features 5 bedrooms, 4 full baths, 2 half baths (one primary suite up & one down), and a remarkable 2,850 SF subterranean 10-car garage with an elevator to the 2nd & 3rd floors. The finest materials & impeccable craftsmanship used in the construction of this magnificent home boasting sophisticated architectural details & attention to detail given to every square inch, including extensive use of exotic hardwoods, natural stone, coffered ceilings, arched passages, smooth plaster walls, solid wood palladium doors, LED recessed lighting, designer fixtures, mosaic tile inlays, dual-pane windows, plantation shutters, stone wainscoting, 2 fireplaces, dual-zone A/C, jetted tubs, and walk-in closet organizers. The impressive exterior features include stacked stone siding, Travertine walkways, tropical landscaping, and lighting. Enter through custom solid wood & wrought iron double entry doors to a grand rotunda foyer with a dramatic sweeping stone & wrought iron staircase. The main level includes a versatile formal living room/office/bedroom. The open-concept great-room with soaring ceilings & skylights incorporates the family room w/fireplace, a spacious breakfast room w/a bay window, and a gourmet Chef’s dream kitchen with a large center island w/wrap-around seating, gorgeous granite countertops, metal tile backsplash, custom cabinetry, and Thermador professional-grade appliances, including an 80+ bottle wine fridge. A butler’s pantry is situated between kitchen & banquet-sized formal dining room for effortless entertaining. French doors open to a resort-style backyard w/sparkling pool, spa, water features, Travertine deck areas, and a fully equipped barbecue center, perfect for unforgettable gatherings. The downstairs primary suite includes a separate retreat, lavish spa-style bathroom, fireplace, and French doors to backyard. Upstairs you'll find a large living room with wall-to-wall handcrafted hardwood wet bar that's plumbed for a future 2nd kitchen, along with 3 more bedrooms, a private balcony, jack & jill bath, half bath, and a second luxurious primary suite with a spa-style bathroom and walk-in closet. Close to award-winning schools.
MlsNumber: --
ListingId: OC24145912


Listing Provided By: First Team Real Estate, original listing
Phone: (949) 539-0824
Office Phone: (949) 539-0824
Agent Name: Lily Campbell
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 = 3333 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;
Donna Dostalik
ASCIIRE/MAX Unlimited Real Estate
Call Today!: (714) 863-9393

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App