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

345 Mallard Ln
Craig, MO 64437

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $220,500
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Barnes Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: --
Notes: If you've been waiting for the perfect lake home and location to hit the market, well here it is! Located on the best water depth Big Lake has to offer, this rustic cabin/lake home offers 3-bedrooms (including the loft master suite), 2 baths, sandy beach frontage, single garage, and shade all afternoon from your fully covered deck! It took the Seller's over ten years to package this lake frontage together from which they've enjoyed and raised their three children at this location for the past 22 years! You may choose to purchase this home to include the massive floating dock or package it with any of the two other properties. Several options are being offered so the SOONER you act, the more likely you will get to pick and choose the package that best suits you! May be packaged with the floating dock ($125,000.00) or 341 Mallard next door if you act soon! Price: $245,000.00 Total (includes lot and house) ***4TH OF JULY SPECIAL PRICE: $220,500.00!*** Bedrooms & Bathrooms: 3 & 2 3/4 Year Built: 2008 Sq. Ft: Approx. 2,200 Sq. Ft. main level + loft area Taxes: 2022 Taxes were $2,155.48 Heating/Cooling: Central Water: City Other Features: Open kitchen with bar, tile flooring, and adjacent dining area Spacious living room Centrally located utility room with front load stackable washer/dryer Bedroom 1 & 2 have a queen size bunk bed with overhead twin size Full bath with jacuzzi tub Open stairway to upper loft housing master suite bedroom with king-sized bed, 1/2 bath/vanity and great view of the lake! Open floor plan with vaulted ceilings throughout Plush combination tile and carpeted flooring Superb water depth & lake location Private drive Fantastic lake view! Spacious yard Covered deck off of kitchen/dining area with soft lighting All electric central air and heat with supplemental auxiliary propane heater Two main door entrances in lower level Spacious game/family room that will easily sleep/house 10 twin beds Open stairway to main level
MlsNumber: 11167240


Listing Provided By: Barnes Realty, original listing
Name: Barnes Realty
Phone: (660) 442-3177
Office Name: Barnes Realty
Office Phone: (660) 442-3177
Agent Name: Alyssa Barnes
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App