Haunted Houses in the USA and Canada

Each Haunted Attraction is listed by country, state (or province) and city. For information on how to list a Haunted House here please go to the New House Submission form. If you see anything that needs updated, information fixed, please do so on the error submission form or contact the Owners/Operators and ask them to update their information.

For all things paranormal, check out SpookyStuff.co.uk

Eastern USA
[Alabama] [Connecticut] [Delaware] [Florida] [Georgia] [Kentucky] [Maine] [Maryland] [Massachusetts] [Mississippi] [New Hampshire] [New Jersey] [New York] [North Carolina] [Ohio] [Pennsylvania] [Rhode Island] [South Carolina] [Tennessee] [Vermont] [Virginia] [West Virginia]

Central USA
[Arkansas] [Illinois] [Indiana] [Iowa] [Kansas] [Louisiana] [Michigan] [Minnesota] [Missouri] [Nebraska] [North Dakota] [Oklahoma] [Texas] [Wisconsin]

Western USA and CANADA
[Arizona] [California] [Colorado] [Hawaii] [Idaho] [Montana] [Nevada] [Oregon] [Utah] [Washington]
[Alberta] [British Columbia] [New Brunswick] [New Foundland] [Ontario]

Are you or any of your friends are interested in special effects, life-casting or makeup? If so, please be sure to send them to Our Home Page

*/ ?>

"; //echo "

Displaying results Eastern | Central | Western | Canada

"; if($GetAllHHCOUNT <=0) { echo "No Haunted Houses found."; } else { while ($row = mysql_fetch_array($GetAllHHResult, MYSQL_BOTH)) { $StateProvince = $row["StateProvince"]; echo "

$StateProvince

"; /***** echo" "; echo ""; } //end of while ($row = mysql_fetch_array($GetAllHHResult, MYSQL_BOTH)) //echo "

"; ****/ $GetAllHHCity = "SELECT distinct(City) FROM FX_HauntedHouses WHERE StateProvince = '$StateProvince' AND Display = 'Y' ORDER BY City ASC"; $GetAllHHCityResult = mysql_query($GetAllHHCity) or die ("Couldn't execute query because: " . mysql_error()); while ($row = mysql_fetch_array($GetAllHHCityResult, MYSQL_BOTH)) { $City = $row["City"]; echo"

$City -
"; $GetAllHHCityDetails = "SELECT *, DATE_FORMAT(LastUpdate, '%Y-%m-%d') as DateFormatted FROM FX_HauntedHouses WHERE StateProvince = '$StateProvince' AND City = '$City' AND Display = 'Y' ORDER BY StateProvince ASC, City ASC, NameOfAttraction ASC"; $GetAllHHCityDetailsResult = mysql_query($GetAllHHCityDetails) or die ("Couldn't execute query because: " . mysql_error()); while ($row = mysql_fetch_array($GetAllHHCityDetailsResult, MYSQL_BOTH)) { $PrimaryID = $row["PrimaryID"]; $NameOfAttraction = $row["NameOfAttraction"]; $Slogan = $row["Slogan"]; $Comments = $row["Comments"]; $URL = $row["URL"]; $Address = $row["Address"]; $City = $row["City"]; $StateProvince = $row["StateProvince"]; $Country = $row["Country"]; $SubmitterName = $row["SubmitterName"]; $SubmitterEmail = $row["SubmitterEmail"]; $SubmitterAddress = $row["SubmitterAddress"]; $SubmitterPhone = $row["SubmitterPhone"]; $SubmitterHouseSizeFeet = $row["SubmitterHouseSizeFeet"]; $SubmitterHouseSizeAcres = $row["SubmitterHouseSizeAcres"]; $FormOfContact = $row["FormOfContact"]; $DatePosted = $row["DatePosted"]; $DateFormatted = $row["DateFormatted"]; $LastUpdate = $row["LastUpdate"]; $Display = $row["Display"]; echo ""; if($URL <> '' ) { $NameOfAttraction = "$NameOfAttraction"; } if($Address <> '' ) { $Address = "$Address
"; } if($Slogan <> '' ) { $Slogan = "$Slogan
"; } if($Comments <> '' ) { $Comments = "$Comments
"; } echo "

$NameOfAttraction
$Address $Slogan $Comments Posted: $DateFormatted FX ID: $PrimaryID

"; } //end of while ($row = mysql_fetch_array($GetAllHHCityDetailsResult, MYSQL_BOTH)) echo "

"; } //end of while ($row = mysql_fetch_array($GetAllHHCityResult, MYSQL_BOTH)) //echo "

"; //echo "

"; } //end of else ?>