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.
$3,298,0005300 Morning Sage WaySan Diego CA 92130View Listing
$3,288,8883315 2nd AveSan Diego CA 92103View Listing
$3,250,0002215 Juan StSan Diego CA 92103View Listing
$3,245,0003945 Wildwood RdSan Diego CA 92107View Listing
$3,200,0003791 Cedarbrae LnSan Diego CA 92106View Listing
$3,200,000804 Rosecrans StSan Diego CA 92106View Listing
$3,000,00012833 Lunada PlSan Diego CA 92128View Listing
$3,000,0005572 Havenridge WaySan Diego CA 92130View Listing
$2,999,0003573 Jewell StSan Diego CA 92109View Listing
$2,999,0004414 Ladera StSan Diego CA 92107View Listing
$2,999,0007967 Entrada LazanjaSan Diego CA 92127View Listing
$2,995,0005315 Canterbury DrSan Diego CA 92116View Listing
$2,975,00014648 LA PlataSan Diego CA 92127View Listing
$2,975,00013025 Harwick LnSan Diego CA 92130View Listing
$2,950,0007462 LA MantanzaSan Diego CA 92127View Listing
$2,900,0005410 Sparkling Shores DrSan Diego CA 92130View Listing
$2,899,9994561 Niagara AveSan Diego CA 92107View Listing
$2,895,00013044 Polvera AveSan Diego CA 92128View Listing
$2,888,8881855-1857 Frankfort StSan Diego CA 92110View Listing
$2,875,00011662 Big Canyon LnSan Diego CA 92131View Listing
$2,800,00012415 Kingspine AveSan Diego CA 92131View Listing
$2,800,00012436 Grainwood WaySan Diego CA 92131View Listing
$2,800,00013209 Winstanley WaySan Diego CA 92130View Listing
$2,750,0001241 Tourmaline StSan Diego CA 92109View 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 3:08:09 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