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

905 S Palm Drive
Largo, FL 33770

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $550,000
Beds: 3
Baths: 3
Status: Active
SqFt: 1638
Agency: TAMPA BAY RENTAL SOLUTIONS

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1957
Notes: PREPARE TO BE AWESTRUCK BY THE DESIGNER TOUCHES FOUND THROUGHOUT THIS STUNNING HOME THAT GO BEYOND THE 2021 KITCHEN CABINET UPDATES AND QUARTZ COUNTERS! 2023 ROOF, 2018 HVAC, stunningly remodeled bathroom, high tray ceilings, shiplap accents, updated fixtures, lighting, updated panel door hardware throughout and more! (Be sure to look at the feature and upgrade sheet) FLOOD ZONE X WITH NO FLOOD INSURANCE REQUIRED! The beauty of the tropical low maintence yard will have you spending more time enjoying sitting around the fire pit than working in the yard! That's right—the green lawn is actually artificial turf, and the established plants and monkeypod tree require very little attention. This is one of the few homes on the market at this price point that will captivate your attention at every turn as you imagine yourself living your best life within a short drive to award-winning Florida beaches, nature parks, and preserves. For outdoor exercise enthusiasts, there is plenty of opportunity to hop right on the Pinellas Trail which for miles of adrenaline-producing adventures. Largo is a short-term rental friendly community for those looking to subsidize a second home purchase or add to their investment portfolio! If you enjoy outdoor entertaining, there is a 1/4 bathroom located in the spacious heated/cooled utility room in the garage to cut down on traffic through the home. Desire a fourth bedroom? Take advantage of the den to create space for that special someone! Set up your private tour today in order to fully appreciate all that this home has to offer!<br /> <br /> Experience the digital walk through at https://www.youtube.com/embed/TJLdh_bkM0k?si=y_nbVWm-fb18ivUP
MlsNumber: U8238204


Listing Provided By: TAMPA BAY RENTAL SOLUTIONS, original listing
Name: TAMPA BAY RENTAL SOLUTIONS
Phone: (727) 400-6990
Office Name: RE/MAX ACTION FIRST OF FLORIDA
Office Phone: (727) 531-2006
Agent Name: Denver Goodman
Disclaimer: Copyright © 2024 Pinellas Suncoast Association of REALTORS ®, Inc. 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