Listings - ComFree Realty

Back to Map

$3,500

Ontario,Waterloo

For Rent Active

561 MAYAPPLE STREET, Waterloo, Ontario N2V2E3

4
3
2500 - 3000Square Feet

Contact Seller

Feature Sheet

Basic Details

Description

Most desire Vista Hill detached house with 4 bedrooms and walked up basement. Close to new school, Costco and boradwalk shopping. First foor open concept family, living room and kitchen. 4 bright bedrooms on 2nd floor with master bedroom ensuite. Great choice for family and group students. (id:62783)

Basic Details

Property Type: Residential Lease
Listing Type: For Rent
Listing ID: X13473716
Price: $3,500
Bedrooms: 4
Bathrooms: 3
Half Bathrooms: 1
Square Footage: 2500 - 3000 Sqft
Status: Active
Property Sub Type: Single Family
Office Key: 70066

Features & Appliances

Features

Heating System: Forced air, Natural gas
Cooling System: Central air conditioning, Ventilation system
Basement: N/A, Walk-up, Unfinished
Parking: Garage, Attached Garage
Exterior Features: Brick Facing, Shingles
Sewer: Sanitary sewer

Address Map

Location: CA, Ontario, Waterloo, N2V2E3
Street: Mayapple
Street Number: 561
Street Suffix: Street
Longitude: W81° 24' 4.8''
Latitude: N43° 27' 32.9''

Additional Information

Water Source:
Lot Features:
Lot Size Dimensions: 51 FT
Stories: 2.0

Listing updated: 2026-06-22 15:08:54

Schedule a Tour

List Your Property

