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

18105 Bastanchury Road
Yorba Linda, CA 92886
Maureen Haney with Compass, original listing - (626) 914-2904

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,498,000
Beds: 6
Baths: Full: 3, ¾: 2
Status: Active
SqFt: 4844 Square Feet
Agency: Compass
Agency Phone: (626) 914-2904

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1985
Notes: Discover this unique property featuring two single-story custom homes, each with its own address, situated on a sprawling 38,333 SF lot and accessed by a private driveway offering privacy and seclusion. Nestled in a serene area, this estate offers a private backyard oasis with a stunning rock pool and spa, complete with a soothing waterfall. Enjoy the expansive deck, charming gazebo, built-in BBQ, and lush lawn area perfect for relaxation and entertaining. The property also includes a versatile open space with fruit trees, planting beds, and a basketball court area, plus gated RV parking for added convenience. Whether you're seeking a family compound or additional space for guests, this property provides ample space and endless possibilities.<br /> Main House (18105 Bastanchury Rd.) This 1986 custom-built gem boasts 3,609 SF of living space with three bedrooms, a private office, and three bathrooms. The home greets you with a spacious driveway leading to a charming brick porch and double doors. Inside, enjoy high ceilings, wood and marble flooring, and stunning pool views. The formal living room features a cozy fireplace and built-ins, while the formal dining room showcases hardwood floors and custom drapery. The family room, with wood-beamed ceilings and French doors, includes a built-in bar with a Scotsman refrigerator, ice maker, and glass cabinets. The gourmet kitchen is a chef’s dream with a Wolf six-burner range, Viking trash compactor, Sub-Zero refrigerator, and more. The luxurious primary suite with a fireplace, walk-in closet, and remodeled bathroom add to the allure. Two additional bedrooms, two additional bathrooms, a large laundry room, and ample storage complete this magnificent home.<br /> <br /> 2nd Home (18107 Bastanchury Rd.) Built in 2005, this 1,235 SF home features three bedrooms and two bathrooms. The open living area includes a fireplace and slider door to the outside. The spacious kitchen offers white cabinets, granite counters, and stainless appliances. The primary suite comes with a walk-in closet and a bathroom with a spa bathtub. Additional amenities include a hallway bathroom with a large shower, an inside laundry room, and an attached one-car garage with a private driveway.<br /> This unique property offers privacy, spacious living, and a beautiful setting—an opportunity not to be missed!
MlsNumber: --
ListingId: CV25001330


Listing Provided By: Compass, original listing
Phone: (626) 216-8067
Office Phone: (626) 914-2904
Agent Name: Maureen Haney
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.


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 = 217 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;
Anthony Piscitello
ASCIIPiscitello Realty
Call Today!: (951) 638-4513

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App