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

18027 Se 90th Street
Ocklawaha, FL 32179
Deidre Fernandez with MAJESTIC OAKS REALTY, original listing - (352) 274-6224

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $479,000
Beds: 2
Baths: Full: 1
Status: Active
SqFt: 1389 Square Feet
Agency: MAJESTIC OAKS REALTY
Agency Phone: (352) 274-6224

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1951
Notes: Welcome to Lakeside Serenity - Your Dream Escape Awaits! Nestled beneath sprawling oak trees and offering stunning views of the lake, this charming 2 bedroom, 1 bath home invites you into a world of tranquility. As you step inside, you're greeted by the warmth of the living room with its cozy fireplace acting as the centerpiece, framed by large windows that perfectly capture the calming lake view. Whether you're relaxing by the fire or just enjoying a quiet evening, this space is designed for peace and comfort. This home also offers flexibility, with additional room for an office or den, all complemented by a new roof installed in 2018. Imaging sipping your morning coffee on the screened lanai, watching the sun rise over the water - a perfect start to your day.<br /> Adding even more allure to this property is a separate, spacious 1,200 sq ft in-law suite. This private retreat features 1 bedroom, 1 bath, with ample room for easy conversion into a second bedroom. The suite includes a kitchen with a walk-in pantry, a dining room overlooking the lake and an impressive 22 x 22 living area and a dedicated office space. The large walk-in closet and indoor laundry room make things convenient, while the vinyl plank flooring throughout brings a modern touch. Although the in-law suite needs some finishing touches to complete the renovations it presents an exciting opportunity for customization and personal flair.<br /> Bring your Boat, RVs and toys, outdoor equipment and vehicles, the property offers abundant space with a 40 x 60 pole barn, a 2 car garage with full bath and a 10 x 20 metal storage shed. <br /> Rounding out the property is a charming 16 x 21 cook shed, set on a concrete slab, providing the perfect spot for hosting gatherings with your friends and family.<br /> Each home on this property is equipped with its own septic tank (new drain fields installed 7 years ago) ensuring independent functionality and convenience.<br /> Whether you're looking for a peaceful retreat or a project to make your own, this property combines modern upgrades with endless potential in a beautiful lakeside setting.<br /> Don't Miss This Opportunity - Make Your Appointment Today!!!!
MlsNumber: --
ListingId: OM686977


Listing Provided By: MAJESTIC OAKS REALTY, original listing
Phone: (352) 233-5540
Office Phone: (352) 274-6224
Agent Name: Deidre Fernandez
Disclaimer: Copyright © 2024 Stellar 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 = 3229 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;
Real Estate Expert Photo for Sebert (Gene) Reese
Sebert (Gene) Reese
ASCIISellstate Next Generation Realty
Call Today!: (863) 633-8094

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App