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

6650 Berkley Road
Polk City, FL 33868
Selah Bell with HARPER REALTY FL, LLC, original listing - (863) 687-8020

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,499,900
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 5493 Square Feet
Agency: HARPER REALTY FL, LLC
Agency Phone: (877) 277-8808

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: WELCOME TO YOUR METICULOUSLY MAINTAINED ONE OWNER ESTATE SITUATED ON 5.10 ACRES. The luxury experience begins with the gorgeous electric aluminum entrance gate. This home boasts 5 bedrooms, 5 1/2 bathrooms 7881 Sq Ft under roof with 5493 Sq Ft of living area. The main house has 3 large bedrooms and 3 ½ bathrooms. The kitchen is thoughtfully laid out with beautiful cabinetry, granite, Kitchen Aid and Bosch stainless steel appliances, cooktop in the island and eating space off the kitchen with a full walk-in pantry. Off the kitchen is the living room with a large stone gas fireplace and wood cabinetry/bookshelves lining the entire wall. Upstairs could be another bedroom, man cave, home office it has 1/2 bath, bar, sink and counter.There are endless possibilities for this multi-purpose room. The Expansive master suite has beautiful hardwood flooring, a dream-worthy walk-in closet, a large soaking tub with architectural columns for treating yourself to a well-deserved relaxing spa evening and a walk-in tile shower. The formal Living room has tray ceilings and beautiful architectural columns. No worries about having to share a bathroom with guests. Your guest or family members will like having their own bathroom in each bedroom. You also get a totally separate attached Second Home it isn't your ordinary studio sized guest space. The guest house is complete with two large bedrooms, two bathrooms, fully functioning kitchen, living room, dining room, laundry, single car garage and screened patio. There has been a newer metal roof installed on the entire estate. Your oasis awaits in the backyard with the custom-built crystal-clear swimming pool with paver decking and vinyl privacy fencing. When you're not enjoying yourself in your personal sanctuary home, you can explore all of your hobbies in the 2 story 2200 sf (50 x 44) workshop/barn. This space can hold all of your toys, animals or both. It includes 3 separate stalls with roll up doors and is tall enough for your RV to include the electrical hookup. It has a full functioning upstairs that is 705 sq ft. The garden shed is equipped with a sink and water hookup for all your landscaping needs. There is so much about this home you must see it to appreciate. Scrupulously designed, this palatial estate sets the tone for the best of entertaining and home ownership. Don’t let this rare opportunity pass you by. Call for your private showing today.
MlsNumber: --
ListingId: L4947785


Listing Provided By: HARPER REALTY FL, LLC, original listing
Phone: (863) 581-3699
Office Phone: (863) 687-8020
Agent Name: Selah Bell
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 = 376 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 Laura Medina-Ruiz
Laura Medina-Ruiz
ASCIIKeller Williams Realty Smart 1
Call Today!: (863) 207-4784

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App