Chelsea Real Estate
require_once 'DB.php'; include("mySQLpref.php"); include("functions.php"); //$agentID=$_GET['agentID']; //$hood=$_GET['hood']; $db = DB::connect($dsn); if (DB::isError($db)) { // get the native backend error // and the last query //echo $db->getDebugInfo(); echo "Sorry, we are experiencing heavy network traffic on our database server. Please try back in about 15 minutes.
"; exit; } $sql= "SELECT count(*) from real_estate WHERE sold='No' and agentID='".$agentID."'"; //print ""; $countNum=$db->getOne($sql); chkSqlError($db); if ($countNum==0) { echo ""; exit; } else { $getAgentInfo="select firstName,lastName, phoneNumber from real_estate_users where agentID=$agentID"; $agentInfo=$db->getRow($getAgentInfo); $agentFirstName=$agentInfo[0]; $agentLastName=$agentInfo[1]; $agentPhone=$agentInfo[2]; if ($hood==""){ $getSQL= "select distinct listingID, listingDate, sold, city, state, listingType, price, bed, bath,sqFeet,mlsID,shortDesc,photo,hood,triumphLinkURL FROM real_estate where agentID='".$agentID."' and sold='No' ORDER BY hood DESC"; } else { $getSQL= "select distinct listingID, listingDate, sold, city, state, listingType, price, bed, bath,sqFeet,mlsID,shortDesc,photo,hood,triumphLinkURL FROM real_estate where agentID='".$agentID."' and sold='No' and hood='".$hood."'ORDER BY bed DESC"; } //print ""; $results=$db->query($getSQL); chkSqlError($db); $howMany=$results->numRows(); if ($howMany!=0) { echo '| Description | Neighborhood | Beds / Baths | Approx Sq Feet* | Price | Contact Info |
$imageTag {$result[11]} |
$neighborhood |
{$result[7]} / {$result[8]} | {$sqFeet} Sq ft* |
{$listPrice} |
Agent: $agentFirstName $agentLastName
$agentPhone Click Here For More Details |
North of 14th Street, South of 28th Street, West of Fifth Avenue to the Hudson River .
Ask AptAGogo about:
- Chelsea condos
- Chelsea apartments
- Chelsea coops
- Chelsea rentals and sales
Less than a decade ago, many residents marveled at signs of renewal in Chelsea . These days, it's quite a feat to find properties available for sale or rent. With charming townhouses, lofts and new condominiums setting the market demand for Chelsea properties have reached an all time high. No longer does it take second billing from the West Village in luxury living; some will argue it is even setting the trend. Great restaurants and clubs are only part of the reason residents find this area hot, fun and trendy. Flexibility in space and layouts is also a crucial factor. Some points of interest include the Chelsea Pier, the Chelsea Hotel .
The townhouses and prewar co-ops of gay-friendly Chelsea have been home to photographers and filmmakers for years. But "we're increasingly seeing doctors, lawyers, and business owners. Some of the finest luxury rental buildings and condominiums have been recently completed to offer Chelsea residents the luxury of uptown in a downtown setting.
Interested in Real Estate in Chelsea?
google_ad_client = "pub-2828711705598959"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text"; google_ad_channel =""; google_color_border = "FFFFFF"; google_color_bg = "FFFFFF"; google_color_link = "000000"; google_color_text = "000000"; google_color_url = "008000"; //-->