<?php

// echo 'hello';
// exit;

// old IP prior to Aug. 17: 184.4.238.12
$myip = 'myip';
$showqueries = 'yes';
$showqueries = 'no';
if ( isset($_SERVER['HTTP_USER_AGENT']) && $_SERVER['HTTP_USER_AGENT'] == 'Java/1.6.0_21' ) {
	header("Location: http://www.google.com/"); 
	exit;
}


// $mysqliconnfile = $_SERVER['DOCUMENT_ROOT'].'/incs/connmysqlireso.php';
// require_once($mysqliconnfile); // Include database connection


$STELLAR_SWSubdivCommunityName = 'STELLAR_SWSubdivCommunityName';
$SubdivisionName = 'SubdivisionName';
if ( isset($_REQUEST['proptype']) && $_REQUEST['proptype'] == 'Commercial') {
	$STELLAR_SWSubdivCommunityName = 'STELLAR_ComplexDevelopmentName';
	$SubdivisionName = 'STELLAR_ComplexDevelopmentName';
} 
if ( isset($proptype) && $proptype == 'Commercial' ) {
	$STELLAR_SWSubdivCommunityName = 'STELLAR_ComplexDevelopmentName';
	$SubdivisionName = 'STELLAR_ComplexDevelopmentName';
}


if (isset($_REQUEST['page']) && is_numeric($_REQUEST['page'])) {
	$page = $_REQUEST['page'];
	$mypage = $page;
	unset($_REQUEST['page']);
} else {
	$page = 1;
}

// prearray($PropertySubTypes);
if ( isset($_REQUEST['proptype']) &&  $_REQUEST['proptype'] == 'Rentals' ) {
	header("HTTP/1.0 410 Gone");
	if ( !isset($h1) ) {
		$h1 = 'Page Not Found';
	}
	include 'header.php';
	unset($h1);
	// include 'header.php';
	include 'technical.php';
	include 'searchform.php';
	include 'footer.php';
	exit;
} 
else {
	// include 'header.php';
}


if ( isset($_REQUEST['proptype']) &&
 		( $_REQUEST['proptype'] == 'Homes'
		|| $_REQUEST['proptype'] == 'Condos'
		|| $_REQUEST['proptype'] == 'Commercial'
		// || $_REQUEST['proptype'] == 'Rentals'
		|| $_REQUEST['proptype'] == 'Land'
		|| $_REQUEST['proptype'] == 'Lots'
		|| $_REQUEST['proptype'] == 'Multifamily'
		)
	)
{
		$proptype = $_REQUEST['proptype'];
		if ( $proptype == 'Lots' ) {
			$proptype == 'Land';
		}
		elseif ( $proptype == 'Condos' ) {
			$proptype = 'Condominium';
		}
		elseif ( $proptype == 'Multifamily' ) {
			$proptype = 'Residential Income';
		}
} else {
	$proptype = 'Homes';
}

if ( isset($_REQUEST['proptype']) ) {
	// echo $_REQUEST['proptype'];
// $proptype = makesafe($_REQUEST['proptype']);
	$proptype = $_REQUEST['proptype'];
	if ($proptype == 'Homes') {
		$PropertyType = 'Residential';
	} elseif ($proptype == 'Lots' || $proptype == 'Land') {
		$PropertyType = 'Land';
	} elseif ($proptype == 'Condos') {
		$PropertyType = 'Condominium';
	} elseif ($proptype == 'Commercial') {
		$PropertyType = 'Commercial';
	} elseif ($proptype == 'Mobile-Homes') {
		$PropertyType = 'Mobile Home';
	} elseif ($proptype == 'Multifamily') {
		$PropertyType = 'Residential Lease';
	} elseif ($proptype == 'Residential Income') {
		$PropertyType = 'Residential Income';
	}
} else {
	$proptype = 'Homes';
}


