Title Page Background
DEBUG FN args: Array ( [0] => 352 [1] => [2] => [3] => agent ) BEFORE: Site: 352 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 352 Igate: njhud LocID: 352 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 = 352 AND i.igate IN ('flhud','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 = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 352 [1] => [2] => [3] => lender ) BEFORE: Site: 352 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 352 Igate: njhud LocID: 352 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 = 352 AND i.igate IN ('flhud','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 = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 352 [1] => [2] => [3] => other ) BEFORE: Site: 352 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 352 Igate: njhud LocID: 352 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 = 352 AND i.igate IN ('flhud','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 = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

3111 Lewis Road
Dover, FL 33527
CJ Cornett with BAYSIDE REALTY GROUP INC, original listing - (813) 634-0900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $788,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2524 Square Feet
Agency: BAYSIDE REALTY GROUP INC
Agency Phone: (813) 634-0900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1993
Notes: Jeffrey-Built Home with NINE ACRES and Direct LAKE FRONTAGE on Stearns Lake! Welcome to this extraordinary property offering nine acres of land, over 300 feet of lake frontage, and endless opportunities! This unique compound includes a three-bedroom, two-bath home, a 19-run air-conditioned dog kennel, and a one-stall horse barn with a tack room—all nestled in a serene, no HOA, no CDD -This spacious 2,552 sq. ft. single-level home boasts an inviting open floor plan with cathedral ceilings, a wood-burning fireplace, and breathtaking views of Stearns Lake. Master Suite: A tranquil retreat featuring a large walk-in closet and serene lake views. The en-suite bath includes dual vanities, a garden tub, and a separate walk-in shower. Kitchen: Bright and functional with ample cabinet space, a breakfast nook, and an open flow to the family room, perfect for entertaining. Living Spaces: Formal dining room, a large bonus room with panoramic lake views, and a cozy enclosed porch for year-round enjoyment. Additional Bedrooms: Two spacious rooms offering flexibility and comfort. Exterior and Land: The property sits on a gorgeous lakefront lot with nearly 33 acres of Stearns Lake. Enjoy over 300 feet of private lake frontage with endless possibilities—build your dream dock, launch your small electric trolling boat, or simply soak in the stunning sunsets. Outdoor Living: A huge private fenced backyard invites you to relax, host BBQs, or enjoy evenings by the lake. Additional Features: Two-car garage, covered carport, and a well/septic system Kennel and Barn:19-Run Dog Kennel: Fully equipped with air conditioning, running water, a grooming area, and its own private fenced yard. Perfect for a home business, boarding facility, or grooming center with significant income potential. Horse Barn: Includes one stall and a tack room, ideal for horse lovers or additional storage. Updates: Roof: Approximately 6 years old. A/C System: Approximately 4 years old. Location: Situated on a quiet dead-end street, this property provides a peaceful sanctuary while still being close to everything! Convenience: Minutes from Downtown Tampa, MacDill AFB, major highways (HWY 60, I-75, I-275, I-4, Selmon Expressway), Tampa International Airport, shopping, schools, golf courses, and restaurants. From the moment you arrive, you’ll feel the peace and tranquility of this stunning lakefront property. Whether you’re seeking a personal sanctuary, an investment opportunity, or a combination of both, this home has it all. Call today for your private tour of this one-of-a-kind home! Front door does not convey and will be replaced with similar door. Measurements are approximate buyer to verify.
MlsNumber: --
ListingId: TB8326905


Listing Provided By: BAYSIDE REALTY GROUP INC, original listing
Phone: (813) 629-0248
Office Phone: (813) 634-0900
Agent Name: CJ Cornett
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] => hillsborough-northeast [3] => FL [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: hillsborough-northeast State: FL Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: hillsborough-northeast 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 = 352 AND i.igate IN ('flhud','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 = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Stephanie Floyd
Stephanie Floyd
ASCIIGoldsmith Property Solutions
Call Today!: (813) 598-2451

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App