'$minprice' ORDER BY sold_date DESC"; } $totalres = mysql_query($sqlsearchquery); //}else{ // if($maxprice != '') // { // $sqlsearchquery = "SELECT * FROM $scrap_tablename WHERE rowprice > '$minprice' AND rowprice < '$maxprice' ORDER BY sold_date DESC"; // }else{ // $sqlsearchquery = "SELECT * FROM $scrap_tablename WHERE rowprice > '$minprice' ORDER BY sold_date DESC"; // } // $totalres = mysql_query($sqlsearchquery); //} //if($query != '' or $minprice != 0 or $maxprice != 'unlimited') //{ // $pagelabel = '(Showing recently sold)'; //}else{ // $pagelabel = '(Showing all listings)'; //} $totalitems = mysql_num_rows($totalres); $maxpage = (int)($totalitems / $items_per_page);$maxpage = $maxpage+1; //Addthis code $addthis = '
Share |
'; //Page info if($page <1 or $page > $maxpage){$page=1;} $startfrom = $page-1;$startfrom = $startfrom*$items_per_page; $result = mysql_query($sqlsearchquery." LIMIT $startfrom,$items_per_page"); $table = ''; if(mysql_num_rows($result) != 0) { while($row = mysql_fetch_array($result)) { //Prepare pictures if($row['pictures'] != 0) { $picture = 'mylistings/pictures/'.$row['id'].'_0.jpg'; $currentpic = 1; }else{ $picture = 'mylistings/images/nopic.jpg'; $currentpic = 0; } //Prepare More-Info links if($row[multimedia_link] == 'Not Available') { $moreinfolink = 'Not Available'; }else{ $mlink = @parse_url($row[multimedia_link]); if($mlink == ''){ $mlink = 'Not Available'; $moreinfolink = ''.$mlink.''; }else{ $moreinfolink = ''.$mlink[host].''; } } //Config Addthis $location = strip_tags(str_replace('
',' ',$row[location])); $addthis_code = $addthis; $addthis_code = str_replace('[#THE_MLS#]',$row[mls],$addthis_code); $addthis_code = str_replace('[#THE_TITLE#]',$location,$addthis_code); $addthis_code = str_replace('[#THE_DESCRIPTION#]',$row[description],$addthis_code); //Create table $listings .= '
Photo '.$row[title].' More info
'.$row[bedrooms].'

'.$row[price].'

'.$row[dir_cross_st].' '.$row[building_type].' '.$row[age].' '.$row[gar_park].'
'; } }else{ $listings = '
No results to show
'; } ###Create pags control bar### //[FIRST] and [PREVIOUS] links if($page == 1){ $first_link = ''; $previous_link = ''; }else{ $prevpage = $page-1; if($query == ''){ $first_link = 'First | '; $previous_link = 'Previous | '; }else{ $first_link = 'First | '; $previous_link = 'Previous | '; } } //[NEXT] and [LAST] links if($page == $maxpage){ $next_link = ''; $last_link = ''; }else{ $nextpage = $page+1; if($query == ''){ $next_link = 'Next | '; $last_link = 'Last'; }else{ $next_link = 'Next | '; $last_link = 'Last'; } } //PAGES links //Leftside if($page != 1) { $leftp = array(); $c=0; for($i=$page-1;$i>0;$i--) { if($c < 9) { $leftp[$c] = $i; $c++; } } sort($leftp); if($query != ''){$qparam = '&q='.$query;} for($i=0;$i'.$leftp[$i].' | '; } } //Rightside if($page != $maxpage) { $rightp = array(); $c=0; for($i=$page+1;$i<$maxpage+1;$i++) { if($c < 9) { $rightp[$c] = $i; $c++; } } if($query != ''){$qparam = '&q='.$query;} for($i=0;$i'.$rightp[$i].' | '; } } if($page == $maxpage){$separator='';}else{$separator=' | ';} $pagscontrol = $first_link.$previous_link.$pagesleft.$page.$separator.$pagesright.$next_link.$last_link; ###END OF [Create pags control bar]### ### [Prepare Max and Min price list] ### $pricelist = array('25000','50000','75000','100000','125000','150000','175000','200000','225000','250000','275000','300000','325000','350000','375000','400000','425000','450000','475000','500000','550000','600000','650000','700000','750000','800000','850000','900000','950000','1000000','1500000','2000000','2500000','3000000','4000000','5000000','7500000','10000000'); //Generate option list [Min Price] for($i=0;$i'.$formated.''; } //Generate option list [Max Price] for($i=0;$i'.$formated.''; } ###END OF [Prepare Max and Min price list] ### ?>
  • darkblurbg
    Truly Personalized Service from someone
    who is available when you need them;
    before, during and after the sales process.
  • darkblurbg
    Learn how to get the best price for your home
    or find you the home you've been dreaming of.
    Make your experience comfortable, guided, fast, and efficient.
  • darkblurbg
    Get Expert advice when buying your home
    My real estate knowledge and
    expertise are completely dedicated to you.

Welcome to my Real Estate Website

Thank you for visiting my website. I've made a commitment to serve the real estate needs of my community - one family and one home at a time. My real estate knowledge and expertise are completely dedicated to you.

Whether you're looking to buy or sell, I can get your home sold, or find you the home you"ve been dreaming of. Either way, my goal is to make your experience comfortable, guided, fast, and efficient.

I can offer different packages for you to choose when listing your property. I can offer listing commission as low as 1% up to 5% depending on your situation and according to your need.

Client Testimonials

Featured Properties