SELECT *, CASE WHEN `locality` LIKE "west lafayette%" AND `slide_location` = "" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `slide_location` = "" AND `logo_file_name` IS NOT NULL THEN 5 END as `rank` FROM `wp_slides` WHERE st = "IN" AND (locality IN ("west lafayette") 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 25
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "IN" 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 25
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.
$1,500,0004727 N 140 WWest Lafayette IN 47906View Listing
$665,000641 Fox TrlWest Lafayette IN 47906View Listing
$615,000US 231 Hwy NWest Lafayette IN 47906View Listing
$489,0002722 Jaydin DrBattle Ground IN 47920View Listing
$480,0001204 E 900 NBattle Ground IN 47920View Listing
$480,0007201 Robert Ross LnWest Lafayette IN 47906View Listing
$375,0006730 Pretty Prairie RdBattle Ground IN 47920View Listing
$349,9009005 S 700 WWestpoint IN 47992View Listing
$349,9004022 Jackson HwyWest Lafayette IN 47906View Listing
$325,0004251 Morehouse RdWest Lafayette IN 47906View Listing
$310,0004138 Division RdWest Lafayette IN 47906View Listing
$260,0006534 N 300 EWest Lafayette IN 47906View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "IN" 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 25
Blah
Commercial
Land
Ranch
Single Family
