*/ ?>

Dealer Search Results

Fleetwood provides products globally but has chosen to limit the number of dealers listed online. Less than 5% of our Authorized Dealerships are listed in the following search results. You can be confident that the dealer you choose here is as elite as the Fleetwood product you are purchasing.

Before you select a dealer, we encourage you to review "Making the Right Choices" in our Homeowners section.


'". $zip1s ."' && sales_zip1 <> '". $zip1e ."',order_by-6,order_by) as order_by, alt_1, alt_city, alt_st, alt_zip, alt_5 FROM CUSTOMERS WHERE (sales_zip1 = '$zip1s' or sales_zip1 = '$zip1e' or sales_zip2 = '$zip1s' or sales_zip2 = '$zip1e' or sales_zip3 = '$zip1s' or sales_zip3 = '$zip1e' or sales_zip4 = '$zip1s' or sales_zip4 = '$zip1e' or sales_zip5 = '$zip1s' or sales_zip5 = '$zip1e') AND publish_alt not like '0' ORDER BY order_by DESC"; echo ""; //$query = "SELECT udf1, cust_name, addr_city, addr_st, phone, udf2, email_addr, status_descr, sales_person , ytd_2Year, sales_zip1, order_by FROM customers where (sales_zip1 = '$zip1s' or sales_zip1 = '$zip1e' or sales_zip2 = '$zip1s' or sales_zip2 = '$zip1e' or sales_zip3 = '$zip1s' or sales_zip3 = '$zip1e' or sales_zip4 = '$zip1s' or sales_zip4 = '$zip1e' or sales_zip5 = '$zip1s' or sales_zip5 = '$zip1e') and addr1 not like '%take%' and status_descr not like 'no%' and status_descr not like 'ina%' and status_descr not like 'fap%' and status_descr not like 'see%' and status_descr not like 'job%' and sales_person not like 'xx%' and mult not like '0.4' and udf1 not like 'no%' order by order_by desc"; $result = mysql_query($query); $num_results = mysql_num_rows($result); $numofrows = mysql_num_rows($result); $numofrows1 = mysql_num_rows($result); // echo "

Number records found: ".$num_results."

"; //echo $query; if ($numofrows1 == 0) { //echo "No Records found for your search criteria!"; } else { //while($row = mysql_fetch_array($result)) echo "\n"; echo "\n"; for($i = 0; $i < $numofrows; $i++) { $row = mysql_fetch_array($result); //get a row from our result set $sales_zip = array(strtolower($row['sales_zip1']), strtolower($row['sales_zip2']), strtolower($row['sales_zip3']), strtolower($row['sales_zip4']), strtolower($row['sales_zip5'])); //print_r($sales_zip); $city_value = array(strtolower($row['alt_1']), strtolower($row['alt_city']), strtolower($row['alt_st']), strtolower($row['alt_zip']), strtolower($row['alt_5'])); //print_r($city_value); $city = NULL; for ($x=0; $x <= 4; $x++) { if ($sales_zip[$x] != NULL) { if (($sales_zip[$x] == $zip1s) || ($sales_zip[$x] == $zip1e)) { $alt_values=explode(";",$city_value[$x]); /* Within the alt_city fields we can have multiple values separated by a semicolon: alt_values: 0=alternate city, 1=alternate phone# */ if ($alt_values[0] == NULL) { //If the 'alt' field corresponding with our current 'sales_zip' is null, then use the addr_city field instead. //11-26-12 Instead of addr_city field, use new alt_1 field...kad $city = $city_value[0]; } else $city = $alt_values[0]; if (($city != NULL) && ($sales_zip[$x] != NULL)){ $email = $row['web_EMAIL_ADDR']; $tok_email = strtok ($email, ";"); $stripe++; if($stripe % 2) { //this means if there is a remainder echo "\n"; } else { //if there isn't a remainder we will do the else echo "\n"; } //print_r ($alt_values); //Check if we have an alternate phone number, else use the default one. //Always use new web_PHONE field...11-20-12 kad $phone = $row['web_PHONE']; //if ($alt_values[1] != NULL) { $phone = $alt_values[1]; } //else { $phone = $row['phone']; } /* 10-26-2010 EDN - Added code to display a link to a page displaying the dealer's showroom Requirements: - udf1 field in customers table is "Showroom" - Landing page must be located in /images/Dealer_Showrooms - Landing page must have .php extension - Landing page filename must begin with the dealer's dealer code and be delimited with a single underscore - Example: 3761_Baker_Windows_And_Doors.php */ $display = ""; $cust_code = $row['CUST_CODE']; if (strtolower($row['udf1']) == "showroom") { $pathname = $_SERVER['DOCUMENT_ROOT'] . "/menu_bar/Dealer_Search/Dealer_Showrooms"; if ($handle = opendir($pathname)) { while (false !== ($file = readdir($handle))) { $prefix = explode("_",$file); $extension = explode(".", $file); $count = count($extension) - 1; $extension = strtolower($extension[$count]); if (($prefix[0] == $cust_code) && ($extension == "php")){ $display = "Showroom"; } if (!$display) { $display = $row['udf1']; } } closedir($handle); } } else { $display = $row['udf1']; } echo ""; /*if (($row['publish_website'] != 0) && ($row['publish_website'] != NULL) && ($row['web_site'] != NULL)) { echo "\n \n"; } else { echo "\n"; }*/ }//End: if ($city != NULL) }//End: if (($sales_zip[$x] == $zip1s) || ($sales_zip[$x] == $zip1e)) }//End: if (($zip . $x) != NULL) }//End: for ($x=1; $x <= 5; $x++) }//End: for($i = 0; $i < $numofrows; $i++) echo "
DisplayCompanyCityPhoneE-MailProvisions
".$display."
".$row['cust_name']."
".strtoupper($city)."
".$phone."
$tok_email
".$row['udf2']."
Visit Website
\n"; } if ($numofrows1 == 0) { echo "

There are currently no dealers listed for this area.
Please contact Fleetwood sales at 1(800) 736-7363 or sales@fleetwoodusa.com for assistance.

"; $nodealers = 1; } if (($row['addr_st'] == 'CA') || ($row['addr_st'] == 'AZ') || ($row['addr_st'] == 'HI')) { } if ($nodealers != 1) { print '
'; print '

If you are unable to locate a dealer near you, or if your experience with the dealer does not meet your expectations, please contact the Sales Manager directly: sales@fleetwoodusa.com'; } ?>