Jump to content

PAGINATION

hybmg57

By hybmg57
in PHP Coding Help

 Share

Recommended Posts

hybmg57 Member

hybmg57

Posted
Posted

Hi,

 

I'm trying to get this "NEXT" and "PREVIOUS" button coming out at each end of the loop after page 15 and one before page 1.

 

Is there a way we can do this? I have tried several ways but cannot get this going. Any help would be much appreciated!

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" xmlns:ice="http://ns.adobe.com/incontextediting">
<head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Honolulu Hawaii Real Estate | Honolulu Area Residential Property Search</title>
<meta name="description" content="The most complete and comprehensive Honolulu Hawaii real estate search, including homes for sale, properties for sales, condos for sale, new home sales, land for sale in the MLS. Listings of beach real estate by realtors and real estate agents, island real estate, and luxury homes. Complete Hawaii relocation information, community and neighborhood information, real estate resource and library for Hawaii buyers and sellers." />
<meta name="keywords" content="home in honolulu hawaii, honolulu hawaii real estate for sale, homes for sale in honolulu hawaii, hawaii condos, hawaii realtors, hawaii land, hawaii real estate agent, hawaii real estate search, hawaii realty, hawaii condo, hawaii properties, hawaii listings, new homes in hawaii, hawaii mls, hawaii realtor, hawaii houses for sale, hawaii realestate, hawaii homes for sale estate, hawaii beach real estate, hawaii townhomes, hawaii home sales, hawaii townhouse, island real estate, hawaii estate listings, hawaii condos for sale, hawaii brokers real estate, hawaii luxury homes, hawaii listing real estate, hawaii sales real estate, hawaii broker real estate, hawaii home values, hawaii mls estate, hawaii area real estate, hawaii luxury real estate, hawaii homes for sale, buy hawaii real estate, find hawaii real estate, hawaii information real estate, hawaii luxury condos, honolulu real estate, hi real estate, condo real estate, hawaii oceanfront real estate, hawaii condos real estate, oahu real estate, real estate in hawaii, hawaii realty, oahu homes, honolulu hawaii real estate, hawaii mls, condos oahu, hawaii real estate agents, hawaii realtors, kailua real estate, hawaii realtor, oahu real estate, oahu realty, mililani real estate, hawaii real estate market, waikiki real estate, oahu mls, oahu properties, kahala real estate, kaneohe real estate" />
<meta name="abstract" content="Honolulu Hawaii area real estate for sale, Honolulu Hawaii relocation information, Honolulu Hawaii community information, Honolulu Hawaii real estate resources." />
<meta name="page-topic" content="Search Honolulu area residential single family, townhouse, condominium real estate  and properties." />
<meta name="classification" content="Honolulu Hawaii real estate, Hawaii real estate, Honolulu real estate, Hawaii homes for sale on Oahu, Honolulu homes for sale on Oahu, Hawaii MLS listings." />
<meta name="robots" content="index, follow" />
<meta name="document-class" content="Living Document" />
<meta name="document-type" content="Public" />
<meta name="distribution" content="Global" />

<meta name="language" content="en-us" />
<meta name="document-rating" content="General" />
<meta name="Author" content="Gabbard Hawaii Properties" />
<meta name="Copyright" content="Copyright © Gabbard Hawaii Properties, All Rights Reserved" />
<LINK REL="SHORTCUT ICON" HREF="/favicon.ico">
<link href="/9style_sub.css" rel="stylesheet" type="text/css" />
<link href="/9layout_sub.css" rel="stylesheet" type="text/css" />

<?php include("db.php"); ?>





