Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 955 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 955 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 955 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

3224 Cr 1350
Havana, KS 67347
Jake Kolb with L2 Realty, Inc, original listing - (620) 577-4487

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,200,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2576 Square Feet
Agency: L2 Realty, Inc
Agency Phone: (620) 577-4487

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 60 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: Have you ever dreamed of owning a completely private lakefront lodge that is completely out of site with zero road visibility? If so, it's time to turn that dream into reality. Nestled within a tranquil 60-acre sanctuary, this remarkable 2,576 sq. ft. Native Sandstone Rock Lodge is a true gem, constructed with attention to detail in 2003. Boasting a secluded, private setting that remains hidden from the road's prying eyes, this 4/5 bedroom, 3.5 bathroom lodge offers the perfect blend of modern comfort and rustic charm. The lodge's design combines classic and contemporary, featuring a vaulted ceiling, wood-finished walls and ceilings, that create a warm, inviting atmosphere throughout. The 1.5-story layout, complete with a loft, wraparound deck, and walkout basement, ensures every space is optimized for your pleasure. As you walk in the main door the open layout of kitchen and living area with the large prominent Native Stone Fireplace and vaulted ceilings, immediately grabs your attention. Perfect for feeding and entertaining a group of family or friends, this open layout provides the perfect setting for telling all of the latest hunting stories, while also providing an intimate setting that doesn't take a crowd to enjoy. You'll also find the visitor 1/2 bath in this area as well as the Master Suite which contains a master bath that has to be seen to be appreciated, while also providing a view of the lake. Over looking it all, is the loft area with multiple dormer windows that enhance the loft space while also offering picturesque views. This space would make a great office, play area, or an additional bedroom if needed. Downstairs in the fully finished walkout basement, you will find the two "mirrored" bedrooms on each side of the stairs. Each room is equipped with their own private full bath, large closets, as well as multiple windows overlooking the lake. Past these bedrooms you will find what is currently being used as the bunk room with two additional beds. This room would also make a perfect game room or additional family room if necessary. Also in this room, you'll see that safety and security are paramount, as evidenced by the built-in 8'x8' concrete safe-room/gun safe with a vault door, that ensures your peace of mind. The property includes a 30'x40' metal building with a concrete floor, two overhead doors, and a walk door, making it the ideal space for your hobbies or storage needs. Part of the building previously contained living quarters, and is still equipped with central heat and a window air unit. One of the crown jewels of this property is the private access it offers to a what was originally designed as a 110-acre impoundment. This area continues to suffer from an unprecedented drought, which is evident to the current level of the lake. At normal pool, the property will contain 15+/- surface acres of the watershed lake, and will continue to cooperate with a "Water Usage Agreement" with adjoining landowners providing access to the entire lake. The property offers a private boat ramp and dock, and invites you to enjoy freshwater fishing for largemouth bass, crappie, and catfish to name a few species. The lake is also known to offer some excellent waterfowl hunting opportunities, and some water sport opportunities, while creating endless opportunities for outdoor adventure and peace of mind. This property also provides ample space for outdoor enthusiasts with ATV/UTV trails, while the timber and broken pasture areas are known for both whitetail deer and turkey. Natural travel corridors traverse the property providing multiple stand and blind locations, for the trophy quality animals the property produces and has a history of producing. The upper pasture area also offers a couple of ideal locations for food plots, which would only enhance the property, or with a little additional fencing would provide some grazing opportunities for cattle or a horse. This listing is truly your chance to own a piece of paradise.
MlsNumber: --
ListingId: 11345864


Listing Provided By: L2 Realty, Inc, original listing
Phone: (620) 577-4487
Office Phone: (620) 577-4487
Agent Name: Jake Kolb
Disclaimer: Copyright © 2024 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 955 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Sarah Smith (Fabian Test Account)
ASCIIBetter Homes and Gardens Real Estate - Nicholson Group
Cell: (241) 555-1812

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App