Listings - ComFree Realty

Back to Map

$1,150,000

Ontario,Waterloo

For Sale Active

538 SANDBANKS Crescent, Waterloo, Ontario N2V2K2

5
4
3,716 Sqft

Contact Seller

Basic Details

Description

Welcome to 538 Sandbanks Crescent, a stunning and beautifully updated home nestled in the highly sought-after Laurelwood neighbourhood in Waterloo. From the moment you arrive it is clear this home has been cared for with exceptional pride of ownership and thoughtful attention to detail throughout. Backing onto protected green space and filled with an abundance of natural light, this home

offers the perfect blend of comfort, flexibility and modern living. The layout is incredibly versatile featuring two flexible main floor rooms that can be used as a home office, den or additional bedrooms depending on your family’s needs, along with a full bathroom on the main level, making it ideal for multigenerational living or aging parents. With a generous above grade footprint plus a finished walkout basement, there is no shortage of space for everyone to enjoy. Located just steps from Laurel Creek Conservation Area, 6 minutes from the charming village of St. Jacobs, and within the catchment of top ranked schools including Laurelwood Public School and Laurel Heights Secondary School. The Stork Family YMCA, Waterloo Public Library and The Boardwalk shopping district are all just minutes away. This truly is a neighbourhood people fall in love with and never want to leave. Updates include a new air conditioner (2022), quartz countertops in the kitchen (2024), new water softener (2025), updated paint throughout various areas, professionally painted entry, main and upstairs hallways and updated vanity taps in the upstairs bathroom (2026). Truly move in ready. Do not miss your opportunity to call this incredible home yours! (id:62650)

Basic Details

Property Type: Residential
Listing Type: For Sale
Listing ID: 40845281
Price: $1,150,000
Bedrooms: 5
Bathrooms: 4
Square Footage: 3,716 Sqft
Year Built: 2000
Status: Active
Property Sub Type: Single Family
Office Key: 156376

Features & Appliances

Features

Heating System: Forced air, Natural gas
Cooling System: Central air conditioning
Basement: Finished, Full
Parking: Attached Garage
Exterior Features: Vinyl siding, Brick
Sewer: Municipal sewage system
Fireplaces Total: 1

Address Map

Location: CA, Ontario, Waterloo, 441 - Erbsville/Laurelwood, N2V2K2
Street: SANDBANKS
Street Number: 538
Street Suffix: Crescent
Longitude: W81° 25' 12.4''
Latitude: N43° 29' 45.1''

Additional Information

Water Source:
Community Features:
Lot Features:
Stories: 2.0

Financial

Tax Annual Amount: 7891.76

Listing updated: 2026-07-07 22:47:35

Schedule a Tour

List Your Property

Mortgage Calculator

Get Pre-Approved

Home Price $

Down Payment

Interest Rate %

Mortgage Term years

Monthly Payment (Est.) $

Similar Properties

Listing Information

List Agent Key: 2103569
List Office Key: 156376
Modification Timestamp: 2026-07-07T20:35:24Z
Originating System Name: Cornerstone Association of REALTORS®
Status Change Timestamp: 2026-07-07T20:29:27Z

Listing updated: 2026-07-07 22:47:35

REALTOR®, REALTORS®, and the REALTOR® logo are certification marks that are owned by REALTOR® Canada Inc. and licensed exclusively to The Canadian Real Estate Association (CREA). These certification marks identify real estate professionals who are members of CREA and who must abide by CREA’s By‐Laws, Rules, and the REALTOR® Code. The MLS® trademark and the MLS® logo are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA.

The information contained on this site is based in whole or in part on information that is provided by members of The Canadian Real Estate Association, who are responsible for its accuracy. CREA reproduces and distributes this information as a service for its members and assumes no responsibility for its accuracy.

Website is operated by a brokerage or salesperson who is a member of The Canadian Real Estate Association.

The listing content on this website is protected by copyright and other laws, and is intended solely for the private, non‐commercial use by individuals. Any other reproduction, distribution or use of the content, in whole or in part, is specifically forbidden. The prohibited uses include commercial use, “screen scraping”, “database scraping”, and any other activity intended to collect, store, reorganize or manipulate data on the pages produced by or displayed on this website.

By continuing to use this website and its services, you agree to these

These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract.

I acknowledge I can only access these forms as a ComFree customer under contract.

Yes, I am a ComFree customer under contract

These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract and in partnership with Zubic Law.

I acknowledge I can only access these forms as a ComFree customer under contract.

Yes, I am a ComFree customer under contract

These forms are provided to ComFree’s Unrepresented Sellers as part of their Mere Posting ComFree Listing Contract and in partnership with Imperium LLP – Rocky Kim.

I acknowledge I can only access these forms as a ComFree customer under contract.

Yes, I am a ComFree customer under contract

How It Works

1. Purchase Your Package

2. We Ship Your ‘For Sale’ Sign

3. Book Your VR Tour

4. Complete Listing Input Forms

5. We Make Your Listing Live

6. Get Support 7 Days a Week

7. iSOLD!

