<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%> <% var Providers_list__MMColParam = "1"; if (String(Request.QueryString("provider_num")) != "undefined" && String(Request.QueryString("provider_num")) != "") { Providers_list__MMColParam = String(Request.QueryString("provider_num")); } %> <% var Providers_list = Server.CreateObject("ADODB.Recordset"); Providers_list.ActiveConnection = MM_CCommunity_DB_STRING; Providers_list.Source = "SELECT * FROM Providers WHERE Provider_number = "+ Providers_list__MMColParam.replace(/'/g, "''") + ""; Providers_list.CursorType = 0; Providers_list.CursorLocation = 2; Providers_list.LockType = 1; Providers_list.Open(); var Providers_list_numRows = 0; %> <% var Provider_contact__MMColParam = "1"; if (String(Request.QueryString("Provider_num")) != "undefined" && String(Request.QueryString("Provider_num")) != "") { Provider_contact__MMColParam = String(Request.QueryString("Provider_num")); } %> <% var Provider_contact = Server.CreateObject("ADODB.Recordset"); Provider_contact.ActiveConnection = MM_CCommunity_DB_STRING; Provider_contact.Source = "SELECT * FROM Provider_contacts WHERE Provider_number = "+ Provider_contact__MMColParam.replace(/'/g, "''") + " ORDER BY Sort_field ASC"; Provider_contact.CursorType = 0; Provider_contact.CursorLocation = 2; Provider_contact.LockType = 1; Provider_contact.Open(); var Provider_contact_numRows = 0; %> <% var Provider_desc__MMColParam = "1"; if (String(Request.QueryString("Provider_num")) != "undefined" && String(Request.QueryString("Provider_num")) != "") { Provider_desc__MMColParam = String(Request.QueryString("Provider_num")); } %> <% var Provider_desc = Server.CreateObject("ADODB.Recordset"); Provider_desc.ActiveConnection = MM_CCommunity_DB_STRING; Provider_desc.Source = "SELECT * FROM Service_desc WHERE Provider_number = "+ Provider_desc__MMColParam.replace(/'/g, "''") + ""; Provider_desc.CursorType = 0; Provider_desc.CursorLocation = 2; Provider_desc.LockType = 1; Provider_desc.Open(); var Provider_desc_numRows = 0; %> <% var Provider_internet__MMColParam = "1"; if (String(Request.QueryString("Provider_num")) != "undefined" && String(Request.QueryString("Provider_num")) != "") { Provider_internet__MMColParam = String(Request.QueryString("Provider_num")); } %> <% var Provider_internet = Server.CreateObject("ADODB.Recordset"); Provider_internet.ActiveConnection = MM_CCommunity_DB_STRING; Provider_internet.Source = "SELECT Contact_label, Hyperlink_name, Link FROM Provider_internet WHERE Provider_number = "+ Provider_internet__MMColParam.replace(/'/g, "''") + " ORDER BY Sort_field ASC"; Provider_internet.CursorType = 0; Provider_internet.CursorLocation = 2; Provider_internet.LockType = 1; Provider_internet.Open(); var Provider_internet_numRows = 0; %> <% var Provider_legal__MMColParam = "1"; if (String(Request.QueryString("Provider_num")) != "undefined" && String(Request.QueryString("Provider_num")) != "") { Provider_legal__MMColParam = String(Request.QueryString("Provider_num")); } %> <% var Provider_legal = Server.CreateObject("ADODB.Recordset"); Provider_legal.ActiveConnection = MM_CCommunity_DB_STRING; Provider_legal.Source = "SELECT * FROM Provider_legal_items WHERE Provider_number = "+ Provider_legal__MMColParam.replace(/'/g, "''") + ""; Provider_legal.CursorType = 0; Provider_legal.CursorLocation = 2; Provider_legal.LockType = 1; Provider_legal.Open(); var Provider_legal_numRows = 0; %> <% var Repeat2__numRows = -1; var Repeat2__index = 0; Provider_contact_numRows += Repeat2__numRows; %> <% var Repeat3__numRows = -1; var Repeat3__index = 0; Provider_internet_numRows += Repeat3__numRows; %> <% var Repeat1__numRows = -1; var Repeat1__index = 0; Provider_legal_numRows += Repeat1__numRows; %> Learning Center Provider Profile for CCommunity
   
 
Main Company Profile Visit Communities Service Providers Press Releases Contact Us FAQ

Click on the community name in the Jump Menu

Jump Menu

or click on one of the pictures below

Woodfield Hunt Club CommunityWoodfield Hunt Club

Long Lake Estates CommunityLong Lake Estates

Fieldbrook Estates CommunityWoodfield Hunt Club

Residents of Andover, Seasons, The Preserve, and The Hamlet should click on the communty picture on the left to enter the specific website for their community. You will be prompted for your password on some portions of the website.

 

Chat with CCommunity.com

 

Learning Center Provider Profile for CCommunity

 

">
">
">
">
">
">

 
" border="1">
Company name:

<%=(Providers_list.Fields.Item("Company_name").Value)%>
Address: <%=(Providers_list.Fields.Item("Address_1").Value)%> <%=(Providers_list.Fields.Item("Address_2").Value)%>

 

<%=(Providers_list.Fields.Item("City").Value)%>, <%=(Providers_list.Fields.Item("State").Value)%> <%=(Providers_list.Fields.Item("zip").Value)%>

Contact name:

<%=(Providers_list.Fields.Item("Contact_name").Value)%>
<% while ((Repeat2__numRows-- != 0) && (!Provider_contact.EOF)) { %> <% Repeat2__index++; Provider_contact.MoveNext(); } %>
<%=(Provider_contact.Fields.Item("Contact_label").Value)%> (<%=(Provider_contact.Fields.Item("Set1").Value)%>) <%=(Provider_contact.Fields.Item("set2").Value)%>- <%=(Provider_contact.Fields.Item("set3").Value)%>  <%=(Provider_contact.Fields.Item("set4").Value)%>
<% while ((Repeat3__numRows-- != 0) && (!Provider_internet.EOF)) { %> <% Repeat3__index++; Provider_internet.MoveNext(); } %>
<%=(Provider_internet.Fields.Item("Contact_label").Value)%> " target="_blank" class="link"><%=(Provider_internet.Fields.Item("Hyperlink_name").Value)%>
Legal Item Value
<% while ((Repeat1__numRows-- != 0) && (!Provider_legal.EOF)) { %> <% Repeat1__index++; Provider_legal.MoveNext(); } %>
<%=(Provider_legal.Fields.Item("Provider_item").Value)%> <%=(Provider_legal.Fields.Item("Provider_item_link").Value)%> " target="_blank" class="link"><%=(Provider_legal.Fields.Item("Item_link_label").Value)%>
About our Business:
"> <%=(Provider_desc.Fields.Item("Desc1").Value)%>
"> <%=(Provider_desc.Fields.Item("Desc2").Value)%>
"> <%=(Provider_desc.Fields.Item("Desc3").Value)%>
"> <%=(Provider_desc.Fields.Item("Desc4").Value)%>
"> <%=(Provider_desc.Fields.Item("Desc5").Value)%>
"> <%=(Provider_desc.Fields.Item("Desc6").Value)%>
"> <%=(Provider_desc.Fields.Item("Desc7").Value)%>
"> <%=(Provider_desc.Fields.Item("Desc8").Value)%>
"> <%=(Provider_desc.Fields.Item("Desc9").Value)%>
"> <%=(Provider_desc.Fields.Item("Desc10").Value)%>

 

Copyright notice • Disclaimer • Patent • Privacy Statement • Better Business Bureau
© Copyright CCommunity.com 2004 All rights reserved
CCommunity.com is a registered service mark

Patent Pending status awarded for unique business process

The names and/or logos of the listed communities belong to the repective communities. Inclusion does not imply specific endorsement of services offered by CCommunity.

<% Providers_list.Close(); %> <% Provider_contact.Close(); %> <% Provider_desc.Close(); %> <% Provider_internet.Close(); %> <% Provider_legal.Close(); %>