SELECT TOP 100 PERCENT tpaddenftp.n2n_company.id, tpaddenftp.n2n_company.companyname, tpaddenftp.n2n_company.phone, tpaddenftp.n2n_company.fax, tpaddenftp.n2n_company.email, tpaddenftp.n2n_company.contact, tpaddenftp.n2n_company.maddress, tpaddenftp.n2n_company.maddress2, tpaddenftp.n2n_company.mcity, tpaddenftp.n2n_company.mstate, tpaddenftp.n2n_company.mzip, tpaddenftp.n2n_company.territory, dbo.n2n_company_territory.territory_id FROM tpaddenftp.n2n_company INNER JOIN dbo.n2n_company_territory ON tpaddenftp.n2n_company.id = dbo.n2n_company_territory.company_id WHERE (tpaddenftp.n2n_company.acttype = 'r') AND (tpaddenftp.n2n_company.active = 1) AND (tpaddenftp.n2n_company.pending = 0) and dbo.n2n_company_territory.territory_id=#url.state# ORDER BY tpaddenftp.n2n_company.companyname
Find the Nation2Nation representative for your area.


#companyname#
#maddress#
#maddress2#
#mcity#, #mstate# #mzip#
Phone #phone#
Fax #fax#
E-mail #email#

Territory:
#territory#


Nation2Nation Imports
P.O. Box 5060
Austin Texas 78763
sales@nation2nation.com
Phone 1-866-458-6015
Fax 1-866-458-6015