2000000) {
$resiPriceLow = ($row_rsShowResi['search_price'] - 700000);
$resiPriceHigh = ($row_rsShowResi['search_price'] + 700000);
$resiSqftLow = ($row_rsShowResi['square_foot'] - 1500);
$resiSqftHigh = ($row_rsShowResi['square_foot'] + 1500);
} else if ($row_rsShowResi['search_price'] > 1000000) {
$resiPriceLow = ($row_rsShowResi['search_price'] - 250000);
$resiPriceHigh = ($row_rsShowResi['search_price'] + 250000);
$resiSqftLow = ($row_rsShowResi['square_foot'] - 800);
$resiSqftHigh = ($row_rsShowResi['square_foot'] + 800);
} else {
$resiPriceLow = ($row_rsShowResi['search_price'] - 80000);
$resiPriceHigh = ($row_rsShowResi['search_price'] + 80000);
$resiSqftLow = ($row_rsShowResi['square_foot'] - 400);
$resiSqftHigh = ($row_rsShowResi['square_foot'] + 400);
}
$query_rsShowMul = "SELECT multi_id, mls_id, search_price, square_foot
FROM multi_data
WHERE mls_id = '$grabMls' ";
$rsShowMul = mysqli_query($mlsMain, $query_rsShowMul);
$row_rsShowMul = mysqli_fetch_array($rsShowMul, MYSQLI_ASSOC);
$totalRows_rsShowMul = mysqli_num_rows($rsShowMul);
$mulPriceLow = ($row_rsShowMul['search_price'] - 100000);
$mulPriceHigh = ($row_rsShowMul['search_price'] + 100000);
$query_rsShowLot = "SELECT lot_id, mls_id, search_price, lot_size
FROM lot_data
WHERE mls_id = '$grabMls' ";
$rsShowLot = mysqli_query($mlsMain, $query_rsShowLot);
$row_rsShowLot = mysqli_fetch_array($rsShowLot, MYSQLI_ASSOC);
$totalRows_rsShowLot = mysqli_num_rows($rsShowLot);
$lotPriceLow = ($row_rsShowLot['search_price'] - 100000);
$lotPriceHigh = ($row_rsShowLot['search_price'] + 100000);
$query_rsShowCom = "SELECT comm_id, mls_id, search_price
FROM comm_data
WHERE mls_id = '$grabMls' ";
$rsShowCom = mysqli_query($mlsMain, $query_rsShowCom);
$row_rsShowCom = mysqli_fetch_array($rsShowCom, MYSQLI_ASSOC);
$totalRows_rsShowCom = mysqli_num_rows($rsShowCom);
$comPriceLow = ($row_rsShowCom['search_price'] - 100000);
$comPriceHigh = ($row_rsShowCom['search_price'] + 100000);
if ($fromVar == 'R') {
$_SESSION['searchSql'] = "AND search_price BETWEEN $resiPriceLow AND $resiPriceHigh AND square_foot BETWEEN $resiSqftLow AND $resiSqftHigh";
}
if ($fromVar == 'RL') {
$_SESSION['searchSql'] = "AND search_price BETWEEN $luxPriceLow AND $luxPriceHigh";
$fromVar = "R";
}
if ($fromVar == 'M') {
$_SESSION['searchSql'] = "AND search_price BETWEEN $mulPriceLow AND $mulPriceHigh AND sq_ft BETWEEN $resiSqftLow AND $resiSqftHigh";
}
if ($fromVar == 'L') {
$_SESSION['searchSql'] = "AND search_price BETWEEN $lotPriceLow AND $lotPriceHigh";
}
if ($fromVar == 'C') {
$_SESSION['searchSql'] = "AND search_price BETWEEN $comPriceLow AND $comPriceHigh";
}
$goToPage = "property_list?ref=sim&t=$fromVar&rows=10";
?>