SELECT *, CASE WHEN `name` LIKE "carson city%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "carson city" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "carson city" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "carson city" 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 = "NV" AND (locality IN ("carson city") 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 20
Blah
SELECT *, CASE WHEN `name` LIKE "carson city%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "carson city" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "carson city" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "carson city" 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 = "NV" AND (locality IN ("carson city") OR locality IS NULL) AND slide_location IN ("city-agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[1] matching rows / [0.00 msec]
Blog ID 20
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,950,000273 Swifts Station DrCarson City NV 89705View Listing
$12,750,0003532 Knob Point Trl Unit 108Carson City NV 89705View Listing
$11,750,000212 Overlook DrCarson City NV 89705View Listing
$11,250,000269 Redding WayCarson City NV 89705View Listing
$10,000,000200 Overlook Dr Unit 29Carson City NV 89705View Listing
$9,998,000183 Scenic Range CtCarson City NV 89705View Listing
$9,475,000153 Walton Toll RdCarson City NV 89705View Listing
$4,500,000298 Senecas CtCarson City NV 89705View Listing
$4,300,000249 Mill Race LoopCarson City NV 89705View Listing
$4,200,0003465 Alura Ln Unit 1Carson City NV 89705View Listing
$3,650,000280 Mill Race LoopCarson City NV 89705View Listing
$2,995,0001860 W Winnie LnCarson City NV 89703View Listing
$2,899,0002032 Ash Canyon RdCarson City NV 89703View Listing
$2,400,000102 N Curry StCarson City NV 89703View Listing
$2,395,0002650 Manhattan DrCarson City NV 89703View Listing
$2,350,0003000 Old Clear Creek RdCarson City NV 89705View Listing
$2,149,0002750 Manhattan DrCarson City NV 89703View Listing
$1,575,0004370 Timberline DrCarson City NV 89703View Listing
$1,350,0002555 Wellington SCarson City NV 89703View Listing
$1,200,0003606 Hobbyhorse LnCarson City NV 89701View Listing
$1,150,0002186 Canterbury LnCarson City NV 89703View Listing
$1,100,0004040 County Line RdCarson City NV 89703View Listing
$1,074,9955780 Laurel RdCarson City NV 89701View Listing
$1,000,0002043 Emily CtCarson City NV 89703View 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-04-2024 11:15:08 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NV" 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 20
Blah