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 = 0 AND i.igate IN ('usahud','nyhud','ushud') 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') 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;

132 81st Avenue N
St Petersburg, FL 33702

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $340,000
Beds: 2
Baths: 1
Status: Active
SqFt: 894
Agency: Star Bay Realty Corp

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1958
Notes: Move-In ready, stunning single family home in the PREMIER and highly desired RIVIERA BAY!! Sunny and breezy home features a large owners/main bedroom with a SPA-LIKE main bathroom showcasing a top notch design , Soaking tub and Rain-shower fixture , WOOOD touches, state of the art fixtures, as well as an elegant vanity. Second bedroom featuring large DESIGNER CLOSET space enclose by OVERZISE WOOD DOORS. Beautiful, high-end, waterproof LUX VINYL LAMINATE floors throughout. Living/dining room combo to enjoy those family and friends gatherings. STAINLESS STEEL appliances showcasing modern RANGE HOOD, KITCHEN ISLAND with TONS of cabinet storage. LED recessed Ceiling Downlight lights, not to mention tons of natural light coming from the SPACIOUS BACKYARD for your POOL IDEAS , parties, grilling, gardening and entertainment. On the outside, large backyard with space for those delightfull sunsets as well as those gardening creations.on the outside Spacious 2 CAR CARPOT and 4 car-size driveway!!. REMARKABLE CURVE APPEAL - PLUS great street parking on the quiet street in front for those additional guests. Home upgrades include insulated IMPACT RESISTAN WINDOWS and doors for energy savings AND SO MUCH MORE! All this located less 1 mile away from top notch restaurants and breweries. Minutes away from great beaches, nature parks, walking distance from shopping plazas, chain supermarkets, restaurants, gyms, shops, theaters and way much more! Do not miss this opportunity to be part of all what this gorgeous neighborhood has to offer and to be the ENVY of all your friends!
MlsNumber: T3498445


Listing Provided By: Star Bay Realty Corp, original listing
Name: Star Bay Realty Corp
Phone: (813) 533-6467
Office Name: STAR BAY REALTY CORP.
Office Phone: (813) 533-6467
Agent Name: Julian Arias
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