array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29908777 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411
+post_id: "1534852"
+post_author: 1
+"ListingKey": "29908777"
+"ListingId": "40839715"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T02:00:06Z"
+"RFModificationTimestamp": "2026-06-23T02:02:00Z"
+"ListPrice": 535000.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-23T01:51:23Z"
+"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 [
"RoomKey" => "1665793901"
"RoomType" => "Laundry room"
"ListingId" => "40839715"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 6'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T01:51:23.52Z"
]
1 => array:11 [
"RoomKey" => "1665793902"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839715"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T01:51:23.53Z"
]
2 => array:11 [
"RoomKey" => "1665793903"
"RoomType" => "Bedroom"
"ListingId" => "40839715"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T01:51:23.53Z"
]
3 => array:11 [
"RoomKey" => "1665793904"
"RoomType" => "Bedroom"
"ListingId" => "40839715"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 13'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T01:51:23.53Z"
]
4 => array:11 [
"RoomKey" => "1665793905"
"RoomType" => "Primary Bedroom"
"ListingId" => "40839715"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T01:51:23.54Z"
]
5 => array:11 [
"RoomKey" => "1665793906"
"RoomType" => "2pc Bathroom"
"ListingId" => "40839715"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T01:51:23.54Z"
]
6 => array:11 [
"RoomKey" => "1665793907"
"RoomType" => "Dining room"
"ListingId" => "40839715"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T01:51:23.55Z"
]
7 => array:11 [
"RoomKey" => "1665793908"
"RoomType" => "Kitchen"
"ListingId" => "40839715"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T01:51:23.56Z"
]
8 => array:11 [
"RoomKey" => "1665793909"
"RoomType" => "Living room"
"ListingId" => "40839715"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 21'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T01:51:23.57Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29908777_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/e8f17a8c4e11da4ac887713b925a8225.webp"
"MediaSize" => 129831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-e8f17a8c4e11da4ac887713b925a8225.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Multi-level townhome featuring light-colored siding and brick accents"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29908777_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/3b540c3e86cf2007ac5010ff7abad587.webp"
"MediaSize" => 58996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-3b540c3e86cf2007ac5010ff7abad587.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29908777_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/f3b231388ecd09abedbc2bffdbcb43fb.webp"
"MediaSize" => 63681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-f3b231388ecd09abedbc2bffdbcb43fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29908777_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/978400e537a5e36aa043858340efb3f5.webp"
"MediaSize" => 67018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-978400e537a5e36aa043858340efb3f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious open-concept living area featuring dark wood-finish flooring, recessed lighting, and a built-in console with shelving"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29908777_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/d7a602fd7110265e80707893cbaea753.webp"
"MediaSize" => 81911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-d7a602fd7110265e80707893cbaea753.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring wood-finish flooring, recessed lighting, and a sliding glass door providing access to an outdoor deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29908777_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/da9fb8d0aaff10b73fa44fb28102c1e8.webp"
"MediaSize" => 88580
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-da9fb8d0aaff10b73fa44fb28102c1e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept interior featuring light wood-finish flooring, recessed lighting, and white walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29908777_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/47f895b949c4915fd6ffc6ac90919a96.webp"
"MediaSize" => 72664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-47f895b949c4915fd6ffc6ac90919a96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring wood-finish flooring, dark wood cabinetry, light-toned countertops, and stainless steel appliances including a refrigerator and range"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29908777_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/d00831c24a778da68afa653f89f0bd06.webp"
"MediaSize" => 82084
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-d00831c24a778da68afa653f89f0bd06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring dark wood cabinetry, light countertops, a stainless steel gas range, a stainless steel dishwasher, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29908777_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/3b2ca784855785bf4dfc06be5bc7c581.webp"
"MediaSize" => 73829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-3b2ca784855785bf4dfc06be5bc7c581.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen area featuring stainless steel refrigerator, dark wood-finish cabinetry, and a light-toned countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29908777_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/5c65bd6bc3e4e0e6d33c6c68c9f36aaa.webp"
"MediaSize" => 31927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-5c65bd6bc3e4e0e6d33c6c68c9f36aaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom vanity featuring a vessel sink, single-handle faucet, dark wood-finish cabinetry, and an illuminated mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29908777_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/fd4e6f0af04f8d61da8588c097930dae.webp"
"MediaSize" => 59196
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-fd4e6f0af04f8d61da8588c097930dae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hardwood-finish flooring complementing white walls and trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29908777_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/67c675ee9b376de01850b0be3271039d.webp"
"MediaSize" => 41810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-67c675ee9b376de01850b0be3271039d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring dark wood-finish flooring, white walls, and white bi-fold closet doors with brass-tone knobs"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29908777_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/78fbea7c401a4dff750c6f6ac630c132.webp"
"MediaSize" => 52291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-78fbea7c401a4dff750c6f6ac630c132.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29908777_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/1f56c620ba8a79fa0acf672dd8119284.webp"
"MediaSize" => 50859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-1f56c620ba8a79fa0acf672dd8119284.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright room with rich wood-finish flooring, white walls, and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29908777_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/35ecce72f515c7f9506bc85d97e53b9b.webp"
"MediaSize" => 68359
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-35ecce72f515c7f9506bc85d97e53b9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hardwood flooring throughout featuring white walls, a flush-mount ceiling light, and two large multi-pane windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29908777_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/3fd97ccbcfc261d3a1208f972354ea20.webp"
"MediaSize" => 53873
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-3fd97ccbcfc261d3a1208f972354ea20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, white walls, and a large window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29908777_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/3bc4405fe373dc0f5a8f19cbcbd26603.webp"
"MediaSize" => 60732
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-3bc4405fe373dc0f5a8f19cbcbd26603.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Crisp white interior walls highlighting dark wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29908777_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/deaef44980c35d35470ff9caec409fc0.webp"
"MediaSize" => 49682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-deaef44980c35d35470ff9caec409fc0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a built-in vanity with a marbled countertop, an integrated sink with chrome fixtures, a full-width mirror, a toilet, and a bathtub with a shower head"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29908777_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/ba0838a102aa60d3daf40b08e347161f.webp"
"MediaSize" => 87454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-ba0838a102aa60d3daf40b08e347161f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Laundry area featuring a utility sink, exposed concrete wall, exposed ceiling joists, and a window for natural light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29908777_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/0f1c174e9e782dd238d09c7f52ed98f4.webp"
"MediaSize" => 181904
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-0f1c174e9e782dd238d09c7f52ed98f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Outdoor wood deck featuring a lattice privacy screen and wood railing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29908777_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/8d5d6e4f1d6f3a50c56b9b84aef3e37b.webp"
"MediaSize" => 136527
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-8d5d6e4f1d6f3a50c56b9b84aef3e37b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exterior deck featuring wood planking and a sliding glass door with a screen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29908777_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/ddcec068e0a5d5311679512efec740d7.webp"
"MediaSize" => 183261
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-ddcec068e0a5d5311679512efec740d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29908777_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/b0019e86df5e8ac601953eae776c3726.webp"
"MediaSize" => 168398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-b0019e86df5e8ac601953eae776c3726.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rear exterior featuring a wooden deck with railing, sliding glass door access, and a patio area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29908777_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/4d04fe1b9845b8a8bad1b23ca697aaac.webp"
"MediaSize" => 165046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-4d04fe1b9845b8a8bad1b23ca697aaac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious backyard featuring a large wooden deck, raised garden beds, and mature trees"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29908777_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/bf02c630ccaa930492b7eb9673693c6e.webp"
"MediaSize" => 43903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-bf02c630ccaa930492b7eb9673693c6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29908777_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/17dcb6af0c4fb3a0dd192fb381834a39.webp"
"MediaSize" => 51263
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-17dcb6af0c4fb3a0dd192fb381834a39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29908777_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/8caf517925f02ea0164e2f3fb98bf5e9.webp"
"MediaSize" => 41509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-8caf517925f02ea0164e2f3fb98bf5e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908777')"
+"ID": "1534852"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 289541" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24796
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2055634" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24883
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29908777'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25185
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29908777'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25204
+items: array:3 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25201
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31508464"
+"ListingKey": "29908777"
+"ListingId": "40839715"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-20"
+"OpenHouseStartTime": "2026-06-20T14:00:00Z"
+"OpenHouseEndTime": "2026-06-20T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-20T18:24:28Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31508464')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25203
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31508463"
+"ListingKey": "29908777"
+"ListingId": "40839715"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-21"
+"OpenHouseStartTime": "2026-06-21T14:00:00Z"
+"OpenHouseEndTime": "2026-06-21T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-20T18:24:28Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31508463')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25200
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31577299"
+"ListingKey": "29908777"
+"ListingId": "40839715"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-21"
+"OpenHouseStartTime": "2026-06-21T14:00:00Z"
+"OpenHouseEndTime": "2026-06-21T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-21T17:22:55Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31577299')"
}
]
+success: true
+page_size: 3
+page_count: 1
+count: 3
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29908777' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5870471 43.4667674)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25260
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25254
+post_id: "1556233"
+post_author: 1
+"ListingKey": "29939876"
+"ListingId": "40842165"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T02:20:06Z"
+"RFModificationTimestamp": "2026-06-23T04:41:37Z"
+"ListPrice": 149900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 700.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3Z4"
+"UnparsedAddress": "580 BEAVER CREEK Road Unit# Lot 158, Waterloo, Ontario N2J3Z4"
+"Coordinates": array:2 [
0 => -80.5851199
1 => 43.4834036
]
+"Latitude": 43.4834036
+"Longitude": -80.5851199
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
+"PublicRemarks": "Private serene setting in Green Acre Park. Located right next to beautiful forest and no rear or side neighbours. Approximately 700 sf plus 500 sf of freshly painted deck plus gazebo to enjoy a wonderful summer in a resort like park with lots of fun amenities. Newer French doors, roof furnace and AC. Nothing to do but enjoy. Tastefully decorated throughout with two bedrooms, one bathroom and an open concept kitchen dining and living room area. Lots of room to park on a dead end street. Large yard area with campfire pit and shed for storage. Park is closed January and February. Annual lease fees include use of all amenities to include heated swimming pool, playground, mini putt, fishing pond and more. Also includes water, sewer, garbage disposal, property taxes and common area maintenance. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T04:41:34.277607+00:00"
+"Directions": "Conservation Rd/Beaver Creek Rd"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "None"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1987928"
+"ListOfficeKey": "291581"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Crushed stone driveway"
1 => "Country residential"
2 => "Recreational"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-23T02:14:58Z"
+"PhotosCount": 22
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T02:14:58Z"
+"Stories": "1.0"
+"StreetName": "BEAVER CREEK"
+"StreetNumber": "580"
+"StreetSuffix": "Road"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1665803707"
"RoomType" => "3pc Bathroom"
"ListingId" => "40842165"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939876"
"RoomLength" => null
"RoomDimensions" => "8' x 5'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:14:58.07Z"
]
1 => array:11 [
"RoomKey" => "1665803708"
"RoomType" => "Bedroom"
"ListingId" => "40842165"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939876"
"RoomLength" => null
"RoomDimensions" => "5'11'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:14:58.07Z"
]
2 => array:11 [
"RoomKey" => "1665803709"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842165"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939876"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:14:58.07Z"
]
3 => array:11 [
"RoomKey" => "1665803710"
"RoomType" => "Living room"
"ListingId" => "40842165"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939876"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 14'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:14:58.08Z"
]
4 => array:11 [
"RoomKey" => "1665803711"
"RoomType" => "Eat in kitchen"
"ListingId" => "40842165"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939876"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:14:58.08Z"
]
]
+"ListAOR": "Brantford"
+"ListAORKey": "41"
+"ListingURL": "www.realtor.ca/real-estate/29939876/580-beaver-creek-road-unit-lot-158-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Modular"
]
+"CommonInterest": "Leasehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 700
+"OriginalEntryTimestamp": "2026-06-23T02:14:57.98Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1272130"
+"ListOfficeNationalAssociationId": "1400487"
+"Media": array:22 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29939876_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/41bebb5583f0848a9f156f8762fe65a6.webp"
"MediaSize" => 101865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-41bebb5583f0848a9f156f8762fe65a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29939876_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/2e4f7262ddd67c1c95213575e414b28a.webp"
"MediaSize" => 103635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-2e4f7262ddd67c1c95213575e414b28a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29939876_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/6844a3480ce4c91e70314cb465f86481.webp"
"MediaSize" => 101103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-6844a3480ce4c91e70314cb465f86481.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29939876_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/07d4fe3adf0e27ba8ecfdbb575f8dd80.webp"
"MediaSize" => 103635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-07d4fe3adf0e27ba8ecfdbb575f8dd80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29939876_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/ea3799368219881e646f005cca5837c6.webp"
"MediaSize" => 88881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-ea3799368219881e646f005cca5837c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29939876_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/021bee7972cd2eb60a7e14c38909c2c6.webp"
"MediaSize" => 97840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-021bee7972cd2eb60a7e14c38909c2c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29939876_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/59df0662a88af5d1842a1634f41dd394.webp"
"MediaSize" => 76740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-59df0662a88af5d1842a1634f41dd394.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29939876_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/08ef3c531cdae9014538e6d56ad3872c.webp"
"MediaSize" => 90113
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-08ef3c531cdae9014538e6d56ad3872c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29939876_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/eeee94ff5fe13b1cb9686bb5e8cddb6a.webp"
"MediaSize" => 84219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-eeee94ff5fe13b1cb9686bb5e8cddb6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29939876_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/d7932f797d43acb5c47324cf285253c3.webp"
"MediaSize" => 104626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-d7932f797d43acb5c47324cf285253c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29939876_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/6e05ed1714670887a0df8e860263c878.webp"
"MediaSize" => 122115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-6e05ed1714670887a0df8e860263c878.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29939876_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/61aba34eade769c25897480797a20dc4.webp"
"MediaSize" => 52329
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-61aba34eade769c25897480797a20dc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29939876_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/763db300599294291270749ea39449e7.webp"
"MediaSize" => 62817
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-763db300599294291270749ea39449e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29939876_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/79a2d09f17734c81a7610b4011ade9e8.webp"
"MediaSize" => 63803
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-79a2d09f17734c81a7610b4011ade9e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29939876_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/f23d047d6627006751f6816e741a404a.webp"
"MediaSize" => 65090
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-f23d047d6627006751f6816e741a404a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29939876_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/f6bb67718de7320a324a95016b64fbd4.webp"
"MediaSize" => 61993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-f6bb67718de7320a324a95016b64fbd4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29939876_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/dbc652ec205a2768d7cec48e6277be35.webp"
"MediaSize" => 61811
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-dbc652ec205a2768d7cec48e6277be35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29939876_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/5083652eed0e8dcb963052e54c4b4a70.webp"
"MediaSize" => 58872
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-5083652eed0e8dcb963052e54c4b4a70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29939876_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/321552b5b50dc7f6bd9d8edd35111d1e.webp"
"MediaSize" => 50949
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-321552b5b50dc7f6bd9d8edd35111d1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29939876_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/177383850602f524d297b8d7a3fe19fb.webp"
"MediaSize" => 58660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-177383850602f524d297b8d7a3fe19fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29939876_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/23f0af4be1c515a240963fd8d33d6e37.webp"
"MediaSize" => 49630
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-23f0af4be1c515a240963fd8d33d6e37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29939876_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/d3848718f005d5696c1661fd162cd8eb.webp"
"MediaSize" => 38253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-d3848718f005d5696c1661fd162cd8eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29939876')"
+"ID": "1556233"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25256
+post_id: "1553272"
+post_author: 1
+"ListingKey": "29935006"
+"ListingId": "40841536"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T12:00:24Z"
+"RFModificationTimestamp": "2026-06-22T13:42:48Z"
+"ListPrice": 949999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2240.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2J2"
+"UnparsedAddress": "479 TIMBERCROFT Crescent, Waterloo, Ontario N2T2J2"
+"Coordinates": array:2 [
0 => -80.5707503
1 => 43.4704296
]
+"Latitude": 43.4704296
+"Longitude": -80.5707503
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This beautiful 4-bedroom backsplit home is located in the highly sought-after Laurelwood neighbourhood of Waterloo, offering the perfect blend of space, comfort, and convenience in one of the city's most established and family-friendly communities. Situated on a mature, tree-lined street, this well-maintained property features a double-car garage and a brand-new double-wide asphalt driveway, providing ample parking and impressive curb appeal. The spacious backsplit layout offers multiple levels of living space, ideal for growing families, entertaining guests, or creating dedicated work-from-home areas.Step outside to your private backyard retreat, complete with a sparkling inground saltwater pool—perfect for relaxing on warm summer days and hosting family gatherings and outdoor celebrations.The home enjoys an exceptional location close to many of Waterloo's most desirable amenities. Families will appreciate being within easy reach of Laurelwood Public School and St. Nicholas Catholic Elementary School. Post-secondary institutions including University of Waterloo and Wilfrid Laurier University are just a short drive away, making this location ideal for university staff, faculty, and families with students. Nature lovers will enjoy the close proximity to Laurel Creek Conservation Area, offering scenic trails, recreational activities, and year-round outdoor enjoyment. Everyday conveniences are also nearby, with shopping, restaurants, services, and amenities just minutes from your doorstep. Combining a desirable backsplit design, outstanding outdoor living, excellent schools, nearby universities, and access to nature, this home presents a rare opportunity to live in one of Waterloo's most desirable mature neighbourhoods. Whether you're raising a family, entertaining friends, or simply enjoying the peaceful surroundings, this Laurelwood property offers a lifestyle that is both comfortable and convenient. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Hood Fan"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T13:42:38.585379+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "Electric"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2069548"
+"ListOfficeKey": "274404"
+"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-22T11:50:15Z"
+"PhotosCount": 38
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T11:50:15Z"
+"Stories": "2.0"
+"StreetName": "TIMBERCROFT"
+"StreetNumber": "479"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5727"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1665204082"
"RoomType" => "Recreation room"
"ListingId" => "40841536"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "15'2'' x 20'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.72Z"
]
1 => array:11 [
"RoomKey" => "1665204083"
"RoomType" => "Laundry room"
"ListingId" => "40841536"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 15'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.72Z"
]
2 => array:11 [
"RoomKey" => "1665204084"
"RoomType" => "Living room"
"ListingId" => "40841536"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "18'6'' x 19'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.72Z"
]
3 => array:11 [
"RoomKey" => "1665204085"
"RoomType" => "Bedroom"
"ListingId" => "40841536"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.72Z"
]
4 => array:11 [
"RoomKey" => "1665204086"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841536"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.72Z"
]
5 => array:11 [
"RoomKey" => "1665204087"
"RoomType" => "Bedroom"
"ListingId" => "40841536"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.72Z"
]
6 => array:11 [
"RoomKey" => "1665204088"
"RoomType" => "Bedroom"
"ListingId" => "40841536"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29935006"
…5
]
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/29935006/479-timbercroft-crescent-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1177
+"BelowGradeFinishedArea": 1063
+"OriginalEntryTimestamp": "2026-06-22T11:50:15.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1344717"
+"ListOfficeNationalAssociationId": "1254957"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29935006')"
+"ID": "1553272"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25253
+post_id: "1549245"
+post_author: 1
+"ListingKey": "29930561"
+"ListingId": "40841361"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-21T20:40:13Z"
+"RFModificationTimestamp": "2026-06-21T20:42:36Z"
+"ListPrice": 839900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2321.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2Z3"
+"UnparsedAddress": "570 ST MORITZ Avenue, Waterloo, Ontario N2T2Z3"
+"Coordinates": array:2 [
0 => -80.5830118
1 => 43.453361
]
+"Latitude": 43.453361
+"Longitude": -80.5830118
+"YearBuilt": 2008
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "AN ABSOLUTE GEM! Beautifully maintained home on generous lot with double garage! Inviting front entrance with large covered porch, spacious foyer with 2 pc. bathroom, open concept main floor, gorgeous kitchen with granite countertops, stainless steel appliances, & breakfast bar with 4 bar stools (included), spacious dining area with walkout to new wrap-around deck and beautiful fenced yard, and huge living room with hardwood floors & custom feature wall! The upper floor features an oversized primary bedroom with walk-in closet, fabulous ensuite bathroom with large vanity, double sinks & tiled shower with built-in bench & glass door, 2 additional good sized bedrooms, and 4 pc. main bathroom. Venture downstairs to see the professionally finished basement featuring a large rec room, 2 office areas, and a pull-down Murphy bed! Beautifully landscaped exterior with professionally maintained lawns and attractive gardens. Other features include newer carpeting on upper floor, newer roof (2022), new deck & side privacy fence (2025), new water softener (2025), and interior & exterior painting! Ideal location steps from Edna Staebler pubic school and close to Costco & Canadian Tire plaza! Don't miss out on this exceptional family home! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Range - Gas"
4 => "Dishwasher"
5 => "Dryer"
6 => "Central Vacuum - Roughed In"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"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-19T21:08:44.485878+00:00"
+"Directions": "Columbia St. W. to St. Moritz"
+"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": "1564080"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T19:51:13Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-21T20:31:45Z"
+"Stories": "2.0"
+"StreetName": "ST MORITZ"
+"StreetNumber": "570"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5944"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"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/29930561/570-st-moritz-avenue-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "FR G2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 39.0
+"AboveGradeFinishedArea": 1746
+"BelowGradeFinishedArea": 575
+"OriginalEntryTimestamp": "2026-06-19T19:51:13.63Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1070108"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930561')"
+"ID": "1549245"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25257
+post_id: "1548475"
+post_author: 1
+"ListingKey": "29928698"
+"ListingId": "40841473"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T20:40:19Z"
+"RFModificationTimestamp": "2026-06-20T20:43:00Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1992.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A3"
+"UnparsedAddress": "795 LAURELWOOD Drive Unit# C13, Waterloo, Ontario N2V0A3"
+"Coordinates": array:2 [
0 => -80.6001493
1 => 43.4708976
]
+"Latitude": 43.4708976
+"Longitude": -80.6001493
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This beautiful corner unit open bright family home offers spacious layout throughout. The Master bedroom is on the main floor with a full ensuite, ideal for older home owners or families looking for comfort. Situated on a quiet cul-de-sac with privacy surrounded by mature trees and landscaping. This unit has lots of natural lighting with soaring living room ceiling. The main floor starts with a formal living room or reading nook with a spacious powder room. The laundry/office is spacious behind the kitchen. The kitchen has stainless steel appliances, a quartz counter top, white cabinetry and an island (cabinets on both sides for more storage). The dining area flows from the kitchen with high ceilings with a 2nd floor overlook. The second floor common area is very spacious that can be converted to a 4th bedroom.Large sliding glass doors lead to the deck, cozy for reading or entertaining during summer evenings. Few minutes walking distance to highly rated Abraham Erb public school and Laurel Heights Secondary school, Food basics and Shoppers drug mart. Within 7 min drive to University of Waterloo, Costco, YMCA, and The Boardwalk. Enjoy worry-free living with lawn maintenance and snow removal (including your driveway and steps to the entry). Recent upgrades include a furnace, A/C, sump pump, flooring, smart lighting, and pot lights.Enjoy easy access to numerous year-round walking trails throughout the neighbourhood.Whether you're downsizing or raising a growing family, this exceptional home offers the perfect blend of comfort, convenience, and lifestyle. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"AssociationFee": "314"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T19:50:55.275414+00:00"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2141441"
+"ListOfficeKey": "300100"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-19T16:32:43Z"
+"PhotosCount": 39
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T20:31:17Z"
+"Stories": "2.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "795"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "4864"
+"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/29928698/795-laurelwood-drive-unit-c13-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "Md-3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1992
+"OriginalEntryTimestamp": "2026-06-19T16:32:42.81Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1393129"
+"ListOfficeNationalAssociationId": "1482864"
+"Media": array:39 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29928698')"
+"ID": "1548475"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25255
+post_id: "1546922"
+post_author: 1
+"ListingKey": "29926813"
+"ListingId": "X13465286"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-21T12:30:32Z"
+"RFModificationTimestamp": "2026-06-21T12:32:09Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A3"
+"UnparsedAddress": "13 - 795 LAURELWOOD DRIVE, Waterloo, Ontario N2V0A3"
+"Coordinates": array:2 [
0 => -80.600804
1 => 43.471001
]
+"Latitude": 43.471001
+"Longitude": -80.600804
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This beautiful corner unit open bright family home offers spacious layout throughout. The Master bedroom is on the main floor with a full ensuite, ideal for older home owners or families looking for comfort. Situated on a quiet cul-de-sac with privacy surrounded by mature trees and landscaping. This unit has lots of natural lighting with soaring living room ceiling. The main floor starts with a formal living room or reading nook with a spacious powder room. The laundry/office is spacious behind the kitchen. The kitchen has stainless steel appliances, a quartz counter top, white cabinetry and an island (cabinets on both sides for more storage). The dining area flows from the kitchen with high ceilings with a 2nd floor overlook. The second floor common area is very spacious that can be converted to a 4th bedroom.Large sliding glass doors lead to the deck, cozy for reading or entertaining during summer evenings. Few minutes walking distance to highly rated Abraham Erb public school and Laurel Heights Secondary school, Food basics and Shoppers drug mart. Within 7 min drive to University of Waterloo, Costco, YMCA, and The Boardwalk. Enjoy worry-free living with lawn maintenance and snow removal (including your driveway and steps to the entry). Recent upgrades include a furnace, A/C, sump pump, flooring, smart lighting, and pot lights.Enjoy easy access to numerous year-round walking trails throughout the neighbourhood.Whether you're downsizing or raising a growing family, this exceptional home offers the perfect blend of comfort, convenience, and lifestyle. (id:62783)"
+"Appliances": array:11 [
0 => "Refrigerator"
1 => "Water purifier"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"AssociationFee": "314"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T06:49:35.931020+00:00"
+"Directions": "Cross Streets: Erbsville Road / Laurelwood Drive. ** Directions: Erbsville Rd/Laurelwood drive."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2245275"
+"ListOfficeKey": "299835"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T04:42:01Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-21T12:23:57Z"
+"Stories": "2.0"
+"StreetName": "Laurelwood"
+"StreetNumber": "795"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4864"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29926813/13-795-laurelwood-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Self-managed"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1999
+"LivingAreaMinimum": 1800
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-19T04:42:01.07Z"
+"ListAgentNationalAssociationId": "1484041"
+"ListOfficeNationalAssociationId": "1477585"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29926813')"
+"ID": "1546922"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25250
+post_id: "1544041"
+post_author: 1
+"ListingKey": "29922564"
+"ListingId": "X13461546"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T19:10:09Z"
+"RFModificationTimestamp": "2026-06-18T19:13:19Z"
+"ListPrice": 999990.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B4"
+"UnparsedAddress": "274 BUTTONBUSH STREET, Waterloo, Ontario N2V0B4"
+"Coordinates": array:2 [
0 => -80.590313
1 => 43.451104
]
+"Latitude": 43.451104
+"Longitude": -80.590313
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This Is The Opportunity Buyers Have Been Waiting For. A Detached 4+1 Bedroom, 4 Bathroom Home With Over 3,000 Sq Ft Of Finished Living Space, Double Garage, Finished Basement With Separate Entrance, And Immediate Vacant Possession - All In One Of Waterloo's Most Sought-After School Communities. Located In The Highly Desired Vista Hills Neighbourhood, Known For Top-Ranked Schools, Parks, Trails, And Family-Friendly Living, This Home Delivers The Space, Location, And Flexibility That Are Almost Impossible To Replace At This Price Point. The Main Floor Offers A Bright Open-Concept Layout With Hardwood Floors, Pot Lights, Large Windows, And A Chef-Inspired Kitchen Featuring Quartz Counters, Stainless Steel Appliances, And An Oversized Centre Island. Upstairs Features A Spacious Primary Retreat With Walk-In Closet And Ensuite, Plus Generous Bedrooms - Including A Rare Jr. Primary-Style Bedroom Ideal For Older Children, Guests, Extended Family, Or A Private Home Office. The Finished Lower Level Adds Major Value With A Full Bedroom, 3-Piece Bath, Large Rec Room, Separate Entrance, And Excellent In-Law Suite Or Income Potential. Vacant, Easy To Show, And Ready For Immediate Closing. If You Have Been Waiting For The Right Waterloo Family Home At The Right Price - This Is It. A Home With This Much Space, In This School District, At This Price Point, Should Not Be Missed! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T18:59:58.572140+00:00"
+"Directions": "Columbia St W and Ladyslipper Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1976739"
+"ListOfficeKey": "238732"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "In-Law Suite"
]
+"LotSizeDimensions": "34.1 x 98.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T19:00:22Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T19:00:21Z"
+"Stories": "2.5"
+"StreetName": "Buttonbush"
+"StreetNumber": "274"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6513.55"
+"VirtualTourURLUnbranded": "https://sites.happyhousegta.com/274buttonbushstreet"
+"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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29922564/274-buttonbush-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 34.1
+"OriginalEntryTimestamp": "2026-06-18T16:44:37.31Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1263079"
+"ListOfficeNationalAssociationId": "1200762"
+"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('29922564')"
+"ID": "1544041"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1543514"
+post_author: 1
+"ListingKey": "29921932"
+"ListingId": "40841103"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T16:20:06Z"
+"RFModificationTimestamp": "2026-06-18T17:34:50Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1638.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2P7"
+"UnparsedAddress": "350 ERBSVILLE Road Unit# 13, Waterloo, Ontario N2T2P7"
+"Coordinates": array:2 [
0 => -80.5787185
1 => 43.4610221
]
+"Latitude": 43.4610221
+"Longitude": -80.5787185
+"YearBuilt": 1994
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 350 Erbsville Rd #13, Waterloo! Ideally located in a highly desirable neighbourhood with convenient access to the universities, Tech Park, YMCA, shopping centres, transit, and numerous amenities. This well-maintained home offers excellent potential for first-time buyers, investors, or parents seeking housing for university students. Main floor features a functional layout with a walkout from the living room to a private deck and spacious backyard—perfect for relaxing or entertaining. The finished basement adds valuable living space, complete with a large recreation room featuring good-sized windows, laminate flooring, and a 3-piece bathroom. this home presents a fantastic opportunity to build equity and create a comfortable living space in one of Waterloo’s most sought-after locations. Don't miss this affordable entry into the Waterloo market! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "230"
+"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-18T17:34:37.381920+00:00"
+"Directions": "olumbia Street W/ Erbsville Road"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1834644"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-18T16:11:13Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T16:11:13Z"
+"Stories": "2.0"
+"StreetName": "ERBSVILLE"
+"StreetNumber": "350"
+"StreetSuffix": "Road"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "3652"
+"View": "City view"
+"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/29921932/350-erbsville-road-unit-13-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD-3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1223
+"BelowGradeFinishedArea": 415
+"OriginalEntryTimestamp": "2026-06-18T15:51:28.04Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1196787"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:23 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921932')"
+"ID": "1543514"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25258
+post_id: "1542528"
+post_author: 1
+"ListingKey": "29920639"
+"ListingId": "40839251"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-21T20:40:11Z"
+"RFModificationTimestamp": "2026-06-21T20:42:47Z"
+"ListPrice": 1270000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3505.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0H9"
+"UnparsedAddress": "350 CANADA PLUM Street, Waterloo, Ontario N2V0H9"
+"Coordinates": array:2 [
0 => -80.5983757
1 => 43.4579421
]
+"Latitude": 43.4579421
+"Longitude": -80.5983757
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Better Than New – 2025 Built Home in Prestigious Vista Hills! Nestled in one of Waterloo’s most desirable communities and located within the highly acclaimed Laurel Heights Secondary School boundary, this stunning 4-bedroom family home offers over 3,500 sq. ft. of beautifully finished living space. Enjoy exceptional convenience with easy access to Costco, The Boardwalk, restaurants, parks, and transit. The thoughtfully designed main floor features 9-foot ceilings, engineered hardwood flooring in the great room, elegant pot lighting throughout, and a spacious open-concept layout perfect for modern living. The upgraded chef’s kitchen showcases quartz countertops, a large centre island with breakfast bar, premium cabinetry, and stainless steel appliances. A convenient main-floor laundry and mudroom adds everyday functionality. Upstairs, you’ll find four generously sized bedrooms, including a luxurious primary retreat complete with a walk-in closet and a versatile sitting area ideal for a home office, reading nook, or entertainment space. The professionally finished walk-out basement, completed by the builder, includes a full bathroom and offers outstanding potential for a future legal secondary suite or in-law setup, subject to municipal approvals—an excellent opportunity for additional rental income. Step outside and enjoy direct access to the scenic Vista Hills trail system, perfect for walking, cycling, and year-round outdoor enjoyment. Surrounded by playgrounds, greenspace, and the city’s largest forest park, this family-friendly neighbourhood offers the perfect blend of nature and convenience. The rear deck featuring elegant glass railings, creating the perfect outdoor space for relaxing or entertaining. A rare opportunity to own a move-in-ready, better-than-new home in one of Waterloo’s most sought-after communities. Don't miss it! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CreationDate": "2026-06-18T14:25:22.085552+00:00"
+"Directions": "Sundew Drive and Mayapple Street"
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Brick"
2 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2050676"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T12:51:04Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-21T20:32:36Z"
+"Stories": "2.0"
+"StreetName": "CANADA PLUM"
+"StreetNumber": "350"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "7782"
+"VirtualTourURLUnbranded": "https://youriguide.com/350_canada_plum_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29920639/350-canada-plum-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2475
+"BelowGradeFinishedArea": 1030
+"OriginalEntryTimestamp": "2026-06-18T12:51:03.89Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1325963"
+"ListOfficeNationalAssociationId": "1452740"
+"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('29920639')"
+"ID": "1542528"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25259
+post_id: "1542297"
+post_author: 1
+"ListingKey": "29920234"
+"ListingId": "40840985"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T20:40:17Z"
+"RFModificationTimestamp": "2026-06-20T20:43:25Z"
+"ListPrice": 1399000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3965.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T0B3"
+"UnparsedAddress": "505 ST MORITZ Avenue, Waterloo, Ontario N2T0B3"
+"Coordinates": array:2 [
0 => -80.5797441
1 => 43.4507512
]
+"Latitude": 43.4507512
+"Longitude": -80.5797441
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this exceptional custom-built two-storey residence nestled in the highly sought-after Clair Hills community. This stunning home offers over three levels of beautifully finished living space, featuring 3+2 bedrooms and 3.5 bathrooms. Meticulously maintained and extensively upgraded over the last three years, the home showcases a beautifully renovated chef-inspired kitchen and a luxurious primary ensuite, along with numerous high-quality improvements throughout. The sophisticated open-concept layout is ideal for both everyday living and entertaining, while the expansive walk-in pantry provides exceptional storage and convenience. The inviting family room is anchored by a striking custom stone fireplace and enhanced by a premium built-in audio system throughout the home. Sliding doors lead to a spacious deck overlooking a private, resort-style backyard oasis complete with a sparkling inground pool, creating the perfect setting for summer enjoyment and outdoor entertaining. Fronting onto St. Moritz Park, the property enjoys exceptional privacy with no rear neighbours, offering a serene, countryside-like setting rarely found within the city. Surrounded by mature greenery and tranquil views, the backyard provides a peaceful retreat that feels miles away from urban living. A functional mudroom with direct garage access adds practicality, while the professionally finished lower level offers additional living space, two bedrooms, full bathroom, and a walk-up to the backyard, providing excellent flexibility for guests, extended family, or recreation. Ideally situated within walking distance to top-rated schools, parks, scenic trails, and everyday amenities, and just minutes from Highways 7 / 8, this remarkable property seamlessly blends luxury, comfort, and convenience in one of Waterloo's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Gas stove(s)"
5 => "Range - Gas"
6 => "Dishwasher"
7 => "Wine Fridge"
8 => "Dryer"
9 => "Central Vacuum - Roughed In"
10 => "Hood Fan"
11 => "Window Coverings"
12 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T05:21:24.245183+00:00"
+"Directions": "Columbia Road/St.Moritz Avenue"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1905477"
+"ListOfficeKey": "296136"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
2 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-20T12:10:13Z"
+"PhotosCount": 41
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T20:31:29Z"
+"Stories": "2.0"
+"StreetName": "ST MORITZ"
+"StreetNumber": "505"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "8727"
+"VirtualTourURLUnbranded": "https://youriguide.com/505_st_moritz_ave_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29920234/505-st-moritz-avenue-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2039305"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "296136"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "FR G2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 31.0
+"AboveGradeFinishedArea": 2787
+"BelowGradeFinishedArea": 1178
+"OriginalEntryTimestamp": "2026-06-18T04:19:36.99Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1219577"
+"ListOfficeNationalAssociationId": "1454937"
+"CoListAgentNationalAssociationId": "1315396"
+"CoListOfficeNationalAssociationId": "1454937"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29920234')"
+"ID": "1542297"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 110
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]