#!/usr/bin/perl
require "config.idx";

print "Content-type: text/html\n\n";

$long = $ENV{'QUERY_STRING'};

if ($long) {
	@pairs=split(/&/,$long);
	foreach $item(@pairs) {
		($name,$content)=split (/=/,$item,2);
		$content=~tr/+/ /;
		$content=~ s/%(..)/pack("c",hex($1))/ge;
		if ($INPUT{$name}) { $INPUT{$name} = $INPUT{$name}.",".$content; }
		else { $INPUT{$name} = $content; }
	}
}
else {
	read(STDIN, $buffer, $ENV{'CONTENT_LENGTH'});
	@pairs = split(/&/, $buffer);
	foreach $pair (@pairs) {
		($name, $value) = split(/=/, $pair);
		$value =~ tr/+/ /;
		$value =~ s/%([a-fA-F0-9][a-fA-F0-9])/pack("C", hex($1))/eg;
		if ($INPUT{$name}) { $INPUT{$name} = $INPUT{$name}.",".$value; }
		else { $INPUT{$name} = $value; }
	}
}

if ($INPUT{action} eq "choose") { &choose; }
else { &main; }


sub main {


use DBI;
my $dsn = "DBI:mysql:database=$d_name;host=localhost";
my $dbh = DBI->connect($dsn, $d_username, $d_pass, {RaiseError => 1}) || die $DBI::errstr;
my $pasth = $dbh->prepare("select * from listings_res3 where mlsnum = '$INPUT{mlsnumber}'");
$pasth->execute;

while ($data_ref = $pasth->fetchrow_hashref()) {
%db = %$data_ref;


$db{Remarks} =~ s/\CHR1/'/gi;
$db{Remarks} =~ s/\CHR2/"/gi;

$db{TotalSqFt} = &commas($db{TotalSqFt});


($LivingRoomLength,$LivingRoomWidth) = split(/X/i,$db{LivingRoomSize});
($GreatRoomLength,$GreatRoomWidth) = split(/X/i,$db{GreatRoomSize});
($FamilyRoomLength,$FamilyRoomWidth) = split(/X/i,$db{FamilyRoomSize});
($KitchenLength,$KitchenWidth) = split(/X/i,$db{KitchenSize});
($DiningRoomLength,$DiningRoomWidth) = split(/X/i,$db{DiningRoomSize});
($DenStudyLength,$DenStudyWidth) = split(/X/i,$db{DenStudySize});
($Bedroom1Length,$Bedroom1Width) = split(/X/i,$db{Bedroom1Size});
($Bedroom2Length,$Bedroom2Width) = split(/X/i,$db{Bedroom2Size});
($Bedroom3Length,$Bedroom3Width) = split(/X/i,$db{Bedroom3Size});
($Bedroom4Length,$Bedroom4Width) = split(/X/i,$db{Bedroom4Size});
($Bedroom5Length,$Bedroom5Width) = split(/X/i,$db{Bedroom5Size});
($Bathroom1Length,$Bathroom1Width) = split(/X/i,$db{Bathroom1Size});
($Bathroom2Length,$Bathroom2Width) = split(/X/i,$db{Bathroom2Size});
($UtilityRoomLength,$UtilityRoomWidth) = split(/X/i,$db{UtilityRoomSize});
($OtherRoom1Length,$OtherRoom1Width) = split(/X/i,$db{OtherRoom1Size});
($OtherRoom2Length,$OtherRoom2Width) = split(/X/i,$db{OtherRoom2Size});
($OtherRoom3Length,$OtherRoom3Width) = split(/X/i,$db{OtherRoom3Size});
($Outbuilding1Length,$Outbuilding1Width) = split(/X/i,$db{Outbuilding1Size});



unless ($db{GreatRoomLevel}) {
$db{GreatRoomLevel} = "-";
}
unless ($db{FamilyRoomLevel}) {
$db{FamilyRoomLevel} = "-";
}
unless ($db{KitchenLevel}) {
$db{KitchenLevel} = "-";
}
unless ($db{DiningRoomLevel}) {
$db{DiningRoomLevel} = "-";
}
unless ($db{DenStudyLevel}) {
$db{DenStudyLevel} = "-";
}
unless ($db{Bedroom1Level}) {
$db{Bedroom1Level} = "-";
}
unless ($db{Bedroom2Level}) {
$db{Bedroom2Level} = "-";
}
unless ($db{Bedroom3Level}) {
$db{Bedroom3Level} = "-";
}
unless ($db{Bedroom4Level}) {
$db{Bedroom4Level} = "-";
}
unless ($db{Bedroom5Level}) {
$db{Bedroom5Level} = "-";
}
unless ($db{Bathroom1Level}) {
$db{Bathroom1Level} = "-";
}
unless ($db{Bathroom2Level}) {
$db{Bathroom2Level} = "-";
}
unless ($db{OtherRoom1Level}) {
$db{OtherRoom1Level} = "-";
}
unless ($db{OtherRoom2Level}) {
$db{OtherRoom2Level} = "-";
}
unless ($db{UtilityRoomLevel}) {
$db{UtilityRoomLevel} = "-";
}

unless ($db{LivingRoomLevel}) {
$db{LivingRoomLevel} = "-";
}



unless ($LivingRoomLength) {
$LivingRoomLength = "-";
}
unless ($LivingRoomWidth) {
$LivingRoomWidth = "-";
}
unless ($GreatRoomLength) {
$GreatRoomLength = "-";
}
unless ($GreatRoomWidth) {
$GreatRoomWidth = "-";
}
unless ($FamilyRoomLength) {
$FamilyRoomLength = "-";
}
unless ($FamilyRoomWidth) {
$FamilyRoomWidth = "-";
}
unless ($KitchenLength) {
$KitchenLength = "-";
}
unless ($KitchenWidth) {
$KitchenWidth = "-";
}
unless ($DiningRoomLength) {
$DiningRoomLength = "-";
}
unless ($DiningRoomWidth) {
$DiningRoomWidth = "-";
}
unless ($DenStudyLength) {
$DenStudyLength = "-";
}
unless ($DenStudyWidth) {
$DenStudyWidth = "-";
}
unless ($Bedroom1Length) {
$Bedroom1Length = "-";
}
unless ($Bedroom1Width) {
$Bedroom1Width = "-";
}
unless ($Bedroom2Length) {
$Bedroom2Length = "-";
}
unless ($Bedroom2Width) {
$Bedroom2Width = "-";
}
unless ($Bedroom3Length) {
$Bedroom3Length = "-";
}
unless ($Bedroom3Width) {
$Bedroom3Width = "-";
}
unless ($Bedroom4Length) {
$Bedroom4Length = "-";
}
unless ($Bedroom4Width) {
$Bedroom4Width = "-";
}
unless ($Bedroom5Length) {
$Bedroom5Length = "-";
}
unless ($Bedroom5Width) {
$Bedroom5Width = "-";
}
unless ($Bathroom1Length) {
$Bathroom1Length = "-";
}
unless ($Bathroom1Width) {
$Bathroom1Width = "-";
}
unless ($Bathroom2Length) {
$Bathroom2Length = "-";
}
unless ($Bathroom2Width) {
$Bathroom2Width = "-";
}
unless ($OtherRoom1Length) {
$OtherRoom1Length = "-";
}
unless ($OtherRoom1Width) {
$OtherRoom1Width = "-";
}
unless ($OtherRoom2Length) {
$OtherRoom2Length = "-";
}
unless ($OtherRoom2Width) {
$OtherRoom2Width = "-";
}
unless ($UtilityRoomLength) {
$UtilityRoomLength = "-";
}
unless ($UtilityRoomWidth) {
$UtilityRoomWidth = "-";
}


$LivingRoomLength =~ s/CHR1/\'/gi;


$LivingRoomWidth =~ s/CHR1/\'/gi;


$GreatRoomLength =~ s/CHR1/\'/gi;


$GreatRoomWidth =~ s/CHR1/\'/gi;


$FamilyRoomLength =~ s/CHR1/\'/gi;


$FamilyRoomWidth =~ s/CHR1/\'/gi;


$KitchenLength =~ s/CHR1/\'/gi;


$KitchenWidth =~ s/CHR1/\'/gi;


$DiningRoomLength =~ s/CHR1/\'/gi;


$DiningRoomWidth =~ s/CHR1/\'/gi;


$DenStudyLength =~ s/CHR1/\'/gi;


$DenStudyWidth =~ s/CHR1/\'/gi;


$Bedroom1Length =~ s/CHR1/\'/gi;


$Bedroom1Width =~ s/CHR1/\'/gi;


$Bedroom2Length =~ s/CHR1/\'/gi;


$Bedroom2Width =~ s/CHR1/\'/gi;


$Bedroom3Length =~ s/CHR1/\'/gi;


$Bedroom3Width =~ s/CHR1/\'/gi;


$Bedroom4Length =~ s/CHR1/\'/gi;


$Bedroom4Width =~ s/CHR1/\'/gi;


$Bedroom5Length =~ s/CHR1/\'/gi;


$Bedroom5Width =~ s/CHR1/\'/gi;


$Bathroom1Length =~ s/CHR1/\'/gi;


$Bathroom1Width =~ s/CHR1/\'/gi;


$Bathroom2Length =~ s/CHR1/\'/gi;


$Bathroom2Width =~ s/CHR1/\'/gi;


$OtherRoom1Length =~ s/CHR1/\'/gi;


$OtherRoom1Width =~ s/CHR1/\'/gi;


$OtherRoom2Length =~ s/CHR1/\'/gi;


$OtherRoom2Width =~ s/CHR1/\'/gi;


$UtilityRoomLength =~ s/CHR1/\'/gi;


$UtilityRoomWidth =~ s/CHR1/\'/gi;




$LivingRoomLength =~ s/CHR2/\"/gi;


$LivingRoomWidth =~ s/CHR2/\"/gi;


$GreatRoomLength =~ s/CHR2/\"/gi;


$GreatRoomWidth =~ s/CHR2/\"/gi;


$FamilyRoomLength =~ s/CHR2/\"/gi;


$FamilyRoomWidth =~ s/CHR2/\"/gi;


$KitchenLength =~ s/CHR2/\"/gi;


$KitchenWidth =~ s/CHR2/\"/gi;


$DiningRoomLength =~ s/CHR2/\"/gi;


$DiningRoomWidth =~ s/CHR2/\"/gi;


$DenStudyLength =~ s/CHR2/\"/gi;


$DenStudyWidth =~ s/CHR2/\"/gi;


$Bedroom1Length =~ s/CHR2/\"/gi;


$Bedroom1Width =~ s/CHR2/\"/gi;


$Bedroom2Length =~ s/CHR2/\"/gi;


$Bedroom2Width =~ s/CHR2/\"/gi;


$Bedroom3Length =~ s/CHR2/\"/gi;


$Bedroom3Width =~ s/CHR2/\"/gi;


$Bedroom4Length =~ s/CHR2/\"/gi;


$Bedroom4Width =~ s/CHR2/\"/gi;


$Bedroom5Length =~ s/CHR2/\"/gi;


$Bedroom5Width =~ s/CHR2/\"/gi;


$Bathroom1Length =~ s/CHR2/\"/gi;


$Bathroom1Width =~ s/CHR2/\"/gi;


$Bathroom2Length =~ s/CHR2/\"/gi;


$Bathroom2Width =~ s/CHR2/\"/gi;


$OtherRoom1Length =~ s/CHR2/\"/gi;


$OtherRoom1Width =~ s/CHR2/\"/gi;


$OtherRoom2Length =~ s/CHR2/\"/gi;


$OtherRoom2Width =~ s/CHR2/\"/gi;


$UtilityRoomLength =~ s/CHR2/\"/gi;


$UtilityRoomWidth =~ s/CHR2/\"/gi;

@thefeatures = split(/\|/,$db{UsesFeaturesDataToChoose});


$startcount = "0";
foreach $one (@thefeatures) {

$yasth = $dbh->prepare("select featurename,categoryname from features where codenum = ?");
$yasth->execute($one);

while (($featurename,$categoryname) = $yasth->fetchrow_array()) {

$categoryname = lc($categoryname);
$featurename = lc($featurename);

$realname =~ s/CHR1/\'/gi;
$realname =~ s/CHR2/\"/gi;
$categoryname =~ s/CHR1/\'/gi;
$categoryname =~ s/CHR2/\"/gi;


$showfeaturestable .= "<td nowrap><img src=images/dot.gif>$categoryname <b>$featurename</b></td>";

if ($startcount eq "2") {
$showfeaturestable .= "</tr><tr>";
$startcount = "0";
}
else {
$startcount++;
}

}
}

if ($db{Garage}) {
$fGarage = "<img src=images/dot.gif>Garage <b>$db{Garage}</b><img src=images/line_spacer.gif height=1 width=1><br>";
}
else {
}



if ($db{YearBuilt}) {
$fYearBuilt = "<img src=images/dot.gif>Year Built <b>$db{YearBuilt}</b><br>";
}
else {
}

if ($db{OutbuildingType}) {
$fOutbuildingType = "<img src=images/dot.gif>Outbuilding <b>$db{OutbuildingType}</b><img src=images/line_spacer.gif height=1 width=1><br>";
}
else {
}


$showpicture = &image_format("full","$db{MLSNUM}");

$printoffice = "Listing Office: $db{ListingOffice1Name}; Listing Agent: $db{AgentName}";

if ($db{Remarks} eq "") {
$printRemarks = qq~
<font face="Arial, Helvetica, sans-serif"><font size="3"><b>Financing Information</b></font></font><br>
<img src="images/line_spacer.gif" height="3" width="1"><br>
<img src="images/black_fill.gif" height="1" width="320"><br>
<img src="images/line_spacer.gif" height="1" width="11">
<font size="3"><i>Call Eagle Financial <img src="images/efs_small.gif"> Now!</i></font><br><br>
~;
}
else {
$printRemarks = qq~
<font face="Arial, Helvetica, sans-serif"><font size="3"><b>Listing Remarks</b></font></font><br>
<img src="images/line_spacer.gif" height="3" width="1"><br>
<img src="images/black_fill.gif" height="1" width="320"><br>
<img src="images/line_spacer.gif" height="1" width="11">
$db{Remarks}<br><br>
~;
}




print qq~

<html>
<head>
<title>Eagle  MLS #$db{MLSNUM} Flyer</title>
<link rel="stylesheet" TYPE="text/css" href="includes/style.css">
</head>
<body bgcolor="white" leftMargin="0" topMargin="0" marginwidth="0" marginheight="0">
	<table border="0" cellpadding="0" cellspacing="0" widht="665">
		<tr>
			<td valign="top" width="665">

				<table border="0" cellpadding="0" cellspacing="0" width="665">
					<tr>
						<td valign="top" width="382">
							<img src="images/quickflyer.gif" width="382"><br>
						</td>
~;
if ($db{ListingOffice1ID} eq "48") {
						my $dsn = "DBI:mysql:database=$d_name;host=localhost";
						my $dbh = DBI->connect($dsn, $d_username, $d_pass, {RaiseError => 1}) || die $DBI::errstr;
						my $iasth = $dbh->prepare("select agentid,mlsid,firstname,lastname,image,title,phone2name,phone2number from agents where display = '1' AND mlsid = '$db{AgentID}' order by lastname desc LIMIT 0,1");
						$iasth->execute;

						while (($agentid,$mlsid,$firstname,$lastname,$image,$title,$phone2name,$phone2number) = $iasth->fetchrow_array()) {
						print qq~
			 			<td valign="top" width="283">
						<table border="0" cellpadding="3" cellspacing="0" width="100%">
						<tr>
						<td valign="middle" align="right">
							<br>
							$firstname $lastname<br>
							<b>Eagle Real Estate, Inc.</b><br>
							4020 N. Rosewood Ave.<br>
							Muncie, Indiana 47304<br>
							(765) 741-9111 Office<br>
							$phone2number $phone2name<br>
							<font size="2" color="navy"><i><b>We can sell your home!</i></b></font><br>
						</td>
						<td valign="middle">
						<br>
						<img src="images/agentpics/$image" width="60" height="83"><br>
						</td>
						</tr>
						</table>
~;
}
}
else {
print qq~
<td valign="middle" width="283">
<center>
You may be represented by Eagle Real Estate, Inc. when purchasing this property<br><b>Experience the buyer agency difference!</b><br><font size="2"><b>Call (765) 741-9111 for info</b></font><br>
</center>
~;
}
print qq~						
						</td>
					</tr>
					<tr>
						<td valign="top" colspan="2"><img src="images/quickflyer_2.gif"><br></td>
					</tr>
				</table>
				<table border="0" cellpadding="0" cellspacing="0" width="665">
					<tr>
						<td width="341" valign="top">
								<table border="0" cellpadding="0" cellspacing="0" width="100%">
									<tr>
										<td valign="top" width="70%">
											<font size="3" face="Arial" color="navy"><b><i>$db{AddressNumber} $db{AddressDirection} $db{AddressStreet}</i></b></font><br>
										</td>
										<td valign="top" width="30%">
											<font size="3" face="Arial" color="navy"><b><i>$ShowCity{$db{City}}</i></b></font><br>
										</td>
									</tr>
								</table>
							<img src="images/line_spacer.gif" height="3" width="1"><br>
							<img src="$showpicture" name="picture" width="368" height="272"><br>
						</td>
						<td width="324" valign="top">
							<table border="0" cellpadding="4" cellspacing="0" width="100%">
								<tr>
									<td valign="top">
										<br><br>
										$printRemarks
									</td>
								</tr>
							</table>
						</td>
					</tr>
				</table>
				<br>
				<table border="0" cellpadding="0" cellspacing="0" width="665">
					<tr>
						<td valign="top" width="665">
							<font face="Arial, Helvetica, sans-serif"><font size="3"><b>Property Details</b></font></font><br>
							<img src="images/line_spacer.gif" height="3" width="1"><br>
							<img src="images/black_fill.gif" height="2" width="665"><br>
							<img src="images/line_spacer.gif" height="2" width="1"><br>
								<table border="0" cellpadding="0" cellspacing="0" width="100%">
									<tr>
										<td valign="top" width="33%">
				<img src="images/dot.gif">Total Rooms <b>$db{Rooms}</b><br><img src="images/line_spacer.gif" height="1" width="1"><br>
				<img src="images/dot.gif">Bedrooms <b>$db{Bedrooms}</b><br><img src="images/line_spacer.gif" height="1" width="1"><br>
				<img src="images/dot.gif">Full Bathrooms <b>$db{FullBaths}</b><br><img src="images/line_spacer.gif" height="1" width="1"><br>
				<img src="images/dot.gif">Half Bathrooms <b>$db{HalfBaths}</b><br><img src="images/line_spacer.gif" height="1" width="1"><br>
				$fGarage
				$fOutbuildingType
										</td>
										<td valign="top" width="33%">
<img src="images/dot.gif">Township <b>$db{Township}</b><br><img src="images/line_spacer.gif" height="1" width="1"><br>
<img src="images/dot.gif">Area <b>$db{Area}</b><br><img src="images/line_spacer.gif" height="1" width="1"><br>
<img src="images/dot.gif">Subdivision <b>$db{Subdivision}</b><br><img src="images/line_spacer.gif" height="1" width="1"><br>
<img src="images/dot.gif">Acres <b>$db{Acres}</b><br><img src="images/line_spacer.gif" height="1" width="1"><br>
<img src="images/dot.gif">Year Built <b>$db{YearBuilt}</b><br><img src="images/line_spacer.gif" height="1" width="1"><br>
<img src="images/dot.gif">Square Feet <b>$db{TotalSqFt}</b><br><img src="images/line_spacer.gif" height="1" width="1"><br>
										</td>
										<td valign="top" width="34%">
<img src="images/dot.gif">Elem. School <b>$db{ElementarySchool}</b><br><img src="images/line_spacer.gif" height="1" width="1"><br>
<img src="images/dot.gif">Middle School <b>$db{MiddleSchool}</b><br><img src="images/line_spacer.gif" height="1" width="1"><br>
<img src="images/dot.gif">High School <b>$db{HighSchool}</b><br><img src=images/line_spacer.gif height=1 width=1><br>
<img src="images/dot.gif">Est. Annual Taxes <b>$db{EstimatedAnnualTax}</b><img src="images/line_spacer.gif" height="1" width="1"><br>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td valign="top" width="15">
<img src="images/dot.gif">
</td>
<td valign="top" width="100%">Directions: <b>$db{Directions}</b><br></td>
</tr>
</table>
										</td>
									</tr>
								</table>
						</td>
					</tr>
				</table>
				<br>
				<table border="0" cellpadding="0" cellspacing="0" width="665">
					<tr>
						<td valign="top" width="665">
							<font face="Arial, Helvetica, sans-serif"><font size="3"><b>Property Features</b></font></font><br>
							<img src="images/line_spacer.gif" height="2" width="1"><br>
							<img src="images/black_fill.gif" height="2" width="665"><br>
							<img src="images/line_spacer.gif" height="2" width="1"><br>
								<table border="0" cellpadding="0" cellspacing="0" width="100%">
									<tr>
										$showfeaturestable
									</tr>
								</table>
						</td>
					</tr>
				</table>
				<br>
				<table border="0" cellpadding="0" cellspacing="0" width="665">
					<tr>
						<td valign="top" width="665">
							<font face="Arial, Helvetica, sans-serif"><font size="3"><b>Room Sizes</b></font></font><br>
							<img src="images/line_spacer.gif" height="2" width="1"><br>
							<img src="images/black_fill.gif" height="2" width="665"><br>
							<img src="images/line_spacer.gif" height="2" width="1"><br>
							    <table border="0" cellpadding="1" cellspacing="0" width="665">
					              <tr bgcolor="#999999"> 
					                <td valign="top"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><b>Room</b></font></td>
					                <td valign="top"><div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><b>Length</b></font></div></td>
					                <td valign="top">&nbsp;</td>
					                <td valign="top"><div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><b>Width</b></font></div></td>
					                <td valign="top"><div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><b>Level</b></font></div></td>
					                <td valign="top"><strong><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">Room</font></strong></td>
					                <td valign="top"><div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><b>Length</b></font></div></td>
					                <td valign="top">&nbsp;</td>
					                <td valign="top"><div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><b>Width</b></font></div></td>
					                <td valign="top"><div align="center"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><b>Level</b></font></div></td>
					              </tr>
					              <tr> 
					                <td valign="top"><b>Bedroom 1</b></td>
					                <td valign="top"><div align="center"><b>$Bedroom1Length</b></div></td>
					                <td valign="top"><div align="center"><b>x</b></div></td>
					                <td valign="top"><div align="center"><b>$Bedroom1Width</b></div></td>
					                <td valign="top"><div align="center"><b>$db{Bedroom1Level}</b></div></td>
					                <td valign="top"><b>Kitchen</b></td>
					                <td valign="top"><div align="center"><b>$KitchenLength</b></div></td>
					                <td valign="top"><div align="center"><b>x</b></div></td>
					                <td valign="top"><div align="center"><b>$KitchenWidth</b></div></td>
					                <td valign="top"><div align="center"><b>$db{KitchenLevel}</b></div></td>
					              </tr>
					              <tr bgcolor="#EAE7E7"> 
					                <td valign="top"><b>Bedroom 2</b></td>
					                <td valign="top"><div align="center"><b>$Bedroom2Length</b></div></td>
					                <td valign="top"><div align="center"><b>x</b></div></td>
					                <td valign="top"><div align="center"><b>$Bedroom2Width</b></div></td>
					                <td valign="top"><div align="center"><b>$db{Bedroom2Level}</b></div></td>
					                <td valign="top"><b>Dining Room</b></td>
					                <td valign="top"><div align="center"><b>$DiningRoomLength</b></div></td>
					                <td valign="top"><div align="center"><b>x</b></div></td>
					                <td valign="top"><div align="center"><b>$DiningRoomWidth</b></div></td>
					                <td valign="top"><div align="center"><b>$db{DiningRoomLevel}</b></div></td>
					              </tr>
					              <tr> 
					                <td valign="top"><b>Bedroom 3</b></td>
					                <td valign="top"><div align="center"><b>$Bedroom3Length</b></div></td>
					                <td valign="top"><div align="center"><b>x</b></div></td>
					                <td valign="top"><div align="center"><b>$Bedroom3Width</b></div></td>
					                <td valign="top"><div align="center"><b>$db{Bedroom3Level}</b></div></td>
					                <td valign="top"><b>Family Room</b></td>
					                <td valign="top"><div align="center"><b>$FamilyRoomLength</b></div></td>
					                <td valign="top"><div align="center"><b>x</b></div></td>
					                <td valign="top"><div align="center"><b>$FamilyRoomWidth</b></div></td>
					                <td valign="top"><div align="center"><b>$db{FamilyRoomLevel}</b></div></td>
					              </tr>
					              <tr bgcolor="#EAE7E7"> 
					                <td valign="top"><b>Bedroom 4</b></td>
					                <td valign="top"><div align="center"><b>$Bedroom4Length</b></div></td>
					                <td valign="top"><div align="center"><b>x</b></div></td>
					                <td valign="top"><div align="center"><b>$Bedroom4Width</b></div></td>
					                <td valign="top"><div align="center"><b>$db{Bedroom4Level}</b></div></td>
					                <td valign="top"><b>Den / Study</b></td>
					                <td valign="top"><div align="center"><b>$DenStudyLength</b></div></td>
					                <td valign="top"><div align="center"><b>x</b></div></td>
					                <td valign="top"><div align="center"><b>$DenStudyWidth</b></div></td>
					                <td valign="top"><div align="center"><b>$db{DenStudyLevel}</b></div></td>
					              </tr>
					              <tr> 
					                <td valign="top"><b>Bedroom 5</b></td>
					                <td valign="top"><div align="center"><b>$Bedroom5Length</b></div></td>
					                <td valign="top"><div align="center"><b>x</b></div></td>
					                <td valign="top"><div align="center"><b>$Bedroom5Width</b></div></td>
					                <td valign="top"><div align="center"><b>$db{Bedroom5Level}</b></div></td>
					                <td valign="top"><b>Other Room 1</b></td>
					                <td valign="top"><div align="center"><b>$OtherRoom1Length</b></div></td>
					                <td valign="top"><div align="center"><b>x</B></div></td>
					                <td valign="top"><div align="center"><b>$OtherRoom1Width</b></div></td>
					                <td valign="top"><div align="center"><b>$db{OtherRoom1Level}</b></div></td>
					              </tr>
				    	          <tr bgcolor="#EAE7E7"> 
				        	        <td valign="top"><b>Bathroom 1</b></td>
					                <td valign="top" colspan="4"><div align="center"><b>$Bathroom1Size</b></div></td>
					                <td valign="top"><b>Other Room 2</b></td>
					                <td valign="top"><div align="center"><b>$OtherRoom2Length</b></div></td>
					                <td valign="top"><div align="center"><b>x</b></div></td>
					                <td valign="top"><div align="center"><b>$OtherRoom2Width</b></div></td>
					                <td valign="top"><div align="center"><b>$db{OtherRoom2Level}</b></div></td>
					              </tr>
					              <tr> 
					                <td valign="top"><b>Bathroom 2</b></td>
					                <td valign="top" colspan="4"><div align="Center"><b>$Bathroom2Size</b></div></td>
							        <td valign="top"><b>Other Room 3</b></td>
					                <td valign="top"><div align="center"><b>$OtherRoom3Length</b></div></td>
					                <td valign="top"><div align="center"><b>x</b></div></td>
					                <td valign="top"><div align="center"><b>$OtherRoom3Width</b></div></td>
					                <td valign="top"><div align="center"><b>$db{OtherRoom3Level}</b></div></td>
					              </tr>
					              <tr bgcolor="#EAE7E7"> 
					                <td valign="top"><b>Living Room</b></td>
					                <td valign="top"><div align="center"><b>$LivingRoomLength</b></div></td>
					                <td valign="top"><div align="center"><b>x</b></div></td>
					                <td valign="top"><div align="center"><b>$LivingRoomWidth</b></div></td>
					                <td valign="top"><div align="center"><b>$db{LivingRoomLevel}</b></div></td>
					                <td valign="top"><b>Utility Room</b></td>
					                <td valign="top"><div align="center"><b>$UtilityRoomLength</b></div></td>
					                <td valign="top"><div align="center"><b>x</b></div></td>
					                <td valign="top"><div align="center"><b>$UtilityRoomWidth</b></div></td>
					                <td valign="top"><div align="center"><b>$db{UtilityRoomLevel}</b></div></td>
					              </tr>
					              <tr> 
					                <td valign="top"><b>Great Room</b></td>
					                <td valign="top"><div align="center"><b>$GreatRoomLength</b></div></td>
					                <td valign="top"><div align="center"><b>x</b></div></td>
					                <td valign="top"><div align="center"><b>$GreatRoomWidth</b></div></td>
					                <td valign="top"><div align="center"><b>$db{GreatRoomLevel}</b></div></td>
					                <td valign="top" colspan="5">&nbsp;</td>
					              </tr>
				            </table>
</td>
</tr>
</table>
<br>
$printoffice
<center>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top">
<img src="images/eho.gif"><br>
</td>
<td valign="middle">
<center>
<font size="2">This information is deemed reliable, but not guaranteed. All room sizes are approximate.</font><br>
</center> 
</td>
<td valign="top">
<img src="images/re.gif"><br>
</td>
</tr>
</table>

</center>
<br>
<br>

<script language="JavaScript" type="text/javascript">
<!--

var da = (document.all) ? 1 : 0;
var pr = (window.print) ? 1 : 0;
var mac = (navigator.userAgent.indexOf("Mac") != -1);

function printWin()
{
    if (pr) {
        // NS4+, IE5+
        window.print();
    } else if (!mac) {
        // IE3 and IE4 on PC
        VBprintWin();
    } else {
        // everything else
        handle_error();
    }
}

function handle_error()
{
    window.alert('Your browser does not support this print option. Press Control/Option + P to print.');
    return true;
}

// -->
</script>

<script language="VBSCript" type="text/vbscript">
<!--

sub window_onunload
    on error resume next
    ' Just tidy up when we leave to be sure we aren't
    ' keeping instances of the browser control in memory
    set WB = nothing
end sub

sub VBprintWin
    OLECMDID_PRINT = 6
    on error resume next

    ' IE4 object has a different command structure
    if da then
        call WB.ExecWB(OLECMDID_PRINT, 1)
    else
        call WB.IOleCommandTarget.Exec(OLECMDID_PRINT, 1, "", "")
    end if
end sub

' -->
</script>

<script language="JavaScript" type="text/javascript">
<!--
printWin();
// -->
</script>

</body>
</html>

~;
}
$dbh->disconnect;
}