array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29978817 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: "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 [
"RoomKey" => "1673404017"
"RoomType" => "Dining room"
"ListingId" => "40844546"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29978817"
"RoomLength" => null
"RoomDimensions" => "7'5'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T16:50:33.12Z"
]
1 => array:11 [
"RoomKey" => "1673404018"
"RoomType" => "3pc Bathroom"
"ListingId" => "40844546"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29978817"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T16:50:33.12Z"
]
2 => array:11 [
"RoomKey" => "1673404019"
"RoomType" => "Recreation room"
"ListingId" => "40844546"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29978817"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 17'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T16:50:33.12Z"
]
3 => array:11 [
"RoomKey" => "1673404020"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844546"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29978817"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T16:50:33.12Z"
]
4 => array:11 [
"RoomKey" => "1673404021"
"RoomType" => "Bedroom"
"ListingId" => "40844546"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29978817"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T16:50:33.12Z"
]
5 => array:11 [
"RoomKey" => "1673404022"
"RoomType" => "Bedroom"
"ListingId" => "40844546"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29978817"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 12'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T16:50:33.12Z"
]
6 => array:11 [
"RoomKey" => "1673404023"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844546"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29978817"
"RoomLength" => null
"RoomDimensions" => "14'7'' x 15'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T16:50:33.12Z"
]
7 => array:11 [
"RoomKey" => "1673404024"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844546"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29978817"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T16:50:33.12Z"
]
8 => array:11 [
"RoomKey" => "1673404025"
"RoomType" => "Kitchen"
"ListingId" => "40844546"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29978817"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T16:50:33.13Z"
]
9 => array:11 [
"RoomKey" => "1673404026"
"RoomType" => "Living room"
"ListingId" => "40844546"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29978817"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 18'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T16:50:33.13Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29978817_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/a367ce583397287766eeb48eefb00eaa.webp"
"MediaSize" => 93473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-a367ce583397287766eeb48eefb00eaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Traditional two-story residence featuring light-toned siding, a single-car garage, and a concrete walkway"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:09.12Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29978817_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/f4709c36bb472d08930e6dd5fe453983.webp"
"MediaSize" => 115719
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-f4709c36bb472d08930e6dd5fe453983.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring light blue siding, a white garage door, and a covered porch with white railings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:09.12Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29978817_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/590b88299b027c16135c7a17c25259e1.webp"
"MediaSize" => 115197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-590b88299b027c16135c7a17c25259e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Inviting front entry featuring light blue horizontal siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:09.12Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29978817_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/61f09dab655de22b9854326e8271a84b.webp"
"MediaSize" => 51033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-61f09dab655de22b9854326e8271a84b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring warm wood-finish flooring, white paneled doors, and a decorative frosted glass front door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:07.72Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29978817_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/ccdd3a4924287db422f0d33d7e0309cd.webp"
"MediaSize" => 75672
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-ccdd3a4924287db422f0d33d7e0309cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring wood-finish flooring, a contemporary chandelier, and an open layout to a kitchen with white cabinetry, dark countertops, and a subway tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:07.72Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29978817_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/9327fdee3172896517be040a9cb96e69.webp"
"MediaSize" => 56711
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-9327fdee3172896517be040a9cb96e69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white cabinetry, dark countertops, wood-finish flooring, a stainless steel range, and a stainless steel dishwasher"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:09.71Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29978817_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/19fe11c0557b210e8e4e7be8cf53b2ec.webp"
"MediaSize" => 85393
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-19fe11c0557b210e8e4e7be8cf53b2ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept kitchen and dining area featuring wood-finish flooring, white cabinetry, a built-in dishwasher, and a stainless steel refrigerator"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:11.17Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29978817_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/02b4a7c08657000b1babbab888374a09.webp"
"MediaSize" => 81922
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-02b4a7c08657000b1babbab888374a09.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:09.12Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29978817_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/448ae74a3a4542fda5f669963abfd7ac.webp"
"MediaSize" => 96082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-448ae74a3a4542fda5f669963abfd7ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area with wood-finish flooring and light wall colors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:09.12Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29978817_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/af34f90b8e1e46bddfc1315a11222f88.webp"
"MediaSize" => 66413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-af34f90b8e1e46bddfc1315a11222f88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Pedestal vanity with dark wood-finish cabinetry, white ceramic sink, and dark bronze faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:09.12Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29978817_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/9d430b30103ba5bf6bdb636ae02d7640.webp"
"MediaSize" => 57300
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-9d430b30103ba5bf6bdb636ae02d7640.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Staircase with white balusters and carpeted treads, leading to a carpeted landing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:07.72Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29978817_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/44f34630b25a15480315cab386172b76.webp"
"MediaSize" => 68358
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-44f34630b25a15480315cab386172b76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious bedroom featuring light-toned carpeting, white painted walls, and a large window with ample natural light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:07.72Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29978817_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/8713b2296fb21f2c45a7fa1974666079.webp"
"MediaSize" => 69520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-8713b2296fb21f2c45a7fa1974666079.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a dark wood vanity with a white countertop and integrated sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:07.72Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29978817_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/2f7ec51b3633516c1a4ce6e6b178e862.webp"
"MediaSize" => 50561
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-2f7ec51b3633516c1a4ce6e6b178e862.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with light neutral carpet flooring, a window with horizontal blinds, and a flush mount ceiling light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:09.12Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29978817_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/f0814c46e8eb409b5ae8f951bf251239.webp"
"MediaSize" => 58740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-f0814c46e8eb409b5ae8f951bf251239.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted room with a window featuring horizontal blinds, a flush-mount ceiling light, and white painted walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:07.72Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29978817_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/054518f61fabc671be5f9542541be30b.webp"
"MediaSize" => 46972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-054518f61fabc671be5f9542541be30b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:07.72Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29978817_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/2917df1ad12c67910dd9fb16b2bbde83.webp"
"MediaSize" => 62259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-2917df1ad12c67910dd9fb16b2bbde83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring wood-finish flooring, white walls, and an overhead flush-mount light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:07.72Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29978817_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/896b5835dcbe7f88efdc6003a13ec3c8.webp"
"MediaSize" => 83068
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-896b5835dcbe7f88efdc6003a13ec3c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept interior featuring wood-finish flooring, white walls, and a recessed ceiling light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:07.72Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29978817_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/c493ec5adc93afe60a53c97d0bca9f5e.webp"
"MediaSize" => 48081
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-c493ec5adc93afe60a53c97d0bca9f5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a corner shower enclosure, a vanity with a white countertop and dark gray cabinetry, and a circular wall mirror with an attached three-light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:07.72Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29978817_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/c2069c1f989e224ba75d021c3bd284a0.webp"
"MediaSize" => 121562
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-c2069c1f989e224ba75d021c3bd284a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:07.72Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29978817_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/d85f06ee2e7fbeab2b18ddc62cc0633c.webp"
"MediaSize" => 130919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-d85f06ee2e7fbeab2b18ddc62cc0633c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious wooden deck with a dark metal gazebo, complete with string lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:12.16Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29978817_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/6aaecdd82f19418f134aeb3ae3c1e96c.webp"
"MediaSize" => 134902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-6aaecdd82f19418f134aeb3ae3c1e96c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive outdoor deck featuring wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:09.12Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29978817_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/a01745103a5fa2b9907e5e1c74501d0a.webp"
"MediaSize" => 131750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-a01745103a5fa2b9907e5e1c74501d0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive wood-finish deck with black metal railings, featuring a covered pergola and integrated stone steps"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:07.72Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29978817_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/0faefe2cbff8c589034ab3eaf0b1bed8.webp"
"MediaSize" => 138114
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-0faefe2cbff8c589034ab3eaf0b1bed8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a wood deck with black metal railings, a manicured lawn, a wooden storage shed, and a tall privacy fence"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:07.72Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29978817_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978817/f1497d3584dc1a715d2004527991f47b.webp"
"MediaSize" => 129175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978817/thumbnail-f1497d3584dc1a715d2004527991f47b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive wood deck with a built-in gazebo featuring string lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844546"
"ResourceRecordKey" => "29978817"
"ModificationTimestamp" => "2026-07-02T16:33:07.72Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29978817')"
+"ID": "1587452"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 285135" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24873
+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 1920294" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24831
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29978817'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25213
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29978817'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25229
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29978817' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5004055 43.5144025)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25282
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25276
+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 [
"RoomKey" => "1674297532"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843697"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986048"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:33.21Z"
]
1 => array:11 [
"RoomKey" => "1674297533"
"RoomType" => "Full bathroom"
"ListingId" => "40843697"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986048"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:33.22Z"
]
2 => array:11 [
"RoomKey" => "1674297534"
"RoomType" => "Bedroom"
"ListingId" => "40843697"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986048"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:33.22Z"
]
3 => array:11 [
"RoomKey" => "1674297535"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843697"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986048"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:33.22Z"
]
4 => array:11 [
"RoomKey" => "1674297536"
"RoomType" => "Living room"
"ListingId" => "40843697"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986048"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 16'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:33.22Z"
]
5 => array:11 [
"RoomKey" => "1674297537"
"RoomType" => "Kitchen"
"ListingId" => "40843697"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986048"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:33.22Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29986048/255-northfield-drive-e-unit-505-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2059475"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "292003"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 158.0
+"AboveGradeFinishedArea": 801
+"OriginalEntryTimestamp": "2026-07-03T18:18:33.17Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1476314"
+"ListOfficeNationalAssociationId": "1407357"
+"CoListAgentNationalAssociationId": "1334623"
+"CoListOfficeNationalAssociationId": "1407357"
+"Media": array:8 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29986048_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/a455392c75fffdd9e494d033914cb72d.webp"
"MediaSize" => 53177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-a455392c75fffdd9e494d033914cb72d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29986048_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/e25770c11d666d2b4f3073002318c2e7.webp"
"MediaSize" => 56207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-e25770c11d666d2b4f3073002318c2e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29986048_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/74c2bf188f8b64fd271b95408206166e.webp"
"MediaSize" => 80547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-74c2bf188f8b64fd271b95408206166e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29986048_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/1b60f67966064961b32684bbcbd89e9c.webp"
"MediaSize" => 48842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-1b60f67966064961b32684bbcbd89e9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29986048_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/f0b6df7db15b5b6b99bb96c889185565.webp"
"MediaSize" => 46887
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-f0b6df7db15b5b6b99bb96c889185565.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29986048_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/70f541a0b017c0b10ebc5cd61c888761.webp"
"MediaSize" => 56129
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-70f541a0b017c0b10ebc5cd61c888761.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29986048_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/7a5eb6523874431a96da7ad431aa8813.webp"
"MediaSize" => 45602
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-7a5eb6523874431a96da7ad431aa8813.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29986048_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/5de9898eb6125a7035c48be6e2c9aaee.webp"
"MediaSize" => 72288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-5de9898eb6125a7035c48be6e2c9aaee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986048')"
+"ID": "1590600"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25278
+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"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25275
+post_id: "1589769"
+post_author: 1
+"ListingKey": "29984026"
+"ListingId": "40844904"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T19:05:17Z"
+"RFModificationTimestamp": "2026-07-03T19:06:07Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1753.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0E8"
+"UnparsedAddress": "532 WISMER Street, Waterloo, Ontario N2K0E8"
+"Coordinates": array:2 [
0 => -80.4878425
1 => 43.4990626
]
+"Latitude": 43.4990626
+"Longitude": -80.4878425
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Freehold End-Unit Townhome with No Condo Fees! Welcome to this beautifully updated freehold end-unit townhome, where extra windows, added privacy, and a larger fenced yard create the feel of a semi-detached home—all with no condo fees. The welcoming ground level features a versatile flex space, ideal as a home office, guest room, gym, or playroom, adapting effortlessly to your lifestyle. Upstairs, the bright and airy open-concept main living area is designed for both everyday living and entertaining. The stylish kitchen boasts quartz countertops, stainless steel appliances, and a spacious eat-in area, while still offering room for a separate dining space. The inviting living room opens through sliding doors to an elevated deck with stairs leading down to the fully fenced backyard—perfect for summer barbecues, children, or pets. A convenient two-piece powder room completes this level.The upper floor offers a spacious primary retreat featuring a walk-in closet and private ensuite bathroom. Two additional generously sized bedrooms and a second full bathroom provide comfortable space for family or guests. Situated in a fantastic Waterloo location close to parks, schools, shopping, universities, transit, and everyday amenities, this move-in-ready home is an exceptional opportunity for first-time buyers, young families, professionals, or investors looking for a low-maintenance property in a highly desirable neighbourhood. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T17:12:14.864059+00:00"
+"Directions": "University/Woolwich"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563569"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T14:18:21Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:59:24Z"
+"Stories": "3.0"
+"StreetName": "WISMER"
+"StreetNumber": "532"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "5302"
+"VirtualTourURLUnbranded": "https://youriguide.com/532_wismer_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1674331790"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844904"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29984026"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:59:24.96Z"
]
1 => array:11 [
"RoomKey" => "1674331791"
"RoomType" => "3pc Bathroom"
"ListingId" => "40844904"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29984026"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:59:24.96Z"
]
2 => array:11 [
"RoomKey" => "1674331792"
"RoomType" => "Bedroom"
"ListingId" => "40844904"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29984026"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:59:24.96Z"
]
3 => array:11 [
"RoomKey" => "1674331793"
"RoomType" => "Bedroom"
"ListingId" => "40844904"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29984026"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 15'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:59:24.96Z"
]
4 => array:11 [
"RoomKey" => "1674331794"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844904"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29984026"
"RoomLength" => null
"RoomDimensions" => "13'1'' x 14'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:59:24.96Z"
]
5 => array:11 [
"RoomKey" => "1674331795"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844904"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29984026"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:59:24.96Z"
]
6 => array:11 [
"RoomKey" => "1674331796"
"RoomType" => "Dining room"
"ListingId" => "40844904"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29984026"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 14'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:59:24.96Z"
]
7 => array:11 [
"RoomKey" => "1674331797"
"RoomType" => "Kitchen"
"ListingId" => "40844904"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29984026"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 15'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:59:24.96Z"
]
8 => array:11 [
"RoomKey" => "1674331798"
"RoomType" => "Living room"
"ListingId" => "40844904"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29984026"
"RoomLength" => null
"RoomDimensions" => "14'1'' x 18'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:59:24.96Z"
]
9 => array:11 [
"RoomKey" => "1674331799"
"RoomType" => "Office"
"ListingId" => "40844904"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29984026"
"RoomLength" => null
"RoomDimensions" => "13'7'' x 17'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:59:24.96Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29984026/532-wismer-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1600603"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2246706"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "76826"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 34.0
+"AboveGradeFinishedArea": 1753
+"BelowGradeFinishedArea": 0
+"OriginalEntryTimestamp": "2026-07-03T14:18:21.44Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1109914"
+"ListOfficeNationalAssociationId": "1389824"
+"CoListAgentNationalAssociationId": "1145016"
+"CoListAgentNationalAssociationId2": "1485557"
+"CoListOfficeNationalAssociationId": "1004387"
+"CoListOfficeNationalAssociationId2": "1004387"
+"Media": array:43 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29984026_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984026/398bae6919c8c6ad8969f6b16d5b64fc.webp"
"MediaSize" => 128582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984026/thumbnail-398bae6919c8c6ad8969f6b16d5b64fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844904"
"ResourceRecordKey" => "29984026"
"ModificationTimestamp" => "2026-07-03T14:18:21.45Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29984026_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984026/c396b3869d8ed6c0c692908fabe8695d.webp"
"MediaSize" => 138022
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984026/thumbnail-c396b3869d8ed6c0c692908fabe8695d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844904"
"ResourceRecordKey" => "29984026"
"ModificationTimestamp" => "2026-07-03T14:18:21.45Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29984026_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984026/7e2cc0344944c23047500292e6d0a4de.webp"
"MediaSize" => 133023
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984026/thumbnail-7e2cc0344944c23047500292e6d0a4de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844904"
"ResourceRecordKey" => "29984026"
"ModificationTimestamp" => "2026-07-03T14:18:21.45Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29984026_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984026/1cbb66e103ed53c681ccc04e1cbe9396.webp"
"MediaSize" => 156429
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984026/thumbnail-1cbb66e103ed53c681ccc04e1cbe9396.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844904"
"ResourceRecordKey" => "29984026"
"ModificationTimestamp" => "2026-07-03T14:18:21.45Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29984026_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984026/5ba78b9a3264e95ee6b0fa0668392eea.webp"
"MediaSize" => 134155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984026/thumbnail-5ba78b9a3264e95ee6b0fa0668392eea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844904"
"ResourceRecordKey" => "29984026"
"ModificationTimestamp" => "2026-07-03T14:18:21.45Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29984026_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984026/1929e931782d63938ee80f8f2e9f1c8e.webp"
"MediaSize" => 62699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984026/thumbnail-1929e931782d63938ee80f8f2e9f1c8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844904"
"ResourceRecordKey" => "29984026"
"ModificationTimestamp" => "2026-07-03T14:18:21.45Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29984026_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984026/558dd803e19450060697a8db39c1c5d3.webp"
"MediaSize" => 49459
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984026/thumbnail-558dd803e19450060697a8db39c1c5d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844904"
"ResourceRecordKey" => "29984026"
"ModificationTimestamp" => "2026-07-03T14:18:21.45Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29984026_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29984026/e5b8d177e2310618cf6e4d14efc5325f.webp"
"MediaSize" => 55520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29984026/thumbnail-e5b8d177e2310618cf6e4d14efc5325f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29984026')"
+"ID": "1589769"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25279
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25277
+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 {#25272
+post_id: "1576427"
+post_author: 1
+"ListingKey": "29964980"
+"ListingId": "X13499606"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T19:35:17Z"
+"RFModificationTimestamp": "2026-06-29T19:41:06Z"
+"ListPrice": 659000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4N9"
+"UnparsedAddress": "488 COLT STREET, Waterloo, Ontario N2K4N9"
+"Coordinates": array:2 [
0 => -80.490937
1 => 43.499333
]
+"Latitude": 43.499333
+"Longitude": -80.490937
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright, impeccably maintained freehold townhouse nestled in Waterloo's highly desirable Lexington neighbourhood. Designed for modern living, the open-concept main floor offers a spacious kitchen complete with stainless steel appliances, a well-appointed dining area, and an inviting great room that seamlessly connects to the outdoors. Step out to the expansive deck, perfect for summer entertaining, morning coffee, or simply relaxing in your private backyard setting, backing onto only one neighbouring property. The carpet-free main floor adds both style and practicality. Upstairs, you'll find three generously sized bedrooms, two full bathrooms, and the convenience of second-floor laundry. Ideally located close to shopping, schools, parks, public transit, and everyday amenities, this move-in-ready home offers the perfect blend of comfort, privacy, and convenience. Some photos virtually staged. Roof '23, AC '22 (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Window Coverings"
9 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T14:43:10.232271+00:00"
+"Directions": "Cross Streets: University/Woolwich. ** Directions: University to Colt."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1982520"
+"ListOfficeKey": "286883"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "22.9 x 102 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-29T13:50:08Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T19:28:30Z"
+"Stories": "2.0"
+"StreetName": "Colt"
+"StreetNumber": "488"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4354"
+"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": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29964980/488-colt-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 22.1
+"OriginalEntryTimestamp": "2026-06-29T13:50:08.26Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1267654"
+"ListOfficeNationalAssociationId": "1364605"
+"Media": array:31 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964980')"
+"ID": "1576427"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1575738"
+post_author: 1
+"ListingKey": "29964993"
+"ListingId": "40839771"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T19:00:07Z"
+"RFModificationTimestamp": "2026-06-29T19:03:37Z"
+"ListPrice": 659000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.05
+"LivingArea": 1440.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4N9"
+"UnparsedAddress": "488 COLT Street, Waterloo, Ontario N2K4N9"
+"Coordinates": array:2 [
0 => -80.4908096
1 => 43.4991897
]
+"Latitude": 43.4991897
+"Longitude": -80.4908096
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright, impeccably maintained freehold townhouse nestled in Waterloo's highly desirable Lexington neighbourhood. Designed for modern living, the open-concept main floor offers a spacious kitchen complete with stainless steel appliances, a well-appointed dining area, and an inviting great room that seamlessly connects to the outdoors. Step out to the expansive deck, perfect for summer entertaining, morning coffee, or simply relaxing in your private backyard setting, backing onto only one neighbouring property.The carpet-free main floor adds both style and practicality. Upstairs, you'll find three generously sized bedrooms, two full bathrooms, and the convenience of second-floor laundry. Ideally located close to shopping, schools, parks, public transit, and everyday amenities, this move-in-ready home offers the perfect blend of comfort, privacy, and convenience. Some photos virtually staged. Roof '23 AC ' 22 (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T14:32:02.394661+00:00"
+"Directions": "University to Colt"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1982520"
+"ListOfficeKey": "294000"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "0.05"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T13:50:41Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T18:51:28Z"
+"Stories": "2.0"
+"StreetName": "COLT"
+"StreetNumber": "488"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "4354"
+"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/29964993/488-colt-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 23.0
+"AboveGradeFinishedArea": 1440
+"OriginalEntryTimestamp": "2026-06-29T13:50:41.6Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1267654"
+"ListOfficeNationalAssociationId": "1434122"
+"Media": array:31 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964993')"
+"ID": "1575738"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25280
+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"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25281
+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"
}
]
+success: true
+page_size: 9
+page_count: 6
+count: 46
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]