array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30009098 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23469
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23471
+post_id: "1607622"
+post_author: 1
+"ListingKey": "30009098"
+"ListingId": "X13541106"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T15:40:07Z"
+"RFModificationTimestamp": "2026-07-09T15:48:35Z"
+"ListPrice": 1174900.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2S2"
+"UnparsedAddress": "456 KELSO DRIVE, Waterloo, Ontario N2V2S2"
+"Coordinates": array:2 [
0 => -80.585768
1 => 43.490898
]
+"Latitude": 43.490898
+"Longitude": -80.585768
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome home to 456 Kelso Drive - a beautifully finished, carefully tended to, and thoughtfully updated over the years - set in one of Waterloo's most desirable neighbourhoods, just moments from the trails and natural beauty of Laurel Creek Conservation Area. From the moment you step inside, the sense of space is unmistakable. With over 4,000 sq. ft. of finished living area, this two-storey home unfolds gracefully from room to room, offering a floor plan designed for both connection and comfort. The kitchen sits at the heart of it all - warm, inviting, and impressively functional, with ample cabinetry and generous counter space that make everyday cooking and family gatherings feel effortless. Upstairs, four spacious bedrooms provide room for families of all shapes and sizes. The primary suite feels like a private retreat, complete with a walk-in closet and a beautifully renovated ensuite (2020) featuring double sinks, a soothing soaker tub, and a walk-in shower. The lower level tells its own story - one of celebration, laughter, and evenings spent with friends. Renovated in 2018, the finished basement features a stunning custom bar and a cozy fireplace, creating the perfect backdrop for game nights, movie marathons, or hosting holidays. Step outside and you'll find a backyard designed for enjoyment. The manicured landscaping and new deck (2020) set the stage for summer barbecues, outdoor entertaining, or even the future pool you've been dreaming about. It's a space that invites you to slow down, unwind, and make memories. With a 2-car garage, a quiet street setting, and close proximity to the amenities of Waterloo's west end, this home offers a rare blend of location, lifestyle, and meticulous care. Opportunities like this don't come often. This one is ready to be lived in-and loved. (id:66098)"
+"Appliances": array:6 [
0 => "All"
1 => "Water softener"
2 => "Freezer"
3 => "Water Treatment"
4 => "Window Coverings"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T01:45:36.099594+00:00"
+"Directions": "Cross Streets: Pinery Trail. ** Directions: From Westmount Rd N turn west onto Conservation Dr, then turn north onto Lake Louise Blvd, then turn west onto kelso Dr."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2030044"
+"ListOfficeKey": "284058"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "44.8 x 131.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T01:44:00Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T15:30:09Z"
+"Stories": "2.0"
+"StreetName": "Kelso"
+"StreetNumber": "456"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "8765.43"
+"VirtualTourURLUnbranded": "https://youriguide.com/456_kelso_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1679155420"
"RoomType" => "Eating area"
"ListingId" => "X13541106"
"RoomLevel" => "Main level"
"RoomWidth" => 3.92
"ListingKey" => "30009098"
"RoomLength" => 2.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T15:30:09.14Z"
]
1 => array:11 [
"RoomKey" => "1679155421"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13541106"
"RoomLevel" => "Second level"
"RoomWidth" => 5.24
"ListingKey" => "30009098"
"RoomLength" => 4.39
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T15:30:09.14Z"
]
2 => array:11 [
"RoomKey" => "1679155422"
"RoomType" => "Other"
"ListingId" => "X13541106"
"RoomLevel" => "Basement"
"RoomWidth" => 3.15
"ListingKey" => "30009098"
"RoomLength" => 4.23
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T15:30:09.14Z"
]
3 => array:11 [
"RoomKey" => "1679155423"
"RoomType" => "Den"
"ListingId" => "X13541106"
"RoomLevel" => "Basement"
"RoomWidth" => 3.22
"ListingKey" => "30009098"
"RoomLength" => 3.19
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T15:30:09.14Z"
]
4 => array:11 [
"RoomKey" => "1679155424"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13541106"
"RoomLevel" => "Basement"
"RoomWidth" => 3.77
"ListingKey" => "30009098"
"RoomLength" => 10.61
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T15:30:09.14Z"
]
5 => array:11 [
"RoomKey" => "1679155425"
"RoomType" => "Dining room"
"ListingId" => "X13541106"
"RoomLevel" => "Main level"
"RoomWidth" => 3.1
"ListingKey" => "30009098"
"RoomLength" => 3.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T15:30:09.14Z"
]
6 => array:11 [
"RoomKey" => "1679155426"
"RoomType" => "Family room"
"ListingId" => "X13541106"
"RoomLevel" => "Main level"
"RoomWidth" => 4.99
"ListingKey" => "30009098"
"RoomLength" => 4.01
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T15:30:09.14Z"
]
7 => array:11 [
"RoomKey" => "1679155427"
"RoomType" => "Foyer"
"ListingId" => "X13541106"
"RoomLevel" => "Main level"
"RoomWidth" => 3.47
"ListingKey" => "30009098"
"RoomLength" => 3.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T15:30:09.14Z"
]
8 => array:11 [
"RoomKey" => "1679155428"
"RoomType" => "Kitchen"
"ListingId" => "X13541106"
"RoomLevel" => "Main level"
"RoomWidth" => 3.87
"ListingKey" => "30009098"
"RoomLength" => 4.23
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T15:30:09.15Z"
]
9 => array:11 [
"RoomKey" => "1679155429"
"RoomType" => "Laundry room"
"ListingId" => "X13541106"
"RoomLevel" => "Main level"
"RoomWidth" => 3.2
"ListingKey" => "30009098"
"RoomLength" => 2.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T15:30:09.15Z"
]
10 => array:11 [
"RoomKey" => "1679155430"
"RoomType" => "Living room"
"ListingId" => "X13541106"
"RoomLevel" => "Main level"
"RoomWidth" => 4.31
"ListingKey" => "30009098"
"RoomLength" => 3.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T15:30:09.15Z"
]
11 => array:11 [
"RoomKey" => "1679155431"
"RoomType" => "Bedroom 2"
"ListingId" => "X13541106"
"RoomLevel" => "Second level"
"RoomWidth" => 4.48
"ListingKey" => "30009098"
"RoomLength" => 3.83
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T15:30:09.15Z"
]
12 => array:11 [
"RoomKey" => "1679155432"
"RoomType" => "Bedroom 3"
"ListingId" => "X13541106"
"RoomLevel" => "Second level"
"RoomWidth" => 3.45
"ListingKey" => "30009098"
"RoomLength" => 4.81
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T15:30:09.15Z"
]
13 => array:11 [
"RoomKey" => "1679155433"
"RoomType" => "Bedroom 4"
"ListingId" => "X13541106"
"RoomLevel" => "Second level"
"RoomWidth" => 4.39
"ListingKey" => "30009098"
"RoomLength" => 3.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T15:30:09.15Z"
]
]
+"ListAOR": "OnePoint"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/30009098/456-kelso-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2164913"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "293714"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 44.9
+"OriginalEntryTimestamp": "2026-07-09T01:29:31.88Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1307735"
+"ListOfficeNationalAssociationId": "1338255"
+"CoListAgentNationalAssociationId": "1415698"
+"CoListOfficeNationalAssociationId": "1430565"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30009098_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/600ad799d26d68a3cf14f1ac88b7600e.webp"
"MediaSize" => 307363
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-600ad799d26d68a3cf14f1ac88b7600e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30009098_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/de8eff5940fac946f8f2dfb3adcb4ceb.webp"
"MediaSize" => 278134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-de8eff5940fac946f8f2dfb3adcb4ceb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30009098_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/a3cc84562c2a2e371c8eaebc1b8223bd.webp"
"MediaSize" => 346908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-a3cc84562c2a2e371c8eaebc1b8223bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30009098_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/aa776af9184110ed067469e2ca5a6e89.webp"
"MediaSize" => 300628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-aa776af9184110ed067469e2ca5a6e89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30009098_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/4892966f6f2fbd03ef8d94ba13fd0115.webp"
"MediaSize" => 172040
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-4892966f6f2fbd03ef8d94ba13fd0115.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30009098_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/842a8ab190f57bc36c20247be0fe6937.webp"
"MediaSize" => 181009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-842a8ab190f57bc36c20247be0fe6937.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30009098_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/83e4b1291fe7600659484e56fe52797b.webp"
"MediaSize" => 177525
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-83e4b1291fe7600659484e56fe52797b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30009098_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/3c937060fd804d93f651b53efdb5329d.webp"
"MediaSize" => 192054
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-3c937060fd804d93f651b53efdb5329d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30009098_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/b8e2766dd9aed4701f957792563b9702.webp"
"MediaSize" => 165152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-b8e2766dd9aed4701f957792563b9702.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30009098_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/f282335cbb17853975ee3d5666448535.webp"
"MediaSize" => 178104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-f282335cbb17853975ee3d5666448535.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30009098_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/6d68496d7be611a4a4ffc03f1a4486d1.webp"
"MediaSize" => 190341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-6d68496d7be611a4a4ffc03f1a4486d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30009098_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/14c0a4a2c5bc4012f189a847527d2db6.webp"
"MediaSize" => 180176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-14c0a4a2c5bc4012f189a847527d2db6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30009098_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/8dc481b3343727b63ffc0c62c0d14c9a.webp"
"MediaSize" => 200896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-8dc481b3343727b63ffc0c62c0d14c9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30009098_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/68039aab1141d0b393385d57f52a2a15.webp"
"MediaSize" => 160968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-68039aab1141d0b393385d57f52a2a15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30009098_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/d37802861ca3f1daa0da4bfa7ecc0f20.webp"
"MediaSize" => 167500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-d37802861ca3f1daa0da4bfa7ecc0f20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30009098_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/22bfa46a6ac3e9ba17b67a868c34f374.webp"
"MediaSize" => 185547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-22bfa46a6ac3e9ba17b67a868c34f374.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30009098_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/ec1abb3a29db2fb3d9013a1efd6484f3.webp"
"MediaSize" => 126850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-ec1abb3a29db2fb3d9013a1efd6484f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30009098_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/789589e5fa59960752dfff800c04597f.webp"
"MediaSize" => 164473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-789589e5fa59960752dfff800c04597f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30009098_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/ef33095e4f993fb71d4b87c2329e79ca.webp"
"MediaSize" => 165466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-ef33095e4f993fb71d4b87c2329e79ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30009098_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/2a040eaa296f0649314bc5a3bdac3fc9.webp"
"MediaSize" => 192302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-2a040eaa296f0649314bc5a3bdac3fc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30009098_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/1aa5ed7077ac9ee7ddd0eed8e1af3900.webp"
"MediaSize" => 148515
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-1aa5ed7077ac9ee7ddd0eed8e1af3900.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30009098_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/aae73efae82b0d92a66cb9b411b69047.webp"
"MediaSize" => 161148
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-aae73efae82b0d92a66cb9b411b69047.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30009098_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/6c071f3590a6bd1b73d15bd8c92866f4.webp"
"MediaSize" => 162926
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-6c071f3590a6bd1b73d15bd8c92866f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30009098_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/716d868a1da1aef807455339c5fa5802.webp"
"MediaSize" => 149434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-716d868a1da1aef807455339c5fa5802.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30009098_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/876d2a31c91a20bb33dc7615dbe3c148.webp"
"MediaSize" => 158097
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-876d2a31c91a20bb33dc7615dbe3c148.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30009098_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/f1594d71937120a9ac68f12268a6f312.webp"
"MediaSize" => 147845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-f1594d71937120a9ac68f12268a6f312.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30009098_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/f0109361e474e0d4bf87d0e7aa5df32b.webp"
"MediaSize" => 160763
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-f0109361e474e0d4bf87d0e7aa5df32b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30009098_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/f0eb47b861fac6fd9bcc662f034e82a5.webp"
"MediaSize" => 97586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-f0eb47b861fac6fd9bcc662f034e82a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30009098_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/2e2f7bdf9b4668fc406fbcfbd6ef114f.webp"
"MediaSize" => 167488
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-2e2f7bdf9b4668fc406fbcfbd6ef114f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30009098_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/bcf27c01df4814cb81c21a8efc4b2e60.webp"
"MediaSize" => 162604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-bcf27c01df4814cb81c21a8efc4b2e60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30009098_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/3c44421227d3332911bf00c690b17e6d.webp"
"MediaSize" => 163995
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-3c44421227d3332911bf00c690b17e6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30009098_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/dcae46c2608e84b97c747c3849ba52aa.webp"
"MediaSize" => 190033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-dcae46c2608e84b97c747c3849ba52aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30009098_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/073fc01ca7e32ca702bac2b5b39d1968.webp"
"MediaSize" => 129818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-073fc01ca7e32ca702bac2b5b39d1968.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30009098_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/915e154530a47ce0e80990149d28d20c.webp"
"MediaSize" => 183720
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-915e154530a47ce0e80990149d28d20c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30009098_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/19be39facbf66340b99678421ac71b23.webp"
"MediaSize" => 192389
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-19be39facbf66340b99678421ac71b23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "30009098_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/b6d69a2d44c181eb85a1fc7b6e086588.webp"
"MediaSize" => 179478
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-b6d69a2d44c181eb85a1fc7b6e086588.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "30009098_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/302ca62f81118bf4eae09c2e639eb512.webp"
"MediaSize" => 189918
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-302ca62f81118bf4eae09c2e639eb512.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "30009098_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/cfd048e7abd70cfcebf763e71eb52bfb.webp"
"MediaSize" => 162616
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-cfd048e7abd70cfcebf763e71eb52bfb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "30009098_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/c680af81d12fb20714018038c9f416ac.webp"
"MediaSize" => 144341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-c680af81d12fb20714018038c9f416ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "30009098_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/f9003a918697263157a09df5c4aac446.webp"
"MediaSize" => 117417
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-f9003a918697263157a09df5c4aac446.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "30009098_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/5c6823a8dc9537b42fe0616093a80bcb.webp"
"MediaSize" => 325226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-5c6823a8dc9537b42fe0616093a80bcb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "30009098_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/85864aea23318a3bdc93e432eab6eeb8.webp"
"MediaSize" => 353932
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-85864aea23318a3bdc93e432eab6eeb8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "30009098_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/803e3b9ac93e3bc720e28dd2436a125e.webp"
"MediaSize" => 370791
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-803e3b9ac93e3bc720e28dd2436a125e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "30009098_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/565ddb6bdb9c587307247d4922e788c4.webp"
"MediaSize" => 349863
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009098/thumbnail-565ddb6bdb9c587307247d4922e788c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541106"
"ResourceRecordKey" => "30009098"
"ModificationTimestamp" => "2026-07-09T01:29:31.88Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "30009098_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009098/9d5f09d2b90b2ac6cd646e10fbe67b9f.webp"
…10
]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30009098')"
+"ID": "1607622"
}
]
+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=OfficeKey eq 284058" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25004
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24901
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Keller Williams Home Group Realty"
+"OfficeEmail": null
+"OfficePhone": "226-780-0202"
+"OfficeMlsId": "560701"
+"ModificationTimestamp": "2026-04-22T08:10:00Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "284058"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "5 EDINBURGH ROAD SOUTH, UNIT 1B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "GUELPH"
+"OfficePostalCode": "N1H5N"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "OnePoint"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1338255"
+"OriginalEntryTimestamp": "2018-10-05T15:00:00Z"
+"OfficeFax": "519-286-9192"
+"OfficeAORKey": "47"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [ …6]
]
+"FranchiseNationalAssociationId": "1230713"
+"OfficeBrokerNationalAssociationId": "1250872"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('284058')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2030044" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24907
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30009098'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25323
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30009098' AND OpenHouseDate ge '2026-07-10'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25338
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25339
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31882256"
+"ListingKey": "30009098"
+"ListingId": "X13541106"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-12"
+"OpenHouseStartTime": "2026-07-12T11:00:00Z"
+"OpenHouseEndTime": "2026-07-12T13:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-10T23:32:05Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31882256')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25341
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31882255"
+"ListingKey": "30009098"
+"ListingId": "X13541106"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-11"
+"OpenHouseStartTime": "2026-07-11T11:00:00Z"
+"OpenHouseEndTime": "2026-07-11T13:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-10T23:32:05Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31882255')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30009098' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.585768 43.490898)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25430
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25424
+post_id: "1613200"
+post_author: 1
+"ListingKey": "30017618"
+"ListingId": "X13549040"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T16:50:01Z"
+"RFModificationTimestamp": "2026-07-10T17:20:24Z"
+"ListPrice": 149900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3Z4"
+"UnparsedAddress": "236 - 580 BEAVER CREEK ROAD, Waterloo, Ontario N2J3Z4"
+"Coordinates": array:2 [
0 => -80.583659
1 => 43.485334
]
+"Latitude": 43.485334
+"Longitude": -80.583659
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome to 580 Beaver Creek Road, Unit 236, located in the charming community of Green Acre Park near the beautiful Laurel Creek Conservation Area in Waterloo. This bright and spacious 2-bedroom model trailer offers an affordable opportunity for downsizers, seasonal living, or anyone looking to step out of the rental market. Step inside to a sun-filled and versatile sunroom and imagine what you can do to this space. Bonus is that the Heat pump (heating/cooling) was newly added in 2024 by Aire One. The living room is filled with natural light and flows seamlessly into the kitchen, creating a functional and comfortable living space. Larger than it appears, this home offers a cozy cottage feel with the convenience of nearby city amenities. Backing onto peaceful farmers' fields, this unit enjoys added privacy and a serene setting in one of the park's desirable locations. Green Acre Park offers fantastic community amenities, including a swimming pool, games room, playground, and catch-and-release fishing pond, providing plenty of opportunities for outdoor enjoyment and recreation. Land Lease fee $10,190.00 + $111.25 for large trailer fee. Green Acre Park is closed for the months of Januray and February. Enjoy the benefits of 10-month seasonal living, with the park closed during January and February-perfect timing to escape somewhere warm for the winter. A wonderful opportunity to enjoy relaxed living in a welcoming community setting (id:59439)"
+"Appliances": array:3 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-10T17:20:20.989625+00:00"
+"Directions": "Cross Streets: Conservation. ** Directions: Conservation Dr to Beaver Creek."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2165646"
+"ListOfficeKey": "293196"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-10T16:31:11Z"
+"PhotosCount": 28
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T16:31:11Z"
+"Stories": "1.0"
+"StreetName": "Beaver Creek"
+"StreetNumber": "580"
+"StreetSuffix": "Road"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=cmPSK_jOA88"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "OnePoint"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/30017618/236-580-beaver-creek-road-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Mobile Home"
]
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "FD"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-10T16:31:11.11Z"
+"ListAgentNationalAssociationId": "1416447"
+"ListOfficeNationalAssociationId": "1423680"
+"Media": array:28 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30017618')"
+"ID": "1613200"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25426
+post_id: "1612616"
+post_author: 1
+"ListingKey": "30017462"
+"ListingId": "40847021"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T23:25:17Z"
+"RFModificationTimestamp": "2026-07-10T23:28:03Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.14
+"LivingArea": 2026.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4N1"
+"UnparsedAddress": "602 HIGHPOINT Avenue, Waterloo, Ontario N2L4N1"
+"Coordinates": array:2 [
0 => -80.5629561
1 => 43.4866781
]
+"Latitude": 43.4866781
+"Longitude": -80.5629561
+"YearBuilt": 1972
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "OPPORTUNITY KNOCKS IN LAKESHORE ! Welcome to 602 Highpoint Avenue, a rock-solid, all-brick raised bungalow nestled in one of Waterloo’s most desirable family neighborhoods. Offered as a clean blank canvas ready for its next chapter. The main floor features an exceptionally bright, expansive living room with a massive front bay window, a formal dining area, a functional kitchen with a rear walkout, three bedrooms, and a full 4-piece bathroom. Distinct from conventional raised bungalows, the low-profile design features a highly accessible entry with just a single step into the home. The fully finished lower level massively expands your living space, showcasing a huge family room anchored by a rustic brick feature wall and a cozy wood-burning stove. This level also includes a spacious fourth bedroom, a powder room, a dedicated laundry area, and a separate workshop/utility space with abundant storage. Step outside to your private wood deck overlooking a wide, beautifully landscaped, fully fenced yard framed by a pristine cedar hedge and mature fruit trees. Additional features include a deep asphalt driveway and vinyl windows (approximately 10 years old). Walk to top-rated schools, parks, and local amenities. Unlock this home’s massive potential today! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
5 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-10T17:02:19.277804+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Other"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2214101"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.14"
+"NumberOfUnitsTotal": "1"
+"PhotosChangeTimestamp": "2026-07-10T19:48:11Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T23:18:10Z"
+"Stories": "1.0"
+"StreetName": "HIGHPOINT"
+"StreetNumber": "602"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "3987"
+"VirtualTourURLUnbranded": "https://youriguide.com/602_highpoint_avenue_waterloo_on/"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30017462/602-highpoint-avenue-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 1050
+"BelowGradeFinishedArea": 976
+"OriginalEntryTimestamp": "2026-07-10T16:18:24.88Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1459821"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:37 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30017462')"
+"ID": "1612616"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25423
+post_id: "1608024"
+post_author: 1
+"ListingKey": "30009620"
+"ListingId": "40846083"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T00:55:19Z"
+"RFModificationTimestamp": "2026-07-10T00:59:51Z"
+"ListPrice": 720000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1850.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2A7"
+"UnparsedAddress": "704 JACOB Lane, Waterloo, Ontario N2V2A7"
+"Coordinates": array:2 [
0 => -80.5702204
1 => 43.4978201
]
+"Latitude": 43.4978201
+"Longitude": -80.5702204
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 704 Jacob Lane, Waterloo, a beautifully maintained family home nestled in the highly desirable Lakeshore North neighbourhood, where excellent schools, scenic walking trails, parks, shopping, and everyday conveniences are all just minutes away. Enjoy quick access to Laurel Creek Conservation Area, the St. Jacobs Farmers' Market, Costco, The Boardwalk Shopping Centre, the University of Waterloo, Wilfrid Laurier University, and Highway 85, making this an exceptional location for families, professionals, and commuters alike. Thoughtfully designed with over 2,000 sq. ft. of finished living space, this bright and inviting home offers the perfect blend of comfort and functionality. The welcoming main floor features a spacious living room filled with natural light, complemented by warm hardwood flooring and an elegant staircase. The heart of the home is the stylish kitchen, showcasing rich espresso cabinetry, stainless steel appliances, a centre island with additional prep space, ample storage, and a timeless subway tile backsplash. The open-concept dining area overlooks the backyard, creating an ideal setting for family dinners and entertaining. Upstairs, you'll find generously sized bedrooms, including a spacious primary retreat, while additional bedrooms provide plenty of room for a growing family, guests, or a home office. The finished lower level expands your living space with a large recreation room perfect for movie nights, a children's play area, home gym, or workspace. Step outside to enjoy the fully fenced backyard, an ideal space for summer BBQs, kids, pets, or simply relaxing after a long day. Located in one of Waterloo's most sought-after family communities, 704 Jacob Lane offers the perfect combination of modern living, everyday convenience, and an unbeatable location close to schools, parks, trails, shopping, transit, and some of the Region's most popular amenities. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T14:05:02.933201+00:00"
+"Directions": "Take Westmount, turn east on Osprey, left on Jacob Lane."
+"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": "1983959"
+"ListOfficeKey": "292624"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T13:42:37Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T00:48:08Z"
+"Stories": "2.0"
+"StreetName": "JACOB"
+"StreetNumber": "704"
+"StreetSuffix": "Lane"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "4205.88"
+"VirtualTourURLUnbranded": "https://youriguide.com/704_jacob_ln_waterloo_on/"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30009620/704-jacob-lane-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2213528"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "291822"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 31.0
+"AboveGradeFinishedArea": 1250
+"BelowGradeFinishedArea": 599
+"OriginalEntryTimestamp": "2026-07-09T11:48:54.94Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1268752"
+"ListOfficeNationalAssociationId": "1414872"
+"CoListAgentNationalAssociationId": "1459332"
+"CoListOfficeNationalAssociationId": "1405037"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30009620')"
+"ID": "1608024"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25427
+post_id: "1608025"
+post_author: 1
+"ListingKey": "30009619"
+"ListingId": "40846263"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T14:35:20Z"
+"RFModificationTimestamp": "2026-07-09T14:49:15Z"
+"ListPrice": 1174900.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 4036.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2S2"
+"UnparsedAddress": "456 KELSO Drive, Waterloo, Ontario N2V2S2"
+"Coordinates": array:2 [
0 => -80.5860759
1 => 43.4907983
]
+"Latitude": 43.4907983
+"Longitude": -80.5860759
+"YearBuilt": 2010
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome home to 456 Kelso Drive - beautifully finished, carefully tended to, and thoughtfully updated over the years - set in one of Waterloo's most desirable neighbourhoods, just moments from the trails and natural beauty of Laurel Creek Conservation Area. From the moment you step inside, the sense of space is unmistakable. With over 4,000 sq. ft. of finished living area, this two-storey home unfolds gracefully from room to room, offering a floor plan designed for both connection and comfort. The kitchen sits at the heart of it all - warm, inviting, and impressively functional, with ample cabinetry and generous counter space that make everyday cooking and family gatherings feel effortless. Upstairs, four spacious bedrooms provide room for families of all shapes and sizes. The primary suite feels like a private retreat, complete with a walk-in closet and a beautifully renovated ensuite (2020) featuring double sinks, a soothing soaker tub, and a walk-in shower. The lower level tells its own story - one of celebration, laughter, and evenings spent with friends. Renovated in 2018, the finished basement features a stunning custom bar and a cozy fireplace, creating the perfect backdrop for game nights, movie marathons, or hosting holidays. Step outside and you'll find a backyard designed for enjoyment. The manicured landscaping and new deck (2020) set the stage for summer barbecues, outdoor entertaining, or even the future pool you've been dreaming about. It's a space that invites you to slow down, unwind, and make memories. With a 2-car garage, a quiet street setting, and close proximity to the amenities of Waterloo's west end, this home offers a rare blend of location, lifestyle, and meticulous care. Opportunities like this don't come often. This one is ready to be lived in-and loved. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T14:04:20.980552+00:00"
+"ExteriorFeatures": array:3 [
0 => "Stucco"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2231226"
+"ListOfficeKey": "293636"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T11:48:54Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T14:30:01Z"
+"Stories": "2.0"
+"StreetName": "KELSO"
+"StreetNumber": "456"
+"StreetSuffix": "Drive"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "8765.43"
+"VirtualTourURLUnbranded": "https://youriguide.com/456_kelso_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30009619/456-kelso-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 2776
+"BelowGradeFinishedArea": 1260
+"OriginalEntryTimestamp": "2026-07-09T11:48:54.01Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1472257"
+"ListOfficeNationalAssociationId": "1429499"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30009619')"
+"ID": "1608025"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25425
+post_id: "1607853"
+post_author: 1
+"ListingKey": "30009710"
+"ListingId": "X13541622"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T01:15:06Z"
+"RFModificationTimestamp": "2026-07-10T01:22:26Z"
+"ListPrice": 720000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2A7"
+"UnparsedAddress": "704 JACOB LANE, Waterloo, Ontario N2V2A7"
+"Coordinates": array:2 [
0 => -80.570198
1 => 43.497813
]
+"Latitude": 43.497813
+"Longitude": -80.570198
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 704 Jacob Lane, Waterloo, a beautifully maintained family home nestled in the highly desirable Lakeshore North neighbourhood, where excellent schools, scenic walking trails, parks, shopping, and everyday conveniences are all just minutes away. Enjoy quick access to Laurel Creek Conservation Area, the St. Jacobs Farmers' Market, Costco, The Boardwalk Shopping Centre, the University of Waterloo, Wilfrid Laurier University, and Highway 85, making this an exceptional location for families, professionals, and commuters alike. Thoughtfully designed with over 2,000 sq. ft. of finished living space, this bright and inviting home offers the perfect blend of comfort and functionality. The welcoming main floor features a spacious living room filled with natural light, complemented by warm hardwood flooring and an elegant staircase. The heart of the home is the stylish kitchen, showcasing rich espresso cabinetry, stainless steel appliances, a centre island with additional prep space, ample storage, and a timeless subway tile backsplash. The open-concept dining area overlooks the backyard, creating an ideal setting for family dinners and entertaining. Upstairs, you'll find generously sized bedrooms, including a spacious primary retreat, while additional bedrooms provide plenty of room for a growing family, guests, or a home office. The finished lower level expands your living space with a large recreation room perfect for movie nights, a children's play area, home gym, or workspace. Step outside to enjoy the fully fenced backyard, an ideal space for summer BBQs, kids, pets, or simply relaxing after a long day. Located in one of Waterloo's most sought-after family communities, 704 Jacob Lane offers the perfect combination of modern living, everyday convenience, and an unbeatable location close to schools, parks, trails, shopping, transit, and some of the Region's most popular amenities. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T13:37:30.386351+00:00"
+"Directions": "Cross Streets: Westmount Rd N. ** Directions: Take Westmount, turn east on Osprey, left on Jacob Lane."
+"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": "2213528"
+"ListOfficeKey": "297463"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "31.2 x 104.9 FT ; 104.88 ft x 31.22 ft x108.64 ftx30.93 ft"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T13:46:27Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T01:08:33Z"
+"Stories": "2.0"
+"StreetName": "Jacob"
+"StreetNumber": "704"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "4205.88"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30009710/704-jacob-lane-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 31.2
+"OriginalEntryTimestamp": "2026-07-09T12:08:02.14Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1459332"
+"ListOfficeNationalAssociationId": "1470704"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30009710')"
+"ID": "1607853"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25406
+post_id: "1602037"
+post_author: 1
+"ListingKey": "30001128"
+"ListingId": "X13533822"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T19:20:09Z"
+"RFModificationTimestamp": "2026-07-07T23:43:23Z"
+"ListPrice": 1799900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2Y4"
+"UnparsedAddress": "422 RIDEAU RIVER STREET, Waterloo, Ontario N2V2Y4"
+"Coordinates": array:2 [
0 => -80.588911
1 => 43.491282
]
+"Latitude": 43.491282
+"Longitude": -80.588911
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Experience luxury living at 422 Rideau River St in the highly sought-after ConservationMeadows community. This custom built home offers premium finishes, thoughtful design, and anincredible natural setting with no rear neighbours.A beautifully landscaped front approach, featuring an interlocking stone driveway, and naturalstone steps leading to the entrance, sets the tone for the exceptional craftsmanship foundthroughout. Inside, hand-scraped hardwood flooring extends across the main and second levels,The kitchen is a true showpiece, complete with a 14-foot soapstone waterfall island, cast ironsink, butler's pantry, and a premium Gaggenau appliance package that blends precision withperformance. From the kitchen, the home opens into comfortable living areas, including afamily room with a fireplace and large windows filling the room with natural light.The luxurious primary suite offers a private sitting area, custom dressing room, walk-inclosets with built-in cabinetry, and a spa-inspired ensuite featuring an oversized glassshower and a Victoria + Albert volcanic stone soaking tub. 3 additional spacious bedrooms anda 5-piece bath complete the upper level.The finished walk-out basement includes a large recreation room, dedicated media room wiredSonos sound system, a 5th bedroom, full bathroom with custom tile shower, upgradedpet-resistant carpeting, and a whimsical Fairy Play House with bunk loft.Additional features include a custom whiskey cabinet, built-in dog wash.The fully fenced backyard with garden beds, mature fruit trees, berry bushes, and rose gardenswhile overlooking a pond and the Stamm Woodlot with over 6 km of scenic walking trails.Moments from St. Jacobs Farmers' Market, Laurel Creek Conservation Area, and farm-freshprovisions. A truly signature residence in an exceptional location. A detailed propertyinformation package prepared for buyer review is available through MLS via your REALTOR (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Dryer"
7 => "Microwave"
8 => "Freezer"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener remote(s)"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-07-07T23:43:20.278625+00:00"
+"Directions": "Cross Streets: Pinery Trail. ** Directions: From Conservation Drive turn onto Rideau River St, follow around bend to home on R/S."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2197726"
+"ListOfficeKey": "294392"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Sump Pump"
]
+"LotSizeDimensions": "45 x 109.3 FT ; 45.07ft. x 109.43ft. x 45.07ft. x109.43"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T19:11:30Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T19:11:29Z"
+"Stories": "2.0"
+"StreetName": "Rideau River"
+"StreetNumber": "422"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "8878"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30001128/422-rideau-river-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-07-07T19:11:29.33Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1446142"
+"ListOfficeNationalAssociationId": "1438599"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30001128')"
+"ID": "1602037"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23483
+post_id: "1602047"
+post_author: 1
+"ListingKey": "30001669"
+"ListingId": "40845281"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T20:35:24Z"
+"RFModificationTimestamp": "2026-07-07T23:05:36Z"
+"ListPrice": 1150000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3716.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2K2"
+"UnparsedAddress": "538 SANDBANKS Crescent, Waterloo, Ontario N2V2K2"
+"Coordinates": array:2 [
0 => -80.5798863
1 => 43.4958737
]
+"Latitude": 43.4958737
+"Longitude": -80.5798863
+"YearBuilt": 2000
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 538 Sandbanks Crescent, a stunning and beautifully updated home nestled in the highly sought-after Laurelwood neighbourhood in Waterloo. From the moment you arrive it is clear this home has been cared for with exceptional pride of ownership and thoughtful attention to detail throughout. Backing onto protected green space and filled with an abundance of natural light, this home offers the perfect blend of comfort, flexibility and modern living. The layout is incredibly versatile featuring two flexible main floor rooms that can be used as a home office, den or additional bedrooms depending on your family's needs, along with a full bathroom on the main level, making it ideal for multigenerational living or aging parents. With a generous above grade footprint plus a finished walkout basement, there is no shortage of space for everyone to enjoy. Located just steps from Laurel Creek Conservation Area, 6 minutes from the charming village of St. Jacobs, and within the catchment of top ranked schools including Laurelwood Public School and Laurel Heights Secondary School. The Stork Family YMCA, Waterloo Public Library and The Boardwalk shopping district are all just minutes away. This truly is a neighbourhood people fall in love with and never want to leave. Updates include a new air conditioner (2022), quartz countertops in the kitchen (2024), new water softener (2025), updated paint throughout various areas, professionally painted entry, main and upstairs hallways and updated vanity taps in the upstairs bathroom (2026). Truly move in ready. Do not miss your opportunity to call this incredible home yours! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T23:05:29.635886+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2103569"
+"ListOfficeKey": "156376"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T20:29:28Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T20:29:27Z"
+"Stories": "2.0"
+"StreetName": "SANDBANKS"
+"StreetNumber": "538"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "7891.76"
+"VirtualTourURLUnbranded": "https://youriguide.com/538_sandbanks_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30001669/538-sandbanks-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 2492
+"BelowGradeFinishedArea": 1224
+"OriginalEntryTimestamp": "2026-07-07T20:29:27.96Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1373130"
+"ListOfficeNationalAssociationId": "1003925"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30001669')"
+"ID": "1602047"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25428
+post_id: "1600924"
+post_author: 1
+"ListingKey": "30000572"
+"ListingId": "40845913"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T18:25:12Z"
+"RFModificationTimestamp": "2026-07-07T20:02:50Z"
+"ListPrice": 1799900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.113
+"LivingArea": 4131.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2Y4"
+"UnparsedAddress": "422 RIDEAU RIVER Street, Waterloo, Ontario N2V2Y4"
+"Coordinates": array:2 [
0 => -80.5890379
1 => 43.4912404
]
+"Latitude": 43.4912404
+"Longitude": -80.5890379
+"YearBuilt": 2009
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience luxury living at 422 Rideau River St in the highly sought-after Conservation Meadows community. This custom built home offers premium finishes, thoughtful design, and an incredible natural setting with no rear neighbours. A beautifully landscaped front approach, featuring an interlocking stone driveway, and natural stone steps leading to the entrance, sets the tone for the exceptional craftsmanship found throughout. Inside, hand-scraped hardwood flooring extends across the main and second levels, The kitchen is a true showpiece, complete with a 14-foot soapstone waterfall island, cast iron sink, butler's pantry, and a premium Gaggenau appliance package that blends precision with performance. From the kitchen, the home opens into comfortable living areas, including a family room with a fireplace and large windows filling the room with natural light. The luxurious primary suite offers a private sitting area, custom dressing room, walk-in closets with built-in cabinetry, and a spa-inspired ensuite featuring an oversized glass shower and a Victoria + Albert volcanic stone soaking tub. 3 additional spacious bedrooms and a 5-piece bath complete the upper level. The finished walk-out basement includes a large recreation room, dedicated media room wired Sonos sound system, a 5th bedroom, full bathroom with custom tile shower, upgraded pet-resistant carpeting, and a whimsical Fairy Play House with bunk loft. Additional features include a custom whiskey cabinet, built-in dog wash. The fully fenced backyard with garden beds, mature fruit trees, berry bushes, and rose gardens while overlooking a pond and the Stamm Woodlot with over 6 km of scenic walking trails. Moments from St. Jacobs Farmers' Market, Laurel Creek Conservation Area, and farm-fresh provisions. A truly signature residence in an exceptional location. A detailed property information package prepared for buyer review is available through MLS® via your REALTOR® (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T20:02:44.755339+00:00"
+"Directions": "From Conservation Drive turn onto Rideau River St, follow around bend to home on R/S"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2094304"
+"ListOfficeKey": "297560"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Gazebo"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.113"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-07T18:18:29Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T18:18:28Z"
+"Stories": "2.0"
+"StreetName": "RIDEAU RIVER"
+"StreetNumber": "422"
+"StreetSuffix": "Street"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "8878"
+"VirtualTourURLUnbranded": "https://youriguide.com/pkm51_422_rideau_river_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:20 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30000572/422-rideau-river-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2245088"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "292918"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 2956
+"BelowGradeFinishedArea": 1175
+"OriginalEntryTimestamp": "2026-07-07T18:18:28.86Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1366723"
+"ListOfficeNationalAssociationId": "1467595"
+"CoListAgentNationalAssociationId": "1483759"
+"CoListOfficeNationalAssociationId": "1419429"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30000572')"
+"ID": "1600924"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25429
+post_id: "1602306"
+post_author: 1
+"ListingKey": "29998188"
+"ListingId": "40845586"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T13:55:11Z"
+"RFModificationTimestamp": "2026-07-07T17:58:04Z"
+"ListPrice": 785000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1549.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1L8"
+"UnparsedAddress": "108 CLEARWATER Crescent, Waterloo, Ontario N2V1L8"
+"Coordinates": array:2 [
0 => -80.5635421
1 => 43.4922983
]
+"Latitude": 43.4922983
+"Longitude": -80.5635421
+"YearBuilt": 1984
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled in the highly sought-after Lakeshore North community, this beautifully maintained 2-storey home offers the perfect blend of comfort, functionality, and lifestyle. Featuring 3 spacious bedrooms, 2 bathrooms, and a thoughtfully designed layout, this home is ideal for growing families, professionals, and those who love to entertain. From the upgraded vinyl flooring throughout portions of the main floor to the seamless walk-through kitchen design, every detail has been curated to enhance the natural flow of the home—making everyday living and hosting effortless. Beyond the cosmetic upgrades, this home has also been mechanically updated over the years, offering buyers peace of mind and truly worry-free ownership. The pride of ownership is evident throughout, making this a move-in-ready opportunity in one of Waterloo’s most desirable neighbourhoods. The heart of the home opens into inviting living and dining spaces perfect for gatherings with family and friends, while the fully finished basement offers endless versatility—whether you envision a yoga studio, recreation room, home gym, workshop, or additional entertaining space. Step outside to enjoy a beautifully private backyard retreat, ideal for summer evenings, barbecues, or relaxing in peace. Located just minutes from the highway, top-rated dining, gyms, shopping, and both universities, this home delivers unbeatable convenience in an area known for its strong community feel, mature surroundings, and exceptional accessibility. Complete with a double-car garage, fantastic layout for entertaining, and extensive updates throughout, this is a rare opportunity to own a turn-key home in the coveted Lakeshore North neighbourhood. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Gas stove(s)"
6 => "Dryer"
7 => "Freezer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Ductless"
]
+"CreationDate": "2026-07-07T17:57:52.057126+00:00"
+"Directions": "Wintergreen Dr. Northlake and Highpoint Ave."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2129938"
+"ListOfficeKey": "292877"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T13:48:23Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T13:48:23Z"
+"Stories": "2.0"
+"StreetName": "CLEARWATER"
+"StreetNumber": "108"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "4711"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youriguide.com/108_clearwater_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29998188/108-clearwater-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1941951"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "292877"
+"GeocodeManualYN": true
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 53.0
+"AboveGradeFinishedArea": 1549
+"OriginalEntryTimestamp": "2026-07-07T13:48:23.04Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1382907"
+"ListOfficeNationalAssociationId": "1418791"
+"CoListAgentNationalAssociationId": "1238606"
+"CoListOfficeNationalAssociationId": "1418791"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29998188')"
+"ID": "1602306"
}
]
+success: true
+page_size: 9
+page_count: 7
+count: 62
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]