MLS On The Fly Debug Panel

 Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25202
  +post_id: "1554338"
  +post_author: 1
  +"ListingKey": "29937081"
  +"ListingId": "40841989"
  +"PropertyType": "Residential Lease"
  +"PropertySubType": "Single Family"
  +"StandardStatus": "Active"
  +"ModificationTimestamp": "2026-06-22T18:00:16Z"
  +"RFModificationTimestamp": "2026-06-22T18:47:39Z"
  +"ListPrice": 0
  +"BathroomsTotalInteger": 4.0
  +"BathroomsHalf": 1
  +"BedroomsTotal": 5.0
  +"LotSizeArea": 0
  +"LivingArea": 4903.0
  +"BuildingAreaTotal": 0
  +"City": "Waterloo"
  +"PostalCode": "N2V2S7"
  +"UnparsedAddress": "872 CREEKSIDE Drive, Waterloo, Ontario N2V2S7"
  +"Coordinates": array:2 [
    0 => -80.5949334
    1 => 43.4749526
  ]
  +"Latitude": 43.4749526
  +"Longitude": -80.5949334
  +"YearBuilt": 2004
  +"InternetAddressDisplayYN": true
  +"FeedTypes": "IDX"
  +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
  +"PublicRemarks": "MOVE-IN READY. Welcome to this stunning custom-built 4+1 beds, 4 baths home in one of Waterloo’s most sought-after communities—Laurelwood. Stunning curb appeal with grand stone exterior wall and concrete driveway, Backing onto a naturally protected forest, this rare property offers exceptional privacy and serene views, with occasionally deer(s) visiting near your backyard. Step inside to discover elegant living and dining spaces that seamlessly flow into a gourmet kitchen featuring a large centre island, dark maple cabinetry, granite countertops (2024), high-end stainless steel appliances and a premium range hood (2024). The main floor is finished with good quality tiles, Canadian maple hardwood flooring, and impressive 9-foot ceilings. The dramatic open-to-above great room is the heart of the home, showcasing soaring ceilings, a stunning custom gas fireplace, and oversized windows overlooking the great views of the backyard. Walk out from the breakfast area to a spacious deck—perfect for entertaining or relaxing in nature. The main floor also offers an office, a 2pc powder room and a laundry room. Upstairs, the expansive primary suite offers a walk-in closet and a luxurious 5-piece en-suite with a glass shower and separate tub. Three additional generously sized bedrooms and a well-appointed main bath with double sinks complete the upper level. The fully finished walkout basement adds incredible versatility, featuring a large rec room with a second gas fireplace, a fifth bedroom, a 4th bathroom, and rare direct access to the garage. Recent Updates Include: Newer painted walls and kitchen cabinets (2025). Newer light fixtures (2025). Upgraded upper-level shower fixtures. Granite countertops (2024). Fridge (2025) & A/C (2024). Roof (2019). Owned Hot Water Heater. Located just steps from top-ranked schools, shopping, transit, parks, trails. A short drive to the YMCA, Costco, and both universities—this home offers the perfect blend of luxury, comfort, and convenience. (id:62650)"
  +"Appliances": array:6 [
    0 => "Washer"
    1 => "Refrigerator"
    2 => "Water softener"
    3 => "Dishwasher"
    4 => "Stove"
    5 => "Dryer"
  ]
  +"AssociationFeeIncludes": array:1 [
    0 => "Insurance"
  ]
  +"Basement": array:2 [
    0 => "Finished"
    1 => "Full"
  ]
  +"BathroomsPartial": 1
  +"CommunityFeatures": array:2 [
    0 => "Quiet Area"
    1 => "School Bus"
  ]
  +"Cooling": array:1 [
    0 => "Central air conditioning"
  ]
  +"CreationDate": "2026-06-22T18:47:27.835837+00:00"
  +"Directions": "Laurelwood Dr. to Creekside Dr."
  +"ExteriorFeatures": array:3 [
    0 => "Brick"
    1 => "Stone"
    2 => "Vinyl siding"
  ]
  +"FireplaceYN": true
  +"FireplacesTotal": "2"
  +"FoundationDetails": array:1 [
    0 => "Poured Concrete"
  ]
  +"Heating": array:2 [
    0 => "Forced air"
    1 => "Natural gas"
  ]
  +"InternetEntireListingDisplayYN": true
  +"ListAgentKey": "1970409"
  +"ListOfficeKey": "295659"
  +"LivingAreaUnits": "square feet"
  +"LotFeatures": array:1 [
    0 => "Sump Pump"
  ]
  +"ParkingFeatures": array:1 [
    0 => "Attached Garage"
  ]
  +"PhotosChangeTimestamp": "2026-06-22T17:52:49Z"
  +"PhotosCount": 50
  +"Sewer": array:1 [
    0 => "Municipal sewage system"
  ]
  +"StateOrProvince": "Ontario"
  +"StatusChangeTimestamp": "2026-06-22T17:52:49Z"
  +"Stories": "2.0"
  +"StreetName": "CREEKSIDE"
  +"StreetNumber": "872"
  +"StreetSuffix": "Drive"
  +"SubdivisionName": "441 - Erbsville/Laurelwood"
  +"TaxAnnualAmount": "9946"
  +"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/872-Creekside-Dr"
  +"WaterSource": array:1 [
    0 => "Municipal water"
  ]
  +"Rooms": array:17 [
    0 => array:11 [
      "RoomKey" => "1665501394"
      "RoomType" => "Utility room"
      "ListingId" => "40841989"
      "RoomLevel" => "Basement"
      "RoomWidth" => null
      "ListingKey" => "29937081"
      "RoomLength" => null
      "RoomDimensions" => "11'9'' x 14'1''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T17:51:25.98Z"
    ]
    1 => array:11 [
      "RoomKey" => "1665501395"
      "RoomType" => "Recreation room"
      "ListingId" => "40841989"
      "RoomLevel" => "Basement"
      "RoomWidth" => null
      "ListingKey" => "29937081"
      "RoomLength" => null
      "RoomDimensions" => "21'0'' x 36'8''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T17:51:25.98Z"
    ]
    2 => array:11 [
      "RoomKey" => "1665501396"
      "RoomType" => "Bedroom"
      "ListingId" => "40841989"
      "RoomLevel" => "Basement"
      "RoomWidth" => null
      "ListingKey" => "29937081"
      "RoomLength" => null
      "RoomDimensions" => "11'8'' x 13'3''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T17:51:25.99Z"
    ]
    3 => array:11 [
      "RoomKey" => "1665501397"
      "RoomType" => "3pc Bathroom"
      "ListingId" => "40841989"
      "RoomLevel" => "Basement"
      "RoomWidth" => null
      "ListingKey" => "29937081"
      "RoomLength" => null
      "RoomDimensions" => "8'7'' x 9'0''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T17:51:25.99Z"
    ]
    4 => array:11 [
      "RoomKey" => "1665501398"
      "RoomType" => "Bedroom"
      "ListingId" => "40841989"
      "RoomLevel" => "Second level"
      "RoomWidth" => null
      "ListingKey" => "29937081"
      "RoomLength" => null
      "RoomDimensions" => "14'7'' x 20'1''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T17:51:25.99Z"
    ]
    5 => array:11 [
      "RoomKey" => "1665501399"
      "RoomType" => "Bedroom"
      "ListingId" => "40841989"
      "RoomLevel" => "Second level"
      "RoomWidth" => null
      "ListingKey" => "29937081"
      "RoomLength" => null
      "RoomDimensions" => "11'8'' x 19'11''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T17:51:25.99Z"
    ]
    6 => array:11 [
      "RoomKey" => "1665501400"
      "RoomType" => "Bedroom"
      "ListingId" => "40841989"
      "RoomLevel" => "Second level"
      "RoomWidth" => null
      "ListingKey" => "29937081"
      "RoomLength" => null
      "RoomDimensions" => "11'1'' x 14'8''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T17:51:25.99Z"
    ]
    7 => array:11 [
      "RoomKey" => "1665501401"
      "RoomType" => "Primary Bedroom"
      "ListingId" => "40841989"
      "RoomLevel" => "Second level"
      "RoomWidth" => null
      "ListingKey" => "29937081"
      "RoomLength" => null
      "RoomDimensions" => "13'0'' x 17'0''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T17:51:25.99Z"
    ]
    8 => array:11 [
      "RoomKey" => "1665501402"
      "RoomType" => "Full bathroom"
      "ListingId" => "40841989"
      "RoomLevel" => "Second level"
      "RoomWidth" => null
      "ListingKey" => "29937081"
      "RoomLength" => null
      "RoomDimensions" => "11'3'' x 11'7''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T17:51:25.99Z"
    ]
    9 => array:11 [
      "RoomKey" => "1665501403"
      "RoomType" => "4pc Bathroom"
      "ListingId" => "40841989"
      "RoomLevel" => "Second level"
      "RoomWidth" => null
      "ListingKey" => "29937081"
      "RoomLength" => null
      "RoomDimensions" => "6'0'' x 11'7''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T17:51:25.99Z"
    ]
    10 => array:11 [
      "RoomKey" => "1665501404"
      "RoomType" => "Office"
      "ListingId" => "40841989"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29937081"
      "RoomLength" => null
      "RoomDimensions" => "10'0'' x 10'5''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T17:51:25.99Z"
    ]
    11 => array:11 [
      "RoomKey" => "1665501405"
      "RoomType" => "Great room"
      "ListingId" => "40841989"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29937081"
      "RoomLength" => null
      "RoomDimensions" => "15'6'' x 17'7''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T17:51:26Z"
    ]
    12 => array:11 [
      "RoomKey" => "1665501406"
      "RoomType" => "Laundry room"
      "ListingId" => "40841989"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29937081"
      "RoomLength" => null
      "RoomDimensions" => "7'0'' x 10'5''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T17:51:26Z"
    ]
    13 => array:11 [
      "RoomKey" => "1665501407"
      "RoomType" => "Eat in kitchen"
      "ListingId" => "40841989"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29937081"
      "RoomLength" => null
      "RoomDimensions" => "12'10'' x 21'10''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T17:51:26Z"
    ]
    14 => array:11 [
      "RoomKey" => "1665501408"
      "RoomType" => "Foyer"
      "ListingId" => "40841989"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29937081"
      "RoomLength" => null
      "RoomDimensions" => "6'0'' x 8'2''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T17:51:26Z"
    ]
    15 => array:11 [
      "RoomKey" => "1665501409"
      "RoomType" => "Living room/Dining room"
      "ListingId" => "40841989"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29937081"
      "RoomLength" => null
      "RoomDimensions" => "11'3'' x 29'8''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T17:51:26Z"
    ]
    16 => array:11 [
      "RoomKey" => "1665501410"
      "RoomType" => "2pc Bathroom"
      "ListingId" => "40841989"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29937081"
      "RoomLength" => null
      "RoomDimensions" => "6'6'' x 4'11''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T17:51:26Z"
    ]
  ]
  +"ListAOR": "Cornerstone"
  +"ListAORKey": "14"
  +"ListingURL": "www.realtor.ca/real-estate/29937081/872-creekside-drive-waterloo"
  +"ParkingTotal": 4
  +"StructureType": array:1 [
    0 => "House"
  ]
  +"CommonInterest": "Freehold"
  +"GeocodeManualYN": true
  +"TotalActualRent": 5000
  +"ZoningDescription": "R4"
  +"BedroomsAboveGrade": 4
  +"BedroomsBelowGrade": 1
  +"LeaseAmountFrequency": "Monthly"
  +"FrontageLengthNumeric": 51.0
  +"AboveGradeFinishedArea": 3430
  +"BelowGradeFinishedArea": 1473
  +"OriginalEntryTimestamp": "2026-06-22T17:51:25.95Z"
  +"FrontageLengthNumericUnits": "feet"
  +"AboveGradeFinishedAreaUnits": "square feet"
  +"BelowGradeFinishedAreaUnits": "square feet"
  +"AboveGradeFinishedAreaSource": "Other"
  +"BelowGradeFinishedAreaSource": "Other"
  +"ListAgentNationalAssociationId": "1257707"
  +"ListOfficeNationalAssociationId": "1452740"
  +"Media": array:50 [
    0 => array:13 [
      "Order" => 1
      "MediaKey" => "29937081_4890_1"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/95b00513d6c45ef1bfc02c8e0f419189.webp"
      "MediaSize" => 193892
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-95b00513d6c45ef1bfc02c8e0f419189.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Image quality insufficient for description"
      "PreferredPhotoYN" => true
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:44.15Z"
    ]
    1 => array:13 [
      "Order" => 2
      "MediaKey" => "29937081_4890_2"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/e1dcb5d04394c3158e72198280922d42.webp"
      "MediaSize" => 75039
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-e1dcb5d04394c3158e72198280922d42.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Vaulted ceiling great room featuring a wood-finish floor and a fireplace with a wood mantle"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:44.15Z"
    ]
    2 => array:13 [
      "Order" => 3
      "MediaKey" => "29937081_4890_3"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/54856a8e7bb8be0dc06c115d4e358541.webp"
      "MediaSize" => 123808
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-54856a8e7bb8be0dc06c115d4e358541.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Stone veneer exterior featuring multiple gables and a double garage"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:43.96Z"
    ]
    3 => array:13 [
      "Order" => 4
      "MediaKey" => "29937081_4890_4"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/8f422a8e937bc27555364b9efb174153.webp"
      "MediaSize" => 132953
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-8f422a8e937bc27555364b9efb174153.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Two-story residence featuring a stone facade and beige siding accents"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:44.16Z"
    ]
    4 => array:13 [
      "Order" => 5
      "MediaKey" => "29937081_4890_5"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/16d461adbf56303e2ab8c94ae54cff99.webp"
      "MediaSize" => 123607
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-16d461adbf56303e2ab8c94ae54cff99.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Stone-clad exterior featuring a two-car garage with overhead lighting"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:44.15Z"
    ]
    5 => array:13 [
      "Order" => 6
      "MediaKey" => "29937081_4890_6"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/d41ef5f85fb58e3521ef3a220e4c8c3e.webp"
      "MediaSize" => 76037
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-d41ef5f85fb58e3521ef3a220e4c8c3e.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Foyer featuring tile flooring, a dark-paneled door with decorative glass, and a traditional ceiling light fixture"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:43.91Z"
    ]
    6 => array:13 [
      "Order" => 7
      "MediaKey" => "29937081_4890_7"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/d855f4efc1d88491e1ec8d95d98a38dd.webp"
      "MediaSize" => 76649
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-d855f4efc1d88491e1ec8d95d98a38dd.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Foyer featuring tiled flooring, a natural wood staircase, and an arched window"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:46.4Z"
    ]
    7 => array:13 [
      "Order" => 8
      "MediaKey" => "29937081_4890_8"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/1c9d1de7eaa27f12695ad7b7594cabf2.webp"
      "MediaSize" => 88783
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-1c9d1de7eaa27f12695ad7b7594cabf2.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Spacious living area featuring light wood-finish flooring, a prominent bay window, crown molding, and neutral wall tones"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:43.43Z"
    ]
    8 => array:13 [
      "Order" => 9
      "MediaKey" => "29937081_4890_9"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/1e3dd2b889a2d9a3717525649eb46be1.webp"
      "MediaSize" => 74509
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-1e3dd2b889a2d9a3717525649eb46be1.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Bright interior space featuring light wood-finish flooring, neutral wall tones, white crown molding, and white baseboards"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:45.11Z"
    ]
    9 => array:13 [
      "Order" => 10
      "MediaKey" => "29937081_4890_10"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/784d253e5d0ee3b890dd7f43afa9959c.webp"
      "MediaSize" => 80566
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-784d253e5d0ee3b890dd7f43afa9959c.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Dining area featuring wood-finish flooring, crown molding, and a chandelier"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:44.17Z"
    ]
    10 => array:13 [
      "Order" => 11
      "MediaKey" => "29937081_4890_11"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/54501529b9ec38b97f49bd28ceaa5432.webp"
      "MediaSize" => 91832
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-54501529b9ec38b97f49bd28ceaa5432.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Spacious interior room featuring light wood-finish flooring, a bay window, and a chandelier light fixture"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:43.91Z"
    ]
    11 => array:13 [
      "Order" => 12
      "MediaKey" => "29937081_4890_12"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/66121205e5eadb284de859d3f8ea104b.webp"
      "MediaSize" => 83015
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-66121205e5eadb284de859d3f8ea104b.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Vaulted ceilings featuring a chandelier, hardwood flooring, and a fireplace with a stone surround"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:43.43Z"
    ]
    12 => array:13 [
      "Order" => 13
      "MediaKey" => "29937081_4890_13"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/f68180dd3f6a2835bf234bbef297bab1.webp"
      "MediaSize" => 87554
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-f68180dd3f6a2835bf234bbef297bab1.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Vaulted ceiling living space featuring large arched and rectangular windows, wood-finish flooring, a fireplace with a dark mantel, and an open concept kitchen with dark cabinetry and a central island"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:43.67Z"
    ]
    13 => array:13 [
      "Order" => 14
      "MediaKey" => "29937081_4890_14"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/b8a9029e1eda82df24e73c56f598fc00.webp"
      "MediaSize" => 77494
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-b8a9029e1eda82df24e73c56f598fc00.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Great room with soaring ceilings and wood-finish flooring extending into the kitchen"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:45.15Z"
    ]
    14 => array:13 [
      "Order" => 15
      "MediaKey" => "29937081_4890_15"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/260c821f72f5898b28700a1a2168919a.webp"
      "MediaSize" => 85405
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-260c821f72f5898b28700a1a2168919a.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Spacious kitchen featuring a large central island with a light-toned countertop, extensive dark wood cabinetry, and stainless steel appliances"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:44.15Z"
    ]
    15 => array:13 [
      "Order" => 16
      "MediaKey" => "29937081_4890_16"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/4be53d22572975e570ad264afeb30ac0.webp"
      "MediaSize" => 87382
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-4be53d22572975e570ad264afeb30ac0.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Gourmet kitchen featuring extensive dark wood-finish cabinetry, granite countertops, a central island with integrated cooktop, stainless steel appliances, and tile flooring"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:45.13Z"
    ]
    16 => array:13 [
      "Order" => 17
      "MediaKey" => "29937081_4890_17"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/ad0c390b8db5665509b5a7ddb94f4951.webp"
      "MediaSize" => 98602
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-ad0c390b8db5665509b5a7ddb94f4951.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Kitchen featuring dark wood-finish cabinetry, light-toned tiled flooring, and an L-shaped countertop"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:46.41Z"
    ]
    17 => array:13 [
      "Order" => 18
      "MediaKey" => "29937081_4890_18"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/2ad2b2f4525bb631679c37fa67de08d6.webp"
      "MediaSize" => 99146
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-2ad2b2f4525bb631679c37fa67de08d6.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Kitchen featuring dark wood-finish cabinetry, light-toned tile flooring, and integrated stainless steel appliances"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:44.15Z"
    ]
    18 => array:13 [
      "Order" => 19
      "MediaKey" => "29937081_4890_19"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/ae61ddb0514f1f0c5123abf44094d5ed.webp"
      "MediaSize" => 90558
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-ae61ddb0514f1f0c5123abf44094d5ed.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Kitchen island with dark wood cabinetry and a polished stone countertop featuring pendant lighting"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:45.16Z"
    ]
    19 => array:13 [
      "Order" => 20
      "MediaKey" => "29937081_4890_20"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/b17a8adafa09d595bafaa63c8fd0320c.webp"
      "MediaSize" => 99367
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-b17a8adafa09d595bafaa63c8fd0320c.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Kitchen featuring dark wood cabinetry, a granite-topped island with seating, a tile backsplash, and stainless steel appliances"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:45.14Z"
    ]
    20 => array:13 [
      "Order" => 21
      "MediaKey" => "29937081_4890_21"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/0533f6451d96d2a4b410c6db4b388931.webp"
      "MediaSize" => 85483
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-0533f6451d96d2a4b410c6db4b388931.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Open-concept dining area featuring tiled flooring"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:46.41Z"
    ]
    21 => array:13 [
      "Order" => 22
      "MediaKey" => "29937081_4890_22"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/79e622a0c50d66e7295f26c4d97c60a5.webp"
      "MediaSize" => 64143
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-79e622a0c50d66e7295f26c4d97c60a5.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Powder room featuring a dark wood vanity with an integral sink, a dark stone countertop, and a decorative framed mirror"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:45.16Z"
    ]
    22 => array:13 [
      "Order" => 23
      "MediaKey" => "29937081_4890_23"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/ae523e50bc8ef3c35fbe6a189a69f1f3.webp"
      "MediaSize" => 66771
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-ae523e50bc8ef3c35fbe6a189a69f1f3.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Room featuring light wood-finish flooring and neutral wall tones"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:44.15Z"
    ]
    23 => array:13 [
      "Order" => 24
      "MediaKey" => "29937081_4890_24"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/17386c0dcb949c109341dec2bfa1aca8.webp"
      "MediaSize" => 78005
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-17386c0dcb949c109341dec2bfa1aca8.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Entryway featuring tile flooring, a natural wood staircase with balusters, a laundry area with a washing machine, and a built-in storage closet"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:45.12Z"
    ]
    24 => array:13 [
      "Order" => 25
      "MediaKey" => "29937081_4890_25"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/318de1de8b59fb10f00f0a5cc945db5f.webp"
      "MediaSize" => 69714
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-318de1de8b59fb10f00f0a5cc945db5f.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Upper-level landing featuring wood-finish flooring, light-toned walls, a chandelier fixture, and natural wood railings"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:45.13Z"
    ]
    25 => array:13 [
      "Order" => 26
      "MediaKey" => "29937081_4890_26"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/ab6f7af2bc6a6332371c699bd7d9804a.webp"
      "MediaSize" => 92286
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-ab6f7af2bc6a6332371c699bd7d9804a.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Spacious room featuring hardwood flooring, multiple windows with blinds, crown molding, and a flush mount ceiling light"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:45.96Z"
    ]
    26 => array:13 [
      "Order" => 27
      "MediaKey" => "29937081_4890_27"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/a29f4ec2c5a5b26e2f430f102b79f395.webp"
      "MediaSize" => 54828
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-a29f4ec2c5a5b26e2f430f102b79f395.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Bedroom featuring light wood flooring and neutral wall tones"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:45.15Z"
    ]
    27 => array:13 [
      "Order" => 28
      "MediaKey" => "29937081_4890_28"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/d60045f9d567d4594bbc10136d6e2e15.webp"
      "MediaSize" => 83556
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-d60045f9d567d4594bbc10136d6e2e15.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Modern bathroom featuring a freestanding soaking tub, a frameless glass shower enclosure, a stone accent wall, a vanity with a vessel sink and stone countertop, and large format tile flooring"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:45.14Z"
    ]
    28 => array:13 [
      "Order" => 29
      "MediaKey" => "29937081_4890_29"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/8e45fb93763cfaee3cf29460478a75d3.webp"
      "MediaSize" => 88192
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-8e45fb93763cfaee3cf29460478a75d3.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Freestanding soaking tub with a floor-mounted faucet, complemented by a stone accent wall"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:46.28Z"
    ]
    29 => array:13 [
      "Order" => 30
      "MediaKey" => "29937081_4890_30"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/14042e39bac8648be7a5a58eb6b78421.webp"
      "MediaSize" => 76496
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-14042e39bac8648be7a5a58eb6b78421.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Vaulted ceiling bedroom featuring light wood-finish flooring, a large arched window with horizontal blinds, and neutral wall tones"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:44.14Z"
    ]
    30 => array:13 [
      "Order" => 31
      "MediaKey" => "29937081_4890_31"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/bf365703f02bb9794aabaa1e56d4c32e.webp"
      "MediaSize" => 79912
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-bf365703f02bb9794aabaa1e56d4c32e.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Contemporary bathroom featuring a double vanity with vessel sinks, mirrored cabinets, and decorative wall sconces"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:49.38Z"
    ]
    31 => array:13 [
      "Order" => 32
      "MediaKey" => "29937081_4890_32"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/14bda44fcc895abe8013c6506e6a5560.webp"
      "MediaSize" => 76039
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-14bda44fcc895abe8013c6506e6a5560.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Bright interior featuring wood-finish flooring, neutral wall tones, and a large arched window"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:45.42Z"
    ]
    32 => array:13 [
      "Order" => 33
      "MediaKey" => "29937081_4890_33"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/50366e47f78996fac111449a8816df69.webp"
      "MediaSize" => 52683
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-50366e47f78996fac111449a8816df69.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Spacious room featuring wood-finish flooring, light neutral wall paint, and a white ceiling"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:45.41Z"
    ]
    33 => array:13 [
      "Order" => 34
      "MediaKey" => "29937081_4890_34"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/fc7cf2773b6bbe745bad392688634dfd.webp"
      "MediaSize" => 65231
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-fc7cf2773b6bbe745bad392688634dfd.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Bedroom with light wood-finish flooring and neutral-toned walls"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:43.43Z"
    ]
    34 => array:13 [
      "Order" => 35
      "MediaKey" => "29937081_4890_35"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/be8cf4ce1bcf267cce41543b3cba1f5f.webp"
      "MediaSize" => 76442
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-be8cf4ce1bcf267cce41543b3cba1f5f.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Living space featuring light-toned carpeting and neutral wall colors"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:45.16Z"
    ]
    35 => array:13 [
      "Order" => 36
      "MediaKey" => "29937081_4890_36"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/28bd11b2f4808ba5f93b0ad144c0fc9d.webp"
      "MediaSize" => 59275
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-28bd11b2f4808ba5f93b0ad144c0fc9d.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Spacious lower-level area with recessed lighting, light-toned carpeting, neutral wall paint, and a wood-finish fireplace mantel"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:46.4Z"
    ]
    36 => array:13 [
      "Order" => 37
      "MediaKey" => "29937081_4890_37"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/890591e400a3e499897b6ef3d4d52763.webp"
      "MediaSize" => 73850
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-890591e400a3e499897b6ef3d4d52763.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Spacious lower-level area featuring recessed lighting, light-toned carpeting, and a neutral wall palette"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:45.96Z"
    ]
    37 => array:13 [
      "Order" => 38
      "MediaKey" => "29937081_4890_38"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/e63c9a194580b772d6e4e0d45858dfe7.webp"
      "MediaSize" => 57854
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-e63c9a194580b772d6e4e0d45858dfe7.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Expansive carpeted room featuring recessed lighting and neutral wall tones"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:44.15Z"
    ]
    38 => array:13 [
      "Order" => 39
      "MediaKey" => "29937081_4890_39"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/d536fae6f2e2613259ec5e277df63f21.webp"
      "MediaSize" => 68428
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-d536fae6f2e2613259ec5e277df63f21.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Spacious finished lower level featuring recessed lighting, light-toned carpeting, a built-in fireplace with a wood mantle, and an open layout"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:45.19Z"
    ]
    39 => array:13 [
      "Order" => 40
      "MediaKey" => "29937081_4890_40"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/2588393146248884689c191591be2dd7.webp"
      "MediaSize" => 79895
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-2588393146248884689c191591be2dd7.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Bedroom featuring neutral tone walls, white trim, recessed lighting, and a horizontal casement window"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:45.14Z"
    ]
    40 => array:13 [
      "Order" => 41
      "MediaKey" => "29937081_4890_41"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/f39f468a9015b4d8fc1e8bc970a8fd90.webp"
      "MediaSize" => 56357
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-f39f468a9015b4d8fc1e8bc970a8fd90.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Bathroom with a corner shower enclosure, white toilet, and a vanity featuring a dark countertop and wood-finish cabinetry"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:45.11Z"
    ]
    41 => array:13 [
      "Order" => 42
      "MediaKey" => "29937081_4890_42"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/aaf5a028a8cc48b9a8498c332de40865.webp"
      "MediaSize" => 57292
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-aaf5a028a8cc48b9a8498c332de40865.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Bathroom featuring a light wood-finish vanity with a dark countertop, an integrated sink, and a four-light fixture above a large mirror"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:45.14Z"
    ]
    42 => array:13 [
      "Order" => 43
      "MediaKey" => "29937081_4890_43"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/d9d77b4640d2faf2cbb674a2c2ea9748.webp"
      "MediaSize" => 138221
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-d9d77b4640d2faf2cbb674a2c2ea9748.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Spacious outdoor deck featuring wood flooring and a wooden railing"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:45.15Z"
    ]
    43 => array:13 [
      "Order" => 44
      "MediaKey" => "29937081_4890_44"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/63d566d03756ef6868cf1dd5b3be036e.webp"
      "MediaSize" => 184481
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-63d566d03756ef6868cf1dd5b3be036e.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Expansive rear yard featuring a multi-level structure with a brick lower level and siding upper levels"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:46.28Z"
    ]
    44 => array:13 [
      "Order" => 45
      "MediaKey" => "29937081_4890_45"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/e2557e47ec8b16b790ae19fd7770af33.webp"
      "MediaSize" => 180560
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-e2557e47ec8b16b790ae19fd7770af33.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Rear exterior featuring a two-story brick and siding construction with an expansive deck and staircase"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:44.16Z"
    ]
    45 => array:13 [
      "Order" => 46
      "MediaKey" => "29937081_4890_46"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/2c59f0785b15d48f0832220e383b1896.webp"
      "MediaSize" => 139811
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-2c59f0785b15d48f0832220e383b1896.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Rear elevation featuring a multi-level wood deck with stairs to the lawn"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:43.91Z"
    ]
    46 => array:13 [
      "Order" => 47
      "MediaKey" => "29937081_4890_47"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/2b1c2c157734e34abf5b1797864587cc.webp"
      "MediaSize" => 181691
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-2b1c2c157734e34abf5b1797864587cc.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Image quality insufficient for description"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:44.15Z"
    ]
    47 => array:13 [
      "Order" => 48
      "MediaKey" => "29937081_4890_48"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/9c12d562d74c98d47bfb21ba64fdab1c.webp"
      "MediaSize" => 179309
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-9c12d562d74c98d47bfb21ba64fdab1c.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Aerial perspective showcasing a residential neighborhood with ample green space"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:44.15Z"
    ]
    48 => array:13 [
      "Order" => 49
      "MediaKey" => "29937081_4890_49"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/6f275957a9c70d19c4aecfebdc954620.webp"
      "MediaSize" => 202199
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-6f275957a9c70d19c4aecfebdc954620.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Aerial perspective showcasing a residential community surrounded by lush green trees and natural water features"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:45.96Z"
    ]
    49 => array:13 [
      "Order" => 50
      "MediaKey" => "29937081_4890_50"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/d15d4f5c2843f9f87e023a5331fb65ee.webp"
      "MediaSize" => 173608
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-d15d4f5c2843f9f87e023a5331fb65ee.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => "Aerial perspective showcasing a property surrounded by mature trees"
      "PreferredPhotoYN" => false
      "ResourceRecordId" => "40841989"
      "ResourceRecordKey" => "29937081"
      "ModificationTimestamp" => "2026-06-22T17:52:44.15Z"
    ]
  ]
  +"DaysOnMarket": 0
  +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29937081')"
  +"ID": "1554338"
}

