INBOUND L1:0 L2:10 Primary Category:(326)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 (326,2455,2456) 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) Real Estate Development

Real Estate Development




Jaymarc Homes

7525 SE 24th St, Ste 487, Mercer Island WA 98040

(425) 226-9100

48

Bill Beazley Homes

3002 Haynes Station Dr, Augusta GA 30909

(706) 790-1797

46

FSBOHomes.com

576 Boyson Rd NE, Ste 106, Cedar Rapids IA 52402

(319) 373-8150

46

Flight Facilities Inc

16508 Arminta St, Van Nuys CA 91406

(818) 989-7623

43

Stoneridge Homes

4707 NE Minnehaha St, Ste 305, Vancouver WA 98661

(360) 949-7705

43

United Landmark Associates

3708 W Swann Ave, Ste 103, Tampa FL 33609

(813) 870-9519

43

Peli Peli

110 Vintage Park Blvd, Ste P, Houston TX 77070

(281) 257-9500

43

Oxord Exchange LLC

420 W Kennedy Blvd, Tampa FL 33606

(813) 254-1036

42

West Bend Property Company LLC

2754 NW Crossing Dr, Ste 201, Bend OR 97701

(541) 312-6473

42

The Walter Company

400 S Beverly Dr, Ste 411, Beverly Hills CA 90212

(310) 888-2399

42