array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29173465/Property?$select=ALL&$top=20&$filter=ListingKey eq 29173465&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29173465/Property?$select=ALL&$top=20&$filter=ListingKey eq 29173465&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23512
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23514
+post_id: "470800"
+post_author: 1
+"ListingKey": "29173465"
+"ListingId": "1293189"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-09T14:00:54Z"
+"RFModificationTimestamp": "2025-12-09T17:18:38Z"
+"ListPrice": 999500.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "St John's"
+"PostalCode": "A1E1C2"
+"UnparsedAddress": "722 Water Street, St John's, Newfoundland & Labrador A1E1C2"
+"Coordinates": array:2 [
0 => -52.720139
1 => 47.548841
]
+"Latitude": 47.548841
+"Longitude": -52.720139
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Investor Opportunity – Mixed-Use Portfolio (2 adjoining Properties) with business number if needed. Seize this rare chance to own a diverse, income-producing portfolio of 2 mixed-use properties offering strong current returns and long-term growth potential. With a combination of residential units, commercial leases, and included assets, this package delivers over $7700/month in rental income. --722 Water Street Flexible Use: 1–2 residential units or commercial space on the main with residential above Current Income: $3,200/month Zoning: Commercial/residential mix Ideal For: Owner-occupiers, live/work setups, or pure rental. --720 Water Street (Neighbouring Property) Commercial Lease: Triple Net (NNN) tenant at $4,500/month. Fully Renovated: Modernized throughout. Bonus Asset: Includes a fully equipped butcher shop with $250,000 in commercial-grade equipment (included in sale). Turnkey Investment: Stable tenant with minimal maintenance. (id:62650)"
+"BusinessType": "Accommodation,Food Services and Beverage,Restaurant,Retail and Wholesale"
+"CreationDate": "2025-12-09T17:18:21.957943+00:00"
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2135750"
+"ListOfficeKey": "285811"
+"PhotosChangeTimestamp": "2025-12-09T13:52:45Z"
+"PhotosCount": 20
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-12-09T13:52:45Z"
+"StreetName": "Water"
+"StreetNumber": "722"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3300"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29173465/722-water-street-st-johns"
+"StructureType": array:1 [
0 => "Retail"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "cm"
+"OriginalEntryTimestamp": "2025-12-09T13:52:45.86Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:20 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6362748723"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/5244c56d65d711476c9310a216a5d102.webp"
"MediaSize" => 248761
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-5244c56d65d711476c9310a216a5d102.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6362748733"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/c4472422de9d14e4a1f198ff6e4d5927.webp"
"MediaSize" => 186065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-c4472422de9d14e4a1f198ff6e4d5927.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6362748741"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/5895c51e705595f16fa5ab0db9b3939c.webp"
"MediaSize" => 175959
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-5895c51e705595f16fa5ab0db9b3939c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6362748748"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/fbcbd98dcd54f96c92f5f6b68cc68fa7.webp"
"MediaSize" => 174807
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-fbcbd98dcd54f96c92f5f6b68cc68fa7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6362748756"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/cbb2c20e50304dd40a2874d07f286916.webp"
"MediaSize" => 171256
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-cbb2c20e50304dd40a2874d07f286916.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6362748758"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/a0e99c8a7dc9d506bd759e013e3a1d0c.webp"
"MediaSize" => 187817
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-a0e99c8a7dc9d506bd759e013e3a1d0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6362748762"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/d2f164f76b4c3570ea6ad747d9c903ac.webp"
"MediaSize" => 269567
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-d2f164f76b4c3570ea6ad747d9c903ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6362748764"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/d9a46e88c0aaab7502d679b46e0bedc0.webp"
"MediaSize" => 200321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-d9a46e88c0aaab7502d679b46e0bedc0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6362748766"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/793d27149f8131a041016f0b512f5e88.webp"
"MediaSize" => 116088
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-793d27149f8131a041016f0b512f5e88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6362748771"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/a6497fa0b96b70b18be77d1743f3d3cc.webp"
"MediaSize" => 127544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-a6497fa0b96b70b18be77d1743f3d3cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6362748772"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/6bbe2616de1ace162346d944f0589632.webp"
"MediaSize" => 123751
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-6bbe2616de1ace162346d944f0589632.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6362748776"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/c909895db6e4564878da6aaf95ed1fc8.webp"
"MediaSize" => 117222
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-c909895db6e4564878da6aaf95ed1fc8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6362748777"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/d011213cde8026b943e20d8cc020b3eb.webp"
"MediaSize" => 128356
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-d011213cde8026b943e20d8cc020b3eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6362748780"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/2dd4ea3db442f9aa6819ca43c3ee490b.webp"
"MediaSize" => 157532
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-2dd4ea3db442f9aa6819ca43c3ee490b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6362748781"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/a897207967020f5346091652de167c40.webp"
"MediaSize" => 135621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-a897207967020f5346091652de167c40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6362748783"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/027f169b0d9556a479dbfd8508ed2497.webp"
"MediaSize" => 135030
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-027f169b0d9556a479dbfd8508ed2497.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6362748785"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/50a77509880ce178572855c8a8414c76.webp"
"MediaSize" => 121411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-50a77509880ce178572855c8a8414c76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6362748787"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/dfedb44a14ee5a53ac4dc547a095a3db.webp"
"MediaSize" => 108255
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-dfedb44a14ee5a53ac4dc547a095a3db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6362748789"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/7bcd5b863820ea5c1f2c7e74f41d97ca.webp"
"MediaSize" => 142722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-7bcd5b863820ea5c1f2c7e74f41d97ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6362748792"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173465/508d1e17135aa13317fe0c4893891b3b.webp"
"MediaSize" => 79641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173465/thumbnail-508d1e17135aa13317fe0c4893891b3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293189"
"ResourceRecordKey" => "29173465"
"ModificationTimestamp" => "2025-12-09T13:52:45.87Z"
]
]
+"Member": array:1 [
0 => array:21 [
"MemberFullName" => "Jeff LeDrew"
"MemberFirstName" => "Jeff"
"MemberLastName" => "LeDrew"
"MemberMlsId" => "ledreje"
"OriginatingSystemName" => 26
"MemberKey" => "2135750"
"ModificationTimestamp" => "2024-11-28T20:05:39Z"
"MemberStatus" => "Active"
"OfficeKey" => "285811"
"MemberAOR" => "Newfoundland & Labrador"
"MemberCity" => "St. John's"
"MemberType" => "Salesperson"
"MemberAORKey" => "117"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberAddress1" => "33 Pippy Place, Suite 304"
"MemberOfficePhone" => "709-727-8850"
"MemberStateOrProvince" => "Newfoundland & Labrador"
"OriginalEntryTimestamp" => "2021-05-28T14:10:00Z"
"MemberNationalAssociationId" => "1388077"
"OfficeNationalAssociationId" => "1354950"
]
]
+"Office": array:1 [
0 => array:20 [
"OfficeName" => "eXp Realty"
"OfficePhone" => "709-800-0412"
"OfficeMlsId" => "exprealty"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "285811"
"ModificationTimestamp" => "2025-04-20T17:56:20Z"
"OfficeAddress1" => "33 Pippy Place, Suite 304"
"OfficeCity" => "St. John's"
"OfficePostalCode" => "A1B3X"
"OfficeStateOrProvince" => "Newfoundland & Labrador"
"OfficeStatus" => "Active"
"OfficeAOR" => "Newfoundland & Labrador"
"OfficeType" => "Firm"
"OfficeAORKey" => "117"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2019-09-19T14:11:00Z"
"OfficeNationalAssociationId" => "1354950"
"OfficeBrokerNationalAssociationId" => "1157864"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29173465')"
+"ID": "470800"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
"RF Cache Key: 02a57f84c4b122d6125d52d9f801c27973a8218520d859d406329970ae74ded6" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23812
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25314
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "eXp Realty"
+"OfficeEmail": null
+"OfficePhone": "709-800-0412"
+"OfficeMlsId": "exprealty"
+"ModificationTimestamp": "2025-04-20T17:56:20Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "285811"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "33 Pippy Place, Suite 304"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "St. John's"
+"OfficePostalCode": "A1B3X"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Newfoundland & Labrador"
+"OfficeStatus": "Active"
+"OfficeAOR": "Newfoundland & Labrador"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1354950"
+"OriginalEntryTimestamp": "2019-09-19T14:11:00Z"
+"OfficeAORKey": "117"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "431082"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "285811"
"SocialMediaUrlOrId" => "http://exprealty.ca/"
"ModificationTimestamp" => "2025-04-20T17:41:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1157864"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('285811')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2135750/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2135750&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2135750/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2135750&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25307
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29173465" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24949
+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 29173465/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29173465&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29173465/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29173465&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24929
+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 29173465 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.720139 47.548841)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29173465 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.720139 47.548841)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29173465 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.720139 47.548841)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29173465 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.720139 47.548841)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24856
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24793
+post_id: "500446"
+post_author: 1
+"ListingKey": "29202425"
+"ListingId": "1293393"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-23T19:05:27Z"
+"RFModificationTimestamp": "2025-12-23T19:40:17Z"
+"ListPrice": 995000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 9654.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1B2B7"
+"UnparsedAddress": "95 Lemarchant Road, St. John's, Newfoundland & Labrador A1B2B7"
+"Coordinates": array:2 [
0 => -52.717313
1 => 47.560558
]
+"Latitude": 47.560558
+"Longitude": -52.717313
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Situated in a high visibility, prime city centre location with ample rear parking lot, this purpose built medical services/office building presents a unique opportunity! With 3 developed levels, including the walk out basement, this well-constructed building consists of central lobby area, multiple self-contained spaces (ideal for independent tenants if desired), offices, boardroom, kitchenettes, open area for pod systems, several bathroom facilities and storage, allowing for a variety of uses. The accessible main level (~4400 square feet) has a vacant space of 3500 square feet, ideal for an owner occupied tenant. Two wonderful long-term tenants currently occupying a portion of the main level and entire second floor. The walk out basement also has vacant space. Building has been well-maintained by current owner with roof covering and parking lot recently replaced. Great city and harbour views from the rear! Great opportunity exists, with on site parking, and easy access to bus route! (id:62650)"
+"BusinessType": "Other,Service"
+"CreationDate": "2025-12-23T19:40:11.508759+00:00"
+"Flooring": array:1 [
0 => "Mixed Flooring"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1964615"
+"ListOfficeKey": "293977"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "65x200x82x194"
+"PhotosChangeTimestamp": "2025-12-23T18:52:51Z"
+"PhotosCount": 50
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-12-23T18:52:51Z"
+"StreetName": "Lemarchant"
+"StreetNumber": "95"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "29129"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29202425/95-lemarchant-road-st-johns"
+"StructureType": array:1 [
0 => "Other"
]
+"CoListAgentKey": "1906420"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "88555"
+"GeocodeManualYN": true
+"ZoningDescription": "Comm."
+"OriginalEntryTimestamp": "2025-12-23T18:52:51.47Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:50 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6381420566"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/9e98ccf77d6d55f4b0e1ffdba88af945.webp"
"MediaSize" => 102217
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-9e98ccf77d6d55f4b0e1ffdba88af945.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6381420569"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/7d6c3e1ab4081b5d1b6f1fccf67bbb8f.webp"
"MediaSize" => 259900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-7d6c3e1ab4081b5d1b6f1fccf67bbb8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6381420572"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/1076de815a44a4632edf2045499b7786.webp"
"MediaSize" => 120344
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-1076de815a44a4632edf2045499b7786.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6381420575"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/7e8260f7f516f4d97b51604532f6b60c.webp"
"MediaSize" => 116832
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-7e8260f7f516f4d97b51604532f6b60c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6381420578"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/1bbe2a24d82cf0547258c959c4e38ea7.webp"
"MediaSize" => 134695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-1bbe2a24d82cf0547258c959c4e38ea7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6381420581"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/426dc09971586c7f23dea27875011d9b.webp"
"MediaSize" => 148842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-426dc09971586c7f23dea27875011d9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6381420586"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/be1c8a80a8af83055d3d07703a21bad4.webp"
"MediaSize" => 152241
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-be1c8a80a8af83055d3d07703a21bad4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6381420600"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/761960038897cb658b1097b910be655c.webp"
"MediaSize" => 160521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-761960038897cb658b1097b910be655c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6381420607"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/a08d985ddbb6ddaa441df4ea4fb11845.webp"
"MediaSize" => 130980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-a08d985ddbb6ddaa441df4ea4fb11845.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6381420612"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/caf516b960299e027328a43df5031fdb.webp"
"MediaSize" => 145167
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-caf516b960299e027328a43df5031fdb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6381420618"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/18232e100d1185d90e534e1f48fd6a74.webp"
"MediaSize" => 127848
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-18232e100d1185d90e534e1f48fd6a74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6381420624"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/506b809c464cc9950c54035578e77154.webp"
"MediaSize" => 128655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-506b809c464cc9950c54035578e77154.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6381420631"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/6ff2204f04ed1a8ecea9cc9839355c0a.webp"
"MediaSize" => 127752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-6ff2204f04ed1a8ecea9cc9839355c0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6381420638"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/939e802e196b04d536833d774baadfc1.webp"
"MediaSize" => 111520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-939e802e196b04d536833d774baadfc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6381420649"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/c3c5df3db8b413aed149a119b45918d1.webp"
"MediaSize" => 92171
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-c3c5df3db8b413aed149a119b45918d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6381420678"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/d8c7c485d0f179430db7b2977cd25528.webp"
"MediaSize" => 93372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-d8c7c485d0f179430db7b2977cd25528.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6381420704"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/9b62d962c728cf899f242d412d755062.webp"
"MediaSize" => 83758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-9b62d962c728cf899f242d412d755062.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6381420712"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/cb54df33992ca5e39a82295eb14483b8.webp"
"MediaSize" => 98450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-cb54df33992ca5e39a82295eb14483b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6381420730"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/a99142c7726f35e3c94ec8c5fbffc833.webp"
"MediaSize" => 93477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-a99142c7726f35e3c94ec8c5fbffc833.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6381420739"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/ef7f8b65f250c99e2a809edc93df900e.webp"
"MediaSize" => 104482
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-ef7f8b65f250c99e2a809edc93df900e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6381420749"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/bf2d9dfe6a2c000ec93ee7cc473eb6e9.webp"
"MediaSize" => 78557
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-bf2d9dfe6a2c000ec93ee7cc473eb6e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6381420759"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/4449b69ae84602c634481b381c4f9d42.webp"
"MediaSize" => 100467
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-4449b69ae84602c634481b381c4f9d42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6381420769"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/7529f5ea7a29b1ec43ec10a97ed2b236.webp"
"MediaSize" => 88592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-7529f5ea7a29b1ec43ec10a97ed2b236.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6381420778"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/aad6774775bd6a9338a87c1a0d22c1c7.webp"
"MediaSize" => 82788
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-aad6774775bd6a9338a87c1a0d22c1c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6381420787"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/77ec60ddaab1821f4989da2e9b0e7e3e.webp"
"MediaSize" => 90442
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-77ec60ddaab1821f4989da2e9b0e7e3e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6381420794"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/2063c96bc84571e74e75386363171b93.webp"
"MediaSize" => 85215
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-2063c96bc84571e74e75386363171b93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6381420804"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/204aee7ebc0347e557df7e5a51bc8981.webp"
"MediaSize" => 93609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-204aee7ebc0347e557df7e5a51bc8981.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6381420811"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/4bcf347134bd59fae7c73273dd1aae03.webp"
"MediaSize" => 88249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-4bcf347134bd59fae7c73273dd1aae03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6381420817"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/b0ecdf4d708d52bd5dc916c776472bc9.webp"
"MediaSize" => 89888
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-b0ecdf4d708d52bd5dc916c776472bc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6381420823"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/9608d88ef460c328b488a29401316fbf.webp"
"MediaSize" => 93163
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-9608d88ef460c328b488a29401316fbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6381420830"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/31584d5f4c45df86c2e1a6ed82504b2a.webp"
"MediaSize" => 97618
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-31584d5f4c45df86c2e1a6ed82504b2a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6381420836"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/59a8cea78ec4c5d50de99ef577e00054.webp"
"MediaSize" => 45453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-59a8cea78ec4c5d50de99ef577e00054.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6381420843"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/dd499fdde22990e7548b946a6972813d.webp"
"MediaSize" => 106209
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-dd499fdde22990e7548b946a6972813d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6381420849"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/961d59a31e0bbdecffd060bb1e36afaf.webp"
"MediaSize" => 237570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-961d59a31e0bbdecffd060bb1e36afaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6381420855"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/cc7bf81a0c24b60f4d289e3c5fac75bb.webp"
"MediaSize" => 191820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-cc7bf81a0c24b60f4d289e3c5fac75bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6381420860"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/f410aafc7c96d59477390ae3f7739033.webp"
"MediaSize" => 191626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-f410aafc7c96d59477390ae3f7739033.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6381420865"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/76d7fba947ac83c64c23304ffa38e281.webp"
"MediaSize" => 187510
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-76d7fba947ac83c64c23304ffa38e281.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6381420870"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/a4ff297aa8fc6bab118351f056efbead.webp"
"MediaSize" => 208853
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-a4ff297aa8fc6bab118351f056efbead.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6381420876"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/945e1d1d01eb18a643126436216c5158.webp"
"MediaSize" => 241972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-945e1d1d01eb18a643126436216c5158.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6381420881"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/c46c5d1472cfd1f81e46b0c882da0ec8.webp"
"MediaSize" => 190685
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-c46c5d1472cfd1f81e46b0c882da0ec8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6381420886"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/ae672c600e6d58fc23ddea620a4eb9ed.webp"
"MediaSize" => 240086
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-ae672c600e6d58fc23ddea620a4eb9ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6381420890"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/32661f56001f6df5a799af269f6d05c8.webp"
"MediaSize" => 151821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-32661f56001f6df5a799af269f6d05c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
42 => array:13 [
"Order" => 42
"MediaKey" => "6381420894"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/4d8d25d9493e3b34ead4407f43065421.webp"
"MediaSize" => 174513
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-4d8d25d9493e3b34ead4407f43065421.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
43 => array:13 [
"Order" => 43
"MediaKey" => "6381420900"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/d7ceb0508def79e2d46bd6a9ac31f9b1.webp"
"MediaSize" => 151175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-d7ceb0508def79e2d46bd6a9ac31f9b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
44 => array:13 [
"Order" => 44
"MediaKey" => "6381420904"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/a12b4f7802e49b2a05d5df1dd80791fb.webp"
"MediaSize" => 235485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-a12b4f7802e49b2a05d5df1dd80791fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
45 => array:13 [
"Order" => 45
"MediaKey" => "6381420906"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/1b791f739ad9e7c09c32a8a59897d3ad.webp"
"MediaSize" => 157681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-1b791f739ad9e7c09c32a8a59897d3ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
46 => array:13 [
"Order" => 46
"MediaKey" => "6381420911"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/59c37ecc23357bf928dbff41f151ec10.webp"
"MediaSize" => 71847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-59c37ecc23357bf928dbff41f151ec10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
47 => array:13 [
"Order" => 47
"MediaKey" => "6381420916"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/7bc6e0f8370867a8b5241834426fb4eb.webp"
"MediaSize" => 111536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-7bc6e0f8370867a8b5241834426fb4eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
48 => array:13 [
"Order" => 48
"MediaKey" => "6381420921"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/f12ba5f3b5430a52e59c0a0dd92c3795.webp"
"MediaSize" => 104479
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-f12ba5f3b5430a52e59c0a0dd92c3795.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
49 => array:13 [
"Order" => 49
"MediaKey" => "6381420927"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202425/cd704dddb7c9af47967f4175490aa108.webp"
"MediaSize" => 93103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202425/thumbnail-cd704dddb7c9af47967f4175490aa108.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1293393"
"ResourceRecordKey" => "29202425"
"ModificationTimestamp" => "2025-12-23T18:52:51.48Z"
]
]
+"Member": []
+"Office": array:1 [
0 => array:19 [
"OfficeName" => "RE/MAX Infinity Realty Inc. - Sheraton Hotel"
"OfficePhone" => "709-793-0909"
"OfficeMlsId" => "infinity"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "293977"
"ModificationTimestamp" => "2024-06-19T08:31:11Z"
"OfficeAddress1" => "115 Cavendish Square"
"OfficeCity" => "St. John's"
"OfficePostalCode" => "A1C3K2"
"OfficeStateOrProvince" => "Newfoundland & Labrador"
"OfficeStatus" => "Active"
"OfficeAOR" => "Newfoundland & Labrador"
"OfficeType" => "Firm"
"OfficeAORKey" => "117"
"OriginalEntryTimestamp" => "2023-02-16T15:30:00Z"
"OfficeNationalAssociationId" => "1433917"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1245171"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29202425')"
+"ID": "500446"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25159
+post_id: "450937"
+post_author: 1
+"ListingKey": "29145111"
+"ListingId": "1292910"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-19T14:11:02Z"
+"RFModificationTimestamp": "2025-12-19T14:13:14Z"
+"ListPrice": 425000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "ST JOHNS"
+"PostalCode": "A1E3C3"
+"UnparsedAddress": "68 Pearce Avenue, ST JOHNS, Newfoundland & Labrador A1E3C3"
+"Coordinates": array:2 [
0 => -52.73438
1 => 47.553574
]
+"Latitude": 47.553574
+"Longitude": -52.73438
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Great investment property in the center of the city , high traffic area and storefront across from MUNDY POND and ROPEWALK LANE . Multi -use main floor has had many uses such as convenience store , hair salon, currently a used furniture and antique store with a kitchen and full bathroom , storage . The units consist of a top floor two bedroom unit , a main floor two bedroom unit and a one bedroom unit all with separate meters . 4 units total . Improvements were made on the property over the years by the current owner , all electric heat and tenants pay there own utilities . multiple vehicle parking , monthly income $3250 , long term tenants , 24 hour notice for all viewings , wont last long in this location . (id:62650)"
+"BusinessType": "Food Services and Beverage,Other,Retail and Wholesale,Residential"
+"CreationDate": "2025-11-28T17:29:27.095308+00:00"
+"Flooring": array:2 [
0 => "Laminate"
1 => "Mixed Flooring"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1571842"
+"ListOfficeKey": "264296"
+"LotSizeDimensions": "80X120"
+"PhotosChangeTimestamp": "2025-12-01T21:13:02Z"
+"PhotosCount": 21
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-12-19T13:52:53Z"
+"StreetName": "Pearce"
+"StreetNumber": "68"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "2837"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29145111/68-pearce-avenue-st-johns"
+"StructureType": array:1 [
0 => "Commercial Mix"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "res/comm"
+"OriginalEntryTimestamp": "2025-11-28T14:42:38.95Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:21 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6350464519"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/77d27ddbe9113452e2e6374cce488bc8.webp"
"MediaSize" => 183468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-77d27ddbe9113452e2e6374cce488bc8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:15.89Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6350464540"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/009fde57cfb3dd56ce8505a44dab3aaf.webp"
"MediaSize" => 130680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-009fde57cfb3dd56ce8505a44dab3aaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.51Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6350464558"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/c4728ce10359c3d3431bbb2b7619446a.webp"
"MediaSize" => 138054
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-c4728ce10359c3d3431bbb2b7619446a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:19.21Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6350464562"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/a0822354a28badd9911bc1080e3b4ef9.webp"
"MediaSize" => 333570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-a0822354a28badd9911bc1080e3b4ef9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:16.55Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6350464571"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/e9f001a7a68cde5811718b36698ccf16.webp"
"MediaSize" => 339114
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-e9f001a7a68cde5811718b36698ccf16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.79Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6350464597"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/6339dbbaab84e06b580a84abdc300fde.webp"
"MediaSize" => 167575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-6339dbbaab84e06b580a84abdc300fde.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.34Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6350464614"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/126a940478eea90358f8fd398a055566.webp"
"MediaSize" => 191854
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-126a940478eea90358f8fd398a055566.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.76Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6350464622"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/773dd87cb1fa985ba00af334d218630e.webp"
"MediaSize" => 286373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-773dd87cb1fa985ba00af334d218630e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:21.2Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6350464675"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/917e36313f2db596e61550dc201967d4.webp"
"MediaSize" => 371682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-917e36313f2db596e61550dc201967d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.86Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6350464701"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/e88258b6589d562a66c9326e556dc690.webp"
"MediaSize" => 333708
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-e88258b6589d562a66c9326e556dc690.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.93Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6350464731"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/9ed84ff26b647c5b13a110c7eff63e7c.webp"
"MediaSize" => 334932
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-9ed84ff26b647c5b13a110c7eff63e7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.64Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6350464766"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/7b418624fb265856be8a8957e0ea4c53.webp"
"MediaSize" => 143709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-7b418624fb265856be8a8957e0ea4c53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:21.06Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6350464792"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/13fe17488d89ceba08713f257bbb38df.webp"
"MediaSize" => 143042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-13fe17488d89ceba08713f257bbb38df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:19.08Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6350464871"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/2549c6e598a104478eb73d95f27bf835.webp"
"MediaSize" => 371264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-2549c6e598a104478eb73d95f27bf835.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.77Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6350464935"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/feba710c646eaf7dc44fdf70da90c5e7.webp"
"MediaSize" => 74384
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-feba710c646eaf7dc44fdf70da90c5e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.07Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6350465001"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/11733a70bbb57243b1c9526001f8743c.webp"
"MediaSize" => 142198
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-11733a70bbb57243b1c9526001f8743c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.51Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6350465025"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/23cd308d668c93385a92d2a39d36f2c9.webp"
"MediaSize" => 108594
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-23cd308d668c93385a92d2a39d36f2c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:21.05Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6350465114"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/417c4b4847c98d600535555042b93597.webp"
"MediaSize" => 328962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-417c4b4847c98d600535555042b93597.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.98Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6350465180"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/6f847edddc5d013934434074b22d5ebe.webp"
"MediaSize" => 342128
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-6f847edddc5d013934434074b22d5ebe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.95Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6350465192"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/15b12dc76c7cd196803a208bd77e801f.webp"
"MediaSize" => 148951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-15b12dc76c7cd196803a208bd77e801f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.42Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6350465271"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145111/3aaa816b6be5f98562b84f255c2cc7ca.webp"
"MediaSize" => 330544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145111/thumbnail-3aaa816b6be5f98562b84f255c2cc7ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292910"
"ResourceRecordKey" => "29145111"
"ModificationTimestamp" => "2025-12-01T21:10:20.97Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "HOLLY RIDEOUT"
"MemberFirstName" => "HOLLY"
"MemberLastName" => "RIDEOUT"
"MemberMlsId" => "66722"
"OriginatingSystemName" => 26
"MemberKey" => "1571842"
"ModificationTimestamp" => "2025-09-02T19:42:04Z"
"MemberStatus" => "Active"
"OfficeKey" => "264296"
"MemberAOR" => "Newfoundland & Labrador"
"Media" => array:1 [ …1]
"MemberFax" => "709-753-5375"
"MemberCity" => "St. John's"
"MemberType" => "Salesperson"
"MemberAORKey" => "117"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberAddress1" => "137 Patrick Street"
"MemberOfficePhone" => "709-687-3892"
"MemberStateOrProvince" => "Newfoundland & Labrador"
"MemberNationalAssociationId" => "1148184"
"OfficeNationalAssociationId" => "1224790"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "Rideout Realty"
"OfficePhone" => "709-687-3892"
"OfficeMlsId" => "14168"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "264296"
"ModificationTimestamp" => "2024-06-19T08:31:11Z"
"OfficeAddress1" => "137 Patrick Street"
"OfficeCity" => "St. John's"
"OfficePostalCode" => "A1E2S9"
"OfficeStateOrProvince" => "Newfoundland & Labrador"
"OfficeStatus" => "Active"
"Media" => array:1 [ …1]
"OfficeAOR" => "Newfoundland & Labrador"
"OfficeFax" => "709-753-5375"
"OfficeType" => "Firm"
"OfficeAORKey" => "117"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2011-06-18T01:26:00Z"
"OfficeNationalAssociationId" => "1224790"
"OfficeBrokerNationalAssociationId" => "1148184"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29145111')"
+"ID": "450937"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24827
+post_id: "440916"
+post_author: 1
+"ListingKey": "29131757"
+"ListingId": "1292848"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-24T18:01:00Z"
+"RFModificationTimestamp": "2025-11-24T18:23:34Z"
+"ListPrice": 1060000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 5646.0
+"BuildingAreaTotal": 0
+"City": "St. Johns"
+"PostalCode": "A1E1T1"
+"UnparsedAddress": "209 Blackmarsh Road, St. Johns, Newfoundland & Labrador A1E1T1"
+"Coordinates": array:2 [
0 => -52.739086
1 => 47.545885
]
+"Latitude": 47.545885
+"Longitude": -52.739086
+"YearBuilt": 2015
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "First time to market; Discover an impressive commercial opportunity in this beautifully designed 5,600+ sq. ft. office building, built in 2015 and meticulously maintained. With thoughtful layout, modern systems, and relevant parking capacity, this property is perfectly suited for a professional organization, or corporate headquarters. The main floor welcomes you with a bright lobby leading into a spacious reception area with an adjacent private office. This level also features a large boardroom, full office kitchen, two bathrooms, a cleaning/storage room, a porch with closet, and efficient flow throughout. Wide corridors and smart design make for a comfortable and professional environment. Upstairs, you’ll find another bathroom, two dedicated meeting rooms, and a substantial executive office. The second floor also offers six additional offices (five with exterior windows), plus two storage areas, including one conveniently located near the secondary exit. An elevator services both floors, with a rear second-floor exit for fire safety. Reach out today to explore this fantastic business opportunity ! (id:62650)"
+"BusinessType": "Other,Service"
+"CreationDate": "2025-11-24T18:23:17.954858+00:00"
+"Flooring": array:1 [
0 => "Mixed Flooring"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2149289"
+"ListOfficeKey": "285811"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "25.89x50.1 m"
+"PhotosChangeTimestamp": "2025-11-24T17:53:43Z"
+"PhotosCount": 40
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-11-24T17:53:43Z"
+"Stories": "2.0"
+"StreetName": "Blackmarsh"
+"StreetNumber": "209"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "26432"
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2024
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29131757/209-blackmarsh-road-st-johns"
+"StructureType": array:1 [
0 => "Other"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "COMMERCIAL"
+"OriginalEntryTimestamp": "2025-11-24T17:53:43.71Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:40 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6337561807"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131757/f4176177753e6c387cd185a198de909c.webp"
"MediaSize" => 183260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131757/thumbnail-f4176177753e6c387cd185a198de909c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292848"
"ResourceRecordKey" => "29131757"
"ModificationTimestamp" => "2025-11-24T17:53:43.72Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6337561856"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131757/e200354f2e0720582fe15fcfe9533347.webp"
"MediaSize" => 215331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131757/thumbnail-e200354f2e0720582fe15fcfe9533347.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292848"
"ResourceRecordKey" => "29131757"
"ModificationTimestamp" => "2025-11-24T17:53:43.72Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6337561933"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131757/8238dc332b64e67b7c64c87b8bc1480c.webp"
"MediaSize" => 328098
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131757/thumbnail-8238dc332b64e67b7c64c87b8bc1480c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292848"
"ResourceRecordKey" => "29131757"
"ModificationTimestamp" => "2025-11-24T17:53:43.72Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6337562005"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131757/ce960bc0e1c382e2c277f6a8fa449380.webp"
"MediaSize" => 303284
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131757/thumbnail-ce960bc0e1c382e2c277f6a8fa449380.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292848"
"ResourceRecordKey" => "29131757"
"ModificationTimestamp" => "2025-11-24T17:53:43.72Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6337562041"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131757/8837003bd865ae1bc23761c45307c4ca.webp"
"MediaSize" => 231831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131757/thumbnail-8837003bd865ae1bc23761c45307c4ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292848"
"ResourceRecordKey" => "29131757"
"ModificationTimestamp" => "2025-11-24T17:53:43.72Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6337562062"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131757/bbafc659fd26eb88b37c561c0fe08737.webp"
"MediaSize" => 227158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131757/thumbnail-bbafc659fd26eb88b37c561c0fe08737.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292848"
"ResourceRecordKey" => "29131757"
"ModificationTimestamp" => "2025-11-24T17:53:43.72Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6337562132"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131757/11015b8bc207d8d78d772b5a4aa29a15.webp"
"MediaSize" => 247642
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131757/thumbnail-11015b8bc207d8d78d772b5a4aa29a15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292848"
"ResourceRecordKey" => "29131757"
"ModificationTimestamp" => "2025-11-24T17:53:43.72Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6337562163"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131757/a1f979830ffb6aca71b0b195b8c63253.webp"
"MediaSize" => 102562
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131757/thumbnail-a1f979830ffb6aca71b0b195b8c63253.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292848"
"ResourceRecordKey" => "29131757"
"ModificationTimestamp" => "2025-11-24T17:53:43.72Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6337562202"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131757/3057cfd7710093afe8ab7fac38e90439.webp"
"MediaSize" => 75341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131757/thumbnail-3057cfd7710093afe8ab7fac38e90439.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292848"
"ResourceRecordKey" => "29131757"
"ModificationTimestamp" => "2025-11-24T17:53:43.72Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6337562209"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131757/e117df741e4a685d1f7c94692b60b4b4.webp"
"MediaSize" => 258827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131757/thumbnail-e117df741e4a685d1f7c94692b60b4b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292848"
"ResourceRecordKey" => "29131757"
"ModificationTimestamp" => "2025-11-24T17:53:43.72Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6337562256"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131757/1e251cb0ca141945b709b01bf2e038fb.webp"
"MediaSize" => 72973
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131757/thumbnail-1e251cb0ca141945b709b01bf2e038fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292848"
"ResourceRecordKey" => "29131757"
"ModificationTimestamp" => "2025-11-24T17:53:43.72Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6337562269"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131757/ff06bd6a63164f8f66cdafa1f5696378.webp"
"MediaSize" => 194225
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131757/thumbnail-ff06bd6a63164f8f66cdafa1f5696378.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292848"
"ResourceRecordKey" => "29131757"
"ModificationTimestamp" => "2025-11-24T17:53:43.72Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6337562314"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131757/d1d882ba43e62daffdd372c19dc1ad80.webp"
"MediaSize" => 252259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131757/thumbnail-d1d882ba43e62daffdd372c19dc1ad80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292848"
"ResourceRecordKey" => "29131757"
"ModificationTimestamp" => "2025-11-24T17:53:43.72Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6337562373"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131757/3cb494e41e8b9cd579e2bf43cd1c6219.webp"
"MediaSize" => 166246
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131757/thumbnail-3cb494e41e8b9cd579e2bf43cd1c6219.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292848"
"ResourceRecordKey" => "29131757"
"ModificationTimestamp" => "2025-11-24T17:53:43.72Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6337562401"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131757/762fe8f176fad29e866256db6eae3a27.webp"
"MediaSize" => 255642
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131757/thumbnail-762fe8f176fad29e866256db6eae3a27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292848"
"ResourceRecordKey" => "29131757"
"ModificationTimestamp" => "2025-11-24T17:53:43.72Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6337562427"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131757/0f367a0f95746028f0e14956782e3729.webp"
"MediaSize" => 253346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131757/thumbnail-0f367a0f95746028f0e14956782e3729.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292848"
"ResourceRecordKey" => "29131757"
"ModificationTimestamp" => "2025-11-24T17:53:43.72Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6337562467"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131757/ae710d0a0dfcf474650fe99b916c1bc0.webp"
"MediaSize" => 195183
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131757/thumbnail-ae710d0a0dfcf474650fe99b916c1bc0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292848"
"ResourceRecordKey" => "29131757"
"ModificationTimestamp" => "2025-11-24T17:53:43.72Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6337562488"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131757/3d3fc7b5ac0336cc31c7b2aea7405e24.webp"
"MediaSize" => 204097
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131757/thumbnail-3d3fc7b5ac0336cc31c7b2aea7405e24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292848"
"ResourceRecordKey" => "29131757"
"ModificationTimestamp" => "2025-11-24T17:53:43.72Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6337562514"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131757/d724400ebb1c299d5b304638d6fdb1e9.webp"
"MediaSize" => 258291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131757/thumbnail-d724400ebb1c299d5b304638d6fdb1e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292848"
"ResourceRecordKey" => "29131757"
"ModificationTimestamp" => "2025-11-24T17:53:43.72Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6337562530"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131757/2518a729e10762ce5e6af1d41538654c.webp"
"MediaSize" => 129906
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131757/thumbnail-2518a729e10762ce5e6af1d41538654c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1292848"
"ResourceRecordKey" => "29131757"
"ModificationTimestamp" => "2025-11-24T17:53:43.72Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6337562558"
…11
]
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]
]
+"Member": []
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29131757')"
+"ID": "440916"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25158
+post_id: "406547"
+post_author: 1
+"ListingKey": "29086015"
+"ListingId": "1292385"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-10T13:25:07Z"
+"RFModificationTimestamp": "2025-11-10T20:23:32Z"
+"ListPrice": 360000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C2M9"
+"UnparsedAddress": "12 Freshwater Road, St. John's, Newfoundland & Labrador A1C2M9"
+"Coordinates": array:2 [
0 => -52.717398
1 => 47.563822
]
+"Latitude": 47.563822
+"Longitude": -52.717398
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Location,location,location!Well maintained property in a high traffic location. Owner operated, serving great food for many years. Large dining room and large kitchen with lots of storage. Property has a living area on the second floor that could be the living space for a new owner, or possibly a potential rental. Separate entrance for the upstairs space. Mini splits keep the property cozy in the colder months and nice and cool during the summer. The property is fully equipped ready for you to make it your own. Any applicable hst. is the responsibility of the purchaser. (id:62650)"
+"BusinessType": "Restaurant"
+"CreationDate": "2025-11-10T20:23:22.131289+00:00"
+"Heating": array:3 [
0 => "Radiant heat"
1 => "Oil"
2 => "Mini-Split"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1688612"
+"ListOfficeKey": "88627"
+"PhotosChangeTimestamp": "2025-11-10T13:12:57Z"
+"PhotosCount": 7
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-11-10T13:12:57Z"
+"StreetName": "Freshwater"
+"StreetNumber": "12"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3000"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29086015/12-freshwater-road-st-johns"
+"StructureType": array:1 [
0 => "Special Purpose"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "Residential/com"
+"OriginalEntryTimestamp": "2025-11-10T13:12:57.39Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:7 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
]
+"Member": []
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29086015')"
+"ID": "406547"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25160
+post_id: "341214"
+post_author: 1
+"ListingKey": "27725884"
+"ListingId": "1280231"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-14T19:25:35Z"
+"RFModificationTimestamp": "2025-11-14T19:27:07Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 5483.0
+"BuildingAreaTotal": 0
+"City": "St.John's"
+"PostalCode": "A1E2V7"
+"UnparsedAddress": "47 Leslie Street, St.John's, Newfoundland & Labrador A1E2V7"
+"Coordinates": array:2 [
0 => -52.723593
1 => 47.549554
]
+"Latitude": 47.549554
+"Longitude": -52.723593
+"YearBuilt": 1930
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Outstanding opportunity to own a versatile 5,483 sq. ft. three-story building situated on a spacious 12,154 sq. ft. corner lot in a highly desirable west-end location. Zoned R3, this property offers excellent potential for redevelopment or conversion to a multi-unit residential building. Previously occupied by medical practices, the building features kitchenettes, washrooms, and multiple office spaces on both the main and second floors. The third floor features additional offices, a bathroom, and a large skylight that opens to the level below, providing natural light throughout. The 1,216 sq. ft. basement offers abundant storage space with convenient exterior access. Additional highlights include a 400-amp electrical service with four separate meters and on-site parking for 10 vehicles at the front of the building. A rare opportunity for investors or developers seeking a solid property with excellent versatility and strong future potential in a prime west-end location. This property is being sold "AS IS WHERE IS". (id:62650)"
+"BusinessType": "Other,Service"
+"CreationDate": "2025-10-22T13:47:50.823664+00:00"
+"Flooring": array:1 [
0 => "Mixed Flooring"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1572005"
+"ListOfficeKey": "275242"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "12,154"
+"PhotosChangeTimestamp": "2025-11-14T18:40:21Z"
+"PhotosCount": 48
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-11-14T19:14:00Z"
+"Stories": "4.0"
+"StreetName": "Leslie"
+"StreetNumber": "47"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "9926.75"
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2025
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/27725884/47-leslie-street-stjohns"
+"StructureType": array:1 [
0 => "Commercial Mix"
]
+"CoListAgentKey": "1572008"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "275242"
+"BuildingFeatures": array:1 [
0 => "Laundry Facility"
]
+"ZoningDescription": "R3"
+"OriginalEntryTimestamp": "2024-12-10T12:52:38.5Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"Member": []
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('27725884')"
+"ID": "341214"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24839
+post_id: "296490"
+post_author: 1
+"ListingKey": "28955793"
+"ListingId": "1291083"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-16T18:55:41Z"
+"RFModificationTimestamp": "2025-12-16T18:59:59Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C1A9"
+"UnparsedAddress": "202 Water Street, St. John's, Newfoundland & Labrador A1C1A9"
+"Coordinates": array:2 [
0 => -52.707178
1 => 47.564323
]
+"Latitude": 47.564323
+"Longitude": -52.707178
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Exceptional Investment on Historic Water Street in Downtown St. John’s. This is a rare opportunity to own a fully leased mixed-use property in one of the city’s most desirable locations. Situated at 202 Water Street, the building features two commercial storefronts on the main and second floors, along with a residential apartment on the third floor, offering a strong tenant mix and dependable income. Generating an annual income of approximately $67,000, this property provides both consistent cash flow and long-term value. Located along the designated Pedestrian Mall, it benefits from some of the highest foot traffic during the summer months, making it an ideal spot for retail or service-based businesses. With its classic brick façade, excellent street visibility, and prime downtown setting, this property is perfect for investors looking to expand their portfolio or buyers seeking a signature commercial space in one of St. John’s most vibrant areas. (id:62650)"
+"BusinessType": "Food Services and Beverage,Other,Retail and Wholesale,Service"
+"CreationDate": "2025-10-06T17:57:42.272884+00:00"
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2141852"
+"ListOfficeKey": "88563"
+"PhotosChangeTimestamp": "2025-10-06T16:54:01Z"
+"PhotosCount": 1
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-12-16T18:42:35Z"
+"StreetName": "Water"
+"StreetNumber": "202"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4770"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/28955793/202-water-street-st-johns"
+"StructureType": array:1 [
0 => "Retail"
]
+"CoListAgentKey": "2196213"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "88563"
+"GeocodeManualYN": true
+"ZoningDescription": "Comm"
+"OriginalEntryTimestamp": "2025-10-06T16:54:01.85Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:1 [
0 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28955793')"
+"ID": "296490"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23526
+post_id: "296491"
+post_author: 1
+"ListingKey": "28955794"
+"ListingId": "1291081"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-16T18:55:41Z"
+"RFModificationTimestamp": "2025-12-16T18:59:59Z"
+"ListPrice": 770000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C1B8"
+"UnparsedAddress": "302-304 Water Street, St. John's, Newfoundland & Labrador A1C1B8"
+"Coordinates": array:2 [
0 => -52.709954
1 => 47.562014
]
+"Latitude": 47.562014
+"Longitude": -52.709954
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Prime Mixed-Use Investment in the Heart of Downtown St. John’s. Discover 302-304 Water Street, a rare opportunity to own a versatile and income-generating property in one of the city’s most iconic and high-traffic areas. This property features two commercial units on the main level, currently occupied by Hollow Noggin Vape Shop and a restaurant, along with two residential apartments on the upper floors, offering a strong tenant mix and consistent returns. Generating an annual income of approximately $83,000, it provides both stability and long-term growth potential. With rear access to Mahon’s Lane and a direct connection to George Street, the property benefits from exceptional visibility and foot traffic year-round. Surrounded by established businesses and high-value buildings, 302-304 Water Street is an ideal investment for those looking to expand their portfolio or secure a landmark asset in one of St. John’s most desirable downtown locations. (id:62650)"
+"BusinessType": "Other,Service"
+"CreationDate": "2025-10-06T17:57:41.785273+00:00"
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2141852"
+"ListOfficeKey": "88563"
+"PhotosChangeTimestamp": "2025-10-06T16:54:02Z"
+"PhotosCount": 1
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-12-16T18:42:36Z"
+"StreetName": "Water"
+"StreetNumber": "302-304"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5830"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/28955794/302-304-water-street-st-johns"
+"StructureType": array:1 [
0 => "Other"
]
+"CoListAgentKey": "2196213"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "88563"
+"GeocodeManualYN": true
+"ZoningDescription": "CDM"
+"OriginalEntryTimestamp": "2025-10-06T16:54:01.97Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:1 [
0 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28955794')"
+"ID": "296491"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25157
+post_id: "282766"
+post_author: 1
+"ListingKey": "28949178"
+"ListingId": "1291146"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-03T19:20:40Z"
+"RFModificationTimestamp": "2025-10-03T21:21:28Z"
+"ListPrice": 349900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 2775.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C1V4"
+"UnparsedAddress": "113-117 Longs Hill, St. John's, Newfoundland & Labrador A1C1V4"
+"Coordinates": array:2 [
0 => -52.713347
1 => 47.564468
]
+"Latitude": 47.564468
+"Longitude": -52.713347
+"YearBuilt": 1955
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Discover a unique mixed-use property at the top of Long’s Hill in the heart of downtown St. John’s, offering an excellent opportunity for entrepreneurs or investors. The main floor features a commercial space currently leased as a restaurant, ideal for a variety of business ventures in a high-visibility location. Upstairs, the residential unit includes three bedrooms, one bathroom, and classic hardwood floors, providing a comfortable living space in a vibrant urban setting. The basement offers ample storage, perfect for business or personal use. With updated plumbing and mostly vinyl windows, the property ensures functionality and efficiency. Situated close to grocery stores and the lively downtown core, this property is well-positioned for convenience and accessibility, making it a compelling choice for those seeking a live-work lifestyle or a multi-unit investment in one of St. John’s most dynamic areas. For more details or to schedule a viewing, reach out today. (id:62650)"
+"BusinessType": "Other"
+"CreationDate": "2025-10-03T21:21:23.492606+00:00"
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2058349"
+"ListOfficeKey": "88555"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "20x45"
+"PhotosChangeTimestamp": "2025-10-03T19:13:20Z"
+"PhotosCount": 20
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-10-03T19:13:20Z"
+"StreetName": "Longs"
+"StreetNumber": "113-117"
+"StreetSuffix": "Hill"
+"TaxAnnualAmount": "3836"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=rVykrrdRWmR"
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/28949178/113-117-longs-hill-st-johns"
+"StructureType": array:1 [
0 => "Other"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "COM/RES MIX"
+"OriginalEntryTimestamp": "2025-10-03T19:13:20.35Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:20 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28949178')"
+"ID": "282766"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24782
+post_id: "243130"
+post_author: 1
+"ListingKey": "28912948"
+"ListingId": "1290924"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-23T13:00:24Z"
+"RFModificationTimestamp": "2025-10-23T13:02:01Z"
+"ListPrice": 335000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1650.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1E2T2"
+"UnparsedAddress": "24 Brine Street, St. John's, Newfoundland & Labrador A1E2T2"
+"Coordinates": array:2 [
0 => -52.715905
1 => 47.554442
]
+"Latitude": 47.554442
+"Longitude": -52.715905
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "This 1650 ft.² space currently is operated as a commercial Laundromat. Currently one level however this building is permitted to go up an additional three stories. Located in a perfect area on the edge of downtown close to all amenities and zoned commercial /residential mix this property offers many options. The interior building dimensions are 66ft X 25ft, by 9ft 6in ceiling height and has Propane and electric heat. It is a full concrete building with steel clad roof and a 3 phase electric power supply, and 3/4 inch water supply. This property is also connected to a large building which is also for sale (with a 5000 ft.² footprint that is currently a shell but can be developed as high as 4 floors with a basement) see MLS # 1290922 and together could be developed into multiple residential or commercial spaces. Ask the listing realtor for a prospectus that also includes the potential for additional attached dwellings. Owners are willing to rent back the space. Opportunity awaits for the smart investor. (id:62650)"
+"BusinessType": "Other"
+"CreationDate": "2025-09-25T20:06:21.149303+00:00"
+"Directions": "First left off Hamilton Ave going west."
+"Flooring": array:1 [
0 => "Concrete Slab"
]
+"Heating": array:2 [
0 => "Electric"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1572237"
+"ListOfficeKey": "88627"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "70 x 29"
+"PhotosChangeTimestamp": "2025-09-25T18:23:02Z"
+"PhotosCount": 2
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2025-10-23T12:42:50Z"
+"Stories": "1.0"
+"StreetName": "Brine"
+"StreetNumber": "24"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5095"
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2024
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/28912948/24-brine-street-st-johns"
+"StructureType": array:1 [
0 => "Commercial Mix"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "RES/COMM MIX"
+"OriginalEntryTimestamp": "2025-09-25T18:12:29.53Z"
+"MapCoordinateVerifiedYN": true
+"Media": array:2 [
0 => array:13 [ …13]
1 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28912948')"
+"ID": "243130"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 17
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]