MLS On The Fly Debug Panel

 array:6 [
  "RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29936185 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409
      +items: array:1 [
        0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411
          +post_id: "1553587"
          +post_author: 1
          +"ListingKey": "29936185"
          +"ListingId": "X13473716"
          +"PropertyType": "Residential Lease"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-22T16:05:10Z"
          +"RFModificationTimestamp": "2026-06-22T17:20:20Z"
          +"ListPrice": 0
          +"BathroomsTotalInteger": 3.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 4.0
          +"LotSizeArea": 0
          +"LivingArea": 0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V2E3"
          +"UnparsedAddress": "561 MAYAPPLE STREET, Waterloo, Ontario N2V2E3"
          +"Coordinates": array:2 [
            0 => -80.598661
            1 => 43.459135
          ]
          +"Latitude": 43.459135
          +"Longitude": -80.598661
          +"YearBuilt": 0
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Toronto Regional Real Estate Board"
          +"PublicRemarks": "Most desire Vista Hill detached house with 4 bedrooms and walked up basement. Close to new school, Costco and boradwalk shopping. First foor open concept family, living room and kitchen. 4 bright bedrooms on 2nd floor with master bedroom ensuite. Great choice for family and group students. (id:62783)"
          +"Appliances": array:1 [
            0 => "Water Heater"
          ]
          +"Basement": array:4 [
            0 => "Unfinished"
            1 => "Walk-up"
            2 => "N/A"
            3 => "N/A"
          ]
          +"BathroomsPartial": 1
          +"Cooling": array:2 [
            0 => "Central air conditioning"
            1 => "Ventilation system"
          ]
          +"CreationDate": "2026-06-22T17:20:11.472435+00:00"
          +"Directions": "Cross Streets: Sundrew And Mayapple Street. ** Directions: South."
          +"ExteriorFeatures": array:2 [
            0 => "Brick Facing"
            1 => "Shingles"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "1945012"
          +"ListOfficeKey": "70066"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:1 [
            0 => "Sump Pump"
          ]
          +"LotSizeDimensions": "51 FT"
          +"ParkingFeatures": array:2 [
            0 => "Attached Garage"
            1 => "Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-22T15:55:57Z"
          +"PhotosCount": 11
          +"Sewer": array:1 [
            0 => "Sanitary sewer"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-22T15:55:57Z"
          +"Stories": "2.0"
          +"StreetName": "Mayapple"
          +"StreetNumber": "561"
          +"StreetSuffix": "Street"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:6 [
            0 => array:11 [
              "RoomKey" => "1665421341"
              "RoomType" => "Living room"
              "ListingId" => "X13473716"
              "RoomLevel" => "Main level"
              "RoomWidth" => 8.68
              "ListingKey" => "29936185"
              "RoomLength" => 4.67
              "RoomDimensions" => null
              "RoomDescription" => null
              "RoomLengthWidthUnits" => "meters"
              "ModificationTimestamp" => "2026-06-22T15:55:57.25Z"
            ]
            1 => array:11 [
              "RoomKey" => "1665421342"
              "RoomType" => "Family room"
              "ListingId" => "X13473716"
              "RoomLevel" => "Main level"
              "RoomWidth" => 4.86
              "ListingKey" => "29936185"
              "RoomLength" => 4.86
              "RoomDimensions" => null
              "RoomDescription" => null
              "RoomLengthWidthUnits" => "meters"
              "ModificationTimestamp" => "2026-06-22T15:55:57.25Z"
            ]
            2 => array:11 [
              "RoomKey" => "1665421343"
              "RoomType" => "Primary Bedroom"
              "ListingId" => "X13473716"
              "RoomLevel" => "Second level"
              "RoomWidth" => 4.6
              "ListingKey" => "29936185"
              "RoomLength" => 4.37
              "RoomDimensions" => null
              "RoomDescription" => null
              "RoomLengthWidthUnits" => "meters"
              "ModificationTimestamp" => "2026-06-22T15:55:57.25Z"
            ]
            3 => array:11 [
              "RoomKey" => "1665421344"
              "RoomType" => "Bedroom 2"
              "ListingId" => "X13473716"
              "RoomLevel" => "Second level"
              "RoomWidth" => 4.8
              "ListingKey" => "29936185"
              "RoomLength" => 3.5
              "RoomDimensions" => null
              "RoomDescription" => null
              "RoomLengthWidthUnits" => "meters"
              "ModificationTimestamp" => "2026-06-22T15:55:57.26Z"
            ]
            4 => array:11 [
              "RoomKey" => "1665421345"
              "RoomType" => "Bedroom 3"
              "ListingId" => "X13473716"
              "RoomLevel" => "Second level"
              "RoomWidth" => 4.85
              "ListingKey" => "29936185"
              "RoomLength" => 3.6
              "RoomDimensions" => null
              "RoomDescription" => null
              "RoomLengthWidthUnits" => "meters"
              "ModificationTimestamp" => "2026-06-22T15:55:57.26Z"
            ]
            5 => array:11 [
              "RoomKey" => "1665421346"
              "RoomType" => "Bedroom 4"
              "ListingId" => "X13473716"
              "RoomLevel" => "Second level"
              "RoomWidth" => 3.45
              "ListingKey" => "29936185"
              "RoomLength" => 2.7
              "RoomDimensions" => null
              "RoomDescription" => null
              "RoomLengthWidthUnits" => "meters"
              "ModificationTimestamp" => "2026-06-22T15:55:57.26Z"
            ]
          ]
          +"ListAOR": "Toronto"
          +"ListAORKey": "82"
          +"ListingURL": "www.realtor.ca/real-estate/29936185/561-mayapple-street-waterloo"
          +"ParkingTotal": 4
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": false
          +"TotalActualRent": 3500
          +"LivingAreaMaximum": 3000
          +"LivingAreaMinimum": 2500
          +"BedroomsAboveGrade": 4
          +"LeaseAmountFrequency": "Monthly"
          +"FrontageLengthNumeric": 51.0
          +"OriginalEntryTimestamp": "2026-06-22T15:55:57.23Z"
          +"FrontageLengthNumericUnits": "feet"
          +"ListAgentNationalAssociationId": "1240556"
          +"ListOfficeNationalAssociationId": "1132867"
          +"Media": array:11 [
            0 => array:13 [
              "Order" => 1
              "MediaKey" => "29936185_4890_1"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936185/005d1b126ee105f29ef06bd439533a03.webp"
              "MediaSize" => 98242
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936185/thumbnail-005d1b126ee105f29ef06bd439533a03.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => true
              "ResourceRecordId" => "X13473716"
              "ResourceRecordKey" => "29936185"
              "ModificationTimestamp" => "2026-06-22T15:55:57.24Z"
            ]
            1 => array:13 [
              "Order" => 2
              "MediaKey" => "29936185_4890_2"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936185/faf7d7757d1e6802912c29918f584cd5.webp"
              "MediaSize" => 65599
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936185/thumbnail-faf7d7757d1e6802912c29918f584cd5.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "X13473716"
              "ResourceRecordKey" => "29936185"
              "ModificationTimestamp" => "2026-06-22T15:55:57.24Z"
            ]
            2 => array:13 [
              "Order" => 3
              "MediaKey" => "29936185_4890_3"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936185/12968768d78389c565c82e31d91e15ae.webp"
              "MediaSize" => 86161
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936185/thumbnail-12968768d78389c565c82e31d91e15ae.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "X13473716"
              "ResourceRecordKey" => "29936185"
              "ModificationTimestamp" => "2026-06-22T15:55:57.24Z"
            ]
            3 => array:13 [
              "Order" => 4
              "MediaKey" => "29936185_4890_4"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936185/a94cd6eb1fcbd877eaf789df203cb463.webp"
              "MediaSize" => 107471
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936185/thumbnail-a94cd6eb1fcbd877eaf789df203cb463.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "X13473716"
              "ResourceRecordKey" => "29936185"
              "ModificationTimestamp" => "2026-06-22T15:55:57.24Z"
            ]
            4 => array:13 [
              "Order" => 5
              "MediaKey" => "29936185_4890_5"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936185/e12364721838965c2dd997ca6d69b439.webp"
              "MediaSize" => 88985
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936185/thumbnail-e12364721838965c2dd997ca6d69b439.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "X13473716"
              "ResourceRecordKey" => "29936185"
              "ModificationTimestamp" => "2026-06-22T15:55:57.24Z"
            ]
            5 => array:13 [
              "Order" => 6
              "MediaKey" => "29936185_4890_6"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936185/89d4d1dc30689302be31f9f26cdd6f1a.webp"
              "MediaSize" => 47244
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936185/thumbnail-89d4d1dc30689302be31f9f26cdd6f1a.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "X13473716"
              "ResourceRecordKey" => "29936185"
              "ModificationTimestamp" => "2026-06-22T15:55:57.24Z"
            ]
            6 => array:13 [
              "Order" => 7
              "MediaKey" => "29936185_4890_7"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936185/8b527a88587e24ed6bff041539b1cbc7.webp"
              "MediaSize" => 85618
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936185/thumbnail-8b527a88587e24ed6bff041539b1cbc7.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "X13473716"
              "ResourceRecordKey" => "29936185"
              "ModificationTimestamp" => "2026-06-22T15:55:57.24Z"
            ]
            7 => array:13 [
              "Order" => 8
              "MediaKey" => "29936185_4890_8"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936185/180ce46bb95bc1dea0a4b5d2ddccc3d6.webp"
              "MediaSize" => 32152
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936185/thumbnail-180ce46bb95bc1dea0a4b5d2ddccc3d6.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "X13473716"
              "ResourceRecordKey" => "29936185"
              "ModificationTimestamp" => "2026-06-22T15:55:57.24Z"
            ]
            8 => array:13 [
              "Order" => 9
              "MediaKey" => "29936185_4890_9"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936185/ad5cded902b1f42fbd691dfde827c24a.webp"
              "MediaSize" => 76110
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936185/thumbnail-ad5cded902b1f42fbd691dfde827c24a.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "X13473716"
              "ResourceRecordKey" => "29936185"
              "ModificationTimestamp" => "2026-06-22T15:55:57.24Z"
            ]
            9 => array:13 [
              "Order" => 10
              "MediaKey" => "29936185_4890_10"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936185/b2054efb544fb88e1e59cbff475ac098.webp"
              "MediaSize" => 44646
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936185/thumbnail-b2054efb544fb88e1e59cbff475ac098.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "X13473716"
              "ResourceRecordKey" => "29936185"
              "ModificationTimestamp" => "2026-06-22T15:55:57.24Z"
            ]
            10 => array:13 [
              "Order" => 11
              "MediaKey" => "29936185_4890_11"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936185/8c23e8cd718fce9aaf1779c63ba4c20b.webp"
              "MediaSize" => 84385
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936185/thumbnail-8c23e8cd718fce9aaf1779c63ba4c20b.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "X13473716"
              "ResourceRecordKey" => "29936185"
              "ModificationTimestamp" => "2026-06-22T15:55:57.24Z"
            ]
          ]
          +"DaysOnMarket": 0
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29936185')"
          +"ID": "1553587"
        }
      ]
      +success: true
      +page_size: 1
      +page_count: 1
      +count: 1
      +after_key: ""
    }
    "RF Response Time" => "0.12 seconds"
  ]
  "RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 70066" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24769
      +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 1945012" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24763
      +items: []
      +success: true
      +page_size: 0
      +page_count: 0
      +count: 0
      +after_key: ""
    }
    "RF Response Time" => "0.12 seconds"
  ]
  "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29936185'" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25139
      +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 '29936185'" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25155
      +items: []
      +success: true
      +page_size: 0
      +page_count: 0
      +count: 0
      +after_key: ""
    }
    "RF Response Time" => "0.1 seconds"
  ]
  "RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29936185' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Residential Lease' AND geo.distance(Coordinates, POINT(-80.598661 43.459135)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25208
      +items: array:9 [
        0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25202
          +post_id: "1554338"
          +post_author: 1
          +"ListingKey": "29937081"
          +"ListingId": "40841989"
          +"PropertyType": "Residential Lease"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-22T18:00:16Z"
          +"RFModificationTimestamp": "2026-06-22T18:47:39Z"
          +"ListPrice": 0
          +"BathroomsTotalInteger": 4.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 5.0
          +"LotSizeArea": 0
          +"LivingArea": 4903.0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V2S7"
          +"UnparsedAddress": "872 CREEKSIDE Drive, Waterloo, Ontario N2V2S7"
          +"Coordinates": array:2 [
            0 => -80.5949334
            1 => 43.4749526
          ]
          +"Latitude": 43.4749526
          +"Longitude": -80.5949334
          +"YearBuilt": 2004
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
          +"PublicRemarks": "MOVE-IN READY. Welcome to this stunning custom-built 4+1 beds, 4 baths home in one of Waterloo’s most sought-after communities—Laurelwood. Stunning curb appeal with grand stone exterior wall and concrete driveway, Backing onto a naturally protected forest, this rare property offers exceptional privacy and serene views, with occasionally deer(s) visiting near your backyard. Step inside to discover elegant living and dining spaces that seamlessly flow into a gourmet kitchen featuring a large centre island, dark maple cabinetry, granite countertops (2024), high-end stainless steel appliances and a premium range hood (2024). The main floor is finished with good quality tiles, Canadian maple hardwood flooring, and impressive 9-foot ceilings. The dramatic open-to-above great room is the heart of the home, showcasing soaring ceilings, a stunning custom gas fireplace, and oversized windows overlooking the great views of the backyard. Walk out from the breakfast area to a spacious deck—perfect for entertaining or relaxing in nature. The main floor also offers an office, a 2pc powder room and a laundry room. Upstairs, the expansive primary suite offers a walk-in closet and a luxurious 5-piece en-suite with a glass shower and separate tub. Three additional generously sized bedrooms and a well-appointed main bath with double sinks complete the upper level. The fully finished walkout basement adds incredible versatility, featuring a large rec room with a second gas fireplace, a fifth bedroom, a 4th bathroom, and rare direct access to the garage. Recent Updates Include: Newer painted walls and kitchen cabinets (2025). Newer light fixtures (2025). Upgraded upper-level shower fixtures. Granite countertops (2024). Fridge (2025) & A/C (2024). Roof (2019). Owned Hot Water Heater. Located just steps from top-ranked schools, shopping, transit, parks, trails. A short drive to the YMCA, Costco, and both universities—this home offers the perfect blend of luxury, comfort, and convenience. (id:62650)"
          +"Appliances": array:6 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Water softener"
            3 => "Dishwasher"
            4 => "Stove"
            5 => "Dryer"
          ]
          +"AssociationFeeIncludes": array:1 [
            0 => "Insurance"
          ]
          +"Basement": array:2 [
            0 => "Finished"
            1 => "Full"
          ]
          +"BathroomsPartial": 1
          +"CommunityFeatures": array:2 [
            0 => "Quiet Area"
            1 => "School Bus"
          ]
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-06-22T18:47:27.835837+00:00"
          +"Directions": "Laurelwood Dr. to Creekside Dr."
          +"ExteriorFeatures": array:3 [
            0 => "Brick"
            1 => "Stone"
            2 => "Vinyl siding"
          ]
          +"FireplaceYN": true
          +"FireplacesTotal": "2"
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "1970409"
          +"ListOfficeKey": "295659"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:1 [
            0 => "Sump Pump"
          ]
          +"ParkingFeatures": array:1 [
            0 => "Attached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-22T17:52:49Z"
          +"PhotosCount": 50
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-22T17:52:49Z"
          +"Stories": "2.0"
          +"StreetName": "CREEKSIDE"
          +"StreetNumber": "872"
          +"StreetSuffix": "Drive"
          +"SubdivisionName": "441 - Erbsville/Laurelwood"
          +"TaxAnnualAmount": "9946"
          +"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/872-Creekside-Dr"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:17 [
            0 => array:11 [
              "RoomKey" => "1665501394"
              "RoomType" => "Utility room"
              "ListingId" => "40841989"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "29937081"
              "RoomLength" => null
              "RoomDimensions" => "11'9'' x 14'1''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T17:51:25.98Z"
            ]
            1 => array:11 [
              "RoomKey" => "1665501395"
              "RoomType" => "Recreation room"
              "ListingId" => "40841989"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "29937081"
              "RoomLength" => null
              "RoomDimensions" => "21'0'' x 36'8''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T17:51:25.98Z"
            ]
            2 => array:11 [
              "RoomKey" => "1665501396"
              "RoomType" => "Bedroom"
              "ListingId" => "40841989"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "29937081"
              "RoomLength" => null
              "RoomDimensions" => "11'8'' x 13'3''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T17:51:25.99Z"
            ]
            3 => array:11 [
              "RoomKey" => "1665501397"
              "RoomType" => "3pc Bathroom"
              "ListingId" => "40841989"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "29937081"
              "RoomLength" => null
              "RoomDimensions" => "8'7'' x 9'0''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T17:51:25.99Z"
            ]
            4 => array:11 [
              "RoomKey" => "1665501398"
              "RoomType" => "Bedroom"
              "ListingId" => "40841989"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29937081"
              "RoomLength" => null
              "RoomDimensions" => "14'7'' x 20'1''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T17:51:25.99Z"
            ]
            5 => array:11 [
              "RoomKey" => "1665501399"
              "RoomType" => "Bedroom"
              "ListingId" => "40841989"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29937081"
              "RoomLength" => null
              "RoomDimensions" => "11'8'' x 19'11''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T17:51:25.99Z"
            ]
            6 => array:11 [
              "RoomKey" => "1665501400"
              "RoomType" => "Bedroom"
              "ListingId" => "40841989"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29937081"
              "RoomLength" => null
              "RoomDimensions" => "11'1'' x 14'8''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T17:51:25.99Z"
            ]
            7 => array:11 [
              "RoomKey" => "1665501401"
              "RoomType" => "Primary Bedroom"
              "ListingId" => "40841989"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29937081"
              "RoomLength" => null
              "RoomDimensions" => "13'0'' x 17'0''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T17:51:25.99Z"
            ]
            8 => array:11 [
              "RoomKey" => "1665501402"
              "RoomType" => "Full bathroom"
              "ListingId" => "40841989"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29937081"
              "RoomLength" => null
              "RoomDimensions" => "11'3'' x 11'7''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T17:51:25.99Z"
            ]
            9 => array:11 [
              "RoomKey" => "1665501403"
              "RoomType" => "4pc Bathroom"
              "ListingId" => "40841989"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29937081"
              "RoomLength" => null
              "RoomDimensions" => "6'0'' x 11'7''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T17:51:25.99Z"
            ]
            10 => array:11 [
              "RoomKey" => "1665501404"
              "RoomType" => "Office"
              "ListingId" => "40841989"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29937081"
              "RoomLength" => null
              "RoomDimensions" => "10'0'' x 10'5''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T17:51:25.99Z"
            ]
            11 => array:11 [
              "RoomKey" => "1665501405"
              "RoomType" => "Great room"
              "ListingId" => "40841989"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29937081"
              "RoomLength" => null
              "RoomDimensions" => "15'6'' x 17'7''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T17:51:26Z"
            ]
            12 => array:11 [
              "RoomKey" => "1665501406"
              "RoomType" => "Laundry room"
              "ListingId" => "40841989"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29937081"
              "RoomLength" => null
              "RoomDimensions" => "7'0'' x 10'5''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T17:51:26Z"
            ]
            13 => array:11 [
              "RoomKey" => "1665501407"
              "RoomType" => "Eat in kitchen"
              "ListingId" => "40841989"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29937081"
              "RoomLength" => null
              "RoomDimensions" => "12'10'' x 21'10''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T17:51:26Z"
            ]
            14 => array:11 [
              "RoomKey" => "1665501408"
              "RoomType" => "Foyer"
              "ListingId" => "40841989"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29937081"
              "RoomLength" => null
              "RoomDimensions" => "6'0'' x 8'2''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T17:51:26Z"
            ]
            15 => array:11 [
              "RoomKey" => "1665501409"
              "RoomType" => "Living room/Dining room"
              "ListingId" => "40841989"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29937081"
              "RoomLength" => null
              "RoomDimensions" => "11'3'' x 29'8''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T17:51:26Z"
            ]
            16 => array:11 [
              "RoomKey" => "1665501410"
              "RoomType" => "2pc Bathroom"
              "ListingId" => "40841989"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29937081"
              "RoomLength" => null
              "RoomDimensions" => "6'6'' x 4'11''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T17:51:26Z"
            ]
          ]
          +"ListAOR": "Cornerstone"
          +"ListAORKey": "14"
          +"ListingURL": "www.realtor.ca/real-estate/29937081/872-creekside-drive-waterloo"
          +"ParkingTotal": 4
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"TotalActualRent": 5000
          +"ZoningDescription": "R4"
          +"BedroomsAboveGrade": 4
          +"BedroomsBelowGrade": 1
          +"LeaseAmountFrequency": "Monthly"
          +"FrontageLengthNumeric": 51.0
          +"AboveGradeFinishedArea": 3430
          +"BelowGradeFinishedArea": 1473
          +"OriginalEntryTimestamp": "2026-06-22T17:51:25.95Z"
          +"FrontageLengthNumericUnits": "feet"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"BelowGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Other"
          +"BelowGradeFinishedAreaSource": "Other"
          +"ListAgentNationalAssociationId": "1257707"
          +"ListOfficeNationalAssociationId": "1452740"
          +"Media": array:50 [
            0 => array:13 [
              "Order" => 1
              "MediaKey" => "29937081_4890_1"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/95b00513d6c45ef1bfc02c8e0f419189.webp"
              "MediaSize" => 193892
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-95b00513d6c45ef1bfc02c8e0f419189.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Image quality insufficient for description"
              "PreferredPhotoYN" => true
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:44.15Z"
            ]
            1 => array:13 [
              "Order" => 2
              "MediaKey" => "29937081_4890_2"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/e1dcb5d04394c3158e72198280922d42.webp"
              "MediaSize" => 75039
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-e1dcb5d04394c3158e72198280922d42.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Vaulted ceiling great room featuring a wood-finish floor and a fireplace with a wood mantle"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:44.15Z"
            ]
            2 => array:13 [
              "Order" => 3
              "MediaKey" => "29937081_4890_3"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/54856a8e7bb8be0dc06c115d4e358541.webp"
              "MediaSize" => 123808
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-54856a8e7bb8be0dc06c115d4e358541.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Stone veneer exterior featuring multiple gables and a double garage"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:43.96Z"
            ]
            3 => array:13 [
              "Order" => 4
              "MediaKey" => "29937081_4890_4"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/8f422a8e937bc27555364b9efb174153.webp"
              "MediaSize" => 132953
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-8f422a8e937bc27555364b9efb174153.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Two-story residence featuring a stone facade and beige siding accents"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:44.16Z"
            ]
            4 => array:13 [
              "Order" => 5
              "MediaKey" => "29937081_4890_5"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/16d461adbf56303e2ab8c94ae54cff99.webp"
              "MediaSize" => 123607
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-16d461adbf56303e2ab8c94ae54cff99.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Stone-clad exterior featuring a two-car garage with overhead lighting"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:44.15Z"
            ]
            5 => array:13 [
              "Order" => 6
              "MediaKey" => "29937081_4890_6"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/d41ef5f85fb58e3521ef3a220e4c8c3e.webp"
              "MediaSize" => 76037
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-d41ef5f85fb58e3521ef3a220e4c8c3e.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Foyer featuring tile flooring, a dark-paneled door with decorative glass, and a traditional ceiling light fixture"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:43.91Z"
            ]
            6 => array:13 [
              "Order" => 7
              "MediaKey" => "29937081_4890_7"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/d855f4efc1d88491e1ec8d95d98a38dd.webp"
              "MediaSize" => 76649
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-d855f4efc1d88491e1ec8d95d98a38dd.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Foyer featuring tiled flooring, a natural wood staircase, and an arched window"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:46.4Z"
            ]
            7 => array:13 [
              "Order" => 8
              "MediaKey" => "29937081_4890_8"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/1c9d1de7eaa27f12695ad7b7594cabf2.webp"
              "MediaSize" => 88783
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-1c9d1de7eaa27f12695ad7b7594cabf2.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Spacious living area featuring light wood-finish flooring, a prominent bay window, crown molding, and neutral wall tones"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:43.43Z"
            ]
            8 => array:13 [
              "Order" => 9
              "MediaKey" => "29937081_4890_9"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/1e3dd2b889a2d9a3717525649eb46be1.webp"
              "MediaSize" => 74509
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-1e3dd2b889a2d9a3717525649eb46be1.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Bright interior space featuring light wood-finish flooring, neutral wall tones, white crown molding, and white baseboards"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:45.11Z"
            ]
            9 => array:13 [
              "Order" => 10
              "MediaKey" => "29937081_4890_10"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/784d253e5d0ee3b890dd7f43afa9959c.webp"
              "MediaSize" => 80566
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-784d253e5d0ee3b890dd7f43afa9959c.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Dining area featuring wood-finish flooring, crown molding, and a chandelier"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:44.17Z"
            ]
            10 => array:13 [
              "Order" => 11
              "MediaKey" => "29937081_4890_11"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/54501529b9ec38b97f49bd28ceaa5432.webp"
              "MediaSize" => 91832
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-54501529b9ec38b97f49bd28ceaa5432.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Spacious interior room featuring light wood-finish flooring, a bay window, and a chandelier light fixture"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:43.91Z"
            ]
            11 => array:13 [
              "Order" => 12
              "MediaKey" => "29937081_4890_12"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/66121205e5eadb284de859d3f8ea104b.webp"
              "MediaSize" => 83015
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-66121205e5eadb284de859d3f8ea104b.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Vaulted ceilings featuring a chandelier, hardwood flooring, and a fireplace with a stone surround"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:43.43Z"
            ]
            12 => array:13 [
              "Order" => 13
              "MediaKey" => "29937081_4890_13"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/f68180dd3f6a2835bf234bbef297bab1.webp"
              "MediaSize" => 87554
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-f68180dd3f6a2835bf234bbef297bab1.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Vaulted ceiling living space featuring large arched and rectangular windows, wood-finish flooring, a fireplace with a dark mantel, and an open concept kitchen with dark cabinetry and a central island"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:43.67Z"
            ]
            13 => array:13 [
              "Order" => 14
              "MediaKey" => "29937081_4890_14"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/b8a9029e1eda82df24e73c56f598fc00.webp"
              "MediaSize" => 77494
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-b8a9029e1eda82df24e73c56f598fc00.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Great room with soaring ceilings and wood-finish flooring extending into the kitchen"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:45.15Z"
            ]
            14 => array:13 [
              "Order" => 15
              "MediaKey" => "29937081_4890_15"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/260c821f72f5898b28700a1a2168919a.webp"
              "MediaSize" => 85405
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-260c821f72f5898b28700a1a2168919a.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Spacious kitchen featuring a large central island with a light-toned countertop, extensive dark wood cabinetry, and stainless steel appliances"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:44.15Z"
            ]
            15 => array:13 [
              "Order" => 16
              "MediaKey" => "29937081_4890_16"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/4be53d22572975e570ad264afeb30ac0.webp"
              "MediaSize" => 87382
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-4be53d22572975e570ad264afeb30ac0.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Gourmet kitchen featuring extensive dark wood-finish cabinetry, granite countertops, a central island with integrated cooktop, stainless steel appliances, and tile flooring"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:45.13Z"
            ]
            16 => array:13 [
              "Order" => 17
              "MediaKey" => "29937081_4890_17"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/ad0c390b8db5665509b5a7ddb94f4951.webp"
              "MediaSize" => 98602
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-ad0c390b8db5665509b5a7ddb94f4951.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Kitchen featuring dark wood-finish cabinetry, light-toned tiled flooring, and an L-shaped countertop"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:46.41Z"
            ]
            17 => array:13 [
              "Order" => 18
              "MediaKey" => "29937081_4890_18"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/2ad2b2f4525bb631679c37fa67de08d6.webp"
              "MediaSize" => 99146
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-2ad2b2f4525bb631679c37fa67de08d6.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Kitchen featuring dark wood-finish cabinetry, light-toned tile flooring, and integrated stainless steel appliances"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:44.15Z"
            ]
            18 => array:13 [
              "Order" => 19
              "MediaKey" => "29937081_4890_19"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/ae61ddb0514f1f0c5123abf44094d5ed.webp"
              "MediaSize" => 90558
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-ae61ddb0514f1f0c5123abf44094d5ed.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Kitchen island with dark wood cabinetry and a polished stone countertop featuring pendant lighting"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:45.16Z"
            ]
            19 => array:13 [
              "Order" => 20
              "MediaKey" => "29937081_4890_20"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/b17a8adafa09d595bafaa63c8fd0320c.webp"
              "MediaSize" => 99367
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-b17a8adafa09d595bafaa63c8fd0320c.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Kitchen featuring dark wood cabinetry, a granite-topped island with seating, a tile backsplash, and stainless steel appliances"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:45.14Z"
            ]
            20 => array:13 [
              "Order" => 21
              "MediaKey" => "29937081_4890_21"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/0533f6451d96d2a4b410c6db4b388931.webp"
              "MediaSize" => 85483
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-0533f6451d96d2a4b410c6db4b388931.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Open-concept dining area featuring tiled flooring"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:46.41Z"
            ]
            21 => array:13 [
              "Order" => 22
              "MediaKey" => "29937081_4890_22"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/79e622a0c50d66e7295f26c4d97c60a5.webp"
              "MediaSize" => 64143
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-79e622a0c50d66e7295f26c4d97c60a5.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Powder room featuring a dark wood vanity with an integral sink, a dark stone countertop, and a decorative framed mirror"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:45.16Z"
            ]
            22 => array:13 [
              "Order" => 23
              "MediaKey" => "29937081_4890_23"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/ae523e50bc8ef3c35fbe6a189a69f1f3.webp"
              "MediaSize" => 66771
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-ae523e50bc8ef3c35fbe6a189a69f1f3.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Room featuring light wood-finish flooring and neutral wall tones"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:44.15Z"
            ]
            23 => array:13 [
              "Order" => 24
              "MediaKey" => "29937081_4890_24"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/17386c0dcb949c109341dec2bfa1aca8.webp"
              "MediaSize" => 78005
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-17386c0dcb949c109341dec2bfa1aca8.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Entryway featuring tile flooring, a natural wood staircase with balusters, a laundry area with a washing machine, and a built-in storage closet"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:45.12Z"
            ]
            24 => array:13 [
              "Order" => 25
              "MediaKey" => "29937081_4890_25"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/318de1de8b59fb10f00f0a5cc945db5f.webp"
              "MediaSize" => 69714
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-318de1de8b59fb10f00f0a5cc945db5f.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Upper-level landing featuring wood-finish flooring, light-toned walls, a chandelier fixture, and natural wood railings"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:45.13Z"
            ]
            25 => array:13 [
              "Order" => 26
              "MediaKey" => "29937081_4890_26"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/ab6f7af2bc6a6332371c699bd7d9804a.webp"
              "MediaSize" => 92286
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-ab6f7af2bc6a6332371c699bd7d9804a.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Spacious room featuring hardwood flooring, multiple windows with blinds, crown molding, and a flush mount ceiling light"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:45.96Z"
            ]
            26 => array:13 [
              "Order" => 27
              "MediaKey" => "29937081_4890_27"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/a29f4ec2c5a5b26e2f430f102b79f395.webp"
              "MediaSize" => 54828
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-a29f4ec2c5a5b26e2f430f102b79f395.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Bedroom featuring light wood flooring and neutral wall tones"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:45.15Z"
            ]
            27 => array:13 [
              "Order" => 28
              "MediaKey" => "29937081_4890_28"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/d60045f9d567d4594bbc10136d6e2e15.webp"
              "MediaSize" => 83556
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-d60045f9d567d4594bbc10136d6e2e15.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Modern bathroom featuring a freestanding soaking tub, a frameless glass shower enclosure, a stone accent wall, a vanity with a vessel sink and stone countertop, and large format tile flooring"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:45.14Z"
            ]
            28 => array:13 [
              "Order" => 29
              "MediaKey" => "29937081_4890_29"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/8e45fb93763cfaee3cf29460478a75d3.webp"
              "MediaSize" => 88192
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-8e45fb93763cfaee3cf29460478a75d3.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Freestanding soaking tub with a floor-mounted faucet, complemented by a stone accent wall"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:46.28Z"
            ]
            29 => array:13 [
              "Order" => 30
              "MediaKey" => "29937081_4890_30"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/14042e39bac8648be7a5a58eb6b78421.webp"
              "MediaSize" => 76496
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-14042e39bac8648be7a5a58eb6b78421.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Vaulted ceiling bedroom featuring light wood-finish flooring, a large arched window with horizontal blinds, and neutral wall tones"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:44.14Z"
            ]
            30 => array:13 [
              "Order" => 31
              "MediaKey" => "29937081_4890_31"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/bf365703f02bb9794aabaa1e56d4c32e.webp"
              "MediaSize" => 79912
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-bf365703f02bb9794aabaa1e56d4c32e.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Contemporary bathroom featuring a double vanity with vessel sinks, mirrored cabinets, and decorative wall sconces"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:49.38Z"
            ]
            31 => array:13 [
              "Order" => 32
              "MediaKey" => "29937081_4890_32"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/14bda44fcc895abe8013c6506e6a5560.webp"
              "MediaSize" => 76039
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-14bda44fcc895abe8013c6506e6a5560.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Bright interior featuring wood-finish flooring, neutral wall tones, and a large arched window"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:45.42Z"
            ]
            32 => array:13 [
              "Order" => 33
              "MediaKey" => "29937081_4890_33"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/50366e47f78996fac111449a8816df69.webp"
              "MediaSize" => 52683
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-50366e47f78996fac111449a8816df69.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Spacious room featuring wood-finish flooring, light neutral wall paint, and a white ceiling"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:45.41Z"
            ]
            33 => array:13 [
              "Order" => 34
              "MediaKey" => "29937081_4890_34"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/fc7cf2773b6bbe745bad392688634dfd.webp"
              "MediaSize" => 65231
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-fc7cf2773b6bbe745bad392688634dfd.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Bedroom with light wood-finish flooring and neutral-toned walls"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:43.43Z"
            ]
            34 => array:13 [
              "Order" => 35
              "MediaKey" => "29937081_4890_35"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/be8cf4ce1bcf267cce41543b3cba1f5f.webp"
              "MediaSize" => 76442
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-be8cf4ce1bcf267cce41543b3cba1f5f.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Living space featuring light-toned carpeting and neutral wall colors"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:45.16Z"
            ]
            35 => array:13 [
              "Order" => 36
              "MediaKey" => "29937081_4890_36"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/28bd11b2f4808ba5f93b0ad144c0fc9d.webp"
              "MediaSize" => 59275
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-28bd11b2f4808ba5f93b0ad144c0fc9d.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Spacious lower-level area with recessed lighting, light-toned carpeting, neutral wall paint, and a wood-finish fireplace mantel"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:46.4Z"
            ]
            36 => array:13 [
              "Order" => 37
              "MediaKey" => "29937081_4890_37"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/890591e400a3e499897b6ef3d4d52763.webp"
              "MediaSize" => 73850
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-890591e400a3e499897b6ef3d4d52763.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Spacious lower-level area featuring recessed lighting, light-toned carpeting, and a neutral wall palette"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:45.96Z"
            ]
            37 => array:13 [
              "Order" => 38
              "MediaKey" => "29937081_4890_38"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/e63c9a194580b772d6e4e0d45858dfe7.webp"
              "MediaSize" => 57854
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-e63c9a194580b772d6e4e0d45858dfe7.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Expansive carpeted room featuring recessed lighting and neutral wall tones"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:44.15Z"
            ]
            38 => array:13 [
              "Order" => 39
              "MediaKey" => "29937081_4890_39"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/d536fae6f2e2613259ec5e277df63f21.webp"
              "MediaSize" => 68428
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-d536fae6f2e2613259ec5e277df63f21.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Spacious finished lower level featuring recessed lighting, light-toned carpeting, a built-in fireplace with a wood mantle, and an open layout"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:45.19Z"
            ]
            39 => array:13 [
              "Order" => 40
              "MediaKey" => "29937081_4890_40"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/2588393146248884689c191591be2dd7.webp"
              "MediaSize" => 79895
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-2588393146248884689c191591be2dd7.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Bedroom featuring neutral tone walls, white trim, recessed lighting, and a horizontal casement window"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:45.14Z"
            ]
            40 => array:13 [
              "Order" => 41
              "MediaKey" => "29937081_4890_41"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/f39f468a9015b4d8fc1e8bc970a8fd90.webp"
              "MediaSize" => 56357
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-f39f468a9015b4d8fc1e8bc970a8fd90.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Bathroom with a corner shower enclosure, white toilet, and a vanity featuring a dark countertop and wood-finish cabinetry"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:45.11Z"
            ]
            41 => array:13 [
              "Order" => 42
              "MediaKey" => "29937081_4890_42"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/aaf5a028a8cc48b9a8498c332de40865.webp"
              "MediaSize" => 57292
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-aaf5a028a8cc48b9a8498c332de40865.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Bathroom featuring a light wood-finish vanity with a dark countertop, an integrated sink, and a four-light fixture above a large mirror"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:45.14Z"
            ]
            42 => array:13 [
              "Order" => 43
              "MediaKey" => "29937081_4890_43"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/d9d77b4640d2faf2cbb674a2c2ea9748.webp"
              "MediaSize" => 138221
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-d9d77b4640d2faf2cbb674a2c2ea9748.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Spacious outdoor deck featuring wood flooring and a wooden railing"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:45.15Z"
            ]
            43 => array:13 [
              "Order" => 44
              "MediaKey" => "29937081_4890_44"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/63d566d03756ef6868cf1dd5b3be036e.webp"
              "MediaSize" => 184481
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-63d566d03756ef6868cf1dd5b3be036e.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Expansive rear yard featuring a multi-level structure with a brick lower level and siding upper levels"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:46.28Z"
            ]
            44 => array:13 [
              "Order" => 45
              "MediaKey" => "29937081_4890_45"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/e2557e47ec8b16b790ae19fd7770af33.webp"
              "MediaSize" => 180560
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-e2557e47ec8b16b790ae19fd7770af33.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Rear exterior featuring a two-story brick and siding construction with an expansive deck and staircase"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:44.16Z"
            ]
            45 => array:13 [
              "Order" => 46
              "MediaKey" => "29937081_4890_46"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/2c59f0785b15d48f0832220e383b1896.webp"
              "MediaSize" => 139811
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-2c59f0785b15d48f0832220e383b1896.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Rear elevation featuring a multi-level wood deck with stairs to the lawn"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:43.91Z"
            ]
            46 => array:13 [
              "Order" => 47
              "MediaKey" => "29937081_4890_47"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/2b1c2c157734e34abf5b1797864587cc.webp"
              "MediaSize" => 181691
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-2b1c2c157734e34abf5b1797864587cc.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Image quality insufficient for description"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:44.15Z"
            ]
            47 => array:13 [
              "Order" => 48
              "MediaKey" => "29937081_4890_48"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/9c12d562d74c98d47bfb21ba64fdab1c.webp"
              "MediaSize" => 179309
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-9c12d562d74c98d47bfb21ba64fdab1c.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Aerial perspective showcasing a residential neighborhood with ample green space"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:44.15Z"
            ]
            48 => array:13 [
              "Order" => 49
              "MediaKey" => "29937081_4890_49"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/6f275957a9c70d19c4aecfebdc954620.webp"
              "MediaSize" => 202199
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-6f275957a9c70d19c4aecfebdc954620.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Aerial perspective showcasing a residential community surrounded by lush green trees and natural water features"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:45.96Z"
            ]
            49 => array:13 [
              "Order" => 50
              "MediaKey" => "29937081_4890_50"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937081/d15d4f5c2843f9f87e023a5331fb65ee.webp"
              "MediaSize" => 173608
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937081/thumbnail-d15d4f5c2843f9f87e023a5331fb65ee.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Aerial perspective showcasing a property surrounded by mature trees"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841989"
              "ResourceRecordKey" => "29937081"
              "ModificationTimestamp" => "2026-06-22T17:52:44.15Z"
            ]
          ]
          +"DaysOnMarket": 0
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29937081')"
          +"ID": "1554338"
        }
        1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25204
          +post_id: "1542259"
          +post_author: 1
          +"ListingKey": "29919922"
          +"ListingId": "X13459366"
          +"PropertyType": "Residential Lease"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-18T01:50:02Z"
          +"RFModificationTimestamp": "2026-06-18T04:56:54Z"
          +"ListPrice": 0
          +"BathroomsTotalInteger": 3.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 2.0
          +"LotSizeArea": 0
          +"LivingArea": 0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V0G9"
          +"UnparsedAddress": "14 - 142 FOAMFLOWER PLACE, Waterloo, Ontario N2V0G9"
          +"Coordinates": array:2 [
            0 => -80.589669
            1 => 43.44955
          ]
          +"Latitude": 43.44955
          +"Longitude": -80.589669
          +"YearBuilt": 0
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Toronto Regional Real Estate Board"
          +"PublicRemarks": "Welcome to 142 Foamflower Place Unit #14, a rare opportunity to lease a stunning brand new condo townhome in the highly desirable Vista Hills community of Waterloo. This beautifully designed "Viola" model offers approximately 1,300 sq. ft. of modern finished living space, perfectly blending style, comfort, and functionality. From the moment you step inside, you'll appreciate the bright open-concept layout, elegant laminate flooring, upgraded finishes, and thoughtfully selected details throughout. The contemporary kitchen features rich chocolate brown cabinetry, sleek quartz countertops, a spacious center island, and brand-new stainless steel appliances, making it ideal for both everyday living and entertaining. The inviting Great Room opens onto a private balcony, creating the perfect space to relax and unwind. The upper level offers two spacious bedrooms, including a luxurious primary retreat complete with a walk-in closet, private balcony access, and a spa-inspired 4-piece ensuite featuring an upgraded glass-enclosed shower. The second bedroom is generously sized and conveniently served by another full 4-piece bathroom, making this home ideal for families, professionals, or roommates. Additional conveniences include upper-level laundry with a stackable washer and dryer, linen storage, zebra blinds already installed, and one dedicated parking space. Located just minutes from top-rated schools, beautiful parks, Costco, shopping centers, restaurants, and both the University of Waterloo and Wilfrid Laurier University, this exceptional property offers unmatched convenience in one of Waterloo's fastest-growing communities. Owners prefer families or working professionals with strong credit and stable income. Utilities are extra. Don't miss your chance to enjoy upscale, stress-free living in this AAA+ location, schedule your private showing today! (id:62783)"
          +"Appliances": array:6 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Dishwasher"
            3 => "Stove"
            4 => "Dryer"
            5 => "Hood Fan"
          ]
          +"Basement": array:1 [
            0 => "None"
          ]
          +"BathroomsPartial": 1
          +"CommunityFeatures": array:1 [
            0 => "Pets Allowed With Restrictions"
          ]
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-06-18T04:56:48.353153+00:00"
          +"Directions": "Cross Streets: Columbia St. ** Directions: ERBSVILLE RD/ COLOMBIA ST W/LADYSLIPPER DR."
          +"ExteriorFeatures": array:1 [
            0 => "Concrete"
          ]
          +"FoundationDetails": array:1 [
            0 => "Concrete"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "2130557"
          +"ListOfficeKey": "288578"
          +"LivingAreaUnits": "square feet"
          +"ParkingFeatures": array:1 [
            0 => "No Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-18T01:44:13Z"
          +"PhotosCount": 33
          +"PropertyAttachedYN": true
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-18T01:44:13Z"
          +"StreetName": "FOAMFLOWER"
          +"StreetNumber": "142"
          +"StreetSuffix": "Place"
          +"Rooms": array:6 [
            0 => array:11 [
              "RoomKey" => "1661722342"
              "RoomType" => "Great room"
              "ListingId" => "X13459366"
              "RoomLevel" => "Main level"
              "RoomWidth" => 3.81
              "ListingKey" => "29919922"
              "RoomLength" => 3.86
              "RoomDimensions" => null
              "RoomDescription" => null
              "RoomLengthWidthUnits" => "meters"
               …1
            ]
            1 => array:11 [ …11]
            2 => array:11 [ …11]
            3 => array:11 [ …11]
            4 => array:11 [ …11]
            5 => array:11 [ …11]
          ]
          +"ListAOR": "Toronto"
          +"ListAORKey": "82"
          +"ListingURL": "www.realtor.ca/real-estate/29919922/14-142-foamflower-place-waterloo"
          +"ParkingTotal": 1
          +"StructureType": array:1 [
            0 => "Row / Townhouse"
          ]
          +"CommonInterest": "Condo/Strata"
          +"AssociationName": "Wilson Blanchard"
          +"GeocodeManualYN": false
          +"TotalActualRent": 2450
          +"BuildingFeatures": array:1 [
            0 => "Visitor Parking"
          ]
          +"LivingAreaMaximum": 1399
          +"LivingAreaMinimum": 1200
          +"BedroomsAboveGrade": 2
          +"BedroomsBelowGrade": 0
          +"LeaseAmountFrequency": "Monthly"
          +"OriginalEntryTimestamp": "2026-06-18T01:44:13.68Z"
          +"ListAgentNationalAssociationId": "1389915"
          +"ListOfficeNationalAssociationId": "1369645"
          +"Media": array:33 [
            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]
          ]
          +"DaysOnMarket": 4
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919922')"
          +"ID": "1542259"
        }
        2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25201
          +post_id: "1540643"
          +post_author: 1
          +"ListingKey": "29918295"
          +"ListingId": "40838733"
          +"PropertyType": "Residential Lease"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-17T20:30:09Z"
          +"RFModificationTimestamp": "2026-06-17T20:54:51Z"
          +"ListPrice": 0
          +"BathroomsTotalInteger": 3.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 2.0
          +"LotSizeArea": 0
          +"LivingArea": 1280.0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V0J1"
          +"UnparsedAddress": "142 FOAMFLOWER Place Unit# 14, Waterloo, Ontario N2V0J1"
          +"Coordinates": array:2 [
            0 => -80.5899854
            1 => 43.4496439
          ]
          +"Latitude": 43.4496439
          +"Longitude": -80.5899854
          +"YearBuilt": 2024
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
          +"PublicRemarks": "Welcome to 142 Foamflower Place Unit #14, a rare opportunity to lease a stunning brand new condo townhome in the highly desirable Vista Hills community of Waterloo. This beautifully designed “Viola” model offers approximately 1,300 sq. ft. of modern finished living space, perfectly blending style, comfort, and functionality. From the moment you step inside, you’ll appreciate the bright open-concept layout, elegant laminate flooring, upgraded finishes, and thoughtfully selected details throughout. The contemporary kitchen features rich chocolate brown cabinetry, sleek quartz countertops, a spacious center island, and brand-new stainless steel appliances, making it ideal for both everyday living and entertaining. The inviting Great Room opens onto a private balcony, creating the perfect space to relax and unwind. The upper level offers two spacious bedrooms, including a luxurious primary retreat complete with a walk-in closet, private balcony access, and a spa-inspired 4-piece ensuite featuring an upgraded glass-enclosed shower. The second bedroom is generously sized and conveniently served by another full 4-piece bathroom, making this home ideal for families, professionals, or roommates. Additional conveniences include upper-level laundry with a stackable washer and dryer, linen storage, zebra blinds already installed, and one dedicated parking space. Located just minutes from top-rated schools, beautiful parks, Costco, shopping centers, restaurants, and both the University of Waterloo and Wilfrid Laurier University, this exceptional property offers unmatched convenience in one of Waterloo’s fastest-growing communities. Owners prefer families or working professionals with strong credit and stable income. Utilities are extra. Don’t miss your chance to enjoy upscale, stress-free living in this AAA+ location, schedule your private showing today! (id:62650)"
          +"Appliances": array:7 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Water softener"
            3 => "Dishwasher"
            4 => "Stove"
            5 => "Dryer"
            6 => "Hood Fan"
          ]
          +"Basement": array:1 [
            0 => "None"
          ]
          +"BathroomsPartial": 1
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-06-17T20:54:42.381657+00:00"
          +"Directions": "ERBSVILLE RD/ COLOMBIA ST W/LADYSLIPPER DR"
          +"ExteriorFeatures": array:3 [
            0 => "Stucco"
            1 => "Vinyl siding"
            2 => "Brick Veneer"
          ]
          +"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 => "Balcony"
          ]
          +"ParkingFeatures": array:1 [
            0 => "Open"
          ]
          +"PhotosChangeTimestamp": "2026-06-17T20:21:26Z"
          +"PhotosCount": 33
          +"PropertyAttachedYN": true
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-17T20:21:25Z"
          +"Stories": "2.0"
          +"StreetName": "FOAMFLOWER"
          +"StreetNumber": "142"
          +"StreetSuffix": "Place"
          +"SubdivisionName": "443 - Columbia Forest/Clair Hills"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:7 [
            0 => array:11 [ …11]
            1 => array:11 [ …11]
            2 => array:11 [ …11]
            3 => array:11 [ …11]
            4 => array:11 [ …11]
            5 => array:11 [ …11]
            6 => array:11 [ …11]
          ]
          +"ListAOR": "Cornerstone"
          +"ListAORKey": "14"
          +"ListingURL": "www.realtor.ca/real-estate/29918295/142-foamflower-place-unit-14-waterloo"
          +"ParkingTotal": 1
          +"StructureType": array:1 [
            0 => "Row / Townhouse"
          ]
          +"CommonInterest": "Condo/Strata"
          +"GeocodeManualYN": true
          +"TotalActualRent": 2450
          +"ZoningDescription": "R6-FT"
          +"BedroomsAboveGrade": 2
          +"BedroomsBelowGrade": 0
          +"LeaseAmountFrequency": "Monthly"
          +"AboveGradeFinishedArea": 1280
          +"OriginalEntryTimestamp": "2026-06-17T20:21:25.35Z"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Owner"
          +"ListAgentNationalAssociationId": "1123254"
          +"ListOfficeNationalAssociationId": "1380559"
          +"Media": array:33 [
            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]
          ]
          +"DaysOnMarket": 4
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918295')"
          +"ID": "1540643"
        }
        3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25205
          +post_id: "1537444"
          +post_author: 1
          +"ListingKey": "29912396"
          +"ListingId": "40839543"
          +"PropertyType": "Residential Lease"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-16T21:00:09Z"
          +"RFModificationTimestamp": "2026-06-16T22:53:28Z"
          +"ListPrice": 0
          +"BathroomsTotalInteger": 4.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 4.0
          +"LotSizeArea": 0
          +"LivingArea": 3217.0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V0B9"
          +"UnparsedAddress": "603 SUNDEW Drive, Waterloo, Ontario N2V0B9"
          +"Coordinates": array:2 [
            0 => -80.5977533
            1 => 43.4599617
          ]
          +"Latitude": 43.4599617
          +"Longitude": -80.5977533
          +"YearBuilt": 2015
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
          +"PublicRemarks": "Welcome to 603 Sundew Drive, a beautifully maintained home in the highly desirable Vista Hills community. This impressive 2,267 sq. ft. residence offers the perfect blend of comfort, style, and convenience. The main level features 9-foot ceilings and a bright, open-concept design ideal for both everyday living and entertaining. The spacious great room is highlighted by a cozy fireplace and provides direct access to a large patio overlooking the private natural setting. A convenient main-floor laundry room offers interior access to the double-car garage. Upstairs, the generous primary suite serves as a relaxing retreat, complete with a walk-in closet and a luxurious 5-piece ensuite. Two additional well-sized bedrooms and a full main bathroom complete the upper level. The finished basement adds valuable living space, featuring a large recreation room, an additional bedroom, and a 3-piece bathroom—perfect for guests, a home office, or growing families. Outside, professionally landscaped grounds enhance the home's curb appeal and outdoor enjoyment. Ideally located close to shopping at Costco and The Boardwalk, medical facilities, parks, and public transit, with a short 12-minute bus ride to the universities. Families will also appreciate the proximity to Vista Hills Public School, making this an exceptional place to call home. (id:62650)"
          +"Appliances": array:5 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Dishwasher"
            3 => "Stove"
            4 => "Dryer"
          ]
          +"AssociationFeeIncludes": array:1 [
            0 => "Insurance"
          ]
          +"Basement": array:2 [
            0 => "Finished"
            1 => "Full"
          ]
          +"BathroomsPartial": 1
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-06-16T22:53:21.978725+00:00"
          +"ExteriorFeatures": array:3 [
            0 => "Stone"
            1 => "Vinyl siding"
            2 => "Brick Veneer"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "2060436"
          +"ListOfficeKey": "295659"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:1 [
            0 => "Paved driveway"
          ]
          +"ParkingFeatures": array:1 [
            0 => "Attached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-16T20:51:17Z"
          +"PhotosCount": 21
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-16T20:51:17Z"
          +"Stories": "2.0"
          +"StreetName": "SUNDEW"
          +"StreetNumber": "603"
          +"StreetSuffix": "Drive"
          +"SubdivisionName": "443 - Columbia Forest/Clair Hills"
          +"TaxAnnualAmount": "6768"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:13 [
            0 => array:11 [ …11]
            1 => array:11 [ …11]
            2 => array:11 [ …11]
            3 => array:11 [ …11]
            4 => array:11 [ …11]
            5 => array:11 [ …11]
            6 => array:11 [ …11]
            7 => array:11 [ …11]
            8 => array:11 [ …11]
            9 => array:11 [ …11]
            10 => array:11 [ …11]
            11 => array:11 [ …11]
            12 => array:11 [ …11]
          ]
          +"ListAOR": "Cornerstone"
          +"ListAORKey": "14"
          +"ListingURL": "www.realtor.ca/real-estate/29912396/603-sundew-drive-waterloo"
          +"ParkingTotal": 4
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"TotalActualRent": 3500
          +"ZoningDescription": "NR"
          +"BedroomsAboveGrade": 3
          +"BedroomsBelowGrade": 1
          +"LeaseAmountFrequency": "Monthly"
          +"FrontageLengthNumeric": 46.0
          +"AboveGradeFinishedArea": 2267
          +"BelowGradeFinishedArea": 950
          +"OriginalEntryTimestamp": "2026-06-16T20:51:17.38Z"
          +"FrontageLengthNumericUnits": "feet"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"BelowGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Assessor"
          +"BelowGradeFinishedAreaSource": "Owner"
          +"ListAgentNationalAssociationId": "1335580"
          +"ListOfficeNationalAssociationId": "1452740"
          +"Media": array:21 [
            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]
          ]
          +"DaysOnMarket": 5
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912396')"
          +"ID": "1537444"
        }
        4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25203
          +post_id: "1532832"
          +post_author: 1
          +"ListingKey": "29907351"
          +"ListingId": "X13448166"
          +"PropertyType": "Residential Lease"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-16T14:25:03Z"
          +"RFModificationTimestamp": "2026-06-16T14:25:46Z"
          +"ListPrice": 0
          +"BathroomsTotalInteger": 3.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 4.0
          +"LotSizeArea": 0
          +"LivingArea": 0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V2T5"
          +"UnparsedAddress": "437 SPECKLED ALDER STREET, Waterloo, Ontario N2V2T5"
          +"Coordinates": array:2 [
            0 => -80.594098
            1 => 43.468816
          ]
          +"Latitude": 43.468816
          +"Longitude": -80.594098
          +"YearBuilt": 0
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Toronto Regional Real Estate Board"
          +"PublicRemarks": "Well Maintained 3 Bedroom House, Open Concept Kitchen With Large Breakfast Area. Large Master Bedroom, Walking Distance To Schools. Close To Park And All Other Amenities. (id:62650)"
          +"Appliances": array:5 [
            0 => "Refrigerator"
            1 => "Dishwasher"
            2 => "Stove"
            3 => "Range"
            4 => "Window Coverings"
          ]
          +"Basement": array:2 [
            0 => "Finished"
            1 => "N/A"
          ]
          +"BathroomsPartial": 1
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-06-16T00:44:46.016698+00:00"
          +"Directions": "Erbsville Rd/Laurewood Dr."
          +"ExteriorFeatures": array:1 [
            0 => "Brick"
          ]
          +"FoundationDetails": array:1 [
            0 => "Concrete"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "1948797"
          +"ListOfficeKey": "51127"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:1 [
            0 => "In suite Laundry"
          ]
          +"LotSizeDimensions": "33.1 x 82 FT"
          +"ParkingFeatures": array:1 [
            0 => "Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-15T22:48:00Z"
          +"PhotosCount": 14
          +"Sewer": array:1 [
            0 => "Sanitary sewer"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-16T14:19:55Z"
          +"Stories": "2.0"
          +"StreetName": "Speckled Alder"
          +"StreetNumber": "437"
          +"StreetSuffix": "Street"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"ListAOR": "Toronto"
          +"ListAORKey": "82"
          +"ListingURL": "www.realtor.ca/real-estate/29907351/437-speckled-alder-street-waterloo"
          +"ParkingTotal": 3
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CoListAgentKey": "1569377"
          +"CommonInterest": "Freehold"
          +"CoListOfficeKey": "51127"
          +"GeocodeManualYN": false
          +"TotalActualRent": 3100
          +"LivingAreaMaximum": 1500
          +"LivingAreaMinimum": 1100
          +"BedroomsAboveGrade": 3
          +"BedroomsBelowGrade": 1
          +"LeaseAmountFrequency": "Monthly"
          +"FrontageLengthNumeric": 33.1
          +"OriginalEntryTimestamp": "2026-06-15T22:48:00.53Z"
          +"FrontageLengthNumericUnits": "feet"
          +"ListAgentNationalAssociationId": "1243317"
          +"ListOfficeNationalAssociationId": "1003215"
          +"CoListAgentNationalAssociationId": "1150697"
          +"CoListOfficeNationalAssociationId": "1003215"
          +"Media": array:14 [
            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]
          ]
          +"DaysOnMarket": 6
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29907351')"
          +"ID": "1532832"
        }
        5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25198
          +post_id: "1526891"
          +post_author: 1
          +"ListingKey": "29899080"
          +"ListingId": "X13440356"
          +"PropertyType": "Residential Lease"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-12T23:25:19Z"
          +"RFModificationTimestamp": "2026-06-13T01:33:25Z"
          +"ListPrice": 0
          +"BathroomsTotalInteger": 1.0
          +"BathroomsHalf": 0
          +"BedroomsTotal": 1.0
          +"LotSizeArea": 0
          +"LivingArea": 0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V0B4"
          +"UnparsedAddress": "BASEMENT - 262 SWEET GALE STREET, Waterloo, Ontario N2V0B4"
          +"Coordinates": array:2 [
            0 => -80.592534
            1 => 43.450193
          ]
          +"Latitude": 43.450193
          +"Longitude": -80.592534
          +"YearBuilt": 0
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Toronto Regional Real Estate Board"
          +"PublicRemarks": "Welcome to the beautifully maintained basement unit at 262 Sweet Gale street, Waterloo! This exceptional 1-bedroom, 1-bathroom residence feels just like new, having been very lightly lived in and meticulously cared for. Offering a private entrance and separate access, this unit provides the perfect blend of comfort, privacy, and convenience. Step inside to discover a thoughtfully designed open-concept layout featuring a modern kitchen complete with full-size appliances, ample cabinetry, and a stylish island that doubles as the perfect dining and gathering space. The inviting living room is highlighted by a stunning accent wall with an elegant fireplace, creating a warm and welcoming atmosphere for relaxing or entertaining. The spacious bedroom offers plenty of room for a comfortable retreat, while the well-appointed 3-piece bathroom adds both functionality and style. You'll also appreciate the abundance of storage space throughout the unit, making everyday living easy and organized. Separate laundry facilities provide added convenience and independence. One parking space is included, and tenants are responsible for only 30% of utilities. Located in one of Waterloo's most sought-after neighborhoods, this home is just minutes from Costco, The Boardwalk Shopping Centre, restaurants, grocery stores, transit, top-rated schools, parks, walking trails, and countless other amenities. Whether you're a young professional, couple, small family, or someone seeking a comfortable and affordable place to call home, this property offers incredible value in an outstanding location. Opportunities like this don't come around often. Book your private showing today and experience everything this fantastic home has to offer! (id:62783)"
          +"Appliances": array:6 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Water softener"
            3 => "Dishwasher"
            4 => "Stove"
            5 => "Dryer"
          ]
          +"Basement": array:1 [
            0 => "Full"
          ]
          +"Cooling": array:2 [
            0 => "Central air conditioning"
            1 => "Air exchanger"
          ]
          +"CreationDate": "2026-06-13T01:33:22.175522+00:00"
          +"Directions": "Ladyslipper Dr To Sweetgale Street"
          +"ExteriorFeatures": array:2 [
            0 => "Brick"
            1 => "Vinyl siding"
          ]
          +"FireplaceYN": true
          +"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:2 [
            0 => "In suite Laundry"
            1 => "Sump Pump"
          ]
          +"LotSizeDimensions": "34 FT"
          +"ParkingFeatures": array:1 [
            0 => "Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-12T23:16:54Z"
          +"PhotosCount": 18
          +"Sewer": array:1 [
            0 => "Sanitary sewer"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-12T23:16:54Z"
          +"StreetName": "Sweet Gale"
          +"StreetNumber": "262"
          +"StreetSuffix": "Street"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"ListAOR": "Toronto"
          +"ListAORKey": "82"
          +"ListingURL": "www.realtor.ca/real-estate/29899080/basement-262-sweet-gale-street-waterloo"
          +"ParkingTotal": 1
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": false
          +"TotalActualRent": 1400
          +"LivingAreaMaximum": 2500
          +"LivingAreaMinimum": 2000
          +"BedroomsAboveGrade": 0
          +"BedroomsBelowGrade": 1
          +"LeaseAmountFrequency": "Monthly"
          +"FrontageLengthNumeric": 34.0
          +"OriginalEntryTimestamp": "2026-06-12T23:16:54.86Z"
          +"FrontageLengthNumericUnits": "feet"
          +"ListAgentNationalAssociationId": "1389915"
          +"ListOfficeNationalAssociationId": "1369645"
          +"Media": array:18 [
            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]
          ]
          +"DaysOnMarket": 9
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29899080')"
          +"ID": "1526891"
        }
        6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
          +post_id: "1525250"
          +post_author: 1
          +"ListingKey": "29898016"
          +"ListingId": "40839020"
          +"PropertyType": "Residential Lease"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-12T21:00:26Z"
          +"RFModificationTimestamp": "2026-06-12T21:27:08Z"
          +"ListPrice": 0
          +"BathroomsTotalInteger": 1.0
          +"BathroomsHalf": 0
          +"BedroomsTotal": 1.0
          +"LotSizeArea": 0
          +"LivingArea": 1000.0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V0B4"
          +"UnparsedAddress": "262 SWEET GALE Street Unit# Basement, Waterloo, Ontario N2V0B4"
          +"Coordinates": array:2 [
            0 => -80.5925443
            1 => 43.4502233
          ]
          +"Latitude": 43.4502233
          +"Longitude": -80.5925443
          +"YearBuilt": 2017
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
          +"PublicRemarks": "Welcome to the beautifully maintained basement unit at 262 Sweet Gale street, Waterloo! This exceptional 1-bedroom, 1-bathroom residence feels just like new, having been very lightly lived in and meticulously cared for. Offering a private entrance and separate access, this unit provides the perfect blend of comfort, privacy, and convenience. Step inside to discover a thoughtfully designed open-concept layout featuring a modern kitchen complete with full-size appliances, ample cabinetry, and a stylish island that doubles as the perfect dining and gathering space. The inviting living room is highlighted by a stunning accent wall with an elegant fireplace, creating a warm and welcoming atmosphere for relaxing or entertaining. The spacious bedroom offers plenty of room for a comfortable retreat, while the well-appointed 3-piece bathroom adds both functionality and style. You’ll also appreciate the abundance of storage space throughout the unit, making everyday living easy and organized. Separate laundry facilities provide added convenience and independence. One parking space is included, and tenants are responsible for only 30% of utilities. Located in one of Waterloo’s most sought-after neighborhoods, this home is just minutes from Costco, The Boardwalk Shopping Centre, restaurants, grocery stores, transit, top-rated schools, parks, walking trails, and countless other amenities. Whether you’re a young professional, couple, small family, or someone seeking a comfortable and affordable place to call home, this property offers incredible value in an outstanding location. Opportunities like this don’t come around often. Book your private showing today and experience everything this fantastic home has to offer! (id:62650)"
          +"Appliances": array:6 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Water softener"
            3 => "Dishwasher"
            4 => "Stove"
            5 => "Dryer"
          ]
          +"Basement": array:2 [
            0 => "Unfinished"
            1 => "Full"
          ]
          +"CommunityFeatures": array:1 [
            0 => "Quiet Area"
          ]
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-06-12T21:27:05.548279+00:00"
          +"Directions": "Ladyslipper Dr To Sweetgale Street"
          +"ExteriorFeatures": array:2 [
            0 => "Brick"
            1 => "Vinyl siding"
          ]
          +"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:3 [
            0 => "Conservation/green belt"
            1 => "Paved driveway"
            2 => "Sump Pump"
          ]
          +"PhotosChangeTimestamp": "2026-06-12T20:51:34Z"
          +"PhotosCount": 18
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-12T20:51:34Z"
          +"Stories": "2.0"
          +"StreetName": "SWEET GALE"
          +"StreetNumber": "262"
          +"StreetSuffix": "Street"
          +"SubdivisionName": "443 - Columbia Forest/Clair Hills"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:6 [
            0 => array:11 [ …11]
            1 => array:11 [ …11]
            2 => array:11 [ …11]
            3 => array:11 [ …11]
            4 => array:11 [ …11]
            5 => array:11 [ …11]
          ]
          +"ListAOR": "Cornerstone"
          +"ListAORKey": "14"
          +"ListingURL": "www.realtor.ca/real-estate/29898016/262-sweet-gale-street-unit-basement-waterloo"
          +"ParkingTotal": 1
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"TotalActualRent": 1400
          +"SecurityFeatures": array:1 [
            0 => "Alarm system"
          ]
          +"ZoningDescription": "RES4"
          +"BedroomsAboveGrade": 0
          +"BedroomsBelowGrade": 1
          +"LeaseAmountFrequency": "Monthly"
          +"FrontageLengthNumeric": 34.0
          +"AboveGradeFinishedArea": 1000
          +"OriginalEntryTimestamp": "2026-06-12T20:51:34.03Z"
          +"FrontageLengthNumericUnits": "feet"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Owner"
          +"ListAgentNationalAssociationId": "1123254"
          +"ListOfficeNationalAssociationId": "1380559"
          +"Media": array:18 [
            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]
          ]
          +"DaysOnMarket": 9
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898016')"
          +"ID": "1525250"
        }
        7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25206
          +post_id: "1523008"
          +post_author: 1
          +"ListingKey": "29893337"
          +"ListingId": "40839237"
          +"PropertyType": "Residential Lease"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-12T01:15:05Z"
          +"RFModificationTimestamp": "2026-06-12T05:34:42Z"
          +"ListPrice": 0
          +"BathroomsTotalInteger": 2.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 3.0
          +"LotSizeArea": 0
          +"LivingArea": 1976.0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V2T4"
          +"UnparsedAddress": "479 TREMBLING ASPEN Avenue, Waterloo, Ontario N2V2T4"
          +"Coordinates": array:2 [
            0 => -80.5932768
            1 => 43.4687994
          ]
          +"Latitude": 43.4687994
          +"Longitude": -80.5932768
          +"YearBuilt": 2003
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
          +"PublicRemarks": "Available for Lease AUGUST 1 2026 in Waterloo’s Top School District! Situated in one of Waterloo’s most sought-after neighbourhoods, this 3-bedroom, 2-bathroom home is just a 5-minute walk to both elementary and high schools, with easy bus access to local universities. Inside, you’ll find a functional layout with fresh updates throughout: brand-new Berber carpet on the upper level, new luxury vinyl flooring in the bathrooms, fresh paint, and modern pot lighting for a bright, contemporary feel. The open-concept kitchen flows seamlessly into the living and dining areas and is equipped with stainless steel appliances, all updated within the past five years. The upper-level family room impresses with soaring ceilings and plenty of natural light—perfect for an additional lounge or work-from-home space. The professionally landscaped front and backyard feature new sod and low-maintenance design, with a newly added walkway that can double as a second parking spot. The garage also includes a brand-new insulated door. Additional highlights include two separate living areas, an unfinished basement with laundry and rough-in for a future bathroom, and close proximity to shopping, transit, parks, and major roadways for easy commuting. This home is meticulously maintained, pet-free, and ready for its next family! (id:62783)"
          +"Appliances": array:11 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Water purifier"
            3 => "Water softener"
            4 => "Gas stove(s)"
            5 => "Range - Gas"
            6 => "Stove"
            7 => "Dryer"
            8 => "Microwave"
            9 => "Window Coverings"
            10 => "Microwave Built-in"
          ]
          +"Basement": array:2 [
            0 => "Unfinished"
            1 => "Full"
          ]
          +"BathroomsPartial": 1
          +"CommunityFeatures": array:2 [
            0 => "School Bus"
            1 => "Community Centre"
          ]
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-06-12T05:34:41.323297+00:00"
          +"Directions": "From Erbsville Road, turn west onto Laurelwood Drive, then turn left onto Blue Beech Boulevard, and finally turn right onto Trembling Aspen Avenue. The property is on the right-hand side."
          +"ExteriorFeatures": array:2 [
            0 => "Brick"
            1 => "Vinyl siding"
          ]
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "2091826"
          +"ListOfficeKey": "289541"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:3 [
            0 => "Conservation/green belt"
            1 => "Paved driveway"
            2 => "Automatic Garage Door Opener"
          ]
          +"ParkingFeatures": array:1 [
            0 => "Attached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-12T01:09:50Z"
          +"PhotosCount": 30
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-12T01:09:49Z"
          +"Stories": "2.0"
          +"StreetName": "TREMBLING ASPEN"
          +"StreetNumber": "479"
          +"StreetSuffix": "Avenue"
          +"SubdivisionName": "443 - Columbia Forest/Clair Hills"
          +"Utilities": array:1 [
            0 => "Telephone"
          ]
          +"WaterSource": array:2 [
            0 => "Municipal water"
            1 => "Unknown"
          ]
          +"Rooms": array:11 [
            0 => array:11 [ …11]
            1 => array:11 [ …11]
            2 => array:11 [ …11]
            3 => array:11 [ …11]
            4 => array:11 [ …11]
            5 => array:11 [ …11]
            6 => array:11 [ …11]
            7 => array:11 [ …11]
            8 => array:11 [ …11]
            9 => array:11 [ …11]
            10 => array:11 [ …11]
          ]
          +"ListAOR": "Cornerstone"
          +"ListAORKey": "14"
          +"ListingURL": "www.realtor.ca/real-estate/29893337/479-trembling-aspen-avenue-waterloo"
          +"ParkingTotal": 3
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"TotalActualRent": 2950
          +"SecurityFeatures": array:1 [
            0 => "Smoke Detectors"
          ]
          +"ZoningDescription": "RES-4"
          +"BedroomsAboveGrade": 3
          +"BedroomsBelowGrade": 0
          +"LeaseAmountFrequency": "Monthly"
          +"FrontageLengthNumeric": 28.0
          +"AboveGradeFinishedArea": 1406
          +"BelowGradeFinishedArea": 570
          +"OriginalEntryTimestamp": "2026-06-12T01:09:49.83Z"
          +"FrontageLengthNumericUnits": "feet"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"BelowGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Owner"
          +"BelowGradeFinishedAreaSource": "Other"
          +"ListAgentNationalAssociationId": "1364413"
          +"ListOfficeNationalAssociationId": "1378680"
          +"Media": array:30 [
            0 => array:13 [ …13]
            1 => array:13 [ …13]
            2 => array:13 [ …13]
            3 => array:13 [ …13]
            4 => array:13 [ …13]
            5 => array:13 [ …13]
            6 => array:13 [ …13]
            7 => array:13 [ …13]
            8 => array:13 [ …13]
            9 => array:13 [ …13]
            10 => array:13 [ …13]
            11 => array:13 [ …13]
            12 => array:13 [ …13]
            13 => array:13 [ …13]
            14 => array:13 [ …13]
            15 => array:13 [ …13]
            16 => array:13 [ …13]
            17 => array:13 [ …13]
            18 => array:13 [ …13]
            19 => array:13 [ …13]
            20 => array:13 [ …13]
            21 => array:13 [ …13]
            22 => array:13 [ …13]
            23 => array:13 [ …13]
            24 => array:13 [ …13]
            25 => array:13 [ …13]
            26 => array:13 [ …13]
            27 => array:13 [ …13]
            28 => array:13 [ …13]
            29 => array:13 [ …13]
          ]
          +"DaysOnMarket": 10
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29893337')"
          +"ID": "1523008"
        }
        8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25207
          +post_id: "1519777"
          +post_author: 1
          +"ListingKey": "29889657"
          +"ListingId": "40836552"
          +"PropertyType": "Residential Lease"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-15T17:35:26Z"
          +"RFModificationTimestamp": "2026-06-15T17:59:41Z"
          +"ListPrice": 0
          +"BathroomsTotalInteger": 5.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 5.0
          +"LotSizeArea": 0
          +"LivingArea": 3460.0
          +"BuildingAreaTotal": 0
          +"City": "Waterloo"
          +"PostalCode": "N2V0C4"
          +"UnparsedAddress": "757 PASTURE ROSE Street, Waterloo, Ontario N2V0C4"
          +"Coordinates": array:2 [
            0 => -80.6014022
            1 => 43.4612875
          ]
          +"Latitude": 43.4612875
          +"Longitude": -80.6014022
          +"YearBuilt": 2013
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
          +"PublicRemarks": "FOR RENT ** Welcome to 757 PASTURE ROSE ST, an exceptional, CARPET-FREE detached home available for lease in the highly desirable VISTA HILLS community of Waterloo West. This 5-BEDROOM & 4.5 BATH residence spans an impressive 3,400+ sq. ft of finished living space (2,760 above grade + 700 in the basement), perfectly blending executive luxury with everyday family functionality. The bright, open-concept main floor boasts 9-foot ceilings, a spacious living room with California shutters and a cozy fireplace, a double-sink kitchen with a Butler’s pantry + Walk-In pantry, Powder Room and a breakfast room that walks out to the backyard. Upstairs, you will find 4 large bedrooms and 3 bathrooms—including a primary bedroom with a wall-to-wall walk-in closet and private ensuite—along side a highly convenient UPPER-LEVEL LAUNDRY ROOM. The FULLY FINISHED BASEMENT adds excellent auxiliary space, featuring a massive 30-foot recreation room, an additional guest/in-law bedroom, and a full 3-piece bathroom. Outfitted with durable luxury vinyl and tile flooring throughout, this home is incredibly practical for active families and pet considerations. Outdoor living is a breeze on the large, welcoming deck within the FULLY-FENCED LARGE BACKYARD, complete with an included BBQ and patio set. Parking is effortless with a 2-car garage and a double-wide driveway accommodating a total of 4-VEHICLES PARKING. Close to top-rated schools & universities, parks, trails, Costco, Cinemas and Medical clinics, this home is ideal for corporate relocations or families seeking a move-in ready property with great landlords. Tenants pay 100% utilities and water heater rental (approx. $50/month). Applicants must provide a rental application, government ID, employment letter, 3 recent pay stubs, references, a valid Equifax credit report, a $100 key deposit, and tenant liability insurance. (id:62783)"
          +"Appliances": array:10 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Water meter"
            3 => "Water softener"
            4 => "Gas stove(s)"
            5 => "Dishwasher"
            6 => "Stove"
            7 => "Dryer"
            8 => "Hood Fan"
            9 => "Window Coverings"
          ]
          +"ArchitecturalStyle": array:1 [
            0 => "Contemporary"
          ]
          +"AssociationFeeIncludes": array:1 [
            0 => "Insurance"
          ]
          +"Basement": array:2 [
            0 => "Finished"
            1 => "Full"
          ]
          +"BathroomsPartial": 1
          +"CommunityFeatures": array:2 [
            0 => "Quiet Area"
            1 => "School Bus"
          ]
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-06-11T18:18:08.204276+00:00"
          +"Directions": "Take Columbia St W toward Vista Hills, turn onto Sundew Dr. towards the end. Take a left to Rock Elm, then 2nd right onto Pasture Rose St."
          +"ExteriorFeatures": array:2 [
            0 => "Vinyl siding"
            1 => "Brick Veneer"
          ]
          +"Fencing": array:1 [
            0 => "Fence"
          ]
          +"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": "2130641"
          +"ListOfficeKey": "283125"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:3 [
            0 => "Paved driveway"
            1 => "Automatic Garage Door Opener"
            2 => "In-Law Suite"
          ]
          +"ParkingFeatures": array:1 [
            0 => "Attached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-15T17:11:18Z"
          +"PhotosCount": 40
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-15T17:11:18Z"
          +"Stories": "2.0"
          +"StreetName": "PASTURE ROSE"
          +"StreetNumber": "757"
          +"StreetSuffix": "Street"
          +"SubdivisionName": "443 - Columbia Forest/Clair Hills"
          +"TaxAnnualAmount": "8092"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:18 [
            0 => array:11 [ …11]
            1 => array:11 [ …11]
            2 => array:11 [ …11]
            3 => array:11 [ …11]
            4 => array:11 [ …11]
            5 => array:11 [ …11]
            6 => array:11 [ …11]
            7 => array:11 [ …11]
            8 => array:11 [ …11]
            9 => array:11 [ …11]
            10 => array:11 [ …11]
            11 => array:11 [ …11]
            12 => array:11 [ …11]
            13 => array:11 [ …11]
            14 => array:11 [ …11]
            15 => array:11 [ …11]
            16 => array:11 [ …11]
            17 => array:11 [ …11]
          ]
          +"ListAOR": "Cornerstone"
          +"ListAORKey": "14"
          +"ListingURL": "www.realtor.ca/real-estate/29889657/757-pasture-rose-street-waterloo"
          +"ParkingTotal": 4
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"TotalActualRent": 4600
          +"SecurityFeatures": array:1 [
            0 => "Smoke Detectors"
          ]
          +"ZoningDescription": "R6"
          +"BedroomsAboveGrade": 4
          +"BedroomsBelowGrade": 1
          +"LeaseAmountFrequency": "Monthly"
          +"FrontageLengthNumeric": 51.0
          +"AboveGradeFinishedArea": 2760
          +"BelowGradeFinishedArea": 700
          +"OriginalEntryTimestamp": "2026-06-11T16:51:47.17Z"
          +"FrontageLengthNumericUnits": "feet"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"BelowGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Builder"
          +"BelowGradeFinishedAreaSource": "Owner"
          +"ListAgentNationalAssociationId": "1383481"
          +"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": 11
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889657')"
          +"ID": "1519777"
        }
      ]
      +success: true
      +page_size: 9
      +page_count: 2
      +count: 17
      +after_key: ""
    }
    "RF Response Time" => "0.21 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

Menu

Resources

Get Started

Contact us

Offer to Purchase Forms

Offer to Lease

Offer to Purchase Forms

Offer to Purchase Forms

Offer to Lease

How It Works

MLS On The Fly Debug Panel

MLS On The Fly Debug Panel

MLS On The Fly Debug Panel