<%

	Dim SQL1, SQL2
	Dim Conn, RS, RS2
	
	Set Conn = Server.CreateObject("ADODB.Connection")
	Conn.Open "DRIVER={SQL Server};SERVER=WEBSRV01;UID=web;pwd=w3bs1t3;DATABASE=AVANTE"

	
	SQL1 = "Select * from Entity E inner join Entity_Detail ED on E.Entity_ID = ED.Entity_ID where E.Entity_ID = '3553'" 
	'& Request.QueryString("Entity_ID") & "'"
		
	Set RS=Conn.Execute(SQL1)
	
	SQL2 = "Select * from Entity E inner join (Group_Entity_Map GEM inner join (Att_Group_Map AGM Inner Join Attribute_Type A on AGM.ATT_ID = A.ATT_ID) on GEM.Group_ID = AGM.Group_ID)	on E.Entity_ID = GEM.Entity_ID Where E.Entity_ID = '" & Request.QueryString("Entity_ID") & "'"
		
	Set RS2=Conn.Execute(SQL2)
	
	




%>


<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="/Style-sheets/standard-input-form.css" type="text/css">
<link rel="stylesheet" href="/Style-sheets/headline.css" type="text/css">
<link rel="stylesheet" href="/Style-sheets/galley-text-indent.css" type="text/css">
<script language="JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
//-->
</script>
<link rel="stylesheet" href="/Style-sheets/Profile-layout.css" type="text/css">
<table width="99%" border="0" cellspacing="0" cellpadding="0" align="center" background="/images/bkgrnd-test.gif">
  <tr> 
    <td width="1%" bgcolor="#FFFFFF" height="38"></td>
    <td align="right" width="98%" valign="bottom" height="38"> 
      <table width="100%" border="0" cellspacing="0" cellpadding="0" background="/images/bckgrnd-ffffff.gif">
        <tr> 
          <td width="36%" valign="bottom" bgcolor="#FFFFFF"><a href="JavaScript:if (1);" onClick="JavaScript:window.open('http://216.64.196.139/servlet/hpLiveHelperChat?ACTION=SENDNAMEENTRYSCREEN&COMPANYID=1039891&GROUPNAME=Support', 'nameEntry', 'height=300,width=295,toolbar=no,menubar=no,directories=no,resizable=no'); return;"></a> 
            <table border="0" cellspacing="0" cellpadding="0" width="100%">
              <tr> 
                <td valign="bottom" align="center" width="56%"><a href="JavaScript:if (1);" onClick="JavaScript:window.open('http://216.64.196.139/servlet/hpLiveHelperChat?ACTION=SENDNAMEENTRYSCREEN&COMPANYID=1039891&GROUPNAME=Support', 'nameEntry', 'height=300,width=295,toolbar=no,menubar=no,directories=no,resizable=no'); return;"><img src="/images/chat-images/live-help-banner-horizontal.gif" width="166" height="41" border= "0" alt="Ask our Vacation Specialists"></a></td>
                <td valign="bottom" align="center" width="44%">&nbsp;</td>
              </tr>
            </table>
          </td>
          <td width="8%" valign="bottom" bgcolor="#FFFFFF">&nbsp;</td>
          <td align="right" width="56%" valign="bottom" bgcolor="#FFFFFF"> 
            <table border="0" cellpadding="0" cellspacing="0">
              <!-- fwtable fwsrc="test-bar-3.png" fwbase="test-bar-3-framed-live.gif" -->
              <tr> 
                <!-- Shim row, height 1. -->
                <td><img src="/images/top-bar/shim.gif" width="88" height="1" border="0"></td>
                <td><img src="/images/top-bar/shim.gif" width="99" height="1" border="0"></td>
                <td><img src="/images/top-bar/shim.gif" width="103" height="1" border="0"></td>
                <td><img src="/images/top-bar/shim.gif" width="96" height="1" border="0"></td>
                <td><img src="/images/top-bar/shim.gif" width="114" height="1" border="0"></td>
              </tr>
              <tr valign="top"> 
                <!-- row 1 -->
                <td><a href="/main-lodging-full.asp"><img name="testbar3framedlive_r1_c1" src="/images/top-bar/test-bar-3-framed-select_r1_c1.gif" width="88" height="20" border="0"></a></td>
                <td><a href="/main-packages-full.asp"><img name="testbar3framedlive_r1_c2" src="/images/top-bar/test-bar-3-framed-dimmed_r1_c2.gif" width="99" height="20" border="0"></a></td>
                <td><a href="/main-attractions-full.asp"><img name="testbar3framedlive_r1_c3" src="/images/top-bar/test-bar-3-framed-dimmed_r1_c3.gif" width="103" height="20" border="0"></a></td>
                <td><a href="/main-events-full.asp"><img name="testbar3framedlive_r1_c4" src="/images/top-bar/test-bar-3-framed-dimmed_r1_c4.gif" width="96" height="20" border="0"></a></td>
                <td><a href="/main-destinations-full.asp"><img name="testbar3framedlive_r1_c5" src="/images/top-bar/test-bar-3-framed-dimmed_r1_c5.gif" width="114" height="20" border="0"></a></td>
              </tr>
              <!--   This table was automatically created with Macromedia Fireworks 3.0   -->
              <!--   http://www.macromedia.com   -->
            </table>
          </td>
        </tr>
      </table>
    </td>
    <td align="right" width="1%" valign="bottom" bgcolor="#FFFFFF" height="38">&nbsp;</td>
  </tr>
  <tr> 
    <td width="1%" rowspan="2" valign="top"><img src="/images/corner-upper-left.gif" width="10" height="10"></td>
    <td width="98%" bgcolor="#2A2F88"><img src="/images/shim.gif" width="1" height="1"></td>
    <td rowspan="2" align="right" width="1%"><img src="/images/corner-upper-right.gif" width="10" height="10"></td>
  </tr>
  <tr valign="top"> 
    <td width="98%"><img src="/images/shim.gif" width="1" height="9"></td>
  </tr>
