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

301 Windrush Loop
Tarpon Springs, FL 34689

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $344,700
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1060 Square Feet
Agency: Engel & Völkers St. Pete
Agency Phone: (727) 295-0000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Other-Single Family Residence
Year Built: 1985
Notes: Location, Location, Location! Tranquil Oasis and Florida living at its finest, this is what this little gem will provide. Located between Sunset Beach and Fred Howard Park, this is the Florida lifestyle you've been longing for. Just a short walk to the Gulf with breathtaking views! Take in the sunset from a gazebo or boardwalk -or- take a dip in the pool to cool off or relax in the Jacuzzi to wind down. Get the best of both worlds in this standalone corner lot villa that offers both privacy and maintenance free living. Relax and take in the sights and sounds of nature. You are close to restaurants in historic downtown Tarpon Springs and the famous Sponge Docks, renowned for Greek culture, restaurants and gift shops. Enjoy the wonderful bayous and don't miss First Friday! Walk or bike the Pinellas County Trail or go on a sunset boat ride. Live like a Vacationer! All ages are welcome. Small pets allowed. No flood insurance required. This standalone villa offers a spacious floor plan for easy Florida living. Large chefs kitchen with solid Brazilian cherry wood cabinets, stainless steel appliances, and granite countertops. Crown molding throughout the home, an extra large Florida room for year round indoor/outdoor living. Both bathrooms feature walk-in showers for ease of use and grab bars for safety. The Villa features many new updates and improvements both inside and out, including a new roof, HVAC, water heater, ceiling fans, all done in the past 2-3 years. There is an added outside patio with new pavers for additional outdoor living. Windrush is a planned community situated on a private peninsula, offering relaxed modern waterfront living nestled away from the congestion of city life in Tarpon Springs, Florida. This is Florida Living at its finest. Make this your new home and start living the good life at Windrush! Take the 3D tour by clicking on the virtual tour link or just click here: https://www.zillow.com/view-imx/710a4987-c434-4702-9150-bc926e8c6ca1?setAttribution=mls&wl=true&initialViewType=pano&utm_source=dashboard
MlsNumber: --
ListingId: U8249157


Listing Provided By: Engel & Völkers St. Pete, original listing
Phone: (727) 295-0000
Office Phone: (727) 295-0000
Agent Name: John Suleiman
Disclaimer: Copyright © 2024 Engel & Völkers. 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 = 375 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;
Stephanie Goode
ASCIIColdwell Banker Realty
Call Today!: (727) 501-6225

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App