Recommended Listings
Select m.*, m.city + m.street As address From MLS m, MLS_REC r Where m.mlsnum = r.mlsnum And r.targetno = '542' UNION ALL Select m.*, m.city + m.street As address From Agent_MLS am, MLS m Where am.mlsnum = m.mlsnum And am.mlsnum Not In(Select mlsnum From MLS_REC Where targetno = '542') And am.agentno = '542'
Your search returned total 15 records.
1  2  3  / Total 3 Page(s) [15 Estate(s)]
Sorted By
Los Angeles
Res. Lease    Active at 2/24/2018 5:24:05 PM
Offered at $6,950
3 Bedrooms, 3 Baths
1707 Viewmont Drive, Los Angeles, CA 90069
Fantastic Single Family Home With Views Off Sunset Plaza! Tastefully Remodeled! Updated Modern Natural Bright! Br, Ba, Bonus Room,den, And Car Garage. 3,578 Sqft Living Area On 5,776 Sqft Lot, Built In 1962. Formal Entryway, Living Room With...
more info
Hacienda Heights
S. Family    Active at 2/23/2018 6:12:13 PM
Offered at $858,000
5 Bedrooms, 3 Baths
16559 Nicoya Drive, Hacienda Heights, CA 91745
Beautiful Story Home Nestled On Quiet Cul De Sac One Bed And One Full Bath Downstair Enjoy All The Upgrade In The House, Fireplace In Family Room And Gorgeous Pool With Spacious Elegant Patio Area For Entertainments And Is Conveniently Located...
more info
Toluca Lake
S. Family    Active at 2/23/2018 4:20:17 PM
Offered at $1,349,900
3 Bedrooms, 5 Baths
4555 Mariota Avenue, Toluca Lake, CA 91602
G奧 Tastefully Upgraded Estate Home In Prime Toluca Lake. G奧 The Furniture Is Included In Sale (not Decoration Items). G奧 Bright And Airy: Fantastic Open Floor Plan. G奧 The Design Offers Approximately 2,456 Sqft On 1,3632 Sqft Lot, Bedr...
more info
Chino Hills
Land    Active at 2/22/2018 5:16:32 PM
Offered at $325,000
Bedrooms, Baths
15805 Sedona Drive, Chino Hills, CA 91709
First Time On The Market At The Prestigious Higgins Ranch Community In Chino Hills! Perfect Opportunity For Builders And Investors To Purchase Vacant Flat Lot, Zoned And Entitled For Single Family Home With Approved Architecture Plans For "cant...
more info
Rowland Heights
S. Family    Active at 2/22/2018 11:56:07 AM
Offered at $1,050,000
5 Bedrooms, 4 Baths
2308 Ruth Court, Rowland Heights, CA 91748
Beautiful Home With Side View In Desirable Location, Bedrooms And 3.5 Baths. New Master Suit Added On Approximately Years Old Downstairs.master Beds W/ Walk-in Closet And Retreat. Master Bathroom With Skylight. Large Family Room With Fireplace...
more info
1  2  3  / Total 3 Page(s) [15 Estate(s)]
Back
Some properties which appear for sale on this web site may have subsequently sold and may no longer be available.