Pre-Construction. To be built. PRE CONSTRUCTION RESERVATIONS ARE CURRENTLY BEING TAKEN FOR CLEARWATER BEACH’S NEWEST DEVELOPMENT. BAY HAVEN CONDOMINIUMS ARE SITUATED JUST NORTH OF THE CLEARWATER BEACH RECREATIONAL CENTER. THIS 16 UNIT DEVELOPMENT WILL BE ONE OF A HANDFUL OF PROPERTIES ON CLEARWATER BEACH WITH A ONE WEEK MINIMUM RENTAL. THIS OF COURSE WILL MAKE BAY HAVEN A VERY HIGHLY SOUGHT AFTER OPPORTUNITY. ANOTHER UNIQUE FEATURE THIS DEVELOPMENT OFFERS IS OWNERS WILL GET TWO UNDER BUILDING PARKING SPACES WITH THEIR PURCHASE. THE LOCATION IS CONVENIENTLY LOCATED ALONG A WIDE STRETCH OF THE INTRACOASTAL WATERWAY AND JUST STEPS FROM TRIP ADVISORY’S VOTED NUMBER 1 BEACH IN THE USA. WALK TO CLEARWATER BEACH’S MOST POPULAR RESTAURANTS AND RETAIL SHOPS IN MINUTES FROM YOUR NEW HOME.
Features
: Central
: Central Air
: Assigned, Under Building
: Public
: Public Sewer
: Other
: Carpet, Ceramic Tile
: Balcony
Appliances
: Other
Address Map
US
FL
Pinellas
Clearwater
MANDALAY UNIT 5 REP
33767
BAY ESPLANADE
64
W83° 10' 31.1''
N27° 59' 6.4''
401
33767 - Clearwater/Clearwater Beach
Highway 60 North (right) on Mandalay Avenue, turn right on Bay Esplanade
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4840
+post_id: "65863"
+post_author: 1
+"ListingKey": "MFR533060963"
+"ListingId": "U8071254"
+"PropertyType": "Residential"
+"PropertySubType": "Condominium"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2025-02-24T17:01:11Z"
+"RFModificationTimestamp": "2025-02-24T18:25:36.526670+00:00"
+"ListPrice": 850000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2020.0
+"BuildingAreaTotal": 0
+"City": "Clearwater"
+"PostalCode": "33767"
+"UnparsedAddress": "64 Bay Esplanade #401, Clearwater, Florida 33767"
+"Coordinates": array:2 [0 => -82.8247081 => 27.985111]
+"Latitude": 27.985111
+"Longitude": -82.824708
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Scott McNay"
+"ListOfficeName": "BHHS FLORIDA PROPERTIES GROUP"
+"ListAgentMlsId": "260011088"
+"ListOfficeMlsId": "260032839"
+"OriginatingSystemName": "Stellar"
+"PublicRemarks": "Pre-Construction. To be built. PRE CONSTRUCTION RESERVATIONS ARE CURRENTLY BEING TAKEN FOR CLEARWATER BEACH'S NEWEST DEVELOPMENT. BAY HAVEN CONDOMINIUMS ARE SITUATED JUST NORTH OF THE CLEARWATER BEACH RECREATIONAL CENTER. THIS 16 UNIT DEVELOPMENT WILL BE ONE OF A HANDFUL OF PROPERTIES ON CLEARWATER BEACH WITH A ONE WEEK MINIMUM RENTAL. THIS OF COURSE WILL MAKE BAY HAVEN A VERY HIGHLY SOUGHT AFTER OPPORTUNITY. ANOTHER UNIQUE FEATURE THIS DEVELOPMENT OFFERS IS OWNERS WILL GET TWO UNDER BUILDING PARKING SPACES WITH THEIR PURCHASE. THE LOCATION IS CONVENIENTLY LOCATED ALONG A WIDE STRETCH OF THE INTRACOASTAL WATERWAY AND JUST STEPS FROM TRIP ADVISORY'S VOTED NUMBER 1 BEACH IN THE USA. WALK TO CLEARWATER BEACH'S MOST POPULAR RESTAURANTS AND RETAIL SHOPS IN MINUTES FROM YOUR NEW HOME."
+"Appliances": array:1 [0 => "Other"
]
+"AssociationFeeIncludes": array:5 [0 => "Maintenance Grounds"
1 => "Pool"
2 => "Sewer"
3 => "Trash"
4 => "Water"
]
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"CommunityFeatures": array:1 [0 => "Pool"
]
+"ConstructionMaterials": array:2 [0 => "Block"
1 => "Stucco"
]
+"Cooling": array:1 [0 => "Central Air"
]
+"Country": "US"
+"CountyOrParish": "Pinellas"
+"CreationDate": "2024-01-10T19:32:53.270388+00:00"
+"CumulativeDaysOnMarket": 2
+"DaysOnMarket": 2
+"DirectionFaces": "South"
+"Directions": "Highway 60 North (right) on Mandalay Avenue, turn right on Bay Esplanade"
+"ExteriorFeatures": array:1 [0 => "Balcony"
]
+"Flooring": array:2 [0 => "Carpet"
1 => "Ceramic Tile"
]
+"FoundationDetails": array:1 [0 => "Slab"
]
+"Heating": array:1 [0 => "Central"
]
+"InteriorFeatures": array:1 [0 => "Other"
]
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [0 => "One"
]
+"ListAOR": "Pinellas Suncoast"
+"ListAgentAOR": "Pinellas Suncoast"
+"ListAgentDirectPhone": "727-461-1700"
+"ListAgentEmail": "scottmcnay@hotmail.com"
+"ListAgentFax": "727-467-4290"
+"ListAgentKey": "1068325"
+"ListAgentOfficePhoneExt": "7749"
+"ListAgentPager": "727-647-6533"
+"ListAgentURL": "http://thegulfliferealtygroup.com"
+"ListOfficeFax": "727-683-9312"
+"ListOfficeKey": "521930191"
+"ListOfficePhone": "727-461-1700"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2020-01-14"
+"ListingTerms": "Cash,Conventional"
+"LivingAreaSource": "Builder"
+"LotSizeAcres": 0.29
+"LotSizeSquareFeet": 12763
+"MLSAreaMajor": "33767 - Clearwater/Clearwater Beach"
+"MlgCanUse": array:1 [0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"NewConstructionYN": true
+"OffMarketDate": "2020-01-16"
+"OriginalEntryTimestamp": "2020-01-16T20:58:35Z"
+"OriginalListPrice": 850000
+"OriginatingSystemKey": "533060963"
+"Ownership": "Fee Simple"
+"ParcelNumber": "05-29-15-54756-079-0020-401"
+"ParkingFeatures": array:2 [0 => "Assigned"
1 => "Under Building"
]
+"PetsAllowed": array:1 [0 => "Yes"
]
+"PhotosChangeTimestamp": "2024-01-10T19:31:08Z"
+"PhotosCount": 8
+"PostalCodePlus4": "1608"
+"PropertyCondition": array:1 [0 => "Pre-Construction"
]
+"PublicSurveyRange": "15"
+"PublicSurveySection": "05"
+"PurchaseContractDate": "2020-01-16"
+"Roof": array:1 [0 => "Metal"
]
+"Sewer": array:1 [0 => "Public Sewer"
]
+"ShowingRequirements": array:1 [0 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [0 => "None"
]
+"StateOrProvince": "FL"
+"StatusChangeTimestamp": "2020-01-16T21:01:26Z"
+"StoriesTotal": "6"
+"StreetName": "BAY ESPLANADE"
+"StreetNumber": "64"
+"SubdivisionName": "MANDALAY UNIT 5 REP"
+"TaxAnnualAmount": "33937.08"
+"TaxBlock": "79"
+"TaxBookNumber": "20-48"
+"TaxLegalDescription": "MANDALAY UNIT NO. 5 REPLAT BLK 79, THAT PART OF LOT 2 LYING N OF REV LAYOUT OF CLEARWATER ST & LOT 3 AS DESC IN PL 20 PG 27"
+"TaxLot": "2"
+"TaxYear": "2021"
+"Township": "29"
+"UnitNumber": "401"
+"UniversalPropertyId": "US-12103-N-052915547560790020401-S-401"
+"Utilities": array:1 [0 => "Public"
]
+"View": "Water"
+"VirtualTourURLUnbranded": "https://www.propertypanorama.com/instaview/stellar/U8071254"
+"WaterSource": array:1 [0 => "Public"
]
+"MFR_CDDYN": "0"
+"MFR_DPRYN": "0"
+"MFR_DPRURL": "https://www.workforce-resource.com/dpr/listing/MFRMLS/U8071254?w=Agent&skip_sso=true"
+"MFR_SDEOYN": "0"
+"MFR_DPRURL2": "https://www.workforce-resource.com/dpr/listing/MFRMLS/U8071254?w=Customer"
+"MFR_CondoFees": "800"
+"MFR_RoomCount": "6"
+"MFR_WaterView": "Gulf/Ocean - Partial,Intracoastal Waterway"
+"MFR_FloorNumber": "4"
+"MFR_HomesteadYN": "0"
+"MFR_WaterViewYN": "1"
+"MFR_CurrentPrice": "850000.00"
+"MFR_MaxPetWeight": "60"
+"MFR_MinimumLease": "1 Week"
+"MFR_TotalAcreage": "Non-Applicable"
+"MFR_UnitNumberYN": "0"
+"MFR_CondoFeesTerm": "Monthly"
+"MFR_FloodZoneCode": "AE"
+"MFR_FloodZoneDate": "2003-09-03"
+"MFR_WaterAccessYN": "0"
+"MFR_WaterExtrasYN": "0"
+"MFR_ContractStatus": "Other Contract Contingencies"
+"MFR_FloodZonePanel": "12103C0102G"
+"MFR_PreviousStatus": "Active"
+"MFR_PetRestrictions": "Pet restrictions subject to change"
+"MFR_TotalAnnualFees": "9600.00"
+"MFR_LivingAreaMeters": "187.66"
+"MFR_TotalMonthlyFees": "800.00"
+"MFR_AttributionContact": "727-461-1700"
+"MFR_BackupsRequestedYN": "0"
+"MFR_BuildingElevatorYN": "1"
+"MFR_BuildingNameNumber": "NA"
+"MFR_PublicRemarksAgent": "PRE CONSTRUCTION RESERVATIONS ARE CURRENTLY BEING TAKEN FOR CLEARWATER BEACH'S NEWEST DEVELOPMENT. BAY HAVEN CONDOMINIUMS ARE SITUATED JUST NORTH OF THE CLEARWATER BEACH RECREATIONAL CENTER. THIS 16 UNIT DEVELOPMENT WILL BE ONE OF A HANDFUL OF PROPERTIES ON CLEARWATER BEACH WITH A ONE WEEK MINIMUM RENTAL. THIS OF COURSE WILL MAKE BAY HAVEN A VERY HIGHLY SOUGHT AFTER OPPORTUNITY. ANOTHER UNIQUE FEATURE THIS DEVELOPMENT OFFERS IS OWNERS WILL GET TWO UNDER BUILDING PARKING SPACES WITH THEIR PURCHASE. THE LOCATION IS CONVENIENTLY LOCATED ALONG A WIDE STRETCH OF THE INTRACOASTAL WATERWAY AND JUST STEPS FROM TRIP ADVISORY'S VOTED NUMBER 1 BEACH IN THE USA. WALK TO CLEARWATER BEACH'S MOST POPULAR RESTAURANTS AND RETAIL SHOPS IN MINUTES FROM YOUR NEW HOME."
+"MFR_AvailableForLeaseYN": "1"
+"MFR_CondoLandIncludedYN": "1"
+"MFR_ExpectedClosingDate": "2025-12-31T00:00:00.000"
+"MFR_LeaseRestrictionsYN": "1"
+"MFR_LotSizeSquareMeters": "1186"
+"MFR_WaterfrontFeetTotal": "0"
+"MFR_MonthlyCondoFeeAmount": "800"
+"MFR_ShowingConsiderations": "Under Construction"
+"MFR_OriginatingSystemName_": "Stellar MLS"
+"MFR_ProjectedCompletionDate": "2023-12-31T00:00:00.000"
+"MFR_ListOfficeContactPreferred": "727-461-1700"
+"MFR_AdditionalLeaseRestrictions": "Lease restrictions subject to change, however 1 week minimum lease is confirmed"
+"MFR_MontlyMaintAmtAdditionToHOA": "0"
+"MFR_AssociationApprovalRequiredYN": "0"
+"MFR_YrsOfOwnerPriorToLeasingReqYN": "0"
+"MFR_ListOfficeHeadOfficeKeyNumeric": "1056269"
+"MFR_CommunityAssociationWaterFeatures": "Waterfront"
+"MFR_CalculatedListPriceByCalculatedSqFt": "420.79"
+"MFR_RATIO_CurrentPrice_By_CalculatedSqFt": "420.79"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MFR533060963')"
+"provider_name": "Stellar"
+"Media": array:8 [0 => array:12 [
"Order" => 0
"MediaKey" => "5e20ceac8296a26ce696968a"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/a008b6bd838d301c876f5561a2ad593e.jpg"
"MediaSize" => 88343
"MediaType" => "jpg"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/thumbnail-a008b6bd838d301c876f5561a2ad593e.jpg"
"ImageWidth" => 1024
"ImageHeight" => 550
"LongDescription" => "="
"ResourceRecordKey" => "MFR533060963"
"ImageSizeDescription" => "1024x550"
"MediaModificationTimestamp" => "2020-01-16T20:59:24.744Z"
]
1 => array:12 [
"Order" => 1
"MediaKey" => "5e20ceac8296a26ce696968b"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/7705ad4f1038f9f532965665fbcc5b21.jpg"
"MediaSize" => 90218
"MediaType" => "jpg"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/thumbnail-7705ad4f1038f9f532965665fbcc5b21.jpg"
"ImageWidth" => 1024
"ImageHeight" => 662
"LongDescription" => "="
"ResourceRecordKey" => "MFR533060963"
"ImageSizeDescription" => "1024x662"
"MediaModificationTimestamp" => "2020-01-16T20:59:24.822Z"
]
2 => array:12 [
"Order" => 2
"MediaKey" => "5e20ceac8296a26ce696968c"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/2dff296f1e07688aa13816f45ad97e4b.jpg"
"MediaSize" => 51499
"MediaType" => "jpg"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/thumbnail-2dff296f1e07688aa13816f45ad97e4b.jpg"
"ImageWidth" => 590
"ImageHeight" => 768
"LongDescription" => "="
"ResourceRecordKey" => "MFR533060963"
"ImageSizeDescription" => "590x768"
"MediaModificationTimestamp" => "2020-01-16T20:59:24.773Z"
]
3 => array:12 [
"Order" => 3
"MediaKey" => "5e20ceac8296a26ce696968d"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/2dd03e681b66278ff88b2bb8f7df36a7.jpg"
"MediaSize" => 163126
"MediaType" => "jpg"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/thumbnail-2dd03e681b66278ff88b2bb8f7df36a7.jpg"
"ImageWidth" => 1024
"ImageHeight" => 764
"LongDescription" => "="
"ResourceRecordKey" => "MFR533060963"
"ImageSizeDescription" => "1024x764"
"MediaModificationTimestamp" => "2020-01-16T20:59:24.799Z"
]
4 => array:12 [
"Order" => 4
"MediaKey" => "5e20ceea07b153759e583677"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/62c20f3d2fdcf295dbeef3160b5c2394.jpg"
"MediaSize" => 105554
"MediaType" => "jpg"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/thumbnail-62c20f3d2fdcf295dbeef3160b5c2394.jpg"
"ImageWidth" => 1024
"ImageHeight" => 763
"LongDescription" => "="
"ResourceRecordKey" => "MFR533060963"
"ImageSizeDescription" => "1024x763"
"MediaModificationTimestamp" => "2020-01-16T21:00:26.753Z"
]
5 => array:12 [
"Order" => 5
"MediaKey" => "5e20ceea07b153759e583678"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/bd42419802d017341ba685f59ba41505.jpg"
"MediaSize" => 109855
"MediaType" => "jpg"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/thumbnail-bd42419802d017341ba685f59ba41505.jpg"
"ImageWidth" => 1024
"ImageHeight" => 762
"LongDescription" => "="
"ResourceRecordKey" => "MFR533060963"
"ImageSizeDescription" => "1024x762"
"MediaModificationTimestamp" => "2020-01-16T21:00:26.763Z"
]
6 => array:12 [
"Order" => 6
"MediaKey" => "5e20ceac8296a26ce696968f"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/9e6413d1cf1d31138f7ab72a9e54eb0b.jpg"
"MediaSize" => 100134
"MediaType" => "jpg"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/thumbnail-9e6413d1cf1d31138f7ab72a9e54eb0b.jpg"
"ImageWidth" => 1024
"ImageHeight" => 664
"LongDescription" => "="
"ResourceRecordKey" => "MFR533060963"
"ImageSizeDescription" => "1024x664"
"MediaModificationTimestamp" => "2020-01-16T20:59:24.784Z"
]
7 => array:12 [
"Order" => 7
"MediaKey" => "5e39e459f59bec69a1d6588e"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/0e08f0a580d4bc91cedf746ebc22215f.jpg"
"MediaSize" => 71074
"MediaType" => "jpg"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/thumbnail-0e08f0a580d4bc91cedf746ebc22215f.jpg"
"ImageWidth" => 988
"ImageHeight" => 768
"LongDescription" => "="
"ResourceRecordKey" => "MFR533060963"
"ImageSizeDescription" => "988x768"
"MediaModificationTimestamp" => "2020-02-04T21:38:33.700Z"
]
]
+"ID": "65863"
}
MLS On The Fly Debug Panel
array:1 [
"RF Query: /Property?$select=ALL&$top=20&$filter=(StandardStatus in ('Active','Pending') and PropertyType eq 'Residential') and ListingKey eq 'MFR533060963'/Property?$select=ALL&$top=20&$filter=(StandardStatus in ('Active','Pending') and PropertyType eq 'Residential') and ListingKey eq 'MFR533060963'&$expand=Media/Property?$select=ALL&$top=20&$filter=(StandardStatus in ('Active','Pending') and PropertyType eq 'Residential') and ListingKey eq 'MFR533060963'/Property?$select=ALL&$top=20&$filter=(StandardStatus in ('Active','Pending') and PropertyType eq 'Residential') and ListingKey eq 'MFR533060963'&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4838
+items: array:1 [0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4840
+post_id: "65863"
+post_author: 1
+"ListingKey": "MFR533060963"
+"ListingId": "U8071254"
+"PropertyType": "Residential"
+"PropertySubType": "Condominium"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2025-02-24T17:01:11Z"
+"RFModificationTimestamp": "2025-02-24T18:25:36.526670+00:00"
+"ListPrice": 850000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2020.0
+"BuildingAreaTotal": 0
+"City": "Clearwater"
+"PostalCode": "33767"
+"UnparsedAddress": "64 Bay Esplanade #401, Clearwater, Florida 33767"
+"Coordinates": array:2 [0 => -82.8247081 => 27.985111]
+"Latitude": 27.985111
+"Longitude": -82.824708
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Scott McNay"
+"ListOfficeName": "BHHS FLORIDA PROPERTIES GROUP"
+"ListAgentMlsId": "260011088"
+"ListOfficeMlsId": "260032839"
+"OriginatingSystemName": "Stellar"
+"PublicRemarks": "Pre-Construction. To be built. PRE CONSTRUCTION RESERVATIONS ARE CURRENTLY BEING TAKEN FOR CLEARWATER BEACH'S NEWEST DEVELOPMENT. BAY HAVEN CONDOMINIUMS ARE SITUATED JUST NORTH OF THE CLEARWATER BEACH RECREATIONAL CENTER. THIS 16 UNIT DEVELOPMENT WILL BE ONE OF A HANDFUL OF PROPERTIES ON CLEARWATER BEACH WITH A ONE WEEK MINIMUM RENTAL. THIS OF COURSE WILL MAKE BAY HAVEN A VERY HIGHLY SOUGHT AFTER OPPORTUNITY. ANOTHER UNIQUE FEATURE THIS DEVELOPMENT OFFERS IS OWNERS WILL GET TWO UNDER BUILDING PARKING SPACES WITH THEIR PURCHASE. THE LOCATION IS CONVENIENTLY LOCATED ALONG A WIDE STRETCH OF THE INTRACOASTAL WATERWAY AND JUST STEPS FROM TRIP ADVISORY'S VOTED NUMBER 1 BEACH IN THE USA. WALK TO CLEARWATER BEACH'S MOST POPULAR RESTAURANTS AND RETAIL SHOPS IN MINUTES FROM YOUR NEW HOME."
+"Appliances": array:1 [0 => "Other"
]
+"AssociationFeeIncludes": array:5 [0 => "Maintenance Grounds"
1 => "Pool"
2 => "Sewer"
3 => "Trash"
4 => "Water"
]
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"CommunityFeatures": array:1 [0 => "Pool"
]
+"ConstructionMaterials": array:2 [0 => "Block"
1 => "Stucco"
]
+"Cooling": array:1 [0 => "Central Air"
]
+"Country": "US"
+"CountyOrParish": "Pinellas"
+"CreationDate": "2024-01-10T19:32:53.270388+00:00"
+"CumulativeDaysOnMarket": 2
+"DaysOnMarket": 2
+"DirectionFaces": "South"
+"Directions": "Highway 60 North (right) on Mandalay Avenue, turn right on Bay Esplanade"
+"ExteriorFeatures": array:1 [0 => "Balcony"
]
+"Flooring": array:2 [0 => "Carpet"
1 => "Ceramic Tile"
]
+"FoundationDetails": array:1 [0 => "Slab"
]
+"Heating": array:1 [0 => "Central"
]
+"InteriorFeatures": array:1 [0 => "Other"
]
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [0 => "One"
]
+"ListAOR": "Pinellas Suncoast"
+"ListAgentAOR": "Pinellas Suncoast"
+"ListAgentDirectPhone": "727-461-1700"
+"ListAgentEmail": "scottmcnay@hotmail.com"
+"ListAgentFax": "727-467-4290"
+"ListAgentKey": "1068325"
+"ListAgentOfficePhoneExt": "7749"
+"ListAgentPager": "727-647-6533"
+"ListAgentURL": "http://thegulfliferealtygroup.com"
+"ListOfficeFax": "727-683-9312"
+"ListOfficeKey": "521930191"
+"ListOfficePhone": "727-461-1700"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2020-01-14"
+"ListingTerms": "Cash,Conventional"
+"LivingAreaSource": "Builder"
+"LotSizeAcres": 0.29
+"LotSizeSquareFeet": 12763
+"MLSAreaMajor": "33767 - Clearwater/Clearwater Beach"
+"MlgCanUse": array:1 [0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"NewConstructionYN": true
+"OffMarketDate": "2020-01-16"
+"OriginalEntryTimestamp": "2020-01-16T20:58:35Z"
+"OriginalListPrice": 850000
+"OriginatingSystemKey": "533060963"
+"Ownership": "Fee Simple"
+"ParcelNumber": "05-29-15-54756-079-0020-401"
+"ParkingFeatures": array:2 [0 => "Assigned"
1 => "Under Building"
]
+"PetsAllowed": array:1 [0 => "Yes"
]
+"PhotosChangeTimestamp": "2024-01-10T19:31:08Z"
+"PhotosCount": 8
+"PostalCodePlus4": "1608"
+"PropertyCondition": array:1 [0 => "Pre-Construction"
]
+"PublicSurveyRange": "15"
+"PublicSurveySection": "05"
+"PurchaseContractDate": "2020-01-16"
+"Roof": array:1 [0 => "Metal"
]
+"Sewer": array:1 [0 => "Public Sewer"
]
+"ShowingRequirements": array:1 [0 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [0 => "None"
]
+"StateOrProvince": "FL"
+"StatusChangeTimestamp": "2020-01-16T21:01:26Z"
+"StoriesTotal": "6"
+"StreetName": "BAY ESPLANADE"
+"StreetNumber": "64"
+"SubdivisionName": "MANDALAY UNIT 5 REP"
+"TaxAnnualAmount": "33937.08"
+"TaxBlock": "79"
+"TaxBookNumber": "20-48"
+"TaxLegalDescription": "MANDALAY UNIT NO. 5 REPLAT BLK 79, THAT PART OF LOT 2 LYING N OF REV LAYOUT OF CLEARWATER ST & LOT 3 AS DESC IN PL 20 PG 27"
+"TaxLot": "2"
+"TaxYear": "2021"
+"Township": "29"
+"UnitNumber": "401"
+"UniversalPropertyId": "US-12103-N-052915547560790020401-S-401"
+"Utilities": array:1 [0 => "Public"
]
+"View": "Water"
+"VirtualTourURLUnbranded": "https://www.propertypanorama.com/instaview/stellar/U8071254"
+"WaterSource": array:1 [0 => "Public"
]
+"MFR_CDDYN": "0"
+"MFR_DPRYN": "0"
+"MFR_DPRURL": "https://www.workforce-resource.com/dpr/listing/MFRMLS/U8071254?w=Agent&skip_sso=true"
+"MFR_SDEOYN": "0"
+"MFR_DPRURL2": "https://www.workforce-resource.com/dpr/listing/MFRMLS/U8071254?w=Customer"
+"MFR_CondoFees": "800"
+"MFR_RoomCount": "6"
+"MFR_WaterView": "Gulf/Ocean - Partial,Intracoastal Waterway"
+"MFR_FloorNumber": "4"
+"MFR_HomesteadYN": "0"
+"MFR_WaterViewYN": "1"
+"MFR_CurrentPrice": "850000.00"
+"MFR_MaxPetWeight": "60"
+"MFR_MinimumLease": "1 Week"
+"MFR_TotalAcreage": "Non-Applicable"
+"MFR_UnitNumberYN": "0"
+"MFR_CondoFeesTerm": "Monthly"
+"MFR_FloodZoneCode": "AE"
+"MFR_FloodZoneDate": "2003-09-03"
+"MFR_WaterAccessYN": "0"
+"MFR_WaterExtrasYN": "0"
+"MFR_ContractStatus": "Other Contract Contingencies"
+"MFR_FloodZonePanel": "12103C0102G"
+"MFR_PreviousStatus": "Active"
+"MFR_PetRestrictions": "Pet restrictions subject to change"
+"MFR_TotalAnnualFees": "9600.00"
+"MFR_LivingAreaMeters": "187.66"
+"MFR_TotalMonthlyFees": "800.00"
+"MFR_AttributionContact": "727-461-1700"
+"MFR_BackupsRequestedYN": "0"
+"MFR_BuildingElevatorYN": "1"
+"MFR_BuildingNameNumber": "NA"
+"MFR_PublicRemarksAgent": "PRE CONSTRUCTION RESERVATIONS ARE CURRENTLY BEING TAKEN FOR CLEARWATER BEACH'S NEWEST DEVELOPMENT. BAY HAVEN CONDOMINIUMS ARE SITUATED JUST NORTH OF THE CLEARWATER BEACH RECREATIONAL CENTER. THIS 16 UNIT DEVELOPMENT WILL BE ONE OF A HANDFUL OF PROPERTIES ON CLEARWATER BEACH WITH A ONE WEEK MINIMUM RENTAL. THIS OF COURSE WILL MAKE BAY HAVEN A VERY HIGHLY SOUGHT AFTER OPPORTUNITY. ANOTHER UNIQUE FEATURE THIS DEVELOPMENT OFFERS IS OWNERS WILL GET TWO UNDER BUILDING PARKING SPACES WITH THEIR PURCHASE. THE LOCATION IS CONVENIENTLY LOCATED ALONG A WIDE STRETCH OF THE INTRACOASTAL WATERWAY AND JUST STEPS FROM TRIP ADVISORY'S VOTED NUMBER 1 BEACH IN THE USA. WALK TO CLEARWATER BEACH'S MOST POPULAR RESTAURANTS AND RETAIL SHOPS IN MINUTES FROM YOUR NEW HOME."
+"MFR_AvailableForLeaseYN": "1"
+"MFR_CondoLandIncludedYN": "1"
+"MFR_ExpectedClosingDate": "2025-12-31T00:00:00.000"
+"MFR_LeaseRestrictionsYN": "1"
+"MFR_LotSizeSquareMeters": "1186"
+"MFR_WaterfrontFeetTotal": "0"
+"MFR_MonthlyCondoFeeAmount": "800"
+"MFR_ShowingConsiderations": "Under Construction"
+"MFR_OriginatingSystemName_": "Stellar MLS"
+"MFR_ProjectedCompletionDate": "2023-12-31T00:00:00.000"
+"MFR_ListOfficeContactPreferred": "727-461-1700"
+"MFR_AdditionalLeaseRestrictions": "Lease restrictions subject to change, however 1 week minimum lease is confirmed"
+"MFR_MontlyMaintAmtAdditionToHOA": "0"
+"MFR_AssociationApprovalRequiredYN": "0"
+"MFR_YrsOfOwnerPriorToLeasingReqYN": "0"
+"MFR_ListOfficeHeadOfficeKeyNumeric": "1056269"
+"MFR_CommunityAssociationWaterFeatures": "Waterfront"
+"MFR_CalculatedListPriceByCalculatedSqFt": "420.79"
+"MFR_RATIO_CurrentPrice_By_CalculatedSqFt": "420.79"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MFR533060963')"
+"provider_name": "Stellar"
+"Media": array:8 [0 => array:12 [
"Order" => 0
"MediaKey" => "5e20ceac8296a26ce696968a"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/a008b6bd838d301c876f5561a2ad593e.jpg"
"MediaSize" => 88343
"MediaType" => "jpg"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/thumbnail-a008b6bd838d301c876f5561a2ad593e.jpg"
"ImageWidth" => 1024
"ImageHeight" => 550
"LongDescription" => "="
"ResourceRecordKey" => "MFR533060963"
"ImageSizeDescription" => "1024x550"
"MediaModificationTimestamp" => "2020-01-16T20:59:24.744Z"
]
1 => array:12 [
"Order" => 1
"MediaKey" => "5e20ceac8296a26ce696968b"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/7705ad4f1038f9f532965665fbcc5b21.jpg"
"MediaSize" => 90218
"MediaType" => "jpg"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/thumbnail-7705ad4f1038f9f532965665fbcc5b21.jpg"
"ImageWidth" => 1024
"ImageHeight" => 662
"LongDescription" => "="
"ResourceRecordKey" => "MFR533060963"
"ImageSizeDescription" => "1024x662"
"MediaModificationTimestamp" => "2020-01-16T20:59:24.822Z"
]
2 => array:12 [
"Order" => 2
"MediaKey" => "5e20ceac8296a26ce696968c"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/2dff296f1e07688aa13816f45ad97e4b.jpg"
"MediaSize" => 51499
"MediaType" => "jpg"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/thumbnail-2dff296f1e07688aa13816f45ad97e4b.jpg"
"ImageWidth" => 590
"ImageHeight" => 768
"LongDescription" => "="
"ResourceRecordKey" => "MFR533060963"
"ImageSizeDescription" => "590x768"
"MediaModificationTimestamp" => "2020-01-16T20:59:24.773Z"
]
3 => array:12 [
"Order" => 3
"MediaKey" => "5e20ceac8296a26ce696968d"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/2dd03e681b66278ff88b2bb8f7df36a7.jpg"
"MediaSize" => 163126
"MediaType" => "jpg"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/thumbnail-2dd03e681b66278ff88b2bb8f7df36a7.jpg"
"ImageWidth" => 1024
"ImageHeight" => 764
"LongDescription" => "="
"ResourceRecordKey" => "MFR533060963"
"ImageSizeDescription" => "1024x764"
"MediaModificationTimestamp" => "2020-01-16T20:59:24.799Z"
]
4 => array:12 [
"Order" => 4
"MediaKey" => "5e20ceea07b153759e583677"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/62c20f3d2fdcf295dbeef3160b5c2394.jpg"
"MediaSize" => 105554
"MediaType" => "jpg"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/thumbnail-62c20f3d2fdcf295dbeef3160b5c2394.jpg"
"ImageWidth" => 1024
"ImageHeight" => 763
"LongDescription" => "="
"ResourceRecordKey" => "MFR533060963"
"ImageSizeDescription" => "1024x763"
"MediaModificationTimestamp" => "2020-01-16T21:00:26.753Z"
]
5 => array:12 [
"Order" => 5
"MediaKey" => "5e20ceea07b153759e583678"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/bd42419802d017341ba685f59ba41505.jpg"
"MediaSize" => 109855
"MediaType" => "jpg"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/thumbnail-bd42419802d017341ba685f59ba41505.jpg"
"ImageWidth" => 1024
"ImageHeight" => 762
"LongDescription" => "="
"ResourceRecordKey" => "MFR533060963"
"ImageSizeDescription" => "1024x762"
"MediaModificationTimestamp" => "2020-01-16T21:00:26.763Z"
]
6 => array:12 [
"Order" => 6
"MediaKey" => "5e20ceac8296a26ce696968f"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/9e6413d1cf1d31138f7ab72a9e54eb0b.jpg"
"MediaSize" => 100134
"MediaType" => "jpg"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/thumbnail-9e6413d1cf1d31138f7ab72a9e54eb0b.jpg"
"ImageWidth" => 1024
"ImageHeight" => 664
"LongDescription" => "="
"ResourceRecordKey" => "MFR533060963"
"ImageSizeDescription" => "1024x664"
"MediaModificationTimestamp" => "2020-01-16T20:59:24.784Z"
]
7 => array:12 [
"Order" => 7
"MediaKey" => "5e39e459f59bec69a1d6588e"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/0e08f0a580d4bc91cedf746ebc22215f.jpg"
"MediaSize" => 71074
"MediaType" => "jpg"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR533060963/thumbnail-0e08f0a580d4bc91cedf746ebc22215f.jpg"
"ImageWidth" => 988
"ImageHeight" => 768
"LongDescription" => "="
"ResourceRecordKey" => "MFR533060963"
"ImageSizeDescription" => "988x768"
"MediaModificationTimestamp" => "2020-02-04T21:38:33.700Z"
]
]
+"ID": "65863"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
]
MLS On The Fly Debug Panel
[Deprecated] Optional parameter $select declared before required parameter $condition is implicitly treated as a required parameter in /home/holidaymain/public_html/wp-content/plugins/real-estate-listing-realtyna-wpl-pro/libraries/addon_sms.php on line 100
[Warning] Undefined array key "energy_tag" in /home/holidaymain/public_html/wp-content/plugins/real-estate-listing-realtyna-wpl-pro/views/activities/energy_tag/tmpl/default.php on line 17
