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;

5555 Fairview Place
Agoura Hills, CA 91301
Orna Ered with Elite Residential Realty, original listing - (818) 878-0878

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,500,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 2763 Square Feet
Agency: Elite Residential Realty
Agency Phone: (818) 878-0878

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1976
Notes: Welcome to the exclusive and highly desirable Old Agoura. This 5-bedroom, 3-bath home offers spacious, airy living areas, a cook’s kitchen, dining room with garden views, 12ft vaulted ceilings with skylights, 2 fireplaces, and parking for 4+ cars, including 2 driveways and 2 garages.<br /> <br /> With 2,763 sq ft, this property has potential for expansion. The adjacent garage can be converted, increasing the livable space to nearly 3,500 sq ft or transformed into a 720 sq ft ADU/income unit with its own garden and driveway. Architectural plans are available.<br /> <br /> The entrance features an elegant arched porch with slate tile, leading to a modern interior with shiplap walls, steel cable railings, oak-colored floors, and decorative tile accents. The vaulted primary suite includes a balcony, organized closet, and en-suite bathroom with dual sinks, concrete countertops, a 2-person rain shower, and a second closet.<br /> <br /> Three more queen-sized bedrooms and a family bathroom complete the upper level. A 5th bedroom (currently used as an office) is on the lower level, alongside a modern bath and laundry room. This level also has a second large living room with a fireplace, a nook (potential kitchenette), and a private entry, ideal for use as a separate unit.<br /> <br /> The professionally landscaped grounds feature a drought-tolerant front yard with a dry creek and a fully fenced backyard with an 800 sq ft Trex deck, perfect for entertaining. An outdoor kitchen includes a 40-inch gas grill, side burner, refrigerator, stone counter, and a 6ft gas firepit, next to a cement tile patio with spa hookups and an elevated pergola. A bocce court and a second lawn area provide space for a future pool. The property is equestrian zoned, with a large side yard and 12ft access gate for animals, horses, or RVs.<br /> <br /> This private, remodeled home offers room for families of all sizes and opportunities for rental income. Located in a peaceful rural community near the 101 freeway and the Chesebro trailhead, it's a slice of heaven!
MlsNumber: --
ListingId: SR24215130


Listing Provided By: Elite Residential Realty, original listing
Phone: (818) 974-5776
Office Phone: (818) 878-0878
Agent Name: Orna Ered
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