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

502 Hillside Court
Brandon, FL 33510

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $425,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1528
Agency: International Realty Plus-Tampa Bay

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1974
Notes: STOP THE CAR! This home offers country living, in the middle of town. It has what you've been looking for-the freedom from the CDD and HOA fees and scrutiny you dislike, but give you the lifestyle, modern features, location, and space you love. Get ready to be impressed by the stunning transformation of this 3-bedroom, 2-bath, 2-car garage nestled on a fenced-in 1/3-acre lot. Bid farewell to old iron pipes. This home has a whole-house water supply re-pipe with new Pex A plumbing, guaranteeing the cleanest drinking water around. Step inside, and you will immediately notice the absence of carpet. Instead, revel in the luxurious ceramic tile & luxury vinyl flooring throughout. The kitchen has been redesigned with culinary enthusiasts in mind, featuring top-of-the-line LG stainless steel appliances under warranty, new all-wood cabinets, dazzling quartz countertops & even a dedicated coffee bar. The enhancements do not end there. The interior has been freshly painted, including the door handles & hinges. All new Faux wood Blinds recently installed also. <br /> The exterior boasts a fresh look akin to a new home, thanks to the addition of all-new fascia & soffit, and a dimensional shingle roof with a transferrable warranty. Indoors, discover new outlets, switches, interior doors & a new Rheem Pro hot water heater.<br /> The Master bedroom is a massive 24x14 giving you room for a King-sized bed, sitting area, and a study area! The renovated bathrooms showcase brand-new wood vanities, quartz countertops, fixtures, & a lighted mirror in Master bath equipped with touch control options.<br /> Outside, a newly installed wood fence encircles the 1/3 acre property, ensuring both privacy & security. The backyard is a third acre and is ready for you to place your boat, RV pad, outside storage, workshop, work trucks or whatever your lifestyle needs. Situated conveniently near Brandon Mall, I-75, I-4 & I-275, with no HOA or CDD fees, this property welcomes your Boat, Trailer, or RV!<br /> Do not let this Opportunity slip away - Submit your offer Today! Please feel free to check out the 3D Matterport attached to this Listing.
MlsNumber: T3520628


Listing Provided By: International Realty Plus-Tampa Bay, original listing
Name: International Realty Plus-Tampa Bay
Phone: (813) 629-6954
Office Name: INTL. REALTY PLUS-TAMPA BAY
Office Phone: (813) 629-6954
Agent Name: Tamra Wondrow
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 = 352 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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;
Angela Royster & Lauren Batcho
ASCIIAR Realty
Call Today!: (813) 484-9330

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App