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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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;

6213 Spring Lake Circle
Zephyrhills, FL 33540

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $99,900
Beds: 2
Baths: 2
Status: Active
SqFt: 1248
Agency: J & N Mobile Home Sales dba Elite Mobile Home Sale

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Other
Year Built: 1991
Notes: Welcome to this 1991 Glen 2 bedroom/2 bath lake home! A beautiful home that has an inside laundry room! You have an open floor plan with a large open kitchen with plenty of cabinets and counterspace plus a kitchen window that overlooks the lake. Nice roomy dining room with a lighted built in hutch. A large open living room that has sliding glass door that leads into the sunroom that has a spectacular view of the entire lake. Absolutely gorgeous! Down the hallway on left you have a spacious guest bedroom big enough for a queen bed. The private guest bath in directly across hall. this bathroom also has an opening from the laundry room, so when you come back from pool you can change without tracking through main house! You have a large master bedroom fit for a king bedroom suit and other furnishings. It has a large walk-in closet. You have a large ensuite bath that has a nice garden tub for a long relaxing candle lit and glass of wine after a long day of shopping or a day at the beach! There is double vanities. a walk-in shower and the privy is private. You will enjoy this beautiful home on the lake beautiful views at night and especially at Christmas when everyone decorates because it has an great view of the entire lake. Plus you can fish from your own backyard for bass and trout!!! Forest Lake Estates is a 55 plus gated community with tons of activities to keep you busy year round. We have 2 pools, hot tub, huge shuffleboard, tennis courts, 18 holes of Putt-Putt, horseshoes, basketball. A 10.000 square foot clubhouse that has a billiards room with 3 pool tables, ping-pong and steel darts. we have dinner dances, card games, bingo, food trucks, too many activities to mention. We also have two fishing piers, sidewalks and two dog parks. Come check us out!!! You'll be glad you did!!
MlsNumber: 11261174


Listing Provided By: J & N Mobile Home Sales dba Elite Mobile Home Sale, original listing
Name: J & N Mobile Home Sales dba Elite Mobile Home Sale
Phone: (813) 517-0076
Office Name: Elite Mobile Home Sales
Office Phone: (813) 935-7700
Agent Name: Lola Webber
Disclaimer: Copyright © 2024 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App