array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 27653989 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
+post_id: "952660"
+post_author: 1
+"ListingKey": "27653989"
+"ListingId": "1279626"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T14:40:01Z"
+"RFModificationTimestamp": "2026-06-26T14:57:41Z"
+"ListPrice": 230000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1496.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1A2C2"
+"UnparsedAddress": "99 New Cove Road, St. John's, Newfoundland & Labrador A1A2C2"
+"Coordinates": array:2 [
0 => -52.708798
1 => 47.581132
]
+"Latitude": 47.581132
+"Longitude": -52.708798
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Take advantage of this opportunity to own a commercial space in the vibrant east end of St. John's! Located at 99 New Cove Road, this property presents an ideal investment for your future. The main floor boasts a spacious storefront with a large window, ensuring excellent visibility and an open layout that can be tailored to meet your business requirements. The space is equipped with a convenient main floor bathroom and kitchenette, designed for both functionality and ease of use. Downstairs, you will find ample undeveloped space featuring a new subfloor, perfect for storage. Both levels are efficiently heated and cooled with individual mini-split systems, providing comfort for all occupants year-round. Situated in a high-traffic area, this property offers parking and prime billboard sign space at the front, enhancing your business's visibility. This location is well-suited for a variety of ventures, including hair salons, professional offices for doctors, lawyers, insurance agents, massage therapy, chiropractic services, and more. As one business relocates don’t miss this exceptional opportunity to establish your business in a thriving community. Any applicable HST will be the responsibility of the purchaser. (id:62650)"
+"BusinessType": "Retail and Wholesale"
+"CreationDate": "2025-07-06T00:12:08.356742+00:00"
+"Flooring": array:2 [
0 => "Other"
1 => "Wood"
]
+"Heating": array:2 [
0 => "Electric"
1 => "Mini-Split"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2085464"
+"ListOfficeKey": "262663"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "25x100"
+"PhotosChangeTimestamp": "2026-02-02T16:49:18Z"
+"PhotosCount": 20
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-26T14:33:47Z"
+"StreetName": "New Cove"
+"StreetNumber": "99"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5759"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/27653989/99-new-cove-road-st-johns"
+"StructureType": array:1 [
0 => "Retail"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1 - COMM"
+"OriginalEntryTimestamp": "2024-11-15T15:14:09.45Z"
+"ListAgentNationalAssociationId": "1358861"
+"ListOfficeNationalAssociationId": "1223039"
+"Media": array:20 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6437259518"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27653989/b70999907abb4e2ba544e5b46a66b4ed.webp"
"MediaSize" => 256070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27653989/thumbnail-b70999907abb4e2ba544e5b46a66b4ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1279626"
"ResourceRecordKey" => "27653989"
"ModificationTimestamp" => "2024-11-15T15:14:49.21Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6437259527"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27653989/d1ad29753716cbf40ce890c3a10de180.webp"
"MediaSize" => 244658
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27653989/thumbnail-d1ad29753716cbf40ce890c3a10de180.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1279626"
"ResourceRecordKey" => "27653989"
"ModificationTimestamp" => "2024-11-15T15:14:49.28Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6437259539"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27653989/f0ca62fb0e87a37be296c7053929aac7.webp"
"MediaSize" => 223835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27653989/thumbnail-f0ca62fb0e87a37be296c7053929aac7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1279626"
"ResourceRecordKey" => "27653989"
"ModificationTimestamp" => "2024-11-15T15:14:49.29Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6437259544"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27653989/7181dde9ed8512d5b4607d70dfb7c142.webp"
"MediaSize" => 244138
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27653989/thumbnail-7181dde9ed8512d5b4607d70dfb7c142.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1279626"
"ResourceRecordKey" => "27653989"
"ModificationTimestamp" => "2024-11-15T15:14:49.29Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6437259554"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27653989/01601cceca9e5f5c17c0ec64d28d8008.webp"
"MediaSize" => 257466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27653989/thumbnail-01601cceca9e5f5c17c0ec64d28d8008.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1279626"
"ResourceRecordKey" => "27653989"
"ModificationTimestamp" => "2024-11-15T15:14:49.3Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6437259572"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27653989/603023867c7a6d8f90f39de075088afb.webp"
"MediaSize" => 235710
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27653989/thumbnail-603023867c7a6d8f90f39de075088afb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1279626"
"ResourceRecordKey" => "27653989"
"ModificationTimestamp" => "2024-11-15T15:14:49.3Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6437259582"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27653989/13e74d17a3ab859bd8012228f5d72646.webp"
"MediaSize" => 230935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27653989/thumbnail-13e74d17a3ab859bd8012228f5d72646.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1279626"
"ResourceRecordKey" => "27653989"
"ModificationTimestamp" => "2024-11-15T15:14:49.31Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6437259586"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27653989/e071cd48ee6908a6b3c69c853dc07b4d.webp"
"MediaSize" => 222660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27653989/thumbnail-e071cd48ee6908a6b3c69c853dc07b4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1279626"
"ResourceRecordKey" => "27653989"
"ModificationTimestamp" => "2024-11-15T15:14:49.31Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6437259599"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27653989/72481434d60d3057da506b1aa136fdc6.webp"
"MediaSize" => 87850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27653989/thumbnail-72481434d60d3057da506b1aa136fdc6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1279626"
"ResourceRecordKey" => "27653989"
"ModificationTimestamp" => "2024-11-15T15:14:49.32Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6437259637"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27653989/a5307d14502c29fa4702aa10b5cc1484.webp"
"MediaSize" => 201537
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27653989/thumbnail-a5307d14502c29fa4702aa10b5cc1484.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1279626"
"ResourceRecordKey" => "27653989"
"ModificationTimestamp" => "2024-11-15T15:14:49.22Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6437259677"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27653989/b6d4c70fe4e3544600bda8717b506811.webp"
"MediaSize" => 193132
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27653989/thumbnail-b6d4c70fe4e3544600bda8717b506811.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1279626"
"ResourceRecordKey" => "27653989"
"ModificationTimestamp" => "2024-11-15T15:14:49.22Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6437259680"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27653989/c88835af6f09b2944443eabb9fda10df.webp"
"MediaSize" => 180708
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27653989/thumbnail-c88835af6f09b2944443eabb9fda10df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1279626"
"ResourceRecordKey" => "27653989"
"ModificationTimestamp" => "2024-11-15T15:14:49.23Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6437259681"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27653989/a18c2fd6b4fe77aa1ac6f51b42975ea6.webp"
"MediaSize" => 282936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27653989/thumbnail-a18c2fd6b4fe77aa1ac6f51b42975ea6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1279626"
"ResourceRecordKey" => "27653989"
"ModificationTimestamp" => "2024-11-15T15:14:49.23Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6437259686"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27653989/2e20a4caaae896e69b6fdeafd3e16873.webp"
"MediaSize" => 285131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27653989/thumbnail-2e20a4caaae896e69b6fdeafd3e16873.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1279626"
"ResourceRecordKey" => "27653989"
"ModificationTimestamp" => "2024-11-15T15:14:49.24Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6437259690"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27653989/80931b7c1883377c9fd5064f6f99fda0.webp"
"MediaSize" => 205730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27653989/thumbnail-80931b7c1883377c9fd5064f6f99fda0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1279626"
"ResourceRecordKey" => "27653989"
"ModificationTimestamp" => "2024-11-15T15:14:49.24Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6437259715"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27653989/412996d38134ad5c00430568643d3d51.webp"
"MediaSize" => 248447
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27653989/thumbnail-412996d38134ad5c00430568643d3d51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1279626"
"ResourceRecordKey" => "27653989"
"ModificationTimestamp" => "2024-11-15T15:14:49.25Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6437259723"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27653989/c51e55581abc560f78541dc41a07e382.webp"
"MediaSize" => 278303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27653989/thumbnail-c51e55581abc560f78541dc41a07e382.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1279626"
"ResourceRecordKey" => "27653989"
"ModificationTimestamp" => "2024-11-15T15:14:49.26Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6437259735"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27653989/5673c88b84586b3c988b16d9731c5648.webp"
"MediaSize" => 310868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27653989/thumbnail-5673c88b84586b3c988b16d9731c5648.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1279626"
"ResourceRecordKey" => "27653989"
"ModificationTimestamp" => "2024-11-15T15:14:49.27Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6437259750"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27653989/4ccd8768b1f369ed304a2c1cf21d0b1d.webp"
"MediaSize" => 418038
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27653989/thumbnail-4ccd8768b1f369ed304a2c1cf21d0b1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1279626"
"ResourceRecordKey" => "27653989"
"ModificationTimestamp" => "2024-11-15T15:14:49.28Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6437259760"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27653989/3d540697b6b49b806dcbfa785e99c85b.webp"
"MediaSize" => 292303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27653989/thumbnail-3d540697b6b49b806dcbfa785e99c85b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1279626"
"ResourceRecordKey" => "27653989"
"ModificationTimestamp" => "2024-11-15T15:14:49.29Z"
]
]
+"DaysOnMarket": 595
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('27653989')"
+"ID": "952660"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 262663" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24818
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2085464" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24809
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '27653989'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25192
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '27653989'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25208
+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 '27653989' 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.708798 47.581132)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25261
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25255
+post_id: 1588981
+post_author: 1
+"ListingKey": "29979532"
+"ListingId": "1299783"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T17:45:08Z"
+"RFModificationTimestamp": "2026-07-02T18:45:04Z"
+"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.710355
1 => 47.578545
]
+"Latitude": 47.578545
+"Longitude": -52.710355
+"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 OR SEIZE A RARE OPPORTUNITY TO ESTABLISH YOUR LOW TRAFFIC ,HIGH VALUE BUSINESS IN A GREAT LOCATION THAT 32 PORTUGAL COVE OFFERS.THIS SITE IS STRATTEGICALLY POSITIONED IN A VERY DESIRABLE NEIGHBOUR HOOD.THIS LOCATION WAS FIRST ESTABLISHED BACK IN THE 1960S AND HAS BEEN OPERATED AS BREENS FOR THE LAST 32 YRS.THE OPEN MAIN FLOOR ALLOWS FOR EASY CUSTOMIZATION TO SUITE YOUR SPECIFIC NEEDS .IDEAL FOR LOW TRAFFIC BUSINESSES SUCH AS BOUTIQUE CLINICS, SMALL PROFESSIONAL SERVICES,SPECIALTY RETAIL QUITE CAFES AND ART STUDIO/GALLARY SALE PRICE IS PLUS HST. BUYER MUST ME A HST REGISTRANT (id:62650)"
+"BusinessType": "Retail and Wholesale"
+"CreationDate": "2026-07-02T18:44:59.951916+00:00"
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Mini-Split"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1571878"
+"ListOfficeKey": "88555"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40X81"
+"PhotosChangeTimestamp": "2026-07-02T17:33:47Z"
+"PhotosCount": 8
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-07-02T17:33:47Z"
+"StreetName": "PORTUGAL COVE"
+"StreetNumber": "32"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5614"
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2026
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29979532/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": "2026-07-02T17:33:47.66Z"
+"ListAgentNationalAssociationId": "1033691"
+"ListOfficeNationalAssociationId": "1007294"
+"Media": array:8 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29979532_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979532/c9d6e3993ca75ca38c9cba4ab243ffed.webp"
"MediaSize" => 240922
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979532/thumbnail-c9d6e3993ca75ca38c9cba4ab243ffed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1299783"
"ResourceRecordKey" => "29979532"
"ModificationTimestamp" => "2026-07-02T17:33:47.66Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29979532_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979532/9141d7b62adfe2127902018299571609.webp"
"MediaSize" => 298000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979532/thumbnail-9141d7b62adfe2127902018299571609.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299783"
"ResourceRecordKey" => "29979532"
"ModificationTimestamp" => "2026-07-02T17:33:47.66Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29979532_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979532/37c38b5f6d3ecac24f467ce898803e31.webp"
"MediaSize" => 258853
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979532/thumbnail-37c38b5f6d3ecac24f467ce898803e31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299783"
"ResourceRecordKey" => "29979532"
"ModificationTimestamp" => "2026-07-02T17:33:47.66Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29979532_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979532/74718b5223c9b020adda50f99fd9fea8.webp"
"MediaSize" => 240208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979532/thumbnail-74718b5223c9b020adda50f99fd9fea8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299783"
"ResourceRecordKey" => "29979532"
"ModificationTimestamp" => "2026-07-02T17:33:47.66Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29979532_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979532/23c161afa8bb6d9eca0833de0360ab00.webp"
"MediaSize" => 187257
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979532/thumbnail-23c161afa8bb6d9eca0833de0360ab00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299783"
"ResourceRecordKey" => "29979532"
"ModificationTimestamp" => "2026-07-02T17:33:47.66Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29979532_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979532/249912ced6963e184d81f3598cab6a08.webp"
"MediaSize" => 251239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979532/thumbnail-249912ced6963e184d81f3598cab6a08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299783"
"ResourceRecordKey" => "29979532"
"ModificationTimestamp" => "2026-07-02T17:33:47.66Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29979532_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979532/097ba953c9fff3a36c2b1989c49a52c4.webp"
"MediaSize" => 243269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979532/thumbnail-097ba953c9fff3a36c2b1989c49a52c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299783"
"ResourceRecordKey" => "29979532"
"ModificationTimestamp" => "2026-07-02T17:33:47.66Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29979532_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979532/9d7b196c7d8b3bb8022564476be3cb0c.webp"
"MediaSize" => 248851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979532/thumbnail-9d7b196c7d8b3bb8022564476be3cb0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299783"
"ResourceRecordKey" => "29979532"
"ModificationTimestamp" => "2026-07-02T17:33:47.66Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29979532')"
+"ID": 1588981
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25257
+post_id: "1484787"
+post_author: 1
+"ListingKey": "29839352"
+"ListingId": "1298177"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:45:34Z"
+"RFModificationTimestamp": "2026-06-16T17:20:33Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 2740.0
+"BuildingAreaTotal": 0
+"City": "ST. JOHN'S"
+"PostalCode": "A1C3L3"
+"UnparsedAddress": "28 COCHRANE Street, ST. JOHN'S, Newfoundland & Labrador A1C3L3"
+"Coordinates": array:2 [
0 => -52.702767
1 => 47.569378
]
+"Latitude": 47.569378
+"Longitude": -52.702767
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Step into the charm and character of old St. John's with this beautiful historic property. Rich in architectural detail and timeless curb appeal, this iconic downtown home offers a rare opportunity to own a piece of the city's heritage. Currently leased commercially, the property also presents incredible potential to be transformed into a stunning residential home full of warmth, personality, and classic Newfoundland character. Featuring distinctive heritage trim, soaring ceilings, dormer windows and a striking facade, this property stands proudly among the colourful streetscapes that make St. John's so beloved. Inside, the possibilities are endless, whether you envision an elegant residence, live/work space, boutique style home or investment property. Located in the heart of downtown just steps from the vibrancy of the city core. A unique opportunity to restore, reimagine, and make your mark on one of St. John's most charming historic streets. (id:62650)"
+"BusinessType": "Service"
+"CreationDate": "2026-06-02T17:21:20.316815+00:00"
+"Flooring": array:1 [
0 => "Wood"
]
+"Heating": array:2 [
0 => "Hot water radiator heat"
1 => "Oil"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1571812"
+"ListOfficeKey": "88555"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "30X40"
+"PhotosChangeTimestamp": "2026-06-02T15:23:13Z"
+"PhotosCount": 36
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-16T16:35:27Z"
+"StreetName": "COCHRANE"
+"StreetNumber": "28"
+"StreetSuffix": "Street"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29839352/28-cochrane-street-st-johns"
+"StructureType": array:1 [
0 => "Offices"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Living Accommodation"
]
+"ZoningDescription": "COMM."
+"OriginalEntryTimestamp": "2026-06-02T15:23:13Z"
+"ListAgentNationalAssociationId": "1108011"
+"ListOfficeNationalAssociationId": "1007294"
+"Media": array:36 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29839352_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/fae7a7209e36e7967013bec5d3258455.webp"
"MediaSize" => 251131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-fae7a7209e36e7967013bec5d3258455.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29839352_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/760adf3887ab75a7b7961e1959fb0ae1.webp"
"MediaSize" => 153107
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-760adf3887ab75a7b7961e1959fb0ae1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29839352_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/f56e51d86323fca2700b867207fb9898.webp"
"MediaSize" => 309417
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-f56e51d86323fca2700b867207fb9898.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29839352_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/69075f69bee0d3b408ba182ef1a4e381.webp"
"MediaSize" => 278611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-69075f69bee0d3b408ba182ef1a4e381.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29839352_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/eff4dc1be96142ef7db433d676dd2717.webp"
"MediaSize" => 221567
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-eff4dc1be96142ef7db433d676dd2717.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29839352_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/7bb10e60a003178c9ba119c3d3967038.webp"
"MediaSize" => 110011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-7bb10e60a003178c9ba119c3d3967038.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29839352_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/bc4f540eb111fda485f733134bc8b283.webp"
"MediaSize" => 84541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-bc4f540eb111fda485f733134bc8b283.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29839352_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/2f97c32fb7cfde8b826f20cf199dbb2d.webp"
"MediaSize" => 200150
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-2f97c32fb7cfde8b826f20cf199dbb2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29839352_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/5adf89ea8f0e568a83cad79de1471a30.webp"
"MediaSize" => 119172
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-5adf89ea8f0e568a83cad79de1471a30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29839352_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/cc5838eb23bdff2f56e277db5e93c158.webp"
"MediaSize" => 206840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-cc5838eb23bdff2f56e277db5e93c158.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29839352_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/c43227a9c4e4e48911436df778974802.webp"
"MediaSize" => 181055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-c43227a9c4e4e48911436df778974802.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29839352_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/dbbc720027718040563ed0f4d655385a.webp"
"MediaSize" => 191970
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-dbbc720027718040563ed0f4d655385a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29839352_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/5311203878bd6b82d7a13239a0f91955.webp"
"MediaSize" => 124609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-5311203878bd6b82d7a13239a0f91955.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29839352_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/4da208ad622f1cb96c2bfb34f784a9f7.webp"
"MediaSize" => 174992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-4da208ad622f1cb96c2bfb34f784a9f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29839352_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/71addbe99ab8f150b76d787b590a32c7.webp"
"MediaSize" => 124723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-71addbe99ab8f150b76d787b590a32c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29839352_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/e50647d00d5d89f08c81817ef7ba0ee8.webp"
"MediaSize" => 128230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-e50647d00d5d89f08c81817ef7ba0ee8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29839352_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/3a23dec3bc561169d16fdf43c87a42ef.webp"
"MediaSize" => 110045
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-3a23dec3bc561169d16fdf43c87a42ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29839352_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/efba1d4ca13390c07d4598c1c476189a.webp"
"MediaSize" => 178068
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-efba1d4ca13390c07d4598c1c476189a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29839352_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/94e5dfc249019c7408c87c7b22aacc7f.webp"
"MediaSize" => 121169
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-94e5dfc249019c7408c87c7b22aacc7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29839352_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/dc5888142febd1c1207dcf20fc07b7f0.webp"
"MediaSize" => 135779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-dc5888142febd1c1207dcf20fc07b7f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29839352_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/ae3b3e24c4763b19d01f8584ac0c98a1.webp"
"MediaSize" => 158636
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-ae3b3e24c4763b19d01f8584ac0c98a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29839352_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/7d9b8e8d6d08e0fc2e3ef5abbdefa4fc.webp"
"MediaSize" => 114206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-7d9b8e8d6d08e0fc2e3ef5abbdefa4fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29839352_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/dd2cda732c2850c7e9bcc72523008630.webp"
"MediaSize" => 89280
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-dd2cda732c2850c7e9bcc72523008630.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29839352_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/68d7df443ff892b151650e90ec54f534.webp"
"MediaSize" => 143504
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-68d7df443ff892b151650e90ec54f534.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29839352_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/22eee1695fab8980a4c2444f48a27ed0.webp"
"MediaSize" => 203478
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-22eee1695fab8980a4c2444f48a27ed0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29839352_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/130fd518bed154b1ab49c24d35f03623.webp"
"MediaSize" => 159354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-130fd518bed154b1ab49c24d35f03623.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29839352_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/c0a28ac0a7d2eda8e344315529fca016.webp"
"MediaSize" => 133622
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-c0a28ac0a7d2eda8e344315529fca016.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29839352_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/af4e5e8cb5f328dcc871a1801658737a.webp"
"MediaSize" => 208257
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-af4e5e8cb5f328dcc871a1801658737a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29839352_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/b4ff81c0305251e1c121f224c01f6488.webp"
"MediaSize" => 98005
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-b4ff81c0305251e1c121f224c01f6488.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29839352_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/3aeac7257db7f2ce02644d62c9315612.webp"
"MediaSize" => 190874
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-3aeac7257db7f2ce02644d62c9315612.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29839352_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/598f3c7e5bae16118aa22c7a4b3b49d2.webp"
"MediaSize" => 121455
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-598f3c7e5bae16118aa22c7a4b3b49d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29839352_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/054458cde2688d24c984ce0bfb9a7ff4.webp"
"MediaSize" => 167934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-054458cde2688d24c984ce0bfb9a7ff4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29839352_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/44402ecaa99787b39f3adf1128423414.webp"
"MediaSize" => 119675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-44402ecaa99787b39f3adf1128423414.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29839352_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/b555ea124742afcc7c938faf3eb4b7f6.webp"
"MediaSize" => 190405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-b555ea124742afcc7c938faf3eb4b7f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29839352_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/53935cb4396e8be7937f32de1e4dfe90.webp"
"MediaSize" => 192057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-53935cb4396e8be7937f32de1e4dfe90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29839352_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29839352/654f75e7ddb96a6dc6c12a1f2e54e129.webp"
"MediaSize" => 123299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29839352/thumbnail-654f75e7ddb96a6dc6c12a1f2e54e129.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298177"
"ResourceRecordKey" => "29839352"
"ModificationTimestamp" => "2026-06-02T15:23:13.01Z"
]
]
+"DaysOnMarket": 31
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29839352')"
+"ID": "1484787"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25254
+post_id: "1457251"
+post_author: 1
+"ListingKey": "29801494"
+"ListingId": "1298036"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:45:29Z"
+"RFModificationTimestamp": "2026-06-16T17:21:02Z"
+"ListPrice": 269900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1964.0
+"BuildingAreaTotal": 0
+"City": "St. John’s"
+"PostalCode": "A1C2G5"
+"UnparsedAddress": "6 LeMarchant Road, St. John’s, Newfoundland & Labrador A1C2G5"
+"Coordinates": array:2 [
0 => -52.715429
1 => 47.563918
]
+"Latitude": 47.563918
+"Longitude": -52.715429
+"YearBuilt": 1928
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Step into this captivating heritage home where classic charm meets modern upgrades! This well-maintained gem boasts stunning original features, including a beautiful staircase, wainscoting, wood moldings, doors, and trims, all adding to its rich character. The inviting cut glass porch entrance opens to a spacious foyer, setting the tone for the entire home. Throughout the house, you'll find impressive hardwood and softwood floors, exuding warmth and character. The kitchen leads to a fully enclosed, private garden—a peaceful retreat. A separate dining room seamlessly connects to the cozy living room, perfect for both entertaining and everyday living. Upstairs, you’ll find three generous bedrooms and a convenient laundry area. The basement is a fantastic bonus with high ceilings, full insulation, and great storage potential. Enjoy the working dining room fireplace, complete with chimney, as well as a sealed fireplace in the living room for added ambiance. The owner has made numerous upgrades, including a new furnace and oil tank in 2020. New windows and main floor bath in recent years. This home is well-equipped with appliances. The central location offers the best of both worlds: tucked away from the busy street but still close to downtown, shopping, and all the amenities you need. Note: Zoning is CM. Main floor is commercial and second floor is zoned for residential use. A Purchaser can apply to use the main floor as residential use under a discretionary use. Don't miss the opportunity to own this character-filled beauty! (id:62650)"
+"BusinessType": "Other,Retail and Wholesale,Service"
+"CreationDate": "2026-05-25T19:26:02.405997+00:00"
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Other"
]
+"Heating": array:2 [
0 => "Hot water radiator heat"
1 => "Oil"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1571777"
+"ListOfficeKey": "88555"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "23.74 x 30.83 x 19.64 x 12.66 x 12 x 7.57 x 36.83"
+"PhotosChangeTimestamp": "2026-05-26T00:00:20Z"
+"PhotosCount": 37
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-16T16:35:41Z"
+"StreetName": "LeMarchant"
+"StreetNumber": "6"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "1840"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=MG2TUSJ8i6P"
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2026
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29801494/6-lemarchant-road-st-johns"
+"StructureType": array:1 [
0 => "Retail"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "CM"
+"OriginalEntryTimestamp": "2026-05-25T18:52:35.55Z"
+"ListAgentNationalAssociationId": "1033615"
+"ListOfficeNationalAssociationId": "1007294"
+"Media": array:37 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29801494_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/35eb1ebd6d503e94487c7e9e4cc56891.webp"
"MediaSize" => 298989
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-35eb1ebd6d503e94487c7e9e4cc56891.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:12.9Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29801494_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/b2714ef17d8615ac778e3a22b24876a7.webp"
"MediaSize" => 348300
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-b2714ef17d8615ac778e3a22b24876a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:16.27Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29801494_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/64090e8ed0ce75ad2c8d5f207ef595a1.webp"
"MediaSize" => 246444
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-64090e8ed0ce75ad2c8d5f207ef595a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:20.26Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29801494_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/7286c83be1d411e11cb03ea3c56660d8.webp"
"MediaSize" => 251107
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-7286c83be1d411e11cb03ea3c56660d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:21.85Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29801494_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/8dfeac9535be4eb0020c48cbfa6dab07.webp"
"MediaSize" => 164440
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-8dfeac9535be4eb0020c48cbfa6dab07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:22.12Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29801494_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/b3869896dc2c291f9a5eaff68b34caf2.webp"
"MediaSize" => 167632
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-b3869896dc2c291f9a5eaff68b34caf2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:22.02Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29801494_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/f32f9d704ec644837197eefe7e292911.webp"
"MediaSize" => 186743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-f32f9d704ec644837197eefe7e292911.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:22.15Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29801494_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/464c771db51f39974688718f64071642.webp"
"MediaSize" => 205612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-464c771db51f39974688718f64071642.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:22.24Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29801494_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/cb31aeb0bf6e797a9fb024cb9e4737dd.webp"
"MediaSize" => 181789
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-cb31aeb0bf6e797a9fb024cb9e4737dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:22.1Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29801494_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/1878fd8c7add827cc5332fa1da598afc.webp"
"MediaSize" => 132796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-1878fd8c7add827cc5332fa1da598afc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:14.08Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29801494_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/3534e35056a77ea6213bb0e95501c7f9.webp"
"MediaSize" => 210002
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-3534e35056a77ea6213bb0e95501c7f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:14.44Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29801494_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/e424bd0dcecbac1fdc51ac5dc4a06f14.webp"
"MediaSize" => 140406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-e424bd0dcecbac1fdc51ac5dc4a06f14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:14.36Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29801494_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/f3e690decd73cbd2d273efd4637c0264.webp"
"MediaSize" => 174679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-f3e690decd73cbd2d273efd4637c0264.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:14.66Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29801494_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/9666f0e317dc0e2cd98e7c3ebed55dce.webp"
"MediaSize" => 194727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-9666f0e317dc0e2cd98e7c3ebed55dce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:14.41Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29801494_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/c006d6cecd25b53a150295dd6ed35edc.webp"
"MediaSize" => 290388
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-c006d6cecd25b53a150295dd6ed35edc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:15Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29801494_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/cfe9b2ee771eb75497373a042716942b.webp"
"MediaSize" => 218694
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-cfe9b2ee771eb75497373a042716942b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:14.46Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29801494_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/4e260ba67996dec79474f0ba662031cc.webp"
"MediaSize" => 116040
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-4e260ba67996dec79474f0ba662031cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:14.43Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29801494_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/45de36b3ef3618e1eb4b860a76e14f47.webp"
"MediaSize" => 108851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-45de36b3ef3618e1eb4b860a76e14f47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:14.47Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29801494_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/e574173131392bfc7fb69760ad77071d.webp"
"MediaSize" => 94477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-e574173131392bfc7fb69760ad77071d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:14.45Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29801494_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/89cd670299a75d457d483b503fed51df.webp"
"MediaSize" => 101250
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-89cd670299a75d457d483b503fed51df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:14.59Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29801494_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/f7f52ee237fc490c305e90edd2fd4129.webp"
"MediaSize" => 167305
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-f7f52ee237fc490c305e90edd2fd4129.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:16.12Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29801494_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/abcf77a869a6f11120f1d871f5f389b0.webp"
"MediaSize" => 177364
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-abcf77a869a6f11120f1d871f5f389b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:16.5Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29801494_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/197c8065c1d2054045c7c868d83fd61c.webp"
"MediaSize" => 123585
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-197c8065c1d2054045c7c868d83fd61c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:14.43Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29801494_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/5d7fb01bd6495e6c2399bc731c59ceb2.webp"
"MediaSize" => 187710
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-5d7fb01bd6495e6c2399bc731c59ceb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:17.52Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29801494_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/c0d96d90ef8a42ce2e393eb5bf50f135.webp"
"MediaSize" => 127946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-c0d96d90ef8a42ce2e393eb5bf50f135.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:19.72Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29801494_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/5b2824304f864d7bc40844aa85c66579.webp"
"MediaSize" => 186139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-5b2824304f864d7bc40844aa85c66579.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:19.75Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29801494_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/e48fb61909b506091365dbb93571e742.webp"
"MediaSize" => 134770
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-e48fb61909b506091365dbb93571e742.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:19.97Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29801494_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/c58bacb02b4ddba9680aab81faee3c49.webp"
"MediaSize" => 160835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-c58bacb02b4ddba9680aab81faee3c49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:20.31Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29801494_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/844e87967c404038608e74c1c043f638.webp"
"MediaSize" => 151295
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-844e87967c404038608e74c1c043f638.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:20.44Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29801494_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/7e5d6fab2e727f25bbabbd5b0c1ce273.webp"
"MediaSize" => 230707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-7e5d6fab2e727f25bbabbd5b0c1ce273.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:20.3Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29801494_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/1e7c161b1cced2e8f1d73a14ced8feb0.webp"
"MediaSize" => 123737
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-1e7c161b1cced2e8f1d73a14ced8feb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:20.84Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29801494_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/565293ba55fba049ef440058b6c51b66.webp"
"MediaSize" => 161353
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-565293ba55fba049ef440058b6c51b66.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:20.38Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29801494_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/a4b1c20256076a46b8555eb88e91f54d.webp"
"MediaSize" => 463858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-a4b1c20256076a46b8555eb88e91f54d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-26T00:00:18.48Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29801494_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/4b00aef1d9197d4085832db0136e6918.webp"
"MediaSize" => 249640
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-4b00aef1d9197d4085832db0136e6918.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:20.6Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29801494_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/94c92e221e1f724fb07c6705d5c384c3.webp"
"MediaSize" => 56973
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-94c92e221e1f724fb07c6705d5c384c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:20.78Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29801494_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/ea0ecd434818a815026b1a14c35fc618.webp"
"MediaSize" => 76142
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-ea0ecd434818a815026b1a14c35fc618.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:21.65Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29801494_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29801494/844bead51c8617af6464237fd0c93239.webp"
"MediaSize" => 77591
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29801494/thumbnail-844bead51c8617af6464237fd0c93239.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298036"
"ResourceRecordKey" => "29801494"
"ModificationTimestamp" => "2026-05-25T22:00:21.83Z"
]
]
+"DaysOnMarket": 38
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29801494')"
+"ID": "1457251"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25258
+post_id: "1439575"
+post_author: 1
+"ListingKey": "29774982"
+"ListingId": "1296761"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T12:40:06Z"
+"RFModificationTimestamp": "2026-06-18T12:42:58Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 4443.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C2C9"
+"UnparsedAddress": "124 Military Road, St. John's, Newfoundland & Labrador A1C2C9"
+"Coordinates": array:2 [
0 => -52.707773
1 => 47.569208
]
+"Latitude": 47.569208
+"Longitude": -52.707773
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Ideally positioned at one of St. John’s most prominent central intersections, this classic heritage property offers a rare opportunity to own a landmark building in the heart of the downtown core. Offering over 5,000 sq. ft. of interior space, the property provides exceptional visibility, complete with driveway at rear and ample adjacent public parking. The property has been extremely well maintained and thoughtfully upgraded by the current owner, reflecting true pride of ownership throughout. This character home retains many original features, including high ceilings, custom plaster work, stunning trim and millwork, walk-in bay windows, fireplace mantels, and an outstanding staircase that highlights its craftsmanship and historic charm. Currently configured for professional office use, the interior includes multiple private and multi-purpose offices, a boardroom, cafe/lunchroom, top-floor kitchenette, and three bathrooms. Its flexible layout supports a wide range of potential uses such as boutique retail, studio space, gallery, professional offices, or spa services. The property also offers excellent potential for mixed-use conversion, with the ability to operate a business on the main and lower levels while residing on the second and third floors—an ideal live-work opportunity in a prime downtown setting. Located within the historic quarter, it is surrounded by cafés, coffee shops, restaurants, and local shopping, offering a vibrant and highly walkable environment. Positioned on the edge of Bannerman Park, a beautifully revitalized historic green space, this highly sought-after location provides outstanding exposure, convenience, and long-term investment appeal in downtown St. John’s. (id:62650)"
+"BusinessType": "Other,Retail and Wholesale,Service"
+"CreationDate": "2026-05-20T18:30:20.280564+00:00"
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Other"
2 => "Mixed Flooring"
]
+"Heating": array:2 [
0 => "Hot water radiator heat"
1 => "Mini-Split"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1964615"
+"ListOfficeKey": "293977"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "232 square meters"
+"PhotosChangeTimestamp": "2026-06-18T12:33:20Z"
+"PhotosCount": 49
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-18T12:33:20Z"
+"Stories": "4.0"
+"StreetName": "Military"
+"StreetNumber": "124"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "12331"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29774982/124-military-road-st-johns"
+"StructureType": array:1 [
0 => "Retail"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Air Conditioning"
]
+"ZoningDescription": "R2"
+"OriginalEntryTimestamp": "2026-05-20T12:23:34.2Z"
+"ListAgentNationalAssociationId": "1253254"
+"ListOfficeNationalAssociationId": "1433917"
+"Media": array:49 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29774982_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774982/140b6ea3df8c02c1a0bbd19929c48ce4.webp"
"MediaSize" => 353656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774982/thumbnail-140b6ea3df8c02c1a0bbd19929c48ce4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1296761"
"ResourceRecordKey" => "29774982"
"ModificationTimestamp" => "2026-05-20T12:23:34.21Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29774982_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774982/f447ca172bebfc9d9903bae1130c6fcf.webp"
"MediaSize" => 381896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774982/thumbnail-f447ca172bebfc9d9903bae1130c6fcf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296761"
"ResourceRecordKey" => "29774982"
"ModificationTimestamp" => "2026-05-20T12:23:34.21Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29774982_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774982/f2ad9a8e0eb9ae8892cc92f229e98add.webp"
"MediaSize" => 384038
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774982/thumbnail-f2ad9a8e0eb9ae8892cc92f229e98add.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296761"
"ResourceRecordKey" => "29774982"
"ModificationTimestamp" => "2026-05-20T12:23:34.21Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29774982_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774982/89362fefe6cb1c806c1e7a12118d18ea.webp"
"MediaSize" => 187444
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774982/thumbnail-89362fefe6cb1c806c1e7a12118d18ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entrance"
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296761"
"ResourceRecordKey" => "29774982"
"ModificationTimestamp" => "2026-06-18T12:30:23.73Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29774982_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774982/f4183d4a6ca949497ba82780dfd76006.webp"
"MediaSize" => 229054
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774982/thumbnail-f4183d4a6ca949497ba82780dfd76006.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front Porch"
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296761"
"ResourceRecordKey" => "29774982"
"ModificationTimestamp" => "2026-06-18T12:30:24.29Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29774982_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774982/c141a226401bee1ba23f390ed73632a3.webp"
"MediaSize" => 170274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774982/thumbnail-c141a226401bee1ba23f390ed73632a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front Foyer"
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296761"
"ResourceRecordKey" => "29774982"
"ModificationTimestamp" => "2026-06-18T12:30:23.8Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29774982_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774982/aed0a755bd467ed13f3638f60bff8c97.webp"
"MediaSize" => 229782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774982/thumbnail-aed0a755bd467ed13f3638f60bff8c97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front Foyer"
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296761"
"ResourceRecordKey" => "29774982"
"ModificationTimestamp" => "2026-06-18T12:30:26.17Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29774982_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774982/6d51570680dc128c9368d43aba646e2e.webp"
"MediaSize" => 207675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774982/thumbnail-6d51570680dc128c9368d43aba646e2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lunchroom Cafe"
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296761"
"ResourceRecordKey" => "29774982"
"ModificationTimestamp" => "2026-06-18T12:30:26.14Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29774982_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774982/0ef0cab076e8d82e64fbd1cb2e9fe795.webp"
"MediaSize" => 181099
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774982/thumbnail-0ef0cab076e8d82e64fbd1cb2e9fe795.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lunchroom Cafe"
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296761"
"ResourceRecordKey" => "29774982"
"ModificationTimestamp" => "2026-06-18T12:30:25.97Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29774982_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774982/0986db46c7efdc07c93d5b5a5cc60cb2.webp"
"MediaSize" => 167870
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774982/thumbnail-0986db46c7efdc07c93d5b5a5cc60cb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lucnhroom Cafe"
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296761"
"ResourceRecordKey" => "29774982"
"ModificationTimestamp" => "2026-06-18T12:30:12.41Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29774982_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774982/645fc11216ce5d62a71554f3877102b9.webp"
"MediaSize" => 222417
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774982/thumbnail-645fc11216ce5d62a71554f3877102b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office Space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296761"
"ResourceRecordKey" => "29774982"
"ModificationTimestamp" => "2026-06-18T12:30:12.4Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29774982_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774982/389c1f82e9115da469f72e2dd0d14ccc.webp"
"MediaSize" => 217802
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774982/thumbnail-389c1f82e9115da469f72e2dd0d14ccc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office Space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296761"
"ResourceRecordKey" => "29774982"
"ModificationTimestamp" => "2026-06-18T12:30:12.41Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29774982_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774982/8a88833c02cd1bdef1655fed1f6d3219.webp"
"MediaSize" => 228355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774982/thumbnail-8a88833c02cd1bdef1655fed1f6d3219.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office Space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296761"
"ResourceRecordKey" => "29774982"
"ModificationTimestamp" => "2026-06-18T12:30:12.42Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29774982_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774982/9d86add83e973702e7ec8168a2c4b5f8.webp"
"MediaSize" => 216200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774982/thumbnail-9d86add83e973702e7ec8168a2c4b5f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office Space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296761"
"ResourceRecordKey" => "29774982"
"ModificationTimestamp" => "2026-06-18T12:30:12.91Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29774982_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774982/ff739ff549d7e9c592b1e690c1847d76.webp"
"MediaSize" => 218106
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774982/thumbnail-ff739ff549d7e9c592b1e690c1847d76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office Space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296761"
"ResourceRecordKey" => "29774982"
"ModificationTimestamp" => "2026-06-18T12:30:12.94Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29774982_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774982/0f0fce46eeb9742aca886285902417c5.webp"
"MediaSize" => 228314
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774982/thumbnail-0f0fce46eeb9742aca886285902417c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office Space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296761"
"ResourceRecordKey" => "29774982"
"ModificationTimestamp" => "2026-06-18T12:30:12.44Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29774982_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774982/2e08ff37b906f3d89e563165e3648533.webp"
"MediaSize" => 145524
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774982/thumbnail-2e08ff37b906f3d89e563165e3648533.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office Space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296761"
"ResourceRecordKey" => "29774982"
"ModificationTimestamp" => "2026-06-18T12:30:12.59Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29774982_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29774982/54a5da90f4f862703f9cf1d538de642e.webp"
"MediaSize" => 176882
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29774982/thumbnail-54a5da90f4f862703f9cf1d538de642e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 44
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29774982')"
+"ID": "1439575"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25256
+post_id: "1435108"
+post_author: 1
+"ListingKey": "29768419"
+"ListingId": "1297661"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-19T14:00:49Z"
+"RFModificationTimestamp": "2026-05-19T17:37:49Z"
+"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.707222
1 => 47.564135
]
+"Latitude": 47.564135
+"Longitude": -52.707222
+"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": "2026-05-19T17:37:40.426731+00:00"
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2141852"
+"ListOfficeKey": "88563"
+"PhotosChangeTimestamp": "2026-05-19T13:54:30Z"
+"PhotosCount": 1
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-05-19T13:54:30Z"
+"StreetName": "Water"
+"StreetNumber": "202"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4770"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29768419/202-water-street-st-johns"
+"StructureType": array:1 [
0 => "Retail"
]
+"CoListAgentKey": "1987537"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "88563"
+"GeocodeManualYN": true
+"ZoningDescription": "Comm"
+"OriginalEntryTimestamp": "2026-05-19T13:54:30.71Z"
+"ListAgentNationalAssociationId": "1393507"
+"ListOfficeNationalAssociationId": "1260564"
+"CoListAgentNationalAssociationId": "1271779"
+"CoListOfficeNationalAssociationId": "1260564"
+"Media": array:1 [
0 => array:13 [ …13]
]
+"DaysOnMarket": 45
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29768419')"
+"ID": "1435108"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25251
+post_id: "1400981"
+post_author: 1
+"ListingKey": "29715738"
+"ListingId": "1297203"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:45:21Z"
+"RFModificationTimestamp": "2026-06-16T17:22:30Z"
+"ListPrice": 359000.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.704829
1 => 47.566414
]
+"Latitude": 47.566414
+"Longitude": -52.704829
+"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,Service,Arts and Entertainment"
+"CreationDate": "2026-05-07T17:25:20.763012+00:00"
+"Directions": "Directly across from the Alt hotel ."
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2020022"
+"ListOfficeKey": "285811"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-05-07T16:33:20Z"
+"PhotosCount": 26
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-16T16:37:07Z"
+"StreetName": "Water"
+"StreetNumber": "132"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7555"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29715738/132-water-street-st-johns"
+"StructureType": array:1 [
0 => "Special Purpose"
]
+"CoListAgentKey": "1991125"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "285811"
+"GeocodeManualYN": true
+"ZoningDescription": "CMD"
+"OriginalEntryTimestamp": "2026-05-07T16:33:20.39Z"
+"ListAgentNationalAssociationId": "1300090"
+"ListOfficeNationalAssociationId": "1354950"
+"CoListAgentNationalAssociationId": "1274822"
+"CoListOfficeNationalAssociationId": "1354950"
+"Media": array:26 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
]
+"DaysOnMarket": 57
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29715738')"
+"ID": "1400981"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1327588"
+post_author: 1
+"ListingKey": "29618995"
+"ListingId": "1296302"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:45:14Z"
+"RFModificationTimestamp": "2026-06-16T16:47:51Z"
+"ListPrice": 1390000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 4070.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C1H3"
+"UnparsedAddress": "148 Duckworth Street, St. John's, Newfoundland & Labrador A1C1H3"
+"Coordinates": array:2 [
0 => -52.702628
1 => 47.568876
]
+"Latitude": 47.568876
+"Longitude": -52.702628
+"YearBuilt": 2022
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Immersed within the bustling east end of downtown St. John's at prominent and high-visibility corner of Cochrane Street and Duckworth Street, approximate 4,000sf commercial building completely re-built new 2022. Currently, 2,400sf of the building space has been designed for restaurant use and outfitted with professional series kitchen equipment. The existing restaurant space may be expanded to include an additional 1,600sf, which is ready for interior fit-up, or a separate business may be employed within the adjacent suite. Multiple opportunities for consideration. Permitted zoning sues and discretionary uses include restaurant, lounge, craft brewery/distillery, bakery, clinic, retail, convenience store, service, office, health and wellness and training facility. Location and visibility, coupled with traffic and pedestrian exposure, also make the site and building ideal for franchising. (id:62650)"
+"BusinessType": "Other,Restaurant,Retail and Wholesale,Arts and Entertainment"
+"CreationDate": "2026-04-17T16:21:45.491889+00:00"
+"Flooring": array:2 [
0 => "Laminate"
1 => "Other"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1571879"
+"ListOfficeKey": "275242"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "584.4 sm"
+"PhotosChangeTimestamp": "2026-04-17T13:02:49Z"
+"PhotosCount": 19
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-16T16:38:23Z"
+"Stories": "1.0"
+"StreetName": "Duckworth"
+"StreetNumber": "148"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "10789"
+"View": "View"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29618995/148-duckworth-street-st-johns"
+"StructureType": array:1 [
0 => "Special Purpose"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "CDM"
+"OriginalEntryTimestamp": "2026-04-17T13:02:49.81Z"
+"ListAgentNationalAssociationId": "1033654"
+"ListOfficeNationalAssociationId": "1263794"
+"Media": array:19 [
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]
]
+"DaysOnMarket": 77
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29618995')"
+"ID": "1327588"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25259
+post_id: "1307668"
+post_author: 1
+"ListingKey": "29588114"
+"ListingId": "1296067"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-10T19:10:27Z"
+"RFModificationTimestamp": "2026-04-10T20:19:25Z"
+"ListPrice": 249900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C1G8"
+"UnparsedAddress": "245 Duckworth Street, St. John's, Newfoundland & Labrador A1C1G8"
+"Coordinates": array:2 [
0 => -52.705038
1 => 47.566679
]
+"Latitude": 47.566679
+"Longitude": -52.705038
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Nestled in the heart of downtown St. John’s, The Tickle Trunk has become a beloved institution for both locals and tourists alike. With its charming and eclectic atmosphere, this one-of-a-kind shop offers an exceptional array of locally crafted goods, from artwork to books and everything in between. Whether you're in search of a unique souvenir or a special gift, The Tickle Trunk is the perfect destination for anyone looking to take a piece of Newfoundland home with them. For decades, this downtown treasure has been a must-visit stop on the tourism circuit, showcasing the rich creative spirit of the province. Every item in the store tells a story – whether it's a handmade piece of Newfoundland art, a beautifully crafted jewelry piece, or a locally penned book, you’ll find treasures that celebrate the culture and character of this vibrant city. This is more than just a retail space—it’s a cultural hub, supporting local artists, writers, and makers from around the province. As an established name in St. John's, The Tickle Trunk offers an incredible opportunity to connect with the community while growing a business that is as much about culture and heritage as it is about commerce. If you’re looking for an investment in a business with a loyal customer base, a rich history, and a bright future, The Tickle Trunk is your chance to own a piece of St. John’s tradition while continuing to celebrate the creative heart of Newfoundland. (id:62650)"
+"BusinessType": "Retail and Wholesale"
+"CreationDate": "2026-04-10T20:18:55.607181+00:00"
+"Heating": array:1 [
0 => "Oil"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2016745"
+"ListOfficeKey": "293977"
+"PhotosChangeTimestamp": "2026-04-10T19:03:19Z"
+"PhotosCount": 13
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-04-10T19:03:19Z"
+"StreetName": "Duckworth"
+"StreetNumber": "245"
+"StreetSuffix": "Street"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29588114/245-duckworth-street-st-johns"
+"CoListAgentKey": "1985667"
+"CommonInterest": "Leasehold"
+"CoListOfficeKey": "293977"
+"GeocodeManualYN": true
+"ZoningDescription": "Commercial"
+"OriginalEntryTimestamp": "2026-04-10T19:03:19.17Z"
+"ListAgentNationalAssociationId": "1297987"
+"ListOfficeNationalAssociationId": "1433917"
+"CoListAgentNationalAssociationId": "1270301"
+"CoListOfficeNationalAssociationId": "1433917"
+"Media": array:13 [
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]
]
+"DaysOnMarket": 83
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29588114')"
+"ID": "1307668"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25260
+post_id: "1286462"
+post_author: 1
+"ListingKey": "29560575"
+"ListingId": "1295815"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:45:11Z"
+"RFModificationTimestamp": "2026-06-16T16:48:07Z"
+"ListPrice": 1149900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 7584.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C1A9"
+"UnparsedAddress": "170 Water Street, St. John's, Newfoundland & Labrador A1C1A9"
+"Coordinates": array:2 [
0 => -52.706376
1 => 47.565046
]
+"Latitude": 47.565046
+"Longitude": -52.706376
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "This exceptional mixed-use property presents a rare opportunity in the heart of downtown St. John’s. Comprising two commercial units and two residential units across three levels, the building offers approximately 7,584 square feet of well-configured space with strong income potential and long-term value. The ground floor features prime retail frontage with excellent exposure, benefiting from consistent pedestrian and vehicle traffic in one of the city’s most established commercial corridors. The second floor is currently configured as open-concept office space, offering flexibility for a range of professional or creative uses. The upper level includes two residential units, providing additional income streams in a location where rental demand remains consistently strong. The property is income-producing, with recent performance reflecting approximately $120,000 in annual gross revenue, supported by a diversified tenant mix across both commercial and residential uses. A rare opportunity to acquire a well-located, income-producing mixed-use asset in the heart of downtown St. John’s! *Purchase price is + HST if applicable. (id:62650)"
+"BusinessType": "Other,Retail and Wholesale,Residential"
+"CreationDate": "2026-04-06T17:51:23.827457+00:00"
+"Flooring": array:1 [
0 => "Mixed Flooring"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1906420"
+"ListOfficeKey": "293977"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "Under 0.5 Acres"
+"PhotosChangeTimestamp": "2026-04-06T15:32:28Z"
+"PhotosCount": 39
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-16T16:39:01Z"
+"Stories": "3.0"
+"StreetName": "Water"
+"StreetNumber": "170"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "17025"
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2026
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29560575/170-water-street-st-johns"
+"StructureType": array:1 [
0 => "Retail"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "CDM"
+"OriginalEntryTimestamp": "2026-04-06T15:32:28.75Z"
+"ListAgentNationalAssociationId": "1220321"
+"ListOfficeNationalAssociationId": "1433917"
+"Media": array:39 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
]
+"DaysOnMarket": 88
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29560575')"
+"ID": "1286462"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 14
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]