Rentals Listed Below"; } if ( $listing_type == 1 ) { echo "

Homes for Sale Below


Click Here For
Land Listings

   

Click Here For
Commercial Listings

"; } if ( $listing_type == 2 ) { echo "

Land for Sale Below


Click Here For
Home Listings

    

Click Here For
Commercial Listings

"; } if ( $listing_type == 3 ) { echo "

Commercial Properties Listed Below


Click Here For
Land Listings

    

Click Here For
Home Listings

"; } // else { echo "

Featured Listings

"; } ?>

Woodstock NY Homes For Sale - Homes In Saugerties, Phoenicia, Catskill Mountain and Ulster County New York

Teran Realty has an extensive list of Woodstock NY homes for sale. We also service the surrounding area and have homes listed in Ulster County, Catskill Mountain homes, Phoenicia homes for sale as well as Saugerties homes available. Take a look at the homes for sale below to view our featured homes for sale in New York.

 

 
Rentals

"; $sql = "SELECT * FROM main_listings WHERE listing_status = 1 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 "
"; ?>

The State of the Market 2007
A 15 Year Perspective

For the Record, a Selection of Archived 4)){ echo "Properties"; } if ( $listing_type == 4 ) { echo "Rentals";} ?>


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