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 = 3194 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 = 3194 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 = 3194 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;

186 45th Avenue
St Pete Beach, FL 33706

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $798,000
Beds: 3
Baths: 3
Status: Active
SqFt: 1454
Agency: PinPoint Realty Group, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1956
Notes: Location, Location, Location! Newly Remodeled Beach Home in Quaint Lido Beach Neighborhood<br /> <br /> Don't miss the opportunity to own this newly remodeled 3-bedroom, 2.5-bath beach home in the rarely available and highly desired neighborhood of Lido Beach. Just one block from the Lido community's deeded access to the sugar sands and turquoise waters of St. Pete Beach, this home offers the ultimate beach lifestyle.<br /> <br /> The large living room with a dining "L" floor plan provides ample space for entertaining. The owner's bedroom suite features a spacious en-suite bathroom with a walk-in shower. The generously sized second bedroom and another full bathroom are located down the hall, while the family room and third bedroom are situated at the rear of the home, offering additional privacy and space.<br /> <br /> The fully fenced, private backyard is perfect for relaxation, featuring a covered hot tub and grill area. The easy-maintenance concrete tile roof, xeriscaped yard, accented with tropical plants, gives the home a delightful, homey feel. Recent updates include a new water heater, new electric panel, new kitchen with stainless steel appliances, new bathrooms, new flooring, new paint, new Trane AC, and new plantation shutters throughout—this home is like new!<br /> <br /> The Lido Beach subdivision offers a park, playground, and picnic pavilion, and is within walking distance to local grocery stores. Just one block away, cross Gulf Blvd to access the pristine white sandy beaches and the Gulf of Mexico. Don't feel like driving? Catch a ride on the Freebee shuttle or beach trolley to brunch at the famous Don Cesar Hotel, dinner at any of the fantastic beachside restaurants, or shopping on quaint Corey Ave.<br /> <br /> Ready to start living the beach life? Hurry, this home won’t last long! Call or click for a tour today! Be sure to check out the Walk thru video and the 3-D walk thru tour in the attached video links! Copy to share with others!
MlsNumber: T3530250


Listing Provided By: PinPoint Realty Group, LLC, original listing
Name: PinPoint Realty Group, LLC
Phone: (813) 501-6539
Office Name: PINPOINT REALTY GROUP LLC
Office Phone: (813) 501-6539
Agent Name: Thomas Settles
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 = 3194 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;
Real Estate Expert Photo for Dana Murdock
Dana Murdock
ASCIIEPIQUE REALTY, INC.
Call Today!: (727) 300-9257

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App