<!--#include file=webhead.asp-->
<title><%=webname%>-二手房求购</title>

<SCRIPT language=javaScript>
<!--
function mOvr(src,clrOver){ 
	if (!src.contains(event.fromElement)) { 
		src.style.cursor = 'hand'; 
		src.bgColor = clrOver; 
	}
}
function mOut(src,clrIn)  { 
	if (!src.contains(event.toElement)) { 
		src.style.cursor = 'default'; 
		src.bgColor = clrIn; 
	}
} 
//-->
</SCRIPT>


<div align="center">
	<table border="0" width="784" cellspacing="0" cellpadding="0" bordercolor="#000000" style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px" >
		<tr>
			<td bgcolor="#E9E9E9" height=2></td>
				</tr>
		<tr>
			<td height=5></td>
				</tr>
		<tr>
			<td align="center">
		<p align="center"><%if ad2453class=0 then%><a target="_blank" href="<%=ad2453url%>"><img  alt="<%=ad2453name%>" src="<%=ad2453%>"  border="0" width=777 height=123></a>
	<%else%>
													<object classid="clsid:D27CDB6E-AE6D-11CF-96B8-444553540000" id="obj1" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0" border="0" width="777" height="123">
	<param name="movie" value="<%=ad2453%>">
	<param name="quality" value="High">
	<embed src="<%=ad2453%>" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" name="obj1" width="777" height="123"></object>

	<%end if%>
	
												
												
												</td>
				</tr>
		<tr>
			<td height=5></td>
				</tr>
		<tr>
			<td height=5></td>
				</tr>
			</table>
</div>

	<div align="center">

	<table border="0" width="784" cellspacing="0" cellpadding="0" bordercolor="#000000" style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px">
			<tr>
			<td >
							<p align="center">　</td>
			<td>
							　</td>
			<td  align="right">
							<a href="index.asp">二手房出售</a> <a href="index2.asp">
							<font color="#FF0000">二手房求购</font></a>&nbsp;&nbsp; |&nbsp;&nbsp;
							<a href="../user/">发布二手房出售</a> <a href="../user/">发布二手房求购</a>&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;
							<a href="../user/reg.asp">会员注册</a>
							<a href="../user/login.asp">会员登录</a>&nbsp;&nbsp;&nbsp;</td>
		</tr>
		<tr>
			<td colspan="3"  height=8></td>
		</tr>
		<tr>
			<td colspan="3">
			<div align="center">
				<table border="0" width="100%" cellspacing="0" cellpadding="0">
					<tr>
						<td><div align="center"><!--#include file="in_search2.asp"-->
				　</td>
					</tr>
				</table>
			</div>
			</td>
		</tr>
		
	</table>
</div>
</div>
<div align="center">
	<table border="0" width="784" cellpadding="0" style="border-collapse: collapse; border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px" bordercolor="#000000">
		<tr>
			<td width="200" valign="top" >
								<!--#include file="in_buynotice.asp"-->
								<!--#include file="in_policy.asp"-->
			　</td>
				<td width=3 bgcolor="#ffffff">　</td>
			<td width=1 bgcolor="#E9E9E9">　</td>
			<td width=3 bgcolor="#ffffff">　</td>
			<td width=580 valign="top">
				<table border="0" width="99%" cellspacing="0" cellpadding="0">
												<tr>
													<td bgcolor="#F7F7F7" height=20>
													&nbsp;二手房求购 </td>
															
													<td bgcolor="#F7F7F7" height=20>
													<p align="right"> &nbsp;&nbsp; </td>
															
													<td bgcolor="#E9E9E9"  width=2></td>
												</tr>
												<tr>
												
													<td bgcolor="#E9E9E9" height=2 colspan="2"></td>
													<td bgcolor="#E9E9E9" height=2 colspan="1"></td>

												</tr>
											</table>
				<div align="right">
			
				<div align="left">
				<table id="AutoNumber4" style="BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; BORDER-COLLAPSE: collapse; BORDER-RIGHT-WIDTH: 0px" borderColor="#111111" cellSpacing="2" cellPadding="2" width="96%" align="center" border="0">
						<tr bgColor="#f7f7f7">
							<td  height="21">
							<div align="center">
								地区</div>
							</td>
							<td  height="21">
							<p align="center">详细地址</td>
							<td height="21">
							<p align="center">户型</td>
							<td  height="21">
							<div align="center">
								面积(米&sup2;)</div>
							</td>
							<td  height="23">
							<div align="center">
								售价(万元)</div>
							</td>
							<td  height="24">
							<div align="center">
								发布时间</div>
							</td>
							<td  height="21">
							<div align="center">
								物业类型</div>
							</td>
						</tr>
						<%
									
									set rs=server.createobject("adodb.recordset")
    sql="select  * from [sell2] where by_shenhe=1 order by adddate desc"
        rs.open sql,conn,1,1
	if rs.recordcount=0 then 
		else
		
	  		rs.PageSize =20 '每页记录条数
			iCount=rs.RecordCount '记录总数
			iPageSize=rs.PageSize
    		maxpage=rs.PageCount 
    		page=request("page")
    
    if Not IsNumeric(page) or page="" then
        page=1
    else
        page=cint(page)
    end if
    
    if page<1 then
        page=1
    elseif  page>maxpage then
        page=maxpage
    end if
    
    rs.AbsolutePage=Page

	if page=maxpage then
		x=iCount-(maxpage-1)*iPageSize
	else
		x=iPageSize
	end if
	
			For i=1 To x
		%>
							
						<tr class="sellright" onmouseout="mOut(this,'#F7F7F7');" onmouseover="mOvr(this,'#FFD28E');"  bgcolor="#F7F7F7">
							<td width="14%" align="left" height=23>
							</span><%
                  set rss=server.createobject("adodb.recordset")
