Title Page Background
DEBUG FN args: Array ( [0] => 3343 [1] => [2] => [3] => agent ) BEFORE: Site: 3343 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3343 Igate: njhud LocID: 3343 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3343 AND i.igate IN ('flhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3343 [1] => [2] => [3] => lender ) BEFORE: Site: 3343 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3343 Igate: njhud LocID: 3343 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3343 AND i.igate IN ('flhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3343 [1] => [2] => [3] => other ) BEFORE: Site: 3343 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3343 Igate: njhud LocID: 3343 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3343 AND i.igate IN ('flhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

771 Gran Kaymen Way
Apollo Beach, FL 33572

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $980,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2291 Square Feet
Agency: COLDWELL BANKER REALTY
Agency Phone: (727) 360-6927

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Townhouse
Year Built: 2023
Notes: Every now and then, a new community comes along that transcends the ordinary – one that distinguishes itself by virtue of a unique location, innovative architectural design and an amazing lifestyle. This is one of those rare times and special places. Welcome to SADYNE SUNRISE a modern coastal masterpiece located in Apollo Beach, FL, the Best Kept Secret in Tampa Bay. Set within the Tampa Bay region, an iconic development on the banks oF Tampa Bay with direct Gulf Access, SADYNE SUNRISE offers luxury living in a vibrant, diverse neighborhood setting. Limited to 8 exclusive Residences, these Coastal homes feature contemporary architecture and unparalleled quality of construction with spectacular waterfront sunset views. All Residents will enjoy waterfront living at it's best including 10k pound boat lift and dock just a short boat ride to world-class Beaches on the wide open waters of Tampa Bay and the Gulf of Mexico. Offering an outdoor rooftop terrace, and plenty of green space, the living environment is so perfect it will entice you to stay at home. There’s nothing quite like living on the water, especially when you can live it every day! At SADYNE SUNRISE , you can Enjoy direct deep-water access with fast, easy navigation to the Intracoastal Waterway and all of Tampa Bay. Contemporary Design, quality construction, stunning wide waterfront views, elevator, chefs Kitchen, stainless appliances, oversized pantry, split floor plan, custom flooring, oversized garage, storage, boat dock, roof terrace and so much more even the most discriminating buyer will be pleased. This Beautiful collection of luxurious three-story, 4-Bedroom with unique floor-plan designs from 2291 to 2396 square feet to choose from. Living at SADYNE SUNRISE brings all the pleasures of living on the water right to your doorstep. Offering a great location just 25 minutes to TIA airport and close to shopping and restaurants, this location has it all. A paradise for boaters and coastal living enthusiasts that enables residents to enjoy the unique charms and appeal of Tampa Bay every day. Isn’t this the lifestyle you promised yourself? . You will not be disappointed. Start living your best life at SADYNE SUNRISE today! Most Pictures display the model unit, and each unit is unique. inside unit colors, finishes and fixtures will vary from home to home. Call for a private tour today!
MlsNumber: --
ListingId: U8243703


Listing Provided By: COLDWELL BANKER REALTY, original listing
Phone: (727) 520-2737
Office Phone: (727) 360-6927
Agent Name: Donna Miller
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 Mortgage Pro

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => hillsborough-southeast [3] => FL [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: hillsborough-southeast State: FL Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: hillsborough-southeast State: FL Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3343 AND i.igate IN ('flhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) 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