array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29771045 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
+post_id: "1436022"
+post_author: 1
+"ListingKey": "29771045"
+"ListingId": "1297649"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T19:00:04Z"
+"RFModificationTimestamp": "2026-06-28T19:02:48Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2223.0
+"BuildingAreaTotal": 0
+"City": "St John's"
+"PostalCode": "A1C2A5"
+"UnparsedAddress": "50 Queens Road, St John's, Newfoundland & Labrador A1C2A5"
+"Coordinates": array:2 [
0 => -52.709091
1 => 47.566952
]
+"Latitude": 47.566952
+"Longitude": -52.709091
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Located in the heart of historic St. John’s, this executive Brownstone townhouse presents a rare opportunity with breathtaking harbour and city views from every level. It’s sure to impress the most discerning buyers. The gracious main floor layout is perfect for entertaining, featuring an open-concept design that leads to a private patio with a European feel—ideal for relaxing or hosting guests. On the second level, you’ll find two spacious bedrooms, including a primary suite with a walk-in closet and luxurious ensuite, as well as a conveniently located laundry area. The top-floor loft/studio space is truly special, with a wood-burning fireplace, custom built-in wet bar, and expansive front and back windows showcasing natural light and once again, those breathtaking harbour views. The fully developed basement offers a bonus guest bedroom with its own bathroom, providing additional privacy and comfort, along with ample storage space. An in-house garage plus private driveway complete this spectacular home. This is a one-of-a-kind address—a rare blend of style, location, and views that is truly extraordinary. A rare turnkey opportunity. Also included in the sale are the central vacuum system, garburator, all blinds, draperies, and hardware. This home will be sold with all contents included—just move in and enjoy. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Alarm System"
8 => "Wet Bar"
]
+"Cooling": array:1 [
0 => "Air exchanger"
]
+"CreationDate": "2026-05-19T20:07:39.477491+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Other"
]
+"FireplaceYN": true
+"Flooring": array:5 [
0 => "Hardwood"
1 => "Marble"
2 => "Carpeted"
3 => "Ceramic"
4 => "Mixed Flooring"
]
+"FoundationDetails": array:2 [
0 => "Concrete"
1 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1571911"
+"ListOfficeKey": "88553"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "20 x 60"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T15:23:53Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-28T18:53:17Z"
+"Stories": "1.0"
+"StreetName": "Queens"
+"StreetNumber": "50"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5548"
+"View": "Ocean view,View"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1670503160"
"RoomType" => "Bath (# pieces 1-6)"
"ListingId" => "1297649"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29771045"
"RoomLength" => null
"RoomDimensions" => "5 X 7"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T18:53:17.73Z"
]
1 => array:11 [
"RoomKey" => "1670503161"
"RoomType" => "Storage"
"ListingId" => "1297649"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29771045"
"RoomLength" => null
"RoomDimensions" => "8 x 5"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T18:53:17.73Z"
]
2 => array:11 [
"RoomKey" => "1670503162"
"RoomType" => "Bedroom"
"ListingId" => "1297649"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29771045"
"RoomLength" => null
"RoomDimensions" => "11 x13"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T18:53:17.74Z"
]
3 => array:11 [
"RoomKey" => "1670503163"
"RoomType" => "Hobby room"
"ListingId" => "1297649"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29771045"
"RoomLength" => null
"RoomDimensions" => "18 x 25"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T18:53:17.74Z"
]
4 => array:11 [
"RoomKey" => "1670503164"
"RoomType" => "Bedroom"
"ListingId" => "1297649"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29771045"
"RoomLength" => null
"RoomDimensions" => "12 x 9"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T18:53:17.75Z"
]
5 => array:11 [
"RoomKey" => "1670503165"
"RoomType" => "Primary Bedroom"
"ListingId" => "1297649"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29771045"
"RoomLength" => null
"RoomDimensions" => "18 x 17"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T18:53:17.77Z"
]
6 => array:11 [
"RoomKey" => "1670503166"
"RoomType" => "Living room"
"ListingId" => "1297649"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29771045"
"RoomLength" => null
"RoomDimensions" => "18x13"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T18:53:17.77Z"
]
7 => array:11 [
"RoomKey" => "1670503167"
"RoomType" => "Dining room"
"ListingId" => "1297649"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29771045"
"RoomLength" => null
"RoomDimensions" => "12 x 18"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T18:53:17.78Z"
]
8 => array:11 [
"RoomKey" => "1670503168"
"RoomType" => "Eat in kitchen"
"ListingId" => "1297649"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29771045"
"RoomLength" => null
"RoomDimensions" => "18 X13"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T18:53:17.79Z"
]
]
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2026
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29771045/50-queens-road-st-johns"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2163655"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "88553"
+"GeocodeManualYN": true
+"ZoningDescription": "Res"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-05-19T18:13:45.81Z"
+"ListAgentNationalAssociationId": "1033727"
+"ListOfficeNationalAssociationId": "1007292"
+"CoListAgentNationalAssociationId": "1414587"
+"CoListOfficeNationalAssociationId": "1007292"
+"Media": array:45 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29771045_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/33d42951360dd282ef50286aadc891db.webp"
"MediaSize" => 343934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-33d42951360dd282ef50286aadc891db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:23.62Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29771045_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/78cd42b85436e0d66f5549644cae9c89.webp"
"MediaSize" => 297123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-78cd42b85436e0d66f5549644cae9c89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:27.44Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29771045_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/fe7e53cce9df587b11c34cd1b6419ddc.webp"
"MediaSize" => 295881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-fe7e53cce9df587b11c34cd1b6419ddc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-05-19T18:13:45.83Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29771045_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/adc814020af10e46fdaab66a1e462365.webp"
"MediaSize" => 191595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-adc814020af10e46fdaab66a1e462365.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:33.67Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29771045_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/5951b17a710c048eaa5b46ba71c060c5.webp"
"MediaSize" => 399596
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-5951b17a710c048eaa5b46ba71c060c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:37.3Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29771045_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/881053078c6431216d52111a1cdce856.webp"
"MediaSize" => 378545
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-881053078c6431216d52111a1cdce856.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:32.16Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29771045_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/c19e892a84d4e39c89ff7ee1c73801bd.webp"
"MediaSize" => 314612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-c19e892a84d4e39c89ff7ee1c73801bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:38.36Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29771045_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/f2577d75e635ce06f60cf56a587eabb8.webp"
"MediaSize" => 281929
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-f2577d75e635ce06f60cf56a587eabb8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:35.01Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29771045_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/23cb2c035ad47e815090723df582754a.webp"
"MediaSize" => 80323
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-23cb2c035ad47e815090723df582754a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:35.26Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29771045_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/5683b7bcafe37d27255d96bd1dd175e7.webp"
"MediaSize" => 125435
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-5683b7bcafe37d27255d96bd1dd175e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:24.23Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29771045_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/75a4f54cdbe57e6d46e3d2b3ae7e7c77.webp"
"MediaSize" => 279231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-75a4f54cdbe57e6d46e3d2b3ae7e7c77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:23.89Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29771045_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/9dd99aa9b79d7daae2d460ee71109f13.webp"
"MediaSize" => 279231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-9dd99aa9b79d7daae2d460ee71109f13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-05-19T18:13:45.83Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29771045_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/9b3e8e58b6efb8bb7c68144ead7e9af4.webp"
"MediaSize" => 313639
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-9b3e8e58b6efb8bb7c68144ead7e9af4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:24.42Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29771045_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/d6316a5201c6e770b1150de26d1ffd6b.webp"
"MediaSize" => 300088
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-d6316a5201c6e770b1150de26d1ffd6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:25.62Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29771045_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/e8ec542d0888022b54d9d33aaa9942b6.webp"
"MediaSize" => 214053
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-e8ec542d0888022b54d9d33aaa9942b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:25.98Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29771045_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/1d8b8d88266f2a914d490a5ac8a78d36.webp"
"MediaSize" => 223838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-1d8b8d88266f2a914d490a5ac8a78d36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:25.64Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29771045_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/a4553c24e25f228d4add3e95ac93a195.webp"
"MediaSize" => 286495
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-a4553c24e25f228d4add3e95ac93a195.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:29.93Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29771045_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/4649b26527d4b9a8472a19b65302f5b5.webp"
"MediaSize" => 175988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-4649b26527d4b9a8472a19b65302f5b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:27.07Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29771045_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/2781db16bebfb35b0a07368be08dd12a.webp"
"MediaSize" => 246157
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-2781db16bebfb35b0a07368be08dd12a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:31.63Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29771045_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/30d0cdd80d1d5b3a180651b1163ebdc2.webp"
"MediaSize" => 248703
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-30d0cdd80d1d5b3a180651b1163ebdc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:32.12Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29771045_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/530176065c3821abe52222f9d13170dc.webp"
"MediaSize" => 210503
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-530176065c3821abe52222f9d13170dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:28.12Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29771045_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/5fb9d8fe42dca541e4bea75a6f8f1c37.webp"
"MediaSize" => 252344
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-5fb9d8fe42dca541e4bea75a6f8f1c37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:34.52Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29771045_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/901dfd2d4743f013efb4a97169f25ef8.webp"
"MediaSize" => 220653
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-901dfd2d4743f013efb4a97169f25ef8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:27.41Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29771045_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/7f80035c2dac3a4942d70907b072641e.webp"
"MediaSize" => 251861
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-7f80035c2dac3a4942d70907b072641e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:31.61Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29771045_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/537faf6d6a3a7ed301127335ba9f0eff.webp"
"MediaSize" => 268605
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-537faf6d6a3a7ed301127335ba9f0eff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:27.49Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29771045_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/620ea16d33a196d34a7bb39730bc55a2.webp"
"MediaSize" => 129811
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-620ea16d33a196d34a7bb39730bc55a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:32.96Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29771045_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/e04ace5bd7b361d31b0550680c8f009e.webp"
"MediaSize" => 225858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-e04ace5bd7b361d31b0550680c8f009e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:28.75Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29771045_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/618b5f0ca365a97ff3b5a8a3e5bd2bda.webp"
"MediaSize" => 228280
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-618b5f0ca365a97ff3b5a8a3e5bd2bda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:34.57Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29771045_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/6a5f408dbbf2cb470bda38fb2c8580f1.webp"
"MediaSize" => 215514
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-6a5f408dbbf2cb470bda38fb2c8580f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:25.84Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29771045_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/37c52c5b8de535b4e216ad7414014f52.webp"
"MediaSize" => 189907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-37c52c5b8de535b4e216ad7414014f52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:29.41Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29771045_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/a835dfc52e864513124faf8ce77a1c44.webp"
"MediaSize" => 399596
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-a835dfc52e864513124faf8ce77a1c44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:29.4Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29771045_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/37b8577818f7a472b597a06df371f6aa.webp"
"MediaSize" => 378545
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-37b8577818f7a472b597a06df371f6aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:35.07Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29771045_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/aca393f730a38568895e3fee2dffacb2.webp"
"MediaSize" => 194533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-aca393f730a38568895e3fee2dffacb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:28.95Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29771045_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/d916a83705cdba3803af57b46ab8dea8.webp"
"MediaSize" => 63353
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-d916a83705cdba3803af57b46ab8dea8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:47.61Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29771045_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/dfda0e118a1a69ae96a89c9b34fb017d.webp"
"MediaSize" => 163573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-dfda0e118a1a69ae96a89c9b34fb017d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:28.96Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29771045_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/9c76f7b68371aae7ba56b6f35ee29596.webp"
"MediaSize" => 108022
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-9c76f7b68371aae7ba56b6f35ee29596.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:33.84Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29771045_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/ba0b4ddbd3e3cd9fd39ce1859c1c94ae.webp"
"MediaSize" => 140006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-ba0b4ddbd3e3cd9fd39ce1859c1c94ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:28.98Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29771045_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/5352e3987f1551f3ca9fa79eaaed5145.webp"
"MediaSize" => 172578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-5352e3987f1551f3ca9fa79eaaed5145.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:34.68Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29771045_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/e61709b3c44d32916e89588d0c955f85.webp"
"MediaSize" => 189777
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-e61709b3c44d32916e89588d0c955f85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:29.1Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29771045_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/a4274dbfede0ad63f27ef0d23ebf7b91.webp"
"MediaSize" => 229241
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-a4274dbfede0ad63f27ef0d23ebf7b91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:29.28Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29771045_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/24b540ddb5cc38de0958f50e684daaac.webp"
"MediaSize" => 223838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-24b540ddb5cc38de0958f50e684daaac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:34.63Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29771045_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/4228e5f277f420d10d2613d6943c89d3.webp"
"MediaSize" => 219807
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-4228e5f277f420d10d2613d6943c89d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:30.02Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29771045_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/aeeddebbfac7ac7079a9dec97387cc88.webp"
"MediaSize" => 249740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-aeeddebbfac7ac7079a9dec97387cc88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:35.28Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29771045_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/d4ef6c87f6e5175ff2d92b01b0ce0628.webp"
"MediaSize" => 136045
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-d4ef6c87f6e5175ff2d92b01b0ce0628.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:31.02Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29771045_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29771045/7cd8d00853c6d05d8b3dc3197647220e.webp"
"MediaSize" => 95586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29771045/thumbnail-7cd8d00853c6d05d8b3dc3197647220e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1297649"
"ResourceRecordKey" => "29771045"
"ModificationTimestamp" => "2026-06-24T15:20:31.32Z"
]
]
+"DaysOnMarket": 45
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29771045')"
+"ID": "1436022"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.76 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 88553" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24912
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1571911" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24870
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29771045'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25272
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29771045'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25379
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25380
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31310852"
+"ListingKey": "29771045"
+"ListingId": "1297649"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-07"
+"OpenHouseStartTime": "2026-06-07T14:00:00Z"
+"OpenHouseEndTime": "2026-06-07T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-07T14:20:07Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31310852')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25382
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31629248"
+"ListingKey": "29771045"
+"ListingId": "1297649"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-28"
+"OpenHouseStartTime": "2026-06-28T14:00:00Z"
+"OpenHouseEndTime": "2026-06-28T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-28T15:20:15Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31629248')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29771045' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-52.709091 47.566952)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25310
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25304
+post_id: "1592033"
+post_author: 1
+"ListingKey": "29986540"
+"ListingId": "1299837"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T19:10:05Z"
+"RFModificationTimestamp": "2026-07-04T00:06:39Z"
+"ListPrice": 1249000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 4826.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C2Z1"
+"UnparsedAddress": "54 Circular Road, St. John's, Newfoundland & Labrador A1C2Z1"
+"Coordinates": array:2 [
0 => -52.710063
1 => 47.572958
]
+"Latitude": 47.572958
+"Longitude": -52.710063
+"YearBuilt": 1849
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Welcome to 54 Circular Road, the iconic Bannerman House, a rare opportunity to own a piece of St. John’s history dating back to 1849. Set on a prominent corner lot along one of the city’s most picturesque streets, directly across from Bannerman Park, this remarkable property is surrounded by heritage homes, mature trees, and the quiet charm of downtown living. From the front and side of the home, you’ll often catch the timeless sight of RNC officers riding on horseback as they pass by, adding to the character and rhythm of this historic neighbourhood. Rich in detail, the home retains many of its original architectural features, offering a sense of craftsmanship and permanence seldom found today. Entering through the porch, the space opens into a generous dining room and eat-in kitchen, with both a living room and family room providing inviting settings for gathering and everyday living. The second level features a well-proportioned primary bedroom with walk-in closet and ensuite, along with additional rooms suited for rest or study, while the third-floor attic offers a private retreat with its own bedroom, bathroom, and living area. Adding to its appeal, the property includes two attached one-bedroom units, creating a rare opportunity for rental income while preserving the integrity of the main home. With Bannerman Park, cafés, restaurants, and all downtown amenities just steps away, this location offers a lifestyle that is both vibrant and enduring. Properties like this, where history and opportunity meet so naturally, are seldom offered. (id:62650)"
+"Appliances": array:1 [
0 => "Dishwasher"
]
+"BathroomsPartial": 1
+"CreationDate": "2026-07-03T23:51:14.596544+00:00"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Flooring": array:1 [
0 => "Other"
]
+"Heating": array:1 [
0 => "Hot water radiator heat"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2141852"
+"ListOfficeKey": "88563"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "61X248X157"
+"PhotosChangeTimestamp": "2026-07-03T19:02:19Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-07-03T19:02:19Z"
+"StreetName": "Circular"
+"StreetNumber": "54"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6076"
+"VirtualTourURLUnbranded": "https://www.dropbox.com/scl/fo/i48n5ntaba2bp9frb1p3f/ABYzER83D2DFVNXk8UV3mEg/360 Tour - 54 Circular Road.web?rlkey=1yfbrzd8rzxjx2g3u2oa7llyz&st=s8lshstf&dl=0"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [
"RoomKey" => "1674334003"
"RoomType" => "Other"
"ListingId" => "1299837"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29986540"
"RoomLength" => null
"RoomDimensions" => "18.1 x 28.9"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:02:19.11Z"
]
1 => array:11 [
"RoomKey" => "1674334004"
"RoomType" => "Bath (# pieces 1-6)"
"ListingId" => "1299837"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29986540"
"RoomLength" => null
"RoomDimensions" => "15.10 x 9.6"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:02:19.11Z"
]
2 => array:11 [
"RoomKey" => "1674334005"
"RoomType" => "Bedroom"
"ListingId" => "1299837"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29986540"
"RoomLength" => null
"RoomDimensions" => "15.10 x 12.11"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:02:19.11Z"
]
3 => array:11 [
"RoomKey" => "1674334006"
"RoomType" => "Bath (# pieces 1-6)"
"ListingId" => "1299837"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986540"
"RoomLength" => null
"RoomDimensions" => "4.7 x 6.8"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:02:19.12Z"
]
4 => array:11 [
"RoomKey" => "1674334007"
"RoomType" => "Bedroom"
"ListingId" => "1299837"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986540"
"RoomLength" => null
"RoomDimensions" => "12.11 x 16.4"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:02:19.12Z"
]
5 => array:11 [
"RoomKey" => "1674334008"
"RoomType" => "Bedroom"
"ListingId" => "1299837"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986540"
"RoomLength" => null
"RoomDimensions" => "18.1 x 18.1"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:02:19.12Z"
]
6 => array:11 [
"RoomKey" => "1674334009"
"RoomType" => "Ensuite"
"ListingId" => "1299837"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986540"
"RoomLength" => null
"RoomDimensions" => "13.2 x 10.1"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:02:19.12Z"
]
7 => array:11 [
"RoomKey" => "1674334010"
"RoomType" => "Primary Bedroom"
"ListingId" => "1299837"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986540"
"RoomLength" => null
"RoomDimensions" => "20.3 x 15.7"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:02:19.12Z"
]
8 => array:11 [
"RoomKey" => "1674334011"
"RoomType" => "Not known"
"ListingId" => "1299837"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986540"
"RoomLength" => null
"RoomDimensions" => "11.1 x 12.9"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:02:19.12Z"
]
9 => array:11 [
"RoomKey" => "1674334012"
"RoomType" => "Bath (# pieces 1-6)"
"ListingId" => "1299837"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986540"
"RoomLength" => null
"RoomDimensions" => "11.1 x 4.4"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:02:19.13Z"
]
10 => array:11 [
"RoomKey" => "1674334013"
"RoomType" => "Not known"
"ListingId" => "1299837"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986540"
"RoomLength" => null
"RoomDimensions" => "14.1 x 17.6"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:02:19.14Z"
]
11 => array:11 [
"RoomKey" => "1674334014"
"RoomType" => "Not known"
"ListingId" => "1299837"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986540"
"RoomLength" => null
"RoomDimensions" => "4.2 x 10.5"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:02:19.14Z"
]
12 => array:11 [
"RoomKey" => "1674334015"
"RoomType" => "Bath (# pieces 1-6)"
"ListingId" => "1299837"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986540"
"RoomLength" => null
"RoomDimensions" => "7.10 x 3.9"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:02:19.15Z"
]
13 => array:11 [
"RoomKey" => "1674334016"
"RoomType" => "Not known"
"ListingId" => "1299837"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986540"
"RoomLength" => null
"RoomDimensions" => "9.9 x 8.11"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:02:19.16Z"
]
14 => array:11 [
"RoomKey" => "1674334017"
"RoomType" => "Family room"
"ListingId" => "1299837"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986540"
"RoomLength" => null
"RoomDimensions" => "13.6 x 16.4"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:02:19.17Z"
]
15 => array:11 [
"RoomKey" => "1674334018"
"RoomType" => "Living room"
"ListingId" => "1299837"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986540"
"RoomLength" => null
"RoomDimensions" => "18.6 x 17.3"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:02:19.17Z"
]
16 => array:11 [
"RoomKey" => "1674334019"
"RoomType" => "Eat in kitchen"
"ListingId" => "1299837"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986540"
"RoomLength" => null
"RoomDimensions" => "18.4 x 18.1"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:02:19.19Z"
]
17 => array:11 [
"RoomKey" => "1674334020"
"RoomType" => "Dining room"
"ListingId" => "1299837"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986540"
"RoomLength" => null
"RoomDimensions" => "18.2 x 18.1"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:02:19.2Z"
]
]
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2026
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29986540/54-circular-road-st-johns"
+"StructureType": array:1 [
0 => "Two Apartment House"
]
+"CoListAgentKey": "1987537"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "88563"
+"GeocodeManualYN": true
+"ZoningDescription": "RES"
+"OriginalEntryTimestamp": "2026-07-03T19:02:19.04Z"
+"ListAgentNationalAssociationId": "1393507"
+"ListOfficeNationalAssociationId": "1260564"
+"CoListAgentNationalAssociationId": "1271779"
+"CoListOfficeNationalAssociationId": "1260564"
+"Media": array:29 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29986540_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986540/438fdcfb6f4743a923f2e96c3f94b90a.webp"
"MediaSize" => 318397
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986540/thumbnail-438fdcfb6f4743a923f2e96c3f94b90a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1299837"
"ResourceRecordKey" => "29986540"
"ModificationTimestamp" => "2026-07-03T19:02:19.06Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29986540_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986540/e851153e37538f737409cdcc64a067df.webp"
"MediaSize" => 344831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986540/thumbnail-e851153e37538f737409cdcc64a067df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299837"
"ResourceRecordKey" => "29986540"
"ModificationTimestamp" => "2026-07-03T19:02:19.06Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29986540_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986540/d3eecbee1b8f18f3f825a4fa09b5954b.webp"
"MediaSize" => 362827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986540/thumbnail-d3eecbee1b8f18f3f825a4fa09b5954b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299837"
"ResourceRecordKey" => "29986540"
"ModificationTimestamp" => "2026-07-03T19:02:19.06Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29986540_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986540/df7a5b60bd951c1fc76e8ffac95b1b85.webp"
"MediaSize" => 438801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986540/thumbnail-df7a5b60bd951c1fc76e8ffac95b1b85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299837"
"ResourceRecordKey" => "29986540"
"ModificationTimestamp" => "2026-07-03T19:02:19.06Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29986540_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986540/8ec82a21ba2a0f9c368e42611c89f918.webp"
"MediaSize" => 465767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986540/thumbnail-8ec82a21ba2a0f9c368e42611c89f918.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299837"
"ResourceRecordKey" => "29986540"
"ModificationTimestamp" => "2026-07-03T19:02:19.06Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29986540_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986540/fe3d71b3504b973d19393e935a25c636.webp"
"MediaSize" => 206858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986540/thumbnail-fe3d71b3504b973d19393e935a25c636.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299837"
"ResourceRecordKey" => "29986540"
"ModificationTimestamp" => "2026-07-03T19:02:19.06Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29986540_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986540/c5001e46f81daa6e6e4d01825722d410.webp"
"MediaSize" => 250744
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986540/thumbnail-c5001e46f81daa6e6e4d01825722d410.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299837"
"ResourceRecordKey" => "29986540"
"ModificationTimestamp" => "2026-07-03T19:02:19.06Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29986540_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986540/fbff3c2046511c68523adf9dbdbdf0d1.webp"
"MediaSize" => 151292
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986540/thumbnail-fbff3c2046511c68523adf9dbdbdf0d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299837"
"ResourceRecordKey" => "29986540"
"ModificationTimestamp" => "2026-07-03T19:02:19.06Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29986540_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986540/0de8ff79c45096e561886c808ddf3949.webp"
"MediaSize" => 257078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986540/thumbnail-0de8ff79c45096e561886c808ddf3949.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299837"
"ResourceRecordKey" => "29986540"
"ModificationTimestamp" => "2026-07-03T19:02:19.06Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29986540_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986540/ca1b9ddc5aee6bd634d0f3d1950f1ee8.webp"
"MediaSize" => 202957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986540/thumbnail-ca1b9ddc5aee6bd634d0f3d1950f1ee8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299837"
"ResourceRecordKey" => "29986540"
"ModificationTimestamp" => "2026-07-03T19:02:19.06Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29986540_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986540/f50c1cf379bbd61e3937ac18d5789f06.webp"
"MediaSize" => 298589
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986540/thumbnail-f50c1cf379bbd61e3937ac18d5789f06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299837"
"ResourceRecordKey" => "29986540"
"ModificationTimestamp" => "2026-07-03T19:02:19.06Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29986540_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986540/1991bd5fee957407af9b8ca4564c7735.webp"
"MediaSize" => 197401
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986540/thumbnail-1991bd5fee957407af9b8ca4564c7735.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299837"
"ResourceRecordKey" => "29986540"
"ModificationTimestamp" => "2026-07-03T19:02:19.06Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29986540_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986540/a0f9925fd910761a6a5aa01fe61f89f6.webp"
"MediaSize" => 242673
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986540/thumbnail-a0f9925fd910761a6a5aa01fe61f89f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299837"
"ResourceRecordKey" => "29986540"
"ModificationTimestamp" => "2026-07-03T19:02:19.06Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29986540_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986540/ab0805686a6ad89c245c7e1c39f8621c.webp"
"MediaSize" => 230264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986540/thumbnail-ab0805686a6ad89c245c7e1c39f8621c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299837"
"ResourceRecordKey" => "29986540"
"ModificationTimestamp" => "2026-07-03T19:02:19.06Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29986540_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986540/34909a0146ba7245b7f127206d42470a.webp"
"MediaSize" => 174464
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986540/thumbnail-34909a0146ba7245b7f127206d42470a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299837"
"ResourceRecordKey" => "29986540"
"ModificationTimestamp" => "2026-07-03T19:02:19.06Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29986540_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986540/dd315244ac903db20ff167201a0109ea.webp"
"MediaSize" => 213399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986540/thumbnail-dd315244ac903db20ff167201a0109ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299837"
"ResourceRecordKey" => "29986540"
"ModificationTimestamp" => "2026-07-03T19:02:19.06Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29986540_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986540/a122a2c1224a0ffc9ee9880338299fb3.webp"
"MediaSize" => 91399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986540/thumbnail-a122a2c1224a0ffc9ee9880338299fb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299837"
"ResourceRecordKey" => "29986540"
"ModificationTimestamp" => "2026-07-03T19:02:19.06Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29986540_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986540/1a66b506b391e9d0897e5b8e6211dfe5.webp"
"MediaSize" => 312814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986540/thumbnail-1a66b506b391e9d0897e5b8e6211dfe5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299837"
"ResourceRecordKey" => "29986540"
"ModificationTimestamp" => "2026-07-03T19:02:19.06Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29986540_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986540/6306b03902960723c3a6f4ad62a96f13.webp"
"MediaSize" => 158635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986540/thumbnail-6306b03902960723c3a6f4ad62a96f13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1299837"
"ResourceRecordKey" => "29986540"
"ModificationTimestamp" => "2026-07-03T19:02:19.06Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29986540_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986540/950514d4ae3c9752e5f6472d8e8b75ad.webp"
"MediaSize" => 207135
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986540/thumbnail-950514d4ae3c9752e5f6472d8e8b75ad.webp"
…7
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986540')"
+"ID": "1592033"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25306
+post_id: "1590353"
+post_author: 1
+"ListingKey": "29983438"
+"ListingId": "1299771"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T12:00:04Z"
+"RFModificationTimestamp": "2026-07-03T19:55:20Z"
+"ListPrice": 429000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1605.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C1S3"
+"UnparsedAddress": "8 Bond Street, St. John's, Newfoundland & Labrador A1C1S3"
+"Coordinates": array:2 [
0 => -52.704112
1 => 47.570209
]
+"Latitude": 47.570209
+"Longitude": -52.704112
+"YearBuilt": 2008
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Experience the perfect blend of historic charm and modern comfort in this beautifully renovated 4+1 bedroom, 2-bathroom home located in the heart of downtown St. John's. Fully rebuilt from the studs a decade ago, this property has continued to be updated with new flooring, fresh paint, a contemporary kitchen, new electric fireplace, and a stylish new bathroom. The open-concept kitchen, living, and dining area is ideal for both entertaining and everyday living. This home offers flexibility as a family residence, Airbnb, or income property in one of the city's most walkable neighbourhoods. Enjoy a private deck/patio and fully fenced yard — a rare downtown bonus — plus ensuite bath, dishwasher, microwave, stove, washer, and dryer. With shopping, tourist attractions, and vibrant city life just steps away, this is your chance to live in the center of it all. Book your viewing today! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
]
+"CreationDate": "2026-07-03T19:55:17.860090+00:00"
+"ExteriorFeatures": array:1 [
0 => "Other"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Laminate"
1 => "Marble"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2058349"
+"ListOfficeKey": "88555"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "17 x 57"
+"PhotosChangeTimestamp": "2026-07-03T11:52:14Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-07-03T11:52:14Z"
+"Stories": "1.0"
+"StreetName": "Bond"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2513"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=mBKFAdCHhCv"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29983438/8-bond-street-st-johns"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RES"
+"OriginalEntryTimestamp": "2026-07-03T11:52:14.07Z"
+"ListAgentNationalAssociationId": "1333492"
+"ListOfficeNationalAssociationId": "1007294"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983438')"
+"ID": "1590353"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25303
+post_id: "1590382"
+post_author: 1
+"ListingKey": "29983479"
+"ListingId": "1299742"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T12:20:08Z"
+"RFModificationTimestamp": "2026-07-03T19:49:37Z"
+"ListPrice": 329900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1492.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C4A8"
+"UnparsedAddress": "2 Allan Square, St. John's, Newfoundland & Labrador A1C4A8"
+"Coordinates": array:2 [
0 => -52.710538
1 => 47.56416
]
+"Latitude": 47.56416
+"Longitude": -52.710538
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Semi detached three storey downtown property that has been completely renovated from top to bottom ~7 years ago and is within walking distance to all downtown amenities. This 3 bed, 2 bath home is ideal for first time home buyers or any professional looking to live in a modernized, move-in-ready downtown property. The main floor is open concept with original exposed brick, laminate flooring throughout, a hardwood kitchen with a peninsula for seating, an eating area, a front living room and rear access to the back patio. The second floor has 2 good sized bedrooms with laminate flooring and a 3pc main bathroom featuring ceramic tile and a custom tiled shower. The 3rd floor is a large open loft style space for the primary bedroom. It includes an incredible 4pc ensuite with a soaker tub and corner shower, stackable laundry on this level and ample space for a home office, sitting area or fitness space. The basement is dry, insulated and heated, making it ideal for storage. The exterior features maintenance-free vinyl siding and vinyl windows. The back patio is ideal for entertaining and is also accessible from the side of the house. No offers will be conveyed until Thursday July 9th at 5pm, as per the seller's direction. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"Cooling": array:1 [
0 => "Air exchanger"
]
+"CreationDate": "2026-07-03T19:49:29.866984+00:00"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Flooring": array:3 [
0 => "Laminate"
1 => "Marble"
2 => "Ceramic"
]
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1964811"
+"ListOfficeKey": "88542"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "16.8x32.5x14.7x33.1"
+"PhotosChangeTimestamp": "2026-07-03T12:10:36Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-07-03T12:10:36Z"
+"Stories": "3.0"
+"StreetName": "Allan"
+"StreetNumber": "2"
+"StreetSuffix": "Square"
+"TaxAnnualAmount": "2363"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2026
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29983479/2-allan-square-st-johns"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "Res"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-07-03T12:01:32.33Z"
+"ListAgentNationalAssociationId": "1253371"
+"ListOfficeNationalAssociationId": "1007277"
+"Media": array:26 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983479')"
+"ID": "1590382"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25307
+post_id: "1590598"
+post_author: 1
+"ListingKey": "29986420"
+"ListingId": "1299838"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T19:00:05Z"
+"RFModificationTimestamp": "2026-07-03T19:36:55Z"
+"ListPrice": 1249000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 4826.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C2Z1"
+"UnparsedAddress": "54 Circular Road, St. John's, Newfoundland & Labrador A1C2Z1"
+"Coordinates": array:2 [
0 => -52.710029
1 => 47.572952
]
+"Latitude": 47.572952
+"Longitude": -52.710029
+"YearBuilt": 1849
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Welcome to 54 Circular Road, the iconic Bannerman House, a rare opportunity to own a piece of St. John’s history dating back to 1849. Set on a prominent corner lot along one of the city’s most picturesque streets, directly across from Bannerman Park, this remarkable property is surrounded by heritage homes, mature trees, and the quiet charm of downtown living. From the front and side of the home, you’ll often catch the timeless sight of RNC officers riding on horseback as they pass by, adding to the character and rhythm of this historic neighbourhood. Rich in detail, the home retains many of its original architectural features, offering a sense of craftsmanship and permanence seldom found today. Entering through the porch, the space opens into a generous dining room and eat-in kitchen, with both a living room and family room providing inviting settings for gathering and everyday living. The second level features a well-proportioned primary bedroom with walk-in closet and ensuite, along with additional rooms suited for rest or study, while the third-floor attic offers a private retreat with its own bedroom, bathroom, and living area. Adding to its appeal, the property includes two attached one-bedroom units, creating a rare opportunity for rental income while preserving the integrity of the main home. With Bannerman Park, cafés, restaurants, and all downtown amenities just steps away, this location offers a lifestyle that is both vibrant and enduring. Properties like this, where history and opportunity meet so naturally, are seldom offered. (id:62650)"
+"Appliances": array:1 [
0 => "Dishwasher"
]
+"BathroomsPartial": 1
+"CreationDate": "2026-07-03T19:35:28.647175+00:00"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Flooring": array:1 [
0 => "Other"
]
+"Heating": array:1 [
0 => "Hot water radiator heat"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2141852"
+"ListOfficeKey": "88563"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "61X248X157"
+"PhotosChangeTimestamp": "2026-07-03T18:52:50Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-07-03T18:52:50Z"
+"Stories": "1.0"
+"StreetName": "Circular"
+"StreetNumber": "54"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6076"
+"VirtualTourURLUnbranded": "https://www.dropbox.com/scl/fo/i48n5ntaba2bp9frb1p3f/ABYzER83D2DFVNXk8UV3mEg/360 Tour - 54 Circular Road.web?rlkey=1yfbrzd8rzxjx2g3u2oa7llyz&st=s8lshstf&dl=0"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29986420/54-circular-road-st-johns"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1987537"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "88563"
+"GeocodeManualYN": true
+"ZoningDescription": "RES"
+"OriginalEntryTimestamp": "2026-07-03T18:52:50.21Z"
+"ListAgentNationalAssociationId": "1393507"
+"ListOfficeNationalAssociationId": "1260564"
+"CoListAgentNationalAssociationId": "1271779"
+"CoListOfficeNationalAssociationId": "1260564"
+"Media": array:29 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986420')"
+"ID": "1590598"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25305
+post_id: "1589379"
+post_author: 1
+"ListingKey": "29984564"
+"ListingId": "1299731"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T15:30:04Z"
+"RFModificationTimestamp": "2026-07-03T17:07:22Z"
+"ListPrice": 309900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1568.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1B1B2"
+"UnparsedAddress": "240 Freshwater Road, St. John's, Newfoundland & Labrador A1B1B2"
+"Coordinates": array:2 [
0 => -52.73488
1 => 47.563265
]
+"Latitude": 47.563265
+"Longitude": -52.73488
+"YearBuilt": 1955
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Whether you're searching for an affordable family home or a smart investment property in one of St. John's most desirable rental locations, 240 Freshwater Road is a must-see. Ideally situated directly across from the Farmers' Market and within walking distance of Memorial University, the Health Sciences Centre, Avalon Mall, grocery stores, restaurants, and numerous amenities, this property also offers convenient access to public transit right at your doorstep. The main level features a bright and functional layout with a spacious open concept living-dining-kitchen, full bathroom, and bedroom with an additional two bedrooms on the upper level. Hardwood flooring runs throughout much of the home, adding warmth and character. The lower-level in-law suite includes its own kitchen area, bedroom, bathroom, and living space, providing excellent potential for rental income, multigenerational living, or additional flexibility for homeowners. Recent improvements include a mini-split heat pump installed in 2026 for efficient heating and cooling, a beautifully remodeled main floor bathroom featuring a new tub and vanity (2025), and roof shingles replaced in 2024. Most windows have already been upgraded to vinyl, and there is also the option to install a wood stove for an additional heat source. Outside, you'll find a large fully fenced backyard complete with a storage shed, offering plenty of space for children, pets, gardening, or entertaining. The lot also provides the opportunity to create drive-in access to the backyard, adding even more versatility for future use. Cute, functional, affordable, and packed with potential, this detached 4-bedroom, 2-bathroom home offers an exceptional opportunity for homeowners and investors alike in a highly sought-after location. As per the Sellers Directive offers will not be presented until after 12:00pm on Tues July 7th with replies given by 5pm that same day. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"CreationDate": "2026-07-03T17:07:14.630470+00:00"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Other"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Mini-Split"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1883087"
+"ListOfficeKey": "88627"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "51 x 100 x 45 x 100"
+"PhotosChangeTimestamp": "2026-07-03T15:21:52Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-07-03T15:21:52Z"
+"Stories": "1.5"
+"StreetName": "Freshwater"
+"StreetNumber": "240"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "2098"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=tLUHcQoJmiu"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2026
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29984564/240-freshwater-road-st-johns"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2252013"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "88627"
+"GeocodeManualYN": true
+"ZoningDescription": "Res"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-07-03T15:21:52.34Z"
+"ListAgentNationalAssociationId": "1207653"
+"ListOfficeNationalAssociationId": "1007257"
+"CoListAgentNationalAssociationId": "1490978"
+"CoListOfficeNationalAssociationId": "1007257"
+"Media": array:45 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29984564')"
+"ID": "1589379"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25300
+post_id: "1585797"
+post_author: 1
+"ListingKey": "29980413"
+"ListingId": "1299795"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T19:00:15Z"
+"RFModificationTimestamp": "2026-07-02T19:54:07Z"
+"ListPrice": 359900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1195.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C2H2"
+"UnparsedAddress": "130 Lemarchant Road Unit#407, St. John's, Newfoundland & Labrador A1C2H2"
+"Coordinates": array:2 [
0 => -52.719541
1 => 47.559097
]
+"Latitude": 47.559097
+"Longitude": -52.719541
+"YearBuilt": 1996
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Beautifully maintained condo, freshly painted throughout and ideally situated in a central location close to the downtown core, bus routes, schools, and walking trails. Featuring 9-foot ceilings, the bright open-concept layout offers a welcoming living room with access to a private 12x12 covered balcony, seamlessly flowing into the dining area and kitchen—perfect for everyday living and entertaining. The unit includes two well-proportioned bedrooms, including a primary suite complete with a heated-floor ensuite, along with a main 4-piece bathroom also featuring in-floor heating. Efficient mini-split systems provide year-round comfort with both heating and cooling. Additional highlights include a convenient in-unit soundproofed laundry area and bonus storage space in the basement. The monthly condo fee covers general common area maintenance, as well as garbage and snow removal, offering added ease of living. A pleasure to view—this one won’t last long! No conveyence of offers until Wednesday, July 8 @ 2:00pm and left open for acceptance until 5:00pm the same day (id:62650)"
+"AssociationFee": "453"
+"AssociationFeeFrequency": "Monthly"
+"CreationDate": "2026-07-02T19:54:01.263388+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Mixed Flooring"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
3 => "Mini-Split"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1881592"
+"ListOfficeKey": "293977"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "N/A - Condo"
+"PhotosChangeTimestamp": "2026-07-02T18:53:05Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-07-02T18:53:05Z"
+"StreetName": "Lemarchant"
+"StreetNumber": "130"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3154"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29980413/130-lemarchant-road-unit407-st-johns"
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "Res."
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-07-02T18:53:05.23Z"
+"ListAgentNationalAssociationId": "1206842"
+"ListOfficeNationalAssociationId": "1433917"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29980413')"
+"ID": "1585797"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1585513"
+post_author: 1
+"ListingKey": "29980504"
+"ListingId": "1299776"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T19:10:08Z"
+"RFModificationTimestamp": "2026-07-02T19:43:07Z"
+"ListPrice": 299900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1782.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C4L2"
+"UnparsedAddress": "45 Franklyn Avenue, St. John's, Newfoundland & Labrador A1C4L2"
+"Coordinates": array:2 [
0 => -52.718882
1 => 47.561754
]
+"Latitude": 47.561754
+"Longitude": -52.718882
+"YearBuilt": 1910
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "This spacious two-storey semi-attached home offers the perfect blend of character, updates, and versatility in the heart of St. John’s. Freshly painted throughout and available for quick possession, this move-in-ready property is ideal for first-time buyers, growing families, or savvy investors. The bright and inviting main floor features a spacious living room with a fireplace (currently non-operational), while the beautifully updated eat-in kitchen boasts modern shaker cabinetry, stainless steel appliances, ample counter space, and a large picture window overlooking the private backyard. Upstairs you’ll find three bedrooms, all offering great natural light, along with a beautifully renovated full bathroom featuring a custom vanity and stylish tiled tub surround. The lower level offers incredible flexibility with a separate exterior entrance, second kitchen, additional living area, and bonus room—making it an excellent opportunity for an in-law suite, extended family living, or future income potential (subject to any required approvals). Outside, enjoy one of the property’s most unique features—a fully fenced backyard complete with a storage shed and a mature apple tree, creating a private outdoor oasis that’s rarely found in the downtown core. Recent improvements include a new torch-on roof (2025) and fresh paint throughout, allowing you to move in with confidence. Whether you’re searching for a family home with room to grow or an investment with exceptional potential, this property is one you won’t want to miss. As per seller's directive, no conveyance of offers until Monday July 6th at 5pm and offers to be left open until 10pm July 6th, 2026 (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"CreationDate": "2026-07-02T19:42:53.171424+00:00"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Flooring": array:1 [
0 => "Mixed Flooring"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1572006"
+"ListOfficeKey": "88627"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "25x76"
+"PhotosChangeTimestamp": "2026-07-02T19:03:01Z"
+"PhotosCount": 25
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-07-02T19:03:01Z"
+"Stories": "2.0"
+"StreetName": "Franklyn"
+"StreetNumber": "45"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "1999"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2026
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29980504/45-franklyn-avenue-st-johns"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-07-02T19:03:01.06Z"
+"ListAgentNationalAssociationId": "1133400"
+"ListOfficeNationalAssociationId": "1007257"
+"Media": array:25 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29980504')"
+"ID": "1585513"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25308
+post_id: "1585516"
+post_author: 1
+"ListingKey": "29979539"
+"ListingId": "1299232"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T15:40:05Z"
+"RFModificationTimestamp": "2026-07-03T15:58:49Z"
+"ListPrice": 349900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 965.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C1P4"
+"UnparsedAddress": "139 Gower Street Unit#301, St. John's, Newfoundland & Labrador A1C1P4"
+"Coordinates": array:2 [
0 => -52.706136
1 => 47.567452
]
+"Latitude": 47.567452
+"Longitude": -52.706136
+"YearBuilt": 1998
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Spectacular top floor unit in the iconic Carriage House Condominium building (with elevator) with incredible views of The Narrows, Signal Hill and downtown St. John's. This executive 2 bed, 1.5 bath condo shows like brand new and has been completely renovated throughout with exceptional high-end finishes. The bright, open-concept main living space features a custom kitchen from Nova Scotia with birch lined cabinets, titanium polished granite countertops and high end appliances, a spacious living area with a large window, an eating area with direct patio access, and an in-unit laundry/storage area. The flooring throughout is warm, custom-cut, glue-down cork. Both bathrooms have been fully renovated and customized with granite counters, custom cabinets and all top of the line fixtures. The bedrooms are bright and spacious, featuring good-sized closets and harbour views and the primary bedroom includes a half-bath ensuite. The building features a common area to host small gatherings, a fitness room, elevator access, storage lockers and designated off-street parking. Located in the heart of downtown St. John's this unit is within walking distance to all amenities and is ideal for professionals working downtown, those downsizing who want to retain a downtown lifestyle or for an investor looking for an upscale unit in a historic building. As per the seller's direction, there will be no conveyance of any offers until 3pm on July 8, 2026. Offers are to be left open for acceptance untl 8pm same day. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "614"
+"AssociationFeeFrequency": "Monthly"
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Air exchanger"
]
+"CreationDate": "2026-07-02T18:40:57.926193+00:00"
+"ExteriorFeatures": array:1 [
0 => "Other"
]
+"Flooring": array:2 [
0 => "Marble"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1964811"
+"ListOfficeKey": "88542"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-07-02T17:33:55Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-07-03T15:32:01Z"
+"StreetName": "Gower"
+"StreetNumber": "139"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2276"
+"View": "Ocean view,View"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2026
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29979539/139-gower-street-unit301-st-johns"
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "Res"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-07-02T17:33:55.42Z"
+"ListAgentNationalAssociationId": "1253371"
+"ListOfficeNationalAssociationId": "1007277"
+"Media": array:37 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29979539')"
+"ID": "1585516"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25309
+post_id: "1586106"
+post_author: 1
+"ListingKey": "29979355"
+"ListingId": "1299777"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T17:40:57Z"
+"RFModificationTimestamp": "2026-07-02T18:09:06Z"
+"ListPrice": 549900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1225.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C5H2"
+"UnparsedAddress": "14 Fort Amherst Road, St. John's, Newfoundland & Labrador A1C5H2"
+"Coordinates": array:2 [
0 => -52.688621
1 => 47.564547
]
+"Latitude": 47.564547
+"Longitude": -52.688621
+"YearBuilt": 1941
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Perched in one of St. John's most scenic & historical locations, this unique three bedroom, three bathroom home blends coastal charm with versatile opportunity. From its inviting balconies, take in spectacular views of the narrows, watch cruise ships glide by and enjoy the daily rhythm of local fisherman returning to port. Inside, the home offers spacious living areas filled with natural light and ocean breezes, creating a warm and welcoming atmosphere. With each bedroom thoughtfully designed for comfort and privacy, it's ideal as a family home, a guesthouse, or an income generated Airbnb. This home has three bathrooms, two full ensuites for generating income. Located Just minutes from the downtown hub, you'll be steps away from St. John's vibrant shops, restaurants, and cultural experiences. The property also boasts stunning views of Cabot Tower - a reminder of the city's rich history and timeless beauty. Whether you're looking for a peaceful retreat, a smart investment, or a place to share Newfoundland's charm with visitors, this oceanside gem delivers it all. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Cooling": array:1 [
0 => "Air exchanger"
]
+"CreationDate": "2026-07-02T17:53:08.540796+00:00"
+"Directions": "Southside Road to Fort Amherst"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1571797"
+"ListOfficeKey": "88555"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "21x41x26x46"
+"PhotosChangeTimestamp": "2026-07-02T17:13:47Z"
+"PhotosCount": 22
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-07-02T17:13:47Z"
+"Stories": "2.0"
+"StreetName": "Fort Amherst"
+"StreetNumber": "14"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "1604"
+"View": "Ocean view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29979355/14-fort-amherst-road-st-johns"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RES"
+"OriginalEntryTimestamp": "2026-07-02T17:13:47.73Z"
+"ListAgentNationalAssociationId": "1033603"
+"ListOfficeNationalAssociationId": "1007294"
+"Media": array:22 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29979355')"
+"ID": "1586106"
}
]
+success: true
+page_size: 9
+page_count: 10
+count: 88
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]