if ( isset($_REQUEST['city']) ) {
	$_REQUEST['city'] = ucwords(strtolower($_REQUEST['city']));
	$city = str_replace('-', ' ', escape_datai($_REQUEST['city']) );
	$city = str_replace('+', ' ', $city);
	$city = ucwords(strtolower($city));
}
$querycitypart = '';
if ( isset($_REQUEST['city']) && !empty($_REQUEST['city']) && $_REQUEST['city'] != 'Any-city' && $_REQUEST['city'] != 'Any city' ) {
	$mycity = $city;
	$searchcity = escape_datai($city);
	if ( $searchcity == 'Punta Gorda Isles' ) {
		$querycitypart .= " AND ( ";
		$querycitypart .= " City NOT LIKE '%Deep Creek%' ";
		$querycitypart .= " AND STELLAR_ComplexCommunityNameNCCB NOT LIKE '%Deep Creek%' ";
		
			$querycitypart .= " AND REPLACE($SubdivisionName,'-',' ') NOT LIKE '%Deep Creek%' ";
			$querycitypart .= " AND REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') NOT LIKE '%Deep Creek%' ";
		if ( $_REQUEST['proptype'] != 'Land' ) {
			$querycitypart .= " AND REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') NOT LIKE '%Deep Creek%' ";
		}
		
		
		$querycitypart .= " AND PostalCode NOT LIKE '%33983%' ";
		$querycitypart .= " ) ";
	}
	if ( $searchcity != 'Desoto County' && $searchcity != 'De Soto County'  ) {
		$querycitypart .= " AND ( ";
		$querycitypart .= " REPLACE(City,'-',' ') LIKE '%$searchcity%' ";
	}
	if ( $searchcity == 'Desoto County' || $searchcity == 'De Soto County' ) {
		$querycitypart .= " AND ( ";
		$querycitypart .= " CountyOrParish = 'DeSoto' OR CountyOrParish = 'De Soto'";
	}
	if ( $searchcity == 'Lakewood Ranch' ) {
		$querycitypart .= " AND ( ";
		$querycitypart .= " City LIKE '%$searchcity%' ";
		$querycitypart .= " ) ";
	} 	
	else {
		if ( !is_numeric($searchcity) ) {
			// echo 'NOT NUMERIC';
		} elseif (is_numeric($searchcity)) {
			// echo 'NUMERIC';
		}
		if ( !is_numeric($searchcity) && $searchcity != 'Ona' && $searchcity != 'DeSoto County' && $searchcity != 'De Soto County' ) {
			$querycitypart .= " OR STELLAR_ComplexCommunityNameNCCB LIKE '%$searchcity%' ";
				$querycitypart .= " OR REPLACE($SubdivisionName,'-',' ') LIKE '%$searchcity%' ";
				$querycitypart .= " OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%$searchcity%' ";
				if ( $searchcity == 'Punta Gorda Isles' ) {
					// this stuff is from build cityquery.php in SuncoastSearch
					$querycitypart .= " 
					OR REPLACE(City,'-',' ') LIKE 'Punta Gorda%' AND ( 
					 REPLACE(City,'-',' ') LIKE 'Punta Gorda Isles%'
					OR REPLACE(REPLACE($SubdivisionName,'-',' '),'-',' ') LIKE '%Punta Gorda Isles%' 
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%PGI%' 
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Aqui Esta Villas%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Bal Harbor Place%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Banyan Point%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Bass Harbour%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Bella Lago%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Boca Lago%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Bridge Point%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Brisas%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Champagne%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Charleston South%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Clipper Cove%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Coldway Commons%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Colony Point%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Conquistador%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Costa Bella%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Dockside%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Dolphin Club%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Driftwood%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Estuary South%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Fountain Court%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Gateway Point%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Golf Course Villa%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Grand Bay%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Grand Cove%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Harbor Landing%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Hibiscus%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Islander Point%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Jamaica Way%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%La Porta Boca%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%La Romana%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Lavista%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Magdalena Gardens%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Miramar%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Outlook Cove%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Palacio Del Sol%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Park Beach Club%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Points West%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Rockdove%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Rookery%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Sailboat Cove%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Schooner Cove%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Sea Isles%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Silver Sands%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Solamar%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Spinnaker Point%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Starboard Point%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Tarpon Cove'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Venetian Isles%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Villas of Bal Harbor%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Villas of Cedar Key%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Vivante%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Water Gardens%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%White Ibis%'
					OR REPLACE($SubdivisionName,'-',' ') LIKE '%Windjammer%'

					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Punta Gorda Isles%' 
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%PGI%' 
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Aqui Esta Villas%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Bal Harbor Place%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Banyan Point%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Bass Harbour%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Bella Lago%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Boca Lago%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Bridge Point%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Brisas%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Champagne%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Charleston South%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Clipper Cove%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Coldway Commons%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Colony Point%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Conquistador%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Costa Bella%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Dockside%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Dolphin Club%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Driftwood%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Estuary South%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Fountain Court%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Gateway Point%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Golf Course Villa%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Grand Bay%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Grand Cove%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Harbor Landing%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Hibiscus%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Islander Point%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Jamaica Way%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%La Porta Boca%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%La Romana%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Lavista%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Magdalena Gardens%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Miramar%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Outlook Cove%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Palacio Del Sol%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Park Beach Club%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Points West%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Rockdove%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Rookery%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Sailboat Cove%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Schooner Cove%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Sea Isles%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Silver Sands%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Solamar%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Spinnaker Point%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Starboard Point%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Tarpon Cove'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Venetian Isles%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Villas of Bal Harbor%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Villas of Cedar Key%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Vivante%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Water Gardens%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%White Ibis%'
					OR REPLACE($STELLAR_SWSubdivCommunityName,'-',' ') LIKE '%Windjammer%'
					) 	";
				}
		}
	}

	$querycitypart .= " ) ";
	
	$keepincharlottecty = array('Country Homes');
	// if ( isset($searchcity) && in_array($searchcity, $keepincharlottecty) ) {
	// 	if ( $_SERVER['HTTP_HOST'] != 'www.portcharlottehouses.com' && $_SERVER['HTTP_HOST'] != 'www.searchsuncoast.com' ) {
	// 		$querycitypart .= " AND County = 'Charlotte County' ";
	// 	}
	// }

} else {
	
	$mycity = 'the Punta Gorda &amp; Port Charlotte Area';
	$searchcity = 'the Punta Gorda &amp; Port Charlotte Area';
}
if ( !isset($_GET['counties']) && !isset($_GET['county']) && ( !isset($_GET['city']) || $_GET['city'] == '' || $_GET['city'] == 'Any-city' || $_GET['city'] == 'Any city' ) ) {
	$querycitypart .= " AND CountyOrParish IN ('Charlotte','Manatee','Sarasota','Glades','Lee','Hendry','Collier','DeSoto','De Soto' ) ";
}

// if ( isset($_REQUEST['mycities']) && !empty($_REQUEST['mycities']) && count($_REQUEST['mycities']) == 1  ) {
// 	$mycity = ucwords(strtolower($_REQUEST['mycities'][0]));
// }

// $page_title = isset($mypage) && $mypage != 1 ? " Page $mypage " : ''; 
// $page_title .= $myprop.' for Sale in '.$mycity;
if ( isset($searchcity) ) {
	$page_title = 'Real Estate for Sale in '.$searchcity;
}


if ( isset($_REQUEST['featured']) ) {
	$page_title = 'Featured homes, lots and condos for sale from '.$config['company'];
} elseif ( isset($_REQUEST['luxury']) ) {
	$page_title = 'Luxury Estates in the Punta Gorda Area';	
} elseif (isset($_REQUEST['iswaterfront'])) {
	$page_title = 'Waterfront Homes in the Punta Gorda Area';	
} elseif (isset($_REQUEST['gulfaccess'])) {
	$page_title = 'Gulf Access Homes in the Punta Gorda Area';	
} elseif (isset($_REQUEST['luxcondo'])) {
	$page_title = 'Luxury Condos in the Punta Gorda Area';	
} elseif (isset($_REQUEST['poolhome'])) {
	$page_title = 'Pool Homes in the Punta Gorda Area';	
}
$page_keywords = 'Port Charlotte, Punta Gorda, Englewood, Venice, Burnt Store, Gulf Coast, southwest, Florida, south, Fl, fla, real estate, homes, land, lots, condos, commercial, investment, property, MLS, listings, realtor, real estate agent';
$page_description = "$mycity Real Estate for sale in $mycity - {$config['company']}";

if ( !isset($h1) && !isset($_GET['featured']) ) {
	$h1 = 'Search Results';
} elseif ( isset($_GET['featured']) ) {
	$h1 = 'Featured Listings';
}
include 'header.php';

