<!-- getsql.php -->
<!-- MinPrice in gsql:  --> 
<!-- array = no -->
<!-- listtownsq: select * from cust_towns where cust_id = 36 order by townname -->
<!-- Query in gsql: select id,mod_date_time,class as pclass,status,list_price,town,rooms,bedrooms,baths,lavs,nof_units,frontage,taxes,glaag,lot_size_acres from mls where prop_type in ('R','T','L')  and water_body like '%wakonda%' and (water_frontage > 0)  and townstate in ('Acworth NH','Albany NH','Alexandria NH','Allenstown NH','Alstead NH','Alton NH','Amherst NH','Andover NH','Antrim NH','Ashland NH','Atkinson NH','Attleboro MA','Auburn NH','Barnstead NH','Barrington NH','Bartlett NH','Bath NH','Beans Grant NH','Beans Purchase NH','Bedford NH','Belmont NH','Bennington NH','Benton NH','Berlin NH','Bethlehem NH','Boscawen NH','Bow NH','Bradford NH','Brentwood NH','Bridgewater NH','Bristol NH','Brookfield NH','Brookline NH','Cambridge NH','Campton NH','Canaan NH','Candia NH','Canterbury NH','Carroll NH','Center Harbor NH','Chandlers Purchase NH','Charlestown NH','Chatham NH','Chester NH','Chesterfield NH','Chichester NH','Claremont NH','Clarksville NH','Colebrook NH','Columbia NH','Concord NH','Contoocook NH','Conway NH','Cornish NH','Crawfords Purchase NH','Croydon NH','Cutts Grant NH','Dalton NH','Danbury NH','Danville NH','Deering NH','Derry NH','Dixs Grant NH','Dixville NH','Dorchester NH','Dover NH','Dublin NH','Dummer NH','Dunbarton NH','Durham NH','East Kingston NH','Eastman NH','Eaton NH','Effingham NH','Ellsworth NH','Enfield NH','Epping NH','Epsom NH','Errol NH','Ervings Location NH','Exeter NH','Farmington NH','Fitzwilliam NH','Francestown NH','Franconia NH','Franklin NH','Freedom NH','Fremont NH','Gilford NH','Gilmanton NH','Gilsum NH','Goffstown NH','Gorham NH','Goshen NH','Grafton NH','Grantham NH','Greenfield NH','Greenland NH','Greens Grant NH','Greenville NH','Groton NH','Hadleys Purchase NH','Hales Location NH','Hampstead NH','Hampton Falls NH','Hampton NH','Hancock NH','Hanover NH','Harrisville NH','Harts Location NH','Haverhill NH','Hebron NH','Henniker NH','Hill NH','Hillsboro NH','Hinsdale NH','Holderness NH','Hollis NH','Hooksett NH','Hopkinton NH','Hudson NH','Jackson NH','Jaffrey NH','Jefferson NH','Keene NH','Kensington NH','Kilkinney NH','Kingston NH','Laconia NH','Lancaster NH','Landaff NH','Langdon NH','Lebanon NH','Lee NH','Lempster NH','Lincoln NH','Lisbon NH','Litchfield NH','Littleton NH','Livermore NH','Londonderry NH','Loudon NH','Low/Burbanks Grant NH','Lyman NH','Lyme NH','Lyndeborough NH','Madbury NH','Madison NH','Manchester NH','Marlborough NH','Marlow NH','Martins Location NH','Mason NH','Meredith NH','Merrimack NH','Middleton NH','Milan NH','Milford NH','Millsfield NH','Milton NH','Monroe NH','Mont Vernon NH','Moultonborough NH','Nashua NH','Nelson NH','New Boston NH','New Castle NH','New Durham NH','New Hampton NH','New Ipswich NH','New London NH','Newbury NH','Newfields NH','Newington NH','Newmarket NH','Newport NH','Newton NH','North Hampton NH','Northfield NH','Northumberland NH','Northwood NH','Nottingham NH','Odell NH','Orange NH','Orford NH','Ossipee NH','Pelham NH','Pembroke NH','Penacook NH','Peterborough NH','Piermont NH','Pinkhams Grant NH','Pittsburg NH','Pittsfield NH','Plainfield NH','Plaistow NH','Plymouth NH','Portsmouth NH','Randolph NH','Raymond NH','Richmond NH','Rindge NH','Rochester NH','Rollinsford NH','Roxbury NH','Rumney NH','Rye NH','Salem NH','Salisbury NH','Sanbornton NH','Sandisfield MA','Sandown NH','Sandwich NH','Sargents Purchase NH','Seabrook Beach NH','Seabrook NH','Second College Grant NH','Sharon NH','Shelburne NH','Somersworth NH','South Hampton NH','Springfield NH','Stark NH','Stewartstown NH','Stoddard NH','Strafford NH','Stratford NH','Success NH','Sugar Hill NH','Sullivan NH','Sunapee NH','Suncook NH','Surry NH','Sutton NH','Swanzey NH','Tamworth NH','Thornton NH','Tilton NH','Troy NH','Truro MA','Tuftonboro NH','Unity NH','Wakefield NH','Walpole NH','Warner NH','Warren NH','Washington NH','Weare NH','Webster NH','Wentworth NH','Wentworths Location NH','Westmoreland NH','Whitefield NH','Wilmot NH','Wilton NH','Winchester NH','Windham NH','Windsor NH','Wolfeboro NH','Woodstock NH') order by list_price desc --> 
<!--select id,mod_date_time,class as pclass,status,list_price,town,rooms,bedrooms,baths,lavs,nof_units,frontage,taxes,glaag,lot_size_acres from mls where prop_type in ('R','T','L')  and water_body like '%wakonda%' and (water_frontage > 0)  and townstate in ('Acworth NH','Albany NH','Alexandria NH','Allenstown NH','Alstead NH','Alton NH','Amherst NH','Andover NH','Antrim NH','Ashland NH','Atkinson NH','Attleboro MA','Auburn NH','Barnstead NH','Barrington NH','Bartlett NH','Bath NH','Beans Grant NH','Beans Purchase NH','Bedford NH','Belmont NH','Bennington NH','Benton NH','Berlin NH','Bethlehem NH','Boscawen NH','Bow NH','Bradford NH','Brentwood NH','Bridgewater NH','Bristol NH','Brookfield NH','Brookline NH','Cambridge NH','Campton NH','Canaan NH','Candia NH','Canterbury NH','Carroll NH','Center Harbor NH','Chandlers Purchase NH','Charlestown NH','Chatham NH','Chester NH','Chesterfield NH','Chichester NH','Claremont NH','Clarksville NH','Colebrook NH','Columbia NH','Concord NH','Contoocook NH','Conway NH','Cornish NH','Crawfords Purchase NH','Croydon NH','Cutts Grant NH','Dalton NH','Danbury NH','Danville NH','Deering NH','Derry NH','Dixs Grant NH','Dixville NH','Dorchester NH','Dover NH','Dublin NH','Dummer NH','Dunbarton NH','Durham NH','East Kingston NH','Eastman NH','Eaton NH','Effingham NH','Ellsworth NH','Enfield NH','Epping NH','Epsom NH','Errol NH','Ervings Location NH','Exeter NH','Farmington NH','Fitzwilliam NH','Francestown NH','Franconia NH','Franklin NH','Freedom NH','Fremont NH','Gilford NH','Gilmanton NH','Gilsum NH','Goffstown NH','Gorham NH','Goshen NH','Grafton NH','Grantham NH','Greenfield NH','Greenland NH','Greens Grant NH','Greenville NH','Groton NH','Hadleys Purchase NH','Hales Location NH','Hampstead NH','Hampton Falls NH','Hampton NH','Hancock NH','Hanover NH','Harrisville NH','Harts Location NH','Haverhill NH','Hebron NH','Henniker NH','Hill NH','Hillsboro NH','Hinsdale NH','Holderness NH','Hollis NH','Hooksett NH','Hopkinton NH','Hudson NH','Jackson NH','Jaffrey NH','Jefferson NH','Keene NH','Kensington NH','Kilkinney NH','Kingston NH','Laconia NH','Lancaster NH','Landaff NH','Langdon NH','Lebanon NH','Lee NH','Lempster NH','Lincoln NH','Lisbon NH','Litchfield NH','Littleton NH','Livermore NH','Londonderry NH','Loudon NH','Low/Burbanks Grant NH','Lyman NH','Lyme NH','Lyndeborough NH','Madbury NH','Madison NH','Manchester NH','Marlborough NH','Marlow NH','Martins Location NH','Mason NH','Meredith NH','Merrimack NH','Middleton NH','Milan NH','Milford NH','Millsfield NH','Milton NH','Monroe NH','Mont Vernon NH','Moultonborough NH','Nashua NH','Nelson NH','New Boston NH','New Castle NH','New Durham NH','New Hampton NH','New Ipswich NH','New London NH','Newbury NH','Newfields NH','Newington NH','Newmarket NH','Newport NH','Newton NH','North Hampton NH','Northfield NH','Northumberland NH','Northwood NH','Nottingham NH','Odell NH','Orange NH','Orford NH','Ossipee NH','Pelham NH','Pembroke NH','Penacook NH','Peterborough NH','Piermont NH','Pinkhams Grant NH','Pittsburg NH','Pittsfield NH','Plainfield NH','Plaistow NH','Plymouth NH','Portsmouth NH','Randolph NH','Raymond NH','Richmond NH','Rindge NH','Rochester NH','Rollinsford NH','Roxbury NH','Rumney NH','Rye NH','Salem NH','Salisbury NH','Sanbornton NH','Sandisfield MA','Sandown NH','Sandwich NH','Sargents Purchase NH','Seabrook Beach NH','Seabrook NH','Second College Grant NH','Sharon NH','Shelburne NH','Somersworth NH','South Hampton NH','Springfield NH','Stark NH','Stewartstown NH','Stoddard NH','Strafford NH','Stratford NH','Success NH','Sugar Hill NH','Sullivan NH','Sunapee NH','Suncook NH','Surry NH','Sutton NH','Swanzey NH','Tamworth NH','Thornton NH','Tilton NH','Troy NH','Truro MA','Tuftonboro NH','Unity NH','Wakefield NH','Walpole NH','Warner NH','Warren NH','Washington NH','Weare NH','Webster NH','Wentworth NH','Wentworths Location NH','Westmoreland NH','Whitefield NH','Wilmot NH','Wilton NH','Winchester NH','Windham NH','Windsor NH','Wolfeboro NH','Woodstock NH') order by list_price desc <br> -->
<!-- MLSList:   -->
<!-- MLSList: 2762470 <br> --><!--Current Item: 1 
Total Found: 1 
Total Pages: 1 
Thispage: 1 
Startitem: 0 
--><!-- Navigation goes here 
 --><html>

