SELECT *, CASE WHEN `name` LIKE "san diego%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "san diego" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "san diego" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "san diego" 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 ("san diego") 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.
$4,499,0001409 Opal StSan Diego CA 92109View Listing
$4,495,0008225 Artesian RdSan Diego CA 92127View Listing
$4,495,0004605 Yerba Santa DrSan Diego CA 92115View Listing
$4,395,0005585 Meadows Del MarSan Diego CA 92130View Listing
$4,195,00011897 Tierra Del SurSan Diego CA 92130View Listing
$4,195,00017155 Reflections CirSan Diego CA 92127View Listing
$3,999,0004584 Leon StSan Diego CA 92107View Listing
$3,995,000921 Harbor View DrSan Diego CA 92106View Listing
$3,990,0004106 Alameda DrSan Diego CA 92103View Listing
$3,900,0005198 Pendleton StSan Diego CA 92109View Listing
$3,900,0001610 Loring StSan Diego CA 92109View Listing
$3,898,0006183 Summit Crest CirSan Diego CA 92130View Listing
$3,880,00013073 Polvera AveSan Diego CA 92128View Listing
$3,878,9982111 W California StSan Diego CA 92110View Listing
$3,789,9999208 Fostoria CtSan Diego CA 92127View Listing
$3,650,0008308 Top O the Morning Way Lot 47San Diego CA 92127View Listing
$3,500,0001447 Plum StSan Diego CA 92106View Listing
$3,499,00017208 Holly Leaf CtSan Diego CA 92127View Listing
$3,499,00016829 Going My WaySan Diego CA 92127View Listing
$3,498,000870 San Antonio PlSan Diego CA 92106View Listing
$3,495,0008423 Run of the KnollsSan Diego CA 92127View Listing
$3,349,9005155 Del Mar Mesa RdSan Diego CA 92130View Listing
$3,299,9504351 Ridgeway DrSan Diego CA 92116View Listing
$3,299,0003758-60 Charles StSan Diego CA 92106View 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-09-2024 4:55:04 am.
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