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"; //-->

Upper East Side Real Estate Apartments

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 ''; //fetch all $db->setFetchMode(DB_FETCHMODE_ASSOC); $color=1; foreach (range(0,$howMany) as $rownum) { if (!$result = $results->fetchrow(DB_FETCHMODE_ORDERED,$rownum)) { break; } if (($color%2)==0) { print""; } else { echo ""; } //format the price $listPrice="\$".number_format($result[6]); $imageFileName=$result[12]; $imageTag=superSmallImageResizer($imageFileName,$result[3],$result[4]); $sqFeet=number_format($result[9]); $neighborhood=$result[13]; $neighborhood=ucwords($neighborhood); echo ""; $color++; } } 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

"; } // else count==0 ?>

North of 59th Street, South of 96th, East of Fifth Avenue to the East River. Neighborhoods include: Carnegie Hill .Yorkville .Lenox Hill.

Ask AptAGogo about:

• Upper east side condos
• Upper east side apartments
• Upper east side coops
• Upper east side rentals and sales

With its world-famous museums, elite schools, luxury boutiques, and proximity to Central Park, the family-oriented Upper East Side is home to some of the city's richest residents. Today, this area can count diplomats, celebrities, corporate executives and even New York City’s mayor’s among its residents. The museum mile on Fifth Ave with Metropolitan, Whitney and Guggenheim Museums, distinctive shops and elite restaurants, and most of the city’s best private school. East of Lexington Avenue, young professionals and budding families live in prewar and postwar co-ops, condos, and mid-block townhouses.

Interested in an apartment on the Upper East Side?

Click here to get started

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"; //-->