0 && $_POST['month'] > 0 && $_POST['year'] > 0) { echo calendar_availability($_POST['propid'],$_POST['month'],$_POST['year']); exit; } // To use this variable into property_contact_mail.php for check user send inquiery ot owener $_SESSION['contact_form']='hg'; $propid=trim($_REQUEST['propid']); $reviewReceived = 0; $db->query("select count(id) AS 'nr' from review where propid='".$propid."' "); $record = $db->next_row(); $reviewReceived = $record['nr']; $db->query('SELECT p.*,u.fname,u.lname,u.mor_country_code,u.mor_phone_area,u.mor_phone,u.eve_country_code,u.eve_phone_area,u.eve_phone,u.fax_country_code,u.fax_area,u.fax,u.language_spoken,u.agent,c.name,c.url FROM ((property p) INNER JOIN users u ON (u.email=p.email)) LEFT JOIN category c ON (p.category_id=c.id) WHERE active!="s" AND propid='.$propid); if($db->num_rows()==0) RedirectPage(); $db->next_row(); // to set in seesion for viewed $_SESSION['viewed'][$propid]=1; update_visits($propid); // update property visit counter $propZip = $db->RECORD['zip']; if($db->RECORD['active'] == 'd') $expired='yes'; $email=$db->RECORD['email']; $isAgentProp=''; if($db->RECORD['agent'] == 'Y' && $db->RECORD['agent_payment'] == 'N') $isAgentProp='Y'; if($isAgentProp == 'Y') $contact_name='Vacation Rental Experts'; else $contact_name=ucfirst($db->RECORD['fname']).' '.ucfirst($db->RECORD['lname']); $category_id=$db->RECORD['category_id']; $category_name=$db->RECORD['name']; $category_url=$db->RECORD['url']; if($isAgentProp == 'Y') { $mor_phone .='+1-877-469-6136 ext 3'; } else { if($db->RECORD['mor_country_code'] > 0) $mor_phone .='+'.$db->RECORD['mor_country_code']; if($db->RECORD['mor_phone_area'] > 0) $mor_phone .=' ('.$db->RECORD['mor_phone_area'].') '; if($db->RECORD['mor_phone'] != "") $mor_phone .=$db->RECORD['mor_phone']; if($db->RECORD['eve_country_code'] > 0) $eve_phone .='+'.$db->RECORD['eve_country_code']; if($db->RECORD['eve_phone_area'] > 0) $eve_phone .=' ('.$db->RECORD['eve_phone_area'].') '; if($db->RECORD['eve_phone'] != "") $eve_phone .=$db->RECORD['eve_phone']; if($db->RECORD['eve_country_code'] > 0 && $db->RECORD['eve_phone_area'] > 0 && $db->RECORD['eve_phone'] != "") $eve_phone='Evening Phone: '.$eve_phone.'
'; else $eve_phone=''; if($db->RECORD['fax_country_code'] > 0) $fax .='+'.$db->RECORD['fax_area']; if($db->RECORD['fax_area'] > 0) $fax .=' ('.$db->RECORD['fax_area'].') '; if($db->RECORD['fax'] != "") $fax .=$db->RECORD['fax']; if($db->RECORD['fax_country_code'] > 0 && $db->RECORD['fax_area'] > 0 && $db->RECORD['fax'] != "") $fax='Fax: '.$fax.'
'; else $fax=''; } $language_spoken=$db->RECORD['language_spoken']; $mainCategoryLink=getCategoryLink($category_id,''); $otherPropertyInArea=getCategoryLink($category_id,', '); $total_record=countPropertyByCategory($category_id); $propertyId=$db->RECORD['propid']; $display_address=$db->RECORD['display_address']; $address1=$db->RECORD['address1']; $zip=$db->RECORD['zip']; $property_type =$db->RECORD['property_type']; $airport=$db->RECORD['airport']; $beachDistance=$db->RECORD['beach_distance']; if($beachDistance) $beachDistance .=($db->RECORD['beach_dist_miles']=='M'?'Miles':'Kms'); $bedrooms=$db->RECORD['bedrooms']; $bathrooms=$db->RECORD['bathrooms']; $floors=$db->RECORD['floors']; $people_sleep=$db->RECORD['people_sleep']; $prop_title=$db->RECORD['prop_title']; $prop_desc=str_replace("\n","
",$db->RECORD['prop_desc']); $features=$db->RECORD['features']; $appliances=$db->RECORD['appliances']; $activities=$db->RECORD['activities']; $location_type=$db->RECORD['location_type']; $other_am=str_replace("\n","
",$db->RECORD['other_am']); $rental_length=$db->RECORD['rental_length']; $occupancy=$db->RECORD['occupancy']; $rate_policy=str_replace("\n","
",trim($db->RECORD['rate_policy'])); $season=$db->RECORD['season']; $display_calender=$db->RECORD['display_calender']; $area_desc=str_replace("\n","
",$db->RECORD['area_desc']); if($db->RECORD['king_bed']) $bedroomsConfig='
  • King Beds: '.$db->RECORD['king_bed'].'
  • '; if($db->RECORD['queen_bed']) $bedroomsConfig .='
  • Queen Beds: '.$db->RECORD['queen_bed'].'
  • '; if($db->RECORD['double_bed']) $bedroomsConfig .='
  • Double Beds: '.$db->RECORD['double_bed'].'
  • '; if($db->RECORD['twin_bed']) $bedroomsConfig .='
  • Twin Beds: '.$db->RECORD['twin_bed'].'
  • '; if($db->RECORD['sofa_bed']) $bedroomsConfig .='
  • Sofa Beds: '.$db->RECORD['sofa_bed'].'
  • '; if($db->RECORD['cribs']) $bedroomsConfig .='
  • Cribs: '.$db->RECORD['cribs'].'
  • '; $patterns[0] = '/[h,H][t,T][t,T][p,P][s,S]:\/\//'; $patterns[1] = '/[h,H][t,T][t,T][p,P]:\/\//'; $patterns[2] = '/[h,H][t,T][t,T][p,P]\/\//'; $patterns[3] = '/[h,H][t,T][t,T][p,P]:\//'; $patterns[4] = '/[h,H][t,T][t,T][p,P]:/'; $patterns[5] = '/[h,H][t,T][t,T][p,P]/'; $patterns[6] = '/[t,T][t,T][p,P]:\/\//'; $patterns[7] = '/[h,H][t,T][p,P]:\/\//'; $patterns[8] = '/[h,H][t,T][p,P]\/\//'; $other_calender=preg_replace($patterns,'',trim($db->RECORD['other_url_calender'])); $pc_name=$db->RECORD['pc_name']; $check_in=$db->RECORD['check_in']; $check_out=$db->RECORD['check_out']; $tax=$db->RECORD['tax']; $required_stay=$db->RECORD['required_stay']; $cancel_policy=trim($db->RECORD['cancel_policy']); $deposits=trim($db->RECORD['deposits']); $deposits_percentage=trim($db->RECORD['deposits_percentage']); $other_fee=trim($db->RECORD['other_fee']); $cleaning_fee=trim($db->RECORD['cleaning_fee']); $other_policies=trim($db->RECORD['other_policies']); $prop_date=date('l, M d, Y',strtotime($db->RECORD['prop_date'])); $link1_approval=$db->RECORD['link1_approval']; $link2_approval=$db->RECORD['link2_approval']; if($db->RECORD['url_virtual_tour'] && $link1_approval) $propertyWebsite='Virtual Tour URL

    '; if($db->RECORD['url_virtual_tour2'] && $link2_approval) $propertyWebsite .='URL to Main Website'; $db->free(); // to check property expired/tiral or not $expired_prop=0; $db->query('SELECT cart_id,cart_name FROM cart WHERE propid='.$propid.' AND status=1 AND cart_name IN(\'Property Payment\',\'Free Month\') AND expdate >= sysdate() ORDER BY cart_id desc limit 0,1'); if($db->num_rows() > 0) { $db->next_row(); $expired_prop=1; if($db->RECORD['cart_name'] == 'Free Month') $propertyTrial=1; } $db->free(); $db->query('SELECT name FROM property_typemaster WHERE id="'.$property_type.'"'); $db->next_row(); $property_type=$db->RECORD['name']; $db->free(); // get language spoken if($language_spoken) { $langSpokeArr=explode(',',$language_spoken); foreach($langSpokeArr as $k=>$v) if($v){$langArr[]=$v;} $db->query('SELECT name FROM language_spoken WHERE id IN('.implode(',',$langArr).')'); while($db->next_row()) { $lang_spoke .=$db->RECORD['name'].', '; } } // Get maximum reting from reviews $maximumRating=''; $db->query('SELECT MAX(rating) as max_rating FROM review WHERE status=1 AND propid ='.$propid.' GROUP BY propid'); if($db->num_rows() > 0) { $db->next_row(); $maximumRating=''; } $db->free(); // Get total review $totalReview=''; $db->query('SELECT COUNT(propid) as tot_review FROM review WHERE status=1 AND propid='.$propid.' GROUP BY propid'); if($db->num_rows() > 0) { $db->next_row(); if($db->RECORD['tot_review'] > 0) $totalReview='Read '.$db->RECORD['tot_review'].' Reviews'; } $db->free(); // get rates $prop_rates=''; $db->query('SELECT MIN(ROUND(nightly)) as min_nightly,MAX(ROUND(nightly)) as max_nightly FROM effective_dates WHERE propid='.$propid.' AND nightly!=0 GROUP BY propid'); if($db->num_rows() > 0) { $db->next_row(); $prop_rates .='from'.currencyConverter($db->RECORD['min_nightly'],CURRENCY_RATE).'night'; } $db->query('SELECT MIN(ROUND(weekend)) as min_weekend,MAX(ROUND(weekend)) as max_weekend FROM effective_dates WHERE propid='.$propid.' AND weekend!=0 GROUP BY propid'); if($db->num_rows() > 0) { $db->next_row(); $prop_rates .='from'.currencyConverter($db->RECORD['min_weekend'],CURRENCY_RATE).'weekend'; } $db->query('SELECT MIN(ROUND(weekly)) as min_weekly,MAX(ROUND(weekly)) as max_weekly FROM effective_dates WHERE propid='.$propid.' AND weekly!=0 GROUP BY propid'); if($db->num_rows() > 0) { $db->next_row(); $prop_rates .='from'.currencyConverter($db->RECORD['min_weekly'],CURRENCY_RATE).'week'; } $db->query('SELECT MIN(ROUND(monthly)) as min_monthly,MAX(ROUND(monthly)) as max_monthly FROM effective_dates WHERE propid='.$propid.' AND monthly!=0 GROUP BY propid'); if($db->num_rows() > 0) { $db->next_row(); $prop_rates .='from'.currencyConverter($db->RECORD['min_monthly'],CURRENCY_RATE).'month'; } $currency_sign="$"; $currency="USD"; $currency_value=1; if($_POST['currency_name']) { $db->query('select * from currency where currency="'.$_POST['currency_name'].'"'); $db->next_row(); $currency_sign=$db->RECORD['sign']; $currency=$db->RECORD['currency']; $currency_value=$db->RECORD['value']; } $i=0;$ratesArr==$specialRateArr=array(); $db->query('SELECT * FROM effective_dates WHERE propid='.$propid.' order by start_date'); while($db->next_row()) { $id=$db->RECORD['id']; $ratesArr[$id]['season']=$db->RECORD['season']; $ratesArr[$id]['start_date']=date('M d,Y',strtotime($db->RECORD['start_date'])); $ratesArr[$id]['end_date']=date('M d,Y',strtotime($db->RECORD['end_date'])); $ratesArr[$id]['nightly']=($db->RECORD['nightly']==0?'NA':($currency_sign.($currency_value*$db->RECORD['nightly']).' '.$currency)); $ratesArr[$id]['weekend']=($db->RECORD['weekend']==0?'NA':($currency_sign.($currency_value*$db->RECORD['weekend']).' '.$currency)); $ratesArr[$id]['weekly']=($db->RECORD['weekly']==0?'NA':($currency_sign.($currency_value*$db->RECORD['weekly']).' '.$currency)); $ratesArr[$id]['monthly']=($db->RECORD['monthly']==0?'NA':($currency_sign.($currency_value*$db->RECORD['monthly']).' '.$currency)); $ratesArr[$id]['description']=trim($db->RECORD['description']); } $db->query('SELECT *,DATE_ADD(display_date,INTERVAL terms MONTH) as end_date FROM special_offer WHERE DATE_ADD(display_date,INTERVAL terms MONTH) > SYSDATE() AND propid='.$propid); while($db->next_row()) { $id=$db->RECORD['id']; $specialRateArr[$id]['title']=$db->RECORD['title']; $specialRateArr[$id]['start_date']=date('M d,Y',strtotime($db->RECORD['display_date'])); $specialRateArr[$id]['end_date']=date('M d,Y',strtotime($db->RECORD['end_date'])); $specialRateArr[$id]['nightly']=($db->RECORD['nightly']==0?'NA':($currency_sign.($currency_value*$db->RECORD['nightly']).' '.$currency)); $specialRateArr[$id]['weekend']=($db->RECORD['weekend']==0?'NA':($currency_sign.($currency_value*$db->RECORD['weekend']).' '.$currency)); $specialRateArr[$id]['weekly']=($db->RECORD['weekly']==0?'NA':($currency_sign.($currency_value*$db->RECORD['weekly']).' '.$currency)); $specialRateArr[$id]['monthly']=($db->RECORD['monthly']==0?'NA':($currency_sign.($currency_value*$db->RECORD['monthly']).' '.$currency)); $specialRateArr[$id]['description']=trim($db->RECORD['description']); } $tot_rates=count($ratesArr) + count($specialRateArr); if($tot_rates > 0) { $rates=''; if(is_array($ratesArr)) { foreach($ratesArr as $k=>$v) { $rates .=' '; if($v['description']!='') { $rates .=''; } if(($tot_rates-1) != $i) { $rates .=''; } $i++; } } if(is_array($specialRateArr)) { foreach($specialRateArr as $k=>$v) { $rates .=''; if($v['description']!='') { $rates .='<---->'; } if(($tot_rates-1) != $i) { $rates .=''; } $i++; } } $rates .='
    Period Name Period Begins Period Ends Nightly Weekend Weekly Monthly
    '.$v['season'].' '.$v['start_date'].' '.$v['end_date'].' '.$v['nightly'].' '.$v['weekend'].' '.$v['weekly'].' '.$v['monthly'].'
    '.$v['season'].' '.$v['start_date'].' '.$v['end_date'].' '.$v['nightly'].' '.$v['weekend'].' '.$v['weekly'].' '.$v['monthly'].'
      Note: '.$v['description'].'
    '; } if($location_type) { $locationArr=explode(',',$location_type); foreach($locationArr as $k=>$v) { if($v){$locationTypeArr[]=$v;} } $locationType=''; $db->query('SELECT DISTINCT name FROM location_type WHERE id IN('.implode(',',$locationTypeArr).') order by name'); while($db->next_row()) { $locationType .=$db->RECORD['name'].', '; } $locationType=substr($locationType,0,-2); } if($features) { $feaArr=explode(',',$features); foreach($feaArr as $k=>$v) { if($v){$featrueArr[]=$v;} } $firstCol=$secCol=$thirdCol=''; $db->query('SELECT DISTINCT * FROM features WHERE id IN('.implode(',',$featrueArr).') order by name'); $perCol=$db->num_rows()/3; for($i=0;$i<$perCol;$i++) { if($db->next_row()) $firstCol .='
  • '.$db->RECORD['name'].'
  • '; } for($i=0;$i<$perCol;$i++) { if($db->next_row()) $secCol .='
  • '.$db->RECORD['name'].'
  • '; } for($i=0;$i<$perCol;$i++) { while($db->next_row()) { $thirdCol .='
  • '.$db->RECORD['name'].'
  • '; } } $amenities_html='
    Property Amenities
    '; } if($appliances) { $appliancesArr=explode(',',$appliances); foreach($appliancesArr as $k=>$v) { if($v){$appArr[]=$v;} } $firstCol=$secCol=$thirdCol=''; $db->query('SELECT name FROM appliances WHERE id IN('.implode(',',$appArr).') order by name'); $perCol=$db->num_rows()/3; for($i=0;$i<$perCol;$i++) { if($db->next_row()) $firstCol .='
  • '.$db->RECORD['name'].'
  • '; } for($i=0;$i<$perCol;$i++) { if($db->next_row()) $secCol .='
  • '.$db->RECORD['name'].'
  • '; } for($i=0;$i<$perCol;$i++) { while($db->next_row()) { $thirdCol .='
  • '.$db->RECORD['name'].'
  • '; } } $appliances_html=' '; } if($activities) { $actArr=explode(',',$activities); foreach($actArr as $k=>$v) { if($v){$activitiesArr[]=$v;} } $firstCol=$secCol=$thirdCol=''; $db->query('SELECT DISTINCT * FROM activities WHERE id IN('.implode(',',$activitiesArr).') order by name'); $perCol=$db->num_rows()/3; for($i=0;$i<$perCol;$i++) { if($db->next_row()) $firstCol .='
  • '.$db->RECORD['name'].'
  • '; } for($i=0;$i<$perCol;$i++) { if($db->next_row()) $secCol .='
  • '.$db->RECORD['name'].'
  • '; } for($i=0;$i<$perCol;$i++) { while($db->next_row()) { $thirdCol .='
  • '.$db->RECORD['name'].'
  • '; } } $activities_html=' '; } $db->query('SELECT * FROM property_image WHERE propid='.$propid.' ORDER BY photo_no'); if($db->num_rows() > 0) { $pho=0;$row=1; $totPhotos=$db->num_rows(); $division=($totPhotos<10?3:4); $propGallery .=''; while($db->next_row()) { $photoPath=$propPhotoPath.'/'.$db->RECORD['path'].'/'.$db->RECORD['photo_name']; $small_photo=$propPhotoPath.'/'.$db->RECORD['path'].'/'.$db->RECORD['photo_small']; if(is_file($sitePath_photo.'/'.$db->RECORD['path'].'/'.$db->RECORD['photo_name'])) { $propGallery .='
  • '.$db->RECORD['caption'].'
  • '; $pho++; if($pho == $division) { $propGallery .=''; $pho=0; if(!in_array($totPhotos,array(3,6,9,12))) $propGallery .=''; } } if($db->RECORD['photo_no'] == 1) { if(is_file($sitePath_photo.'/'.$db->RECORD['path'].'/'.$db->RECORD['photo_detail'])) $summaryPhoto=$propPhotoPath.'/'.$db->RECORD['path'].'/'.$db->RECORD['photo_detail']; else $summaryPhoto=$propPhotoPath.'/not-available-d.jpg'; } else if($summaryPhoto == '') $summaryPhoto=$propPhotoPath.'/not-available-d.jpg'; } $extraTD=''; if($totPhotos==2 || $totPhotos==5 || $totPhotos==8 || $totPhotos==11) $propGallery .=''; else if($totPhotos==4 || $totPhotos==7 || $totPhotos==10) $propGallery .=''; } else $summaryPhoto=$propPhotoPath.'/not-available-d.jpg'; // title $categoryName=$prop_title; $include_css=''; $shortCategoryForMap = getShortCategory($category_id,', ',0); if(preg_match('/Mexico/i',$mainCategoryLink)) $shortCategoryForMap=$category_name.', Mexico'; $googleMapAddress = ''; if($zip > 0 && $address1) { $googleMapAddress=$address1.', '.$shortCategoryForMap.' '.$zip; $show_address=$address1.', '.$shortCategoryForMap; } else if($zip > 0) { $googleMapAddress=$shortCategoryForMap.' '.$zip; $show_address=$shortCategoryForMap; } else if($address1) { $googleMapAddress=$address1.', '.$shortCategoryForMap; $show_address=$address1.', '.$shortCategoryForMap; } else { $googleMapAddress=$shortCategoryForMap; } include_once 'include/header.php'; ?>

    Vacation Rentals

    Summary:
    bedrooms, bathrooms, sleeps
    Property Type:
     
    Location Type:
    Airport:

    Location

    Full Map Hide Map

    Rates

    Please contact owner for rates';?>
    CURRENCY_SYMBOL
      Contact Owner
      Reviews
      Add a review
      • Description
      • Rates
      • Availability
      • Reviews
      • Contact Owner
      • Amenities & Attractions

        Property Appliances
        Bedrooms Configuration
          Activities & Attractions
          Other amenities or activities

        • Convert to