<head><title>Maxfield Real Estate</title>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">

<style type="text/css"><!--

a:link       { color: #000000; font-family:Verdana, Arial, Helvetica, sans-serif;font-size: 8pt }
a:visited   { color: #000000; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 8pt }
a:hover      { color: #000000; font-size: 8pt; font-family: Verdana, Arial, Helvetica, sans-serif; }
a:active     { color: #000000; font-size: 8pt; font-family: Verdana, Arial, Helvetica, sans-serif; }


span.body1   { font-size: 8pt; font-family: Arial, verenda, helvetica; color: #666666 }

body {
	background-color: #FFFFEC;
}

.txt {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 10px;
	line-height: 15px;
	color: #666666;
}

P {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 10px;
	line-height: 15px;
	color: #666666;
}

span.txtTitle{
	font-family: Arial;
	font-size: 8pt;
	line-height: 15px;
	color:#661619;text-transform:uppercase; font-weight:bold
}

.tdh2 {
	padding-left: 3; padding-right: 2; background-color: #efefef;
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 10px;
	color: #000000;
}

.tdm2 {
	padding-left: 3; padding-right: 2; font-weight: bold;
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 10px;
	color: #000000;
}

.footercopy2 {  
	font-family: Verdana, San Serif;
	font-size: 11px; 
	line-height: 15px; 
	font-weight: bold; 
	color: #faf8eb;
}

.footercopy {  
	font-family: Verdana, San Serif;
	font-size: 11px; 
	line-height: 15px; 
	font-weight: normal; 
	color: #faf8eb;
}

#aapics {
	position: relative;
	width: 500px;
	height: 400px;
	background-color: #fff;
}

#aamainpics {
	float: left;
	width: 300px;
	height: 400px;
	text-align: center;
}

#aamainpics a {
	clear: both;
}

#aamorepics {
	float: left;
	width: 199px;
	height: 400px;
	padding-top: 3px;
}

#aabigpic {
	float: left;
	width: 291px;
	height: 218px;
	margin: 5px;
	margin-bottom: 0px;
}

