0 ) { $agentInfo = mysql_fetch_array($result); $subdir = strtolower($agentInfo['firstName'].$agentInfo['lastName']); //header("Location: agent.php?agentID=".$agentInfo['agentID']); header("Location: http://www.century21today.com/agentIDX/".$subdir); } include("includes/dbConnection.php"); if( $_REQUEST['agentID'] != "" ) { $agentInfo = mysql_fetch_array(mysql_query("SELECT * FROM agents WHERE agentID = ".$_REQUEST['agentID'])); // check the MLS agent ID cookie for lead generation to make sure it exists if( !isset($_COOKIES['agentMLSID']) ) setcookie("agentMLSID", $agentInfo['mlsnAgentID'], time()+60*60*24*180 , "/"); } // get the school districts for the search dropdown $school_districts = array(); $schoolDistrictTables[0] = 'idxResidential'; $schoolDistrictTables[0] = 'idxCondo'; $schoolDistrictTables[0] = 'idxCommercial'; $schoolDistrictTables[0] = 'idxMultiFamily'; $schoolDistrictTables[0] = 'idxVacantLand'; foreach ($schoolDistrictTables as $qTableName) { $schoolDistrictsQuery = "SELECT DISTINCT School_District FROM ".$qTableName." WHERE School_District <> '' ORDER BY School_District"; $sd_result = mysql_query($schoolDistrictsQuery); while( $schoolDistrict = mysql_fetch_array($sd_result)) { $school_districts[] = $schoolDistrict['School_District']; } } ?>
Real Estate | CENTURY 21 Affiliated | Wisconsin, Illinois & Minnesota Homes for Sale
Search bank owned
listings
More
Search the entire
area MLS
More
See what's open this week
More
Financing at competitiverates
More
Property Type
Offered
>Residential
>Condos
>Multi-Family
>Commercial
>Vacant Land
>For Sale
>For Lease
Preferred City
Price Range
$area ) echo '
' . $area . '
'; ?>
Any'; for( $i = 500; $i <= 2400; $i += 2000 ) { echo "
$".number_format($i)."
"; } for( $i = 2500; $i <= 4900; $i += 2500 ) { echo "
$".number_format($i)."
"; } for( $i = 5000; $i <= 9900; $i += 5000 ) { echo "
$".number_format($i)."
"; } for( $i = 10000; $i <= 49000; $i += 40000 ) { echo "
$".number_format($i)."
"; } for( $i = 50000; $i <= 75000; $i += 25000 ) { echo "
$".number_format($i)."
"; } for( $i = 100000; $i <= 650000; $i += 50000 ) { echo "
$".number_format($i)."
"; } for( $i = 700000; $i <= 1200000; $i += 100000 ) { echo "
$".number_format($i)."
"; } for( $i = 1300000; $i <= 3000000; $i += 500000 ) { echo "
$".number_format($i)."
"; } ?>
to
Any'; for( $i = 2500; $i <= 4900; $i += 2500 ) { echo "
$".number_format($i)."
"; } for( $i = 5000; $i <= 9900; $i += 5000 ) { echo "
$".number_format($i)."
"; } for( $i = 10000; $i <= 40000; $i += 40000 ) { echo "
$".number_format($i)."
"; } for( $i = 50000; $i <= 75000; $i += 25000 ) { echo "
$".number_format($i)."
"; } for( $i = 100000; $i <= 650000; $i += 50000 ) { echo "
$".number_format($i)."
"; } for( $i = 700000; $i <= 1200000; $i += 100000 ) { echo "
$".number_format($i)."
"; } for( $i = 1300000; $i <= 4500000; $i += 500000 ) { echo "
$".number_format($i)."
"; } for( $i = 5000000; $i <= 30000000; $i += 2000000 ) { echo "
$".number_format($i)."
"; } ?>
School District
Preferences
Any'; foreach ($school_districts as $myschooldistrict) { echo '
'.$myschooldistrict.'
'; } ?>
Any
1+
2+
3+
4+
5+
Beds
Any
1+
2+
3+
4+
5+
Baths
Selling Tools
More
Buyer Tools
More
Find community and
school information
More
Great Career Opportunity
More
