Title Page Background
DEBUG FN args: Array ( [0] => 3236 [1] => [2] => [3] => agent ) BEFORE: Site: 3236 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3236 Igate: njhud LocID: 3236 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3236 AND i.igate IN ('azhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3236 [1] => [2] => [3] => lender ) BEFORE: Site: 3236 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3236 Igate: njhud LocID: 3236 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3236 AND i.igate IN ('azhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3236 [1] => [2] => [3] => other ) BEFORE: Site: 3236 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3236 Igate: njhud LocID: 3236 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3236 AND i.igate IN ('azhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

1335 Dean Street
Mulberry, FL 33860
Renee Perry with FUTURE HOME REALTY INC, original listing - (813) 855-4982

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $489,900
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1941 Square Feet
Agency: FUTURE HOME REALTY INC
Agency Phone: (813) 855-4982

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1974
Notes: WOW! Completely renovated 2 MASTER SUITES PLUS OVERSIZED 3rd Bedroom on 5 ACRES with NO DEED RESTRICTIONS home is turn-key ready to be your HOME! From the Brand-new Luxury Vinyl flooring to the NEW ROOF Trusses, 650+ FEET OF EXTERIOR DRAINAGE, NEW HVAC DUCT WORK, NEW GOURMET KITCHEN, NEW A/C, NEW BARN (2023) NEW APPLIANCES including CONVECTION OVEN, BUILT-IN MICROWAVE, NEW MASTER BATHROOM, NEW DRYWALL, NEW ELECTRICAL WIRING +POWER PANEL NEW HOT TUB PUMP, NEW SEPTIC GRINDER PUMP (equipped for RV hookup) NEW WELL Pump/TANK, BRAND NEW Quartz 11 foot kitchen ISLAND, NEW CEILING FANS, NEW CUSTOM OVERSIZED CLOSETS, NEW RHEEM WATER HEATER {5 year NEW ROOF} the list is ENDLESS! This REMARKABLE property will check every box! Bring your RV, BOAT, HORSES, CHICKENS, whatever you wish for, NO HOA but don't forget your HAMMOCK to enjoy the absolute serenity you will appreciate, especially when the CREEK RIVER water is flowing, pure BLISS! The front covered porch is over 43 FEET long leading through the NEW Glass etched Front Door into the 21 x 11 FOOT KITCHEN complete with SOFT CLOSE Doors|Drawers, Kohler Designer Faucet with Glacier Bay Extended Farm Sink, POT FILLING STATION, Stainless Steel Hood, EXTENDED BREAKFAST BAR will accommodate 6+. Beautifully appointed LIVING ROOM splits this floorplan. The PRIMARY SUITE offers NEW Recessed Lighting, Ceiling Fan, Tray Ceiling with En-Suite Bathroom equipped for Two! Double Stone Vanity, WALK-IN TILED SHOWER, NEW TILED FLOOR that leads to the MASSIVELY OVERSIZED WALK-IN CUSTOM CLOSET! Laundry station is convenient with plenty of room for additional Storage! The second Primary Bedroom is HUGE! Offering a private fully equipped Bathroom including TUB/Shower Combination, completely renovated with oversized custom walk-in closet; All professionally designed! The 3rd OVERSIZED bedroom includes CROWN MOLDING, Designer wainscotting, CUSTOM WALK-IN extended Closet, ceiling fan & beautiful country views! The backyard is completely fenced with a Spa Gazebo outbuilding, plenty of room for Plants, Patio Setting or BBQ area. Beyond the extended gate the RED BARN is brand new along with the covered Pole Barn and over 4.5 ACRES of PRIVATE MATURE OAKS, lots of wildlife including Deer, Turkeys and even fish within the River stream. This property is zoned for Horses and the entire property is partially fenced. Great School Zone, Willow Oak Elementary and Newly rebuilt Mulberry High School. LOCATION is just off State Road 60/Brandon Blvd, convenient to Tampa, Lakeland, Brandon, Valrico, I-4 and so much more! Don't miss this rare opportunity to find a true essence of country living at an affordable price!
MlsNumber: --
ListingId: T3529316


Listing Provided By: FUTURE HOME REALTY INC, original listing
Phone: (954) 448-8485
Office Phone: (813) 855-4982
Agent Name: Renee Perry
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => polk-south [3] => FL [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: polk-south State: FL Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: polk-south State: FL Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3236 AND i.igate IN ('azhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Susan Brown
Susan Brown
ASCIIColdwell Banker Realty
Call Today!: (863) 640-5722

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App