|
Apartment Availability and Floorplans
| Type |
Date Available |
Unit # |
Rent |
Sq Ft |
Floorplan |
<%
strSQL = "SELECT *, (SELECT typName FROM PC_Types WHERE typID = aptTypeID) AS aptType FROM PC_Apartments INNER JOIN PC_Floorplans ON PC_Apartments.aptFloorplanID = PC_Floorplans.fpID WHERE fpStatus = 1 AND aptStatus <> 0"
strSQL = strSQL & " ORDER BY aptNumber ASC"
set getRecords = dbConn.execute(strSQL)
while NOT getRecords.EOF
aptID = getRecords("aptID")
aptTypeID = getRecords("aptTypeID")
aptFloorplanID = getRecords("aptFloorplanID")
aptStatus = getRecords("aptStatus")
aptFloor = getRecords("aptFloor")
aptPrice = getRecords("aptPrice")
aptAvailableDate = getRecords("aptAvailableDate")
aptPriceType = getRecords("aptPriceType")
aptNumber = getRecords("aptNumber")
aptDescription = getRecords("aptDescription")
fpRooms = getRecords("fpRooms")
fpBaths = getRecords("fpBaths")
fpSquareFeet = getRecords("fpSquareFeet")
fpPrice = getRecords("fpPrice")
fpName = getRecords("fpName")
fpImage = getRecords("fpImage")
fpDescription = getRecords("fpDescription")
fpHTML = getRecords("fpHTML")
aptType = getRecords("aptType")
if aptStatus = 2 then
aptImage = "images/slug-rented.gif"
else
aptImage = "images/slug-for-rent.gif"
end if
%>
| <%=aptType%> |
<%=aptAvailableDate%> |
<%=aptNumber%> |
<%=formatcurrency(aptPrice, 2)%> |
<%=formatnumber(fpSquareFeet, 0)%> |
 <%=fpName%> |
<%
getRecords.movenext()
wend
set getRecords = nothing
%>
|
|
From $2,500 • Rent Now
|
| METRO92 • 92 Main Street • Yonkers, NY | www.METRO92.com
| 914.410.9090 |
| Copyright © METRO92 Inc. All rights reserved. |
|
