The home is priced at land value. The improvements have little if any value. The home was flooded during hurricane Helene. No remediation has been completed. Next door and nearby, homes are being raised or razed to create multi-story homes above the flood line. Incredible views of a cove just off the Gulf Intracoastal Waterway. The 65 feet of waterfront allows for larger yachts to be parked behind the home. If you have always dreamed of a waterfront home on the Pinellas County beaches, this is your opportunity to purchase the lot for that home at a modest price. The seller has requested that all buyers submit their highest and best by 11:59 pm on 4/10/2025.
Features
: Central
: Central Air
: Wood
: Wood Burning, Living Room
: Rear Porch, Deck, Porch, Enclosed
: Intracoastal Waterway
: BB/HS Internet Available, Electricity Available, Water Available, Cable Available, Public
: Public Sewer
: In Garage
: Eat-in Kitchen, Primary Bedroom Main Floor
: Carpet, Tile, Terrazzo
: Other
: Ranch
Appliances
: None
Address Map
US
FL
Pinellas
Redington Beach
33708
REDINGTON
15507
DRIVE
W83° 11' 41.6''
N27° 48' 25.6''
33708 - St Pete/Madeira Bch/N Redington Bch/Shores
Gulf Blvd to Redington Beach to 155th St to Redington Drive to 15507 Redington Dr.
North
Neighborhood
Bauder Elementary-PN
Seminole High-PN
Seminole Middle-PN
Additional Info
ENGEL & VOLKERS BELLEAIR
Irwin Wilensky
Sqft0
Sqft0
Additional Information
65x140
: Public
1
754100
2025-03-24
: Paved, City Limits, Street Dead-End, FloodZone, Flood Insurance Required
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4817
+post_id: "60294"
+post_author: 1
+"ListingKey": "MFR751461510"
+"ListingId": "TB8365570"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2025-05-13T16:59:09Z"
+"RFModificationTimestamp": "2025-05-13T17:02:52.085893+00:00"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1690.0
+"BuildingAreaTotal": 2122.0
+"City": "Redington Beach"
+"PostalCode": "33708"
+"UnparsedAddress": "15507 Redington Dr, Redington Beach, Florida 33708"
+"Coordinates": array:2 [0 => -82.8051061 => 27.807103]
+"Latitude": 27.807103
+"Longitude": -82.805106
+"YearBuilt": 1955
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Irwin Wilensky"
+"ListOfficeName": "ENGEL & VOLKERS BELLEAIR"
+"ListAgentMlsId": "261508580"
+"ListOfficeMlsId": "260030438"
+"OriginatingSystemName": "Stellar"
+"PublicRemarks": "The home is priced at land value. The improvements have little if any value. The home was flooded during hurricane Helene. No remediation has been completed. Next door and nearby, homes are being raised or razed to create multi-story homes above the flood line. Incredible views of a cove just off the Gulf Intracoastal Waterway. The 65 feet of waterfront allows for larger yachts to be parked behind the home. If you have always dreamed of a waterfront home on the Pinellas County beaches, this is your opportunity to purchase the lot for that home at a modest price. The seller has requested that all buyers submit their highest and best by 11:59 pm on 4/10/2025."
+"Appliances": array:1 [0 => "None"
]
+"ArchitecturalStyle": array:1 [0 => "Ranch"
]
+"AttachedGarageYN": true
+"BathroomsFull": 2
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:2 [0 => "Block"
1 => "Stucco"
]
+"Cooling": array:1 [0 => "Central Air"
]
+"Country": "US"
+"CountyOrParish": "Pinellas"
+"CreationDate": "2025-03-25T04:12:55.351903+00:00"
+"CumulativeDaysOnMarket": 104
+"DaysOnMarket": 28
+"DirectionFaces": "North"
+"Directions": "Gulf Blvd to Redington Beach to 155th St to Redington Drive to 15507 Redington Dr."
+"ElementarySchool": "Bauder Elementary-PN"
+"ExteriorFeatures": array:1 [0 => "Other"
]
+"Fencing": array:1 [0 => "Wood"
]
+"FireplaceFeatures": array:2 [0 => "Living Room"
1 => "Wood Burning"
]
+"FireplaceYN": true
+"Flooring": array:3 [0 => "Carpet"
1 => "Terrazzo"
2 => "Tile"
]
+"FoundationDetails": array:1 [0 => "Slab"
]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [0 => "Central"
]
+"HighSchool": "Seminole High-PN"
+"InteriorFeatures": array:2 [0 => "Eat-in Kitchen"
1 => "Primary Bedroom Main Floor"
]
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [0 => "In Garage"
]
+"Levels": array:1 [0 => "One"
]
+"ListAOR": "Pinellas Suncoast"
+"ListAgentAOR": "Pinellas Suncoast"
+"ListAgentDirectPhone": "727-644-9183"
+"ListAgentEmail": "irwin.wilensky@evrealestate.com"
+"ListAgentFax": "727-461-1002"
+"ListAgentKey": "1099350"
+"ListAgentPager": "727-644-9183"
+"ListAgentURL": "http://www.nexthomesunraye.com"
+"ListOfficeFax": "727-461-1002"
+"ListOfficeKey": "1039150"
+"ListOfficePhone": "727-461-1000"
+"ListOfficeURL": "http://belleair.evrealestate.com"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-03-24"
+"ListingTerms": "Cash"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:5 [0 => "Flood Insurance Required"
1 => "FloodZone"
2 => "City Limits"
3 => "Street Dead-End"
4 => "Paved"
]
+"LotSizeAcres": 0.21
+"LotSizeDimensions": "65x140"
+"LotSizeSquareFeet": 8986
+"MLSAreaMajor": "33708 - St Pete/Madeira Bch/N Redington Bch/Shores"
+"MiddleOrJuniorSchool": "Seminole Middle-PN"
+"MlgCanUse": array:1 [0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OccupantType": "Vacant"
+"OffMarketDate": "2025-04-21"
+"OnMarketDate": "2025-03-24"
+"OriginalEntryTimestamp": "2025-03-24T22:15:42Z"
+"OriginalListPrice": 754100
+"OriginatingSystemKey": "751461510"
+"Ownership": "Fee Simple"
+"ParcelNumber": "09-31-15-52596-024-0420"
+"PatioAndPorchFeatures": array:4 [0 => "Deck"
1 => "Enclosed"
2 => "Porch"
3 => "Rear Porch"
]
+"PhotosChangeTimestamp": "2025-03-24T22:17:10Z"
+"PhotosCount": 13
+"PostalCodePlus4": "1737"
+"PreviousListPrice": 754100
+"PriceChangeTimestamp": "2025-04-01T20:48:59Z"
+"PublicSurveyRange": "15"
+"PublicSurveySection": "09"
+"PurchaseContractDate": "2025-04-21"
+"RoadSurfaceType": array:1 [0 => "Asphalt"
]
+"Roof": array:1 [0 => "Built-Up"
]
+"Sewer": array:1 [0 => "Public Sewer"
]
+"ShowingRequirements": array:1 [0 => "ShowingTime"
]
+"SpecialListingConditions": array:1 [0 => "Real Estate Owned"
]
+"StateOrProvince": "FL"
+"StatusChangeTimestamp": "2025-04-22T17:17:58Z"
+"StoriesTotal": "1"
+"StreetName": "REDINGTON"
+"StreetNumber": "15507"
+"StreetSuffix": "DRIVE"
+"SubdivisionName": "LONE PALM BEACH 4TH ADD"
+"TaxAnnualAmount": "2886.22"
+"TaxBlock": "24"
+"TaxBookNumber": "23-10"
+"TaxLegalDescription": "LONE PALM BEACH 4TH ADD BLK 24, LOT 42"
+"TaxLot": "42"
+"TaxYear": "2024"
+"Township": "31"
+"UniversalPropertyId": "US-12103-N-093115525960240420-R-N"
+"Utilities": array:5 [0 => "BB/HS Internet Available"
1 => "Cable Available"
2 => "Electricity Available"
3 => "Public"
4 => "Water Available"
]
+"Vegetation": array:2 [0 => "Mature Landscaping"
1 => "Trees/Landscaped"
]
+"View": "Water"
+"WaterSource": array:1 [0 => "Public"
]
+"WaterfrontFeatures": array:1 [0 => "Intracoastal Waterway"
]
+"WaterfrontYN": true
+"MFR_CDDYN": "0"
+"MFR_DPRYN": "1"
+"MFR_DPRURL": "https://www.workforce-resource.com/dpr/listing/MFRMLS/TB8365570?w=Agent&skip_sso=true"
+"MFR_DockYN": "1"
+"MFR_SDEOYN": "0"
+"MFR_DPRURL2": "https://www.workforce-resource.com/dpr/listing/MFRMLS/TB8365570?w=Customer"
+"MFR_RoomCount": "6"
+"MFR_WaterView": "Intracoastal Waterway"
+"MFR_EscrowCity": "Moon Twp"
+"MFR_EscrowState": "PA"
+"MFR_HomesteadYN": "0"
+"MFR_RealtorInfo": "As-Is"
+"MFR_WaterAccess": "Intracoastal Waterway"
+"MFR_WaterViewYN": "1"
+"MFR_CurrentPrice": "699900.00"
+"MFR_InLawSuiteYN": "0"
+"MFR_MinimumLease": "1 Month"
+"MFR_TotalAcreage": "0 to less than 1/4"
+"MFR_UnitNumberYN": "0"
+"MFR_EscrowCompany": "Servicelink"
+"MFR_FloodZoneCode": "VE"
+"MFR_WaterAccessYN": "1"
+"MFR_WaterExtrasYN": "0"
+"MFR_Association2YN": "0"
+"MFR_ContractStatus": "No Contingency"
+"MFR_DockDimensions": "6x15"
+"MFR_EscrowAgentFax": "855-858-2749"
+"MFR_PreviousStatus": "Active"
+"MFR_AdditionalRooms": "Florida Room"
+"MFR_DockDescription": "Dock - Wood"
+"MFR_EscrowAgentName": "Steven Ward"
+"MFR_TotalAnnualFees": "0.00"
+"MFR_EscrowAgentEmail": "steven.ward@svclnk.com"
+"MFR_EscrowAgentPhone": "412-776-2035"
+"MFR_EscrowPostalCode": "15108"
+"MFR_EscrowStreetName": "Cherrington Parkway"
+"MFR_ExistLseTenantYN": "0"
+"MFR_LivingAreaMeters": "157.01"
+"MFR_TotalMonthlyFees": "0.00"
+"MFR_AttributionContact": "727-461-1000"
+"MFR_BackupsRequestedYN": "0"
+"MFR_EscrowStreetNumber": "1355"
+"MFR_ListingExclusionYN": "0"
+"MFR_PublicRemarksAgent": "The home is priced at land value. The improvements have little if any value. The home was flooded during hurricane Helene. No remediation has been completed. Next door and nearby, homes are being raised or razed to create multi-story homes above the flood line. Incredible views of a cove just off the Gulf Intracoastal Waterway. The 65 feet of waterfront allows for larger yachts to be parked behind the home. If you have always dreamed of a waterfront home on the Pinellas County beaches, this is your opportunity to purchase the lot for that home at a modest price. The seller has requested that all buyers submit their highest and best by 11:59 pm on 4/10/2025."
+"MFR_AvailableForLeaseYN": "1"
+"MFR_ExpectedClosingDate": "2025-05-19T00:00:00.000"
+"MFR_LeaseRestrictionsYN": "1"
+"MFR_LotSizeSquareMeters": "835"
+"MFR_WaterfrontFeetTotal": "65"
+"MFR_AlternateKeyFolioNum": "093115525960240420"
+"MFR_SellerRepresentation": "Transaction Broker"
+"MFR_WaterFrontageFeetICW": "65"
+"MFR_GreenVerificationCount": "0"
+"MFR_OriginatingSystemName_": "Stellar MLS"
+"MFR_BuildingAreaTotalSrchSqM": "197.14"
+"MFR_AdditionalWaterInformation": "Just north of the Tom Stewart causeway, south of the narrows."
+"MFR_ListOfficeContactPreferred": "727-461-1000"
+"MFR_AdditionalLeaseRestrictions": "Please contact the city 727-391-3875 to determine current and future lease restrictions."
+"MFR_AssociationApprovalRequiredYN": "0"
+"MFR_YrsOfOwnerPriorToLeasingReqYN": "0"
+"MFR_ListOfficeHeadOfficeKeyNumeric": "1039150"
+"MFR_CalculatedListPriceByCalculatedSqFt": "414.14"
+"MFR_RATIO_CurrentPrice_By_CalculatedSqFt": "414.14"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MFR751461510')"
+"provider_name": "Stellar"
+"Media": array:13 [0 => array:12 [
"Order" => 0
"MediaKey" => "67e1d9ce98236a30fd8f0736"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/84c816c17bf6c3d18aaeefd143e7db20.webp"
"MediaSize" => 311699
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-84c816c17bf6c3d18aaeefd143e7db20.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 900
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x900"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.820Z"
]
1 => array:12 [
"Order" => 1
"MediaKey" => "67e1d9ce98236a30fd8f0737"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/b78be44c11a21f47db651cf325c163e8.webp"
"MediaSize" => 377817
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-b78be44c11a21f47db651cf325c163e8.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 900
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x900"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.864Z"
]
2 => array:12 [
"Order" => 2
"MediaKey" => "67e1d9ce98236a30fd8f0738"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/41c1cef9d6cea53bf131fa1f40c55d90.webp"
"MediaSize" => 327429
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-41c1cef9d6cea53bf131fa1f40c55d90.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 900
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x900"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.800Z"
]
3 => array:12 [
"Order" => 3
"MediaKey" => "67e1d9ce98236a30fd8f0739"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/59e9f8c43c1df97ae881c54773189d8b.webp"
"MediaSize" => 442835
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-59e9f8c43c1df97ae881c54773189d8b.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 900
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x900"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.834Z"
]
4 => array:12 [
"Order" => 4
"MediaKey" => "67e1d9ce98236a30fd8f073a"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/8a2bb3d1bb9624f2bccec18dcfac5cc0.webp"
"MediaSize" => 272344
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-8a2bb3d1bb9624f2bccec18dcfac5cc0.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 900
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x900"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.809Z"
]
5 => array:12 [
"Order" => 5
"MediaKey" => "67e1d9ce98236a30fd8f073b"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/6e22db5842e9a6cfb59711cc59071b91.webp"
"MediaSize" => 329956
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-6e22db5842e9a6cfb59711cc59071b91.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 900
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x900"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.803Z"
]
6 => array:12 [
"Order" => 6
"MediaKey" => "67e1d9ce98236a30fd8f073c"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/0c53d9755f6e9bd9c3367b6c21ad3656.webp"
"MediaSize" => 560988
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-0c53d9755f6e9bd9c3367b6c21ad3656.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 1199
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x1199"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.805Z"
]
7 => array:12 [
"Order" => 7
"MediaKey" => "67e1d9ce98236a30fd8f073d"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/376af3b8801499e221f060a5f62391b5.webp"
"MediaSize" => 522816
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-376af3b8801499e221f060a5f62391b5.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 1199
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x1199"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.806Z"
]
8 => array:12 [
"Order" => 8
"MediaKey" => "67e1d9ce98236a30fd8f073e"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/d3132f8638b8cd4a3edc41e862852350.webp"
"MediaSize" => 370409
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-d3132f8638b8cd4a3edc41e862852350.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 1199
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x1199"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.741Z"
]
9 => array:12 [
"Order" => 9
"MediaKey" => "67e1d9ce98236a30fd8f073f"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/f7c19bd0d99f1f44840d926fc91bdb15.webp"
"MediaSize" => 359912
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-f7c19bd0d99f1f44840d926fc91bdb15.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 1199
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x1199"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.825Z"
]
10 => array:12 [
"Order" => 10
"MediaKey" => "67e1d9ce98236a30fd8f0740"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/89bd1282c7bbad8e5d84e31cf2df58fe.webp"
"MediaSize" => 377574
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-89bd1282c7bbad8e5d84e31cf2df58fe.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 1199
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x1199"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.786Z"
]
11 => array:12 [
"Order" => 11
"MediaKey" => "67e1d9ce98236a30fd8f0741"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/51e28614c38e4f53193a04ac32c1c24a.webp"
"MediaSize" => 261815
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-51e28614c38e4f53193a04ac32c1c24a.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 1199
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x1199"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.820Z"
]
12 => array:12 [
"Order" => 12
"MediaKey" => "67e1d9ce98236a30fd8f0742"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/dec8b464d448af24201cd2f781d56226.webp"
"MediaSize" => 366686
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-dec8b464d448af24201cd2f781d56226.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 1199
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x1199"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.851Z"
]
]
+"ID": "60294"
}
MLS On The Fly Debug Panel
array:1 [
"RF Query: /Property?$select=ALL&$top=20&$filter=(StandardStatus in ('Active','Pending')) and ListingKey eq 'MFR751461510'/Property?$select=ALL&$top=20&$filter=(StandardStatus in ('Active','Pending')) and ListingKey eq 'MFR751461510'&$expand=Media/Property?$select=ALL&$top=20&$filter=(StandardStatus in ('Active','Pending')) and ListingKey eq 'MFR751461510'/Property?$select=ALL&$top=20&$filter=(StandardStatus in ('Active','Pending')) and ListingKey eq 'MFR751461510'&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4815
+items: array:1 [0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4817
+post_id: "60294"
+post_author: 1
+"ListingKey": "MFR751461510"
+"ListingId": "TB8365570"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2025-05-13T16:59:09Z"
+"RFModificationTimestamp": "2025-05-13T17:02:52.085893+00:00"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1690.0
+"BuildingAreaTotal": 2122.0
+"City": "Redington Beach"
+"PostalCode": "33708"
+"UnparsedAddress": "15507 Redington Dr, Redington Beach, Florida 33708"
+"Coordinates": array:2 [0 => -82.8051061 => 27.807103]
+"Latitude": 27.807103
+"Longitude": -82.805106
+"YearBuilt": 1955
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Irwin Wilensky"
+"ListOfficeName": "ENGEL & VOLKERS BELLEAIR"
+"ListAgentMlsId": "261508580"
+"ListOfficeMlsId": "260030438"
+"OriginatingSystemName": "Stellar"
+"PublicRemarks": "The home is priced at land value. The improvements have little if any value. The home was flooded during hurricane Helene. No remediation has been completed. Next door and nearby, homes are being raised or razed to create multi-story homes above the flood line. Incredible views of a cove just off the Gulf Intracoastal Waterway. The 65 feet of waterfront allows for larger yachts to be parked behind the home. If you have always dreamed of a waterfront home on the Pinellas County beaches, this is your opportunity to purchase the lot for that home at a modest price. The seller has requested that all buyers submit their highest and best by 11:59 pm on 4/10/2025."
+"Appliances": array:1 [0 => "None"
]
+"ArchitecturalStyle": array:1 [0 => "Ranch"
]
+"AttachedGarageYN": true
+"BathroomsFull": 2
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:2 [0 => "Block"
1 => "Stucco"
]
+"Cooling": array:1 [0 => "Central Air"
]
+"Country": "US"
+"CountyOrParish": "Pinellas"
+"CreationDate": "2025-03-25T04:12:55.351903+00:00"
+"CumulativeDaysOnMarket": 104
+"DaysOnMarket": 28
+"DirectionFaces": "North"
+"Directions": "Gulf Blvd to Redington Beach to 155th St to Redington Drive to 15507 Redington Dr."
+"ElementarySchool": "Bauder Elementary-PN"
+"ExteriorFeatures": array:1 [0 => "Other"
]
+"Fencing": array:1 [0 => "Wood"
]
+"FireplaceFeatures": array:2 [0 => "Living Room"
1 => "Wood Burning"
]
+"FireplaceYN": true
+"Flooring": array:3 [0 => "Carpet"
1 => "Terrazzo"
2 => "Tile"
]
+"FoundationDetails": array:1 [0 => "Slab"
]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [0 => "Central"
]
+"HighSchool": "Seminole High-PN"
+"InteriorFeatures": array:2 [0 => "Eat-in Kitchen"
1 => "Primary Bedroom Main Floor"
]
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [0 => "In Garage"
]
+"Levels": array:1 [0 => "One"
]
+"ListAOR": "Pinellas Suncoast"
+"ListAgentAOR": "Pinellas Suncoast"
+"ListAgentDirectPhone": "727-644-9183"
+"ListAgentEmail": "irwin.wilensky@evrealestate.com"
+"ListAgentFax": "727-461-1002"
+"ListAgentKey": "1099350"
+"ListAgentPager": "727-644-9183"
+"ListAgentURL": "http://www.nexthomesunraye.com"
+"ListOfficeFax": "727-461-1002"
+"ListOfficeKey": "1039150"
+"ListOfficePhone": "727-461-1000"
+"ListOfficeURL": "http://belleair.evrealestate.com"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-03-24"
+"ListingTerms": "Cash"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:5 [0 => "Flood Insurance Required"
1 => "FloodZone"
2 => "City Limits"
3 => "Street Dead-End"
4 => "Paved"
]
+"LotSizeAcres": 0.21
+"LotSizeDimensions": "65x140"
+"LotSizeSquareFeet": 8986
+"MLSAreaMajor": "33708 - St Pete/Madeira Bch/N Redington Bch/Shores"
+"MiddleOrJuniorSchool": "Seminole Middle-PN"
+"MlgCanUse": array:1 [0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OccupantType": "Vacant"
+"OffMarketDate": "2025-04-21"
+"OnMarketDate": "2025-03-24"
+"OriginalEntryTimestamp": "2025-03-24T22:15:42Z"
+"OriginalListPrice": 754100
+"OriginatingSystemKey": "751461510"
+"Ownership": "Fee Simple"
+"ParcelNumber": "09-31-15-52596-024-0420"
+"PatioAndPorchFeatures": array:4 [0 => "Deck"
1 => "Enclosed"
2 => "Porch"
3 => "Rear Porch"
]
+"PhotosChangeTimestamp": "2025-03-24T22:17:10Z"
+"PhotosCount": 13
+"PostalCodePlus4": "1737"
+"PreviousListPrice": 754100
+"PriceChangeTimestamp": "2025-04-01T20:48:59Z"
+"PublicSurveyRange": "15"
+"PublicSurveySection": "09"
+"PurchaseContractDate": "2025-04-21"
+"RoadSurfaceType": array:1 [0 => "Asphalt"
]
+"Roof": array:1 [0 => "Built-Up"
]
+"Sewer": array:1 [0 => "Public Sewer"
]
+"ShowingRequirements": array:1 [0 => "ShowingTime"
]
+"SpecialListingConditions": array:1 [0 => "Real Estate Owned"
]
+"StateOrProvince": "FL"
+"StatusChangeTimestamp": "2025-04-22T17:17:58Z"
+"StoriesTotal": "1"
+"StreetName": "REDINGTON"
+"StreetNumber": "15507"
+"StreetSuffix": "DRIVE"
+"SubdivisionName": "LONE PALM BEACH 4TH ADD"
+"TaxAnnualAmount": "2886.22"
+"TaxBlock": "24"
+"TaxBookNumber": "23-10"
+"TaxLegalDescription": "LONE PALM BEACH 4TH ADD BLK 24, LOT 42"
+"TaxLot": "42"
+"TaxYear": "2024"
+"Township": "31"
+"UniversalPropertyId": "US-12103-N-093115525960240420-R-N"
+"Utilities": array:5 [0 => "BB/HS Internet Available"
1 => "Cable Available"
2 => "Electricity Available"
3 => "Public"
4 => "Water Available"
]
+"Vegetation": array:2 [0 => "Mature Landscaping"
1 => "Trees/Landscaped"
]
+"View": "Water"
+"WaterSource": array:1 [0 => "Public"
]
+"WaterfrontFeatures": array:1 [0 => "Intracoastal Waterway"
]
+"WaterfrontYN": true
+"MFR_CDDYN": "0"
+"MFR_DPRYN": "1"
+"MFR_DPRURL": "https://www.workforce-resource.com/dpr/listing/MFRMLS/TB8365570?w=Agent&skip_sso=true"
+"MFR_DockYN": "1"
+"MFR_SDEOYN": "0"
+"MFR_DPRURL2": "https://www.workforce-resource.com/dpr/listing/MFRMLS/TB8365570?w=Customer"
+"MFR_RoomCount": "6"
+"MFR_WaterView": "Intracoastal Waterway"
+"MFR_EscrowCity": "Moon Twp"
+"MFR_EscrowState": "PA"
+"MFR_HomesteadYN": "0"
+"MFR_RealtorInfo": "As-Is"
+"MFR_WaterAccess": "Intracoastal Waterway"
+"MFR_WaterViewYN": "1"
+"MFR_CurrentPrice": "699900.00"
+"MFR_InLawSuiteYN": "0"
+"MFR_MinimumLease": "1 Month"
+"MFR_TotalAcreage": "0 to less than 1/4"
+"MFR_UnitNumberYN": "0"
+"MFR_EscrowCompany": "Servicelink"
+"MFR_FloodZoneCode": "VE"
+"MFR_WaterAccessYN": "1"
+"MFR_WaterExtrasYN": "0"
+"MFR_Association2YN": "0"
+"MFR_ContractStatus": "No Contingency"
+"MFR_DockDimensions": "6x15"
+"MFR_EscrowAgentFax": "855-858-2749"
+"MFR_PreviousStatus": "Active"
+"MFR_AdditionalRooms": "Florida Room"
+"MFR_DockDescription": "Dock - Wood"
+"MFR_EscrowAgentName": "Steven Ward"
+"MFR_TotalAnnualFees": "0.00"
+"MFR_EscrowAgentEmail": "steven.ward@svclnk.com"
+"MFR_EscrowAgentPhone": "412-776-2035"
+"MFR_EscrowPostalCode": "15108"
+"MFR_EscrowStreetName": "Cherrington Parkway"
+"MFR_ExistLseTenantYN": "0"
+"MFR_LivingAreaMeters": "157.01"
+"MFR_TotalMonthlyFees": "0.00"
+"MFR_AttributionContact": "727-461-1000"
+"MFR_BackupsRequestedYN": "0"
+"MFR_EscrowStreetNumber": "1355"
+"MFR_ListingExclusionYN": "0"
+"MFR_PublicRemarksAgent": "The home is priced at land value. The improvements have little if any value. The home was flooded during hurricane Helene. No remediation has been completed. Next door and nearby, homes are being raised or razed to create multi-story homes above the flood line. Incredible views of a cove just off the Gulf Intracoastal Waterway. The 65 feet of waterfront allows for larger yachts to be parked behind the home. If you have always dreamed of a waterfront home on the Pinellas County beaches, this is your opportunity to purchase the lot for that home at a modest price. The seller has requested that all buyers submit their highest and best by 11:59 pm on 4/10/2025."
+"MFR_AvailableForLeaseYN": "1"
+"MFR_ExpectedClosingDate": "2025-05-19T00:00:00.000"
+"MFR_LeaseRestrictionsYN": "1"
+"MFR_LotSizeSquareMeters": "835"
+"MFR_WaterfrontFeetTotal": "65"
+"MFR_AlternateKeyFolioNum": "093115525960240420"
+"MFR_SellerRepresentation": "Transaction Broker"
+"MFR_WaterFrontageFeetICW": "65"
+"MFR_GreenVerificationCount": "0"
+"MFR_OriginatingSystemName_": "Stellar MLS"
+"MFR_BuildingAreaTotalSrchSqM": "197.14"
+"MFR_AdditionalWaterInformation": "Just north of the Tom Stewart causeway, south of the narrows."
+"MFR_ListOfficeContactPreferred": "727-461-1000"
+"MFR_AdditionalLeaseRestrictions": "Please contact the city 727-391-3875 to determine current and future lease restrictions."
+"MFR_AssociationApprovalRequiredYN": "0"
+"MFR_YrsOfOwnerPriorToLeasingReqYN": "0"
+"MFR_ListOfficeHeadOfficeKeyNumeric": "1039150"
+"MFR_CalculatedListPriceByCalculatedSqFt": "414.14"
+"MFR_RATIO_CurrentPrice_By_CalculatedSqFt": "414.14"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MFR751461510')"
+"provider_name": "Stellar"
+"Media": array:13 [0 => array:12 [
"Order" => 0
"MediaKey" => "67e1d9ce98236a30fd8f0736"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/84c816c17bf6c3d18aaeefd143e7db20.webp"
"MediaSize" => 311699
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-84c816c17bf6c3d18aaeefd143e7db20.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 900
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x900"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.820Z"
]
1 => array:12 [
"Order" => 1
"MediaKey" => "67e1d9ce98236a30fd8f0737"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/b78be44c11a21f47db651cf325c163e8.webp"
"MediaSize" => 377817
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-b78be44c11a21f47db651cf325c163e8.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 900
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x900"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.864Z"
]
2 => array:12 [
"Order" => 2
"MediaKey" => "67e1d9ce98236a30fd8f0738"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/41c1cef9d6cea53bf131fa1f40c55d90.webp"
"MediaSize" => 327429
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-41c1cef9d6cea53bf131fa1f40c55d90.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 900
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x900"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.800Z"
]
3 => array:12 [
"Order" => 3
"MediaKey" => "67e1d9ce98236a30fd8f0739"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/59e9f8c43c1df97ae881c54773189d8b.webp"
"MediaSize" => 442835
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-59e9f8c43c1df97ae881c54773189d8b.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 900
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x900"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.834Z"
]
4 => array:12 [
"Order" => 4
"MediaKey" => "67e1d9ce98236a30fd8f073a"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/8a2bb3d1bb9624f2bccec18dcfac5cc0.webp"
"MediaSize" => 272344
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-8a2bb3d1bb9624f2bccec18dcfac5cc0.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 900
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x900"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.809Z"
]
5 => array:12 [
"Order" => 5
"MediaKey" => "67e1d9ce98236a30fd8f073b"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/6e22db5842e9a6cfb59711cc59071b91.webp"
"MediaSize" => 329956
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-6e22db5842e9a6cfb59711cc59071b91.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 900
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x900"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.803Z"
]
6 => array:12 [
"Order" => 6
"MediaKey" => "67e1d9ce98236a30fd8f073c"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/0c53d9755f6e9bd9c3367b6c21ad3656.webp"
"MediaSize" => 560988
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-0c53d9755f6e9bd9c3367b6c21ad3656.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 1199
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x1199"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.805Z"
]
7 => array:12 [
"Order" => 7
"MediaKey" => "67e1d9ce98236a30fd8f073d"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/376af3b8801499e221f060a5f62391b5.webp"
"MediaSize" => 522816
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-376af3b8801499e221f060a5f62391b5.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 1199
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x1199"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.806Z"
]
8 => array:12 [
"Order" => 8
"MediaKey" => "67e1d9ce98236a30fd8f073e"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/d3132f8638b8cd4a3edc41e862852350.webp"
"MediaSize" => 370409
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-d3132f8638b8cd4a3edc41e862852350.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 1199
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x1199"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.741Z"
]
9 => array:12 [
"Order" => 9
"MediaKey" => "67e1d9ce98236a30fd8f073f"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/f7c19bd0d99f1f44840d926fc91bdb15.webp"
"MediaSize" => 359912
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-f7c19bd0d99f1f44840d926fc91bdb15.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 1199
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x1199"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.825Z"
]
10 => array:12 [
"Order" => 10
"MediaKey" => "67e1d9ce98236a30fd8f0740"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/89bd1282c7bbad8e5d84e31cf2df58fe.webp"
"MediaSize" => 377574
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-89bd1282c7bbad8e5d84e31cf2df58fe.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 1199
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x1199"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.786Z"
]
11 => array:12 [
"Order" => 11
"MediaKey" => "67e1d9ce98236a30fd8f0741"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/51e28614c38e4f53193a04ac32c1c24a.webp"
"MediaSize" => 261815
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-51e28614c38e4f53193a04ac32c1c24a.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 1199
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x1199"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.820Z"
]
12 => array:12 [
"Order" => 12
"MediaKey" => "67e1d9ce98236a30fd8f0742"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/dec8b464d448af24201cd2f781d56226.webp"
"MediaSize" => 366686
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/15/MFR751461510/thumbnail-dec8b464d448af24201cd2f781d56226.webp"
"ImageWidth" => 1600
"Permission" => array:1 [0 => "Public"
]
"ImageHeight" => 1199
"ResourceRecordKey" => "MFR751461510"
"ImageSizeDescription" => "1600x1199"
"MediaModificationTimestamp" => "2025-03-24T22:16:46.851Z"
]
]
+"ID": "60294"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 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