$value) {
$$key = $value;
}
reset($_GET);
foreach ($_POST as $key => $value) {
$$key = $value;
}
reset($_POST);
if ($_GET[‘Offset’]) {
$Offset = $_GET[‘Offset’];
} else if ($_POST[‘Offset’]) {
$Offset = $_POST[‘Offset’];
} else {
$Offset = 0;
}
if ($_GET[‘Limit’]) {
$Limit = $_GET[‘Limit’];
} else if ($_POST[‘Limit’]) {
$Limit = $_POST[‘Limit’];
} else {
$Limit = 12;
}
if ($_GET[‘Prop_Type_res0’]) {
$_GET[‘Prop_Type_res’][0] = $_GET[‘Prop_Type_res0’];
$_POST[‘Prop_Type_res’][0] = $_GET[‘Prop_Type_res0’];
$key = “Prop_Type_res[0]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_res0’]).”&”;
}
if ($_GET[‘Prop_Type_res’][0]) {
$_POST[‘Prop_Type_res’][0] = $_GET[‘Prop_Type_res’][0];
$key = “Prop_Type_res[0]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_res0’]).”&”;
}
if ($_GET[‘Prop_Type_res1’]) {
$_GET[‘Prop_Type_res’][1] = $_GET[‘Prop_Type_res1’];
$_POST[‘Prop_Type_res’][1] = $_GET[‘Prop_Type_res1’];
$key = “Prop_Type_res[1]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_res1’]).”&”;
}
if ($_GET[‘Prop_Type_res’][1]) {
$_POST[‘Prop_Type_res’][1] = $_GET[‘Prop_Type_res’][1];
$key = “Prop_Type_res[1]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_res1’]).”&”;
}
if ($_GET[‘Prop_Type_res2’]) {
$_GET[‘Prop_Type_res’][2] = $_GET[‘Prop_Type_res2’];
$_POST[‘Prop_Type_res’][2] = $_GET[‘Prop_Type_res2’];
$key = “Prop_Type_res[2]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_res2’]).”&”;
}
if ($_GET[‘Prop_Type_res’][2]) {
$_POST[‘Prop_Type_res’][2] = $_GET[‘Prop_Type_res’][2];
$key = “Prop_Type_res[2]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_res2’]).”&”;
}
if ($_GET[‘Prop_Type_comm0’]) {
$_GET[‘Prop_Type_comm’][0] = $_GET[‘Prop_Type_comm0’];
$_POST[‘Prop_Type_comm’][0] = $_GET[‘Prop_Type_comm0’];
$key = “Prop_Type_comm[0]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_comm0’]).”&”;
}
if ($_GET[‘Prop_Type_comm’][0]) {
$_POST[‘Prop_Type_comm’][0] = $_GET[‘Prop_Type_comm’][0];
$key = “Prop_Type_comm[0]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_comm0’]).”&”;
}
if ($_GET[‘Prop_Type_comm1’]) {
$_GET[‘Prop_Type_comm’][1] = $_GET[‘Prop_Type_comm1’];
$_POST[‘Prop_Type_comm’][1] = $_GET[‘Prop_Type_comm1’];
$key = “Prop_Type_comm[1]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_comm1’]).”&”;
}
if ($_GET[‘Prop_Type_comm’][1]) {
$_POST[‘Prop_Type_comm’][1] = $_GET[‘Prop_Type_comm’][1];
$key = “Prop_Type_comm[1]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_comm1’]).”&”;
}
if ($_GET[‘Prop_Type_land0’]) {
$_GET[‘Prop_Type_land’][0] = $_GET[‘Prop_Type_land0’];
$_POST[‘Prop_Type_land’][0] = $_GET[‘Prop_Type_land0’];
$key = “Prop_Type_land[0]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_land0’]).”&”;
}
if ($_GET[‘Prop_Type_land’][0]) {
$_POST[‘Prop_Type_land’][0] = $_GET[‘Prop_Type_land’][0];
$key = “Prop_Type_land[0]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_land0’]).”&”;
}
if ($_GET[‘Prop_Type_land1’]) {
$_GET[‘Prop_Type_land’][1] = $_GET[‘Prop_Type_land1’];
$_POST[‘Prop_Type_land’][1] = $_GET[‘Prop_Type_land1’];
$key = “Prop_Type_land[1]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_land1’]).”&”;
}
if ($_GET[‘Prop_Type_land’][1]) {
$_POST[‘Prop_Type_land’][1] = $_GET[‘Prop_Type_land’][1];
$key = “Prop_Type_land[1]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_land1’]).”&”;
}
reset($_POST[‘Prop_Type_res’]);
// cycle thru passed areas
if ($_GET[‘Area’]) {
foreach ($_GET[‘Area’] as $key => $value) {
$_POST[‘Area’][$key] = $value;
}
} else {
for($i=0;$i<=11;$i++) {
$thisArea = "Area".$i;
if ($_GET[$thisArea]) {
$_POST['Area'][$i] = $_GET[$thisArea];
$GetPass .= "Area[$i]=".urlencode($_GET[$thisArea])."&";
}
}
}
// cycle thru passed acres
if ($_GET['Number_Acres']) {
foreach ($_GET['Number_Acres'] as $key => $value) {
$_POST[‘Number_Acres’][$key] = $value;
}
} else {
for($i=0;$i<=11;$i++) {
$thisAcres = "Number_Acres".$i;
if ($_GET[$thisAcres]) {
$_POST['Number_Acres'][$i] = $_GET[$thisAcres];
$GetPass .= "Number_Acres[$i]=".urlencode($_GET[$thisAcres])."&";
}
}
}
// cycle thru passed bdrms
if ($_GET['Bedrooms']) {
foreach ($_GET['Bedrooms'] as $key => $value) {
$_POST[‘Bedrooms’][$key] = $value;
}
} else {
for($i=0;$i<=5;$i++) {
$thisBdrm = "Bedrooms".$i;
if ($_GET[$thisBdrm]) {
$_POST['Bedrooms'][$i] = $_GET[$thisBdrm];
$GetPass .= "Bedrooms[$i]=".urlencode($_GET[$thisBdrm])."&";
}
}
}
// cycle thru passed Fl_Baths
if ($_GET['Fl_Baths']) {
foreach ($_GET['Fl_Baths'] as $key => $value) {
$_POST[‘Fl_Baths’][$key] = $value;
}
} else {
for($i=0;$i<=2;$i++) {
$thisBtrm = "Fl_Baths".$i;
if ($_GET[$thisBtrm]) {
$_POST['Fl_Baths'][$i] = $_GET[$thisBtrm];
$GetPass .= "Fl_Baths[$i]=".urlencode($_GET[$thisBtrm])."&";
}
}
}
// cycle thru passed Ttl_Sqft
if ($_GET['TotalSqFt']) {
foreach ($_GET['TotalSqFt'] as $key => $value) {
$_POST[‘TotalSqFt’][$key] = $value;
}
} else {
for($i=0;$i<=4;$i++) {
$thisTtlsqft = "TotalSqFt".$i;
if ($_GET[$thisTtlsqft]) {
$_POST['TotalSqFt'][$i] = $_GET[$thisTtlsqft];
$GetPass .= "TotalSqFt[$i]=".urlencode($_GET[$thisTtlsqft])."&";
}
}
}
// create the conditions for the query
// it's a search on property details
// default to all property classes if none are checked
if ((!$_POST['Prop_Type_res']) and (!$_POST['Prop_Type_comm']) and (!$_POST['Prop_Type_land']) and (!$_GET['Prop_Class'])) {
$Conditions .= "(Prop_Class = 'Residential' OR Prop_Class = 'Commercial' OR Prop_Class = 'Land' OR Prop_Class = 'Farmranch')";
} else {
$Conditions .= "(";
if ($_GET['Prop_Class']=="Residential") {
$Conditions .= "(Prop_Class = 'Residential'";
$Conditions .= ") OR ";
$GetPass .= "Prop_Class=Residential&";
}
if ($_POST['Prop_Type_comm'] || $_GET['Prop_Class']=="Commercial") {
$Conditions .= "(Prop_Class = 'Commercial'";
$Conditions .= ") OR ";
$GetPass .= "Prop_Class=Commercial&";
}
$landRanchFlag = 0;
if ($_POST['Prop_Type_land'] || $_GET['Prop_Class']=="Land") {
if ($_POST['Prop_Type_land']) {
$propTypeLndCond = "";
foreach ($_POST['Prop_Type_land'] as $key => $value) {
if ($value == “Ranch”) {
$landRanchFlag = 1;
$propTypeLndCond .= “Prop_Class = ‘Farmranch’ || “;
$GetPass .= “Prop_Type_land=Ranch&”;
}
}
if ($propTypeLndCond) {
$propTypeLndCond = substr($propTypeLndCond,0,-4);
$Conditions .= “($propTypeLndCond) OR “;
}
}
if (!$landRanchFlag) {
$Conditions .= “(Prop_Class = ‘Land'”;
$Conditions .= “) OR “;
$GetPass .= “Prop_Class=Land&”;
}
}
if ($_POST[‘Prop_Type_res’]) {
$propTypeResCond = “”;
foreach ($_POST[‘Prop_Type_res’] as $key => $value) {
$propTypeResCond .= “Prop_Type = ‘$value’ || “;
$GetPass .= “Prop_Type_res[$key]=$value&”;
if ($value == “Single Family”) {
$propTypeResCond .= “Prop_Type = ‘Single Family’ || Prop_Type = ‘Single Fam w Acc Dwelling’ || Prop_Type = ‘Stick Built’ || Prop_Type = ‘Modular’ || “;
}
if ($value == “Condo”) {
$propTypeResCond .= “Prop_Type = ‘Multi-Family’ || Prop_Type = ‘Townhouse’ || “;
}
}
if ($propTypeResCond) {
$propTypeResCond = substr($propTypeResCond,0,-4);
$Conditions .= “($propTypeResCond) OR “;
}
}
// for the property classes, trim the ‘ OR ‘
$Conditions = substr($Conditions, 0, strlen($Conditions)-4);
$Conditions .= “)”;
}
// then go on to formulate the rest of the query
if ($Asking_Price_from) $Conditions .= ” AND Asking_Price >= ‘$Asking_Price_from'”;
if ($Asking_Price_to) $Conditions .= ” AND Asking_Price <= '$Asking_Price_to'";
$areaStr = "";
$areaCnt = 0;
if ($_POST['Area']) {
foreach ($_POST['Area'] as $key => $value) {
$areaCnt++;
$areaStr .= ” Area = ‘$value’ || “;
if ($value == “Crested Butte Rural”) $areaStr .= ” Area = ‘Mt. Crested Butte Rural’ || “;
$GetPass .= “Area[“.$areaCnt.”]=”.urlencode($value).”&”;
}
if ($areaStr) {
$areaStr = substr($areaStr,0,-4);
$Conditions .= ” AND ($areaStr)”;
}
}
// set areas if none are chosen
if (!$areaStr) {
$Conditions .= ” AND (Area = ‘Crested Butte’ || Area = ‘Crested Butte Rural’ || Area = ‘Mt. Crested Butte Rural’ || Area = ‘Mt. Crested Butte’ || Area = ‘Crested Butte South’ || Area = ‘Kebler Pass’ || Area = ‘Almont’ || Area = ‘Gunnison’ || Area = ‘Gunnison Rural’ || Area = ‘Ohio Creek Area’ || Area = ‘Powderhorn’)”;
}
$sqftConditions = “”;
if ($_POST[‘TotalSqFt’]) {
foreach ($_POST[‘TotalSqFt’] as $key => $value) {
if ($value == “5000+”) {
$sqftConditions .= “(TotalSqFt >= ‘5000’) || “;
} else {
$sqftBits = explode(“-“,$value);
$sqftConditions .= “(TotalSqFt >= ‘$sqftBits[0]’ && TotalSqFt <= '$sqftBits[1]') || ";
}
$GetPass .= "TotalSqFt[$key]=$value&";
}
$sqftConditions = substr($sqftConditions, 0, strlen($sqftConditions)-4);
if ($sqftConditions) $Conditions .= " AND ($sqftConditions)";
}
if ($Number_Acres && !$Prop_Class_land) {
// This works fine for non land properties
foreach ($Number_Acres as $key => $value) {
if ($value) {
$GetPass .= “Number_Acres[$key]=$value&”;
$acreConditions .= “(“;
$Acres = explode(“-“, $value);
$acreConditions .= “Acres >= ‘$Acres[0]'”;
$acreConditions .= ” AND Acres <= '$Acres[1]'";
$acreConditions .= ") || ";
}
}
} else if ($Number_Acres && $Prop_Class_land) {
foreach ($Number_Acres as $key => $value) {
if ($value) {
$GetPass .= “Number_Acres[$key]=$value&”;
if ($value == “-0.5”) $acreConditions .= “Acres = ‘Less than 1’ || “;
if ($value == “0.5-1”) $acreConditions .= “Acres = ‘Less than 1’ || “;
if ($value == “1-5”) $acreConditions .= “Acres = ‘1-5’ || “;
if ($value == “5-10”) $acreConditions .= “Acres = ‘6-10′ || “;
if ($value == “10-40”) $acreConditions .= “Acres = ’11-40′ || “;
if ($value == “40-100”) $acreConditions .= “Acres = ’41+’ || “;
if ($value == “100-10000000000″) $acreConditions .= ” Acres = ’41+’ || “;
}
}
}
$acreConditions = substr($acreConditions, 0, strlen($acreConditions)-4);
if ($acreConditions) $Conditions .= ” AND ($acreConditions)”;
$bdrmStr = “”;
if ($_POST[‘Bedrooms’]) {
foreach ($_POST[‘Bedrooms’] as $key => $value) {
if ($value == “Studio”) {
$bdrmStr .= ” Bedrooms = ‘Studio’ || “;
$GetPass .= “Bedrooms[1]=Studio&”;
}
if ($value == “1”) {
$bdrmStr .= ” Bedrooms = ‘1’ || “;
$GetPass .= “Bedrooms[2]=1&”;
}
if ($value == “2”) {
$bdrmStr .= “Bedrooms = ‘2’ || “;
$GetPass .= “Bedrooms[3]=2&”;
}
if ($value == “3”) {
$bdrmStr .= “Bedrooms = ‘3’ || “;
$GetPass .= “Bedrooms[4]=3&”;
}
if ($value == “4”) {
$bdrmStr .= “Bedrooms = ‘4’ || “;
$GetPass .= “Bedrooms[5]=4&”;
}
if ($value == “5”) {
$bdrmStr .= “Bedrooms = ‘5’ || “;
$GetPass .= “Bedrooms[6]=5&”;
}
}
if ($bdrmStr) {
$bdrmStr = substr($bdrmStr,0,-4);
$Conditions .= ” AND ($bdrmStr)”;
}
}
$btrmStr = “”;
if ($_POST[‘Fl_Baths’]) {
foreach ($_POST[‘Fl_Baths’] as $key => $value) {
if ($value == “2”) {
$btrmStr .= ” Fl_Baths = ‘2’ || “;
$GetPass .= “Fl_Baths[1]=2&”;
}
if ($value == “3”) {
$btrmStr .= ” Fl_Baths = ‘3’ || “;
$GetPass .= “Fl_Baths[2]=3&”;
}
if ($value == “4”) {
$btrmStr .= ” Fl_Baths = ‘4’ || “;
$GetPass .= “Fl_Baths[3]=4&”;
}
}
if ($btrmStr) {
$btrmStr = substr($btrmStr,0,-4);
$Conditions .= ” AND ($btrmStr)”;
}
}
if ($Prop_Type) $Conditions .= ” AND Prop_Type = ‘$Prop_Type'”;
// Array for displaying bedrooms numerically in limited area
$bedDisplayArray[‘Studio’] = “Studio”;
$bedDisplayArray[‘One’] = “1”;
$bedDisplayArray[‘Two’] = “2”;
$bedDisplayArray[‘Three’] = “3”;
$bedDisplayArray[‘Four’] = “4”;
$bedDisplayArray[‘Five’] = “5”;
$bedDisplayArray[‘Six’] = “6”;
$bedDisplayArray[‘Seven’] = “7”;
$bedDisplayArray[‘Eight’] = “8”;
$bedDisplayArray[‘Nine’] = “9”;
$bedDisplayArray[‘Ten Or More’] = “10+”;
$Conditions = $FLConditions;
$db = mysqli_connect(“localhost”, “ramman”, “ippw4rm”, “mlsidx”);
//$Order_By = “Asking_Price DESC”; //For Testing
if (!$Order_By) $Order_By = “Asking_Price DESC”;
//$Limit = 12;
//if (!$Limit) $Limit = 12;
//if (!$Offset) $Offset = 0;
$sql = “SELECT
*
FROM Gunnison_listings_new
WHERE $Conditions
ORDER BY $Order_By
LIMIT $Offset, $Limit
“;
$result = mysqli_query($db,$sql);
//echo ““;
$error_text = mysqli_error($db); if ($error_text) echo ““;
$sqlCount = “SELECT COUNT(*)
FROM Gunnison_listings_new
WHERE $Conditions
LIMIT 50
“;
$resultCount = mysqli_query($db,$sqlCount);
//echo “$sqlCount”;
if ($myrowCount = mysqli_fetch_row($resultCount)) $numListings = $myrowCount[0];
if ($numListings > 500) $numListings = 500;
if ($_GET[‘lastLimit’]) {
$LimitToUse = $_GET[‘lastLimit’];
} else {
$LimitToUse = $Limit;
}
$numpages = (INT)($numListings / $LimitToUse);
if ($numListings % $LimitToUse) $numpages++;
$pageNow = $Offset/$LimitToUse +1;
$nextPage = $pageNow + 1;
$lastPage = $pageNow – 1;
if ($_POST) {
while(list($key,$value)=each($_POST)) {
if (($value) and ($key != “Details_search”) and ($key != “Area”) and ($key != “Ttl_Sqft”) and ($key != “Number_Acres”) and ($key != “Prop_Class_res”) and ($key != “Prop_Class_land”) and ($key != “Prop_Class_comm”) and ($key != “Prop_Class”) and ($key != “Prop_type”) and ($key != “Prop_Type_res”) and ($key != “Bedrooms”) and ($key != “Fl_Baths”) and ($key != “Limit”) and ($key != “lastLimit”)) {
$GetPass .= “$key=”.stripslashes(urlencode($value)).”&”;
}
}
}
if ($_GET) {
while(list($key,$value)=each($_GET)) {
if (($value) and ($key != “Offset”) and ($key != “Area”) and ($key != “Ttl_Sqft”) and ($key != “Number_Acres”) and ($key != “Prop_Class_res”) and ($key != “Prop_Class_land”) and ($key != “Prop_Class_comm”) and ($key != “Prop_Class”) and ($key != “Prop_type”) and ($key != “Prop_Type_res”) and ($key != “Bedrooms”) and ($key != “Fl_Baths”) and ($key != “Limit”) and ($key != “lastLimit”)) {
$GetPass .= “$key=”.urlencode($value).”&”;
}
}
}
for($i=1;$i<=$numpages;$i++) {
$offpass = ($i-1) * $LimitToUse;
if ($i == $pageNow) {
$navText .= "$i “;
} else {
// check for last page
if ($i == $numpages) {
$nextLimit = (500-$offpass);
$lastLimit = $Limit;
} else {
$nextLimit = $LimitToUse;
}
$navText .= “$i “;
}
}
// echo “
$navText
“;
$offpassPrev = $Offset – $Limit;
$offpassNext = $Offset + $Limit;
if ($Offset >= $Limit) {
$navDisplaya .= ““;
} else {
$navDisplaya .= ““;
}
$navDisplay .= “ “;
if (($Offset+$Limit) >= $numListings) {
$navDisplayb .= ““;
} else {
$navDisplayb .= ““;
}
// echo “
$navDisplay
“;
$displayCount = 0;
$colCnt = 1;
while ($myrow = mysqli_fetch_array($result)) {
$displayCount++;
// strip non-alpha numeric chars
$addressProcessed = str_replace(” “,”-“,preg_replace(‘/[^a-zA-Z0-9\s]/’, ”, $myrow[‘Address’]));
$cityProcessed = str_replace(” “,”-“,preg_replace(‘/[^a-zA-Z0-9\s]/’, ”, $myrow[‘City’]));
$stateProcessed = str_replace(” “,”-“,preg_replace(‘/[^a-zA-Z0-9\s]/’, ”, $myrow[‘State’]));
// set details page link
$detailsPgLnk = strtolower($addressProcessed.”-“.$cityProcessed.”-“.$stateProcessed.”-“.$myrow[‘Mls_Num’].”.php”);
// look in custom file for a virtual tour for this property
if ($propTourArr[$myrow[‘Mls_Num’]]) $myrow[‘virtual_tour’] = $propTourArr[$myrow[‘Mls_Num’]];
while(list($key,$value)=each($myrow)){
if ($value && $key != “Remarks” && $key != “virtual_tour” && $key != “virtualTour” && $key != “propertyPageURL” && $key != “propertyPageLinkText” && $value != “SLO”) {
$myrow[$key] = ucwords(strtolower($value));
}
}
$priceShow = number_format($myrow[‘Asking_Price’]);
$imageSourcePath = “http://cren.interactiveproperties.com/images/listings/cren”.$myrow[‘Mls_Num’].”.jpg”;
//——————————————————————————
// check for images
$imgCode = “”;
$imgCheck = “”;
if ($myrow[‘imageLocations’]) {
$imgBits = explode(“|”,$myrow[‘imageLocations’]);
for($i=0;$i
“;
$imgCheck = 1;
}
}
}
//——————————————————————————
$imageServerPath = $imageSourcePath;
if ($imgCheck) {
$imageBG = “#000000”; // Black background to images
} else {
$imageBG = “#FFFFFF”; // White background if no image
}
if ($colCnt == 1) {
$listings .= “Crested Butte Commercial Real Estate
“;
$colCnt++;
} else {
$listings .= “
“; } echo $listings; if ($numpages > “1”) { echo ”
“;
}
echo ”
“; } else { echo “
“;
$colCnt++;
}
if ($colCnt == 4) $colCnt = 1;
$listings .= “
“;
if ($displayCount % 3 == 0) {
$listings .= “
“;
}
} // END while ($myrow = mysql_fetch_array($result))
if ($numListings) {
echo ”
“;
if ($numpages > “1”) {
echo ”
“;
if ($imgCheck) {
$sizes = “”;
$sizes = getimagesize($imageServerPath);
if ($sizes[0] > $sizes[1]) { // landscape
// resize images in a 2 step process to ensure they are no larger than black background
if ($sizes[0] > “280”) {
$ratio = 280 / $sizes[0];
$sizes[0] = “280”;
$sizes[1] = $sizes[1] * $ratio;
}
if ($sizes[1] > “186”) {
$ratio = 186 / $sizes[1];
$sizes[1] = “186”;
$sizes[0] = $sizes[0] * $ratio;
}
} else { // portrait
// resize images in a 2 step process to ensure they are no larger than black background
if ($sizes[1] > “186”) {
$ratio = 186 / $sizes[1];
$sizes[1] = “186”;
$sizes[0] = $sizes[0] * $ratio;
}
if ($sizes[0] > “280”) {
$ratio = 280 / $sizes[0];
$sizes[0] = “280”;
$sizes[1] = $sizes[1] * $ratio;
}
}
$listings .= ““.$imgCode.”
“; } if ($myrow[‘Status’] == “Uc/contingent/call Lb” || $myrow[‘Status’] == “Pending”) { $thisStatus = “UNDER CONTRACT”; } else if ($myrow[‘Status’]) { $thisStatus = $myrow[‘Status’]; } else { $thisStatus = “Active”; } $listings .= “Status: $thisStatus
“; if ($myrow[‘Bedrooms’]) { $listings .= “$myrow[Bedrooms] BR”; } if ($myrow[‘Bedrooms’] && $myrow[‘Fl_Baths’]) { $listings .= ” | “; } if ($myrow[‘Fl_Baths’]) { $listings .= “$myrow[Fl_Baths] Bth”; } if (($myrow[‘Bedrooms’] || $myrow[‘Fl_Baths’]) && $myrow[‘Acres’]) { $listings .= ” | “; } if ($myrow[‘Acres’]) { $listings .= “$myrow[Acres] Acres”; } if (($myrow[‘Bedrooms’] || $myrow[‘Fl_Baths’] || $myrow[‘Acres’]) && $myrow[‘TotalSqFt’]) { $listings .= ” | “; } if ($myrow[‘TotalSqFt’]) { $listings .= “$myrow[TotalSqFt] Sq Ft”; } if ($myrow[‘Bedrooms’] || $myrow[‘Fl_Baths’] || $myrow[‘Acres’] || $myrow[‘TotalSqFt’]) { $listings .= “
“; } if ($myrow[‘Address’]) { $listings .= ““; if ($myrow[‘Address’]) $listings .= $myrow[‘Address’]; if ($myrow[‘Address_2’]) $listings .= “, “.$myrow[‘Address_2’]; $listings .= “
“; } if ($myrow[‘City’]) $listings .= $myrow[‘City’].” “; if ($myrow[‘State’]) $listings .= strtoupper($myrow[‘State’]).” “; if ($myrow[‘Zip’]) $listings .= $myrow[‘Zip’].” “; //$listings .= “
“; if ($priceShow) $listings .= ” | $”.$priceShow.”
“; //if ($myrow[‘Office’]) $listings .= “
Listing courtesy of
“.$myrow[‘Office’].”“; $listings .= “
“; } if ($myrow[‘Status’] == “Uc/contingent/call Lb” || $myrow[‘Status’] == “Pending”) { $thisStatus = “UNDER CONTRACT”; } else if ($myrow[‘Status’]) { $thisStatus = $myrow[‘Status’]; } else { $thisStatus = “Active”; } $listings .= “Status: $thisStatus
“; if ($myrow[‘Bedrooms’]) { $listings .= “$myrow[Bedrooms] BR”; } if ($myrow[‘Bedrooms’] && $myrow[‘Fl_Baths’]) { $listings .= ” | “; } if ($myrow[‘Fl_Baths’]) { $listings .= “$myrow[Fl_Baths] Bth”; } if (($myrow[‘Bedrooms’] || $myrow[‘Fl_Baths’]) && $myrow[‘Acres’]) { $listings .= ” | “; } if ($myrow[‘Acres’]) { $listings .= “$myrow[Acres] Acres”; } if (($myrow[‘Bedrooms’] || $myrow[‘Fl_Baths’] || $myrow[‘Acres’]) && $myrow[‘TotalSqFt’]) { $listings .= ” | “; } if ($myrow[‘TotalSqFt’]) { $listings .= “$myrow[TotalSqFt] Sq Ft”; } if ($myrow[‘Bedrooms’] || $myrow[‘Fl_Baths’] || $myrow[‘Acres’] || $myrow[‘TotalSqFt’]) { $listings .= “
“; } if ($myrow[‘Address’]) { $listings .= ““; if ($myrow[‘Address’]) $listings .= $myrow[‘Address’]; if ($myrow[‘Address_2’]) $listings .= “, “.$myrow[‘Address_2’]; $listings .= “
“; } if ($myrow[‘City’]) $listings .= $myrow[‘City’].” “; if ($myrow[‘State’]) $listings .= strtoupper($myrow[‘State’]).” “; if ($myrow[‘Zip’]) $listings .= $myrow[‘Zip’].” “; //$listings .= “
“; if ($priceShow) $listings .= ” | $”.$priceShow.”
“; //if ($myrow[‘Office’]) $listings .= “
Listing courtesy of
“.$myrow[‘Office’].”“; $listings .= “
“.$navText.” |
“; } echo $listings; if ($numpages > “1”) { echo ”
“.$navText.” |
“; } else { echo “
There are currently no properties available.
Search For Properties
The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange (IDX) program of Colorado Real Estate Network, Inc. (CREN), © Copyright $year. All rights reserved. All data deemed reliable but not guaranteed and should be independently verified. This database record is provided subject to "limited license" rights. Duplication or reproduction is prohibited.
Real Estate listings held by companies other than contain that company’s name. Data last updated on: |
Powered by RAM Designs