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;

1940 Hawaii Avenue Ne
Saint Petersburg, FL 33703
Sarah Howe with COMPASS FLORIDA LLC, original listing - (727) 339-7902

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $6,625,000
Beds: 4
Baths: Full: 5, ½: 1
Status: Active
SqFt: 5315 Square Feet
Agency: COMPASS FLORIDA LLC
Agency Phone: (727) 339-7902

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2025
Notes: Under Construction. Step inside this stunning house brought to life by Paragon Waterfront Properties. Each corner of this residence showcases a blend of style and functionality, creating a living experience that is truly one-of-a-kind. Step into innovative spaces that redefine what a home can be from the versatile game room and tranquil study to the inviting covered lanai and expansive loft, every detail has been thoughtfully executed. The grand great room serves as the heart of the home, offering a perfect blend of comfort and elegance. This home stands as a testament to extraordinary design, setting a new benchmark for luxury living in St. Pete. Embrace the opportunity to live in a space that is as unique as it is functional, far beyond the ordinary.<br /> <br /> Home Highlights: <br /> Deep protected water access and water views on Venetian Isles, St. Pete, FL, <br /> Expansive 5,315 square-foot layout, <br /> 4 bedrooms plus office / study, <br /> 5.5 bathrooms (his and hers water closet in primary bathroom,) <br /> 1,051 sqft of outdoor covered lanai space, <br /> Floor to ceiling windows in water facing rooms; great room, kitchen, den/study, primary bedroom, <br /> 12 ft ceiling height downstairs, 10 ft ceiling height on the second floor, extra high garage ceiling with 9 ft garage doors/ room for car lift<br /> Warm contemporary coastal design with custom features, <br /> White Oak hardwood flooring throughout, <br /> Grand entryway with a wooden oak staircase Private media room and owners lounge/ loft, <br /> Kitchen & Lighting Gallery provide top-of-the-line appliances, plumbing, and lighting solutions including Sub-Zero refrigerators, Wolf cooking appliances, and Cove dishwashers, washer and dryer downstairs and upstairs, <br /> Custom cabinetry, built-ins, wall details, and millwork. Each piece is crafted to perfection in a climate-controlled workspace, <br /> Exquisite quartzite, marble and travertine countertops throughout the home, providing elegance and durability in each room, <br /> Carefully curated selection of natural stone, quartz, and specialty slabs ensuring top-quality surfaces in every space, <br /> One of a kind tiles add texture and style throughout the home’s kitchen and bathrooms, <br /> House automation for alarm, AC systems, lights, blinds, music, etc., <br /> Gray slate roof, <br /> New seawall, dock and lift (24K lbs. fits 39ft boat,) <br /> Whole house generator,<br /> Completion Date - February. <br /> <br /> Featured Builder:<br /> Paragon Waterfront Properties is a premier custom home builder and renovator specializing in luxury waterfront homes in Florida. Renowned for their commitment to quality, innovation, and exquisite design, Paragon creates dream residences that harmonize with Florida’s scenic coastlines. With years of expertise in the luxury home building industry, they understand the unique challenges of coastal construction. Paragon works closely with homeowners to transform their visions into personalized living spaces that embody luxury, comfort, and sophistication. Their dedication to craftsmanship involves selecting premium materials, employing state-of-the-art construction techniques, and partnering with skilled artisans. www.paragonwaterfrontproperties.com<br /> <br /> Luxury Designer:<br /> Verve Design Verve Design Co is a luxury interior design firm based in central Florida, led by the award-winning sister duo Erin Nunnery and Keri Ferguson. Rooted in experience and driven by passion, Verve is sustained by the belief that every detail matters www.vervedesignco.com
MlsNumber: --
ListingId: TB8330307


Listing Provided By: COMPASS FLORIDA LLC, original listing
Phone: (813) 774-1999
Office Phone: (727) 339-7902
Agent Name: Sarah Howe
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;
Sandy Castles
ASCIICastles Real estate
Call Today!: (727) 459-7500

Local Mortgage Pro

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;
Real Estate Expert Photo for Joe Spellman NMLS# 2142845
Joe Spellman NMLS# 2142845
ASCIIFamily First Mortgage USA empowered by NEXA
Call Today!: (863) 559-8288

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App