array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29891240 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1521937"
+post_author: 1
+"ListingKey": "29891240"
+"ListingId": "X13433662"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T20:15:13Z"
+"RFModificationTimestamp": "2026-06-11T20:20:04Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2X4"
+"UnparsedAddress": "462 LAUSANNE CRESCENT, Waterloo, Ontario N2T2X4"
+"Coordinates": array:2 [
0 => -80.5749644
1 => 43.453304
]
+"Latitude": 43.453304
+"Longitude": -80.5749644
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Rarely does a home offer the perfect combination of privacy, convenience, and natural surroundings quite like this. Welcome to 462 Lausanne Crescent, a beautifully maintained FREEHOLD townhouse in Waterloo's highly desirable Clair Hills neighbourhood - providing the freedom of homeownership with no condo fees and backing directly onto open park-like space. Inside, you'll find a thoughtfully designed layout featuring two spacious bedrooms, each complete with its own private 4-piece ensuite bathroom - an ideal setup for professionals, downsizers, guests, or those seeking comfortable multi-generational living. The bright and functional main living areas provide an inviting space for everyday life, while the fully finished basement expands your options with a generous recreation room and versatile den, perfect for a home office or hobby room. One of the home's standout features is its exceptional setting. Backing onto expansive open park-like space with no rear neighbours, you'll enjoy peaceful views, added privacy, and direct access to trails and the outdoors. Located in the sought-after Clair Hills community and nearby Boardwalk shopping district, you'll enjoy close proximity to shopping, restaurants, public transit, and everyday amenities making this a favourite neighbourhood for professionals, families, and active adults alike. Offering flexible living space, a fully finished basement, two private ensuites, no condo fees, and a premium park-side location, this is a wonderful opportunity to enjoy all that Clair Hills has to offer. (id:66098)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Sauna"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Freezer"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T20:19:52.553690+00:00"
+"Directions": "Cross Streets: Erbsville Road. ** Directions: Erbsville Road to Keats Way to Brandenburg Blvd to Lausanne Cres."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1555372"
+"ListOfficeKey": "85457"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "16 x 99.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T19:31:56Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T20:04:17Z"
+"Stories": "2.0"
+"StreetName": "Lausanne"
+"StreetNumber": "462"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3766.84"
+"VirtualTourURLUnbranded": "https://youriguide.com/lmi4y_462_lausanne_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1657306820"
"RoomType" => "Living room"
"ListingId" => "X13433662"
"RoomLevel" => "Main level"
"RoomWidth" => 4.32
"ListingKey" => "29891240"
"RoomLength" => 4.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T20:04:17.77Z"
]
1 => array:11 [
"RoomKey" => "1657306821"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13433662"
"RoomLevel" => "Basement"
"RoomWidth" => 4.06
"ListingKey" => "29891240"
"RoomLength" => 8.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T20:04:17.77Z"
]
2 => array:11 [
"RoomKey" => "1657306822"
"RoomType" => "Office"
"ListingId" => "X13433662"
"RoomLevel" => "Basement"
"RoomWidth" => 2.81
"ListingKey" => "29891240"
"RoomLength" => 3.85
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T20:04:17.77Z"
]
3 => array:11 [
"RoomKey" => "1657306823"
"RoomType" => "Utility room"
"ListingId" => "X13433662"
"RoomLevel" => "Basement"
"RoomWidth" => 2.25
"ListingKey" => "29891240"
"RoomLength" => 4.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T20:04:17.78Z"
]
4 => array:11 [
"RoomKey" => "1657306824"
"RoomType" => "Kitchen"
"ListingId" => "X13433662"
"RoomLevel" => "Main level"
"RoomWidth" => 2.4
"ListingKey" => "29891240"
"RoomLength" => 2.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T20:04:17.78Z"
]
5 => array:11 [
"RoomKey" => "1657306825"
"RoomType" => "Dining room"
"ListingId" => "X13433662"
"RoomLevel" => "Main level"
"RoomWidth" => 3.22
"ListingKey" => "29891240"
"RoomLength" => 3.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T20:04:17.78Z"
]
6 => array:11 [
"RoomKey" => "1657306826"
"RoomType" => "Laundry room"
"ListingId" => "X13433662"
"RoomLevel" => "Main level"
"RoomWidth" => 2.34
"ListingKey" => "29891240"
"RoomLength" => 1.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T20:04:17.78Z"
]
7 => array:11 [
"RoomKey" => "1657306827"
"RoomType" => "Foyer"
"ListingId" => "X13433662"
"RoomLevel" => "Main level"
"RoomWidth" => 1.67
"ListingKey" => "29891240"
"RoomLength" => 3.26
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T20:04:17.78Z"
]
8 => array:11 [
"RoomKey" => "1657306828"
"RoomType" => "Bathroom"
"ListingId" => "X13433662"
"RoomLevel" => "Main level"
"RoomWidth" => 1.37
"ListingKey" => "29891240"
"RoomLength" => 1.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T20:04:17.78Z"
]
9 => array:11 [
"RoomKey" => "1657306829"
"RoomType" => "Bedroom"
"ListingId" => "X13433662"
"RoomLevel" => "Second level"
"RoomWidth" => 5.63
"ListingKey" => "29891240"
"RoomLength" => 3.54
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T20:04:17.78Z"
]
10 => array:11 [
"RoomKey" => "1657306830"
"RoomType" => "Bathroom"
"ListingId" => "X13433662"
"RoomLevel" => "Second level"
"RoomWidth" => 2.95
"ListingKey" => "29891240"
"RoomLength" => 2.31
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T20:04:17.78Z"
]
11 => array:11 [
"RoomKey" => "1657306831"
"RoomType" => "Bedroom 2"
"ListingId" => "X13433662"
"RoomLevel" => "Second level"
"RoomWidth" => 3.66
"ListingKey" => "29891240"
"RoomLength" => 3.67
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T20:04:17.79Z"
]
12 => array:11 [
"RoomKey" => "1657306832"
"RoomType" => "Bathroom"
"ListingId" => "X13433662"
"RoomLevel" => "Second level"
"RoomWidth" => 1.84
"ListingKey" => "29891240"
"RoomLength" => 2.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T20:04:17.79Z"
]
]
+"ListAOR": "OnePoint"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29891240/462-lausanne-crescent-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2088761"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "85457"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 16.0
+"OriginalEntryTimestamp": "2026-06-11T19:31:56.5Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1147383"
+"ListOfficeNationalAssociationId": "1002051"
+"CoListAgentNationalAssociationId": "1362076"
+"CoListOfficeNationalAssociationId": "1002051"
+"Media": array:47 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29891240_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/1b6f2c67722e395e77c9e6ddde7dc8cc.webp"
"MediaSize" => 401872
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-1b6f2c67722e395e77c9e6ddde7dc8cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29891240_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/520a9e485491a067f2c7597ff32f092a.webp"
"MediaSize" => 493007
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-520a9e485491a067f2c7597ff32f092a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29891240_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/038f6ff795ceb076407415c79d71dc83.webp"
"MediaSize" => 273110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-038f6ff795ceb076407415c79d71dc83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29891240_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/88777b9d0f967bd4cce534775fb7c930.webp"
"MediaSize" => 166864
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-88777b9d0f967bd4cce534775fb7c930.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29891240_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/af1494c01ca309705466db90f659d8c4.webp"
"MediaSize" => 166409
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-af1494c01ca309705466db90f659d8c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29891240_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/3deb0af6191b3d9580b990404008494e.webp"
"MediaSize" => 194948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-3deb0af6191b3d9580b990404008494e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29891240_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/c00906c20cea2f3e66a0ef75a8afa40a.webp"
"MediaSize" => 230839
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-c00906c20cea2f3e66a0ef75a8afa40a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29891240_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/9dcc93bead9c5c65985fd2d71496b548.webp"
"MediaSize" => 218861
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-9dcc93bead9c5c65985fd2d71496b548.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29891240_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/5bb9a6344964287e4acecd7fe58ecc82.webp"
"MediaSize" => 204755
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-5bb9a6344964287e4acecd7fe58ecc82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29891240_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/3385cdaf48745d69dbdb683317ffb8a5.webp"
"MediaSize" => 231086
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-3385cdaf48745d69dbdb683317ffb8a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29891240_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/fbc0f050ba907ee231ceef21c359b178.webp"
"MediaSize" => 179177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-fbc0f050ba907ee231ceef21c359b178.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29891240_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/ef90076ee68648d1bac1ef09305c1c9d.webp"
"MediaSize" => 189765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-ef90076ee68648d1bac1ef09305c1c9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29891240_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/3ee7330c6e128a0657bd66f5fc85f50a.webp"
"MediaSize" => 216782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-3ee7330c6e128a0657bd66f5fc85f50a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29891240_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/bf9c118411e182b9c2a3c8359bf5ed25.webp"
"MediaSize" => 182648
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-bf9c118411e182b9c2a3c8359bf5ed25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29891240_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/8888f9cefb2eb29b1ba328d5d6ebd60f.webp"
"MediaSize" => 214920
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-8888f9cefb2eb29b1ba328d5d6ebd60f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29891240_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/bd59f51d9fe623b071091028db0b85d6.webp"
"MediaSize" => 227908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-bd59f51d9fe623b071091028db0b85d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29891240_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/726020bc5ccede7ca7d98387a3fc62cb.webp"
"MediaSize" => 162541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-726020bc5ccede7ca7d98387a3fc62cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29891240_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/0fc1373c1a068211f3599fdbb207f9cc.webp"
"MediaSize" => 137753
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-0fc1373c1a068211f3599fdbb207f9cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29891240_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/cb84f6273972138987de53c6d67035e0.webp"
"MediaSize" => 201170
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-cb84f6273972138987de53c6d67035e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29891240_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/dbb17e2826e0c00f677738881f6336fa.webp"
"MediaSize" => 170487
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-dbb17e2826e0c00f677738881f6336fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primay bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29891240_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/a02be811806ec09c5fea96aa22521900.webp"
"MediaSize" => 169018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-a02be811806ec09c5fea96aa22521900.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29891240_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/99dd1d2bbab1bf5d0a8077d8136cb980.webp"
"MediaSize" => 126315
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-99dd1d2bbab1bf5d0a8077d8136cb980.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29891240_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/021344699348c13410abdcffe72c132e.webp"
"MediaSize" => 120725
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-021344699348c13410abdcffe72c132e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary ensuite"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29891240_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/06ae23b9729c88dca8044b43df52f6de.webp"
"MediaSize" => 122066
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-06ae23b9729c88dca8044b43df52f6de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary ensuite"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29891240_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/6cfd59e74287bf3e502acc70622cb5ca.webp"
"MediaSize" => 171075
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-6cfd59e74287bf3e502acc70622cb5ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29891240_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/5d97c0faf8e64bfdb74bae186d8cbcaf.webp"
"MediaSize" => 174340
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-5d97c0faf8e64bfdb74bae186d8cbcaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29891240_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/206e7a4578f80d61ea85f88a6689eed6.webp"
"MediaSize" => 144847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-206e7a4578f80d61ea85f88a6689eed6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom ensuite"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29891240_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/dcd35cb1f8fd65a360e79c3389f57c06.webp"
"MediaSize" => 127386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-dcd35cb1f8fd65a360e79c3389f57c06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom ensuite"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29891240_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/f9c24ba6422ca02d7bdc286664e051e8.webp"
"MediaSize" => 193194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-f9c24ba6422ca02d7bdc286664e051e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29891240_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/0af3b18742b083f4b82f8201f4fba43e.webp"
"MediaSize" => 165309
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-0af3b18742b083f4b82f8201f4fba43e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29891240_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/619c04a6a071d58c77af30218ab52caa.webp"
"MediaSize" => 202793
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-619c04a6a071d58c77af30218ab52caa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29891240_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/3dce19a6abd6df14c1803288896cf10f.webp"
"MediaSize" => 193553
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-3dce19a6abd6df14c1803288896cf10f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29891240_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/69d5b274adb7e411cd664d97f77d0756.webp"
"MediaSize" => 186263
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-69d5b274adb7e411cd664d97f77d0756.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29891240_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/83dca5b75a0b578ee13c3cf1c065d22b.webp"
"MediaSize" => 189284
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-83dca5b75a0b578ee13c3cf1c065d22b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29891240_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/a701d26f40b3514a009cb78897b75f2b.webp"
"MediaSize" => 185588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-a701d26f40b3514a009cb78897b75f2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29891240_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/67989e5dfc80a6f729db71b1bcbe85e0.webp"
"MediaSize" => 360665
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-67989e5dfc80a6f729db71b1bcbe85e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29891240_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/f391361c97546bae5a409b7212e2eacd.webp"
"MediaSize" => 344195
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-f391361c97546bae5a409b7212e2eacd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29891240_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/6d3a7d608f0ad02f617dcc63666a803a.webp"
"MediaSize" => 400187
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-6d3a7d608f0ad02f617dcc63666a803a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29891240_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/c7a051b04f4b200e18f48830f56058dd.webp"
"MediaSize" => 379105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-c7a051b04f4b200e18f48830f56058dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29891240_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/83d8894be7f33601dea8274b7b844d1a.webp"
"MediaSize" => 392627
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-83d8894be7f33601dea8274b7b844d1a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29891240_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/34954d0d419e0f6420825633b6044257.webp"
"MediaSize" => 368285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-34954d0d419e0f6420825633b6044257.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29891240_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/1573c60f06702012d63259cb36fc31a3.webp"
"MediaSize" => 336178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-1573c60f06702012d63259cb36fc31a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29891240_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/881ca80a97595b52b42b42b750196608.webp"
"MediaSize" => 479913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-881ca80a97595b52b42b42b750196608.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29891240_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/22bb92a7b5df24af58abaf3c3dc6a259.webp"
"MediaSize" => 494111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-22bb92a7b5df24af58abaf3c3dc6a259.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29891240_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/a1a8ff048b550e01ead89a24274a828e.webp"
"MediaSize" => 106845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-a1a8ff048b550e01ead89a24274a828e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29891240_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/91f535a33be991fbe0a30b25a5492128.webp"
"MediaSize" => 113655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-91f535a33be991fbe0a30b25a5492128.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29891240_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891240/7e6e5b419c82282895c8eff1125e0089.webp"
"MediaSize" => 95539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891240/thumbnail-7e6e5b419c82282895c8eff1125e0089.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433662"
"ResourceRecordKey" => "29891240"
"ModificationTimestamp" => "2026-06-11T19:31:56.5Z"
]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891240')"
+"ID": "1521937"
}
]
+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 85457" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24817
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1555372" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24790
+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 '29891240'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25138
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29891240'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25154
+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 '29891240' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5749644 43.453304)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25227
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25221
+post_id: "1535094"
+post_author: 1
+"ListingKey": "29908779"
+"ListingId": "40835169"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T13:40:12Z"
+"RFModificationTimestamp": "2026-06-16T17:54:46Z"
+"ListPrice": 1399900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3956.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5M1"
+"UnparsedAddress": "387 STILLMEADOW Circle, Waterloo, Ontario N2L5M1"
+"Coordinates": array:2 [
0 => -80.5618392
1 => 43.4673142
]
+"Latitude": 43.4673142
+"Longitude": -80.5618392
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 387 Stillmeadow Circle, a beautifully renovated family home in one of Waterloo's most sought-after neighbourhoods. Completely transformed from top to bottom in 2018, this exceptional property blends timeless design, quality craftsmanship, and modern functionality throughout. Offering over three finished levels of living space, the home features 4 spacious bedrooms upstairs, an additional bedroom in the fully finished lower level, and 4 beautifully appointed bathrooms. The thoughtfully designed layout is ideal for growing families, with generous principal rooms, stylish finishes, and plenty of space to gather, entertain, and unwind. Step outside to your private backyard retreat backing directly onto a park, providing peaceful views, added privacy, and direct access to green space. Whether you're enjoying morning coffee on the patio or hosting summer gatherings, this outdoor setting is truly special. Additional updates include a new furnace and air conditioner installed in 2025, offering peace of mind for years to come. Located within walking distance to the community pool and tennis courts, and close to excellent schools, trails, shopping, and amenities, this is a rare opportunity to own a turnkey home in a premier Waterloo location. Move in and enjoy the perfect combination of luxury, comfort, and community living. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:53:49.943718+00:00"
+"Directions": "Columbia to Beechlawn to Stillmeadow"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1688209"
+"ListOfficeKey": "296447"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T13:31:43Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T13:31:43Z"
+"Stories": "2.0"
+"StreetName": "STILLMEADOW"
+"StreetNumber": "387"
+"StreetSuffix": "Circle"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "10118.54"
+"VirtualTourURLUnbranded": "https://youriguide.com/387_stillmeadow_cir_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [
"RoomKey" => "1660444463"
"RoomType" => "Utility room"
"ListingId" => "40835169"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908779"
"RoomLength" => null
"RoomDimensions" => "16'4'' x 18'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:31:43.17Z"
]
1 => array:11 [
"RoomKey" => "1660444464"
"RoomType" => "Recreation room"
"ListingId" => "40835169"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908779"
"RoomLength" => null
"RoomDimensions" => "33'8'' x 20'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:31:43.17Z"
]
2 => array:11 [
"RoomKey" => "1660444465"
"RoomType" => "Bedroom"
"ListingId" => "40835169"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908779"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:31:43.17Z"
]
3 => array:11 [
"RoomKey" => "1660444466"
"RoomType" => "3pc Bathroom"
"ListingId" => "40835169"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908779"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:31:43.17Z"
]
4 => array:11 [
"RoomKey" => "1660444467"
"RoomType" => "Primary Bedroom"
"ListingId" => "40835169"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908779"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 20'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:31:43.17Z"
]
5 => array:11 [
"RoomKey" => "1660444468"
"RoomType" => "Bedroom"
"ListingId" => "40835169"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908779"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 8'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:31:43.17Z"
]
6 => array:11 [
"RoomKey" => "1660444469"
"RoomType" => "Bedroom"
"ListingId" => "40835169"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908779"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:31:43.18Z"
]
7 => array:11 [
"RoomKey" => "1660444470"
"RoomType" => "Bedroom"
"ListingId" => "40835169"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908779"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:31:43.18Z"
]
8 => array:11 [
"RoomKey" => "1660444471"
"RoomType" => "Full bathroom"
"ListingId" => "40835169"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908779"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:31:43.18Z"
]
9 => array:11 [
"RoomKey" => "1660444472"
"RoomType" => "4pc Bathroom"
"ListingId" => "40835169"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908779"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:31:43.18Z"
]
10 => array:11 [
"RoomKey" => "1660444473"
"RoomType" => "Office"
"ListingId" => "40835169"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908779"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:31:43.18Z"
]
11 => array:11 [
"RoomKey" => "1660444474"
"RoomType" => "Laundry room"
"ListingId" => "40835169"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908779"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 13'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:31:43.18Z"
]
12 => array:11 [
"RoomKey" => "1660444475"
"RoomType" => "Kitchen"
"ListingId" => "40835169"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908779"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 12'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:31:43.18Z"
]
13 => array:11 [
"RoomKey" => "1660444476"
"RoomType" => "Dining room"
"ListingId" => "40835169"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908779"
"RoomLength" => null
"RoomDimensions" => "18'4'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:31:43.18Z"
]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29908779/387-stillmeadow-circle-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2099327"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283397"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 55.0
+"AboveGradeFinishedArea": 2681
+"BelowGradeFinishedArea": 1275
+"OriginalEntryTimestamp": "2026-06-16T13:31:43.12Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1173922"
+"ListOfficeNationalAssociationId": "1458684"
+"CoListAgentNationalAssociationId": "1369514"
+"CoListOfficeNationalAssociationId": "1328541"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908779')"
+"ID": "1535094"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25223
+post_id: "1534852"
+post_author: 1
+"ListingKey": "29908777"
+"ListingId": "40839715"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T22:15:05Z"
+"RFModificationTimestamp": "2026-06-16T22:16:00Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1487.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2V2"
+"UnparsedAddress": "600 WHITE ELM Boulevard Unit# 9, Waterloo, Ontario N2V2V2"
+"Coordinates": array:2 [
0 => -80.5870471
1 => 43.4667674
]
+"Latitude": 43.4667674
+"Longitude": -80.5870471
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained carpet-free 3-bedroom, 2-bathroom townhome in the highly sought-after Laurelwood/Columbia Forest community of Waterloo. Featuring elegant oak hardwood flooring throughout the living area and the entire second floor, this home offers both timeless style and easy maintenance. The bright and functional open-concept main floor boasts spacious living and dining areas with large windows and sliding doors that flood the space with natural light and lead to a private deck and backyard—perfect for entertaining or relaxing outdoors. The well-appointed kitchen provides ample cabinetry and workspace, while the upper level offers three generous bedrooms, including a spacious primary bedroom with a walk-in closet and convenient access to a full bathroom. The basement includes a bathroom rough-in, presenting an excellent opportunity to add a future washroom and customize additional living space to meet your needs. Complete with an attached garage and driveway parking, this home is ideally located steps to parks, trails, public transit, and top-rated schools, and just minutes from the Boardwalk Shopping Centre, YMCA, both universities, and all major amenities. The condo fees provide exceptional value by covering major exterior components, including roof, windows, and exterior doors repair and replacement, offering added peace of mind and reduced long-term maintenance costs. An outstanding opportunity for families, first-time buyers, or investors to own in one of Waterloo’s most desirable neighbourhoods. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Garage door opener"
]
+"AssociationFee": "713.32"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:53:42.414855+00:00"
+"Directions": "Erbsville Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2055634"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "0"
+"PhotosChangeTimestamp": "2026-06-16T13:30:50Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T22:09:47Z"
+"Stories": "2.0"
+"StreetName": "WHITE ELM"
+"StreetNumber": "600"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3308.52"
+"Utilities": array:1 [
0 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/9_600_white_elm_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29908777/600-white-elm-boulevard-unit-9-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R7"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1367
+"BelowGradeFinishedArea": 120
+"OriginalEntryTimestamp": "2026-06-16T13:30:49.96Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1330898"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:27 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908777')"
+"ID": "1534852"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25219
+post_id: "1535095"
+post_author: 1
+"ListingKey": "29909404"
+"ListingId": "X13449772"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T15:10:12Z"
+"RFModificationTimestamp": "2026-06-16T17:22:49Z"
+"ListPrice": 1399900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5M1"
+"UnparsedAddress": "387 STILLMEADOW CIRCLE, Waterloo, Ontario N2L5M1"
+"Coordinates": array:2 [
0 => -80.561844
1 => 43.467325
]
+"Latitude": 43.467325
+"Longitude": -80.561844
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 387 Stillmeadow Circle, a beautifully renovated family home in one of Waterloo's most sought-after neighbourhoods. Completely transformed from top to bottom in 2018, this exceptional property blends timeless design, quality craftsmanship, and modern functionality throughout. Offering over three finished levels of living space, the home features 4 spacious bedrooms upstairs, an additional bedroom in the fully finished lower level, and 4 beautifully appointed bathrooms. The thoughtfully designed layout is ideal for growing families, with generous principal rooms, stylish finishes, and plenty of space to gather, entertain, and unwind. Step outside to your private backyard retreat backing directly onto a park, providing peaceful views, added privacy, and direct access to green space. Whether you're enjoying morning coffee on the patio or hosting summer gatherings, this outdoor setting is truly special. Additional updates include a new furnace and air conditioner installed in 2025, offering peace of mind for years to come. Located within walking distance to the community pool and tennis courts, and close to excellent schools, trails, shopping, and amenities, this is a rare opportunity to own a turnkey home in a premier Waterloo location. Move in and enjoy the perfect combination of luxury, comfort, and community living. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Cooktop"
8 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:22:35.484541+00:00"
+"Directions": "Cross Streets: Columbia and Fischer Hallman. ** Directions: Columbia to Beechlawn to Stillmeadow."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2211703"
+"ListOfficeKey": "296481"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "55.2 x 118.2 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T15:02:20Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:02:20Z"
+"Stories": "2.0"
+"StreetName": "Stillmeadow"
+"StreetNumber": "387"
+"StreetSuffix": "Circle"
+"TaxAnnualAmount": "10118.54"
+"VirtualTourURLUnbranded": "https://youriguide.com/387_stillmeadow_cir_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29909404/387-stillmeadow-circle-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 55.2
+"OriginalEntryTimestamp": "2026-06-16T15:02:20.75Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1457628"
+"ListOfficeNationalAssociationId": "1470796"
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909404')"
+"ID": "1535095"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25224
+post_id: "1531332"
+post_author: 1
+"ListingKey": "29906172"
+"ListingId": "X13447102"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T20:30:18Z"
+"RFModificationTimestamp": "2026-06-15T20:55:52Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2K6"
+"UnparsedAddress": "629B SETTLERSFIELD COURT, Waterloo, Ontario N2T2K6"
+"Coordinates": array:2 [
0 => -80.569765
1 => 43.449035
]
+"Latitude": 43.449035
+"Longitude": -80.569765
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Prepare to fall in love with this beautifully updated back-split with separate side entrance. Located in a quiet family friendly neighbourhood close to the Boardwalk Costco and more. This 2 plus bedroom boasts 3 full bathrooms, open concept floor plan featuring Stainless steel appliance, quartz countertops, upgraded kitchen cabinets and lighting package plus an attractive staircase. Upstairs you will find 2 bedrooms plus built in laundry and 4 piece bath. You'll love the family-room with large windows for tons of natural light. Full 4 piece bath is within easy reach, there is a side entrance leading to a great deck and a fully fenced pie shaped back yard with mature trees. Looking for extra space then basement level features a brand new inlaw with 2nd kitchen with appliances, good size 3rd bedroom or rec-room plus another 3 piece bathroom for the teens. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
6 => "Water Heater"
]
+"Basement": array:7 [
0 => "Finished"
1 => "Full"
2 => "Apartment in basement"
3 => "Separate entrance"
4 => "N/A"
5 => "N/A"
6 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T20:55:42.913447+00:00"
+"Directions": "Cross Streets: Pinerow. ** Directions: ERBSVILLE ROAD TO RUMMERLHARDT DR TO PINEROW CRES."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2152762"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "24 x 121.7 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T20:02:49Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T20:23:02Z"
+"StreetName": "Settlersfield"
+"StreetNumber": "629B"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "3850"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/629_b_settlersfield_ct_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29906172/629b-settlersfield-court-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 24.0
+"OriginalEntryTimestamp": "2026-06-15T20:02:49.07Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1404760"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29906172')"
+"ID": "1531332"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25222
+post_id: "1530352"
+post_author: 1
+"ListingKey": "29904040"
+"ListingId": "X13445040"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T17:45:13Z"
+"RFModificationTimestamp": "2026-06-16T17:49:22Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5B1"
+"UnparsedAddress": "50 COMBERMERE CRESCENT, Waterloo, Ontario N2L5B1"
+"Coordinates": array:2 [
0 => -80.555507
1 => 43.4638809
]
+"Latitude": 43.4638809
+"Longitude": -80.555507
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Some homes are simply worth the wait. 50 Combermere Crescent is one of them. Offered for sale for the first time in almost 50 years, this rare Beechwood opportunity presents a spacious 5-bedroom, 2.5-bathroom raised bungalow on a beautifully landscaped 0.256-acre reverse pie-shaped lot, delivering exceptional curb appeal from the moment you arrive. A sweeping circular driveway and attached double-car garage complete the picture. Beechwood isn't just a neighbourhood. It's a way of life. Surrounded by mature trees and neighbours who have watched generations of children grow up together, this is a community where front porches still mean something. As a member of the Beechwood II Homes Association, with annual dues conveniently included in your property taxes, you'll enjoy access to a private community pool, tennis courts, multi-sport court, summer recreation programs, and neighbourhood events that have made Beechwood one of Waterloo's most beloved places to call home. Inside, the generous floor plan offers ample space for growing families, multi-generational living, or those seeking room to work and entertain. The home carries its original 1970s character throughout - solid, well-built, and full of warmth - ready for a buyer with the vision to renovate, reimagine, and make it their own. Outdoor enthusiasts will appreciate the proximity to Clair Lake Park and its scenic trail network, while Laurel Creek Conservation Area is just minutes away for hiking, paddling, nature exploration, and winter recreation. Excellent schools, the universities, The Boardwalk, Uptown Waterloo, restaurants, transit, and everyday amenities are all within easy reach. Whether you're looking to undertake a full renovation, modernize thoughtfully over time, or build lasting equity in one of Waterloo's premier locations, opportunities like this are increasingly rare. 50 Combermere Crescent. Rare. Rooted. Ready for its next chapter. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:7 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "Walk-up"
4 => "N/A"
5 => "N/A"
6 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-15T17:31:08.964190+00:00"
+"Directions": "Cross Streets: Craigleith & Combermere. ** Directions: Fischer-Hallman to Craigleith to Combermere."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2191304"
+"ListOfficeKey": "300391"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Wooded area"
]
+"LotSizeDimensions": "151.5 x 131 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T16:38:31Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T17:33:50Z"
+"Stories": "1.0"
+"StreetName": "Combermere"
+"StreetNumber": "50"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6736.21"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/50_combermere_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29904040/50-combermere-crescent-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Separate Heating Controls"
1 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 151.6
+"OriginalEntryTimestamp": "2026-06-15T16:14:04.52Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1440395"
+"ListOfficeNationalAssociationId": "1487304"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29904040')"
+"ID": "1530352"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25197
+post_id: "1530278"
+post_author: 1
+"ListingKey": "29902772"
+"ListingId": "40839584"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T15:40:08Z"
+"RFModificationTimestamp": "2026-06-15T20:50:40Z"
+"ListPrice": 879900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3141.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1Y4"
+"UnparsedAddress": "487 EDENVALLEY Crescent, Waterloo, Ontario N2T1Y4"
+"Coordinates": array:2 [
0 => -80.5587807
1 => 43.4453202
]
+"Latitude": 43.4453202
+"Longitude": -80.5587807
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located in one of Waterloo's most desirable family-friendly neighbourhoods Westvale! This wonderful home is just steps from Westvale Public School and Holy Rosary Catholic School, making school drop-offs and after-school activities effortless. Designed with family living in mind, this warm and welcoming home offers plenty of space to gather and grow. The spacious living room and separate dining room provide the perfect setting for family dinners and holiday celebrations. The updated kitchen features abundant counter space, a walk-in pantry, and a bright eat-in area overlooking the large patio and fully fenced backyard—ideal for family meals and keeping an eye on the kids while they play. The sunken family room is the heart of the home, showcasing a cozy gas fireplace and beautiful stone accent wall—perfect for relaxing evenings together. Main floor mudroom/ laundry room for the added bonus! Upstairs, you'll find four generously sized bedrooms, including a massive primary retreat with a walk-in closet and private ensuite. An updated main bathroom serves the additional bedrooms. The finished lower level adds valuable living space with a spacious rec room, fifth bedroom or home office, and a full bathroom with a deep soaker tub. Outside, enjoy a large patio and fully fenced backyard, perfect for summer barbecues, family gatherings, and outdoor play. Recent updates include the roof, furnace, and central air conditioning, allowing you to move in with confidence. Ideally located just minutes from The Boardwalk, Movati Athletic, shopping, restaurants, transit, universities, parks, and trails, this move-in-ready home offers the perfect blend of comfort, space, and convenience for today's growing family. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Partial"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T15:43:43.864027+00:00"
+"Directions": "Fischer Hallman"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1600661"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T12:51:16Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T15:31:16Z"
+"Stories": "2.0"
+"StreetName": "EDENVALLEY"
+"StreetNumber": "487"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "5891"
+"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/29902772/487-edenvalley-crescent-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "5R1-10"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 49.0
+"AboveGradeFinishedArea": 2320
+"BelowGradeFinishedArea": 821
+"OriginalEntryTimestamp": "2026-06-15T12:51:15.61Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1155649"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29902772')"
+"ID": "1530278"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1525564"
+post_author: 1
+"ListingKey": "29898161"
+"ListingId": "40839319"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T19:45:02Z"
+"RFModificationTimestamp": "2026-06-13T19:46:04Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1322.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2K6"
+"UnparsedAddress": "629 SETTLERSFIELD Court Unit# B, Waterloo, Ontario N2T2K6"
+"Coordinates": array:2 [
0 => -80.569755
1 => 43.4490121
]
+"Latitude": 43.4490121
+"Longitude": -80.569755
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Prepare to fall in love with this beautifully updated backsplit with separate side entrance. Located in a quiet family friendly neighbourhood close to the Boardwalk Costco and more. This 2 plus bedroom boasts 3 full bathrooms, open concept floor plan featuring Stainless steel appliance, quartz countertops, upgraded kitchen cabinets and lighting package plus an attractive staircase. Upstairs you will find 2 bedrooms plus built in laundry and 4 piece bath. You'll love the familyroom with large windows for tons of natural light. Full 4 piece bath is within easy reach, there is a side entrance leading to a great deck and a fully fenced pie shaped back yard with mature trees. Looking for extra space then basement level features a brand new inlaw with 2nd kitchen with appliances, good size 3rd bedroom or recroom plus another 3 piece bathroom for the teens. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T21:37:11.360335+00:00"
+"Directions": "ERBSVILLE ROAD TO RUMMERLHARDT DR TO PINEROW CRES"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1948781"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-06-12T21:10:21Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T19:39:15Z"
+"Stories": "3.0"
+"StreetName": "SETTLERSFIELD"
+"StreetNumber": "629"
+"StreetSuffix": "Court"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "4025"
+"Utilities": array:1 [
0 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/629_b_settlersfield_ct_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29898161/629-settlersfield-court-unit-b-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1563914"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76807"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 24.0
+"AboveGradeFinishedArea": 829
+"BelowGradeFinishedArea": 493
+"OriginalEntryTimestamp": "2026-06-12T21:10:19.47Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1243289"
+"ListOfficeNationalAssociationId": "1380559"
+"CoListAgentNationalAssociationId": "1069671"
+"CoListOfficeNationalAssociationId": "1004370"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898161')"
+"ID": "1525564"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25225
+post_id: "1524680"
+post_author: 1
+"ListingKey": "29894553"
+"ListingId": "40829023"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T14:30:06Z"
+"RFModificationTimestamp": "2026-06-12T20:09:42Z"
+"ListPrice": 429900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1596.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5S7"
+"UnparsedAddress": "417 KEATS Way Unit# 4, Waterloo, Ontario N2L5S7"
+"Coordinates": array:2 [
0 => -80.5566627
1 => 43.4577016
]
+"Latitude": 43.4577016
+"Longitude": -80.5566627
+"YearBuilt": 1977
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Updated and spacious, this Beechwood, 3 bedroom, 2.5 bathroom townhouse offers approximately 1,600 square feet of comfortable living space in a highly desirable Waterloo location. Ideal for first-time buyers, families, or investors, the home features a bright, open living room with built-in shelving and elegant crown molding. Upstairs, you’ll find a large primary bedroom with a walk-in closet, along with two additional generously sized bedrooms. The fully finished basement adds excellent flexibility with a large, versatile rec room, full bathroom, and laundry area. Set in a quiet complex with ample visitor parking and green space, this property is conveniently located close to everyday amenities, including two grocery stores within walking distance, major bus routes, the expressway, and both universities, including walking distance to the University of Waterloo. A well-kept, move-in-ready opportunity in a convenient and sought-after location. (id:62783)"
+"AssociationFee": "612"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T20:09:38.059035+00:00"
+"Directions": "Fischer-Hallman"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564479"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-06-12T14:22:18Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T14:22:18Z"
+"Stories": "2.0"
+"StreetName": "KEATS"
+"StreetNumber": "417"
+"StreetSuffix": "Way"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3014"
+"VirtualTourURLUnbranded": "https://youriguide.com/4_417_keats_way_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29894553/417-keats-way-unit-4-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1366
+"BelowGradeFinishedArea": 230
+"OriginalEntryTimestamp": "2026-06-12T14:22:18.59Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1125580"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29894553')"
+"ID": "1524680"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25226
+post_id: "1524681"
+post_author: 1
+"ListingKey": "29895192"
+"ListingId": "X13436726"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T15:40:12Z"
+"RFModificationTimestamp": "2026-06-12T19:50:47Z"
+"ListPrice": 429900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5S7"
+"UnparsedAddress": "4 - 417 KEATS WAY, Waterloo, Ontario N2L5S7"
+"Coordinates": array:2 [
0 => -80.556684
1 => 43.457734
]
+"Latitude": 43.457734
+"Longitude": -80.556684
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Updated and spacious, this Beechwood, 3 bedroom, 2.5 bathroom townhouse offers approximately 1,600 square feet of comfortable living space in a highly desirable Waterloo location. Ideal for first-time buyers, families, or investors, the home features a bright, open living room with built-in shelving and elegant crown molding. Upstairs, you'll find a large primary bedroom with a walk-in closet, along with two additional generously sized bedrooms. The fully finished basement adds excellent flexibility with a large, versatile rec room, full bathroom, and laundry area. Set in a quiet complex with ample visitor parking and green space, this property is conveniently located close to everyday amenities, including two grocery stores within walking distance, major bus routes, the expressway, and both universities, including walking distance to the University of Waterloo. A well-kept, move-in-ready opportunity in a convenient and sought-after location. (id:62783)"
+"AssociationFee": "612"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:48:38.683182+00:00"
+"Directions": "Fischer-Hallman"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100955"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:3 [
0 => "Garage"
1 => "Carport"
2 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-12T15:30:32Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T15:30:32Z"
+"Stories": "2.0"
+"StreetName": "Keats"
+"StreetNumber": "417"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "3014"
+"VirtualTourURLUnbranded": "https://youriguide.com/4_417_keats_way_waterloo_on/"
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29895192/4-417-keats-way-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Weigel Management"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-12T15:30:32.56Z"
+"ListAgentNationalAssociationId": "1370979"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895192')"
+"ID": "1524681"
}
]
+success: true
+page_size: 9
+page_count: 14
+count: 122
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]