array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29986089 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
+post_id: "1590601"
+post_author: 1
+"ListingKey": "29986089"
+"ListingId": "X13519890"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T18:35:15Z"
+"RFModificationTimestamp": "2026-07-03T19:48:02Z"
+"ListPrice": 524900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2H1"
+"UnparsedAddress": "505 - 255 NORTHFIELD DRIVE E, Waterloo, Ontario N2V2H1"
+"Coordinates": array:2 [
0 => -80.521297
1 => 43.510381
]
+"Latitude": 43.510381
+"Longitude": -80.521297
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to Blackstone Condominiums, one of Waterloo's most sought-after communities, where modern design, exceptional amenities, and an unbeatable location come together. This beautifully maintained 2-bedroom, 2-bathroom suite offers over 800 sq. ft. of stylish living space with contemporary finishes throughout. The bright open-concept layout is designed for everyday living and entertaining, featuring a modern kitchen with quartz countertops, stainless steel appliances, a white subway tile backsplash, ample cabinetry, and a spacious island overlooking the living and dining area. Expansive windows fill the home with natural light, while the generous balcony provides the perfect place to enjoy your morning coffee. At the end of the day, retreat to the spacious primary bedroom featuring a private ensuite. The second bedroom and additional full bathroom offer flexible space for guests, family, or a dedicated home office. In-suite laundry and an exclusive surface parking space add everyday convenience. Residents of Blackstone enjoy an exceptional collection of amenities, including a fully equipped fitness centre, co-working/business lounge, an impressive party room, games and media room, rooftop terrace, landscaped gardens, bike storage, pet wash station, and BBQ areas. Even better, the condo fees include heat, high-speed internet, building insurance, building and grounds maintenance, common elements, snow removal, private garbage collection, roof maintenance, property management, and parking, providing outstanding value and predictable monthly expenses. Perfectly located just minutes from Conestoga Mall, the ION LRT, RIM Park, Walter Bean Trail, Grey Silo Golf Club, St. Jacobs Farmers' Market, the University of Waterloo, Wilfrid Laurier University, and an excellent selection of shopping, cafés, and restaurants right at your doorstep, this home is ideal for professionals, first-time buyers, downsizers, and investors alike. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Heat"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "School Bus"
1 => "Community Centre"
2 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T19:47:55.686450+00:00"
+"Directions": "Cross Streets: NORTHFIELD/BRIDGE. ** Directions: NORTHFIELD TO BRIDGE ST."
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1899457"
+"ListOfficeKey": "292096"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Flat site"
1 => "Conservation/green belt"
2 => "Elevator"
3 => "Balcony"
4 => "Dry"
5 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T18:25:30Z"
+"PhotosCount": 8
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:25:30Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3752.53"
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1674300889"
"RoomType" => "Kitchen"
"ListingId" => "X13519890"
"RoomLevel" => "Main level"
"RoomWidth" => 3.28
"ListingKey" => "29986089"
"RoomLength" => 3.53
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T18:25:30.07Z"
]
1 => array:11 [
"RoomKey" => "1674300890"
"RoomType" => "Living room"
"ListingId" => "X13519890"
"RoomLevel" => "Main level"
"RoomWidth" => 3.28
"ListingKey" => "29986089"
"RoomLength" => 5.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T18:25:30.07Z"
]
2 => array:11 [
"RoomKey" => "1674300891"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13519890"
"RoomLevel" => "Main level"
"RoomWidth" => 3.3
"ListingKey" => "29986089"
"RoomLength" => 3.61
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T18:25:30.07Z"
]
3 => array:11 [
"RoomKey" => "1674300892"
"RoomType" => "Bedroom 2"
"ListingId" => "X13519890"
"RoomLevel" => "Main level"
"RoomWidth" => 3.3
"ListingKey" => "29986089"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T18:25:30.07Z"
]
4 => array:11 [
"RoomKey" => "1674300893"
"RoomType" => "Bathroom"
"ListingId" => "X13519890"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29986089"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T18:25:30.07Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29986089_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986089/f669e0517760b96eeb5b8080ceed2b1e.webp"
"MediaSize" => 55051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986089/thumbnail-f669e0517760b96eeb5b8080ceed2b1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13519890"
"ResourceRecordKey" => "29986089"
"ModificationTimestamp" => "2026-07-03T18:25:30.03Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29986089_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986089/22dd96e695fd602cd3236ca1efdd39e9.webp"
"MediaSize" => 58247
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986089/thumbnail-22dd96e695fd602cd3236ca1efdd39e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13519890"
"ResourceRecordKey" => "29986089"
"ModificationTimestamp" => "2026-07-03T18:25:30.03Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29986089_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986089/19f0428de97ecf2f68f7fec1b4bcdbfb.webp"
"MediaSize" => 85669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986089/thumbnail-19f0428de97ecf2f68f7fec1b4bcdbfb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13519890"
"ResourceRecordKey" => "29986089"
"ModificationTimestamp" => "2026-07-03T18:25:30.03Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29986089_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986089/3ba09bf288a66a4bbd3be8206da884be.webp"
"MediaSize" => 50868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986089/thumbnail-3ba09bf288a66a4bbd3be8206da884be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13519890"
"ResourceRecordKey" => "29986089"
"ModificationTimestamp" => "2026-07-03T18:25:30.03Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29986089_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986089/5d18194f098b29adee2df9b61c5c6efb.webp"
"MediaSize" => 49077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986089/thumbnail-5d18194f098b29adee2df9b61c5c6efb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13519890"
"ResourceRecordKey" => "29986089"
"ModificationTimestamp" => "2026-07-03T18:25:30.03Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29986089_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986089/48375bbc61814f29d8da03e46f16d9ec.webp"
"MediaSize" => 57885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986089/thumbnail-48375bbc61814f29d8da03e46f16d9ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13519890"
"ResourceRecordKey" => "29986089"
"ModificationTimestamp" => "2026-07-03T18:25:30.03Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29986089_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986089/1747d0c8abb7d5b67d0cb75e730b5935.webp"
"MediaSize" => 48058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986089/thumbnail-1747d0c8abb7d5b67d0cb75e730b5935.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13519890"
"ResourceRecordKey" => "29986089"
"ModificationTimestamp" => "2026-07-03T18:25:30.03Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29986089_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986089/2131a138cea0c297ccbb3e7aa249dece.webp"
"MediaSize" => 74273
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986089/thumbnail-2131a138cea0c297ccbb3e7aa249dece.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13519890"
"ResourceRecordKey" => "29986089"
"ModificationTimestamp" => "2026-07-03T18:25:30.03Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986089')"
+"ID": "1590601"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 292096" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24838
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1899457" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24796
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29986089'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25161
+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 '29986089'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25177
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29986089' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.521297 43.510381)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25230
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25224
+post_id: 1591137
+post_author: 1
+"ListingKey": "29987150"
+"ListingId": "40844520"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T20:35:12Z"
+"RFModificationTimestamp": "2026-07-03T23:19:32Z"
+"ListPrice": 1247000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3235.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4G5"
+"UnparsedAddress": "517 STARBOARD Crescent, Waterloo, Ontario N2K4G5"
+"Coordinates": array:2 [
0 => -80.5062174
1 => 43.5105961
]
+"Latitude": 43.5105961
+"Longitude": -80.5062174
+"YearBuilt": 2004
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 517 Starboard Crescent, Waterloo, a beautifully maintained bungalow offering 3 bedrooms, 3 bathrooms, and a spacious open-concept layout designed for comfortable everyday living and entertaining. Step inside to the welcoming foyer where you're greeted by an airy floor plan. To the right, the formal living room features a cozy gas fireplace and skylight, creating a bright and inviting space. The living room flows seamlessly into the dining area and spacious kitchen, complete with granite countertops, stainless steel appliances, abundant cabinetry, generous prep space, and a large centre island with breakfast bar seating. A convenient door off the kitchen provides easy access to the backyard. The main floor also features updated hardwood flooring throughout, a convenient mudroom/laundry room with direct access to the double garage, and a 3-piece bathroom. Two bedrooms are located on this level, including the spacious primary suite with a walk-in closet and a luxurious 5-piece ensuite. The finished basement expands your living space with a large recreation room highlighted by a stylish gas fireplace, an additional bedroom, and a 3-piece bathroom—ideal for guests, extended family, or a home office. Step outside to your private backyard retreat featuring an inground saltwater pool and patio area, perfect for relaxing or entertaining all summer long. Complete with a double car garage and parking for up to six vehicles in the driveway, this exceptional home offers the perfect combination of space, comfort, and lifestyle in a sought-after Waterloo neighbourhood. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T23:19:24.529023+00:00"
+"Directions": "Chesapeake Drive to Starboard Cres"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908292"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T20:33:15Z"
+"PhotosCount": 48
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T20:33:15Z"
+"Stories": "1.0"
+"StreetName": "STARBOARD"
+"StreetNumber": "517"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "7992.01"
+"VirtualTourURLUnbranded": "https://youriguide.com/517_starboard_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1674395024"
"RoomType" => "Utility room"
"ListingId" => "40844520"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "31'4'' x 18'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.98Z"
]
1 => array:11 [
"RoomKey" => "1674395025"
"RoomType" => "Recreation room"
"ListingId" => "40844520"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "31'4'' x 19'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.98Z"
]
2 => array:11 [
"RoomKey" => "1674395026"
"RoomType" => "Cold room"
"ListingId" => "40844520"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 18'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.98Z"
]
3 => array:11 [
"RoomKey" => "1674395027"
"RoomType" => "Bedroom"
"ListingId" => "40844520"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 16'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
4 => array:11 [
"RoomKey" => "1674395028"
"RoomType" => "3pc Bathroom"
"ListingId" => "40844520"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
5 => array:11 [
"RoomKey" => "1674395029"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "14'2'' x 17'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
6 => array:11 [
"RoomKey" => "1674395030"
"RoomType" => "Living room"
"ListingId" => "40844520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "19'7'' x 16'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
7 => array:11 [
"RoomKey" => "1674395031"
"RoomType" => "Laundry room"
"ListingId" => "40844520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "5'11'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
8 => array:11 [
"RoomKey" => "1674395032"
"RoomType" => "Kitchen"
"ListingId" => "40844520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 14'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
9 => array:11 [
"RoomKey" => "1674395033"
"RoomType" => "Foyer"
"ListingId" => "40844520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 8'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
10 => array:11 [
"RoomKey" => "1674395034"
"RoomType" => "Dining room"
"ListingId" => "40844520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 14'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
11 => array:11 [
"RoomKey" => "1674395035"
"RoomType" => "Bedroom"
"ListingId" => "40844520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
12 => array:11 [
"RoomKey" => "1674395036"
"RoomType" => "Full bathroom"
"ListingId" => "40844520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
13 => array:11 [
"RoomKey" => "1674395037"
"RoomType" => "3pc Bathroom"
"ListingId" => "40844520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29987150_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/c5dfba95e4ba0907ab3ea1e524896930.webp"
"MediaSize" => 120105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-c5dfba95e4ba0907ab3ea1e524896930.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.87Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29987150_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/8dc368700c4a90a60f5609dec9117a75.webp"
"MediaSize" => 121050
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-8dc368700c4a90a60f5609dec9117a75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.87Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29987150_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/3745765af2223e7a3ccb9ebc5bf434b2.webp"
"MediaSize" => 106236
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-3745765af2223e7a3ccb9ebc5bf434b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:10.19Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29987150_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/d7282e03111268c7f81e7d4b8a6de682.webp"
"MediaSize" => 127876
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-d7282e03111268c7f81e7d4b8a6de682.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:11.46Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29987150_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/2dbce625577091e7fe94ff622b710b65.webp"
"MediaSize" => 116463
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-2dbce625577091e7fe94ff622b710b65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:08.96Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29987150_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/bd127d809b8c9beea9346ef0b1bcccbf.webp"
"MediaSize" => 66838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-bd127d809b8c9beea9346ef0b1bcccbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:10.28Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29987150_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/3239edd8f5931bb904d6c69f97336404.webp"
"MediaSize" => 71849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-3239edd8f5931bb904d6c69f97336404.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:10.3Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29987150_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/411292fca1c61369beab260c338c80ed.webp"
"MediaSize" => 92479
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-411292fca1c61369beab260c338c80ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.86Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29987150_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/85711576dc521f2aa49a69c60e218e39.webp"
"MediaSize" => 93383
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-85711576dc521f2aa49a69c60e218e39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:08.96Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29987150_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/518f51ba95e52b35506f60da3b2d0573.webp"
"MediaSize" => 57864
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-518f51ba95e52b35506f60da3b2d0573.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:08.9Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29987150_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/46104cfb33b421a278db9a2a3387f4d9.webp"
"MediaSize" => 76487
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-46104cfb33b421a278db9a2a3387f4d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.87Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29987150_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/06ab24702822dd0803822e2df2fe407c.webp"
"MediaSize" => 93107
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-06ab24702822dd0803822e2df2fe407c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:13.08Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29987150_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/6dc917564b99d529d6f75e52b2d864fb.webp"
"MediaSize" => 85665
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-6dc917564b99d529d6f75e52b2d864fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:11.73Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29987150_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/08d2085e0b6c9d26aa6f870d2bdc2f26.webp"
"MediaSize" => 74454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-08d2085e0b6c9d26aa6f870d2bdc2f26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:10.14Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29987150_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/93afa28d29901124c4d76bf2fd02201d.webp"
"MediaSize" => 82419
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-93afa28d29901124c4d76bf2fd02201d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:08.96Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29987150_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/9d6f37f35bb340838d1ad042755150de.webp"
"MediaSize" => 70929
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-9d6f37f35bb340838d1ad042755150de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.95Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29987150_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/f392546fe5b4fd2ab9c268b474445e5d.webp"
"MediaSize" => 77655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-f392546fe5b4fd2ab9c268b474445e5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:13.07Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29987150_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/43f76e7015878786e15d8fd52bc7bfba.webp"
"MediaSize" => 76410
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-43f76e7015878786e15d8fd52bc7bfba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:11.72Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29987150_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/33933856c747e0db6c1e49b80a2ec671.webp"
"MediaSize" => 69717
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-33933856c747e0db6c1e49b80a2ec671.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.87Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29987150_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/5ccc1a39c7fb73e8843bac1bc67930f4.webp"
"MediaSize" => 69751
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-5ccc1a39c7fb73e8843bac1bc67930f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:10.23Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29987150_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/ffd3ccd1e9a4167c2d0b4cd92bb7b1ad.webp"
"MediaSize" => 42190
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-ffd3ccd1e9a4167c2d0b4cd92bb7b1ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:11.46Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29987150_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/75fe56c0f040da43aa755e8ad174b13d.webp"
"MediaSize" => 63886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-75fe56c0f040da43aa755e8ad174b13d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:13.27Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29987150_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/0d1a79b693785f5b26581a88504eddbd.webp"
"MediaSize" => 30799
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-0d1a79b693785f5b26581a88504eddbd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:10.24Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29987150_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/134de0468f0a391f1a4b8c16c7ece89e.webp"
"MediaSize" => 71927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-134de0468f0a391f1a4b8c16c7ece89e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.87Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29987150_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/679ba2a6231953f9106364ec1da9d63f.webp"
"MediaSize" => 62430
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-679ba2a6231953f9106364ec1da9d63f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.87Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29987150_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/18e89d51661cf84333d90a7666c71868.webp"
"MediaSize" => 87505
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-18e89d51661cf84333d90a7666c71868.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.87Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29987150_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/335188d50fbb0ffec8d63c0ba43a545e.webp"
"MediaSize" => 100715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-335188d50fbb0ffec8d63c0ba43a545e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:14.4Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29987150_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/c93227a3891c5a165a01cd1d7f82948d.webp"
"MediaSize" => 82680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-c93227a3891c5a165a01cd1d7f82948d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:14.4Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29987150_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/97b79fdc68b7d907836927754ee24cc4.webp"
"MediaSize" => 68621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-97b79fdc68b7d907836927754ee24cc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.87Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29987150_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/3d389ad3c156e152a09c5ac807635750.webp"
"MediaSize" => 54240
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-3d389ad3c156e152a09c5ac807635750.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.96Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29987150_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/dd8d8c08cd408df56dba00de42c267d1.webp"
"MediaSize" => 59529
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-dd8d8c08cd408df56dba00de42c267d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.98Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29987150_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/989e14a03ce054960e9ed37342c9cb69.webp"
"MediaSize" => 94399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-989e14a03ce054960e9ed37342c9cb69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:13.13Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29987150_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/ab603b1669540446c64c9dfb87940322.webp"
"MediaSize" => 81085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-ab603b1669540446c64c9dfb87940322.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:11.47Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29987150_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/312df54dab6faab41ebcddae069014ff.webp"
"MediaSize" => 79731
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-312df54dab6faab41ebcddae069014ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:11.46Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29987150_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/6b3d25b577dbdc6b407d06c78e347998.webp"
"MediaSize" => 74505
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-6b3d25b577dbdc6b407d06c78e347998.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:15.31Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29987150_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/deebf00efea75142466d46289b6d10e6.webp"
"MediaSize" => 77365
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-deebf00efea75142466d46289b6d10e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:13.02Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29987150_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/e4ec21e41e1ed66dcae5f031ccdab5c9.webp"
"MediaSize" => 73877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-e4ec21e41e1ed66dcae5f031ccdab5c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:15.4Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29987150_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/ef9f836d890e623836d8b69568ef102e.webp"
"MediaSize" => 87975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-ef9f836d890e623836d8b69568ef102e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:10.19Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29987150_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/582c8a333a414e6210c62dcbf03bf169.webp"
"MediaSize" => 86072
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-582c8a333a414e6210c62dcbf03bf169.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:14.46Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29987150_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/8b79de4d1b5567aa0c3c52be9d2a400f.webp"
"MediaSize" => 172687
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-8b79de4d1b5567aa0c3c52be9d2a400f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:11.72Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29987150_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/ecf2330455472288bc742d025d40ac51.webp"
"MediaSize" => 133274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-ecf2330455472288bc742d025d40ac51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:10.26Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29987150_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/615e10e3aa427318bef228f0e3ba17e2.webp"
"MediaSize" => 156602
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-615e10e3aa427318bef228f0e3ba17e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:10.16Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29987150_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/7cfda36a4e2eb04d0a41bc04f1237ff5.webp"
"MediaSize" => 151137
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-7cfda36a4e2eb04d0a41bc04f1237ff5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:11.67Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29987150_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/6a401c32c52b2221afe771f4564614d5.webp"
"MediaSize" => 144408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-6a401c32c52b2221afe771f4564614d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:13.02Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29987150_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/ceded095b1a54b7218d4a1b7b2ed3405.webp"
"MediaSize" => 171318
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-ceded095b1a54b7218d4a1b7b2ed3405.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:12.43Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29987150_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/8616eda1caf0305182b9bc9ada9cbaef.webp"
…10
]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29987150')"
+"ID": 1591137
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25226
+post_id: "1590600"
+post_author: 1
+"ListingKey": "29986048"
+"ListingId": "40843697"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T18:25:13Z"
+"RFModificationTimestamp": "2026-07-03T19:51:49Z"
+"ListPrice": 524900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 7.26
+"LivingArea": 801.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2H1"
+"UnparsedAddress": "255 NORTHFIELD Drive E Unit# 505, Waterloo, Ontario N2V2H1"
+"Coordinates": array:2 [
0 => -80.5214326
1 => 43.5107434
]
+"Latitude": 43.5107434
+"Longitude": -80.5214326
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Blackstone Condominiums, one of Waterloo's most sought-after communities, where modern design, exceptional amenities, and an unbeatable location come together. This beautifully maintained 2-bedroom, 2-bathroom suite offers over 800 sq. ft. of stylish living space with contemporary finishes throughout. The bright open-concept layout is designed for everyday living and entertaining, featuring a modern kitchen with quartz countertops, stainless steel appliances, a white subway tile backsplash, ample cabinetry, and a spacious island overlooking the living and dining area. Expansive windows fill the home with natural light, while the generous balcony provides the perfect place to enjoy your morning coffee. At the end of the day, retreat to the spacious primary bedroom featuring a private ensuite. The second bedroom and additional full bathroom offer flexible space for guests, family, or a dedicated home office. In-suite laundry and an exclusive surface parking space add everyday convenience. Residents of Blackstone enjoy an exceptional collection of amenities, including a fully equipped fitness centre, co-working/business lounge, an impressive party room, games and media room, rooftop terrace, landscaped gardens, bike storage, pet wash station, and BBQ areas. Even better, the condo fees include heat, high-speed internet, building insurance, building and grounds maintenance, common elements, snow removal, private garbage collection, roof maintenance, property management, and parking, providing outstanding value and predictable monthly expenses. Perfectly located just minutes from Conestoga Mall, the ION LRT, RIM Park, Walter Bean Trail, Grey Silo Golf Club, St. Jacobs Farmers' Market, the University of Waterloo, Wilfrid Laurier University, and an excellent selection of shopping, cafés, and restaurants right at your doorstep, this home is ideal for professionals, first-time buyers, downsizers, and investors alike. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Heat"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T19:51:46.539329+00:00"
+"Directions": "NORTHFIELD TO BRIDGE ST"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2238484"
+"ListOfficeKey": "292003"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"LotSizeDimensions": "7.26"
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-03T18:18:33Z"
+"PhotosCount": 8
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:18:33Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3752.53"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29986048/255-northfield-drive-e-unit-505-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2059475"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "292003"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 158.0
+"AboveGradeFinishedArea": 801
+"OriginalEntryTimestamp": "2026-07-03T18:18:33.17Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1476314"
+"ListOfficeNationalAssociationId": "1407357"
+"CoListAgentNationalAssociationId": "1334623"
+"CoListOfficeNationalAssociationId": "1407357"
+"Media": array:8 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986048')"
+"ID": "1590600"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25223
+post_id: "1590387"
+post_author: 1
+"ListingKey": "29984547"
+"ListingId": "X13518412"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T15:30:04Z"
+"RFModificationTimestamp": "2026-07-03T17:08:31Z"
+"ListPrice": 999999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Prince Edward County (Sophiasburg Ward)"
+"PostalCode": "K0K1W0"
+"UnparsedAddress": "213 GOMORRAH ROAD, Prince Edward County (Sophiasburg Ward), Ontario K0K1W0"
+"Coordinates": array:2 [
0 => -80.499587
1 => 43.507364
]
+"Latitude": 43.507364
+"Longitude": -80.499587
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Central Lakes Association of REALTORS®"
+"PublicRemarks": "Nestled in a serene historical hamlet of Prince Edward County, this magnificent two-storey country home sits on a picturesque 2.6-acre parcel, featuring Smith's Creek gently meandering through the property behind a beautifully restored multi-level Dutch barn. Cross the creek via a quaint bridge to discover a spacious garden area perfect for quiet enjoyment of outdoor gatherings. Meticulous care has been taken to preserve the original character of this century home. The main floor welcomes you with grand 8-ft double library doors leading to both the formal living room and the cozy family room. Each space is enhanced by original pine flooring, elegant trim, soaring ceilings, and the inviting glow of propane fireplaces. The living room also boasts an intricately designed tin ceiling, adding a touch of period charm. The newly installed kitchen (2022) was thoughtfully crafted to harmonize with the home's historic aesthetic. It offers abundant cabinetry, a central island, and opens into the bright dining area, which leads to a large deck overlooking the grounds. This deck connects seamlessly with the inviting wraparound covered porch - ideal for enjoying peaceful country views. Upstairs, the second level features four comfortable bedrooms, a spacious 4-piece bathroom, and a large walk-in storage closet. Original hardwood floors and woodwork continue throughout, preserving the timeless warmth and character of the home. The impressive multi-level barn, dating back to the late 1800's, has undergone significant structural improvements, including foundation reinforcement and interior refinishing with rustic pine planks. Currently used for dry storage, its versatile design and unique atmosphere make it a perfect venue for festive events or creative ventures. Surrounded by farmland and forest teeming with local wildlife and bird species, this one-of-a-kind property offers a rare opportunity to own a piece of County heritage, with all the tranquility and beauty of rural living. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Oven"
7 => "Dryer"
8 => "Microwave"
9 => "Oven - Built-In"
10 => "Water Treatment"
11 => "Window Coverings"
12 => "Water Heater"
]
+"Basement": array:5 [
0 => "Unfinished"
1 => "Partial"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T17:08:24.679771+00:00"
+"Directions": "Cross Streets: County Road 14 & County Road 15. ** Directions: Follow County Roads 14 or 15 to Gomorrah, just outside of Demorestville."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1433818"
+"ListOfficeKey": "211195"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Level lot"
1 => "Sloping"
2 => "Open space"
3 => "Level"
]
+"LotSizeDimensions": "293.5 x 500 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T15:20:58Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T15:20:58Z"
+"Stories": "2.0"
+"StreetName": "Gomorrah"
+"StreetNumber": "213"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "2824.93"
+"Utilities": array:4 [
0 => "Electricity"
1 => "Telephone"
2 => "Wireless"
3 => "Electricity Connected"
]
+"View": "View of water,Direct Water View"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/213_gommorah_rd_prince_edward_on/"
+"WaterSource": array:1 [
0 => "Dug Well"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Central Lakes"
+"CityRegion": "Sophiasburg Ward"
+"ListAORKey": "88"
+"ListingURL": "www.realtor.ca/real-estate/29984547/213-gomorrah-road-prince-edward-county-sophiasburg-ward-sophiasburg-ward"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "RR1"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 293.6
+"OriginalEntryTimestamp": "2026-07-03T15:20:58.7Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1117495"
+"ListOfficeNationalAssociationId": "1193887"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29984547')"
+"ID": "1590387"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25227
+post_id: "1587688"
+post_author: 1
+"ListingKey": "29982473"
+"ListingId": "40843934"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T16:55:14Z"
+"RFModificationTimestamp": "2026-07-03T17:09:22Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2845.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3P2"
+"UnparsedAddress": "570 HALLMARK Drive, Waterloo, Ontario N2K3P2"
+"Coordinates": array:2 [
0 => -80.5232066
1 => 43.5004294
]
+"Latitude": 43.5004294
+"Longitude": -80.5232066
+"YearBuilt": 1989
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Location, Location, Location. Lovely 2 storey home in sought after 'Colonial Acres', backing onto trees and the privacy of Anndale Park with no neighbours behind. This home features two 2 Bedrooms up with new flooring and both with 4pc Ensuites. The main floor has a spacious Living room, formal Dining room, TV room with hardwood floor, 2pc Powder room and a walk-out to a deck with a retractable awning.The bright basement has a finished Recreation room with walk-out leading to a fenced yard, a 3pc Bath, an additional 3rd Bedroom, laundry and storage. This home has been well maintained throughout, with additional insulation added to the attic. This home is ideally located providing ameneties for the whole family, being steps from Conestoga Mall, LRT Transit Hub, Grey Silo Golf course, RIM Park recreation centre, walking trails, St. Jacob’s Farmers market, great schools and offering convenient access to the Expressway. A great place to call Home. (id:62650)"
+"Appliances": array:10 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Freezer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T00:59:43.127043+00:00"
+"Directions": "Davenport Rd to Hallmark Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563939"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Southern exposure"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Paved driveway"
4 => "Sump Pump"
5 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T23:10:26Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T16:48:31Z"
+"Stories": "2.0"
+"StreetName": "HALLMARK"
+"StreetNumber": "570"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "6316.27"
+"VirtualTourURLUnbranded": "https://youriguide.com/570_hallmark_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29982473/570-hallmark-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1775
+"BelowGradeFinishedArea": 1070
+"OriginalEntryTimestamp": "2026-07-02T23:10:26.09Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070118"
+"ListOfficeNationalAssociationId": "1473831"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29982473')"
+"ID": "1587688"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25225
+post_id: "1585240"
+post_author: 1
+"ListingKey": "29980078"
+"ListingId": "X13514038"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T18:40:18Z"
+"RFModificationTimestamp": "2026-07-02T19:13:12Z"
+"ListPrice": 724900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4L7"
+"UnparsedAddress": "765 ANGLER WAY, Waterloo, Ontario N2K4L7"
+"Coordinates": array:2 [
0 => -80.5001427
1 => 43.5145232
]
+"Latitude": 43.5145232
+"Longitude": -80.5001427
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "765 Angler Way, Waterloo is a spacious 3-bedroom, 2.5-bathroom home offering 1,437 sq ft above grade plus a finished basement. Located in one of north Waterloo's most highly sought-after family neighbourhoods on a quiet dead-end street, this property offers privacy, safety for children, and a true sense of community. The main floor includes a convenient 2-piece powder room, while the second level features three good-sized bedrooms and a 4-piece bathroom. The finished basement provides flexible living space with a basic rec room and 3-piece bathroom. Outside, enjoy the large back patio ideal for BBQs and relaxing in the private yard. With excellent access to top schools, parks, and amenities, this home is perfect for families looking to put down roots in a desirable location. (id:62650)"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T19:13:10.994697+00:00"
+"Directions": "Cross Streets: University. ** Directions: University to New Hampshire."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2154832"
+"ListOfficeKey": "285194"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "28 x 98.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T18:32:27Z"
+"PhotosCount": 24
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T18:32:27Z"
+"Stories": "2.0"
+"StreetName": "Angler"
+"StreetNumber": "765"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "4452"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/o6z5m_765_angler_way_waterloo_on/"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29980078/765-angler-way-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 28.0
+"OriginalEntryTimestamp": "2026-07-02T18:32:27.6Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1406273"
+"ListOfficeNationalAssociationId": "1348537"
+"Media": array:24 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29980078')"
+"ID": "1585240"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25220
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29978817')"
+"ID": "1587452"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1574855"
+post_author: 1
+"ListingKey": "29964583"
+"ListingId": "40843675"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T03:45:02Z"
+"RFModificationTimestamp": "2026-06-30T03:49:17Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2615.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4M2"
+"UnparsedAddress": "729 GRAND BANKS Drive, Waterloo, Ontario N2K4M2"
+"Coordinates": array:2 [
0 => -80.4982397
1 => 43.5124183
]
+"Latitude": 43.5124183
+"Longitude": -80.4982397
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautiful family home in the highly desirable Eastbridge neighbourhood! Featuring a bright open-concept layout, this well-maintained home offers a grand two-storey foyer, spacious Great Room with maple hardwood flooring, California shutters, and a walkout to the deck with stunning seasonal views of the Grand River. The kitchen boasts abundant cabinetry, a breakfast bar, and updated appliances. Upstairs, the spacious primary bedroom features a walk-in closet, an elegant 9'4 tray ceiling, and a private ensuite. The finished walkout basement provides additional living space, direct access to a large stone patio, and a rough-in for a future bathroom. The fully fenced backyard is perfect for family enjoyment and entertaining. Recent updates include roof (2021), driveway resurfacing (2023), patio and deck improvements (2024), bathroom updates (2025), washer (2022), kitchen appliances (2019), and owned water softener. Ideally located within walking distance to top-rated schools and close to RIM Park, shopping, trails, transit, and the Expressway. A fantastic opportunity to own a move-in-ready home in one of Waterloo's most sought-after family communities! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T06:20:09.218915+00:00"
+"Directions": "TAKE UNIVERSITY AVE EAST; TURN LEFT ON TO NEW BEDFORD DR; THEN TURN RIGHT ON TO GRAND BANKS DR."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955745"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-30T03:39:21Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T03:39:21Z"
+"Stories": "2.0"
+"StreetName": "GRAND BANKS"
+"StreetNumber": "729"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "5946"
+"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/29964583/729-grand-banks-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1825
+"BelowGradeFinishedArea": 790
+"OriginalEntryTimestamp": "2026-06-29T05:59:41.08Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1247419"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:38 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964583')"
+"ID": "1574855"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25228
+post_id: "1574152"
+post_author: 1
+"ListingKey": "29963525"
+"ListingId": "40843481"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T21:40:17Z"
+"RFModificationTimestamp": "2026-07-02T21:51:57Z"
+"ListPrice": 354990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 582.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G5"
+"UnparsedAddress": "255 NORTHFIELD Drive Unit# 308, Waterloo, Ontario N2K0G5"
+"Coordinates": array:2 [
0 => -80.5213765
1 => 43.5107332
]
+"Latitude": 43.5107332
+"Longitude": -80.5213765
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning 1-bedroom plus den, 1-bath condo offering the perfect blend of style, comfort, and low-maintenance living in one of the area's most sought-after neighbourhoods. This beautifully appointed unit features high-end finishes, abundant natural light, a primary bedroom complete with a walk-in closet and ensuite access, convenient in-suite laundry, one underground parking space, and a private locker. The versatile den is ideal for a home office. Enjoy an impressive selection of building amenities, including a fitness centre, event room, rooftop terrace with BBQ area and beautiful views, bike storage, and even a dog washing station. The well-maintained building also offers keyless entry. Perfectly situated just minutes from restaurants, shopping, theatres, the community centre, and the renowned St. Jacobs Farmers' Market. Outdoor enthusiasts will appreciate the nearby Walter Bean Trail, Grand River, RIM Park, and Grey Silo Golf Course. Conveniently located close to two universities with quick access to Highways 85 and 401, making commuting a breeze. This exceptional condo truly has it all—don't miss your opportunity to make it yours. Book your private showing today! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"AssociationFee": "493"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-28T01:33:38.248335+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564233"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-28T00:20:47Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T21:33:06Z"
+"Stories": "3.0"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3137.65"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29963525/255-northfield-drive-unit-308-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 582
+"OriginalEntryTimestamp": "2026-06-28T00:20:47.64Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070035"
+"ListOfficeNationalAssociationId": "1324759"
+"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('29963525')"
+"ID": "1574152"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25229
+post_id: "1572262"
+post_author: 1
+"ListingKey": "29961016"
+"ListingId": "40843507"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-27T20:25:21Z"
+"RFModificationTimestamp": "2026-06-27T20:29:58Z"
+"ListPrice": 1630000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 4544.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3H9"
+"UnparsedAddress": "250 GREY SQUIRREL Place, Waterloo, Ontario N2K3H9"
+"Coordinates": array:2 [
0 => -80.5202288
1 => 43.5085201
]
+"Latitude": 43.5085201
+"Longitude": -80.5202288
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover exceptional family living at 250 Grey Squirrel Place, a beautifully maintained home nestled on a quiet crescent in Waterloo's sought-after Colonial Acres. Situated on a rare double-sized lot, this impressive property offers an outstanding blend of space, comfort, and privacy in one of the city's most established neighbourhoods. Step inside to an inviting interior highlighted by soaring 14-foot ceilings in the front living room, rich hardwood flooring, and a charming wood-burning fireplace. A second fireplace anchors the spacious family room, providing the perfect setting for relaxed evenings, while a dedicated main-floor office offers a quiet space for working from home. Everyday convenience is enhanced by the functional mudroom and laundry area with direct access from the double-car garage. At the heart of the home, the well-appointed kitchen features granite countertops, a Bosch stove, Miele appliances, and a walkout to the newly completed tiered wood deck (2025). The expansive backyard is a true standout, offering a sports court, mature landscaping, Honeycrisp apple trees, a peach tree, and ample room for entertaining, gardening, or family recreation. The upper level features four spacious bedrooms, including a private primary retreat with its own ensuite bath, as well as a second full bathroom to accommodate family and guests. The fully finished basement adds incredible versatility with two additional bedrooms, a three-piece bathroom, and a large recreation area ideal for movie nights, games, or multi-generational living. Surrounded by mature trees and enhanced by an interlock driveway, this home delivers both curb appeal and lasting quality. Ideally positioned just minutes from Uptown Waterloo, the University of Waterloo, Waterloo Park, RIM Park, Grey Silo Golf Course, and The Boardwalk, this exceptional property offers the perfect balance of peaceful family living and convenient access to the region's top amenities. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Hood Fan"
8 => "Garage door opener"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T22:36:56.385277+00:00"
+"Directions": "Deer Run Dr to Grey Squirrel Pl"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2152269"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T21:50:05Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-27T20:19:50Z"
+"Stories": "2.0"
+"StreetName": "GREY SQUIRREL"
+"StreetNumber": "250"
+"StreetSuffix": "Place"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "9353.85"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:22 [
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]
20 => array:11 [ …11]
21 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29961016/250-grey-squirrel-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 114.0
+"AboveGradeFinishedArea": 2883
+"BelowGradeFinishedArea": 1661
+"OriginalEntryTimestamp": "2026-06-26T21:50:05.68Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1403932"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29961016')"
+"ID": "1572262"
}
]
+success: true
+page_size: 9
+page_count: 4
+count: 36
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]