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

5351 Algarrobo
Laguna Woods, CA 92637
Gail Shapiro with Laguna Premier Realty Inc., original listing - (949) 900-6930

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $784,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 989 Square Feet
Agency: Laguna Premier Realty Inc.
Agency Phone: (949) 900-6930

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Condominium
Year Built: 1975
Notes: Be the first to live in this BRAND NEW Spectacularly Remodeled Casa Vista model home. All you need are your personal belongings. This 2 bedroom/ 2 bath property is HIGH END EVERYTHING newly built by one of the best contractors in Orange County. Extra large kitchen island faces the great room featuring a built in entertainment center with a WIFI CONTROLLED High-end Touch-Stone electric, heated Fireplace with underneath lighting. The OPEN SKYLIGHTS ARE SOLAR POWERED WITH SHADES THAT OPEN AND CLOSE REMOTELY. The refrigerator opens with a swipe of hand. Pull-out drawers in cupboards enhance your convenience. THE KITCHEN boasts High End Cabinets and glass front appliances. TV outlets in each room. NEW CENTRAL A/C. NEW Large Walk In Pantry Closet. Extra storage built into the dining area. Extra Storage in the Bedroom closets. The Master bathroom has been redesigned with an extra large walk in shower, new fixtures and sinks, special lighted/heated mirrors to avoid mirror moisture. The high end washer and dryer are located in their own laundry closet. Every detail has been handcrafted to satisfy even the most discriminating tastes. Enjoy the greenery views from your newly enclosed patio with screens. There is also a special outdoor sitting area off the master bedroom attached to the enclosed patio. This home must be seen to appreciate.<br /> Join the Active Ageless in 'CAMP' Laguna Woods Village where the Amenities can keep you young. Included is a resident bus system around the community & to area shopping, restaurants, medical facilities; Over 200 Social Clubs, Tennis, 27 hole Golf Course and a Par 3 walking course, Library, 800 seat Performing Arts Center with Live Entertainment, Art, Jewelry, Computer, Photography and Equestrian Center; 3 Fitness Centers, 5 Pools, 8 Clubhouses, horseback riding/stables, garden centers, basketball, card rooms, billiards, bocce ball, Emeritus classes, Tennis, PICKLEBALL, Bridge and more. Dues include Cable TV, trash, water, landscaping, building maintenance and building insurance, Guard Gated, Security Patrol and so much more. Must be 55 years old to live in the community. Only minutes to World Renown Laguna Beach.
MlsNumber: --
ListingId: OC24196839


Listing Provided By: Laguna Premier Realty Inc., original listing
Phone: (949) 929-7540
Office Phone: (949) 900-6930
Agent Name: Gail Shapiro
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