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

1816 Se 112th Street
Inglis, FL 34449

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $435,000
Beds: 4
Baths: 2
Status: Active
SqFt: 1218
Agency: Citrus Life, Realtors LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1980
Notes: One or more photo(s) has been virtually staged. Welcome to your dream oasis on the serene Tenmile Creek with direct Gulf access. Enjoy a brief 5-minute boat ride to Cow Creek, which leads to the breathtaking Waccasassa Bay. This property spans three parcels totaling 0.74 acres, providing ample space for your outdoor lifestyle. This LUXURIOUS "hunting & fishing camp" boasts multiple outbuildings, offering versatility for storage/workshops or various outdoor pursuits... fish, hunt, swim, ride the trails on your ATV / UTV's the adventures are non-stop! Recent upgrades (2022/2023) include a NEW metal roof, HVAC system, well pump/tank+ wellhouse enclosure, LVP flooring thru-out & dual pane windows. The practical features continue with a private boat dock+ fishing shed for the fishing enthusiasts! Like to boat/kayak, push off at "launch" at dock. Step inside to discover a blend of modern comforts & stylish finishes. The Main House is 4 bedrooms/2 bathrooms with great room, eat-in-kitchen with wood burning stove. The kitchen features new cabinets, butcher block counters, stainless steel appliances including an air fryer oven! The old "laundry" shed has been converted into a private Master Ensuite, 460 SF with a laundry hook-up, complemented by a mini-split for personalized climate control. Technological enhancements abound, with two hundred amp service, reverse osmosis at the kitchen/icemaker, a water softener & updated lighting thru-out. Outdoor living is elevated with a new deck connecting to the Master Ensuite, providing a perfect spot to enjoy the scenic views & observe Mother Nature. Additional features include remodeled bathrooms, solid wood doors, new paint inside & out and a second carport for added convenience. The property comes with a transferable termite protection for peace of mind. This waterfront gem not only offers a home but a lifestyle. Immerse yourself in the beauty of Gulf access living combined with modern conveniences. Your private retreat awaits, offering a perfect blend of tranquility & adventure.
MlsNumber: 830890


Listing Provided By: Citrus Life, Realtors LLC, original listing
Name: Citrus Life, Realtors LLC
Phone: (352) 541-4000
Office Name: Citrus Life, Realtors LLC
Office Phone: (352) 541-4000
Agent Name: Tamara "Tami" L Mayer
Disclaimer: Copyright © 2024 REALTORS Association of Citrus County, Inc. 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