array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29886750 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23274
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23272
+post_id: "1518314"
+post_author: 1
+"ListingKey": "29886750"
+"ListingId": "40838535"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T02:10:13Z"
+"RFModificationTimestamp": "2026-06-11T06:36:34Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1200.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T0B2"
+"UnparsedAddress": "831 PARIS Boulevard, Waterloo, Ontario N2T0B2"
+"Coordinates": array:2 [
0 => -80.5764073
1 => 43.4479671
]
+"Latitude": 43.4479671
+"Longitude": -80.5764073
+"YearBuilt": 2014
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Clair Meadows, an exclusive community of luxury townhomes ideally located near Ira Needles and Erb Street in Waterloo. This bright and spacious 3-bedroom, 1.5 bathroom home features a large primary suite, two additional generous bedrooms, and a modern layout designed for comfort. The gourmet kitchen offers granite countertops, stainless steel appliances, and ample cabinetry, opening to an inviting dining area and great room with engineered hardwood flooring. Additional highlights include a main-floor powder room, second-floor full bath, central air, high-efficiency gas heating, air exchanger, water softener, and five included appliances. Enjoy outdoor living on your private patio with privacy fence, plus a single-car garage with inside entry, driveway parking, and a spacious unfinished basement. Professionally landscaped grounds and lawn maintenance are included. Zoned FR, allowing home professions, and located steps from Edna Staebler Public School, shopping, restaurants, and The Boardwalk. No student rentals. Shows AAA! (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T06:36:27.546754+00:00"
+"Directions": "Erbsville to Brandenburg to Paris Blvd"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1962973"
+"ListOfficeKey": "259258"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T01:49:32Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T02:01:41Z"
+"Stories": "2.0"
+"StreetName": "PARIS"
+"StreetNumber": "831"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1656743520"
"RoomType" => "4pc Bathroom"
"ListingId" => "40838535"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29886750"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T02:01:41.06Z"
]
1 => array:11 [
"RoomKey" => "1656743521"
"RoomType" => "Bedroom"
"ListingId" => "40838535"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29886750"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 12'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T02:01:41.06Z"
]
2 => array:11 [
"RoomKey" => "1656743522"
"RoomType" => "Bedroom"
"ListingId" => "40838535"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29886750"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T02:01:41.06Z"
]
3 => array:11 [
"RoomKey" => "1656743523"
"RoomType" => "Primary Bedroom"
"ListingId" => "40838535"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29886750"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T02:01:41.06Z"
]
4 => array:11 [
"RoomKey" => "1656743526"
"RoomType" => "Kitchen"
"ListingId" => "40838535"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29886750"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T02:01:41.06Z"
]
5 => array:11 [
"RoomKey" => "1656743528"
"RoomType" => "Living room"
"ListingId" => "40838535"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29886750"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 21'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T02:01:41.06Z"
]
6 => array:11 [
"RoomKey" => "1656743531"
"RoomType" => "2pc Bathroom"
"ListingId" => "40838535"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29886750"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T02:01:41.06Z"
]
7 => array:11 [
"RoomKey" => "1656743533"
"RoomType" => "Foyer"
"ListingId" => "40838535"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29886750"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T02:01:41.06Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29886750/831-paris-boulevard-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2750
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1200
+"OriginalEntryTimestamp": "2026-06-11T01:49:32.79Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1252469"
+"ListOfficeNationalAssociationId": "1217708"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29886750_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/7e82bf27ec043c99ec58f9391bfd5824.webp"
"MediaSize" => 127996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-7e82bf27ec043c99ec58f9391bfd5824.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick and siding exterior featuring gabled rooflines, gray garage doors, a covered front entry with a black railing, and arched upper windows"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29886750_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/a3dbcf43234d4808109828e65a62b9b7.webp"
"MediaSize" => 136150
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-a3dbcf43234d4808109828e65a62b9b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29886750_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/8f4732b6dbf915c7c1dba56d4fa36d6f.webp"
"MediaSize" => 63646
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-8f4732b6dbf915c7c1dba56d4fa36d6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Foyer featuring multi-toned tile flooring, a wood-finish staircase with white risers, a white paneled door, and a recessed ceiling light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29886750_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/dd24826abda15c4ea95ad02bd7a94afc.webp"
"MediaSize" => 69104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-dd24826abda15c4ea95ad02bd7a94afc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted staircase with wood-finish handrail and newel post"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29886750_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/ee26f67eb26e9a540226f70e6829c883.webp"
"MediaSize" => 45888
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-ee26f67eb26e9a540226f70e6829c883.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Pedestal sink with chrome faucet and rectangular mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29886750_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/23729a5ad197d4db6a939c20e6e17cff.webp"
"MediaSize" => 62800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-23729a5ad197d4db6a939c20e6e17cff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring, a kitchen island with seating, dark wood cabinetry, stainless steel appliances, and a sliding glass door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29886750_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/dc104f7a356ef4a09a0f95cebc3098a1.webp"
"MediaSize" => 70322
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-dc104f7a356ef4a09a0f95cebc3098a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring, a kitchen with dark cabinetry, stainless steel appliances, and a central island with a sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29886750_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/053618027390601679f55288ee6cfc24.webp"
"MediaSize" => 56598
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-053618027390601679f55288ee6cfc24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29886750_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/a52c20ee437e9d27af08f21031cbb83a.webp"
"MediaSize" => 70321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-a52c20ee437e9d27af08f21031cbb83a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29886750_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/55fdf97c954448e55bb907eaa57d60c3.webp"
"MediaSize" => 60589
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-55fdf97c954448e55bb907eaa57d60c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring dark wood-finish cabinetry, light speckled countertops, a white subway tile backsplash, and stainless steel appliances"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29886750_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/6312fb4eeb4ee08de2a2c5df2b47fa20.webp"
"MediaSize" => 65567
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-6312fb4eeb4ee08de2a2c5df2b47fa20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring a breakfast bar with stone countertop, stainless steel appliances, wood-finish cabinetry, and subway tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29886750_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/bc9ec69e00c8662deb1fd7554e3cd0ca.webp"
"MediaSize" => 47023
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-bc9ec69e00c8662deb1fd7554e3cd0ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious interior room featuring wood-finish flooring, white baseboards, and neutral wall tones"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29886750_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/83e14956e67ff0e77a1f844ee9978e63.webp"
"MediaSize" => 73714
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-83e14956e67ff0e77a1f844ee9978e63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring granite-style countertops, stainless steel appliances, wood-finish cabinetry, a white subway tile backsplash, and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29886750_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/0d4d9c61fc92d8c17b445cffcf3faff5.webp"
"MediaSize" => 68297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-0d4d9c61fc92d8c17b445cffcf3faff5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen island featuring a double basin stainless steel sink with a high-arc faucet, integrated stainless steel dishwasher, dark wood-finish cabinetry, and a light-colored speckled countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29886750_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/e74cdc81a820f406d76d0a23cab4608b.webp"
"MediaSize" => 53557
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-e74cdc81a820f406d76d0a23cab4608b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring light-colored carpet flooring, white painted walls, and multiple windows with blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29886750_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/c5a645aaf634a1c8c71fd28234aa843c.webp"
"MediaSize" => 71298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-c5a645aaf634a1c8c71fd28234aa843c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29886750_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/7f79bb2591667611244d564985e8fd1a.webp"
"MediaSize" => 57410
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-7f79bb2591667611244d564985e8fd1a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a glass-enclosed shower with white subway tile, a vanity with a dark wood-finish cabinet, a built-in sink, and a countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29886750_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/642662534d4f90b2ba350a09e65f8a24.webp"
"MediaSize" => 32045
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-642662534d4f90b2ba350a09e65f8a24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Shower enclosure with clear glass doors, white subway tile surround, and a rain showerhead"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29886750_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/49a32eb048a53da81ea187b7a0531f40.webp"
"MediaSize" => 59122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-49a32eb048a53da81ea187b7a0531f40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring light gray carpet, white painted walls, a flush-mount ceiling light fixture, and a single window with white blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29886750_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/e934d3210fb036788e9d1507d968d420.webp"
"MediaSize" => 73757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-e934d3210fb036788e9d1507d968d420.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29886750_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/6da843e7432144b42f80a3055a89e479.webp"
"MediaSize" => 64852
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-6da843e7432144b42f80a3055a89e479.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted room featuring a single window with horizontal blinds, white baseboards, a flat-panel door, and a flush-mount ceiling light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29886750_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/1ae6b812c6e6ce1aa58c21ab8ac2180e.webp"
"MediaSize" => 58996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-1ae6b812c6e6ce1aa58c21ab8ac2180e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary bathroom featuring a vanity with a stone-finish countertop and undermount sink, complementing the patterned flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29886750_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/602791d1e7e109d8c8b837722f64ed49.webp"
"MediaSize" => 40372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-602791d1e7e109d8c8b837722f64ed49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry area featuring a washer and dryer, wire shelving, and durable tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29886750_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/ef7f62fc973a78cf941c9676e84e1227.webp"
"MediaSize" => 96073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-ef7f62fc973a78cf941c9676e84e1227.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfinished basement featuring insulated walls, exposed ceiling joists, concrete flooring, a water heater, and a small casement window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29886750_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/667f5bba509a85103a715789ba8355f1.webp"
"MediaSize" => 91880
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-667f5bba509a85103a715789ba8355f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfinished basement with concrete flooring, exposed ceiling joists, and insulated perimeter walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29886750_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/d80410edaedbe8544bd3ec6b173e69e0.webp"
"MediaSize" => 92086
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-d80410edaedbe8544bd3ec6b173e69e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfinished basement featuring exposed wood joists, pink insulation, concrete flooring, a utility sink, and visible plumbing and ductwork"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29886750_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/a3f894521083421873602bf30b6df129.webp"
"MediaSize" => 115327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-a3f894521083421873602bf30b6df129.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive grassy yard area featuring a wooden privacy fence, mature evergreen trees, and a wooden deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29886750_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/13416f291fc0b6ef4f9d8f07411f1019.webp"
"MediaSize" => 128976
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-13416f291fc0b6ef4f9d8f07411f1019.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive green lawn with a full perimeter wood privacy fence"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29886750_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/376ce37980cfe172e6b495d5f376322e.webp"
"MediaSize" => 128976
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-376ce37980cfe172e6b495d5f376322e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive green lawn with a full perimeter wood privacy fence"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29886750_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/32aac07ec7a039f2c98a3aeaae55ee1a.webp"
"MediaSize" => 139308
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-32aac07ec7a039f2c98a3aeaae55ee1a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive grass lawn bordered by multi-level townhomes"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29886750_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29886750/38c8cc94418502b2a878ce59c9193b43.webp"
"MediaSize" => 130390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29886750/thumbnail-38c8cc94418502b2a878ce59c9193b43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exterior featuring brick and vertical siding, a rear wood deck, sliding glass door access, multiple windows, and a landscaped lawn"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838535"
"ResourceRecordKey" => "29886750"
"ModificationTimestamp" => "2026-06-11T01:49:32.8Z"
]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29886750')"
+"ID": "1518314"
}
]
+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 259258" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24590
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1962973" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24614
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29886750'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24850
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29886750'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24866
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29886750' 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.5764073 43.4479671)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24915
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24909
+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 [
"Order" => 1
"MediaKey" => "29899080_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899080/111ea2e9170b85e2ad1609e4adabfdee.webp"
"MediaSize" => 316324
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899080/thumbnail-111ea2e9170b85e2ad1609e4adabfdee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13440356"
"ResourceRecordKey" => "29899080"
"ModificationTimestamp" => "2026-06-12T23:16:54.87Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29899080_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899080/d951d5b690ef69744386c4b2ac7b744a.webp"
"MediaSize" => 91935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899080/thumbnail-d951d5b690ef69744386c4b2ac7b744a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440356"
"ResourceRecordKey" => "29899080"
"ModificationTimestamp" => "2026-06-12T23:16:54.87Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29899080_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899080/66bf9a892799b0cf1339d72a75624102.webp"
"MediaSize" => 106461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899080/thumbnail-66bf9a892799b0cf1339d72a75624102.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440356"
"ResourceRecordKey" => "29899080"
"ModificationTimestamp" => "2026-06-12T23:16:54.87Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29899080_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899080/4623ed1850b1316d2a0cdbffabd9bf3b.webp"
"MediaSize" => 152633
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899080/thumbnail-4623ed1850b1316d2a0cdbffabd9bf3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440356"
"ResourceRecordKey" => "29899080"
"ModificationTimestamp" => "2026-06-12T23:16:54.87Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29899080_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899080/42637d9435ecdab6872c6a49394bcde3.webp"
"MediaSize" => 203392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899080/thumbnail-42637d9435ecdab6872c6a49394bcde3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440356"
"ResourceRecordKey" => "29899080"
"ModificationTimestamp" => "2026-06-12T23:16:54.87Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29899080_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899080/ff7e6535d31cd82fc6133f5ac66db538.webp"
"MediaSize" => 118847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899080/thumbnail-ff7e6535d31cd82fc6133f5ac66db538.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440356"
"ResourceRecordKey" => "29899080"
"ModificationTimestamp" => "2026-06-12T23:16:54.87Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29899080_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899080/742b0ee8a5c2df4076e75d6eb1c7a4a3.webp"
"MediaSize" => 140572
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899080/thumbnail-742b0ee8a5c2df4076e75d6eb1c7a4a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440356"
"ResourceRecordKey" => "29899080"
"ModificationTimestamp" => "2026-06-12T23:16:54.87Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29899080_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899080/39f2e12949b9bf61a8e4e5fcc5e5e9ac.webp"
"MediaSize" => 142526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899080/thumbnail-39f2e12949b9bf61a8e4e5fcc5e5e9ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440356"
"ResourceRecordKey" => "29899080"
"ModificationTimestamp" => "2026-06-12T23:16:54.87Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29899080_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899080/ba16ea791d0e9053779edfee34c67629.webp"
"MediaSize" => 119029
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899080/thumbnail-ba16ea791d0e9053779edfee34c67629.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440356"
"ResourceRecordKey" => "29899080"
"ModificationTimestamp" => "2026-06-12T23:16:54.87Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29899080_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899080/40eb844ee5ff7411225dc814e924a41d.webp"
"MediaSize" => 126009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899080/thumbnail-40eb844ee5ff7411225dc814e924a41d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440356"
"ResourceRecordKey" => "29899080"
"ModificationTimestamp" => "2026-06-12T23:16:54.87Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29899080_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899080/e586f098b9160218e5a596a44d3d3305.webp"
"MediaSize" => 121575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899080/thumbnail-e586f098b9160218e5a596a44d3d3305.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440356"
"ResourceRecordKey" => "29899080"
"ModificationTimestamp" => "2026-06-12T23:16:54.87Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29899080_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899080/251f07f9620ef04fb2721d1699d9e7a2.webp"
"MediaSize" => 162105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899080/thumbnail-251f07f9620ef04fb2721d1699d9e7a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440356"
"ResourceRecordKey" => "29899080"
"ModificationTimestamp" => "2026-06-12T23:16:54.87Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29899080_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899080/3683e2dfaf51f089ac256932fb8a9b86.webp"
"MediaSize" => 143639
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899080/thumbnail-3683e2dfaf51f089ac256932fb8a9b86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440356"
"ResourceRecordKey" => "29899080"
"ModificationTimestamp" => "2026-06-12T23:16:54.87Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29899080_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899080/57c64dfea3692e0e3e3b5ae81cff3214.webp"
"MediaSize" => 146260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899080/thumbnail-57c64dfea3692e0e3e3b5ae81cff3214.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440356"
"ResourceRecordKey" => "29899080"
"ModificationTimestamp" => "2026-06-12T23:16:54.87Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29899080_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899080/a97e30059148da7995df1c5017009069.webp"
"MediaSize" => 144115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899080/thumbnail-a97e30059148da7995df1c5017009069.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440356"
"ResourceRecordKey" => "29899080"
"ModificationTimestamp" => "2026-06-12T23:16:54.87Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29899080_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899080/c949cdf2d86c29357da6477e12ced80d.webp"
"MediaSize" => 142996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899080/thumbnail-c949cdf2d86c29357da6477e12ced80d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440356"
"ResourceRecordKey" => "29899080"
"ModificationTimestamp" => "2026-06-12T23:16:54.87Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29899080_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899080/8631e77526b913a4dc88b73f9ddd0e1f.webp"
"MediaSize" => 141636
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899080/thumbnail-8631e77526b913a4dc88b73f9ddd0e1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440356"
"ResourceRecordKey" => "29899080"
"ModificationTimestamp" => "2026-06-12T23:16:54.87Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29899080_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899080/7c4668c5ff9e7ddd6b6d984f8aa7fadf.webp"
"MediaSize" => 359834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899080/thumbnail-7c4668c5ff9e7ddd6b6d984f8aa7fadf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440356"
"ResourceRecordKey" => "29899080"
"ModificationTimestamp" => "2026-06-12T23:16:54.87Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29899080')"
+"ID": "1526891"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24911
+post_id: "1527621"
+post_author: 1
+"ListingKey": "29897726"
+"ListingId": "40839431"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T20:20:10Z"
+"RFModificationTimestamp": "2026-06-13T00:05:16Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1751.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2X8"
+"UnparsedAddress": "428 BERNAY Drive, Waterloo, Ontario N2T2X8"
+"Coordinates": array:2 [
0 => -80.5759443
1 => 43.4509368
]
+"Latitude": 43.4509368
+"Longitude": -80.5759443
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located in one of Waterloo’s most sought-after and family-friendly neighbourhoods, this well-maintained home offers convenience, comfort, and excellent access to everyday amenities. **Property Features:** * 3 spacious bedrooms * 3 bathrooms (1 full bathroom and 2 powder rooms) * Finished basement providing additional living space * Fully fenced backyard with a large deck – perfect for entertaining and family gatherings * Bright and functional layout ideal for families **Outstanding Location:** * Minutes to Costco, The Boardwalk Shopping Centre, Canadian Tire, Starbucks, Tim Hortons, and numerous restaurants * Convenient access to public transit with bus routes nearby * Close to parks, trails, and community amenities * Steps to an elementary school – perfect for young families * Easy access to universities, shopping, and major roadways Enjoy the perfect combination of a quiet residential setting and urban convenience in West Waterloo. This is an excellent opportunity for families seeking a welcoming community and a convenient lifestyle. (id:62783)"
+"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": 2
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T00:05:11.284710+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2162407"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T20:10:40Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T20:10:40Z"
+"Stories": "2.0"
+"StreetName": "BERNAY"
+"StreetNumber": "428"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1657947517"
"RoomType" => "2pc Bathroom"
"ListingId" => "40839431"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29897726"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T20:10:40.21Z"
]
1 => array:11 [
"RoomKey" => "1657947518"
"RoomType" => "Utility room"
"ListingId" => "40839431"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29897726"
"RoomLength" => null
"RoomDimensions" => "5'4'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T20:10:40.21Z"
]
2 => array:11 [
"RoomKey" => "1657947519"
"RoomType" => "Recreation room"
"ListingId" => "40839431"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29897726"
"RoomLength" => null
"RoomDimensions" => "15'6'' x 17'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T20:10:40.21Z"
]
3 => array:11 [
"RoomKey" => "1657947520"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839431"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29897726"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T20:10:40.21Z"
]
4 => array:11 [
"RoomKey" => "1657947521"
"RoomType" => "Bedroom"
"ListingId" => "40839431"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29897726"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T20:10:40.21Z"
]
5 => array:11 [
"RoomKey" => "1657947522"
"RoomType" => "Bedroom"
"ListingId" => "40839431"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29897726"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T20:10:40.21Z"
]
6 => array:11 [
"RoomKey" => "1657947523"
"RoomType" => "Primary Bedroom"
"ListingId" => "40839431"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29897726"
"RoomLength" => null
"RoomDimensions" => "14'7'' x 15'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T20:10:40.21Z"
]
7 => array:11 [
"RoomKey" => "1657947524"
"RoomType" => "2pc Bathroom"
"ListingId" => "40839431"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29897726"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T20:10:40.22Z"
]
8 => array:11 [
"RoomKey" => "1657947525"
"RoomType" => "Kitchen"
"ListingId" => "40839431"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29897726"
"RoomLength" => null
"RoomDimensions" => "8'7'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T20:10:40.22Z"
]
9 => array:11 [
"RoomKey" => "1657947526"
"RoomType" => "Dining room"
"ListingId" => "40839431"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29897726"
"RoomLength" => null
"RoomDimensions" => "7'9'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T20:10:40.22Z"
]
10 => array:11 [
"RoomKey" => "1657947527"
"RoomType" => "Living room"
"ListingId" => "40839431"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29897726"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T20:10:40.22Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29897726/428-bernay-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2950
+"ZoningDescription": "A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1401
+"BelowGradeFinishedArea": 350
+"OriginalEntryTimestamp": "2026-06-12T20:10:40.19Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1413428"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:29 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29897726_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/3b3065dd588ef2bad60ae4c936bac266.webp"
"MediaSize" => 128109
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-3b3065dd588ef2bad60ae4c936bac266.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring a brick and siding exterior"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839431"
"ResourceRecordKey" => "29897726"
"ModificationTimestamp" => "2026-06-12T20:10:40.2Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29897726_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/926149af204d895106916416846d0134.webp"
"MediaSize" => 64703
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-926149af204d895106916416846d0134.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839431"
"ResourceRecordKey" => "29897726"
"ModificationTimestamp" => "2026-06-12T20:10:40.2Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29897726_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/2a527b995e7e1d46d8ddafdae1c4a7e6.webp"
"MediaSize" => 55504
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-2a527b995e7e1d46d8ddafdae1c4a7e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839431"
"ResourceRecordKey" => "29897726"
"ModificationTimestamp" => "2026-06-12T20:10:40.2Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29897726_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/62b71987b4f752421cd0a7c1a4a76514.webp"
"MediaSize" => 86475
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-62b71987b4f752421cd0a7c1a4a76514.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring wood-finish cabinetry, tile flooring, and a stainless steel dishwasher"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839431"
"ResourceRecordKey" => "29897726"
"ModificationTimestamp" => "2026-06-12T20:10:40.2Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29897726_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/4c841d35354496651a3370d41b31c582.webp"
"MediaSize" => 91379
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-4c841d35354496651a3370d41b31c582.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring wood-finish cabinetry, tile flooring, a window with horizontal blinds, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839431"
"ResourceRecordKey" => "29897726"
"ModificationTimestamp" => "2026-06-12T20:10:40.2Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29897726_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/7f16b86256f560ada431f5ab06a79e25.webp"
"MediaSize" => 83463
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-7f16b86256f560ada431f5ab06a79e25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen and dining area featuring light wood cabinetry, white appliances, and a tiled floor"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839431"
"ResourceRecordKey" => "29897726"
"ModificationTimestamp" => "2026-06-12T20:10:40.2Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29897726_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/dc6f7151b93cee675350521562a2aeb2.webp"
"MediaSize" => 89635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-dc6f7151b93cee675350521562a2aeb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring light wood cabinetry, a double basin stainless steel sink, a tile backsplash, and a built-in dishwasher"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839431"
"ResourceRecordKey" => "29897726"
"ModificationTimestamp" => "2026-06-12T20:10:40.2Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29897726_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/b0664c0f253f217eed0c0651550267d1.webp"
"MediaSize" => 94306
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-b0664c0f253f217eed0c0651550267d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring wood-finish flooring and neutral wall tones"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839431"
"ResourceRecordKey" => "29897726"
"ModificationTimestamp" => "2026-06-12T20:10:40.2Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29897726_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/a73c26415dd69ca445eea2d86a9da522.webp"
"MediaSize" => 97431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-a73c26415dd69ca445eea2d86a9da522.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring wood-finish flooring, a ceiling fan, and ample natural light from a large window and sliding glass door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839431"
"ResourceRecordKey" => "29897726"
"ModificationTimestamp" => "2026-06-12T20:10:40.2Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29897726_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/27a2ebe7b8cfc29b334493a024e0ba8d.webp"
"MediaSize" => 81993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-27a2ebe7b8cfc29b334493a024e0ba8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring a modern pendant light fixture, large window with blinds, and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839431"
"ResourceRecordKey" => "29897726"
"ModificationTimestamp" => "2026-06-12T20:10:40.2Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29897726_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/62c0b2be9f107777da5d7aafa3f4c177.webp"
"MediaSize" => 96895
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-62c0b2be9f107777da5d7aafa3f4c177.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring wood-finish flooring, a ceiling fan with integrated lighting, and a defined kitchen space with tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839431"
"ResourceRecordKey" => "29897726"
"ModificationTimestamp" => "2026-06-12T20:10:40.2Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29897726_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/d101f02bdd11fe4dffd62176206accb6.webp"
"MediaSize" => 32072
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-d101f02bdd11fe4dffd62176206accb6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Powder room featuring a ceramic toilet, tiled flooring, and a window with sheer curtain"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839431"
"ResourceRecordKey" => "29897726"
"ModificationTimestamp" => "2026-06-12T20:10:40.2Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29897726_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/c4951951c3c081caeb0cff1a04e63cf6.webp"
"MediaSize" => 28807
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-c4951951c3c081caeb0cff1a04e63cf6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Pedestal sink with brass-finish faucet, framed mirror, and dual-bulb wall sconce"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839431"
"ResourceRecordKey" => "29897726"
"ModificationTimestamp" => "2026-06-12T20:10:40.2Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29897726_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/eea983d4a2d4c369e4de33dcd71b1023.webp"
"MediaSize" => 78248
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-eea983d4a2d4c369e4de33dcd71b1023.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring a large window, wall-mounted sconces, and a flush-mount ceiling light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839431"
"ResourceRecordKey" => "29897726"
"ModificationTimestamp" => "2026-06-12T20:10:40.2Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29897726_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/c3913b78b732e3fa1f86f58ac4e57d6a.webp"
"MediaSize" => 79124
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-c3913b78b732e3fa1f86f58ac4e57d6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring neutral-toned carpeting and light-colored walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839431"
"ResourceRecordKey" => "29897726"
"ModificationTimestamp" => "2026-06-12T20:10:40.2Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29897726_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/8b51146bc6d13169c81b0fa0881e823d.webp"
"MediaSize" => 85898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-8b51146bc6d13169c81b0fa0881e823d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright interior space featuring a window with dark curtains, a built-in ceiling light fixture, and light-colored carpeting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839431"
"ResourceRecordKey" => "29897726"
"ModificationTimestamp" => "2026-06-12T20:10:40.2Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29897726_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/7113dfa6ef50de82c2cf667f407924fb.webp"
"MediaSize" => 82159
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-7113dfa6ef50de82c2cf667f407924fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring neutral wall paint, textured ceiling, a ceiling-mounted light fixture, and carpet flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839431"
"ResourceRecordKey" => "29897726"
"ModificationTimestamp" => "2026-06-12T20:10:40.2Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29897726_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/cc298098eb61085ae08e91194af08401.webp"
"MediaSize" => 84264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-cc298098eb61085ae08e91194af08401.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted room featuring a white ceiling, overhead flush-mount light fixture, and two-tone painted walls with a chair rail"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839431"
"ResourceRecordKey" => "29897726"
"ModificationTimestamp" => "2026-06-12T20:10:40.2Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29897726_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/5528dfe2f13038db065f5b5d8eeeecf8.webp"
"MediaSize" => 95552
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-5528dfe2f13038db065f5b5d8eeeecf8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Window with outdoor greenery, light-colored walls, recessed ceiling lighting, wall-mounted artwork, and a built-in storage unit"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839431"
"ResourceRecordKey" => "29897726"
"ModificationTimestamp" => "2026-06-12T20:10:40.2Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29897726_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/1f31ec17135066f6d858df9e0925ff21.webp"
"MediaSize" => 87194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-1f31ec17135066f6d858df9e0925ff21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a vanity with a light-toned countertop and wood-finish cabinetry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839431"
"ResourceRecordKey" => "29897726"
"ModificationTimestamp" => "2026-06-12T20:10:40.2Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29897726_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/dfb3886db0474eaf7cfeb2a9fc6fc599.webp"
"MediaSize" => 65812
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-dfb3886db0474eaf7cfeb2a9fc6fc599.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted staircase and hallway featuring recessed lighting and a built-in vanity with a dark wood-finish base and framed mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839431"
"ResourceRecordKey" => "29897726"
"ModificationTimestamp" => "2026-06-12T20:10:40.2Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29897726_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/94e1c3a73bb5c5c5735fb50b71493bab.webp"
"MediaSize" => 38208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-94e1c3a73bb5c5c5735fb50b71493bab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Powder room featuring a dark wood vanity with white countertop and integrated sink, framed mirror, wall-mounted faucet, and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839431"
"ResourceRecordKey" => "29897726"
"ModificationTimestamp" => "2026-06-12T20:10:40.2Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29897726_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897726/3409b84659b0cb9cf9650d1c106f0c0b.webp"
"MediaSize" => 56028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897726/thumbnail-3409b84659b0cb9cf9650d1c106f0c0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway featuring carpet flooring, recessed lighting, white trim, and panel doors"
"PreferredPhotoYN" => false
…3
]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29897726')"
+"ID": "1527621"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24908
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898016')"
+"ID": "1525250"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24912
+post_id: "1522952"
+post_author: 1
+"ListingKey": "29893806"
+"ListingId": "40838863"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T05:10:05Z"
+"RFModificationTimestamp": "2026-06-12T06:28:02Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2158.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2B2"
+"UnparsedAddress": "289 WESTVALE Drive, Waterloo, Ontario N2T2B2"
+"Coordinates": array:2 [
0 => -80.5598085
1 => 43.4428496
]
+"Latitude": 43.4428496
+"Longitude": -80.5598085
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 289 Westvale Drive, Waterloo. This beautifully updated home offers an excellent leasing opportunity in one of Waterloo’s most desirable family oriented neighbourhoods. The standout features of this location is its exceptional convenience for families. The home is situated close to four schools, including a highly regarded French Immersion school, with another school within walking distance. This makes daily routines easier and adds tremendous value for families with children. The house is recently renovated throughout, the property features a modern kitchen equipped with stainless steel appliances, including a refrigerator, stove, and dishwasher. The spacious main floor offers a functional layout with a separate family room, a combined living and dining area, a large kitchen, and convenient main floor laundry. The primary bedroom includes a walk in closet and a private ensuite bathroom, while the additional bedrooms are generously sized and provide ample space for the whole family. The finished basement adds valuable living space, perfect for a recreation room, home office, or play area. Enjoy outdoor living in the fully fenced backyard, featuring a large deck accessible directly from the kitchen through sliding doors, making it ideal for entertaining, relaxing, or spending time with family. Residents will also appreciate the nearby large park, scenic walking trails, and the welcoming community atmosphere that makes Westvale one of Waterloo’s most sought after neighbourhoods. Additional features include a gas fireplace, central air conditioning, and a double car garage. Ideally located close to The Boardwalk at Ira Needles, universities, shopping, restaurants, parks, schools, and major amenities, this home offers comfort, convenience, and an exceptional lifestyle in a friendly and established community. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "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-12T06:27:53.734201+00:00"
+"Directions": "Thorndale Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2181659"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T05:01:50Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T05:01:50Z"
+"Stories": "2.0"
+"StreetName": "WESTVALE"
+"StreetNumber": "289"
+"StreetSuffix": "Drive"
+"SubdivisionName": "439 - Westvale"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29893806/289-westvale-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3500
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 47.0
+"AboveGradeFinishedArea": 1581
+"BelowGradeFinishedArea": 577
+"OriginalEntryTimestamp": "2026-06-12T05:01:50.18Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1431441"
+"ListOfficeNationalAssociationId": "1389824"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29893806')"
+"ID": "1522952"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24910
+post_id: "1518424"
+post_author: 1
+"ListingKey": "29886985"
+"ListingId": "40838859"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T03:40:06Z"
+"RFModificationTimestamp": "2026-06-11T06:28:43Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1178.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0J1"
+"UnparsedAddress": "142 FOAMFLOWER Place Unit# 7, Waterloo, Ontario N2V0J1"
+"Coordinates": array:2 [
0 => -80.5881507
1 => 43.4499201
]
+"Latitude": 43.4499201
+"Longitude": -80.5881507
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained stacked townhouse in the highly desirable Clair Hills community of Waterloo! This bright and functional home features 2 bedrooms and 2.5 bathrooms with a modern open-concept layout and large windows that fill the space with natural light. The kitchen offers stainless steel appliances, ample cabinetry, and a spacious island perfect for everyday living and entertaining. Upstairs, you’ll find spacious bedrooms including a primary suite with ensuite bath and generous closet space. Additional features include in-suite laundry, a private balcony, and one parking spot. Conveniently located close to Costco, The Boardwalk, universities, schools, parks, trails, and public transit. Ideal for professionals, couples, or small families looking for a comfortable home in a prime Waterloo location. Tenant responsible for utilities. Available after July 15, 2026. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T06:28:36.913705+00:00"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2168691"
+"ListOfficeKey": "253316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-11T03:30:21Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T03:30:21Z"
+"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/29886985/142-foamflower-place-unit-7-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2550
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1178
+"OriginalEntryTimestamp": "2026-06-11T03:30:21.09Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1419376"
+"ListOfficeNationalAssociationId": "1223329"
+"Media": array:13 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29886985')"
+"ID": "1518424"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24905
+post_id: "1518442"
+post_author: 1
+"ListingKey": "29886681"
+"ListingId": "X13429250"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T13:25:10Z"
+"RFModificationTimestamp": "2026-06-11T13:28:15Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B6"
+"UnparsedAddress": "445 AVENS STREET, Waterloo, Ontario N2V0B6"
+"Coordinates": array:2 [
0 => -80.596467
1 => 43.453819
]
+"Latitude": 43.453819
+"Longitude": -80.596467
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "445 Avens Street is a rare offering in the heart of Vista Hills-an address that captures the essence of modern Waterloo living with confidence, style, and undeniable potential. Thoughtfully designed and effortlessly livable, this residence balances clean architectural lines with warm, inviting spaces that feel as good as they look. Natural light pours through the home, animating every corner and enhancing a layout created for both connection and quiet retreat. The main level unfolds with ease-an open, contemporary setting where daily life and entertaining exist in perfect harmony. At its centre, a refined kitchen anchors the space, equal parts function and design, ready to host everything from casual mornings to unforgettable evenings. Above, three well-appointed bedrooms offers comfort without compromise. The primary suite is a calm and elevated escape, complete with its own ensuite and walk-in closet-a space designed to recharge and reset. Beyond the interiors, the home continues to impress. Set against a quiet residential backdrop, the outdoor space offers a sense of calm rarely found at this price point-an everyday luxury that enhances how the home is lived and experienced. The lower level remains untouched-a canvas of opportunity, inviting future owners to expand, create, and add lasting value. Positioned just moments from The Boardwalk, Costco Wholesale, and the academic and cultural energy of University of Waterloo and Wilfrid Laurier University, this is a location defined by convenience, growth, and community. This is more than a home-it's a smart, stylish foothold in one of Waterloo's most desirable neighbourhoods. A place to grow, invest, and thrive.445 Avens Street is not just an opportunity. It's a move forward. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T03:12:13.275388+00:00"
+"Directions": "SUNDEW DR / WILD CALLA ST"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2197711"
+"ListOfficeKey": "280684"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "28.7 x 119.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T01:12:52Z"
+"PhotosCount": 38
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T13:16:18Z"
+"Stories": "2.0"
+"StreetName": "Avens"
+"StreetNumber": "445"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29886681/445-avens-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3000
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 28.8
+"OriginalEntryTimestamp": "2026-06-11T01:12:52.65Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1446160"
+"ListOfficeNationalAssociationId": "1316438"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29886681')"
+"ID": "1518442"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23260
+post_id: "1509120"
+post_author: 1
+"ListingKey": "29872296"
+"ListingId": "X13416402"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T20:26:05Z"
+"RFModificationTimestamp": "2026-06-08T23:20:40Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2X8"
+"UnparsedAddress": "506 CHABLIS DRIVE, Waterloo, Ontario N2T2X8"
+"Coordinates": array:2 [
0 => -80.57555
1 => 43.450552
]
+"Latitude": 43.450552
+"Longitude": -80.57555
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this bright and inviting 3-bedroom, 1.5-bathroom home for lease, ideally located in a family-friendly neighbourhood. The carpet-free main floor is filled with natural light from large windows, creating a warm and welcoming atmosphere throughout. A spacious great room provides the perfect setting for relaxing, entertaining, or spending time with family. The large kitchen offers ample counter space and abundant cabinetry, making meal preparation and storage effortless. Upstairs, you'll find three spacious bedrooms, including a generous primary bedroom featuring two closets for excellent storage. The functional layout provides comfortable living space for families and professionals alike. Step outside to enjoy the fully fenced, generously sized backyard-ideal for children, pets, gardening, or outdoor gatherings. Conveniently situated just steps from Edna Staebler Public School and close to parks, shopping centres, and expressway access, this home offers exceptional convenience for commuters and families. You'll also be just minutes from The Boardwalk and Costco, with its wide selection of shops, restaurants, entertainment, and everyday amenities. Don't miss this opportunity to lease a well-maintained home in one of Waterloo's most desirable and convenient locations. Photos are from before tenant moved in. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-08T23:20:35.874424+00:00"
+"Directions": "Cross Streets: Erbsville Rd. ** Directions: Erbsville Rd to Chablis Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2196992"
+"ListOfficeKey": "163253"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Sump Pump"
]
+"LotSizeDimensions": "28.1 x 105.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-08T20:16:18Z"
+"PhotosCount": 24
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T20:16:17Z"
+"Stories": "2.0"
+"StreetName": "Chablis"
+"StreetNumber": "506"
+"StreetSuffix": "Drive"
+"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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29872296/506-chablis-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2800
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 28.1
+"OriginalEntryTimestamp": "2026-06-08T20:16:17.94Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1445441"
+"ListOfficeNationalAssociationId": "1184464"
+"Media": array:24 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29872296')"
+"ID": "1509120"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24913
+post_id: "1506223"
+post_author: 1
+"ListingKey": "29869744"
+"ListingId": "X13413982"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T16:45:06Z"
+"RFModificationTimestamp": "2026-06-12T16:54:19Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2K8"
+"UnparsedAddress": "630 PINEROW CRESCENT, Waterloo, Ontario N2T2K8"
+"Coordinates": array:2 [
0 => -80.56966
1 => 43.44863
]
+"Latitude": 43.44863
+"Longitude": -80.56966
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Spacious 3-Bedroom Semi-Detached in Beechwood, Waterloo! Located in one of Waterloo's best school districts, this home is perfect for families seeking top-rated schools.3 generous bedrooms, Bright living and dining areas, Functional kitchen. Finished Basement with a Private separate entrance. Ideal for Extended Family or Home Office: 2 additional rooms that are perfect for a playroom, guest suite, or remote work. Large sized Backyard, fully fenced, private, and ready for kids, pets, or summer entertaining. Walk to parks and trails. Minutes to universities (UW & WLU), transit, and shopping. Don't miss this rare rental - space, privacy, and top schools all in one! (id:62783)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:5 [
0 => "Finished"
1 => "None"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-08T16:18:08.988832+00:00"
+"Directions": "Erbsville /Erb St W"
+"ExteriorFeatures": array:1 [
0 => "Brick Facing"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1411041"
+"ListOfficeKey": "288626"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "32.5 x 116.8 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T16:37:18Z"
+"PhotosCount": 29
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T16:37:18Z"
+"Stories": "2.0"
+"StreetName": "Pinerow"
+"StreetNumber": "630"
+"StreetSuffix": "Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29869744/630-pinerow-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2800
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 32.6
+"OriginalEntryTimestamp": "2026-06-08T15:35:34Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1113142"
+"ListOfficeNationalAssociationId": "1370159"
+"Media": array:29 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29869744')"
+"ID": "1506223"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24914
+post_id: "1481265"
+post_author: 1
+"ListingKey": "29835119"
+"ListingId": "X13223564"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-01T19:26:02Z"
+"RFModificationTimestamp": "2026-06-01T20:31:46Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B8"
+"UnparsedAddress": "BSMNT - 400 WILDCALLA STREET, Waterloo, Ontario N2V0B8"
+"Coordinates": array:2 [
0 => -80.595386
1 => 43.452648
]
+"Latitude": 43.452648
+"Longitude": -80.595386
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning, Bright & Spacious 1-Bedroom Basement Apartment in Vista Hills!? Welcome to your next home! This newer, premium basement apartment is located in the highly prestigious and desirable Vista Hills community. Built to impress, this unit offers exceptional living space that is much larger than your expectations. Key Features: Spacious Open-Concept: Seamless flow between the massive living area and the kitchen, perfect for relaxing or entertaining. Modern Kitchen: Equipped with 1-year brand-new appliances and sleek finishes. Sun-Drenched Rooms: Large windows and a layout designed to maximize natural light. Premium Lighting: Packed with elegant pot lights throughout for a warm, bright ambiance. Separate Entrance: Private and secure entry accessible directly from the backyard. Convenience & Storage: Dedicated laundry room and ample storage space. Rental Details: Rent: Monthly Rent + 30%Utilities (id:62783)"
+"Appliances": array:2 [
0 => "Refrigerator"
1 => "Stove"
]
+"Basement": array:2 [
0 => "Apartment in basement"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-01T20:31:41.375747+00:00"
+"Directions": "ERBSVILLE/COLUMBIA ST"
+"ExteriorFeatures": array:2 [
0 => "Stucco"
1 => "Brick Facing"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1994479"
+"ListOfficeKey": "290183"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-01T19:17:17Z"
+"PhotosCount": 13
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-01T19:17:17Z"
+"StreetName": "Wildcalla"
+"StreetNumber": "400"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29835119/bsmnt-400-wildcalla-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 1600
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-01T19:17:17.65Z"
+"ListAgentNationalAssociationId": "1277525"
+"ListOfficeNationalAssociationId": "1384540"
+"Media": array:13 [
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]
]
+"DaysOnMarket": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29835119')"
+"ID": "1481265"
}
]
+success: true
+page_size: 9
+page_count: 3
+count: 21
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]