if ( isset($_GET['MLNums']) ) {
	$mlnumarray = explode(',',$_GET['MLNums']);
	$themlnums = "'".implode("', '",$mlnumarray)."'";
	$mywholequery = " SELECT *, DATE_FORMAT(ListingContractDate, '%Y') as ListYear 
		FROM Listings
		WHERE ListingId IN ( $themlnums ) ";
	$getlistings = mysqli_query($dbcmls,$mywholequery) or trigger_error('Bad myquery: '.mysqli_error($dbcmls).'<br>'.$mywholequery);
	if ( !$getlistings || mysqli_num_rows($getlistings) == 0 ) {
		echo '<p>Sorry, we did not find any listings matching your search. Please try again, or search the MLS:</p>';
		include 'searchbymls.php';
		echo '<br style="display:block; clear:both;" />';
		include 'searchform.php';
	}
	if ( $getlistings && mysqli_num_rows($getlistings) > 0 ) {
		$howmany = mysqli_num_rows($getlistings);
		echo '<p>We found '.$howmany . ' listings.</p>';
		while ( $row = mysqli_fetch_assoc($getlistings) ) {
			include 'listingtable.php';
			echo '<br style="display:block; clear:both;" />';
		}
		include 'searchform.php';
	} 
	include 'footer.php';
	exit;
}


if (isset($proptype)) {
	$myprop = $proptype.' Real Estate';
	if ($proptype == 'Homes') {
		$myprop = 'Homes';
	} elseif ($proptype == 'Condos') {
		$myprop = 'Condos';
	} elseif ($proptype == 'Condominium') {
		$myprop = 'Condos';
	} elseif ($proptype == 'Lots' || $proptype == 'Land' ) {
		$myprop = 'Land';
	} elseif ($proptype == 'Commercial') {
		$myprop = 'Commercial Real Estate';
	} elseif ($proptype == 'Mobile Home') {
		$myprop = 'Mobile Homes';
	} elseif ($proptype == 'Mobile Home') {
		$myprop = 'Mobile Homes';
	} elseif ($proptype == 'Mobile-Homes') {
		$myprop = 'Mobile Homes';
	}
} else {
	$myprop = 'Homes';
}
// exit;

$mlsname = 'My Florida Regional MLS DBA Stellar MLS';

$courtesy = '<p class="courtesy"><em>';
$courtesy .=  'The information relating to real estate for sale on this website comes in part from the '.$mlsname.'. This information is provided exclusively for consumers\' personal, non-commercial use. It may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed accurate by the MLS.';
// echo $courtesy;

$mlsname = 'Stellar MLS';
$courtesy .= ' <br/><br />A <strong>*</strong> means that the information is not available in the '.$mlsname.' database'."\n";
$courtesy .= '</em></p>'."\n";


