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

6605 N Boulevard
Tampa, FL 33604

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,000,000
Beds: 2
Baths: 2
Status: Active
SqFt: 1224
Agency: Coastal Properties Group International, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1956
Notes: Welcome to an exceptional opportunity to own nearly ONE ACRE of paradise nestled along the HILLSBOROUGH RIVER, featuring approximately 222ft (MOL) of waterfront! Explore the potential for future development! This property offers a variety of possibilities for the discerning buyer. You could opt to retain the lot in its current state and revamp the existing home, or embark on the creation of a stunning, custom-designed residence with panoramic river views. The property could also offer the opportunity for the new owner to pursue options such as lot splitting or rezoning, subject to city approval. Should the new owner opt to subdivide the lot into two, this presents the opportunity to build two distinct homes. Additionally, there's the potential for rezoning and repurposing the property for multiple units. Interested buyers should conduct their own due diligence and follow city procedures for any desired changes. Nestled on this expansive lot, adorned with mature trees, is a serene 2-bedroom, 2-bath retreat. Ensconced in privacy, this sanctuary offers a tranquil escape from the hustle and bustle of city life. Step outside to immerse yourself in the sprawling outdoors, ideal for relaxation and introspection. With the property extending to the waterfront, endless outdoor adventures await. Consider your enjoyment with this waterfront lifestyle providing unparalleled access to the Hillsborough River and a gateway to Tampa Bay and the Gulf of Mexico! Experience the allure of secluded living while remaining just moments away from Tampa's vibrant shopping and dining scene. Located a mere 14 minutes from Armature Works and Downtown Tampa, Tampa General Hospital, and just 5 minutes from the interstate, shopping, and renowned restaurants, this property offers the perfect blend of tranquility and convenience. This isn't simply a home; it's a celebration of authentic Florida living. Please note that the current owner has a survey of the lot and in addition, has two surveys displaying the proposed two lots. The surveys have not been submitted to the Formal Decision Department but according to the department this property meets the lot size qualifications to apply for a Formal Decision for a lot split. As long as the lot meets the following: :The current RS-50 lot is 10,000sqft or more with a width of 100ft or more. When the lot is split the two new lots must be a minimum of 5,000sqft or more with a width of 50ft or more.
MlsNumber: T3519970


Listing Provided By: Coastal Properties Group International, LLC, original listing
Name: Coastal Properties Group International, LLC
Phone: (727) 493-1555
Office Name: COASTAL PROPERTIES GROUP INTERNATIONAL
Office Phone: (727) 493-1555
Agent Name: Natalie Wetherington
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