Canton Economic Development
Developing north country business opportunitiesPromoting recreational tourism in the north country.
Canton New York Office of Economic Development

Contact Us ~ Services Offered ~ Our 6 Year Develpment Plan ~ Strategic Advantages ~ Related Links ~ Home

View Zoning Map Zoning Key: C-1 = Retail Commerial C-2 = General Commercial C-3 = Commercial Park District
M-1 = Manufacturing B-1 = Business

Please Note: Other properties are available that require special permits. Please contact one of the real estate agents listed for further inquiries. Click on the images below to see a larger version. View a listing of Canton's Strategic Advantages for business. <% 'this shows what is before the needed asp code 'Declare a record set dim oRS 'Create a record set object to store data in set oRS=Server.createObject("ADODB.recordset") 'Set up the SQL statement sSQL = "select * from CommercialProperty" 'name of table that info drawn from 'Add an ORDER BY clause to the SQL to sort the records sSQL = sSQL & " order by zoning;" 'a field in table if you want it ordered 'Run the query and store the results in the oRS record set oRS.Open sSQL, "dsn=ced" 'this is where you enter the name of the DSN set up by ISP if oRS.EOF then 'No records found; eof = end of file response.write "

No records found" else oRS.MoveFirst Response.write "" 'Loop through the record set and build HTML code to fill the table with items Do while NOT oRS.EOF 'enter as many fields as you want to display from the table Response.write "" oRS.MoveNext if not oRS.EOF then Response.write "" Response.write "" oRS.MoveNext End if Loop end if Response.Write "
" Response.write "" & _ "" & "
" Response.write "" Response.write "Location: " & oRS("Location") & "
" Response.write "Zoning: " & oRS("Zoning") & "
" Response.write "Square Footage: " & oRS("SquareFootage") & "
" Response.write "For: " & oRS("SaleRent") & "
" Response.write "Price $: " & oRS("Price") & "
" Response.write "Contact: " & oRS("Contact") & "
" Response.write "Comments: " & oRS("Comments") & "
" ' Response.write ": " & oRS("") & "
" Response.write "
" Response.write "" & _ "" & "
" Response.write "" Response.write "Location: " & oRS("Location") & "
" Response.write "Zoning: " & oRS("Zoning") & "
" Response.write "Square Footage: " & oRS("SquareFootage") & "
" Response.write "For: " & oRS("SaleRent") & "
" Response.write "Price $: " & oRS("Price") & "
" Response.write "Contact: " & oRS("Contact") & "
" Response.write "Comments: " & oRS("Comments") & "
" ' Response.write ": " & oRS("") & "
" Response.write "
" %>

Contact Us ~ Services Offered ~ Our 6 Year Develpment Plan ~ Related Links ~ Home

Copyright Canton Office of Economic Development 2002

<% 'oRS =object record set this is the file cabinet or holder for a bunch of records '=comment%>