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

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

Ask AptAGogo about:

• Harlem condos
• Harlem apartments
• Harlem coops
• Harlem rentals and sales

Harlem Basics: Harlem's new residents are strikingly diverse: straight and gay, black and white, Asian and European. They're here for the neighborhood's history and the immaculate houses on Strivers Row—plus fixer-upper brownstones that cost 20 percent of what they would a mile to the south.

Boundaries: The East Harlem/El Barrio (Spanish Harlem) community stretches from First Avenue to Fifth Avenue and from East 96th Street to East 125th Street. Central Harlem stretches from Central Park North to the Harlem River and from Fifth Avenue to St. Nicholas Avenue. West Harlem , including Hamilton Heights and Sugar Hill, stretches from 123rd to 155th Streets and from St. Nicholas Avenue to the Hudson River.

Subway stops: 6 to 110th Street for East Harlem; 2 or 3 to 116th Street for Central Harlem; A, B, C, or D to 125th Street for West Harlem.

The building boom continues. A flood of co-ops and condos is coming onto the market next year to satisfy the in-between market (that is, buyers with a decent income who can’t afford a Strivers Row townhouse). Typical example: The Sugar Hill Condominiums, a six-story luxury conversion at 146th Street and Convent Avenue, will offer two- and three-bedroom units as large as 1,900 square feet (prices are still TBA). Corcoran’s Vie Wilson calls the development “dynamic.” “There are virtually no new condominiums in Harlem,” she says. “They just don’t exist.”
Harlem has been home to a variety of ethnic groups, black and white, since the turn of the twentieth century. As the ethnic landscape has changed, cultural and religious buildings have been reshaped to serve the evolving populations. Harlem has been called a state of mind, but it is also a real place, remembered in oral histories, described in photographs, and evaluated by scholars.

 

Interested in Real Estate in Harlem?

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