<!--Array
(
    [listing_id] => 2451810
    [agent_user_id] => 35
    [mls] => 1050408
    [price] => 290000
    [currency] => 1
    [year_built] => 2002
    [property_address] => 13002  Lake Medora Rd 0
    [property_zip] => 49950
    [property_city] => Mohawk
    [property_state] => MI
    [virtual_tour] => 
    [county] => Keweenaw
    [school] => 0
    [school_common] => Calumet Public
    [elementary_school] => 
    [junior_high] => 
    [high_school] => 
    [extras] => 
    [bedrooms] => 4
    [bathrooms] => 1
    [sq_ft] => 1704
    [heading] => Beautiful home with amazing flower gardens!  This open concept, three bedroom...
    [description] => Beautiful home with amazing flower gardens!  This open concept, three bedroom one bath home is situated on private road, a few miles south of Copper Harbor overlooking a quiet bay on Lake Medora.  Breath taking views, beautiful hand laid stone fire place with marble hearth, 2 large wood storage areas, 213 feet of frontage with beach and 2 docks, 2 large detached garages, one with cement driveway.  Home and garages have maintenace free exterior with  50 year shingles. Beautiful gardens with over 1,000 ft. of stone and concrete walks, pond, terraced streams, bridges and fire pit area with permanent benches and picnic tables.  This home is Country lake living at its best.
    [new_construction] => 0
    [basement_description] => 
    [construction_description] => 
    [energy_description] => 
    [exterior_description] => 
    [roof_description] => 
    [extras_description] => 
    [foundation_description] => 
    [flooring] => 
    [garage_size] => 
    [garage_description] => 
    [heat_description] => 
    [cooling_description] => 
    [style_description] => 
    [acreage] => 2.25
    [lot] => 213x374
    [type_id] => 1
    [class] => residential
    [rental] => 0
    [waterfront] => 1
    [waterfront_description] => 
    [status] => 1
    [view_status] => 1
    [mls_update_date] => 0000-00-00
    [mls_price_update] => 0000-00-00
    [added] => 2010-01-16
    [updated] => 2010-09-05 12:31:09
    [update_status] => 0000-00-00
    [update_pic_price] => 0000-00-00
    [addressprecision] => city
    [tmp_lat] => 47.401965
    [tmp_lon] => -88.17119
    [nredb_featured] => 0
    [mls_feed_id] => 17
    [list_agent_name] => VAIRUS, GERALD
    [list_agent_office] => KEWEENAW REAL ESTATE INC.
    [list_agent_phone] => 
    [list_agent_address] => 
    [list_agent_id] => 
    [pic1] => 
    [pic2] => 
    [pic3] => 
    [pic4] => 
    [pic5] => 
    [pic6] => 
    [hl_image] => 
    [tmp_marker] => 1
    [agent_id] => 20
    [agent_cell] => 
    [agent_toll_free] => 
    [agent_pager] => 
    [agent_office] => 
    [agent_home] => 
    [agent_alt_phone] => fax 906-337-222
    [agent_alt_phone_label] => 906-337-4444
    [agent_titles] => 
    [agent_awards] => 
    [realtor] => 0
    [site_opt_in] => 1
    [agent_level] => 1
    [office_id] => 3
    [agent_phone] => 
    [agent_fax] => 
    [sms_number] => 
    [sms_carrier] => 0
    [website] => 
    [agent_city] => Laurium
    [agent_state] => MI
    [agent_zip] => 49913
    [agent_deleted] => 0
    [optave_username] => diane
    [optave_password] => 5f4dcc3b5aa765d61d8327deb882cf99
    [user_id] => 35
    [user_name] => gerald
    [password] => 380891959a0754c24a7ad3525c2d1e77
    [site_id] => 0
    [user_type] => 2
    [last_activity] => 2007-06-07 10:54:17
    [email] => kre@ecenterusa.com
    [f_name] => Gerald K
    [l_name] => Vairus
    [zip_aware] => 0
    [agency_id] => 3
    [office_name] => Keweenaw Real Estate
    [office_user_id] => 16
    [mls_id] => 1
    [max_agents] => 0
    [office_address] => 300 Hacla suite 16
    [office_city] => Laurium
    [office_state] => 
    [office_zip] => 49913
    [office_phone] => 906.337.4444
    [office_fax] => 906.337.2222
    [office_addressprecision] => address
    [office_lat] => 47.237014
    [office_lon] => -88.442917
    [optave_uid] => 2
    [agency_name] => Keweenaw Real Estate
    [franchise] => 4
    [agency_user_id] => 16
    [agency_address] => 300 Hecla suite 16
    [agency_city] => Larium
    [agency_state] => MI
    [agency_zip] => 49945
    [agency_phone] => 906.337.4444
    [agency_fax] => 906.337.2222
    [agency_tollfree] => 
    [agency_website] => 
    [opt_nredb] => 1
    [allowmls] => 17
    [mls_name] => UPAR MLS
    [listing_owner] => Listing provided by $listing_agent of $listing_office
    [legal] => Data provided by UPAR. All data is for personal non-commercial use to identify prospective properties for purchase. All data is deemed reliable but not guaranteed by UPAR.
    [totallistings] => 6160
    [use_layout] => 1
    [comingle] => 0
    [listing_status] => 1
)
--><html>
<head>
<title>Keweenaw Real Estate - Houghton County Dickinson Homes Builder/Dealer</title>
<style>

