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;

215 Gladys Avenue
Inglis, FL 34449

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $349,999
Beds: 3
Baths: 2
Status: Active
SqFt: 1512
Agency: 488 Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 2005
Notes: Welcome to your dream home at 215 Gladys Avenue, a stunning property that seamlessly blends modern amenities with the charm and spaciousness of country living. This beautifully updated residence is not just a house, it's a lifestyle opportunity for anyone seeking tranquility, space, and endless possibilities for outdoor activities. As you step into this move-in-ready house, you'll be greeted by an expanse of 1,512 square feet of meticulously renovated living space. The home boasts three cozy bedrooms and two modern bathrooms, providing ample room for family, guests, or a home office. The heart of the home features a kitchen designed for gatherings and culinary adventures, flowing effortlessly into inviting living areas. What sets this property apart is its remarkable outdoor offerings on a sprawling 2-acre lot. Fully fenced and situated on a corner lot for added privacy and accessibility, it includes 3 covered 50 amp RV parking with hook-up facilities 2 septic tanks, 2 electric meters, 2 water meters—a rare find that promises adventures on the road without leaving the comforts of home behind. Additionally, the property houses a versatile barn and an expansive area ideal for pets or potentially setting up equestrian facilities. For those who cherish their own personal retreat or hobby space, the property includes an adaptable man cave/she shed overlooking a refreshing pool—an oasis of relaxation on hot summer days. The location couldn't be more perfect for water enthusiasts; it's just a short distance to a public boat ramp providing easy access to Withlacoochee River, Gulf of Mexico, Crystal River, and Rainbow River. 215 Gladys Avenue is not just offering a house; it's offering an adventure-rich lifestyle without an HOA. Bring your toys, invite your guests—there's room for everyone to create unforgettable memories.
MlsNumber: 831007


Listing Provided By: 488 Real Estate, original listing
Name: 488 Real Estate
Phone: (352) 535-3288
Office Name: Cain Real Estate
Office Phone: (352) 535-3288
Agent Name: Shawnette Cain
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