array:6 [
"RF Cache Key: de0c4cea6da3f7a4842e11968ddb0e875a5483b564588e136db96380e643ec6a" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#21754
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23338
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "29880472"
+"ListingId": "40837748"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T04:10:38Z"
+"RFModificationTimestamp": "2026-06-10T06:47:30Z"
+"ListPrice": 569000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1147.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G9"
+"UnparsedAddress": "142 FOAMFLOWER Place Unit# A036, Waterloo, Ontario N2V0G9"
+"Coordinates": array:2 [
0 => -80.5903782
1 => 43.4498871
]
+"Latitude": 43.4498871
+"Longitude": -80.5903782
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to luxury living in the highly sought-after Vista Hills community of West Waterloo. This stunning executive stacked townhouse offers the perfect blend of modern design, comfort, and convenience. Featuring 3 spacious bedrooms and 2.5 bathrooms, this beautifully maintained home boasts an open-concept layout designed for today's lifestyle. The bright and inviting main floor is carpet-free and showcases a stylish kitchen complete with elegant quartz countertops, abundant cabinetry, a large center island with breakfast bar seating, and plenty of workspace for entertaining or everyday living. The spacious living and dining areas flow seamlessly to private outdoor spaces, with two balconies providing the perfect setting to enjoy your morning coffee or unwind after a long day. Upstairs, the primary retreat offers a luxurious ensuite bathroom featuring a sleek glass-enclosed shower, creating a spa-like experience in the comfort of your own home. Located in one of Waterloo's most desirable neighborhoods, Vista Hills is known for its top-rated schools, scenic walking trails, parks, and close proximity to shopping, dining, universities, and major commuter routes. xWhether you're a professional, growing family, or savvy investor, this exceptional home delivers the perfect combination of style, functionality, and an unbeatable location. Don't miss your opportunity to own in one of West Waterloo's premier communities. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"AssociationFee": "363.87"
+"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": "2026-06-10T06:47:20.432400+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:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-06-10T04:00:56Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T04:00:56Z"
+"Stories": "2.0"
+"StreetName": "FOAMFLOWER"
+"StreetNumber": "142"
+"StreetSuffix": "Place"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3329"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1656118439"
"RoomType" => "Laundry room"
"ListingId" => "40837748"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29880472"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T04:00:56.59Z"
]
1 => array:11 [
"RoomKey" => "1656118440"
"RoomType" => "4pc Bathroom"
"ListingId" => "40837748"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29880472"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T04:00:56.6Z"
]
2 => array:11 [
"RoomKey" => "1656118441"
"RoomType" => "Full bathroom"
"ListingId" => "40837748"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29880472"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T04:00:56.6Z"
]
3 => array:11 [
"RoomKey" => "1656118442"
"RoomType" => "Bedroom"
"ListingId" => "40837748"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29880472"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T04:00:56.6Z"
]
4 => array:11 [
"RoomKey" => "1656118443"
"RoomType" => "Primary Bedroom"
"ListingId" => "40837748"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29880472"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T04:00:56.6Z"
]
5 => array:11 [
"RoomKey" => "1656118444"
"RoomType" => "2pc Bathroom"
"ListingId" => "40837748"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29880472"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T04:00:56.6Z"
]
6 => array:11 [
"RoomKey" => "1656118445"
"RoomType" => "Kitchen"
"ListingId" => "40837748"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29880472"
"RoomLength" => null
"RoomDimensions" => "8'5'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T04:00:56.6Z"
]
7 => array:11 [
"RoomKey" => "1656118446"
"RoomType" => "Living room/Dining room"
"ListingId" => "40837748"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29880472"
"RoomLength" => null
"RoomDimensions" => "18'4'' x 13'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T04:00:56.6Z"
]
8 => array:11 [
"RoomKey" => "1656118447"
"RoomType" => "Foyer"
"ListingId" => "40837748"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29880472"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 13'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T04:00:56.6Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29880472/142-foamflower-place-unit-a036-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R9 R6-FT"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1147
+"OriginalEntryTimestamp": "2026-06-10T04:00:56.55Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1205009"
+"ListOfficeNationalAssociationId": "1324759"
+"Media": array:36 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29880472_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/a3cdb55c70cfe83966aff0e1f9b2f8e6.webp"
"MediaSize" => 68967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-a3cdb55c70cfe83966aff0e1f9b2f8e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern townhome complex featuring a multi-story facade with light-toned wood-finish siding, white and grey paneling, and dark window frames"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29880472_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/e49a3e0619bc278224ffa8bbc3d137f7.webp"
"MediaSize" => 84810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-e49a3e0619bc278224ffa8bbc3d137f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern townhome exteriors featuring horizontal light-toned siding, dark grey paneling, and white facade accents"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29880472_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/eb6d4fe3057cefcf63f898ca38de8ece.webp"
"MediaSize" => 86913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-eb6d4fe3057cefcf63f898ca38de8ece.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern townhome facade featuring a varied material palette of light-colored siding, dark paneling, and stone accents"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29880472_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/23cb73de520e2a2ad4a68e667355867f.webp"
"MediaSize" => 57213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-23cb73de520e2a2ad4a68e667355867f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29880472_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/0de92f91788feaf33e5acebf8d5e7441.webp"
"MediaSize" => 44403
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-0de92f91788feaf33e5acebf8d5e7441.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a full-light door with a matte gray finish"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29880472_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/1fdf6afc501d2a86e13f7e6c405b7bc4.webp"
"MediaSize" => 23590
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-1fdf6afc501d2a86e13f7e6c405b7bc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stairwell featuring light wood-finish flooring, a light wood handrail, and a flush-mount ceiling light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29880472_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/b02209f868f7a0d8e80748dfa4970030.webp"
"MediaSize" => 52869
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-b02209f868f7a0d8e80748dfa4970030.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space with wood-finish flooring, an island kitchen featuring a double basin sink and integrated dishwasher, a pendant light fixture, and large windows providing abundant natural li"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29880472_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/5a034a5694dff61ae48e1c377ceb2892.webp"
"MediaSize" => 57853
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-5a034a5694dff61ae48e1c377ceb2892.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring throughout"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29880472_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/641b5ac39c12401a57a60be8bbc516be.webp"
"MediaSize" => 63147
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-641b5ac39c12401a57a60be8bbc516be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring wood-finish cabinetry, stainless steel appliances, a white subway tile backsplash, and a granite-look island with an undermount sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29880472_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/223ebd65ea89ab9f4d6f547963283c0f.webp"
"MediaSize" => 56022
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-223ebd65ea89ab9f4d6f547963283c0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring a central island with an integrated sink, granite countertop, wood-finish cabinetry, white subway tile backsplash, and stainless steel appliances"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29880472_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/45bb9d99198d62c68210d1fe7faa9412.webp"
"MediaSize" => 61728
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-45bb9d99198d62c68210d1fe7faa9412.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen island featuring a dual-basin stainless steel sink, integrated dishwasher, and granite-look countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29880472_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/d9ed49fe191d821a3f0057860356b25a.webp"
"MediaSize" => 57822
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-d9ed49fe191d821a3f0057860356b25a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring wood-finish flooring, a large window with exterior scenery, recessed lighting, and a staircase with a natural wood handrail"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29880472_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/993651a5090ccfab5809e02f45cf74f8.webp"
"MediaSize" => 60497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-993651a5090ccfab5809e02f45cf74f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring, a kitchen island with seating, stainless steel appliances, and a staircase with a natural wood handrail"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29880472_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/72df7688a647b4be8d95e16eff30418c.webp"
"MediaSize" => 82937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-72df7688a647b4be8d95e16eff30418c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Balcony with glass panel railing and black metal frame"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29880472_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/24921c08dd19c545f676d502a9f78bd0.webp"
"MediaSize" => 51608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-24921c08dd19c545f676d502a9f78bd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring, a kitchen island with seating, stainless steel appliances, white subway tile backsplash, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29880472_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/d4c2fba2af53e7e21ca815dffc25d0bf.webp"
"MediaSize" => 56175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-d4c2fba2af53e7e21ca815dffc25d0bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring wood-finish flooring, white baseboards, and neutral wall tones"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29880472_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/d7135381bc564f299cb6c72a18eeded0.webp"
"MediaSize" => 33347
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-d7135381bc564f299cb6c72a18eeded0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Pedestal sink with chrome faucet, complemented by a rectangular wall-mounted mirror and two-light vanity fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29880472_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/9124401bb25eb63a9171ce2d58d6ec90.webp"
"MediaSize" => 85391
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-9124401bb25eb63a9171ce2d58d6ec90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Utility area featuring a tankless water heater, water softener system, and HVAC unit"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29880472_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/af9ac5bf638bfe1cf0d02f554e73233f.webp"
"MediaSize" => 34087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-af9ac5bf638bfe1cf0d02f554e73233f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Upper landing featuring light wood-finish flooring, white wall paneling, a light wood handrail, and a white interior door frame"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29880472_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/a0da1c31c8c9bf0ea9d5c336ba6ced2e.webp"
"MediaSize" => 58626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-a0da1c31c8c9bf0ea9d5c336ba6ced2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a vanity with a light granite countertop and undermount sink, a large wall-mounted mirror, and a three-light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29880472_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/f2705f753e6b09a22ec53223438cc682.webp"
"MediaSize" => 62744
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-f2705f753e6b09a22ec53223438cc682.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright room featuring light-toned walls, wood-finish flooring, and a large window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29880472_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/bc0b055aa0c79001e88693ca4ddd955c.webp"
"MediaSize" => 50712
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-bc0b055aa0c79001e88693ca4ddd955c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring neutral wall tones, crown molding, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29880472_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/10eb56a4495a0e7a8ae19734c21962fa.webp"
"MediaSize" => 57940
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-10eb56a4495a0e7a8ae19734c21962fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring light wood-finish flooring and white walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29880472_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/f438512df72a19b44a5f301a25875ba5.webp"
"MediaSize" => 53289
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-f438512df72a19b44a5f301a25875ba5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light wood-finish flooring, white painted walls, and a single window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29880472_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/c29c535920004d78dcf0325ffddf514e.webp"
"MediaSize" => 94851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-c29c535920004d78dcf0325ffddf514e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Balcony featuring glass panel railing and a painted exterior wall, overlooking a green expanse and residential properties"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29880472_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/491a44fd1f232559a2288db895721748.webp"
"MediaSize" => 52197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-491a44fd1f232559a2288db895721748.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a glass-enclosed shower, a vanity with a granite countertop, an undermount sink, and a wall-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29880472_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/1f90ee1bc725bc70e730832a114178b3.webp"
"MediaSize" => 33433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-1f90ee1bc725bc70e730832a114178b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry closet featuring a white stacked washer and dryer unit"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29880472_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/a73a275d7c2c6bcf83c495b4ed4de619.webp"
"MediaSize" => 100904
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-a73a275d7c2c6bcf83c495b4ed4de619.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29880472_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/6249f1a58bdccc137a8ede8cd60a5132.webp"
"MediaSize" => 114123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-6249f1a58bdccc137a8ede8cd60a5132.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29880472_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/534f02ceb5721f8486258a63ffdbb8bf.webp"
"MediaSize" => 110644
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-534f02ceb5721f8486258a63ffdbb8bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern townhome community featuring contemporary architectural facades"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29880472_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/47e603ec5245cd18b7e2762281255f8d.webp"
"MediaSize" => 108027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-47e603ec5245cd18b7e2762281255f8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern townhome exteriors featuring multi-toned paneling, dark framed windows, and individual balconies"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29880472_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/76578d6a184a2c8bbafb749e63efc79c.webp"
"MediaSize" => 112332
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-76578d6a184a2c8bbafb749e63efc79c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial perspective showcasing a modern residential community"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29880472_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/5afd859e2bb7b375389964c8e7ed6363.webp"
"MediaSize" => 103683
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-5afd859e2bb7b375389964c8e7ed6363.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary townhome community featuring modern architectural designs and a structured layout"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29880472_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/44a32d05e348de6f4c1d23b3f2b03b6e.webp"
"MediaSize" => 44798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-44a32d05e348de6f4c1d23b3f2b03b6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29880472_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/9fab34722c90e69a175cbe711308248d.webp"
"MediaSize" => 45738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-9fab34722c90e69a175cbe711308248d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29880472_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29880472/dfd708b06b872f1ff1cad32a815fa58d.webp"
"MediaSize" => 25563
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29880472/thumbnail-dfd708b06b872f1ff1cad32a815fa58d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837748"
"ResourceRecordKey" => "29880472"
"ModificationTimestamp" => "2026-06-10T04:00:56.56Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29880472')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Cache Key: 132922ed44a0adb387053293db31449942ef832f1b153944f588b7fb6fae517d" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24448
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
]
"RF Cache Key: cf13e6a3c2fd5e74ad282a71211c5f863a7c2f3e45057052573991e003ca4e20" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24725
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29880472'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25080
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Cache Key: a9b3fe66d17390520441ff9bcf0630fa9dca1ea74715edc8252c074a06fb6d7f" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24686
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
]
"RF Cache Key: a1e8371375dc1514ee14c5c0b11ccf12a9fb1377b7d655ed0c944e576fbd524d" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25085
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23336
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "29884895"
+"ListingId": "40838570"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T20:15:15Z"
+"RFModificationTimestamp": "2026-06-10T20:43:37Z"
+"ListPrice": 675000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1952.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2L2"
+"UnparsedAddress": "704 STAR FLOWER Avenue, Waterloo, Ontario N2V2L2"
+"Coordinates": array:2 [
0 => -80.5876117
1 => 43.4653582
]
+"Latitude": 43.4653582
+"Longitude": -80.5876117
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning 2 story home with a HUGE LOFT in a desirable family neighbourhood. Brand new kitchen with quartz countertops and new stainless appliances. Lovely living room with multiple windows that provide lots of natural light--such a great family space. Sunny dinette with slider walk-out to the deck. Amazing 3rd floor loft is fabulous bonus space for multipurpose--so many options: family room, workout area, office, den, playroom, etc! Good sized primary bedroom with vaulted ceiling and walk-in closet. The 2 other bedrooms are also large with good size closets. Finished basement with a walk out to the large private fenced yard. The home just received multiple updates which include New Kitchen, Appliances, Bathrooms, Paint, Carpet-Free Flooring, Lighting and much more! Amazing location: close to top rated schools, parks, shopping, Costco, kilometres of walking trails (also great for running, biking, walking the dog, etc.) (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T20:41:07.698967+00:00"
+"Directions": "Erbsville Rd & Columbia Forest Blvd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1768640"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T20:09:55Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T20:09:55Z"
+"Stories": "2.0"
+"StreetName": "STAR FLOWER"
+"StreetNumber": "704"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4864"
+"VirtualTourURLUnbranded": "https://youriguide.com/704_star_flower_ave_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1656489669"
"RoomType" => "Recreation room"
"ListingId" => "40838570"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29884895"
"RoomLength" => null
"RoomDimensions" => "16'1'' x 20'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T20:09:55.58Z"
]
1 => array:11 [
"RoomKey" => "1656489670"
"RoomType" => "Bonus Room"
"ListingId" => "40838570"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29884895"
"RoomLength" => null
"RoomDimensions" => "24'2'' x 21'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T20:09:55.58Z"
]
2 => array:11 [
"RoomKey" => "1656489671"
"RoomType" => "4pc Bathroom"
"ListingId" => "40838570"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29884895"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T20:09:55.59Z"
]
3 => array:11 [
"RoomKey" => "1656489672"
"RoomType" => "Bedroom"
"ListingId" => "40838570"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29884895"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T20:09:55.59Z"
]
4 => array:11 [
"RoomKey" => "1656489673"
"RoomType" => "Bedroom"
"ListingId" => "40838570"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29884895"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T20:09:55.59Z"
]
5 => array:11 [
"RoomKey" => "1656489674"
"RoomType" => "Primary Bedroom"
"ListingId" => "40838570"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29884895"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T20:09:55.59Z"
]
6 => array:11 [
"RoomKey" => "1656489675"
"RoomType" => "2pc Bathroom"
"ListingId" => "40838570"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29884895"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T20:09:55.59Z"
]
7 => array:11 [
"RoomKey" => "1656489676"
"RoomType" => "Dining room"
"ListingId" => "40838570"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29884895"
"RoomLength" => null
"RoomDimensions" => "8'9'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T20:09:55.59Z"
]
8 => array:11 [
"RoomKey" => "1656489677"
"RoomType" => "Kitchen"
"ListingId" => "40838570"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29884895"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 9'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T20:09:55.59Z"
]
9 => array:11 [
"RoomKey" => "1656489678"
"RoomType" => "Living room"
"ListingId" => "40838570"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29884895"
"RoomLength" => null
"RoomDimensions" => "13'8'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T20:09:55.59Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29884895/704-star-flower-avenue-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1952
+"OriginalEntryTimestamp": "2026-06-10T20:09:55.55Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"ListAgentNationalAssociationId": "1185878"
+"ListOfficeNationalAssociationId": "1004370"
+"Media": array:43 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29884895_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884895/7e1441971d828fa48d1a6c92656254f7.webp"
"MediaSize" => 150171
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884895/thumbnail-7e1441971d828fa48d1a6c92656254f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40838570"
"ResourceRecordKey" => "29884895"
"ModificationTimestamp" => "2026-06-10T20:09:55.56Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29884895_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884895/a26e7c44e8f552eb83974f503fb1824e.webp"
"MediaSize" => 71275
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884895/thumbnail-a26e7c44e8f552eb83974f503fb1824e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838570"
"ResourceRecordKey" => "29884895"
"ModificationTimestamp" => "2026-06-10T20:09:55.56Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29884895_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884895/8136df596a1be88d3a980db5d8d2d44e.webp"
"MediaSize" => 67573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884895/thumbnail-8136df596a1be88d3a980db5d8d2d44e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838570"
"ResourceRecordKey" => "29884895"
"ModificationTimestamp" => "2026-06-10T20:09:55.56Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29884895_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884895/5a1c0763fb5ffb3bbfabb7f02e0cf24f.webp"
"MediaSize" => 65255
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884895/thumbnail-5a1c0763fb5ffb3bbfabb7f02e0cf24f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838570"
"ResourceRecordKey" => "29884895"
"ModificationTimestamp" => "2026-06-10T20:09:55.56Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29884895_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884895/a26da546bfa7a9b131ab18f59f874224.webp"
"MediaSize" => 49788
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884895/thumbnail-a26da546bfa7a9b131ab18f59f874224.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838570"
"ResourceRecordKey" => "29884895"
"ModificationTimestamp" => "2026-06-10T20:09:55.56Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29884895_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884895/9e73f9e207c7b98c30c16141c31078d6.webp"
"MediaSize" => 56566
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884895/thumbnail-9e73f9e207c7b98c30c16141c31078d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838570"
"ResourceRecordKey" => "29884895"
"ModificationTimestamp" => "2026-06-10T20:09:55.56Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29884895_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884895/6e85636015706943d834938cb5049640.webp"
"MediaSize" => 70326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884895/thumbnail-6e85636015706943d834938cb5049640.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838570"
"ResourceRecordKey" => "29884895"
"ModificationTimestamp" => "2026-06-10T20:09:55.56Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29884895_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884895/aee9d012481d5f9df37d49d4cecf356c.webp"
"MediaSize" => 67504
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884895/thumbnail-aee9d012481d5f9df37d49d4cecf356c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838570"
"ResourceRecordKey" => "29884895"
"ModificationTimestamp" => "2026-06-10T20:09:55.56Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29884895_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884895/5223e48d4bd2504fc1077058477f0b46.webp"
"MediaSize" => 80887
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884895/thumbnail-5223e48d4bd2504fc1077058477f0b46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838570"
"ResourceRecordKey" => "29884895"
"ModificationTimestamp" => "2026-06-10T20:09:55.56Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29884895_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884895/9880560de6788761871df7bed8307204.webp"
"MediaSize" => 84331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884895/thumbnail-9880560de6788761871df7bed8307204.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838570"
"ResourceRecordKey" => "29884895"
"ModificationTimestamp" => "2026-06-10T20:09:55.56Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29884895_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884895/15f65f0243508342d3c90d0695c2900e.webp"
"MediaSize" => 40535
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884895/thumbnail-15f65f0243508342d3c90d0695c2900e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838570"
"ResourceRecordKey" => "29884895"
"ModificationTimestamp" => "2026-06-10T20:09:55.56Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29884895_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884895/0ac6fe1823a78f0d22aaa3e1e95a0750.webp"
"MediaSize" => 37532
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884895/thumbnail-0ac6fe1823a78f0d22aaa3e1e95a0750.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838570"
"ResourceRecordKey" => "29884895"
"ModificationTimestamp" => "2026-06-10T20:09:55.56Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29884895_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884895/24b1890217b6d5e2ec8257a6e61e840f.webp"
"MediaSize" => 36908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884895/thumbnail-24b1890217b6d5e2ec8257a6e61e840f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838570"
"ResourceRecordKey" => "29884895"
"ModificationTimestamp" => "2026-06-10T20:09:55.56Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29884895_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884895/ff2d3928c8e7567f36ca9fb90ffbc17f.webp"
"MediaSize" => 38589
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884895/thumbnail-ff2d3928c8e7567f36ca9fb90ffbc17f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838570"
"ResourceRecordKey" => "29884895"
"ModificationTimestamp" => "2026-06-10T20:09:55.56Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29884895_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884895/aef2e14e0ddd203bde70ce632e0e1cee.webp"
"MediaSize" => 62967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884895/thumbnail-aef2e14e0ddd203bde70ce632e0e1cee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838570"
"ResourceRecordKey" => "29884895"
"ModificationTimestamp" => "2026-06-10T20:09:55.56Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29884895_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884895/68e66d1645c3928f830efff676f08ea7.webp"
"MediaSize" => 54175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884895/thumbnail-68e66d1645c3928f830efff676f08ea7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838570"
"ResourceRecordKey" => "29884895"
"ModificationTimestamp" => "2026-06-10T20:09:55.56Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29884895_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884895/9008443896e0660dfbef6e1409d5892c.webp"
"MediaSize" => 51801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884895/thumbnail-9008443896e0660dfbef6e1409d5892c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838570"
"ResourceRecordKey" => "29884895"
"ModificationTimestamp" => "2026-06-10T20:09:55.56Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29884895_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884895/f752ee6ca63de6041bb6d14839b1fb1a.webp"
"MediaSize" => 40277
"MediaType" => "webp"
…8
]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29884895')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23351
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "29877772"
+"ListingId": "X13421192"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T21:26:09Z"
+"RFModificationTimestamp": "2026-06-09T21:34:02Z"
+"ListPrice": 989900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2X4"
+"UnparsedAddress": "444 LAUSANNE CRESCENT, Waterloo, Ontario N2T2X4"
+"Coordinates": array:2 [
0 => -80.574006
1 => 43.452858
]
+"Latitude": 43.452858
+"Longitude": -80.574006
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 444 Lausanne Crescent! This well-maintained detached home offers an exceptional opportunity for growing families seeking space, comfort, and versatility. Featuring 3 spacious bedrooms plus a dedicated office space, this bright and functional home provides plenty of room for today's lifestyle. The main floor boasts a practical layout with generous living and dining areas, a well-appointed kitchen with ample cabinetry, and abundant natural light throughout.The upper level features three generously sized bedrooms and a separate office space, perfect for working from home, studying, or creating a dedicated hobby area. The fully finished basement adds valuable living space with two additional bedrooms, a kitchen, a living area, and its own dedicated laundry, providing excellent flexibility for extended family, guests, or multi-generational living. Enjoy a private backyard with no rear neighbours, offering added privacy and an ideal setting for entertaining, relaxing, and family gatherings. Located in a family-friendly neighbourhood close to schools, parks, shopping, restaurants, public transit, and major amenities. Just minutes from both the University of Waterloo and Wilfrid Laurier University, this move-in-ready home combines space, convenience, and an unbeatable location in one of Waterloo's most desirable communities. (id:62650)"
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T19:22:40.554775+00:00"
+"Directions": "Erbsville Rd To Brandenburg"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1896837"
+"ListOfficeKey": "51498"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "36 x 105.8 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T18:56:32Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T21:19:23Z"
+"StreetName": "Lausanne"
+"StreetNumber": "444"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "5571.35"
+"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"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29877772/444-lausanne-crescent-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 36.0
+"OriginalEntryTimestamp": "2026-06-09T18:56:32.71Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1214984"
+"ListOfficeNationalAssociationId": "1124039"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29877772')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23352
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "29877136"
+"ListingId": "X13420892"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T18:01:04Z"
+"RFModificationTimestamp": "2026-06-09T18:46:38Z"
+"ListPrice": 1049000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2V0B8"
+"UnparsedAddress": "541 SUNDEW DRIVE, Kitchener, Ontario N2V0B8"
+"Coordinates": array:2 [
0 => -80.596797
1 => 43.457194
]
+"Latitude": 43.457194
+"Longitude": -80.596797
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "(STEP INSIDE) 4-bdrm detached 2-storey in Vista Hills, Waterloo. Open-concept main floor built around a fully equipped gas kitchen, walk-out dining rm with built-in wine cooler & a family rm that overlooks the backyard. Primary bdrm has his & her walk-in closets & a private 4pc en suite with soaker tub & standup shower. Full-width unfinished basement rec room. Vacant & available with flexible closing. (MAIN LEVEL) Ceramic-tiled foyer leads to a generous laminate landing before the living areas open up. Kitchen has a full stainless steel appliance package - gas stove, range hood, fridge, dishwasher & microwave - double sink & laminate floors, all open to the family rm with clear backyard views. Dining area has a wine cooler & walk-out to the back deck - a practical extension of the space on warmer evenings. 2pc powder rm off the main hall. Dedicated laundry rm with GE washer/dryer, blue cabinetry & direct inside access to the garage. (UPPER LEVEL) Primary bdrm has his & her walk-in closets & a private 4pc en suite with separate standup shower & large soaker tub. Bdrms 2, 3 & 4 are each well-proportioned with double closets, large windows & laminate floors. Main 4pc bath serves the secondary bdrms. (BASEMENT) Full-width open rec room - unfinished & ready for your own layout. Utility rm has hot water tank, water treatment system & HRV, all in one organized space. Additional dedicated storage rm. (LOCATION) Vista Hills at the northwest edge of Waterloo, backed by Laurel Creek Conservation Area to the west. Sundew Park is steps from the door - playground & community garden with direct trail access. Geo-Time Trail network connects the neighbourhood to the largest protected woodland in Waterloo. The Boardwalk at Ira Needles is ~10 min by car for grocery, dining, retail & Costco. Laurel Heights SS 1.5 km north. University of Waterloo & Wilfrid Laurier University a short drive east. (id:62650)"
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T18:46:25.888979+00:00"
+"Directions": "Cross Streets: Platinum Dr and Columbia St W. ** Directions: At Platinum Dr and Columbia St W, head northwest on Platinum Dr; At the roundabout, take the 3rd exit onto Columbia St W for 400 m; At the roundabout, take the 1st exit onto Sundew Dr; Destination will be on the left."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1922276"
+"ListOfficeKey": "238732"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "38 x 98.4 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T17:50:25Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T17:50:25Z"
+"Stories": "2.0"
+"StreetName": "Sundew"
+"StreetNumber": "541"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6686"
+"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": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29877136/541-sundew-drive-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 38.0
+"OriginalEntryTimestamp": "2026-06-09T17:50:25.54Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1227436"
+"ListOfficeNationalAssociationId": "1200762"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29877136')"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25180
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "29874981"
+"ListingId": "40836085"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T13:50:30Z"
+"RFModificationTimestamp": "2026-06-09T17:33:54Z"
+"ListPrice": 1349888.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.16
+"LivingArea": 3928.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N5"
+"UnparsedAddress": "805 MUNICH Circle, Waterloo, Ontario N2V2N5"
+"Coordinates": array:2 [
0 => -80.5902978
1 => 43.4603169
]
+"Latitude": 43.4603169
+"Longitude": -80.5902978
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 805 Munich Circle, a STUNNING LAURELVIEW HOMES-BUILT RESIDENCE nestled within the prestigious Rosewood Estates enclave of Clair Hills, one of Waterloo's most sought-after communities. Offering over 3,900 sq. ft. of finished living space, this exceptional 4-bedroom, 3.5-bathroom HOME IS PERFECTLY SITUATED ON A BEAUTIFULLY LANDSCAPED 0.16-ACRE LOT in a quiet cul-de-sac surrounded by nature trails and executive homes. Step inside to a grand two-storey foyer and discover elegant formal living and dining rooms accented by arched entryways and abundant natural light. The spacious kitchen is designed for both EVERYDAY LIVING AND ENTERTAINING, featuring white shaker cabinetry, granite countertops, mosaic tile backsplash, valance lighting, gas stove, peninsula island, recessed lighting and a bright dinette overlooking the backyard. The adjoining family room offers a cozy gas fireplace, wall-mounted TV feature, and EXPANSIVE WINDOWS SHOWCASING THE OUTDOOR SETTING. The main floor is complete with California shutters, laundry room, powder room, and direct access to the double-car garage. Upstairs, a curved hardwood staircase with wrought iron spindles leads to the SPACIOUS PRIMARY SUITE featuring a walk-in closet and 4-piece ensuite with soaker tub, granite vanity, and separate shower. Three additional bedrooms and a full family bathroom complete the upper level. The professionally finished basement expands the living space with a large recreation room, media/games area, full 3-piece bathroom, and VERSATILE HOBBY ROOM OR HOME OFFICE with walk-in closet. Enjoy outdoor living with a deck, gazebo, interlock patio, landscaped grounds, and private backyard retreat. Located just minutes from TOP-RATED SCHOOLS, PARKS, TRAILS, SHOPPING, UNIVERSITIES, AND THE BOARDWALK, this exceptional property offers the perfect combination of luxury, comfort, and convenience in one of Waterloo's premier neighbourhoods. A rare opportunity to call Rosewood Estates home. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T17:33:46.286858+00:00"
+"Directions": "Columbia St turn onto Salzburg Drive follow until Munich Circle"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563948"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Visual exposure"
2 => "Ravine"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.16"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T13:40:50Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T13:40:50Z"
+"Stories": "2.0"
+"StreetName": "MUNICH"
+"StreetNumber": "805"
+"StreetSuffix": "Circle"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "7433.43"
+"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/sites/805-munich-cir-waterloo-on-n2v-2n5-25574745/branded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:20 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29874981/805-munich-circle-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "47.7-R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 92.0
+"AboveGradeFinishedArea": 2760
+"BelowGradeFinishedArea": 1168
+"OriginalEntryTimestamp": "2026-06-09T13:39:46.51Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1135552"
+"ListOfficeNationalAssociationId": "1378680"
+"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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29874981')"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25200
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "29875583"
+"ListingId": "X13419136"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T16:05:47Z"
+"RFModificationTimestamp": "2026-06-09T16:10:39Z"
+"ListPrice": 1450000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0E7"
+"UnparsedAddress": "787 SNOWBERRY COURT, Waterloo, Ontario N2V0E7"
+"Coordinates": array:2 [
0 => -80.602215
1 => 43.462072
]
+"Latitude": 43.462072
+"Longitude": -80.602215
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A great house in an equally great neighborhood! 787 Snowberry court is one of the few walkout lots on the quiet court in Vista Hills: a neighborhood emersed into nature surrounded by forests of walking trails and some of the top-rated schools in the region. This classic all brick and stone 2 story has beautiful curb appeal, further enhanced by its interlocking driveway and armour stone accents. The double front doors open to a large foyer; adjacent to it is the living room/office, a formal space at the front of the home. The main level was designed around an open spiral oak staircase providing a stunning centre piece that elegantly connects the main floor to the second. The flooring throughout the main is a combination of modern 12x24 tile and wide plank engineered hardwood. The design flows freely through the dining room, over sized kitchen, and dinette overlooking the fully fenced yard complete with composite fencing. The kitchen features abundant cabinet space, built-in stainless-steel appliances, and quartz countertops. The family room sits adjacent and showcases a beautiful fireplace feature wall with staggered floating shelves. The sunken mudroom achieves a partial separation from the main level and is an extremely practical space for access to and from the garage with groceries and preparations. Hardwood flooring continues to finish the space in the high traffic hallway of the second floor. Four bedrooms, 3 bathrooms and a conveniently located laundry make up the second-floor space. The primary bedroom sits at the back of the home and features a walk-in closet with elegant 5 piece ensuite; complete with glass shower and soaker tub. The second bedroom also features a private 3 piece ensuite with glass shower, leaving the 3rd and 4th bedrooms sharing a 5-piece jack and jill bathroom with all the vanities in the home finished in quartz. The basement is ready for your imagination; large windows and large footprint provide lots of finishing options! Don't miss it! (id:62650)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"Basement": array:4 [
0 => "Unfinished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T16:10:35.124713+00:00"
+"Directions": "Cross Streets: Autumn Willow. ** Directions: Columbia St to Sundew right on Balsam Poplar St left on Autumn Willow follow to Snowberry Court."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2239281"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "46.1 x 108 FT ; 103.79 x 46.29 x 107.96 x 63.28"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T14:55:41Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T15:54:00Z"
+"Stories": "2.0"
+"StreetName": "Snowberry"
+"StreetNumber": "787"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "10383.89"
+"VirtualTourURLUnbranded": "https://youtu.be/Vn1tecMngZM"
+"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": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29875583/787-snowberry-court-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 46.1
+"OriginalEntryTimestamp": "2026-06-09T14:55:41.17Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1477313"
+"ListOfficeNationalAssociationId": "1385020"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29875583')"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25201
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "29875084"
+"ListingId": "40836738"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T15:11:08Z"
+"RFModificationTimestamp": "2026-06-09T15:13:27Z"
+"ListPrice": 1450000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3118.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0E7"
+"UnparsedAddress": "787 SNOWBERRY Court, Waterloo, Ontario N2V0E7"
+"Coordinates": array:2 [
0 => -80.6023791
1 => 43.4621044
]
+"Latitude": 43.4621044
+"Longitude": -80.6023791
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A great house in an equally great neighborhood! 787 Snowberry court is one of the few walkout lots on the quiet court in Vista Hills: a neighborhood emersed into nature surrounded by forests of walking trails and some of the top-rated schools in the region. This classic all brick and stone 2 story has beautiful curb appeal, further enhanced by its interlocking driveway and armour stone accents. The double front doors open to a large foyer; adjacent to it is the living room/office, a formal space at the front of the home. The main level was designed around an open spiral oak staircase providing a stunning centre piece that elegantly connects the main floor to the second. The flooring throughout the main is a combination of modern 12x24 tile and wide plank engineered hardwood. The design flows freely through the dining room, over sized kitchen, and dinette overlooking the fully fenced yard complete with composite fencing. The kitchen features abundant cabinet space, built-in stainless-steel appliances, and quartz countertops. The family room sits adjacent and showcases a beautiful fireplace feature wall with staggered floating shelves. The sunken mudroom achieves a partial separation from the main level and is an extremely practical space for access to and from the garage with groceries and preparations. Hardwood flooring continues to finish the space in the high traffic hallway of the second floor. Four bedrooms, 3 bathrooms and a conveniently located laundry make up the second-floor space. The primary bedroom sits at the back of the home and features a walk-in closet with elegant 5 piece ensuite; complete with glass shower and soaker tub. The second bedroom also features a private 3 piece ensuite with glass shower, leaving the 3rd and 4th bedrooms sharing a 5-piece jack and jill bathroom with all the vanities in the home finished in quartz. The basement is ready for your imagination; large windows and large footprint provide lots of finishing options! Don't miss it! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T15:13:19.628518+00:00"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1836163"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T14:02:32Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T15:00:34Z"
+"Stories": "2.0"
+"StreetName": "SNOWBERRY"
+"StreetNumber": "787"
+"StreetSuffix": "Court"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "10383.89"
+"VirtualTourURLUnbranded": "https://youtu.be/Vn1tecMngZM"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29875084/787-snowberry-court-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1563584"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76789"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 46.0
+"AboveGradeFinishedArea": 3118
+"OriginalEntryTimestamp": "2026-06-09T14:02:32.4Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1197077"
+"ListOfficeNationalAssociationId": "1384313"
+"CoListAgentNationalAssociationId": "1143001"
+"CoListOfficeNationalAssociationId": "1004357"
+"Media": array:45 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29875084')"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25202
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "29870543"
+"ListingId": "40836542"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T17:35:40Z"
+"RFModificationTimestamp": "2026-06-08T19:11:24Z"
+"ListPrice": 1400000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2658.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B4"
+"UnparsedAddress": "239 BUTTONBUSH Street, Waterloo, Ontario N2V0B4"
+"Coordinates": array:2 [
0 => -80.5915277
1 => 43.4499496
]
+"Latitude": 43.4499496
+"Longitude": -80.5915277
+"YearBuilt": 2014
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 239 Buttonbush Street, a stunning executive home in Waterloo’s desirable Vista Hills neighbourhood. This home offers the perfect blend of elegance, comfort, and everyday family functionality. Bright, and inviting, the main floor features beautiful new hardwood flooring and an open-concept layout designed for connection. Whether you’re hosting friends or gathering for a family meal, the spacious living and dining area brings everyone together. The elegant kitchen is the heart of the home, with stone countertops and a custom pantry. For added convenience, the main floor includes a large, dedicated laundry room and a powder room. Upstairs, five large bedrooms offer great flexibility for growing families and can also serve as a home office. The primary bedroom feels like a private retreat, with a large walk-in closet and a spa-like ensuite. You'll appreciate the stand-up shower on hectic mornings, and the soaker tub will be your sanctuary for relaxation following a strenuous day. This finished basement provides versatility for a fitness space, rec room, or guest suite and includes a full bathroom. You will appreciate the opportunity to customize this lower level to your needs. Step outside to your private backyard oasis! An incredible lot like this is difficult to find in the city! Perfect for lounging, dining, and entertaining, you will enjoy hot summer days cooling off in the spa pool or crisp, Fall mornings sipping coffee. The electric awning feature gives you the choice to have more shade or sun. Located in the prestigious and quiet Vista Hills neighbourhood, this home is close to excellent schools, parks, and amenities. Just minutes away, you will love the convenient proximity to Costco and all the dining, shopping and daily essentials of the bustling Boardwalk. This is a wonderful opportunity to own a thoughtfully designed family home in one of Waterloo’s most sought-after communities. Your home search stops here! Book your private showing today! (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Central Vacuum - Roughed In"
6 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-08T19:10:25.408971+00:00"
+"Directions": "Ladyslipper Drive / Buttonbush Street"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2025082"
+"ListOfficeKey": "291822"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-08T17:02:41Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T17:02:41Z"
+"Stories": "2.0"
+"StreetName": "BUTTONBUSH"
+"StreetNumber": "239"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "7879.08"
+"VirtualTourURLUnbranded": "https://youtu.be/7S_lr6SQODU"
+"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/29870543/239-buttonbush-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1989189"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "292624"
+"GeocodeManualYN": true
+"ZoningDescription": "R6-S"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 34.0
+"AboveGradeFinishedArea": 2658
+"OriginalEntryTimestamp": "2026-06-08T17:02:41.15Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1304786"
+"ListOfficeNationalAssociationId": "1405037"
+"CoListAgentNationalAssociationId": "1273184"
+"CoListOfficeNationalAssociationId": "1414872"
+"Media": array:45 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29870543')"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25203
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "29869912"
+"ListingId": "40837561"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T16:11:05Z"
+"RFModificationTimestamp": "2026-06-08T16:42:46Z"
+"ListPrice": 1050000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2752.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2Y2"
+"UnparsedAddress": "729 KEATS Way, Waterloo, Ontario N2T2Y2"
+"Coordinates": array:2 [
0 => -80.5790861
1 => 43.4543598
]
+"Latitude": 43.4543598
+"Longitude": -80.5790861
+"YearBuilt": 2004
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to desirable Clair Hills, one of Waterloo's most sought-after family neighborhoods! Ideally located near The Boardwalk, top-rated schools, parks, and the trails of Columbia Forest Pride of ownership is evident throughout this well-maintained home; A standout feature is the rare 700+ sq. ft. finished third-floor loft, offering incredible flexibility as a home office, studio, gym, media room, playroom, or additional living space. The updated kitchen features two-tone cabinetry, quartz countertops, stylish backsplash, under-cabinet lighting, and a modern induction stove, with the existing gas hookup retained for future flexibility. Recent UPDATES INLCUDE : upper-level hardwood flooring, updated bathroom vanities, upgraded lighting, built-in second-floor cabinetry, fresh paint throughout, and a new heat pump installed in 2025 for efficient cooling and comfort. In the backyard, enjoy a private deck and mature setting perfect for summer barbecues or relaxing evenings. With generous room sizes, a double garage, and a unique bonus loft rarely found in today's homes, this is an exceptional opportunity in a highly desirable Waterloo community. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Ductless"
]
+"CreationDate": "2026-06-08T16:42:33.775790+00:00"
+"Directions": "Erbsville to Keats Way"
+"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": "1600675"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-08T16:00:25Z"
+"PhotosCount": 27
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T16:00:25Z"
+"Stories": "3.0"
+"StreetName": "KEATS"
+"StreetNumber": "729"
+"StreetSuffix": "Way"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "6760.26"
+"VirtualTourURLUnbranded": "https://youriguide.com/a636k_729_keats_way_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29869912/729-keats-way-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2752
+"OriginalEntryTimestamp": "2026-06-08T16:00:25.17Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1150112"
+"ListOfficeNationalAssociationId": "1473831"
+"Media": array:27 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29869912')"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25204
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "29869595"
+"ListingId": "40837497"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T16:11:05Z"
+"RFModificationTimestamp": "2026-06-08T16:12:15Z"
+"ListPrice": 1249900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2550.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0H1"
+"UnparsedAddress": "375 CHOKECHERRY Crescent, Waterloo, Ontario N2V0H1"
+"Coordinates": array:2 [
0 => -80.5929567
1 => 43.452034
]
+"Latitude": 43.452034
+"Longitude": -80.5929567
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Fully loaded with upgrades and featuring a WALKOUT BASEMENT, this impressive executive home offers over 2,500 square feet of beautifully designed living space in one of Waterloo's most sought-after family communities, Vista Hills . This contemporary thoughtfully designed main floor showcases 9-foot ceilings, a spacious family room with hardwood flooring, and a stunning kitchen complete with quartz countertops, a large island, and breakfast bar seating—perfect for everyday living and entertaining. A convenient main floor laundry room, mudroom, custom zebra blinds, and pot lights throughout add both style and functionality. The fully fenced backyard is an added bonus for families, children, and pets. Upstairs, all four bedrooms enjoy ensuite privilege, providing exceptional comfort for family and guests. 3 FULL BATHROOMS on the upper level make this home ideal for a growing family. The spacious primary suite features a large walk-in closet, private balcony access, and a luxurious ensuite with double sinks, a deep soaker tub, and an oversized glass shower. Three additional generously sized bedrooms are complemented by their own bathroom access. The unfinished walkout basement offers outstanding future potential, whether for an in-law setup, multigenerational living, or a spacious recreation room. Large windows and double sliding doors flood the space with natural light and provide direct access to the backyard. Ideally located just steps to schools, parks, trails, direct University of Waterloo transit, Costco, shopping, restaurants, and all the conveniences of the Ira Needles corridor, this exceptional home combines luxury, space, and an unbeatable location. Additional features include an electric vehicle charger rough-in, offering added convenience and future-ready functionality for today's homeowner. Some photos virtually staged. (id:62650)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
5 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Contemporary"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-08T16:12:05.476358+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1600661"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-08T15:20:52Z"
+"PhotosCount": 27
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T16:00:26Z"
+"Stories": "2.0"
+"StreetName": "CHOKECHERRY"
+"StreetNumber": "375"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "7549"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29869595/375-chokecherry-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2550
+"OriginalEntryTimestamp": "2026-06-08T15:20:52.51Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1155649"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:27 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29869595')"
}
]
+success: true
+page_size: 9
+page_count: 9
+count: 75
+after_key: ""
}
]
]