sqls="select * from province where shengNo="&int(rs("province"))
rss.open sqls,conn,1,1
if rss.eof then

end if
if rs("province") =0 then
response.write "不详"
end if
               response.write  rss("shengname")
               shengid=rss("id")
                rss.close
                set rss=nothing
                %>
                <%
                  set rss=server.createobject("adodb.recordset")
sqls="select * from city where Shengid="&shengid&" and  shino="&int(rs("city"))
rss.open sqls,conn,1,1
if rss.eof then

end if
               response.write  rss("shiname")
                rss.close
                set rss=nothing
                %>
				　</font></td>
							<td width="20%" align="left"><a href="sell2info.asp?id=<%=rs("id")%>"><%if rs("guding")=1 then%>
							<font color="ff0000"><%end if%><%=rs("address")%></font></a></td>
							<td width="12%" align="left">
							<%=rs("room")%>室<%=rs("hall")%>厅<%=rs("toilet")%>卫</td>
							<td width="11%" align="left">
							<div align="left"><%=rs("usearea")%>
								</span></div>
							</td>
							<td width="12%" align="left">
							<div align="left">
								<%=rs("money")%></span></div>
							</td>
							<td width="12%" align="left">
							<%if rs("guding")=1 then%>
          <%=year(rs("gddate"))%>-<%=month(rs("gddate"))%>-<%=day(rs("gddate"))%>
          <%else%>
 <%=year(rs("adddate"))%>-<%=month(rs("adddate"))%>-<%=day(rs("adddate"))%>
<%end if%></td>
							<td width="12%" align="left">
							<%if rs("sort")=1 then			response.write "普通住宅"
							if rs("sort")=2 then			response.write "小高层住宅"
							if rs("sort")=3 then			response.write "高层住宅"
							if rs("sort")=4 then			response.write "别墅"
							if rs("sort")=5 then			response.write "写字楼"
							if rs("sort")=6 then			response.write "店面房"
							if rs("sort")=7 then			response.write "厂房"
							if rs("sort")=8 then			response.write "车库车位"
							if rs("sort")=9 then			response.write "公寓"
							if rs("sort")=10 then			response.write "单身公寓"
							if rs("sort")=11 then			response.write "其他"

							%></span></td>
						</tr>
						<%rs.movenext
		next
			end if
						rs.close
						
						%>
						</table>
				</div>
				</div>
				<table width="100%" cellspacing="0" cellpadding="2">
					<tr>
						<td bgcolor="#F7F7F7">
						<p align="right"><%	call PageControl(iCount,maxpage,page,"border=0 align=right","<p align=center>")


		rs.close
		set rs=nothing
Sub PageControl(iCount,pagecount,page,table_style,font_style)
'生成上一页下一页链接
    Dim query, a, x, temp
    action = "http://" & Request.ServerVariables("HTTP_HOST") & Request.ServerVariables("SCRIPT_NAME")

    query = Split(Request.ServerVariables("QUERY_STRING"), "&")
    For Each x In query
        a = Split(x, "=")
        If StrComp(a(0), "page", vbTextCompare) <> 0 Then
            temp = temp & a(0) & "=" & a(1) & "&"
        End If
    Next

    Response.Write("<table " & Table_style & ">" & vbCrLf )        
    Response.Write("<form method=get onsubmit=""document.location = '" & action & "?" & temp & "Page='+ this.page.value;return false;""><TR>" & vbCrLf )
    Response.Write("<TD align=right>" & vbCrLf )
    Response.Write(font_style & vbCrLf )    
        
    if page<=1 then     
        Response.Write ("上页 " & vbCrLf)
    else        
        Response.Write("<A HREF=" & action & "?" & temp & "Page=" & (Page-1) & ">上页</A> " & vbCrLf)
    end if

    if page>=pagecount then
        Response.Write ("下页 " & vbCrLf)    
    else
        Response.Write("<A HREF=" & action & "?" & temp & "Page=" & (Page+1) & ">下页</A> " & vbCrLf)  
    end if

    Response.Write(" 页次：" & page & "/" & pageCount & "页" &  vbCrLf)
    Response.Write(" 共有" & iCount & "条信息" &  vbCrLf)
    Response.Write("</TD>" & vbCrLf )                
    Response.Write("</TR></form>" & vbCrLf )        
    Response.Write("</table>" & vbCrLf )        
End Sub
%></td>
					</tr>
				</table>
				</td>
		</tr>
		</table>
</div>
<!--#include file=webfoot.asp-->