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

East Village 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 ''; //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 ?>

East Village NY

People used to want to live here because it was trendy but now people know it’s one of the last "neighborhoody" neighborhoods left. Young professionals love the renovated Tompkins Square Park , and the Ukrainian and Polish communities still thrive.

East Village Boundaries: 14th Street to Houston Street on the east side. Borders: Lower East Side and the West Village and Gramercy

East Village Subway stops: 6 to Astor Place & L Train 14th St

During the 19th century, millionaires like the Astors and Vanderbilts had large pieces of real estate in the East Village, but the waves of Irish, German, Jewish, Polish, and Ukrainian immigrants who flooded into New York City in the 1900s soon displaced the elite, who moved uptown. The East Village has been home to the Beat generation of the 1950s, hippies in the 1960s, and punks in the late 1970s and 1980s. Over the last 100 years, the East Village/Lower East Side has arguably contributed more to American arts and culture than any other neighborhood in the nation. Today it's still a young person's neighborhood, with its experimental music clubs and theaters and cutting-edge fashion. New York University is in the area, so there's no shortage of clientele here. Foodies take note: this neighborhood reputedly contains the most varied assortment of ethnic restaurants in New York City, from the crush of Indian eateries on the south side of East Sixth Street (sometimes called "Little Bombay") to McSorley's Old Ale House, a pub that seems unchanged since it first opened in 1854. Nearby, in what was once the home of the Astor Library, the restored Public Theater has been the opening venue for many now-famous plays. The luxury real estate (rentals and sales) are in high demand.

Interested in Real Estate in the East Village?

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