<script src="/rollover.js" type="text/javascript"></script>
<script src="/includes/ice/ice.js" type="text/javascript"></script>
<style type="text/css">
<!--
body {
background-image: url(/9images/bg3sub.jpg);
background-color: #bbbbcc;
}
a:link {
color: #333399;
}
.style2 {color: #333399}
.style5 {color: #666699}
-->
</style></head>

<body  id="page1" onload="MM_preloadImages('/9images/m1-act.gif','/9images/m2-act.gif','/9images/m3-act.gif','/9images/m4-act.gif','/9images/m5-act.gif','/9images/m6-act.gif')"><div class="right_bgd"></div>
<div class="main">
<div id="header"><form action="/9search_results.html" enctype="application/x-www-form-urlencoded" id="cse-search-box" method="get">
<div class="indent1"><span class="fright">Honolulu Hawaii Real Estate | <a title="Contact Us" onclick="window.open('/info/contactus.html','','width=515,height=590');return false;" href="/info/contactus.html">Contact Us</a>| <a href="../extras/login.html"><span style="font-family: arial,helvetica,sans-serif;">Login</span></a><br /></span><input name="cx" type="hidden" value="005411365982401374147:xhmlagjeh6w" /><input name="cof" type="hidden" value="FORID:9" /><input name="ie" type="hidden" value="UTF-8" /><a title="Home" href="/">Home</a> > <a title="Search" href="/search/overview.html">Search</a></div>
</form><a href="/index.html"><img class="logo" src="/9images/logo.gif" alt="Gabbard Hawaii Properties Logo" title="Gabbard Hawaii Properties" width="244" height="92" /></a><br /><a title="Home" onmouseover="MM_swapImage('Image2','','/9images/m1-act.gif',1)" onmouseout="MM_swapImgRestore()" href="/index.html"><img id="Image2" src="/9images/m1.gif" alt="Home" title="Home" height="69" /></a><a title="Start here to find your Hawaii dream home." onmouseover="MM_swapImage('Image3','','/9images/m2-act.gif',1)" onmouseout="MM_swapImgRestore()" href="/search/overview.html"><img id="Image3" src="/9images/m2-act.gif" alt="Search" title="Start here to find your Hawaii dream home." width="150" height="69" /></a><a title="Let us be your guide...we can show you the way." onmouseover="MM_swapImage('Image4','','/9images/m3-act.gif',1)" onmouseout="MM_swapImgRestore()" href="/relocate/overview.html"><img id="Image4" src="/9images/m3.gif" alt="Relocate" title="Let us be your guide...we can show you the way." width="178" height="69" /></a><a title="Explore our communities. Where do you want to live?" onmouseover="MM_swapImage('Image5','','/9images/m4-act.gif',1)" onmouseout="MM_swapImgRestore()" href="/explore/overview.html"><img id="Image5" src="/9images/m4.gif" alt="Explore" title="Explore our communities. Where do you want to live?" width="181" height="69" /></a><a title="Questions? Click for answers." onmouseover="MM_swapImage('Image6','','/9images/m5-act.gif',1)" onmouseout="MM_swapImgRestore()" href="/research/overview.html"><img id="Image6" src="/9images/m5.gif" alt="Research" title="Questions? Click for answers." width="157" height="69" /></a><a title="Our vision, our values, who we are." onmouseover="MM_swapImage('Image7','','/9images/m6-act.gif',1)" onmouseout="MM_swapImgRestore()" href="/meet/overview.html"><img id="Image7" src="/9images/m6.gif" alt="Meet" title="Our vision, our values, who we are." width="158" height="69" /></a><br />
<div class="indent">
<div class="container1">
<div class="col-1"><a title="New Construction" href="/search/newhomes/overview.html"><img src="/search/images/search1.jpg" alt="New Construction" title="New Construction" width="294" height="172" /></a>
<div class="block"></div>
</div>
<div class="col-2"><a title="Financing Information" href="/search/financing/overview.html"><img src="/search/images/search2.jpg" alt="Financing Information" title="Financing Information" width="294" height="172" /></a>
<div class="block"></div>
</div>
<div class="col-3"><a title="Hawaii Market Reports" href="/search/market/overview.html"><img src="/search/images/search3.jpg" alt="Hawaii Market Reports" title="Hawaii Market Reports" width="294" height="172" /></a>
<div class="block"></div>
</div>
<br class="clear" /></div>
</div>
</div>
<div id="content">
<div class="bg-cont png">
<div class="indent-main">
<div class="container">
<div class="col-1">
<div class="box1">
<div class="indent-box1"><a title="Search" href="/search/overview.html"><img src="/search/images/text-search.gif" alt="Search" title="Search" width="225" height="20" /></a>  <br /><br />
<ul class="indent-3">
<li><a title="Search O'ahu Island Properties" href="/search/overview.html">Island Property Search</a></li>
<li><a title="Search by Building Name"http://www.beautifulhawaiihomes.idxco.com/idx/4745/mapSearch.php">Island Map Search</a></li>
<li><a title="Search by Listing Number" href="/search/listingnumber.html">Island Lifestyle Search</a></li>
</ul>
</div>
</div>
<div class="indent">
<div class="box"><form action="http://www.beautifulhawaiihomes.idxco.com/idx/4745/userLogin.php" enctype="application/x-www-form-urlencoded" method="post">
<div class="indent-box3"><img class="title1" src="/9images/login_header.gif" alt="Login" title="Login" />
<div class="h1">
<div id="IDX-listingIDsearch" class="IDX-searchBox">
<div id="IDX-listingIDsearchLabel" class="IDX-searchLabel">Email Address</div>
<div id="IDX-listingIDsearchInput" class="IDX-searchInput"><input id="IDX-userLoginEmail" style="color: #7f7d7c;" maxlength="255" name="leadEmail" size="30" type="text" value="Email Address:" /> </div>
</div>
</div>
<div class="h1">
<div id="IDX-listingIDsearch" class="IDX-searchBox">
<div id="IDX-listingIDsearchLabel" class="IDX-searchLabel">Password</div>
<div id="IDX-listingIDsearchInput" class="IDX-searchInput"><input id="IDX-userLoginPassword" style="color: #7f7d7c;" maxlength="32" name="password" size="30" type="text" value="Password:" /> </div>
</div>
</div>
<div id="IDX-searchReset" class="IDX-searchReset"><input id="IDX-resetButton" type="reset" value="Reset" /> </div>
<div id="IDX-searchSubmit" class="IDX-searchInput"><input id="IDX-userLoginSubmit" type="submit" value="Log In" /> </div>
</div>
</form><br />                  Need to Register? <a href="http://www.beautifulhawaiihomes.idxco.com/idx/4745/userSignup.php">Click Here</a><br /><br /></div>
</div>
<div class="indent">
<div class="box"><input name="stp" type="hidden" value="listingID" />
<div class="indent-box3"><img class="title1" src="/9images/1page_title1a.gif" alt="Quick Search" title="Quick Search" />
<div class="h1">
<ul class="indent-3">
<li><a title="New Single Family Listings" href="http://www.beautifulhawaiihomes.idxco.com/idx/4745/results.php?stp=advanced&pt=sfr&idxID=105&sfrType[]=Residential&ba=0&add=2&srt=ASC&aw_area[]=Central&aw_area[]=DiamondHd&aw_area[]=Ewaplain&aw_area[]=HawaiiKai&aw_area[]=Kailua&aw_area[]=Kaneohe&aw_area[]=Leeward&aw_area[]=Makakilo&aw_area[]=Metro&aw_area[]=Norshore&aw_area[]=PearlCity&aw_area[]=Waipahu">New Single Family Listings</a></li>
<li><a title="New Condominium Listings" href="http://www.beautifulhawaiihomes.idxco.com/idx/4745/results.php?stp=advanced&pt=sfr&idxID=105&sfrType[]=Condo&sfrType[]=Townhouse&ba=0&add=2&srt=ASC&aw_area[]=Central&aw_area[]=DiamondHd&aw_area[]=Ewaplain&aw_area[]=HawaiiKai&aw_area[]=Kailua&aw_area[]=Kaneohe&aw_area[]=Leeward&aw_area[]=Makakilo&aw_area[]=Metro&aw_area[]=Norshore&aw_area[]=PearlCity&aw_area[]=Waipahu">New Condominium Listings</a></li>
<li><a title="Click for $500K Listings" href="http://www.beautifulhawaiihomes.idxco.com/idx/4745/results.php?stp=advanced&pt=sfr&idxID=105&sfrType[]=Residential&sfrType[]=Condo&sfrType[]=Townhouse&lp=500000&hp=500000&ba=0&srt=ASC&aw_area[]=Central&aw_area[]=DiamondHd&aw_area[]=Ewaplain&aw_area[]=HawaiiKai&aw_area[]=Kailua&aw_area[]=Kaneohe&aw_area[]=Leeward&aw_area[]=Makakilo&aw_area[]=Metro&aw_area[]=Norshore&aw_area[]=PearlCity&aw_area[]=Waipahu">What do you get for $500K?</a></li>
<li><a title="Click for $1M Listings" href="http://www.beautifulhawaiihomes.idxco.com/idx/4745/results.php?stp=advanced&pt=sfr&idxID=105&sfrType[]=Residential&sfrType[]=Condo&sfrType[]=Townhouse&lp=1000000&hp=1000000&ba=0&srt=ASC&aw_area[]=Central&aw_area[]=DiamondHd&aw_area[]=Ewaplain&aw_area[]=HawaiiKai&aw_area[]=Kailua&aw_area[]=Kaneohe&aw_area[]=Leeward&aw_area[]=Makakilo&aw_area[]=Metro&aw_area[]=Norshore&aw_area[]=PearlCity&aw_area[]=Waipahu">What do you get for $1M?</a></li>
<li><a title="Click for $5-$6M Listings" href="http://www.beautifulhawaiihomes.idxco.com/idx/4745/results.php?stp=advanced&pt=sfr&idxID=105&sfrType[]=Residential&lp=5000000&hp=6000000&ba=0&srt=ASC&aw_area[]=Central&aw_area[]=DiamondHd&aw_area[]=Ewaplain&aw_area[]=HawaiiKai&aw_area[]=Kailua&aw_area[]=Kaneohe&aw_area[]=Leeward&aw_area[]=Makakilo&aw_area[]=Metro&aw_area[]=Norshore&aw_area[]=PearlCity&aw_area[]=Waipahu">What do you get for $5M-$6M?</a></li>
</ul>
</div>
</div>
<form action="http://www.beautifulhawaiihomes.idxco.com/idx/4745/results.php" enctype="application/x-www-form-urlencoded" id="form" method="get">
<p><br /><br /><br /><br /></p>
<p> </p>
</form></div>
</div>
</div>
<div class="indent-colSearch"><br /><img src="/search/images/text-search-results.gif" alt="Property Search" title="Property Search" /></div>
<div class="indent-colSearch2">

<div id="rha-mls-pager-container">
<?php 


$sfrtype = $_GET['sfrType[]'];
$showfield = $_GET['showField'];
$bycity = $_GET['city'][0];
$byzipcode = intval($_GET['zipCode[]'][0]);
$byregion = $_GET['aw_area[]']; 
if($_GET['lp']!="Min Price" && $_GET['lp']!=NULL){$lp = $_GET['lp'];}else{$lp = intval(0);}
if($_GET['hp']!="Max Price" && $_GET['hp']!=NULL){$hp = $_GET['hp'];}else{$hp = intval(100000000);}
$landtenure = $_GET['aw_tenure[]'];
$beds = intval($_GET['bd']);
$bath = intval($_GET['ba']);
$sort = $_GET['srt'];
$sqft = intval($_GET['sqFt']);
$landarea = intval($_GET['kw_landArea']);
$numresults = $_GET['per'];
$neighbourhood = $_GET['aw_neighborhood[]'];
$view = $_GET['aw_view[]'];
$schools = $_GET['aw_schools[]'];
$building = $_GET['aw_buildingName[]'];
$frontage = $_GET['aw_frontage[]'];
$pool = $_GET['aw_pool[]'];


if(isset($_GET['zipCode'])){
$SEARCH = "WHERE 1 ";
foreach ($_GET['zipCode'] as $key1 => $z){if($key1 == 0){$SEARCH .= " AND zip = {$z} ";}else{$SEARCH .= " OR zip = {$z} ";}}
} elseif(isset($_GET['city'])){
$SEARCH = "WHERE 1 ";
foreach ($_GET['city'] as $key2 => $c){if($key2 == 0){$SEARCH .= " AND city LIKE '%{$c}%' ";}else{$SEARCH .= " OR city LIKE '%{$c}%' ";}}
} elseif(isset($_GET['aw_area'])){
$SEARCH = "WHERE 1 ";
foreach ($_GET['aw_area'] as $key3 => $r){if($key3 ==0){$SEARCH .= " AND region LIKE '%{$r}%' ";}else{$SEARCH .= " OR region LIKE '%{$r}%' ";}}
} else {
$SEARCH = "WHERE 1";
}

$SEARCH .=	" AND listprice >= ".$lp.
	" AND listprice <= ".$hp;


if($_GET['aw_tenure'][0]!=NULL){$SEARCH.=" AND landtenure LIKE '%{$_GET['aw_tenure'][0]}%'";}
$SEARCH .=	" AND bedrooms >= ".$beds.
	" AND baths >= ".$bath.
	" AND totintarea >= ".$sqft.
	" AND landarea >=".$landarea;
if($_GET['aw_neighborhood'] != NULL){
foreach ($_GET['aw_neighborhood'] as $key4 => $n){if($key4 ==0){$SEARCH .= " AND nbrhood LIKE '%{$n}%'";}else{$SEARCH .= " OR nbrhood LIKE '%{$n}%'";}}
}
if($_GET['aw_view'] != NULL){
foreach ($_GET['aw_view'] as $key5 => $v){if($key5 ==0){$SEARCH .= " AND featstring1 LIKE '%{$v}%'";}else{$SEARCH .= " OR featstring1 LIKE '%{$v}%'";}}
}
if($_GET['aw_schools'] != NULL){
foreach ($_GET['aw_schools'] as $key6 => $s){if($key6 ==0){$SEARCH .= " AND highschool LIKE '%{$s}%'";}else{$SEARCH .= " OR highschool LIKE '%{$s}%'";}}
}
if($_GET['aw_buildingName'] != NULL){
foreach ($_GET['aw_buildingName'] as $key7 => $bn){if($key7 ==0){$SEARCH .= " AND bldgname LIKE '%{$bn}%'";}else{$SEARCH .= " OR bldgname LIKE '%{$bn}%'";}}
}
if($_GET['aw_frontage'] != NULL){
foreach ($_GET['aw_frontage'] as $key8 => $ft){if($key8 ==0){$SEARCH .= " AND featstring1 LIKE '%{$ft}%'";}else{$SEARCH .= " OR featstring1 LIKE '%{$ft}%'";}}
}
if($_GET['aw_pool'] != NULL){
foreach ($_GET['aw_pool'] as $key9 => $pl){if($key9 ==0){$SEARCH .= " AND featstring7 LIKE '%{$pl}%'";}else{$SEARCH .= " OR featstring7 LIKE '%{$pl}%'";}}
}




$sort	= "listprice";
$sortby = $_GET['srt']; 
//if($offset != 0){$offset = $_GET['offset']+$_GET['per'];}else{$offset = $_GET['offset'];}
$limit 	= $_GET['per'];

$result = mysql_query("SELECT * 
		FROM idx 
		".$SEARCH."
		ORDER BY {$sort} {$sortby}
		LIMIT {$offset}, {$limit}")
		or die(mysql_error());


mysql_query("SELECT SQL_CALC_FOUND_ROWS * 
		FROM idx
		".$SEARCH."
		ORDER BY {$sort}
		LIMIT {$offset}, {$limit}");
$total_rows	=	mysql_query("SELECT FOUND_ROWS()");
$total_found	= 	mysql_fetch_array($total_rows);
$pages_count	= 	intval($total_found[0] / $limit);
if($total_found[0]%$limit){$pages_count++;}
?>
<div>
<?php

echo $total_found[0]." results found";
echo "<br/>";
echo "<br/>";

  
if($pages_count <= 1){$onepage = 0;}else{if($pages_count <= 14){$onepage = $pages_count;}else{$onepage = 15;}}

for($i=1; $i <= $onepage; $i++){

if($_GET['pg'] == $i){
	echo "<b>{$i}</b>    ";


		} else {


			$url = "<a href='results.php?";
			$url .= "pg=".$i."&";
			$url .= "offset=".($_GET['per']*($i-1))."&";
			if(is_array($_GET['sfrType'])){foreach($_GET['sfrType'] as $sfr){$url .= "sfrType[]=".$sfr."&";}}else{$url .= $_GET['sfrType'];}
			$url .= "showField=".$_GET['showField']."&";
			if(is_array($_GET['city'])){foreach($_GET['city'] as $cities){$url .= "city=".$cities."&";}}else{$url .= $_GET['city'];}
			$url .= "lp=".$_GET['lp']."&";
			$url .= "hp=".$_GET['hp']."&";
			if(is_array($_GET['aw_tenure'])){foreach($_GET['aw_tenure'] as $tenure){$url .= "aw_tenure[]=".$tenure."&";}}else{$url .= $_GET['aw_tenure'];}
			$url .= "bd=".$_GET['bd']."&";
			$url .= "ba=".$_GET['ba']."&";
			$url .= "srt=".$_GET['srt']."&";
			$url .= "sqFt=".$_GET['sqFt']."&";
			$url .= "kw_landArea=".$_GET['kw_landarea']."&";
			$url .= "per=".$_GET['per']."&"; 
			$url .= "'>{$i}</a>     ";			

			echo $url;

			if($i == 1){
			$url1 = "<a href='results.php?";
			$url1 .= "pg=".($i+14)."&";
			$url1 .= "offset=".($_GET['per']*($i+14))."&";
			if(is_array($_GET['sfrType'])){foreach($_GET['sfrType'] as $sfr){$url1 .= "sfrType[]=".$sfr."&";}}else{$url1 .= $_GET['sfrType'];}
			$url1 .= "showField=".$_GET['showField']."&";
			if(is_array($_GET['city'])){foreach($_GET['city'] as $cities){$url1 .= "city=".$cities."&";}}else{$url1 .= $_GET['city'];}
			$url1 .= "lp=".$_GET['lp']."&";
			$url1 .= "hp=".$_GET['hp']."&";
			if(is_array($_GET['aw_tenure'])){foreach($_GET['aw_tenure'] as $tenure){$url1 .= "aw_tenure[]=".$tenure."&";}}else{$url1 .= $_GET['aw_tenure'];}
			$url1 .= "bd=".$_GET['bd']."&";
			$url1 .= "ba=".$_GET['ba']."&";
			$url1 .= "srt=".$_GET['srt']."&";
			$url1 .= "sqFt=".$_GET['sqFt']."&";
			$url1 .= "kw_landArea=".$_GET['kw_landarea']."&";
			$url1 .= "per=".$_GET['per']."&"; 
			$url1 .= "'>NEXT</a>     ";


			}
			if($i == 15){echo $url1;}
		}
}




echo "    ";
echo ($pgnum+1)." out of ".($pages_count+1)." pages";

?>

<br />
</div>


<tr><td><!-- ################################################### -->
<?php while ($row = mysql_fetch_array($result)){ ?>
<table width="520" cellspacing="0" cellpadding="0" border="0" align="center">
<tbody><tr><td height="2" colspan="6"><hr size="1"></td></tr>
<tr>
  <td width="32%" rowspan="3"><a href=<?php echo "detailed_results.php?listnum=".$row['listnum']; ?>><img width="169" height="134" border="0" alt=<?php echo $row['listnum']; ?> src=<?php 
  if(file_exists("ftp://RUThGabb:Ruth@gh77@idxftp.hicentralmls.com/IDX/PhotosAll/".substr($row['listnum'],-1)."/".$row['listnum']."_0.jpg")){ 
  $image1 = "ftp://RUThGabb:Ruth@gh77@idxftp.hicentralmls.com/IDX/PhotosAll/".substr($row['listnum'],-1)."/".$row['listnum']."_0.jpg";
  echo $image1; 
  }elseif(file_exists("ftp://RUThGabb:Ruth@gh77@idxftp.hicentralmls.com/IDX/PhotosAll/".substr($row['listnum'],-1)."/".$row['listnum']."_1.jpg")){ 
  $image1 = "ftp://RUThGabb:Ruth@gh77@idxftp.hicentralmls.com/IDX/PhotosAll/".substr($row['listnum'],-1)."/".$row['listnum']."_1.jpg";
  echo $image1; 
  }elseif(file_exists("ftp://RUThGabb:Ruth@gh77@idxftp.hicentralmls.com/IDX/PhotosAll/".substr($row['listnum'],-1)."/".$row['listnum']."_2.jpg")){
  $image1 = "ftp://RUThGabb:Ruth@gh77@idxftp.hicentralmls.com/IDX/PhotosAll/".substr($row['listnum'],-1)."/".$row['listnum']."_2.jpg";
  echo $image1; 
  }else{
  echo "../images/NoPhoto.jpg";
  } ?>></a></td>
  <td width="4%" rowspan="3"><a href="register.php?url=featured.php%3Flistnum%3D2101425%26amp%3Bproptype%3Dres"></a></td>
<td height="27" align="left" class="thumbnailhead" colspan="3">
<a href=<?php echo "detailed_results.php?listnum=".$row['listnum']; ?>><?php echo $row['streetnum']." ".$row['streetname'].", ".$row['city']." ".$row['state'].", ".$row['zip']; ?></a></td>
<td align="right" class="thumbnailhead">
<a href=<?php echo "detailed_results.php?listnum=".$row['listnum']; ?>><?php echo "$".number_format($row['listprice']); ?></a></td></tr>
<tr>
<td width="17%" height="38" class="thumbnailbody"><?php echo $row['bedrooms']." Bedrooms"; ?></td>
<td width="15%" height="38" class="thumbnailbody"><?php echo $row['baths']." Baths"; ?></td>
<td width="21%" height="38" class="thumbnailbody">MLS#: <?php echo $row['listnum']; ?></td>
</tr>
<tr>
<td width="17%" valign="top" height="25" class="thumbnailbody"><?php echo $row['landarea']; ?> SqFt AC</td>
<td width="15%" valign="top" height="25" class="thumbnailbody">Built: <?php echo $row['yearbuilt']; ?> </td>
<td width="21%" valign="top" height="26" style="color: rgb(0, 102, 204);" class="thumbnailbody"><?php if($row['landtenure']=="FS"){echo "Fee Simple";}elseif($row['landtenure']=="LH"){echo "Leasehold";} ?></td>

</tr>
<tr><td colspan="5" class="thumbnailbody"></td></tr>
</tbody></table><br/>
<?php } ?>

<!-- ################################################### --></td></tr>

</div>
<div class="indent-box4">

</div>
</div>
</div>

<table style="margin: 0px auto; width: 875px; height: 10px; text-align: center;" border="0">
<tbody>
<tr>
<td style="height: 60px;"> </td>
</tr>
<tr>
<td>
<p><img src="/info/images/mininavigation.jpg" alt="" width="875" height="15" /></p>
<table style="margin: 0px auto; width: 800px; height: 10px; text-align: center;" border="0">
<tbody>
<tr>
<td style="width: 195px; height: 0px;" valign="top">
<p style="text-align: left;"><img src="/info/images/text-info-address.gif" alt="Gabbard Hawaii Properties" title="Gabbard Hawaii Properties" width="150" height="71" /><br /><br /><span style="font-family: arial,helvetica,sans-serif;"> 808-534-1850 Telephone<br /> 877-ALOHA HI (256-4244)<br /></span> <a title="beautifulhawaiihomes.com" href="/"><span style="font-family: arial,helvetica,sans-serif;">beautifulhawaiihomes.com</span></a><br /><br /> <a title="Contact Us" onclick="window.open('/info/contactus.html','','width=515,height=590');return false;" href="/info/contactus.html"><span style="font-family: arial,helvetica,sans-serif;">Contact Us</span></a><br /> <a title="Send a Referral" href="/kino/referrals.html" target="_blank"><span style="font-family: arial,helvetica,sans-serif;">Send a Referral</span></a><br /> <a title="Read Our Honolulu Real Estate Blog" href="/aloha"><span style="font-family: arial,helvetica,sans-serif;">Read Our Blog</span></a><br /><br /></p>
</td>
<td style="width: 225px; height: 0px;" valign="top">
<p style="text-align: left;"><span style="font-family: georgia,palatino;"><strong>SEARCH NAVIGATION<br /></strong></span><a title="Search" href="/search/overview.html">Search</a><br /><br /><a title="Search Residential Listings" href="/search/overview.html">Search Residential Listings</a> <br /><a title="Search Lots and Land Listings" href="/search/land.html">Search Lots and Land Listings</a><br /><a title="Search Multifamily Listings" href="/search/multi.html">Search Multifamily Listings</a> <br /><a title="Search by Building Name" href="/search/building.html">Search by Building Name</a><br /><a title="Search by Listing Number" href="/search/listingnumber.html">Search by Listing Number</a><br /><a title="Search by Map" href="http://www.beautifulhawaiihomes.idxco.com/idx/4745/mapSearch.php">Search by Map</a><br /><a title="Search by Property Address" href="/search/address.html">Search by Property Address</a><br /><br /><a title="Need to register?" href="http://www.beautifulhawaiihomes.idxco.com/idx/4745/userSignup.php">Need to Register?</a><br /><br /><a title="New Single Family Listings" href="http://www.beautifulhawaiihomes.idxco.com/idx/4745/results.php?stp=advanced&pt=sfr&idxID=105&sfrType[]=Residential&ba=0&add=2&srt=ASC&aw_area[]=Central&aw_area[]=DiamondHd&aw_area[]=Ewaplain&aw_area[]=HawaiiKai&aw_area[]=Kailua&aw_area[]=Kaneohe&aw_area[]=Leeward&aw_area[]=Makakilo&aw_area[]=Metro&aw_area[]=Norshore&aw_area[]=PearlCity&aw_area[]=Waipahu">New Single Family Listings</a><br /><a title="New Condominium Listings" href="http://www.beautifulhawaiihomes.idxco.com/idx/4745/results.php?stp=advanced&pt=sfr&idxID=105&sfrType[]=Condo&sfrType[]=Townhouse&ba=0&add=2&srt=ASC&aw_area[]=Central&aw_area[]=DiamondHd&aw_area[]=Ewaplain&aw_area[]=HawaiiKai&aw_area[]=Kailua&aw_area[]=Kaneohe&aw_area[]=Leeward&aw_area[]=Makakilo&aw_area[]=Metro&aw_area[]=Norshore&aw_area[]=PearlCity&aw_area[]=Waipahu">New Condominium Listings</a><br /><a title="What do you get for $500K?" href="http://www.beautifulhawaiihomes.idxco.com/idx/4745/results.php?stp=advanced&pt=sfr&idxID=105&sfrType[]=Residential&sfrType[]=Condo&sfrType[]=Townhouse&lp=500000&hp=500000&ba=0&srt=ASC&aw_area[]=Central&aw_area[]=DiamondHd&aw_area[]=Ewaplain&aw_area[]=HawaiiKai&aw_area[]=Kailua&aw_area[]=Kaneohe&aw_area[]=Leeward&aw_area[]=Makakilo&aw_area[]=Metro&aw_area[]=Norshore&aw_area[]=PearlCity&aw_area[]=Waipahu">What do you get for $500K?</a><br /><a title="What do you get for $1M?" href="http://www.beautifulhawaiihomes.idxco.com/idx/4745/results.php?stp=advanced&pt=sfr&idxID=105&sfrType[]=Residential&sfrType[]=Condo&sfrType[]=Townhouse&lp=1000000&hp=1000000&ba=0&srt=ASC&aw_area[]=Central&aw_area[]=DiamondHd&aw_area[]=Ewaplain&aw_area[]=HawaiiKai&aw_area[]=Kailua&aw_area[]=Kaneohe&aw_area[]=Leeward&aw_area[]=Makakilo&aw_area[]=Metro&aw_area[]=Norshore&aw_area[]=PearlCity&aw_area[]=Waipahu">What do you get for $1M?</a><br /><a title="What do you get for $5M-$6M?" href="http://www.beautifulhawaiihomes.idxco.com/idx/4745/results.php?stp=advanced&pt=sfr&idxID=105&sfrType[]=Residential&lp=5000000&hp=6000000&ba=0&srt=ASC&aw_area[]=Central&aw_area[]=DiamondHd&aw_area[]=Ewaplain&aw_area[]=HawaiiKai&aw_area[]=Kailua&aw_area[]=Kaneohe&aw_area[]=Leeward&aw_area[]=Makakilo&aw_area[]=Metro&aw_area[]=Norshore&aw_area[]=PearlCity&aw_area[]=Waipahu">What do you get for $5M-$6M?</a><br /><br /><a title="New Single Family Developments" href="/search/newhomes/overview.html"><span style="font-family: arial,helvetica,sans-serif;">New Single Family Developments</span></a><br /><a title="New Townhome Developments" href="/search/newhomes/townhomes.html"><span style="font-family: arial,helvetica,sans-serif;">New Townhome Developments</span></a><br /><a title="New Condominium Developments" href="/search/newhomes/condos.html"><span style="font-family: arial,helvetica,sans-serif;">New Condominium Developments</span></a></p>
</td>
<td style="width: 265px; height: 0px;" valign="top">
<p style="text-align: left;"><span style="font-family: georgia,palatino;"><strong>SEARCH NAVIGATION<br />CONTINUED<br /></strong><a title="Financing Information" href="/search/financing/overview.html"><span style="font-family: arial,helvetica,sans-serif;">Financing Information</span></a><br /><a title="15 Must Ask Lender Questions" href="/search/financing/lenderq.html"><span style="font-family: arial,helvetica,sans-serif;">15 Must Ask Lender Questions</span></a><br /><span style="font-family: arial,helvetica,sans-serif;"><a title="Interest Rates & Calculators" href="/search/financing/ratescalculators.html">Interest Rates & Calculators<br /></a></span><br /><span style="font-family: arial,helvetica,sans-serif;"><a title="Hawaii Market Reports" href="/search/market/overview.html">Hawaii Market Reports</a><br /><a title="HBR Market Press Release" href="/search/market/pdf/current/marketpressrelease.pdf" target="_blank">HBR Market Press Release</a><br /><a title="O'ahu Closed and Pending Sales" href="/search/market/pdf/current/closedpendingsales.pdf" target="_blank">O'ahu Closed and Pending Sales</a><br /><a title="O'ahu Median and Average Sale Prices" href="/search/market/pdf/current/medianaverage.pdf" target="_blank">O'ahu Median and Average Sale Prices</a><br /><a title="O'ahu List Price to Sales Price Ratio" href="/search/market/pdf/current/listpriceratio.pdf" target="_blank">O'ahu List Price to Sales Price Ratio</a><br /><a title="O'ahu Days on Market (DOM) to Sale" href="/search/market/pdf/current/dom.pdf" target="_blank">O'ahu Days on Market (DOM) to Sale</a><br /><a title="O'ahu New Listings on the Market " href="/search/market/pdf/current/newlistings.pdf" target="_blank">O'ahu New Listings on the Market</a><br /><a title="O'ahu Market Overview" href="/search/market/pdf/current/marketoverview.pdf" target="_blank">O'ahu Market Overview</a><br /><a title="O'ahu Median Sale Prices v. Affordability" href="/search/market/pdf/affordability.pdf" target="_blank">O'ahu Median Sale Prices v. Affordability</a><br /><a title="Neighborhood Median Price Comparisons" href="/search/market/pdf/annualneighborhodcomparisons.pdf" target="_blank">Neighborhood Median Price Comparisons</a><br /><a title="O'ahu Median Sale Prices" href="/search/market/saleprices.html">O'ahu Median Sale Prices<br /></a></span></span><span style="font-family: georgia,palatino;"><a title="O'ahu Annual Median Sales Price History " href="/search/market/pdf/annualmedian.pdf" target="_blank"><span style="font-family: arial,helvetica,sans-serif;">O'ahu Annual Median Sale Price History</span><br /><span style="font-family: arial,helvetica,sans-serif;">O'ahu Sales Volume History</span></a></span></p>
</td>
<td style="width: 115px; height: 0px;" valign="top">
<p style="text-align: left;"><span style="font-family: georgia,palatino;"><strong>MAIN MENU<br /></strong><a title="Home" href="/index.html"><span style="font-family: arial,helvetica,sans-serif;">Home</span></a><br /><a title="Search" href="/search/overview.html"><span style="font-family: arial,helvetica,sans-serif;">Search</span></a><br /><a title="Relocate" href="/relocate/overview.html"><span style="font-family: arial,helvetica,sans-serif;">Relocate</span></a><br /><a title="Explore" href="/explore/overview.html"><span style="font-family: arial,helvetica,sans-serif;">Explore</span></a><span style="font-family: arial,helvetica,sans-serif;"> <br /></span><a title="Research" href="/research/overview.html"><span style="font-family: arial,helvetica,sans-serif;">Research</span></a><br /><a title="Meet" href="/meet/overview.html"><span style="font-family: arial,helvetica,sans-serif;">Meet</span></a><br /><br /><br /><span style="font-size: 12px;"><strong>SITE INFO</strong></span><br /><a title="Terms of Use" href="/info/terms.html"><span style="font-family: arial,helvetica,sans-serif;">Terms of Use </span></a><br /><a title="Privacy Policies" href="/info/privacy.html"><span style="font-family: arial,helvetica,sans-serif;">Privacy Policies</span></a><br /><a title="Site Maps" href="/info/sitemaps.html"><span style="font-family: arial,helvetica,sans-serif;">Site Maps</span></a></span></p>
</td>
</tr>
<tr>
<td colspan=4>
Based on the information from the Multiple Listing Service of the Multiple Listing Service of HiCentral MLS, Ltd. Active listings last updated on <?php echo date("m/d/Y"); ?>. Information is deemed reliable but not guaranteed. Copyright: 2010 by HiCentral MLS, Ltd.

IDX information is provided exclusively for consumers' personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is based on data available to the associate, including county records. The information has not been verified by the associate and should be verified by the buyer.

Some of the active listings appearing on this site may be listed by other REALTORS®. If you are interested in those active listings, our company may represent you as the buyer's agent. If the active listing you are interested in is our company’s active listing, you may speak to one of our agents regarding your options for representation.

Hawaii and Kauai properties displayed courtesy of Hawaii Information Service. 
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>

</div>
</div>
<div id="footer">
<div class="indent-footer"><span class="style5">© Gabbard Hawaii Properties. All rights reserved.</span> <span class="style5">|</span> <a title="Terms of Use" href="/info/terms.html">Terms</a> <span class="style5">| </span><a title="Privacy Policies" href="/info/privacy.html">Privacy</a><span class="style5"> |</span> <a title="Site Maps" href="/info/sitemaps.html">Site Maps</a></div>
</div>
</div>
<script type="text/javascript">// <![CDATA[
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
// ]]></script>
<script type="text/javascript">// <![CDATA[
try {
var pageTracker = _gat._getTracker("UA-1018066-2");
pageTracker._trackPageview();
} catch(err) {}
// ]]></script>
<script type="text/javascript">// <![CDATA[
//Disable right mouse click Script

var message="Kapu! © Gabbard Hawaii Properties. All rights reserved.";

///////////////////////////////////
function clickIE4(){
if (event.button==2){
alert(message);
return false;
}
}

function clickNS4(e){
if (document.layers||document.getElementById&&!document.all){
if (e.which==2||e.which==3){
alert(message);
return false;
}
}
}

if (document.layers){
document.captureEvents(Event.MOUSEDOWN);
document.onmousedown=clickNS4;
}
else if (document.all&&!document.getElementById){
document.onmousedown=clickIE4;
}

document.oncontextmenu=new Function("alert(message);return false")
// ]]></script>
<div></div><!-- com.omniupdate.button --><div style="position:absolute; left: 0px; bottom: 0px;"><a href="http://www.omniupdate.com/ox/de.jsp?user=rgabbard&site=AlohaMLS&path=%2Fsearch%2Foverview.html" target="_top"><img src="http://www.beautifulhawaiihomes.com/z-omniupdate/dired.gif" style="border:0px;" width="36px" height="36px" alt="omniupdate" /></a></div><!-- /com.omniupdate.button --></body>


</html>

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.