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','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 = 352 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 = 352 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;

1803 Tawnee Place
Brandon, FL 33510
Michelle Chenault with COLDWELL BANKER REALTY, original listing - (727) 581-9411

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $539,700
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 2250 Square Feet
Agency: COLDWELL BANKER REALTY
Agency Phone: (727) 581-9411

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1988
Notes: Welcome to your POOL home located on a.35-acre lot nestled on a quiet cul-de-sac in this community conveniently located in Brandon. When you arrive, you will be greeted by easy care landscaping. Once you pass through the grand covered entryway, the home is bright and open with plenty of natural light and has been recently painted. There is a formal dining room immediately to your right with easy-to-clean tile floors, and the living room with its waterproof/scuff-proof wood laminate flooring is straight ahead with a large wall-sized slider that leads to the enclosed porch leading the back yard and pool. The open kitchen has newer appliances and beautifully refreshed cabinets and counter tops, which offers plenty of storage and work space, a breakfast bar, and a separate eating space. The kitchen opens to the spacious great room, where you can cozy up by the wood-burning fireplace on chilly evenings or enjoy entertaining friends and family, with a large slider to the outside porch area. The bedrooms are split for privacy, and the owner’s retreat offers its own private sliding door to the back porch and an en-suite bathroom with a dual sink vanity, a large walk-in shower, and a soaking tub.. The second bedroom is on the side of the home and would be a great office or nursery. On the other side of the home are 2 nice-sized bedrooms and a second bath with a tub. This home has had many upgrades, including a new roof (December 2021), solar panels (2022 ), newer kitchen appliances, Refreshed cabinets and counters throughout, a Water conditioner and softener system, and a whole-house Generac system (2023), which is run by Propane. The garage is large and has a Mini-split A/C unit which allows for storage or can use it as a man cave or entertainment room for your family. You will love to entertain on the enclosed porch area with ceiling fans to keep you cool, or take a dip in the sparkling, screened-in swimming pool with a gorgeous deck. The backyard is fully fenced and has a shed for extra storage. The yard boasts plenty of gardening opportunities and lots of space for family activities. Lakeview Village is a quiet, deed-restricted community that is conveniently located near I-75, I-4, and the Selmon Expressway. The community borders Lake Mango, a 66-acre competitive ski lake, as well as about 20 acres of privately owned land
MlsNumber: --
ListingId: TB8342162


Listing Provided By: COLDWELL BANKER REALTY, original listing
Phone: (727) 481-5700
Office Phone: (727) 581-9411
Agent Name: Michelle Chenault
Disclaimer: Copyright © 2025 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