Listings - ComFree Realty

Back to Map

$949,900

Ontario,Waterloo

For Sale Active

500 GLACIER Street, Waterloo, Ontario N2V2J3

3
3
2,733 Sqft

Contact Seller

Next Open House

Jul 4 14:00 - 16:00
Jul 5 14:00 - 16:00

Basic Details

Description

**PUBLIC OPEN HOUSE: SAT & SUN 2-4 PM** 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)

Basic Details

Property Type: Residential
Listing Type: For Sale
Listing ID: 40842487
Price: $949,900
Bedrooms: 3
Bathrooms: 3
Half Bathrooms: 1
Square Footage: 2,733 Sqft
Year Built: 2001
Status: Active
Property Sub Type: Single Family
Office Key: 289722

Features & Appliances

Features

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

Address Map

Location: CA, Ontario, Waterloo, 441 - Erbsville/Laurelwood, N2V2J3
Street: GLACIER
Street Number: 500
Street Suffix: Street
Longitude: W81° 25' 15.5''
Latitude: N43° 29' 44.8''

Additional Information

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

Financial

Tax Annual Amount: 5653

Listing updated: 2026-07-04 06:55:40

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: 1564122
List Office Key: 289722
Modification Timestamp: 2026-07-03T16:25:14Z
Originating System Name: Cornerstone Association of REALTORS®
Status Change Timestamp: 2026-07-03T16:18:39Z

