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 = 797 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 = 797 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 = 797 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;

28407 Highland Drive
Moravia, IA 52571
Jason Kok with Lake Homes And Farms Realty, original listing - (608) 386-5597

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $740,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 1953 Square Feet
Agency: Lake Homes And Farms Realty
Agency Phone: (608) 386-5597

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 9 acre(s)
Garage: Garage
Property Type: Residential-Single Family Attached
Year Built: 2016
Notes: Looking for what everyone dreams of owning? Woods, Waterfront, Seclusion? This stunning lakefront home boasts 4 bedrooms, 2 bath home spanning over 1,950 square feet of living space on the main level. Open living, dining, and kitchen area. Geothermal Heating and cooling with a main floor wood burning fireplace, with oversized 2 stall attached garage, and an additional 42' by 60' detached pole building, perfect for storing all your lake gear. This residence offers unparalleled privacy for a lakefront setting located on a dead-end road and the last lots on the South Bay of the lake. The interior showcases a blend of cabin, lake home, and contemporary elements, custom cabinets, stained tile master shower, all of this is just the on the main level of the house. Discover what lakeside living is all about! The expansive living/dining/kitchen space showcases breathtaking views of picturesque bay on Lake Sundown and rolling hills of Southern Appanoose County. The custom kitchen features an oversized moveable island, bespoke custom cabinets, and full appliance package including laundry room with washer and dryer included and a generous walk-in pantry. Seamlessly integrated, the dining and living areas offer an ideal setting for entertaining, unwinding, and indulging in the home's luxuries. Cozy up by the wood burning fireplace and bask in the warmth and comfort of this inviting space. The covered front porch with established perennials provides a touch of color for every season. Open air back deck is set in the amongst towering hardwoods offering ample shade and sunlight for dining area overlooking Sundown Lake. Each of the four bedrooms boasts ample space, but the primary suite is a sanctuary unto itself, featuring tray ceilings, private deck access, custom stained glass tile shower, walk-in closet, with a separate access direct to laundry area, fulfilling every homeowner's dream. With its meticulously planned layout, this home offers a seamless blend of comfort and functionality. Beyond the main level lies the captivating walkout basement oasis that is ready for finishing. This area has the start to a bathroom, living/family area, storage potential and could be 5thbedroom or bunk room. Pole Building just a short walk from the house- features 14' sidewalls with 42' by 60' footprint with full concrete approach and floor, one side entry door and one overhead door. A great space for hobbies, storage, an open canvass for the new owners. Immerse yourself in the outdoors of this property with two Sundown Lots with a total of 9.88 acres. Great hunting opportunities with an abundance of turkey and Whitetails. It would be nearly impossible to find a setting like this with lake frontage in Iowa. Put your finishing touches on over 200 feet of lakefront a partial trail to the water with a flat grassy shoreline area would be the perfect place to establish a dock or additional outdoor space. Discover hidden upgrades like the geothermal heating and cooling system the home has a lower deck perfect for an outdoor hot tub adding to the home's functionality, comfort and efficiency. This unique home offers incredible value, impossible to replicate at this price point. Complete with a turn-key experience, this is an opportunity not to be missed. With so much to offer both inside and outside, it's challenging to capture every detail. Schedule anexclusive viewing of your future lakefront haven today!
MlsNumber: --
ListingId: 11343616


Listing Provided By: Lake Homes And Farms Realty, original listing
Phone: (608) 386-5597
Office Phone: (608) 386-5597
Agent Name: Jason Kok
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 = 797 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