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

3510 N 9th Street
Tampa, FL 33605

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $308,900
Beds: 3
Baths: 1
Status: Pending
SqFt: 1015
Agency: Future Home Realty, Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1948
Notes: Under contract-accepting backup offers. Who says you can't have it all? Starting with its super Red Hot Ybor location, Updates, and Layout, this home also exudes extra mid-century Charm Galore. Completely remodeled with 3 bedrooms, den/sunroom/dining, open living room, beautiful kitchen, front porch, back covered lanai, one car attached garage, and the coveted double-sized 100x100 lot ... this home will impress! 1948 Ybor City Ranch Style in the Francis Subdivision boasts many bungalows and Victorian-styled dwellings right in the heart of all the rapid changes in the urban Tampa landscape. Located 5 minutes from Downtown, the Riverwalk, Channelside, Armature Works, Seminole Hts, Tampa Hts, and Ybor City, you can avoid all the traffic jams. This is the home your future self will thank you for (with a modest price now...think long-term $$$ gains as the city continues to grow and improve). I-275 is just a minute away for commuting (Floribraska or MLK exits), and access to the airport, I-4, and bridges to the beaches are just a few minutes away, too! The home features many upgrades, including a freshly painted interior, Custom Cabinets with Island, Marble Countertops, Professional Series Stainless Steel Appliances, Custom Fixtures, upgraded tile flooring in the kitchen/bath/den/dining area, real oak hardwood plank flooring, crown molding, 5 1/4" baseboards, upgraded interior doors, and hardware. The home also has a 2018 HVAC/Air-handler and a 2018 Roof! Other home features include block construction, an attached sizeable one-car garage with a washer and dryer hookup, a 15 x 10 covered lanai, and an oversized double lot, which is hard to come by!!! Available for a quick closing and easy to view, call for your appointment today! Measurements are approximate and are to be verified by the buyer. Please see 3D tour!
MlsNumber: T3512149


Listing Provided By: Future Home Realty, Inc, original listing
Name: Future Home Realty, Inc
Phone: (727) 409-3368
Office Name: FUTURE HOME REALTY INC
Office Phone: (813) 855-4982
Agent Name: Susan McGowan
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App