array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29110053/Property?$select=ALL&$top=20&$filter=ListingKey eq 29110053&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29110053/Property?$select=ALL&$top=20&$filter=ListingKey eq 29110053&$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: "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 [
"Order" => 0
"MediaKey" => "6326528032"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/33907e35a64903229cbedcd0d8a017ee.webp"
"MediaSize" => 174405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-33907e35a64903229cbedcd0d8a017ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6326528064"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/d9e7a4aa83a741c7293d6c78175831c5.webp"
"MediaSize" => 276112
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-d9e7a4aa83a741c7293d6c78175831c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6326528182"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/816629a5578c58ae36527427bf37ef8a.webp"
"MediaSize" => 289528
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-816629a5578c58ae36527427bf37ef8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6326528324"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/56ec2c412de5dc68caaea69161913d02.webp"
"MediaSize" => 209865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-56ec2c412de5dc68caaea69161913d02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6326528404"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/ed9aa5159790897ac8cead26b805bb70.webp"
"MediaSize" => 209442
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-ed9aa5159790897ac8cead26b805bb70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6326528471"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/16adb2ccb69640a4793fa7de88099421.webp"
"MediaSize" => 99946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-16adb2ccb69640a4793fa7de88099421.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6326528523"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/cb7d690edd1899a8a88278d5587f7e63.webp"
"MediaSize" => 200086
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-cb7d690edd1899a8a88278d5587f7e63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6326528611"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/2a06d9bff8edf576e6d56c6e3bf8e6cf.webp"
"MediaSize" => 232295
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-2a06d9bff8edf576e6d56c6e3bf8e6cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6326528718"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/b286062bfb9598b7b9007eeb36cf85c4.webp"
"MediaSize" => 226638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-b286062bfb9598b7b9007eeb36cf85c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6326528781"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/5eef0f1c7d40a4647067d9073c9a05ff.webp"
"MediaSize" => 249117
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-5eef0f1c7d40a4647067d9073c9a05ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6326528865"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/907db00002e959f407818cd8608e808e.webp"
"MediaSize" => 187886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-907db00002e959f407818cd8608e808e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6326528899"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/7350ada3d508cbd9c84085dcee596544.webp"
"MediaSize" => 241436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-7350ada3d508cbd9c84085dcee596544.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6326528932"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/3f304fac6d44df45c640c01dcb7f10a7.webp"
"MediaSize" => 246659
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-3f304fac6d44df45c640c01dcb7f10a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6326528948"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/a0c06c45e4c8e0f6926dadca00b9da0c.webp"
"MediaSize" => 253041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-a0c06c45e4c8e0f6926dadca00b9da0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6326529041"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/74b9e48acf21c17f7cfad59c08b87087.webp"
"MediaSize" => 233033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-74b9e48acf21c17f7cfad59c08b87087.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6326529145"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/749a9cc6aa21fa87c26af81a2d0ff9ba.webp"
"MediaSize" => 130845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-749a9cc6aa21fa87c26af81a2d0ff9ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6326529193"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/5526f7dadeece44d16e18de8d3f64f5e.webp"
"MediaSize" => 130531
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-5526f7dadeece44d16e18de8d3f64f5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6326529294"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/35482c6784cef648a00095b40fe89ab8.webp"
"MediaSize" => 111659
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-35482c6784cef648a00095b40fe89ab8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6326529323"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/09538b80399be97ccfd339e451cfba82.webp"
"MediaSize" => 143096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-09538b80399be97ccfd339e451cfba82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6326529428"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/a527a8cdb709545eed7441ae1fcae6f0.webp"
"MediaSize" => 118006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-a527a8cdb709545eed7441ae1fcae6f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6326529476"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/1a830e1c73dffb4f4e1a48edab580983.webp"
"MediaSize" => 241041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-1a830e1c73dffb4f4e1a48edab580983.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6326529564"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/145ecb2926619916348bafd040f625aa.webp"
"MediaSize" => 208394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-145ecb2926619916348bafd040f625aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6326529595"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/9842cbafae0a00326efc2b4fbb3ffdf3.webp"
"MediaSize" => 241222
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-9842cbafae0a00326efc2b4fbb3ffdf3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6326529655"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/ff3ade0d94e5362d26c4d3a00057bceb.webp"
"MediaSize" => 212391
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-ff3ade0d94e5362d26c4d3a00057bceb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6326529717"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/724df0689a5f5ed888200296aed33fc7.webp"
"MediaSize" => 263118
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-724df0689a5f5ed888200296aed33fc7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6326529720"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29110053/6f3671ae77863dc0504ec950e109783a.webp"
"MediaSize" => 257379
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29110053/thumbnail-6f3671ae77863dc0504ec950e109783a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292659"
"ResourceRecordKey" => "29110053"
"ModificationTimestamp" => "2025-11-17T17:42:30.16Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "MICHAEL SAMSON"
"MemberFirstName" => "MICHAEL"
"MemberLastName" => "SAMSON"
"MemberMlsId" => "132141"
"OriginatingSystemName" => 26
"MemberKey" => "2020022"
"ModificationTimestamp" => "2025-10-14T21:43:17Z"
"MemberStatus" => "Active"
"OfficeKey" => "285811"
"MemberAOR" => "Newfoundland & Labrador"
"MemberFax" => "709-522-6350"
"MemberCity" => "St. John's"
"MemberType" => "Salesperson"
"MemberAORKey" => "117"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberAddress1" => "33 Pippy Place, Suite 304"
"MemberOfficePhone" => "709-325-1028"
"MemberStateOrProvince" => "Newfoundland & Labrador"
"OriginalEntryTimestamp" => "2016-10-07T16:27:00Z"
"MemberNationalAssociationId" => "1300090"
"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('29110053')"
+"ID": "423526"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 285811/Office?$select=ALL&$top=10&$filter=OfficeKey eq 285811&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 285811/Office?$select=ALL&$top=10&$filter=OfficeKey eq 285811&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25321
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25323
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "eXp Realty"
+"OfficeEmail": null
+"OfficePhone": "709-800-0412"
+"OfficeMlsId": "exprealty"
+"ModificationTimestamp": "2025-04-20T17:56:20Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "285811"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "33 Pippy Place, Suite 304"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "St. John's"
+"OfficePostalCode": "A1B3X"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Newfoundland & Labrador"
+"OfficeStatus": "Active"
+"OfficeAOR": "Newfoundland & Labrador"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1354950"
+"OriginalEntryTimestamp": "2019-09-19T14:11:00Z"
+"OfficeAORKey": "117"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "431082"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "285811"
"SocialMediaUrlOrId" => "http://exprealty.ca/"
"ModificationTimestamp" => "2025-04-20T17:41:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1157864"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('285811')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2020022/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2020022&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2020022/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2020022&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25326
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.26 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29110053" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24956
+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 29110053/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29110053&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29110053/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29110053&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24936
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29110053 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.705236 47.566836)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29110053 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.705236 47.566836)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29110053 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.705236 47.566836)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29110053 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.705236 47.566836)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24855
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24866
+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"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24769
+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"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24870
+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 [
"Order" => 0
"MediaKey" => "6306182458"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29086015/37f09272d6d6c198733b8be6459e2cd9.webp"
"MediaSize" => 272877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29086015/thumbnail-37f09272d6d6c198733b8be6459e2cd9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1292385"
"ResourceRecordKey" => "29086015"
"ModificationTimestamp" => "2025-11-10T13:12:57.4Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6306182468"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29086015/9b83d4062e66043c3f22de08dd4d955d.webp"
"MediaSize" => 293575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29086015/thumbnail-9b83d4062e66043c3f22de08dd4d955d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292385"
"ResourceRecordKey" => "29086015"
"ModificationTimestamp" => "2025-11-10T13:12:57.4Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6306182505"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29086015/1b830398f06b0227b549f5803a1bb3bf.webp"
"MediaSize" => 242648
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29086015/thumbnail-1b830398f06b0227b549f5803a1bb3bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292385"
"ResourceRecordKey" => "29086015"
"ModificationTimestamp" => "2025-11-10T13:12:57.4Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6306182556"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29086015/0ec3fa1f8e382dcb8ce17cfe99f3d1b7.webp"
"MediaSize" => 178915
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29086015/thumbnail-0ec3fa1f8e382dcb8ce17cfe99f3d1b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292385"
"ResourceRecordKey" => "29086015"
"ModificationTimestamp" => "2025-11-10T13:12:57.4Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6306182581"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29086015/280a80b06623f2394fb86f8d52afbff1.webp"
"MediaSize" => 157126
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29086015/thumbnail-280a80b06623f2394fb86f8d52afbff1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292385"
"ResourceRecordKey" => "29086015"
"ModificationTimestamp" => "2025-11-10T13:12:57.4Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6306182606"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29086015/e40eb14d9d6f40f026dde6d9d190fb8a.webp"
"MediaSize" => 173570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29086015/thumbnail-e40eb14d9d6f40f026dde6d9d190fb8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292385"
"ResourceRecordKey" => "29086015"
"ModificationTimestamp" => "2025-11-10T13:12:57.4Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6306182642"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29086015/8ef50e06b9e9f51739478cead260e712.webp"
"MediaSize" => 183159
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29086015/thumbnail-8ef50e06b9e9f51739478cead260e712.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292385"
"ResourceRecordKey" => "29086015"
"ModificationTimestamp" => "2025-11-10T13:12:57.4Z"
]
]
+"Member": []
+"Office": array:1 [
0 => array:20 [
"OfficeName" => "Hanlon Realty"
"OfficePhone" => "709-738-6200"
"OfficeMlsId" => "10139"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "88627"
"ModificationTimestamp" => "2025-11-24T16:37:51Z"
"OfficeAddress1" => "385 East White Hills Road"
"OfficeCity" => "St. John's"
"OfficePostalCode" => "A1A5X"
"OfficeStateOrProvince" => "Newfoundland & Labrador"
"OfficeStatus" => "Active"
"OfficeAOR" => "Newfoundland & Labrador"
"OfficeFax" => "709-738-6201"
"OfficeType" => "Firm"
"OfficeAORKey" => "117"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OfficeNationalAssociationId" => "1007257"
"OfficeBrokerNationalAssociationId" => "1033506"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29086015')"
+"ID": "406547"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24857
+post_id: "393830"
+post_author: 1
+"ListingKey": "29070247"
+"ListingId": "1292350"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T16:41:12Z"
+"RFModificationTimestamp": "2025-11-27T16:46:55Z"
+"ListPrice": 299900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1400.0
+"BuildingAreaTotal": 0
+"City": "ST JOHN'S"
+"PostalCode": "A1B2L9"
+"UnparsedAddress": "32 PORTUGAL COVE Road, ST JOHN'S, Newfoundland & Labrador A1B2L9"
+"Coordinates": array:2 [
0 => -52.710318
1 => 47.578582
]
+"Latitude": 47.578582
+"Longitude": -52.710318
+"YearBuilt": 1953
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "STEP INTO A READY-TO-OPERATE BUSINESS THATS A COMMUNITY FAVORITE .RARE OPPORTUNITY TO ACQUIRE A THRIVING,WELL ESTABLISHED CONVENIENCE STORE AND DELI WITH A LOYAL CUSTOMER BASE AND PROVEN PROFITABILITY. YES BREENS ON 32 PORTUGAL COVE RD IS NOW BEING OFFERED TO THE MARKET. STRATEGICALLY LOCATED IN A HIGH TRAFFIC AREA WITH CONSISTANT FOOT AND VEHICLE TRAFFIC. KEY FEATURES: INCLUDES FULLY EQUIPPED AS YOU WILL VIEW WITH SOME SUPPLIER EXCEPTIONS PLEASE REVIEW PROPERTY CONDITION DISCLOSURE STATEMENT UNDER DOCUMENTS SERIOUS INQUIRIES ONLY (id:62650)"
+"BusinessType": "Retail and Wholesale"
+"CreationDate": "2025-11-06T08:58:04.058937+00:00"
+"Heating": array:3 [
0 => "Baseboard heaters"
1 => "Electric"
2 => "Mini-Split"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1571878"
+"ListOfficeKey": "88555"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40X81"
+"PhotosChangeTimestamp": "2025-11-05T17:50:15Z"
+"PhotosCount": 8
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-11-27T16:23:01Z"
+"Stories": "1.0"
+"StreetName": "PORTUGAL COVE"
+"StreetNumber": "32"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5614"
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2025
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29070247/32-portugal-cove-road-st-johns"
+"StructureType": array:1 [
0 => "Retail"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Air Conditioning"
]
+"ZoningDescription": "C-TOLERANCE"
+"OriginalEntryTimestamp": "2025-11-05T17:13:23.65Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:8 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6296805889"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070247/60f610bfc5241bcc77e2672c68888afe.webp"
"MediaSize" => 240922
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070247/thumbnail-60f610bfc5241bcc77e2672c68888afe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1292350"
"ResourceRecordKey" => "29070247"
"ModificationTimestamp" => "2025-11-05T17:50:14.58Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6296805986"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070247/e07de2dac0ccea7023674536ebc45686.webp"
"MediaSize" => 298000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070247/thumbnail-e07de2dac0ccea7023674536ebc45686.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292350"
"ResourceRecordKey" => "29070247"
"ModificationTimestamp" => "2025-11-05T17:50:14.64Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6296806026"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070247/060e6ebe82bf405a07cd5f664a209542.webp"
"MediaSize" => 258853
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070247/thumbnail-060e6ebe82bf405a07cd5f664a209542.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292350"
"ResourceRecordKey" => "29070247"
"ModificationTimestamp" => "2025-11-05T17:50:15.94Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6296806053"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070247/a1d3564548db81e9f240dd8ff2cbbc2d.webp"
"MediaSize" => 240208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070247/thumbnail-a1d3564548db81e9f240dd8ff2cbbc2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292350"
"ResourceRecordKey" => "29070247"
"ModificationTimestamp" => "2025-11-05T17:50:14.68Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6296806132"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070247/9b0affab06a68f06dec53b3f0c946d5c.webp"
"MediaSize" => 187257
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070247/thumbnail-9b0affab06a68f06dec53b3f0c946d5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292350"
"ResourceRecordKey" => "29070247"
"ModificationTimestamp" => "2025-11-05T17:50:15.9Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6296806233"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070247/0d11dd527abb5b0a8847c1bf2e2d92c6.webp"
"MediaSize" => 251239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070247/thumbnail-0d11dd527abb5b0a8847c1bf2e2d92c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292350"
"ResourceRecordKey" => "29070247"
"ModificationTimestamp" => "2025-11-05T17:50:15.86Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6296806321"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070247/5c0dffeea57709365c2e7ab97ceb2931.webp"
"MediaSize" => 243269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070247/thumbnail-5c0dffeea57709365c2e7ab97ceb2931.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292350"
"ResourceRecordKey" => "29070247"
"ModificationTimestamp" => "2025-11-05T17:50:15.82Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6296806357"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070247/215bca2d702956b2379eaa84620d907d.webp"
"MediaSize" => 248851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070247/thumbnail-215bca2d702956b2379eaa84620d907d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292350"
"ResourceRecordKey" => "29070247"
"ModificationTimestamp" => "2025-11-05T17:50:15.69Z"
]
]
+"Member": []
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "RE/MAX Realty Specialists"
"OfficePhone" => "709-726-8300"
"OfficeMlsId" => "10237"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "88555"
"ModificationTimestamp" => "2025-03-27T14:03:54Z"
"OfficeAddress1" => "202-125 Kelsey Drive"
"OfficeCity" => "St. John's"
"OfficePostalCode" => "A1B0L"
"OfficeStateOrProvince" => "Newfoundland & Labrador"
"OfficeStatus" => "Active"
"Media" => array:1 [ …1]
"OfficeAOR" => "Newfoundland & Labrador"
"OfficeFax" => "709-726-4219"
"OfficeType" => "Firm"
"OfficeAORKey" => "117"
"OfficeCountry" => "Canada"
"OfficeNationalAssociationId" => "1007294"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1126195"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29070247')"
+"ID": "393830"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24795
+post_id: "378620"
+post_author: 1
+"ListingKey": "29052151"
+"ListingId": "1292177"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-02T12:55:24Z"
+"RFModificationTimestamp": "2025-11-02T12:58:43Z"
+"ListPrice": 275000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "St.John's"
+"PostalCode": "A1B1S1"
+"UnparsedAddress": "100 Elizabeth Avenue Unit#004, St.John's, Newfoundland & Labrador A1B1S1"
+"Coordinates": array:2 [
0 => -52.716084
1 => 47.580729
]
+"Latitude": 47.580729
+"Longitude": -52.716084
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Welcome to 100 Elizabeth Avenue. This versatile commercial space is a 1245 square-foot gem awaiting an exceptional opportunity for your business and is in the heart of St. John’s most popular, trend setting neighborhoods. Situated in the lower level of the Elizabeth Towers Condo complex, this space perfectly captures the essence of downtown and uptown vibes. The optimal layout includes a waiting area, six office spaces, with one office transformed into a functional board room and is ideal for private consultations, group meetings and/or training opportunities. This innovative, exemplary space offers endless possibilities for any business venture. Don't miss this rare opportunity to be part of a neighborhood which seamlessly blends tradition with contemporary flair. This space is not just a location; it's an opportunity to be a part of a vibrant community where success is waiting for you. (id:62650)"
+"BusinessType": "Service"
+"CreationDate": "2025-11-01T01:16:25.482614+00:00"
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1878693"
+"ListOfficeKey": "88555"
+"PhotosChangeTimestamp": "2025-11-02T12:42:09Z"
+"PhotosCount": 16
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-11-02T12:42:09Z"
+"StreetName": "Elizabeth"
+"StreetNumber": "100"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "1816"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=8nv9wQNw6Tn&brand=0"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29052151/100-elizabeth-avenue-unit004-stjohns"
+"StructureType": array:1 [
0 => "Offices"
]
+"BuildingFeatures": array:1 [
0 => "Air Conditioning"
]
+"ZoningDescription": "Comm."
+"OriginalEntryTimestamp": "2025-10-31T13:52:57.79Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:16 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6292113412"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29052151/725883a2e3f1563bb60c524f3a27c285.webp"
"MediaSize" => 71518
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29052151/thumbnail-725883a2e3f1563bb60c524f3a27c285.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1292177"
"ResourceRecordKey" => "29052151"
"ModificationTimestamp" => "2025-11-02T12:40:11.96Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6292113414"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29052151/5272bb57dfcdd0c2c153643b41306b45.webp"
"MediaSize" => 90488
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29052151/thumbnail-5272bb57dfcdd0c2c153643b41306b45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292177"
"ResourceRecordKey" => "29052151"
"ModificationTimestamp" => "2025-11-02T12:40:14.1Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6292113415"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29052151/a289afce6f61e994dc583309412b2394.webp"
"MediaSize" => 109088
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29052151/thumbnail-a289afce6f61e994dc583309412b2394.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292177"
"ResourceRecordKey" => "29052151"
"ModificationTimestamp" => "2025-11-02T12:40:13.88Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6292113418"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29052151/4189e2a84c2430d393b8cf215945f316.webp"
"MediaSize" => 120652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29052151/thumbnail-4189e2a84c2430d393b8cf215945f316.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292177"
"ResourceRecordKey" => "29052151"
"ModificationTimestamp" => "2025-11-02T12:40:14.18Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6292113422"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29052151/49ef9891cca44713d72a5fcb99240a91.webp"
"MediaSize" => 104802
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29052151/thumbnail-49ef9891cca44713d72a5fcb99240a91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292177"
"ResourceRecordKey" => "29052151"
"ModificationTimestamp" => "2025-11-02T12:40:14.15Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6292113423"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29052151/b6ab0ce22b77743453e1cbaf28be064a.webp"
"MediaSize" => 107882
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29052151/thumbnail-b6ab0ce22b77743453e1cbaf28be064a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292177"
"ResourceRecordKey" => "29052151"
"ModificationTimestamp" => "2025-11-02T12:40:14.13Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6292113428"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29052151/ff45d75065d3e838516f85f2affcf7bd.webp"
"MediaSize" => 126429
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29052151/thumbnail-ff45d75065d3e838516f85f2affcf7bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292177"
"ResourceRecordKey" => "29052151"
"ModificationTimestamp" => "2025-11-02T12:40:12.64Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6292113434"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29052151/ae3e097d3d39cb435f764a4350a3d62f.webp"
"MediaSize" => 149226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29052151/thumbnail-ae3e097d3d39cb435f764a4350a3d62f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292177"
"ResourceRecordKey" => "29052151"
"ModificationTimestamp" => "2025-11-02T12:40:14.11Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6292113436"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29052151/5d940699022f40829174c9e488254751.webp"
"MediaSize" => 147105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29052151/thumbnail-5d940699022f40829174c9e488254751.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292177"
"ResourceRecordKey" => "29052151"
"ModificationTimestamp" => "2025-11-02T12:40:14.16Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6292113443"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29052151/d6c3a04b6c9e2299605062bc92ea7aae.webp"
"MediaSize" => 168622
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29052151/thumbnail-d6c3a04b6c9e2299605062bc92ea7aae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292177"
"ResourceRecordKey" => "29052151"
"ModificationTimestamp" => "2025-11-02T12:40:13.86Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6292113447"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29052151/fa3135f43d376d602e0e3c061cd32896.webp"
"MediaSize" => 124531
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29052151/thumbnail-fa3135f43d376d602e0e3c061cd32896.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292177"
"ResourceRecordKey" => "29052151"
"ModificationTimestamp" => "2025-11-02T12:40:14.11Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6292113452"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29052151/1622f0283e891066ec122f036debee97.webp"
"MediaSize" => 126512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29052151/thumbnail-1622f0283e891066ec122f036debee97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292177"
"ResourceRecordKey" => "29052151"
"ModificationTimestamp" => "2025-11-02T12:40:14.18Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6292113454"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29052151/673ad4d1412c845407378b3802d26f08.webp"
"MediaSize" => 146729
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29052151/thumbnail-673ad4d1412c845407378b3802d26f08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292177"
"ResourceRecordKey" => "29052151"
"ModificationTimestamp" => "2025-11-02T12:40:13.9Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6292113458"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29052151/3fcb7f160631a50eb368ea6d5dcf4029.webp"
"MediaSize" => 156638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29052151/thumbnail-3fcb7f160631a50eb368ea6d5dcf4029.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292177"
"ResourceRecordKey" => "29052151"
"ModificationTimestamp" => "2025-11-02T12:40:13.98Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6292113462"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29052151/87d315b982f6ee5478d95b637c141f30.webp"
"MediaSize" => 149613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29052151/thumbnail-87d315b982f6ee5478d95b637c141f30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292177"
"ResourceRecordKey" => "29052151"
"ModificationTimestamp" => "2025-11-02T12:40:14.15Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6292113464"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29052151/55862cb606560be9bec35189422611fb.webp"
"MediaSize" => 118373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29052151/thumbnail-55862cb606560be9bec35189422611fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292177"
"ResourceRecordKey" => "29052151"
"ModificationTimestamp" => "2025-11-02T12:40:14.09Z"
]
]
+"Member": array:1 [
0 => array:24 [
"MemberFullName" => "CHRIS HODDER"
"MemberFirstName" => "CHRIS"
"MemberLastName" => "HODDER"
"MemberMlsId" => "98035"
"OriginatingSystemName" => 26
"MemberKey" => "1878693"
"ModificationTimestamp" => "2025-12-01T21:30:46Z"
"MemberStatus" => "Active"
"OfficeKey" => "88555"
"MemberAOR" => "Newfoundland & Labrador"
"Media" => array:1 [ …1]
"MemberFax" => "709-726-4219"
"MemberCity" => "St. John's"
"MemberType" => "Salesperson"
"MemberAORKey" => "117"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberAddress1" => "202-125 Kelsey Drive"
"MemberOfficePhone" => "709-682-6476"
"MemberSocialMedia" => array:2 [ …2]
"MemberStateOrProvince" => "Newfoundland & Labrador"
"OriginalEntryTimestamp" => "2010-01-09T07:01:00Z"
"MemberNationalAssociationId" => "1205508"
"OfficeNationalAssociationId" => "1007294"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "RE/MAX Realty Specialists"
"OfficePhone" => "709-726-8300"
"OfficeMlsId" => "10237"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "88555"
"ModificationTimestamp" => "2025-03-27T14:03:54Z"
"OfficeAddress1" => "202-125 Kelsey Drive"
"OfficeCity" => "St. John's"
"OfficePostalCode" => "A1B0L"
"OfficeStateOrProvince" => "Newfoundland & Labrador"
"OfficeStatus" => "Active"
"Media" => array:1 [ …1]
"OfficeAOR" => "Newfoundland & Labrador"
"OfficeFax" => "709-726-4219"
"OfficeType" => "Firm"
"OfficeAORKey" => "117"
"OfficeCountry" => "Canada"
"OfficeNationalAssociationId" => "1007294"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1126195"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29052151')"
+"ID": "378620"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25172
+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 [
"Order" => 0
"MediaKey" => "6269996831"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29025224/a8d681c60bb616ca6e6c094233182bdd.webp"
"MediaSize" => 333314
"MediaType" => "webp"
…8
]
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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23526
+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"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24797
+post_id: "296491"
+post_author: 1
+"ListingKey": "28955794"
+"ListingId": "1291081"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-16T18:55:41Z"
+"RFModificationTimestamp": "2025-12-16T18:59:59Z"
+"ListPrice": 770000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C1B8"
+"UnparsedAddress": "302-304 Water Street, St. John's, Newfoundland & Labrador A1C1B8"
+"Coordinates": array:2 [
0 => -52.709954
1 => 47.562014
]
+"Latitude": 47.562014
+"Longitude": -52.709954
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Prime Mixed-Use Investment in the Heart of Downtown St. John’s. Discover 302-304 Water Street, a rare opportunity to own a versatile and income-generating property in one of the city’s most iconic and high-traffic areas. This property features two commercial units on the main level, currently occupied by Hollow Noggin Vape Shop and a restaurant, along with two residential apartments on the upper floors, offering a strong tenant mix and consistent returns. Generating an annual income of approximately $83,000, it provides both stability and long-term growth potential. With rear access to Mahon’s Lane and a direct connection to George Street, the property benefits from exceptional visibility and foot traffic year-round. Surrounded by established businesses and high-value buildings, 302-304 Water Street is an ideal investment for those looking to expand their portfolio or secure a landmark asset in one of St. John’s most desirable downtown locations. (id:62650)"
+"BusinessType": "Other,Service"
+"CreationDate": "2025-10-06T17:57:41.785273+00:00"
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2141852"
+"ListOfficeKey": "88563"
+"PhotosChangeTimestamp": "2025-10-06T16:54:02Z"
+"PhotosCount": 1
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-12-16T18:42:36Z"
+"StreetName": "Water"
+"StreetNumber": "302-304"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5830"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/28955794/302-304-water-street-st-johns"
+"StructureType": array:1 [
0 => "Other"
]
+"CoListAgentKey": "2196213"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "88563"
+"GeocodeManualYN": true
+"ZoningDescription": "CDM"
+"OriginalEntryTimestamp": "2025-10-06T16:54:01.97Z"
+"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('28955794')"
+"ID": "296491"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24838
+post_id: "282766"
+post_author: 1
+"ListingKey": "28949178"
+"ListingId": "1291146"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-03T19:20:40Z"
+"RFModificationTimestamp": "2025-10-03T21:21:28Z"
+"ListPrice": 349900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 2775.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C1V4"
+"UnparsedAddress": "113-117 Longs Hill, St. John's, Newfoundland & Labrador A1C1V4"
+"Coordinates": array:2 [
0 => -52.713347
1 => 47.564468
]
+"Latitude": 47.564468
+"Longitude": -52.713347
+"YearBuilt": 1955
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Discover a unique mixed-use property at the top of Long’s Hill in the heart of downtown St. John’s, offering an excellent opportunity for entrepreneurs or investors. The main floor features a commercial space currently leased as a restaurant, ideal for a variety of business ventures in a high-visibility location. Upstairs, the residential unit includes three bedrooms, one bathroom, and classic hardwood floors, providing a comfortable living space in a vibrant urban setting. The basement offers ample storage, perfect for business or personal use. With updated plumbing and mostly vinyl windows, the property ensures functionality and efficiency. Situated close to grocery stores and the lively downtown core, this property is well-positioned for convenience and accessibility, making it a compelling choice for those seeking a live-work lifestyle or a multi-unit investment in one of St. John’s most dynamic areas. For more details or to schedule a viewing, reach out today. (id:62650)"
+"BusinessType": "Other"
+"CreationDate": "2025-10-03T21:21:23.492606+00:00"
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2058349"
+"ListOfficeKey": "88555"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "20x45"
+"PhotosChangeTimestamp": "2025-10-03T19:13:20Z"
+"PhotosCount": 20
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-10-03T19:13:20Z"
+"StreetName": "Longs"
+"StreetNumber": "113-117"
+"StreetSuffix": "Hill"
+"TaxAnnualAmount": "3836"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=rVykrrdRWmR"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/28949178/113-117-longs-hill-st-johns"
+"StructureType": array:1 [
0 => "Other"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "COM/RES MIX"
+"OriginalEntryTimestamp": "2025-10-03T19:13:20.35Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:20 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28949178')"
+"ID": "282766"
}
]
+success: true
+page_size: 9
+page_count: 3
+count: 21
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]