SELECT *, CASE WHEN `name` LIKE "fountain valley%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "fountain valley" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "fountain valley" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "fountain valley" 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 ("fountain valley") 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.
$2,399,00018648 Cedar CirFountain Valley CA 92708View Listing
$2,049,00016331 Rosewood StFountain Valley CA 92708View Listing
$1,999,00018230 Santa Arabella StFountain Valley CA 92708View Listing
$1,879,9909894 Finch AveFountain Valley CA 92708View Listing
$1,869,9909870 Finch AveFountain Valley CA 92708View Listing
$1,649,00016416 Mount Ararat CirFountain Valley CA 92708View Listing
$1,597,8908964 Canary AveFountain Valley CA 92708View Listing
$1,589,00016516 Elm CirFountain Valley CA 92708View Listing
$1,499,00018621 Santa Ramona StFountain Valley CA 92708View Listing
$1,449,00017205 Palm StFountain Valley CA 92708View Listing
$1,429,00016537 Pinyon CirFountain Valley CA 92708View Listing
$1,395,00016360 Sandalwood StFountain Valley CA 92708View Listing
$1,375,00017126 Walnut StFountain Valley CA 92708View Listing
$1,350,00010484 Thrush AveFountain Valley CA 92708View Listing
$1,350,00018096 S 3rd StFountain Valley CA 92708View Listing
$1,325,00018566 Santa Andrea StFountain Valley CA 92708View Listing
$1,300,00016341 Myrtlewood StFountain Valley CA 92708View Listing
$1,289,90018572 San Felipe StFountain Valley CA 92708View Listing
$1,274,9009572 Robin AveFountain Valley CA 92708View Listing
$1,225,00011366 Coriender AveFountain Valley CA 92708View Listing
$1,199,00011301 Primrose AveFountain Valley CA 92708View Listing
$1,149,00016245 Mount Baden Powell StFountain Valley CA 92708View Listing
$1,145,00010784 El Mar AveFountain Valley CA 92708View Listing
$969,00017972 Los Vasos StFountain Valley CA 92708View 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-12-2024 1:34:13 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
Ranch
Single Family
