array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29986048 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23447
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23449
+post_id: "1590600"
+post_author: 1
+"ListingKey": "29986048"
+"ListingId": "40843697"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T15:35:22Z"
+"RFModificationTimestamp": "2026-07-07T15:37:10Z"
+"ListPrice": 424900.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-07T15:29:47Z"
+"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 [
"RoomKey" => "1677381952"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843697"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986048"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T15:29:47.66Z"
]
1 => array:11 [
"RoomKey" => "1677381953"
"RoomType" => "Full bathroom"
"ListingId" => "40843697"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986048"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T15:29:47.66Z"
]
2 => array:11 [
"RoomKey" => "1677381954"
"RoomType" => "Bedroom"
"ListingId" => "40843697"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986048"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T15:29:47.66Z"
]
3 => array:11 [
"RoomKey" => "1677381955"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843697"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986048"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T15:29:47.66Z"
]
4 => array:11 [
"RoomKey" => "1677381956"
"RoomType" => "Living room"
"ListingId" => "40843697"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986048"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 16'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T15:29:47.66Z"
]
5 => array:11 [
"RoomKey" => "1677381957"
"RoomType" => "Kitchen"
"ListingId" => "40843697"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986048"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T15:29:47.67Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29986048_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/a455392c75fffdd9e494d033914cb72d.webp"
"MediaSize" => 53177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-a455392c75fffdd9e494d033914cb72d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29986048_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/e25770c11d666d2b4f3073002318c2e7.webp"
"MediaSize" => 56207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-e25770c11d666d2b4f3073002318c2e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29986048_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/74c2bf188f8b64fd271b95408206166e.webp"
"MediaSize" => 80547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-74c2bf188f8b64fd271b95408206166e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29986048_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/1b60f67966064961b32684bbcbd89e9c.webp"
"MediaSize" => 48842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-1b60f67966064961b32684bbcbd89e9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29986048_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/f0b6df7db15b5b6b99bb96c889185565.webp"
"MediaSize" => 46887
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-f0b6df7db15b5b6b99bb96c889185565.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29986048_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/70f541a0b017c0b10ebc5cd61c888761.webp"
"MediaSize" => 56129
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-70f541a0b017c0b10ebc5cd61c888761.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29986048_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/7a5eb6523874431a96da7ad431aa8813.webp"
"MediaSize" => 45602
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-7a5eb6523874431a96da7ad431aa8813.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29986048_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/5de9898eb6125a7035c48be6e2c9aaee.webp"
"MediaSize" => 72288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-5de9898eb6125a7035c48be6e2c9aaee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986048')"
+"ID": "1590600"
}
]
+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 292003" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24844
+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 2238484" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24813
+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 '29986048'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25172
+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 '29986048'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25286
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29986048' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5214326 43.5107434)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25206
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25200
+post_id: "1599845"
+post_author: 1
+"ListingKey": "29998331"
+"ListingId": "X13531056"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T14:25:15Z"
+"RFModificationTimestamp": "2026-07-07T17:48:11Z"
+"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.503252
1 => 43.498882
]
+"Latitude": 43.498882
+"Longitude": -80.503252
+"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-07-07T17:48:05.120236+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-07-07T14:10:48Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T14:10:47Z"
+"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=301"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1677319000"
"RoomType" => "Living room"
"ListingId" => "X13531056"
"RoomLevel" => "Main level"
"RoomWidth" => 4.93
"ListingKey" => "29998331"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:10:47.95Z"
]
1 => array:11 [
"RoomKey" => "1677319001"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13531056"
"RoomLevel" => "Basement"
"RoomWidth" => 7.92
"ListingKey" => "29998331"
"RoomLength" => 7.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:10:47.95Z"
]
2 => array:11 [
"RoomKey" => "1677319002"
"RoomType" => "Bedroom 4"
"ListingId" => "X13531056"
"RoomLevel" => "Basement"
"RoomWidth" => 2.86
"ListingKey" => "29998331"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:10:47.95Z"
]
3 => array:11 [
"RoomKey" => "1677319003"
"RoomType" => "Laundry room"
"ListingId" => "X13531056"
"RoomLevel" => "Basement"
"RoomWidth" => 3.56
"ListingKey" => "29998331"
"RoomLength" => 3.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:10:47.95Z"
]
4 => array:11 [
"RoomKey" => "1677319004"
"RoomType" => "Bathroom"
"ListingId" => "X13531056"
"RoomLevel" => "Basement"
"RoomWidth" => 1.67
"ListingKey" => "29998331"
"RoomLength" => 2.98
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:10:47.95Z"
]
5 => array:11 [
"RoomKey" => "1677319005"
"RoomType" => "Dining room"
"ListingId" => "X13531056"
"RoomLevel" => "Main level"
"RoomWidth" => 3.08
"ListingKey" => "29998331"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:10:47.95Z"
]
6 => array:11 [
"RoomKey" => "1677319006"
"RoomType" => "Kitchen"
"ListingId" => "X13531056"
"RoomLevel" => "Main level"
"RoomWidth" => 5.63
"ListingKey" => "29998331"
"RoomLength" => 3.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:10:47.95Z"
]
7 => array:11 [
"RoomKey" => "1677319007"
"RoomType" => "Family room"
"ListingId" => "X13531056"
"RoomLevel" => "Main level"
"RoomWidth" => 3.74
"ListingKey" => "29998331"
"RoomLength" => 5.21
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:10:47.95Z"
]
8 => array:11 [
"RoomKey" => "1677319008"
"RoomType" => "Bathroom"
"ListingId" => "X13531056"
"RoomLevel" => "Main level"
"RoomWidth" => 1.73
"ListingKey" => "29998331"
"RoomLength" => 1.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:10:47.95Z"
]
9 => array:11 [
"RoomKey" => "1677319009"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13531056"
"RoomLevel" => "Second level"
"RoomWidth" => 5.63
"ListingKey" => "29998331"
"RoomLength" => 4.32
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:10:47.95Z"
]
10 => array:11 [
"RoomKey" => "1677319010"
"RoomType" => "Bathroom"
"ListingId" => "X13531056"
"RoomLevel" => "Second level"
"RoomWidth" => 1.46
"ListingKey" => "29998331"
"RoomLength" => 2.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:10:47.95Z"
]
11 => array:11 [
"RoomKey" => "1677319011"
"RoomType" => "Bedroom 2"
"ListingId" => "X13531056"
"RoomLevel" => "Second level"
"RoomWidth" => 3.38
"ListingKey" => "29998331"
"RoomLength" => 2.77
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:10:47.96Z"
]
12 => array:11 [
"RoomKey" => "1677319012"
"RoomType" => "Bedroom 3"
"ListingId" => "X13531056"
"RoomLevel" => "Second level"
"RoomWidth" => 3.38
"ListingKey" => "29998331"
"RoomLength" => 3.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:10:47.96Z"
]
13 => array:11 [
"RoomKey" => "1677319013"
"RoomType" => "Bathroom"
"ListingId" => "X13531056"
"RoomLevel" => "Second level"
"RoomWidth" => 2.89
"ListingKey" => "29998331"
"RoomLength" => 2.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:10:47.96Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29998331/359-lexington-road-waterloo"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2185334"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299885"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 65.7
+"OriginalEntryTimestamp": "2026-07-07T14:10:47.92Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1129773"
+"ListOfficeNationalAssociationId": "1478640"
+"CoListAgentNationalAssociationId": "1435541"
+"CoListOfficeNationalAssociationId": "1478640"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29998331_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/5ebb1d8957c9dbb92b9ac26a8bfc005a.webp"
"MediaSize" => 369063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-5ebb1d8957c9dbb92b9ac26a8bfc005a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29998331_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/f1da9665f280f946cc46e399aa2dd8e8.webp"
"MediaSize" => 366167
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-f1da9665f280f946cc46e399aa2dd8e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29998331_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/4e15a1e2ee0ac833a9c516b16a9800b9.webp"
"MediaSize" => 389947
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-4e15a1e2ee0ac833a9c516b16a9800b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29998331_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/990667fa2b8f9845db87745d2798b2bb.webp"
"MediaSize" => 277168
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-990667fa2b8f9845db87745d2798b2bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29998331_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/6d4ec8fc6791a6d97fe196b19e9bf625.webp"
"MediaSize" => 130485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-6d4ec8fc6791a6d97fe196b19e9bf625.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29998331_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/182cbf427c7d8ca08d121f7a0be3d983.webp"
"MediaSize" => 223590
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-182cbf427c7d8ca08d121f7a0be3d983.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29998331_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/171aea1d23fabc3e1700bcc44f50d21f.webp"
"MediaSize" => 208025
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-171aea1d23fabc3e1700bcc44f50d21f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29998331_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/6c151aaf59bfe076a281bc90822d05bc.webp"
"MediaSize" => 229274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-6c151aaf59bfe076a281bc90822d05bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29998331_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/5ae7ff8540208b22c0696d15f853d47c.webp"
"MediaSize" => 183321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-5ae7ff8540208b22c0696d15f853d47c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29998331_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/4caa12cb82ade36b6e13fc765b9e902b.webp"
"MediaSize" => 212869
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-4caa12cb82ade36b6e13fc765b9e902b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29998331_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/b41e865bd5c3192c037dd60cf06b5464.webp"
"MediaSize" => 142111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-b41e865bd5c3192c037dd60cf06b5464.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29998331_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/39a71b4c9f2d40e3a2af556d1d44fbd7.webp"
"MediaSize" => 168672
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-39a71b4c9f2d40e3a2af556d1d44fbd7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29998331_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/00c22296a4af16b8df5d3e9242c1c4b9.webp"
"MediaSize" => 156426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-00c22296a4af16b8df5d3e9242c1c4b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29998331_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/e50b900849d92c5deebad298cd0b29a6.webp"
"MediaSize" => 188074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-e50b900849d92c5deebad298cd0b29a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29998331_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/78a600f8c6625e26745c3a3c71600c43.webp"
"MediaSize" => 200808
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-78a600f8c6625e26745c3a3c71600c43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29998331_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/56b72e1c212460217d28d3bd512fd002.webp"
"MediaSize" => 165516
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-56b72e1c212460217d28d3bd512fd002.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29998331_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/abf2855c2cb7ccbdc40caee36b47173d.webp"
"MediaSize" => 196132
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-abf2855c2cb7ccbdc40caee36b47173d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29998331_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/a6d122430a07f4ebb7c0ddd942f676f1.webp"
"MediaSize" => 214779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-a6d122430a07f4ebb7c0ddd942f676f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29998331_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/f7bc27a35309d474f760248b6d5b7092.webp"
"MediaSize" => 256455
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-f7bc27a35309d474f760248b6d5b7092.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29998331_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/7bc38b852c5754d7bb3e0bd76ecbf96e.webp"
"MediaSize" => 119177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-7bc38b852c5754d7bb3e0bd76ecbf96e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29998331_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/aabad8f8383b505a3cbf6b526235163b.webp"
"MediaSize" => 121900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-aabad8f8383b505a3cbf6b526235163b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29998331_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/069f42489913d9d198976deba3e0af46.webp"
"MediaSize" => 195232
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-069f42489913d9d198976deba3e0af46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29998331_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/cbe03b9df94c200b5a7eecba1883ec39.webp"
"MediaSize" => 226201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-cbe03b9df94c200b5a7eecba1883ec39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29998331_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/691832320969649a40045fa388dac9ac.webp"
"MediaSize" => 197855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-691832320969649a40045fa388dac9ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29998331_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/19555f64b4e67a152bfac9f7137ae98e.webp"
"MediaSize" => 166569
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-19555f64b4e67a152bfac9f7137ae98e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29998331_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/e5467c0815755c889d57432248304ed7.webp"
"MediaSize" => 147728
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-e5467c0815755c889d57432248304ed7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29998331_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/ab0f75e7e543ad95b92dc3e5c9336a71.webp"
"MediaSize" => 134131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-ab0f75e7e543ad95b92dc3e5c9336a71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29998331_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/c28f6bceb16f299d92aedf383bb474de.webp"
"MediaSize" => 156500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-c28f6bceb16f299d92aedf383bb474de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29998331_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/94892b5b08703a87165c3851a93afb02.webp"
"MediaSize" => 151604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-94892b5b08703a87165c3851a93afb02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29998331_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/d2df1fe7dfaa3a6306d805bec74d5ea9.webp"
"MediaSize" => 166064
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-d2df1fe7dfaa3a6306d805bec74d5ea9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29998331_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/9f01ac7a5135dc7399add45f5cbc6ffe.webp"
"MediaSize" => 153887
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-9f01ac7a5135dc7399add45f5cbc6ffe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29998331_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/93d77da47c172370cdbe075b731d892c.webp"
"MediaSize" => 136625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-93d77da47c172370cdbe075b731d892c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29998331_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/ae3bd9fc520e9630271adb4ba190edc9.webp"
"MediaSize" => 176363
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-ae3bd9fc520e9630271adb4ba190edc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29998331_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/087af215fc729d590d0dbd54c5c7a8c6.webp"
"MediaSize" => 169510
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-087af215fc729d590d0dbd54c5c7a8c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29998331_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/c5b76ccb2ec84862a7f7a291e68042cc.webp"
"MediaSize" => 108883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-c5b76ccb2ec84862a7f7a291e68042cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29998331_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/0c5d4a44e2c2ac3ed54ccebf4b5bb887.webp"
"MediaSize" => 148628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-0c5d4a44e2c2ac3ed54ccebf4b5bb887.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29998331_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/c8bbfaaf6ce0a8bb1f64535c2c061b74.webp"
"MediaSize" => 183314
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-c8bbfaaf6ce0a8bb1f64535c2c061b74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29998331_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/edca1bb368d9cbd27b2cd8e62fd6fffb.webp"
"MediaSize" => 346414
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-edca1bb368d9cbd27b2cd8e62fd6fffb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29998331_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/923103c508007e222f69c2a992695592.webp"
"MediaSize" => 436372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-923103c508007e222f69c2a992695592.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29998331_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/57da35ab7331fc06ad16fb48ea9f6e7a.webp"
"MediaSize" => 373681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-57da35ab7331fc06ad16fb48ea9f6e7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29998331_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/a1061287cdb5557fe179eb47a6a87b45.webp"
"MediaSize" => 352988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-a1061287cdb5557fe179eb47a6a87b45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
"ResourceRecordKey" => "29998331"
"ModificationTimestamp" => "2026-07-07T14:10:47.93Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29998331_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998331/955824dbaecf049187b3d4b86c20bab3.webp"
"MediaSize" => 440153
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998331/thumbnail-955824dbaecf049187b3d4b86c20bab3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13531056"
…2
]
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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29998331')"
+"ID": "1599845"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25202
+post_id: "1597921"
+post_author: 1
+"ListingKey": "29996548"
+"ListingId": "X13529768"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T00:05:25Z"
+"RFModificationTimestamp": "2026-07-07T00:19:00Z"
+"ListPrice": 1569990.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K1X6"
+"UnparsedAddress": "255 NORMANDY AVENUE, Waterloo, Ontario N2K1X6"
+"Coordinates": array:2 [
0 => -80.512617
1 => 43.495644
]
+"Latitude": 43.495644
+"Longitude": -80.512617
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome to the lifestyle you've been working toward. Nestled in Waterloo's sought after Colonial Acres neighbourhood, this exceptional home offers nearly 4,000 sq. ft. of total finished living space designed for the way modern families live today. Whether you're working from home, hosting family gatherings, entertaining friends by the pool, or simply looking for more room to enjoy everyday life, this home delivers the flexibility and comfort to do it all. Inside, soaring ceilings and sun filled living spaces create a warm, inviting atmosphere. The thoughtfully designed main floor features multiple living areas, dedicated work from home space, and seamless flow for both daily living and entertaining. Upstairs, spacious bedrooms provide room for the whole family, including a private primary retreat designed for rest and relaxation.The finished basement unlocks incredible flexibility with a second kitchen, spacious recreation room, additional bedroom, and second laundry, making it ideal for multigenerational living or extended family. Step outside and discover what truly sets this property apart. The backyard feels like a private resort, complete with a heated saltwater pool, expansive patio, gazebo, gas BBQ hookup, and beautifully landscaped perennial gardens. It's the perfect setting for summer gatherings, quiet afternoons bird-watching, and making memories with family and friends. Built in 2013 and thoughtfully upgraded with solar power generation, dual heat pumps, and energy efficient systems, this home offers the rare combination of modern comfort, exceptional outdoor living, and reduced operating costs. Situated on a premium 66 x 171 ft lot just minutes from RIM Park, Grey Silo Golf Club, St. Jacob's market, scenic trails, top rated schools, universities, shopping, and commuter routes, this is an opportunity to enjoy one of Waterloo's most desirable neighbourhoods without compromise. More than a house, this is a home designed to support the way you want to live. (id:66098)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Whirlpool"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"Basement": array:7 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "Walk-up"
4 => "N/A"
5 => "N/A"
6 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Wall unit"
]
+"CreationDate": "2026-07-06T23:12:28.096554+00:00"
+"Directions": "Cross Streets: Lexington/Anndale. ** Directions: Lexington > Anndale > Normandy."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Flooring": array:3 [
0 => "Tile"
1 => "Hardwood"
2 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:5 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Electric"
3 => "Natural gas"
4 => "Solar"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2247560"
+"ListOfficeKey": "85457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Gazebo"
1 => "Sump Pump"
]
+"LotSizeDimensions": "66.8 x 171.3 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T22:30:10Z"
+"PhotosCount": 47
+"PoolFeatures": array:2 [
0 => "Inground pool"
1 => "Salt Water Pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T23:59:31Z"
+"Stories": "2.0"
+"StreetName": "Normandy"
+"StreetNumber": "255"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "10344"
+"VirtualTourURLUnbranded": "https://youriguide.com/255_normandy_ave_waterloo_on"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:20 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
]
+"ListAOR": "OnePoint"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29996548/255-normandy-avenue-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Separate Heating Controls"
1 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"PropertyCondition": array:1 [
0 => "Insulation upgraded"
]
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 66.9
+"OriginalEntryTimestamp": "2026-07-06T22:30:10.75Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1486430"
+"ListOfficeNationalAssociationId": "1002051"
+"Media": array:47 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29996548')"
+"ID": "1597921"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25199
+post_id: "1593289"
+post_author: 1
+"ListingKey": "29989631"
+"ListingId": "X13522824"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T14:25:14Z"
+"RFModificationTimestamp": "2026-07-07T14:30:48Z"
+"ListPrice": 949000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4E5"
+"UnparsedAddress": "597 LITTLE DOVER CRESCENT E, Waterloo, Ontario N2K4E5"
+"Coordinates": array:2 [
0 => -80.512699
1 => 43.5077852
]
+"Latitude": 43.5077852
+"Longitude": -80.512699
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "LOCATION, LAYOUT & LIFESTYLE! Welcome to 597 Little Dover Crescent, a beautifully maintained executive detached home on a premium pie-shaped lot in one of East Waterloo's most sought-after neighbourhoods. Offering 3 bedrooms, 3 bathrooms, and a unique multi-level layout, this move-in-ready home is designed for comfortable family living.The bright kitchen features granite countertops, an oversized island, and stainless steel appliances, while the inviting family room includes a hidden bonus storage/playroom. The spacious primary suite offers a walk-in closet and private ensuite, and the bright lower level boasts 9-foot ceilings, large windows, a home office, and new flooring.Outside, enjoy exceptional curb appeal with a double-car garage, a rare 6-car parking capacity, no-sidewalk, a two-tier deck, and an expansive pie-shaped backyard that's perfect for entertaining family and friends.Located just minutes from waterloo regions top-rated schools, Rim Park, Grey Silo Golf Course, Grand River trails, shopping, restaurants, and transit, this exceptional home offers the perfect blend of location, space, and lifestyle. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-04T17:56:15.332596+00:00"
+"Directions": "Cross Streets: Brigantine Dr. ** Directions: Bridge St to Chesapeake Dr to Brigantine Dr to Little Dover Cres."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2243953"
+"ListOfficeKey": "272157"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "28.8 x 133 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-04T16:40:04Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T14:10:40Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "Little Dover"
+"StreetNumber": "597"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6115"
+"Utilities": array:2 [
0 => "Electricity"
1 => "Cable"
]
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=5ZSMrpadqYT"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29989631/597-little-dover-crescent-e-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Separate Electricity Meters"
1 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 28.9
+"OriginalEntryTimestamp": "2026-07-04T16:40:04.07Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1482521"
+"ListOfficeNationalAssociationId": "1242539"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29989631')"
+"ID": "1593289"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25203
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29987150')"
+"ID": "1591137"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25201
+post_id: "1590601"
+post_author: 1
+"ListingKey": "29986089"
+"ListingId": "X13519890"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T16:00:03Z"
+"RFModificationTimestamp": "2026-07-07T16:01:32Z"
+"ListPrice": 424900.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-07T15:54:44Z"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986089')"
+"ID": "1590601"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25196
+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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29984547')"
+"ID": "1590387"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23461
+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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29982473')"
+"ID": "1587688"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25204
+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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29980078')"
+"ID": "1585240"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25205
+post_id: "1587452"
+post_author: 1
+"ListingKey": "29978817"
+"ListingId": "40844546"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T17:00:11Z"
+"RFModificationTimestamp": "2026-07-02T17:08:43Z"
+"ListPrice": 724900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1923.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4L7"
+"UnparsedAddress": "765 ANGLER Way, Waterloo, Ontario N2K4L7"
+"Coordinates": array:2 [
0 => -80.5004055
1 => 43.5144025
]
+"Latitude": 43.5144025
+"Longitude": -80.5004055
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"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)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T17:08:31.519059+00:00"
+"Directions": "NEW HAMPSHIRE STREET"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1920294"
+"ListOfficeKey": "285135"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Gazebo"
2 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T16:33:12Z"
+"PhotosCount": 25
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T16:50:33Z"
+"Stories": "2.0"
+"StreetName": "ANGLER"
+"StreetNumber": "765"
+"StreetSuffix": "Way"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "4452"
+"VirtualTourURLUnbranded": "https://youriguide.com/o6z5m_765_angler_way_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/29978817/765-angler-way-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1437
+"BelowGradeFinishedArea": 486
+"OriginalEntryTimestamp": "2026-07-02T16:33:07.71Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1226483"
+"ListOfficeNationalAssociationId": "1347769"
+"Media": array:25 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29978817')"
+"ID": "1587452"
}
]
+success: true
+page_size: 9
+page_count: 5
+count: 37
+after_key: ""
}
"RF Response Time" => "0.33 seconds"
]
]