First Realty Company | Kaar Search

Properties
Buying
Selling
Careers
Agents
Contact
Auctions
Relocation

SELECT * FROM `kaar_rets_comm` WHERE 1 AND (AGENTID = '5742') ORDER BY FIELD(OFFICEID, 1048,1572) DESC, LP DESC LIMIT 0,10

Search Results - Page 1 (of 0)

Showing results 1 thru 0 out of 0 Commercial Listings. Refine Search

© 2008 First Realty Company, Designed by: Firefly Creative Media
116 South Lowe Avenue • Cookeville, TN 38501
Phone: 931-528-1573 • Email: info@firstrealty.net