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

106 Alameda Court
Tampa, FL 33609

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $265,000
Beds: 2
Baths: 1
Status: Pending
SqFt: 864
Agency: Mainframe Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1970
Notes: Under contract-accepting backup offers. Welcome to your new coastal oasis in the heart of Beach Park! This stunning 2-bedroom, 1-bathroom condominium offers the perfect blend of comfort, convenience, and resort-style living. Step into the bright and airy open floor plan, where natural light floods the space, creating an inviting ambiance throughout.<br /> <br /> Prepare to be impressed by the modern touches in the updated bathroom, adding a touch of luxury to your daily routine. In-unit laundry ensures convenience, while large walk-in closets provide ample storage space for all your belongings.<br /> <br /> Nestled within a gated community, enjoy peace of mind and security, along with access to a host of amenities including a sparkling community pool, fitness center, and clubhouse. Take a leisurely stroll through the meticulously landscaped grounds or pamper your car with the convenient car wash station.<br /> <br /> For your furry friends, a dedicated dog park awaits, offering the perfect space for them to play and socialize. With pool bathrooms on-site, you can spend endless hours soaking up the Florida sunshine without interruption.<br /> <br /> Located just moments away from shopping, dining, and entertainment options, everything you need is right at your fingertips. Plus, with easy access to Tampa International Airport and the Howard Frankland Bridge to St. Petersburg, traveling is a breeze.<br /> <br /> Don't miss out on this move-in ready gem – schedule your showing today and start living the beachside lifestyle!<br /> <br /> Major Mechanics: HVAC - 2016, Hot Water Heater - 2016, W/D - 2015, Stove - 2022<br /> Roof Assessment: Sellers will pay off $10,000 roof assessment in full at closing!
MlsNumber: U8237784


Listing Provided By: Mainframe Real Estate, original listing
Name: Mainframe Real Estate
Phone: (407) 513-4257
Office Name: MAINFRAME REAL ESTATE
Office Phone: (727) 350-7727
Agent Name: Alex Clark
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