Listings - ComFree Realty

Back to Map

$529,900

Newfoundland & Labrador,St. John's

For Sale Active

5 Brad Gushue Crescent, St. John's, Newfoundland & Labrador A1H0A3

4
3
2,170 Sqft

Contact Seller

Feature Sheet

Basic Details

Description

Welcome to this beautifully renovated and fully developed home, offering a bright open-concept design with 4 bedrooms and 3 bathrooms. The spacious primary suite features a stunning remodelled 4 pc bathroom and a walk-in closet. Extensively updated throughout, this home boasts a gorgeous new kitchen with modern cabinetry, an updated main bathroom vanity and faucet, new flooring, upgraded stairs and

railings, stylish light fixtures, new door hardware, updated switches and outlets, custom closet organizers, new thermostats, and the added comfort and efficiency of two new mini-split heat pumps. Outside, you’ll find equally impressive improvements including newly paved driveway with convenient rear yard access to a newly constructed 12′ x 14′ garage, along with new fencing and updated flower planters that enhance the property’s curb appeal. As per Seller’s Direction, no offers will be presented prior to 2 pm, Monday, June 15, 2026. All offers to remain open for acceptance until 7 p.m. the same day. (id:62650)

Basic Details

Property Type: Residential
Listing Type: For Sale
Listing ID: 1298597
Price: $529,900
Bedrooms: 4
Bathrooms: 3
Half Bathrooms: 1
Square Footage: 2,170 Sqft
Year Built: 2007
Status: Active
Property Sub Type: Single Family
Office Key: 88542

Features & Appliances

Features

Heating System: Baseboard heaters, Electric, Mini-Split
Fence: Fence
Parking: Detached Garage, Attached Garage
Exterior Features: Vinyl siding
Flooring: Laminate, Mixed Flooring
Sewer: Municipal sewage system

Address Map

Location: CA, Newfoundland & Labrador, St. John's, A1H0A3
Street: Brad Gushue
Street Number: 5
Street Suffix: Crescent
Longitude: W53° 11' 20.7''
Latitude: N47° 29' 27''

Additional Information

Water Source:
Foundation Details:
Lot Size Dimensions: 50 x 105
Stories: 1.0

Financial

Tax Annual Amount: 3330

Listing updated: 2026-06-13 19:29:28

Schedule a Tour

List Your Property

Mortgage Calculator

Get Pre-Approved

Home Price $

Down Payment

Interest Rate %

Mortgage Term years

Monthly Payment (Est.) $