MLS On The Fly Debug Panel

 Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25310
  +post_id: "1602037"
  +post_author: 1
  +"ListingKey": "30001128"
  +"ListingId": "X13533822"
  +"PropertyType": "Residential"
  +"PropertySubType": "Single Family"
  +"StandardStatus": "Active"
  +"ModificationTimestamp": "2026-07-07T19:20:09Z"
  +"RFModificationTimestamp": "2026-07-07T23:43:23Z"
  +"ListPrice": 1799900.0
  +"BathroomsTotalInteger": 4.0
  +"BathroomsHalf": 1
  +"BedroomsTotal": 5.0
  +"LotSizeArea": 0
  +"LivingArea": 0
  +"BuildingAreaTotal": 0
  +"City": "Waterloo"
  +"PostalCode": "N2V2Y4"
  +"UnparsedAddress": "422 RIDEAU RIVER STREET, Waterloo, Ontario N2V2Y4"
  +"Coordinates": array:2 [
    0 => -80.588911
    1 => 43.491282
  ]
  +"Latitude": 43.491282
  +"Longitude": -80.588911
  +"YearBuilt": 0
  +"InternetAddressDisplayYN": true
  +"FeedTypes": "IDX"
  +"OriginatingSystemName": "Toronto Regional Real Estate Board"
  +"PublicRemarks": "Experience luxury living at 422 Rideau River St in the highly sought-after ConservationMeadows community. This custom built home offers premium finishes, thoughtful design, and anincredible natural setting with no rear neighbours.A beautifully landscaped front approach, featuring an interlocking stone driveway, and naturalstone steps leading to the entrance, sets the tone for the exceptional craftsmanship foundthroughout. Inside, hand-scraped hardwood flooring extends across the main and second levels,The kitchen is a true showpiece, complete with a 14-foot soapstone waterfall island, cast ironsink, butler's pantry, and a premium Gaggenau appliance package that blends precision withperformance. From the kitchen, the home opens into comfortable living areas, including afamily room with a fireplace and large windows filling the room with natural light.The luxurious primary suite offers a private sitting area, custom dressing room, walk-inclosets with built-in cabinetry, and a spa-inspired ensuite featuring an oversized glassshower and a Victoria + Albert volcanic stone soaking tub. 3 additional spacious bedrooms anda 5-piece bath complete the upper level.The finished walk-out basement includes a large recreation room, dedicated media room wiredSonos sound system, a 5th bedroom, full bathroom with custom tile shower, upgradedpet-resistant carpeting, and a whimsical Fairy Play House with bunk loft.Additional features include a custom whiskey cabinet, built-in dog wash.The fully fenced backyard with garden beds, mature fruit trees, berry bushes, and rose gardenswhile overlooking a pond and the Stamm Woodlot with over 6 km of scenic walking trails.Moments from St. Jacobs Farmers' Market, Laurel Creek Conservation Area, and farm-freshprovisions. A truly signature residence in an exceptional location. A detailed propertyinformation package prepared for buyer review is available through MLS via your REALTOR (id:62650)"
  +"Appliances": array:12 [
    0 => "Washer"
    1 => "Refrigerator"
    2 => "Water meter"
    3 => "Dishwasher"
    4 => "Stove"
    5 => "Range"
    6 => "Dryer"
    7 => "Microwave"
    8 => "Freezer"
    9 => "Hood Fan"
    10 => "Window Coverings"
    11 => "Garage door opener remote(s)"
  ]
  +"Basement": array:5 [
    0 => "Finished"
    1 => "Full"
    2 => "Walk out"
    3 => "N/A"
    4 => "N/A"
  ]
  +"BathroomsPartial": 1
  +"CommunityFeatures": array:1 [
    0 => "School Bus"
  ]
  +"Cooling": array:2 [
    0 => "Central air conditioning"
    1 => "Air exchanger"
  ]
  +"CreationDate": "2026-07-07T23:43:20.278625+00:00"
  +"Directions": "Cross Streets: Pinery Trail. ** Directions: From Conservation Drive turn onto Rideau River St, follow around bend to home on R/S."
  +"ExteriorFeatures": array:2 [
    0 => "Brick"
    1 => "Stone"
  ]
  +"FireplaceYN": true
  +"FoundationDetails": array:1 [
    0 => "Poured Concrete"
  ]
  +"Heating": array:2 [
    0 => "Forced air"
    1 => "Natural gas"
  ]
  +"InternetEntireListingDisplayYN": true
  +"ListAgentKey": "2197726"
  +"ListOfficeKey": "294392"
  +"LivingAreaUnits": "square feet"
  +"LotFeatures": array:2 [
    0 => "Conservation/green belt"
    1 => "Sump Pump"
  ]
  +"LotSizeDimensions": "45 x 109.3 FT   ; 45.07ft. x 109.43ft. x 45.07ft. x109.43"
  +"ParkingFeatures": array:2 [
    0 => "Attached Garage"
    1 => "Garage"
  ]
  +"PhotosChangeTimestamp": "2026-07-07T19:11:30Z"
  +"PhotosCount": 50
  +"Sewer": array:1 [
    0 => "Sanitary sewer"
  ]
  +"StateOrProvince": "Ontario"
  +"StatusChangeTimestamp": "2026-07-07T19:11:29Z"
  +"Stories": "2.0"
  +"StreetName": "Rideau River"
  +"StreetNumber": "422"
  +"StreetSuffix": "Street"
  +"TaxAnnualAmount": "8878"
  +"WaterSource": array:1 [
    0 => "Municipal water"
  ]
  +"Rooms": array:19 [
    0 => array:11 [
      "RoomKey" => "1677550145"
      "RoomType" => "Bathroom"
      "ListingId" => "X13533822"
      "RoomLevel" => "Main level"
      "RoomWidth" => 0.93
      "ListingKey" => "30001128"
      "RoomLength" => 1.91
      "RoomDimensions" => null
      "RoomDescription" => null
      "RoomLengthWidthUnits" => "meters"
      "ModificationTimestamp" => "2026-07-07T19:11:29.67Z"
    ]
    1 => array:11 [
      "RoomKey" => "1677550146"
      "RoomType" => "Bedroom 2"
      "ListingId" => "X13533822"
      "RoomLevel" => "Second level"
      "RoomWidth" => 3.25
      "ListingKey" => "30001128"
      "RoomLength" => 3.37
      "RoomDimensions" => null
      "RoomDescription" => null
      "RoomLengthWidthUnits" => "meters"
      "ModificationTimestamp" => "2026-07-07T19:11:29.69Z"
    ]
    2 => array:11 [
      "RoomKey" => "1677550147"
      "RoomType" => "Bedroom 3"
      "ListingId" => "X13533822"
      "RoomLevel" => "Second level"
      "RoomWidth" => 5.42
      "ListingKey" => "30001128"
      "RoomLength" => 3.06
      "RoomDimensions" => null
      "RoomDescription" => null
      "RoomLengthWidthUnits" => "meters"
      "ModificationTimestamp" => "2026-07-07T19:11:29.7Z"
    ]
    3 => array:11 [
      "RoomKey" => "1677550148"
      "RoomType" => "Primary Bedroom"
      "ListingId" => "X13533822"
      "RoomLevel" => "Second level"
      "RoomWidth" => 4.86
      "ListingKey" => "30001128"
      "RoomLength" => 4.13
      "RoomDimensions" => null
      "RoomDescription" => null
      "RoomLengthWidthUnits" => "meters"
      "ModificationTimestamp" => "2026-07-07T19:11:29.7Z"
    ]
    4 => array:11 [
      "RoomKey" => "1677550149"
      "RoomType" => "Bathroom"
      "ListingId" => "X13533822"
      "RoomLevel" => "Basement"
      "RoomWidth" => 1.75
      "ListingKey" => "30001128"
      "RoomLength" => 3.1
      "RoomDimensions" => null
      "RoomDescription" => null
      "RoomLengthWidthUnits" => "meters"
      "ModificationTimestamp" => "2026-07-07T19:11:29.73Z"
    ]
    5 => array:11 [
      "RoomKey" => "1677550150"
      "RoomType" => "Bedroom 5"
      "ListingId" => "X13533822"
      "RoomLevel" => "Basement"
      "RoomWidth" => 1.94
      "ListingKey" => "30001128"
      "RoomLength" => 1.74
      "RoomDimensions" => null
      "RoomDescription" => null
      "RoomLengthWidthUnits" => "meters"
      "ModificationTimestamp" => "2026-07-07T19:11:29.73Z"
    ]
    6 => array:11 [
      "RoomKey" => "1677550151"
      "RoomType" => "Other"
      "ListingId" => "X13533822"
      "RoomLevel" => "Basement"
      "RoomWidth" => 5.53
      "ListingKey" => "30001128"
      "RoomLength" => 3.11
      "RoomDimensions" => null
      "RoomDescription" => null
      "RoomLengthWidthUnits" => "meters"
      "ModificationTimestamp" => "2026-07-07T19:11:29.74Z"
    ]
    7 => array:11 [
      "RoomKey" => "1677550152"
      "RoomType" => "Recreational, Games room"
      "ListingId" => "X13533822"
      "RoomLevel" => "Basement"
      "RoomWidth" => 7.76
      "ListingKey" => "30001128"
      "RoomLength" => 10.59
      "RoomDimensions" => null
      "RoomDescription" => null
      "RoomLengthWidthUnits" => "meters"
      "ModificationTimestamp" => "2026-07-07T19:11:29.76Z"
    ]
    8 => array:11 [
      "RoomKey" => "1677550153"
      "RoomType" => "Utility room"
      "ListingId" => "X13533822"
      "RoomLevel" => "Basement"
      "RoomWidth" => 1.75
      "ListingKey" => "30001128"
      "RoomLength" => 1.42
      "RoomDimensions" => null
      "RoomDescription" => null
      "RoomLengthWidthUnits" => "meters"
      "ModificationTimestamp" => "2026-07-07T19:11:29.79Z"
    ]
    9 => array:11 [
      "RoomKey" => "1677550154"
      "RoomType" => "Utility room"
      "ListingId" => "X13533822"
      "RoomLevel" => "Basement"
      "RoomWidth" => 2.88
      "ListingKey" => "30001128"
      "RoomLength" => 3.42
      "RoomDimensions" => null
      "RoomDescription" => null
      "RoomLengthWidthUnits" => "meters"
      "ModificationTimestamp" => "2026-07-07T19:11:29.8Z"
    ]
    10 => array:11 [
      "RoomKey" => "1677550155"
      "RoomType" => "Dining room"
      "ListingId" => "X13533822"
      "RoomLevel" => "Main level"
      "RoomWidth" => 3.37
      "ListingKey" => "30001128"
      "RoomLength" => 5.28
      "RoomDimensions" => null
      "RoomDescription" => null
      "RoomLengthWidthUnits" => "meters"
      "ModificationTimestamp" => "2026-07-07T19:11:29.8Z"
    ]
    11 => array:11 [
      "RoomKey" => "1677550156"
      "RoomType" => "Family room"
      "ListingId" => "X13533822"
      "RoomLevel" => "Main level"
      "RoomWidth" => 4.88
      "ListingKey" => "30001128"
      "RoomLength" => 4.19
      "RoomDimensions" => null
      "RoomDescription" => null
      "RoomLengthWidthUnits" => "meters"
      "ModificationTimestamp" => "2026-07-07T19:11:29.81Z"
    ]
    12 => array:11 [
      "RoomKey" => "1677550157"
      "RoomType" => "Other"
      "ListingId" => "X13533822"
      "RoomLevel" => "Main level"
      "RoomWidth" => 6.42
      "ListingKey" => "30001128"
      "RoomLength" => 5.4
      "RoomDimensions" => null
      "RoomDescription" => null
      "RoomLengthWidthUnits" => "meters"
      "ModificationTimestamp" => "2026-07-07T19:11:29.81Z"
    ]
    13 => array:11 [
      "RoomKey" => "1677550158"
      "RoomType" => "Kitchen"
      "ListingId" => "X13533822"
      "RoomLevel" => "Main level"
      "RoomWidth" => 5.21
      "ListingKey" => "30001128"
      "RoomLength" => 6.52
      "RoomDimensions" => null
      "RoomDescription" => null
      "RoomLengthWidthUnits" => "meters"
      "ModificationTimestamp" => "2026-07-07T19:11:29.81Z"
    ]
    14 => array:11 [
      "RoomKey" => "1677550159"
      "RoomType" => "Laundry room"
      "ListingId" => "X13533822"
      "RoomLevel" => "Main level"
      "RoomWidth" => 2.6
      "ListingKey" => "30001128"
      "RoomLength" => 2.91
      "RoomDimensions" => null
      "RoomDescription" => null
      "RoomLengthWidthUnits" => "meters"
      "ModificationTimestamp" => "2026-07-07T19:11:29.82Z"
    ]
    15 => array:11 [
      "RoomKey" => "1677550160"
      "RoomType" => "Living room"
      "ListingId" => "X13533822"
      "RoomLevel" => "Main level"
      "RoomWidth" => 4.1
      "ListingKey" => "30001128"
      "RoomLength" => 3.27
      "RoomDimensions" => null
      "RoomDescription" => null
      "RoomLengthWidthUnits" => "meters"
      "ModificationTimestamp" => "2026-07-07T19:11:29.82Z"
    ]
    16 => array:11 [
      "RoomKey" => "1677550161"
      "RoomType" => "Bathroom"
      "ListingId" => "X13533822"
      "RoomLevel" => "Second level"
      "RoomWidth" => 3.12
      "ListingKey" => "30001128"
      "RoomLength" => 2.73
      "RoomDimensions" => null
      "RoomDescription" => null
      "RoomLengthWidthUnits" => "meters"
      "ModificationTimestamp" => "2026-07-07T19:11:29.82Z"
    ]
    17 => array:11 [
      "RoomKey" => "1677550162"
      "RoomType" => "Bathroom"
      "ListingId" => "X13533822"
      "RoomLevel" => "Second level"
      "RoomWidth" => 2.97
      "ListingKey" => "30001128"
      "RoomLength" => 3.63
      "RoomDimensions" => null
      "RoomDescription" => null
      "RoomLengthWidthUnits" => "meters"
      "ModificationTimestamp" => "2026-07-07T19:11:29.85Z"
    ]
    18 => array:11 [
      "RoomKey" => "1677550163"
      "RoomType" => "Bedroom"
      "ListingId" => "X13533822"
      "RoomLevel" => "Second level"
      "RoomWidth" => 4.62
      "ListingKey" => "30001128"
      "RoomLength" => 4.31
      "RoomDimensions" => null
      "RoomDescription" => null
      "RoomLengthWidthUnits" => "meters"
      "ModificationTimestamp" => "2026-07-07T19:11:29.85Z"
    ]
  ]
  +"ListAOR": "Toronto"
  +"TaxYear": 2026
  +"ListAORKey": "82"
  +"ListingURL": "www.realtor.ca/real-estate/30001128/422-rideau-river-street-waterloo"
  +"ParkingTotal": 4
  +"StructureType": array:1 [
    0 => "House"
  ]
  +"CommonInterest": "Freehold"
  +"GeocodeManualYN": false
  +"BuildingFeatures": array:1 [
    0 => "Fireplace(s)"
  ]
  +"SecurityFeatures": array:2 [
    0 => "Security system"
    1 => "Smoke Detectors"
  ]
  +"LivingAreaMaximum": 3000
  +"LivingAreaMinimum": 2500
  +"ZoningDescription": "R4"
  +"BedroomsAboveGrade": 4
  +"BedroomsBelowGrade": 1
  +"FrontageLengthNumeric": 45.0
  +"OriginalEntryTimestamp": "2026-07-07T19:11:29.33Z"
  +"FrontageLengthNumericUnits": "feet"
  +"ListAgentNationalAssociationId": "1446142"
  +"ListOfficeNationalAssociationId": "1438599"
  +"Media": array:50 [
    0 => array:13 [
      "Order" => 1
      "MediaKey" => "30001128_4890_1"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/544683894a3a9fff22a2eef725e8c48d.webp"
      "MediaSize" => 390388
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-544683894a3a9fff22a2eef725e8c48d.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Front Stone Exterior, Interlocking Stone Driveway"
      "PreferredPhotoYN" => true
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    1 => array:13 [
      "Order" => 2
      "MediaKey" => "30001128_4890_2"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/f282b57792fdcdcfdcc628d57c50bf23.webp"
      "MediaSize" => 434807
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-f282b57792fdcdcfdcc628d57c50bf23.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Main Entrance"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    2 => array:13 [
      "Order" => 3
      "MediaKey" => "30001128_4890_3"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/fd69053d578784feaa3a825b1b97c8eb.webp"
      "MediaSize" => 237743
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-fd69053d578784feaa3a825b1b97c8eb.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Foyer with 3/4\" hand scraped hardwood"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    3 => array:13 [
      "Order" => 4
      "MediaKey" => "30001128_4890_4"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/ec4c642074a0d1dcb9bd6015ec0ca8d0.webp"
      "MediaSize" => 214491
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-ec4c642074a0d1dcb9bd6015ec0ca8d0.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Foyer with 3/4\" hand scraped hardwood"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    4 => array:13 [
      "Order" => 5
      "MediaKey" => "30001128_4890_5"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/fd8e784e415ba05dbe17e4061b63376f.webp"
      "MediaSize" => 169403
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-fd8e784e415ba05dbe17e4061b63376f.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Foyer with 3/4\" hand scraped hardwood"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    5 => array:13 [
      "Order" => 6
      "MediaKey" => "30001128_4890_6"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/7d4a964f23a74b0c9b76bb0c7d01eec4.webp"
      "MediaSize" => 245474
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-7d4a964f23a74b0c9b76bb0c7d01eec4.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Sonos System Wired Through House With 6 Zones"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    6 => array:13 [
      "Order" => 7
      "MediaKey" => "30001128_4890_7"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/ac23e221acab7d631c5ec3bf047bb62a.webp"
      "MediaSize" => 242840
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-ac23e221acab7d631c5ec3bf047bb62a.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    7 => array:13 [
      "Order" => 8
      "MediaKey" => "30001128_4890_8"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/0113612702a4383135c251cf93bf4959.webp"
      "MediaSize" => 128712
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-0113612702a4383135c251cf93bf4959.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    8 => array:13 [
      "Order" => 9
      "MediaKey" => "30001128_4890_9"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/0e68689388f0dcba3edc8a2ae286ab42.webp"
      "MediaSize" => 250778
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-0e68689388f0dcba3edc8a2ae286ab42.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    9 => array:13 [
      "Order" => 10
      "MediaKey" => "30001128_4890_10"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/0fbe9ddc13aa84e12ea87b397f192f9e.webp"
      "MediaSize" => 242679
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-0fbe9ddc13aa84e12ea87b397f192f9e.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    10 => array:13 [
      "Order" => 11
      "MediaKey" => "30001128_4890_11"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/0ed232db033c147cea7b2b9651f10ac0.webp"
      "MediaSize" => 238086
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-0ed232db033c147cea7b2b9651f10ac0.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    11 => array:13 [
      "Order" => 12
      "MediaKey" => "30001128_4890_12"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/f878fd0b8a799deb2065ecae732fbf4c.webp"
      "MediaSize" => 206193
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-f878fd0b8a799deb2065ecae732fbf4c.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    12 => array:13 [
      "Order" => 13
      "MediaKey" => "30001128_4890_13"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/f1d419b88a1d5278839405e6dd15507f.webp"
      "MediaSize" => 224653
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-f1d419b88a1d5278839405e6dd15507f.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    13 => array:13 [
      "Order" => 14
      "MediaKey" => "30001128_4890_14"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/a5a8e483e68c6b619e38c130d4e84bc6.webp"
      "MediaSize" => 190495
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-a5a8e483e68c6b619e38c130d4e84bc6.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    14 => array:13 [
      "Order" => 15
      "MediaKey" => "30001128_4890_15"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/96eb110ea58d2c10a63079eb66f60c35.webp"
      "MediaSize" => 180271
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-96eb110ea58d2c10a63079eb66f60c35.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Custom Kitchen Designed By Xanadu Fine Homes"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    15 => array:13 [
      "Order" => 16
      "MediaKey" => "30001128_4890_16"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/337951723abc3ec722c34a42a2a2642c.webp"
      "MediaSize" => 166265
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-337951723abc3ec722c34a42a2a2642c.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Oversized (14lf) Soap Stone Waterfall island"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    16 => array:13 [
      "Order" => 17
      "MediaKey" => "30001128_4890_17"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/fe9a82259b52f2be5f0fdcc743bfa767.webp"
      "MediaSize" => 192018
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-fe9a82259b52f2be5f0fdcc743bfa767.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "All Appliances Are Gaggeneau"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    17 => array:13 [
      "Order" => 18
      "MediaKey" => "30001128_4890_18"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/ac256d9e9f2900208ce0bdb04993feec.webp"
      "MediaSize" => 187553
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-ac256d9e9f2900208ce0bdb04993feec.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Custom Inserts Into Pull Out Drawers And Cupboards"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    18 => array:13 [
      "Order" => 19
      "MediaKey" => "30001128_4890_19"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/5cec7355aa5263e1f99876304d08d551.webp"
      "MediaSize" => 106350
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-5cec7355aa5263e1f99876304d08d551.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    19 => array:13 [
      "Order" => 20
      "MediaKey" => "30001128_4890_20"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/38371b288fb29337df7ffbe81ddf6fa8.webp"
      "MediaSize" => 109741
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-38371b288fb29337df7ffbe81ddf6fa8.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    20 => array:13 [
      "Order" => 21
      "MediaKey" => "30001128_4890_21"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/c6833eb73e496f82cbb9e378990076f9.webp"
      "MediaSize" => 301116
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-c6833eb73e496f82cbb9e378990076f9.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    21 => array:13 [
      "Order" => 22
      "MediaKey" => "30001128_4890_22"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/49ce6e92ab04417ba0b7e92efbff4105.webp"
      "MediaSize" => 327149
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-49ce6e92ab04417ba0b7e92efbff4105.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    22 => array:13 [
      "Order" => 23
      "MediaKey" => "30001128_4890_23"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/95758937830bce990dca8a88a9dc7135.webp"
      "MediaSize" => 120874
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-95758937830bce990dca8a88a9dc7135.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Samsung Front Load Washer And Dryer"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    23 => array:13 [
      "Order" => 24
      "MediaKey" => "30001128_4890_24"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/9e7e9003081f6fca1f62c78f2abe895b.webp"
      "MediaSize" => 101881
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-9e7e9003081f6fca1f62c78f2abe895b.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Built In Dog Shower In Laundry Room"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    24 => array:13 [
      "Order" => 25
      "MediaKey" => "30001128_4890_25"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/bbdce7f14a360a765e6bd5ea3cb4c1f6.webp"
      "MediaSize" => 108453
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-bbdce7f14a360a765e6bd5ea3cb4c1f6.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    25 => array:13 [
      "Order" => 26
      "MediaKey" => "30001128_4890_26"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/518127c61eb93d853683057eea9bb582.webp"
      "MediaSize" => 149906
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-518127c61eb93d853683057eea9bb582.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    26 => array:13 [
      "Order" => 27
      "MediaKey" => "30001128_4890_27"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/8251918206b4a85834e8078560b37d37.webp"
      "MediaSize" => 220004
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-8251918206b4a85834e8078560b37d37.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    27 => array:13 [
      "Order" => 28
      "MediaKey" => "30001128_4890_28"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/b3484bdce984f0e37466293a346bdd7d.webp"
      "MediaSize" => 259785
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-b3484bdce984f0e37466293a346bdd7d.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    28 => array:13 [
      "Order" => 29
      "MediaKey" => "30001128_4890_29"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/ce764b524ea43fac5c83addf69c6cd2d.webp"
      "MediaSize" => 215058
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-ce764b524ea43fac5c83addf69c6cd2d.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    29 => array:13 [
      "Order" => 30
      "MediaKey" => "30001128_4890_30"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/f89de90a6007175ee7cc64ecd60b99f3.webp"
      "MediaSize" => 269974
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-f89de90a6007175ee7cc64ecd60b99f3.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    30 => array:13 [
      "Order" => 31
      "MediaKey" => "30001128_4890_31"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/a9f053889ec5aaa737cbcac5d763c06e.webp"
      "MediaSize" => 166309
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-a9f053889ec5aaa737cbcac5d763c06e.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Victoria And Albert Lava Rock Tub In Ensuite"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    31 => array:13 [
      "Order" => 32
      "MediaKey" => "30001128_4890_32"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/aafb669f4d585cbb6ad71c80066b1504.webp"
      "MediaSize" => 171493
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-aafb669f4d585cbb6ad71c80066b1504.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Victoria And Albert Lava Rock Tub In Ensuite"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    32 => array:13 [
      "Order" => 33
      "MediaKey" => "30001128_4890_33"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/fd4c4866d6ecbf2bc95a6aeaa91f158a.webp"
      "MediaSize" => 84082
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-fd4c4866d6ecbf2bc95a6aeaa91f158a.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    33 => array:13 [
      "Order" => 34
      "MediaKey" => "30001128_4890_34"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/631a75b14f6ac92414ce016116aa64ae.webp"
      "MediaSize" => 201715
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-631a75b14f6ac92414ce016116aa64ae.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    34 => array:13 [
      "Order" => 35
      "MediaKey" => "30001128_4890_35"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/8832e97d83e3e536e32603dfb560ac3c.webp"
      "MediaSize" => 139951
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-8832e97d83e3e536e32603dfb560ac3c.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    35 => array:13 [
      "Order" => 36
      "MediaKey" => "30001128_4890_36"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/751034bba534722805d1e4fa2982347c.webp"
      "MediaSize" => 177047
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-751034bba534722805d1e4fa2982347c.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    36 => array:13 [
      "Order" => 37
      "MediaKey" => "30001128_4890_37"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/e045ee001d7aa43defa9faf5c71bc87f.webp"
      "MediaSize" => 248446
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-e045ee001d7aa43defa9faf5c71bc87f.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    37 => array:13 [
      "Order" => 38
      "MediaKey" => "30001128_4890_38"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/7daced1869f33df55eb674ddf15d5154.webp"
      "MediaSize" => 218950
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-7daced1869f33df55eb674ddf15d5154.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    38 => array:13 [
      "Order" => 39
      "MediaKey" => "30001128_4890_39"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/2507cc7da8344972897493a708e302c6.webp"
      "MediaSize" => 207583
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-2507cc7da8344972897493a708e302c6.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Upgraded Pet Resistant Carpeting"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    39 => array:13 [
      "Order" => 40
      "MediaKey" => "30001128_4890_40"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/04b112500dcfea2779d0025d24721e43.webp"
      "MediaSize" => 222530
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-04b112500dcfea2779d0025d24721e43.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Underpad In Basement"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    40 => array:13 [
      "Order" => 41
      "MediaKey" => "30001128_4890_41"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/60c723d1a43cad450a5f766e57bdc8f6.webp"
      "MediaSize" => 141984
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-60c723d1a43cad450a5f766e57bdc8f6.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Custom Lazer Cut Tiles In Shower"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    41 => array:13 [
      "Order" => 42
      "MediaKey" => "30001128_4890_42"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/a14d5086c04050f51f82f4455c0a682a.webp"
      "MediaSize" => 201927
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-a14d5086c04050f51f82f4455c0a682a.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Full Work Out Room In Basement"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    42 => array:13 [
      "Order" => 43
      "MediaKey" => "30001128_4890_43"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/b05fd1d892340ee4a8bb47ea4a707577.webp"
      "MediaSize" => 491568
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-b05fd1d892340ee4a8bb47ea4a707577.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Gazebo In Backyard and Propane Gas Fire Pit"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    43 => array:13 [
      "Order" => 44
      "MediaKey" => "30001128_4890_44"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/9feb0d1bc9d9d9dcec318c64f54dd1db.webp"
      "MediaSize" => 430210
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-9feb0d1bc9d9d9dcec318c64f54dd1db.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Exterior Propane Line For Barbecue"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    44 => array:13 [
      "Order" => 45
      "MediaKey" => "30001128_4890_45"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/865734ec9044dc5547d3d81fee9210ea.webp"
      "MediaSize" => 501429
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-865734ec9044dc5547d3d81fee9210ea.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    45 => array:13 [
      "Order" => 46
      "MediaKey" => "30001128_4890_46"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/d30ed542082257854554cae45ecfb381.webp"
      "MediaSize" => 489803
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-d30ed542082257854554cae45ecfb381.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Outside Fenced In Separate Garden"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    46 => array:13 [
      "Order" => 47
      "MediaKey" => "30001128_4890_47"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/279c49089dab5bdbf786ea4e8fa0c227.webp"
      "MediaSize" => 480107
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-279c49089dab5bdbf786ea4e8fa0c227.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Outside Fenced In Separate Garden"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    47 => array:13 [
      "Order" => 48
      "MediaKey" => "30001128_4890_48"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/899282eb66ebea4285ea97958a6e585b.webp"
      "MediaSize" => 445954
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-899282eb66ebea4285ea97958a6e585b.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    48 => array:13 [
      "Order" => 49
      "MediaKey" => "30001128_4890_49"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/eee5b3303c9ccab146c9410a96e89ed8.webp"
      "MediaSize" => 439826
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-eee5b3303c9ccab146c9410a96e89ed8.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
    49 => array:13 [
      "Order" => 50
      "MediaKey" => "30001128_4890_50"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001128/0f0914fcf44449244251f0cd1a9cffe1.webp"
      "MediaSize" => 287076
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001128/thumbnail-0f0914fcf44449244251f0cd1a9cffe1.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Front Stone Exterior, Interlocking Stone Driveway"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "X13533822"
      "ResourceRecordKey" => "30001128"
      "ModificationTimestamp" => "2026-07-07T19:11:29.35Z"
    ]
  ]
  +"DaysOnMarket": 0
  +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30001128')"
  +"ID": "1602037"
}

MLS On The Fly Debug Panel

 array:6 [
  "RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30001669 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23447
      +items: array:1 [
        0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23449
          +post_id: "1602047"
          +post_author: 1
          +"ListingKey": "30001669"
          +"ListingId": "40845281"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-07-07T20:35:24Z"
          +"RFModificationTimestamp": "2026-07-07T23:05:36Z"
          +"ListPrice": 1150000.0
          +"BathroomsTotalInteger": 4.0
          +"BathroomsHalf": 0
          +"BedroomsTotal": 5.0
          +"LotSizeArea": 0
          +"LivingArea": 3716.0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V2K2"
          +"UnparsedAddress": "538 SANDBANKS Crescent, Waterloo, Ontario N2V2K2"
          +"Coordinates": array:2 [
            0 => -80.5798863
            1 => 43.4958737
          ]
          +"Latitude": 43.4958737
          +"Longitude": -80.5798863
          +"YearBuilt": 2000
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
          +"PublicRemarks": "Welcome to 538 Sandbanks Crescent, a stunning and beautifully updated home nestled in the highly sought-after Laurelwood neighbourhood in Waterloo. From the moment you arrive it is clear this home has been cared for with exceptional pride of ownership and thoughtful attention to detail throughout. Backing onto protected green space and filled with an abundance of natural light, this home offers the perfect blend of comfort, flexibility and modern living. The layout is incredibly versatile featuring two flexible main floor rooms that can be used as a home office, den or additional bedrooms depending on your family's needs, along with a full bathroom on the main level, making it ideal for multigenerational living or aging parents. With a generous above grade footprint plus a finished walkout basement, there is no shortage of space for everyone to enjoy. Located just steps from Laurel Creek Conservation Area, 6 minutes from the charming village of St. Jacobs, and within the catchment of top ranked schools including Laurelwood Public School and Laurel Heights Secondary School. The Stork Family YMCA, Waterloo Public Library and The Boardwalk shopping district are all just minutes away. This truly is a neighbourhood people fall in love with and never want to leave. Updates include a new air conditioner (2022), quartz countertops in the kitchen (2024), new water softener (2025), updated paint throughout various areas, professionally painted entry, main and upstairs hallways and updated vanity taps in the upstairs bathroom (2026). Truly move in ready. Do not miss your opportunity to call this incredible home yours! (id:62650)"
          +"Appliances": array:10 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Water softener"
            3 => "Central Vacuum"
            4 => "Dishwasher"
            5 => "Stove"
            6 => "Dryer"
            7 => "Microwave"
            8 => "Hood Fan"
            9 => "Window Coverings"
          ]
          +"Basement": array:2 [
            0 => "Finished"
            1 => "Full"
          ]
          +"CommunityFeatures": array:1 [
            0 => "Quiet Area"
          ]
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-07-07T23:05:29.635886+00:00"
          +"ExteriorFeatures": array:2 [
            0 => "Brick"
            1 => "Vinyl siding"
          ]
          +"FireplaceYN": true
          +"FireplacesTotal": "1"
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "2103569"
          +"ListOfficeKey": "156376"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:3 [
            0 => "Conservation/green belt"
            1 => "Sump Pump"
            2 => "Automatic Garage Door Opener"
          ]
          +"ParkingFeatures": array:1 [
            0 => "Attached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-07-07T20:29:28Z"
          +"PhotosCount": 45
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-07-07T20:29:27Z"
          +"Stories": "2.0"
          +"StreetName": "SANDBANKS"
          +"StreetNumber": "538"
          +"StreetSuffix": "Crescent"
          +"SubdivisionName": "441 - Erbsville/Laurelwood"
          +"TaxAnnualAmount": "7891.76"
          +"VirtualTourURLUnbranded": "https://youriguide.com/538_sandbanks_crescent_waterloo_on/"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:18 [
            0 => array:11 [
              "RoomKey" => "1677609240"
              "RoomType" => "Utility room"
              "ListingId" => "40845281"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "30001669"
              "RoomLength" => null
              "RoomDimensions" => "10'6'' x 15'3''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-07T20:29:27.99Z"
            ]
            1 => array:11 [
              "RoomKey" => "1677609241"
              "RoomType" => "Mud room"
              "ListingId" => "40845281"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "30001669"
              "RoomLength" => null
              "RoomDimensions" => "10'5'' x 9'11''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-07T20:29:27.99Z"
            ]
            2 => array:11 [
              "RoomKey" => "1677609242"
              "RoomType" => "3pc Bathroom"
              "ListingId" => "40845281"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "30001669"
              "RoomLength" => null
              "RoomDimensions" => "17'1'' x 5'11''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-07T20:29:27.99Z"
            ]
            3 => array:11 [
              "RoomKey" => "1677609243"
              "RoomType" => "Bedroom"
              "ListingId" => "40845281"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "30001669"
              "RoomLength" => null
              "RoomDimensions" => "10'7'' x 12'1''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-07T20:29:27.99Z"
            ]
            4 => array:11 [
              "RoomKey" => "1677609244"
              "RoomType" => "Gym"
              "ListingId" => "40845281"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "30001669"
              "RoomLength" => null
              "RoomDimensions" => "11'7'' x 12'7''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-07T20:29:27.99Z"
            ]
            5 => array:11 [
              "RoomKey" => "1677609245"
              "RoomType" => "Recreation room"
              "ListingId" => "40845281"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "30001669"
              "RoomLength" => null
              "RoomDimensions" => "17'1'' x 13'1''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-07T20:29:27.99Z"
            ]
            6 => array:11 [
              "RoomKey" => "1677609246"
              "RoomType" => "4pc Bathroom"
              "ListingId" => "40845281"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "30001669"
              "RoomLength" => null
              "RoomDimensions" => "7'6'' x 9'3''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-07T20:29:27.99Z"
            ]
            7 => array:11 [
              "RoomKey" => "1677609247"
              "RoomType" => "Bedroom"
              "ListingId" => "40845281"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "30001669"
              "RoomLength" => null
              "RoomDimensions" => "11'10'' x 20'4''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-07T20:29:27.99Z"
            ]
            8 => array:11 [
              "RoomKey" => "1677609248"
              "RoomType" => "Bedroom"
              "ListingId" => "40845281"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "30001669"
              "RoomLength" => null
              "RoomDimensions" => "9'10'' x 12'8''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-07T20:29:28Z"
            ]
            9 => array:11 [
              "RoomKey" => "1677609249"
              "RoomType" => "Bedroom"
              "ListingId" => "40845281"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "30001669"
              "RoomLength" => null
              "RoomDimensions" => "9'10'' x 12'0''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-07T20:29:28Z"
            ]
            10 => array:11 [
              "RoomKey" => "1677609250"
              "RoomType" => "Full bathroom"
              "ListingId" => "40845281"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "30001669"
              "RoomLength" => null
              "RoomDimensions" => "9'10'' x 13'2''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-07T20:29:28Z"
            ]
            11 => array:11 [
              "RoomKey" => "1677609251"
              "RoomType" => "Primary Bedroom"
              "ListingId" => "40845281"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "30001669"
              "RoomLength" => null
              "RoomDimensions" => "18'10'' x 11'4''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-07T20:29:28Z"
            ]
            12 => array:11 [
              "RoomKey" => "1677609252"
              "RoomType" => "3pc Bathroom"
              "ListingId" => "40845281"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "30001669"
              "RoomLength" => null
              "RoomDimensions" => "7'10'' x 7'0''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-07T20:29:28Z"
            ]
            13 => array:11 [
              "RoomKey" => "1677609253"
              "RoomType" => "Den"
              "ListingId" => "40845281"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "30001669"
              "RoomLength" => null
              "RoomDimensions" => "10'9'' x 11'3''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-07T20:29:28Z"
            ]
            14 => array:11 [
              "RoomKey" => "1677609254"
              "RoomType" => "Living room"
              "ListingId" => "40845281"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "30001669"
              "RoomLength" => null
              "RoomDimensions" => "17'9'' x 12'11''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-07T20:29:28Z"
            ]
            15 => array:11 [
              "RoomKey" => "1677609255"
              "RoomType" => "Dinette"
              "ListingId" => "40845281"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "30001669"
              "RoomLength" => null
              "RoomDimensions" => "11'0'' x 9'9''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-07T20:29:28Z"
            ]
            16 => array:11 [
              "RoomKey" => "1677609256"
              "RoomType" => "Kitchen"
              "ListingId" => "40845281"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "30001669"
              "RoomLength" => null
              "RoomDimensions" => "11'2'' x 13'1''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-07T20:29:28Z"
            ]
            17 => array:11 [
              "RoomKey" => "1677609257"
              "RoomType" => "Office"
              "ListingId" => "40845281"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "30001669"
              "RoomLength" => null
              "RoomDimensions" => "10'9'' x 16'5''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-07T20:29:28Z"
            ]
          ]
          +"ListAOR": "Cornerstone"
          +"ListAORKey": "14"
          +"ListingURL": "www.realtor.ca/real-estate/30001669/538-sandbanks-crescent-waterloo"
          +"ParkingTotal": 4
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"SecurityFeatures": array:1 [
            0 => "Smoke Detectors"
          ]
          +"ZoningDescription": "R"
          +"BedroomsAboveGrade": 4
          +"BedroomsBelowGrade": 1
          +"FrontageLengthNumeric": 42.0
          +"AboveGradeFinishedArea": 2492
          +"BelowGradeFinishedArea": 1224
          +"OriginalEntryTimestamp": "2026-07-07T20:29:27.96Z"
          +"FrontageLengthNumericUnits": "feet"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"BelowGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Other"
          +"BelowGradeFinishedAreaSource": "Other"
          +"ListAgentNationalAssociationId": "1373130"
          +"ListOfficeNationalAssociationId": "1003925"
          +"Media": array:45 [
            0 => array:13 [
              "Order" => 1
              "MediaKey" => "30001669_4890_1"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/fd6bc38f744a34246847557a4b0550ed.webp"
              "MediaSize" => 126981
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-fd6bc38f744a34246847557a4b0550ed.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => true
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            1 => array:13 [
              "Order" => 2
              "MediaKey" => "30001669_4890_2"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/9912a919655d74787c074dfcf1c22893.webp"
              "MediaSize" => 166725
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-9912a919655d74787c074dfcf1c22893.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            2 => array:13 [
              "Order" => 3
              "MediaKey" => "30001669_4890_3"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/8630697fd1447f9bc7b24825dc182ecf.webp"
              "MediaSize" => 146965
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-8630697fd1447f9bc7b24825dc182ecf.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            3 => array:13 [
              "Order" => 4
              "MediaKey" => "30001669_4890_4"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/1dc7d54ac5ff9ec272a07c16f29d82fb.webp"
              "MediaSize" => 171285
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-1dc7d54ac5ff9ec272a07c16f29d82fb.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            4 => array:13 [
              "Order" => 5
              "MediaKey" => "30001669_4890_5"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/629e49cca8a9fb9038f148471f7c3099.webp"
              "MediaSize" => 72726
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-629e49cca8a9fb9038f148471f7c3099.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            5 => array:13 [
              "Order" => 6
              "MediaKey" => "30001669_4890_6"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/830a4ee8291647c64b7773c569b780ca.webp"
              "MediaSize" => 81099
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-830a4ee8291647c64b7773c569b780ca.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            6 => array:13 [
              "Order" => 7
              "MediaKey" => "30001669_4890_7"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/5e0b28650135c0334c5440c01174d91a.webp"
              "MediaSize" => 97037
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-5e0b28650135c0334c5440c01174d91a.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            7 => array:13 [
              "Order" => 8
              "MediaKey" => "30001669_4890_8"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/a3ec705924fa7bd58bcf5982135cdee5.webp"
              "MediaSize" => 68387
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-a3ec705924fa7bd58bcf5982135cdee5.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            8 => array:13 [
              "Order" => 9
              "MediaKey" => "30001669_4890_9"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/2b6d96e56cb59a2c4e9b81c744de0891.webp"
              "MediaSize" => 65984
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-2b6d96e56cb59a2c4e9b81c744de0891.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            9 => array:13 [
              "Order" => 10
              "MediaKey" => "30001669_4890_10"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/920b1a78b677a089fc00e6858c0af6da.webp"
              "MediaSize" => 79546
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-920b1a78b677a089fc00e6858c0af6da.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            10 => array:13 [
              "Order" => 11
              "MediaKey" => "30001669_4890_11"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/00e5b5657527ff74c917881882b26cb4.webp"
              "MediaSize" => 87360
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-00e5b5657527ff74c917881882b26cb4.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            11 => array:13 [
              "Order" => 12
              "MediaKey" => "30001669_4890_12"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/eba678d160dff615e07bb8e83eebaf18.webp"
              "MediaSize" => 74230
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-eba678d160dff615e07bb8e83eebaf18.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            12 => array:13 [
              "Order" => 13
              "MediaKey" => "30001669_4890_13"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/09c435ebb568b2966e663f02ff5fd5c3.webp"
              "MediaSize" => 54510
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-09c435ebb568b2966e663f02ff5fd5c3.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            13 => array:13 [
              "Order" => 14
              "MediaKey" => "30001669_4890_14"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/827936e52feeaa5a582881dfa1ce6799.webp"
              "MediaSize" => 82967
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-827936e52feeaa5a582881dfa1ce6799.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            14 => array:13 [
              "Order" => 15
              "MediaKey" => "30001669_4890_15"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/29607d6e82f0a4a90c94d3d99484e00d.webp"
              "MediaSize" => 73952
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-29607d6e82f0a4a90c94d3d99484e00d.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            15 => array:13 [
              "Order" => 16
              "MediaKey" => "30001669_4890_16"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/93132c483384949db15956388593fc55.webp"
              "MediaSize" => 73240
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-93132c483384949db15956388593fc55.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            16 => array:13 [
              "Order" => 17
              "MediaKey" => "30001669_4890_17"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/c01e568902cac94ae41fadefbe3755fe.webp"
              "MediaSize" => 75425
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-c01e568902cac94ae41fadefbe3755fe.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            17 => array:13 [
              "Order" => 18
              "MediaKey" => "30001669_4890_18"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/ccb6b6a04f7b9f5bd80846c2f5c8638a.webp"
              "MediaSize" => 78744
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-ccb6b6a04f7b9f5bd80846c2f5c8638a.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            18 => array:13 [
              "Order" => 19
              "MediaKey" => "30001669_4890_19"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/d6641f348c85a71e75740a189b809f34.webp"
              "MediaSize" => 67052
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-d6641f348c85a71e75740a189b809f34.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            19 => array:13 [
              "Order" => 20
              "MediaKey" => "30001669_4890_20"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/e2a9e577d13c98cd81e3071d34a194b1.webp"
              "MediaSize" => 69513
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-e2a9e577d13c98cd81e3071d34a194b1.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            20 => array:13 [
              "Order" => 21
              "MediaKey" => "30001669_4890_21"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/f0449add5fe8114e4b121f2a96f7de3f.webp"
              "MediaSize" => 61009
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-f0449add5fe8114e4b121f2a96f7de3f.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            21 => array:13 [
              "Order" => 22
              "MediaKey" => "30001669_4890_22"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/21d9b33b7235a0e0f4e1be478c583101.webp"
              "MediaSize" => 83708
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-21d9b33b7235a0e0f4e1be478c583101.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            22 => array:13 [
              "Order" => 23
              "MediaKey" => "30001669_4890_23"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/d8b7aee2f860cb0da8eb64a94075976e.webp"
              "MediaSize" => 58138
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-d8b7aee2f860cb0da8eb64a94075976e.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            23 => array:13 [
              "Order" => 24
              "MediaKey" => "30001669_4890_24"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/40bffb2a2108f5710c702e1e3dd3d71b.webp"
              "MediaSize" => 57426
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-40bffb2a2108f5710c702e1e3dd3d71b.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            24 => array:13 [
              "Order" => 25
              "MediaKey" => "30001669_4890_25"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/ccb80694b283bb1baf2ce44c60ceae05.webp"
              "MediaSize" => 60249
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-ccb80694b283bb1baf2ce44c60ceae05.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            25 => array:13 [
              "Order" => 26
              "MediaKey" => "30001669_4890_26"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/52ae86d115c237e4575936243b2dc224.webp"
              "MediaSize" => 54334
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-52ae86d115c237e4575936243b2dc224.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            26 => array:13 [
              "Order" => 27
              "MediaKey" => "30001669_4890_27"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/c1fd8a76f2e17ee6af82652a09ccd597.webp"
              "MediaSize" => 75262
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-c1fd8a76f2e17ee6af82652a09ccd597.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            27 => array:13 [
              "Order" => 28
              "MediaKey" => "30001669_4890_28"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/a7c2d8f728a75c78ff72600986650aac.webp"
              "MediaSize" => 66662
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-a7c2d8f728a75c78ff72600986650aac.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            28 => array:13 [
              "Order" => 29
              "MediaKey" => "30001669_4890_29"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/4b38032ff9ee5dddb764d4c7bdd32388.webp"
              "MediaSize" => 75928
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-4b38032ff9ee5dddb764d4c7bdd32388.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            29 => array:13 [
              "Order" => 30
              "MediaKey" => "30001669_4890_30"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/c708ad8493fd42aff9e5b87b890c7f46.webp"
              "MediaSize" => 61094
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-c708ad8493fd42aff9e5b87b890c7f46.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            30 => array:13 [
              "Order" => 31
              "MediaKey" => "30001669_4890_31"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/4846954b4174f396048e3b3d06a6b887.webp"
              "MediaSize" => 69039
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-4846954b4174f396048e3b3d06a6b887.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            31 => array:13 [
              "Order" => 32
              "MediaKey" => "30001669_4890_32"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/65e39800c7a2d660fb35a7b1ff84fafa.webp"
              "MediaSize" => 70721
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-65e39800c7a2d660fb35a7b1ff84fafa.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            32 => array:13 [
              "Order" => 33
              "MediaKey" => "30001669_4890_33"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/6639f60b608749d3c97797d722dfbd70.webp"
              "MediaSize" => 61100
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-6639f60b608749d3c97797d722dfbd70.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            33 => array:13 [
              "Order" => 34
              "MediaKey" => "30001669_4890_34"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/983f077340787e522d508f02095f5b9f.webp"
              "MediaSize" => 166060
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-983f077340787e522d508f02095f5b9f.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            34 => array:13 [
              "Order" => 35
              "MediaKey" => "30001669_4890_35"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/ea7ba1a15f7b07b8234073be7b3d2a26.webp"
              "MediaSize" => 147310
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-ea7ba1a15f7b07b8234073be7b3d2a26.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            35 => array:13 [
              "Order" => 36
              "MediaKey" => "30001669_4890_36"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/600d2c94a14e565629faa57b6a64a20f.webp"
              "MediaSize" => 156014
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-600d2c94a14e565629faa57b6a64a20f.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            36 => array:13 [
              "Order" => 37
              "MediaKey" => "30001669_4890_37"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/cbf0d087cd5e7bd22efc9eb08577caec.webp"
              "MediaSize" => 178145
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-cbf0d087cd5e7bd22efc9eb08577caec.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            37 => array:13 [
              "Order" => 38
              "MediaKey" => "30001669_4890_38"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/be57ca9418cec5e7dbb5b1b4b105fabc.webp"
              "MediaSize" => 189308
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-be57ca9418cec5e7dbb5b1b4b105fabc.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            38 => array:13 [
              "Order" => 39
              "MediaKey" => "30001669_4890_39"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001669/cb3a74f61e0583819caef738af8864b5.webp"
              "MediaSize" => 201766
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001669/thumbnail-cb3a74f61e0583819caef738af8864b5.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40845281"
              "ResourceRecordKey" => "30001669"
              "ModificationTimestamp" => "2026-07-07T20:29:27.97Z"
            ]
            39 => array:13 [
              "Order" => 40
              "MediaKey" => "30001669_4890_40"
               …11
            ]
            40 => array:13 [ …13]
            41 => array:13 [ …13]
            42 => array:13 [ …13]
            43 => array:13 [ …13]
            44 => array:13 [ …13]
          ]
          +"DaysOnMarket": 0
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30001669')"
          +"ID": "1602047"
        }
      ]
      +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 156376" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24917
      +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 2103569" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24886
      +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 '30001669'" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25282
      +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 '30001669'" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25359
      +items: []
      +success: true
      +page_size: 0
      +page_count: 0
      +count: 0
      +after_key: ""
    }
    "RF Response Time" => "0.1 seconds"
  ]
  "RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30001669' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5798863 43.4958737)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25316
      +items: array:9 [
        0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25310
          +post_id: "1602037"
          +post_author: 1
          +"ListingKey": "30001128"
          +"ListingId": "X13533822"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-07-07T19:20:09Z"
          +"RFModificationTimestamp": "2026-07-07T23:43:23Z"
          +"ListPrice": 1799900.0
          +"BathroomsTotalInteger": 4.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 5.0
          +"LotSizeArea": 0
          +"LivingArea": 0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V2Y4"
          +"UnparsedAddress": "422 RIDEAU RIVER STREET, Waterloo, Ontario N2V2Y4"
          +"Coordinates": array:2 [
            0 => -80.588911
            1 => 43.491282
          ]
          +"Latitude": 43.491282
          +"Longitude": -80.588911
          +"YearBuilt": 0
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Toronto Regional Real Estate Board"
          +"PublicRemarks": "Experience luxury living at 422 Rideau River St in the highly sought-after ConservationMeadows community. This custom built home offers premium finishes, thoughtful design, and anincredible natural setting with no rear neighbours.A beautifully landscaped front approach, featuring an interlocking stone driveway, and naturalstone steps leading to the entrance, sets the tone for the exceptional craftsmanship foundthroughout. Inside, hand-scraped hardwood flooring extends across the main and second levels,The kitchen is a true showpiece, complete with a 14-foot soapstone waterfall island, cast ironsink, butler's pantry, and a premium Gaggenau appliance package that blends precision withperformance. From the kitchen, the home opens into comfortable living areas, including afamily room with a fireplace and large windows filling the room with natural light.The luxurious primary suite offers a private sitting area, custom dressing room, walk-inclosets with built-in cabinetry, and a spa-inspired ensuite featuring an oversized glassshower and a Victoria + Albert volcanic stone soaking tub. 3 additional spacious bedrooms anda 5-piece bath complete the upper level.The finished walk-out basement includes a large recreation room, dedicated media room wiredSonos sound system, a 5th bedroom, full bathroom with custom tile shower, upgradedpet-resistant carpeting, and a whimsical Fairy Play House with bunk loft.Additional features include a custom whiskey cabinet, built-in dog wash.The fully fenced backyard with garden beds, mature fruit trees, berry bushes, and rose gardenswhile overlooking a pond and the Stamm Woodlot with over 6 km of scenic walking trails.Moments from St. Jacobs Farmers' Market, Laurel Creek Conservation Area, and farm-freshprovisions. A truly signature residence in an exceptional location. A detailed propertyinformation package prepared for buyer review is available through MLS via your REALTOR (id:62650)"
          +"Appliances": array:12 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Water meter"
            3 => "Dishwasher"
            4 => "Stove"
            5 => "Range"
            6 => "Dryer"
            7 => "Microwave"
            8 => "Freezer"
            9 => "Hood Fan"
            10 => "Window Coverings"
            11 => "Garage door opener remote(s)"
          ]
          +"Basement": array:5 [
            0 => "Finished"
            1 => "Full"
            2 => "Walk out"
            3 => "N/A"
            4 => "N/A"
          ]
          +"BathroomsPartial": 1
          +"CommunityFeatures": array:1 [
            0 => "School Bus"
          ]
          +"Cooling": array:2 [
            0 => "Central air conditioning"
            1 => "Air exchanger"
          ]
          +"CreationDate": "2026-07-07T23:43:20.278625+00:00"
          +"Directions": "Cross Streets: Pinery Trail. ** Directions: From Conservation Drive turn onto Rideau River St, follow around bend to home on R/S."
          +"ExteriorFeatures": array:2 [
            0 => "Brick"
            1 => "Stone"
          ]
          +"FireplaceYN": true
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "2197726"
          +"ListOfficeKey": "294392"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:2 [
            0 => "Conservation/green belt"
            1 => "Sump Pump"
          ]
          +"LotSizeDimensions": "45 x 109.3 FT   ; 45.07ft. x 109.43ft. x 45.07ft. x109.43"
          +"ParkingFeatures": array:2 [
            0 => "Attached Garage"
            1 => "Garage"
          ]
          +"PhotosChangeTimestamp": "2026-07-07T19:11:30Z"
          +"PhotosCount": 50
          +"Sewer": array:1 [
            0 => "Sanitary sewer"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-07-07T19:11:29Z"
          +"Stories": "2.0"
          +"StreetName": "Rideau River"
          +"StreetNumber": "422"
          +"StreetSuffix": "Street"
          +"TaxAnnualAmount": "8878"
          +"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": "Toronto"
          +"TaxYear": 2026
          +"ListAORKey": "82"
          +"ListingURL": "www.realtor.ca/real-estate/30001128/422-rideau-river-street-waterloo"
          +"ParkingTotal": 4
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": false
          +"BuildingFeatures": array:1 [
            0 => "Fireplace(s)"
          ]
          +"SecurityFeatures": array:2 [
            0 => "Security system"
            1 => "Smoke Detectors"
          ]
          +"LivingAreaMaximum": 3000
          +"LivingAreaMinimum": 2500
          +"ZoningDescription": "R4"
          +"BedroomsAboveGrade": 4
          +"BedroomsBelowGrade": 1
          +"FrontageLengthNumeric": 45.0
          +"OriginalEntryTimestamp": "2026-07-07T19:11:29.33Z"
          +"FrontageLengthNumericUnits": "feet"
          +"ListAgentNationalAssociationId": "1446142"
          +"ListOfficeNationalAssociationId": "1438599"
          +"Media": array:50 [
            0 => array:13 [ …13]
            1 => array:13 [ …13]
            2 => array:13 [ …13]
            3 => array:13 [ …13]
            4 => array:13 [ …13]
            5 => array:13 [ …13]
            6 => array:13 [ …13]
            7 => array:13 [ …13]
            8 => array:13 [ …13]
            9 => array:13 [ …13]
            10 => array:13 [ …13]
            11 => array:13 [ …13]
            12 => array:13 [ …13]
            13 => array:13 [ …13]
            14 => array:13 [ …13]
            15 => array:13 [ …13]
            16 => array:13 [ …13]
            17 => array:13 [ …13]
            18 => array:13 [ …13]
            19 => array:13 [ …13]
            20 => array:13 [ …13]
            21 => array:13 [ …13]
            22 => array:13 [ …13]
            23 => array:13 [ …13]
            24 => array:13 [ …13]
            25 => array:13 [ …13]
            26 => array:13 [ …13]
            27 => array:13 [ …13]
            28 => array:13 [ …13]
            29 => array:13 [ …13]
            30 => array:13 [ …13]
            31 => array:13 [ …13]
            32 => array:13 [ …13]
            33 => array:13 [ …13]
            34 => array:13 [ …13]
            35 => array:13 [ …13]
            36 => array:13 [ …13]
            37 => array:13 [ …13]
            38 => array:13 [ …13]
            39 => array:13 [ …13]
            40 => array:13 [ …13]
            41 => array:13 [ …13]
            42 => array:13 [ …13]
            43 => array:13 [ …13]
            44 => array:13 [ …13]
            45 => array:13 [ …13]
            46 => array:13 [ …13]
            47 => array:13 [ …13]
            48 => array:13 [ …13]
            49 => array:13 [ …13]
          ]
          +"DaysOnMarket": 0
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30001128')"
          +"ID": "1602037"
        }
        1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25312
          +post_id: "1600924"
          +post_author: 1
          +"ListingKey": "30000572"
          +"ListingId": "40845913"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-07-07T18:25:12Z"
          +"RFModificationTimestamp": "2026-07-07T20:02:50Z"
          +"ListPrice": 1799900.0
          +"BathroomsTotalInteger": 4.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 5.0
          +"LotSizeArea": 0.113
          +"LivingArea": 4131.0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V2Y4"
          +"UnparsedAddress": "422 RIDEAU RIVER Street, Waterloo, Ontario N2V2Y4"
          +"Coordinates": array:2 [
            0 => -80.5890379
            1 => 43.4912404
          ]
          +"Latitude": 43.4912404
          +"Longitude": -80.5890379
          +"YearBuilt": 2009
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
          +"PublicRemarks": "Experience luxury living at 422 Rideau River St in the highly sought-after Conservation Meadows community. This custom built home offers premium finishes, thoughtful design, and an incredible natural setting with no rear neighbours. A beautifully landscaped front approach, featuring an interlocking stone driveway, and natural stone steps leading to the entrance, sets the tone for the exceptional craftsmanship found throughout. Inside, hand-scraped hardwood flooring extends across the main and second levels, The kitchen is a true showpiece, complete with a 14-foot soapstone waterfall island, cast iron sink, butler's pantry, and a premium Gaggenau appliance package that blends precision with performance. From the kitchen, the home opens into comfortable living areas, including a family room with a fireplace and large windows filling the room with natural light. The luxurious primary suite offers a private sitting area, custom dressing room, walk-in closets with built-in cabinetry, and a spa-inspired ensuite featuring an oversized glass shower and a Victoria + Albert volcanic stone soaking tub. 3 additional spacious bedrooms and a 5-piece bath complete the upper level. The finished walk-out basement includes a large recreation room, dedicated media room wired Sonos sound system, a 5th bedroom, full bathroom with custom tile shower, upgraded pet-resistant carpeting, and a whimsical Fairy Play House with bunk loft. Additional features include a custom whiskey cabinet, built-in dog wash. The fully fenced backyard with garden beds, mature fruit trees, berry bushes, and rose gardens while overlooking a pond and the Stamm Woodlot with over 6 km of scenic walking trails. Moments from St. Jacobs Farmers' Market, Laurel Creek Conservation Area, and farm-fresh provisions. A truly signature residence in an exceptional location. A detailed property information package prepared for buyer review is available through MLS® via your REALTOR® (id:62650)"
          +"Appliances": array:9 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Dishwasher"
            3 => "Stove"
            4 => "Dryer"
            5 => "Freezer"
            6 => "Hood Fan"
            7 => "Window Coverings"
            8 => "Microwave Built-in"
          ]
          +"Basement": array:2 [
            0 => "Finished"
            1 => "Full"
          ]
          +"BathroomsPartial": 1
          +"CommunityFeatures": array:1 [
            0 => "School Bus"
          ]
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-07-07T20:02:44.755339+00:00"
          +"Directions": "From Conservation Drive turn onto Rideau River St, follow around bend to home on R/S"
          +"ExteriorFeatures": array:3 [
            0 => "Brick"
            1 => "Stone"
            2 => "Vinyl siding"
          ]
          +"FireplaceYN": true
          +"FireplacesTotal": "2"
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "2094304"
          +"ListOfficeKey": "297560"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:4 [
            0 => "Conservation/green belt"
            1 => "Gazebo"
            2 => "Sump Pump"
            3 => "Automatic Garage Door Opener"
          ]
          +"LotSizeDimensions": "0.113"
          +"ParkingFeatures": array:2 [
            0 => "Attached Garage"
            1 => "Open"
          ]
          +"PhotosChangeTimestamp": "2026-07-07T18:18:29Z"
          +"PhotosCount": 50
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-07-07T18:18:28Z"
          +"Stories": "2.0"
          +"StreetName": "RIDEAU RIVER"
          +"StreetNumber": "422"
          +"StreetSuffix": "Street"
          +"SubdivisionName": "441 - Erbsville/Laurelwood"
          +"TaxAnnualAmount": "8878"
          +"VirtualTourURLUnbranded": "https://youriguide.com/pkm51_422_rideau_river_st_waterloo_on/"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:20 [
            0 => array:11 [ …11]
            1 => array:11 [ …11]
            2 => array:11 [ …11]
            3 => array:11 [ …11]
            4 => array:11 [ …11]
            5 => array:11 [ …11]
            6 => array:11 [ …11]
            7 => array:11 [ …11]
            8 => array:11 [ …11]
            9 => array:11 [ …11]
            10 => array:11 [ …11]
            11 => array:11 [ …11]
            12 => array:11 [ …11]
            13 => array:11 [ …11]
            14 => array:11 [ …11]
            15 => array:11 [ …11]
            16 => array:11 [ …11]
            17 => array:11 [ …11]
            18 => array:11 [ …11]
            19 => array:11 [ …11]
          ]
          +"ListAOR": "Cornerstone"
          +"ListAORKey": "14"
          +"ListingURL": "www.realtor.ca/real-estate/30000572/422-rideau-river-street-waterloo"
          +"ParkingTotal": 4
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CoListAgentKey": "2245088"
          +"CommonInterest": "Freehold"
          +"CoListOfficeKey": "292918"
          +"GeocodeManualYN": true
          +"SecurityFeatures": array:2 [
            0 => "Security system"
            1 => "Smoke Detectors"
          ]
          +"ZoningDescription": "R4"
          +"BedroomsAboveGrade": 4
          +"BedroomsBelowGrade": 1
          +"FrontageLengthNumeric": 45.0
          +"AboveGradeFinishedArea": 2956
          +"BelowGradeFinishedArea": 1175
          +"OriginalEntryTimestamp": "2026-07-07T18:18:28.86Z"
          +"FrontageLengthNumericUnits": "feet"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"BelowGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Other"
          +"BelowGradeFinishedAreaSource": "Other"
          +"ListAgentNationalAssociationId": "1366723"
          +"ListOfficeNationalAssociationId": "1467595"
          +"CoListAgentNationalAssociationId": "1483759"
          +"CoListOfficeNationalAssociationId": "1419429"
          +"Media": array:50 [
            0 => array:13 [ …13]
            1 => array:13 [ …13]
            2 => array:13 [ …13]
            3 => array:13 [ …13]
            4 => array:13 [ …13]
            5 => array:13 [ …13]
            6 => array:13 [ …13]
            7 => array:13 [ …13]
            8 => array:13 [ …13]
            9 => array:13 [ …13]
            10 => array:13 [ …13]
            11 => array:13 [ …13]
            12 => array:13 [ …13]
            13 => array:13 [ …13]
            14 => array:13 [ …13]
            15 => array:13 [ …13]
            16 => array:13 [ …13]
            17 => array:13 [ …13]
            18 => array:13 [ …13]
            19 => array:13 [ …13]
            20 => array:13 [ …13]
            21 => array:13 [ …13]
            22 => array:13 [ …13]
            23 => array:13 [ …13]
            24 => array:13 [ …13]
            25 => array:13 [ …13]
            26 => array:13 [ …13]
            27 => array:13 [ …13]
            28 => array:13 [ …13]
            29 => array:13 [ …13]
            30 => array:13 [ …13]
            31 => array:13 [ …13]
            32 => array:13 [ …13]
            33 => array:13 [ …13]
            34 => array:13 [ …13]
            35 => array:13 [ …13]
            36 => array:13 [ …13]
            37 => array:13 [ …13]
            38 => array:13 [ …13]
            39 => array:13 [ …13]
            40 => array:13 [ …13]
            41 => array:13 [ …13]
            42 => array:13 [ …13]
            43 => array:13 [ …13]
            44 => array:13 [ …13]
            45 => array:13 [ …13]
            46 => array:13 [ …13]
            47 => array:13 [ …13]
            48 => array:13 [ …13]
            49 => array:13 [ …13]
          ]
          +"DaysOnMarket": 0
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30000572')"
          +"ID": "1600924"
        }
        2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25309
          +post_id: "1602306"
          +post_author: 1
          +"ListingKey": "29998188"
          +"ListingId": "40845586"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-07-07T13:55:11Z"
          +"RFModificationTimestamp": "2026-07-07T17:58:04Z"
          +"ListPrice": 785000.0
          +"BathroomsTotalInteger": 2.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 3.0
          +"LotSizeArea": 0
          +"LivingArea": 1549.0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V1L8"
          +"UnparsedAddress": "108 CLEARWATER Crescent, Waterloo, Ontario N2V1L8"
          +"Coordinates": array:2 [
            0 => -80.5635421
            1 => 43.4922983
          ]
          +"Latitude": 43.4922983
          +"Longitude": -80.5635421
          +"YearBuilt": 1984
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
          +"PublicRemarks": "Nestled in the highly sought-after Lakeshore North community, this beautifully maintained 2-storey home offers the perfect blend of comfort, functionality, and lifestyle. Featuring 3 spacious bedrooms, 2 bathrooms, and a thoughtfully designed layout, this home is ideal for growing families, professionals, and those who love to entertain. From the upgraded vinyl flooring throughout portions of the main floor to the seamless walk-through kitchen design, every detail has been curated to enhance the natural flow of the home—making everyday living and hosting effortless. Beyond the cosmetic upgrades, this home has also been mechanically updated over the years, offering buyers peace of mind and truly worry-free ownership. The pride of ownership is evident throughout, making this a move-in-ready opportunity in one of Waterloo’s most desirable neighbourhoods. The heart of the home opens into inviting living and dining spaces perfect for gatherings with family and friends, while the fully finished basement offers endless versatility—whether you envision a yoga studio, recreation room, home gym, workshop, or additional entertaining space. Step outside to enjoy a beautifully private backyard retreat, ideal for summer evenings, barbecues, or relaxing in peace. Located just minutes from the highway, top-rated dining, gyms, shopping, and both universities, this home delivers unbeatable convenience in an area known for its strong community feel, mature surroundings, and exceptional accessibility. Complete with a double-car garage, fantastic layout for entertaining, and extensive updates throughout, this is a rare opportunity to own a turn-key home in the coveted Lakeshore North neighbourhood. (id:62650)"
          +"Appliances": array:8 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Water purifier"
            3 => "Water softener"
            4 => "Central Vacuum"
            5 => "Gas stove(s)"
            6 => "Dryer"
            7 => "Freezer"
          ]
          +"Basement": array:2 [
            0 => "Finished"
            1 => "Full"
          ]
          +"BathroomsPartial": 1
          +"Cooling": array:1 [
            0 => "Ductless"
          ]
          +"CreationDate": "2026-07-07T17:57:52.057126+00:00"
          +"Directions": "Wintergreen Dr. Northlake and Highpoint Ave."
          +"ExteriorFeatures": array:2 [
            0 => "Brick"
            1 => "Vinyl siding"
          ]
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:2 [
            0 => "Baseboard heaters"
            1 => "Other"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "2129938"
          +"ListOfficeKey": "292877"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:1 [
            0 => "Automatic Garage Door Opener"
          ]
          +"ParkingFeatures": array:1 [
            0 => "Attached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-07-07T13:48:23Z"
          +"PhotosCount": 50
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-07-07T13:48:23Z"
          +"Stories": "2.0"
          +"StreetName": "CLEARWATER"
          +"StreetNumber": "108"
          +"StreetSuffix": "Crescent"
          +"SubdivisionName": "442 - Lakeshore North"
          +"TaxAnnualAmount": "4711"
          +"View": "City view"
          +"VirtualTourURLUnbranded": "https://youriguide.com/108_clearwater_crescent_waterloo_on/"
          +"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": "Cornerstone"
          +"ListAORKey": "14"
          +"ListingURL": "www.realtor.ca/real-estate/29998188/108-clearwater-crescent-waterloo"
          +"ParkingTotal": 4
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CoListAgentKey": "1941951"
          +"CommonInterest": "Freehold"
          +"CoListOfficeKey": "292877"
          +"GeocodeManualYN": true
          +"ZoningDescription": "R3"
          +"BedroomsAboveGrade": 3
          +"BedroomsBelowGrade": 0
          +"FrontageLengthNumeric": 53.0
          +"AboveGradeFinishedArea": 1549
          +"OriginalEntryTimestamp": "2026-07-07T13:48:23.04Z"
          +"FrontageLengthNumericUnits": "feet"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Other"
          +"ListAgentNationalAssociationId": "1382907"
          +"ListOfficeNationalAssociationId": "1418791"
          +"CoListAgentNationalAssociationId": "1238606"
          +"CoListOfficeNationalAssociationId": "1418791"
          +"Media": array:50 [
            0 => array:13 [ …13]
            1 => array:13 [ …13]
            2 => array:13 [ …13]
            3 => array:13 [ …13]
            4 => array:13 [ …13]
            5 => array:13 [ …13]
            6 => array:13 [ …13]
            7 => array:13 [ …13]
            8 => array:13 [ …13]
            9 => array:13 [ …13]
            10 => array:13 [ …13]
            11 => array:13 [ …13]
            12 => array:13 [ …13]
            13 => array:13 [ …13]
            14 => array:13 [ …13]
            15 => array:13 [ …13]
            16 => array:13 [ …13]
            17 => array:13 [ …13]
            18 => array:13 [ …13]
            19 => array:13 [ …13]
            20 => array:13 [ …13]
            21 => array:13 [ …13]
            22 => array:13 [ …13]
            23 => array:13 [ …13]
            24 => array:13 [ …13]
            25 => array:13 [ …13]
            26 => array:13 [ …13]
            27 => array:13 [ …13]
            28 => array:13 [ …13]
            29 => array:13 [ …13]
            30 => array:13 [ …13]
            31 => array:13 [ …13]
            32 => array:13 [ …13]
            33 => array:13 [ …13]
            34 => array:13 [ …13]
            35 => array:13 [ …13]
            36 => array:13 [ …13]
            37 => array:13 [ …13]
            38 => array:13 [ …13]
            39 => array:13 [ …13]
            40 => array:13 [ …13]
            41 => array:13 [ …13]
            42 => array:13 [ …13]
            43 => array:13 [ …13]
            44 => array:13 [ …13]
            45 => array:13 [ …13]
            46 => array:13 [ …13]
            47 => array:13 [ …13]
            48 => array:13 [ …13]
            49 => array:13 [ …13]
          ]
          +"DaysOnMarket": 0
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29998188')"
          +"ID": "1602306"
        }
        3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25313
          +post_id: "1602307"
          +post_author: 1
          +"ListingKey": "29998680"
          +"ListingId": "X13531268"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-07-07T14:50:06Z"
          +"RFModificationTimestamp": "2026-07-07T17:26:37Z"
          +"ListPrice": 785000.0
          +"BathroomsTotalInteger": 2.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 3.0
          +"LotSizeArea": 0
          +"LivingArea": 0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V1L8"
          +"UnparsedAddress": "108 CLEARWATER CRESCENT, Waterloo, Ontario N2V1L8"
          +"Coordinates": array:2 [
            0 => -80.563513
            1 => 43.49232
          ]
          +"Latitude": 43.49232
          +"Longitude": -80.563513
          +"YearBuilt": 0
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Toronto Regional Real Estate Board"
          +"PublicRemarks": "Nestled in the highly sought-after Lakeshore North community, this beautifully maintained 2-storey home offers the perfect blend of comfort,functionality, and lifestyle. Featuring 3 spacious bedrooms, 2 bathrooms, and a thoughtfully designed layout, this home is ideal for growingfamilies, professionals, and those who love to entertain. From the upgraded vinyl flooring throughout portions of the main floor to the seamlesswalk-through kitchen design, every detail has been curated to enhance the natural flow of the home-making everyday living and hostingeffortless. Beyond the cosmetic upgrades, this home has also been mechanically updated over the years, offering buyers peace of mind and trulyworry-free ownership. The pride of ownership is evident throughout, making this a move-in-ready opportunity in one of Waterloo's mostdesirable neighbourhoods. The heart of the home opens into inviting living and dining spaces perfect for gatherings with family and friends, whilethe fully finished basement offers endless versatility-whether you envision a yoga studio, recreation room, home gym, workshop, or additionalentertaining space. Step outside to enjoy a beautifully private backyard retreat, ideal for summer evenings, barbecues, or relaxing in peace.Located just minutes from the highway, top-rated dining, gyms, shopping, and both universities, this home delivers unbeatable convenience inan area known for its strong community feel, mature surroundings, and exceptional accessibility. Complete with a double-car garage, fantasticlayout for entertaining, and extensive updates throughout, this is a rare opportunity to own a turn-key home in the coveted Lakeshore Northneighbourhood. (id:62650)"
          +"Appliances": array:6 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Water softener"
            3 => "Gas stove(s)"
            4 => "Dryer"
            5 => "Freezer"
          ]
          +"Basement": array:2 [
            0 => "Finished"
            1 => "N/A"
          ]
          +"BathroomsPartial": 1
          +"CreationDate": "2026-07-07T17:26:22.569712+00:00"
          +"Directions": "Cross Streets: Wintergreen Dr. Northlake and Highpoint Ave. ** Directions: Northfield > Highpoint > Wintergreen."
          +"ExteriorFeatures": array:2 [
            0 => "Brick"
            1 => "Vinyl siding"
          ]
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:2 [
            0 => "Baseboard heaters"
            1 => "Electric"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "2237937"
          +"ListOfficeKey": "285286"
          +"LivingAreaUnits": "square feet"
          +"LotSizeDimensions": "52.9 x 108 FT ; 52.89x107.97x36.9x120.33"
          +"ParkingFeatures": array:2 [
            0 => "Attached Garage"
            1 => "Garage"
          ]
          +"PhotosChangeTimestamp": "2026-07-07T14:42:20Z"
          +"PhotosCount": 50
          +"Sewer": array:1 [
            0 => "Sanitary sewer"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-07-07T14:42:20Z"
          +"Stories": "2.0"
          +"StreetName": "Clearwater"
          +"StreetNumber": "108"
          +"StreetSuffix": "Crescent"
          +"TaxAnnualAmount": "4711"
          +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/108_clearwater_crescent_waterloo_on/"
          +"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": "Toronto"
          +"ListAORKey": "82"
          +"ListingURL": "www.realtor.ca/real-estate/29998680/108-clearwater-crescent-waterloo"
          +"ParkingTotal": 4
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CoListAgentKey": "2235642"
          +"CommonInterest": "Freehold"
          +"CoListOfficeKey": "285286"
          +"GeocodeManualYN": false
          +"LivingAreaMaximum": 2000
          +"LivingAreaMinimum": 1500
          +"BedroomsAboveGrade": 3
          +"FrontageLengthNumeric": 52.1
          +"OriginalEntryTimestamp": "2026-07-07T14:42:20.06Z"
          +"FrontageLengthNumericUnits": "feet"
          +"ListAgentNationalAssociationId": "1475924"
          +"ListOfficeNationalAssociationId": "1349912"
          +"CoListAgentNationalAssociationId": "1473542"
          +"CoListOfficeNationalAssociationId": "1349912"
          +"Media": array:50 [
            0 => array:13 [ …13]
            1 => array:13 [ …13]
            2 => array:13 [ …13]
            3 => array:13 [ …13]
            4 => array:13 [ …13]
            5 => array:13 [ …13]
            6 => array:13 [ …13]
            7 => array:13 [ …13]
            8 => array:13 [ …13]
            9 => array:13 [ …13]
            10 => array:13 [ …13]
            11 => array:13 [ …13]
            12 => array:13 [ …13]
            13 => array:13 [ …13]
            14 => array:13 [ …13]
            15 => array:13 [ …13]
            16 => array:13 [ …13]
            17 => array:13 [ …13]
            18 => array:13 [ …13]
            19 => array:13 [ …13]
            20 => array:13 [ …13]
            21 => array:13 [ …13]
            22 => array:13 [ …13]
            23 => array:13 [ …13]
            24 => array:13 [ …13]
            25 => array:13 [ …13]
            26 => array:13 [ …13]
            27 => array:13 [ …13]
            28 => array:13 [ …13]
            29 => array:13 [ …13]
            30 => array:13 [ …13]
            31 => array:13 [ …13]
            32 => array:13 [ …13]
            33 => array:13 [ …13]
            34 => array:13 [ …13]
            35 => array:13 [ …13]
            36 => array:13 [ …13]
            37 => array:13 [ …13]
            38 => array:13 [ …13]
            39 => array:13 [ …13]
            40 => array:13 [ …13]
            41 => array:13 [ …13]
            42 => array:13 [ …13]
            43 => array:13 [ …13]
            44 => array:13 [ …13]
            45 => array:13 [ …13]
            46 => array:13 [ …13]
            47 => array:13 [ …13]
            48 => array:13 [ …13]
            49 => array:13 [ …13]
          ]
          +"DaysOnMarket": 0
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29998680')"
          +"ID": "1602307"
        }
        4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25311
          +post_id: "1590741"
          +post_author: 1
          +"ListingKey": "29986386"
          +"ListingId": "40844884"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-07-03T18:55:15Z"
          +"RFModificationTimestamp": "2026-07-03T19:40:13Z"
          +"ListPrice": 649900.0
          +"BathroomsTotalInteger": 2.0
          +"BathroomsHalf": 0
          +"BedroomsTotal": 3.0
          +"LotSizeArea": 0
          +"LivingArea": 1618.0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V1P6"
          +"UnparsedAddress": "315 MAYVIEW Crescent Unit# B, Waterloo, Ontario N2V1P6"
          +"Coordinates": array:2 [
            0 => -80.5558434
            1 => 43.499126
          ]
          +"Latitude": 43.499126
          +"Longitude": -80.5558434
          +"YearBuilt": 1987
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
          +"PublicRemarks": "Welcome to 315B Mayview Crescent! This beautifully maintained 3-bedroom, 2-bathroom home offers the perfect blend of modern updates, functional living space, and an incredible backyard retreat. Whether you're a first-time buyer, growing family, or looking to downsize, this move-in-ready home is sure to impress. Step inside to a bright, open-concept main floor featuring a spacious living and dining area that flows effortlessly into the beautifully renovated kitchen (2024), complete with contemporary finishes, ample cabinetry, and plenty of workspace. Upstairs, you'll find three generously sized bedrooms and a full bathroom, while the finished basement extends your living space with a large recreation room and an updated 3-piece bathroom (2021)—perfect for movie nights, overnight guests, or a home office. Outside, you'll discover your own private backyard oasis. The fully fenced yard is beautifully landscaped and offers mature trees for added privacy, an expansive lawn for children and pets to enjoy, and a covered gazebo that creates the perfect setting for summer entertaining or relaxing with family and friends. Additional updates include a new roof (2020) and a new furnace and central air conditioning system (2024), providing added peace of mind for years to come. Situated in a desirable, family-friendly neighbourhood close to schools, parks, shopping, trails, and everyday amenities, this home combines comfort, style, and convenience in one exceptional package. Don't miss your opportunity to make this beautifully updated property your next home! (id:62650)"
          +"Appliances": array:6 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Stove"
            3 => "Dryer"
            4 => "Window Coverings"
            5 => "Microwave Built-in"
          ]
          +"Basement": array:2 [
            0 => "Finished"
            1 => "Full"
          ]
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-07-03T19:40:00.148172+00:00"
          +"Directions": "Northlake Drive & Mayview Cres"
          +"ExteriorFeatures": array:2 [
            0 => "Brick"
            1 => "Aluminum siding"
          ]
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:1 [
            0 => "Forced air"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "1951940"
          +"ListOfficeKey": "283125"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:3 [
            0 => "Paved driveway"
            1 => "Country residential"
            2 => "Sump Pump"
          ]
          +"PhotosChangeTimestamp": "2026-07-03T18:48:32Z"
          +"PhotosCount": 40
          +"PropertyAttachedYN": true
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-07-03T18:48:32Z"
          +"Stories": "2.0"
          +"StreetName": "MAYVIEW"
          +"StreetNumber": "315"
          +"StreetSuffix": "Crescent"
          +"SubdivisionName": "442 - Lakeshore North"
          +"TaxAnnualAmount": "3523"
          +"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/315-B-Mayview-Crescent"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:10 [
            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]
          ]
          +"ListAOR": "Cornerstone"
          +"ListAORKey": "14"
          +"ListingURL": "www.realtor.ca/real-estate/29986386/315-mayview-crescent-unit-b-waterloo"
          +"ParkingTotal": 3
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"SecurityFeatures": array:1 [
            0 => "Smoke Detectors"
          ]
          +"ZoningDescription": "R4"
          +"BedroomsAboveGrade": 3
          +"BedroomsBelowGrade": 0
          +"FrontageLengthNumeric": 32.0
          +"AboveGradeFinishedArea": 1113
          +"BelowGradeFinishedArea": 505
          +"OriginalEntryTimestamp": "2026-07-03T18:48:32.63Z"
          +"FrontageLengthNumericUnits": "feet"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"BelowGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Other"
          +"BelowGradeFinishedAreaSource": "Other"
          +"ListAgentNationalAssociationId": "1245634"
          +"ListOfficeNationalAssociationId": "1324759"
          +"Media": array:40 [
            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]
          ]
          +"DaysOnMarket": 4
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986386')"
          +"ID": "1590741"
        }
        5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25306
          +post_id: "1585264"
          +post_author: 1
          +"ListingKey": "29979277"
          +"ListingId": "X13513406"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-07-06T12:20:32Z"
          +"RFModificationTimestamp": "2026-07-06T12:43:02Z"
          +"ListPrice": 849900.0
          +"BathroomsTotalInteger": 4.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 5.0
          +"LotSizeArea": 0
          +"LivingArea": 0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V2S1"
          +"UnparsedAddress": "430 KELSO DRIVE, Waterloo, Ontario N2V2S1"
          +"Coordinates": array:2 [
            0 => -80.583859
            1 => 43.490424
          ]
          +"Latitude": 43.490424
          +"Longitude": -80.583859
          +"YearBuilt": 0
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Toronto Regional Real Estate Board"
          +"PublicRemarks": "Welcome to 430 Kelso Drive, Waterloo: a beautifully maintained family home nestled in the highly sought-after Lakeshore North community. Situated on an impressive 44 x 139 ft. lot and just steps from the scenic Laurel Creek Conservation Area, this exceptional property offers fantastic curb appeal and parking for up to 4 vehicles, including a 2-car garage and 2-car private driveway. Step inside to a bright, carpet-free interior featuring soaring 9-foot ceilings, an open-concept layout and abundant natural light throughout. The kitchen comes complete with updated appliances, ample cabinetry, and generous counter space, making meal preparation effortless. The adjoining dining and living areas, anchored by a cozy electric fireplace create a warm, inviting atmosphere. Main floor laundry adds everyday convenience. Upstairs, you'll find 4 generously sized bedrooms and two full bathrooms, including a primary retreat with a walk-in closet and private ensuite. Designed with growing families in mind, the upper level offers both comfort and functionality. The fully finished basement adds tremendous versatility with a large recreation room, an additional bedroom and 3pc bathroom, ideal for extended family, guests, an in-law suite or mortgage-helper potential. This home has been thoughtfully upgraded for comfort and efficiency: a new heat pump (2024, doubling as central air), a two-stage furnace and refreshed R-60 attic insulation (2022) keep utility costs down year-round. Step outside to a huge, fully fenced, pool-sized backyard with a concrete patio, perfect for summer bbq's, family gatherings or simply relaxing. Set on a quiet street in one of Waterloo's most desirable neighbourhoods, this home is close to top-rated schools, parks, trails, universities, the YMCA, Conestoga Mall, shopping, restaurants, public transit, and major highways. A premium lot in an outstanding location, this house truly checks all the boxes. Don't miss your chance, book your private showing today! (id:62650)"
          +"Appliances": array:10 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Water softener"
            3 => "Gas stove(s)"
            4 => "Dishwasher"
            5 => "Dryer"
            6 => "Hood Fan"
            7 => "Garage door opener"
            8 => "Garage door opener remote(s)"
            9 => "Water Heater"
          ]
          +"Basement": array:2 [
            0 => "Finished"
            1 => "Full"
          ]
          +"BathroomsPartial": 1
          +"CommunityFeatures": array:1 [
            0 => "Community Centre"
          ]
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-07-02T19:09:35.541665+00:00"
          +"Directions": "Cross Streets: LakeLouise Blvd. ** Directions: Kelso Dr To LakeLouise Blvd."
          +"ExteriorFeatures": array:2 [
            0 => "Brick"
            1 => "Vinyl siding"
          ]
          +"FireplaceYN": true
          +"FireplacesTotal": "1"
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "2130557"
          +"ListOfficeKey": "288578"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:1 [
            0 => "Conservation/green belt"
          ]
          +"LotSizeDimensions": "44.8 x 139.7 FT"
          +"ParkingFeatures": array:2 [
            0 => "Attached Garage"
            1 => "Garage"
          ]
          +"PhotosChangeTimestamp": "2026-07-02T19:29:47Z"
          +"PhotosCount": 50
          +"Sewer": array:1 [
            0 => "Sanitary sewer"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-07-06T12:14:37Z"
          +"Stories": "2.0"
          +"StreetName": "Kelso"
          +"StreetNumber": "430"
          +"StreetSuffix": "Drive"
          +"TaxAnnualAmount": "6672"
          +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/c95ms_430_kelso_dr_waterloo_on/"
          +"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": "Toronto"
          +"ListAORKey": "82"
          +"ListingURL": "www.realtor.ca/real-estate/29979277/430-kelso-drive-waterloo"
          +"ParkingTotal": 4
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": false
          +"BuildingFeatures": array:1 [
            0 => "Fireplace(s)"
          ]
          +"LivingAreaMaximum": 2500
          +"LivingAreaMinimum": 2000
          +"BedroomsAboveGrade": 4
          +"BedroomsBelowGrade": 1
          +"FrontageLengthNumeric": 44.9
          +"OriginalEntryTimestamp": "2026-07-02T17:00:50.97Z"
          +"FrontageLengthNumericUnits": "feet"
          +"ListAgentNationalAssociationId": "1389915"
          +"ListOfficeNationalAssociationId": "1369645"
          +"Media": array:50 [
            0 => array:13 [ …13]
            1 => array:13 [ …13]
            2 => array:13 [ …13]
            3 => array:13 [ …13]
            4 => array:13 [ …13]
            5 => array:13 [ …13]
            6 => array:13 [ …13]
            7 => array:13 [ …13]
            8 => array:13 [ …13]
            9 => array:13 [ …13]
            10 => array:13 [ …13]
            11 => array:13 [ …13]
            12 => array:13 [ …13]
            13 => array:13 [ …13]
            14 => array:13 [ …13]
            15 => array:13 [ …13]
            16 => array:13 [ …13]
            17 => array:13 [ …13]
            18 => array:13 [ …13]
            19 => array:13 [ …13]
            20 => array:13 [ …13]
            21 => array:13 [ …13]
            22 => array:13 [ …13]
            23 => array:13 [ …13]
            24 => array:13 [ …13]
            25 => array:13 [ …13]
            26 => array:13 [ …13]
            27 => array:13 [ …13]
            28 => array:13 [ …13]
            29 => array:13 [ …13]
            30 => array:13 [ …13]
            31 => array:13 [ …13]
            32 => array:13 [ …13]
            33 => array:13 [ …13]
            34 => array:13 [ …13]
            35 => array:13 [ …13]
            36 => array:13 [ …13]
            37 => array:13 [ …13]
            38 => array:13 [ …13]
            39 => array:13 [ …13]
            40 => array:13 [ …13]
            41 => array:13 [ …13]
            42 => array:13 [ …13]
            43 => array:13 [ …13]
            44 => array:13 [ …13]
            45 => array:13 [ …13]
            46 => array:13 [ …13]
            47 => array:13 [ …13]
            48 => array:13 [ …13]
            49 => array:13 [ …13]
          ]
          +"DaysOnMarket": 5
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29979277')"
          +"ID": "1585264"
        }
        6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23461
          +post_id: "1584362"
          +post_author: 1
          +"ListingKey": "29977664"
          +"ListingId": "40842487"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-07-06T13:40:08Z"
          +"RFModificationTimestamp": "2026-07-06T13:53:56Z"
          +"ListPrice": 949900.0
          +"BathroomsTotalInteger": 3.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 3.0
          +"LotSizeArea": 0
          +"LivingArea": 2733.0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V2J3"
          +"UnparsedAddress": "500 GLACIER Street, Waterloo, Ontario N2V2J3"
          +"Coordinates": array:2 [
            0 => -80.5790234
            1 => 43.4957774
          ]
          +"Latitude": 43.4957774
          +"Longitude": -80.5790234
          +"YearBuilt": 2001
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
          +"PublicRemarks": "Welcome to 500 Glacier Street in Waterloo-your dream home with a spectacular backyard retreat, including a heated above-ground saltwater pool, backing onto greenspace & trails. Situated on an oversized corner lot in the highly desirable & family-oriented neighbourhood of Conservation Meadows, this lovely 4-bedroom, 3-bathroom home offers over 2,700 sq. ft. of finished living space, many recent updates & a bright, spacious open-concept layout perfect for entertaining or relaxing with family. The recently renovated gourmet kitchen features stainless steel appliances, a beautiful backsplash & a convenient centre island for casual dining, while the oversized dining area offers plenty of space for more formal gatherings. Relax & unwind in the sophisticated family room, complete with a gas fireplace, oversized windows & sliding door access to the expansive deck & pool area. A 2-piece bathroom & main floor laundry complete the main level.  Upstairs, the stunning primary suite features vaulted ceilings, custom built-ins, two walk-in closets & a newly updated spa-like 3-piece ensuite with tiled glass shower, rain shower fixture, heated floors & heated towel rack. Two additional spacious bedrooms & a 4-piece main bathroom complete this level. The fully finished basement offers a large recreation room, a potential 4th bedroom & the added convenience of a walk-up directly into the garage.. Notable updates include furnace & air conditioning in 2017, shingles in 2015 & above-ground saltwater pool in 2018. Additional features include a carpet-free main & lower level with luxury vinyl flooring, custom blinds & more. Backing onto greenspace & walking trails, surrounded by mature trees & lush perennial gardens, this lovely home is located on a quiet, tree-lined street in a premium location close to schools, parks, Laurel Creek Conservation Area, shopping, restaurants, Starbucks, Sobeys, St. Jacobs Farmers’ Market, quick highway access & more. (id:62650)"
          +"Appliances": array:8 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Water softener"
            3 => "Dishwasher"
            4 => "Stove"
            5 => "Dryer"
            6 => "Window Coverings"
            7 => "Garage door opener"
          ]
          +"Basement": array:2 [
            0 => "Finished"
            1 => "Full"
          ]
          +"BathroomsPartial": 1
          +"CommunityFeatures": array:3 [
            0 => "Quiet Area"
            1 => "School Bus"
            2 => "Community Centre"
          ]
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-07-02T17:41:40.814366+00:00"
          +"Directions": "Conservation Drive to Lake Louise to Glacier"
          +"ExteriorFeatures": array:2 [
            0 => "Brick"
            1 => "Vinyl siding"
          ]
          +"Fencing": array:1 [
            0 => "Fence"
          ]
          +"FireplaceYN": true
          +"FireplacesTotal": "1"
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "1564122"
          +"ListOfficeKey": "289722"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:5 [
            0 => "Corner Site"
            1 => "Backs on greenbelt"
            2 => "Conservation/green belt"
            3 => "Sump Pump"
            4 => "Automatic Garage Door Opener"
          ]
          +"ParkingFeatures": array:1 [
            0 => "Attached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-07-06T13:31:14Z"
          +"PhotosCount": 49
          +"PoolFeatures": array:1 [
            0 => "Above ground pool"
          ]
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-07-06T13:31:14Z"
          +"Stories": "2.0"
          +"StreetName": "GLACIER"
          +"StreetNumber": "500"
          +"StreetSuffix": "Street"
          +"SubdivisionName": "441 - Erbsville/Laurelwood"
          +"TaxAnnualAmount": "5653"
          +"VirtualTourURLUnbranded": "https://youriguide.com/500_glacier_street_waterloo_on/"
          +"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": "Cornerstone"
          +"ListAORKey": "14"
          +"ListingURL": "www.realtor.ca/real-estate/29977664/500-glacier-street-waterloo"
          +"ParkingTotal": 4
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"ZoningDescription": "R"
          +"BedroomsAboveGrade": 3
          +"BedroomsBelowGrade": 0
          +"FrontageLengthNumeric": 63.0
          +"AboveGradeFinishedArea": 1854
          +"BelowGradeFinishedArea": 879
          +"OriginalEntryTimestamp": "2026-07-02T14:33:21.61Z"
          +"FrontageLengthNumericUnits": "feet"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"BelowGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Measurement follows RMS"
          +"BelowGradeFinishedAreaSource": "Other"
          +"ListAgentNationalAssociationId": "1142829"
          +"ListOfficeNationalAssociationId": "1380559"
          +"Media": array:49 [
            0 => array:13 [ …13]
            1 => array:13 [ …13]
            2 => array:13 [ …13]
            3 => array:13 [ …13]
            4 => array:13 [ …13]
            5 => array:13 [ …13]
            6 => array:13 [ …13]
            7 => array:13 [ …13]
            8 => array:13 [ …13]
            9 => array:13 [ …13]
            10 => array:13 [ …13]
            11 => array:13 [ …13]
            12 => array:13 [ …13]
            13 => array:13 [ …13]
            14 => array:13 [ …13]
            15 => array:13 [ …13]
            16 => array:13 [ …13]
            17 => array:13 [ …13]
            18 => array:13 [ …13]
            19 => array:13 [ …13]
            20 => array:13 [ …13]
            21 => array:13 [ …13]
            22 => array:13 [ …13]
            23 => array:13 [ …13]
            24 => array:13 [ …13]
            25 => array:13 [ …13]
            26 => array:13 [ …13]
            27 => array:13 [ …13]
            28 => array:13 [ …13]
            29 => array:13 [ …13]
            30 => array:13 [ …13]
            31 => array:13 [ …13]
            32 => array:13 [ …13]
            33 => array:13 [ …13]
            34 => array:13 [ …13]
            35 => array:13 [ …13]
            36 => array:13 [ …13]
            37 => array:13 [ …13]
            38 => array:13 [ …13]
            39 => array:13 [ …13]
            40 => array:13 [ …13]
            41 => array:13 [ …13]
            42 => array:13 [ …13]
            43 => array:13 [ …13]
            44 => array:13 [ …13]
            45 => array:13 [ …13]
            46 => array:13 [ …13]
            47 => array:13 [ …13]
            48 => array:13 [ …13]
          ]
          +"DaysOnMarket": 5
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977664')"
          +"ID": "1584362"
        }
        7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25314
          +post_id: "1583779"
          +post_author: 1
          +"ListingKey": "29977455"
          +"ListingId": "40841745"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-07-05T20:25:17Z"
          +"RFModificationTimestamp": "2026-07-05T20:31:51Z"
          +"ListPrice": 849900.0
          +"BathroomsTotalInteger": 4.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 5.0
          +"LotSizeArea": 0.144
          +"LivingArea": 3238.0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V2S5"
          +"UnparsedAddress": "430 KELSO Drive, Waterloo, Ontario N2V2S5"
          +"Coordinates": array:2 [
            0 => -80.5838742
            1 => 43.4904493
          ]
          +"Latitude": 43.4904493
          +"Longitude": -80.5838742
          +"YearBuilt": 2009
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
          +"PublicRemarks": "Welcome to 430 Kelso Drive, Waterloo: a beautifully maintained family home nestled in the highly sought-after Lakeshore North community. Situated on an impressive 44 x 139 ft. lot and just steps from the scenic Laurel Creek Conservation Area, this exceptional property offers fantastic curb appeal and parking for up to 4 vehicles, including a 2-car garage and 2-car private driveway. Step inside to a bright, carpet-free interior featuring soaring 9-foot ceilings, an open-concept layout and abundant natural light throughout. The kitchen comes complete with updated appliances, ample cabinetry, and generous counter space, making meal preparation effortless. The adjoining dining and living areas, anchored by a cozy electric fireplace create a warm, inviting atmosphere. Main floor laundry adds everyday convenience. Upstairs, you'll find 4 generously sized bedrooms and two full bathrooms, including a primary retreat with a walk-in closet and private ensuite. Designed with growing families in mind, the upper level offers both comfort and functionality. The fully finished basement adds tremendous versatility with a large recreation room, an additional bedroom and 3pc bathroom, ideal for extended family, guests, an in-law suite or mortgage-helper potential. This home has been thoughtfully upgraded for comfort and efficiency: a new heat pump (2024, doubling as central air), a two-stage furnace and refreshed R-60 attic insulation (2022) keep utility costs down year-round. Step outside to a huge, fully fenced, pool-sized backyard with a concrete patio, perfect for summer bbq's, family gatherings or simply relaxing. Set on a quiet street in one of Waterloo's most desirable neighbourhoods, this home is close to top-rated schools, parks, trails, universities, the YMCA, Conestoga Mall, shopping, restaurants, public transit, and major highways. A premium lot in an outstanding location, this house truly checks all the boxes. Don't miss your chance, book your private showing today! (id:62650)"
          +"Appliances": array:8 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Water softener"
            3 => "Gas stove(s)"
            4 => "Dishwasher"
            5 => "Dryer"
            6 => "Hood Fan"
            7 => "Garage door opener"
          ]
          +"Basement": array:2 [
            0 => "Finished"
            1 => "Full"
          ]
          +"BathroomsPartial": 1
          +"CommunityFeatures": array:2 [
            0 => "Quiet Area"
            1 => "Community Centre"
          ]
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-07-02T16:19:31.551916+00:00"
          +"Directions": "Kelso Dr/LakeLouise Blvd"
          +"ExteriorFeatures": array:3 [
            0 => "Brick"
            1 => "Stone"
            2 => "Vinyl siding"
          ]
          +"FireplaceFeatures": array:2 [
            0 => "Electric"
            1 => "Other - See remarks"
          ]
          +"FireplaceYN": true
          +"FireplacesTotal": "1"
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "1564507"
          +"ListOfficeKey": "289722"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:2 [
            0 => "Conservation/green belt"
            1 => "Automatic Garage Door Opener"
          ]
          +"LotSizeDimensions": "0.144"
          +"ParkingFeatures": array:1 [
            0 => "Attached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-07-02T18:34:06Z"
          +"PhotosCount": 50
          +"Sewer": array:1 [
            0 => "Sanitary sewer"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-07-05T20:19:21Z"
          +"Stories": "2.0"
          +"StreetName": "KELSO"
          +"StreetNumber": "430"
          +"StreetSuffix": "Drive"
          +"SubdivisionName": "442 - Lakeshore North"
          +"TaxAnnualAmount": "6672"
          +"VirtualTourURLUnbranded": "https://youriguide.com/c95ms_430_kelso_dr_waterloo_on/"
          +"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": "Cornerstone"
          +"ListAORKey": "14"
          +"ListingURL": "www.realtor.ca/real-estate/29977455/430-kelso-drive-waterloo"
          +"ParkingTotal": 4
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"SecurityFeatures": array:1 [
            0 => "Smoke Detectors"
          ]
          +"ZoningDescription": "R"
          +"BedroomsAboveGrade": 4
          +"BedroomsBelowGrade": 1
          +"FrontageLengthNumeric": 45.0
          +"AboveGradeFinishedArea": 2250
          +"BelowGradeFinishedArea": 988
          +"OriginalEntryTimestamp": "2026-07-02T14:12:03.26Z"
          +"FrontageLengthNumericUnits": "feet"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"BelowGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Plans"
          +"BelowGradeFinishedAreaSource": "Plans"
          +"ListAgentNationalAssociationId": "1123254"
          +"ListOfficeNationalAssociationId": "1380559"
          +"Media": array:50 [
            0 => array:13 [ …13]
            1 => array:13 [ …13]
            2 => array:13 [ …13]
            3 => array:13 [ …13]
            4 => array:13 [ …13]
            5 => array:13 [ …13]
            6 => array:13 [ …13]
            7 => array:13 [ …13]
            8 => array:13 [ …13]
            9 => array:13 [ …13]
            10 => array:13 [ …13]
            11 => array:13 [ …13]
            12 => array:13 [ …13]
            13 => array:13 [ …13]
            14 => array:13 [ …13]
            15 => array:13 [ …13]
            16 => array:13 [ …13]
            17 => array:13 [ …13]
            18 => array:13 [ …13]
            19 => array:13 [ …13]
            20 => array:13 [ …13]
            21 => array:13 [ …13]
            22 => array:13 [ …13]
            23 => array:13 [ …13]
            24 => array:13 [ …13]
            25 => array:13 [ …13]
            26 => array:13 [ …13]
            27 => array:13 [ …13]
            28 => array:13 [ …13]
            29 => array:13 [ …13]
            30 => array:13 [ …13]
            31 => array:13 [ …13]
            32 => array:13 [ …13]
            33 => array:13 [ …13]
            34 => array:13 [ …13]
            35 => array:13 [ …13]
            36 => array:13 [ …13]
            37 => array:13 [ …13]
            38 => array:13 [ …13]
            39 => array:13 [ …13]
            40 => array:13 [ …13]
            41 => array:13 [ …13]
            42 => array:13 [ …13]
            43 => array:13 [ …13]
            44 => array:13 [ …13]
            45 => array:13 [ …13]
            46 => array:13 [ …13]
            47 => array:13 [ …13]
            48 => array:13 [ …13]
            49 => array:13 [ …13]
          ]
          +"DaysOnMarket": 5
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977455')"
          +"ID": "1583779"
        }
        8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25315
          +post_id: "1584541"
          +post_author: 1
          +"ListingKey": "29977329"
          +"ListingId": "X13511442"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-07-06T14:20:04Z"
          +"RFModificationTimestamp": "2026-07-06T14:32:43Z"
          +"ListPrice": 949900.0
          +"BathroomsTotalInteger": 3.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 3.0
          +"LotSizeArea": 0
          +"LivingArea": 0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V2J3"
          +"UnparsedAddress": "500 GLACIER STREET, Waterloo, Ontario N2V2J3"
          +"Coordinates": array:2 [
            0 => -80.578434
            1 => 43.495943
          ]
          +"Latitude": 43.495943
          +"Longitude": -80.578434
          +"YearBuilt": 0
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Toronto Regional Real Estate Board"
          +"PublicRemarks": "Welcome to 500 Glacier Street in Waterloo - your dream home with a spectacular backyard retreat, including a heated above-ground saltwater pool, backing onto greenspace & trails. Situated on an oversized corner lot in the highly desirable & family-oriented neighbourhood of Conservation Meadows, this lovely 4-bed, 3-bath home offers over 2,700 sq. ft. of finished living space, many recent updates & a bright, spacious open-concept layout perfect for entertaining or relaxing with family. The recently renovated gourmet kitchen features stainless steel appliances, a beautiful backsplash & a convenient centre island for casual dining, while the oversized dining area offers plenty of space for more formal gatherings. Relax & unwind in the sophisticated family room, complete with a gas fireplace, oversized windows & sliding door access to the expansive deck & pool area. A 2-piece bathroom & main floor laundry complete the main level. Upstairs, the stunning primary suite features vaulted ceilings, custom built-ins, two walk-in closets & a newly updated spa-like 3-piece ensuite with tiled glass shower, rain shower fixture, heated floors & heated towel rack. Two additional spacious bedrooms & a 4-piece main bathroom complete this level. The fully finished basement offers a large recreation room, a potential 4th bedroom & the added convenience of a walk-up directly into the garage. Notable updates include furnace & air conditioning in 2017, shingles in 2015 & above-ground saltwater pool in 2018. Additional features include a carpet-free main & lower level with luxury vinyl flooring, custom blinds & more. Backing onto greenspace & walking trails, surrounded by mature trees & lush perennial gardens, this lovely home is located on a quiet, tree-lined street in a premium location close to schools, parks, Laurel Creek Conservation Area, shopping, restaurants, Starbucks, Sobeys, St. Jacobs Farmers' Market, quick highway access & more. (id:62650)"
          +"Appliances": array:11 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Water meter"
            3 => "Dishwasher"
            4 => "Stove"
            5 => "Dryer"
            6 => "Water Treatment"
            7 => "Window Coverings"
            8 => "Garage door opener"
            9 => "Garage door opener remote(s)"
            10 => "Water Heater"
          ]
          +"Basement": array:2 [
            0 => "Finished"
            1 => "N/A"
          ]
          +"BathroomsPartial": 1
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-07-02T15:52:13.449772+00:00"
          +"Directions": "Cross Streets: Lake Louise Blvd. ** Directions: Conservation Drive to Lake Louise to Glacier."
          +"ExteriorFeatures": array:2 [
            0 => "Brick"
            1 => "Vinyl siding"
          ]
          +"FireplaceYN": true
          +"FireplacesTotal": "1"
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "2099842"
          +"ListOfficeKey": "288578"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:3 [
            0 => "Wooded area"
            1 => "Conservation/green belt"
            2 => "Sump Pump"
          ]
          +"LotSizeDimensions": "63.1 x 124.7 FT"
          +"ParkingFeatures": array:2 [
            0 => "Attached Garage"
            1 => "Garage"
          ]
          +"PhotosChangeTimestamp": "2026-07-06T13:38:20Z"
          +"PhotosCount": 45
          +"PoolFeatures": array:2 [
            0 => "Above ground pool"
            1 => "Salt Water Pool"
          ]
          +"Sewer": array:1 [
            0 => "Sanitary sewer"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-07-06T14:10:35Z"
          +"Stories": "2.0"
          +"StreetName": "Glacier"
          +"StreetNumber": "500"
          +"StreetSuffix": "Street"
          +"TaxAnnualAmount": "5653"
          +"View": "View"
          +"VirtualTourURLUnbranded": "https://youriguide.com/500_glacier_street_waterloo_on/doc/floorplan_imperial.pdf"
          +"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": "Toronto"
          +"TaxYear": 2025
          +"ListAORKey": "82"
          +"ListingURL": "www.realtor.ca/real-estate/29977329/500-glacier-street-waterloo"
          +"ParkingTotal": 4
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": false
          +"BuildingFeatures": array:1 [
            0 => "Fireplace(s)"
          ]
          +"LivingAreaMaximum": 2000
          +"LivingAreaMinimum": 1500
          +"ZoningDescription": "R"
          +"BedroomsAboveGrade": 3
          +"FrontageLengthNumeric": 63.1
          +"OriginalEntryTimestamp": "2026-07-02T13:47:07.33Z"
          +"FrontageLengthNumericUnits": "feet"
          +"ListAgentNationalAssociationId": "1370032"
          +"ListOfficeNationalAssociationId": "1369645"
          +"Media": array:45 [
            0 => array:13 [ …13]
            1 => array:13 [ …13]
            2 => array:13 [ …13]
            3 => array:13 [ …13]
            4 => array:13 [ …13]
            5 => array:13 [ …13]
            6 => array:13 [ …13]
            7 => array:13 [ …13]
            8 => array:13 [ …13]
            9 => array:13 [ …13]
            10 => array:13 [ …13]
            11 => array:13 [ …13]
            12 => array:13 [ …13]
            13 => array:13 [ …13]
            14 => array:13 [ …13]
            15 => array:13 [ …13]
            16 => array:13 [ …13]
            17 => array:13 [ …13]
            18 => array:13 [ …13]
            19 => array:13 [ …13]
            20 => array:13 [ …13]
            21 => array:13 [ …13]
            22 => array:13 [ …13]
            23 => array:13 [ …13]
            24 => array:13 [ …13]
            25 => array:13 [ …13]
            26 => array:13 [ …13]
            27 => array:13 [ …13]
            28 => array:13 [ …13]
            29 => array:13 [ …13]
            30 => array:13 [ …13]
            31 => array:13 [ …13]
            32 => array:13 [ …13]
            33 => array:13 [ …13]
            34 => array:13 [ …13]
            35 => array:13 [ …13]
            36 => array:13 [ …13]
            37 => array:13 [ …13]
            38 => array:13 [ …13]
            39 => array:13 [ …13]
            40 => array:13 [ …13]
            41 => array:13 [ …13]
            42 => array:13 [ …13]
            43 => array:13 [ …13]
            44 => array:13 [ …13]
          ]
          +"DaysOnMarket": 5
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977329')"
          +"ID": "1584541"
        }
      ]
      +success: true
      +page_size: 9
      +page_count: 8
      +count: 64
      +after_key: ""
    }
    "RF Response Time" => "0.22 seconds"
  ]
]

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