body,table,tr,td,span,div,a{
font-size:12px;
font-family: Verdana
}
.formtext{
line-height: 27px;
}
a.blacklink:link,a.blacklink:visited,a.blacklink:hover,a.blacklink:active{
color: #000000;
text-decoration:none;
}
a.whitelink:link,a.whitelink:visited,a.whitelink:hover,a.whitelink:active{
color: #ffffff;
text-decoration:none;
}
a:link,a:visited,a:hover,a:active{
color: #137864;
}

</style>
</head>
<body>
<table cellpadding="0" cellspacing="0" border="0"  width="775" align="center">
	<tr><td><a href="/"><img src="img_1/header.jpg" border="0" alt="Keweenaw Real Estate"></a>
		
<!--end header-->
</td></tr>
<tr><td>
<!--start nav-->

<center>
<a href="/">Home</a>
&nbsp;&nbsp;-&nbsp;&nbsp;
<a href="search.php">Search Properties</a>
&nbsp;&nbsp;-&nbsp;&nbsp;
<a href="/results.php?yid=16">Our Listings</a>
&nbsp;&nbsp;-&nbsp;&nbsp;
<a href="glossary.php">Glossary</a>
&nbsp;&nbsp;-&nbsp;&nbsp;
<a href="articles.php">Articles</a>
&nbsp;&nbsp;-&nbsp;&nbsp;
<a href="calculator.php">Financing</a>
&nbsp;&nbsp;-&nbsp;&nbsp;
<a href="agent_index.php">Agents</a>
&nbsp;&nbsp;-&nbsp;&nbsp;
<a href="testimonials.php">Testimonials</a>
&nbsp;&nbsp;-&nbsp;&nbsp;
<a href="faqs.php">FAQs</a>
</center>


<!--end nav-->
</td></tr>

<tr><td>
<!--start page-->
	<table cellpadding="0" cellspacing="0" border="0" width="775">
		<tr><td><img src="img_1/bar1.gif" alt="Keweenaw County Real Estate"></td></tr>
	</table>

<table cellspacing="5" cellpadding="0" border="0" width="775"><tr><td>