.aathumb {
	border: 0;
	width: 90px;
	height: 75px;
	margin: 2px;
	float: left;
}

.aamainthumb {
	margin: 5px;
	margin-top: 1px;
}

-->
</style>
      
</head>

<body >

<div align="center">
	<center>
	<table  width="747" id="table1" style="BORDER-COLLAPSE: collapse" borderColor="#54232c" cellSpacing="0" cellPadding="0"  border="0">
		<tr>
			<td borderColor="#701222" bgColor="#701222" height="133" rowSpan="3">
				<p align="center">
				<img height="113" src="images/maxfieldsignmaroon.jpg" width="120" border="0" hspace="5">
			</td>
			<td vAlign="bottom" borderColor="#701222" width="100%" bgColor="#701222" height="46">
				<img height="21" src="http://maxfieldrealestate.com/images/elements/maxfieldrealestate/masthead2.gif" width="70" border="0">
			</td>
		</tr>
		<tr>
			<td vAlign="top" borderColor="#701222" width="100%" bgColor="#701222" height="44">
			<img height="33" src="http://maxfieldrealestate.com/images/elements/maxfieldrealestate/masthead.gif" width="316" border="0"><br>
			<img height="31" src="http://maxfieldrealestate.com/images/elements/maxfieldrealestate/masthead3.gif" width="410" border="0">
		</td>
		</tr>
		<tr>
			<td vAlign="top" borderColor="#701222" width="100%" bgColor="#701222" align="right">

							
			</td>
		</tr>
		<tr>
			<td align="center" width="100%" bgcolor="#BCB889" colspan="2">

