SELECT *, CASE WHEN `name` LIKE "agoura hills%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "agoura hills" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "agoura hills" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "agoura hills" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "CA" AND (locality IN ("agoura hills") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 2
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "CA" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 2
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$7,750,00028685 Wagon RdAgoura Hills CA 91301View Listing
$6,924,95028888 Lake Vista DrAgoura Hills CA 91301View Listing
$5,750,00031625 Lobo Canyon RdAgoura Hills CA 91301View Listing
$4,950,00029535 Mulholland HwyAgoura Hills CA 91301View Listing
$4,699,0006108 Chesebro RdAgoura Hills CA 91301View Listing
$4,175,0002068 Shadow Creek DrAgoura Hills CA 91301View Listing
$3,999,0006040 Macadam CtAgoura Hills CA 91301View Listing
$3,749,9971909 Hazel Nut CtAgoura Hills CA 91301View Listing
$3,575,0004019 Hunt Club CtAgoura Hills CA 91301View Listing
$2,995,00029425 Weeping Willow DrAgoura Hills CA 91301View Listing
$2,950,0005934 Colodny DrAgoura Hills CA 91301View Listing
$2,699,00028241 Foothill DrAgoura Hills CA 91301View Listing
$2,495,00029411 Deerview CtAgoura Hills CA 91301View Listing
$2,288,0005541 Foothill DrAgoura Hills CA 91301View Listing
$2,149,00029318 Oakpath DrAgoura Hills CA 91301View Listing
$2,129,00029003 Woodcreek CtAgoura Hills CA 91301View Listing
$1,995,00029514 Meadowmist WayAgoura Hills CA 91301View Listing
$1,995,0006084 Lake Lindero DrAgoura Hills CA 91301View Listing
$1,650,00029085 Lake Vista DrAgoura Hills CA 91301View Listing
$1,600,0004948 Hydepark DrAgoura Hills CA 91301View Listing
$1,495,00029383 Crags DrAgoura Hills CA 91301View Listing
$1,415,00028802 Eagleton StAgoura Hills CA 91301View Listing
$1,349,00028604 Eagleton StAgoura Hills CA 91301View Listing
$1,299,0004964 Calle MontecilloAgoura Hills CA 91301View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-06-2024 10:02:59 pm.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "CA" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 2
Blah