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;

101 18th Avenue N
St Petersburg, FL 33704

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,395,000
Beds: 5
Baths: 5
Status: Active
SqFt: 3910
Agency: Keller Williams St. Pete Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2024
Notes: Under Construction. Canopy Builders New Construction (Estimated Completion in December 2024) in The Historic Old Northeast Neighborhood with Detached Accessory Dwelling Unit Over Garage, Pool and Spa! Located on an Oversized Corner Lot (75' x 127') within Steps to Coffee Pot Bayou, 4th St, Coffee Pot Park, Boat Ramp, Sunken Gardens, Restaurants and Shops; This Single Family Residence Offers 4 Bedrooms + Study, 3 Full Bathrooms, Upstairs Loft and Dedicated Mudroom in the Main House (3,293 Living SF), and a One (1) Bedroom Accessory Dwelling Unit (617 Living SF) with Kitchen, Separate Bathroom & Laundry Room Above a Detached 2 Car Garage (25'x25'). No Expense has Been Spared with this New Build Which Boasts Hardie Plank Siding, Impact Resistant Windows, Fireplace, Outdoor Kitchen, 10' Ceilings on the Main Level & 9' Ceilings on the 2nd Level, Dedicated Laundry Room on 2nd Level with Expansive Cabinetry, Pantry, Wrap-Around Front Porch and Large Covered Rear Porch. Thoughtfully Selected Finishes have been Hand Picked by Lauren Leitner Design, and Include the Following: Engineered Hardwood Flooring, 8' Shaker Style Interior Doors, Spacious Island with Calacatta Marble Counters, Thermador Appliances, Designer Lighting Fixtures, Calacatta Marble Backsplash, 48" Free-Standing Natural Gas Range, Apron Kitchen Sink, Designer Hardware, Gas Tankless Water Heater, Pavered Front Porch & Front Walkway, Natural Gas Sconces, Numerous Built-In's, Multiple Trim Accents and So Much More. The Spacious, Master Suite is a True Retreat, and Offers Two Large Walk-In Closets, Double Sink Vanity, Free-Standing Tub and Walk-In Shower. Located on a High & Dry, Non-Flood Zone Lot Within Minutes to Booming Downtown St. Petersburg, I-275 and the Gulf Beaches. Come and View This Home Today and Move In Before the End of the Year!
MlsNumber: U8228958


Listing Provided By: Keller Williams St. Pete Realty, original listing
Name: Keller Williams St. Pete Realty
Phone: (727) 894-1600
Office Name: KELLER WILLIAMS ST PETE REALTY
Office Phone: (727) 894-1600
Agent Name: Zach Zehnder
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