array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29588114 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+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 [
"Order" => 1
"MediaKey" => "6584602441"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29588114/30d1eb67be91dd9a582d7884b1a6ca07.webp"
"MediaSize" => 280347
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29588114/thumbnail-30d1eb67be91dd9a582d7884b1a6ca07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1296067"
"ResourceRecordKey" => "29588114"
"ModificationTimestamp" => "2026-04-10T19:03:19.18Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6584602484"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29588114/e563e9955a83b660aff2d3c6d8ccb493.webp"
"MediaSize" => 361981
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29588114/thumbnail-e563e9955a83b660aff2d3c6d8ccb493.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296067"
"ResourceRecordKey" => "29588114"
"ModificationTimestamp" => "2026-04-10T19:03:19.18Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6584602508"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29588114/a80d504d966af523e5fcb3d9f5343954.webp"
"MediaSize" => 332521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29588114/thumbnail-a80d504d966af523e5fcb3d9f5343954.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296067"
"ResourceRecordKey" => "29588114"
"ModificationTimestamp" => "2026-04-10T19:03:19.18Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6584602557"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29588114/9b0aa522932673ec48c40840f42d0572.webp"
"MediaSize" => 330682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29588114/thumbnail-9b0aa522932673ec48c40840f42d0572.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296067"
"ResourceRecordKey" => "29588114"
"ModificationTimestamp" => "2026-04-10T19:03:19.18Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6584602661"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29588114/718526f344b95ef90272992178a8b8ad.webp"
"MediaSize" => 382073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29588114/thumbnail-718526f344b95ef90272992178a8b8ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296067"
"ResourceRecordKey" => "29588114"
"ModificationTimestamp" => "2026-04-10T19:03:19.18Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6584602740"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29588114/a5b0abf1bbf288fcd89912a861f9d908.webp"
"MediaSize" => 316944
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29588114/thumbnail-a5b0abf1bbf288fcd89912a861f9d908.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296067"
"ResourceRecordKey" => "29588114"
"ModificationTimestamp" => "2026-04-10T19:03:19.18Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6584602767"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29588114/6b3fade83ae27ef1579f0dfaa7bc5c64.webp"
"MediaSize" => 329532
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29588114/thumbnail-6b3fade83ae27ef1579f0dfaa7bc5c64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296067"
"ResourceRecordKey" => "29588114"
"ModificationTimestamp" => "2026-04-10T19:03:19.18Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6584602852"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29588114/274d27e1f471c4efee9cf621332f698c.webp"
"MediaSize" => 351158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29588114/thumbnail-274d27e1f471c4efee9cf621332f698c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296067"
"ResourceRecordKey" => "29588114"
"ModificationTimestamp" => "2026-04-10T19:03:19.18Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6584602877"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29588114/a202fda69c0dd36edff33552d2fcc408.webp"
"MediaSize" => 299951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29588114/thumbnail-a202fda69c0dd36edff33552d2fcc408.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296067"
"ResourceRecordKey" => "29588114"
"ModificationTimestamp" => "2026-04-10T19:03:19.18Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6584602900"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29588114/d81bd41c18ff6800ef0460daf1f21a2e.webp"
"MediaSize" => 305590
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29588114/thumbnail-d81bd41c18ff6800ef0460daf1f21a2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296067"
"ResourceRecordKey" => "29588114"
"ModificationTimestamp" => "2026-04-10T19:03:19.18Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6584603003"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29588114/4017f5d3152ab2babefd6e96fd064d7b.webp"
"MediaSize" => 347928
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29588114/thumbnail-4017f5d3152ab2babefd6e96fd064d7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296067"
"ResourceRecordKey" => "29588114"
"ModificationTimestamp" => "2026-04-10T19:03:19.18Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6584603071"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29588114/b862f5bdf7cb12668951c51739bd2746.webp"
"MediaSize" => 284917
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29588114/thumbnail-b862f5bdf7cb12668951c51739bd2746.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296067"
"ResourceRecordKey" => "29588114"
"ModificationTimestamp" => "2026-04-10T19:03:19.18Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6584603174"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29588114/492ede1b11a6ae5a3912ee68b4763b24.webp"
"MediaSize" => 289087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29588114/thumbnail-492ede1b11a6ae5a3912ee68b4763b24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1296067"
"ResourceRecordKey" => "29588114"
"ModificationTimestamp" => "2026-04-10T19:03:19.18Z"
]
]
+"DaysOnMarket": 82
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29588114')"
+"ID": "1307668"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 293977" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24790
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2016745" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24800
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29588114'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25174
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29588114'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25190
+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 '29588114' 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.705038 47.566679)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25243
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25237
+post_id: "1564228"
+post_author: 1
+"ListingKey": "29951410"
+"ListingId": "1299498"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T15:10:10Z"
+"RFModificationTimestamp": "2026-06-29T15:12:28Z"
+"ListPrice": 349900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1500.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1A2H4"
+"UnparsedAddress": "209 Empire Avenue, St. John's, Newfoundland & Labrador A1A2H4"
+"Coordinates": array:2 [
0 => -52.728872
1 => 47.565825
]
+"Latitude": 47.565825
+"Longitude": -52.728872
+"YearBuilt": 1965
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "**Live where you work — a rare mixed-use opportunity in the heart of St. John's.** Perfectly positioned in a central, highly accessible part of the city, this versatile property pairs comfortable residential living with a turnkey commercial space, offering a genuinely unique opportunity for the entrepreneur ready to build something of their own. The residential side features four spacious bedrooms and a full bath, with recently installed new flooring and fresh paint throughout that give the home a clean, move-in-ready feel. An attached garage and a fully fenced backyard round out the living space, providing privacy, storage, and room to enjoy. The commercial side is set up for food service, complete with a commercial kitchen, dedicated storage, and a takeout/lobby area — ideal for launching your own takeout, bakery, catering operation, or specialty food business. Set within a residential neighbourhood that carries an established commercial use, this is the kind of location and zoning combination that's hard to find and even harder to replicate. Whether you're an established operator looking to expand or a first-time owner dreaming of running your own kitchen while living just steps away, this property delivers the location, the layout, and the opportunity to make it happen. Properties like this don't come along often — book your viewing today. (id:62650)"
+"BusinessType": "Food Services and Beverage,Restaurant"
+"CreationDate": "2026-06-25T20:46:45.659901+00:00"
+"Flooring": array:1 [
0 => "Mixed Flooring"
]
+"Heating": array:1 [
0 => "Oil"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2058349"
+"ListOfficeKey": "88555"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "50 x 100"
+"PhotosChangeTimestamp": "2026-06-25T14:43:19Z"
+"PhotosCount": 42
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-29T15:03:02Z"
+"StreetName": "Empire"
+"StreetNumber": "209"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3740"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=xDtyveZGFQ1"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29951410/209-empire-avenue-st-johns"
+"StructureType": array:1 [
0 => "Special Purpose"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R3"
+"OriginalEntryTimestamp": "2026-06-25T14:43:19.33Z"
+"ListAgentNationalAssociationId": "1333492"
+"ListOfficeNationalAssociationId": "1007294"
+"Media": array:42 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29951410_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/6fb416e3b8b75718652df26c4e5a464e.webp"
"MediaSize" => 347920
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-6fb416e3b8b75718652df26c4e5a464e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29951410_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/bd3fc6ee998029fcac6ec3a53dade933.webp"
"MediaSize" => 402114
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-bd3fc6ee998029fcac6ec3a53dade933.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29951410_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/a1ce8db425b960d6bf5b657918f0a656.webp"
"MediaSize" => 389884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-a1ce8db425b960d6bf5b657918f0a656.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29951410_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/40df46eb1627d3ab26ca27e26975e303.webp"
"MediaSize" => 469036
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-40df46eb1627d3ab26ca27e26975e303.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29951410_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/7fd049867f050ed7c90811d335f8a8dc.webp"
"MediaSize" => 407242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-7fd049867f050ed7c90811d335f8a8dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29951410_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/110543a13ec5b1d93f17a9dbc8837b26.webp"
"MediaSize" => 313018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-110543a13ec5b1d93f17a9dbc8837b26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29951410_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/5e5d456fe40244d55a3b5c8b9c04e7da.webp"
"MediaSize" => 338773
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-5e5d456fe40244d55a3b5c8b9c04e7da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29951410_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/ef58794ab806bd861e8986f77ea1f6f6.webp"
"MediaSize" => 249375
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-ef58794ab806bd861e8986f77ea1f6f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29951410_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/542356304a5927129bd2be93d64bd926.webp"
"MediaSize" => 256168
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-542356304a5927129bd2be93d64bd926.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29951410_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/f8feb18d950e753156e7dcb9fdda41d9.webp"
"MediaSize" => 230666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-f8feb18d950e753156e7dcb9fdda41d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29951410_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/47d70f3cd7da036e7b72bfb43f094c2c.webp"
"MediaSize" => 148279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-47d70f3cd7da036e7b72bfb43f094c2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29951410_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/850d048c148495e9ef68b2d67a971564.webp"
"MediaSize" => 285926
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-850d048c148495e9ef68b2d67a971564.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29951410_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/d2c286a0e559c78f3feb0eb409c1c9e6.webp"
"MediaSize" => 281524
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-d2c286a0e559c78f3feb0eb409c1c9e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29951410_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/854032ef40979283fca22b4da9d04708.webp"
"MediaSize" => 264283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-854032ef40979283fca22b4da9d04708.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29951410_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/1716c08d3cd3151ebf9f4c3da274ea69.webp"
"MediaSize" => 254358
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-1716c08d3cd3151ebf9f4c3da274ea69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29951410_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/aeff5f61570a3767ea3e2cb1781fb277.webp"
"MediaSize" => 322436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-aeff5f61570a3767ea3e2cb1781fb277.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29951410_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/b96362323dab6c1fc7f961d4a8a2baf6.webp"
"MediaSize" => 334785
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-b96362323dab6c1fc7f961d4a8a2baf6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29951410_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/9b5bb0d73f08a966ab806e4d727c9321.webp"
"MediaSize" => 322506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-9b5bb0d73f08a966ab806e4d727c9321.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29951410_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/298c5a17ca5efb68aca1a70f361d9ee5.webp"
"MediaSize" => 301116
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-298c5a17ca5efb68aca1a70f361d9ee5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29951410_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/39674ca8d6f751d63d4ca3d05c7ededb.webp"
"MediaSize" => 320274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-39674ca8d6f751d63d4ca3d05c7ededb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29951410_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/0790fb45293586d9ec55ba5a645d28ad.webp"
"MediaSize" => 162825
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-0790fb45293586d9ec55ba5a645d28ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29951410_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/2c95593d7b707a9b988e9dac3b9f6298.webp"
"MediaSize" => 239847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-2c95593d7b707a9b988e9dac3b9f6298.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29951410_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/29ed7a64529b0dbf53ea5de991dc5640.webp"
"MediaSize" => 225864
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-29ed7a64529b0dbf53ea5de991dc5640.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29951410_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/33840272fb2638101acc1535afb1afd2.webp"
"MediaSize" => 177536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-33840272fb2638101acc1535afb1afd2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29951410_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/465f22d3b84cfacc2be453818e9421b8.webp"
"MediaSize" => 245201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-465f22d3b84cfacc2be453818e9421b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29951410_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/f6f97fbbd0bcd349a2d5f148af903b3b.webp"
"MediaSize" => 157193
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-f6f97fbbd0bcd349a2d5f148af903b3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29951410_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/1f0aabee8c3832b44875f2a5e6c24854.webp"
"MediaSize" => 159894
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-1f0aabee8c3832b44875f2a5e6c24854.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29951410_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/005264ab1eb3be22fa33a4952941e001.webp"
"MediaSize" => 108487
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-005264ab1eb3be22fa33a4952941e001.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29951410_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/57ab8f47519b703fda17aeaf1a9688da.webp"
"MediaSize" => 220131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-57ab8f47519b703fda17aeaf1a9688da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29951410_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/3e779a47229562749a4a752b4bb6b034.webp"
"MediaSize" => 220874
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-3e779a47229562749a4a752b4bb6b034.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29951410_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/a0d68928e11971578fe53e68f316300f.webp"
"MediaSize" => 238721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-a0d68928e11971578fe53e68f316300f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29951410_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/473612805a26601750a4fcf3fa450f0e.webp"
"MediaSize" => 262534
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-473612805a26601750a4fcf3fa450f0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29951410_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/7ad6f6c3415b7474c3e04deeae0d4510.webp"
"MediaSize" => 256355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-7ad6f6c3415b7474c3e04deeae0d4510.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29951410_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/fb348e82a698905439d51c73ab59e2ce.webp"
"MediaSize" => 226953
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-fb348e82a698905439d51c73ab59e2ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29951410_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/800948cacd56917d37ff9acb85ac778e.webp"
"MediaSize" => 257221
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-800948cacd56917d37ff9acb85ac778e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29951410_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/1348b9ff2fcc57e033ebaf623bd839aa.webp"
"MediaSize" => 251197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-1348b9ff2fcc57e033ebaf623bd839aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29951410_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/e0d9ca5f5f7f5c23a66098b830dca8aa.webp"
"MediaSize" => 306983
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-e0d9ca5f5f7f5c23a66098b830dca8aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29951410_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/d506ee7c3fa3ba7afb417de6097a9efa.webp"
"MediaSize" => 231014
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-d506ee7c3fa3ba7afb417de6097a9efa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29951410_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/40d8e18c6fe1c75c8b27a23fe9611080.webp"
"MediaSize" => 227858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-40d8e18c6fe1c75c8b27a23fe9611080.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29951410_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/c0ae70db257be9a161f0b4940c27b1ec.webp"
"MediaSize" => 237417
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-c0ae70db257be9a161f0b4940c27b1ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29951410_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/305f20d78e2bb9de700eb5913f7dccb9.webp"
"MediaSize" => 197518
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-305f20d78e2bb9de700eb5913f7dccb9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29951410_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951410/abffa3352cc9bb724f32cf6ab71ef081.webp"
"MediaSize" => 238534
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951410/thumbnail-abffa3352cc9bb724f32cf6ab71ef081.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299498"
"ResourceRecordKey" => "29951410"
"ModificationTimestamp" => "2026-06-25T14:43:19.34Z"
]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29951410')"
+"ID": "1564228"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25239
+post_id: "1549885"
+post_author: 1
+"ListingKey": "29929794"
+"ListingId": "1299244"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T18:45:01Z"
+"RFModificationTimestamp": "2026-06-19T19:47:25Z"
+"ListPrice": 349000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C4G7"
+"UnparsedAddress": "27 Cookstown Road, St. John's, Newfoundland & Labrador A1C4G7"
+"Coordinates": array:2 [
0 => -52.71597
1 => 47.563489
]
+"Latitude": 47.563489
+"Longitude": -52.71597
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Welcome to 27 Cookstown Road, a prime opportunity for entrepreneurs in historic downtown St. John’s. This versatile mixed-use property offers the perfect blend of commercial functionality and modern residential living. The main level features a fully equipped bakery restaurant with a spacious kitchen, two half bathrooms for customer use, and recent upgrades including new baseboard heaters, renovated storage, updated flooring, bar, fresh paint, appliances, equipment, furniture, and fixtures. The restaurant is currently leased, providing immediate rental income. Upstairs, the executive-style 3-bedroom apartment offers a brand-new kitchen, bathroom, flooring, doors, roof, fresh paint, and a private balcony with artificial grass. A large basement storage area adds flexibility for business or personal use. Save on utilities with two mini-split heat pumps in the commercial space and one in the apartment, all under a 10-year warranty. Situated in the heart of downtown, this property is surrounded by thriving businesses, shopping, and entertainment, making it a prime location for success. Whether you're an entrepreneur, investor, or business owner, this is an incredible opportunity to own a property with strong commercial and residential potential. (id:62650)"
+"BusinessType": "Food Services and Beverage,Other,Restaurant"
+"CreationDate": "2026-06-19T19:47:17.233997+00:00"
+"Heating": array:3 [
0 => "Baseboard heaters"
1 => "Electric"
2 => "Mini-Split"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2141852"
+"ListOfficeKey": "88563"
+"PhotosChangeTimestamp": "2026-06-19T18:33:25Z"
+"PhotosCount": 29
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-19T18:33:25Z"
+"StreetName": "Cookstown"
+"StreetNumber": "27"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "1797"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29929794/27-cookstown-road-st-johns"
+"StructureType": array:1 [
0 => "Special Purpose"
]
+"CoListAgentKey": "1987537"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "88563"
+"GeocodeManualYN": true
+"ZoningDescription": "Com/Res"
+"OriginalEntryTimestamp": "2026-06-19T18:33:25.31Z"
+"ListAgentNationalAssociationId": "1393507"
+"ListOfficeNationalAssociationId": "1260564"
+"CoListAgentNationalAssociationId": "1271779"
+"CoListOfficeNationalAssociationId": "1260564"
+"Media": array:29 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29929794_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/0585044761bd184bbdd3c0eae89cadaf.webp"
"MediaSize" => 285204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-0585044761bd184bbdd3c0eae89cadaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29929794_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/d8bfb5fd18addd50ed79c3ad808252a6.webp"
"MediaSize" => 166825
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-d8bfb5fd18addd50ed79c3ad808252a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29929794_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/640e42a8e33c4c0e0b12451adf4fda8b.webp"
"MediaSize" => 182214
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-640e42a8e33c4c0e0b12451adf4fda8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29929794_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/bfff3fff9f1dda29c2715be6ba843d4e.webp"
"MediaSize" => 163110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-bfff3fff9f1dda29c2715be6ba843d4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29929794_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/c6eb3b7f96eee018fb2b2fe772d1fd55.webp"
"MediaSize" => 149661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-c6eb3b7f96eee018fb2b2fe772d1fd55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29929794_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/0c105ccf40a78e8538a1592498a668cc.webp"
"MediaSize" => 152949
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-0c105ccf40a78e8538a1592498a668cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29929794_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/5311ca70c043ad3157a2ecfaacff81d0.webp"
"MediaSize" => 101104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-5311ca70c043ad3157a2ecfaacff81d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29929794_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/9861b9851e6cc720d9664543f3e0f456.webp"
"MediaSize" => 140432
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-9861b9851e6cc720d9664543f3e0f456.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29929794_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/020116f546f4c926733eb7c64eb5c99e.webp"
"MediaSize" => 151647
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-020116f546f4c926733eb7c64eb5c99e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29929794_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/dda752c9dba43e4a8d16777e23ecaf8a.webp"
"MediaSize" => 162933
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-dda752c9dba43e4a8d16777e23ecaf8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29929794_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/27b62401ecdaf41a36af2cba045036ba.webp"
"MediaSize" => 153589
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-27b62401ecdaf41a36af2cba045036ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29929794_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/c5ace7e6b47d9a413550943e3b0f2187.webp"
"MediaSize" => 87595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-c5ace7e6b47d9a413550943e3b0f2187.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29929794_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/88546c774ace928e20ecc171db322f8d.webp"
"MediaSize" => 90369
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-88546c774ace928e20ecc171db322f8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29929794_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/9d40a961ca28971610d2946c6845b5a9.webp"
"MediaSize" => 187777
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-9d40a961ca28971610d2946c6845b5a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29929794_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/52ff905fc34550c8aa5a97501c2b5df2.webp"
"MediaSize" => 188270
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-52ff905fc34550c8aa5a97501c2b5df2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29929794_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/82dad21a6c5917fbca1fee4bd78883e2.webp"
"MediaSize" => 198041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-82dad21a6c5917fbca1fee4bd78883e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29929794_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/def15674d6c2e52b6cb33b7c4efbdf1b.webp"
"MediaSize" => 136136
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-def15674d6c2e52b6cb33b7c4efbdf1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29929794_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/634db439a0b5b86d52ccb3913629e1c6.webp"
"MediaSize" => 151660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-634db439a0b5b86d52ccb3913629e1c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29929794_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/1c5cc74ccdd010b56580ca7960d3cec5.webp"
"MediaSize" => 144063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-1c5cc74ccdd010b56580ca7960d3cec5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29929794_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/5a1582996483b06b3afcafe46b0af7ba.webp"
"MediaSize" => 137205
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-5a1582996483b06b3afcafe46b0af7ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29929794_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/24885b930592b5e2579d3a7c1648498a.webp"
"MediaSize" => 117148
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-24885b930592b5e2579d3a7c1648498a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29929794_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/15f6ca9ffe698fe3cf4be5b0aa3308cd.webp"
"MediaSize" => 87180
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-15f6ca9ffe698fe3cf4be5b0aa3308cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29929794_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/95ec0bff323a56c69dda96c0f2c0eaa8.webp"
"MediaSize" => 123403
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-95ec0bff323a56c69dda96c0f2c0eaa8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29929794_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/001718be48d140a752ff1807bf602758.webp"
"MediaSize" => 121976
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-001718be48d140a752ff1807bf602758.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29929794_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/4dec76122e8e58951fb3ef8f61e3946a.webp"
"MediaSize" => 113151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-4dec76122e8e58951fb3ef8f61e3946a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29929794_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/68fd5256e574271c928831f56a053ea0.webp"
"MediaSize" => 251268
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-68fd5256e574271c928831f56a053ea0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29929794_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/8026393d78a64d45d5b6cfcca4adc8c4.webp"
"MediaSize" => 275429
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-8026393d78a64d45d5b6cfcca4adc8c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29929794_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/56c7b1e3249d8676f63a5a36010fd1c5.webp"
"MediaSize" => 263622
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-56c7b1e3249d8676f63a5a36010fd1c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29929794_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29929794/4ef01173356ab5f60f4b0a2002b2e5c3.webp"
"MediaSize" => 305571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29929794/thumbnail-4ef01173356ab5f60f4b0a2002b2e5c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299244"
"ResourceRecordKey" => "29929794"
"ModificationTimestamp" => "2026-06-19T18:33:25.31Z"
]
]
+"DaysOnMarket": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29929794')"
+"ID": "1549885"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25236
+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"
…5
]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"DaysOnMarket": 29
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29839352')"
+"ID": "1484787"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25240
+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 [ …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]
]
+"DaysOnMarket": 37
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29801494')"
+"ID": "1457251"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25238
+post_id: "1450815"
+post_author: 1
+"ListingKey": "29788978"
+"ListingId": "1297894"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T12:50:01Z"
+"RFModificationTimestamp": "2026-06-29T13:03:07Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 3136.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C2L6"
+"UnparsedAddress": "210 Pennywell Road, St. John's, Newfoundland & Labrador A1C2L6"
+"Coordinates": array:2 [
0 => -52.726668
1 => 47.559974
]
+"Latitude": 47.559974
+"Longitude": -52.726668
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Ideal owner-operator restaurant opportunity in the center of St. John's. Operating as the well-known New City Restaurant, this high-visibility property successfully served the community for more than 25 years and offers outstanding potential for a wide range of future uses. Ideally located just moments from downtown, Ropewalk Lane, Memorial University, the Avalon Mall, major amenities, and key transportation routes, this property combines convenience, exposure, and long-term upside in one strategic location. The longstanding restaurant operation may support future discretionary commercial use opportunities subject to City approvals, while the existing layout and history provide an excellent foundation for a purchaser looking to bring new life and vision to the space. Currently zoned R2, the property also presents significant redevelopment and residential intensification potential. The building includes a spacious 6-bedroom apartment, creating additional income potential for investors or flexibility for owner occupancy, staff accommodations, or future redevelopment concepts. Whether you're an entrepreneur, investor, restaurateur, or developer, this property offers exceptional value and upside potential in a rapidly evolving area of the city. The property is being offered in its current condition and presents an excellent opportunity for purchasers looking to renovate, reposition, or customize the property to suit their vision. Rarely do opportunities with this combination of location, history, zoning flexibility, and future potential become available. Note - basement not included in total square footage. Please see the 3d tour. (id:62650)"
+"BusinessType": "Other"
+"CreationDate": "2026-05-22T13:55:08.730420+00:00"
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1572241"
+"ListOfficeKey": "293977"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "72x49x75x49x150"
+"PhotosChangeTimestamp": "2026-06-29T12:23:40Z"
+"PhotosCount": 50
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-29T12:43:33Z"
+"StreetName": "Pennywell"
+"StreetNumber": "210"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6995"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=Mu7gMqC4Pit"
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2026
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29788978/210-pennywell-road-st-johns"
+"StructureType": array:1 [
0 => "Commercial Mix"
]
+"CoListAgentKey": "2246148"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "293977"
+"GeocodeManualYN": true
+"ZoningDescription": "Res / Comm"
+"OriginalEntryTimestamp": "2026-05-22T12:23:02.54Z"
+"ListAgentNationalAssociationId": "1117242"
+"ListOfficeNationalAssociationId": "1433917"
+"CoListAgentNationalAssociationId": "1484979"
+"CoListOfficeNationalAssociationId": "1433917"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 40
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29788978')"
+"ID": "1450815"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25233
+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 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 42
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29774982')"
+"ID": "1439575"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1438446"
+post_author: 1
+"ListingKey": "29770682"
+"ListingId": "1297475"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:45:25Z"
+"RFModificationTimestamp": "2026-06-16T17:21:39Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 3855.0
+"BuildingAreaTotal": 0
+"City": "St. Johns"
+"PostalCode": "A1C4K7"
+"UnparsedAddress": "90 Barters Hill, St. Johns, Newfoundland & Labrador A1C4K7"
+"Coordinates": array:2 [
0 => -52.71654
1 => 47.561366
]
+"Latitude": 47.561366
+"Longitude": -52.71654
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Welcome to 90 Barter’s Hill — a rare opportunity to own a character-filled commercial property in a prime downtown location, just steps from local cafés, restaurants, and everyday amenities. Full of charm and original character throughout, this unique building offers the perfect blend of functionality and presence, making it ideal for a variety of professional or business uses. Inside, you’ll find a spacious reception area, a large boardroom, seven office spaces spread across multiple levels, a kitchenette, and three bathrooms — all thoughtfully laid out to support a growing business or multi-office setup. The main floor features an inviting reception area, large boardroom, two private offices, and a bathroom. There is also wheelchair accessibility to the main floor through the rear entrance of the building, adding valuable accessibility and convenience for clients and staff alike. Upstairs offers five more office spaces along with a two generous storage rooms. While the basement provides substantial additional storage with multiple separate rooms, a kitchenette, two bathrooms and endless flexibility for operational needs. The property is also equipped with 8 mini split heads, offering efficient heating and cooling throughout the building for year-round comfort. Outside, the exterior has been redone in the past (shingles, siding, windows) and the property offers valuable off-street parking with space for 6-7 vehicles — a rare find this close to downtown. With exceptional visibility, timeless character, and an unbeatable location, 90 Barter’s Hill is the kind of commercial space that rarely comes available. (id:62650)"
+"BusinessType": "Service"
+"CreationDate": "2026-05-19T19:02:24.440669+00:00"
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Concrete Slab"
]
+"Heating": array:4 [
0 => "Hot water radiator heat"
1 => "Radiant heat"
2 => "Electric"
3 => "Mini-Split"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2006056"
+"ListOfficeKey": "280379"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "512sqm"
+"PhotosChangeTimestamp": "2026-05-19T17:42:56Z"
+"PhotosCount": 34
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-16T16:36:37Z"
+"Stories": "2.0"
+"StreetName": "Barters"
+"StreetNumber": "90"
+"StreetSuffix": "Hill"
+"TaxAnnualAmount": "13508"
+"VirtualTourURLUnbranded": "https://unbranded.visithome.ai/nzc8L6SaddLSnQ6aP9jhDK?mu=ft"
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2026
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29770682/90-barters-hill-st-johns"
+"StructureType": array:1 [
0 => "Offices"
]
+"CoListAgentKey": "2084916"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "280379"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Air Conditioning"
]
+"ZoningDescription": "RM"
+"OriginalEntryTimestamp": "2026-05-19T17:42:56.52Z"
+"ListAgentNationalAssociationId": "1288406"
+"ListOfficeNationalAssociationId": "1313257"
+"CoListAgentNationalAssociationId": "1358339"
+"CoListOfficeNationalAssociationId": "1313257"
+"Media": array:34 [
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]
]
+"DaysOnMarket": 43
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29770682')"
+"ID": "1438446"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25241
+post_id: "1435093"
+post_author: 1
+"ListingKey": "29768315"
+"ListingId": "1297663"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Office"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-19T13:40:56Z"
+"RFModificationTimestamp": "2026-05-19T17:45:28Z"
+"ListPrice": 1300000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1E1B7"
+"UnparsedAddress": "260-268 Water Street, St. John's, Newfoundland & Labrador A1E1B7"
+"Coordinates": array:2 [
0 => -52.708762
1 => 47.562648
]
+"Latitude": 47.562648
+"Longitude": -52.708762
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Welcome to 260–268 Water Street, a prime commercial investment opportunity in the heart of downtown St. John's. This well located mixed use building features a fully operating restaurant on the main floor, The Estee Cafe, known for its strong local presence and steady foot traffic. The second floor is home to The Bamboo Room, a popular bar that adds to the building’s vibrant appeal and consistent revenue potential. Positioned along one of the city’s busiest and most recognized streets, this property benefits from excellent visibility, high pedestrian traffic, and proximity to shops, offices, and tourist attractions. Whether you are looking to expand your portfolio or own a standout property in a sought after downtown location, this building offers both immediate income and long term upside. (id:62650)"
+"BusinessType": "Other,Retail and Wholesale,Service"
+"CreationDate": "2026-05-19T17:45:04.712763+00:00"
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2141852"
+"ListOfficeKey": "88563"
+"PhotosChangeTimestamp": "2026-05-19T13:33:29Z"
+"PhotosCount": 1
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-05-19T13:33:29Z"
+"StreetName": "Water"
+"StreetNumber": "260-268"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "25000"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29768315/260-268-water-street-st-johns"
+"StructureType": array:1 [
0 => "Retail"
]
+"CoListAgentKey": "1987537"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "88563"
+"GeocodeManualYN": true
+"ZoningDescription": "com"
+"OriginalEntryTimestamp": "2026-05-19T13:33:29.7Z"
+"ListAgentNationalAssociationId": "1393507"
+"ListOfficeNationalAssociationId": "1260564"
+"CoListAgentNationalAssociationId": "1271779"
+"CoListOfficeNationalAssociationId": "1260564"
+"Media": array:1 [
0 => array:13 [ …13]
]
+"DaysOnMarket": 43
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29768315')"
+"ID": "1435093"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25242
+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": 43
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29768419')"
+"ID": "1435108"
}
]
+success: true
+page_size: 9
+page_count: 3
+count: 24
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]