if ( !isset($_REQUEST['featured']) ) {

	// $headline = $mycity.' Real Estate';
	$headline = $myprop.' for Sale in '.$searchcity;
	
	if ( isset($_REQUEST['luxury']) ) {
		$headline = 'Luxury Estates in the Punta Gorda Area';
	} elseif (isset($_REQUEST['iswaterfront'])) {
		$headline = 'Waterfront Homes in the Punta Gorda Area';
	} elseif (isset($_REQUEST['gulfaccess'])) {
		$headline = 'Gulf Access Homes in the Punta Gorda Area';
	} elseif (isset($_REQUEST['luxcondo'])) {
		$headline = 'Luxury Condos in the Punta Gorda Area';
	} elseif (isset($_REQUEST['poolhome'])) {
		$headline = 'Pool Homes in the Punta Gorda Area';
	}
	
	if ( isset($_GET['sold']) && $_GET['sold'] == 'sold'  ) {
		$headline = 'SOLD PROPERTIES REPORT<br>'.$headline;
	}
	
	echo '<h1>'.$headline.'</h1>'."\n";
	// start building my query
	// include 'getproptype.php';		

	$solds = '';
	$solddatewhere = '';
	$soldavgprice = '';
	$soldavgpricepcent = '';
	if ( isset($_GET['daterange']) && isset($_GET['sold']) ) {
		if ( $_GET['daterange'] == 'days30' ) {
			$numdays = 30;
		} elseif ( $_GET['daterange'] == 'days60' ) {
			$numdays = 60;
		} elseif ( $_GET['daterange'] == 'days90' ) {
			$numdays = 90;
		} elseif ( $_GET['daterange'] == 'months6' ) {
			$numdays = 180;
		}
		$startdate = date('Y-m-d', strtotime("-$numdays days"));
		// $startdate = '2011-07-01';
		$solds = " , DATE_FORMAT( CloseDate, '%Y-%m-%d' ) AS DateSold 
		,	CAST(ClosePrice AS DECIMAL(12,0)) AS ClosePrice
		,	(ClosePrice/ListPrice) * 100 AS PCent
		,	CONCAT(StreetName,' ',StreetSuffix,', ',City) AS Addy
		";
		$startdate = date('Y-m-d', strtotime("-$numdays days"));
		$solddatewhere = " AND DATE_FORMAT( CloseDate,'%Y-%m-%d' ) >= '$startdate' ";
		$soldavgprice = " , AVG(CAST(ClosePrice AS DECIMAL(12,0))) AS AveClosePrice ";
		$soldavgpricepcent = " , ( SUM(CAST(ClosePrice AS DECIMAL(12,0))) / SUM(CAST(ListPrice AS DECIMAL(12,0))) ) * 100  AS AveTotalPCent ";
		if ( $proptype == 'Lots' ) {
			$solds .= ",	LotSizeDimensions ,	WaterAccessYN ";
		} elseif ( $proptype == 'Condos' ) {
			$solds .= ",	YearBuilt ,	LivingArea AS SqFtSold ";
		} elseif ( $proptype == 'Commercial Property' ) {
			$solds .= ",	YearBuilt ,	BuildingAreaTotal AS SqFtSold ";
		} else {
			$solds .= ",	YearBuilt ,	LivingArea AS SqFtSold ";
		}
	}

	$saletypequery = "";
	$saletype = array();
	if ( isset($_GET['SaleType']) && is_array($_GET['SaleType'])  ) {
		if ( in_array('Private',$_GET['SaleType']) ) {
			$saletype[] = " SpecialListingConditions = 'None of the Above' ";
		}
		if ( in_array('Foreclosure',$_GET['SaleType']) ) {
			// echo '<br>FORECLOSURE<br>';
			$saletype[] = " SpecialListingConditions = 'REO / Bank Owned' ";
		}
		if ( in_array('Shortsale',$_GET['SaleType']) ) {
			$saletype[] = " SpecialListingConditions = 'Short Sale' ";
		}
		if ( count($_GET['SaleType']) < 3 ) {
			$makesaletypearry = implode(" OR " , $saletype );
			$saletypequery = " AND ( $makesaletypearry ) "; 
		}
	}
	$TheTable = 'Listings';
	$myselectquery = " SELECT *
			,	CAST(ListPrice AS DECIMAL(12,0)) AS ListPrice
			, DATE_FORMAT(ListingContractDate, '%Y') as ListYear   
 			$solds
		 FROM $TheTable ";
	// $leftjoinforpics = " LEFT JOIN PhotoURLs ON Listings.ListingKey = PhotoURLs.ResourceRecordKey AND DisplayOrder = 1 ";
	$leftjoinforpics = "  ";
	$myselectquery .= $leftjoinforpics;
	
	$mycountquery = " SELECT count(*) as HowMany $soldavgprice $soldavgpricepcent FROM $TheTable ";
	
	// $ActiveListingTable = $TheTable.'MLSOnly';

	$restofquery = " WHERE 1=1 AND MlsStatus = 'Active'  ";
	// must select property type here
	
	// echo 'proptype: '.$proptype."\n";
	if ( $proptype == 'Homes' ) {
		$dbproptype = " AND PropertyType = 'Residential' AND PropertySubType = 'Single Family Residence' ";
	}
	elseif ( $proptype == 'Condos' ) {
		$dbproptype = " AND PropertyType = 'Residential' AND PropertySubType IN ('Condominium','Townhouse','Villa') ";
	}
	elseif ( $proptype == 'Residential Income'  ) {
		$dbproptype = " AND PropertyType = 'Residential Income' ";
	}
	elseif ( $proptype == 'Lots' || $proptype == 'Land'  ) {
		$dbproptype = " AND PropertyType = 'Land' ";
	}
	elseif ( $proptype == 'Commercial'  ) {
		// $dbproptype = " AND PropertyType = 'Commercial' ";
		$dbproptype = " AND ( PropertyType LIKE '%Commercial%' OR PropertyType LIKE '%Business%' ) ";
		
		$proptypewhere = '';
		if ( $proptype == 'Commercial' ) {
			// $proptypewhere .= " AND STELLAR_ComTransactionType LIKE '%Commercial Sale%' ";
			// $dbproptype .= $proptypewhere;
		}
		
		
	}
	elseif ( $proptype == 'Income'  ) {
		$dbproptype = " AND PropertyType = 'Residential Income' ";
	}
	elseif ( $proptype == 'Rental'  ) {
		$dbproptype = " AND PropertyType = 'Residential Lease' ";
	}
	elseif ( $proptype == 'Multifamily'  ) {
		$dbproptype = " AND PropertyType = 'Residential Income' ";
	} 
	elseif ( $proptype == 'Mobile-Homes'  ) {
		$dbproptype = " AND PropertyType = 'Residential' AND PropertySubType IN ( 'Mobile Home', 'Manufactured Home' )";
	} 
	else {
		$dbproptype = " AND PropertyType = 'Residential' ";
	}
	$restofquery .= " $dbproptype ";
	$restofquery .= " $saletypequery AND ( `MlsStatus` = 'Active' ";
	
	
	if ( isset($_GET['sold']) && $_GET['sold'] == 'sold' ) {
		$restofquery = " WHERE ( 1=1 $solddatewhere $saletypequery ";
	}
	if ( isset($PropertySubType) && $PropertySubType != '' ) {
		$restofquery .= " AND PropertySubType IN ($PropertySubType) )";
	} else {
		$restofquery .= "  )";
	}
	$restofquery .= $querycitypart; // either city or county

	// if not multifamily, land or commercial - check beds and baths
	// if ( $_REQUEST['proptype'] != 'Multifamily' && $_REQUEST['proptype'] != 'Lots' && $_REQUEST['proptype'] != 'Commercial'   ) {
	$bedcheckarry = array('Residential','Homes','Mobile-Homes','Mobile','Manufactured','Manufactured/Mobile Home','Condos','Townhouse','Villa','CTV','Single Family Home','SFH','Modular');
	if ( in_array($proptype , $bedcheckarry) ) {
		$checkit = 'yes';
	} else {
		$checkit = 'no';
	}
	// $checkit = 'yes';

	if ( $checkit == 'yes' ) {
		// Bedrooms
		if ( isset($_REQUEST['beds']) && !empty($_REQUEST['beds']) ) {
			if ( intval($_REQUEST['beds'] == 0) ) {
				$restofquery .= '';
			} elseif ( intval($_REQUEST['beds'] < 4) ) {
				$restofquery .= " AND BedroomsTotal >= ".intval($_REQUEST['beds'].' ');
			} else {
				$restofquery .= " AND BedroomsTotal >= ".intval($_REQUEST['beds'].' ');
			}
		if ( isset($_REQUEST['maxbeds']) && !empty($_REQUEST['maxbeds']) ) {
			$restofquery .= " AND BedroomsTotal <= ".intval($_REQUEST['beds'].' ');
		}
	
		}
		// Baths
		if ( isset($_REQUEST['baths']) && !empty($_REQUEST['baths']) ) {
			if ( intval($_REQUEST['baths'] == 0) ) {
				$restofquery .= '';
			} elseif ( intval($_REQUEST['baths'] < 4) ) {
				$restofquery .= " AND BathroomsFull >= ".intval($_REQUEST['baths'].' ');
			} else {
				$restofquery .= " AND BathroomsFull >= ".intval($_REQUEST['baths'].' ');
			}
	
		}
	} // END if not multifamily, land or commercial

	// Min and Max price
	$min = (isset($_REQUEST['min'])) ? INTVAL($_REQUEST['min']):0;
	$max = (isset($_REQUEST['max'])) ? INTVAL($_REQUEST['max']):0;
	if ($max != 0 && $min > $max) {
		$temp = $min;
		$min = $max;
		$max = $temp;
	}

	if ( isset($_REQUEST['min']) && $_REQUEST['min'] != 0 && $min != 0 ) {
		$restofquery .= " AND ListPrice >= $min ";
	}
	if ( isset($_REQUEST['max']) && $_REQUEST['max'] < 1000001 && $max != 0 ) {
		$restofquery .= " AND ListPrice <= $max ";
	}
	// END Min and Max Price

	// square feet min and max
	// if ( isset($_REQUEST['sqftmin']) && INTVAL($_REQUEST['sqftmin']) != 0 && 
	// 	( $proptype == 'Homes' || $proptype = 'Condos' || $proptype == 'Commercial' || $proptype == 'Income' || $proptype == 'HomesSold' || $proptype = 'CondosSold' || $proptype == 'CommercialSold' || $proptype == 'IncomeSold' ) ) {
	if ( isset($_REQUEST['sqftmin']) && INTVAL($_REQUEST['sqftmin']) != 0 && ( $_REQUEST['proptype'] != 'Vacand Land' && $_REQUEST['proptype'] != 'Land' && $_REQUEST['proptype'] != 'Lots' ) ) {
		$sqftmin = INTVAL($_REQUEST['sqftmin']);
		$restofquery .= " AND LivingArea >= $sqftmin AND LivingArea != '' ";
	}
	if ( isset($_REQUEST['sqftmax']) && INTVAL($_REQUEST['sqftmax']) != 0 && $_REQUEST['sqftmax'] != '5000+' && ( $_REQUEST['proptype'] != 'Vacand Land' && $_REQUEST['proptype'] != 'Land' && $_REQUEST['proptype'] != 'Lots' ) ) {
		$sqftmax = INTVAL($_REQUEST['sqftmax']);
		$restofquery .= " AND LivingArea <= $sqftmax AND LivingArea != '' ";
	}
	// END square feet min and max

	// yearbuilt min and max
	// if ( isset($_REQUEST['yearbuiltmin']) && INTVAL($_REQUEST['yearbuiltmin']) != 0 && ( $proptype != 'Vacand Land' && $proptype != 'Land' && $proptype != 'Lots' ) ) {
	if ( isset($_REQUEST['yearbuiltmin']) && INTVAL($_REQUEST['yearbuiltmin']) != 0 && ( $_REQUEST['proptype'] != 'Vacand Land' && $_REQUEST['proptype'] != 'Land' && $_REQUEST['proptype'] != 'Lots' ) ) {
		$yearbuiltmin = INTVAL($_REQUEST['yearbuiltmin']);
		$restofquery .= " AND YearBuilt >= $yearbuiltmin AND YearBuilt != '' ";
	}
	if ( isset($_REQUEST['yearbuiltmax']) && INTVAL($_REQUEST['yearbuiltmax']) != 0 && ( $_REQUEST['proptype'] != 'Vacand Land' && $_REQUEST['proptype'] != 'Land' && $_REQUEST['proptype'] != 'Lots' ) ) {
		$yearbuiltmax = INTVAL($_REQUEST['yearbuiltmax']);
		$restofquery .= " AND YearBuilt <= $yearbuiltmax AND YearBuilt != '' ";
	}
	// END yearbuilt min and max

	// waterfront & pool
	if ( isset($_REQUEST['waterfront']) && $_REQUEST['waterfront'] == 'Y' ) {
		// $restofquery .=  ($waterfrontcodesarry);
		// $restofquery .= " AND WaterFrontageYN = '1' ";
		$restofquery .= " AND ( WaterfrontYN = 1 ) ";

	} elseif ( isset($_REQUEST['waterfront']) && $_REQUEST['waterfront'] == 'N' ) {
		// $restofquery .= checkarray($waterfrontcodesarry,'N');
		$restofquery .= " AND WaterfrontYN != 1 ";
	}
	if ( isset($_REQUEST['waterfront']) && $_REQUEST['waterfront'] == 'gulfaccess') {
		$_REQUEST['gulfaccess'] = 'gulfaccess';
	}
	if ( isset($_REQUEST['waterfront']) && $_REQUEST['waterfront'] == 'gulfaccess' ) {
		// $restofquery .= " AND FeatureCodes LIKE '%X38F%' ";
		$restofquery .= " AND ( WaterfrontYN = 1 AND ( 
			   STELLAR_WaterAccess LIKE '%Gulf%' 
			OR STELLAR_WaterAccess LIKE '%Intracoastal%' 
			OR STELLAR_WaterAccess LIKE '%Bay/Harbor%' 
			OR STELLAR_WaterAccess LIKE '%Canal - Saltwater%' 
			OR STELLAR_WaterAccess LIKE '%River%' 
			OR STELLAR_WaterAccess LIKE '%Canal - Brackish%' 
		) ) ";
		
		
	}

	if ( $checkit == 'yes' ) {
		if ( isset($_REQUEST['pool']) && $_REQUEST['pool'] == 'Y' ) {
			// $restofquery .= checkarray($poolcodesarry);
			// $restofquery .= " AND ( ( Pool LIKE '%Private%' OR Pool LIKE '%Community%' ) ) ";
			$restofquery .= " AND ( PoolPrivateYN = 1 AND PoolFeatures LIKE '%In Ground%' ) ";
			
			// $restofquery .= " AND ( ( Pool LIKE '%Private%' OR Pool LIKE '%Community%' ) ) ";
		} elseif ( isset($_REQUEST['pool']) && $_REQUEST['pool'] == 'N' ) {
			// $restofquery .= checkarray($poolcodesarry,'N');
			$restofquery .= " AND ( PoolPrivateYN != 1 ) ";
		}
		// garage
		if ( isset($_REQUEST['parking']) ) {
			$parking = INTVAL($_REQUEST['parking']);
			if ( $parking > 0 ) {
				$restofquery .= " AND GarageSpaces >= $parking ";
			}
		}
	}

	$querynolimit = " ";
	$mywholecountquery = $mycountquery.$restofquery;
	
	$result = mysqli_query($dbcmls,$mywholecountquery) or trigger_error('Bad mycount query: ' . mysqli_error($dbcmls).'<br><br>'.$mywholecountquery.'<br><br>');
	if ( !$result || mysqli_num_rows($result) < 1 ) {
		echo '<p>Sorry, no listings matched your search criteria. Please try again.</p>'."\n";
		include 'searchform.php';
		include 'footer.php'; 
		exit;
	}
	$row = mysqli_fetch_assoc($result);
	$mycount = $row['HowMany'];
	$myavgsoldprice = '';
	$myavgsoldpcent = '';
	if ( isset($row['AveClosePrice']) ) {
		$myavgsoldprice = $row['AveClosePrice'];
	}
	if ( isset($row['AveTotalPCent']) ) {
		$myavgsoldpcent = $row['AveTotalPCent'];
	} else {
		// $myavgsoldpcent = 100;
	}
	

	$sortit = " ORDER BY ListPrice DESC ";
	if ( isset($_REQUEST['orderby']) && ( $_REQUEST['orderby'] == 'ListPrice' || $_REQUEST['orderby'] == 'City' || $_REQUEST['orderby'] == 'ListingId' )  ) {
		$sortit1 = " ORDER BY ".$_REQUEST['orderby'];
	} else {
		$sortit1 = " ORDER BY ListPrice ";
	}
	if ( isset($_REQUEST['sortdirection']) && ( $_REQUEST['sortdirection'] == 'ASC' || $_REQUEST['sortdirection'] == 'DESC')  ) {
		$sortit2 = $_REQUEST['sortdirection'];
	} else {
		$sortit2 = " ASC ";
	}
	$orderby = $sortit1.' '.$sortit2;

	// $orderby = " ORDER BY ListPrice DESC ";

	// PAGINATE
	$limit = NUMPERPAGE; //use a default value of ten 
	$limitvalue = $page * $limit - ($limit);
	$max_links_shown = MAXLINKS; //use default
	$limitit = " LIMIT $limitvalue, ".$limit.' ';

	// $fields .= " , PhotoURL ";
	// $photourlsmalltable = 'PhotoURLs';
	// $leftjoinforpics = " LEFT JOIN PhotoURLs ON `$table`.ListingKeyNumeric = PhotoURLsSmall.ListingKeyNumeric AND PhotoKey = 1 ";
	// $myquery = " SELECT $fields FROM $dbname.`$table` $leftjoinforpics $where $proptypewhere ORDER BY $sortitby $sortitdir $limitit	";

	$mywholequery = $myselectquery.$restofquery.$orderby.$limitit ;
	// if ( $_SERVER['REMOTE_ADDR'] == '67.142.112.215' ) {
	// 	echo 'myselectquery: '.$myselectquery.'<br>';
	// 	echo 'restofquery: '.$restofquery.'<br>';
	// 	echo 'orderby: '.$orderby.'<br>';
	// 	echo 'limitit: '.$limitit.'<br>';
	// 	echo 'mywholequery: '.$mywholequery.'<br>';
	// }

	$myip = 'myip';
	$showqueries = 'yes';
	// $showqueries = 'no';

	$numofpages = ceil($mycount / $limit);

	if ($limit > $mycount) {
		$limit = $mycount;
	}

	// echoit('mycount',$mycount);
	if ( $mycount > 1 ) {
		$mylistings = 'listings';
		$mymatch = 'match';
	} elseif ($mycount == 1) {
		$mylistings = 'listing';
		$mymatch = 'matches';
	}	
	
	if ( $mycount > 0 ) {
		echo '<p><strong>'.number_format((float)$mycount).' '.$mylistings.'.</strong> '.ucfirst($config['myour']).' convenient <a href="#search">search form</a> can help you narrow down your search by modifying your search or searching only specific cities.</p>';
	} else {
		echo '<p>Sorry, no listings matched your search criteria. You can try another search:</p>';
		include 'searchform.php';
		include 'footer.php';
		exit;
	}


	if ( isset($_GET['MLNums']) ) {
		$mlnumarray = explode(',',$_GET['MLNums']);
		$themlnums = "'".implode("', '",$mlnumarray)."'";
		// $where = " WHERE ListingId IN ( $themlnums ) ";
		// $table = 'Listings';
		// $proptypewhere = '';
		// $mywholequery = " SELECT $fields FROM $dbname.`$table` $where ORDER BY $sortitby $sortitdir	";
		$mywholequery = " SELECT *, DATE_FORMAT(ListingContractDate, '%Y') as ListYear, MediaURL 
			WHERE ListingId IN ( $themlnums ) ";
	}

	if ( $_SERVER['REMOTE_ADDR'] == '172.58.174.152' ) {
		echo 'mywholequery searchresults 777: '.$mywholequery."<br>";
	}

	$getlistings = mysqli_query($dbcmls,$mywholequery) or trigger_error('Bad myquery: '.mysqli_error($dbcmls).'<br>--'.$mywholequery);


	// BEGIN STUFF FOR PAGINATION
	$firststring = $_SERVER['REQUEST_URI'];
	if ( 
		$_SERVER['REQUEST_URI'] == '/waterfront-homes.html' || 
		$_SERVER['REQUEST_URI'] == '/luxury-estates.html' || 
		$_SERVER['REQUEST_URI'] == '/luxury-condos.html' || 
		$_SERVER['REQUEST_URI'] == '/gulf-access-homes.html' || 
		$_SERVER['REQUEST_URI'] == '/pool-homes.html' 
		) {
		$firststring = '/searchresults.html?';
		foreach( $_REQUEST as $key => $val ) {
			// $firststring .= $key.'='.$val.'&';
			$firststring .= $key.'='.$val.'&';
		}
		if ( $_SERVER['REQUEST_URI'] == '/waterfront-homes.html' ) {
			// $firststring .= '&iswaterfront=iswaterfront';
		} elseif ($_SERVER['REQUEST_URI'] == '/luxury-estates.html') {
			// $firststring .= '&luxury=luxury';
		} elseif ($_SERVER['REQUEST_URI'] == '/gulf-access-homes.html') {
			// $firststring .= '&gulfaccess=gulfaccess';
		} elseif ($_SERVER['REQUEST_URI'] == '/luxury-condos.html') {
			// $firststring .= '&luxcondo=luxcondo';
		} elseif ($_SERVER['REQUEST_URI'] == '/pool-homes.html') {
			// $firststring .= '&poolhome=poolhome';
		}
		$firststring = rtrim($firststring,'&');
		// echo 'this string: '.$firststring.'<br><br>';
		// exit;
	}
