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

16982 Se Highway 42
Weirsdale, FL 32195
Amy Lord with HOMES TO RANCHES REALTY INC, original listing - (352) 732-3276

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,600,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 2462 Square Feet
Agency: HOMES TO RANCHES REALTY INC
Agency Phone: (352) 732-3276

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 13 acre(s)
Garage: Garage
Property Type: Residential-Farm
Year Built: 2014
Notes: Luxury Meets Nature: Stylish Florida Home with Private Orange Grove and Stunning Lake Views<br /> <br /> Enjoy the very best of southern living with this quintessential Florida home on 13.74 acres and overlooking a picturesque lake where a 10 lb., 9 oz. bass was caught just this spring! The fully landscaped and irrigated property includes a freshly painted lovely two-bedroom, two-bath home (2015) with 2,462 sq. ft. of living space, attached two-car garage, a Morton building with a one-bedroom apartment, and an in-ground pool with lanai--all surrounded by the private orange grove and fruit orchard. As you step up to the main home’s welcoming veranda and through its stately front entry, you’ll first notice the spacious open-concept split floorplan, gorgeous wood flooring, and elegant fireplace. But soon, you’ll see the space is enhanced by a soaring cupola lined with windows to bring in plenty of natural light. The kitchen boasts granite countertops, solid hickory cabinetry, an eat-in bar with pendant lighting, an island, a pantry, and stainless-steel appliances. With breathtaking views of the lake, the breakfast nook is the perfect place to enjoy your morning coffee. Next is the sizeable master bedroom with a walk-in closet and access to the pool/lanai. Its en suite master bath features a double-bowl sink, luxurious shower with glass enclosure and decorative tile accents, tub, linen closet, and water closet. Across the main living area, you’ll find a bonus room perfect for a home office or study with lake views, built-in desk, cabinetry, and architectural niches. Down the hallway is a second bedroom, also with pool access, and a guest bath with ample storage, lots of counter space, and a tiled shower with glass enclosure. There is also a convenient laundry room with cabinets, counter space, closet, and sink. From the main living area, the pool and lanai, both within a vast screened enclosure, are accessible through sliding glass doors. This capacious outdoor living space, accentuated by elegant design elements, provides an enticing private retreat. Entertain guests, enjoy leisurely poolside dinners, or just relax in the hot tub after a long day. A few of the extra items the sellers took in building this home are in-wall tubing for pest-control, no pressure wood was used at all and Icynene foam insulation in ceiling; As we moved to the outside, we follow the concrete driveway around to the 1890 square foot Morton building built in 2014, which boasts garage space for equipment, cars, toys, tools, and much more, an attractive 435 square foot one-bedroom apartment with kitchen and full bath, and a wraparound covered patio/carport. And if that’s not enough, some of the other great features of the property include: Two wells (one 5-inch & one 10-inch); a small, fenced side yard for the dogs; a pond loaded with koi; approximately 1,000 producing navel orange trees along with plum, peach, persimmon, and pear trees, and several yummy blueberry bushes. The location couldn’t be better. Just minutes from The Villages, with dining, shopping, entertainment, healthcare, recreation, and more.
MlsNumber: --
ListingId: OM679548


Listing Provided By: HOMES TO RANCHES REALTY INC, original listing
Phone: (352) 502-5855
Office Phone: (352) 732-3276
Agent Name: Amy Lord
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','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;
Real Estate Expert Photo for Amanda Grace Pozo, PA
Amanda Grace Pozo, PA
ASCIICentury 21 Carioti
Call Today!: (585) 545-9485

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App