Archived Homes

"; } if ( $listing_type == 2 ) { echo "Archived Land"; } if ( $listing_type == 3 ) { echo "Archived Commercial Properties"; } ?>

Notes for the Current Strong Market in 2005

    It's important for homebuyers to select a Realtor they feel comfortable with and trust. (Of course, we hope your choice is one of our agents). Many new listings, especially if they are well priced and interesting, will sell before they reach the internet. Without a Realtor who's good, you'll miss the best opportunities. With the right one, you'll be contacted right away when a new listing of interest appears, often before anyone sees it on the internet .
    The listings below are a representative sample of more than 2000 we can show you.

andrew's signature



Andrew Peck

Simply the Best

 
Rentals

"; $sql = "SELECT * FROM main_listings WHERE listing_status = 4 AND type = $listing_type ORDER BY top_flag DESC, id DESC "; $result = dbquery( $sql ); while ($data = dbarray($result)) { $id = $data["id"]; $ext_short_desc = $data["ext_short_desc"]; $short_desc = $data["short_desc"]; $price = $data["price"]; $listing_id = $data["listing_id"]; $listing_date = $data["listing_date"]; $special_tag = $data["special_tag"]; $image_sql = "SELECT * FROM image_table WHERE main_id = '$listing_id' AND type= 1"; $image_result = dbquery ( $image_sql ); //echo $image_sql; while ( $image_data = dbarray ( $image_result )){ $image_name = $image_data["image_aka_name"]; } $virtual_tour_link = $data["virtual_tour"]; echo ""; echo ""; } echo "
NEW!   We're pleased to be the first local broker to bring you All Multiple Listing Service Homes in searchable format right here on our website.
"; if ( $virtual_tour_link != "" ) { echo " "; } echo " $short_desc"; echo " $ext_short_desc
"; echo "$" . $price . " ( $listing_id )"; echo "$special_tag"; echo "
"; ?>

View Older Archives"; } if ( $listing_type == 2 ) { echo "View Older Archives"; } if ( $listing_type == 3 ) { echo "View Older Archives"; } if ( $listing_type == 4 ) { echo "View Older Archives"; } ?>

The State of the Market 2005
A 15 Year Perspective


Home | Table of Contents | Contact Us
Teran Realty · 74 Mill Hill Road · Woodstock, NY 12498
(845) 679-2500 · 1-800-57-TERAN