<!-- Test 2 -->

			   <a href="http://www.maxfieldrealestate.com" target="_parent">Home</a>
			</td>
		</tr>
	</table>
	</center>
</div>
<center>
<table height="1" width="747" border="2" bordercolor="#BCB889">
	<tr>
		<td align="center"><table border="0" cellpadding="0" cellspacing="1" style="border-collapse: collapse" width="100%" id="table1">
		<tr>
			<td align="center">Here are listings
				<b>
1 to 1 of 1		
				</b>
			</td>
		</tr>
		<tr>
			<td align="center">
                  Listings are sorted by price in descending order.
            </td>
		</tr>
		<tr>
			<td align="center">Page: 
			
			</td>
		</tr>
		<tr><td align="center">| <a href="index.php?agentid=">Search Again</a> |</td></tr>
</table>
<center><table width='100%'><!-- item detail starts here -->

<tr>

	<td>

		<table cellSpacing="1" cellPadding="1" width="100%" border="0">

			<tr vAlign="center" bgColor="#cccccc" height="20">

				<td vAlign="center" colSpan="2" bgcolor="#FFFFFF">

					<table cellSpacing="0" cellPadding="0" width="100%" border="1" bordercolor="#E0DEC9" style="border-collapse: collapse">

						<tr>

							<td bgcolor="#E0DEC9">

								<font class="HiLiteCellText" face="Verdana,Arial,Helvetica,Sans-Serif" color="black" size="1">

								<b>#1 &#9679; Moultonborough</b>

								</font>

							</td>

						</tr>

					</table>

				</td>

			</tr>

			<tr vAlign="top">

				<td width="90" bgcolor="#FFFFFF">

					<table cellSpacing="0" cellPadding="0" width="90" border="0">

						<tr>

							<td>

								<a href="listing.php?cid=&agentid=&currentitem=1&mlslist=2762470">

									<img src="../pics/ithumbs/2762/2762470_1.jpg" width="130" border="0">

								    <img alt="View Listing Details" src="images/viewdetails.gif" border="0" width="63" height="24">

	    	                    </a>

							</td>

						</tr>

					</table>

				</td>

				<td width="100%" bgcolor="#FFFFFF">

					<table cellSpacing="2" cellPadding="1" width="100%" border="0">

						<tr vAlign="top">

							<td width="100%">

								<table width="100%">

									<tr>

										<td bgColor="#E0DEC9">

											<font class="HiLiteCellText" face="Verdana,Arial,Helvetica,Sans-Serif" color="black" size="1">

											<b>Price:</b><br>

											$89,900
											</font>

										</td>

										<td bgColor="#E0DEC9">

											<font class="HiLiteCellText" face="Verdana,Arial,Helvetica,Sans-Serif" color="black" size="1">

											<b>BR:</b><br>

											
											</font>

										</td>

										<td bgColor="#E0DEC9">

											<font class="HiLiteCellText" face="Verdana,Arial,Helvetica,Sans-Serif" color="black" size="1">

											<b>Full Baths:</b><br>

											
											</font>

										</td>

										<td bgColor="#E0DEC9">

											<font class="HiLiteCellText" face="Verdana,Arial,Helvetica,Sans-Serif" color="black" size="1">

											<b>3/4 Baths:</b><br>

											
											</font>

										</td>

										<td bgColor="#E0DEC9">

											<font class="HiLiteCellText" face="Verdana,Arial,Helvetica,Sans-Serif" color="black" size="1">

											<b>Half Bath:</b><br>

											
											</font>

										</td>

										<td bgColor="#E0DEC9">

											<font class="HiLiteCellText" face="Verdana,Arial,Helvetica,Sans-Serif" color="black" size="1">

											<b>Sq. Ft.:</b><br>

											0 SF

											</font>

										</td>

										<td bgColor="#E0DEC9">

											<font class="HiLiteCellText" face="Verdana,Arial,Helvetica,Sans-Serif" color="black" size="1">

											<b>MLS ID:</b><br>

											2762470
											</font>

										</td>

									</tr>

								</table>

							</td>

						</tr>

						<tr vAlign="top">

							<td colSpan="5">

								<font class="LoLiteCellText" face="Verdana,Arial,Helvetica,Sans-Serif" size="1">

								<b>Description:&nbsp;</b>

