SELECT *, CASE WHEN `name` LIKE "elk grove%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "elk grove" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "elk grove" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "elk grove" 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 ("elk grove") 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.
$9,400,0007619 Grant Line RdElk Grove CA 95624View Listing
$6,495,0007541 Sloughhouse RdElk Grove CA 95624View Listing
$2,649,0008547 Quest CtElk Grove CA 95624View Listing
$1,600,00010412 Sheldon RdElk Grove CA 95624View Listing
$1,549,0009335 Silverstone LnElk Grove CA 95624View Listing
$1,395,00010265 Sheldon RdElk Grove CA 95624View Listing
$1,299,9999580 Lakepoint DrElk Grove CA 95758View Listing
$1,200,0009534 Sheldon RdElk Grove CA 95624View Listing
$1,195,0008508 Alfama WayElk Grove CA 95757View Listing
$1,148,0009940 Winkle CirElk Grove CA 95757View Listing
$1,099,0008551 Patrickswell CtElk Grove CA 95624View Listing
$999,5009634 Nieman AveElk Grove CA 95624View Listing
$995,9004941 Willow Vale WayElk Grove CA 95758View Listing
$958,1288008 Braelyn WayElk Grove CA 95757View Listing
$921,6288016 Braelyn WayElk Grove CA 95757View Listing
$915,00010069 Richard Ibarra WayElk Grove CA 95757View Listing
$899,9508001 Braelyn WayElk Grove CA 95757View Listing
$887,95010202 Byron Reeves CtElk Grove CA 95757View Listing
$887,9508017 Schrader WayElk Grove CA 95757View Listing
$879,90010236 Stathos DrElk Grove CA 95757View Listing
$859,0757997 Belfry WayElk Grove CA 95757View Listing
$858,5507636 Cosby WayElk Grove CA 95757View Listing
$858,0697641 Chester Dawson WayElk Grove CA 95757View Listing
$858,0697665 Chester Dawson WayElk Grove CA 95757View 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-14-2024 6:30:15 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