if ($rows['lot_size'] <= 0 || $rows['lot_size'] == "") {
$rows['lot_size'] = $lot_size;
}
if ($rows['stories'] <= 0 || $rows['stories'] == "") {
$rows['stories'] = $stories;
}
if ($rows['year_built'] <= 0 || $rows['year_built'] == "") {
$rows['year_built'] = $year_built;
}
if ($rows['distance'] < 0 || $rows['distance'] == "") {
continue;
}
if ($rows['dateSold'] == "") {
continue;
}
$rows['propertyType'] = getPropertyTypeDLP($rows['propertyType']);
/*
if(($rows['sq_size'] > $C1Rangesqrft['Min'] && $rows['sq_size'] < $C1Rangesqrft['Max'] ) && ($rows['lot_size]'] > $C1Rangelot['Min'] && $rows['lot_size]'] < $C1Rangelot['Max']) && ($rows['year_built'] > $C1RangeAge['Min'] && $rows['year_built'] < $C1RangeAge['Max']) && ($ydate> $cn1) && $rows['distance']<$C1Proximity)
{
$c1[] = array('address'=>$rows['address'], 'distance'=>$rows['distance'],'bedsBaths'=>$rows['beds'] ,'sq_size'=>$rows['sq_size'],'year_built'=>$rows['year_built'],'lot_size'=>$rows['lot_size'],'stories'=>$rows['stories'],'dateSold'=>$rows['dateSold'], 'amount'=>$rows['amount'], 'latitude'=>$coords['latitude'], 'longitude'=>$coords['longitude']);
}
else
if(($rows['sq_size'] > $C2Rangesqrft['Min'] && $rows['sq_size'] < $C2Rangesqrft['Max'] ) && ($rows['lot_size'] > $C2Rangelot['Min'] && $rows['lot_size'] < $C2Rangelot['Max']) && ($rows['year_built'] > $C2RangeAge['Min'] && $rows['year_built'] < $C2RangeAge['Max']) && ($ydate> $cn2) && $rows['distance']<$C2Proximity)
{
$c2[] = array('address'=>$rows['address'], 'distance'=>$rows['distance'],'bedsBaths'=>$rows['beds'] ,'sq_size'=>$rows['sq_size'],'year_built'=>$rows['year_built'],'lot_size'=>$rows['lot_size'],'stories'=>$rows['stories'],'dateSold'=>$rows['dateSold'], 'amount'=>$rows['amount'], 'latitude'=>$coords['latitude'], 'longitude'=>$coords['longitude']);
}else */
if ($rows['sq_size'] >= $C3Rangesqrft['Min'] && $rows['sq_size'] <= $C3Rangesqrft['Max'] && ($rows['lot_size'] >= $C3Rangelot['Min'] && $rows['lot_size'] <= $C3Rangelot['Max']) && ($rows['year_built'] >= $C3RangeAge['Min'] && $rows['year_built'] <= $C3RangeAge['Max']) && $rows['distance'] <= $C3Proximity && $rows['stories'] == $stories && $rows['propertyType'] == $propertyType) {
$rows['dateSold'] = preg_replace("@T.*?\$@", "", $rows['dateSold']);
list($y, $m, $d) = preg_split("@-@", $rows['dateSold']);
$rows['dateSold'] = $m . "/" . $d . "/" . $y;
$c3[] = array('address' => $rows['address'], 'distance' => $rows['distance'], 'bedsBaths' => $rows['beds'], 'sq_size' => $rows['sq_size'], 'year_built' => $rows['year_built'], 'lot_size' => $rows['lot_size'], 'stories' => $rows['stories'], 'dateSold' => $rows['dateSold'], 'amount' => $rows['amount'], 'latitude' => $rows['latitude'], 'longitude' => $rows['longitude'], 'pool' => $rows['pool'], 'basement' => $rows['basement'], 'criteria' => '3', 'criteria3' => 'cr3', 'propertyType' => $rows['propertyType']);
url: "home.php?page="+currentPage+"&set_page=index",
success: function(data){
$("#pageContent").html(data);
$('.nav-stacked li').removeClass('active')
$(".nav-stacked li:first").addClass("active");
}
});
</script>
<?php
exit;
}
unset($_SESSION['trackerror']);
$PropData['TOTALBATHROOMCOUNT'] = round($PropData['TOTALBATHROOMCOUNT']);
$pType = $PropData['STANDARDUSECODE_EXT'];
$propertyType = getPropertyTypeDLP($PropData['STANDARDUSECODE_EXT']);
$city = $PropData['_CITY'];
$state = $PropData['_STATE'];
$zip = $PropData['_POSTALCODE'];
$PropData['_STREETADDRESS'] = trim($PropData['_STREETADDRESS']);
$street = $PropData['_HOUSENUMBERFRACTION_EXT'] . " " . $PropData['_HOUSENUMBER'] . " " . $PropData['_DIRECTIONSUFFIX'] . " " . $PropData['_STREETNAME'] . " " . $PropData['_STREETSUFFIX'] . " " . $PropData['_APARTMENTORUNITPREFIX_EXT'] . " " . $PropData['_APARTMENTORUNIT'];
$street = trim($street);
$Add = $street . ' ' . $PropData['_CITY'] . ' ' . $PropData['_STATE'] . ' ' . $PropData['_POSTALCODE'];
$sq_footage = round($PropData['GROSSLIVINGAREASQUAREFEETCOUNT']);
$org_footage = round($PropData['GROSSLIVINGAREASQUAREFEETCOUNT']);
$bedrooms = round($PropData['TOTALBEDROOMCOUNT']);
$bathrooms = round($PropData['TOTALBATHROOMCOUNT']);
$year_built = $PropData['PROPERTYSTRUCTUREBUILTYEAR'];
$lot_size = round($PropData['LOTSIZESQUAREFEETCOUNT_EXT']);
$stories = round($PropData['STORIESCOUNT']);
$sq_f = "+/- 20%";
function get_xml_data_address($arrParam)
{
$url = 'http://dlpapi.realtytrac.com/Reports/Get?ApiKey=a2d3e2aa-9c9b-4aab-af3a-56785ae67e25&Login=accurity&Password=1cyquent!&JobID=&LoanNumber=&PreparedBy=&ResellerID=&PreparedFor=&OwnerFirstName=&OwnerLastName=&AddressType=&PropertyStreetAddress=' . $arrParam['street'] . '&AddressNumber=&StartAddressNumberRange=&EndAddressNumberRange=&StreetDir=&StreetName=&StreetSuffix=&City=' . $arrParam['city'] . '&StateCode=' . $arrParam['state'] . '&County=&ZipCode=&PropertyParcelID=&SAPropertyID=&APN=&ApnRangeStart=&ApnRangeEnd=&GeoCodeX=&GeoCodeY=&GeoCodeRadius=&SearchType=&NumberOfRecords=&Format=XML&ReportID=104&R104_SettingsMode=';
$path = $_SESSION['path'];
$fp = fopen($path, "a");
fwrite($fp, "<p>Query To Get Comparable Property - <b> " . $url . "</b></p>");
fclose($fp);
$curl = curl_init();
curl_setopt_array($curl, array(CURLOPT_RETURNTRANSFER => 1, CURLOPT_URL => $url));
$resp = curl_exec($curl);
curl_close($curl);
preg_match_all("@<PROPERTY>(.*?)</PROPERTY>@is", $resp, $aProp, PREG_SET_ORDER);
$result = array();
foreach ($aProp as $arr) {
preg_match("@_City=\"(.*?)\"\\s*_StreetAddress=\"(.*?)\"\\s*_State=\"(.*?)\"\\s*_PostalCode=\"(.*?)\"@is", $arr[1], $matches);
$address = $matches[2] . " " . $matches[1] . " " . $matches[3] . " " . $matches[4];
preg_match("@DistanceFromSubjectPropertyMilesCount=\"(.*?)\"@is", $arr[1], $distance);
preg_match("@TotalBedroomCount=\"(.*?)\"@is", $arr[1], $beds);
preg_match("@TotalBathroomCount=\"(.*?)\"@is", $arr[1], $baths);
preg_match("@GrossLivingAreaSquareFeetCount=\"(.*?)\"@is", $arr[1], $size);
preg_match("@PropertyStructureBuiltYear=\"(.*?)\"@is", $arr[1], $built);
preg_match("@LotSquareFeetCount=\"(.*?)\"@is", $arr[1], $lot);
preg_match("@StoriesCount=\"(.*?)\"@is", $arr[1], $story);
preg_match("@LatitudeNumber=\"(.*?)\"\\s*LongitudeNumber=\"(.*?)\"@is", $arr[1], $coords);
if (preg_match("@PropertySalesDate@", $arr[1])) {
preg_match("@PropertySalesDate=\"(.*?)\"@is", $arr[1], $sale_date);
} else {
preg_match("@SALES_HISTORY.*?TransferDate_ext=\"(.*?)\"@is", $arr[1], $sale_date);
}
preg_match("@SALES_HISTORY.*?PropertySalesAmount=\"(.*?)\"@is", $arr[1], $sale_amount);
preg_match("@AMENITY _Type=\"Pool\" _ExistsIndicator=\"(.*?)\"@is", $arr[1], $pool);
if ($pool[1] == "") {
$pool[1] = "N";
}
preg_match("@BASEMENT SquareFeetCount=\"(.*?)\"@is", $arr[1], $basement);
if ($basement[1] > 0) {
$basement[1] = "Y";
} else {
$basement[1] = "No";
}
if ($coords[1] != "") {
$latitude = $coords[1];
}
if ($coords[2] != "") {
$longitude = $coords[2];
}
preg_match("@TransferDate_ext=\"(.*?)\"@is", $arr[1], $transfer);
$transfer[1] = preg_replace("@T.*?\$@is", "", $transfer[1]);
preg_match("@StoriesCount=\"(.*?)\"@is", $arr[1], $stories);
$stories = $stories[1];
preg_match("@StandardUseCode_ext=\"(.*?)\"@", $arr[1], $props);
$ptype = trim($props[1]);
$ptype = getPropertyTypeDLP($ptype);
if ($basement[1] == "Yes") {
$basement[1] = "Y";
} else {
if ($basement[1] == "No") {
$basement[1] = "N";
}
}
$result[] = array('address' => $address, 'distance' => $distance[1], 'beds' => floor($beds[1]) . ' /' . floor($baths[1]) . ' ', 'sq_size' => $size[1], 'year_built' => $built[1], 'lot_size' => $lot[1], 'stories' => $story[1], 'dateSold' => $sale_date[1], 'amount' => $sale_amount[1], 'street' => $matches[2], 'city' => $matches[1], 'state' => $matches[3], 'zip' => $matches[4], 'latitude' => $latitude, 'longitude' => $longitude, 'pool' => $pool[1], 'basement' => $basement[1], 'transferDate' => $transfer[1], 'stories' => $stories, 'propertyType' => $ptype);
}
return $result;
}
