<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
  /* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */

  // load viewer library
  $libraryPath = 'cmsAdmin/lib/viewer_functions.php';
  $dirsToCheck = array('/usr/home/klemmr/www/htdocs/','','../','../../','../../../');
  foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
  if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

  // load records
  list($house_listingsRecords, $house_listingsMetaData) = getRecords(array(
    'tableName'   => 'house_listings',
    'orderBy'     => 'price+0 DESC',
  ));
  
 list($agentsRecords, $agentsMetaData) = getRecords(array(
    'tableName'   => 'agents',
  ));

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
 <head>
  <title>Klemm Real Estate - Fine Properties - Litchfield County - Connecticut, CT</title>
  <meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
  
  <meta name="description" content=" Klemm Real Estate, Washington Depot,
Connecticut.  Litchfield County's Premier broker of luxury properties. Serving all 26 towns and villages in Litchfield County, CT.">

<meta name="keywords" content=" Klemm Real Estate,Country Properties,Farm,Farmhouse,Land for Sale,Connecticut,Connecticut Real Estate,Country Rentals,Horse Properties, Estates,Litchfield,Litchfield County,Tanglewood,Prep Schools,Washington,Lakeville,Clemm,Clem,Klem,Sharon,Kent,CT,luxury real estate,lake properties,lake rentals,weekend house,antique,New England,Colonial,Bridgewater,Roxbury CT,Mayflower Inn,Carolyn Klemm,investments,second homes,Barns,Connecticut Rental,Candlewood Lake,Fairfield County,Greenwich CT,Private Properties,Farmland,Private Properties of Connecticut,weekend getaway, Investment Property,Waterfront House,Waterfront Land,Waterfront Property,Antique House,Northwest Conectcut,Salisbury CT,Country Estates,Country Cottage,Connecticut,Seasonal Rental,Summer Rental,New York State,Massachusetts">

<link href="main.css" rel="stylesheet" type="text/css">
<link href="base_kre_cmsb.css" rel="stylesheet" type="text/css">
<script src="nav.js" type="text/javascript"></script>
 </head>
<body>

<body marginwidth="0" marginheight="0" leftmargin="0" rightmargin="0" topmargin="0" bottommargin="0" style="margin: 0" bgcolor="#003300">
<br>
<table border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#003300">
  <tr>
    <td>
	<div class=template_outer>	
	<div class=template_inner>
	
<table align="center" width="900" border="0">
	<tr>
		<td valign="middle" height="70">
		<img src="/images/kre_lgnew.gif" width="300" height="48" alt="Klemm Real Estate">
		</td>
		
		<td align="center" valign="middle" height="70" class="header_italic">
		Local People / Worldwide Connections<br>
		Less than 2 hours from Manhattan
		</td>
	</tr>
</table>

	<table width="900" border="0" cellspacing="0" cellpadding="0">    	
              <tr>
                <td class="nav_bg">
                <table align="center" width="850" border="0" cellspacing="0" cellpadding="4">
                  <tr>
                    <td><div align="center">
                    <a href="/index.html"><img name="home" src="/images/nav_home.gif" border="0" onmouseover="/swap('home_on','home')" onmouseout="/swap('home','home')" alt="Home"></a>
                    <img src="/images/spacer.gif" width="1" height="25" alt="">
                    
                    <a href="/listman/exec/search.cgi?template=_search_results_over4m.html&search=1&perpage=48&marknew=1&sort_order=10%2C123%2Creverse&lfield10_min=%244%2C000%2C000&lfield7_keyword=Residential&lfield13_keyword=For+Sale&shownew=&search=Search+Listings"><img name="properties" src="/images/nav_properties.gif" border="0" onmouseover="/swap('properties_on','properties')" onmouseout="/swap('properties','properties')" alt="Properties"></a>
                    <img src="/images/spacer.gif" width="1" height="25" alt="">
                    
                    <a href="/listman/exec/search.cgi?template=_search_results_land_over1m.html&search=1&perpage=48&marknew=1&sort_order=10%2C123%2Creverse&lfield10_min=%241%2C000%2C000&shownew=&lfield7_keyword=land&lfield13_keyword=For+Sale&search=Search+Listings"><img name="land" src="/images/nav_land.gif" border="0" onmouseover="/swap('land_on','land')" onmouseout="/swap('land','land')" alt="Land"></a>
                    <img src="/images/spacer.gif" width="1" height="25" alt="">
                    
                    <a href="http://www.klemmrentals.com/listman/exec/search.cgi?template=_search_results_rentals.html&search=1&perpage=48&marknew=1&sort_order=8%2Cabc%2Creverse&shownew=&lfield7_keyword=For+Rent&search=Search+Listings"><img name="rentals" src="/images/nav_rentals.gif" border="0" onmouseover="/swap('rentals_on','rentals')" onmouseout="/swap('rentals','rentals')" alt="Rentals"></a>
                    <img src="/images/spacer.gif" width="1" height="25" alt="">
                    
                    <a href="/agents.html"><img name="agents" src="/images/nav_agents.gif" border="0" onmouseover="/swap('agents_on','agents')" onmouseout="/swap('agents','agents')" alt="Agents"></a>
                    <img src="/images/spacer.gif" width="1" height="25" alt="">
                    
                    <a href="/travel.html"><img name="directions" src="/images/nav_directions.gif" border="0" onmouseover="/swap('directions_on','directions')" onmouseout="/swap('directions','directions')" alt="Directions"></a>
                    <img src="/images/spacer.gif" width="1" height="25" alt="">
                    
                    <a href="/about.html"><img name="about" src="/images/nav_about.gif" border="0" onmouseover="/swap('about_on','about')" onmouseout="/swap('about','about')" alt="About Klemm"></a>
                    <img src="/images/spacer.gif" width="1" height="25" alt="">
                    
                    <a href="mailto:info@klemmrealestate.com"><img name="contact" src="/images/nav_contact.gif" border="0" onmouseover="/swap('contact_on','contact')" onmouseout="/swap('contact','contact')" alt="Contact Us"></a></div>
                    </td>
                    </tr>
                </table>
                
               </td>        
             </tr>
          </table>
     	</div> </div>    
      </td>        
   </tr>
