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;

806 W Braddock Street
Tampa, FL 33603

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,250,000
Beds: 4
Baths: 3
Status: Pending
SqFt: 3075
Agency: Keller Williams South Tampa

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2023
Notes: Under contract-accepting backup offers. Unique craftsman style home in the heart of Riverside Heights! This home starts off with a welcoming front porch that spans the width of the home with a wood planked ceiling with ceiling fans. Coach lights flanking the front door and rain chains on the front corners of the house. The living areas of this home are extremely open and well-lit and have hardwood floors and stairs. The downstairs front office has a custom barn doors and a shiplap accented wall. A full bathroom is adjacent to the office making it practical to use the office as a guest suite. The dining and living rooms both have tray ceilings inlaid hardwood accents. The living room has a decorative faux fireplace on a wall accented with shiplap. This gourmet kitchen features 42” white shaker cabinets, large cooking island that seats four, quartz countertops, pendant lighting, ceramic tile backsplash, electric range, and large range hood. Off the kitchen is a galley style laundry room and butler pantry combo complete with gas dryer, beverage fridge, plenty of cabinetry with quartz countertops. The primary bedroom has a walk-in closet, shiplap accent wall behind the headboard, with a glass door leading to a cozy balcony. The primary bath features a long vanity with duel sinks, free standing tub, and a large shower with rain shower head. Double doors open from the living room to a large covered back porch with fans, wood planked ceiling, and plumbed for a gas grill. This leads to the detached garage with alleyway access. Other features include: Cat 6 wiring with fiber wiring to the house; gas water heater; 8’ doors; crown molding; under the stair storage; fully irrigated and landscaped yard. Come be a part of this historical & charming neighborhood with cobblestone streets. Minutes to downtown, Armature Works, and South Tampa.
MlsNumber: T3497360


Listing Provided By: Keller Williams South Tampa, original listing
Name: Keller Williams South Tampa
Phone: (813) 875-3700
Office Name: KELLER WILLIAMS SOUTH TAMPA
Office Phone: (813) 875-3700
Agent Name: Domingo Quintero, III
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