INBOUND L1:0 L2:10 Primary Category:(1494)Premium Listing Activation Pending: (0) (10)
L1:0 PC:1
SELECT * FROM (SELECT @myRow := ifnull(@myRow,-2) + 1 as position, s.* FROM (SELECT DISTINCT l.* FROM pmd_listings l INNER JOIN pmd_listings_categories c ON l.id=c.list_id AND c.cat_id IN (1494) WHERE (l.product_id=1) ORDER BY 'claimed' DESC, zapscore DESC) s)p WHERE position >=0 LIMIT 10
No Results from PQ
Remainder:9
bool(true) Building Restoration & Preservation

Building Restoration & Preservation



Natchitoches Historic Foundation Inc

550 2nd St, Natchitoches LA 71457

(318) 352-0990

40

Cypress Design

15 Dexter Rd, East Providence RI 02914

(401) 438-5105

38

Historic Macon Foundation

935 High St, Macon GA 31201

(478) 742-5084

38

Nantucket Preservation Trust

53 Main St, Nantucket MA 02554

(508) 228-1387

37

ExterPro Inc

Logan UT 84321

(435) 890-4446

36

Building Character

342 N Queen St, Lancaster PA 17603

(717) 394-7201

35

Port Townsend Main Street Program

211 Taylor St, Ste 1, Port Townsend WA 98368

(360) 385-7911

35

Horn In The West Executive Ofc

591 Horn In The West Dr, Boone NC 28607

(828) 264-2120

35

Degruchy Masonry Inc

266 Rock Hill Rd, Quakertown PA 18951

(215) 536-4482

34

First Finish Inc

8300 Guilford Rd, Ste F, Columbia MD 21046

(410) 290-6450

34