Latest NY City Rental Listings - Contact Agent 917 292 3898

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 ?>

Latest Exclusive Sales Listings

Description	Neighborhood	Size	Price
luxury one bed room on Central Park West ( Upper West Side 90s)	Central Park West	3/1/1	$635,000
Spacious One Bed Room with home office on Central Park West	Central Park West	3/1/1	$495,000
& PRICE REDUCED & Top Floor CPW Condo w/ Incredible Park View	Morningside Heights	3/1/1	$525,000

Latest Exclusive Rental Listings

Description	Neighborhood	Size	Rent	UF/F
Cozy new renovated Studio	Upper West Side	2/0/1	$1,640	UF
Prime Upper West Side Studio on 71st St with Doorman	Upper West Side	2/0/1	$1,550	UF
Upper West Side Large Studio in Doorman Bldg	Upper West Side	2/0/1	$1,550	UF
Columbus Ave and West 99th St	Upper West Side	2/0/1	$1,650	UF
luxury doorman Bldg. Alcove Studio Central Park West	Central Park West	2/0/1	$2,000	UF
West Harlem HUGE ONE BED ROOM	West Harlem	3/1/1	$1,100	UF
One bed room steps from Central Park	Upper East Side	3/1/1	$1,150	UF
Upper East Side one bed room in Full service building	Upper East Side	3/1/1	$2,390	UF
Brand New Luxury One bed room in Prime DUMBO	Dumbo	3/1/1	$3,100	UF
One Bed Room Heart of East Village	E. Greenwich Village	3/1/1	$2,875	UF
Spacious One Bed Room near Central Park	Upper East Side	3/1/1	$1,300	UF
Huge One Bed Room Steps from Central Park. upper East Side	East Harlem	3/1/1	$1,150	UF
RENOVATED One bed room on Upper West Side	Upper West Side	3/1/1	$1,590	UF
Best Block of Mid-town East One Bed Room	Turtle Bay	3/1/1	$2,400	UF
Beautiful Inwood Furnished one bed room	Inwood	4/1/1	$1,170	F
BRAND NEW High-End Clinton Hills Huge One Bed Room Loft	Williamsburg	4/2/1	$2,600	UF
Covertible Two bed rooms Central Park Townhouse	Upper East Side	4/2/1	$4,900	UF
West Harlem 2bed room duplex with Private garden-	West Harlem	5/2/1.5	$2,600	UF
Prime East Village Brad New 3 BR	E. Greenwich Village	5/3/1	$4,200	UF
West 144th St and Broadway	West Harlem	5/3/1	$1,950	UF
Ultra Luxury high floor 2 Bed 2 Bath Trump Condo	Upper West Side	5/2/2	$5,800	UF
LUXURY high floor 2 bed rooms 2 baths in Brand New Orion Condo	Clinton	5/2/1	$5,800	UF
West Harlem Huge 3 BR. new renovation	Hamilton Heights	5/3/2	$1,700	UF
Beautiful 2 bed room 94th street UWS	Upper West Side	5/2/1	$3,150	UF
Upper East Side Upscale 3 bed rooms 2 baths	Upper East Side	6/3/2	$5,000	UF
Prime Upper West Large 3 bed 3 bath in doorman Bldg	Upper West Side	6/3/3	$7,250	UF
Prime Upper West Luxury large 3 BR 2.5 Baths	Upper West Side	6/3/1	$7,500	UF
Large four bed rooms by Central park west	Morningside Heights	6/4/1	$3,550	UF
Heart of East Village. Duplex 3 bed Rooms	E. Greenwich Village	6/3/1	$3,900	UF