Listing updated: 2026-07-04 06:55:41

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 {#25364
  +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 [
      "RoomKey" => "1674321401"
      "RoomType" => "Utility room"
      "ListingId" => "40844884"
      "RoomLevel" => "Basement"
      "RoomWidth" => null
      "ListingKey" => "29986386"
      "RoomLength" => null
      "RoomDimensions" => "15'9'' x 11'5''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-07-03T18:48:32.67Z"
    ]
    1 => array:11 [
      "RoomKey" => "1674321402"
      "RoomType" => "3pc Bathroom"
      "ListingId" => "40844884"
      "RoomLevel" => "Basement"
      "RoomWidth" => null
      "ListingKey" => "29986386"
      "RoomLength" => null
      "RoomDimensions" => "5'0'' x 8'0''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-07-03T18:48:32.67Z"
    ]
    2 => array:11 [
      "RoomKey" => "1674321403"
      "RoomType" => "Recreation room"
      "ListingId" => "40844884"
      "RoomLevel" => "Basement"
      "RoomWidth" => null
      "ListingKey" => "29986386"
      "RoomLength" => null
      "RoomDimensions" => "15'9'' x 16'2''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-07-03T18:48:32.67Z"
    ]
    3 => array:11 [
      "RoomKey" => "1674321404"
      "RoomType" => "4pc Bathroom"
      "ListingId" => "40844884"
      "RoomLevel" => "Second level"
      "RoomWidth" => null
      "ListingKey" => "29986386"
      "RoomLength" => null
      "RoomDimensions" => "5'0'' x 8'7''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-07-03T18:48:32.67Z"
    ]
    4 => array:11 [
      "RoomKey" => "1674321405"
      "RoomType" => "Bedroom"
      "ListingId" => "40844884"
      "RoomLevel" => "Second level"
      "RoomWidth" => null
      "ListingKey" => "29986386"
      "RoomLength" => null
      "RoomDimensions" => "8'1'' x 15'5''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-07-03T18:48:32.67Z"
    ]
    5 => array:11 [
      "RoomKey" => "1674321406"
      "RoomType" => "Bedroom"
      "ListingId" => "40844884"
      "RoomLevel" => "Second level"
      "RoomWidth" => null
      "ListingKey" => "29986386"
      "RoomLength" => null
      "RoomDimensions" => "8'2'' x 12'7''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-07-03T18:48:32.67Z"
    ]
    6 => array:11 [
      "RoomKey" => "1674321407"
      "RoomType" => "Primary Bedroom"
      "ListingId" => "40844884"
      "RoomLevel" => "Second level"
      "RoomWidth" => null
      "ListingKey" => "29986386"
      "RoomLength" => null
      "RoomDimensions" => "11'2'' x 13'11''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-07-03T18:48:32.68Z"
    ]
    7 => array:11 [
      "RoomKey" => "1674321408"
      "RoomType" => "Living room"
      "ListingId" => "40844884"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29986386"
      "RoomLength" => null
      "RoomDimensions" => "15'11'' x 11'1''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-07-03T18:48:32.68Z"
    ]
    8 => array:11 [
      "RoomKey" => "1674321409"
      "RoomType" => "Dining room"
      "ListingId" => "40844884"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29986386"
      "RoomLength" => null
      "RoomDimensions" => "12'5'' x 6'3''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-07-03T18:48:32.68Z"
    ]
    9 => array:11 [
      "RoomKey" => "1674321410"
      "RoomType" => "Kitchen"
      "ListingId" => "40844884"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29986386"
      "RoomLength" => null
      "RoomDimensions" => "9'9'' x 12'0''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-07-03T18:48:32.68Z"
    ]
  ]
  +"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 [
      "Order" => 1
      "MediaKey" => "29986386_4890_1"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/edf6004f17ee07911190f726f53faa0e.webp"
      "MediaSize" => 126099
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-edf6004f17ee07911190f726f53faa0e.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Two-story residence featuring light-colored siding and brick accents"
      "PreferredPhotoYN" => true
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    1 => array:13 [
      "Order" => 2
      "MediaKey" => "29986386_4890_2"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/ebbd371a1b79cf34c44be0667d39d897.webp"
      "MediaSize" => 137506
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-ebbd371a1b79cf34c44be0667d39d897.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Two-story residence featuring light-colored siding, brickwork accents, and brown shutters"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    2 => array:13 [
      "Order" => 3
      "MediaKey" => "29986386_4890_3"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/35cc87c76a129274075653fc83789d37.webp"
      "MediaSize" => 125244
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-35cc87c76a129274075653fc83789d37.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Traditional two-story residence with a covered porch, bay window, and a combination of brick and siding exterior"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    3 => array:13 [
      "Order" => 4
      "MediaKey" => "29986386_4890_4"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/70dbf40ecf599957677c0de3b32c0517.webp"
      "MediaSize" => 120526
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-70dbf40ecf599957677c0de3b32c0517.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Two-story residence featuring a brick and siding exterior with brown shutters"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    4 => array:13 [
      "Order" => 5
      "MediaKey" => "29986386_4890_5"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/6ca0d2b53c651888f71e7cc336c8462b.webp"
      "MediaSize" => 108394
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-6ca0d2b53c651888f71e7cc336c8462b.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Inviting front porch featuring a brick facade, white railing, and an architectural bay window"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    5 => array:13 [
      "Order" => 6
      "MediaKey" => "29986386_4890_6"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/44b0b890ac50ab7203ec775064c82e58.webp"
      "MediaSize" => 102394
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-44b0b890ac50ab7203ec775064c82e58.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Covered porch featuring a brick exterior and a bay window with white trim"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    6 => array:13 [
      "Order" => 7
      "MediaKey" => "29986386_4890_7"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/5eccda1ebaff77e6355a6860498d2a27.webp"
      "MediaSize" => 55381
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-5eccda1ebaff77e6355a6860498d2a27.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Carpeted staircase with wooden handrail"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    7 => array:13 [
      "Order" => 8
      "MediaKey" => "29986386_4890_8"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/75e3b06136872bb25db64816cc5aa8ad.webp"
      "MediaSize" => 57199
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-75e3b06136872bb25db64816cc5aa8ad.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    8 => array:13 [
      "Order" => 9
      "MediaKey" => "29986386_4890_9"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/dfda0a8297575b84ed469f297dca1bd9.webp"
      "MediaSize" => 70572
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-dfda0a8297575b84ed469f297dca1bd9.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    9 => array:13 [
      "Order" => 10
      "MediaKey" => "29986386_4890_10"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/bc1fdd4c80bca1321c5cf8408f371097.webp"
      "MediaSize" => 63656
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-bc1fdd4c80bca1321c5cf8408f371097.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Modern kitchen featuring white flat-panel cabinetry and white subway tile backsplash"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    10 => array:13 [
      "Order" => 11
      "MediaKey" => "29986386_4890_11"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/7786e0129a45de9b2ebee2b078c2f3ba.webp"
      "MediaSize" => 66084
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-7786e0129a45de9b2ebee2b078c2f3ba.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Kitchen featuring white flat-panel cabinetry, white subway tile backsplash, white countertops, and wood-finish flooring"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    11 => array:13 [
      "Order" => 12
      "MediaKey" => "29986386_4890_12"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/b13b50b46037faad030f104bdc7b1849.webp"
      "MediaSize" => 68833
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-b13b50b46037faad030f104bdc7b1849.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Bright dining area featuring a bay window, light wood-finish flooring, and white baseboards"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    12 => array:13 [
      "Order" => 13
      "MediaKey" => "29986386_4890_13"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/a925fee8079100225e2e883d8a44ae82.webp"
      "MediaSize" => 72139
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-a925fee8079100225e2e883d8a44ae82.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Dining area featuring wood-finish flooring, a contemporary circular chandelier, and a built-in wooden sideboard"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    13 => array:13 [
      "Order" => 14
      "MediaKey" => "29986386_4890_14"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/cc34e40db0a4142b3ed2f15a9d7ad542.webp"
      "MediaSize" => 71367
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-cc34e40db0a4142b3ed2f15a9d7ad542.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Open concept living area featuring light wood-finish flooring"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    14 => array:13 [
      "Order" => 15
      "MediaKey" => "29986386_4890_15"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/96aeec02024ad0154a1603857cbd3c93.webp"
      "MediaSize" => 71457
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-96aeec02024ad0154a1603857cbd3c93.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Dining area with wood-finish flooring and a contemporary circular chandelier"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    15 => array:13 [
      "Order" => 16
      "MediaKey" => "29986386_4890_16"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/adfa1279cf6a63a94cacc1e7ee8b1f33.webp"
      "MediaSize" => 74827
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-adfa1279cf6a63a94cacc1e7ee8b1f33.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Spacious living area featuring wood-finish flooring, a neutral color palette, and sliding glass doors providing outdoor access"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    16 => array:13 [
      "Order" => 17
      "MediaKey" => "29986386_4890_17"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/3698a2fe881f6a1c0e019eb1097bbec6.webp"
      "MediaSize" => 81803
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-3698a2fe881f6a1c0e019eb1097bbec6.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Living area with light wood-finish flooring, light gray wall color, and a sliding glass door leading to an outdoor patio with a pergola"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    17 => array:13 [
      "Order" => 18
      "MediaKey" => "29986386_4890_18"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/575e6cab5df5cb48f79333e9973a14fc.webp"
      "MediaSize" => 82188
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-575e6cab5df5cb48f79333e9973a14fc.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Spacious living area featuring light wood-finish flooring, light gray wall tones, and a large window with vertical blinds"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    18 => array:13 [
      "Order" => 19
      "MediaKey" => "29986386_4890_19"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/d05b8ba30d5d116997b985be1e470aec.webp"
      "MediaSize" => 81290
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-d05b8ba30d5d116997b985be1e470aec.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Spacious living area featuring light wood-finish flooring, light gray wall paint, and a modern ceiling light fixture"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    19 => array:13 [
      "Order" => 20
      "MediaKey" => "29986386_4890_20"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/006f4645391d3e28f36e46ec167e149b.webp"
      "MediaSize" => 46060
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-006f4645391d3e28f36e46ec167e149b.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    20 => array:13 [
      "Order" => 21
      "MediaKey" => "29986386_4890_21"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/537ad01831057100caa7769542aa5b50.webp"
      "MediaSize" => 51463
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-537ad01831057100caa7769542aa5b50.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Hallway featuring light beige walls and carpeting, with white doors and black hardware"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    21 => array:13 [
      "Order" => 22
      "MediaKey" => "29986386_4890_22"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/f10b7f59fe1433fb661725913309f7eb.webp"
      "MediaSize" => 77839
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-f10b7f59fe1433fb661725913309f7eb.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Room featuring light green wall paint and wood-finish flooring"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    22 => array:13 [
      "Order" => 23
      "MediaKey" => "29986386_4890_23"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/38c2a1073b195dd30d3680d21e41a802.webp"
      "MediaSize" => 76095
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-38c2a1073b195dd30d3680d21e41a802.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Bedroom featuring hardwood flooring, a ceiling-mounted light fixture, and two white sliding closet doors"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    23 => array:13 [
      "Order" => 24
      "MediaKey" => "29986386_4890_24"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/8ee9a7307405d6bb1b69dc41ddb8c23a.webp"
      "MediaSize" => 62130
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-8ee9a7307405d6bb1b69dc41ddb8c23a.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Bathroom featuring a white vanity with a light-colored countertop, an undermount sink, and chrome fixtures"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    24 => array:13 [
      "Order" => 25
      "MediaKey" => "29986386_4890_25"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/a4bab9dd291c1d37e57ebafde9beec24.webp"
      "MediaSize" => 48867
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-a4bab9dd291c1d37e57ebafde9beec24.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    25 => array:13 [
      "Order" => 26
      "MediaKey" => "29986386_4890_26"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/0bb90721cfe75386e64ba554587ab07b.webp"
      "MediaSize" => 50427
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-0bb90721cfe75386e64ba554587ab07b.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Room with wood-finish flooring, white walls, and a recessed ceiling light"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    26 => array:13 [
      "Order" => 27
      "MediaKey" => "29986386_4890_27"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/88fcc83c0942f9005e7860018cf72c52.webp"
      "MediaSize" => 70327
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-88fcc83c0942f9005e7860018cf72c52.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Bedroom with wood-finish flooring, a window featuring white trim, and a ceiling light fixture"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    27 => array:13 [
      "Order" => 28
      "MediaKey" => "29986386_4890_28"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/b526c4f0c76142bb08553589dd0470ba.webp"
      "MediaSize" => 63413
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-b526c4f0c76142bb08553589dd0470ba.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Bedroom featuring wood-finish flooring, white walls, and a recessed closet with bi-fold doors"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    28 => array:13 [
      "Order" => 29
      "MediaKey" => "29986386_4890_29"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/f25ce04491ec30b74f212723f76d5ff3.webp"
      "MediaSize" => 82725
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-f25ce04491ec30b74f212723f76d5ff3.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Finished lower level featuring light gray walls, carpeted flooring, and a drop ceiling with recessed lighting"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    29 => array:13 [
      "Order" => 30
      "MediaKey" => "29986386_4890_30"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/b6bfa497d07ffff11cffd8e3a68ef11a.webp"
      "MediaSize" => 75642
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-b6bfa497d07ffff11cffd8e3a68ef11a.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Finished recreational space featuring neutral wall tones, drop-panel ceiling, and light-toned carpet"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    30 => array:13 [
      "Order" => 31
      "MediaKey" => "29986386_4890_31"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/ab96a5e3b679bab93ac55b895824d86f.webp"
      "MediaSize" => 80239
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-ab96a5e3b679bab93ac55b895824d86f.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Carpeted room with light grey walls and a drop ceiling featuring recessed lighting"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    31 => array:13 [
      "Order" => 32
      "MediaKey" => "29986386_4890_32"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/6dfe1a2f34cd09152f968924b746decc.webp"
      "MediaSize" => 99599
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-6dfe1a2f34cd09152f968924b746decc.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Carpeted lower level featuring drop ceiling with recessed lighting"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    32 => array:13 [
      "Order" => 33
      "MediaKey" => "29986386_4890_33"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/1e94d404c93a84e8738c3ee45b17dd2d.webp"
      "MediaSize" => 76283
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-1e94d404c93a84e8738c3ee45b17dd2d.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Carpeted lower-level room featuring light gray walls, white trim, and a drop ceiling with recessed lighting"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    33 => array:13 [
      "Order" => 34
      "MediaKey" => "29986386_4890_34"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/2ed48254465ff0387e5a287f6bc76d35.webp"
      "MediaSize" => 48922
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-2ed48254465ff0387e5a287f6bc76d35.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Bathroom featuring a white vanity with matte black hardware, a rectangular mirror, a white undermount sink with a matte black faucet, a white shower stall, and dark wood-finish flooring"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    34 => array:13 [
      "Order" => 35
      "MediaKey" => "29986386_4890_35"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/219d9703aeefff3a332df19b2d27a167.webp"
      "MediaSize" => 169441
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-219d9703aeefff3a332df19b2d27a167.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Expansive backyard featuring a lush lawn, a stone patio, and a gazebo with privacy curtains"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    35 => array:13 [
      "Order" => 36
      "MediaKey" => "29986386_4890_36"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/65795d6c9f0b914ac982b3a8e8f88470.webp"
      "MediaSize" => 141674
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-65795d6c9f0b914ac982b3a8e8f88470.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    36 => array:13 [
      "Order" => 37
      "MediaKey" => "29986386_4890_37"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/64b760b695d0856bad338629e1cb368d.webp"
      "MediaSize" => 152013
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-64b760b695d0856bad338629e1cb368d.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Fenced backyard featuring a freestanding gazebo with privacy screens, a paver patio area, and a manicured lawn"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    37 => array:13 [
      "Order" => 38
      "MediaKey" => "29986386_4890_38"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/1f2c9a45d2c8d10d5cfd5267f45feeef.webp"
      "MediaSize" => 152110
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-1f2c9a45d2c8d10d5cfd5267f45feeef.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Expansive backyard featuring a manicured lawn, a gazebo with privacy curtains, and established perimeter landscaping"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    38 => array:13 [
      "Order" => 39
      "MediaKey" => "29986386_4890_39"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/dccfaf0047bc6687dd74d25425b8f7b1.webp"
      "MediaSize" => 129727
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-dccfaf0047bc6687dd74d25425b8f7b1.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Covered patio featuring a metal gazebo with privacy curtains, a sliding glass door, brick exterior, concrete patio flooring, and a privacy fence"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
    39 => array:13 [
      "Order" => 40
      "MediaKey" => "29986386_4890_40"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/57a0745d41242edd7b4c27930d104469.webp"
      "MediaSize" => 136557
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-57a0745d41242edd7b4c27930d104469.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Black metal gazebo featuring a solid roof, privacy curtains, and mesh screens"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40844884"
      "ResourceRecordKey" => "29986386"
      "ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
    ]
  ]
  +"DaysOnMarket": 0
  +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986386')"
  +"ID": "1590741"
}

MLS On The Fly Debug Panel

 array:6 [
  "RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29977664 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
      +items: array:1 [
        0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
          +post_id: ? mixed
          +post_author: ? mixed
          +"ListingKey": "29977664"
          +"ListingId": "40842487"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-07-03T16:25:14Z"
          +"RFModificationTimestamp": "2026-07-03T16:29:59Z"
          +"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": "**PUBLIC OPEN HOUSE: SAT & SUN 2-4 PM** 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-03T15:31:21Z"
          +"PhotosCount": 49
          +"PoolFeatures": array:1 [
            0 => "Above ground pool"
          ]
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-07-03T16:18:39Z"
          +"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 [
              "RoomKey" => "1674206911"
              "RoomType" => "Utility room"
              "ListingId" => "40842487"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "29977664"
              "RoomLength" => null
              "RoomDimensions" => "6'3'' x 12'5''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-03T16:18:39.73Z"
            ]
            1 => array:11 [
              "RoomKey" => "1674206912"
              "RoomType" => "Recreation room"
              "ListingId" => "40842487"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "29977664"
              "RoomLength" => null
              "RoomDimensions" => "22'0'' x 20'4''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-03T16:18:39.73Z"
            ]
            2 => array:11 [
              "RoomKey" => "1674206913"
              "RoomType" => "Office"
              "ListingId" => "40842487"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "29977664"
              "RoomLength" => null
              "RoomDimensions" => "12'5'' x 10'8''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-03T16:18:39.74Z"
            ]
            3 => array:11 [
              "RoomKey" => "1674206914"
              "RoomType" => "Primary Bedroom"
              "ListingId" => "40842487"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29977664"
              "RoomLength" => null
              "RoomDimensions" => "16'0'' x 17'7''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-03T16:18:39.74Z"
            ]
            4 => array:11 [
              "RoomKey" => "1674206915"
              "RoomType" => "Bedroom"
              "ListingId" => "40842487"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29977664"
              "RoomLength" => null
              "RoomDimensions" => "14'9'' x 9'10''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-03T16:18:39.74Z"
            ]
            5 => array:11 [
              "RoomKey" => "1674206916"
              "RoomType" => "Bedroom"
              "ListingId" => "40842487"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29977664"
              "RoomLength" => null
              "RoomDimensions" => "9'11'' x 11'4''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-03T16:18:39.74Z"
            ]
            6 => array:11 [
              "RoomKey" => "1674206917"
              "RoomType" => "4pc Bathroom"
              "ListingId" => "40842487"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29977664"
              "RoomLength" => null
              "RoomDimensions" => "9'2'' x 7'10''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-03T16:18:39.74Z"
            ]
            7 => array:11 [
              "RoomKey" => "1674206918"
              "RoomType" => "Full bathroom"
              "ListingId" => "40842487"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29977664"
              "RoomLength" => null
              "RoomDimensions" => "11'9'' x 4'11''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-03T16:18:39.74Z"
            ]
            8 => array:11 [
              "RoomKey" => "1674206919"
              "RoomType" => "Kitchen"
              "ListingId" => "40842487"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29977664"
              "RoomLength" => null
              "RoomDimensions" => "13'7'' x 11'3''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-03T16:18:39.74Z"
            ]
            9 => array:11 [
              "RoomKey" => "1674206920"
              "RoomType" => "Living room"
              "ListingId" => "40842487"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29977664"
              "RoomLength" => null
              "RoomDimensions" => "13'7'' x 20'11''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-03T16:18:39.74Z"
            ]
            10 => array:11 [
              "RoomKey" => "1674206921"
              "RoomType" => "Dining room"
              "ListingId" => "40842487"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29977664"
              "RoomLength" => null
              "RoomDimensions" => "13'0'' x 9'8''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-03T16:18:39.74Z"
            ]
            11 => array:11 [
              "RoomKey" => "1674206922"
              "RoomType" => "2pc Bathroom"
              "ListingId" => "40842487"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29977664"
              "RoomLength" => null
              "RoomDimensions" => "5'11'' x 4'5''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-07-03T16:18:39.74Z"
            ]
          ]
          +"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 [
              "Order" => 1
              "MediaKey" => "29977664_4890_1"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/cfdbd1bad1a6b8f739457d43984356b1.webp"
              "MediaSize" => 123752
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-cfdbd1bad1a6b8f739457d43984356b1.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Great curb appeal with aggregate driveway and welcoming gardens"
              "PreferredPhotoYN" => true
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            1 => array:13 [
              "Order" => 2
              "MediaKey" => "29977664_4890_2"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/fa985f654cffc634d0156dc72ab1a08b.webp"
              "MediaSize" => 138228
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-fa985f654cffc634d0156dc72ab1a08b.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Lovely gardens"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            2 => array:13 [
              "Order" => 3
              "MediaKey" => "29977664_4890_3"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/42062f7f7c9bfe46d4288cfcb544cd94.webp"
              "MediaSize" => 68098
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-42062f7f7c9bfe46d4288cfcb544cd94.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Bright foyer with ceramic tile"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            3 => array:13 [
              "Order" => 4
              "MediaKey" => "29977664_4890_4"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/236e8d15636f7f7530cf4af354038ec9.webp"
              "MediaSize" => 73284
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-236e8d15636f7f7530cf4af354038ec9.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            4 => array:13 [
              "Order" => 5
              "MediaKey" => "29977664_4890_5"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/a4d58d5001c5172a5dc751a5fc408591.webp"
              "MediaSize" => 91002
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-a4d58d5001c5172a5dc751a5fc408591.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Spacious dining area"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            5 => array:13 [
              "Order" => 6
              "MediaKey" => "29977664_4890_6"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/d6398f5d7990e8fa90adc8aac654c97d.webp"
              "MediaSize" => 76246
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-d6398f5d7990e8fa90adc8aac654c97d.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Bright white kitchen with blue lower cabinets and wood accents"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            6 => array:13 [
              "Order" => 7
              "MediaKey" => "29977664_4890_7"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/f0a944201095ef453639647387b81874.webp"
              "MediaSize" => 75900
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-f0a944201095ef453639647387b81874.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            7 => array:13 [
              "Order" => 8
              "MediaKey" => "29977664_4890_8"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/bb5a1e8538ef7b8260ac1e928bff649a.webp"
              "MediaSize" => 84433
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-bb5a1e8538ef7b8260ac1e928bff649a.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            8 => array:13 [
              "Order" => 9
              "MediaKey" => "29977664_4890_9"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/03f0d69997f078220ce975fc96b1eb97.webp"
              "MediaSize" => 67480
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-03f0d69997f078220ce975fc96b1eb97.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Super clean and spacious kitchen with stainless steel appliances and undermount lighting"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            9 => array:13 [
              "Order" => 10
              "MediaKey" => "29977664_4890_10"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/c5c4c9210223df722403fb0c60f752ce.webp"
              "MediaSize" => 72121
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-c5c4c9210223df722403fb0c60f752ce.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            10 => array:13 [
              "Order" => 11
              "MediaKey" => "29977664_4890_11"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/e3f09cfa47b4faa75c44693bf69a8a9d.webp"
              "MediaSize" => 72707
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-e3f09cfa47b4faa75c44693bf69a8a9d.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Convenient center island"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            11 => array:13 [
              "Order" => 12
              "MediaKey" => "29977664_4890_12"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/d3cd42c7d7240d7234c394a5d27b5a1f.webp"
              "MediaSize" => 61716
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-d3cd42c7d7240d7234c394a5d27b5a1f.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            12 => array:13 [
              "Order" => 13
              "MediaKey" => "29977664_4890_13"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/4b35af46800e745186b11f4a17815691.webp"
              "MediaSize" => 70887
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-4b35af46800e745186b11f4a17815691.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            13 => array:13 [
              "Order" => 14
              "MediaKey" => "29977664_4890_14"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/8880673802e2b85904efa3ba5c322736.webp"
              "MediaSize" => 68906
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-8880673802e2b85904efa3ba5c322736.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            14 => array:13 [
              "Order" => 15
              "MediaKey" => "29977664_4890_15"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/5bec1e2fc945f1855280ee61157f3c03.webp"
              "MediaSize" => 66480
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-5bec1e2fc945f1855280ee61157f3c03.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Spacious and bright living room with walkout to deck and backyard"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            15 => array:13 [
              "Order" => 16
              "MediaKey" => "29977664_4890_16"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/d6cd158185ebd8fafb227902f825fd87.webp"
              "MediaSize" => 60374
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-d6cd158185ebd8fafb227902f825fd87.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            16 => array:13 [
              "Order" => 17
              "MediaKey" => "29977664_4890_17"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/3673cfc213228cbe49988fefb950fc65.webp"
              "MediaSize" => 82463
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-3673cfc213228cbe49988fefb950fc65.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            17 => array:13 [
              "Order" => 18
              "MediaKey" => "29977664_4890_18"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/520f360a2e155f7240b9b8863d928561.webp"
              "MediaSize" => 55055
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-520f360a2e155f7240b9b8863d928561.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "main floor 2 piece powder room"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            18 => array:13 [
              "Order" => 19
              "MediaKey" => "29977664_4890_19"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/eb524bb6a05dbb90e337ed0c9cb116e8.webp"
              "MediaSize" => 58721
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-eb524bb6a05dbb90e337ed0c9cb116e8.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Bedroom with ceiling fan"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            19 => array:13 [
              "Order" => 20
              "MediaKey" => "29977664_4890_20"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/17dbf3b9f72e8da38dcdbb9e04f4eca2.webp"
              "MediaSize" => 76320
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-17dbf3b9f72e8da38dcdbb9e04f4eca2.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            20 => array:13 [
              "Order" => 21
              "MediaKey" => "29977664_4890_21"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/e26a71fcf33b19f03493cafd0b5a5cbf.webp"
              "MediaSize" => 55346
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-e26a71fcf33b19f03493cafd0b5a5cbf.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Main 4 piece family bathroom"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            21 => array:13 [
              "Order" => 22
              "MediaKey" => "29977664_4890_22"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/04e1f70e5e0c80a5853d5c07fdeece34.webp"
              "MediaSize" => 37763
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-04e1f70e5e0c80a5853d5c07fdeece34.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            22 => array:13 [
              "Order" => 23
              "MediaKey" => "29977664_4890_23"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/7e6c80366ece359eb28ef0d09f058072.webp"
              "MediaSize" => 62428
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-7e6c80366ece359eb28ef0d09f058072.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Spacious primary suite with large window and built in dresser/drawers"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            23 => array:13 [
              "Order" => 24
              "MediaKey" => "29977664_4890_24"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/9e0d9a08014c9e203a0f6d20ed34bf74.webp"
              "MediaSize" => 70724
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-9e0d9a08014c9e203a0f6d20ed34bf74.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Lots of built ins and the book case opens up to the walk in closets!"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            24 => array:13 [
              "Order" => 25
              "MediaKey" => "29977664_4890_25"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/ab1b85985cdcd1bb269056819fb6140f.webp"
              "MediaSize" => 53686
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-ab1b85985cdcd1bb269056819fb6140f.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            25 => array:13 [
              "Order" => 26
              "MediaKey" => "29977664_4890_26"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/72f50eeba8c9bd6b63c7f0c1747a0ebc.webp"
              "MediaSize" => 61809
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-72f50eeba8c9bd6b63c7f0c1747a0ebc.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            26 => array:13 [
              "Order" => 27
              "MediaKey" => "29977664_4890_27"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/0325940647d935389b8a764a7bb7da36.webp"
              "MediaSize" => 62225
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-0325940647d935389b8a764a7bb7da36.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Stunning 3 piece ensuite with heated floors"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            27 => array:13 [
              "Order" => 28
              "MediaKey" => "29977664_4890_28"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/e8e27a9cecb3cd1285317591d743a048.webp"
              "MediaSize" => 38224
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-e8e27a9cecb3cd1285317591d743a048.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Custom glass walk in shower"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            28 => array:13 [
              "Order" => 29
              "MediaKey" => "29977664_4890_29"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/cb01f02da62706e1ede5afdee171be6f.webp"
              "MediaSize" => 41772
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-cb01f02da62706e1ede5afdee171be6f.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            29 => array:13 [
              "Order" => 30
              "MediaKey" => "29977664_4890_30"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/eebba0ec4389a047a58043e01b593b32.webp"
              "MediaSize" => 86082
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-eebba0ec4389a047a58043e01b593b32.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            30 => array:13 [
              "Order" => 31
              "MediaKey" => "29977664_4890_31"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/14efa8bd557ebe09946f696a404b3a1e.webp"
              "MediaSize" => 82798
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-14efa8bd557ebe09946f696a404b3a1e.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            31 => array:13 [
              "Order" => 32
              "MediaKey" => "29977664_4890_32"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/ef07764fe59c250dfad36142a5eb4888.webp"
              "MediaSize" => 80054
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-ef07764fe59c250dfad36142a5eb4888.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            32 => array:13 [
              "Order" => 33
              "MediaKey" => "29977664_4890_33"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/ba97c0d5676ca51fce433a05fec47d9d.webp"
              "MediaSize" => 83189
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-ba97c0d5676ca51fce433a05fec47d9d.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            33 => array:13 [
              "Order" => 34
              "MediaKey" => "29977664_4890_34"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/cb2b211b718d2cc90d23343a83a1a54a.webp"
              "MediaSize" => 123675
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-cb2b211b718d2cc90d23343a83a1a54a.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Deck and above ground salt water pool"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            34 => array:13 [
              "Order" => 35
              "MediaKey" => "29977664_4890_35"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/1a1bf5cd92fa3b302990118c03273556.webp"
              "MediaSize" => 124872
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-1a1bf5cd92fa3b302990118c03273556.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            35 => array:13 [
              "Order" => 36
              "MediaKey" => "29977664_4890_36"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/a65a6a1f0b2da8b9f50fc6aa2f09b768.webp"
              "MediaSize" => 119360
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-a65a6a1f0b2da8b9f50fc6aa2f09b768.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            36 => array:13 [
              "Order" => 37
              "MediaKey" => "29977664_4890_37"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/f2875961d4d9dd317b5ce4982320635b.webp"
              "MediaSize" => 136257
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-f2875961d4d9dd317b5ce4982320635b.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            37 => array:13 [
              "Order" => 38
              "MediaKey" => "29977664_4890_38"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/83ef0a4f7b8e2949e4eb428a285a2bee.webp"
              "MediaSize" => 126247
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-83ef0a4f7b8e2949e4eb428a285a2bee.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            38 => array:13 [
              "Order" => 39
              "MediaKey" => "29977664_4890_39"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/e12adb38c8825d5cdb7bae7b0dbc2f94.webp"
              "MediaSize" => 138159
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-e12adb38c8825d5cdb7bae7b0dbc2f94.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            39 => array:13 [
              "Order" => 40
              "MediaKey" => "29977664_4890_40"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/17c41e82a29e798079d307143c2071f4.webp"
              "MediaSize" => 140347
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-17c41e82a29e798079d307143c2071f4.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            40 => array:13 [
              "Order" => 41
              "MediaKey" => "29977664_4890_41"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/7aaf2c3b557f7a32384e885ab7677242.webp"
              "MediaSize" => 157624
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-7aaf2c3b557f7a32384e885ab7677242.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            41 => array:13 [
              "Order" => 42
              "MediaKey" => "29977664_4890_42"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/1f96b9552e7280e6111bc007ab51a4a4.webp"
              "MediaSize" => 136187
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-1f96b9552e7280e6111bc007ab51a4a4.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            42 => array:13 [
              "Order" => 43
              "MediaKey" => "29977664_4890_43"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/c0cd06f0c9a9d8e77025c4558b837e96.webp"
              "MediaSize" => 141381
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-c0cd06f0c9a9d8e77025c4558b837e96.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            43 => array:13 [
              "Order" => 44
              "MediaKey" => "29977664_4890_44"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/8907271bb5a659687fc9e1d52dd91efa.webp"
              "MediaSize" => 141381
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-8907271bb5a659687fc9e1d52dd91efa.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            44 => array:13 [
              "Order" => 45
              "MediaKey" => "29977664_4890_45"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/d67e7e05391499be6605f64b399ad1d3.webp"
              "MediaSize" => 169894
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-d67e7e05391499be6605f64b399ad1d3.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            45 => array:13 [
              "Order" => 46
              "MediaKey" => "29977664_4890_46"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/3469e826827e5a51b3a02e69a2e13b9b.webp"
              "MediaSize" => 162587
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-3469e826827e5a51b3a02e69a2e13b9b.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40842487"
              "ResourceRecordKey" => "29977664"
              "ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
            ]
            46 => array:13 [
              "Order" => 47
              "MediaKey" => "29977664_4890_47"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/00f3660c50d8a0d4bdd75eb1114a387e.webp"
              "MediaSize" => 40978
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-00f3660c50d8a0d4bdd75eb1114a387e.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
               …5
            ]
            47 => array:13 [ …13]
            48 => array:13 [ …13]
          ]
          +"DaysOnMarket": 1
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977664')"
        }
      ]
      +success: true
      +page_size: 1
      +page_count: 1
      +count: 1
      +after_key: ""
    }
    "RF Response Time" => "0.13 seconds"
  ]
  "RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 289722" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24909
      +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 1564122" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24867
      +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 '29977664'" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25273
      +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 '29977664'" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25290
      +items: array:4 [
        0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25289
          +post_id: ? mixed
          +post_author: ? mixed
          +"OpenHouseKey": "31774262"
          +"ListingKey": "29977664"
          +"ListingId": "40842487"
          +"OpenHouseStatus": "Active"
          +"OpenHouseType": "Open House"
          +"OpenHouseDate": "2026-07-04"
          +"OpenHouseStartTime": "2026-07-04T14:00:00Z"
          +"OpenHouseEndTime": "2026-07-04T16:00:00Z"
          +"OpenHouseRemarks": null
          +"OriginatingSystemName": "CREA"
          +"ModificationTimestamp": "2026-07-03T14:28:00Z"
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31774262')"
        }
        1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25291
          +post_id: ? mixed
          +post_author: ? mixed
          +"OpenHouseKey": "31774261"
          +"ListingKey": "29977664"
          +"ListingId": "40842487"
          +"OpenHouseStatus": "Active"
          +"OpenHouseType": "Open House"
          +"OpenHouseDate": "2026-07-05"
          +"OpenHouseStartTime": "2026-07-05T14:00:00Z"
          +"OpenHouseEndTime": "2026-07-05T16:00:00Z"
          +"OpenHouseRemarks": null
          +"OriginatingSystemName": "CREA"
          +"ModificationTimestamp": "2026-07-03T14:28:00Z"
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31774261')"
        }
        2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25288
          +post_id: ? mixed
          +post_author: ? mixed
          +"OpenHouseKey": "31776943"
          +"ListingKey": "29977664"
          +"ListingId": "40842487"
          +"OpenHouseStatus": "Active"
          +"OpenHouseType": "Open House"
          +"OpenHouseDate": "2026-07-05"
          +"OpenHouseStartTime": "2026-07-05T14:00:00Z"
          +"OpenHouseEndTime": "2026-07-05T16:00:00Z"
          +"OpenHouseRemarks": null
          +"OriginatingSystemName": "CREA"
          +"ModificationTimestamp": "2026-07-04T08:53:21Z"
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31776943')"
        }
        3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25292
          +post_id: ? mixed
          +post_author: ? mixed
          +"OpenHouseKey": "31776944"
          +"ListingKey": "29977664"
          +"ListingId": "40842487"
          +"OpenHouseStatus": "Active"
          +"OpenHouseType": "Open House"
          +"OpenHouseDate": "2026-07-04"
          +"OpenHouseStartTime": "2026-07-04T14:00:00Z"
          +"OpenHouseEndTime": "2026-07-04T16:00:00Z"
          +"OpenHouseRemarks": null
          +"OriginatingSystemName": "CREA"
          +"ModificationTimestamp": "2026-07-04T08:53:21Z"
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31776944')"
        }
      ]
      +success: true
      +page_size: 4
      +page_count: 1
      +count: 4
      +after_key: ""
    }
    "RF Response Time" => "0.11 seconds"
  ]
  "RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29977664' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5790234 43.4957774)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25393
      +items: array:9 [
        0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25364
          +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": 0
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986386')"
          +"ID": "1590741"
        }
        1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25366
          +post_id: "1585264"
          +post_author: 1
          +"ListingKey": "29979277"
          +"ListingId": "X13513406"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-07-03T00:20:40Z"
          +"RFModificationTimestamp": "2026-07-03T00:23:03Z"
          +"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-03T00:13:07Z"
          +"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": 1
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29979277')"
          +"ID": "1585264"
        }
        2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25363
          +post_id: "1583779"
          +post_author: 1
          +"ListingKey": "29977455"
          +"ListingId": "40841745"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-07-02T18:45:15Z"
          +"RFModificationTimestamp": "2026-07-02T19:10:05Z"
          +"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-02T18:34:06Z"
          +"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": 1
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977455')"
          +"ID": "1583779"
        }
        3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25367
          +post_id: "1584541"
          +post_author: 1
          +"ListingKey": "29977329"
          +"ListingId": "X13511442"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-07-03T15:20:05Z"
          +"RFModificationTimestamp": "2026-07-03T15:27:41Z"
          +"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": "**PUBLIC OPEN HOUSE: SAT & SUN, 2-4 PM** 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-02T15:37:24Z"
          +"PhotosCount": 45
          +"PoolFeatures": array:2 [
            0 => "Above ground pool"
            1 => "Salt Water Pool"
          ]
          +"Sewer": array:1 [
            0 => "Sanitary sewer"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-07-03T15:12:24Z"
          +"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": 1
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977329')"
          +"ID": "1584541"
        }
        4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25365
          +post_id: "1571384"
          +post_author: 1
          +"ListingKey": "29956800"
          +"ListingId": "40843284"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-29T00:40:03Z"
          +"RFModificationTimestamp": "2026-06-29T00:54:06Z"
          +"ListPrice": 875000.0
          +"BathroomsTotalInteger": 3.0
          +"BathroomsHalf": 0
          +"BedroomsTotal": 4.0
          +"LotSizeArea": 0.12
          +"LivingArea": 2776.0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V2J3"
          +"UnparsedAddress": "491 SANDBANKS Crescent, Waterloo, Ontario N2V2J3"
          +"Coordinates": array:2 [
            0 => -80.5768597
            1 => 43.4964463
          ]
          +"Latitude": 43.4964463
          +"Longitude": -80.5768597
          +"YearBuilt": 0
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
          +"PublicRemarks": "IS THIS YOUR NEW HOME? Situated in desirable Conservation Meadows, this 2 Storey home offers a special option for those needing accessible features, including a main floor bedroom and ramp to the front door (2015) and also a ramp off the deck (2016). The stunning acacia engineered hardwood flooring (2019) greets you as you enter this bright and spacious main floor. The updates continue into the kitchen with new white cabinetry, quartz counters, stainless appliances and dimmable pot lights (2022). The sliders to the backyard walk out to the peaceful backyard showcasing lovely perennial gardens, and also features an Arctic Spa Yukon hot tub. Upstairs you will find 3 good-sized bedrooms including a spacious primary bedroom with large walk-in closet, and a long bathroom with potential for splitting it into two (a main bath and an ensuite bath). In the finished basement you will find a newly finished rec room, large utility room / workshop area, laundry room, cold cellar, and a separate den/office/storage room (potential for a 5th bedroom!). Additional updates include roof (2014), air conditioner (2017) washer/dryer (approx 2021), dishwasher (2024). (id:62650)"
          +"AccessibilityFeatures": array:1 [
            0 => "Accessible Approach with Ramp"
          ]
          +"Appliances": array:9 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Water softener"
            3 => "Hot Tub"
            4 => "Central Vacuum"
            5 => "Dishwasher"
            6 => "Stove"
            7 => "Dryer"
            8 => "Garage door opener"
          ]
          +"ArchitecturalStyle": array:1 [
            0 => "Bungalow"
          ]
          +"Basement": array:2 [
            0 => "Finished"
            1 => "Full"
          ]
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-06-26T13:40:39.835887+00:00"
          +"ExteriorFeatures": array:2 [
            0 => "Vinyl siding"
            1 => "Brick Veneer"
          ]
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "1990854"
          +"ListOfficeKey": "289541"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:2 [
            0 => "Paved driveway"
            1 => "Sump Pump"
          ]
          +"LotSizeDimensions": "0.12"
          +"ParkingFeatures": array:1 [
            0 => "Attached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-29T00:21:11Z"
          +"PhotosCount": 42
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-29T00:31:28Z"
          +"Stories": "1.5"
          +"StreetName": "SANDBANKS"
          +"StreetNumber": "491"
          +"StreetSuffix": "Crescent"
          +"SubdivisionName": "441 - Erbsville/Laurelwood"
          +"TaxAnnualAmount": "6158"
          +"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/view/?s=3148434&nohit=1"
          +"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/29956800/491-sandbanks-crescent-waterloo"
          +"ParkingTotal": 3
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"ZoningDescription": "R4"
          +"BedroomsAboveGrade": 4
          +"BedroomsBelowGrade": 0
          +"FrontageLengthNumeric": 42.0
          +"AboveGradeFinishedArea": 2063
          +"BelowGradeFinishedArea": 713
          +"OriginalEntryTimestamp": "2026-06-26T13:01:54.37Z"
          +"FrontageLengthNumericUnits": "feet"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"BelowGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Plans"
          +"BelowGradeFinishedAreaSource": "Plans"
          +"ListAgentNationalAssociationId": "1274526"
          +"ListOfficeNationalAssociationId": "1378680"
          +"Media": array:42 [
            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]
          ]
          +"DaysOnMarket": 7
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29956800')"
          +"ID": "1571384"
        }
        5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25360
          +post_id: "1566184"
          +post_author: 1
          +"ListingKey": "29947549"
          +"ListingId": "40842250"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-28T19:20:11Z"
          +"RFModificationTimestamp": "2026-06-28T19:24:36Z"
          +"ListPrice": 725000.0
          +"BathroomsTotalInteger": 2.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 2.0
          +"LotSizeArea": 0
          +"LivingArea": 2273.0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V2H4"
          +"UnparsedAddress": "658 ELLESMERE Court, Waterloo, Ontario N2V2H4"
          +"Coordinates": array:2 [
            0 => -80.5729223
            1 => 43.4973152
          ]
          +"Latitude": 43.4973152
          +"Longitude": -80.5729223
          +"YearBuilt": 1998
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
          +"PublicRemarks": "Welcome to this beautiful Thomas built Executive FREEHOLD Townhome. The bungalow feature makes it wonderful for anyone thinking of downsizing. Open concept living room and dining. Look through Galley kitchen for wonderful entertaining purposes. Backing onto the trans Canada Trail. Home is located on a wonderful cul-de-sac location in the quiet area of conservation Meadows. Parking for four cars, including a double car garage. All appliances included. Entrance to rear yard and deck off living. (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"
          ]
          +"ArchitecturalStyle": array:1 [
            0 => "Bungalow"
          ]
          +"Basement": array:2 [
            0 => "Partially finished"
            1 => "Full"
          ]
          +"BathroomsPartial": 1
          +"CommunityFeatures": array:1 [
            0 => "Quiet Area"
          ]
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-06-26T01:56:05.034971+00:00"
          +"Directions": "OFF LAKE LOUISE"
          +"ExteriorFeatures": array:2 [
            0 => "Brick"
            1 => "Stone"
          ]
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "1564596"
          +"ListOfficeKey": "76831"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:3 [
            0 => "Cul-de-sac"
            1 => "Conservation/green belt"
            2 => "Automatic Garage Door Opener"
          ]
          +"ParkingFeatures": array:1 [
            0 => "Attached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-27T17:20:06Z"
          +"PhotosCount": 42
          +"PropertyAttachedYN": true
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-28T19:10:47Z"
          +"Stories": "1.0"
          +"StreetName": "ELLESMERE"
          +"StreetNumber": "658"
          +"StreetSuffix": "Court"
          +"SubdivisionName": "441 - Erbsville/Laurelwood"
          +"TaxAnnualAmount": "4497.29"
          +"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/658-Ellesmere-Ct"
          +"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/29947549/658-ellesmere-court-waterloo"
          +"ParkingTotal": 4
          +"StructureType": array:1 [
            0 => "Row / Townhouse"
          ]
          +"CoListAgentKey": "1950017"
          +"CommonInterest": "Freehold"
          +"CoListOfficeKey": "299554"
          +"GeocodeManualYN": true
          +"ZoningDescription": "RB"
          +"BedroomsAboveGrade": 2
          +"BedroomsBelowGrade": 0
          +"FrontageLengthNumeric": 32.0
          +"AboveGradeFinishedArea": 1133
          +"BelowGradeFinishedArea": 1140
          +"OriginalEntryTimestamp": "2026-06-24T17:11:15.95Z"
          +"FrontageLengthNumericUnits": "feet"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"BelowGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Other"
          +"BelowGradeFinishedAreaSource": "Other"
          +"ListAgentNationalAssociationId": "1095797"
          +"ListOfficeNationalAssociationId": "1004391"
          +"CoListAgentNationalAssociationId": "1244287"
          +"CoListOfficeNationalAssociationId": "1473831"
          +"Media": array:42 [
            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]
          ]
          +"DaysOnMarket": 9
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947549')"
          +"ID": "1566184"
        }
        6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
          +post_id: "1565600"
          +post_author: 1
          +"ListingKey": "29947558"
          +"ListingId": "40841264"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-30T16:25:09Z"
          +"RFModificationTimestamp": "2026-06-30T16:30:46Z"
          +"ListPrice": 829900.0
          +"BathroomsTotalInteger": 3.0
          +"BathroomsHalf": 0
          +"BedroomsTotal": 4.0
          +"LotSizeArea": 0
          +"LivingArea": 1841.0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V2Y4"
          +"UnparsedAddress": "419 RIDEAU RIVER Street, Waterloo, Ontario N2V2Y4"
          +"Coordinates": array:2 [
            0 => -80.5885442
            1 => 43.4909309
          ]
          +"Latitude": 43.4909309
          +"Longitude": -80.5885442
          +"YearBuilt": 0
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
          +"PublicRemarks": "Welcome to 419 Rideau River Street, a beautifully maintained 4-bedroom, 3-bathroom home in a sought-after Waterloo neighbourhood. A charming brick exterior, double garage, and covered front porch offer an inviting first impression.Inside, the bright main floor features hardwood flooring, California shutters throughout, and a comfortable open-concept living and dining area. The kitchen offers warm cabinetry, upgraded counters, stainless steel appliances, a centre island with seating, and plenty of workspace. The primary bedroom includes a walk-in closet and private ensuite with a glass shower, while a second bedroom and full bathroom complete the main level.The finished basement adds exceptional living space with a spacious recreation room, gas fireplace, two legal bedrooms, and a full bathroom, ideal for family, guests, or a home office setup.Enjoy a fully fenced backyard with a patio, landscaped gardens, and a gas BBQ line. The included Broil King BBQ is new in 2026. Notable updates include a 50-year shingle roof (2021), water softener (2017), reverse osmosis system with filters changed in 2026, upgraded kitchen counters (2022), Maytag washer (2022), LG dishwasher (2023), Maytag dryer (2025), and KitchenAid 30 electric range (2026).Outdoor lovers will appreciate being just 150 ft from the entrance to Stamm Woodlot and its 3.5 km wooded walking trail. Conveniently located approximately 4.8 km from St. Jacobs Farmers' Market and 5.5 km from Hwy 7/8 via Northfield Drive. (id:62650)"
          +"Appliances": array:1 [
            0 => "Water softener"
          ]
          +"ArchitecturalStyle": array:1 [
            0 => "Bungalow"
          ]
          +"Basement": array:2 [
            0 => "Partially finished"
            1 => "Full"
          ]
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-06-26T01:04:27.455329+00:00"
          +"ExteriorFeatures": array:1 [
            0 => "Brick"
          ]
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "2238484"
          +"ListOfficeKey": "292003"
          +"LivingAreaUnits": "square feet"
          +"ParkingFeatures": array:1 [
            0 => "Attached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-30T15:51:24Z"
          +"PhotosCount": 31
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-30T16:11:50Z"
          +"Stories": "1.0"
          +"StreetName": "RIDEAU RIVER"
          +"StreetNumber": "419"
          +"StreetSuffix": "Street"
          +"SubdivisionName": "441 - Erbsville/Laurelwood"
          +"TaxAnnualAmount": "5740"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:16 [
            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]
          ]
          +"ListAOR": "Cornerstone"
          +"ListAORKey": "14"
          +"ListingURL": "www.realtor.ca/real-estate/29947558/419-rideau-river-street-waterloo"
          +"ParkingTotal": 4
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"ZoningDescription": "R4"
          +"BedroomsAboveGrade": 2
          +"BedroomsBelowGrade": 2
          +"FrontageLengthNumeric": 40.0
          +"AboveGradeFinishedArea": 1042
          +"BelowGradeFinishedArea": 799
          +"OriginalEntryTimestamp": "2026-06-24T17:11:26.5Z"
          +"FrontageLengthNumericUnits": "feet"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"BelowGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Plans"
          +"BelowGradeFinishedAreaSource": "Plans"
          +"ListAgentNationalAssociationId": "1476314"
          +"ListOfficeNationalAssociationId": "1407357"
          +"Media": array:31 [
            0 => array:13 [ …13]
            1 => array:13 [ …13]
            2 => array:13 [ …13]
            3 => array:13 [ …13]
            4 => array:13 [ …13]
            5 => array:13 [ …13]
            6 => array:13 [ …13]
            7 => array:13 [ …13]
            8 => array:13 [ …13]
            9 => array:13 [ …13]
            10 => array:13 [ …13]
            11 => array:13 [ …13]
            12 => array:13 [ …13]
            13 => array:13 [ …13]
            14 => array:13 [ …13]
            15 => array:13 [ …13]
            16 => array:13 [ …13]
            17 => array:13 [ …13]
            18 => array:13 [ …13]
            19 => array:13 [ …13]
            20 => array:13 [ …13]
            21 => array:13 [ …13]
            22 => array:13 [ …13]
            23 => array:13 [ …13]
            24 => array:13 [ …13]
            25 => array:13 [ …13]
            26 => array:13 [ …13]
            27 => array:13 [ …13]
            28 => array:13 [ …13]
            29 => array:13 [ …13]
            30 => array:13 [ …13]
          ]
          +"DaysOnMarket": 9
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947558')"
          +"ID": "1565600"
        }
        7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25391
          +post_id: "1565101"
          +post_author: 1
          +"ListingKey": "29946711"
          +"ListingId": "X13483494"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-29T12:10:07Z"
          +"RFModificationTimestamp": "2026-06-29T12:13:27Z"
          +"ListPrice": 829900.0
          +"BathroomsTotalInteger": 3.0
          +"BathroomsHalf": 0
          +"BedroomsTotal": 4.0
          +"LotSizeArea": 0
          +"LivingArea": 0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V2Y4"
          +"UnparsedAddress": "419 RIDEAU RIVER STREET, Waterloo, Ontario N2V2Y4"
          +"Coordinates": array:2 [
            0 => -80.588549
            1 => 43.49095
          ]
          +"Latitude": 43.49095
          +"Longitude": -80.588549
          +"YearBuilt": 0
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "OnePoint Association of REALTORS®"
          +"PublicRemarks": "Welcome to 419 Rideau River Street, a beautifully maintained 4-bedroom, 3-bathroom home in a sought-after Waterloo neighbourhood. A charming brick exterior, double garage, and covered front porch offer an inviting first impression.Inside, the bright main floor features hardwood flooring, California shutters throughout, and a comfortable open-concept living and dining area. The kitchen offers warm cabinetry, upgraded counters, stainless steel appliances, a centre island with seating, and plenty of workspace. The primary bedroom includes a walk-in closet and private ensuite with a glass shower, while a second bedroom and full bathroom complete the main level.The finished basement adds exceptional living space with a spacious recreation room, gas fireplace, two legal bedrooms, and a full bathroom, ideal for family, guests, or a home office setup.Enjoy a fully fenced backyard with a patio, landscaped gardens, and a gas BBQ line. The included Broil King BBQ is new in 2026. Notable updates include a 50-year shingle roof (2021), water softener (2017), reverse osmosis system with filters changed in 2026, upgraded kitchen counters (2022), Maytag washer (2022), LG dishwasher (2023), Maytag dryer (2025), and KitchenAid 30" electric range (2026).Outdoor lovers will appreciate being just 150 ft from the entrance to Stamm Woodlot and its 3.5 km wooded walking trail. Conveniently located approximately 4.8 km from St. Jacobs Farmers' Market and 5.5 km from Hwy 7/8 via Northfield Drive. (id:62650)"
          +"Appliances": array:1 [
            0 => "Water softener"
          ]
          +"ArchitecturalStyle": array:1 [
            0 => "Bungalow"
          ]
          +"Basement": array:2 [
            0 => "Partially finished"
            1 => "Full"
          ]
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-06-25T20:21:03.319748+00:00"
          +"Directions": "Conservation Dr & Rideau River St"
          +"ExteriorFeatures": array:1 [
            0 => "Brick"
          ]
          +"FireplaceYN": true
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "1962651"
          +"ListOfficeKey": "293196"
          +"LivingAreaUnits": "square feet"
          +"LotSizeDimensions": "40 x 101.7 FT"
          +"ParkingFeatures": array:2 [
            0 => "Attached Garage"
            1 => "Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-24T18:56:17Z"
          +"PhotosCount": 31
          +"Sewer": array:1 [
            0 => "Sanitary sewer"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-29T12:01:32Z"
          +"Stories": "1.0"
          +"StreetName": "Rideau River"
          +"StreetNumber": "419"
          +"StreetSuffix": "Street"
          +"TaxAnnualAmount": "5740"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:16 [
            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]
          ]
          +"ListAOR": "OnePoint"
          +"TaxYear": 2025
          +"ListAORKey": "47"
          +"ListingURL": "www.realtor.ca/real-estate/29946711/419-rideau-river-street-waterloo"
          +"ParkingTotal": 4
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CoListAgentKey": "1834162"
          +"CommonInterest": "Freehold"
          +"CoListAgentKey2": "1899457"
          +"CoListOfficeKey": "293196"
          +"GeocodeManualYN": false
          +"CoListOfficeKey2": "292096"
          +"LivingAreaMaximum": 2000
          +"LivingAreaMinimum": 1500
          +"BedroomsAboveGrade": 4
          +"FrontageLengthNumeric": 40.0
          +"OriginalEntryTimestamp": "2026-06-24T15:34:32.99Z"
          +"FrontageLengthNumericUnits": "feet"
          +"ListAgentNationalAssociationId": "1252137"
          +"ListOfficeNationalAssociationId": "1423680"
          +"CoListAgentNationalAssociationId": "1196633"
          +"CoListAgentNationalAssociationId2": "1216506"
          +"CoListOfficeNationalAssociationId": "1423680"
          +"CoListOfficeNationalAssociationId2": "1408169"
          +"Media": array:31 [
            0 => array:13 [ …13]
            1 => array:13 [ …13]
            2 => array:13 [ …13]
            3 => array:13 [ …13]
            4 => array:13 [ …13]
            5 => array:13 [ …13]
            6 => array:13 [ …13]
            7 => array:13 [ …13]
            8 => array:13 [ …13]
            9 => array:13 [ …13]
            10 => array:13 [ …13]
            11 => array:13 [ …13]
            12 => array:13 [ …13]
            13 => array:13 [ …13]
            14 => array:13 [ …13]
            15 => array:13 [ …13]
            16 => array:13 [ …13]
            17 => array:13 [ …13]
            18 => array:13 [ …13]
            19 => array:13 [ …13]
            20 => array:13 [ …13]
            21 => array:13 [ …13]
            22 => array:13 [ …13]
            23 => array:13 [ …13]
            24 => array:13 [ …13]
            25 => array:13 [ …13]
            26 => array:13 [ …13]
            27 => array:13 [ …13]
            28 => array:13 [ …13]
            29 => array:13 [ …13]
            30 => array:13 [ …13]
          ]
          +"DaysOnMarket": 9
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946711')"
          +"ID": "1565101"
        }
        8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25392
          +post_id: "1562913"
          +post_author: 1
          +"ListingKey": "29951568"
          +"ListingId": "40842931"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-25T16:00:14Z"
          +"RFModificationTimestamp": "2026-06-25T20:04:15Z"
          +"ListPrice": 949900.0
          +"BathroomsTotalInteger": 3.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 3.0
          +"LotSizeArea": 0
          +"LivingArea": 2385.0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V2A4"
          +"UnparsedAddress": "464 NORTHLAKE Drive, Waterloo, Ontario N2V2A4"
          +"Coordinates": array:2 [
            0 => -80.566943
            1 => 43.497345
          ]
          +"Latitude": 43.497345
          +"Longitude": -80.566943
          +"YearBuilt": 1998
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
          +"PublicRemarks": "Welcome to 464 Northlake Drive, Waterloo – nothing to do but move in and enjoy this fully updated home! From the windows to the kitchen, flooring, bathrooms, and more, this 3-bedroom, 3-bathroom home has been extensively updated throughout. Step inside through the welcoming foyer with a convenient coat closet. The renovated kitchen is designed for both style and function, featuring quartz countertops, a beautiful backsplash, ample workspace, and room for a large island. The dining area flows seamlessly into the bright living room with impressive vaulted ceilings, creating an open and airy space ideal for everyday living and entertaining. A fireplace rough-in is already in place, offering the option to add a cozy focal point. From the kitchen, step out to the professionally landscaped, fully fenced backyard complete with a spacious deck, perfect for summer gatherings. New flooring and carpeting throughout provide a fresh, move-in-ready feel. A convenient 2-piece bathroom completes the main floor. Upstairs, the spacious primary bedroom features a walk-in closet with custom California Closets organizers and a beautifully updated 3-piece ensuite. Two additional bedrooms, both with custom closet organizers, and an updated 4-piece bathroom complete the upper level. The finished basement adds valuable living space with a large recreation room ideal for a family room, games area, home gym, or home office. A rough-in for a future 4-piece bathroom offers added potential. Additional updates include attic insulation, doors, furnace, air conditioner, water softener and hot water heater for improved efficiency and peace of mind. Outside, enjoy an aggregate driveway with parking for two vehicles and a double attached garage. Located in a desirable Waterloo neighbourhood close to parks, schools, shopping, and amenities, this home offers modern updates, comfort, and outstanding value. (id:62650)"
          +"Appliances": array:7 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Water softener"
            3 => "Central Vacuum"
            4 => "Dishwasher"
            5 => "Stove"
            6 => "Dryer"
          ]
          +"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-06-25T20:04:02.027755+00:00"
          +"Directions": "Conservation Drive to Northlake"
          +"ExteriorFeatures": array:2 [
            0 => "Brick"
            1 => "Vinyl siding"
          ]
          +"Fencing": array:1 [
            0 => "Fence"
          ]
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "1908292"
          +"ListOfficeKey": "289541"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:2 [
            0 => "Conservation/green belt"
            1 => "Sump Pump"
          ]
          +"ParkingFeatures": array:1 [
            0 => "Attached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-25T15:11:20Z"
          +"PhotosCount": 46
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-25T15:50:44Z"
          +"Stories": "2.0"
          +"StreetName": "NORTHLAKE"
          +"StreetNumber": "464"
          +"StreetSuffix": "Drive"
          +"SubdivisionName": "442 - Lakeshore North"
          +"TaxAnnualAmount": "5729.04"
          +"VirtualTourURLUnbranded": "https://youriguide.com/464_northlake_drive_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/29951568/464-northlake-drive-waterloo"
          +"ParkingTotal": 4
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"SecurityFeatures": array:1 [
            0 => "Smoke Detectors"
          ]
          +"ZoningDescription": "R1"
          +"BedroomsAboveGrade": 3
          +"BedroomsBelowGrade": 0
          +"FrontageLengthNumeric": 60.0
          +"AboveGradeFinishedArea": 1625
          +"BelowGradeFinishedArea": 760
          +"OriginalEntryTimestamp": "2026-06-25T15:11:20.34Z"
          +"FrontageLengthNumericUnits": "feet"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"BelowGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Other"
          +"BelowGradeFinishedAreaSource": "Other"
          +"ListAgentNationalAssociationId": "1221205"
          +"ListOfficeNationalAssociationId": "1378680"
          +"Media": array:46 [
            0 => array:13 [ …13]
            1 => array:13 [ …13]
            2 => array:13 [ …13]
            3 => array:13 [ …13]
            4 => array:13 [ …13]
            5 => array:13 [ …13]
            6 => array:13 [ …13]
            7 => array:13 [ …13]
            8 => array:13 [ …13]
            9 => array:13 [ …13]
            10 => array:13 [ …13]
            11 => array:13 [ …13]
            12 => array:13 [ …13]
            13 => array:13 [ …13]
            14 => array:13 [ …13]
            15 => array:13 [ …13]
            16 => array:13 [ …13]
            17 => array:13 [ …13]
            18 => array:13 [ …13]
            19 => array:13 [ …13]
            20 => array:13 [ …13]
            21 => array:13 [ …13]
            22 => array:13 [ …13]
            23 => array:13 [ …13]
            24 => array:13 [ …13]
            25 => array:13 [ …13]
            26 => array:13 [ …13]
            27 => array:13 [ …13]
            28 => array:13 [ …13]
            29 => array:13 [ …13]
            30 => array:13 [ …13]
            31 => array:13 [ …13]
            32 => array:13 [ …13]
            33 => array:13 [ …13]
            34 => array:13 [ …13]
            35 => array:13 [ …13]
            36 => array:13 [ …13]
            37 => array:13 [ …13]
            38 => array:13 [ …13]
            39 => array:13 [ …13]
            40 => array:13 [ …13]
            41 => array:13 [ …13]
            42 => array:13 [ …13]
            43 => array:13 [ …13]
            44 => array:13 [ …13]
            45 => array:13 [ …13]
          ]
          +"DaysOnMarket": 8
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29951568')"
          +"ID": "1562913"
        }
      ]
      +success: true
      +page_size: 9
      +page_count: 8
      +count: 64
      +after_key: ""
    }
    "RF Response Time" => "0.37 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