// exit;
	// print '<br>thestring before pregreplace: '.$firststring.'<br>';
	$thestring = $firststring;
	$thestring = preg_replace('/&page=[0-9]*/','',$thestring);
	$thestring = preg_replace('/&/','&amp;',$thestring);
	$thestring = preg_replace('/\+/','-',$thestring);
	$thestring = rtrim($thestring,'&amp;');

// END STUFF FOR PAGINATION


	if ( !$getlistings ) {
		header( "HTTP/1.0 404 Not Found" );
		echo '<p>Sorry, no listings matched your search. Please try again...</p>'."\n";
		include '/home/flaidx/public_html/incsbridge2022/searchform.php';
		include 'footer.php'; 
		exit;
	}

	if ($getlistings) {
		$_SESSION['searchpage'] = $_SERVER['REQUEST_URI'];
		include ('/home/flaidx/public_html/incsbridge2022/paginate.php');
		if ( isset($_GET['sold']) && $_GET['sold'] == 'sold' ) {
			// spititout($getlistings, $TheTable, $proptype);
			include '/home/flaidx/public_html/incsbridge2022/soldtable.php';
		} else {
			while ($row = mysqli_fetch_assoc($getlistings)) {
				include '/home/flaidx/public_html/incsbridge2022/listingtable.php';	
			}
		}
		include ('paginate.php');
	}  else { // END if ($getlistings)
		include 'technical.php';
		include 'footer.php';
		exit;
	}
	// END if ($getlistings)


	echo $courtesy;

	// if ( $_SERVER['REMOTE_ADDR'] == '67.142.113.20' ) {
	// 	$stellardate = new DateTime('2019-06-04');
	// 	$nowdate = new DateTime();
	//
	// 	if($nowdate >= $nowdate) {
	// 	    echo 'show stellar';
	// 	} else {
	// 		echo 'show mfr';
	// 	}
	// }


} // END if !isset get featured

