|
|
 |
|
|
|
Manufactured Brands Home Builders
|
|
| Factory Expo Home Centers |
Factory Expo Home Centers
Factory-direct pricing that saves you $$$$
FREE factory tours available – see how your home is built from the ground up!
Over 30 different models on location at the factory!
Complimentary hotel accommodations available.
|
|
|
SELECT * FROM CLASSIFIED_DATA CD, COMPANY C WHERE CD.COMPANY_ID = C.ID AND CD.ITEM_CATEGORY_ID = 11 AND CD.STATUS_ID = 'ACT' AND CD.STATE_CD LIKE '%|IA|%' OR CD.COMPANY_ID = C.ID AND CD.ITEM_CATEGORY_ID = 11 AND CD.STATUS_ID = 'ACT' AND CD.STATE_CD LIKE '%|IA|%' OR CD.COMPANY_ID = C.ID AND CD.ITEM_CATEGORY_ID = 11 AND CD.STATUS_ID = 'ACT' AND CD.STATE_CD LIKE '%|IA|%' ORDER BY C.REVENUE DESC, C.COMPANY_NAME ASC |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|