SELECT *, CASE WHEN `locality` LIKE "princeton%" 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 = "TX" AND (locality IN ("princeton") 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 37
Blah
SELECT *, CASE WHEN `locality` LIKE "princeton%" AND `slide_location` = "city-agent" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `slide_location` = "city-agent" AND `logo_file_name` IS NOT NULL THEN 5 END as `rank` FROM `wp_slides` WHERE st = "TX" AND (locality IN ("princeton") OR locality IS NULL) AND slide_location IN ("city-agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[4] matching rows / [0.00 msec]
Blog ID 37
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.
$24,000,0003550 N Custer RdMcKinney TX 75071View Listing
$13,082,030402 County Road 695Farmersville TX 75442View Listing
$12,600,0002364 FM 75Princeton TX 75407View Listing
$12,546,1672315 E Audie Murphy PkwyFarmersville TX 75442View Listing
$10,301,9401392 Old Mill RdMcKinney TX 75069View Listing
$9,750,0002472 FM 982Princeton TX 75407View Listing
$8,000,0003034 County Road 463Princeton TX 75407View Listing
$6,600,00016776 County Road 668Farmersville TX 75442View Listing
$6,000,00010 Ac E US Highway 380McKinney TX 75069View Listing
$5,555,6253868 County Road 494Princeton TX 75407View Listing
$5,304,060Tbv County Road 850Farmersville TX 75442View Listing
$5,200,00016485 County Road 617Farmersville TX 75442View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
SELECT *, CASE WHEN `locality` LIKE "princeton%" AND `slide_location` = "city-lenders-title-lower" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `slide_location` = "city-lenders-title-lower" AND `logo_file_name` IS NOT NULL THEN 5 END as `rank` FROM `wp_slides` WHERE st = "TX" AND (locality IN ("princeton") OR locality IS NULL) AND slide_location IN ("city-lenders-title-lower") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[2] matching rows / [0.00 msec]
Blog ID 37
Blah