SELECT *, CASE WHEN `locality` LIKE "fall creek%" 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 ("fall creek") 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.
$44,505,00014600 N Olio RdNoblesville IN 46060View Listing
$8,499,99911101 W Hawthorn RdgFishers IN 46037View Listing
$6,590,00012304 E 196th StNoblesville IN 46060View Listing
$4,900,000115 W State Road 38Pendleton IN 46064View Listing
$4,500,000Cherry Tree Rd Lot 10100200Noblesville IN 46062View Listing
$4,500,00010571 E 116th StFishers IN 46037View Listing
$3,200,00011052 Cumberland RdFishers IN 46037View Listing
$2,999,00022100 Cammack-000-005 001-008 Rd Lot 29-06Noblesville IN 46062View Listing
$2,995,00014101 E 113th StFishers IN 46040View Listing
$2,696,969405 Breakwater DrFishers IN 46037View Listing
$2,650,25011038 Greenfield AveNoblesville IN 46060View Listing
$2,511,600James RdNoblesville IN 46062View 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