SELECT *, CASE WHEN `name` LIKE "johnson city%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "johnson city" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "johnson city" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "johnson 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 = "TN" AND (locality IN ("johnson 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 47
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "TN" 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 47
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.
$4,500,000370 Roy Martin RdJohnson City TN 37615View Listing
$2,600,000108 Blevins RdJohnson City TN 37601View Listing
$2,600,000450 Lake ApproachJohnson City TN 37601View Listing
$1,400,0004206 Bristol HwyJohnson City TN 37601View Listing
$1,125,000138 Simmons RdgJohnson City TN 37604View Listing
$1,099,000120 Willows Ridge CtJohnson City TN 37601View Listing
$999,900130 Minga DrJohnson City TN 37604View Listing
$999,000301 Sunset Ridge CtJohnson City TN 37615View Listing
$985,00011 Carriage CtJohnson City TN 37604View Listing
$974,000118 Willows Ridge CtJohnson City TN 37601View Listing
$949,000165 Trail LnJohnson City TN 37615View Listing
$935,000204 Highland Ridge TerJohnson City TN 37615View Listing
$820,000107 Strawberry Field DrJohnson City TN 37604View Listing
$799,9002782 Watauga RdJohnson City TN 37601View Listing
$799,9001299 Brumit FldsJohnson City TN 37615View Listing
$799,000131 Reed CirJohnson City TN 37601View Listing
$775,0001904 Roundtree DrJohnson City TN 37604View Listing
$769,500300 Woodbriar DrJohnson City TN 37604View Listing
$749,899Old Buffalo RdJohnson City TN 37601View Listing
$749,500135 Fairridge RdJohnson City TN 37604View Listing
$735,0001119 Waterbrooke LnJohnson City TN 37604View Listing
$729,0001451 Brumit FldsJohnson City TN 37615View Listing
$725,0001038 Hunters Lake DrJohnson City TN 37604View Listing
$699,9002115 Sawyers Pond DrJohnson City TN 37604View 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-19-2024 2:51:39 pm.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "TN" 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 47
Blah