SELECT *, CASE WHEN `name` LIKE "sacramento%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "sacramento" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "sacramento" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "sacramento" 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 ("sacramento") 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,980,0004201 Garden HwySacramento CA 95834View Listing
$2,895,000540 Crocker RdSacramento CA 95864View Listing
$2,795,0003011 Morse AveSacramento CA 95821View Listing
$2,700,0009610 Florin RdSacramento CA 95829View Listing
$2,575,0001022 44th StSacramento CA 95819View Listing
$2,500,000557 Crocker RdSacramento CA 95864View Listing
$2,149,000745 Estates DrSacramento CA 95864View Listing
$2,125,0001341 39th StSacramento CA 95816View Listing
$1,995,000930 Saverien DrSacramento CA 95864View Listing
$1,950,0003125 Pope AveSacramento CA 95821View Listing
$1,895,0001038 46th StSacramento CA 95819View Listing
$1,865,0002101 G StSacramento CA 95816View Listing
$1,829,000741 Estates DrSacramento CA 95864View Listing
$1,789,0001000 47th StSacramento CA 95819View Listing
$1,592,5001636 47th StSacramento CA 95819View Listing
$1,549,0004010 Wycombe DrSacramento CA 95864View Listing
$1,525,000749 41st StSacramento CA 95819View Listing
$1,500,0008111 Stallion WaySacramento CA 95830View Listing
$1,490,0001419 30th StSacramento CA 95816View Listing
$1,450,0001600 3rd AveSacramento CA 95818View Listing
$1,439,0002382 5th AveSacramento CA 95818View Listing
$1,420,0002735 14th StSacramento CA 95818View Listing
$1,399,999513 53rd StSacramento CA 95819View Listing
$1,350,0002948 25th StSacramento CA 95818View 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 5:14:33 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
