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;

17075 Se Highway 42
Weirsdale, FL 32195
Denise Beserock with RE/MAX PREMIER REALTY, original listing - (352) 461-0800

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $399,900
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2064 Square Feet
Agency: RE/MAX PREMIER REALTY
Agency Phone: (352) 461-0800

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1948
Notes: Welcome Home to this stunningly unique Florida GEM!! This traditional home with all of its character and Southern charm will absolutely delight you. As you enter the property through the electric gate, you'll be instantly transported by majestic oak trees, luscious gardens and the home's exterior embellished with oak siding board and batten. A charming flagstone path leads to the front porch as you are welcomed through a dutch front door. Upon entering the home, you will notice the plaster walls, ornate crown molding, plantation shutters, original hard wood floors and a wood burning fireplace in the main living area which connects to an enchanting Florida/bonus room flooded with natural light. Enjoy family meals in your separate dining room overlooking your private backyard. The kitchen boasts solid wood cabinetry, quartz countertops and a ceramic tile floor and has been updated with the modern conveniences including a glass subway tile backsplash with a pot filler about the stove, slide outs in all the bottom cabinets in which all (but one cabinet) were recently built custom to the kitchen space, a double drawer dishwasher, stainless steel refrigerator all connecting to the laundry room. Down the hallway is your own reading nook, the guest bath and three bedrooms. The deluxe primary bedroom has an ensuite bathroom with new glass shower door, new toilet and lots of storage and features custom, no wire closets. There is also a private doorway off the bedroom providing easy access outside to the fully fenced backyard. The two guest bedrooms are of good size, offering ample storage and custom closets with no wire in the back bedroom. Every room is adorned with a ceiling fan. There are many UPDATES that are impressive in this older home.<br /> 2021 UPGRADES: ROOF, Tankless Water Heater, Interior and Exterior Painted, Additional Septic and Drain Field, Toilets, Water Softener, Iron Filter (2022)<br /> Quartz Countertops 2023, NEW ceiling fans in every room, generator hook up, <br /> Five foot no-climb security fence around entire perimeter of the property with an electric remote/coded gate. Cross fenced to create your back yard oasis. The backyard boasts a 35 x 35 flagstone patio shaded by a huge oak tree and many tropical fruit trees including 3 Meyer lemons, Shibui oranges, key limes, finger limes, Calamondins, 2 banana trees, ponderosa lemons, Rangpur limes, 2 Barbados cherries, tangerines, Kaffir limes, Buddha lemons and troughs for raised bed gardens. You will also notice a wide variety of camellias, azaleas, roses, hydrangeas and many flowers for pollinators. There is also a small pool for hot afternoons providing everything you need to enjoy nature and to relax.<br /> You'll appreciate the 25 x 25 workshop/man cave with electrical service and the large carport featuring covered parking and the 8 x 20 greenhouse. Golf cart is included. Don't wait to see this gorgeous home and the beautiful property nestled among the sweeping trees and blooms.<br /> Step into a retreat like no other in this perfect place to call home!
MlsNumber: --
ListingId: G5087359


Listing Provided By: RE/MAX PREMIER REALTY, original listing
Phone: (321) 947-5120
Office Phone: (352) 461-0800
Agent Name: Denise Beserock
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 Rhonda Buckner
Rhonda Buckner
ASCIIBuckner Homes Realty
Call Today!: (352) 266-2637

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App