|
|
 |
|
|
|
|
|
| Lufkin, TX Homes |
R & H Mobile Housing of Lufkin, Texas
Manufactured Homes from Patriot, Cappaert, Fleetwood!
"Neighbors Helping Neighbors"
Over 49 years of combined Experience!
-
Single Wides
-
Double Wides
-
Triple Wides
*New *Used *Repo
We're here to STAY and we're here to make sure you are happy with your new home!
|
|
|
SELECT * FROM CLASSIFIED_DATA CD, COMPANY C WHERE CD.COMPANY_ID = C.ID AND CD.ITEM_CATEGORY_ID = 29 AND CD.STATUS_ID = 'ACT' AND CD.STATE_CD LIKE '%|TX|%' OR CD.COMPANY_ID = C.ID AND CD.ITEM_CATEGORY_ID = 29 AND CD.STATUS_ID = 'ACT' AND CD.STATE_CD LIKE '%|TX|%' OR CD.COMPANY_ID = C.ID AND CD.ITEM_CATEGORY_ID = 29 AND CD.STATUS_ID = 'ACT' AND CD.STATE_CD LIKE '%|TX|%' ORDER BY C.REVENUE DESC, C.COMPANY_NAME ASC |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|