////// FEATURED LISTINGS //////   ////// Get the agents own listings
if ( isset($_REQUEST['featured']) ) {

	function getspreadheader($proptype) {
		$spreadheader = '';
		$spreadheader .=  '<table class="minilistingspread">'."\n";	
		$spreadheader .=  '<tr class="detailstab">'."\n";
		$spreadheader .= '<th>Address</th>';
		$spreadheader .= '<th>Price</th>';

		if ( $proptype == 'Lots' ) {
			$spreadheader .= '<th colspan="3" class="ctr">Use</th>';
		} elseif (  $proptype == 'Commercial' ) {
			$spreadheader .= '<th colspan="3" class="ctr">Use</th>';
		} else {
			$spreadheader .= '<th>Bedrooms</th>';
			$spreadheader .= '<th>Baths</th>';
			$spreadheader .= '<th>Sq. Ft. (Living)</th>';
		}
		$spreadheader .= '<th>MLS #</th>';
		$spreadheader .= '</tr>';
		return $spreadheader;
	}
	$spreadend = '</table>';

	if ( !empty($config['AgentID']) ) {
		$agentarry = explode(',',$config['AgentID']);
		if ( count($agentarry) > 1 ) {
			$getagentstring = " AND ListAgentMlsId IN (".$config['AgentID'].") ";
		} elseif ( count($agentarry) == 1 ) {
			$getagentstring = " AND ListAgentMlsId = '".$config['AgentID']."'";
		}
	} else {
		$getagentstring = '';
	}
	if ( $_SERVER['HTTP_HOST'] == 'www.portcharlottehouses.com' || $_SERVER['HTTP_HOST'] == 'www.searchsuncoast.com' ) {
			$getagentstring = " AND ListOfficeMlsId = '".$config['OfficeIDNum']."'";
	}

	
	$orderby = ' ORDER BY ListPrice DESC ';
	if ( $_REQUEST['featured'] == 'mobi' ) {
		$orderby = ' ORDER BY StreetName ASC ';
	}
	
	$_REQUEST['proptype'] = 'Homes';
		
	// HOMES first
	$proptype = 'Homes';
	$myprop = 'Home';
	$myselect = " SELECT *, DATE_FORMAT(ListingContractDate, '%Y') as ListYear, PhotoURL ";
	// $getfields = '';
	// $getfields = $all + $homes;
	// $myselect .= implode(', ',$getfields);
	$fromtable = " FROM Listings ";
	$andwhere = " WHERE MlsStatus = 'Active' ";
	$andwhere .= " AND PropertyType = 'Residential' ";
	$andwhere .= " AND PropertySubType IN ('Single Family Residence', 'Condominium', 'Townhouse', 'Villa', 'Farm', 'Manufactured Home', 'Mobile Home') ";
	$andwhere .= $getagentstring;

	// get pics
	$table = 'Listings';
	$phototable = 'PhotoURLs';
	// $fields .= " , PhotoURL ";
	// $leftjoinforpics = " LEFT JOIN $phototable ON `$table`.ListingKeyNumeric = $phototable.ListingKeyNumeric AND PhotoKey = 1 ";
	$leftjoinforpics = "  ";
	
	
	$queryhomes = $myselect.$fromtable.$leftjoinforpics.$andwhere.$orderby;
	// if ( $_SERVER['REMOTE_ADDR'] == '67.142.112.229' ) {
	// 	echo 'line 918 queryhomes: <br>'.$queryhomes.'<br>';
	// }
	$gethomes = mysqli_query($dbcmls,$queryhomes) or trigger_error('Bad gethomes query: '.mysqli_error($dbcmls).'<br>'.$queryhomes);
	$myselect = '';


	// Condos
	$proptype = 'Condos';
	$myprop = 'Condo';
	$myselect = " SELECT *,  DATE_FORMAT(ListingContractDate, '%Y') as ListYear ";
	// $getfields = '';
	// $getfields = $all + $condos;
	// $myselect .= implode(', ',$getfields);
	$fromtable = " FROM Listings ";
	$andwhere = " WHERE MlsStatus = 'Active' ";
	$andwhere .= " AND PropertyType = 'Residential' ";
	$andwhere .= " AND PropertySubType = 'Condominium' ";
	$andwhere .= $getagentstring;
	$querycondos = $myselect.$fromtable.$leftjoinforpics.$andwhere.$orderby;
	// echo '<br>Condo query: '.$querycondos.'<br>';
	$getcondos = mysqli_query($dbcmls,$querycondos) or trigger_error('Bad getcondos query: '.mysqli_error($dbcmls));
	$myselect = '';

	// Lots
	$proptype = 'Lots';
	$myprop = 'Lot';
	$myselect = " SELECT *, DATE_FORMAT(ListingContractDate, '%Y') as ListYear ";
	// $getfields = '';
	// $getfields = $all + $lots;
	// $myselect .= implode(', ',$getfields);
	$fromtable = " FROM Listings ";
	$andwhere = " WHERE MlsStatus = 'Active' ";
	$andwhere .= " AND PropertyType ='Land' ";
	$andwhere .= $getagentstring;
	$querylots = $myselect.$fromtable.$leftjoinforpics.$andwhere.$orderby;
	// echo '<br>Lots query: '.$querylots.'<br>';
	$getlots = mysqli_query($dbcmls,$querylots) or trigger_error('Bad getlots query: '.mysqli_error($dbcmls));
	$myselect = '';

	// Commercial
	$proptype = 'Commercial';
	$myprop = 'Commercial Properties';
	$myselect = " SELECT *, DATE_FORMAT(ListingContractDate, '%Y') as ListYear ";
	// $getfields = '';
	// $getfields = $all + $commercial;
	// $myselect .= implode(', ',$getfields);
	$fromtable = " FROM Listings ";
	$andwhere = " WHERE MlsStatus = 'Active' ";
	$andwhere .= " AND PropertyType ='Commercial' ";
	$andwhere .= $getagentstring;
	$querycommercial = $myselect.$fromtable.$leftjoinforpics.$andwhere.$orderby;
	// echo '<br>Commercial query: '.$querycommercial.'<br>';
	$getcommercial = mysqli_query($dbcmls,$querycommercial) or trigger_error('Bad getlots query: '.mysqli_error($dbcmls));
	$myselect = '';


	echo '<ul style="margin-left:0; padding-left:0;">';
	if ($gethomes && mysqli_num_rows($gethomes) > 0 ) {
		echo '<li style="display:block; float:left; padding-left:15px;"><a href="#ourhomes">Featured Homes</a></li>';
	}
	if ($getcondos && mysqli_num_rows($getcondos) > 0 ) {
		echo '<li style="display:block; float:left;margin-left:5px; padding-left:15px;"><a href="#ourcondos">Featured Condos</a></li>';
	}
	if ($getlots && mysqli_num_rows($getlots) > 0 ) {
		echo '<li style="display:block; float:left;margin-left:5px; padding-left:15px;"><a href="#ourlots">Featured Land</a></li>';
	}
	if ($getcommercial && mysqli_num_rows($getcommercial) > 0 ) {
		echo '<li style="display:block; float:left;margin-left:5px; padding-left:15px;"><a href="#ourcommercial">Featured Commercial Properties</a></li>';
	}
	echo '</ul><br clear="all">';

	if ($gethomes && mysqli_num_rows($gethomes) > 0 ) {
		$proptype = 'Homes';
		echo '<a name="ourhomes"></a>';
		echo '<h2 class="topmgn">Featured Homes</h2>';
		$details = ( $_REQUEST['featured'] == 'mobi' ) ? getspreadheader($proptype) : '';
		while ($row = mysqli_fetch_assoc($gethomes)) {
			if ( $_REQUEST['featured'] == 'mobi' ) {
				include '/home/flaidx/public_html/incsbridge2022/listingtable.php';
			} else {
				include '/home/flaidx/public_html/incsbridge2022/listingtable.php';
			}
		}
		if ( $_REQUEST['featured'] == 'mobi' ) {
			$details .= $spreadend;
			echo $details;
		}

		$row = array();
	}


	if ($getcondos && mysqli_num_rows($getcondos) > 0 ) {
		$proptype = 'Condos';
		echo '<a name="ourcondos"></a>';
		echo '<h2 class="topmgn">Featured Condos</h2>';
		$details = ( $_REQUEST['featured'] == 'mobi' ) ? getspreadheader($proptype) : '';
		while ($row = mysqli_fetch_assoc($getcondos)) {
			if ( $_REQUEST['featured'] == 'mobi' ) {
				include '/home/flaidx/public_html/incsbridge2022/listingtablespread.php';
			} else {
				include '/home/flaidx/public_html/incsbridge2022/listingtable.php';
			}
		}
		if ( $_REQUEST['featured'] == 'mobi' ) {
			$details .=$spreadend;
			echo $details;
		}
		$row = array();
	}

	if ($getlots && mysqli_num_rows($getlots) > 0 ) {
		$proptype = 'Lots';
		echo '<a name="ourlots"></a>';
		echo '<h2 class="topmgn">Featured Lots & Land</h2>';
		$details = ( $_REQUEST['featured'] == 'mobi' ) ? getspreadheader($proptype) : '';
		while ($row = mysqli_fetch_assoc($getlots)) {
			if ( $_REQUEST['featured'] == 'mobi' ) {
				include '/home/flaidx/public_html/incsbridge2022/listingtablespread.php';
			} else {
				include '/home/flaidx/public_html/incsbridge2022/listingtable.php';
			}
		}
		if ( $_REQUEST['featured'] == 'mobi' ) {
			$details .=$spreadend;
			echo $details;
		}
		$row = array();
	}

	if ($getcommercial && mysqli_num_rows($getcommercial) > 0 ) {
		$proptype = 'Commercial';
		echo'<a name="ourcommercial"></a>';
		echo '<h2 class="topmgn">Featured Commercial Property</h2>';
		$details = ( $_REQUEST['featured'] == 'mobi' ) ? getspreadheader($proptype) : '';
		while ($row = mysqli_fetch_assoc($getcommercial)) {
			if ( $_REQUEST['featured'] == 'mobi' ) {
				include '/home/flaidx/public_html/incsbridge2022/listingtablespread.php';
			} else {
				include '/home/flaidx/public_html/incsbridge2022/listingtable.php';
			}
		}
		if ( $_REQUEST['featured'] == 'mobi' ) {
			$details .=$spreadend;
			echo $details;
		}
		
		$row = array();
	}
	
	echo $courtesy;

	// echo '<ul><li>You can <a href="/search-listings.html">search for property listings</a> based on your own criteria to help you find the perfect southwest Florida real estate.</li></ul>';
	// include 'searchform.php';

}


// include '/home/flaidx/public_html/incsbridge2022/searchform.php';


include 'footer.php';