|
|
 |
|
|
|
|
|
| Kerrville, TX Homes |
Spears Homes, Inc. has the LARGEST SELECTION OF NEW HOMES IN THE HILL COUNTRY!
Why Spears Mobile Homes??
-
Home Selections
-
Choice of Locations
-
Quality and Service
Featuring homes by Karsten, Patriot Homes, Clayton, Schult, and Centara
|
|
|
SELECT * FROM CLASSIFIED_DATA CD, COMPANY C WHERE CD.COMPANY_ID = C.ID AND CD.ITEM_CATEGORY_ID = 30 AND CD.STATUS_ID = 'ACT' AND CD.STATE_CD LIKE '%|TX|%' OR CD.COMPANY_ID = C.ID AND CD.ITEM_CATEGORY_ID = 30 AND CD.STATUS_ID = 'ACT' AND CD.STATE_CD LIKE '%|TX|%' OR CD.COMPANY_ID = C.ID AND CD.ITEM_CATEGORY_ID = 30 AND CD.STATUS_ID = 'ACT' AND CD.STATE_CD LIKE '%|TX|%' ORDER BY C.REVENUE DESC, C.COMPANY_NAME ASC |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|