</table>
<table width="99%" border="0" cellspacing="0" cellpadding="0" align="center" background="/images/bkgrnd-test.gif">
  <tr> 
    <td bgcolor="#2A2F88" width="0%"><img src="/images/shim.gif" width="1" height="1"></td>
    <td width="100%" valign="top" align="center"> 
      <table width="96%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td>
            <table border="0" cellspacing="0" cellpadding="0" align="right">
              <tr> 
                <td>&nbsp;</td>
                <td align="right"><img src="/images/main-stage-tab-left.gif" width="10" height="20"></td>
                <td bgcolor="#2A2F88" align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#999999"><b>Ella 
                  Star Casino</b></font></td>
                <td bgcolor="#2A2F88" align="center"><img src="/images/main-stage-tab-join.gif" width="20" height="20"></td>
                <td bgcolor="#2A2F88" align="center"><b><span class="headline-ffffff"><%=RS("Name")%></span></b></td>
                <td bgcolor="#2A2F88" align="right"><font color="#2A2F88" size="1"><img src="/images/main-stage-tab-right.gif" width="20" height="20"></font></td>
              </tr>
            </table>
          </td>
        </tr>
        <tr>
          <td height="2"> 
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr bgcolor="#2A2F88" align="right"> 
                <td><img src="/images/main-stage-tab-shim.gif" width="20" height="3"></td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
      <table width="96%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td width="27%" valign="top">&nbsp; </td>
          <td width="73%" valign="top" align="right"> 
            <table width="96%" border="0" cellspacing="0" cellpadding="0">
              <tr align="center"> 
                <td class="row-spacing" valign="top" width="69%" align="left">&nbsp;</td>
                <td class="row-spacing" valign="top" width="31%" align="left">&nbsp;</td>
              </tr>
              <tr align="center"> 
                <td rowspan="2" valign="top" width="69%" align="left"> 
                  <table width="98%" border="0" cellspacing="0" cellpadding="0">
                    <tr> 
                      <td rowspan="2" align="center" width="51%" valign="top"><img src="/property-logos/LS-Logo.gif" width="136" height="86"><br>
                      </td>
                      <td align="right" width="49%"><span class="input-box">Deal 
                        Icon</span><img src="/images/single-orange.jpg" width="20" height="20"></td>
                    </tr>
                    <tr> 
                      <td align="right" width="49%" class="headline-bottom"><%=RS("Name")%><br>
                        <%=RS("Address_1")%><br>
                        <%=RS("City")%>, <%=RS("State")%>
                        <%=RS("Zip")%> 
                        <%If RS("Zip_4") <> "" Then Response.Write "-" & RS("Zip_4")%>
                      </td>
                    </tr>
                  </table>
                  <table width="98%" border="0" cellspacing="0" cellpadding="2">
                    <tr> 
                      <td height="20" width="51%" align="center"><span class="headline"> 
                        <%If not RS2.EOF Then%>
                        <%RS2.MoveFirst()
                      Do Until RS2.EOF%>
                        <% IF RS2("Att_Page") = "24" Then%>
                        <%If RS2("Variable") <> "" Then%>
                        <% If RS2("Att_ID") = "524" Then Response.Write RS2("Variable")%>
                        <%End If%>
                        <%End If%>
                        <%RS2.MoveNext()
                      Loop%>
                        <%RS2.MoveFirst()
                      End If%>
                        </span> </td>
                      <td height="20" width="49%" align="right" class="row-spacing">&nbsp; 
                      </td>
                    
                    <tr> 
                      <td height="49" rowspan="4" valign="top" width="51%" class="profile-text"> 
                        <%If not RS2.EOF Then%>
                        <%RS2.MoveFirst()
                      Do Until RS2.EOF%>
                        <% IF RS2("Att_Page") = "24" Then%>
                        <%If RS2("Variable") <> "" Then%>
                        <% If RS2("Att_ID") = "525" Then Response.Write RS2("Variable")%>
                        <%End If%>
                        <%End If%>
                        <%RS2.MoveNext()
                      Loop%>
                        <%RS2.MoveFirst()
                      End If%>
                      </td>
                      <td height="21" width="49%" align="right"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">Located 
                        XX miles from your start point<br>
                        <img src="/icons/location-map.jpg" width="79" height="12" onMouseDown="MM_openBrWindow('/map-pop.htm','','width=450,height=400')"></font></td>
                    </tr>
                    <tr align="right" valign="middle"> 
                      <td width="49%"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Price 
                        range $29.95 - $69.95 night&nbsp;&nbsp;<img src="/images/10p-single-orange.jpg" width="13" height="13"><img src="/images/10p-single-orange.jpg" width="13" height="13"></font><img src="/images/10p-single-orange.jpg" width="13" height="13"></td>
                    </tr>
                    <tr align="right"> 
                      <td width="49%"> </td>
                    </tr>
                    <tr align="right"> 
                      <td width="49%"> </td>
                    </tr>
                  </table>
                </td>
                <td rowspan="2" valign="top" width="31%" align="left"> 
                  <table width="200" border="0" cellspacing="4" cellpadding="0">
                    <tr> 
                      <td valign="middle" align="center"><img src="/property-images/LS-MVC-014S-Front of Hotel-300.jpg" width="200" height="150"></td>
                    </tr>
                    <tr> 
                      <td></td>
                    </tr>
                  </table>
                </td>
              </tr>
              <tr align="center"> </tr>
            </table>
            <table border="0" cellspacing="0" cellpadding="0" width="96%">
              <tr align="center"> 
                <td height="27" width="32%"><img src="/icons/package-plans.gif" width="115" height="15"></td>
                <td height="27" width="33%"><a href="/avail-accom_property-1.asp?Entity_ID=<%=RS("Entity_ID")%>"><img src="/icons/property-avail.gif" width="115" height="15" border="0"></a></td>
                <td height="27" width="35%"><img src="/icons/add-to-favorites.gif" width="115" height="15"></td>
              </tr>
            </table>
            <table width="96%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td><font face="Verdana, Arial, Helvetica, sans-serif" color="#2A2F88" size="2"><b class="sub-head">Lodging 
                  Features:</b></font></td>
              </tr>
              <tr> 
                <td width="95%" class="galley-text-indent" height="12"> 
                  <%If not RS2.EOF Then%>
                  <%RS2.MoveFirst()
                      Do Until RS2.EOF%>
                  <% IF RS2("Att_Page") = "1" Then%>
                  <%If RS2("Variable") <> "" Then%>
                  <% If RS2("Variable") = "True" Then Response.Write RS2("Att_Desc_Detail") & ", " Else Response.Write RS2("Att_Desc_Detail") & " : " & RS2("Variable") & ", "%>
                  <%End If%>
                  <%End If%>
                  <%RS2.MoveNext()
                      Loop%>
                  <%RS2.MoveFirst()
                      End If%>
                </td>
              </tr>
            </table>
            <table width="96%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td colspan="2"><font face="Verdana, Arial, Helvetica, sans-serif" color="#2A2F88" size="2"><b class="sub-head">Business 
                  Travelor Services: </b></font></td>
              </tr>
              <tr> 
                <td width="26">&nbsp;</td>
                <td width="501" class="form-captions">
                  <%If not RS2.EOF Then%>
                  <%RS2.MoveFirst()
                      Do Until RS2.EOF%>
                  <% IF RS2("Att_Page") = "2" Then%>
                  <%If RS2("Variable") <> "" Then%>
                  <% If RS2("Variable") = "True" Then Response.Write RS2("Att_Desc_Detail") & ", " Else Response.Write RS2("Att_Desc_Detail") & " : " & RS2("Variable") & ", "%>
                  <%End If%>
                  <%End If%>
                  <%RS2.MoveNext()
                      Loop%>
                  <%RS2.MoveFirst()
                      End If%>
                </td>
              </tr>
            </table>
            <table width="96%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td colspan="2"><font face="Verdana, Arial, Helvetica, sans-serif" color="#2A2F88" size="2"><b class="sub-head">Convention 
                  Facilities: </b></font></td>
              </tr>
              <tr> 
                <td width="26" height="12">&nbsp;</td>
                <td width="501" class="form-captions" height="12">
                  <%If not RS2.EOF Then%>
                  <%RS2.MoveFirst()
                      Do Until RS2.EOF%>
                  <% IF RS2("Att_Page") = "3" Then%>
                  <%If RS2("Variable") <> "" Then%>
                  <% If RS2("Variable") = "True" Then Response.Write RS2("Att_Desc_Detail") & ", " Else Response.Write RS2("Att_Desc_Detail") & " : " & RS2("Variable") & ", "%>
                  <%End If%>
                  <%End If%>
                  <%RS2.MoveNext()
                      Loop%>
                  <%RS2.MoveFirst()
                      End If%>
                </td>
              </tr>
            </table>
            <table width="96%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td colspan="2" class="sub-head">Dining &amp; Entertainment:</td>
              </tr>
              <tr> 
                <td width="26" height="12">&nbsp;</td>
                <td width="501" class="form-captions" height="12">
                  <%If not RS2.EOF Then%>
                  <%RS2.MoveFirst()
                      Do Until RS2.EOF%>
                  <% IF RS2("Att_Page") = "4" Then%>
                  <%If RS2("Variable") <> "" Then%>
                  <% If RS2("Variable") = "True" Then Response.Write RS2("Att_Desc_Detail") & ", " Else Response.Write RS2("Att_Desc_Detail") & " : " & RS2("Variable") & ", "%>
                  <%End If%>
                  <%End If%>
                  <%RS2.MoveNext()
                      Loop%>
                  <%RS2.MoveFirst()
                      End If%>
                </td>
              </tr>
            </table>
            <table width="96%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td colspan="2"><font face="Verdana, Arial, Helvetica, sans-serif" color="#2A2F88" size="2"><b class="sub-head">Guest 
                  Services Available:</b></font></td>
              </tr>
              <tr> 
                <td width="26" height="12">&nbsp;</td>
                <td width="501" class="form-captions" height="12">
                  <%If not RS2.EOF Then%>
                  <%RS2.MoveFirst()
                      Do Until RS2.EOF%>
                  <% IF RS2("Att_Page") = "5" Then%>
                  <%If RS2("Variable") <> "" Then%>
                  <% If RS2("Variable") = "True" Then Response.Write RS2("Att_Desc_Detail") & ", " Else Response.Write RS2("Att_Desc_Detail") & " : " & RS2("Variable") & ", "%>
                  <%End If%>
                  <%End If%>
                  <%RS2.MoveNext()
                      Loop%>
                  <%RS2.MoveFirst()
                      End If%>
                </td>
              </tr>
            </table>
            <table width="96%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td colspan="2"><font face="Verdana, Arial, Helvetica, sans-serif" color="#2A2F88" size="2"><b class="sub-head">Exercise 
                  &amp; Health Facilities:</b></font></td>
              </tr>
              <tr> 
                <td width="26" height="20">&nbsp;</td>
                <td width="501" class="form-captions" height="20">
                  <%If not RS2.EOF Then%>
                  <%RS2.MoveFirst()
                      Do Until RS2.EOF%>
                  <% IF RS2("Att_Page") = "6" Then%>
                  <%If RS2("Variable") <> "" Then%>
                  <% If RS2("Variable") = "True" Then Response.Write RS2("Att_Desc_Detail") & ", " Else Response.Write RS2("Att_Desc_Detail") & " : " & RS2("Variable") & ", "%>
                  <%End If%>
                  <%End If%>
                  <%RS2.MoveNext()
                      Loop%>
                  <%RS2.MoveFirst()
                      End If%>
                </td>
              </tr>
            </table>
            <table width="96%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td colspan="2"><font face="Verdana, Arial, Helvetica, sans-serif" color="#2A2F88" size="2"><b class="sub-head">Property 
                  Features: </b></font></td>
              </tr>
              <tr> 
                <td width="26" height="12">&nbsp;</td>
                <td width="501" class="form-captions" height="12">
                  <%If not RS2.EOF Then%>
                  <%RS2.MoveFirst()
                      Do Until RS2.EOF%>
                  <% IF RS2("Att_Page") = "7" Then%>
                  <%If RS2("Variable") <> "" Then%>
                  <% If RS2("Variable") = "True" Then Response.Write RS2("Att_Desc_Detail") & ", " Else Response.Write RS2("Att_Desc_Detail") & " : " & RS2("Variable") & ", "%>
                  <%End If%>
                  <%End If%>
                  <%RS2.MoveNext()
                      Loop%>
                  <%RS2.MoveFirst()
                      End If%>
                </td>
              </tr>
            </table>
            <table width="96%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td colspan="2"><font face="Verdana, Arial, Helvetica, sans-serif" color="#2A2F88" size="2"><b class="sub-head">On-Site 
                  Businesses: </b></font></td>
              </tr>
              <tr> 
                <td width="26" height="12">&nbsp;</td>
                <td width="501" class="form-captions" height="12">
                  <%If not RS2.EOF Then%>
                  <%RS2.MoveFirst()
                      Do Until RS2.EOF%>
                  <% IF RS2("Att_Page") = "8" Then%>
                  <%If RS2("Variable") <> "" Then%>
                  <% If RS2("Variable") = "True" Then Response.Write RS2("Att_Desc_Detail") & ", " Else Response.Write RS2("Att_Desc_Detail") & " : " & RS2("Variable") & ", "%>
                  <%End If%>
                  <%End If%>
                  <%RS2.MoveNext()
                      Loop%>
                  <%RS2.MoveFirst()
                      End If%>
                </td>
              </tr>
              <tr> 
            </table>
            <table width="96%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td colspan="2"><font face="Verdana, Arial, Helvetica, sans-serif" color="#2A2F88" size="2"><b class="sub-head">Guest 
                  Services: </b></font></td>
              </tr>
              <tr> 
                <td width="26" height="12">&nbsp;</td>
                <td width="501" class="form-captions" height="12">
                  <%If not RS2.EOF Then%>
                  <%RS2.MoveFirst()
                      Do Until RS2.EOF%>
                  <% IF RS2("Att_Page") = "9" Then%>
                  <%If RS2("Variable") <> "" Then%>
                  <% If RS2("Variable") = "True" Then Response.Write RS2("Att_Desc_Detail") & ", " Else Response.Write RS2("Att_Desc_Detail") & " : " & RS2("Variable") & ", "%>
                  <%End If%>
                  <%End If%>
                  <%RS2.MoveNext()
                      Loop%>
                  <%RS2.MoveFirst()
                      End If%>
                </td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
    </td>
    <td bgcolor="#2A2F88" width="0%"><img src="/images/shim.gif" width="1" height="1"></td>
  </tr>
</table>
<table width="99%" border="0" cellspacing="0" cellpadding="0" align="center" background="/images/bkgrnd-test.gif">
  <tr> 
    <td rowspan="2" width="1%" valign="bottom"><img src="/images/corner-lower-left.gif" width="10" height="10"></td>
    <td width="98%"><img src="/images/shim.gif" width="1" height="9"></td>
    <td rowspan="2" width="1%" valign="bottom" align="right"><img src="/images/corner-lower-right.gif" width="10" height="10"></td>
  </tr>
  <tr> 
    <td width="98%" bgcolor="#2A2F88"><img src="/images/shim.gif" width="1" height="1"></td>
  </tr>
</table>
