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 = 3427 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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 = 3427 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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 = 3427 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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;

5677 Gardens Drive
Sarasota, FL 34243

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $250,000
Beds: 2
Baths: 2
Status: Active
SqFt: 1068
Agency: Charles Rutenberg Realty, Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1985
Notes: Wow, talk about a fantastic view! Stunning views of the swimming pool and lake make this condo a must see. This maintenance-free two bedroom/two bathroom first story condo located in The Gardens of Palm-Aire is perfect for year-round or seasonal Florida living. This beautifully decorated two bedroom/ two bathroom condo boasts 1,068 sf of living enjoyment conveniently located in The Gardens subdivision of The Palm Aire Golf and Country Club (membership is not mandatory). Pride of ownership is apparent when you enter this condo where furnishings are included for buyers convenience.  Featuring tile flooring though main living area, Jeldwen Interior Doors, complete A/C System replaced in 2022 with Honeywell Touchscreen WI-FI Programmable Thermostat and newer Hot Water Heater with water shut-off valves. Open living room and dining room plan with pass through from Kitchen for easy serving. Large Master walk in closet with an in unit laundry. Screened lanai with Ceramic tile makes it ideal for enjoying the Florida weather. Perfect for year round or Seasonal living. Just steps to the Heated Pool,Tennis Courts, Clubhouse and the Shuffleboard court all in a Golf Course Community. Friendly pet policy allowing for one small dog or cat up to 20lbs. Units can also be rented subject to the condo Association rental policy. Asphalt paved driveways in 2022', Tile Roofs in 2014' and Building Painting in 2016' have been completed with no assessments. Close to the University Town Center Mall for abundant shopping, restaurants, entertainment and medical facilities plus 15 minutes to the famous Gulf Beaches. Easy access to I-75. Great location, great community. Just North of University Parkway with easy access to the interstate makes it conveniently close to shopping/dining at University Town Center, downtown Sarasota, St. Armond’s Circle, and the famous soft-sand beaches of Siesta, Lido, and Longboat Key. Great community in a great location. Schedule your showing today.
MlsNumber: U8225129


Listing Provided By: Charles Rutenberg Realty, Inc, original listing
Name: Charles Rutenberg Realty, Inc
Phone: (727) 538-9200
Office Name: CHARLES RUTENBERG REALTY INC
Office Phone: (727) 538-9200
Agent Name: John Nowicki
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

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 = 3427 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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 Shelbie Deatrick
Shelbie Deatrick
ASCIIColdwell Banker Realty
Call Today!: (520) 548-5608

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App