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;

4944 Emerson Avenue S
Saint Petersburg, FL 33707

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $629,999
Beds: 4
Baths: 2
Status: Pending
SqFt: 2174
Agency: Lipply Real Estate Company

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1925
Notes: Under contract-accepting backup offers. Have you ever wanted to own a piece of history? This 99-year old Spanish Revival home is a historical masterpiece right in the heart of the Sunshine City. This distinguished residence leaves no stone unturned when it comes to customization and elegance. Every square inch of this home has been thoughtfully curated to maintain its original historical and architectural significance. The home is approximately 45 ft. above sea level. Come through the front gate and pass a massive bird of paradise on your right. Step inside onto real wood floors and soak in every last detail. The tiles embedded in the original fireplace tell the story of Christopher Columbus' journey across the blue. Your new kitchen is a chef's dream with an ILVE stove imported from Italy, a custom travertine stone sink, handmade custom Spanish Colonial cabinets, a 3-inch Amish butcher block countertop and travertine stone at your feet. Upstairs, the story continues where you'll find your primary bedroom, additional bedroom, and second bathroom with deep-blue tilework in the shower. You'll also find an office and a custom-built shelving unit that pulls out into a closet. Back downstairs, through the dining room and den are French doors leading to the wooden deck and pergola in the tranquil backyard that was installed in 2023. The mature landscaping in this little slice of paradise includes butterfly plants and an assortment of vegetation that the local ecosystem has come to thrive on. Included with the home are two storage sheds. The 380 sq ft. detached building can be converted into an in-law suite or serve as a headquarters for your hobbies, new business venture, or more storage; electrical and plumbing already connected. The driveway behind the home fits 2 cars and backs up to a quiet alley. Enjoy your included gas grill on a sunny day and pamper your best friend at the custom dog wash station around the side. Just 15 minutes away from Downtown St. Pete and everything the city has to offer, this home is in a prime location for anyone looking to enjoy their life in Florida. As with anywhere in our beautiful county, you are just minutes from some of the highest rated beaches in North America. If you ever wanted to live in a house that will be one to remember, your search is over.
MlsNumber: U8240180


Listing Provided By: Lipply Real Estate Company, original listing
Name: Lipply Real Estate Company
Phone: (727) 459-7290
Office Name: LIPPLY REAL ESTATE
Office Phone: (727) 314-1000
Agent Name: Adnian Rakanovic
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