".$_SESSION["secret_s"]."
".$result; $pyear=$_POST['pyear']; $name=$_POST['name']; $lname=$_POST['lname']; $email=$_POST['email']; $aemail=$_POST['aemail']; $street=$_POST['street']; $town=$_POST['town']; $state=$_POST['state']; $country=$_POST['country']; $zip=$_POST['zip']; $hometel=$_POST['hometel']; $worktel=$_POST['worktel']; $mobiletel=$_POST['mobtel']; $comments=$_POST['comments']; $subscribeFlag=$_POST['subscribeFlag']; if(isset($_POST['subscribeFlag'])) $subscribeFlag=$_POST['subscribeFlag']; else $subscribeFlag=0; if($result=="TRUE") { if (isset($_POST['countryids'])){ $countryids=$_POST['countryids']; $countryid=","; $countryname=""; if ($countryids[0]!="Any") { foreach($countryids as $v){ $countryid = $countryid.$v.","; $sqlcountry="select * from countries where countryid=$v"; $qrycountry=mysql_query($sqlcountry) or die("Error : ".mysql_error()); $rowcountry=mysql_fetch_array($qrycountry); if ($countryname=="") $countryname=$rowcountry["countryname"]; else $countryname.=", ".$rowcountry["countryname"]; } } else { $countryid=",0,"; $countryname="Any"; } } if (isset($_POST['typeids'])){ $typeids=$_POST['typeids']; $typeid=","; $typename=""; if ($typeids[0]!="All Properties") { foreach($typeids as $v){ $typeid = $typeid.$v.","; $sqltype="select * from propertytype where typeid=$v"; $qrytype=mysql_query($sqltype) or die("Error : ".mysql_error()); $rowtype=mysql_fetch_array($qrytype); if ($typename=="") $typename=$rowtype["typename"]; else $typename.=", ".$rowtype["typename"]; } } else { $typeid=",0,"; $typename="All Properties"; } } $tomail="deb@caribbeanlandandproperty.com"; $tomail="info@caribbeanlandandproperty.com"; $subject=$name." ".$lname." : ".$refno." "; $frommail="consultant@caribbeanlandandproperty.com"; $fromname="CLP Property Lookup"; $message = "Following are the details of client looking for new property :"; $message .= "
Name : ".str_htmlSpecialChars($name); $message .= "
Last Name : ".str_htmlSpecialChars($lname); $message .= "
Type of Property Wanted : ".str_htmlSpecialChars($typename); $message .= "
Countries / Islands : ".str_htmlSpecialChars($countryname); $message .= "

Street : ".str_htmlSpecialChars($street); $message .= "
Town : ".str_htmlSpecialChars($town); $message .= "
State / County : ".str_htmlSpecialChars($state); $message .= "
Country : ".str_htmlSpecialChars($country); $message .= "
Zip / Postal Code : ".str_htmlSpecialChars($zip); $message .= "
Home Telephone : ".str_htmlSpecialChars($hometel); $message .= "
Work Telephone : ".str_htmlSpecialChars($worktel); $message .= "
Mobile Telephone : ".str_htmlSpecialChars($mobiletel); $message .= "
Email : ".str_htmlSpecialChars($email); $message .= "
Alternative Email : ".str_htmlSpecialChars($aemail); $message .= "

Comments : ".str_htmlSpecialChars($comments); $sqlcrm="insert into crm_buyers (name,lname,street,town,state,country,zip,hometel,worktel,mobile,email,aemail,comments,typeids,countryids,pricerange,pyear,prop_size,visited_comm,date,newFlag) values('".str_singleQuoteReplace($name)."','".str_singleQuoteReplace($lname)."','".str_singleQuoteReplace($street)."','".str_singleQuoteReplace($town)."','".str_singleQuoteReplace($state)."','".str_singleQuoteReplace($country)."','".str_singleQuoteReplace($zip)."','".str_singleQuoteReplace($hometel)."','".str_singleQuoteReplace($worktel)."','".str_singleQuoteReplace($mobiletel)."','".str_singleQuoteReplace($email)."','".str_singleQuoteReplace($aemail)."','".str_singleQuoteReplace($comments)."','".str_singleQuoteReplace($typeid)."','".str_singleQuoteReplace($countryid)."','".$pricerange."',".$pyear.",'".str_singleQuoteReplace($_POST['propsize'])."','".str_singleQuoteReplace($_POST['prevvis'])."','".date("Y-m-d h:i:s")."','1')"; $qrycrm=mysql_query($sqlcrm) or die(mysql_error()); $idQry="select id from crm_buyers where email='".str_singleQuoteReplace($email)."' order by id DESC limit 0,1"; $idRes=mysql_query($idQry); if($idRow=mysql_fetch_object($idRes)) $buyerid=$idRow->id; $dtdate=date("Y-m-d H:i:s"); $qry="insert into crm_buyers_sub(buyerid,propertyid,comments,dtdate,newsubFlag) values($buyerid,'$refno','".str_singleQuoteReplace($comments)."','".$dtdate."','1')"; mysql_query($qry); //echo $qry; //die(); $subscribeFlag=1; if($subscribeFlag==1) { $checkQry=mysql_query("SELECT email FROM subscribers WHERE email='".str_singleQuoteReplace($email)."'"); if(!$checkROW=mysql_fetch_object($checkQry)) { $sql_subscribe="insert into subscribers (name,lname,email,interest,regdate) values('".str_singleQuoteReplace($name)."','".str_singleQuoteReplace($lname)."','".str_singleQuoteReplace($email)."','".str_singleQuoteReplace($countryid)."','".date("Y-m-d")."')"; //echo $sql_subscribe; mysql_query($sql_subscribe); //die(); } } require 'phpmm/PHPMailerAutoload.php'; $mail = new PHPMailer; $mail->setFrom('financial@caribbeanlandandproperty.com', 'CLP'); $mail->addAddress('info@caribbeanlandandproperty.com'); $mail->Subject = $subject; $mail->Body = $message; $mail->IsHTML(true); $mail->SMTPDebug = 0; if ($mail->send()) { $msuccess="Yes"; } else { $msuccess = "No"; /*echo "Mailer Error: " . $mail->ErrorInfo; */ } /* if (mail($tomail,$subject,$message,"From: ".$name." ".$lname." <".$email.">\nReturn-Path:".$email."\nContent-Type: text/html; charset=iso-8859-1") && mail($tomail1,$subject,$message,"From: ".$name." ".$lname." <".$email.">\nReturn-Path:".$email."\nContent-Type: text/html; charset=iso-8859-1")) $msuccess="Yes"; else $msuccess="No"; */ } else { $msuccess="security"; } } include "includes/keywords.php"; ?>
CONTACT US

toptextcontent; else $thanksContent=""; echo '

'.$thanksContent.'

'; ?>


Error submitting application, please retry after sometime.


Wrong security code typed. Try again.


toptextcontent; else $content=""; echo $content; ?>



Please complete the form below and let us know what you are looking for. We will respond normally within 24 hours, or at weekends and holidays on the next working day.

Tell us about what you are looking for:

Type of Property Wanted :