array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29193727/Property?$select=ALL&$top=20&$filter=ListingKey eq 29193727&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29193727/Property?$select=ALL&$top=20&$filter=ListingKey eq 29193727&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23509
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23511
+post_id: "488483"
+post_author: 1
+"ListingKey": "29193727"
+"ListingId": "40794431"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-18T19:40:17Z"
+"RFModificationTimestamp": "2025-12-18T19:45:08Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2701.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P3"
+"UnparsedAddress": "723 BLACK CHERRY Street, Waterloo, Ontario N2V2P3"
+"Coordinates": array:2 [
0 => -80.5913978
1 => 43.4637546
]
+"Latitude": 43.4637546
+"Longitude": -80.5913978
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "NO HOLDING OFFER(S). MOVE-IN READY! Over 2,700 sq ft of beautifully updated living space, this 4 beds & 4 baths single detached home in Columbia Forest / Clair Hills welcomes you to come view its inviting layout. Bright spacious rooms and entertaining potential! Enter through the large foyer to find main floor laundry and gorgeous open concept main level. The kitchen features stainless steel appliances, granite countertops with breakfast bar and plenty of cabinet space. The dining room with double french doors to the back deck is a perfect place to gather with family. On the 2nd floor, you will take in the immense master bedroom complete with jacuzzi ensuite and walk-in closet, and two additional bedrooms plus a 4pc main bathroom. The basement is finished with a 4th bedroom, a large rec-room and a 4th bathroom. Also here is a bonus kitchenette with some storage space. Enjoy the beautiful backyard, perfect for BBQ and dining under the pergola. Outdoor living enjoyed in a fully fenced yard is a summer retreat. Recent Update: New vinyl flooring and baseboards on main and 2nd floors (2025). New paint throughout including walls, doors and windows (2025). New bathroom tiles and lights (2025). New dining room light fixtures and new kitchen potlights (2025). Newly installed staircase carpet and light fixture (2025). Updated basement bathroom and kitchenette. Enjoy the beautiful backyard, perfect for BBQ and dining under the pergola. Outdoor living enjoyed in a fully fenced yard is a summer retreat. This home is located close to schools, playgrounds, bus route(s) and shopping. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-18T17:05:11.476909+00:00"
+"Directions": "Columbia Forest Blvd to Black Cherry St"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1970409"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-18T15:08:28Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-18T19:29:28Z"
+"Stories": "2.0"
+"StreetName": "BLACK CHERRY"
+"StreetNumber": "723"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5220"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/723-Black-Cherry-St"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1550949440"
"RoomType" => "Other"
"ListingId" => "40794431"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29193727"
"RoomLength" => null
"RoomDimensions" => "19'0'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T19:29:28.39Z"
]
1 => array:11 [
"RoomKey" => "1550949441"
"RoomType" => "Bedroom"
"ListingId" => "40794431"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29193727"
"RoomLength" => null
"RoomDimensions" => "15'3'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T19:29:28.4Z"
]
2 => array:11 [
"RoomKey" => "1550949442"
"RoomType" => "3pc Bathroom"
"ListingId" => "40794431"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29193727"
"RoomLength" => null
"RoomDimensions" => "5'6'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T19:29:28.4Z"
]
3 => array:11 [
"RoomKey" => "1550949443"
"RoomType" => "Recreation room"
"ListingId" => "40794431"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29193727"
"RoomLength" => null
"RoomDimensions" => "21'2'' x 12'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T19:29:28.4Z"
]
4 => array:11 [
"RoomKey" => "1550949444"
"RoomType" => "Bedroom"
"ListingId" => "40794431"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29193727"
"RoomLength" => null
"RoomDimensions" => "14'6'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T19:29:28.4Z"
]
5 => array:11 [
"RoomKey" => "1550949445"
"RoomType" => "Full bathroom"
"ListingId" => "40794431"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29193727"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 8'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T19:29:28.4Z"
]
6 => array:11 [
"RoomKey" => "1550949446"
"RoomType" => "Primary Bedroom"
"ListingId" => "40794431"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29193727"
"RoomLength" => null
"RoomDimensions" => "18'1'' x 14'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T19:29:28.4Z"
]
7 => array:11 [
"RoomKey" => "1550949447"
"RoomType" => "4pc Bathroom"
"ListingId" => "40794431"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29193727"
"RoomLength" => null
"RoomDimensions" => "8' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T19:29:28.4Z"
]
8 => array:11 [
"RoomKey" => "1550949448"
"RoomType" => "Bedroom"
"ListingId" => "40794431"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29193727"
"RoomLength" => null
"RoomDimensions" => "14'3'' x 12'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T19:29:28.4Z"
]
9 => array:11 [
"RoomKey" => "1550949449"
"RoomType" => "Laundry room"
"ListingId" => "40794431"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29193727"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 6'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T19:29:28.4Z"
]
10 => array:11 [
"RoomKey" => "1550949450"
"RoomType" => "2pc Bathroom"
"ListingId" => "40794431"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29193727"
"RoomLength" => null
"RoomDimensions" => "5'5'' x 6'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T19:29:28.4Z"
]
11 => array:11 [
"RoomKey" => "1550949451"
"RoomType" => "Living room"
"ListingId" => "40794431"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29193727"
"RoomLength" => null
"RoomDimensions" => "26'1'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T19:29:28.4Z"
]
12 => array:11 [
"RoomKey" => "1550949452"
"RoomType" => "Dining room"
"ListingId" => "40794431"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29193727"
"RoomLength" => null
"RoomDimensions" => "12'8'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T19:29:28.41Z"
]
13 => array:11 [
"RoomKey" => "1550949453"
"RoomType" => "Kitchen"
"ListingId" => "40794431"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29193727"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T19:29:28.41Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29193727/723-black-cherry-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1894
+"BelowGradeFinishedArea": 807
+"OriginalEntryTimestamp": "2025-12-18T15:08:28.58Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"Media": array:43 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6374570761"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/9833e157fb2a5b9390503e7001cacee1.webp"
"MediaSize" => 59192
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-9833e157fb2a5b9390503e7001cacee1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with appliances with stainless steel finishes, light wood finished floors, dark stone counters, decorative light fixtures, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6374570869"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/4eec3ab6c6d6ce13637391949f3ff566.webp"
"MediaSize" => 60910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-4eec3ab6c6d6ce13637391949f3ff566.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area with light wood finished floors and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6374570972"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/c43944f5c0d3e090050096ce6007c546.webp"
"MediaSize" => 53282
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-c43944f5c0d3e090050096ce6007c546.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with vanity and wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6374570982"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/cd180c96c47342985fd72028861a4c55.webp"
"MediaSize" => 56851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-cd180c96c47342985fd72028861a4c55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring a spacious closet, light wood-type flooring, and ensuite bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6374571136"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/d7f44a15bc769a43c7c64095b23f15fb.webp"
"MediaSize" => 139816
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-d7f44a15bc769a43c7c64095b23f15fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front of home with a porch, driveway, an attached garage, roof with shingles, and brick siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6374571215"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/f4d1e60a1a7af1258a65fa3f60a06aed.webp"
"MediaSize" => 120597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-f4d1e60a1a7af1258a65fa3f60a06aed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entrance to property featuring brick siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6374571388"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/5a19a4f4c9ae1f56a4b964df2057aef1.webp"
"MediaSize" => 64937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-5a19a4f4c9ae1f56a4b964df2057aef1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring light wood-style flooring, hanging light fixtures, recessed lighting, and dark stone counters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6374571532"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/e0b69614383b98329af13f1ab2d101ea.webp"
"MediaSize" => 64821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-e0b69614383b98329af13f1ab2d101ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished living room featuring recessed lighting and light wood-style floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6374571606"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/142067c673aeea7ab150019f9c4c021a.webp"
"MediaSize" => 57590
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-142067c673aeea7ab150019f9c4c021a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light wood-style flooring and ensuite bath"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6374571742"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/9bc3f8c1f5f0e1005a9f397eacfa561a.webp"
"MediaSize" => 49908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-9bc3f8c1f5f0e1005a9f397eacfa561a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with a shower stall, a whirlpool tub, and vanity"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6374571839"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/4833babbd290d1688d59bc92098a3c00.webp"
"MediaSize" => 59859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-4833babbd290d1688d59bc92098a3c00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office space with plenty of natural light, light wood-style flooring, and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6374571885"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/8c36309bc890e38e9e48c2de8c04c81e.webp"
"MediaSize" => 154892
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-8c36309bc890e38e9e48c2de8c04c81e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front of home featuring asphalt driveway, covered porch, a garage, and brick siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6374572033"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/1821a94ed91f46968beffd18a5549557.webp"
"MediaSize" => 41823
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-1821a94ed91f46968beffd18a5549557.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light wood-type flooring, a closet, and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6374572128"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/bbfb64c02ca6912827893502dde53dff.webp"
"MediaSize" => 65554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-bbfb64c02ca6912827893502dde53dff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring vanity, light tile patterned floors, and a shower"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6374572198"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/8b902b48f6c25393c1060df612af5b9c.webp"
"MediaSize" => 69736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-8b902b48f6c25393c1060df612af5b9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Finished basement featuring stairway and light colored carpet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6374572253"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/3f11f1a7edaa8dd8d971b07afff82f26.webp"
"MediaSize" => 46520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-3f11f1a7edaa8dd8d971b07afff82f26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bath with a marble finish shower, vanity, and light tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6374572356"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/05324e823123218eb486c985762cff45.webp"
"MediaSize" => 65943
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-05324e823123218eb486c985762cff45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entrance foyer with light wood-type flooring and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6374572476"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/dc2671faf01e416f0e08b30987aa49a3.webp"
"MediaSize" => 76006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-dc2671faf01e416f0e08b30987aa49a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with stainless steel appliances, decorative light fixtures, light wood-style flooring, dark stone counters, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6374572517"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/11b1532a923199ca8a8054ee8ca0edd7.webp"
"MediaSize" => 71092
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-11b1532a923199ca8a8054ee8ca0edd7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with a peninsula, stainless steel appliances, light wood-style floors, decorative light fixtures, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6374572634"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/6c71a56f12ad9845338b7f46cb2769f4.webp"
"MediaSize" => 46717
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-6c71a56f12ad9845338b7f46cb2769f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with open shelves, light countertops, white cabinetry, light wood-type flooring, and stainless steel dishwasher"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6374572712"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/93ec5241a732319828499d9246237f02.webp"
"MediaSize" => 176309
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-93ec5241a732319828499d9246237f02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fenced backyard with outdoor dining space, a wooden deck, and a pergola"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6374572791"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/cd54a822dc5f80f2f1c20bca4548be66.webp"
"MediaSize" => 18948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-cd54a822dc5f80f2f1c20bca4548be66.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of property floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6374572830"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/a7220a19e45cbf3b7139750c36fcce06.webp"
"MediaSize" => 61981
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-a7220a19e45cbf3b7139750c36fcce06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring pendant lighting, dishwasher, light wood-style flooring, recessed lighting, and dark stone counters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6374572930"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/56dc37ae3a71c9b9aac0655fe9eda965.webp"
"MediaSize" => 70837
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-56dc37ae3a71c9b9aac0655fe9eda965.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining room featuring light wood-style floors, french doors, and a chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6374572951"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/91d01b48766becb33025620f0a4bf229.webp"
"MediaSize" => 63680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-91d01b48766becb33025620f0a4bf229.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room with stairway, recessed lighting, and light wood-style floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6374573056"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/996c26c7073474f00c343555a1bc083a.webp"
"MediaSize" => 148075
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-996c26c7073474f00c343555a1bc083a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fenced backyard with a pergola, outdoor dining space, a patio, and area for grilling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6374573085"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/56e1d651e45f47c060101b81e515bff9.webp"
"MediaSize" => 23784
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-56e1d651e45f47c060101b81e515bff9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of home floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6374573166"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/cb8146a1ec5443eecec74c6d45dc6763.webp"
"MediaSize" => 43026
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-cb8146a1ec5443eecec74c6d45dc6763.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with light wood-type flooring and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6374573251"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/228992ba1d774f30b2a1e07c99e15764.webp"
"MediaSize" => 51875
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-228992ba1d774f30b2a1e07c99e15764.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with open shelves, white cabinetry, light countertops, and light wood-style floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6374573318"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/158fd2a0bf16fd6596eed55d18c2dd4e.webp"
"MediaSize" => 140292
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-158fd2a0bf16fd6596eed55d18c2dd4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Wooden deck featuring area for grilling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6374573391"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/189ee94a27d1c502a42f600c4e215c99.webp"
"MediaSize" => 149783
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-189ee94a27d1c502a42f600c4e215c99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rear view of property with a fenced backyard, a wooden deck, french doors, and a pergola"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6374573396"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/e738632127257ef32fd81112491e82ba.webp"
"MediaSize" => 56159
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-e738632127257ef32fd81112491e82ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with vanity, a bath, light tile patterned floors, and a stall shower"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6374573433"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/df153333cd2d6019391dc4ffde565136.webp"
"MediaSize" => 17884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-df153333cd2d6019391dc4ffde565136.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of home floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6374573491"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/04846bdd5bb919663d2176d1ea12e9c5.webp"
"MediaSize" => 149854
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-04846bdd5bb919663d2176d1ea12e9c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front of property featuring covered porch, driveway, brick siding, a garage, and a shingled roof"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6374573528"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/17ae96b577337e32d1a4e0aa21d3d335.webp"
"MediaSize" => 129090
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-17ae96b577337e32d1a4e0aa21d3d335.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entrance to property featuring covered porch, brick siding, and a garage"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6374573545"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/b8623f8544aa753db59e37b967ad8a78.webp"
"MediaSize" => 51208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-b8623f8544aa753db59e37b967ad8a78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hall featuring light wood-style floors and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6374573582"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/671b2174dea2e1a62d2e5f6b1d3fc220.webp"
"MediaSize" => 63485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-671b2174dea2e1a62d2e5f6b1d3fc220.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with vanity, light tile patterned flooring, and a shower"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6374573601"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/ec21a6173163ec9230dc1da39aa29e36.webp"
"MediaSize" => 62411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-ec21a6173163ec9230dc1da39aa29e36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light wood-type flooring and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6374573620"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/9baa798c5aa58bd0b37069192495a69e.webp"
"MediaSize" => 58418
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-9baa798c5aa58bd0b37069192495a69e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Half bath with vanity and toilet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6374573629"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/6fb9fe9de78412764c1eae3869356399.webp"
"MediaSize" => 145818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-6fb9fe9de78412764c1eae3869356399.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Wooden terrace with a fenced backyard, grilling area, and a pergola"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6374573635"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/22d2a4de4361c495763fc618ed653cd6.webp"
"MediaSize" => 51527
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-22d2a4de4361c495763fc618ed653cd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light wood-style floors and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6374573650"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/cb4e378b453752267e65b21444fe0263.webp"
"MediaSize" => 59675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-cb4e378b453752267e65b21444fe0263.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office space with a textured ceiling and light wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
42 => array:13 [
"Order" => 42
"MediaKey" => "6374573661"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193727/d9102d885146e95b2b6a61657ac541a8.webp"
"MediaSize" => 73460
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193727/thumbnail-d9102d885146e95b2b6a61657ac541a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement featuring carpet and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794431"
"ResourceRecordKey" => "29193727"
"ModificationTimestamp" => "2025-12-18T15:08:28.59Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "DON XIA"
"MemberFirstName" => "DON"
"MemberLastName" => "XIA"
"MemberMlsId" => "KWkw8015"
"OriginatingSystemName" => 26
"MemberKey" => "1970409"
"ModificationTimestamp" => "2025-12-11T01:32:02Z"
"MemberStatus" => "Active"
"OfficeKey" => "295659"
"MemberAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberFax" => "905-707-0288"
"MemberCity" => "Waterloo"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "519-591-6888"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2014-02-19T13:08:00Z"
"MemberNationalAssociationId" => "1257707"
"OfficeNationalAssociationId" => "1452740"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "Royal LePage Peaceland Realty"
"OfficePhone" => "226-666-9766"
"OfficeMlsId" => "WR50789"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "295659"
"ModificationTimestamp" => "2025-08-19T15:49:32Z"
"OfficeAddress1" => "279 Weber St. N. Unit 20A"
"OfficeCity" => "Waterloo"
"OfficePostalCode" => "N2J3H"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"OfficeFax" => "905-707-0288"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2023-11-09T14:28:00Z"
"OfficeNationalAssociationId" => "1452740"
"FranchiseNationalAssociationId" => "1146708"
"OfficeBrokerNationalAssociationId" => "1452745"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29193727')"
+"ID": "488483"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 295659/Office?$select=ALL&$top=10&$filter=OfficeKey eq 295659&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 295659/Office?$select=ALL&$top=10&$filter=OfficeKey eq 295659&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25361
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25363
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage Peaceland Realty"
+"OfficeEmail": null
+"OfficePhone": "226-666-9766"
+"OfficeMlsId": "WR50789"
+"ModificationTimestamp": "2025-08-19T15:49:32Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "295659"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "279 Weber St. N. Unit 20A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Waterloo"
+"OfficePostalCode": "N2J3H"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1452740"
+"OriginalEntryTimestamp": "2023-11-09T14:28:00Z"
+"OfficeFax": "905-707-0288"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "335094"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "295659"
"SocialMediaUrlOrId" => "http://www.peacelandrealty.com/"
"ModificationTimestamp" => "2025-08-19T15:26:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1452745"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('295659')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1970409/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1970409&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1970409/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1970409&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25366
+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 29193727" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24988
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29193727/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29193727&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29193727/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29193727&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24968
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29193727 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5913978 43.4637546)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29193727 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5913978 43.4637546)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29193727 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5913978 43.4637546)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29193727 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5913978 43.4637546)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24916
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24909
+post_id: "488391"
+post_author: 1
+"ListingKey": "29193810"
+"ListingId": "40794447"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-18T15:45:37Z"
+"RFModificationTimestamp": "2025-12-18T16:53:44Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2013.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V3"
+"UnparsedAddress": "675 KARLSFELD Road, Waterloo, Ontario N2T2V3"
+"Coordinates": array:2 [
0 => -80.5789594
1 => 43.4577531
]
+"Latitude": 43.4577531
+"Longitude": -80.5789594
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Your Next Home Awaits in Waterloo’s Clair Hills! Move into this beautifully renovated 3-bedroom, 3-bath detached home, perfectly located in one of Waterloo’s most sought-after and family-friendly neighbourhoods. Enjoy a bright and welcoming layout with fresh paint throughout, hardwood flooring on the main level, and a modern kitchen featuring quartz countertops, plenty of cabinetry, new stainless steel appliances, and a water filtration system. The dining area opens to a private backyard — a perfect space to unwind or entertain. Upstairs, you’ll find three spacious bedrooms, including a primary suite with soaring cathedral ceilings and an ensuite bathroom. The finished basement adds extra living space, ideal for a family room or home office. Plus, a brand-new laundry set makes everyday living effortless. This home also includes a single-car garage, double driveway parking, and a northeast-facing front that fills the home with natural light. Located just minutes from top-rated schools, the University of Waterloo, Wilfred Laurier University, Costco, The Boardwalk Shopping Centre, grocery stores, restaurants, parks, and scenic trails — everything you need is right at your doorstep. Don’t miss this opportunity to live in one of Waterloo’s most desirable communities! Perfect for families or professionals seeking comfort, convenience, and style. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-18T16:53:35.936941+00:00"
+"Directions": "Brandenburg to Karlsfeld"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981149"
+"ListOfficeKey": "135429"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-18T15:38:15Z"
+"PhotosCount": 20
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-18T15:38:15Z"
+"Stories": "2.0"
+"StreetName": "KARLSFELD"
+"StreetNumber": "675"
+"StreetSuffix": "Road"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1550839814"
"RoomType" => "Laundry room"
"ListingId" => "40794447"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29193810"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T15:38:15.52Z"
]
1 => array:11 [
"RoomKey" => "1550839815"
"RoomType" => "Recreation room"
"ListingId" => "40794447"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29193810"
"RoomLength" => null
"RoomDimensions" => "20'0'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T15:38:15.52Z"
]
2 => array:11 [
"RoomKey" => "1550839816"
"RoomType" => "4pc Bathroom"
"ListingId" => "40794447"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29193810"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T15:38:15.52Z"
]
3 => array:11 [
"RoomKey" => "1550839817"
"RoomType" => "Bedroom"
"ListingId" => "40794447"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29193810"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T15:38:15.52Z"
]
4 => array:11 [
"RoomKey" => "1550839818"
"RoomType" => "Bedroom"
"ListingId" => "40794447"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29193810"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T15:38:15.52Z"
]
5 => array:11 [
"RoomKey" => "1550839819"
"RoomType" => "Full bathroom"
"ListingId" => "40794447"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29193810"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T15:38:15.52Z"
]
6 => array:11 [
"RoomKey" => "1550839820"
"RoomType" => "Primary Bedroom"
"ListingId" => "40794447"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29193810"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 15'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T15:38:15.53Z"
]
7 => array:11 [
"RoomKey" => "1550839821"
"RoomType" => "2pc Bathroom"
"ListingId" => "40794447"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29193810"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T15:38:15.53Z"
]
8 => array:11 [
"RoomKey" => "1550839822"
"RoomType" => "Living room"
"ListingId" => "40794447"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29193810"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 16'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T15:38:15.53Z"
]
9 => array:11 [
"RoomKey" => "1550839823"
"RoomType" => "Kitchen"
"ListingId" => "40794447"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29193810"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T15:38:15.53Z"
]
10 => array:11 [
"RoomKey" => "1550839824"
"RoomType" => "Dining room"
"ListingId" => "40794447"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29193810"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 8'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-18T15:38:15.53Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29193810/675-karlsfeld-road-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2990
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1350
+"BelowGradeFinishedArea": 663
+"OriginalEntryTimestamp": "2025-12-18T15:38:15.35Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"Media": array:20 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6374612790"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193810/538cb9a9cc7d1f3d744228c9333ff068.webp"
"MediaSize" => 122085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193810/thumbnail-538cb9a9cc7d1f3d744228c9333ff068.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794447"
"ResourceRecordKey" => "29193810"
"ModificationTimestamp" => "2025-12-18T15:38:15.36Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6374612806"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193810/784b8a0f0a612dc232dbd1da80ebc93e.webp"
"MediaSize" => 64905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193810/thumbnail-784b8a0f0a612dc232dbd1da80ebc93e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794447"
"ResourceRecordKey" => "29193810"
"ModificationTimestamp" => "2025-12-18T15:38:15.36Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6374612817"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193810/1b6f42099a2cc30dd0a6ffcb9240ba23.webp"
"MediaSize" => 127610
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193810/thumbnail-1b6f42099a2cc30dd0a6ffcb9240ba23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40794447"
"ResourceRecordKey" => "29193810"
"ModificationTimestamp" => "2025-12-18T15:38:15.36Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6374612829"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193810/92fd2c636e87c964eee00ef4eebbdabf.webp"
"MediaSize" => 56401
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193810/thumbnail-92fd2c636e87c964eee00ef4eebbdabf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794447"
"ResourceRecordKey" => "29193810"
"ModificationTimestamp" => "2025-12-18T15:38:15.36Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6374612848"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193810/c66e09f5390223dd7beac136a8025e77.webp"
"MediaSize" => 72250
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193810/thumbnail-c66e09f5390223dd7beac136a8025e77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794447"
"ResourceRecordKey" => "29193810"
"ModificationTimestamp" => "2025-12-18T15:38:15.36Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6374612868"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193810/ec66fe9bda6ff3cb5d11e56208bdd824.webp"
"MediaSize" => 82968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193810/thumbnail-ec66fe9bda6ff3cb5d11e56208bdd824.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794447"
"ResourceRecordKey" => "29193810"
"ModificationTimestamp" => "2025-12-18T15:38:15.36Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6374612888"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29193810/1ef0ba58afce343d6f376222c699f8d1.webp"
"MediaSize" => 84776
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29193810/thumbnail-1ef0ba58afce343d6f376222c699f8d1.webp"
"ResourceName" => "Property"
…6
]
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29193810')"
+"ID": "488391"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24824
+post_id: "486976"
+post_author: 1
+"ListingKey": "29192626"
+"ListingId": "40794229"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-18T16:25:37Z"
+"RFModificationTimestamp": "2025-12-18T16:29:17Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1278.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G9"
+"UnparsedAddress": "142 FOAMFLOWER Place Unit# A036, Waterloo, Ontario N2V0G9"
+"Coordinates": array:2 [
0 => -80.5888119
1 => 43.449685
]
+"Latitude": 43.449685
+"Longitude": -80.5888119
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome home to this stunning contemporary condo townhouse designed for modern living. This bright and spacious 2-bedroom, 2.5-bath residence features an open-concept layout with 9-foot ceilings on the main floor and a carpet-free main level, creating a clean, airy feel throughout. The beautiful, modern kitchen flows seamlessly into the living and dining areas, offering exceptional space for entertaining or relaxing in style. Step outside to enjoy two private balconies, one off the living room and another off the primary bedroom, perfect for morning coffee or evening unwinding. Upstairs, the primary bedroom retreat boasts its own ensuite with a sleek glass shower, while the second bedroom is serviced by a full main bathroom with a tub, ideal for guests or family living. Finished with contemporary touches throughout, this home is flooded with natural light and offers comfort, style, and functionality in every corner. A true renter’s delight, move in and enjoy effortless condo living. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFee": "398.49"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-17T21:20:15.857236+00:00"
+"Directions": "Columbia to Ladyslipper to Foamflower Place"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1878382"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"PhotosChangeTimestamp": "2025-12-17T20:59:49Z"
+"PhotosCount": 14
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-18T16:08:29Z"
+"Stories": "2.0"
+"StreetName": "FOAMFLOWER"
+"StreetNumber": "142"
+"StreetSuffix": "Place"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29192626/142-foamflower-place-unit-a036-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2450
+"ZoningDescription": "R6-FT"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1278
+"OriginalEntryTimestamp": "2025-12-17T20:59:49.24Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:14 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29192626')"
+"ID": "486976"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24912
+post_id: "486785"
+post_author: 1
+"ListingKey": "29192060"
+"ListingId": "X12638818"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-17T18:30:52Z"
+"RFModificationTimestamp": "2025-12-17T19:44:37Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2X1"
+"UnparsedAddress": "C17 - 619 WILD GINGER AVENUE, Waterloo, Ontario N2V2X1"
+"Coordinates": array:2 [
0 => -80.594044
1 => 43.46998
]
+"Latitude": 43.46998
+"Longitude": -80.594044
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful 3-Bedroom Executive Town House Available For Rent In Waterloo. It Approximately Measures 2,100 Square Feet And Has 3.5 Bathrooms. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-17T19:44:29.617828+00:00"
+"Directions": "Laurelwood & Erbsville"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Vinyl"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2059449"
+"ListOfficeKey": "282777"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-17T18:17:22Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-17T18:17:22Z"
+"Stories": "3.0"
+"StreetName": "Wild Ginger"
+"StreetNumber": "619"
+"StreetSuffix": "Avenue"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29192060/c17-619-wild-ginger-avenue-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3950
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-12-17T18:17:22.41Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:13 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29192060')"
+"ID": "486785"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24828
+post_id: "486791"
+post_author: 1
+"ListingKey": "29191178"
+"ListingId": "40793704"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-17T12:55:37Z"
+"RFModificationTimestamp": "2025-12-17T19:36:06Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 2199.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"UnparsedAddress": "179 DALECROFT Place, Waterloo, Ontario None"
+"Coordinates": array:2 [
0 => -80.5800819
1 => 43.4668742
]
+"Latitude": 43.4668742
+"Longitude": -80.5800819
+"YearBuilt": 1998
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Looking for the perfect home in a family-friendly neighbourhood? This is the one! Situated on a quiet court, this beautifully updated 3-bed, 3-bath home is available for lease and is ideal for growing families. Backing onto serene greenspace and trails, you can unwind in your stunning backyard surrounded by nature. The home features numerous updates throughout, including the kitchen, bathrooms, roof, furnace/AC, basement windows, and more. Located in one of Waterloo's most sought-after neighbourhoods, you'll have access to top-rated schools such as Laurelwood Public School, St. Nicholas Catholic School, and Sir John A. MacDonald Secondary School. Enjoy the convenience of being within walking distance to the Stork Family YMCA, public library, and Laurel Creek Conservation Area, with shopping and the Universities just a short drive away. Be sure to explore the virtual tour and book your showing today—this one won't last! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-17T19:35:46.618890+00:00"
+"Directions": "Off Beavercreek Road"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2043154"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-17T12:48:40Z"
+"PhotosCount": 17
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-17T12:48:40Z"
+"Stories": "2.0"
+"StreetName": "DALECROFT"
+"StreetNumber": "179"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29191178/179-dalecroft-place-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3400
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 29.0
+"AboveGradeFinishedArea": 1554
+"BelowGradeFinishedArea": 645
+"OriginalEntryTimestamp": "2025-12-17T12:48:40.85Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:17 [
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]
]
+"Member": []
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29191178')"
+"ID": "486791"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24908
+post_id: "484133"
+post_author: 1
+"ListingKey": "29188591"
+"ListingId": "40794086"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-16T03:35:23Z"
+"RFModificationTimestamp": "2025-12-16T04:38:01Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2330.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2T3"
+"UnparsedAddress": "421 WHITE BIRCH Avenue, Waterloo, Ontario N2V2T3"
+"Coordinates": array:2 [
0 => -80.5914559
1 => 43.4673633
]
+"Latitude": 43.4673633
+"Longitude": -80.5914559
+"YearBuilt": 2004
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Great Location in Laurelwood Neighbourhood! Situated at the end of a street, this unique home has abundant green space on both sides and the back and a park behind it! Open concept layout. Vaulted California ceilings, a maple kitchen with a ceramic backsplash and an island. Family room with a stone accent wall with sliders to an oversized deck and a private backyard. 3 Bedrooms, 3.5 Bathrooms, fully finished basement with a big-sized Rec. room. Large Master with ensuite on the second floor. All levels are finished. Minutes away from the elementary and high schools, a bus stop to the University of Waterloo directly, a public library, YMCA, Costco, Medical Centre, and Movie Theatre. Fast closing is possible! Easy to show (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-16T04:37:52.322349+00:00"
+"Directions": "WILD GINGER AVENUE / WHITE BIRCH AVENUE"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955745"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-16T03:28:47Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-16T03:28:47Z"
+"Stories": "2.0"
+"StreetName": "WHITE BIRCH"
+"StreetNumber": "421"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"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/29188591/421-white-birch-avenue-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3200
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "FR50"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 31.0
+"AboveGradeFinishedArea": 1940
+"BelowGradeFinishedArea": 390
+"OriginalEntryTimestamp": "2025-12-16T03:28:47.16Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:35 [
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]
]
+"Member": []
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29188591')"
+"ID": "484133"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24825
+post_id: "482743"
+post_author: 1
+"ListingKey": "29186814"
+"ListingId": "40793908"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-15T17:35:20Z"
+"RFModificationTimestamp": "2025-12-15T17:47:52Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 750.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2Y2"
+"UnparsedAddress": "641 FRIEBURG Drive Unit# Lower, Waterloo, Ontario N2T2Y2"
+"Coordinates": array:2 [
0 => -80.5799905
1 => 43.4554446
]
+"Latitude": 43.4554446
+"Longitude": -80.5799905
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to your new Waterloo home in Clair Hills! This bright, spacious, and beautifully maintained 1-bedroom apartment offers over 750 sq ft of comfortable living, tons of built-in storage, and a private entrance for complete independence and quiet living. With warm maple cabinetry, a full dine-in kitchen, front-loading LG washer/dryer, a corner gas fireplace, and an updated bathroom with a glass shower, this unit has everything a professional or graduate student needs. Rent: $1,800/month (All Inclusive) Includes: Heat, Hydro, Water Unit Features Private/separate entrance Bright living area with corner fireplace Large dine-in kitchen with: Maple cabinets Dishwasher Full-size fridge & stove LG front-loader washer & dryer Spacious bedroom with double closet Bathroom with glass corner shower Tons of built-in storage for skis, bikes, gear, etc. Oversized windows with blinds Parking for one car Water softener Space for an outdoor propane BBQ Location – Clair Hills (Waterloo) Perfect for professionals or grad students: 5-min walk to Bus Routes 13 & 29 5-min drive to UW, Costco, Boardwalk Shopping Centre 10-min drive to WLU 15-min walk to Shoppers, Tims, Winners, Dutchie’s Grocery, Canadian Tire & more Quick access to beautiful walking, biking & hiking trails 10 minutes to HydroCut bike trails Availability: January 1/ February 1st 2026 Lease: 1 year Requirements: Credit & references, tenant insurance Occupants: Professionals or graduate students preferred Pets/Smoking: Not permitted Outdoor Space: No separate private yard ***see sales brochure below for showing instructions***** (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2025-12-15T17:47:28.445888+00:00"
+"Directions": "Off of Keatsway"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1834563"
+"ListOfficeKey": "300202"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2025-12-15T17:29:41Z"
+"PhotosCount": 9
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-15T17:29:41Z"
+"Stories": "1.0"
+"StreetName": "FRIEBURG"
+"StreetNumber": "641"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29186814/641-frieburg-drive-unit-lower-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1800
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 0
+"BelowGradeFinishedArea": 750
+"OriginalEntryTimestamp": "2025-12-15T17:29:41.27Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:9 [
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]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29186814')"
+"ID": "482743"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23523
+post_id: "478969"
+post_author: 1
+"ListingKey": "29184586"
+"ListingId": "40793797"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-13T01:45:58Z"
+"RFModificationTimestamp": "2025-12-13T03:34:06Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 690.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A8"
+"UnparsedAddress": "776 LAURELWOOD Drive Unit# 307, Waterloo, Ontario N2V0A8"
+"Coordinates": array:2 [
0 => -80.5983268
1 => 43.4708684
]
+"Latitude": 43.4708684
+"Longitude": -80.5983268
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained 1 bedroom + den condo located in the highly sought-after Laurelwood neighbourhood! This bright and tasteful unit offers a functional layout with a spacious open-concept design, perfect for comfortable everyday living. The kitchen is beautiful and features, granite countertops, stainless steel appliances, and a large island—ideal for casual breakfasts or entertaining guests. The primary bedroom has a walk-in closet and the versatile den provides flexible space that can easily be used as a home office, guest room, or cozy reading nook. Enjoy all the conveniences of condo living in a vibrant community known for its top-rated schools, scenic trails, beautiful parks, the YMCA, public library, shopping, and a wide selection of restaurants—all just minutes from your door. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "326.87"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-13T03:33:46.247518+00:00"
+"Directions": "Erbsville to Laurelwood Drive"
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Brick"
2 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1915825"
+"ListOfficeKey": "290392"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"PhotosChangeTimestamp": "2025-12-13T01:38:20Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-13T01:38:20Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "776"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"VirtualTourURLUnbranded": "https://youriguide.com/776_laurelwood_dr_307_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29184586/776-laurelwood-drive-unit-307-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2100
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 690
+"OriginalEntryTimestamp": "2025-12-13T01:38:19.74Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29184586')"
+"ID": "478969"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24914
+post_id: "477718"
+post_author: 1
+"ListingKey": "29182172"
+"ListingId": "40791630"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-12T12:55:12Z"
+"RFModificationTimestamp": "2025-12-12T19:41:25Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1033.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G3"
+"UnparsedAddress": "778 LAURELWOOD Drive Unit# 403, Waterloo, Ontario N2V0G3"
+"Coordinates": array:2 [
0 => -80.5987556
1 => 43.4711694
]
+"Latitude": 43.4711694
+"Longitude": -80.5987556
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautifully maintained 2-bedroom, 2-bathroom condo for lease in Waterloo’s desirable Laurelwood neighbourhood. Owner-occupied and offering a practical, well-designed layout and approximately 1,000 sq. ft. of comfortable living space. The modern kitchen features granite countertops, a tiled backsplash, a large island, stainless steel appliances, and ample counter space. Additional features include in-suite laundry and a private balcony. The primary bedroom offers a walk-in closet and a 3-piece ensuite. Monthly rent includes water, 2 parking spots (one underground, one surface level), plus a storage locker. Located in a well-kept 7-storey building, residents enjoy excellent on-site amenities such as a bicycle storage room, central gazebo with BBQs and prep station, private theatre, entertainment lounge with pool table and kitchenette, and a versatile multi-purpose event room. Ideally situated within walking distance of Waterloo’s top ranked schools, and close to parks, shopping, public transit, and The Boardwalk. Easy access to both universities. Book your private showing today. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Water"
4 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-12T19:41:05.699741+00:00"
+"Directions": "From Erbsville Rd to Laurelwood Dr"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2045949"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Gazebo"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Covered"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2025-12-12T12:49:26Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-12T12:49:26Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "778"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"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/29182172/778-laurelwood-drive-unit-403-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2650
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1033
+"OriginalEntryTimestamp": "2025-12-12T12:49:26.16Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:40 [
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]
]
+"Member": array:1 [
0 => array:25 [ …25]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29182172')"
+"ID": "477718"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24915
+post_id: "476555"
+post_author: 1
+"ListingKey": "29181658"
+"ListingId": "X12628714"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-15T13:31:02Z"
+"RFModificationTimestamp": "2025-12-15T13:33:29Z"
+"ListPrice": 995000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N8"
+"UnparsedAddress": "670 SALZBURG DRIVE, Waterloo, Ontario N2V2N8"
+"Coordinates": array:2 [
0 => -80.5864391
1 => 43.4620608
]
+"Latitude": 43.4620608
+"Longitude": -80.5864391
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "IF THIS IS YOUR TIME TO DOWNSIZE, THIS IS YOUR HOUSE. A Rare Opportunity Come and see this Home before its gone! If you've been searching for the perfect retirement bungalow, this is the one people remember for years - the one that "got away." A modern-built, freehold bungalow (yes, no condo fees) with a walkout basement and a million-dollar pond view in Waterloo's prestigious Rosewood/Clair Hills community. Homes like this almost never come to market, and with the neighbourhood fully built out, finding another one like it may soon be impossible. Designed for effortless, comfortable living, this 2+1 bedroom, 3-bath walkout bungalow offers nearly 2,000 sq. ft. of beautifully finished space. Freshly painted with brand-new carpet, it's fully move-in ready - the perfect option for anyone looking to simplify without compromising quality. The open-concept main floor features maple hardwood, ceramic tile, & seamless access to a raised deck with glass railings overlooking the tranquil Rosewood Pond - a protected view that can't be duplicated today. The primary suite faces the water & includes a private 4-piece en-suite, while the second bedroom with a built-in Murphy bed easily doubles as a guest room or home office. The bright walkout basement expands your living space with oversized windows, a cozy gas fireplace, & direct yard access for peaceful mornings by the water. A third bedroom with en-suite privileges and a generous storage area complete the lower level. Thoughtfully built with long-term comfort in mind, this home includes widened doorways, lowered switches, updated mechanicals, a double garage, and a quiet, low-traffic street - exactly what downsizers value most. This is the ideal combination: one-floor living, serene natural surroundings, no condo fees, minimal maintenance, & a view to die for. Opportunities like this simply do not come twice. Welcome to Rosewood Estates - a truly irreplaceable home. IT COULD BE YEARS BEFORE ANOTHER ONE COMES ALONG. (id:62650)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Water meter"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-12T00:43:51.399784+00:00"
+"Directions": "Cross Streets: Columbia St. W. ** Directions: Columbia to Salzburg Drive."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100955"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "45 x 118.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-11T23:54:34Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-15T13:26:05Z"
+"Stories": "1.0"
+"StreetName": "Salzburg"
+"StreetNumber": "670"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5446"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "http://youriguide.com/670_salzburg_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29181658/670-salzburg-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2025-12-11T23:54:34.64Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29181658')"
+"ID": "476555"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 113
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]
