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 = 1345 AND i.igate IN ('usahud','mnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mnhud', 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 = 1345 AND i.igate IN ('usahud','mnhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mnhud', 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 = 1345 AND i.igate IN ('usahud','mnhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mnhud', 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;

14534 State 26
Crooked Creek Twp, MN 55919
Kelly Meyer with Keller Williams Premier Realty, original listing - (507) 424-4422

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $647,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3360 Square Feet
Agency: Keller Williams Premier Realty
Agency Phone: (507) 424-4422

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 13 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1988
Notes: Discover a unique blend of luxury and nature in this remarkable home overlooking the scenic Mississippi River. Situated on nearly 14 acres of mature trees and natural beauty, this property offers privacy and serenity while remaining close to the amenities of La Crescent and La Crosse. The stunning great room features soaring ceilings, a floor-to-ceiling stone fireplace, and an abundance of windows that not only flood the space with natural light but also frame the picturesque river views. Rich oak flooring adds warmth and elegance throughout. The finished walkout lower level is designed for entertainment and relaxation, boasting large windows, a spacious bar area, and a versatile living space perfect for gatherings. Outside, you’ll find ample opportunities to connect with nature, with wildlife frequenting the property and plenty of room for outdoor activities. Recent upgrades enhance both the aesthetic and functional appeal of this home. The exterior features durable LP siding and a new roof for added peace of mind. Inside, custom cabinetry and remodeled bathrooms add a touch of sophistication. Your choice of a deck or an enclosed front porch offers cozy spaces for morning coffee or evening relaxation. The heated detached garage provides additional convenience and storage. For those who love the outdoors, this property is a gateway to recreational activities. Whether it's hiking, fishing, or simply enjoying the abundant wildlife, you'll find plenty to explore in this picturesque setting. The location also offers easy access to nearby communities, making it perfect for those seeking both rural tranquility and urban convenience. This home is more than just a place to live; it’s a retreat where you can truly enjoy the best of both worlds—peaceful country living with all the comforts of a modern home. Schedule your private showing today and experience this extraordinary property firsthand.
MlsNumber: --
ListingId: 6592735


Listing Provided By: Keller Williams Premier Realty, original listing
Phone: (507) 450-9395
Office Phone: (507) 424-4422
Agent Name: Kelly Meyer
Disclaimer: Copyright © 2024 Regional Multiple Listing Service of Minnesota [NorthStarMLS]. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App