Cape Style Homes

"; $result = mysql_query("SELECT * FROM home_styles WHERE houseType='community'"); $counter = 1; while($row = mysql_fetch_array($result)){ if($counter == 1){echo "\n";} echo "\n"; echo "

\n"; if($row["special_pricing"]) { echo "

\n"; } elseif($row["virtual_tour"]) { echo "

\n"; } echo "\n $\"Thumbnail\"$ " ."

\n" ."\n

".$row["title"]."

" ."\n

see details" ."\n
download specs
"; if($row["virtual_tour"]) { echo "virtual tour"; } echo "

"; echo "\n"; if($counter == 3){ echo "\n"; $counter = 1; } else { $counter++; } } if(mysql_num_rows($result) == 0){ echo "\n" . "There no Community Models available at this time.\n" . "\n"; } echo "\n"; ?>

Ranch Homes

"; $resultset = mysql_query("SELECT * FROM home_styles WHERE houseType='ranch'"); $counter2 = 1; while($data = mysql_fetch_array($resultset)){ if($counter2 == 1){echo "\n";} echo "\n"; echo "

\n"; if($data["special_pricing"]) { echo "

\n"; } elseif($data["virtual_tour"]) { echo "

\n"; } echo "\n $\"Thumbnail\"$ " ."

\n" ."\n

".$data["title"]."

" ."\n

see details" ."\n
download specs
"; if($data["virtual_tour"]) { echo "virtual tour"; } echo "

\n"; echo "\n"; if($counter2 == 3){ echo "\n"; $counter2 = 1; } else { $counter2++; } } if(mysql_num_rows($resultset) == 0){ echo " There no Ranch Designs available at this time. "; } echo ""; ?>