SELECT *, CASE WHEN `name` LIKE "santa cruz%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "santa cruz" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "santa cruz" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "santa cruz" 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 ("santa cruz") 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.
$12,000,0002950 Pleasure Point DrSanta Cruz CA 95062View Listing
$9,275,0004250 Opal Cliff DrSanta Cruz CA 95062View Listing
$3,900,00036 Rockview DrSanta Cruz CA 95062View Listing
$3,499,000118 1st StSanta Cruz CA 95060View Listing
$2,850,000623 High StSanta Cruz CA 95060View Listing
$2,850,000196 Palomino WaySanta Cruz CA 95060View Listing
$2,688,0001122 Western DrSanta Cruz CA 95060View Listing
$2,499,999243 Harbor Beach CtSanta Cruz CA 95062View Listing
$2,499,0002510 Benson AveSanta Cruz CA 95065View Listing
$2,489,0003707 Moana WaySanta Cruz CA 95062View Listing
$2,298,000390 36th AveSanta Cruz CA 95062View Listing
$1,999,988208 Laurent StSanta Cruz CA 95060View Listing
$1,750,000414 Pelton AveSanta Cruz CA 95060View Listing
$1,690,000346 Spring StSanta Cruz CA 95060View Listing
$1,650,000515 Carbonera DrSanta Cruz CA 95060View Listing
$1,600,000920 Walnut AveSanta Cruz CA 95060View Listing
$1,549,000247 High StSanta Cruz CA 95060View Listing
$1,499,99911 Rincon CtSanta Cruz CA 95060View Listing
$1,499,9991011 Prospect HtsSanta Cruz CA 95065View Listing
$1,499,950322 Nobel DrSanta Cruz CA 95060View Listing
$1,395,0001122 Seabright AveSanta Cruz CA 95062View Listing
$1,375,000711 Vine Hill RdSanta Cruz CA 95065View Listing
$1,375,00055 Towhee DrSanta Cruz CA 95060View Listing
$1,299,0001956 Newport AveSanta Cruz CA 95062View 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-05-2024 9:31: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