</table>

<table align="center" width="900" cellspacing="0">
	<tr>
		<td bgcolor="#3F613F" height="28"> <!-- medium green -->
		&nbsp;
		</td>
	</tr>
	
	<!--<tr>
		<td bgcolor="#E8DEA4" height="2"> <!-- khaki -->
		&nbsp;
		</td>
	</tr>-->
</table>
							
<table align="center" bgcolor="#E8DEA4" width="900" border="0" cellspacing="0" cellpadding="10">
	<tr>
		<td align="center" valign="top">
		<div class="page_heading">Properties For Sale</div>
		
		<p align="center"><div class="italic_12">As local residents for over 30 years Klemm Real Estate has access to dozens of private listings in all price ranges...call for details</div></p>
		</td>
	</tr>
</table>

<br />
<div align="center">

<table align="center" bgcolor="#E8DEA4" width="900" border="3" cellspacing="8" cellpadding="5">
	<tr>
	<?php foreach ($house_listingsRecords as $record): ?>
		<td align="center" valign="top" class="listings">
		<b><?php echo $record['heading'] ?></b><br/>
      		<?php echo $record['property_town'] ?><br/>
      		 		
     		<?php foreach ($record['listings_photo'] as $upload): ?>
          	<?php if ($upload['hasThumbnail']): ?>
            	<a href="<?php echo $record['_link'] ?>" class="navbar"><img src="<?php echo $upload['thumbUrlPath'] ?>" width="150" border="1" alt="" /></a><br/>

          	<?php elseif ($upload['isImage']): ?>
            	<img src="<?php echo $upload['urlPath'] ?>" width="<?php echo $upload['width'] ?>" height="<?php echo $upload['height'] ?>" alt="" /><br/>

          	<?php else: ?>
            	<a href="<?php echo $upload['urlPath'] ?>">Download <?php echo $upload['filename'] ?></a><br/>

          	<?php endif ?>
        	<?php endforeach ?>
     
      		<span class="price">$<?php echo number_format($record['price']) ?></span><br/>
      		<a href="<?php echo $record['_link'] ?>" class="navbar">Property Details</a><br/>
      		<span class="new_info"><?php echo $record['new_info'] ?></span><br/>
      		

    		<?php if (!$house_listingsRecords): ?>
     		 No records were found!<br/><br/>
    		<?php endif ?>
    		</td>
    		
    		<?php $maxCols=4; if (@++$count % $maxCols == 0): ?></tr><tr><?php endif; ?> 
<?php endforeach ?>
	</tr>
</table>
</div>
<br />
<div align="center">
		<a href="/listman/exec/search.cgi?template=_search_results_over4m.html&search=1&perpage=48&marknew=1&sort_order=10%2C123%2Creverse&lfield10_min=%244%2C000%2C000&lfield7_keyword=Residential&lfield13_keyword=For+Sale&shownew=&search=Search+Listings" class="price_range_white">Over $4 Million</a> &nbsp; | &nbsp;  
		<a href="/listman/exec/search.cgi?template=_search_results_2-4m.html&search=1&perpage=50&marknew=1&sort_order=10%2C123%2Creverse&lfield10_min=%242%2C000%2C000&lfield10_max=%244%2C000%2C000&lfield7_keyword=Residential&lfield13_keyword=For+Sale&shownew=&search=Search+Listings" class="price_range_white">$2 - $4 Million</a> &nbsp; | &nbsp; 
		<a href="/listman/exec/search.cgi?template=_search_results_1-2m.html&search=1&perpage=50&marknew=1&sort_order=10%2C123%2Creverse&lfield10_min=%241%2C000%2C000&lfield10_max=%242%2C000%2C000&lfield7_keyword=Residential&lfield13_keyword=For+Sale&shownew=&search=Search+Listings" class="price_range_white">$1 - $2 Million</a> &nbsp; | &nbsp; 
		<a href="/listman/exec/search.cgi?template=_search_results_500k-1m.html&search=1&perpage=50&marknew=1&sort_order=10%2C123%2Creverse&lfield10_min=%24500%2C000&lfield10_max=%241%2C000%2C000&lfield7_keyword=Residential&lfield13_keyword=For+Sale&shownew=&search=Search+Listings" class="price_range_white">$500,000 - $1 Million</a> &nbsp; | &nbsp; 
		<a href="/listman/exec/search.cgi?template=_search_results_under500k.html&search=1&perpage=50&marknew=1&sort_order=10%2C123%2Creverse&lfield10_max=%24500%2C000&lfield7_keyword=Residential&lfield13_keyword=For+Sale&shownew=&search=Search+Listings" class="price_range_white">Up to $500,000</a>
		</div>
		<br>
		
