SELECT * FROM `city_to_business` WHERE `city_id` = '76612' AND `category_id` ='39000'AND page_listing_number BETWEEN '0' AND '20'
red A
McRoberts & Associates
407 Uluniu St, Ste 211
Kailua, HI
red B
Royal Alliance Association Incorporated
Po Box 4792
Kaneohe, HI
red C
Royal Alliance Associates
1100 Ward Ave, #670
Honolulu, HI
red D
Matsushita, Bruce - Matsushita Bruce
1188 Bishop St, #1904
Honolulu, HI
red E
Kuroman Realty Incorporated
1188 Bishop St, #1712
Honolulu, HI
red F
Pacific M & A Group Incorporated
Honolulu, HI
red G
Royal Alliance Associates
1003 Bishop St, Ste 450
Honolulu, HI
red H
Royal Alliance Associates
1001 Bishop St, Ste 1508
Honolulu, HI
red I
Vr Business Brokers Hawaii
1221 Kapiolani Blvd
Honolulu, HI
red J
Royal Alliance Associates
55 Merchant St, Ste 1813
Honolulu, HI
red K
Clayton E Agena & Association
55 Merchant St, #1940
Honolulu, HI
red L
Royal Alliance Associates
1019 Waimanu St, #208
Honolulu, HI
red M
Takagi Verne T Cpf
500 Ala Moana Blvd, Ste 2-301
Honolulu, HI
