array:1 [
"RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=12&$skip=177336&$filter=(PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24534
+items: array:12 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24659
+post_id: "1536831"
+post_author: 1
+"ListingKey": "29909185"
+"ListingId": "1298975"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:45:47Z"
+"RFModificationTimestamp": "2026-06-16T17:17:44Z"
+"ListPrice": 379900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2266.0
+"BuildingAreaTotal": 0
+"City": "Bay Bulls"
+"PostalCode": "A1S1R3"
+"UnparsedAddress": "34 Cabot Drive, Bay Bulls, Newfoundland & Labrador A1S1R3"
+"Coordinates": array:2 [
0 => -52.813785
1 => 47.324006
]
+"Latitude": 47.324006
+"Longitude": -52.813785
+"YearBuilt": 1996
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Welcome to 34 Cabot Drive, Bay Bulls, a unique opportunity to own a vacant, registered two-apartment home situated on an impressive 1.2-acre lot with potential for future development. Whether you're an investor, homeowner looking for rental income, or someone seeking extra space, this property offers incredible flexibility. The home features a self-contained apartment and is complemented by a large detached double garage with three garage doors, providing ample room for vehicles, equipment, storage, or workshop space. With the possibility of subdividing the land into two separate lots (subject to approvals), this property presents excellent long-term value in a growing community just a short drive from St. John's and only seconds from the ocean. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"CreationDate": "2026-06-16T17:17:32.347752+00:00"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Flooring": array:3 [
0 => "Laminate"
1 => "Other"
2 => "Mixed Flooring"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2006792"
+"ListOfficeKey": "88542"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "1.2 acres"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T14:43:16Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Septic tank"
]
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-16T16:33:43Z"
+"StreetName": "Cabot"
+"StreetNumber": "34"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "1574"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:16 [
0 => array:11 [
"RoomKey" => "1660553824"
"RoomType" => "Foyer"
"ListingId" => "1298975"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29909185"
"RoomLength" => null
"RoomDimensions" => "8.7 X 12.3"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.02Z"
]
1 => array:11 [
"RoomKey" => "1660553825"
"RoomType" => "Living room"
"ListingId" => "1298975"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29909185"
"RoomLength" => null
"RoomDimensions" => "16.11 X 12.3"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.02Z"
]
2 => array:11 [
"RoomKey" => "1660553826"
"RoomType" => "Dining room"
"ListingId" => "1298975"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29909185"
"RoomLength" => null
"RoomDimensions" => "9.4 X 11.5"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.02Z"
]
3 => array:11 [
"RoomKey" => "1660553827"
"RoomType" => "Not known"
"ListingId" => "1298975"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29909185"
"RoomLength" => null
"RoomDimensions" => "13.9 X 11.5"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.02Z"
]
4 => array:11 [
"RoomKey" => "1660553828"
"RoomType" => "Bedroom"
"ListingId" => "1298975"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29909185"
"RoomLength" => null
"RoomDimensions" => "10.7 X 12.4"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.02Z"
]
5 => array:11 [
"RoomKey" => "1660553829"
"RoomType" => "Bedroom"
"ListingId" => "1298975"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29909185"
"RoomLength" => null
"RoomDimensions" => "11.10 X 10.7"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.02Z"
]
6 => array:11 [
"RoomKey" => "1660553830"
"RoomType" => "Recreation room"
"ListingId" => "1298975"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29909185"
"RoomLength" => null
"RoomDimensions" => "20.4 X 11.3"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.02Z"
]
7 => array:11 [
"RoomKey" => "1660553831"
"RoomType" => "Utility room"
"ListingId" => "1298975"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29909185"
"RoomLength" => null
"RoomDimensions" => "5.1 X 11.5"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.02Z"
]
8 => array:11 [
"RoomKey" => "1660553832"
"RoomType" => "Bath (# pieces 1-6)"
"ListingId" => "1298975"
"RoomLevel" => "Fourth level"
"RoomWidth" => null
"ListingKey" => "29909185"
"RoomLength" => null
"RoomDimensions" => "8.0 X 11.5"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.02Z"
]
9 => array:11 [
"RoomKey" => "1660553833"
"RoomType" => "Bedroom"
"ListingId" => "1298975"
"RoomLevel" => "Fourth level"
"RoomWidth" => null
"ListingKey" => "29909185"
"RoomLength" => null
"RoomDimensions" => "11.5 X 11.5"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.02Z"
]
10 => array:11 [
"RoomKey" => "1660553834"
"RoomType" => "Bedroom"
"ListingId" => "1298975"
"RoomLevel" => "Fourth level"
"RoomWidth" => null
"ListingKey" => "29909185"
"RoomLength" => null
"RoomDimensions" => "11.1 X 11.5"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.02Z"
]
11 => array:11 [
"RoomKey" => "1660553835"
"RoomType" => "Primary Bedroom"
"ListingId" => "1298975"
"RoomLevel" => "Fourth level"
"RoomWidth" => null
"ListingKey" => "29909185"
"RoomLength" => null
"RoomDimensions" => "14.6 X 11.5"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.02Z"
]
12 => array:11 [
"RoomKey" => "1660553836"
"RoomType" => "Laundry room"
"ListingId" => "1298975"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29909185"
"RoomLength" => null
"RoomDimensions" => "5.7 X 11.4"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.02Z"
]
13 => array:11 [
"RoomKey" => "1660553837"
"RoomType" => "Bath (# pieces 1-6)"
"ListingId" => "1298975"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29909185"
"RoomLength" => null
"RoomDimensions" => "9.10 X 7.8"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.02Z"
]
14 => array:11 [
"RoomKey" => "1660553838"
"RoomType" => "Kitchen"
"ListingId" => "1298975"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29909185"
"RoomLength" => null
"RoomDimensions" => "12.8 X 13.2"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.03Z"
]
15 => array:11 [
"RoomKey" => "1660553839"
"RoomType" => "Dining nook"
"ListingId" => "1298975"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29909185"
"RoomLength" => null
"RoomDimensions" => "12.8 X 11.9"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.03Z"
]
]
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2025
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29909185/34-cabot-drive-bay-bulls"
+"StructureType": array:1 [
0 => "Two Apartment House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RES"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-06-16T14:43:16.33Z"
+"ListAgentNationalAssociationId": "1288965"
+"ListOfficeNationalAssociationId": "1007277"
+"DaysOnMarket": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909185')"
+"ID": "1536831"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24509
+post_id: "1534762"
+post_author: 1
+"ListingKey": "29908725"
+"ListingId": "1298974"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T11:50:11Z"
+"RFModificationTimestamp": "2026-06-22T11:55:27Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1961.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1C1P4"
+"UnparsedAddress": "143 Gower Street, St. John's, Newfoundland & Labrador A1C1P4"
+"Coordinates": array:2 [
0 => -52.70629
1 => 47.567311
]
+"Latitude": 47.567311
+"Longitude": -52.70629
+"YearBuilt": 1886
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "If you have been looking for that perfect address with a great harbour view, this is it! The home has already undergone an extensive overhaul (in 2006 by previous owner). Still filled with tons of old world charm, this home is believed to have been spared the fire of 1867 which leveled most of the city. Main floor offers a huge open concept living/dining and kitchen as well as 1/2 bath. High ceilings and period fireplaces accent the space. 2nd floor has 2 spacious bedrooms as well as a 1/2 bath and laundry. It is here you will find access to the large 11x15 second floor patio with those amazing views of St. John's Harbour. The top floor has the main 4 piece bath and the remainder is the massive primary suite which also has the same incredible view. The home is very clean and well cared for, shows and feels great. (id:62783)"
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"BathroomsPartial": 2
+"CreationDate": "2026-06-16T13:43:56.563738+00:00"
+"ExteriorFeatures": array:1 [
0 => "Other"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1571758"
+"ListOfficeKey": "88542"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "22x54"
+"PhotosChangeTimestamp": "2026-06-16T16:30:48Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-22T11:42:12Z"
+"Stories": "3.0"
+"StreetName": "Gower"
+"StreetNumber": "143"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3265"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1665203851"
"RoomType" => "Bath (# pieces 1-6)"
"ListingId" => "1298974"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29908725"
"RoomLength" => null
"RoomDimensions" => "4pc"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:42:12.83Z"
]
1 => array:11 [
"RoomKey" => "1665203852"
"RoomType" => "Primary Bedroom"
"ListingId" => "1298974"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29908725"
"RoomLength" => null
"RoomDimensions" => "11.1x26.9"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:42:12.83Z"
]
2 => array:11 [
"RoomKey" => "1665203853"
"RoomType" => "Bath (# pieces 1-6)"
"ListingId" => "1298974"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908725"
"RoomLength" => null
"RoomDimensions" => "2pc"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:42:12.83Z"
]
3 => array:11 [
"RoomKey" => "1665203854"
"RoomType" => "Laundry room"
"ListingId" => "1298974"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908725"
"RoomLength" => null
"RoomDimensions" => "5.6x3.6"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:42:12.83Z"
]
4 => array:11 [
"RoomKey" => "1665203855"
"RoomType" => "Bedroom"
"ListingId" => "1298974"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908725"
"RoomLength" => null
"RoomDimensions" => "12.4x14.2"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:42:12.83Z"
]
5 => array:11 [
"RoomKey" => "1665203856"
"RoomType" => "Bedroom"
"ListingId" => "1298974"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908725"
"RoomLength" => null
"RoomDimensions" => "12.4x12.2"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:42:12.83Z"
]
6 => array:11 [
"RoomKey" => "1665203857"
"RoomType" => "Bath (# pieces 1-6)"
"ListingId" => "1298974"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908725"
"RoomLength" => null
"RoomDimensions" => "2pc"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:42:12.84Z"
]
7 => array:11 [
"RoomKey" => "1665203858"
"RoomType" => "Kitchen"
"ListingId" => "1298974"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908725"
"RoomLength" => null
"RoomDimensions" => "11.6x15.9"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:42:12.84Z"
]
8 => array:11 [
"RoomKey" => "1665203859"
"RoomType" => "Dining room"
"ListingId" => "1298974"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908725"
"RoomLength" => null
"RoomDimensions" => "12.8x15.4"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:42:12.84Z"
]
9 => array:11 [
"RoomKey" => "1665203860"
"RoomType" => "Living room"
"ListingId" => "1298974"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908725"
"RoomLength" => null
"RoomDimensions" => "11.5x19.9"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:42:12.84Z"
]
]
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2026
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29908725/143-gower-street-st-johns"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "Res"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-06-16T13:13:32.42Z"
+"ListAgentNationalAssociationId": "1033579"
+"ListOfficeNationalAssociationId": "1007277"
+"Media": array:34 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29908725_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/2c2f05a9d72dca582b74d46f78bab7fd.webp"
"MediaSize" => 269139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-2c2f05a9d72dca582b74d46f78bab7fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T13:13:32.44Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29908725_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/8c50ab1072d9fb6121cac5b12350e1f1.webp"
"MediaSize" => 291499
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-8c50ab1072d9fb6121cac5b12350e1f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T13:13:32.44Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29908725_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/3e701d02d47f6825460eaa1c9478119a.webp"
"MediaSize" => 174825
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-3e701d02d47f6825460eaa1c9478119a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:48.55Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29908725_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/8c1178375350cf3e803e0f041a4708b9.webp"
"MediaSize" => 229353
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-8c1178375350cf3e803e0f041a4708b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:48.62Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29908725_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/cac4466adf752f0727a8c2a9a6b18fe5.webp"
"MediaSize" => 210634
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-cac4466adf752f0727a8c2a9a6b18fe5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:46.73Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29908725_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/75873bc35a98c6e17aef98455583bafd.webp"
"MediaSize" => 184673
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-75873bc35a98c6e17aef98455583bafd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:48.98Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29908725_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/3f41ba3d47c3a2bd67adbf416d5f1f78.webp"
"MediaSize" => 176369
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-3f41ba3d47c3a2bd67adbf416d5f1f78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:45.36Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29908725_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/fde8cc9f7480e3c20d042702298dce94.webp"
"MediaSize" => 176632
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-fde8cc9f7480e3c20d042702298dce94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:48.85Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29908725_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/62e02b1520810ed3d7f6ae0097b61a1c.webp"
"MediaSize" => 160234
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-62e02b1520810ed3d7f6ae0097b61a1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:48.09Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29908725_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/c53f43294661cef63ffaf93b15596ed8.webp"
"MediaSize" => 189937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-c53f43294661cef63ffaf93b15596ed8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:34.77Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29908725_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/a143a2e9e6782f1ce138e6d3f6ba9fd7.webp"
"MediaSize" => 62519
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-a143a2e9e6782f1ce138e6d3f6ba9fd7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:41.02Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29908725_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/7ca97446a2857f8910c46c21358c8d1e.webp"
"MediaSize" => 152161
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-7ca97446a2857f8910c46c21358c8d1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:35.91Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29908725_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/12a9f4f58c8392351f06617f194c41e1.webp"
"MediaSize" => 98598
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-12a9f4f58c8392351f06617f194c41e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:41.8Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29908725_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/f5c2ac10b935f689ae239afe56faca61.webp"
"MediaSize" => 207745
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-f5c2ac10b935f689ae239afe56faca61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:37.07Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29908725_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/52f1a596353b77a98f2b894fad26d80a.webp"
"MediaSize" => 175555
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-52f1a596353b77a98f2b894fad26d80a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:43.5Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29908725_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/4a101e713f5365752216be39c899c1bd.webp"
"MediaSize" => 209811
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-4a101e713f5365752216be39c899c1bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:36.23Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29908725_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/47789d47ea75faa5ed11bb3d7b7ed502.webp"
"MediaSize" => 117491
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-47789d47ea75faa5ed11bb3d7b7ed502.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:41.96Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29908725_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/2bab1c2323fa8e8de5ab02c51aa59d98.webp"
"MediaSize" => 98879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-2bab1c2323fa8e8de5ab02c51aa59d98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:41.8Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29908725_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/a388603a13b3f77a8c05a735a17a63ba.webp"
"MediaSize" => 88056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-a388603a13b3f77a8c05a735a17a63ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:47.23Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29908725_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/9b1cd0b9c0f27b4494194745de811ced.webp"
"MediaSize" => 94139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-9b1cd0b9c0f27b4494194745de811ced.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:48.38Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29908725_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/31c52922af48cbced3221e6d131a3a8f.webp"
"MediaSize" => 80462
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-31c52922af48cbced3221e6d131a3a8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:41.95Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29908725_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/5bf8d650227349e2d7abcfa03ed3807c.webp"
"MediaSize" => 256123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-5bf8d650227349e2d7abcfa03ed3807c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:47.87Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29908725_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/a53c909e6fadbc252a38566999d99428.webp"
"MediaSize" => 257825
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-a53c909e6fadbc252a38566999d99428.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:44.14Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29908725_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/b538b35dc1755cd5bd100a997bdd00ca.webp"
"MediaSize" => 208389
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-b538b35dc1755cd5bd100a997bdd00ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:48.8Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29908725_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/38c7dba0c123b98209e22ef2c2df43f5.webp"
"MediaSize" => 471378
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-38c7dba0c123b98209e22ef2c2df43f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:43.76Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29908725_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/de11a422f4823114a75cc50533e9c4bc.webp"
"MediaSize" => 451649
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-de11a422f4823114a75cc50533e9c4bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:48.58Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29908725_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/21f78adea4dec35db8e35867dc959288.webp"
"MediaSize" => 444375
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-21f78adea4dec35db8e35867dc959288.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:44.13Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29908725_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/e233ce0dc03aef0675eae074d9f470c2.webp"
"MediaSize" => 438351
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-e233ce0dc03aef0675eae074d9f470c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:47.41Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29908725_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/e164c9105ba66eb2427cf3b0176700dc.webp"
"MediaSize" => 388920
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-e164c9105ba66eb2427cf3b0176700dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:44.69Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29908725_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/e841b53b711ac4f64fc6c5af93b405bc.webp"
"MediaSize" => 300414
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-e841b53b711ac4f64fc6c5af93b405bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:43.81Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29908725_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/7fc78314e077b5ea2c4ec6885cef6c03.webp"
"MediaSize" => 311291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-7fc78314e077b5ea2c4ec6885cef6c03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:47.22Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29908725_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/64ef2d68dd8b71725becc0fe1ee97d87.webp"
"MediaSize" => 54879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-64ef2d68dd8b71725becc0fe1ee97d87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:45.11Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29908725_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/b468c237c7a2903da1f258f43254d71c.webp"
"MediaSize" => 57189
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-b468c237c7a2903da1f258f43254d71c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:48.52Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29908725_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908725/69d6a72f55cb209204c339e6f5cde982.webp"
"MediaSize" => 61147
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908725/thumbnail-69d6a72f55cb209204c339e6f5cde982.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298974"
"ResourceRecordKey" => "29908725"
"ModificationTimestamp" => "2026-06-16T16:30:45.32Z"
]
]
+"DaysOnMarket": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908725')"
+"ID": "1534762"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24647
+post_id: "1535251"
+post_author: 1
+"ListingKey": "29905046"
+"ListingId": "1298972"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:45:46Z"
+"RFModificationTimestamp": "2026-06-16T17:18:13Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2520.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"UnparsedAddress": "62 Hopedale Crescent, St. John's, Newfoundland & Labrador None"
+"Coordinates": array:2 [
0 => -52.794683
1 => 47.549954
]
+"Latitude": 47.549954
+"Longitude": -52.794683
+"YearBuilt": 2007
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Set on a corner lot in a convenient St. John's neighbourhood, this fully developed, owner-occupied home offers a polished mix of comfort, space, and future flexibility. It has been carefully maintained and presents well from the moment you arrive, with two paved driveways and a wired twelve-by-sixteen garage adding everyday practicality for parking, storage, hobbies, or the occasional project that was supposed to take one weekend. Inside, the open-concept main floor creates an easy flow for daily living and entertaining. Hardwood and ceramic flooring carry through the space, giving it a warm, well-finished feel. The large eat-in kitchen is the central gathering area, with room for family meals. Three spacious bedrooms are located on the main level, including a comfortable primary bedroom with its own ensuite. A full main bathroom completes this level with a practical layout that works well for everyday routines. The lower level adds excellent usable space and makes this home especially appealing for buyers thinking ahead. A welcoming recreation room with a woodstove offers a cozy place to unwind, while the huge family room with a wet bar gives you plenty of room for movie nights, game days, or hosting friends. This level also includes a fourth bedroom and a three-piece bathroom. With the existing finished space and thoughtful lower-level layout, there may be potential to explore conversion to a two-apartment home, subject to required approvals and buyer verification. The location adds another strong advantage. Hopedale Crescent Park is just steps away, offering quick access to green space close to home. Sobeys Kenmount on Kelsey Drive is also nearby for simple grocery runs and day-to-day errands. Arrange your private tour and discover how well this home could fit your next move. No Conveyance of offers until 3:00 pm on June 21, 2026, and to remain open until 6:00 pm on June 21, 2026. (id:62650)"
+"Appliances": array:1 [
0 => "Dishwasher"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Cooling": array:1 [
0 => "Air exchanger"
]
+"CreationDate": "2026-06-15T18:34:02.305314+00:00"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Flooring": array:1 [
0 => "Mixed Flooring"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Electric"
1 => "Mini-Split"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1571801"
+"ListOfficeKey": "88555"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "43x80x100x65"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T17:53:18Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-16T16:33:43Z"
+"Stories": "1.0"
+"StreetName": "Hopedale"
+"StreetNumber": "62"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3213"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1660553861"
"RoomType" => "Laundry room"
"ListingId" => "1298972"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29905046"
"RoomLength" => null
"RoomDimensions" => "7.7.8"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.43Z"
]
1 => array:11 [
"RoomKey" => "1660553862"
"RoomType" => "Bedroom"
"ListingId" => "1298972"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29905046"
"RoomLength" => null
"RoomDimensions" => "11.6x14"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.43Z"
]
2 => array:11 [
"RoomKey" => "1660553863"
"RoomType" => "Recreation room"
"ListingId" => "1298972"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29905046"
"RoomLength" => null
"RoomDimensions" => "14.6x15"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.43Z"
]
3 => array:11 [
"RoomKey" => "1660553864"
"RoomType" => "Family room"
"ListingId" => "1298972"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29905046"
"RoomLength" => null
"RoomDimensions" => "13x28"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.43Z"
]
4 => array:11 [
"RoomKey" => "1660553865"
"RoomType" => "Bedroom"
"ListingId" => "1298972"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905046"
"RoomLength" => null
"RoomDimensions" => "8.9x10.4"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.43Z"
]
5 => array:11 [
"RoomKey" => "1660553866"
"RoomType" => "Bedroom"
"ListingId" => "1298972"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905046"
"RoomLength" => null
"RoomDimensions" => "9.6x14"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.43Z"
]
6 => array:11 [
"RoomKey" => "1660553867"
"RoomType" => "Primary Bedroom"
"ListingId" => "1298972"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905046"
"RoomLength" => null
"RoomDimensions" => "13.6x14.2"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.43Z"
]
7 => array:11 [
"RoomKey" => "1660553868"
"RoomType" => "Eat in kitchen"
"ListingId" => "1298972"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905046"
"RoomLength" => null
"RoomDimensions" => "14x17.6"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.43Z"
]
8 => array:11 [
"RoomKey" => "1660553869"
"RoomType" => "Living room"
"ListingId" => "1298972"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905046"
"RoomLength" => null
"RoomDimensions" => "12x19.4"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T16:33:43.43Z"
]
]
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2026
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29905046/62-hopedale-crescent-st-johns"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "res"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-15T17:53:17.93Z"
+"ListAgentNationalAssociationId": "1133109"
+"ListOfficeNationalAssociationId": "1007294"
+"Media": array:49 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29905046_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905046/db6109bdec15a9fc41d6b152babac1e9.webp"
"MediaSize" => 244101
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905046/thumbnail-db6109bdec15a9fc41d6b152babac1e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "1298972"
"ResourceRecordKey" => "29905046"
"ModificationTimestamp" => "2026-06-15T17:53:17.93Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29905046_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905046/6371af77c252c22fb83b8236597ba62a.webp"
"MediaSize" => 241857
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905046/thumbnail-6371af77c252c22fb83b8236597ba62a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298972"
"ResourceRecordKey" => "29905046"
"ModificationTimestamp" => "2026-06-15T17:53:17.93Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29905046_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905046/16be85e511cbe798740a5d710cd1c363.webp"
"MediaSize" => 297355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905046/thumbnail-16be85e511cbe798740a5d710cd1c363.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298972"
"ResourceRecordKey" => "29905046"
"ModificationTimestamp" => "2026-06-15T17:53:17.93Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29905046_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905046/8fccb1cf70e7b8ddfbd490170746e2dc.webp"
"MediaSize" => 303622
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905046/thumbnail-8fccb1cf70e7b8ddfbd490170746e2dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298972"
"ResourceRecordKey" => "29905046"
"ModificationTimestamp" => "2026-06-15T17:53:17.93Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29905046_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905046/167462d7d78f6fa351706b730521e71a.webp"
"MediaSize" => 295890
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905046/thumbnail-167462d7d78f6fa351706b730521e71a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298972"
"ResourceRecordKey" => "29905046"
"ModificationTimestamp" => "2026-06-15T17:53:17.93Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29905046_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905046/92d6622afa7293c0c328446f9b6fa64b.webp"
"MediaSize" => 314207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905046/thumbnail-92d6622afa7293c0c328446f9b6fa64b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298972"
"ResourceRecordKey" => "29905046"
"ModificationTimestamp" => "2026-06-15T17:53:17.93Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29905046_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905046/7c0f769ddb5cdf2ac063c5493e11eded.webp"
"MediaSize" => 322098
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905046/thumbnail-7c0f769ddb5cdf2ac063c5493e11eded.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298972"
"ResourceRecordKey" => "29905046"
"ModificationTimestamp" => "2026-06-15T17:53:17.93Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29905046_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905046/77ca116165cb4efe0f8b46c8919a4e32.webp"
"MediaSize" => 250391
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905046/thumbnail-77ca116165cb4efe0f8b46c8919a4e32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298972"
"ResourceRecordKey" => "29905046"
"ModificationTimestamp" => "2026-06-15T17:53:17.93Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29905046_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905046/84541f4b199ceab21298fb18577c4a17.webp"
"MediaSize" => 199767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905046/thumbnail-84541f4b199ceab21298fb18577c4a17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298972"
"ResourceRecordKey" => "29905046"
"ModificationTimestamp" => "2026-06-15T17:53:17.93Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29905046_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905046/b2187ac0818f4093ec870aad1fe182bf.webp"
"MediaSize" => 180760
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905046/thumbnail-b2187ac0818f4093ec870aad1fe182bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298972"
"ResourceRecordKey" => "29905046"
"ModificationTimestamp" => "2026-06-15T17:53:17.93Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29905046_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905046/0b5dc13a2436bf42c405706eb8f6931c.webp"
"MediaSize" => 338613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905046/thumbnail-0b5dc13a2436bf42c405706eb8f6931c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298972"
"ResourceRecordKey" => "29905046"
"ModificationTimestamp" => "2026-06-15T17:53:17.93Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29905046_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905046/562ae3313f5eb8a58cbb26cbf2f90db2.webp"
"MediaSize" => 331909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905046/thumbnail-562ae3313f5eb8a58cbb26cbf2f90db2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298972"
"ResourceRecordKey" => "29905046"
"ModificationTimestamp" => "2026-06-15T17:53:17.93Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29905046_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905046/86be6ff021da46190875610dc78b01b4.webp"
"MediaSize" => 331909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905046/thumbnail-86be6ff021da46190875610dc78b01b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298972"
"ResourceRecordKey" => "29905046"
"ModificationTimestamp" => "2026-06-15T17:53:17.93Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29905046_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905046/8e99d5006904a0a3599af46b2e590e00.webp"
"MediaSize" => 377104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905046/thumbnail-8e99d5006904a0a3599af46b2e590e00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298972"
"ResourceRecordKey" => "29905046"
"ModificationTimestamp" => "2026-06-15T17:53:17.93Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29905046_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905046/c92b29b5f31678b1995d132fa167a61e.webp"
"MediaSize" => 350877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905046/thumbnail-c92b29b5f31678b1995d132fa167a61e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "1298972"
"ResourceRecordKey" => "29905046"
"ModificationTimestamp" => "2026-06-15T17:53:17.93Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29905046_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905046/1bebec416a7fd8635336924cc45d0aae.webp"
…10
]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 17
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905046')"
+"ID": "1535251"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24527
+post_id: "1536473"
+post_author: 1
+"ListingKey": "29905300"
+"ListingId": "1298971"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:45:46Z"
+"RFModificationTimestamp": "2026-06-16T17:18:03Z"
+"ListPrice": 68500.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 863.0
+"BuildingAreaTotal": 0
+"City": "Marystown"
+"PostalCode": "A0E2M0"
+"UnparsedAddress": "512-514 Ville Marie Drive, Marystown, Newfoundland & Labrador A0E2M0"
+"Coordinates": array:2 [
0 => -55.180523
1 => 47.160828
]
+"Latitude": 47.160828
+"Longitude": -55.180523
+"YearBuilt": 1985
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Welcome to 512-514 Ville Marie Drive, Marystown! This affordable and well-maintained three-bedroom, one-bathroom bungalow offers a fantastic opportunity for first-time homebuyers, retirees looking for convenient one-level living, or investors seeking a potential rental property. The home features an all-on-one-level layout with electric heat, a 200-amp breaker panel, municipal water and sewer services, and shingles replaced in 2025. Enjoy your morning coffee or evening relaxation on the large side deck, where you’ll appreciate beautiful water views. Outside, you’ll find two adjoining storage sheds measuring 9’ x 12’ and 9’ x 9’, providing plenty of space for tools, seasonal items, and outdoor equipment. Conveniently located close to shopping, restaurants, and other amenities, this property combines comfort, practicality, and value. Please note that while all three rooms are currently being used as bedrooms, they do not contain closets. This property is an excellent opportunity to step into homeownership, downsize for retirement, or add to your investment portfolio (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"CreationDate": "2026-06-15T19:40:56.640307+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Shingles"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Other"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1942839"
+"ListOfficeKey": "280379"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "80x178"
+"PhotosChangeTimestamp": "2026-06-15T18:23:32Z"
+"PhotosCount": 20
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-16T16:33:43Z"
+"Stories": "1.0"
+"StreetName": "Ville Marie"
+"StreetNumber": "512-514"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "567"
+"View": "Ocean 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"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29905300/512-514-ville-marie-drive-marystown"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "res"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-06-15T18:23:32.58Z"
+"ListAgentNationalAssociationId": "1239183"
+"ListOfficeNationalAssociationId": "1313257"
+"Media": array:20 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
]
+"DaysOnMarket": 17
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905300')"
+"ID": "1536473"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24521
+post_id: "1538051"
+post_author: 1
+"ListingKey": "29910864"
+"ListingId": "1298969"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-21T19:00:04Z"
+"RFModificationTimestamp": "2026-06-21T19:03:46Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 5430.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1B2G2"
+"UnparsedAddress": "37 Dublin Road, St. John's, Newfoundland & Labrador A1B2G2"
+"Coordinates": array:2 [
0 => -52.724831
1 => 47.591241
]
+"Latitude": 47.591241
+"Longitude": -52.724831
+"YearBuilt": 1971
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Commissioned and hand-built by its original owner, Simon Lono, this architecturally significant residence is among the most distinctive homes in St. John's. Ideally located in the coveted Kent's Pond neighbourhood, within walking distance of Churchill Square, Memorial University, parks and schools, and a few minutes drive to downtown. Known for its striking Italian marble exterior and distinctive Spanish clay tile roof, the home showcases exceptional craftsmanship, artistic expression and enduring quality. Dramatic living spaces, soaring ceilings, expansive windows and remarkable architectural details create an atmosphere unlike anything else on the market. A sweeping circular staircase is crowned by a spectacular two-storey vintage Italian Murano hand-blown glass chandelier, believed to date from the 1960s, complemented by coordinating glass fixtures throughout the home. Designed for entertaining on a grand scale, the upper-level gathering room features a propane fireplace, original Mid-Century Modern wet bar with commissioned mosaic tile artwork, and access to a rooftop composite deck with panoramic city and ocean views. The home's unique layout and generous spaces comfortably accommodate large gatherings while remaining warm and inviting for everyday living. Quality is evident throughout with steel beam construction, solid oak doors, plaster mouldings and rosettes, hardwood flooring, intercom system, secure vault, imported lighting and countless custom details. Modern comforts include heated floors in the kitchen, main bath and primary ensuite. With six bedrooms and four bathrooms, this is a home for those who appreciate architecture, originality and inspired living. A rare opportunity to own a true landmark residence—an entertainer's dream and artistic statement unlike anything else in the marketplace. SELLER'S DIRECTION: No conveyance of offers prior to 9:00 AM on June 23, 2026. Offers to remain open for acceptance until 2:00 PM. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Wet Bar"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"BathroomsPartial": 1
+"CreationDate": "2026-06-16T18:32:07.118263+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"Flooring": array:4 [
0 => "Hardwood"
1 => "Marble"
2 => "Ceramic"
3 => "Mixed Flooring"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1572241"
+"ListOfficeKey": "293977"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "98x70"
+"PhotosChangeTimestamp": "2026-06-16T17:53:50Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-21T18:52:47Z"
+"Stories": "2.0"
+"StreetName": "Dublin"
+"StreetNumber": "37"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5561"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=xDY4iqLC8E2"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:24 [
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]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
22 => array:11 [ …11]
23 => array:11 [ …11]
]
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29910864/37-dublin-road-st-johns"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2246148"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "293977"
+"GeocodeManualYN": true
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"OriginalEntryTimestamp": "2026-06-16T17:53:49.99Z"
+"ListAgentNationalAssociationId": "1117242"
+"ListOfficeNationalAssociationId": "1433917"
+"CoListAgentNationalAssociationId": "1484979"
+"CoListOfficeNationalAssociationId": "1433917"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29910864')"
+"ID": "1538051"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24643
+post_id: "1534902"
+post_author: 1
+"ListingKey": "29909420"
+"ListingId": "1298968"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T15:10:12Z"
+"RFModificationTimestamp": "2026-06-16T17:21:02Z"
+"ListPrice": 649000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 3200.0
+"BuildingAreaTotal": 0
+"City": "Stephenville"
+"PostalCode": "A2N3B4"
+"UnparsedAddress": "5-7 Prince Rupert Drive, Stephenville, Newfoundland & Labrador A2N3B4"
+"Coordinates": array:2 [
0 => -58.582791
1 => 48.546174
]
+"Latitude": 48.546174
+"Longitude": -58.582791
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Located in the center of Stephenville with a huge parking lot, this 3200 square foot building has two offices and a bathroom, plus, showroom, and/or workshop, manufacturing facility, storage facility, etc. This building is on a street with other Automotive dealerships, Garages, Parts Stores, offices and businesses including Canadian Tire and Dominion Grocery Store, so this building can be used as almost anything as long as it is approved by the Town. Along with this building and land being for sale it is also a possibility to lease the property if you are so inclined. Do not miss out on this large facility that can be purchased or leased. Call an agent today to get your personal viewing. (id:62650)"
+"BusinessType": "Industrial,Manufacturing,Other,Retail and Wholesale"
+"CreationDate": "2026-06-16T17:20:52.335013+00:00"
+"Flooring": array:1 [
0 => "Concrete Slab"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1918063"
+"ListOfficeKey": "88563"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-16T15:02:33Z"
+"PhotosCount": 5
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-16T15:02:33Z"
+"Stories": "1.0"
+"StreetName": "Prince Rupert"
+"StreetNumber": "5-7"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3339"
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2026
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29909420/5-7-prince-rupert-drive-stephenville"
+"StructureType": array:1 [
0 => "Manufacturing"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "Commercial"
+"OriginalEntryTimestamp": "2026-06-16T15:02:33.15Z"
+"ListAgentNationalAssociationId": "1225758"
+"ListOfficeNationalAssociationId": "1260564"
+"DaysOnMarket": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909420')"
+"ID": "1534902"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24642
+post_id: "1538060"
+post_author: 1
+"ListingKey": "29908536"
+"ListingId": "1298967"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T23:40:03Z"
+"RFModificationTimestamp": "2026-06-17T23:43:36Z"
+"ListPrice": 335000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2400.0
+"BuildingAreaTotal": 0
+"City": "Gander"
+"PostalCode": "A1V2L4"
+"UnparsedAddress": "21 Giffin Place, Gander, Newfoundland & Labrador A1V2L4"
+"Coordinates": array:2 [
0 => -54.612506
1 => 48.972855
]
+"Latitude": 48.972855
+"Longitude": -54.612506
+"YearBuilt": 1982
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Nestled in a highly desirable neighborhood in the friendly community of Gander, this split-entry home sits on a quiet cul-de-sac near Cobbs Pond and walking trails, with easy access to local festivities and the convenience of nearby services, while Gander’s proximity to the international airport and short drives to Fogo Island and Twillingate add to its appeal for families and travelers alike; you’ll enter through a welcoming front foyer and head upstairs to a bright living room with a propane fireplace, to the left the kitchen at the front of the home, two bedrooms and a full bath completing the main level, downstairs you’ll find a large rec room, another full bath, 1 bedroom plus a bonus room that can serve as a fourth bedroom, den, or study, and the fully fenced yard makes this home ideal for children or pets in a cycle-friendly neighborhood; updates include fresh paint throughout, shingles about 10 years old with a 35-year lifespan, a recently updated main water line from the house to the street, 200-amp service, and a 60-gallon hot water tank (one year old). As per Seller's Direction, there will be no conveyance of written offers prior to 3 PM on June 19th, and left open until 8 pm the same day. (id:62650)"
+"Appliances": array:3 [
0 => "Washer"
1 => "Stove"
2 => "Dryer"
]
+"CreationDate": "2026-06-16T13:33:23.990521+00:00"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Mixed Flooring"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Electric"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2031031"
+"ListOfficeKey": "297381"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "65X89"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T23:32:34Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-17T23:32:34Z"
+"Stories": "1.0"
+"StreetName": "Griffin"
+"StreetNumber": "21"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "2245"
+"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"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29908536/21-griffin-place-gander"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RES"
+"OriginalEntryTimestamp": "2026-06-16T12:23:08.87Z"
+"ListAgentNationalAssociationId": "1308523"
+"ListOfficeNationalAssociationId": "1465763"
+"Media": array:43 [
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]
]
+"DaysOnMarket": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908536')"
+"ID": "1538060"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25067
+post_id: "1574368"
+post_author: 1
+"ListingKey": "29940225"
+"ListingId": "1298966"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T11:55:02Z"
+"RFModificationTimestamp": "2026-06-23T17:46:10Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 1287.0
+"BuildingAreaTotal": 0
+"City": "Fogo Island (Deep Bay)"
+"PostalCode": "A0G1W0"
+"UnparsedAddress": "3 & 3A Coles Point, Fogo Island (Deep Bay), Newfoundland & Labrador A0G1W0"
+"Coordinates": array:2 [
0 => -54.291414
1 => 49.671686
]
+"Latitude": 49.671686
+"Longitude": -54.291414
+"YearBuilt": 1875
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Welcome to 3 Coles Point, a rare oceanfront gem in Deep Bay, Fogo Island. This historic ~150–200-year-old salt box house was floated from a nearby island and thoughtfully rebuilt in 2018; repositioned to capture stunning 180-degree views of Deep Bay Harbour, the Leveret Islands, and the open ocean. Inside, locally sourced spruce woodwork, wide plank engineered oak floors, and exposed ceiling beams with custom iron brackets create a warm, artisan feel. The open-concept main floor features large windows, flooding the space with natural light and panoramic water views. A French-made Godin wood/coal stove on an antique stone base adds cozy charm. The kitchen has solid hickory cabinetry, butcher block cherry countertops, handcrafted hardware, and under-cabinet lighting. The oversized bathroom impresses with a live-edge vanity crafted from a vintage sewing machine base, stone vessel sink, and luxurious rainfall shower. Upstairs, the spacious king-sized loft bedroom is a serene retreat with windows that frame breathtaking ocean vistas. This space can easily be converted into two separate bedrooms to suit your needs. Outside, the wraparound deck with built-in windscreen invites relaxation and a place to observe abundant wildlife, while stone-framed gardens and stone steps lead to the water’s edge—ideal for kayaking or boating. Additional highlights include direct, rare full title to the high water mark, a 5800-litre rainwater system housed in an insulated crawlspace, ample parking with a RV hookup, and levelled lot with ample room to build additional building(s). This opportunity also includes the adjacent 3A parcel of land which includes water access via a private fishing stage + vintage 9’ x 11’ double walled wooden shed (originally the villages’ salt store), large parking pad & wood pile. Minutes from Fogo Island’s artist studios, fishing spots, airstrip, and ferry terminal, this coastal retreat offers an extraordinary blend of history, beauty, and modern living. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"CreationDate": "2026-06-23T17:46:07.492449+00:00"
+"ExteriorFeatures": array:1 [
0 => "Cedar shingles"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Woodstove"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"Heating": array:3 [
0 => "Baseboard heaters"
1 => "Electric"
2 => "Wood"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2006056"
+"ListOfficeKey": "280379"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "1763 sqm"
+"PhotosChangeTimestamp": "2026-06-23T11:43:05Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Septic tank"
]
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-23T11:43:05Z"
+"Stories": "1.5"
+"StreetName": "Coles"
+"StreetNumber": "3 & 3A"
+"StreetSuffix": "Point"
+"TaxAnnualAmount": "1035"
+"WaterSource": array:2 [
0 => "Cistern"
1 => "Drilled Well"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29940225/3-3a-coles-point-fogo-island-deep-bay"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2084916"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "280379"
+"GeocodeManualYN": true
+"ZoningDescription": "Res."
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"OriginalEntryTimestamp": "2026-06-23T11:43:05.61Z"
+"ListAgentNationalAssociationId": "1288406"
+"ListOfficeNationalAssociationId": "1313257"
+"CoListAgentNationalAssociationId": "1358339"
+"CoListOfficeNationalAssociationId": "1313257"
+"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": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29940225')"
+"ID": "1574368"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24528
+post_id: "1536080"
+post_author: 1
+"ListingKey": "29909620"
+"ListingId": "1298964"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T17:46:07Z"
+"RFModificationTimestamp": "2026-06-18T18:10:07Z"
+"ListPrice": 169900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 976.0
+"BuildingAreaTotal": 0
+"City": "CLARENVILLE"
+"PostalCode": "A5A1J2"
+"UnparsedAddress": "6 JACQUELINE Avenue, CLARENVILLE, Newfoundland & Labrador A5A1J2"
+"Coordinates": array:2 [
0 => -53.965784
1 => 48.149091
]
+"Latitude": 48.149091
+"Longitude": -53.965784
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Looking for an affordable home in today's market? This well-maintained property offers exceptional value and pride of ownership throughout. The exterior features a brand-new back deck, a compact and private yard, and a spacious 12' x 16' shed complete with a ramp and automatic garage door for added convenience. Inside, you'll find a bright, move-in-ready home with stainless steel appliances, a new hot water heater, a high-efficiency electric furnace, and an electrical panel updated with new breakers. Every detail has been cared for, making this an excellent option for first-time buyers, downsizers, or anyone seeking a low-maintenance property. The location is hard to beat—situated right next to Elizabeth Swan Park and the splash pad, providing easy access to outdoor recreation and family-friendly amenities. Affordable, updated, and well cared for, this home is a must-see! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
]
+"CreationDate": "2026-06-16T17:16:06.872406+00:00"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Other"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1783294"
+"ListOfficeKey": "274626"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "45' X 110'"
+"PhotosChangeTimestamp": "2026-06-16T15:33:28Z"
+"PhotosCount": 17
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-18T17:02:37Z"
+"StreetName": "JACQUELINE"
+"StreetNumber": "6"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "660"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2026
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29909620/6-jacqueline-avenue-clarenville"
+"StructureType": array:1 [
0 => "Mobile Home"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "Res."
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-06-16T15:33:28.19Z"
+"ListAgentNationalAssociationId": "1188316"
+"ListOfficeNationalAssociationId": "1257743"
+"Media": array:17 [
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]
]
+"DaysOnMarket": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909620')"
+"ID": "1536080"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24533
+post_id: "1538424"
+post_author: 1
+"ListingKey": "29914390"
+"ListingId": "1298962"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T12:00:04Z"
+"RFModificationTimestamp": "2026-06-26T12:02:36Z"
+"ListPrice": 695000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2049.0
+"BuildingAreaTotal": 0
+"City": "Holyrood"
+"UnparsedAddress": "61 Northside Road, Holyrood, Newfoundland & Labrador None"
+"Coordinates": array:2 [
0 => -53.137979
1 => 47.394607
]
+"Latitude": 47.394607
+"Longitude": -53.137979
+"YearBuilt": 1987
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Nestled in a sought-after area of scenic Holyrood, this exceptional 1.76 acre estate-style property offers unobstructed ocean views & unmatched privacy. Situated on mature landscaped grounds with frontage on Northside Road & land backing on Kennedy's Lane, this unique property presents future development potential while providing an incredible lifestyle opportunity. With interior design features by renowned architect Philip Pratt, the home is perfectly positioned to preserve panoramic water views while creating the feeling of true oceanfront living with nearly every window capturing breathtaking vistas of Conception Bay. The property also boasts a fenced tennis court with a pickle ball court. The impressive main level showcases exposed beams, soaring ceilings, & an abundance of natural light. The open-concept living & dining areas are thoughtfully designed to maximize the views & feature a custom energy-efficient wood burning fireplace creating a warm & inviting atmosphere. The kitchen offers ample cabinetry, a convenient pass-through, & direct access to the deck & gardens. Also on this level are a spacious bedroom, a full bathroom & laundry area, a rear family room that could easily serve as an additional bedroom, & excellent storage space. The upper level is dedicated entirely to a loft-style primary retreat featuring stunning ocean views, a walk-in closet, an ensuite with soaker tub, & direct access to a private patio. Recent exterior upgrades include Cape Cod wood siding, new windows & exterior doors plus a custom front glass entrance door. Enjoy whale watching, cod fishing, sailboat races, & kayakers from the wide wrap-around deck. Take advantage of the exceptional recreation facilities in Holyrood including the Holyrood Yacht Marina & the Willows Golf Course. Offered to the open market for the first time, this remarkable legacy property combines architectural significance, breathtaking natural surroundings, future potential—an opportunity rarely found. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"CreationDate": "2026-06-17T13:48:57.633617+00:00"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Other"
]
+"Flooring": array:2 [
0 => "Wood"
1 => "Mixed Flooring"
]
+"FoundationDetails": array:1 [
0 => "Concrete Slab"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1964615"
+"ListOfficeKey": "293977"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "1.76 acres"
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-06-26T11:53:21Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-26T11:53:21Z"
+"Stories": "1.0"
+"StreetName": "Northside"
+"StreetNumber": "61"
+"StreetSuffix": "Road"
+"View": "Ocean view,View"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=8eppiZZbHqy&mls=1"
+"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/29914390/61-northside-road-holyrood"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-06-17T12:13:00.27Z"
+"ListAgentNationalAssociationId": "1253254"
+"ListOfficeNationalAssociationId": "1433917"
+"Media": array:43 [
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]
]
+"DaysOnMarket": 15
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914390')"
+"ID": "1538424"
}
10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24531
+post_id: "1539896"
+post_author: 1
+"ListingKey": "29914998"
+"ListingId": "1298961"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-21T19:00:04Z"
+"RFModificationTimestamp": "2026-06-21T19:03:46Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2390.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1B0R9"
+"UnparsedAddress": "4 Cape Norman Street, St. John's, Newfoundland & Labrador A1B0R9"
+"Coordinates": array:2 [
0 => -52.802529
1 => 47.54466
]
+"Latitude": 47.54466
+"Longitude": -52.802529
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Welcome to this like-new registered two-apartment home, ideally situated on a quiet side street in the highly sought-after Kenmount Terrace neighborhood. Thoughtfully designed with custom selections, curated lighting throughout, and quality finishes at every turn, this home offers the perfect blend of style, functionality, and investment potential.The main unit features an inviting open-concept layout with 3 bedrooms and 2.5 bathrooms. The stunning kitchen is finished with timeless ceiling-height off-white cabinetry, premium stainless steel appliances, tiled backsplash, floating shelves, and a island. Patio doors lead to the rear deck and garden, creating an ideal space for entertaining. The bright living room is complemented by a strategically placed mini-split heat pump, providing energy-efficient heating and cooling year-round. The primary suite offers a walk-in closet and private ensuite, while the fully developed lower level includes a spacious rec room, powder room, and laundry area. The bright and self-contained 2-bedroom apartment boasts an open-concept living, dining, and kitchen area complete with stainless steel appliances and a stylish backsplash. The apartment also features its own laundry and a full family bathroom, offering excellent convenience for tenants. Outside, with the addition of side parking, can accommodate approximately 3-4 vehicles. The property also benefits from remaining Atlantic Home Warranty coverage for added peace of mind. Meticulously maintained and showing like new, this exceptional property presents a fantastic opportunity for homeowners and investors alike. The apartment is currently leased to quality tenants at $1,500/month POU, while the main unit is vacant and ready for immediate occupancy. No conveynece of offers until Wednesday, June 24 @ 12:00pm (noon) and left open for accaptence until 5:00pm the same day. (id:62650)"
+"Appliances": array:3 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
]
+"BathroomsPartial": 1
+"CreationDate": "2026-06-17T17:04:27.959423+00:00"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Flooring": array:1 [
0 => "Mixed Flooring"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Baseboard heaters"
1 => "Electric"
2 => "Mini-Split"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1964615"
+"ListOfficeKey": "293977"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "55 x 98 x 55 x 101"
+"PhotosChangeTimestamp": "2026-06-17T14:23:11Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-21T18:52:47Z"
+"StreetName": "Cape Norman"
+"StreetNumber": "4"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3962"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=7tnrpruEPeE&mls=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
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]
]
+"ListAOR": "Newfoundland & Labrador"
+"TaxYear": 2026
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29914998/4-cape-norman-street-st-johns"
+"StructureType": array:1 [
0 => "Two Apartment House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "Res"
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"OriginalEntryTimestamp": "2026-06-17T14:23:11.76Z"
+"ListAgentNationalAssociationId": "1253254"
+"ListOfficeNationalAssociationId": "1433917"
+"Media": array:39 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
]
+"DaysOnMarket": 15
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914998')"
+"ID": "1539896"
}
11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24530
+post_id: "1530762"
+post_author: 1
+"ListingKey": "29904754"
+"ListingId": "1298960"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:45:46Z"
+"RFModificationTimestamp": "2026-06-16T17:18:48Z"
+"ListPrice": 284900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1500.0
+"BuildingAreaTotal": 0
+"City": "St. John's"
+"PostalCode": "A1E1M2"
+"UnparsedAddress": "171 Pleasant Street, St. John's, Newfoundland & Labrador A1E1M2"
+"Coordinates": array:2 [
0 => -52.720683
1 => 47.555198
]
+"Latitude": 47.555198
+"Longitude": -52.720683
+"YearBuilt": 1893
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
+"PublicRemarks": "Welcome to 171 Pleasant St., a captivating home that beautifully combines classic architecture with contemporary living. Nestled in a wonderful area of downtown, this property offers the perfect blend of character and comfort .As you step inside, you'll find a lovely eat-in kitchen on the main level, perfect for casual meals and entertaining. The elegant dining room sets the stage for more formal gatherings, while the cozy living room features a propane fireplace, providing warmth and ambiance for those chilly evenings. Upstairs, you’ll discover three generously sized bedrooms, ideal for families or guests, offering a peaceful retreat at the end of the day. Outside, the back deck serves as a private oasis, providing a tranquil space to unwind and enjoy the beauty of your surroundings. Whether you're savoring a morning coffee or hosting friends for a barbecue, this outdoor space is sure to impress. Conveniently located just minutes from downtown shopping and the waterfront, you'll have easy access to all the amenities and attractions the area has to offer. Don’t miss your chance to own a piece of this charming community! No conveyance of any written signed offer as per sellers directive until 5PM on June 22, 2026 with offers to be left open until 10PM same day. (id:62650)"
+"CreationDate": "2026-06-15T18:01:32.938971+00:00"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Flooring": array:1 [
0 => "Mixed Flooring"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2016745"
+"ListOfficeKey": "293977"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "26 x 54"
+"PhotosChangeTimestamp": "2026-06-15T17:23:23Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Newfoundland & Labrador"
+"StatusChangeTimestamp": "2026-06-16T16:33:44Z"
+"Stories": "1.0"
+"StreetName": "Pleasant"
+"StreetNumber": "171"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2352"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Newfoundland & Labrador"
+"ListAORKey": "117"
+"ListingURL": "www.realtor.ca/real-estate/29904754/171-pleasant-street-st-johns"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2240501"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "293977"
+"GeocodeManualYN": true
+"ZoningDescription": "RES"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-06-15T17:23:23.42Z"
+"ListAgentNationalAssociationId": "1297987"
+"ListOfficeNationalAssociationId": "1433917"
+"CoListAgentNationalAssociationId": "1478459"
+"CoListOfficeNationalAssociationId": "1433917"
+"Media": array:27 [
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]
]
+"DaysOnMarket": 17
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29904754')"
+"ID": "1530762"
}
]
+success: true
+page_size: 12
+page_count: 16665
+count: 199972
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]
