%expand%%append-header(Pragma,public)%append-header(Expires,0)%append-header(Cache-Control,must-revalidate, post-check=0, pre-check=0)%append-header(Content-Type,application/kml+xml; charset=utf8)%append-header(Content-Disposition,attachment; filename="prowebber.kml")<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns="http://earth.google.com/kml/2.0">
<Document>
  <name>Keystone listings</name>
  <Style id="11368:2 (site) (normal)">
    <IconStyle>
      <scale>0.6000000238418579</scale>
      <Icon>
        <href>http://kh.google.com:80/flatfile?lf-0-icons/information_new_nh.png</href>
        <w>32</w>
        <h>32</h>
      </Icon>
      <Border id="khBorderDefault"></Border>
    </IconStyle>
    <LabelStyle>
      <scale>0.8999999761581421</scale>
    </LabelStyle>
    <LineStyle>
      <antialias>0</antialias>
    </LineStyle>
    <PolyStyle>
      <fill>0</fill>
      <outline>0</outline>
    </PolyStyle>
  </Style>
  <StyleMap id="113681">
    <Pair>
      <key>normal</key>
      <styleUrl>#11368:2 (site) (normal)</styleUrl>
    </Pair>
    <Pair>
      <key>highlight</key>
      <styleUrl>#11368:2 (site) (highlight)</styleUrl>
    </Pair>
  </StyleMap>
  <Style id="11368:2 (site) (highlight)">
    <IconStyle>
      <scale>0.699999988079071</scale>
      <Icon>
        <href>http://kh.google.com:80/flatfile?lf-0-icons/information_new_nh.png</href>
        <y>32</y>
        <w>32</w>
        <h>32</h>
      </Icon>
      <Border id="khBorderDefault"></Border>
    </IconStyle>
    <LabelStyle>
      <scale>0.8999999761581421</scale>
    </LabelStyle>
    <LineStyle>
      <antialias>0</antialias>
    </LineStyle>
    <PolyStyle>
      <fill>0</fill>
      <outline>0</outline>
    </PolyStyle>
  </Style>
  <Folder>
    <name>Open House Listings</name>
    <open>1</open>
    <Snippet maxLines="0" id="khSnippet697">
    </Snippet>
    <description><![CDATA[<center>

</center>]]></description>
    <LookAt id="khLookAt698">
        <longitude>-76.34542</longitude>
        <latitude>40.03332</latitude>
      <range>65000.75995303</range>
      <tilt>9.514962785465593e-011</tilt>
      <heading>1.276417824102102</heading>
    </LookAt>
    <Folder>
      <name>Keystone MLS Search Results</name>
      <Snippet maxLines="0" id="khSnippet1504">
      </Snippet>
      <description><![CDATA[Listings generated by ProWeb Associates <a href="http://www.ProWebAssociates.com">www.ProWebAssociates.com</a>]]></description>
      <LookAt id="khLookAt1505">
        <longitude>-76.34542</longitude>
        <latitude>40.03332</latitude>
        <range>65000.75995303</range>
        <tilt>9.635335918686975e-011</tilt>
        <heading>-0.0006290834894002948</heading>
      </LookAt>
%sql(rets_xml;wwi;14east,"select DISTINCT LIST1,ADD0,ADD5,LIST22,LIST_100,LIST_105,LIST_47,LIST_46 from openhouse_data inner join rets_common on openhouse_data.LIST1 = rets_common.LIST_1 WHERE LIST_46 IS NOT NULL AND LIST_9 = 'Residential' AND EVENT100 >= curdate()  AND (NOT FIND_IN_SET(LIST_88,'To Be Built') OR LIST_88 IS NULL) AND (NOT FIND_IN_SET(LIST_88,'Under Construction') OR LIST_88 IS NULL) GROUP BY LIST1 ",
<Placemark>
        <name><![CDATA[%column(ADD0)\, %column(ADD5)]]></name>
        <Snippet maxLines="0">
        </Snippet>
        <description><![CDATA[ <table><td>
$%column(LIST22)<br><img src="%gettoken(%column(LIST_100),",",0)" border="1" width="150" align="left" hspace="5" vspace="2"> <a href="http://www.lebanonopenhouses.com/detail_listings.html?mls=%column(LIST_105)&mlsid=%column(LIST1)&agentid=0&pic=&goog=yes" target="_self">Click for detail</a></td></table> ]]></description>
        <LookAt id="khLookAt%column(LIST1)">
        <longitude>%column(LIST_47)</longitude>
        <latitude>%column(LIST_46)</latitude>
          <range>595.8093853833508</range>
          <tilt>-1.190715371698139e-010</tilt>
          <heading>0.02052230699432949</heading>
        </LookAt>
        <styleUrl>#113681</styleUrl>
        <Style id="khStyle631">
          <IconStyle id="khIconStyle%column(LIST1)">
            <Icon>
              <href>http://www.lebanonopenhouses.com/realestate.png</href>
            </Icon>
          </IconStyle>
          <LabelStyle id="khLabelStyle%column(LIST1)">
            <scale>1</scale>
          </LabelStyle>
        </Style>
        <Point id="khPoint%column(LIST1)">
          <coordinates>%column(LIST_47)\,%column(LIST_46)\,0</coordinates>
        </Point>
      </Placemark>

)
</Folder>
</Folder>
</Document>
</kml>