DEBUG: [SELECT SQL_CALC_FOUND_ROWS DISTINCT(directory.id), directory.* FROM directory LEFT OUTER JOIN directory_categories_link ON directory.id=directory_categories_link.directory_id WHERE active='Y' AND directory.company LIKE '4%' ORDER BY bannerlinkactive DESC, directory.company LIMIT 0,10]

Search Results

Found 2 results
1: 4-B Wood Custom Cabinets - Seville OH US
Phone: 330 769-2188 Web: www.4bwood.com (2045 clicks)

2: 4M Ranch Log Guest Cabin and B&B - Pray MT US
Contact: Ginger and Phil Keck Phone: 403 333-4784 Email: (3174 clicks) Web: www.4mranch.net (2133 clicks)

<< Previous	Next >>
Perform another search