array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29202425/Property?$select=ALL&$top=20&$filter=ListingKey eq 29202425&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29202425/Property?$select=ALL&$top=20&$filter=ListingKey eq 29202425&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23512
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23514
+post_id: "500446"
+post_author: 1
+"ListingKey": "29202425"
+"ListingId": "1293393"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-23T19:05:27Z"
+"RFModificationTimestamp": "2025-12-23T19:40:17Z"
+"ListPrice": 995000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 9654.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1B2B7"
+"UnparsedAddress": "95 Lemarchant Road, St. John's, Newfoundland & Labrador A1B2B7"
+"Coordinates": array:2 [
0 => -52.717313
1 => 47.560558
]
+"Latitude": 47.560558
+"Longitude": -52.717313
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Situated in a high visibility, prime city centre location with ample rear parking lot, this purpose built medical services/office building presents a unique opportunity! With 3 developed levels, including the walk out basement, this well-constructed building consists of central lobby area, multiple self-contained spaces (ideal for independent tenants if desired), offices, boardroom, kitchenettes, open area for pod systems, several bathroom facilities and storage, allowing for a variety of uses. The accessible main level (~4400 square feet) has a vacant space of 3500 square feet, ideal for an owner occupied tenant. Two wonderful long-term tenants currently occupying a portion of the main level and entire second floor. The walk out basement also has vacant space. Building has been well-maintained by current owner with roof covering and parking lot recently replaced. Great city and harbour views from the rear! Great opportunity exists, with on site parking, and easy access to bus route! (id:62650)"
+"BusinessType": "Other,Service"
+"CreationDate": "2025-12-23T19:40:11.508759+00:00"
+"Flooring": array:1 [
0 => "Mixed Flooring"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1964615"
+"ListOfficeKey": "293977"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "65x200x82x194"
+"PhotosChangeTimestamp": "2025-12-23T18:52:51Z"
+"PhotosCount": 50
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-12-23T18:52:51Z"
+"StreetName": "Lemarchant"
+"StreetNumber": "95"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "29129"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29202425/95-lemarchant-road-st-johns"
+"StructureType": array:1 [
0 => "Other"
]
+"CoListAgentKey": "1906420"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "88555"
+"GeocodeManualYN": true
+"ZoningDescription": "Comm."
+"OriginalEntryTimestamp": "2025-12-23T18:52:51.47Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:50 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6381420566"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/9e98ccf77d6d55f4b0e1ffdba88af945.webp"
"MediaSize" => 102217
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-9e98ccf77d6d55f4b0e1ffdba88af945.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6381420569"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/7d6c3e1ab4081b5d1b6f1fccf67bbb8f.webp"
"MediaSize" => 259900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-7d6c3e1ab4081b5d1b6f1fccf67bbb8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6381420572"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/1076de815a44a4632edf2045499b7786.webp"
"MediaSize" => 120344
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-1076de815a44a4632edf2045499b7786.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6381420575"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/7e8260f7f516f4d97b51604532f6b60c.webp"
"MediaSize" => 116832
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-7e8260f7f516f4d97b51604532f6b60c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6381420578"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/1bbe2a24d82cf0547258c959c4e38ea7.webp"
"MediaSize" => 134695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-1bbe2a24d82cf0547258c959c4e38ea7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6381420581"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/426dc09971586c7f23dea27875011d9b.webp"
"MediaSize" => 148842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-426dc09971586c7f23dea27875011d9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6381420586"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/be1c8a80a8af83055d3d07703a21bad4.webp"
"MediaSize" => 152241
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-be1c8a80a8af83055d3d07703a21bad4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6381420600"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/761960038897cb658b1097b910be655c.webp"
"MediaSize" => 160521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-761960038897cb658b1097b910be655c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6381420607"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/a08d985ddbb6ddaa441df4ea4fb11845.webp"
"MediaSize" => 130980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-a08d985ddbb6ddaa441df4ea4fb11845.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6381420612"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/caf516b960299e027328a43df5031fdb.webp"
"MediaSize" => 145167
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-caf516b960299e027328a43df5031fdb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6381420618"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/18232e100d1185d90e534e1f48fd6a74.webp"
"MediaSize" => 127848
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-18232e100d1185d90e534e1f48fd6a74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6381420624"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/506b809c464cc9950c54035578e77154.webp"
"MediaSize" => 128655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-506b809c464cc9950c54035578e77154.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6381420631"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/6ff2204f04ed1a8ecea9cc9839355c0a.webp"
"MediaSize" => 127752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-6ff2204f04ed1a8ecea9cc9839355c0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6381420638"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/939e802e196b04d536833d774baadfc1.webp"
"MediaSize" => 111520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-939e802e196b04d536833d774baadfc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6381420649"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/c3c5df3db8b413aed149a119b45918d1.webp"
"MediaSize" => 92171
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-c3c5df3db8b413aed149a119b45918d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6381420678"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/d8c7c485d0f179430db7b2977cd25528.webp"
"MediaSize" => 93372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-d8c7c485d0f179430db7b2977cd25528.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6381420704"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/9b62d962c728cf899f242d412d755062.webp"
"MediaSize" => 83758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-9b62d962c728cf899f242d412d755062.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6381420712"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/cb54df33992ca5e39a82295eb14483b8.webp"
"MediaSize" => 98450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-cb54df33992ca5e39a82295eb14483b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6381420730"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/a99142c7726f35e3c94ec8c5fbffc833.webp"
"MediaSize" => 93477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-a99142c7726f35e3c94ec8c5fbffc833.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6381420739"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/ef7f8b65f250c99e2a809edc93df900e.webp"
"MediaSize" => 104482
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-ef7f8b65f250c99e2a809edc93df900e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6381420749"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/bf2d9dfe6a2c000ec93ee7cc473eb6e9.webp"
"MediaSize" => 78557
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-bf2d9dfe6a2c000ec93ee7cc473eb6e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6381420759"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/4449b69ae84602c634481b381c4f9d42.webp"
"MediaSize" => 100467
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-4449b69ae84602c634481b381c4f9d42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6381420769"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/7529f5ea7a29b1ec43ec10a97ed2b236.webp"
"MediaSize" => 88592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-7529f5ea7a29b1ec43ec10a97ed2b236.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6381420778"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/aad6774775bd6a9338a87c1a0d22c1c7.webp"
"MediaSize" => 82788
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-aad6774775bd6a9338a87c1a0d22c1c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6381420787"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/77ec60ddaab1821f4989da2e9b0e7e3e.webp"
"MediaSize" => 90442
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-77ec60ddaab1821f4989da2e9b0e7e3e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6381420794"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/2063c96bc84571e74e75386363171b93.webp"
"MediaSize" => 85215
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-2063c96bc84571e74e75386363171b93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6381420804"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/204aee7ebc0347e557df7e5a51bc8981.webp"
"MediaSize" => 93609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-204aee7ebc0347e557df7e5a51bc8981.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6381420811"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/4bcf347134bd59fae7c73273dd1aae03.webp"
"MediaSize" => 88249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-4bcf347134bd59fae7c73273dd1aae03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6381420817"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/b0ecdf4d708d52bd5dc916c776472bc9.webp"
"MediaSize" => 89888
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-b0ecdf4d708d52bd5dc916c776472bc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6381420823"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/9608d88ef460c328b488a29401316fbf.webp"
"MediaSize" => 93163
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-9608d88ef460c328b488a29401316fbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6381420830"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/31584d5f4c45df86c2e1a6ed82504b2a.webp"
"MediaSize" => 97618
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-31584d5f4c45df86c2e1a6ed82504b2a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6381420836"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/59a8cea78ec4c5d50de99ef577e00054.webp"
"MediaSize" => 45453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-59a8cea78ec4c5d50de99ef577e00054.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6381420843"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/dd499fdde22990e7548b946a6972813d.webp"
"MediaSize" => 106209
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-dd499fdde22990e7548b946a6972813d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6381420849"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/961d59a31e0bbdecffd060bb1e36afaf.webp"
"MediaSize" => 237570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-961d59a31e0bbdecffd060bb1e36afaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6381420855"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/cc7bf81a0c24b60f4d289e3c5fac75bb.webp"
"MediaSize" => 191820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-cc7bf81a0c24b60f4d289e3c5fac75bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6381420860"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/f410aafc7c96d59477390ae3f7739033.webp"
"MediaSize" => 191626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-f410aafc7c96d59477390ae3f7739033.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6381420865"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/76d7fba947ac83c64c23304ffa38e281.webp"
"MediaSize" => 187510
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-76d7fba947ac83c64c23304ffa38e281.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6381420870"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/a4ff297aa8fc6bab118351f056efbead.webp"
"MediaSize" => 208853
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-a4ff297aa8fc6bab118351f056efbead.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6381420876"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/945e1d1d01eb18a643126436216c5158.webp"
"MediaSize" => 241972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-945e1d1d01eb18a643126436216c5158.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6381420881"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/c46c5d1472cfd1f81e46b0c882da0ec8.webp"
"MediaSize" => 190685
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-c46c5d1472cfd1f81e46b0c882da0ec8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6381420886"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/ae672c600e6d58fc23ddea620a4eb9ed.webp"
"MediaSize" => 240086
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-ae672c600e6d58fc23ddea620a4eb9ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6381420890"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/32661f56001f6df5a799af269f6d05c8.webp"
"MediaSize" => 151821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-32661f56001f6df5a799af269f6d05c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
42 => array:13 [
"Order" => 42
"MediaKey" => "6381420894"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/4d8d25d9493e3b34ead4407f43065421.webp"
"MediaSize" => 174513
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-4d8d25d9493e3b34ead4407f43065421.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
43 => array:13 [
"Order" => 43
"MediaKey" => "6381420900"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/d7ceb0508def79e2d46bd6a9ac31f9b1.webp"
"MediaSize" => 151175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-d7ceb0508def79e2d46bd6a9ac31f9b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
44 => array:13 [
"Order" => 44
"MediaKey" => "6381420904"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/a12b4f7802e49b2a05d5df1dd80791fb.webp"
"MediaSize" => 235485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-a12b4f7802e49b2a05d5df1dd80791fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
45 => array:13 [
"Order" => 45
"MediaKey" => "6381420906"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/1b791f739ad9e7c09c32a8a59897d3ad.webp"
"MediaSize" => 157681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-1b791f739ad9e7c09c32a8a59897d3ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
46 => array:13 [
"Order" => 46
"MediaKey" => "6381420911"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/59c37ecc23357bf928dbff41f151ec10.webp"
"MediaSize" => 71847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-59c37ecc23357bf928dbff41f151ec10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
47 => array:13 [
"Order" => 47
"MediaKey" => "6381420916"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/7bc6e0f8370867a8b5241834426fb4eb.webp"
"MediaSize" => 111536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-7bc6e0f8370867a8b5241834426fb4eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
48 => array:13 [
"Order" => 48
"MediaKey" => "6381420921"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/f12ba5f3b5430a52e59c0a0dd92c3795.webp"
"MediaSize" => 104479
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-f12ba5f3b5430a52e59c0a0dd92c3795.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
49 => array:13 [
"Order" => 49
"MediaKey" => "6381420927"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/cd704dddb7c9af47967f4175490aa108.webp"
"MediaSize" => 93103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-cd704dddb7c9af47967f4175490aa108.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
]
+"Member": []
+"Office": array:1 [
0 => array:19 [
"OfficeName" => "RE/MAX Infinity Realty Inc. - Sheraton Hotel"
"OfficePhone" => "709-793-0909"
"OfficeMlsId" => "infinity"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "293977"
"ModificationTimestamp" => "2024-06-19T08:31:11Z"
"OfficeAddress1" => "115 Cavendish Square"
"OfficeCity" => "St. John's"
"OfficePostalCode" => "A1C3K2"
"OfficeStateOrProvince" => "Newfoundland & Labrador"
"OfficeStatus" => "Active"
"OfficeAOR" => "Newfoundland & Labrador"
"OfficeType" => "Firm"
"OfficeAORKey" => "117"
"OriginalEntryTimestamp" => "2023-02-16T15:30:00Z"
"OfficeNationalAssociationId" => "1433917"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1245171"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29202425')"
+"ID": "500446"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Cache Key: 39ae490fa8f5b194606a42448dfb94bc82d86568153f64cfbede6422bc615a61" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23873
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25375
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX Infinity Realty Inc. - Sheraton Hotel"
+"OfficeEmail": null
+"OfficePhone": "709-793-0909"
+"OfficeMlsId": "infinity"
+"ModificationTimestamp": "2024-06-19T08:31:11Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "293977"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "115 Cavendish Square"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "St. John's"
+"OfficePostalCode": "A1C3K2"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Newfoundland & Labrador"
+"OfficeStatus": "Active"
+"OfficeAOR": "Newfoundland & Labrador"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1433917"
+"OriginalEntryTimestamp": "2023-02-16T15:30:00Z"
+"OfficeAORKey": "117"
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1245171"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('293977')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1964615/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1964615&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1964615/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1964615&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25368
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29202425" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24980
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29202425/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29202425&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29202425/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29202425&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24960
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29202425 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Commercial Sale' AND geo.distance(Coordinates, POINT(-52.717313 47.560558)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29202425 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Commercial Sale' AND geo.distance(Coordinates, POINT(-52.717313 47.560558)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29202425 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Commercial Sale' AND geo.distance(Coordinates, POINT(-52.717313 47.560558)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29202425 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Commercial Sale' AND geo.distance(Coordinates, POINT(-52.717313 47.560558)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24830
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24901
+post_id: "482733"
+post_author: 1
+"ListingKey": "29186795"
+"ListingId": "1293273"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-22T16:30:36Z"
+"RFModificationTimestamp": "2025-12-22T16:31:05Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 6040.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C1G8"
+"UnparsedAddress": "253 Duckworth Street, St. John's, Newfoundland & Labrador A1C1G8"
+"Coordinates": array:2 [
0 => -52.705309
1 => 47.566541
]
+"Latitude": 47.566541
+"Longitude": -52.705309
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Unique Opportunity! High exposure, 3 level plus full basement, commercial building is optimally located on the corner of Duckworth and Prescott Street in a convenient, high traffic area, downtown St. John’s! Main level is currently vacant with two washrooms, Second level has office space including reception area, two private offices, washroom and storage. Top level is vacant with four offices, kitchenette, board room and washroom. Basement is utilized for general storage and also includes a walk in vault. Ready for immediate occupancy! *Any HST applicable is the responsibility of the purchaser. (id:62650)"
+"BusinessType": "Other"
+"CreationDate": "2025-12-15T17:47:29.689770+00:00"
+"Flooring": array:1 [
0 => "Mixed Flooring"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Forced air"
3 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1571888"
+"ListOfficeKey": "293977"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "31.9'x55'"
+"PhotosChangeTimestamp": "2025-12-22T16:20:09Z"
+"PhotosCount": 1
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-12-22T16:20:09Z"
+"Stories": "4.0"
+"StreetName": "Duckworth"
+"StreetNumber": "253"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "15431"
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2025
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29186795/253-duckworth-street-st-johns"
+"StructureType": array:1 [
0 => "Other"
]
+"CoListAgentKey": "1906420"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "88555"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Air Conditioning"
]
+"ZoningDescription": "CDM"
+"OriginalEntryTimestamp": "2025-12-15T17:22:48.23Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:1 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6379892416"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29186795/e352a4a64b7d8992332495acd5fc1a88.webp"
"MediaSize" => 137814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29186795/thumbnail-e352a4a64b7d8992332495acd5fc1a88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1293273"
"ResourceRecordKey" => "29186795"
"ModificationTimestamp" => "2025-12-22T16:20:09.68Z"
]
]
+"Member": []
+"Office": array:1 [
0 => array:19 [
"OfficeName" => "RE/MAX Infinity Realty Inc. - Sheraton Hotel"
"OfficePhone" => "709-793-0909"
"OfficeMlsId" => "infinity"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "293977"
"ModificationTimestamp" => "2024-06-19T08:31:11Z"
"OfficeAddress1" => "115 Cavendish Square"
"OfficeCity" => "St. John's"
"OfficePostalCode" => "A1C3K2"
"OfficeStateOrProvince" => "Newfoundland & Labrador"
"OfficeStatus" => "Active"
"OfficeAOR" => "Newfoundland & Labrador"
"OfficeType" => "Firm"
"OfficeAORKey" => "117"
"OriginalEntryTimestamp" => "2023-02-16T15:30:00Z"
"OfficeNationalAssociationId" => "1433917"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1245171"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29186795')"
+"ID": "482733"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24895
+post_id: "470800"
+post_author: 1
+"ListingKey": "29173465"
+"ListingId": "1293189"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-09T14:00:54Z"
+"RFModificationTimestamp": "2025-12-09T17:18:38Z"
+"ListPrice": 999500.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "St John's"
+"PostalCode": "A1E1C2"
+"UnparsedAddress": "722 Water Street, St John's, Newfoundland & Labrador A1E1C2"
+"Coordinates": array:2 [
0 => -52.720139
1 => 47.548841
]
+"Latitude": 47.548841
+"Longitude": -52.720139
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Investor Opportunity – Mixed-Use Portfolio (2 adjoining Properties) with business number if needed. Seize this rare chance to own a diverse, income-producing portfolio of 2 mixed-use properties offering strong current returns and long-term growth potential. With a combination of residential units, commercial leases, and included assets, this package delivers over $7700/month in rental income. --722 Water Street Flexible Use: 1–2 residential units or commercial space on the main with residential above Current Income: $3,200/month Zoning: Commercial/residential mix Ideal For: Owner-occupiers, live/work setups, or pure rental. --720 Water Street (Neighbouring Property) Commercial Lease: Triple Net (NNN) tenant at $4,500/month. Fully Renovated: Modernized throughout. Bonus Asset: Includes a fully equipped butcher shop with $250,000 in commercial-grade equipment (included in sale). Turnkey Investment: Stable tenant with minimal maintenance. (id:62650)"
+"BusinessType": "Accommodation,Food Services and Beverage,Restaurant,Retail and Wholesale"
+"CreationDate": "2025-12-09T17:18:21.957943+00:00"
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2135750"
+"ListOfficeKey": "285811"
+"PhotosChangeTimestamp": "2025-12-09T13:52:45Z"
+"PhotosCount": 20
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-12-09T13:52:45Z"
+"StreetName": "Water"
+"StreetNumber": "722"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3300"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29173465/722-water-street-st-johns"
+"StructureType": array:1 [
0 => "Retail"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "cm"
+"OriginalEntryTimestamp": "2025-12-09T13:52:45.86Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:20 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6362748723"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/5244c56d65d711476c9310a216a5d102.webp"
"MediaSize" => 248761
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-5244c56d65d711476c9310a216a5d102.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6362748733"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/c4472422de9d14e4a1f198ff6e4d5927.webp"
"MediaSize" => 186065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-c4472422de9d14e4a1f198ff6e4d5927.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6362748741"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/5895c51e705595f16fa5ab0db9b3939c.webp"
"MediaSize" => 175959
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-5895c51e705595f16fa5ab0db9b3939c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6362748748"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/fbcbd98dcd54f96c92f5f6b68cc68fa7.webp"
"MediaSize" => 174807
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-fbcbd98dcd54f96c92f5f6b68cc68fa7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6362748756"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/cbb2c20e50304dd40a2874d07f286916.webp"
"MediaSize" => 171256
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-cbb2c20e50304dd40a2874d07f286916.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6362748758"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/a0e99c8a7dc9d506bd759e013e3a1d0c.webp"
"MediaSize" => 187817
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-a0e99c8a7dc9d506bd759e013e3a1d0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6362748762"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/d2f164f76b4c3570ea6ad747d9c903ac.webp"
"MediaSize" => 269567
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-d2f164f76b4c3570ea6ad747d9c903ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6362748764"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/d9a46e88c0aaab7502d679b46e0bedc0.webp"
"MediaSize" => 200321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-d9a46e88c0aaab7502d679b46e0bedc0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6362748766"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/793d27149f8131a041016f0b512f5e88.webp"
"MediaSize" => 116088
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-793d27149f8131a041016f0b512f5e88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6362748771"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/a6497fa0b96b70b18be77d1743f3d3cc.webp"
"MediaSize" => 127544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-a6497fa0b96b70b18be77d1743f3d3cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6362748772"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/6bbe2616de1ace162346d944f0589632.webp"
"MediaSize" => 123751
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-6bbe2616de1ace162346d944f0589632.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6362748776"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/c909895db6e4564878da6aaf95ed1fc8.webp"
"MediaSize" => 117222
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-c909895db6e4564878da6aaf95ed1fc8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6362748777"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/d011213cde8026b943e20d8cc020b3eb.webp"
"MediaSize" => 128356
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-d011213cde8026b943e20d8cc020b3eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6362748780"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/2dd4ea3db442f9aa6819ca43c3ee490b.webp"
"MediaSize" => 157532
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-2dd4ea3db442f9aa6819ca43c3ee490b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6362748781"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/a897207967020f5346091652de167c40.webp"
"MediaSize" => 135621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-a897207967020f5346091652de167c40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6362748783"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/027f169b0d9556a479dbfd8508ed2497.webp"
"MediaSize" => 135030
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-027f169b0d9556a479dbfd8508ed2497.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6362748785"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/50a77509880ce178572855c8a8414c76.webp"
"MediaSize" => 121411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-50a77509880ce178572855c8a8414c76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6362748787"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/dfedb44a14ee5a53ac4dc547a095a3db.webp"
"MediaSize" => 108255
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-dfedb44a14ee5a53ac4dc547a095a3db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6362748789"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/7bcd5b863820ea5c1f2c7e74f41d97ca.webp"
"MediaSize" => 142722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-7bcd5b863820ea5c1f2c7e74f41d97ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6362748792"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/508d1e17135aa13317fe0c4893891b3b.webp"
"MediaSize" => 79641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-508d1e17135aa13317fe0c4893891b3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
]
+"Member": array:1 [
0 => array:21 [
"MemberFullName" => "Jeff LeDrew"
"MemberFirstName" => "Jeff"
"MemberLastName" => "LeDrew"
"MemberMlsId" => "ledreje"
"OriginatingSystemName" => 26
"MemberKey" => "2135750"
"ModificationTimestamp" => "2024-11-28T20:05:39Z"
"MemberStatus" => "Active"
"OfficeKey" => "285811"
"MemberAOR" => "Newfoundland & Labrador"
"MemberCity" => "St. John's"
"MemberType" => "Salesperson"
"MemberAORKey" => "117"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberAddress1" => "33 Pippy Place, Suite 304"
"MemberOfficePhone" => "709-727-8850"
"MemberStateOrProvince" => "Newfoundland & Labrador"
"OriginalEntryTimestamp" => "2021-05-28T14:10:00Z"
"MemberNationalAssociationId" => "1388077"
"OfficeNationalAssociationId" => "1354950"
]
]
+"Office": array:1 [
0 => array:20 [
"OfficeName" => "eXp Realty"
"OfficePhone" => "709-800-0412"
"OfficeMlsId" => "exprealty"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "285811"
"ModificationTimestamp" => "2025-04-20T17:56:20Z"
"OfficeAddress1" => "33 Pippy Place, Suite 304"
"OfficeCity" => "St. John's"
"OfficePostalCode" => "A1B3X"
"OfficeStateOrProvince" => "Newfoundland & Labrador"
"OfficeStatus" => "Active"
"OfficeAOR" => "Newfoundland & Labrador"
"OfficeType" => "Firm"
"OfficeAORKey" => "117"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2019-09-19T14:11:00Z"
"OfficeNationalAssociationId" => "1354950"
"OfficeBrokerNationalAssociationId" => "1157864"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29173465')"
+"ID": "470800"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24899
+post_id: "450937"
+post_author: 1
+"ListingKey": "29145111"
+"ListingId": "1292910"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-19T14:11:02Z"
+"RFModificationTimestamp": "2025-12-19T14:13:14Z"
+"ListPrice": 425000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "ST JOHNS"
+"PostalCode": "A1E3C3"
+"UnparsedAddress": "68 Pearce Avenue, ST JOHNS, Newfoundland & Labrador A1E3C3"
+"Coordinates": array:2 [
0 => -52.73438
1 => 47.553574
]
+"Latitude": 47.553574
+"Longitude": -52.73438
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Great investment property in the center of the city , high traffic area and storefront across from MUNDY POND and ROPEWALK LANE . Multi -use main floor has had many uses such as convenience store , hair salon, currently a used furniture and antique store with a kitchen and full bathroom , storage . The units consist of a top floor two bedroom unit , a main floor two bedroom unit and a one bedroom unit all with separate meters . 4 units total . Improvements were made on the property over the years by the current owner , all electric heat and tenants pay there own utilities . multiple vehicle parking , monthly income $3250 , long term tenants , 24 hour notice for all viewings , wont last long in this location . (id:62650)"
+"BusinessType": "Food Services and Beverage,Other,Retail and Wholesale,Residential"
+"CreationDate": "2025-11-28T17:29:27.095308+00:00"
+"Flooring": array:2 [
0 => "Laminate"
1 => "Mixed Flooring"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1571842"
+"ListOfficeKey": "264296"
+"LotSizeDimensions": "80X120"
+"PhotosChangeTimestamp": "2025-12-01T21:13:02Z"
+"PhotosCount": 21
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-12-19T13:52:53Z"
+"StreetName": "Pearce"
+"StreetNumber": "68"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "2837"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29145111/68-pearce-avenue-st-johns"
+"StructureType": array:1 [
0 => "Commercial Mix"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "res/comm"
+"OriginalEntryTimestamp": "2025-11-28T14:42:38.95Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:21 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6350464519"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/77d27ddbe9113452e2e6374cce488bc8.webp"
"MediaSize" => 183468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-77d27ddbe9113452e2e6374cce488bc8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:15.89Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6350464540"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/009fde57cfb3dd56ce8505a44dab3aaf.webp"
"MediaSize" => 130680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-009fde57cfb3dd56ce8505a44dab3aaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.51Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6350464558"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/c4728ce10359c3d3431bbb2b7619446a.webp"
"MediaSize" => 138054
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-c4728ce10359c3d3431bbb2b7619446a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:19.21Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6350464562"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/a0822354a28badd9911bc1080e3b4ef9.webp"
"MediaSize" => 333570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-a0822354a28badd9911bc1080e3b4ef9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:16.55Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6350464571"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/e9f001a7a68cde5811718b36698ccf16.webp"
"MediaSize" => 339114
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-e9f001a7a68cde5811718b36698ccf16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.79Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6350464597"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/6339dbbaab84e06b580a84abdc300fde.webp"
"MediaSize" => 167575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-6339dbbaab84e06b580a84abdc300fde.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.34Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6350464614"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/126a940478eea90358f8fd398a055566.webp"
"MediaSize" => 191854
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-126a940478eea90358f8fd398a055566.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.76Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6350464622"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/773dd87cb1fa985ba00af334d218630e.webp"
"MediaSize" => 286373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-773dd87cb1fa985ba00af334d218630e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:21.2Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6350464675"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/917e36313f2db596e61550dc201967d4.webp"
"MediaSize" => 371682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-917e36313f2db596e61550dc201967d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.86Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6350464701"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/e88258b6589d562a66c9326e556dc690.webp"
"MediaSize" => 333708
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-e88258b6589d562a66c9326e556dc690.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.93Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6350464731"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/9ed84ff26b647c5b13a110c7eff63e7c.webp"
"MediaSize" => 334932
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-9ed84ff26b647c5b13a110c7eff63e7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.64Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6350464766"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/7b418624fb265856be8a8957e0ea4c53.webp"
"MediaSize" => 143709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-7b418624fb265856be8a8957e0ea4c53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:21.06Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6350464792"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/13fe17488d89ceba08713f257bbb38df.webp"
"MediaSize" => 143042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-13fe17488d89ceba08713f257bbb38df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:19.08Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6350464871"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/2549c6e598a104478eb73d95f27bf835.webp"
"MediaSize" => 371264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-2549c6e598a104478eb73d95f27bf835.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.77Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6350464935"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/feba710c646eaf7dc44fdf70da90c5e7.webp"
"MediaSize" => 74384
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-feba710c646eaf7dc44fdf70da90c5e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.07Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6350465001"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/11733a70bbb57243b1c9526001f8743c.webp"
"MediaSize" => 142198
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-11733a70bbb57243b1c9526001f8743c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.51Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6350465025"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/23cd308d668c93385a92d2a39d36f2c9.webp"
"MediaSize" => 108594
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-23cd308d668c93385a92d2a39d36f2c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:21.05Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6350465114"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/417c4b4847c98d600535555042b93597.webp"
"MediaSize" => 328962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-417c4b4847c98d600535555042b93597.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.98Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6350465180"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/6f847edddc5d013934434074b22d5ebe.webp"
"MediaSize" => 342128
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-6f847edddc5d013934434074b22d5ebe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.95Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6350465192"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/15b12dc76c7cd196803a208bd77e801f.webp"
"MediaSize" => 148951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-15b12dc76c7cd196803a208bd77e801f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.42Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6350465271"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/3aaa816b6be5f98562b84f255c2cc7ca.webp"
"MediaSize" => 330544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-3aaa816b6be5f98562b84f255c2cc7ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.97Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "HOLLY RIDEOUT"
"MemberFirstName" => "HOLLY"
"MemberLastName" => "RIDEOUT"
"MemberMlsId" => "66722"
"OriginatingSystemName" => 26
"MemberKey" => "1571842"
"ModificationTimestamp" => "2025-09-02T19:42:04Z"
"MemberStatus" => "Active"
"OfficeKey" => "264296"
"MemberAOR" => "Newfoundland & Labrador"
"Media" => array:1 [ …1]
"MemberFax" => "709-753-5375"
"MemberCity" => "St. John's"
"MemberType" => "Salesperson"
"MemberAORKey" => "117"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberAddress1" => "137 Patrick Street"
"MemberOfficePhone" => "709-687-3892"
"MemberStateOrProvince" => "Newfoundland & Labrador"
"MemberNationalAssociationId" => "1148184"
"OfficeNationalAssociationId" => "1224790"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "Rideout Realty"
"OfficePhone" => "709-687-3892"
"OfficeMlsId" => "14168"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "264296"
"ModificationTimestamp" => "2024-06-19T08:31:11Z"
"OfficeAddress1" => "137 Patrick Street"
"OfficeCity" => "St. John's"
"OfficePostalCode" => "A1E2S9"
"OfficeStateOrProvince" => "Newfoundland & Labrador"
"OfficeStatus" => "Active"
"Media" => array:1 [ …1]
"OfficeAOR" => "Newfoundland & Labrador"
"OfficeFax" => "709-753-5375"
"OfficeType" => "Firm"
"OfficeAORKey" => "117"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2011-06-18T01:26:00Z"
"OfficeNationalAssociationId" => "1224790"
"OfficeBrokerNationalAssociationId" => "1148184"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29145111')"
+"ID": "450937"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25217
+post_id: "448414"
+post_author: 1
+"ListingKey": "29141783"
+"ListingId": "1292919"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T15:35:49Z"
+"RFModificationTimestamp": "2025-11-27T17:08:19Z"
+"ListPrice": 449000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 2724.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1B4S8"
+"UnparsedAddress": "1 Paton Street Unit#008, St. John's, Newfoundland & Labrador A1B4S8"
+"Coordinates": array:2 [
0 => -52.738701
1 => 47.566093
]
+"Latitude": 47.566093
+"Longitude": -52.738701
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Medical Office Space near Memorial University Discover a prime 2724 sq ft condo in St. John's, near Memorial University, offering an exceptional opportunity for medical professionals or versatile business ventures. Key Features: Strategic Location: Close proximity to Memorial University ensures visibility and accessibility, ideal for attracting clients or customers. Versatile Space: Flexible layout allows for customization to suit medical offices or other professional services, maximizing investment potential. Modern Amenities: State-of-the-art infrastructure, including spacious examination rooms, reception areas, and administrative offices. Professional Environment: Sleek design and high-quality finishes create a welcoming atmosphere for clients and staff alike. Convenient Accessibility: Ample parking and proximity to public transportation enhance accessibility for all. Investment Potential: Seize the opportunity to establish a thriving practice or secure a lucrative investment in a growing market. Don't miss out. (id:62650)"
+"BusinessType": "Other,Service"
+"CreationDate": "2025-11-27T17:08:06.007803+00:00"
+"Directions": "Condo is located on the Lower Level of the Building, go down the stairs and turn left"
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1459001"
+"ListOfficeKey": "280379"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "Condo"
+"PhotosChangeTimestamp": "2025-11-27T15:23:11Z"
+"PhotosCount": 23
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-11-27T15:23:11Z"
+"StreetName": "Paton"
+"StreetNumber": "1"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "14312"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29141783/1-paton-street-unit008-st-johns"
+"StructureType": array:1 [
0 => "Other"
]
+"GeocodeManualYN": true
+"ZoningDescription": "Comm."
+"OriginalEntryTimestamp": "2025-11-27T15:23:11.65Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:23 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6342470417"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141783/67dae478f6fd4ed464f44d967dd26d88.webp"
"MediaSize" => 160371
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141783/thumbnail-67dae478f6fd4ed464f44d967dd26d88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292919"
"ResourceRecordKey" => "29141783"
"ModificationTimestamp" => "2025-11-27T15:23:11.66Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6342470420"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141783/4c3523ed82ba8562bfe27a90516712d4.webp"
"MediaSize" => 175452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141783/thumbnail-4c3523ed82ba8562bfe27a90516712d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292919"
"ResourceRecordKey" => "29141783"
"ModificationTimestamp" => "2025-11-27T15:23:11.66Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6342470423"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141783/f2b1d0b1e715ed7974fbcaddcc1d8b6e.webp"
"MediaSize" => 182108
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141783/thumbnail-f2b1d0b1e715ed7974fbcaddcc1d8b6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292919"
"ResourceRecordKey" => "29141783"
"ModificationTimestamp" => "2025-11-27T15:23:11.66Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6342470426"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141783/6490368f303b270c05e068befed8003a.webp"
"MediaSize" => 152291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141783/thumbnail-6490368f303b270c05e068befed8003a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292919"
"ResourceRecordKey" => "29141783"
"ModificationTimestamp" => "2025-11-27T15:23:11.66Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6342470430"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141783/5ed7a929be383f3a999feb30652be942.webp"
"MediaSize" => 242908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141783/thumbnail-5ed7a929be383f3a999feb30652be942.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292919"
"ResourceRecordKey" => "29141783"
"ModificationTimestamp" => "2025-11-27T15:23:11.66Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6342470432"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141783/365a58f3bc041bb69860f86f1cc960a1.webp"
"MediaSize" => 180284
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141783/thumbnail-365a58f3bc041bb69860f86f1cc960a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292919"
"ResourceRecordKey" => "29141783"
"ModificationTimestamp" => "2025-11-27T15:23:11.66Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6342470434"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141783/b8906217debbd71b5b86eb5e28b1be95.webp"
"MediaSize" => 115949
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141783/thumbnail-b8906217debbd71b5b86eb5e28b1be95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292919"
"ResourceRecordKey" => "29141783"
"ModificationTimestamp" => "2025-11-27T15:23:11.66Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6342470436"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141783/1d2ca06596e155e0a7d99cf525538a24.webp"
"MediaSize" => 194897
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141783/thumbnail-1d2ca06596e155e0a7d99cf525538a24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292919"
"ResourceRecordKey" => "29141783"
"ModificationTimestamp" => "2025-11-27T15:23:11.66Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6342470439"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141783/528001515ba05660d8806e0c5e245e55.webp"
"MediaSize" => 115949
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141783/thumbnail-528001515ba05660d8806e0c5e245e55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292919"
"ResourceRecordKey" => "29141783"
"ModificationTimestamp" => "2025-11-27T15:23:11.66Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6342470444"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141783/26be78fadbef4552af9af06e8ca606d2.webp"
"MediaSize" => 124792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141783/thumbnail-26be78fadbef4552af9af06e8ca606d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292919"
"ResourceRecordKey" => "29141783"
"ModificationTimestamp" => "2025-11-27T15:23:11.66Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6342470451"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141783/1e65d29cd0af2ef739200bb4f5093a46.webp"
"MediaSize" => 240998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141783/thumbnail-1e65d29cd0af2ef739200bb4f5093a46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292919"
"ResourceRecordKey" => "29141783"
"ModificationTimestamp" => "2025-11-27T15:23:11.66Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6342470455"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141783/721e0125796a34f2c67f2c62579593b1.webp"
"MediaSize" => 133151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141783/thumbnail-721e0125796a34f2c67f2c62579593b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292919"
"ResourceRecordKey" => "29141783"
"ModificationTimestamp" => "2025-11-27T15:23:11.66Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6342470465"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141783/f9ae05d25519dffdb4c32100ac8f444c.webp"
"MediaSize" => 241122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141783/thumbnail-f9ae05d25519dffdb4c32100ac8f444c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292919"
"ResourceRecordKey" => "29141783"
"ModificationTimestamp" => "2025-11-27T15:23:11.66Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6342470471"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141783/f1a548909c8058ad330ef4be318b98c1.webp"
"MediaSize" => 269396
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141783/thumbnail-f1a548909c8058ad330ef4be318b98c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1292919"
"ResourceRecordKey" => "29141783"
"ModificationTimestamp" => "2025-11-27T15:23:11.66Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6342470480"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141783/62fd96d18c618b693506ab96c1f875ca.webp"
"MediaSize" => 182066
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141783/thumbnail-62fd96d18c618b693506ab96c1f875ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292919"
"ResourceRecordKey" => "29141783"
"ModificationTimestamp" => "2025-11-27T15:23:11.66Z"
]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
]
+"Member": []
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29141783')"
+"ID": "448414"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24894
+post_id: "423526"
+post_author: 1
+"ListingKey": "29110053"
+"ListingId": "1292659"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-17T17:50:55Z"
+"RFModificationTimestamp": "2025-11-17T18:15:30Z"
+"ListPrice": 369000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 2340.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C1A8"
+"UnparsedAddress": "132 Water Street, St. John's, Newfoundland & Labrador A1C1A8"
+"Coordinates": array:2 [
0 => -52.705236
1 => 47.566836
]
+"Latitude": 47.566836
+"Longitude": -52.705236
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Situated in the heart of historic downtown St. John’s, 132 Water Street offers a versatile commercial property in the highly sought-after Commercial Downtown Mixed (CDM) zone. This multi-level building is currently operating with two established businesses: a hair and nail salon on the ground floor and a bustling tattoo studio occupying the upper two floors. With high foot traffic, excellent visibility, and direct street-level access, this property presents an exceptional opportunity for investors or business owners seeking a prime downtown location. The CDM zoning allows for a mix of commercial and residential uses, providing added flexibility for future development or tenant arrangements. All permits, taxes, HST/GST (if applicable), and related approvals will be the responsibility of the purchaser. Don’t miss this rare chance to own a piece of Water Street – a location synonymous with culture, commerce, and character. (id:62650)"
+"BusinessType": "Other,Retail and Wholesale,Residential,Service"
+"CreationDate": "2025-11-17T18:07:53.715619+00:00"
+"Directions": "Directly across from the Alt hotel ."
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2020022"
+"ListOfficeKey": "285811"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2025-11-17T17:42:30Z"
+"PhotosCount": 26
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-11-17T17:42:30Z"
+"StreetName": "Water"
+"StreetNumber": "132"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7555"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29110053/132-water-street-st-johns"
+"StructureType": array:1 [
0 => "Commercial Mix"
]
+"CoListAgentKey": "1991125"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "285811"
+"ZoningDescription": "CMD"
+"OriginalEntryTimestamp": "2025-11-17T17:42:30.16Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:26 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29110053')"
+"ID": "423526"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24911
+post_id: "406547"
+post_author: 1
+"ListingKey": "29086015"
+"ListingId": "1292385"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-10T13:25:07Z"
+"RFModificationTimestamp": "2025-11-10T20:23:32Z"
+"ListPrice": 360000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C2M9"
+"UnparsedAddress": "12 Freshwater Road, St. John's, Newfoundland & Labrador A1C2M9"
+"Coordinates": array:2 [
0 => -52.717398
1 => 47.563822
]
+"Latitude": 47.563822
+"Longitude": -52.717398
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Location,location,location!Well maintained property in a high traffic location. Owner operated, serving great food for many years. Large dining room and large kitchen with lots of storage. Property has a living area on the second floor that could be the living space for a new owner, or possibly a potential rental. Separate entrance for the upstairs space. Mini splits keep the property cozy in the colder months and nice and cool during the summer. The property is fully equipped ready for you to make it your own. Any applicable hst. is the responsibility of the purchaser. (id:62650)"
+"BusinessType": "Restaurant"
+"CreationDate": "2025-11-10T20:23:22.131289+00:00"
+"Heating": array:3 [
0 => "Radiant heat"
1 => "Oil"
2 => "Mini-Split"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1688612"
+"ListOfficeKey": "88627"
+"PhotosChangeTimestamp": "2025-11-10T13:12:57Z"
+"PhotosCount": 7
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-11-10T13:12:57Z"
+"StreetName": "Freshwater"
+"StreetNumber": "12"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3000"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29086015/12-freshwater-road-st-johns"
+"StructureType": array:1 [
0 => "Special Purpose"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "Residential/com"
+"OriginalEntryTimestamp": "2025-11-10T13:12:57.39Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:7 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
]
+"Member": []
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29086015')"
+"ID": "406547"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23526
+post_id: "346911"
+post_author: 1
+"ListingKey": "29025224"
+"ListingId": "1291932"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-24T17:05:25Z"
+"RFModificationTimestamp": "2025-11-24T20:14:44Z"
+"ListPrice": 1475000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 10546.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C1H3"
+"UnparsedAddress": "288-290 Duckworth Street, St. John's, Newfoundland & Labrador A1C1H3"
+"Coordinates": array:2 [
0 => -52.707038
1 => 47.565481
]
+"Latitude": 47.565481
+"Longitude": -52.707038
+"YearBuilt": 1890
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Iconic building for sale on the corner of Duckworth and Cathedral Street in the heart of downtown St. John’s. This building houses the world-famous Number 4 Restaurant, a two-story culinary masterpiece featuring one of the city’s best all-season covered decks, exceptional design, finishes, menu, bar menu, and execution. There are also four occupied apartment units with private entrances, decks, laundry, and modern finishes with much of the original character of the building maintained. On the Duckworth Street side, there’s a vacant main floor bar, well-established Tattoos by Gabby and Andrew on the second floor, and an additional vacant office space with a street-side entrance. This is an exceptional building, well-managed, and in good repair, with eight income-producing units. Please see the 3D tour, ask for the info package, or book a viewing, to own this special piece of downtown St. John’s. Note - in the 3D tour - there's additional links in the restaurant lobby to connect to each individual unit in the building. (id:62650)"
+"BusinessType": "Other"
+"CreationDate": "2025-10-23T20:19:59.386990+00:00"
+"Flooring": array:2 [
0 => "Wood"
1 => "Mixed Flooring"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1572241"
+"ListOfficeKey": "293977"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "56x84X60x108"
+"PhotosChangeTimestamp": "2025-10-23T18:23:40Z"
+"PhotosCount": 46
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-11-24T16:54:54Z"
+"StreetName": "Duckworth"
+"StreetNumber": "288-290"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "38570"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=h4M6wZgMPLQ"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29025224/288-290-duckworth-street-st-johns"
+"StructureType": array:1 [
0 => "Other"
]
+"CommonInterest": "Freehold"
+"BuildingFeatures": array:2 [
0 => "Laundry Facility"
1 => "Living Accommodation"
]
+"ZoningDescription": "CDM"
+"OriginalEntryTimestamp": "2025-10-23T18:23:39.88Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:19 [ …19]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29025224')"
+"ID": "346911"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24847
+post_id: "341214"
+post_author: 1
+"ListingKey": "27725884"
+"ListingId": "1280231"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-14T19:25:35Z"
+"RFModificationTimestamp": "2025-11-14T19:27:07Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 5483.0
+"BuildingAreaTotal": 0
+"City": "St.John's"
+"PostalCode": "A1E2V7"
+"UnparsedAddress": "47 Leslie Street, St.John's, Newfoundland & Labrador A1E2V7"
+"Coordinates": array:2 [
0 => -52.723593
1 => 47.549554
]
+"Latitude": 47.549554
+"Longitude": -52.723593
+"YearBuilt": 1930
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Outstanding opportunity to own a versatile 5,483 sq. ft. three-story building situated on a spacious 12,154 sq. ft. corner lot in a highly desirable west-end location. Zoned R3, this property offers excellent potential for redevelopment or conversion to a multi-unit residential building. Previously occupied by medical practices, the building features kitchenettes, washrooms, and multiple office spaces on both the main and second floors. The third floor features additional offices, a bathroom, and a large skylight that opens to the level below, providing natural light throughout. The 1,216 sq. ft. basement offers abundant storage space with convenient exterior access. Additional highlights include a 400-amp electrical service with four separate meters and on-site parking for 10 vehicles at the front of the building. A rare opportunity for investors or developers seeking a solid property with excellent versatility and strong future potential in a prime west-end location. This property is being sold "AS IS WHERE IS". (id:62650)"
+"BusinessType": "Other,Service"
+"CreationDate": "2025-10-22T13:47:50.823664+00:00"
+"Flooring": array:1 [
0 => "Mixed Flooring"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1572005"
+"ListOfficeKey": "275242"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "12,154"
+"PhotosChangeTimestamp": "2025-11-14T18:40:21Z"
+"PhotosCount": 48
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-11-14T19:14:00Z"
+"Stories": "4.0"
+"StreetName": "Leslie"
+"StreetNumber": "47"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "9926.75"
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2025
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/27725884/47-leslie-street-stjohns"
+"StructureType": array:1 [
0 => "Commercial Mix"
]
+"CoListAgentKey": "1572008"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "275242"
+"BuildingFeatures": array:1 [
0 => "Laundry Facility"
]
+"ZoningDescription": "R3"
+"OriginalEntryTimestamp": "2024-12-10T12:52:38.5Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"Member": []
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('27725884')"
+"ID": "341214"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24896
+post_id: "296490"
+post_author: 1
+"ListingKey": "28955793"
+"ListingId": "1291083"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-16T18:55:41Z"
+"RFModificationTimestamp": "2025-12-16T18:59:59Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C1A9"
+"UnparsedAddress": "202 Water Street, St. John's, Newfoundland & Labrador A1C1A9"
+"Coordinates": array:2 [
0 => -52.707178
1 => 47.564323
]
+"Latitude": 47.564323
+"Longitude": -52.707178
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Exceptional Investment on Historic Water Street in Downtown St. John’s. This is a rare opportunity to own a fully leased mixed-use property in one of the city’s most desirable locations. Situated at 202 Water Street, the building features two commercial storefronts on the main and second floors, along with a residential apartment on the third floor, offering a strong tenant mix and dependable income. Generating an annual income of approximately $67,000, this property provides both consistent cash flow and long-term value. Located along the designated Pedestrian Mall, it benefits from some of the highest foot traffic during the summer months, making it an ideal spot for retail or service-based businesses. With its classic brick façade, excellent street visibility, and prime downtown setting, this property is perfect for investors looking to expand their portfolio or buyers seeking a signature commercial space in one of St. John’s most vibrant areas. (id:62650)"
+"BusinessType": "Food Services and Beverage,Other,Retail and Wholesale,Service"
+"CreationDate": "2025-10-06T17:57:42.272884+00:00"
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2141852"
+"ListOfficeKey": "88563"
+"PhotosChangeTimestamp": "2025-10-06T16:54:01Z"
+"PhotosCount": 1
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-12-16T18:42:35Z"
+"StreetName": "Water"
+"StreetNumber": "202"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4770"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/28955793/202-water-street-st-johns"
+"StructureType": array:1 [
0 => "Retail"
]
+"CoListAgentKey": "2196213"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "88563"
+"GeocodeManualYN": true
+"ZoningDescription": "Comm"
+"OriginalEntryTimestamp": "2025-10-06T16:54:01.85Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:1 [
0 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28955793')"
+"ID": "296490"
}
]
+success: true
+page_size: 9
+page_count: 3
+count: 23
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]