array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29850354 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23363
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23365
+post_id: "1492494"
+post_author: 1
+"ListingKey": "29850354"
+"ListingId": "40830528"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T17:00:10Z"
+"RFModificationTimestamp": "2026-06-17T17:04:21Z"
+"ListPrice": 819000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1880.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4M2"
+"UnparsedAddress": "610 SOUTH HAVEN Drive, Waterloo, Ontario N2K4M2"
+"Coordinates": array:2 [
0 => -80.5000252
1 => 43.5120868
]
+"Latitude": 43.5120868
+"Longitude": -80.5000252
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this exceptional home in the highly sought-after Eastridge community! This move-in ready 2-storey detached home offers 3 spacious bedrooms and 3 bathrooms, ideally located within walking distance to schools and close to charming neighbourhood parks. Backing onto Rim Park and the Grand River, this property provides a rare combination of convenience, privacy, and natural beauty. Recently renovated throughout, the home features brand-new waterproof flooring, fresh designer paint, and numerous modern light fixtures that create a bright and contemporary living environment. The main floor living room is enhanced with abundant pot lights, providing excellent illumination and a warm, inviting atmosphere. The kitchen is equipped with a brand-new refrigerator, adding both style and functionality. Upstairs, a separate family room with a cozy fireplace offers an ideal private retreat for family gatherings, entertainment, or relaxation. The spacious primary bedroom features its own ensuite bathroom, creating a comfortable and private sanctuary. Step outside to enjoy the large backyard deck, perfect for outdoor dining, entertaining, or simply unwinding while enjoying the peaceful surroundings. A beautifully updated home in an unbeatable location—don't miss this incredible opportunity! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Dryer"
5 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-03T23:21:53.555716+00:00"
+"Directions": "Shediac"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2073939"
+"ListOfficeKey": "253316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-03T22:50:39Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T16:53:40Z"
+"Stories": "2.0"
+"StreetName": "SOUTH HAVEN"
+"StreetNumber": "610"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "4891"
+"VirtualTourURLUnbranded": "https://youtu.be/EeMRCR1OF9M"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1661286899"
"RoomType" => "Family room"
"ListingId" => "40830528"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29850354"
"RoomLength" => null
"RoomDimensions" => "17'1'' x 18'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:53:40.05Z"
]
1 => array:11 [
"RoomKey" => "1661286900"
"RoomType" => "Bedroom"
"ListingId" => "40830528"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29850354"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:53:40.05Z"
]
2 => array:11 [
"RoomKey" => "1661286901"
"RoomType" => "4pc Bathroom"
"ListingId" => "40830528"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29850354"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:53:40.05Z"
]
3 => array:11 [
"RoomKey" => "1661286902"
"RoomType" => "Primary Bedroom"
"ListingId" => "40830528"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29850354"
"RoomLength" => null
"RoomDimensions" => "16'0'' x 14'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:53:40.05Z"
]
4 => array:11 [
"RoomKey" => "1661286903"
"RoomType" => "4pc Bathroom"
"ListingId" => "40830528"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29850354"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:53:40.05Z"
]
5 => array:11 [
"RoomKey" => "1661286904"
"RoomType" => "Bedroom"
"ListingId" => "40830528"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29850354"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:53:40.06Z"
]
6 => array:11 [
"RoomKey" => "1661286905"
"RoomType" => "Dining room"
"ListingId" => "40830528"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29850354"
"RoomLength" => null
"RoomDimensions" => "15'8'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:53:40.06Z"
]
7 => array:11 [
"RoomKey" => "1661286906"
"RoomType" => "Living room"
"ListingId" => "40830528"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29850354"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:53:40.06Z"
]
8 => array:11 [
"RoomKey" => "1661286907"
"RoomType" => "2pc Bathroom"
"ListingId" => "40830528"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29850354"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:53:40.06Z"
]
9 => array:11 [
"RoomKey" => "1661286908"
"RoomType" => "Dining room"
"ListingId" => "40830528"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29850354"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:53:40.06Z"
]
10 => array:11 [
"RoomKey" => "1661286909"
"RoomType" => "Kitchen"
"ListingId" => "40830528"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29850354"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 9'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:53:40.06Z"
]
11 => array:11 [
"RoomKey" => "1661286910"
"RoomType" => "Cold room"
"ListingId" => "40830528"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29850354"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:53:40.06Z"
]
12 => array:11 [
"RoomKey" => "1661286911"
"RoomType" => "Laundry room"
"ListingId" => "40830528"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29850354"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:53:40.07Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29850354/610-south-haven-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1880
+"OriginalEntryTimestamp": "2026-06-03T22:50:38.81Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1349103"
+"ListOfficeNationalAssociationId": "1223329"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29850354_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/dfa8c7f83138026405c5dd3f0c359bea.webp"
"MediaSize" => 160642
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-dfa8c7f83138026405c5dd3f0c359bea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29850354_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/68faec400be44da0149eb1f9d4f03b69.webp"
"MediaSize" => 167882
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-68faec400be44da0149eb1f9d4f03b69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29850354_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/dafcd1a5083fb7715bea664682bae795.webp"
"MediaSize" => 182190
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-dafcd1a5083fb7715bea664682bae795.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29850354_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/5b9b26dd0118e20c13f3bfe5749c9c60.webp"
"MediaSize" => 223981
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-5b9b26dd0118e20c13f3bfe5749c9c60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29850354_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/897de2fb86cfe62fbcb8337387b93bba.webp"
"MediaSize" => 49256
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-897de2fb86cfe62fbcb8337387b93bba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29850354_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/9558b1b39871e786bf7faf772cfb920b.webp"
"MediaSize" => 72206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-9558b1b39871e786bf7faf772cfb920b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29850354_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/6d44f50fc89304d3a2f032995369df6d.webp"
"MediaSize" => 72352
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-6d44f50fc89304d3a2f032995369df6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29850354_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/0b313394309067ec5794b78f92014e88.webp"
"MediaSize" => 87083
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-0b313394309067ec5794b78f92014e88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29850354_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/664f3ea67ae76543279d20a9e798d729.webp"
"MediaSize" => 86335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-664f3ea67ae76543279d20a9e798d729.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29850354_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/a6e340acb3a5c7f3ac34b6a2a067d9f4.webp"
"MediaSize" => 87578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-a6e340acb3a5c7f3ac34b6a2a067d9f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29850354_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/acc105d053966f822a7556484fef2cb8.webp"
"MediaSize" => 103354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-acc105d053966f822a7556484fef2cb8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29850354_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/1ffe09b4d73cb4eaee7872226c50e578.webp"
"MediaSize" => 76682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-1ffe09b4d73cb4eaee7872226c50e578.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29850354_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/70cbec0dbb903da46e007a7cbb913343.webp"
"MediaSize" => 75982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-70cbec0dbb903da46e007a7cbb913343.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29850354_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/83e10378ece1fa5cb20edee2ff290d54.webp"
"MediaSize" => 78014
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-83e10378ece1fa5cb20edee2ff290d54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29850354_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/4b1259db7ffad52d280427abed060e74.webp"
"MediaSize" => 76294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-4b1259db7ffad52d280427abed060e74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29850354_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/0877c05cad6485cfadfdbc1026fb26e5.webp"
"MediaSize" => 75160
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-0877c05cad6485cfadfdbc1026fb26e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29850354_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/b963ab5e079f5142b72e2706c41e1f51.webp"
"MediaSize" => 82254
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-b963ab5e079f5142b72e2706c41e1f51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29850354_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/3f44a4bf5813520adbc11c99fa861c64.webp"
"MediaSize" => 78984
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-3f44a4bf5813520adbc11c99fa861c64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29850354_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/dd4f09ae60fdf90c0ced51e95082de35.webp"
"MediaSize" => 83253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-dd4f09ae60fdf90c0ced51e95082de35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29850354_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/adba2a9e2206b10bbe405967e4b96579.webp"
"MediaSize" => 48517
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-adba2a9e2206b10bbe405967e4b96579.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29850354_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/188dd23538b33705f802368479d49b98.webp"
"MediaSize" => 94120
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-188dd23538b33705f802368479d49b98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29850354_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/162e38d8f4a515a4b6f22a7f4d760694.webp"
"MediaSize" => 80927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-162e38d8f4a515a4b6f22a7f4d760694.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29850354_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/c66dfafecb0b121aa3866eecf2a4b357.webp"
"MediaSize" => 80713
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-c66dfafecb0b121aa3866eecf2a4b357.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29850354_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/0d5f02daced0db31249f6237c6eefec4.webp"
"MediaSize" => 76370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-0d5f02daced0db31249f6237c6eefec4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29850354_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/140b9eb471b02f0addb5d61da6d6cd81.webp"
"MediaSize" => 75592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-140b9eb471b02f0addb5d61da6d6cd81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29850354_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/992b1c3a41db299c44e5f45e71470aa0.webp"
"MediaSize" => 71450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-992b1c3a41db299c44e5f45e71470aa0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29850354_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/83fc91c0abe651f829bbebb090251b05.webp"
"MediaSize" => 91954
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-83fc91c0abe651f829bbebb090251b05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29850354_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/a4c56a3c6179b4d9cb390fbb1565e331.webp"
"MediaSize" => 76878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-a4c56a3c6179b4d9cb390fbb1565e331.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29850354_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/c180093d34d3d759ca9f564d7f8951f1.webp"
"MediaSize" => 79490
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-c180093d34d3d759ca9f564d7f8951f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29850354_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/96012f6b7c82e264de3d3d7265b524e4.webp"
"MediaSize" => 185087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-96012f6b7c82e264de3d3d7265b524e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29850354_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29850354/df40e78386172879d7e123d13d9c53bb.webp"
"MediaSize" => 162509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29850354/thumbnail-df40e78386172879d7e123d13d9c53bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40830528"
"ResourceRecordKey" => "29850354"
"ModificationTimestamp" => "2026-06-03T22:50:38.83Z"
]
]
+"DaysOnMarket": 14
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29850354')"
+"ID": "1492494"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 253316" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24757
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2073939" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24842
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29850354'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25150
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29850354'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25164
+items: array:5 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25166
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31304610"
+"ListingKey": "29850354"
+"ListingId": "40830528"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-06"
+"OpenHouseStartTime": "2026-06-06T14:00:00Z"
+"OpenHouseEndTime": "2026-06-06T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-04T22:32:17Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31304610')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25168
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31304609"
+"ListingKey": "29850354"
+"ListingId": "40830528"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-07"
+"OpenHouseStartTime": "2026-06-07T14:00:00Z"
+"OpenHouseEndTime": "2026-06-07T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-04T22:32:17Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31304609')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25165
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31322607"
+"ListingKey": "29850354"
+"ListingId": "40830528"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-07"
+"OpenHouseStartTime": "2026-06-07T14:00:00Z"
+"OpenHouseEndTime": "2026-06-07T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-06T20:14:02Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31322607')"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25169
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31322608"
+"ListingKey": "29850354"
+"ListingId": "40830528"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-06"
+"OpenHouseStartTime": "2026-06-06T14:00:00Z"
+"OpenHouseEndTime": "2026-06-06T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-06T20:14:02Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31322608')"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25167
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31355960"
+"ListingKey": "29850354"
+"ListingId": "40830528"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-07"
+"OpenHouseStartTime": "2026-06-07T14:00:00Z"
+"OpenHouseEndTime": "2026-06-07T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-07T18:56:53Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31355960')"
}
]
+success: true
+page_size: 5
+page_count: 1
+count: 5
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29850354' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5000252 43.5120868)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25194
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25188
+post_id: "1538217"
+post_author: 1
+"ListingKey": "29914406"
+"ListingId": "X13454334"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T12:25:15Z"
+"RFModificationTimestamp": "2026-06-17T13:47:33Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G9"
+"UnparsedAddress": "405 - 243 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.522255
1 => 43.509258
]
+"Latitude": 43.509258
+"Longitude": -80.522255
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Blackstone Condominiums in Waterloo! This modern, carpet-free 2-bedroom, 2-bathroom suite offers stylish finishes throughout, including custom cabinetry, quartz countertops, backsplash, in-suite laundry, and a spacious storage room. Enjoy exceptional building amenities including a fitness centre, co-working lounge, party room, rooftop terrace, bike storage, pet wash station, and landscaped outdoor spaces. High-speed internet is included in the condo fees. Conveniently located steps from Brown's Socialhouse, shopping, restaurants, and transit, with easy access to Conestoga Mall, ION LRT, RIM Park, Grey Silo Golf Club, St. Jacobs, universities, and colleges. A fantastic opportunity to own in one of Waterloo's most desirable communities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
]
+"AssociationFee": "646"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T13:47:22.400606+00:00"
+"Directions": "Cross Streets: Northfield/bridge st w. ** Directions: on northfield dr e."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2249954"
+"ListOfficeKey": "292962"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T12:16:42Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T12:16:42Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "243"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3685"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/405_243_northfield_dr_e_waterloo_on"
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1661039470"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13454334"
"RoomLevel" => "Main level"
"RoomWidth" => 3.05
"ListingKey" => "29914406"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T12:16:42.78Z"
]
1 => array:11 [
"RoomKey" => "1661039471"
"RoomType" => "Bedroom"
"ListingId" => "X13454334"
"RoomLevel" => "Main level"
"RoomWidth" => 3.0
"ListingKey" => "29914406"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T12:16:42.79Z"
]
2 => array:11 [
"RoomKey" => "1661039472"
"RoomType" => "Living room"
"ListingId" => "X13454334"
"RoomLevel" => "Main level"
"RoomWidth" => 3.1
"ListingKey" => "29914406"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T12:16:42.79Z"
]
3 => array:11 [
"RoomKey" => "1661039473"
"RoomType" => "Kitchen"
"ListingId" => "X13454334"
"RoomLevel" => "Main level"
"RoomWidth" => 3.9
"ListingKey" => "29914406"
"RoomLength" => 3.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T12:16:42.79Z"
]
4 => array:11 [
"RoomKey" => "1661039474"
"RoomType" => "Laundry room"
"ListingId" => "X13454334"
"RoomLevel" => "Main level"
"RoomWidth" => 1.68
"ListingKey" => "29914406"
"RoomLength" => 3.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T12:16:42.79Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29914406/405-243-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Five Rivers Property Mgmt"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-17T12:16:42.75Z"
+"ListAgentNationalAssociationId": "1488846"
+"ListOfficeNationalAssociationId": "1420223"
+"Media": array:49 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29914406_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914406/49fd1670661db4b9cf8c81f77b2b0221.webp"
"MediaSize" => 202902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914406/thumbnail-49fd1670661db4b9cf8c81f77b2b0221.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13454334"
"ResourceRecordKey" => "29914406"
"ModificationTimestamp" => "2026-06-17T12:16:42.76Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29914406_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914406/231c74638e49caf154da56ae281b21f2.webp"
"MediaSize" => 297609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914406/thumbnail-231c74638e49caf154da56ae281b21f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454334"
"ResourceRecordKey" => "29914406"
"ModificationTimestamp" => "2026-06-17T12:16:42.76Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29914406_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914406/dc2b9f312e6745f68ceca7c521fb2058.webp"
"MediaSize" => 298681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914406/thumbnail-dc2b9f312e6745f68ceca7c521fb2058.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454334"
"ResourceRecordKey" => "29914406"
"ModificationTimestamp" => "2026-06-17T12:16:42.76Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29914406_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914406/8a8cafdc986b2f382a522a780d3cdb54.webp"
"MediaSize" => 308011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914406/thumbnail-8a8cafdc986b2f382a522a780d3cdb54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454334"
"ResourceRecordKey" => "29914406"
"ModificationTimestamp" => "2026-06-17T12:16:42.76Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29914406_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914406/240c1eb302b4c093d2157b320d78e7fb.webp"
"MediaSize" => 309857
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914406/thumbnail-240c1eb302b4c093d2157b320d78e7fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454334"
"ResourceRecordKey" => "29914406"
"ModificationTimestamp" => "2026-06-17T12:16:42.76Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29914406_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914406/e4f10d3c506381b78cbf95638ebd2b7c.webp"
"MediaSize" => 194159
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914406/thumbnail-e4f10d3c506381b78cbf95638ebd2b7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454334"
"ResourceRecordKey" => "29914406"
"ModificationTimestamp" => "2026-06-17T12:16:42.76Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29914406_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914406/04222fea1dc5af5aafe55597a56b4826.webp"
"MediaSize" => 131007
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914406/thumbnail-04222fea1dc5af5aafe55597a56b4826.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454334"
"ResourceRecordKey" => "29914406"
"ModificationTimestamp" => "2026-06-17T12:16:42.76Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29914406_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914406/78133661054100277e211c58fa8f5fd5.webp"
"MediaSize" => 142265
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914406/thumbnail-78133661054100277e211c58fa8f5fd5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454334"
"ResourceRecordKey" => "29914406"
"ModificationTimestamp" => "2026-06-17T12:16:42.76Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29914406_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914406/5bbc995a7e0ac25a5c45efe6c16ec592.webp"
"MediaSize" => 166707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914406/thumbnail-5bbc995a7e0ac25a5c45efe6c16ec592.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454334"
"ResourceRecordKey" => "29914406"
"ModificationTimestamp" => "2026-06-17T12:16:42.76Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29914406_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914406/d225749a1660aedb0d7f9bbe197a2135.webp"
"MediaSize" => 140597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914406/thumbnail-d225749a1660aedb0d7f9bbe197a2135.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454334"
"ResourceRecordKey" => "29914406"
"ModificationTimestamp" => "2026-06-17T12:16:42.76Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29914406_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914406/cfbb7b0996fdf8be94023946795553e7.webp"
"MediaSize" => 167168
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914406/thumbnail-cfbb7b0996fdf8be94023946795553e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454334"
"ResourceRecordKey" => "29914406"
"ModificationTimestamp" => "2026-06-17T12:16:42.76Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29914406_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914406/63ba8f83bee32cb948ab6246ab12208a.webp"
"MediaSize" => 148314
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914406/thumbnail-63ba8f83bee32cb948ab6246ab12208a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454334"
"ResourceRecordKey" => "29914406"
"ModificationTimestamp" => "2026-06-17T12:16:42.76Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29914406_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914406/ea93ad7efd2ef8ac69945a2cc11b10d0.webp"
"MediaSize" => 187629
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914406/thumbnail-ea93ad7efd2ef8ac69945a2cc11b10d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454334"
"ResourceRecordKey" => "29914406"
"ModificationTimestamp" => "2026-06-17T12:16:42.76Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29914406_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914406/26ce00e1a7ef1d203758e0470a44f090.webp"
"MediaSize" => 162132
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914406/thumbnail-26ce00e1a7ef1d203758e0470a44f090.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454334"
"ResourceRecordKey" => "29914406"
"ModificationTimestamp" => "2026-06-17T12:16:42.76Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29914406_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914406/cb12bfada778b6ed6cff376eac4127ed.webp"
"MediaSize" => 187177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914406/thumbnail-cb12bfada778b6ed6cff376eac4127ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454334"
"ResourceRecordKey" => "29914406"
"ModificationTimestamp" => "2026-06-17T12:16:42.76Z"
]
15 => array:13 [
"Order" => 16
…12
]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914406')"
+"ID": "1538217"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25190
+post_id: "1530988"
+post_author: 1
+"ListingKey": "29903648"
+"ListingId": "40839800"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T15:40:14Z"
+"RFModificationTimestamp": "2026-06-16T15:44:15Z"
+"ListPrice": 700000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2954.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4G8"
+"UnparsedAddress": "460 WOOLWICH Street Unit# 24, Waterloo, Ontario N2K4G8"
+"Coordinates": array:2 [
0 => -80.4939516
1 => 43.5014803
]
+"Latitude": 43.5014803
+"Longitude": -80.4939516
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome home to Riverstone Estates. Beautiful bright 3 bedroom, 3 bathroom multi level townhome located in highly desirable East Waterloo. Main floor has large open concept living/dining/kitchen area. Second floor features 2 bedrooms + 4 pc bath. Master suite located on upper level with full ensuite and walk in closet. Living room features a gas fireplace. All appliances included. Lower level finished, with full walkout basement and access to single garage. Patio door walk out from dining room to private deck area. Parking for 2 cars. Prime location to Walter Bean Trail, the Grand River, Kiwanis Park, Grey Silo Golf Course, Rim Park and expressway. Ample Visitor parking in front of unit. Seller can be flexible on closing. Low Condo Fee. Come Check out. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"AssociationFee": "235"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T19:21:53.555087+00:00"
+"Directions": "Off Woolwich"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564596"
+"ListOfficeKey": "76831"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T15:31:12Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:32:26Z"
+"Stories": "2.0"
+"StreetName": "WOOLWICH"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "4712.14"
+"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/29903648/460-woolwich-street-unit-24-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1950017"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "299554"
+"GeocodeManualYN": true
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 2287
+"BelowGradeFinishedArea": 667
+"OriginalEntryTimestamp": "2026-06-15T15:31:11.85Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1095797"
+"ListOfficeNationalAssociationId": "1004391"
+"CoListAgentNationalAssociationId": "1244287"
+"CoListOfficeNationalAssociationId": "1473831"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29903648')"
+"ID": "1530988"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25187
+post_id: "1523441"
+post_author: 1
+"ListingKey": "29894120"
+"ListingId": "40838919"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T13:15:12Z"
+"RFModificationTimestamp": "2026-06-12T14:37:38Z"
+"ListPrice": 309000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 584.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H2"
+"UnparsedAddress": "243 NORTHFIELD Drive E Unit# 408, Waterloo, Ontario N2K0H2"
+"Coordinates": array:2 [
0 => -80.5218062
1 => 43.510191
]
+"Latitude": 43.510191
+"Longitude": -80.5218062
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Blackstone Condominiums, where modern design meets convenient Waterloo living. This owner-occupied, carpet-free one-bedroom suite has been beautifully maintained and thoughtfully upgraded throughout. The bright open-concept layout overlooks the peaceful courtyard and features a stylish kitchen with upgraded cabinetry, quartz countertops, stainless steel appliances, subway tile backsplash, custom island, and modern pot lighting. Additional highlights include a spacious four-piece bathroom, in-suite laundry, custom remote-controlled blinds, and an owned underground parking space. Residents enjoy exceptional amenities including a fitness center, co-working lounge, party room, rooftop terrace, bike storage, pet wash station, and landscaped outdoor spaces. High-speed Internet is included in the condo fees. Ideally located steps from Brown's Social House, shopping, restaurants, and everyday amenities, with easy access to Conestoga Mall, the ION LRT, RIM Park, Grey Silo Golf Club, St. Jacobs, and Waterloo's universities and colleges. A fantastic opportunity for first-time buyers, professionals or investors seeking a move-in-ready home in one of Waterloo's most desirable communities. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"AssociationFee": "480"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T14:37:36.573103+00:00"
+"Directions": "Corner of Northfield Dr E & Bridge Street"
+"ExteriorFeatures": array:1 [
0 => "Steel"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2043154"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Open"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-12T12:50:34Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T13:10:08Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "243"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3122.33"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29894120/243-northfield-drive-e-unit-408-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "r1"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 584
+"OriginalEntryTimestamp": "2026-06-12T12:50:34.28Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1318898"
+"ListOfficeNationalAssociationId": "1004370"
+"Media": array:35 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29894120')"
+"ID": "1523441"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25191
+post_id: "1521017"
+post_author: 1
+"ListingKey": "29889988"
+"ListingId": "40836212"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T17:40:07Z"
+"RFModificationTimestamp": "2026-06-11T20:19:37Z"
+"ListPrice": 1200000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2866.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0B3"
+"UnparsedAddress": "123 OAK PARK Drive, Waterloo, Ontario N2K0B3"
+"Coordinates": array:2 [
0 => -80.4977201
1 => 43.5205041
]
+"Latitude": 43.5205041
+"Longitude": -80.4977201
+"YearBuilt": 2013
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This exceptional former model freehold townhome with no rear neighbours offers a luxurious living experience, showcasing high-end finishes throughout and an incredible backyard oasis. A spacious front entry welcomes you into the home and flows seamlessly into the dining area and beautifully appointed kitchen, creating the perfect space for both everyday living and entertaining. The inviting great room features a charming gas fireplace and overlooks the private backyard retreat, which can be enjoyed from the comfort of the three-season sunroom. The primary suite serves as a private retreat, complete with a spa-inspired ensuite and walk-in closet. Premium finishes throughout include California shutters, granite countertops, porcelain tile, and numerous quality upgrades. Two additional bedrooms share a second full size bathroom. The professionally finished basement extends the living space with a versatile recreation room, full bathroom and wet bar entertainment area (roughed-in for full kitchen). With excellent potential to add a kitchenette or second kitchen, the basement offers added flexibility for multigenerational living, extended family, or enhanced entertaining. Outside, discover a truly picturesque backyard oasis featuring a beautiful stone patio, gazebo, irrigation system, and meticulously maintained gardens bursting with colourful flowers. An ideal setting for relaxing or hosting family and friends. A rare opportunity to own a beautifully upgraded home, incredibly maintained, in one of the area's most desirable neighbourhoods. With convenient rear access to Rim Park, the Walter Bean Grand River Trail, Grey Silo Golf Course, the East Waterloo Branch Library, and shopping at Conestoga Mall, this exceptional location offers the perfect blend of recreation and everyday convenience. Don't miss your chance! (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Central Vacuum - Roughed In"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T20:19:26.578928+00:00"
+"Directions": "Millenium Dr."
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2091826"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T17:31:43Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T17:31:42Z"
+"Stories": "2.0"
+"StreetName": "OAK PARK"
+"StreetNumber": "123"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "6087.1"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/e9c41qpBM50"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29889988/123-oak-park-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RES-4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 23.0
+"AboveGradeFinishedArea": 2141
+"BelowGradeFinishedArea": 725
+"OriginalEntryTimestamp": "2026-06-11T17:31:42.38Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1364413"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889988')"
+"ID": "1521017"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25189
+post_id: "1519775"
+post_author: 1
+"ListingKey": "29889315"
+"ListingId": "40838920"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T21:40:08Z"
+"RFModificationTimestamp": "2026-06-14T21:41:19Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1559.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3S4"
+"UnparsedAddress": "465 WOOLWICH Street, Waterloo, Ontario N2K3S4"
+"Coordinates": array:2 [
0 => -80.4927797
1 => 43.4997029
]
+"Latitude": 43.4997029
+"Longitude": -80.4927797
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "O.H. SUN JUN 14th (3-5). Welcome to 8-465 Woolwich St., an exceptional value condo-townhouse in Waterloo's desirable Kiwanis Park/Lexington neighbourhood. Move-in ready and welcoming, this home offers a smart, spacious layout with quality laminate and hardwood flooring throughout the main floor and clean carpet upstairs. The efficient galley kitchen connects to the dining area and offers ample counter and cupboard space. The living room opens to your private deck and green space, creating an easy indoor-outdoor flow for summer BBQs, morning coffee, or relaxed entertaining. Upstairs, you'll find two generously sized bedrooms, each with double closets. The finished basement adds versatility and can easily serve as a family room, home office, fitness area, hobby space, or guest retreat. An additional 4-piece bathroom adds convenience and flexibility. The location is a true lifestyle highlight. Just minutes from Kiwanis Park, you'll enjoy playgrounds, picnic areas, trails and one of Waterloo's favourite public pools. Nearby RIM Park offers year-round recreation with arenas, indoor sports fields, walking tracks, fitness facilities, community programs, and Grey Silo Golf Course. Nature lovers will appreciate the close proximity to the Grand River and the Walter Bean Grand River Trail, offering kilometres of scenic pathways through beautiful natural landscapes. Enjoy walking, cycling, birdwatching, and outdoor recreation right at your doorstep. Shopping, restaurants, groceries, schools, and everyday amenities are nearby, while quick access to Highway 85 and the Conestoga Parkway makes commuting throughout Waterloo Region easy. Set in a well-managed condominium community with updates including windows, exterior doors & deck, this home is an excellent opportunity for first-time buyers, downsizers, families, or investors seeking an affordable entry into one of Waterloo's most sought-after neighbourhoods. Call your REALTOR® today and come see for yourself. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"AssociationFee": "483.12"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T18:19:05.284312+00:00"
+"Directions": "University St. to Woolwich St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564736"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-11T20:04:26Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-14T21:32:20Z"
+"Stories": "2.0"
+"StreetName": "WOOLWICH"
+"StreetNumber": "465"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "3113.4"
+"VirtualTourURLUnbranded": "https://youriguide.com/465-_woolwich_st_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/29889315/465-woolwich-street-unit-8-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1060
+"BelowGradeFinishedArea": 499
+"OriginalEntryTimestamp": "2026-06-11T16:32:56.11Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1126313"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889315')"
+"ID": "1519775"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25184
+post_id: "1514962"
+post_author: 1
+"ListingKey": "29880685"
+"ListingId": "40823911"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:45:40Z"
+"RFModificationTimestamp": "2026-06-16T17:19:53Z"
+"ListPrice": 579000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1210.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2G4"
+"UnparsedAddress": "435A LEE Avenue, Waterloo, Ontario N2K2G4"
+"Coordinates": array:2 [
0 => -80.5067851
1 => 43.4965407
]
+"Latitude": 43.4965407
+"Longitude": -80.5067851
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this charming, lovingly maintained semi-detached home, proudly offered by its second owner and located in the highly desirable Lincoln Village neighbourhood. The bright eat-in kitchen features an attractive accent wall, ample cabinetry, and plenty of space for everyday family meals. The spacious open-concept living room is filled with natural light from the large bay window and offers room for both comfortable living and dining. This thoughtfully designed home boasts three generously sized bedrooms, two full bathrooms, and a functional layout that has been lovingly cared for over the years. The basement offers excellent potential for additional living space and includes a full bathroom, laundry area, and abundant storage. Adding to the appeal are the often-overlooked benefits of wonderful neighbours, a large lot, and the only carport on the street. Step outside to the covered deck overlooking the fully fenced backyard, which backs directly onto lush, park greenspace—providing added privacy and a beautiful setting for relaxing, entertaining, or enjoying family time outdoors. Ideally located close to the expressway, schools, shopping, and all amenities, this exceptional property presents a fantastic opportunity for families, first-time buyers, and investors alike. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T16:48:04.415942+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908536"
+"ListOfficeKey": "274404"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-10T17:53:18Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T16:35:36Z"
+"Stories": "2.0"
+"StreetName": "LEE"
+"StreetNumber": "435"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3220"
+"VirtualTourURLUnbranded": "https://youriguide.com/a_435_lee_avenue_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29880685/435a-lee-avenue-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1210
+"OriginalEntryTimestamp": "2026-06-10T11:52:28.19Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1221358"
+"ListOfficeNationalAssociationId": "1254957"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29880685')"
+"ID": "1514962"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23377
+post_id: "1512893"
+post_author: 1
+"ListingKey": "29878309"
+"ListingId": "40838342"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T20:10:20Z"
+"RFModificationTimestamp": "2026-06-09T22:42:10Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2475.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0E9"
+"UnparsedAddress": "271 GREY SILO Road Unit# 29, Waterloo, Ontario N2K0E9"
+"Coordinates": array:2 [
0 => -80.495489
1 => 43.5243855
]
+"Latitude": 43.5243855
+"Longitude": -80.495489
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This is more than a townhouse - it's a thoughtfully crafted luxury residence offering nearly 2,500 SF of elegant living. Ideally situated on a peaceful, family-friendly street in the coveted Carriage Crossing. Step inside to a bright, open-concept main floor where soaring 9-foot ceilings and engineered hardwood flooring create a sense of space and sophistication. The heart of the home is the chef's kitchen, featuring Cambria quartz countertops, SS appliances including a gas stove with a double oven, wine fridge, cabinetry extending to the ceiling, under cabinet lighting & a spacious pantry. A convenient 2-piece bath and a main floor laundry/mud room completes the main level. The private primary retreat occupies its own dedicated floor, with grand-sized windows, an oversized walk-in-closet and a stunning ensuite showcasing a glass shower & Cambria quartz countertops. Upstairs, the top level provides incredible flexibility with a spacious open office, along with two generous, sun-filled bedrooms. The main bathroom is thoughtfully designed with a separate water closet and a shower/tub combination - ideal for family living. The finished look-out basement extends your living space even further, featuring 9 ft ceilings, engineered hardwood flooring, a beautifully appointed 3-piece bathroom with a glass shower, Italian marble tile, and herringbone floors. The rec room is perfect for a games room, playroom, or even a fourth bedroom. Outdoors, unwind on your back deck and enjoy the sounds of birdsong, visits from hummingbirds, and scenic walks along nearby trails where deer sightings and gorgeous sunsets are part of everyday life. Perfectly positioned minutes from top-rated schools, Grey Silo Golf Club, RIM Park, Universities, tech campuses, St. Jacobs, and major highways. Exterior maintenance, from summer landscaping to winter snow removal, is professionally managed. Most furnishings negotiable. This home truly offers the best of both worlds. Your perfect home awaits! (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Wine Fridge"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"AssociationFee": "594.44"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T22:42:06.895935+00:00"
+"Directions": "University to Millennium to Grey Silo"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Stucco"
2 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2030628"
+"ListOfficeKey": "276982"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Paved driveway"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T20:01:00Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T20:00:59Z"
+"Stories": "2.0"
+"StreetName": "GREY SILO"
+"StreetNumber": "271"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "7059"
+"VirtualTourURLUnbranded": "https://singlepropertywebsite.mohrrealestatemedia.com/271_grey_silo_rd-7910"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29878309/271-grey-silo-road-unit-29-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R9"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 2085
+"BelowGradeFinishedArea": 390
+"OriginalEntryTimestamp": "2026-06-09T20:00:59.93Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1308211"
+"ListOfficeNationalAssociationId": "1279868"
+"Media": array:44 [
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]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29878309')"
+"ID": "1512893"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25192
+post_id: "1510935"
+post_author: 1
+"ListingKey": "29876708"
+"ListingId": "X13420624"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T18:10:27Z"
+"RFModificationTimestamp": "2026-06-09T18:24:13Z"
+"ListPrice": 539900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G9"
+"UnparsedAddress": "312 - 251 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.5218383
1 => 43.5103022
]
+"Latitude": 43.5103022
+"Longitude": -80.5218383
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Beautiful residence nestled in one of Waterloo's most desirable communities, offering an exceptional blend of modern luxury, convenience, and lifestyle. Thoughtfully designed with elegant finishes throughout, this sophisticated 2-bed suite features expansive windows that flood the space with natural light, creating an airy and welcoming atmosphere. The primary bedroom features a spacious walk-through closet that leads to the ensuite bath. An additional full bathroom is perfect for guests or family. The stunning chef-inspired kitchen is complete with sleek stainless steel appliances, contemporary cabinetry, and stylish finishes that seamlessly flow into the open-concept living and dining areas. Rich laminate flooring extends throughout the unit, enhancing the home's refined aesthetic. Enjoy the two private balconies, including an exclusive retreat off the spacious primary bedroom; the perfect place to unwind with your morning coffee or evening glass of wine. Residents of Blackstone enjoy access to upscale amenities, including a residents' lounge and event space, co-working rooms, a fully equipped fitness studio, and beautifully designed outdoor terraces. This pet-friendly building even features a convenient dog washing station for your four-legged companions. High-speed internet is included in the condo fees for added value, and the owned parking space is an extra perk! Perfectly positioned near trails, RIM Park, St. Jacobs Farmer's Market, Conestoga Mall, and vibrant Uptown Waterloo this location offers effortless access to exceptional dining, shopping, recreation, and entertainment. Convenient highway access makes commuting simple, while the surrounding green spaces provide a peaceful connection to nature. Whether you are a professional seeking an elevated lifestyle, a first-time buyer looking for luxury and convenience, or an investor searching for a premium opportunity, this exceptional condo delivers. Experience sophisticated Waterloo living at its finest. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"AssociationFee": "788"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:2 [
0 => "Apartment in basement"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T18:02:32.806405+00:00"
+"Directions": "Cross Streets: Bridge St. ** Directions: NORTHFIELD DRIVE EAST."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1934633"
+"ListOfficeKey": "285253"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T17:02:24Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T18:04:48Z"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "251"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4424.3"
+"VirtualTourURLUnbranded": "https://video-api.supreme.one/CrjpcP?branded=true"
+"ListAOR": "OnePoint"
+"TaxYear": 2026
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29876708/312-251-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "5 Rivers"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-09T17:02:24.27Z"
+"ListAgentNationalAssociationId": "1234142"
+"ListOfficeNationalAssociationId": "1349485"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29876708')"
+"ID": "1510935"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25193
+post_id: "1499289"
+post_author: 1
+"ListingKey": "29860637"
+"ListingId": "X13248204"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T12:30:23Z"
+"RFModificationTimestamp": "2026-06-14T12:40:51Z"
+"ListPrice": 565000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G7"
+"UnparsedAddress": "102 - 247 GREY SILO ROAD, Waterloo, Ontario N2K0G7"
+"Coordinates": array:2 [
0 => -80.497131
1 => 43.522269
]
+"Latitude": 43.522269
+"Longitude": -80.497131
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 102 at 247 Grey Silo Road - one of Waterloo's most sought-after addresses. This beautifully appointed 2-bed, 2-bath ground-floor condo features luxury vinyl plank flooring, oversized windows, and brushed nickel hardware throughout. The open concept kitchen is a true highlight, featuring a large island, quartz countertops, KitchenAid stainless steel appliances, and an upgraded range hood - perfect for both cooking and entertaining. Just off the kitchen, step onto an enormous balcony with three distinct seating areas where BBQs are permitted - an entertainer's delight for gatherings or quiet evenings outdoors. The generously sized primary suite comfortably fits a king-size bed with room to spare, includes a double closet, and features a private ensuite with walk-in shower - perfect for downsizers. Modern bathrooms feature quartz vanities and comfort-height toilets, while additional upgrades include in-suite washer and dryer, a high efficiency water heater, water softener, and an HRV system for fresh air circulation year-round. Ground-floor entry keeps daily life effortless, and the rooftop terrace offers even more outdoor space to enjoy. Two owned parking spots included.Steps from Grey Silo Golf Course, the Walter Bean Trail, St. Jacobs Farmers' Market, RIM Park, and local restaurants - with easy access to Uptown Waterloo, both universities, and the expressway. Low-maintenance luxury living in one of Waterloo's most prestigious pockets (id:62650)"
+"Appliances": array:8 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Water Heater"
]
+"AssociationFee": "625.57"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Ventilation system"
]
+"CreationDate": "2026-06-05T17:29:16.857062+00:00"
+"Directions": "Cross Streets: University & Millennium. ** Directions: University to Millennium Blvd."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235403"
+"ListOfficeKey": "294121"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Elevator"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-06T13:12:35Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-14T12:23:41Z"
+"StreetName": "Grey Silo"
+"StreetNumber": "247"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4233.13"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29860637/102-247-grey-silo-road-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "King Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"ZoningDescription": "MR4-MD3"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-05T16:33:05.88Z"
+"ListAgentNationalAssociationId": "1473266"
+"ListOfficeNationalAssociationId": "1435796"
+"Media": array:26 [
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]
]
+"DaysOnMarket": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29860637')"
+"ID": "1499289"
}
]
+success: true
+page_size: 9
+page_count: 6
+count: 51
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]