<div class="subheader_outer"><div class="subheader_inner"></div></div>

			
			<script language="javascript">
			function makebig(imagex){
				document.getElementById('bigimage').src=imagex;
			}
			
			</script>
			
						<table width="100%" cellspacing="1" border="0"><tr><td><a href="results.php?&page=1&view=20">Back To Search</a></td></tr></table>
						<table border='0' width="100%">
			<tr><td colspan="2">
				<table width="100%" border="0" cellpadding="4" class="bgtwo"><tr><td valign="top">
					<b>13002  Lake Medora Rd 0</b><br>Mohawk, MI 49950<br>MLS#: 1050408
				</td><td valign="top">
					    <b> $        290,000</b><br>
					 4 Beds, 1 Baths<br>
					 1704 SQ. FT.
					 
					 
				</td><td>
				
				<a href="http://www.mapquest.com/maps/map.adp?address=13002++Lake+Medora+Rd+0&city=Mohawk&state=MI&zipcode=49950&country=US&cid=lfmaplink" target="_blank">Map This Property</a><br>
				
								
								<a href="listing.php?&page=1&view=20&id=2451810&add_fav=2451810">Add To Favorites</a><br>
							
				<a href="friend.php?&page=1&view=20&id=2451810">Email Listing to a Friend</a><br>
				<a href="#contact">Contact Agent</a><br>
				<a href="/listing.php?id=2451810&tv=printable">Printable Flyer</a>
				</td></tr></table>


			 </td></tr>
			<tr><td>
					<!--picture Box-->
					<table width='360' height='360'><tr><td align="center">
					<img src="/data/_images/listings/medium/810/2451810_1.JPG" id="bigimage">
					</td></tr></table>
					<!--stop picture box-->
			</td><td valign="top">

					<table><tr><td>
										<div style="width:60px;display:inline; padding:1px;"><img src="/data/_images/listings/small/810/2451810_1.JPG" border="0"  onMouseOver="makebig('/data/_images/listings/large/810/2451810_1.JPG')"></div>
										<div style="width:60px;display:inline; padding:1px;"><img src="/data/_images/listings/small/810/2451810_2.JPG" border="0"  onMouseOver="makebig('/data/_images/listings/large/810/2451810_2.JPG')"></div>
										<div style="width:60px;display:inline; padding:1px;"><img src="/data/_images/listings/small/810/2451810_3.JPG" border="0"  onMouseOver="makebig('/data/_images/listings/large/810/2451810_3.JPG')"></div>
										<div style="width:60px;display:inline; padding:1px;"><img src="/data/_images/listings/small/810/2451810_4.JPG" border="0"  onMouseOver="makebig('/data/_images/listings/large/810/2451810_4.JPG')"></div>
										<div style="width:60px;display:inline; padding:1px;"><img src="/data/_images/listings/small/810/2451810_5.JPG" border="0"  onMouseOver="makebig('/data/_images/listings/large/810/2451810_5.JPG')"></div>
										<div style="width:60px;display:inline; padding:1px;"><img src="/data/_images/listings/small/810/2451810_6.JPG" border="0"  onMouseOver="makebig('/data/_images/listings/large/810/2451810_6.JPG')"></div>
										<div style="width:60px;display:inline; padding:1px;"><img src="/data/_images/listings/small/810/2451810_7.JPG" border="0"  onMouseOver="makebig('/data/_images/listings/large/810/2451810_7.JPG')"></div>
							
					
					</td></tr></table>
			</td></tr>
			
			</table>
			
			
			<table width="100%" border=0><tr><td>
				<table><tr><td valign="top">
			
					<b>Beautiful home with amazing flower gardens!  This open concept, three bedroom...</b><br><br>
					Beautiful home with amazing flower gardens!  This open concept, three bedroom one bath home is situated on private road, a few miles south of Copper Harbor overlooking a quiet bay on Lake Medora.  Breath taking views, beautiful hand laid stone fire place with marble hearth, 2 large wood storage areas, 213 feet of frontage with beach and 2 docks, 2 large detached garages, one with cement driveway.  Home and garages have maintenace free exterior with  50 year shingles. Beautiful gardens with over 1,000 ft. of stone and concrete walks, pond, terraced streams, bridges and fire pit area with permanent benches and picnic tables.  This home is Country lake living at its best.
			
				</td>

									<td valign="top">
						<table align="right" width="265"><tr><td valign="top" align="right">
							<img src="/data/_images/agents/medium/35.JPG">
						
						</td><td valign="top">
				
					    		<b>Gerald K Vairus</b>	<br>
					    	    	 	<br>
					    		Keweenaw Real Estate	 	<br>
											
					    	</td></tr></table>
					</td>
				
				</tr></table>
					<hr width="100%">
			<table width='100%' CELLPADDING="2" CELLSPACING="0" border="0"><tr><td width="200">
			<a name="contact">
				<b>Request Information:</b><br>
				<form name="request" action="request.php" method="post">
					<input type="hidden" name="redir" value="/listing.php?id=2451810"><input type="hidden" name="clsf" value="x">
					<input type="hidden" name="id" value="2451810"><input type="hidden" name="subject" value="PROPERTY REQUEST"><input type="hidden" name="mls#" value="1050408">
					<table><tr><td>
						First Name:<br><input type="text" name="f_name" size="15" class="request_field" value="" />
					</td><td>
						Last Name:<br><input type="text" name="l_name" size="15" class="request_field" value="" />
					</td></tr>
					<tr><td>
						Email:<br><input type="text" name="email" size="15" class="request_field" value="" />
					</td><td>
						Phone:<br><input type="text" name="phone" size="15" class="request_field" value="" />
					</td></tr>
					<tr><td colspan="2">
						Best Time To Contact:<br><select name="best_time"  class="request_field"><option value="any time">Any Time</option><option value="mornings">Mornings</option><option value="afternoons">Afternoons</option><option value="evenings">Evenings</option></select>
					</td></tr>
					<tr><td colspan="2">
						Question Comments:<br><textarea name="comments" cols="25" rows="5" class="request_field"></textarea>
					</td></tr><tr><td>	
					<input type="image" src="/img_1/b_submit.gif"></td></tr>
					</table>
			
				</form>
			
			</td><td valign="top"><br><br>
			<b>Details:</b><br><br>
			<table border="0" width="100%" cellpadding="0" cellspacing="0"><tr>
			
			
										<td><li><a href="">Calumet Public</a></li></td>	

					
															<td><li>Bedrooms:4</li></td>

					
							</tr><tr>
																					<td><li>Bathrooms:1</li></td>

					
															<td><li>Sq. ft.:1704</li></td>

					
							</tr><tr>
																					<td><li>Lot Size:213x374</li></td>

					
			</td></tr></table>
			
			
			</td></tr></table>
			
			
			</td></tr></table>
						

</td></tr></table>


<!--end page-->
</td></tr>
<tr><td>
<!--start footer-->

	<table cellpadding="0" cellspacing="0" border="0" width="775">
		<tr><td><img src="img_1/bar1.gif" alt="Houghton Real Estate"></td></tr>
		<tr><td align="right">&nbsp;</td></tr>
		<tr><td bgcolor="#137864"><span style="color:#ffffff;">&nbsp;&nbsp;300 Hecla St - Laurium, MI 49913 - (906) 337-4444 </span></td></tr>
	</table>


</td></tr><tr><td>
<br><br>
<br>
<a href="http://www.906homes.com" style="font-size: 9px; color: #000000; text-decoration: none;">Proudly Listed on 906homes.com - Northern Michigan Real Estate</a>
</td></tr></table>

</body></html>