MLS On The Fly Debug Panel

 Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25139
  +post_id: "1525387"
  +post_author: 1
  +"ListingKey": "29896609"
  +"ListingId": "1298886"
  +"PropertyType": "Residential"
  +"PropertySubType": "Single Family"
  +"StandardStatus": "Active"
  +"ModificationTimestamp": "2026-06-12T19:00:09Z"
  +"RFModificationTimestamp": "2026-06-12T19:03:41Z"
  +"ListPrice": 459900.0
  +"BathroomsTotalInteger": 3.0
  +"BathroomsHalf": 1
  +"BedroomsTotal": 3.0
  +"LotSizeArea": 0
  +"LivingArea": 2175.0
  +"BuildingAreaTotal": 0
  +"City": "St. John's"
  +"PostalCode": "A1H0P4"
  +"UnparsedAddress": "59 Cedar Hill Place, St. John's, Newfoundland & Labrador A1H0P4"
  +"Coordinates": array:2 [
    0 => -52.816843
    1 => 47.497886
  ]
  +"Latitude": 47.497886
  +"Longitude": -52.816843
  +"YearBuilt": 2025
  +"InternetAddressDisplayYN": true
  +"FeedTypes": "IDX"
  +"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
  +"PublicRemarks": "Backing on green space with southern exposure, 59 Cedar Hill Place offers modern design and an exceptional setting in River's Edge–Southlands, one of St. John's most desirable communities. Built in 2025, this beautifully finished semi-detached home features a bright open-concept main floor with spacious living and dining areas and stunning kitchen complete with walk-in pantry. A convenient powder room completes the main level. Upstairs, the spacious primary suite includes a spacious walk-in closet and a well-appointed ensuite featuring a custom tiled shower and soaker tub. Two additional bedrooms, a full bathroom, and second-floor laundry with laundry sink provide comfortable and practical living space for families and professionals alike. Designed for energy efficiency, the home features R-50 attic insulation, R-22 wall insulation, Low-E Argon windows, and two-head mini-split heat pump. Average energy costs were approximately $265 per month over the past 12 months. The undeveloped basement offers excellent potential for future development, whether as additional living space, a home office, gym, or recreation room. Outside, enjoy a fully landscaped lot, paved driveway, rear deck overlooking open space, and smart exterior lighting including WiFi-controlled pot lights, main entrance lights, and seasonal accent lighting. Additional features include a vented range hood, garage door opener and Google Nest doorbell. All appliances are included. River's Edge offers direct access to the Grand Concourse trail system and is just minutes from Costco, Galway shopping, restaurants, Glendenning Golf Course, downtown St. John's, Pitts Memorial Drive, and the Outer Ring Road. Modern construction, energy-efficient design, and an outstanding location combine to create a rare opportunity in one of St. John's most sought-after neighbourhoods. There will be no conveyance of any written offers before 5pm on Wednesday, June 17, 2026. All offers to remain open until 9pm on the same date. (id:62650)"
  +"Appliances": array:5 [
    0 => "Washer"
    1 => "Refrigerator"
    2 => "Dishwasher"
    3 => "Stove"
    4 => "Dryer"
  ]
  +"ArchitecturalStyle": array:1 [
    0 => "2 Level"
  ]
  +"BathroomsPartial": 1
  +"CreationDate": "2026-06-12T19:03:36.011174+00:00"
  +"ExteriorFeatures": array:1 [
    0 => "Vinyl siding"
  ]
  +"Flooring": array:4 [
    0 => "Laminate"
    1 => "Marble"
    2 => "Carpeted"
    3 => "Ceramic"
  ]
  +"FoundationDetails": array:1 [
    0 => "Poured Concrete"
  ]
  +"Heating": array:3 [
    0 => "Baseboard heaters"
    1 => "Electric"
    2 => "Mini-Split"
  ]
  +"InternetEntireListingDisplayYN": true
  +"ListAgentKey": "1991222"
  +"ListOfficeKey": "88542"
  +"LivingAreaUnits": "square feet"
  +"LotSizeDimensions": "32'x113'"
  +"ParkingFeatures": array:1 [
    0 => "Garage"
  ]
  +"PhotosChangeTimestamp": "2026-06-12T18:03:00Z"
  +"PhotosCount": 32
  +"PropertyAttachedYN": true
  +"Sewer": array:1 [
    0 => "Municipal sewage system"
  ]
  +"StateOrProvince": "Newfoundland & Labrador"
  +"StatusChangeTimestamp": "2026-06-12T18:52:57Z"
  +"Stories": "2.0"
  +"StreetName": "Cedar Hill"
  +"StreetNumber": "59"
  +"StreetSuffix": "Place"
  +"TaxAnnualAmount": "3534"
  +"WaterSource": array:1 [
    0 => "Municipal water"
  ]
  +"Rooms": array:12 [
    0 => array:11 [
      "RoomKey" => "1657901672"
      "RoomType" => "Ensuite"
      "ListingId" => "1298886"
      "RoomLevel" => "Second level"
      "RoomWidth" => null
      "ListingKey" => "29896609"
      "RoomLength" => null
      "RoomDimensions" => "3PC"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-12T18:52:57.61Z"
    ]
    1 => array:11 [
      "RoomKey" => "1657901673"
      "RoomType" => "Bath (# pieces 1-6)"
      "ListingId" => "1298886"
      "RoomLevel" => "Second level"
      "RoomWidth" => null
      "ListingKey" => "29896609"
      "RoomLength" => null
      "RoomDimensions" => "4PC"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-12T18:52:57.61Z"
    ]
    2 => array:11 [
      "RoomKey" => "1657901674"
      "RoomType" => "Laundry room"
      "ListingId" => "1298886"
      "RoomLevel" => "Second level"
      "RoomWidth" => null
      "ListingKey" => "29896609"
      "RoomLength" => null
      "RoomDimensions" => "7'7""x5'0"""
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-12T18:52:57.61Z"
    ]
    3 => array:11 [
      "RoomKey" => "1657901675"
      "RoomType" => "Bedroom"
      "ListingId" => "1298886"
      "RoomLevel" => "Second level"
      "RoomWidth" => null
      "ListingKey" => "29896609"
      "RoomLength" => null
      "RoomDimensions" => "10'5""x12'2"""
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-12T18:52:57.61Z"
    ]
    4 => array:11 [
      "RoomKey" => "1657901676"
      "RoomType" => "Bedroom"
      "ListingId" => "1298886"
      "RoomLevel" => "Second level"
      "RoomWidth" => null
      "ListingKey" => "29896609"
      "RoomLength" => null
      "RoomDimensions" => "10'3""x10'7"""
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-12T18:52:57.61Z"
    ]
    5 => array:11 [
      "RoomKey" => "1657901677"
      "RoomType" => "Primary Bedroom"
      "ListingId" => "1298886"
      "RoomLevel" => "Second level"
      "RoomWidth" => null
      "ListingKey" => "29896609"
      "RoomLength" => null
      "RoomDimensions" => "15'5""x12'0"""
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-12T18:52:57.62Z"
    ]
    6 => array:11 [
      "RoomKey" => "1657901678"
      "RoomType" => "Bath (# pieces 1-6)"
      "ListingId" => "1298886"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29896609"
      "RoomLength" => null
      "RoomDimensions" => "2PC"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-12T18:52:57.62Z"
    ]
    7 => array:11 [
      "RoomKey" => "1657901679"
      "RoomType" => "Not known"
      "ListingId" => "1298886"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29896609"
      "RoomLength" => null
      "RoomDimensions" => "5'10""x4'6"""
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-12T18:52:57.62Z"
    ]
    8 => array:11 [
      "RoomKey" => "1657901680"
      "RoomType" => "Kitchen"
      "ListingId" => "1298886"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29896609"
      "RoomLength" => null
      "RoomDimensions" => "9'9""x10'1"""
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-12T18:52:57.62Z"
    ]
    9 => array:11 [
      "RoomKey" => "1657901681"
      "RoomType" => "Dining room"
      "ListingId" => "1298886"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29896609"
      "RoomLength" => null
      "RoomDimensions" => "9'8""x9'10"""
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-12T18:52:57.62Z"
    ]
    10 => array:11 [
      "RoomKey" => "1657901682"
      "RoomType" => "Living room"
      "ListingId" => "1298886"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29896609"
      "RoomLength" => null
      "RoomDimensions" => "11'3""x17'7"""
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-12T18:52:57.62Z"
    ]
    11 => array:11 [
      "RoomKey" => "1657901683"
      "RoomType" => "Foyer"
      "ListingId" => "1298886"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29896609"
      "RoomLength" => null
      "RoomDimensions" => "5'4""x4'8"""
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-12T18:52:57.62Z"
    ]
  ]
  +"ListAOR": "Newfoundland & Labrador"
  +"TaxYear": 2026
  +"ListAORKey": "117"
  +"ListingURL": "www.realtor.ca/real-estate/29896609/59-cedar-hill-place-st-johns"
  +"StructureType": array:1 [
    0 => "House"
  ]
  +"CommonInterest": "Freehold"
  +"GeocodeManualYN": true
  +"ZoningDescription": "RES"
  +"BedroomsAboveGrade": 3
  +"BedroomsBelowGrade": 0
  +"OriginalEntryTimestamp": "2026-06-12T18:03:00.48Z"
  +"ListAgentNationalAssociationId": "1274984"
  +"ListOfficeNationalAssociationId": "1007277"
  +"Media": array:32 [
    0 => array:13 [
      "Order" => 1
      "MediaKey" => "29896609_4890_1"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/5018ee5fefeee7669e20b4b6e207654d.webp"
      "MediaSize" => 259203
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-5018ee5fefeee7669e20b4b6e207654d.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => true
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    1 => array:13 [
      "Order" => 2
      "MediaKey" => "29896609_4890_2"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/f257e9d8896231b05a1d83f2909c1194.webp"
      "MediaSize" => 195905
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-f257e9d8896231b05a1d83f2909c1194.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    2 => array:13 [
      "Order" => 3
      "MediaKey" => "29896609_4890_3"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/196c38a1b3d8c367eeb258b9ad54598e.webp"
      "MediaSize" => 253042
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-196c38a1b3d8c367eeb258b9ad54598e.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    3 => array:13 [
      "Order" => 4
      "MediaKey" => "29896609_4890_4"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/4d7c086435289ce07e9cacd759525ba7.webp"
      "MediaSize" => 62336
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-4d7c086435289ce07e9cacd759525ba7.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    4 => array:13 [
      "Order" => 5
      "MediaKey" => "29896609_4890_5"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/7118254e9e1936a8ba66dd0ab0afca58.webp"
      "MediaSize" => 125790
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-7118254e9e1936a8ba66dd0ab0afca58.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    5 => array:13 [
      "Order" => 6
      "MediaKey" => "29896609_4890_6"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/1a0eb16a6490d96aa6b1c78a2989c1f4.webp"
      "MediaSize" => 145909
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-1a0eb16a6490d96aa6b1c78a2989c1f4.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    6 => array:13 [
      "Order" => 7
      "MediaKey" => "29896609_4890_7"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/198bc355738615e02ae9d08507bf6f2f.webp"
      "MediaSize" => 116519
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-198bc355738615e02ae9d08507bf6f2f.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    7 => array:13 [
      "Order" => 8
      "MediaKey" => "29896609_4890_8"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/198cec301dd1f140342dba87fb6662cc.webp"
      "MediaSize" => 126689
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-198cec301dd1f140342dba87fb6662cc.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    8 => array:13 [
      "Order" => 9
      "MediaKey" => "29896609_4890_9"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/c868fe3f6d2f92f4f70007fcd2c07b64.webp"
      "MediaSize" => 117086
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-c868fe3f6d2f92f4f70007fcd2c07b64.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    9 => array:13 [
      "Order" => 10
      "MediaKey" => "29896609_4890_10"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/9d894e7edfd2dd49195b265ccbb61607.webp"
      "MediaSize" => 88091
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-9d894e7edfd2dd49195b265ccbb61607.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    10 => array:13 [
      "Order" => 11
      "MediaKey" => "29896609_4890_11"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/71cf3f19055811e7fff3c0276513d9aa.webp"
      "MediaSize" => 142864
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-71cf3f19055811e7fff3c0276513d9aa.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    11 => array:13 [
      "Order" => 12
      "MediaKey" => "29896609_4890_12"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/829df187cb0dc7390ce48b8063ec3e3a.webp"
      "MediaSize" => 116743
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-829df187cb0dc7390ce48b8063ec3e3a.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    12 => array:13 [
      "Order" => 13
      "MediaKey" => "29896609_4890_13"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/bf6f117cbc9f0fb8f44bcca2373922d6.webp"
      "MediaSize" => 97036
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-bf6f117cbc9f0fb8f44bcca2373922d6.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    13 => array:13 [
      "Order" => 14
      "MediaKey" => "29896609_4890_14"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/64ba20cd0632e908ae9497ad3505cf95.webp"
      "MediaSize" => 116336
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-64ba20cd0632e908ae9497ad3505cf95.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    14 => array:13 [
      "Order" => 15
      "MediaKey" => "29896609_4890_15"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/649e433e502a4fb42d2c5bedf8885317.webp"
      "MediaSize" => 104992
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-649e433e502a4fb42d2c5bedf8885317.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    15 => array:13 [
      "Order" => 16
      "MediaKey" => "29896609_4890_16"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/9edd9fa97596282abaca9e1db1fa0655.webp"
      "MediaSize" => 127724
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-9edd9fa97596282abaca9e1db1fa0655.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    16 => array:13 [
      "Order" => 17
      "MediaKey" => "29896609_4890_17"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/681cfefc8fa5ea36dde19d25a0141598.webp"
      "MediaSize" => 131049
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-681cfefc8fa5ea36dde19d25a0141598.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    17 => array:13 [
      "Order" => 18
      "MediaKey" => "29896609_4890_18"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/9ef1d5389ff574126bc98eb536ff06f0.webp"
      "MediaSize" => 131987
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-9ef1d5389ff574126bc98eb536ff06f0.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    18 => array:13 [
      "Order" => 19
      "MediaKey" => "29896609_4890_19"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/9c066c520ca7a16f64138c64a0a33eb1.webp"
      "MediaSize" => 75533
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-9c066c520ca7a16f64138c64a0a33eb1.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    19 => array:13 [
      "Order" => 20
      "MediaKey" => "29896609_4890_20"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/da9b4a96540c30df5cc4661c1e5ca06c.webp"
      "MediaSize" => 108201
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-da9b4a96540c30df5cc4661c1e5ca06c.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    20 => array:13 [
      "Order" => 21
      "MediaKey" => "29896609_4890_21"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/8540ff088759d4b057b09f446338fc29.webp"
      "MediaSize" => 94021
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-8540ff088759d4b057b09f446338fc29.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    21 => array:13 [
      "Order" => 22
      "MediaKey" => "29896609_4890_22"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/a2382877f6c6c2f89ffe72c681b8a21a.webp"
      "MediaSize" => 100547
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-a2382877f6c6c2f89ffe72c681b8a21a.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    22 => array:13 [
      "Order" => 23
      "MediaKey" => "29896609_4890_23"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/916f0b9f96254a26bcaeed75a34bc7aa.webp"
      "MediaSize" => 63522
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-916f0b9f96254a26bcaeed75a34bc7aa.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    23 => array:13 [
      "Order" => 24
      "MediaKey" => "29896609_4890_24"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/4dabf37a58ec7702c0608389c4be29c1.webp"
      "MediaSize" => 101967
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-4dabf37a58ec7702c0608389c4be29c1.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    24 => array:13 [
      "Order" => 25
      "MediaKey" => "29896609_4890_25"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/60dbad9d9be46c7c0c2c519c994d58db.webp"
      "MediaSize" => 76985
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-60dbad9d9be46c7c0c2c519c994d58db.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    25 => array:13 [
      "Order" => 26
      "MediaKey" => "29896609_4890_26"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/7669c86e52e7d1625e44b11c673d28de.webp"
      "MediaSize" => 100596
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-7669c86e52e7d1625e44b11c673d28de.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    26 => array:13 [
      "Order" => 27
      "MediaKey" => "29896609_4890_27"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/7c7fe5db121889208e45908eb12a3f98.webp"
      "MediaSize" => 94854
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-7c7fe5db121889208e45908eb12a3f98.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    27 => array:13 [
      "Order" => 28
      "MediaKey" => "29896609_4890_28"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/4f50db22ce49c27cd833f71cfd4a293d.webp"
      "MediaSize" => 262227
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-4f50db22ce49c27cd833f71cfd4a293d.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    28 => array:13 [
      "Order" => 29
      "MediaKey" => "29896609_4890_29"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/fe97c0f12091b7cd15da793e3dd9ff1a.webp"
      "MediaSize" => 303822
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-fe97c0f12091b7cd15da793e3dd9ff1a.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    29 => array:13 [
      "Order" => 30
      "MediaKey" => "29896609_4890_30"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/c179eb4f383d5b54adfa5f60e7fddb68.webp"
      "MediaSize" => 285016
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-c179eb4f383d5b54adfa5f60e7fddb68.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    30 => array:13 [
      "Order" => 31
      "MediaKey" => "29896609_4890_31"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/b79a319f393cc29c7c25c75d303da5ab.webp"
      "MediaSize" => 336425
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-b79a319f393cc29c7c25c75d303da5ab.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
    31 => array:13 [
      "Order" => 32
      "MediaKey" => "29896609_4890_32"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/1a9172869b5b9e7fc6aaf3b883c1906d.webp"
      "MediaSize" => 303763
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-1a9172869b5b9e7fc6aaf3b883c1906d.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "1298886"
      "ResourceRecordKey" => "29896609"
      "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
    ]
  ]
  +"DaysOnMarket": 1
  +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896609')"
  +"ID": "1525387"
}

MLS On The Fly Debug Panel

 array:6 [
  "RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29887507 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23361
      +items: array:1 [
        0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23363
          +post_id: "1520343"
          +post_author: 1
          +"ListingKey": "29887507"
          +"ListingId": "1298597"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-12T13:30:07Z"
          +"RFModificationTimestamp": "2026-06-12T13:31:58Z"
          +"ListPrice": 529900.0
          +"BathroomsTotalInteger": 3.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 4.0
          +"LotSizeArea": 0
          +"LivingArea": 2170.0
          +"BuildingAreaTotal": 0
          +"City": "St. John's"
          +"PostalCode": "A1H0A3"
          +"UnparsedAddress": "5 Brad Gushue Crescent, St. John's, Newfoundland & Labrador A1H0A3"
          +"Coordinates": array:2 [
            0 => -52.810912
            1 => 47.490827
          ]
          +"Latitude": 47.490827
          +"Longitude": -52.810912
          +"YearBuilt": 2007
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
          +"PublicRemarks": "Welcome to this beautifully renovated and fully developed home, offering a bright open-concept design with 4 bedrooms and 3 bathrooms. The spacious primary suite features a stunning remodelled 4 pc bathroom and a walk-in closet.  Extensively updated throughout, this home boasts a gorgeous new kitchen with modern cabinetry, an updated main bathroom vanity and faucet, new flooring, upgraded stairs and railings, stylish light fixtures, new door hardware, updated switches and outlets, custom closet organizers, new thermostats, and the added comfort and efficiency of two new mini-split heat pumps. Outside, you'll find equally impressive improvements including newly paved driveway with convenient rear yard access to a newly constructed 12' x 14' garage, along with new fencing and updated flower planters that enhance the property's curb appeal. As per Seller's Direction, no offers will be presented prior to 2 pm, Monday, June 15, 2026. All offers  to remain open for acceptance until 7 p.m. the same day. (id:62650)"
          +"Appliances": array:2 [
            0 => "Dishwasher"
            1 => "Microwave"
          ]
          +"BathroomsPartial": 1
          +"CreationDate": "2026-06-11T16:05:57.585285+00:00"
          +"ExteriorFeatures": array:1 [
            0 => "Vinyl siding"
          ]
          +"Fencing": array:1 [
            0 => "Fence"
          ]
          +"Flooring": array:2 [
            0 => "Laminate"
            1 => "Mixed Flooring"
          ]
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:3 [
            0 => "Baseboard heaters"
            1 => "Electric"
            2 => "Mini-Split"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "1571729"
          +"ListOfficeKey": "88542"
          +"LivingAreaUnits": "square feet"
          +"LotSizeDimensions": "50 x 105"
          +"ParkingFeatures": array:2 [
            0 => "Attached Garage"
            1 => "Detached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-12T13:20:29Z"
          +"PhotosCount": 26
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Newfoundland & Labrador"
          +"StatusChangeTimestamp": "2026-06-12T13:20:29Z"
          +"Stories": "1.0"
          +"StreetName": "Brad Gushue"
          +"StreetNumber": "5"
          +"StreetSuffix": "Crescent"
          +"TaxAnnualAmount": "3330"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:12 [
            0 => array:11 [
              "RoomKey" => "1657668499"
              "RoomType" => "Storage"
              "ListingId" => "1298597"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "29887507"
              "RoomLength" => null
              "RoomDimensions" => "11.6 x 10.2"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T13:02:53.44Z"
            ]
            1 => array:11 [
              "RoomKey" => "1657668500"
              "RoomType" => "Laundry room"
              "ListingId" => "1298597"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "29887507"
              "RoomLength" => null
              "RoomDimensions" => "11.6 x 8.2"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T13:02:53.44Z"
            ]
            2 => array:11 [
              "RoomKey" => "1657668501"
              "RoomType" => "Bath (# pieces 1-6)"
              "ListingId" => "1298597"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "29887507"
              "RoomLength" => null
              "RoomDimensions" => "2 pc"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T13:02:53.44Z"
            ]
            3 => array:11 [
              "RoomKey" => "1657668502"
              "RoomType" => "Family room"
              "ListingId" => "1298597"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "29887507"
              "RoomLength" => null
              "RoomDimensions" => "24 x 11.6"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T13:02:53.44Z"
            ]
            4 => array:11 [
              "RoomKey" => "1657668503"
              "RoomType" => "Bedroom"
              "ListingId" => "1298597"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "29887507"
              "RoomLength" => null
              "RoomDimensions" => "11.9 x 11"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T13:02:53.44Z"
            ]
            5 => array:11 [
              "RoomKey" => "1657668504"
              "RoomType" => "Bedroom"
              "ListingId" => "1298597"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29887507"
              "RoomLength" => null
              "RoomDimensions" => "14 x 8.4"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T13:02:53.44Z"
            ]
            6 => array:11 [
              "RoomKey" => "1657668505"
              "RoomType" => "Bedroom"
              "ListingId" => "1298597"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29887507"
              "RoomLength" => null
              "RoomDimensions" => "8.9 x 13.4"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T13:02:53.45Z"
            ]
            7 => array:11 [
              "RoomKey" => "1657668506"
              "RoomType" => "Ensuite"
              "ListingId" => "1298597"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29887507"
              "RoomLength" => null
              "RoomDimensions" => "9 x 9 - 4 pc"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T13:02:53.45Z"
            ]
            8 => array:11 [
              "RoomKey" => "1657668507"
              "RoomType" => "Primary Bedroom"
              "ListingId" => "1298597"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29887507"
              "RoomLength" => null
              "RoomDimensions" => "12 x 13.9"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T13:02:53.45Z"
            ]
            9 => array:11 [
              "RoomKey" => "1657668508"
              "RoomType" => "Living room/Dining room"
              "ListingId" => "1298597"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29887507"
              "RoomLength" => null
              "RoomDimensions" => "11.5 x 23"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T13:02:53.45Z"
            ]
            10 => array:11 [
              "RoomKey" => "1657668509"
              "RoomType" => "Kitchen"
              "ListingId" => "1298597"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29887507"
              "RoomLength" => null
              "RoomDimensions" => "15 x 17"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T13:02:53.45Z"
            ]
            11 => array:11 [
              "RoomKey" => "1657668510"
              "RoomType" => "Porch"
              "ListingId" => "1298597"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29887507"
              "RoomLength" => null
              "RoomDimensions" => "4.7 x 5.9"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T13:02:53.45Z"
            ]
          ]
          +"ListAOR": "Newfoundland & Labrador"
          +"TaxYear": 2026
          +"ListAORKey": "117"
          +"ListingURL": "www.realtor.ca/real-estate/29887507/5-brad-gushue-crescent-st-johns"
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"ZoningDescription": "Residential"
          +"BedroomsAboveGrade": 3
          +"BedroomsBelowGrade": 1
          +"OriginalEntryTimestamp": "2026-06-11T12:53:13.68Z"
          +"ListAgentNationalAssociationId": "1033672"
          +"ListOfficeNationalAssociationId": "1007277"
          +"Media": array:26 [
            0 => array:13 [
              "Order" => 2
              "MediaKey" => "29887507_4890_2"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/955dfca986f161498d49a06e67524f3b.webp"
              "MediaSize" => 112167
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-955dfca986f161498d49a06e67524f3b.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Driving Access to Rear"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:22.71Z"
            ]
            1 => array:13 [
              "Order" => 3
              "MediaKey" => "29887507_4890_3"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/e0f5acf863ab57378ce80d54e3d91044.webp"
              "MediaSize" => 216232
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-e0f5acf863ab57378ce80d54e3d91044.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "12 x 14 Garage with driving access"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:28.48Z"
            ]
            2 => array:13 [
              "Order" => 4
              "MediaKey" => "29887507_4890_4"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/433aa7919ba164a9de843f49a31d38ce.webp"
              "MediaSize" => 238241
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-433aa7919ba164a9de843f49a31d38ce.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Back Deck View"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:26.62Z"
            ]
            3 => array:13 [
              "Order" => 5
              "MediaKey" => "29887507_4890_5"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/81c41e6fc938525a342d78ee72070a42.webp"
              "MediaSize" => 318105
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-81c41e6fc938525a342d78ee72070a42.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Back yard fenced"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:31.03Z"
            ]
            4 => array:13 [
              "Order" => 6
              "MediaKey" => "29887507_4890_6"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/79afb8b15093a0545c1eee16e2aa99c9.webp"
              "MediaSize" => 84422
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-79afb8b15093a0545c1eee16e2aa99c9.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Front Entry"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:26.67Z"
            ]
            5 => array:13 [
              "Order" => 7
              "MediaKey" => "29887507_4890_7"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/6d4e9dd297fca05cdf8b522e0cd5647a.webp"
              "MediaSize" => 142062
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-6d4e9dd297fca05cdf8b522e0cd5647a.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Front Entry"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:31.22Z"
            ]
            6 => array:13 [
              "Order" => 8
              "MediaKey" => "29887507_4890_8"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/b33e00418800c546c8eec929e1832c32.webp"
              "MediaSize" => 105387
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-b33e00418800c546c8eec929e1832c32.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Front stairs"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:26.75Z"
            ]
            7 => array:13 [
              "Order" => 9
              "MediaKey" => "29887507_4890_9"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/441a336d595915f1ed6ba54932937d21.webp"
              "MediaSize" => 126547
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-441a336d595915f1ed6ba54932937d21.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Main Floor Hallway"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:31.2Z"
            ]
            8 => array:13 [
              "Order" => 10
              "MediaKey" => "29887507_4890_10"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/73d8a94c7697dd484838de77ac744b41.webp"
              "MediaSize" => 92983
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-73d8a94c7697dd484838de77ac744b41.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Dining and Living Area"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:20.5Z"
            ]
            9 => array:13 [
              "Order" => 11
              "MediaKey" => "29887507_4890_11"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/8ae9163c40e5b1baaff762ce24603a43.webp"
              "MediaSize" => 140963
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-8ae9163c40e5b1baaff762ce24603a43.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Living Room"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:22.56Z"
            ]
            10 => array:13 [
              "Order" => 12
              "MediaKey" => "29887507_4890_12"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/a0a10d93f5f6d2717f8bb5fd3ff33c5c.webp"
              "MediaSize" => 130871
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-a0a10d93f5f6d2717f8bb5fd3ff33c5c.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:22.36Z"
            ]
            11 => array:13 [
              "Order" => 13
              "MediaKey" => "29887507_4890_13"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/d22f2276ccffd57ca8d8b1122e41a6e4.webp"
              "MediaSize" => 139682
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-d22f2276ccffd57ca8d8b1122e41a6e4.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Kitchen"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:22.34Z"
            ]
            12 => array:13 [
              "Order" => 14
              "MediaKey" => "29887507_4890_14"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/db5c6f7926158e81e02682bff30f40a0.webp"
              "MediaSize" => 116525
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-db5c6f7926158e81e02682bff30f40a0.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Primary Bedroom - AI staged"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:22.7Z"
            ]
            13 => array:13 [
              "Order" => 15
              "MediaKey" => "29887507_4890_15"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/19c697471b5bc35fc1fc02cfc08c3453.webp"
              "MediaSize" => 95393
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-19c697471b5bc35fc1fc02cfc08c3453.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Primary Walk in closet and Ensuite bath"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:22.53Z"
            ]
            14 => array:13 [
              "Order" => 16
              "MediaKey" => "29887507_4890_16"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/e540ce56a2b09296a56a4dd6849d84ae.webp"
              "MediaSize" => 98502
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-e540ce56a2b09296a56a4dd6849d84ae.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Ensuite Bath"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:22.53Z"
            ]
            15 => array:13 [
              "Order" => 17
              "MediaKey" => "29887507_4890_17"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/15d7a06409f9aa8d7efedaf550bf2edb.webp"
              "MediaSize" => 137229
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-15d7a06409f9aa8d7efedaf550bf2edb.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Bedroom 2"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:22.56Z"
            ]
            16 => array:13 [
              "Order" => 18
              "MediaKey" => "29887507_4890_18"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/08367bebeeec8c03665eeb3b3299da5a.webp"
              "MediaSize" => 126207
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-08367bebeeec8c03665eeb3b3299da5a.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Bedroom 3"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:22.74Z"
            ]
            17 => array:13 [
              "Order" => 19
              "MediaKey" => "29887507_4890_19"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/d6470f6072f78d4816edc9de3efcb1e1.webp"
              "MediaSize" => 102811
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-d6470f6072f78d4816edc9de3efcb1e1.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Main Bath"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:22.72Z"
            ]
            18 => array:13 [
              "Order" => 20
              "MediaKey" => "29887507_4890_20"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/bcfe49eaeba13eea430b2353e3ec8c70.webp"
              "MediaSize" => 121810
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-bcfe49eaeba13eea430b2353e3ec8c70.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Basement Hallway"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:22.44Z"
            ]
            19 => array:13 [
              "Order" => 21
              "MediaKey" => "29887507_4890_21"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/4af738f2a39d4e161951406e5e1dcb5a.webp"
              "MediaSize" => 158513
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-4af738f2a39d4e161951406e5e1dcb5a.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Basement Bedroom"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:22.89Z"
            ]
            20 => array:13 [
              "Order" => 22
              "MediaKey" => "29887507_4890_22"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/a9848a842d42118b36523f725db10657.webp"
              "MediaSize" => 85183
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-a9848a842d42118b36523f725db10657.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Basement Half Bath"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:23.96Z"
            ]
            21 => array:13 [
              "Order" => 23
              "MediaKey" => "29887507_4890_23"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/7d6fe88e5b6c75427d11308a2e977c46.webp"
              "MediaSize" => 141404
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-7d6fe88e5b6c75427d11308a2e977c46.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Basement Family Room"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:23.49Z"
            ]
            22 => array:13 [
              "Order" => 24
              "MediaKey" => "29887507_4890_24"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/01e7fa2d80ebf94c2119cb0cffd10f4d.webp"
              "MediaSize" => 140936
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-01e7fa2d80ebf94c2119cb0cffd10f4d.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Basement Laundry Room"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:24.34Z"
            ]
            23 => array:13 [
              "Order" => 25
              "MediaKey" => "29887507_4890_25"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/968a3f5ac45690a6f8f22b44f052e0aa.webp"
              "MediaSize" => 89864
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-968a3f5ac45690a6f8f22b44f052e0aa.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Main Floor Plan"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:24.39Z"
            ]
            24 => array:13 [
              "Order" => 26
              "MediaKey" => "29887507_4890_26"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/91873e0a142fdf8ec36ac8bd7c2e289e.webp"
              "MediaSize" => 81241
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-91873e0a142fdf8ec36ac8bd7c2e289e.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Basement Floor Plan"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:00:23.92Z"
            ]
            25 => array:13 [
              "Order" => 1
              "MediaKey" => "29887507_4890_1"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29887507/9f70b1d63f9d1f1466d4ed373654f9b8.webp"
              "MediaSize" => 237016
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29887507/thumbnail-9f70b1d63f9d1f1466d4ed373654f9b8.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => true
              "ResourceRecordId" => "1298597"
              "ResourceRecordKey" => "29887507"
              "ModificationTimestamp" => "2026-06-12T13:20:19.23Z"
            ]
          ]
          +"DaysOnMarket": 2
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29887507')"
          +"ID": "1520343"
        }
      ]
      +success: true
      +page_size: 1
      +page_count: 1
      +count: 1
      +after_key: ""
    }
    "RF Response Time" => "0.12 seconds"
  ]
  "RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 88542" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24776
      +items: []
      +success: true
      +page_size: 0
      +page_count: 0
      +count: 0
      +after_key: ""
    }
    "RF Response Time" => "0.1 seconds"
  ]
  "RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1571729" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24749
      +items: []
      +success: true
      +page_size: 0
      +page_count: 0
      +count: 0
      +after_key: ""
    }
    "RF Response Time" => "0.1 seconds"
  ]
  "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29887507'" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25076
      +items: []
      +success: true
      +page_size: 0
      +page_count: 0
      +count: 0
      +after_key: ""
    }
    "RF Response Time" => "0.1 seconds"
  ]
  "RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29887507'" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25092
      +items: []
      +success: true
      +page_size: 0
      +page_count: 0
      +count: 0
      +after_key: ""
    }
    "RF Response Time" => "0.12 seconds"
  ]
  "RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29887507' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-52.810912 47.490827)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25145
      +items: array:9 [
        0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25139
          +post_id: "1525387"
          +post_author: 1
          +"ListingKey": "29896609"
          +"ListingId": "1298886"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-12T19:00:09Z"
          +"RFModificationTimestamp": "2026-06-12T19:03:41Z"
          +"ListPrice": 459900.0
          +"BathroomsTotalInteger": 3.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 3.0
          +"LotSizeArea": 0
          +"LivingArea": 2175.0
          +"BuildingAreaTotal": 0
          +"City": "St. John's"
          +"PostalCode": "A1H0P4"
          +"UnparsedAddress": "59 Cedar Hill Place, St. John's, Newfoundland & Labrador A1H0P4"
          +"Coordinates": array:2 [
            0 => -52.816843
            1 => 47.497886
          ]
          +"Latitude": 47.497886
          +"Longitude": -52.816843
          +"YearBuilt": 2025
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
          +"PublicRemarks": "Backing on green space with southern exposure, 59 Cedar Hill Place offers modern design and an exceptional setting in River's Edge–Southlands, one of St. John's most desirable communities. Built in 2025, this beautifully finished semi-detached home features a bright open-concept main floor with spacious living and dining areas and stunning kitchen complete with walk-in pantry. A convenient powder room completes the main level. Upstairs, the spacious primary suite includes a spacious walk-in closet and a well-appointed ensuite featuring a custom tiled shower and soaker tub. Two additional bedrooms, a full bathroom, and second-floor laundry with laundry sink provide comfortable and practical living space for families and professionals alike. Designed for energy efficiency, the home features R-50 attic insulation, R-22 wall insulation, Low-E Argon windows, and two-head mini-split heat pump. Average energy costs were approximately $265 per month over the past 12 months. The undeveloped basement offers excellent potential for future development, whether as additional living space, a home office, gym, or recreation room. Outside, enjoy a fully landscaped lot, paved driveway, rear deck overlooking open space, and smart exterior lighting including WiFi-controlled pot lights, main entrance lights, and seasonal accent lighting. Additional features include a vented range hood, garage door opener and Google Nest doorbell. All appliances are included. River's Edge offers direct access to the Grand Concourse trail system and is just minutes from Costco, Galway shopping, restaurants, Glendenning Golf Course, downtown St. John's, Pitts Memorial Drive, and the Outer Ring Road. Modern construction, energy-efficient design, and an outstanding location combine to create a rare opportunity in one of St. John's most sought-after neighbourhoods. There will be no conveyance of any written offers before 5pm on Wednesday, June 17, 2026. All offers to remain open until 9pm on the same date. (id:62650)"
          +"Appliances": array:5 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Dishwasher"
            3 => "Stove"
            4 => "Dryer"
          ]
          +"ArchitecturalStyle": array:1 [
            0 => "2 Level"
          ]
          +"BathroomsPartial": 1
          +"CreationDate": "2026-06-12T19:03:36.011174+00:00"
          +"ExteriorFeatures": array:1 [
            0 => "Vinyl siding"
          ]
          +"Flooring": array:4 [
            0 => "Laminate"
            1 => "Marble"
            2 => "Carpeted"
            3 => "Ceramic"
          ]
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:3 [
            0 => "Baseboard heaters"
            1 => "Electric"
            2 => "Mini-Split"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "1991222"
          +"ListOfficeKey": "88542"
          +"LivingAreaUnits": "square feet"
          +"LotSizeDimensions": "32'x113'"
          +"ParkingFeatures": array:1 [
            0 => "Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-12T18:03:00Z"
          +"PhotosCount": 32
          +"PropertyAttachedYN": true
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Newfoundland & Labrador"
          +"StatusChangeTimestamp": "2026-06-12T18:52:57Z"
          +"Stories": "2.0"
          +"StreetName": "Cedar Hill"
          +"StreetNumber": "59"
          +"StreetSuffix": "Place"
          +"TaxAnnualAmount": "3534"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:12 [
            0 => array:11 [
              "RoomKey" => "1657901672"
              "RoomType" => "Ensuite"
              "ListingId" => "1298886"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29896609"
              "RoomLength" => null
              "RoomDimensions" => "3PC"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T18:52:57.61Z"
            ]
            1 => array:11 [
              "RoomKey" => "1657901673"
              "RoomType" => "Bath (# pieces 1-6)"
              "ListingId" => "1298886"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29896609"
              "RoomLength" => null
              "RoomDimensions" => "4PC"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T18:52:57.61Z"
            ]
            2 => array:11 [
              "RoomKey" => "1657901674"
              "RoomType" => "Laundry room"
              "ListingId" => "1298886"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29896609"
              "RoomLength" => null
              "RoomDimensions" => "7'7""x5'0"""
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T18:52:57.61Z"
            ]
            3 => array:11 [
              "RoomKey" => "1657901675"
              "RoomType" => "Bedroom"
              "ListingId" => "1298886"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29896609"
              "RoomLength" => null
              "RoomDimensions" => "10'5""x12'2"""
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T18:52:57.61Z"
            ]
            4 => array:11 [
              "RoomKey" => "1657901676"
              "RoomType" => "Bedroom"
              "ListingId" => "1298886"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29896609"
              "RoomLength" => null
              "RoomDimensions" => "10'3""x10'7"""
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T18:52:57.61Z"
            ]
            5 => array:11 [
              "RoomKey" => "1657901677"
              "RoomType" => "Primary Bedroom"
              "ListingId" => "1298886"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29896609"
              "RoomLength" => null
              "RoomDimensions" => "15'5""x12'0"""
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T18:52:57.62Z"
            ]
            6 => array:11 [
              "RoomKey" => "1657901678"
              "RoomType" => "Bath (# pieces 1-6)"
              "ListingId" => "1298886"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29896609"
              "RoomLength" => null
              "RoomDimensions" => "2PC"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T18:52:57.62Z"
            ]
            7 => array:11 [
              "RoomKey" => "1657901679"
              "RoomType" => "Not known"
              "ListingId" => "1298886"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29896609"
              "RoomLength" => null
              "RoomDimensions" => "5'10""x4'6"""
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T18:52:57.62Z"
            ]
            8 => array:11 [
              "RoomKey" => "1657901680"
              "RoomType" => "Kitchen"
              "ListingId" => "1298886"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29896609"
              "RoomLength" => null
              "RoomDimensions" => "9'9""x10'1"""
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T18:52:57.62Z"
            ]
            9 => array:11 [
              "RoomKey" => "1657901681"
              "RoomType" => "Dining room"
              "ListingId" => "1298886"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29896609"
              "RoomLength" => null
              "RoomDimensions" => "9'8""x9'10"""
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T18:52:57.62Z"
            ]
            10 => array:11 [
              "RoomKey" => "1657901682"
              "RoomType" => "Living room"
              "ListingId" => "1298886"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29896609"
              "RoomLength" => null
              "RoomDimensions" => "11'3""x17'7"""
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T18:52:57.62Z"
            ]
            11 => array:11 [
              "RoomKey" => "1657901683"
              "RoomType" => "Foyer"
              "ListingId" => "1298886"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29896609"
              "RoomLength" => null
              "RoomDimensions" => "5'4""x4'8"""
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-12T18:52:57.62Z"
            ]
          ]
          +"ListAOR": "Newfoundland & Labrador"
          +"TaxYear": 2026
          +"ListAORKey": "117"
          +"ListingURL": "www.realtor.ca/real-estate/29896609/59-cedar-hill-place-st-johns"
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"ZoningDescription": "RES"
          +"BedroomsAboveGrade": 3
          +"BedroomsBelowGrade": 0
          +"OriginalEntryTimestamp": "2026-06-12T18:03:00.48Z"
          +"ListAgentNationalAssociationId": "1274984"
          +"ListOfficeNationalAssociationId": "1007277"
          +"Media": array:32 [
            0 => array:13 [
              "Order" => 1
              "MediaKey" => "29896609_4890_1"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/5018ee5fefeee7669e20b4b6e207654d.webp"
              "MediaSize" => 259203
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-5018ee5fefeee7669e20b4b6e207654d.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => true
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            1 => array:13 [
              "Order" => 2
              "MediaKey" => "29896609_4890_2"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/f257e9d8896231b05a1d83f2909c1194.webp"
              "MediaSize" => 195905
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-f257e9d8896231b05a1d83f2909c1194.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            2 => array:13 [
              "Order" => 3
              "MediaKey" => "29896609_4890_3"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/196c38a1b3d8c367eeb258b9ad54598e.webp"
              "MediaSize" => 253042
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-196c38a1b3d8c367eeb258b9ad54598e.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            3 => array:13 [
              "Order" => 4
              "MediaKey" => "29896609_4890_4"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/4d7c086435289ce07e9cacd759525ba7.webp"
              "MediaSize" => 62336
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-4d7c086435289ce07e9cacd759525ba7.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            4 => array:13 [
              "Order" => 5
              "MediaKey" => "29896609_4890_5"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/7118254e9e1936a8ba66dd0ab0afca58.webp"
              "MediaSize" => 125790
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-7118254e9e1936a8ba66dd0ab0afca58.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            5 => array:13 [
              "Order" => 6
              "MediaKey" => "29896609_4890_6"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/1a0eb16a6490d96aa6b1c78a2989c1f4.webp"
              "MediaSize" => 145909
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-1a0eb16a6490d96aa6b1c78a2989c1f4.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            6 => array:13 [
              "Order" => 7
              "MediaKey" => "29896609_4890_7"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/198bc355738615e02ae9d08507bf6f2f.webp"
              "MediaSize" => 116519
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-198bc355738615e02ae9d08507bf6f2f.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            7 => array:13 [
              "Order" => 8
              "MediaKey" => "29896609_4890_8"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/198cec301dd1f140342dba87fb6662cc.webp"
              "MediaSize" => 126689
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-198cec301dd1f140342dba87fb6662cc.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            8 => array:13 [
              "Order" => 9
              "MediaKey" => "29896609_4890_9"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/c868fe3f6d2f92f4f70007fcd2c07b64.webp"
              "MediaSize" => 117086
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-c868fe3f6d2f92f4f70007fcd2c07b64.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            9 => array:13 [
              "Order" => 10
              "MediaKey" => "29896609_4890_10"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/9d894e7edfd2dd49195b265ccbb61607.webp"
              "MediaSize" => 88091
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-9d894e7edfd2dd49195b265ccbb61607.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            10 => array:13 [
              "Order" => 11
              "MediaKey" => "29896609_4890_11"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/71cf3f19055811e7fff3c0276513d9aa.webp"
              "MediaSize" => 142864
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-71cf3f19055811e7fff3c0276513d9aa.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            11 => array:13 [
              "Order" => 12
              "MediaKey" => "29896609_4890_12"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/829df187cb0dc7390ce48b8063ec3e3a.webp"
              "MediaSize" => 116743
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-829df187cb0dc7390ce48b8063ec3e3a.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            12 => array:13 [
              "Order" => 13
              "MediaKey" => "29896609_4890_13"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/bf6f117cbc9f0fb8f44bcca2373922d6.webp"
              "MediaSize" => 97036
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-bf6f117cbc9f0fb8f44bcca2373922d6.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            13 => array:13 [
              "Order" => 14
              "MediaKey" => "29896609_4890_14"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/64ba20cd0632e908ae9497ad3505cf95.webp"
              "MediaSize" => 116336
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-64ba20cd0632e908ae9497ad3505cf95.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            14 => array:13 [
              "Order" => 15
              "MediaKey" => "29896609_4890_15"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/649e433e502a4fb42d2c5bedf8885317.webp"
              "MediaSize" => 104992
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-649e433e502a4fb42d2c5bedf8885317.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            15 => array:13 [
              "Order" => 16
              "MediaKey" => "29896609_4890_16"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/9edd9fa97596282abaca9e1db1fa0655.webp"
              "MediaSize" => 127724
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-9edd9fa97596282abaca9e1db1fa0655.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            16 => array:13 [
              "Order" => 17
              "MediaKey" => "29896609_4890_17"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/681cfefc8fa5ea36dde19d25a0141598.webp"
              "MediaSize" => 131049
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-681cfefc8fa5ea36dde19d25a0141598.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            17 => array:13 [
              "Order" => 18
              "MediaKey" => "29896609_4890_18"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/9ef1d5389ff574126bc98eb536ff06f0.webp"
              "MediaSize" => 131987
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-9ef1d5389ff574126bc98eb536ff06f0.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            18 => array:13 [
              "Order" => 19
              "MediaKey" => "29896609_4890_19"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/9c066c520ca7a16f64138c64a0a33eb1.webp"
              "MediaSize" => 75533
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-9c066c520ca7a16f64138c64a0a33eb1.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            19 => array:13 [
              "Order" => 20
              "MediaKey" => "29896609_4890_20"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/da9b4a96540c30df5cc4661c1e5ca06c.webp"
              "MediaSize" => 108201
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-da9b4a96540c30df5cc4661c1e5ca06c.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            20 => array:13 [
              "Order" => 21
              "MediaKey" => "29896609_4890_21"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/8540ff088759d4b057b09f446338fc29.webp"
              "MediaSize" => 94021
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-8540ff088759d4b057b09f446338fc29.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            21 => array:13 [
              "Order" => 22
              "MediaKey" => "29896609_4890_22"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/a2382877f6c6c2f89ffe72c681b8a21a.webp"
              "MediaSize" => 100547
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-a2382877f6c6c2f89ffe72c681b8a21a.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            22 => array:13 [
              "Order" => 23
              "MediaKey" => "29896609_4890_23"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/916f0b9f96254a26bcaeed75a34bc7aa.webp"
              "MediaSize" => 63522
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-916f0b9f96254a26bcaeed75a34bc7aa.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            23 => array:13 [
              "Order" => 24
              "MediaKey" => "29896609_4890_24"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/4dabf37a58ec7702c0608389c4be29c1.webp"
              "MediaSize" => 101967
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-4dabf37a58ec7702c0608389c4be29c1.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            24 => array:13 [
              "Order" => 25
              "MediaKey" => "29896609_4890_25"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/60dbad9d9be46c7c0c2c519c994d58db.webp"
              "MediaSize" => 76985
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-60dbad9d9be46c7c0c2c519c994d58db.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            25 => array:13 [
              "Order" => 26
              "MediaKey" => "29896609_4890_26"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/7669c86e52e7d1625e44b11c673d28de.webp"
              "MediaSize" => 100596
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-7669c86e52e7d1625e44b11c673d28de.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            26 => array:13 [
              "Order" => 27
              "MediaKey" => "29896609_4890_27"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/7c7fe5db121889208e45908eb12a3f98.webp"
              "MediaSize" => 94854
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-7c7fe5db121889208e45908eb12a3f98.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            27 => array:13 [
              "Order" => 28
              "MediaKey" => "29896609_4890_28"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/4f50db22ce49c27cd833f71cfd4a293d.webp"
              "MediaSize" => 262227
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-4f50db22ce49c27cd833f71cfd4a293d.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            28 => array:13 [
              "Order" => 29
              "MediaKey" => "29896609_4890_29"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/fe97c0f12091b7cd15da793e3dd9ff1a.webp"
              "MediaSize" => 303822
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-fe97c0f12091b7cd15da793e3dd9ff1a.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            29 => array:13 [
              "Order" => 30
              "MediaKey" => "29896609_4890_30"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/c179eb4f383d5b54adfa5f60e7fddb68.webp"
              "MediaSize" => 285016
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-c179eb4f383d5b54adfa5f60e7fddb68.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            30 => array:13 [
              "Order" => 31
              "MediaKey" => "29896609_4890_31"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/b79a319f393cc29c7c25c75d303da5ab.webp"
              "MediaSize" => 336425
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-b79a319f393cc29c7c25c75d303da5ab.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
            31 => array:13 [
              "Order" => 32
              "MediaKey" => "29896609_4890_32"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29896609/1a9172869b5b9e7fc6aaf3b883c1906d.webp"
              "MediaSize" => 303763
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29896609/thumbnail-1a9172869b5b9e7fc6aaf3b883c1906d.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "1298886"
              "ResourceRecordKey" => "29896609"
              "ModificationTimestamp" => "2026-06-12T18:03:00.48Z"
            ]
          ]
          +"DaysOnMarket": 1
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896609')"
          +"ID": "1525387"
        }
        1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25141
          +post_id: "1521583"
          +post_author: 1
          +"ListingKey": "29889854"
          +"ListingId": "1298860"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-11T17:30:22Z"
          +"RFModificationTimestamp": "2026-06-11T20:27:37Z"
          +"ListPrice": 554900.0
          +"BathroomsTotalInteger": 4.0
          +"BathroomsHalf": 2
          +"BedroomsTotal": 3.0
          +"LotSizeArea": 0
          +"LivingArea": 2481.0
          +"BuildingAreaTotal": 0
          +"City": "St. John's"
          +"PostalCode": "A1H1A2"
          +"UnparsedAddress": "6 Banyan Place, St. John's, Newfoundland & Labrador A1H1A2"
          +"Coordinates": array:2 [
            0 => -52.816391
            1 => 47.493946
          ]
          +"Latitude": 47.493946
          +"Longitude": -52.816391
          +"YearBuilt": 1999
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
          +"PublicRemarks": "This well-maintained, one owner, fully developed two-story home is located in Southlands on a quiet cul-de-sac.  The kitchen has a large sit up island and there is plenty of counter space. Off the kitchen there is a spacious dining room which leads into a large living room with a propane fireplace. Main floor also includes a large foyer, laundry and a half bath. Upstairs features two bedrooms, a full bath and a large primary bedroom with walk-in closet and en suite. The finished basement area includes huge family room/rec room, two-piece bathroom with room for a shower, an office and storage areas. The home sits on an extra large, south facing lot. There is plenty of deck and patio space to enjoy long summer evenings. There is drive-in access to the heated detached garage and the driveway allows for multi-car parking. Prime location, featuring walking trails and playgrounds. Close to schools, golf course, Southlands Community Centre, shopping and amenities. (id:62783)"
          +"Appliances": array:7 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Central Vacuum"
            3 => "Dishwasher"
            4 => "Stove"
            5 => "Dryer"
            6 => "Alarm System"
          ]
          +"ArchitecturalStyle": array:1 [
            0 => "2 Level"
          ]
          +"BathroomsPartial": 2
          +"Cooling": array:1 [
            0 => "Air exchanger"
          ]
          +"CreationDate": "2026-06-11T20:27:33.164780+00:00"
          +"ExteriorFeatures": array:1 [
            0 => "Vinyl siding"
          ]
          +"Fencing": array:1 [
            0 => "Partially fenced"
          ]
          +"FireplaceFeatures": array:2 [
            0 => "Insert"
            1 => "Propane"
          ]
          +"FireplaceYN": true
          +"FireplacesTotal": "1"
          +"Flooring": array:5 [
            0 => "Hardwood"
            1 => "Laminate"
            2 => "Carpeted"
            3 => "Other"
            4 => "Mixed Flooring"
          ]
          +"FoundationDetails": array:1 [
            0 => "Concrete"
          ]
          +"Heating": array:3 [
            0 => "Hot water radiator heat"
            1 => "Oil"
            2 => "Propane"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "2030827"
          +"ListOfficeKey": "262663"
          +"LivingAreaUnits": "square feet"
          +"LotSizeDimensions": "50 x167"
          +"ParkingFeatures": array:1 [
            0 => "Detached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-11T17:13:40Z"
          +"PhotosCount": 31
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Newfoundland & Labrador"
          +"StatusChangeTimestamp": "2026-06-11T17:13:40Z"
          +"Stories": "2.0"
          +"StreetName": "Banyan"
          +"StreetNumber": "6"
          +"StreetSuffix": "Place"
          +"TaxAnnualAmount": "3456"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:16 [
            0 => array:11 [
              "RoomKey" => "1657189225"
              "RoomType" => "Storage"
              "ListingId" => "1298860"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "29889854"
              "RoomLength" => null
              "RoomDimensions" => "21.9 x 13.11"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-11T17:13:40.26Z"
            ]
            1 => array:11 [
              "RoomKey" => "1657189226"
              "RoomType" => "Utility room"
              "ListingId" => "1298860"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "29889854"
              "RoomLength" => null
              "RoomDimensions" => "6.3 x 12.1"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-11T17:13:40.26Z"
            ]
            2 => array:11 [
              "RoomKey" => "1657189227"
              "RoomType" => "Bath (# pieces 1-6)"
              "ListingId" => "1298860"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "29889854"
              "RoomLength" => null
              "RoomDimensions" => "7.9 x 5.2"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-11T17:13:40.26Z"
            ]
            3 => array:11 [
              "RoomKey" => "1657189228"
              "RoomType" => "Office"
              "ListingId" => "1298860"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "29889854"
              "RoomLength" => null
              "RoomDimensions" => "8.8 x8.3"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-11T17:13:40.26Z"
            ]
            4 => array:11 [
              "RoomKey" => "1657189229"
              "RoomType" => "Family room"
              "ListingId" => "1298860"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "29889854"
              "RoomLength" => null
              "RoomDimensions" => "12.5 x 24.11"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-11T17:13:40.27Z"
            ]
            5 => array:11 [
              "RoomKey" => "1657189230"
              "RoomType" => "Bedroom"
              "ListingId" => "1298860"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29889854"
              "RoomLength" => null
              "RoomDimensions" => "12.10 x 11.2"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-11T17:13:40.27Z"
            ]
            6 => array:11 [
              "RoomKey" => "1657189231"
              "RoomType" => "Bedroom"
              "ListingId" => "1298860"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29889854"
              "RoomLength" => null
              "RoomDimensions" => "10.2 x 12"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-11T17:13:40.27Z"
            ]
            7 => array:11 [
              "RoomKey" => "1657189232"
              "RoomType" => "Bath (# pieces 1-6)"
              "ListingId" => "1298860"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29889854"
              "RoomLength" => null
              "RoomDimensions" => "10 x 6.4"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-11T17:13:40.27Z"
            ]
            8 => array:11 [
              "RoomKey" => "1657189233"
              "RoomType" => "Ensuite"
              "ListingId" => "1298860"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29889854"
              "RoomLength" => null
              "RoomDimensions" => "9.1 x 6.3"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-11T17:13:40.27Z"
            ]
            9 => array:11 [
              "RoomKey" => "1657189234"
              "RoomType" => "Primary Bedroom"
              "ListingId" => "1298860"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29889854"
              "RoomLength" => null
              "RoomDimensions" => "13 x 21.11"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-11T17:13:40.27Z"
            ]
            10 => array:11 [ …11]
            11 => array:11 [ …11]
            12 => array:11 [ …11]
            13 => array:11 [ …11]
            14 => array:11 [ …11]
            15 => array:11 [ …11]
          ]
          +"ListAOR": "Newfoundland & Labrador"
          +"ListAORKey": "117"
          +"ListingURL": "www.realtor.ca/real-estate/29889854/6-banyan-place-st-johns"
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"ZoningDescription": "R1"
          +"BedroomsAboveGrade": 3
          +"BedroomsBelowGrade": 0
          +"OriginalEntryTimestamp": "2026-06-11T17:13:40.15Z"
          +"ListAgentNationalAssociationId": "1308345"
          +"ListOfficeNationalAssociationId": "1223039"
          +"Media": array:31 [
            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]
          ]
          +"DaysOnMarket": 2
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889854')"
          +"ID": "1521583"
        }
        2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25138
          +post_id: "1515895"
          +post_author: 1
          +"ListingKey": "29882438"
          +"ListingId": "1298764"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-10T16:20:11Z"
          +"RFModificationTimestamp": "2026-06-10T16:36:01Z"
          +"ListPrice": 284900.0
          +"BathroomsTotalInteger": 1.0
          +"BathroomsHalf": 0
          +"BedroomsTotal": 2.0
          +"LotSizeArea": 0
          +"LivingArea": 1560.0
          +"BuildingAreaTotal": 0
          +"City": "St. John's"
          +"PostalCode": "A1H1C3"
          +"UnparsedAddress": "153 Green Acre Drive, St. John's, Newfoundland & Labrador A1H1C3"
          +"Coordinates": array:2 [
            0 => -52.806643
            1 => 47.496506
          ]
          +"Latitude": 47.496506
          +"Longitude": -52.806643
          +"YearBuilt": 2006
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
          +"PublicRemarks": "Welcome to 153 Green Acre Drive, an excellent opportunity in the heart of Southlands. Offering a highly attractive price point for first-time buyers, investors, or anyone looking to build equity, this move-in-ready home is located in one of St. John's most desirable neighbourhoods. The second floor features two spacious bedrooms and a full bathroom, while the main level offers comfortable and functional living spaces designed for everyday enjoyment. Outside, you'll appreciate the rear patio, fully fenced backyard, and storage shed, providing excellent space for children, pets, entertaining, and additional storage. Conveniently situated near schools, parks, playgrounds, recreation facilities, shopping, restaurants, and the growing Galway commercial district, you'll also enjoy quick access to the Team Gushue Highway for easy commuting throughout the city. While comfortable and functional as it stands today, the true value lies in the future potential. The undeveloped basement offers ample space for a future rec room, additional bedroom, and bathroom, creating an excellent opportunity to expand your living space while adding long-term value to the property. Whether you're looking for your first home or your next investment, the possibilities are here. Situated in a family-friendly community with strong long-term appeal, this is a home you can enjoy today while planning for tomorrow. As per the Seller’s direction, there will be no conveyance of offers until 5:00pm Sunday, June 14th, and offers are to remain open until 10:00pm the same day. (id:62783)"
          +"CreationDate": "2026-06-10T16:35:57.745084+00:00"
          +"ExteriorFeatures": array:2 [
            0 => "Wood shingles"
            1 => "Vinyl siding"
          ]
          +"Fencing": array:1 [
            0 => "Fence"
          ]
          +"Flooring": array:1 [
            0 => "Mixed Flooring"
          ]
          +"FoundationDetails": array:1 [
            0 => "Concrete"
          ]
          +"Heating": array:1 [
            0 => "Electric"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "2230332"
          +"ListOfficeKey": "88563"
          +"LivingAreaUnits": "square feet"
          +"LotSizeDimensions": "30x100"
          +"PhotosChangeTimestamp": "2026-06-10T16:13:28Z"
          +"PhotosCount": 20
          +"PropertyAttachedYN": true
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Newfoundland & Labrador"
          +"StatusChangeTimestamp": "2026-06-10T16:13:28Z"
          +"Stories": "1.0"
          +"StreetName": "Green Acre"
          +"StreetNumber": "153"
          +"StreetSuffix": "Drive"
          +"TaxAnnualAmount": "2861"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:7 [
            0 => array:11 [ …11]
            1 => array:11 [ …11]
            2 => array:11 [ …11]
            3 => array:11 [ …11]
            4 => array:11 [ …11]
            5 => array:11 [ …11]
            6 => array:11 [ …11]
          ]
          +"ListAOR": "Newfoundland & Labrador"
          +"TaxYear": 2026
          +"ListAORKey": "117"
          +"ListingURL": "www.realtor.ca/real-estate/29882438/153-green-acre-drive-st-johns"
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"ZoningDescription": "R2"
          +"BedroomsAboveGrade": 2
          +"BedroomsBelowGrade": 0
          +"OriginalEntryTimestamp": "2026-06-10T16:13:28.25Z"
          +"ListAgentNationalAssociationId": "1471534"
          +"ListOfficeNationalAssociationId": "1260564"
          +"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": 3
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29882438')"
          +"ID": "1515895"
        }
        3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25142
          +post_id: "1513738"
          +post_author: 1
          +"ListingKey": "29874878"
          +"ListingId": "1298690"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-10T00:15:14Z"
          +"RFModificationTimestamp": "2026-06-10T00:20:38Z"
          +"ListPrice": 649000.0
          +"BathroomsTotalInteger": 2.0
          +"BathroomsHalf": 0
          +"BedroomsTotal": 2.0
          +"LotSizeArea": 0
          +"LivingArea": 2800.0
          +"BuildingAreaTotal": 0
          +"City": "St. John's"
          +"PostalCode": "A1H0N6"
          +"UnparsedAddress": "4 Claddagh Road, St. John's, Newfoundland & Labrador A1H0N6"
          +"Coordinates": array:2 [
            0 => -52.828209
            1 => 47.501894
          ]
          +"Latitude": 47.501894
          +"Longitude": -52.828209
          +"YearBuilt": 2024
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
          +"PublicRemarks": "Ideally situated, this beautiful bungalow backs onto a\u{A0}greenbelt, ensuring your peaceful backyard view is undisturbed. Instead of fences and rooftops, you’ll enjoy a forest backdrop\u{A0}and the calming sounds of nature. Completed in 2024, this home feels brand new, blending striking Cape Cod siding with a sleek, modern aesthetic for standout curb appeal. Inside, the contemporary design continues, offering a pristine space that is as functional as it is stylish. Featuring 9-foot ceilings, beautiful wide-plank engineered hardwood, and abundant natural light, the open-concept layout feels both airy and inviting. The gourmet kitchen features high-end quartz countertops and a custom design that flows seamlessly into the living room, which is anchored by a cozy propane fireplace. The primary suite serves as a true sanctuary, featuring a walk-in closet and a luxury ensuite complete with a custom tiled shower and a deep standalone tub for a spa-like experience. The main floor includes a spacious second bedroom, a full bath, and a convenient laundry room. Practicality meets potential with a large 19’ x 21’ attached garage and a full basement that offers incredible development opportunity—ample space to easily add a 3rd bedroom, a home gym, or a guest suite. Living in Galway means embracing a lifestyle of ultimate convenience; you are within easy walking distance to The Shoppes at Galway and Costco, while benefiting from groomed walking trails and lush green spaces just steps from your door. With rapid access to the TCH and downtown St. John’s, this property offers the perfect balance of modern luxury and natural tranquility. (id:62650)"
          +"ArchitecturalStyle": array:1 [
            0 => "Bungalow"
          ]
          +"CreationDate": "2026-06-09T13:54:08.682987+00:00"
          +"ExteriorFeatures": array:2 [
            0 => "Wood shingles"
            1 => "Other"
          ]
          +"FireplaceYN": true
          +"Flooring": array:1 [
            0 => "Other"
          ]
          +"Heating": array:3 [
            0 => "Baseboard heaters"
            1 => "Electric"
            2 => "Propane"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "2012167"
          +"ListOfficeKey": "280379"
          +"LivingAreaUnits": "square feet"
          +"LotSizeDimensions": "50 x 135.62 x 50 x 130"
          +"ParkingFeatures": array:1 [
            0 => "Attached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-10T00:02:26Z"
          +"PhotosCount": 29
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Newfoundland & Labrador"
          +"StatusChangeTimestamp": "2026-06-10T00:02:25Z"
          +"Stories": "1.0"
          +"StreetName": "Claddagh"
          +"StreetNumber": "4"
          +"StreetSuffix": "Road"
          +"TaxAnnualAmount": "4682"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"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/29874878/4-claddagh-road-st-johns"
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"ZoningDescription": "RES"
          +"BedroomsAboveGrade": 2
          +"BedroomsBelowGrade": 0
          +"OriginalEntryTimestamp": "2026-06-09T13:22:41.14Z"
          +"ListAgentNationalAssociationId": "1293864"
          +"ListOfficeNationalAssociationId": "1313257"
          +"Media": array:29 [
            0 => array:13 [ …13]
            1 => array:13 [ …13]
            2 => array:13 [ …13]
            3 => array:13 [ …13]
            4 => array:13 [ …13]
            5 => array:13 [ …13]
            6 => array:13 [ …13]
            7 => array:13 [ …13]
            8 => array:13 [ …13]
            9 => array:13 [ …13]
            10 => array:13 [ …13]
            11 => array:13 [ …13]
            12 => array:13 [ …13]
            13 => array:13 [ …13]
            14 => array:13 [ …13]
            15 => array:13 [ …13]
            16 => array:13 [ …13]
            17 => array:13 [ …13]
            18 => array:13 [ …13]
            19 => array:13 [ …13]
            20 => array:13 [ …13]
            21 => array:13 [ …13]
            22 => array:13 [ …13]
            23 => array:13 [ …13]
            24 => array:13 [ …13]
            25 => array:13 [ …13]
            26 => array:13 [ …13]
            27 => array:13 [ …13]
            28 => array:13 [ …13]
          ]
          +"DaysOnMarket": 4
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29874878')"
          +"ID": "1513738"
        }
        4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25140
          +post_id: "1506150"
          +post_author: 1
          +"ListingKey": "29869617"
          +"ListingId": "1298620"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-08T15:31:11Z"
          +"RFModificationTimestamp": "2026-06-08T17:02:34Z"
          +"ListPrice": 489900.0
          +"BathroomsTotalInteger": 4.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 5.0
          +"LotSizeArea": 0
          +"LivingArea": 2534.0
          +"BuildingAreaTotal": 0
          +"City": "MOUNT PEARL"
          +"PostalCode": "A1N4W6"
          +"UnparsedAddress": "4 Crystal Place, MOUNT PEARL, Newfoundland & Labrador A1N4W6"
          +"Coordinates": array:2 [
            0 => -52.802247
            1 => 47.500611
          ]
          +"Latitude": 47.500611
          +"Longitude": -52.802247
          +"YearBuilt": 1994
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
          +"PublicRemarks": "Looking for a home that offers space, comfort, and income potential?  This well maintained two apartment home is located on a quiet cul-de-sac and backing onto a playground, all while being just minutes from major amenities.  The main floor features three bedrooms, with a primary bedroom ensuite.  Large eat in kitchen, with a formal dining room, living room and rec room.  Recent upgrades include new HRV, refinished hardwood floors, new laminate, and freshly painted throughout.  The bright and spacious basement apartment features two bedrooms, a living room, an eat in kitchen, its own laundry a well designed layout.  As per the Sellers Direction there will be no conveyance of offers until 5pm on June 10th 2026 and offers are to remain open for consideration until 8pm that same day. (id:62650)"
          +"Appliances": array:3 [
            0 => "Refrigerator"
            1 => "Dishwasher"
            2 => "Stove"
          ]
          +"BathroomsPartial": 1
          +"CreationDate": "2026-06-08T17:02:27.379916+00:00"
          +"ExteriorFeatures": array:1 [
            0 => "Vinyl siding"
          ]
          +"Flooring": array:1 [
            0 => "Hardwood"
          ]
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:1 [
            0 => "Electric"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "1571812"
          +"ListOfficeKey": "88555"
          +"LivingAreaUnits": "square feet"
          +"LotSizeDimensions": "40x103x57x103"
          +"PhotosChangeTimestamp": "2026-06-08T15:23:53Z"
          +"PhotosCount": 48
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Newfoundland & Labrador"
          +"StatusChangeTimestamp": "2026-06-08T15:23:53Z"
          +"StreetName": "Crystal"
          +"StreetNumber": "4"
          +"StreetSuffix": "Place"
          +"TaxAnnualAmount": "2773"
          +"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"
          +"ListAORKey": "117"
          +"ListingURL": "www.realtor.ca/real-estate/29869617/4-crystal-place-mount-pearl"
          +"StructureType": array:1 [
            0 => "Two Apartment House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"ZoningDescription": "res"
          +"OriginalEntryTimestamp": "2026-06-08T15:23:53.33Z"
          +"ListAgentNationalAssociationId": "1108011"
          +"ListOfficeNationalAssociationId": "1007294"
          +"Media": array:48 [
            0 => array:13 [ …13]
            1 => array:13 [ …13]
            2 => array:13 [ …13]
            3 => array:13 [ …13]
            4 => array:13 [ …13]
            5 => array:13 [ …13]
            6 => array:13 [ …13]
            7 => array:13 [ …13]
            8 => array:13 [ …13]
            9 => array:13 [ …13]
            10 => array:13 [ …13]
            11 => array:13 [ …13]
            12 => array:13 [ …13]
            13 => array:13 [ …13]
            14 => array:13 [ …13]
            15 => array:13 [ …13]
            16 => array:13 [ …13]
            17 => array:13 [ …13]
            18 => array:13 [ …13]
            19 => array:13 [ …13]
            20 => array:13 [ …13]
            21 => array:13 [ …13]
            22 => array:13 [ …13]
            23 => array:13 [ …13]
            24 => array:13 [ …13]
            25 => array:13 [ …13]
            26 => array:13 [ …13]
            27 => array:13 [ …13]
            28 => array:13 [ …13]
            29 => array:13 [ …13]
            30 => array:13 [ …13]
            31 => array:13 [ …13]
            32 => array:13 [ …13]
            33 => array:13 [ …13]
            34 => array:13 [ …13]
            35 => array:13 [ …13]
            36 => array:13 [ …13]
            37 => array:13 [ …13]
            38 => array:13 [ …13]
            39 => array:13 [ …13]
            40 => array:13 [ …13]
            41 => array:13 [ …13]
            42 => array:13 [ …13]
            43 => array:13 [ …13]
            44 => array:13 [ …13]
            45 => array:13 [ …13]
            46 => array:13 [ …13]
            47 => array:13 [ …13]
          ]
          +"DaysOnMarket": 5
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29869617')"
          +"ID": "1506150"
        }
        5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25135
          +post_id: "1500767"
          +post_author: 1
          +"ListingKey": "29858575"
          +"ListingId": "1298404"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-05T11:55:21Z"
          +"RFModificationTimestamp": "2026-06-05T18:07:03Z"
          +"ListPrice": 349900.0
          +"BathroomsTotalInteger": 2.0
          +"BathroomsHalf": 0
          +"BedroomsTotal": 5.0
          +"LotSizeArea": 0
          +"LivingArea": 2650.0
          +"BuildingAreaTotal": 0
          +"City": "Mount Pearl"
          +"PostalCode": "A1N3N7"
          +"UnparsedAddress": "89 Ashford Drive, Mount Pearl, Newfoundland & Labrador A1N3N7"
          +"Coordinates": array:2 [
            0 => -52.814349
            1 => 47.508561
          ]
          +"Latitude": 47.508561
          +"Longitude": -52.814349
          +"YearBuilt": 1985
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
          +"PublicRemarks": "Welcome to this spacious and versatile original/one owner home, nestled on a beautiful lot in a family-friendly neighborhood in Mount Pearl - beaming with love & having been so well cared for over the years. Built as a 2-apartment home, this property is currently being enjoyed as a single-family residence, offering endless possibilities for homeowners and investors alike. Boasting over 2,600 sq/ft, the main living area features a bright, open, & functional layout highlighted by stunning hardwood floors, a cozy fireplace in the living room, dining room and a spacious kitchen complete with a center island—perfect for family gatherings and entertaining. The main unit also offers three well sized bedrooms, a full bathroom, and a rec room providing additional living space for the main unit. The self-contained apartment is equally impressive, featuring a welcoming enclosed entrance that provides comfort and convenience during Winter. Inside you'll find a spacious two-bedroom layout with a large eat-in kitchen, living room, full bathroom, and its own private laundry facilities. Separate meter and separate electrical panel. Outside, the property boasts a detached 16' x 20' wired garage, offering excellent storage, workshop space, or room for hobbies which is highlighted by the beautiful perennial garden, large partially fenced backyard and extra wide driveway. This home is just minutes from shopping, restaurants, recreation facilities, schools, public transit, and all major amenities that Mount Pearl has to offer. Whether you're looking for a spacious family home, multigenerational living, or the opportunity to have an income-generating property, this well-maintained home offers exceptional value, flexibility, and location. A fantastic opportunity in a prime Mount Pearl setting! (Among so many interior updates, the Shingles were completed in 2021). As per Seller direction there will be no conveyance of offers prior to 4pm June 10th, offers to remain open until 9pm same day. (id:62783)"
          +"CreationDate": "2026-06-05T18:06:55.929104+00:00"
          +"ExteriorFeatures": array:1 [
            0 => "Vinyl siding"
          ]
          +"Flooring": array:1 [
            0 => "Mixed Flooring"
          ]
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:1 [
            0 => "Electric"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "2163186"
          +"ListOfficeKey": "274842"
          +"LivingAreaUnits": "square feet"
          +"LotSizeDimensions": "54 x 105"
          +"ParkingFeatures": array:1 [
            0 => "Detached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-05T11:42:37Z"
          +"PhotosCount": 41
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Newfoundland & Labrador"
          +"StatusChangeTimestamp": "2026-06-05T11:42:37Z"
          +"StreetName": "Ashford"
          +"StreetNumber": "89"
          +"StreetSuffix": "Drive"
          +"TaxAnnualAmount": "2614"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:14 [
            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]
          ]
          +"ListAOR": "Newfoundland & Labrador"
          +"ListAORKey": "117"
          +"ListingURL": "www.realtor.ca/real-estate/29858575/89-ashford-drive-mount-pearl"
          +"StructureType": array:1 [
            0 => "Two Apartment House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"ZoningDescription": "res"
          +"BedroomsAboveGrade": 3
          +"BedroomsBelowGrade": 2
          +"OriginalEntryTimestamp": "2026-06-05T11:42:36.99Z"
          +"ListAgentNationalAssociationId": "1414124"
          +"ListOfficeNationalAssociationId": "1284884"
          +"Media": array:41 [
            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]
          ]
          +"DaysOnMarket": 8
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29858575')"
          +"ID": "1500767"
        }
        6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23375
          +post_id: "1500768"
          +post_author: 1
          +"ListingKey": "29858573"
          +"ListingId": "1298534"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-07T21:40:50Z"
          +"RFModificationTimestamp": "2026-06-07T21:52:42Z"
          +"ListPrice": 349900.0
          +"BathroomsTotalInteger": 2.0
          +"BathroomsHalf": 0
          +"BedroomsTotal": 5.0
          +"LotSizeArea": 0
          +"LivingArea": 2650.0
          +"BuildingAreaTotal": 0
          +"City": "Mount Pearl"
          +"PostalCode": "A1N3N7"
          +"UnparsedAddress": "89 Ashford Drive, Mount Pearl, Newfoundland & Labrador A1N3N7"
          +"Coordinates": array:2 [
            0 => -52.814272
            1 => 47.508612
          ]
          +"Latitude": 47.508612
          +"Longitude": -52.814272
          +"YearBuilt": 1985
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
          +"PublicRemarks": "Welcome to this spacious and versatile original/one owner home, nestled on a beautiful lot in a family-friendly neighborhood in Mount Pearl - beaming with love & having been so well cared for over the years. Built as a 2-apartment home, this property is currently being enjoyed as a single-family residence, offering endless possibilities for homeowners and investors alike. Boasting over 2,600 sq/ft, the main living area features a bright, open, & functional layout highlighted by stunning hardwood floors, a cozy fireplace in the living room, dining room and a spacious kitchen complete with a center island—perfect for family gatherings and entertaining. The main unit also offers three well sized bedrooms, a full bathroom, and a rec room providing additional living space for the main unit. The self-contained apartment is equally impressive, featuring a welcoming enclosed entrance that provides comfort and convenience during Winter. Inside you'll find a spacious two-bedroom layout with a large eat-in kitchen, living room, full bathroom, and its own private laundry facilities. Separate meter and separate electrical panel. Outside, the property boasts a detached 16' x 20' wired garage, offering excellent storage, workshop space, or room for hobbies which is highlighted by the beautiful perennial garden, large partially fenced backyard and extra wide driveway. This home is just minutes from shopping, restaurants, recreation facilities, schools, public transit, and all major amenities that Mount Pearl has to offer. Whether you're looking for a spacious family home, multigenerational living, or the opportunity to have an income-generating property, this well-maintained home offers exceptional value, flexibility, and location. A fantastic opportunity in a prime Mount Pearl setting! (Among so many interior updates, the Shingles were completed in 2021). As per Seller direction there will be no conveyance of offers prior to 4pm June 10th, offers to remain open until 9pm same day. (id:62783)"
          +"CreationDate": "2026-06-05T18:06:55.770070+00:00"
          +"ExteriorFeatures": array:1 [
            0 => "Vinyl siding"
          ]
          +"Flooring": array:1 [
            0 => "Mixed Flooring"
          ]
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:1 [
            0 => "Electric"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "2163186"
          +"ListOfficeKey": "274842"
          +"LivingAreaUnits": "square feet"
          +"LotSizeDimensions": "54 x 105"
          +"ParkingFeatures": array:1 [
            0 => "Detached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-05T11:42:35Z"
          +"PhotosCount": 41
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Newfoundland & Labrador"
          +"StatusChangeTimestamp": "2026-06-07T21:32:55Z"
          +"Stories": "1.0"
          +"StreetName": "Ashford"
          +"StreetNumber": "89"
          +"StreetSuffix": "Drive"
          +"TaxAnnualAmount": "2614"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:14 [
            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]
          ]
          +"ListAOR": "Newfoundland & Labrador"
          +"ListAORKey": "117"
          +"ListingURL": "www.realtor.ca/real-estate/29858573/89-ashford-drive-mount-pearl"
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"ZoningDescription": "res"
          +"BedroomsAboveGrade": 3
          +"BedroomsBelowGrade": 2
          +"OriginalEntryTimestamp": "2026-06-05T11:42:35.08Z"
          +"ListAgentNationalAssociationId": "1414124"
          +"ListOfficeNationalAssociationId": "1284884"
          +"Media": array:41 [
            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]
          ]
          +"DaysOnMarket": 8
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29858573')"
          +"ID": "1500768"
        }
        7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25143
          +post_id: "1497003"
          +post_author: 1
          +"ListingKey": "29853335"
          +"ListingId": "1298324"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-07T19:00:25Z"
          +"RFModificationTimestamp": "2026-06-07T19:12:40Z"
          +"ListPrice": 555000.0
          +"BathroomsTotalInteger": 4.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 5.0
          +"LotSizeArea": 0
          +"LivingArea": 2620.0
          +"BuildingAreaTotal": 0
          +"City": "St John's"
          +"PostalCode": "A1H0N1"
          +"UnparsedAddress": "168 Diamond Marsh Drive, St John's, Newfoundland & Labrador A1H0N1"
          +"Coordinates": array:2 [
            0 => -52.800774
            1 => 47.494983
          ]
          +"Latitude": 47.494983
          +"Longitude": -52.800774
          +"YearBuilt": 2016
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
          +"PublicRemarks": "This is the home that makes ownership add up.  A carefully built two-apartment in sought-after Southlands, 168 Diamond Marsh Drive pairs a spacious main residence with a high-performing rental - so a first-time buyer gains a foothold, and a growing family gains room for everyone under one roof. Set on a slightly oversized lot with a greenbelt at the rear, it offers privacy and nature you simply can't build next to in most newer subdivisions. The main residence lives like a modern executive home. 9ft ceilings, an open-concept kitchen, living with fireplace, and dining area anchors the main floor and opens to a back deck overlooking the trees. The primary suite is a true retreat - walk-in closet, second closet, and a four-piece ensuite with freestanding tub. Two more bedrooms and a full main bath complete the level, while downstairs a generous rec room, dedicated laundry, and half bath add space to spread out. Two mini-split systems keep it comfortable and efficient year-round. The bright, above-grade two-bedroom apartment feels nothing like a basement. Its own walk-out entrance sits steps from the driveway, and a full kitchen, in-suite laundry, dishwasher, and dedicated mini-split make it genuinely self-contained - ideal for tenants, parents or in-laws. This home commands strong rent because it earns it - and there's a tidy, quiet, reliable tenant already in place who agrees. You're minutes from Costco, Walmart, Sobeys, and Mount Pearl's full slate of shopping and dining, zoned for St. Peter's Primary, St. Peter's Junior High, and O'Donel High, and surrounded by walking trails, parks, and Glendenning Golf Course. Quick links to the Trans-Canada Highway and Pitts Memorial Highway put downtown St. John's about ten minutes away. Smart, spacious, and ready to grow with you. Offers subject to a seller's directive. No offers to be presented prior to 5pm on Tuesday June 9th 2026. Offers to be left open until 10pm, June 9th 2026. (id:62783)"
          +"Appliances": array:6 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Dishwasher"
            3 => "Stove"
            4 => "Dryer"
            5 => "Microwave"
          ]
          +"BathroomsPartial": 1
          +"Cooling": array:1 [
            0 => "Air exchanger"
          ]
          +"CreationDate": "2026-06-04T16:29:38.625448+00:00"
          +"ExteriorFeatures": array:2 [
            0 => "Wood shingles"
            1 => "Vinyl siding"
          ]
          +"FireplaceYN": true
          +"Flooring": array:4 [
            0 => "Laminate"
            1 => "Marble"
            2 => "Other"
            3 => "Ceramic"
          ]
          +"FoundationDetails": array:2 [
            0 => "Concrete"
            1 => "Poured Concrete"
          ]
          +"Heating": array:4 [
            0 => "Heat Pump"
            1 => "Baseboard heaters"
            2 => "Electric"
            3 => "Mini-Split"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "2172916"
          +"ListOfficeKey": "280379"
          +"LivingAreaUnits": "square feet"
          +"LotSizeDimensions": "50x120"
          +"PhotosChangeTimestamp": "2026-06-04T15:53:40Z"
          +"PhotosCount": 46
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Newfoundland & Labrador"
          +"StatusChangeTimestamp": "2026-06-07T18:52:48Z"
          +"StreetName": "Diamond Marsh"
          +"StreetNumber": "168"
          +"StreetSuffix": "Drive"
          +"TaxAnnualAmount": "3918"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:19 [
            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]
          ]
          +"ListAOR": "Newfoundland & Labrador"
          +"TaxYear": 2026
          +"ListAORKey": "117"
          +"ListingURL": "www.realtor.ca/real-estate/29853335/168-diamond-marsh-drive-st-johns"
          +"StructureType": array:1 [
            0 => "Two Apartment House"
          ]
          +"CoListAgentKey": "2202792"
          +"CommonInterest": "Freehold"
          +"CoListOfficeKey": "280379"
          +"GeocodeManualYN": true
          +"ZoningDescription": "R1"
          +"OriginalEntryTimestamp": "2026-06-04T15:53:39.96Z"
          +"ListAgentNationalAssociationId": "1423409"
          +"ListOfficeNationalAssociationId": "1313257"
          +"CoListAgentNationalAssociationId": "1451334"
          +"CoListOfficeNationalAssociationId": "1313257"
          +"Media": array:46 [
            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]
          ]
          +"DaysOnMarket": 9
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29853335')"
          +"ID": "1497003"
        }
        8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25144
          +post_id: "1488444"
          +post_author: 1
          +"ListingKey": "29845512"
          +"ListingId": "1298442"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-03T16:00:34Z"
          +"RFModificationTimestamp": "2026-06-03T16:10:24Z"
          +"ListPrice": 459000.0
          +"BathroomsTotalInteger": 3.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 3.0
          +"LotSizeArea": 0
          +"LivingArea": 2167.0
          +"BuildingAreaTotal": 0
          +"City": "St John's"
          +"PostalCode": "A1H0P4"
          +"UnparsedAddress": "65 Cedar Hill Place, St John's, Newfoundland & Labrador A1H0P4"
          +"Coordinates": array:2 [
            0 => -52.817167
            1 => 47.497959
          ]
          +"Latitude": 47.497959
          +"Longitude": -52.817167
          +"YearBuilt": 2024
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Newfoundland & Labrador Association of REALTORS®"
          +"PublicRemarks": "Built in 2024, loaded with upgrades, and backing onto green space with southern exposure- 65 Cedar Hill Place offers modern living in one of St. John’s newest and most desirable communities. This semi-detached duplex offers the perfect blend of modern comfort, functional living, and an exceptional location with walking trails just steps from your door. The adjoining land is designated as an easement, with no known future development. The main floor features a bright open concept layout, complete with a living room, dining area, and kitchen featuring a walk in pantry and convenient half bath. Upstairs, you’ll find a spacious primary bedroom with a wraparound walk in closet and a full ensuite complete with a tiled shower and tub. Two additional bedrooms, a full bathroom, and laundry. The undeveloped basement offers endless possibilities for future expansion and includes two egress windows, providing excellent potential for additional living space.When constructed, this home was upgraded beyond the builder’s standard specifications, including an exterior vented range hood, upgraded kitchen cabinetry and pantry, kitchen backsplash, enhanced plumbing fixtures, upgraded flooring and ceramic tile, upgraded lighting package, front and rear eavestroughs, Wi-Fi-enabled garage door opener, mini-split heat pump, and two basement egress windows. All appliances are included and come with extended warranty coverage, providing added value and peace of mind. River’s Edge is a vibrant and growing community that offers the perfect balance of a relaxed lifestyle and urban convenience. You’re just minutes from Costco, shopping, restaurants, Glendenning Golf Course, downtown St. John’s, and enjoy quick access to Pitts Memorial Drive and the Outer Ring Road. As per the seller’s direction, no conveyance of offers will occur before Monday, June 8th at 6pm. All offers must remain open until 11 pm. (id:62650)"
          +"Appliances": array:4 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Dishwasher"
            3 => "Dryer"
          ]
          +"ArchitecturalStyle": array:1 [
            0 => "2 Level"
          ]
          +"BathroomsPartial": 1
          +"CreationDate": "2026-06-03T15:08:12.138452+00:00"
          +"ExteriorFeatures": array:1 [
            0 => "Vinyl siding"
          ]
          +"Flooring": array:4 [
            0 => "Laminate"
            1 => "Marble"
            2 => "Ceramic"
            3 => "Mixed Flooring"
          ]
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:2 [
            0 => "Electric"
            1 => "Mini-Split"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "1880073"
          +"ListOfficeKey": "88563"
          +"LivingAreaUnits": "square feet"
          +"LotSizeDimensions": "39 x 116 x 29 x 115"
          +"ParkingFeatures": array:1 [
            0 => "Attached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-03T14:33:44Z"
          +"PhotosCount": 25
          +"PropertyAttachedYN": true
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Newfoundland & Labrador"
          +"StatusChangeTimestamp": "2026-06-03T15:53:19Z"
          +"Stories": "2.0"
          +"StreetName": "Cedar Hill"
          +"StreetNumber": "65"
          +"StreetSuffix": "Place"
          +"TaxAnnualAmount": "3579"
          +"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/29845512/65-cedar-hill-place-st-johns"
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"ZoningDescription": "Residential"
          +"BedroomsAboveGrade": 3
          +"BedroomsBelowGrade": 0
          +"OriginalEntryTimestamp": "2026-06-03T14:33:44.76Z"
          +"ListAgentNationalAssociationId": "1206056"
          +"ListOfficeNationalAssociationId": "1260564"
          +"Media": array:25 [
            0 => array:13 [ …13]
            1 => array:13 [ …13]
            2 => array:13 [ …13]
            3 => array:13 [ …13]
            4 => array:13 [ …13]
            5 => array:13 [ …13]
            6 => array:13 [ …13]
            7 => array:13 [ …13]
            8 => array:13 [ …13]
            9 => array:13 [ …13]
            10 => array:13 [ …13]
            11 => array:13 [ …13]
            12 => array:13 [ …13]
            13 => array:13 [ …13]
            14 => array:13 [ …13]
            15 => array:13 [ …13]
            16 => array:13 [ …13]
            17 => array:13 [ …13]
            18 => array:13 [ …13]
            19 => array:13 [ …13]
            20 => array:13 [ …13]
            21 => array:13 [ …13]
            22 => array:13 [ …13]
            23 => array:13 [ …13]
            24 => array:13 [ …13]
          ]
          +"DaysOnMarket": 10
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29845512')"
          +"ID": "1488444"
        }
      ]
      +success: true
      +page_size: 9
      +page_count: 4
      +count: 28
      +after_key: ""
    }
    "RF Response Time" => "0.15 seconds"
  ]
]

MLS On The Fly Debug Panel

[Deprecated] Optional parameter $select declared before required parameter $condition is implicitly treated as a required parameter in /home/comfreerealtyna/public_html/wp-content/plugins/real-estate-listing-realtyna-wpl-pro/libraries/addon_sms.php on line 100
[User Notice] Function wpdb::prepare was called <strong>incorrectly</strong>. The query only expected one placeholder, but an array of multiple placeholders was sent. Please see <a href="https://developer.wordpress.org/advanced-administration/debug/debug-wordpress/">Debugging in WordPress</a> for more information. (This message was added in version 4.9.0.) in /home/comfreerealtyna/public_html/wp-includes/functions.php on line 6170

1-877-888-3131

We will help you sell your home, commission free.

Save Thousands When You Sell Your Home

Menu

Resources

Get Started

Contact us

Offer to Purchase Forms

Offer to Lease

Offer to Purchase Forms

Offer to Purchase Forms

Offer to Lease

MLS On The Fly Debug Panel

MLS On The Fly Debug Panel

MLS On The Fly Debug Panel

Menu

Resources

Get Started

Contact us

Offer to Purchase Forms

Offer to Lease

Offer to Purchase Forms

Offer to Purchase Forms

Offer to Lease

How It Works

MLS On The Fly Debug Panel

MLS On The Fly Debug Panel

MLS On The Fly Debug Panel