", " "); $this = strtr($this, "<", " "); $this = strtr($this, "|", " "); $$key = $this; } //////////////////////////////// // This will catch if someone is trying to submit a blank // or incomplete form. //////////////////////////////// if ($contact_firstname && $contact_lastname && $contact_streetaddress && $contact_city && $contact_state && $contact_homephone) { ///////////////////////////////// // This section will email me when a report request is received evenif the database update does not work. ///////////////////////////////// $message = "Name: {$contact_firstname} {$contact_lastname}\n"; $message .= "Address: {$contact_streetaddress}\n"; $message .= "Address2: {$contact_address2}\n"; $message .= "City/State: {$contact_city}, {$contact_state} {$contact_zipcode}\n"; $message .= "Work: {$contact_workphone}\n"; $message .= "Home: {$contact_homephone}\n"; $message .= "Fax: {$contact_fax}\n"; $message .= "eMail: {$contact_email}\n"; $message .= "Comments: {$comments}\n"; $message .= "Report: {$report}\n"; $message .= "Buying: {$buying}\n"; $message .= "Selling: {$selling}\n"; $message .= "Mortgage: {$mortgage}\n"; $message .= "Will move in: {$move_time}"; mail("dsprague@contactdallas.com", //To address string "Report Request from Web Site", //Subject string $message, //Message string "MIME-Version : 1.0\n Content-type: text/html; charset=iso-8859-1\n"); //Additional headers string //////////////////////////////// // This is the meat of the query that updates the prospects table //////////////////////////////// $hostname="mysql3.secureserver.net"; $username="dsprague"; $password="mand450l"; $dbname="dsprague"; $query = "INSERT INTO prospects "; $query .= "(contactid, contact_firstname, "; $query .= "contact_lastname, contact_streetaddress, "; $query .= "contact_address2, contact_city, contact_state, "; $query .= "contact_zipcode, contact_workphone, contact_homephone, "; $query .= "contact_fax, contact_email, comments, report_requested, "; $query .= "move_time, date_stamp, buying, selling, mortgage)"; $query .= "values(default,'$contact_firstname',"; $query .= "'$contact_lastname','$contact_streetaddress',"; $query .= "'$contact_address2','$contact_city','$contact_state',"; $query .= "'$contact_zipcode','$contact_workphone','$contact_homephone',"; $query .= "'$contact_fax','$contact_email','$comments','$report','$move_time',NULL,'$buying',"; $query .= "'$selling','$mortgage')"; mysql_connect($hostname,$username,$password) or die("Unable to connect to SQL server for writing"); mysql_select_db($dbname) or die("Unable to select database"); mysql_query($query) or die("Prospects Insert Failed!"); $lastinsertquery = mysql_insert_id(); if($formname=="Home Value") { // $idnum = mysql_query($lastinsertquery) or die("Select for contact id Failed!"); // $idnum1 = mysql_fetch_array($idnum); $query1 = "INSERT INTO housespecs "; $query1 .= "(contactid, squarefeet, bathrooms, garage, carport, pool, spa, "; $query1 .= "sprinkler, security, portecochere, workshop, circulardrive, "; $query1 .= "wooddeck, highlinewire, commercial, halfbaths)"; $query1 .= "values('$lastinsertquery','$squarefeet','$bathrooms','$garage','$carport','$pool',"; $query1 .= "'$spa', '$sprinkler', '$security', '$portecochere', '$workshop', '$circulardrive', "; $query1 .= "'$wooddeck', '$highlinewire', '$commercial', '$halfbaths')"; // mysql_connect($hostname,$username,$password) or die("Unable to connect to SQL server for writing"); // mysql_select_db($dbname) or die("Unable to select database"); mysql_query($query1) or die("Housespecs Insert Failed!"); } else if($formname=="Referral Program") { $query2 = "INSERT INTO referrals "; $query2 .= "(contactid, referral_name, buying, selling, mortgage, referral_phone)"; $query2 .= "values('$lastinsertquery','$referral_name','$buying','$selling','$mortgage','$referral_phone')"; mysql_query($query2) or die("Referrals Insert Failed!"); } } else { //////////////////////////////// // If they didn't include all the required fields set a variable // and keep going. //////////////////////////////// $notall = 1; } } ?>
Sprague Companies Residential

Find Out Your Home Value On-Line

Knowing your home value is important information to have if you are thinking of selling your home.

Using the information you submit to us in the form below, we will conduct a thorough comparative market analysis by searching the database of all similar homes listed and recently sold in your area. We will create a value range for your home from the sales prices and features of these comparable sold homes.

With this current market data, we will be able to determine what your home might sell for if you decided to put it on the market.

There is no cost or obligation for this valuable service.

For a FREE Home Evaluation, please fill in the information requested.

Please note that all fields followed by an asterisk must be filled in.
First Name*
Last Name*
E-mail Address*
Street Address*
City*
State/Prov*
Zip/Postal Code*
Home Phone*
Business Phone
Fax
Comments
# of square feet*
# of full bathrooms*
# of half bathrooms*
# of garage spaces*
# of carport spaces*
Pool*
Sprinkler system*
Security system*
Porte Cochere (covered drive up entrance)*
Stand alone workshop*
Concrete circular drive*
Wood deck*
Backs up to highline electrical wires*
Backs up to a commercial property*