Beautiful level lot in Heatherwood, a short walk to private beach on Wakondah Pond.  Paved quiet road yet only 2 miles to quaint town of Center Harbor and short drive to schools.  Low Moultonboro taxes.  Combine with MLS#2737048 and have a 3 acre lot.
								<br>

								&nbsp;

								</font>

							</td>

						</tr>

						<tr vAlign="top">

							<td width="100%">

								&nbsp;

							</td>

						</tr>

					</table>

				</td>

			</tr>

		</table>

	</td>

</tr>

<!-- item detail ends here -->

</table></center><table border="0" cellpadding="0" cellspacing="1" style="border-collapse: collapse" width="100%" id="table1">
		<tr>
			<td align="center">Here are listings
				<b>
1 to 1 of 1		
				</b>
			</td>
		</tr>
		<tr>
			<td align="center">
                  Listings are sorted by price in descending order.
            </td>
		</tr>
		<tr>
			<td align="center">Page: 
			
			</td>
		</tr>
		<tr><td align="center">| <a href="index.php?agentid=">Search Again</a> |</td></tr>
</table>
</td></tr></table>
</td></tr></table>
<div align="center">
  <center>
  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="747" id="AutoNumber1" bgcolor="#661619">
    <tr>
      <td width="204" bgcolor="#661619" height="25">
      <p align="center" style="margin-top: 10">
      <img border="0" src="http://luxuryrealestatenh.com/images/MaxfieldSign.gif" width="80" height="74"></td>
      <td width="556" bgcolor="#661619" height="54" rowspan="2">
      <font color="#FFFFFF">
      <span class="footercopy2">WOLFEBORO</span><span class = "footercopy"> 15 Railroad Avenue</span><span class = "footercopy2">&nbsp;&nbsp; 
      (800) 726-0480&nbsp;&nbsp; (603) 569-3128<br>
      OSSIPEE</span><span class="footercopy">
  Hodsdon Farm, 1230 Route 16</span><span class = "footercopy2">&nbsp; 
      (800) 726-0499&nbsp;&nbsp; (603) 539-4176<br>
      ALTON</span><span class="footercopy"> 108 Main Street</span><span class = "footercopy2">&nbsp;&nbsp; 
      (800) 871-5687&nbsp;&nbsp; (603) 875-3128<br>
      CENTER HARBOR</span><span class="footercopy"> 319 Whittier Hwy, Jct 
      25 &amp; 25B</span><span class = "footercopy2">&nbsp; 
      (877) 705-2424&nbsp;&nbsp; (603) 253-9360</span></td>
    </tr>
    <tr>
      <td width="204" bgcolor="#661619" height="29" align="center">
    <font size="1" color="#FFFFFF" face="Arial">
    A Division of <a href="http://www.maxfieldrealestate.com/" target="_maxfld">
      <font color="#FFFFFF">Maxfield Real Estate</font></a></font></td>
    </tr>
  </table>
  </center>
</div>
<p align="center"><span class="body1">Website Design by </span>
      <font face="Arial"><a href="mailto:excelsior@metrocast.net">Excelsior Graphics</a></font>
</p>

</body>
</html>