<table align="center" width="900" border="0">
	<tr>
		<td align="center" valign="middle"  class="panel_green">
		<table border="0" cellspacing="8" cellpadding="0">
                  <tr>
                    <td width="128" bordercolor="#cccc66" class="offices"><div align="center"><span class="txt_panel">860.435.6789<br>
                      Lakeville/Salisbury</span></div></td>
                    <td><img src="/images/spacer.gif" width="4" height="20" alt=""></td>
                    
                    <td width="128" bordercolor="#cccc66" class="offices"><div align="center"><span class="txt_panel">860.567.5060<br>
                      Litchfield</span></div></td>
                    <td><img src="/images/spacer.gif" width="4" height="20" alt=""></td>
                    
                    <td width="128" bordercolor="#cccc66" class="offices"><div align="center"><span class="txt_panel">860.354.3263<br>
                      Roxbury</span></div></td>
                    <td><img src="/images/spacer.gif" width="4" height="20" alt=""></td>                   
                    
                    <td width="128" bordercolor="#cccc66" class="offices"><div align="center"><span class="txt_panel">860.364.5993<br>
                      Sharon</span></div></td>
                       <td><img src="/images/spacer.gif" width="4" height="20" alt=""></td>
                       
                       <td width="128" height="48" bordercolor="#cccc66" class="offices"><div align="center"><span class="txt_panel">860.868.7313<br>
                     Washington Depot</span></div></td>
                       <td><img src="/images/spacer.gif" width="4" height="20" alt=""></td>
                       
                    <td width="128" bordercolor="#cccc66" class="offices"><div align="center"><span class="txt_panel">203.263.4040<br>
                      Woodbury</span></div></td>
                  </tr>
                </table>

		<br>
<div align="center">
<a href="mailto:info@klemmrealestate.com" class="email">Email: info@klemmrealestate.com</a>
</div>
<br>

<div align="center">
		<a href="/index.html" class="props_footer">HOME</a>&nbsp; | &nbsp;
		<a 		href="/listman/exec/search.cgi?template=_search_results_over4m.html&search=1&perpage=48&marknew=1&sort_order=10%2C123%2Creverse&lfield10_min=%244%2C000%2C000&lfield7_keyword=Residential&lfield13_keyword=For+Sale&shownew=&search=Search+Listings" class="props_footer">PROPERTIES</a>&nbsp; | &nbsp;
		<a href="/listman/exec/search.cgi?template=_search_results_land.html&search=1&perpage=48&marknew=1&sort_order=10%2C123%2Creverse&shownew=&lfield7_keyword=land&lfield13_keyword=For+Sale&search=Search+Listings" class="props_footer">LAND</a>&nbsp; | &nbsp;
		<a href="http://www.klemmrentals.com/listman/exec/search.cgi?template=_search_results_rentals.html&search=1&perpage=48&marknew=1&sort_order=8%2Cabc%2Creverse&shownew=&lfield7_keyword=For+Rent&search=Search+Listings" class="props_footer">RENTALS</a>&nbsp; | &nbsp;
		<a href="/agents.html" class="props_footer">AGENTS</a>&nbsp; | &nbsp;
		<a href="/travel.html" class="props_footer">DIRECTIONS</a>&nbsp; | &nbsp;
		<a href="/about.html" class="props_footer">ABOUT KLEMM</a>&nbsp; | &nbsp;
		<a href="/listman/exec/search.cgi?template=_search_results_sold.html&search=1&perpage=48&marknew=1&sort_order=10%2C123%2Creversel&lfield13_keyword=Sold&shownew=&search=Search+Listings" class="props_footer">RECENT SALES</a>&nbsp; | &nbsp;
		<a href="/record_sales.pdf" class="props_footer">PAST PERFORMANCE</a>&nbsp; | 
		&nbsp;
		<a href="/travel.html#map" class="props_footer">MAP</a>
		</div>
		<br>
		</td>
	</tr>
</table>
</td></tr></table>

<br><br>

</body>
</html>