INBOUND L1:0 L2:10 Primary Category:(631)Premium Listing Activation Pending: (0) (10)
L1:0 PC:1SELECT s.* FROM (SELECT DISTINCT l.*,@curRow := ifnull(@curRow,-2) + 1 as position FROM pmd_listings l INNER JOIN pmd_listings_categories c ON l.id=c.list_id AND c.cat_id IN (631) WHERE (l.product_id=1) ORDER BY 'claimed' DESC, zapscore DESC) s WHERE position >=0 LIMIT 10array(0) { }
Remainder:9
bool(true) Restaurants Seafood

Restaurants Seafood



Klenda Seafood

104 Thadeus St, South Portland ME 04106

(207) 799-0155

56

Rustler's Rooste

8383 S 48th St, Phoenix AZ 85044

(602) 431-6474

47

Trenton Bridge Lobster Pound

1237 Bar Harbor Rd, Ellsworth ME 04605

(207) 667-2977

46

Golden Rule Grocery

17505 S Dixie Hwy, Miami FL 33157

(305) 235-0661

45

RumFish Grill

6000 Gulf Blvd, Saint Petersburg FL 33706

(727) 329-1428

44

Le Bayou

208 Bourbon St, New Orleans LA 70130

(504) 525-4755

44

Avasant

3601 N Aviation Blvd, Ste 3000, Manhattan Beach CA 90266

(310) 643-3030

43

The Franciscan Crab Restaurant

1 Fishermans Wharf, San Francisco CA 94133

(415) 362-7733

42

Real Seafood Company

341 S Main St, Ann Arbor MI 48104

(734) 769-5960

41

Congressional Seafood

7901 Oceano Ave, Jessup MD 20794

(301) 621-1933

40