if (($address!="")&&($address!=null)) {
echo("ADDRESS: | $address | ");
if (($address2!="")&&($address2!=null)) {
echo(" | $address2 | ");
}
echo(" | ");
}
if (($city!="")&&($city!=null)) {
echo("CITY: | $city | | ");
}
if (($state!="")&&($state!=null)) {
echo("STATE: | $state | | ");
}
if (($zipcode!="")&&($zipcode!=null)) {
echo("ZIP: | $zipcode | | ");
}
if (($t_industrial=="yes")||($t_office=="yes")||($t_retail=="yes")||($t_land=="yes")||($t_investment=="yes")||($t_other=="yes")) {
?>
TYPE: |
if ($t_industrial=="yes") {
echo("Industrial ");
}
if ($t_office=="yes") {
echo("Office ");
}
if ($t_retail=="yes") {
echo("Retail ");
}
if ($t_land=="yes") {
echo("Land ");
}
if ($t_investment=="yes") {
echo("Investment ");
}
if ($t_other=="yes") {
echo("Other");
}
?>
| |
}
if (($cs_forlease=="yes")||($cs_forsale=="yes")||($cs_sold=="yes")||($cs_leased=="yes")) {
?>
STATUS: |
if ($cs_forlease=="yes") {
echo("For Lease ");
}
if ($cs_forsale=="yes") {
echo("For Sale ");
}
if ($cs_sold=="yes") {
echo(" ");
}
if ($cs_leased=="yes") {
echo("Leased");
}
?>
| |
}
?>
|
if (($buildsqft!="")&&($buildsqft!=null)) {
echo("BUILDING SQ FT: | $buildsqft | | ");
}
if (($leasesqft!="")&&($leasesqft!=null)) {
echo("LEASABLE SQ FT: | $leasesqft | | ");
}
if (($landarea!="")&&($landarea!=null)) {
echo("LAND AREA: | $landarea | | ");
}
if (($saleprice!="")&&($saleprice!=null)) {
echo("SALE PRICE: | $saleprice | | ");
}
if (($leaserate!="")&&($leaserate!=null)) {
echo("LEASE RATE: | $leaserate");
if (($leaserateper!="")&&($leaserateper!=null)) {
echo(" per $leaserateper");
}
echo(" | | ");
}
if (($zoning!="")&&($zoning!=null)) {
echo("ZONING: | $zoning | | ");
}
if (($document!="")&&($document!=null)) {
echo(" | ");
}
?>
|
PROPERTY DESCRIPTION:
echo($shortdesc);
?>
if (($zoning!="")&&($zoning!=null)) {
?>
OTHER INFORMATION:
echo($detaileddesc);
?>
}
if (($loopnet!="")&&($loopnet!=null)) {
echo("VIEW LOOPNET INFORMATION ");
}
?>
echo("THIS LISTING HAS BEEN VIEWED $views TIMES");
?>

$sql3 = "SELECT * FROM `listingassoc` WHERE 1 AND `listingid` = $id";
$result3 = mysql_query($sql3);
if($result3 != null) {
while ($item3 = mysql_fetch_array($result3)) {
$id2 = $item3["id"];
$associd = $item3["associd"];
if ($associd!=0) {
$sql2 = "SELECT * FROM `associate` WHERE 1 AND `id` = $associd";
$result2 = mysql_query($sql2);
if($result2 != null) {
$item2 = mysql_fetch_array($result2);
$idassoc[] = $item2["id"];
$fname[] = $item2["fname"];
$lname[] = $item2["lname"];
$phone[] = $item2["phone"];
$mobile[] = $item2["mobile"];
$fax[] = $item2["fax"];
$email[] = $item2["email"];
$website[] = $item2["website"];
}
}
}
}
?>
CONTACT:
if (($fname[0]!="")&&($fname[0]!=null)) {
echo("$fname[0] $lname[0]");
}
if (($fname[1]!="")&&($fname[1]!=null)) {
echo(", $fname[1] $lname[1]");
}
if (($fname[2]!="")&&($fname[2]!=null)) {
echo(", $fname[2] $lname[2]");
}
?>
|
if (($phone[0]!="")&&($phone[0]!=null)) {
echo(" PHONE: $phone[0] ");
}
if (($mobile[0]!="")&&($mobile[0]!=null)) {
echo(" MOBILE: $mobile[0] ");
}
if (($fax[0]!="")&&($fax[0]!=null)) {
echo(" FAX: $fax[0] ");
}
if (($email[0]!="")&&($email[0]!=null)) {
echo(" EMAIL: $email[0] ");
}
if (($website[0]!="")&&($website[0]!=null)) {
echo(" WEB: $website[0] ");
}else{
echo(" WEB: Click Here ");
}
?>
|
|
|