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

3212 Lighthouse Way
Spring Hill, FL 34607

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $114,999
Beds: 2
Baths: 2
Status: Active
SqFt: 1104
Agency: Sun Realty of Florida

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1988
Notes: 2 Bedroom - 2 Bath - 1988 - 1104 sq ft - Mobile Home in the Premier 55+ Community Park of Windward Village in Spring Hill. Monthly Fee is $806.64 and includes: Trash, Lawn, Cable, Internet, Activities and Amenities. Two 30lb Pet Policy. Must Get Park Approval Before Purchasing Home. Home will come with some Furnishings and a Complete List will be discussed at the time of Closing. Beautiful Home Located Right Across from the Club House! New Metal Roof in 2022. One Car Covered Carport with Driveway. Covered Patio. Freshly Painted with Soft Neutral Colors. Gray Laminate Flooring, Light Colored Carpeting in Livingroom and Bedrooms is 2 years old. A/C is a year old. Double Pane Windows. Front Door Walkway Welcomes you Home with a Landscaped Stone Bed! Step up into your Den/Sitting Room with Large/Medium Sized Windows and Screen Door for tons of Natural Lighting! Living Room is Spacious with Cathedral Ceiling and Large Window. Dining Room seats a Table for four comfortably with Built in Hutch. Hutch has Back Lighting, Glass Doors, Drawers and Lower Cabinet Storage with New Knobs/Pulls. Chandelier. Kitchen has Upper/Lower Cabinets, Bay Window with Decorative Shelf, Pantry Cabinets, New Cabinet/Drawer Pull/Knobs and Garbage Disposal. Off the Kitchen/Dining Area is your Sunroom with Tinted Vinyl Windows, Slider Door and Screen Door Access to your Carport. Wood Deck with Stairs takes you down to your landscaped Side Walk to the Shed. Shed is Deep, Lighted, has Upper Shelves and a Small Window. Back inside down the Hallway is your Laundry Closet with Upper Cabinets, Washer/Dryer and Mirrored Doors which gives the Hallway a Bright Feel. Main Bedroom is Large with two Windows, En-suite Bathroom and Lighted Deep Walk in Closet. En-suite Bathroom has a Walk in Shower with Glass Doors & Safety Bar, Toilet has all New Components, Floor to Ceiling Linen Cabinetry, Vanity/Sink, and Window. Guest Bedroom has Large Window with a Deep Lighted Walk in Closet. Hall Bathroom has a Tub/Shower combo, Safety Bar, Small Window, Vanity Sink, New Chair Height Toilet and plenty of Wall Space for Towel Rods/Decor. Window Treatments are Vertical Blinds. Sprinkler System. Gutters. Stone Skirting. Lamp Post (Front Yard). Schedule Today to Take a Tour of This Home! About the Park and Area: Windward Village offers its residents a Spacious Clubhouse Complete with Billiard Tables, Exercise Equipment, Community Library, Kitchen, Recreation Room, Heated Swimming Pool/Hot Tub, Shuffleboard Courts, and a Brand New Cook Out Area with Grill and Firepit Over Looking the Lake! Club House also offers WiFi, a Variety of Activities/Social Events such as Movie Night, Bingo, Potluck Suppers and Craft Hour. Professional and Courteous Onsite Management and Maintenance. Spring Hill has tons of Shopping Plazas, Dining, State-of-the-Art Healthcare Facilities, 2 Theatres, 2 Bowling Ally's, Pine Island Beach, SunWest Park, and Weeki Wachee Springs State Park! Weeki Wachee Springs State Park is less than five minutes from the community. The major metropolitan area of Tampa-St. Pete is just one hour's drive from Windward Village with plenty of things to see and do, including Major League Sporting Events, Busch Gardens Theme Park, and the Sponge Docks of Tarpon Springs. Walt Disney World, Universal Studios Orlando, and SeaWorld are a two hour drive away! Oak Hill Hospital (5 miles)- Bayfront Health (15 miles)- James A. Haley Veterans Hospital (50 miles).
MlsNumber: 11250528


Listing Provided By: Sun Realty of Florida, original listing
Name: Sun Realty of Florida
Phone: (813) 603-8474
Office Name: Sun Realty of Florida
Office Phone: (813) 867-4759
Agent Name: Darrin Mercer
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.


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 = 350 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 Carlos Nunez & Adam Brandt
Carlos Nunez & Adam Brandt
ASCIIBerkshire Hathaway HomeServices Florida Properties Group
Call Today!: (413) 454-3287

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App