' . stripslashes($newsletter_results['newsletter_title']) . ''; if ($newsletter_results['photo']) { $size = getimagesize('http://www.waynepasco.com/images/newsletter/' . $newsletter_results['photo']); $m[] = '' . stripslashes($newsletter_results['newsletter_title']) . ' width='; } if ($newsletter_results['article_sample']) { $m[] = '

' . nl2br(stripslashes($newsletter_results['article_sample'])) . '"

'; } $m[] = '

'; if ($newsletter_results['pdf']) { $newsletter_explode = explode("All information is approximate", html_entity_decode($newsletter_results['newsletter_text'], ENT_QUOTES)); $m[] = stripslashes(nl2br($newsletter_explode[0])); // str_replace("-&-", "-&-", $newsletter_results['pdf']); $newsletter_link = htmlspecialchars_decode($newsletter_results['pdf'], ENT_QUOTES); $newsletter_link = str_replace("-&-", "-&-", $newsletter_link); $m[] = '
"FULL MARKET UPDATE"- (REBGV)
Sales/ Listings Statistics and Graphs for all areas.

'; $m[] = "All information is approximate" . stripslashes(nl2br($newsletter_explode[1])); } else { $m[] = stripslashes(nl2br(html_entity_decode($newsletter_results['newsletter_text'], ENT_QUOTES))); } $m[] = '

'; $listing = $newsletter_results['listing']; if ($listing) { $m[] = '

"' . stripslashes($listing_results['name']) . '"
' . stripslashes($listing_results['address']); if ($listing_results['neighbourhood_id'] < 5) { $m[] = ', ' . $area; } $m[] = '

'; $where = "listing_id='" . $listing . "'"; //$m[] = "SELECT * FROM " . $table_photo . " WHERE " . $where . " AND priority='4'"; $photo_query = mysql_query("SELECT * FROM " . $table_photo . " WHERE " . $where . " AND priority='4'"); $photo_count = mysql_num_rows($photo_query); if ($photo_count > 0) { $photo_results = mysql_fetch_array($photo_query); $m[] = ''; } $m[] = nl2br(stripslashes($listing_results['description'])) . '

Listing Details

'; $m[] = ''; $m[] = ''; $m[] = '

Price: '; if ($listing_results['status'] == 4) { $m[] = 'Sold'; } else { $m[] = '$' . number_format($listing_results['price'], 0) .''; } $m[] = '

MLS #: ' . $listing_results['mls'] .'

Type: ' . $listing_results['type'] .'

Year Built: ' . $listing_results['year_built'] . '

Size: ' . $listing_results['size'] . '

Bedrooms: ' . $listing_results['bedrooms'] . '

Bathrooms: ' . $listing_results['bathrooms'] . '

Parking / Storage: ' . $listing_results['parking_storage'] . '

Maintenance: $' . $listing_results['maintenance'] . '

Property Taxes: $' . $listing_results['taxes'] . '

Amenities: ' . nl2br($listing_results['amenities']) . '

Bylaws: ' . nl2br($listing_results['bylaws']) . '



'; $m[] = '

Image Gallery

'; $gallery_query = mysql_query("SELECT * FROM $table_photo WHERE $where AND priority != '4' ORDER BY priority ASC LIMIT 3"); $gallery_count = mysql_num_rows($gallery_query); if ($gallery_count > 0) { $m[] = ''; while ($gallery_results = mysql_fetch_array($gallery_query)) { $m[] = ''; $m[] = ''; } $m[] = '


'; } $m[] = '
Click here to view listing
'; } $message_count = count($m); for ($m_count = 0; $m_count <= $message_count; $m_count+=1) { $message = $message . $m[$m_count]; } echo $message; echo '

Click here to view newsletter archive

'; } else if ($_GET['archive']){ echo '

Newsletter Archive

'; $newsletter_query = mysql_query("SELECT ID, date, newsletter_title FROM newsletter WHERE sent='0' AND n_id='1' ORDER BY ID DESC"); while ($newsletter_results = mysql_fetch_array($newsletter_query)) { foreach ($newsletter_results as $key => $value) { ${$key} = stripslashes(htmlspecialchars_decode($value, ENT_QUOTES)); } $link = ''; $link_end = ''; echo '
'; echo '

' . $link . $newsletter_title . $link_end . '

'; // listing name and link to listing page echo '

' . $link . date("M d, y", strtotime($date)) . $link_end . '

' . "\n"; // listing status echo ''; } } ?>
Site Map MLS Reciprocity

© WAYNE PASCO SUITE     Disclaimer


Site Designed By : Atomic Eye Design
Site Maintained By : Clayrose Internet Creations