array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29836433 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
+post_id: "1481800"
+post_author: 1
+"ListingKey": "29836433"
+"ListingId": "X13224894"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T22:20:09Z"
+"RFModificationTimestamp": "2026-06-30T22:27:16Z"
+"ListPrice": 1020000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2J9"
+"UnparsedAddress": "359 LEXINGTON ROAD, Waterloo, Ontario N2K2J9"
+"Coordinates": array:2 [
0 => -80.5032142
1 => 43.4989006
]
+"Latitude": 43.4989006
+"Longitude": -80.5032142
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to the home that makes every day feel like a vacation. This meticulously maintained 2-storey family home offers beautifully finished living space across three levels, combining timeless character, thoughtful updates, and an incredible backyard retreat that will have you rethinking summer getaways. The spacious kitchen features an oversized island with seating, abundant cabinetry, and generous prep space that is perfect for hosting family gatherings, holiday celebrations. Large windows throughout fill the home with natural light, creating warm and inviting spaces. With 4 bedrooms and 4 bathrooms, there is room for the entire family to spread out. The recently renovated main bathroom offers a spa-like experience with a luxurious deep soaker tub and skylight to let in the sunshine. The fully finished basement provides exceptional flexibility with additional living space and recreation areas ideal for teens, guests, multi-generational living, or work from home. Step outside and discover what truly sets this property apart. The private backyard oasis features a luxurious heated in ground fiberglass pool surrounded by expansive patio space and mature landscaping. Whether you're entertaining guests, enjoying family time, or simply unwinding after work, this outdoor retreat delivers resort-style living right at home. Additional highlights include a durable steel roof, recently upgraded gas fireplace, double-car garage, parking for six vehicles, abundant storage throughout, and pride of ownership evident in every corner of the property. Every update has been thoughtfully completed, creating a home that is move-in ready and designed to be enjoyed for years to come. Located close to schools, parks, shopping, and everyday amenities, this is more than a home-it's a lifestyle. Don't miss your opportunity to own this exceptional family home, where unforgettable summers, effortless entertaining, and everyday comfort come together in one remarkable property. (id:62650)"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-01T22:54:37.535361+00:00"
+"Directions": "Lexington Rd/Bridge St W"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1474342"
+"ListOfficeKey": "299885"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "65.6 x 148.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-01T21:55:33Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T22:10:39Z"
+"Stories": "2.0"
+"StreetName": "Lexington"
+"StreetNumber": "359"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6473.8"
+"VirtualTourURLUnbranded": "https://estate-shutter-portal.aryeo.com/videos/019e8357-4852-731f-b030-a69f8bc38f7c?v=362"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1672235155"
"RoomType" => "Living room"
"ListingId" => "X13224894"
"RoomLevel" => "Main level"
"RoomWidth" => 4.93
"ListingKey" => "29836433"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T22:10:39.81Z"
]
1 => array:11 [
"RoomKey" => "1672235156"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13224894"
"RoomLevel" => "Basement"
"RoomWidth" => 7.92
"ListingKey" => "29836433"
"RoomLength" => 7.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T22:10:39.81Z"
]
2 => array:11 [
"RoomKey" => "1672235157"
"RoomType" => "Bedroom 4"
"ListingId" => "X13224894"
"RoomLevel" => "Basement"
"RoomWidth" => 2.86
"ListingKey" => "29836433"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T22:10:39.81Z"
]
3 => array:11 [
"RoomKey" => "1672235158"
"RoomType" => "Laundry room"
"ListingId" => "X13224894"
"RoomLevel" => "Basement"
"RoomWidth" => 3.56
"ListingKey" => "29836433"
"RoomLength" => 3.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T22:10:39.81Z"
]
4 => array:11 [
"RoomKey" => "1672235159"
"RoomType" => "Bathroom"
"ListingId" => "X13224894"
"RoomLevel" => "Basement"
"RoomWidth" => 1.67
"ListingKey" => "29836433"
"RoomLength" => 2.98
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T22:10:39.81Z"
]
5 => array:11 [
"RoomKey" => "1672235160"
"RoomType" => "Dining room"
"ListingId" => "X13224894"
"RoomLevel" => "Main level"
"RoomWidth" => 3.08
"ListingKey" => "29836433"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T22:10:39.81Z"
]
6 => array:11 [
"RoomKey" => "1672235161"
"RoomType" => "Kitchen"
"ListingId" => "X13224894"
"RoomLevel" => "Main level"
"RoomWidth" => 5.63
"ListingKey" => "29836433"
"RoomLength" => 3.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T22:10:39.81Z"
]
7 => array:11 [
"RoomKey" => "1672235162"
"RoomType" => "Family room"
"ListingId" => "X13224894"
"RoomLevel" => "Main level"
"RoomWidth" => 3.74
"ListingKey" => "29836433"
"RoomLength" => 5.21
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T22:10:39.81Z"
]
8 => array:11 [
"RoomKey" => "1672235163"
"RoomType" => "Bathroom"
"ListingId" => "X13224894"
"RoomLevel" => "Main level"
"RoomWidth" => 1.73
"ListingKey" => "29836433"
"RoomLength" => 1.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T22:10:39.81Z"
]
9 => array:11 [
"RoomKey" => "1672235164"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13224894"
"RoomLevel" => "Second level"
"RoomWidth" => 5.63
"ListingKey" => "29836433"
"RoomLength" => 4.32
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T22:10:39.81Z"
]
10 => array:11 [
"RoomKey" => "1672235165"
"RoomType" => "Bathroom"
"ListingId" => "X13224894"
"RoomLevel" => "Second level"
"RoomWidth" => 1.46
"ListingKey" => "29836433"
"RoomLength" => 2.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T22:10:39.82Z"
]
11 => array:11 [
"RoomKey" => "1672235166"
"RoomType" => "Bedroom 2"
"ListingId" => "X13224894"
"RoomLevel" => "Second level"
"RoomWidth" => 3.38
"ListingKey" => "29836433"
"RoomLength" => 2.77
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T22:10:39.82Z"
]
12 => array:11 [
"RoomKey" => "1672235167"
"RoomType" => "Bedroom 3"
"ListingId" => "X13224894"
"RoomLevel" => "Second level"
"RoomWidth" => 3.38
"ListingKey" => "29836433"
"RoomLength" => 3.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T22:10:39.82Z"
]
13 => array:11 [
"RoomKey" => "1672235168"
"RoomType" => "Bathroom"
"ListingId" => "X13224894"
"RoomLevel" => "Second level"
"RoomWidth" => 2.89
"ListingKey" => "29836433"
"RoomLength" => 2.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T22:10:39.82Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29836433/359-lexington-road-waterloo"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2185334"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299885"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 65.7
+"OriginalEntryTimestamp": "2026-06-01T21:55:33.75Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1129773"
+"ListOfficeNationalAssociationId": "1478640"
+"CoListAgentNationalAssociationId": "1435541"
+"CoListOfficeNationalAssociationId": "1478640"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29836433_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/7f366af55e311c1203b620e9d53b0d7a.webp"
"MediaSize" => 369092
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-7f366af55e311c1203b620e9d53b0d7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29836433_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/a638ff28456a2985cbf8126fbd096696.webp"
"MediaSize" => 366182
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-a638ff28456a2985cbf8126fbd096696.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29836433_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/8ffcc99662473738bac53b5f9b661279.webp"
"MediaSize" => 389905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-8ffcc99662473738bac53b5f9b661279.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29836433_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/15f551c149ad7f265bae2c8aeb07695e.webp"
"MediaSize" => 277155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-15f551c149ad7f265bae2c8aeb07695e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29836433_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/188c18a9215c9a4110db5faf867986a8.webp"
"MediaSize" => 130485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-188c18a9215c9a4110db5faf867986a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29836433_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/e04fa37abacf32c81e2f0e55c005215a.webp"
"MediaSize" => 223635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-e04fa37abacf32c81e2f0e55c005215a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29836433_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/c2aca08e4f83484bb5713055a002a702.webp"
"MediaSize" => 207976
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-c2aca08e4f83484bb5713055a002a702.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29836433_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/bc2bbe60aef7e7f3ab1342801391c52c.webp"
"MediaSize" => 229337
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-bc2bbe60aef7e7f3ab1342801391c52c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29836433_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/d201e963c57798773eac606e13f46fb5.webp"
"MediaSize" => 183315
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-d201e963c57798773eac606e13f46fb5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29836433_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/ef4b3a6a0c51dce7b8c9779f28af07f5.webp"
"MediaSize" => 212872
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-ef4b3a6a0c51dce7b8c9779f28af07f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29836433_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/82c3b37d0f581fb0a0810ecafa1a1b81.webp"
"MediaSize" => 142141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-82c3b37d0f581fb0a0810ecafa1a1b81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29836433_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/ad41102f2c239b4c56cdb28fd1457b53.webp"
"MediaSize" => 168678
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-ad41102f2c239b4c56cdb28fd1457b53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29836433_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/bb2d8dd36746928db19760f9076eb7c0.webp"
"MediaSize" => 156496
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-bb2d8dd36746928db19760f9076eb7c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29836433_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/4961c074964071296bd98c58cf773470.webp"
"MediaSize" => 188074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-4961c074964071296bd98c58cf773470.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29836433_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/3ce01fe94ceab64d47a157b98dc5c924.webp"
"MediaSize" => 200774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-3ce01fe94ceab64d47a157b98dc5c924.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29836433_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/a105a36dc04373572854d6f622084723.webp"
"MediaSize" => 165530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-a105a36dc04373572854d6f622084723.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29836433_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/f8ef6e66b5fb188cdf43f31b4b9f65c7.webp"
"MediaSize" => 196184
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-f8ef6e66b5fb188cdf43f31b4b9f65c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29836433_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/4c588d92a2cf3e4b33e7b2f087d0b989.webp"
"MediaSize" => 214793
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-4c588d92a2cf3e4b33e7b2f087d0b989.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29836433_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/978d98e00b5609dde85a600eb714b605.webp"
"MediaSize" => 256465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-978d98e00b5609dde85a600eb714b605.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29836433_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/4f4def61303cc50f048a601d7ba61b25.webp"
"MediaSize" => 119204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-4f4def61303cc50f048a601d7ba61b25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29836433_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/2b22c867e81fdab507bb9ab4f99f9866.webp"
"MediaSize" => 156500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-2b22c867e81fdab507bb9ab4f99f9866.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29836433_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/68e9e929be341137c2eda9b057dcfc5b.webp"
"MediaSize" => 121901
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-68e9e929be341137c2eda9b057dcfc5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29836433_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/51261fc180f8c1835061a41092c35e57.webp"
"MediaSize" => 195220
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-51261fc180f8c1835061a41092c35e57.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29836433_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/4a237f1949c7e6a3946266a6c1913cd9.webp"
"MediaSize" => 226202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-4a237f1949c7e6a3946266a6c1913cd9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29836433_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/625904724a5f2c1984ba42def48c0e1c.webp"
"MediaSize" => 197859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-625904724a5f2c1984ba42def48c0e1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29836433_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/4f28a44ae917c94bbdd787babb155e04.webp"
"MediaSize" => 166582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-4f28a44ae917c94bbdd787babb155e04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29836433_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/d43af661bed4e3540d0719bf3874a235.webp"
"MediaSize" => 147750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-d43af661bed4e3540d0719bf3874a235.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29836433_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/7119deddc91c9fb9cdd686738b167d21.webp"
"MediaSize" => 134131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-7119deddc91c9fb9cdd686738b167d21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29836433_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/d49abea0b39dbe02495c47c0cad72bda.webp"
"MediaSize" => 151569
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-d49abea0b39dbe02495c47c0cad72bda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29836433_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/8e2ef5b5e7b2f44d743179850ca3ff70.webp"
"MediaSize" => 166119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-8e2ef5b5e7b2f44d743179850ca3ff70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29836433_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/d8e4157d1e2f09299f66cfd9eefd213e.webp"
"MediaSize" => 153873
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-d8e4157d1e2f09299f66cfd9eefd213e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29836433_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/006526d05a804141dfc689976ed4738d.webp"
"MediaSize" => 136634
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-006526d05a804141dfc689976ed4738d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29836433_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/4a4292e981f28eddfcd31c438a0c1824.webp"
"MediaSize" => 176339
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-4a4292e981f28eddfcd31c438a0c1824.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29836433_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/a684fc85fcb0f8b933c31b1ec5109df6.webp"
"MediaSize" => 169510
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-a684fc85fcb0f8b933c31b1ec5109df6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29836433_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/6af9295bb3551c55eb8b7271c5335e15.webp"
"MediaSize" => 108883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-6af9295bb3551c55eb8b7271c5335e15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29836433_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/51f25f77fa37a771c92d8f9f216d8b9c.webp"
"MediaSize" => 148628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-51f25f77fa37a771c92d8f9f216d8b9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29836433_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/c2cdfaf442d8d36df89759994052d092.webp"
"MediaSize" => 183310
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-c2cdfaf442d8d36df89759994052d092.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29836433_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/fd2ba3dec2fe00a797c2507b4893018c.webp"
"MediaSize" => 346328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-fd2ba3dec2fe00a797c2507b4893018c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29836433_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/142ca716d64e209c5771eb273c8da079.webp"
"MediaSize" => 436372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-142ca716d64e209c5771eb273c8da079.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29836433_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/00299616644e0b743714c28aa15dce5c.webp"
"MediaSize" => 373642
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-00299616644e0b743714c28aa15dce5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29836433_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/4d4de4c7f0e39f3641231c7c42841f49.webp"
"MediaSize" => 353001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-4d4de4c7f0e39f3641231c7c42841f49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29836433_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/22b50084634ebb7eb1e6cfc798c529bb.webp"
"MediaSize" => 440155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-22b50084634ebb7eb1e6cfc798c529bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29836433_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/a4843f95730802639107834799fca131.webp"
"MediaSize" => 435126
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-a4843f95730802639107834799fca131.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29836433_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/d342bab0a064ebe0233c45ec47dbf351.webp"
"MediaSize" => 345308
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-d342bab0a064ebe0233c45ec47dbf351.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29836433_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/cfdba8e392174eb26c06162ab7b69963.webp"
"MediaSize" => 296873
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-cfdba8e392174eb26c06162ab7b69963.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29836433_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/08e3db87c289fb35c69a635a5ba992fe.webp"
"MediaSize" => 323949
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-08e3db87c289fb35c69a635a5ba992fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29836433_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/d1559611f50081bbad661cd92f233171.webp"
"MediaSize" => 527040
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-d1559611f50081bbad661cd92f233171.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29836433_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/fa0e59094166acbba4bed491b340240f.webp"
"MediaSize" => 252860
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-fa0e59094166acbba4bed491b340240f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "29836433_4890_49"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/1602f5578d28024e8c5ca013d1e6346d.webp"
"MediaSize" => 408192
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-1602f5578d28024e8c5ca013d1e6346d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
49 => array:13 [
"Order" => 50
"MediaKey" => "29836433_4890_50"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836433/c837f141b732693dd0f305b2c2ed3a67.webp"
"MediaSize" => 397820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836433/thumbnail-c837f141b732693dd0f305b2c2ed3a67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13224894"
"ResourceRecordKey" => "29836433"
"ModificationTimestamp" => "2026-06-01T21:55:33.76Z"
]
]
+"DaysOnMarket": 32
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29836433')"
+"ID": "1481800"
}
]
+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 299885" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24922
+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 1474342" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24880
+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 '29836433'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25287
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29836433'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25306
+items: array:3 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25303
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31421136"
+"ListingKey": "29836433"
+"ListingId": "X13224894"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-20"
+"OpenHouseStartTime": "2026-06-20T14:00:00Z"
+"OpenHouseEndTime": "2026-06-20T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-11T14:29:32Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31421136')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25305
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31430069"
+"ListingKey": "29836433"
+"ListingId": "X13224894"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-20"
+"OpenHouseStartTime": "2026-06-20T14:00:00Z"
+"OpenHouseEndTime": "2026-06-20T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-15T14:13:48Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31430069')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25302
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31495985"
+"ListingKey": "29836433"
+"ListingId": "X13224894"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-20"
+"OpenHouseStartTime": "2026-06-20T14:00:00Z"
+"OpenHouseEndTime": "2026-06-20T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-21T03:35:40Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31495985')"
}
]
+success: true
+page_size: 3
+page_count: 1
+count: 3
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29836433' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5032142 43.4989006)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25405
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25376
+post_id: "1591137"
+post_author: 1
+"ListingKey": "29987150"
+"ListingId": "40844520"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T20:35:12Z"
+"RFModificationTimestamp": "2026-07-03T23:19:32Z"
+"ListPrice": 1247000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3235.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4G5"
+"UnparsedAddress": "517 STARBOARD Crescent, Waterloo, Ontario N2K4G5"
+"Coordinates": array:2 [
0 => -80.5062174
1 => 43.5105961
]
+"Latitude": 43.5105961
+"Longitude": -80.5062174
+"YearBuilt": 2004
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 517 Starboard Crescent, Waterloo, a beautifully maintained bungalow offering 3 bedrooms, 3 bathrooms, and a spacious open-concept layout designed for comfortable everyday living and entertaining. Step inside to the welcoming foyer where you're greeted by an airy floor plan. To the right, the formal living room features a cozy gas fireplace and skylight, creating a bright and inviting space. The living room flows seamlessly into the dining area and spacious kitchen, complete with granite countertops, stainless steel appliances, abundant cabinetry, generous prep space, and a large centre island with breakfast bar seating. A convenient door off the kitchen provides easy access to the backyard. The main floor also features updated hardwood flooring throughout, a convenient mudroom/laundry room with direct access to the double garage, and a 3-piece bathroom. Two bedrooms are located on this level, including the spacious primary suite with a walk-in closet and a luxurious 5-piece ensuite. The finished basement expands your living space with a large recreation room highlighted by a stylish gas fireplace, an additional bedroom, and a 3-piece bathroom—ideal for guests, extended family, or a home office. Step outside to your private backyard retreat featuring an inground saltwater pool and patio area, perfect for relaxing or entertaining all summer long. Complete with a double car garage and parking for up to six vehicles in the driveway, this exceptional home offers the perfect combination of space, comfort, and lifestyle in a sought-after Waterloo neighbourhood. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T23:19:24.529023+00:00"
+"Directions": "Chesapeake Drive to Starboard Cres"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908292"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T20:33:15Z"
+"PhotosCount": 48
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T20:33:15Z"
+"Stories": "1.0"
+"StreetName": "STARBOARD"
+"StreetNumber": "517"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "7992.01"
+"VirtualTourURLUnbranded": "https://youriguide.com/517_starboard_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1674395024"
"RoomType" => "Utility room"
"ListingId" => "40844520"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "31'4'' x 18'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.98Z"
]
1 => array:11 [
"RoomKey" => "1674395025"
"RoomType" => "Recreation room"
"ListingId" => "40844520"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "31'4'' x 19'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.98Z"
]
2 => array:11 [
"RoomKey" => "1674395026"
"RoomType" => "Cold room"
"ListingId" => "40844520"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 18'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.98Z"
]
3 => array:11 [
"RoomKey" => "1674395027"
"RoomType" => "Bedroom"
"ListingId" => "40844520"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 16'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
4 => array:11 [
"RoomKey" => "1674395028"
"RoomType" => "3pc Bathroom"
"ListingId" => "40844520"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
5 => array:11 [
"RoomKey" => "1674395029"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987150"
…5
]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29987150/517-starboard-crescent-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 64.0
+"AboveGradeFinishedArea": 1623
+"BelowGradeFinishedArea": 1613
+"OriginalEntryTimestamp": "2026-07-03T20:29:14.95Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1221205"
+"ListOfficeNationalAssociationId": "1378680"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29987150')"
+"ID": "1591137"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25378
+post_id: "1590600"
+post_author: 1
+"ListingKey": "29986048"
+"ListingId": "40843697"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T18:25:13Z"
+"RFModificationTimestamp": "2026-07-03T19:51:49Z"
+"ListPrice": 524900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 7.26
+"LivingArea": 801.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2H1"
+"UnparsedAddress": "255 NORTHFIELD Drive E Unit# 505, Waterloo, Ontario N2V2H1"
+"Coordinates": array:2 [
0 => -80.5214326
1 => 43.5107434
]
+"Latitude": 43.5107434
+"Longitude": -80.5214326
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Blackstone Condominiums, one of Waterloo's most sought-after communities, where modern design, exceptional amenities, and an unbeatable location come together. This beautifully maintained 2-bedroom, 2-bathroom suite offers over 800 sq. ft. of stylish living space with contemporary finishes throughout. The bright open-concept layout is designed for everyday living and entertaining, featuring a modern kitchen with quartz countertops, stainless steel appliances, a white subway tile backsplash, ample cabinetry, and a spacious island overlooking the living and dining area. Expansive windows fill the home with natural light, while the generous balcony provides the perfect place to enjoy your morning coffee. At the end of the day, retreat to the spacious primary bedroom featuring a private ensuite. The second bedroom and additional full bathroom offer flexible space for guests, family, or a dedicated home office. In-suite laundry and an exclusive surface parking space add everyday convenience. Residents of Blackstone enjoy an exceptional collection of amenities, including a fully equipped fitness centre, co-working/business lounge, an impressive party room, games and media room, rooftop terrace, landscaped gardens, bike storage, pet wash station, and BBQ areas. Even better, the condo fees include heat, high-speed internet, building insurance, building and grounds maintenance, common elements, snow removal, private garbage collection, roof maintenance, property management, and parking, providing outstanding value and predictable monthly expenses. Perfectly located just minutes from Conestoga Mall, the ION LRT, RIM Park, Walter Bean Trail, Grey Silo Golf Club, St. Jacobs Farmers' Market, the University of Waterloo, Wilfrid Laurier University, and an excellent selection of shopping, cafés, and restaurants right at your doorstep, this home is ideal for professionals, first-time buyers, downsizers, and investors alike. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Heat"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T19:51:46.539329+00:00"
+"Directions": "NORTHFIELD TO BRIDGE ST"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2238484"
+"ListOfficeKey": "292003"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"LotSizeDimensions": "7.26"
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-03T18:18:33Z"
+"PhotosCount": 8
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:18:33Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3752.53"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29986048/255-northfield-drive-e-unit-505-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2059475"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "292003"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 158.0
+"AboveGradeFinishedArea": 801
+"OriginalEntryTimestamp": "2026-07-03T18:18:33.17Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1476314"
+"ListOfficeNationalAssociationId": "1407357"
+"CoListAgentNationalAssociationId": "1334623"
+"CoListOfficeNationalAssociationId": "1407357"
+"Media": array:8 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986048')"
+"ID": "1590600"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25375
+post_id: "1590601"
+post_author: 1
+"ListingKey": "29986089"
+"ListingId": "X13519890"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T18:35:15Z"
+"RFModificationTimestamp": "2026-07-03T19:48:02Z"
+"ListPrice": 524900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2H1"
+"UnparsedAddress": "505 - 255 NORTHFIELD DRIVE E, Waterloo, Ontario N2V2H1"
+"Coordinates": array:2 [
0 => -80.521297
1 => 43.510381
]
+"Latitude": 43.510381
+"Longitude": -80.521297
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to Blackstone Condominiums, one of Waterloo's most sought-after communities, where modern design, exceptional amenities, and an unbeatable location come together. This beautifully maintained 2-bedroom, 2-bathroom suite offers over 800 sq. ft. of stylish living space with contemporary finishes throughout. The bright open-concept layout is designed for everyday living and entertaining, featuring a modern kitchen with quartz countertops, stainless steel appliances, a white subway tile backsplash, ample cabinetry, and a spacious island overlooking the living and dining area. Expansive windows fill the home with natural light, while the generous balcony provides the perfect place to enjoy your morning coffee. At the end of the day, retreat to the spacious primary bedroom featuring a private ensuite. The second bedroom and additional full bathroom offer flexible space for guests, family, or a dedicated home office. In-suite laundry and an exclusive surface parking space add everyday convenience. Residents of Blackstone enjoy an exceptional collection of amenities, including a fully equipped fitness centre, co-working/business lounge, an impressive party room, games and media room, rooftop terrace, landscaped gardens, bike storage, pet wash station, and BBQ areas. Even better, the condo fees include heat, high-speed internet, building insurance, building and grounds maintenance, common elements, snow removal, private garbage collection, roof maintenance, property management, and parking, providing outstanding value and predictable monthly expenses. Perfectly located just minutes from Conestoga Mall, the ION LRT, RIM Park, Walter Bean Trail, Grey Silo Golf Club, St. Jacobs Farmers' Market, the University of Waterloo, Wilfrid Laurier University, and an excellent selection of shopping, cafés, and restaurants right at your doorstep, this home is ideal for professionals, first-time buyers, downsizers, and investors alike. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Heat"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "School Bus"
1 => "Community Centre"
2 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T19:47:55.686450+00:00"
+"Directions": "Cross Streets: NORTHFIELD/BRIDGE. ** Directions: NORTHFIELD TO BRIDGE ST."
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1899457"
+"ListOfficeKey": "292096"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Flat site"
1 => "Conservation/green belt"
2 => "Elevator"
3 => "Balcony"
4 => "Dry"
5 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T18:25:30Z"
+"PhotosCount": 8
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:25:30Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3752.53"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29986089/505-255-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2059475"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Five River Prop Mgrs"
+"CoListAgentKey2": "1834162"
+"CoListOfficeKey": "292096"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Party Room"
2 => "Security/Concierge"
3 => "Visitor Parking"
]
+"CoListOfficeKey2": "293196"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-03T18:25:30.01Z"
+"ListAgentNationalAssociationId": "1216506"
+"ListOfficeNationalAssociationId": "1408169"
+"CoListAgentNationalAssociationId": "1334623"
+"CoListAgentNationalAssociationId2": "1196633"
+"CoListOfficeNationalAssociationId": "1408169"
+"CoListOfficeNationalAssociationId2": "1423680"
+"Media": array:8 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986089')"
+"ID": "1590601"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25379
+post_id: "1589769"
+post_author: 1
+"ListingKey": "29984026"
+"ListingId": "40844904"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T19:05:17Z"
+"RFModificationTimestamp": "2026-07-03T19:06:07Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1753.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0E8"
+"UnparsedAddress": "532 WISMER Street, Waterloo, Ontario N2K0E8"
+"Coordinates": array:2 [
0 => -80.4878425
1 => 43.4990626
]
+"Latitude": 43.4990626
+"Longitude": -80.4878425
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Freehold End-Unit Townhome with No Condo Fees! Welcome to this beautifully updated freehold end-unit townhome, where extra windows, added privacy, and a larger fenced yard create the feel of a semi-detached home—all with no condo fees. The welcoming ground level features a versatile flex space, ideal as a home office, guest room, gym, or playroom, adapting effortlessly to your lifestyle. Upstairs, the bright and airy open-concept main living area is designed for both everyday living and entertaining. The stylish kitchen boasts quartz countertops, stainless steel appliances, and a spacious eat-in area, while still offering room for a separate dining space. The inviting living room opens through sliding doors to an elevated deck with stairs leading down to the fully fenced backyard—perfect for summer barbecues, children, or pets. A convenient two-piece powder room completes this level.The upper floor offers a spacious primary retreat featuring a walk-in closet and private ensuite bathroom. Two additional generously sized bedrooms and a second full bathroom provide comfortable space for family or guests. Situated in a fantastic Waterloo location close to parks, schools, shopping, universities, transit, and everyday amenities, this move-in-ready home is an exceptional opportunity for first-time buyers, young families, professionals, or investors looking for a low-maintenance property in a highly desirable neighbourhood. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T17:12:14.864059+00:00"
+"Directions": "University/Woolwich"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563569"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T14:18:21Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:59:24Z"
+"Stories": "3.0"
+"StreetName": "WISMER"
+"StreetNumber": "532"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "5302"
+"VirtualTourURLUnbranded": "https://youriguide.com/532_wismer_st_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/29984026/532-wismer-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1600603"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2246706"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "76826"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 34.0
+"AboveGradeFinishedArea": 1753
+"BelowGradeFinishedArea": 0
+"OriginalEntryTimestamp": "2026-07-03T14:18:21.44Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1109914"
+"ListOfficeNationalAssociationId": "1389824"
+"CoListAgentNationalAssociationId": "1145016"
+"CoListAgentNationalAssociationId2": "1485557"
+"CoListOfficeNationalAssociationId": "1004387"
+"CoListOfficeNationalAssociationId2": "1004387"
+"Media": array:43 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29984026')"
+"ID": "1589769"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25377
+post_id: "1590387"
+post_author: 1
+"ListingKey": "29984547"
+"ListingId": "X13518412"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T15:30:04Z"
+"RFModificationTimestamp": "2026-07-03T17:08:31Z"
+"ListPrice": 999999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Prince Edward County (Sophiasburg Ward)"
+"PostalCode": "K0K1W0"
+"UnparsedAddress": "213 GOMORRAH ROAD, Prince Edward County (Sophiasburg Ward), Ontario K0K1W0"
+"Coordinates": array:2 [
0 => -80.499587
1 => 43.507364
]
+"Latitude": 43.507364
+"Longitude": -80.499587
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Central Lakes Association of REALTORS®"
+"PublicRemarks": "Nestled in a serene historical hamlet of Prince Edward County, this magnificent two-storey country home sits on a picturesque 2.6-acre parcel, featuring Smith's Creek gently meandering through the property behind a beautifully restored multi-level Dutch barn. Cross the creek via a quaint bridge to discover a spacious garden area perfect for quiet enjoyment of outdoor gatherings. Meticulous care has been taken to preserve the original character of this century home. The main floor welcomes you with grand 8-ft double library doors leading to both the formal living room and the cozy family room. Each space is enhanced by original pine flooring, elegant trim, soaring ceilings, and the inviting glow of propane fireplaces. The living room also boasts an intricately designed tin ceiling, adding a touch of period charm. The newly installed kitchen (2022) was thoughtfully crafted to harmonize with the home's historic aesthetic. It offers abundant cabinetry, a central island, and opens into the bright dining area, which leads to a large deck overlooking the grounds. This deck connects seamlessly with the inviting wraparound covered porch - ideal for enjoying peaceful country views. Upstairs, the second level features four comfortable bedrooms, a spacious 4-piece bathroom, and a large walk-in storage closet. Original hardwood floors and woodwork continue throughout, preserving the timeless warmth and character of the home. The impressive multi-level barn, dating back to the late 1800's, has undergone significant structural improvements, including foundation reinforcement and interior refinishing with rustic pine planks. Currently used for dry storage, its versatile design and unique atmosphere make it a perfect venue for festive events or creative ventures. Surrounded by farmland and forest teeming with local wildlife and bird species, this one-of-a-kind property offers a rare opportunity to own a piece of County heritage, with all the tranquility and beauty of rural living. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Oven"
7 => "Dryer"
8 => "Microwave"
9 => "Oven - Built-In"
10 => "Water Treatment"
11 => "Window Coverings"
12 => "Water Heater"
]
+"Basement": array:5 [
0 => "Unfinished"
1 => "Partial"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T17:08:24.679771+00:00"
+"Directions": "Cross Streets: County Road 14 & County Road 15. ** Directions: Follow County Roads 14 or 15 to Gomorrah, just outside of Demorestville."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1433818"
+"ListOfficeKey": "211195"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Level lot"
1 => "Sloping"
2 => "Open space"
3 => "Level"
]
+"LotSizeDimensions": "293.5 x 500 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T15:20:58Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T15:20:58Z"
+"Stories": "2.0"
+"StreetName": "Gomorrah"
+"StreetNumber": "213"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "2824.93"
+"Utilities": array:4 [
0 => "Electricity"
1 => "Telephone"
2 => "Wireless"
3 => "Electricity Connected"
]
+"View": "View of water,Direct Water View"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/213_gommorah_rd_prince_edward_on/"
+"WaterSource": array:1 [
0 => "Dug Well"
]
+"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": "Central Lakes"
+"CityRegion": "Sophiasburg Ward"
+"ListAORKey": "88"
+"ListingURL": "www.realtor.ca/real-estate/29984547/213-gomorrah-road-prince-edward-county-sophiasburg-ward-sophiasburg-ward"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "RR1"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 293.6
+"OriginalEntryTimestamp": "2026-07-03T15:20:58.7Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1117495"
+"ListOfficeNationalAssociationId": "1193887"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29984547')"
+"ID": "1590387"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25372
+post_id: "1587688"
+post_author: 1
+"ListingKey": "29982473"
+"ListingId": "40843934"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T16:55:14Z"
+"RFModificationTimestamp": "2026-07-03T17:09:22Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2845.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3P2"
+"UnparsedAddress": "570 HALLMARK Drive, Waterloo, Ontario N2K3P2"
+"Coordinates": array:2 [
0 => -80.5232066
1 => 43.5004294
]
+"Latitude": 43.5004294
+"Longitude": -80.5232066
+"YearBuilt": 1989
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Location, Location, Location. Lovely 2 storey home in sought after 'Colonial Acres', backing onto trees and the privacy of Anndale Park with no neighbours behind. This home features two 2 Bedrooms up with new flooring and both with 4pc Ensuites. The main floor has a spacious Living room, formal Dining room, TV room with hardwood floor, 2pc Powder room and a walk-out to a deck with a retractable awning.The bright basement has a finished Recreation room with walk-out leading to a fenced yard, a 3pc Bath, an additional 3rd Bedroom, laundry and storage. This home has been well maintained throughout, with additional insulation added to the attic. This home is ideally located providing ameneties for the whole family, being steps from Conestoga Mall, LRT Transit Hub, Grey Silo Golf course, RIM Park recreation centre, walking trails, St. Jacob’s Farmers market, great schools and offering convenient access to the Expressway. A great place to call Home. (id:62650)"
+"Appliances": array:10 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Freezer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T00:59:43.127043+00:00"
+"Directions": "Davenport Rd to Hallmark Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563939"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Southern exposure"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Paved driveway"
4 => "Sump Pump"
5 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T23:10:26Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T16:48:31Z"
+"Stories": "2.0"
+"StreetName": "HALLMARK"
+"StreetNumber": "570"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "6316.27"
+"VirtualTourURLUnbranded": "https://youriguide.com/570_hallmark_dr_waterloo_on/"
+"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/29982473/570-hallmark-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1775
+"BelowGradeFinishedArea": 1070
+"OriginalEntryTimestamp": "2026-07-02T23:10:26.09Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070118"
+"ListOfficeNationalAssociationId": "1473831"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29982473')"
+"ID": "1587688"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1586352"
+post_author: 1
+"ListingKey": "29981569"
+"ListingId": "X13515546"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T22:20:15Z"
+"RFModificationTimestamp": "2026-07-02T22:40:22Z"
+"ListPrice": 949900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2K4J6"
+"UnparsedAddress": "21 HAWKSWOOD DRIVE, Kitchener, Ontario N2K4J6"
+"Coordinates": array:2 [
0 => -80.479908
1 => 43.495014
]
+"Latitude": 43.495014
+"Longitude": -80.479908
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To 21 Hawkswood Drive - A Rare Offering In Kiwanis Park Community Of Kitchener! This Stunning Home Offers Approx. 3,000 Sq. Ft. Of Beautifully Finished Living Space, Thoughtfully Designed For Modern Family Living And Effortless Entertaining. Step Into A Grand Foyer Leading To An Elegant Open-Concept Layout Featuring Spacious Principal Rooms, Large Sun-Filled Windows, And A Functional Floor Plan That Perfectly Balances Comfort And Style. The Chef-Inspired Kitchen Seamlessly Flows Into The Living And Dining Areas, Creating The Ideal Space For Everyday Living, Family GatheringsThe Upper Level Showcases A Luxurious Primary Retreat Complete With A Spa-Inspired Ensuite Featuring Sophisticated Tile Work, Modern Finishes, And A Spacious Walk-In Closet. 2 Additional Generous Bedrooms Plus A Remarkable Loft Space Offer Exceptional Versatility-Perfect For A Home Office, Kids' Playroom, Media Lounge, Or Easily Convertible Into One Or Even Two Additional Bedrooms To Suit Your Family's Needs.The Finished Basement Further Expands The Living Space And Offers A Recreation Area, Or Theatre Room-An Excellent Option For Guests or Extended Family.A Standout Feature Is The Private Sauna In The Basement, Providing A Spa-Like Retreat And The Perfect Space To Relax And Unwind In The Comfort Of Your Own Home.Step Outside To A Beautifully Landscaped Private Backyard Featuring A Huge Deck And Walkways, Offering The Perfect Setting For Summer BBQs, Relaxation, And Outdoor Entertaining. The Double-Car Garage Plus Two Additional Driveway Parking Spaces Provide Everyday Convenience, While The Attractive Curb Appeal And Low-Maintenance Exterior Add Lasting Value.This Home Is Located Within A Tight-Knit Community Known For Its Pride Of Ownership, Municipal Oversight, And Added Peace Of Mind. Enjoy Direct Access To Kiwanis Park, Extensive Hiking And Walking Trails, Scenic Biking Routes, Grand River Fishing Areas, Playgrounds, And Beautiful Natural Green Spaces Right At Your Doorstep. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T22:34:00.079995+00:00"
+"Directions": "Cross Streets: Woolwich Str. ** Directions: Woolwich Street/Hawkswood."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2009588"
+"ListOfficeKey": "164016"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "42.5 x 101.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T21:16:19Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T22:13:56Z"
+"Stories": "2.0"
+"StreetName": "Hawkswood"
+"StreetNumber": "21"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6566.22"
+"VirtualTourURLUnbranded": "https://media.relavix.com/21-hawkswood-drive-kitchener/?unbranded=true"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29981569/21-hawkswood-drive-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1953365"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "164016"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 42.6
+"OriginalEntryTimestamp": "2026-07-02T21:16:19.76Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1291294"
+"ListOfficeNationalAssociationId": "1184644"
+"CoListAgentNationalAssociationId": "1246702"
+"CoListOfficeNationalAssociationId": "1184644"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29981569')"
+"ID": "1586352"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25380
+post_id: "1585507"
+post_author: 1
+"ListingKey": "29980548"
+"ListingId": "40844709"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T19:45:15Z"
+"RFModificationTimestamp": "2026-07-02T19:48:31Z"
+"ListPrice": 360000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 989.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4G2"
+"UnparsedAddress": "224 HARVARD Place, Waterloo, Ontario N2J4G2"
+"Coordinates": array:2 [
0 => -80.5035366
1 => 43.4833084
]
+"Latitude": 43.4833084
+"Longitude": -80.5035366
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Incredible opportunity to own this stunning, fully renovated condo offering stylish, turnkey living in an unbeatable location! Updated from top to bottom with exceptional attention to detail, this home blends modern finishes with comfort and functionality throughout. The gorgeous new kitchen (2026) is sure to impress, featuring sleek cabinetry with soft-close doors, elegant gold hardware, and brand-new stainless steel appliances including a fridge, stove, and dishwasher. Luxury vinyl flooring (2026) flows seamlessly throughout the home, creating a warm and contemporary feel. The beautifully redesigned bathroom (2026) offers a spa-inspired retreat complete with new tile flooring, a modern vanity, updated fixtures, and a new bathtub with sliding glass doors. Freshly painted in a modern colour palette, every inch of this home feels bright, fresh, and inviting. The spacious living room opens through sliding doors to your own private, backyard oasis, the perfect spot to unwind, entertain, or enjoy your morning coffee. Owned Parking spot is steps from your front door, making it very convenient. Located in a highly desirable Waterloo neighbourhood close to schools, shopping, universities, parks, and easy highway access, this home offers the perfect combination of style, convenience, and low-maintenance living. Absolutely nothing to do but move in and enjoy. This home is a must-see! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "471"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T19:38:35.932906+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1881902"
+"ListOfficeKey": "283386"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Cul-de-sac"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-02T19:11:06Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T19:32:25Z"
+"Stories": "4.0"
+"StreetName": "HARVARD"
+"StreetNumber": "224"
+"StreetSuffix": "Place"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "2191.36"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/224G-Harvard-Pl"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29980548/224g-harvard-place-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2186110"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "283386"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 989
+"OriginalEntryTimestamp": "2026-07-02T19:11:06.07Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1206941"
+"ListOfficeNationalAssociationId": "1328478"
+"CoListAgentNationalAssociationId": "1435727"
+"CoListOfficeNationalAssociationId": "1328478"
+"Media": array:21 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29980548')"
+"ID": "1585507"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25404
+post_id: "1585240"
+post_author: 1
+"ListingKey": "29980078"
+"ListingId": "X13514038"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T18:40:18Z"
+"RFModificationTimestamp": "2026-07-02T19:13:12Z"
+"ListPrice": 724900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4L7"
+"UnparsedAddress": "765 ANGLER WAY, Waterloo, Ontario N2K4L7"
+"Coordinates": array:2 [
0 => -80.5001427
1 => 43.5145232
]
+"Latitude": 43.5145232
+"Longitude": -80.5001427
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "765 Angler Way, Waterloo is a spacious 3-bedroom, 2.5-bathroom home offering 1,437 sq ft above grade plus a finished basement. Located in one of north Waterloo's most highly sought-after family neighbourhoods on a quiet dead-end street, this property offers privacy, safety for children, and a true sense of community. The main floor includes a convenient 2-piece powder room, while the second level features three good-sized bedrooms and a 4-piece bathroom. The finished basement provides flexible living space with a basic rec room and 3-piece bathroom. Outside, enjoy the large back patio ideal for BBQs and relaxing in the private yard. With excellent access to top schools, parks, and amenities, this home is perfect for families looking to put down roots in a desirable location. (id:62650)"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T19:13:10.994697+00:00"
+"Directions": "Cross Streets: University. ** Directions: University to New Hampshire."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2154832"
+"ListOfficeKey": "285194"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "28 x 98.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T18:32:27Z"
+"PhotosCount": 24
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T18:32:27Z"
+"Stories": "2.0"
+"StreetName": "Angler"
+"StreetNumber": "765"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "4452"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/o6z5m_765_angler_way_waterloo_on/"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29980078/765-angler-way-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 28.0
+"OriginalEntryTimestamp": "2026-07-02T18:32:27.6Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1406273"
+"ListOfficeNationalAssociationId": "1348537"
+"Media": array:24 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29980078')"
+"ID": "1585240"
}
]
+success: true
+page_size: 9
+page_count: 10
+count: 86
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]