array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29989099 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23444
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23446
+post_id: "1593233"
+post_author: 1
+"ListingKey": "29989099"
+"ListingId": "40844983"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T15:35:15Z"
+"RFModificationTimestamp": "2026-07-04T15:54:26Z"
+"ListPrice": 1139900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2550.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G2"
+"UnparsedAddress": "573 MAYAPPLE Street, Waterloo, Ontario N2V0G2"
+"Coordinates": array:2 [
0 => -80.5992488
1 => 43.4588412
]
+"Latitude": 43.4588412
+"Longitude": -80.5992488
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rarely offered former model home stands out as one of the most desirable family residences within the prestigious Vista Hills Public School boundary. Boasting striking modern exterior with stone, brick, and stucco accents, undeniable Luxury curb appeal on both sides of Mayapple St & Canada Plum St. Step inside, the home is filled with premium upgrades and thoughtful design elements, this is the turnkey opportunity that today’s buyers have been waiting for. Flooded with natural light from east to west, the home offers an elevated living experience. Warm morning sun and calm, cinematic evening light naturally bring the family together. The open-concept main floor boasts 9-foot ceilings, a convenient powder room and laundry room with soaring 11.5' high ceilings. An upgraded chef’s kitchen with a massive central island—the ultimate hub for daily family life. Upstairs, you’ll find 4 spacious bedrooms and 2 full bathrooms, including a spa-inspired primary suite with a beautifully tiled glass walk-in shower. The unspoiled basement provides lots of storage spaces. Double car garage plus double decorative exposed aggregate concrete driveway. Near Vista Hill Public School, Costco, Long Hiking Trails, and a short drive to both Universities and all other amenities. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-04T13:50:06.846491+00:00"
+"Directions": "Sundew Dr to Mayapple St"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1970409"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Crushed stone driveway"
1 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-04T15:31:45Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T15:31:45Z"
+"Stories": "2.0"
+"StreetName": "MAYAPPLE"
+"StreetNumber": "573"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "8069"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/573-Mayapple-St"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1675013965"
"RoomType" => "Full bathroom"
"ListingId" => "40844983"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29989099"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 14'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T15:29:02.76Z"
]
1 => array:11 [
"RoomKey" => "1675013966"
"RoomType" => "Bedroom"
"ListingId" => "40844983"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29989099"
"RoomLength" => null
"RoomDimensions" => "18'6'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T15:29:02.76Z"
]
2 => array:11 [
"RoomKey" => "1675013967"
"RoomType" => "Bedroom"
"ListingId" => "40844983"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29989099"
"RoomLength" => null
"RoomDimensions" => "17'2'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T15:29:02.76Z"
]
3 => array:11 [
"RoomKey" => "1675013968"
"RoomType" => "Bedroom"
"ListingId" => "40844983"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29989099"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T15:29:02.76Z"
]
4 => array:11 [
"RoomKey" => "1675013969"
"RoomType" => "5pc Bathroom"
"ListingId" => "40844983"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29989099"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T15:29:02.76Z"
]
5 => array:11 [
"RoomKey" => "1675013970"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844983"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29989099"
"RoomLength" => null
"RoomDimensions" => "16'4'' x 16'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T15:29:02.77Z"
]
6 => array:11 [
"RoomKey" => "1675013971"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844983"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29989099"
"RoomLength" => null
"RoomDimensions" => "3'2'' x 8'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T15:29:02.77Z"
]
7 => array:11 [
"RoomKey" => "1675013972"
"RoomType" => "Laundry room"
"ListingId" => "40844983"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29989099"
"RoomLength" => null
"RoomDimensions" => "7'4'' x 15'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T15:29:02.77Z"
]
8 => array:11 [
"RoomKey" => "1675013973"
"RoomType" => "Dining room"
"ListingId" => "40844983"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29989099"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T15:29:02.77Z"
]
9 => array:11 [
"RoomKey" => "1675013974"
"RoomType" => "Kitchen"
"ListingId" => "40844983"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29989099"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 15'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T15:29:02.77Z"
]
10 => array:11 [
"RoomKey" => "1675013975"
"RoomType" => "Living room"
"ListingId" => "40844983"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29989099"
"RoomLength" => null
"RoomDimensions" => "14'4'' x 17'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T15:29:02.77Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29989099/573-mayapple-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "NR-SL"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 44.0
+"AboveGradeFinishedArea": 2550
+"OriginalEntryTimestamp": "2026-07-04T12:28:39.53Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1257707"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:40 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29989099_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/6de44c5a73ffcb5cc1d159624a61c13e.webp"
"MediaSize" => 94500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-6de44c5a73ffcb5cc1d159624a61c13e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary residence featuring a stone and stucco facade"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T12:28:39.55Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29989099_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/781ba8a217c5a1fe4b92e1752a2d9b29.webp"
"MediaSize" => 104053
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-781ba8a217c5a1fe4b92e1752a2d9b29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary exterior featuring a combination of stone veneer and stucco finishes"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T12:28:39.55Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29989099_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/e212a9e12bd41412506c78a48e942c2f.webp"
"MediaSize" => 121374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-e212a9e12bd41412506c78a48e942c2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary exterior with stone and stucco finishes"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T12:28:39.55Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29989099_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/9880a1b78644fbbae5d438995749bdbf.webp"
"MediaSize" => 105470
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-9880a1b78644fbbae5d438995749bdbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern two-story residence featuring a stone and stucco exterior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T12:28:39.55Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29989099_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/da18e79f8852d953d7cd1f2aed5ab1c4.webp"
"MediaSize" => 141879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-da18e79f8852d953d7cd1f2aed5ab1c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T12:28:39.55Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29989099_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/6187ac7c5ebbc4140900a512b6edd2eb.webp"
"MediaSize" => 120856
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-6187ac7c5ebbc4140900a512b6edd2eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exterior entry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:40.18Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29989099_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/418fefa8e4b06020fa04bd5f788a6473.webp"
"MediaSize" => 86718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-418fefa8e4b06020fa04bd5f788a6473.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a white paneled door with frosted glass inserts and a clear transom window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:40.18Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29989099_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/9fece3c981513c75d9f79f63bad20a00.webp"
"MediaSize" => 85928
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-9fece3c981513c75d9f79f63bad20a00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:39.81Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29989099_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/7f5d7b08cea0d72d122d4b98f782c5d5.webp"
"MediaSize" => 77855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-7f5d7b08cea0d72d122d4b98f782c5d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring wood-finish flooring, recessed lighting, and a contemporary chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:40.24Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29989099_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/86938b6d2e4ca0b2df30c0698e88a93e.webp"
"MediaSize" => 83727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-86938b6d2e4ca0b2df30c0698e88a93e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring recessed lighting, a chandelier, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:40.18Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29989099_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/c423166ecc35662e326f1b50eb087a87.webp"
"MediaSize" => 83797
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-c423166ecc35662e326f1b50eb087a87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring, recessed lighting, and contemporary light fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:39.81Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29989099_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/6bd928e72be6c84a52da5ef388e63160.webp"
"MediaSize" => 77556
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-6bd928e72be6c84a52da5ef388e63160.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring dark grey flat-panel cabinetry and stainless steel appliances"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:41.71Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29989099_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/427e49465f84c77b4a3ae54e7d791954.webp"
"MediaSize" => 76429
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-427e49465f84c77b4a3ae54e7d791954.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring a large island with a speckled countertop, gray cabinetry, stainless steel appliances, and a unique tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:43.22Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29989099_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/4dd2f0bd33588d0d229e3e9656f5d117.webp"
"MediaSize" => 81980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-4dd2f0bd33588d0d229e3e9656f5d117.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring grey cabinetry, stainless steel appliances, patterned tile backsplash, white countertops, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:40.18Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29989099_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/645c86e4aaec4169901505d913e0e891.webp"
"MediaSize" => 87402
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-645c86e4aaec4169901505d913e0e891.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen island with a light-toned countertop, under-mount sink, and two pendant light fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:41.59Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29989099_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/1da963dd0bff927e966b9f260618b0aa.webp"
"MediaSize" => 83936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-1da963dd0bff927e966b9f260618b0aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space with wood-finish flooring, recessed lighting, and large windows with vertical blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:43.23Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29989099_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/20716a6f2f973d0348f30cdd66e5962f.webp"
"MediaSize" => 86999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-20716a6f2f973d0348f30cdd66e5962f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring wood-finish flooring, a contemporary chandelier, and a geometric-patterned accent wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:41.59Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29989099_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/2b636b978cbe274a1c5923605204dc96.webp"
"MediaSize" => 90972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-2b636b978cbe274a1c5923605204dc96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept dining area featuring wood-finish flooring, a contemporary chandelier, and geometric pattern wall covering"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:45.69Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29989099_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/079ba5012d2b80f4f79d3197b3614c99.webp"
"MediaSize" => 62864
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-079ba5012d2b80f4f79d3197b3614c99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom vanity featuring a white oval sink, chrome faucet, and speckled countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:43.45Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29989099_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/41e2782ff6340da6f3c66a852d01bb4a.webp"
"MediaSize" => 40961
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-41e2782ff6340da6f3c66a852d01bb4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry area featuring a built-in countertop with an undermount sink, dark wood-grain cabinetry, and light-toned tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:43.45Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29989099_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/1d16e3cb81103534c1bacacd8d8b3dab.webp"
"MediaSize" => 72060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-1d16e3cb81103534c1bacacd8d8b3dab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious landing area featuring wood-finish flooring, a dark banister, recessed lighting, and light gray wall paint"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:43.45Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29989099_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/d1c9877d39263c6a89369a1322bf1c5d.webp"
"MediaSize" => 75908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-d1c9877d39263c6a89369a1322bf1c5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, recessed ceiling lighting, and a modern ceiling fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:43.45Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29989099_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/4c257df589d8827c7fcec57cedcfc6b5.webp"
"MediaSize" => 72739
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-4c257df589d8827c7fcec57cedcfc6b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, light gray wall paint, and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:41.59Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29989099_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/baf5d4765fc4582507bbf89afb791432.webp"
"MediaSize" => 68671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-baf5d4765fc4582507bbf89afb791432.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a double vanity with wood-finish cabinetry, a large frameless mirror, and a glass-enclosed shower with tiled walls and a rain showerhead"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:41.59Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29989099_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/e98a1aaf00a5bcb46dd0c59e5f659e52.webp"
"MediaSize" => 70662
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-e98a1aaf00a5bcb46dd0c59e5f659e52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Built-in soaking tub with chrome fixtures, surrounded by light-toned tilework"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:41.59Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29989099_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/9715191e3503faefcbb310570848cdb0.webp"
"MediaSize" => 114796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-9715191e3503faefcbb310570848cdb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring a prominent exposed brick accent wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:43.45Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29989099_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/ba4c316a40132fefc5dcc32d9eaf7a31.webp"
"MediaSize" => 84938
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-ba4c316a40132fefc5dcc32d9eaf7a31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, multiple windows with blinds, light neutral wall tones, and a contemporary ceiling light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:43.23Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29989099_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/acdd70cbc2275802633cb3796d450701.webp"
"MediaSize" => 89710
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-acdd70cbc2275802633cb3796d450701.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light wood-finish flooring complements a feature wall with exposed brick-style detailing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:41.61Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29989099_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/beaaebd80aa19952deb0ba9e1bd25be0.webp"
"MediaSize" => 64573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-beaaebd80aa19952deb0ba9e1bd25be0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright room featuring light wood-finish flooring, multiple windows, and a flush mount ceiling light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:41.59Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29989099_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/2ed4ece8f6dcfe41088fe7f5a7b381b3.webp"
"MediaSize" => 75341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-2ed4ece8f6dcfe41088fe7f5a7b381b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, a contemporary drum light fixture, and a neutral color palette"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:45.82Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29989099_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/0b14a399600a9514593525eb1b0ede7f.webp"
"MediaSize" => 66788
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-0b14a399600a9514593525eb1b0ede7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, light grey wall paint, and double panel doors with matte black hardware"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:41.58Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29989099_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/a44131e03d22858523058edd8b91dec7.webp"
"MediaSize" => 79463
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-a44131e03d22858523058edd8b91dec7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Double vanity with undermount sinks and light-toned countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:43.45Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29989099_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/db0d9fea414dc9d9f70c4980041cf41e.webp"
"MediaSize" => 63528
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-db0d9fea414dc9d9f70c4980041cf41e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, a window with white trim, a decorative light fixture, and neutral wall tones"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:41.58Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29989099_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/dcb66553c67dda27de73bcf5f23f90e5.webp"
"MediaSize" => 100087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-dcb66553c67dda27de73bcf5f23f90e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfinished basement featuring exposed wood joists, concrete flooring, and insulated walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:41.62Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29989099_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/c92ac830b6aadb67cfdd1964c0471fc7.webp"
"MediaSize" => 100791
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-c92ac830b6aadb67cfdd1964c0471fc7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfinished basement space featuring exposed wood framing, concrete flooring, and visible ductwork"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:43.45Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29989099_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/60118205ff68861b2b4ef5a767150b1c.webp"
"MediaSize" => 107001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-60118205ff68861b2b4ef5a767150b1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious unfinished basement featuring exposed wood joists, concrete flooring, and insulated walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:41.62Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29989099_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/2fc9a33a905e67fc3f1387a47ea226bf.webp"
"MediaSize" => 124722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-2fc9a33a905e67fc3f1387a47ea226bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rear exterior showcasing a two-story design with gray brick siding and dark-trimmed windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:45.82Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29989099_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/dbc34e73fd77e62c093b8ba30a2fa294.webp"
"MediaSize" => 135529
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-dbc34e73fd77e62c093b8ba30a2fa294.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Grey brick exterior with multiple windows, featuring a sliding glass door with external steps leading to a green lawn"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:43.45Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29989099_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/315497cc54807cd41287a7ef7fede497.webp"
"MediaSize" => 19905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-315497cc54807cd41287a7ef7fede497.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:41.58Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29989099_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989099/5dfa61509cbcc2bb3aba1a9e2397541f.webp"
"MediaSize" => 24151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989099/thumbnail-5dfa61509cbcc2bb3aba1a9e2397541f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844983"
"ResourceRecordKey" => "29989099"
"ModificationTimestamp" => "2026-07-04T15:31:41.61Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29989099')"
+"ID": "1593233"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 295659" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24904
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1970409" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24862
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29989099'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25259
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29989099'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25275
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29989099' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5992488 43.4588412)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25348
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25322
+post_id: "1590429"
+post_author: 1
+"ListingKey": "29986610"
+"ListingId": "40844919"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T19:25:11Z"
+"RFModificationTimestamp": "2026-07-03T20:06:53Z"
+"ListPrice": 927500.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2692.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V6"
+"UnparsedAddress": "439 WOODROW Drive, Waterloo, Ontario N2T2V6"
+"Coordinates": array:2 [
0 => -80.5847827
1 => 43.4697703
]
+"Latitude": 43.4697703
+"Longitude": -80.5847827
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled in Waterloo's highly sought after Laurelwood neighbourhood, this beautifully renovated backsplit offers the perfect balance of modern updates, functional living space, and an incredible outdoor retreat. Every level of this home has been thoughtfully updated, making it truly move in ready. The beautifully designed kitchen (2016) serves as the heart of the home, showcasing quartz countertops, a spacious centre island, and abundant cabinetry. Whether you're preparing family meals or hosting friends, the open layout seamlessly connects the kitchen to the bright living and dining areas, creating an ideal space for everyday living and entertaining. A few steps down, the inviting family room is the perfect place to unwind, featuring a stylish gas fireplace with a custom mantel (2021) and patio doors that open to your own private backyard sanctuary. Enjoy beautifully landscaped perennial gardens, a charming gazebo, and an outdoor BBQ with prep station all included creating an exceptional setting for summer gatherings or peaceful evenings outdoors. The lower level features a flexible fourth bedroom or home office, a beautifully updated 3 piece bathroom (2018), a convenient laundry room, and direct access to the side entrance. The fully finished basement provides more living space with a generous recreation room, utility area, and extensive storage options to meet the needs of a growing family. Upstairs, you'll find three spacious bedrooms, including a relaxing primary retreat, along with a tastefully renovated 4npiece bathroom (2020). Additional features include a double car garage with EV charger rough in, a concrete driveway accommodating 4 vehicles, and quality finishes throughout. Ideally situated close to excellent schools, parks, scenic walking trails, shopping, universities, and all the amenities Waterloo has to offer, this exceptional Laurelwood home delivers the perfect combination of comfort, style, and location. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T20:06:47.479378+00:00"
+"Directions": "Laurelwood to Old Oak Dr to Woodrow Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1958320"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Gazebo"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T19:18:19Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T19:18:19Z"
+"Stories": "3.0"
+"StreetName": "WOODROW"
+"StreetNumber": "439"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5946"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/439_woodrow_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1674342406"
"RoomType" => "Storage"
"ListingId" => "40844919"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "15'1'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.18Z"
]
1 => array:11 [
"RoomKey" => "1674342407"
"RoomType" => "Utility room"
"ListingId" => "40844919"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.18Z"
]
2 => array:11 [
"RoomKey" => "1674342408"
"RoomType" => "Storage"
"ListingId" => "40844919"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "3'3'' x 4'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.18Z"
]
3 => array:11 [
"RoomKey" => "1674342409"
"RoomType" => "Recreation room"
"ListingId" => "40844919"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "14'7'' x 18'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.18Z"
]
4 => array:11 [
"RoomKey" => "1674342410"
"RoomType" => "Laundry room"
"ListingId" => "40844919"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "7'7'' x 6'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.18Z"
]
5 => array:11 [
"RoomKey" => "1674342411"
"RoomType" => "3pc Bathroom"
"ListingId" => "40844919"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 7'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.19Z"
]
6 => array:11 [
"RoomKey" => "1674342412"
"RoomType" => "Bedroom"
"ListingId" => "40844919"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "8'9'' x 14'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.19Z"
]
7 => array:11 [
"RoomKey" => "1674342413"
"RoomType" => "Family room"
"ListingId" => "40844919"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "20'5'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.19Z"
]
8 => array:11 [
"RoomKey" => "1674342414"
"RoomType" => "Bedroom"
"ListingId" => "40844919"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.19Z"
]
9 => array:11 [
"RoomKey" => "1674342415"
"RoomType" => "Bedroom"
"ListingId" => "40844919"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.19Z"
]
10 => array:11 [
"RoomKey" => "1674342416"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844919"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.19Z"
]
11 => array:11 [
"RoomKey" => "1674342417"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844919"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.19Z"
]
12 => array:11 [
"RoomKey" => "1674342418"
"RoomType" => "Eat in kitchen"
"ListingId" => "40844919"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "15'8'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.19Z"
]
13 => array:11 [
"RoomKey" => "1674342419"
"RoomType" => "Dining room"
"ListingId" => "40844919"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 13'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.19Z"
]
14 => array:11 [
"RoomKey" => "1674342420"
"RoomType" => "Living room"
"ListingId" => "40844919"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "12'3'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.19Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29986610/439-woodrow-drive-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1564580"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2037
+"BelowGradeFinishedArea": 655
+"OriginalEntryTimestamp": "2026-07-03T19:18:19.14Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1249173"
+"ListOfficeNationalAssociationId": "1389824"
+"CoListAgentNationalAssociationId": "1069941"
+"CoListOfficeNationalAssociationId": "1004387"
+"Media": array:40 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29986610_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986610/539a2e99ee2e3ee4d35a9de0a180f175.webp"
"MediaSize" => 134626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986610/thumbnail-539a2e99ee2e3ee4d35a9de0a180f175.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844919"
"ResourceRecordKey" => "29986610"
"ModificationTimestamp" => "2026-07-03T19:18:19.15Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29986610_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986610/f4436c0042a72da114488be1e56f72a3.webp"
"MediaSize" => 170390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986610/thumbnail-f4436c0042a72da114488be1e56f72a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844919"
"ResourceRecordKey" => "29986610"
"ModificationTimestamp" => "2026-07-03T19:18:19.15Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29986610_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986610/02ada643367467588537eaa0811b334a.webp"
"MediaSize" => 139605
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986610/thumbnail-02ada643367467588537eaa0811b334a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844919"
"ResourceRecordKey" => "29986610"
"ModificationTimestamp" => "2026-07-03T19:18:19.15Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29986610_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986610/df08876de49ef37d0340e96b2b760c17.webp"
"MediaSize" => 120008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986610/thumbnail-df08876de49ef37d0340e96b2b760c17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844919"
"ResourceRecordKey" => "29986610"
"ModificationTimestamp" => "2026-07-03T19:18:19.15Z"
]
4 => array:13 [
"Order" => 5
…12
]
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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986610')"
+"ID": "1590429"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25324
+post_id: "1589222"
+post_author: 1
+"ListingKey": "29984123"
+"ListingId": "40843883"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-05T18:25:14Z"
+"RFModificationTimestamp": "2026-07-05T18:29:33Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2618.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2T8"
+"UnparsedAddress": "569 VIOLET Street, Waterloo, Ontario N2V2T8"
+"Coordinates": array:2 [
0 => -80.5958904
1 => 43.4687764
]
+"Latitude": 43.4687764
+"Longitude": -80.5958904
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 569 Violet Street, where comfort, space, and an incredible family-friendly location come together in one of Waterloo's most sought-after neighbourhoods. This beautifully maintained 4-bedroom home offers the flexibility today's families are looking for, with an additional upper-level room that can easily serve as a fourth bedroom, home office, playroom, or be converted back into a spacious family room. The primary suite is a true retreat, featuring a stunning brand-new ensuite and a generous walk-in closet designed for everyday comfort. The bright, functional main floor is perfect for both entertaining and daily living, with the kitchen (updated in 2022) opening onto a spacious deck overlooking the peaceful green space behind the home. Whether you're enjoying your morning coffee, hosting summer barbecues, or simply unwinding at the end of the day, the private backdrop of the Columbia Forest trail system creates a setting that's hard to beat. Downstairs, the finished walkout basement adds exceptional versatility with direct access to the backyard as well as a separate entrance through the garage, making it an excellent opportunity for multi-generational living or future in-law suite potential. Location is everything, and this home delivers. You're just a short walk to Abraham Erb Public School and Laurel Heights Secondary School, with scenic walking trails, parks, a newer splash pad, shopping, restaurants, the YMCA, public library, transit, and both universities all within easy reach. This is a neighbourhood known for its outstanding schools, beautiful green spaces, and welcoming community atmosphere. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T17:11:59.990060+00:00"
+"Directions": "Erbsville to Laurelwood"
+"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": "1921212"
+"ListOfficeKey": "289792"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T14:29:56Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-05T18:18:31Z"
+"Stories": "2.0"
+"StreetName": "VIOLET"
+"StreetNumber": "569"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5900.92"
+"VirtualTourURLUnbranded": "https://youriguide.com/569_violet_street_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29984123/569-violet-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1984162"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "156376"
+"GeocodeManualYN": true
+"ZoningDescription": "FR50"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1836
+"BelowGradeFinishedArea": 782
+"OriginalEntryTimestamp": "2026-07-03T14:29:56.07Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1226897"
+"ListOfficeNationalAssociationId": "1381240"
+"CoListAgentNationalAssociationId": "1268935"
+"CoListOfficeNationalAssociationId": "1003925"
+"Media": array:33 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29984123')"
+"ID": "1589222"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25321
+post_id: "1589037"
+post_author: 1
+"ListingKey": "29984740"
+"ListingId": "X13518228"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T12:15:12Z"
+"RFModificationTimestamp": "2026-07-04T12:16:30Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2T8"
+"UnparsedAddress": "569 VIOLET STREET, Waterloo, Ontario N2V2T8"
+"Coordinates": array:2 [
0 => -80.595899
1 => 43.468787
]
+"Latitude": 43.468787
+"Longitude": -80.595899
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 569 Violet Street, where comfort, space, and an incredible family-friendly location come together in one of Waterloo's most sought-after neighbourhoods. This beautifully maintained 4-bedroom home offers the flexibility today's families are looking for, with an additional upper-level room that can easily serve as a fourth bedroom, home office, playroom, or be converted back into a spacious family room. The primary suite is a true retreat, featuring a stunning brand-new ensuite and a generous walk-in closet designed for everyday comfort. The bright, functional main floor is perfect for both entertaining and daily living, with the kitchen opening onto a spacious deck overlooking the peaceful green space behind the home. Whether you're enjoying your morning coffee, hosting summer barbecues, or simply unwinding at the end of the day, the private backdrop of the Columbia Forest trail system creates a setting that's hard to beat. Downstairs, the finished walkout basement adds exceptional versatility with direct access to the backyard as well as a separate entrance through the garage, making it an excellent opportunity for multi-generational living or future in-law suite potential. Location is everything, and this home delivers. You're just a short walk to Abraham Erb Public School and Laurel Heights Secondary School, with scenic walking trails, parks, a newer splash pad, shopping, restaurants, the YMCA, public library, transit, and both universities all within easy reach. This is a neighbourhood known for its outstanding schools, beautiful green spaces, and welcoming community atmosphere. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener remote(s)"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T16:16:39.552339+00:00"
+"Directions": "Cross Streets: Laurelwood/Erbsville. ** Directions: Erbsville to Laurelwood."
+"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": "2099892"
+"ListOfficeKey": "289816"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Wooded area"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Carpet Free"
4 => "Sump Pump"
]
+"LotSizeDimensions": "30 x 102.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T15:40:19Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T12:07:48Z"
+"Stories": "2.0"
+"StreetName": "Violet"
+"StreetNumber": "569"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5900.92"
+"VirtualTourURLUnbranded": "https://youriguide.com/569_violet_street_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29984740/569-violet-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "FR50"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 30.0
+"OriginalEntryTimestamp": "2026-07-03T15:40:19.68Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1370040"
+"ListOfficeNationalAssociationId": "1381521"
+"Media": array:33 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29984740')"
+"ID": "1589037"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25325
+post_id: "1584801"
+post_author: 1
+"ListingKey": "29978834"
+"ListingId": "40842119"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-05T20:25:17Z"
+"RFModificationTimestamp": "2026-07-05T20:31:49Z"
+"ListPrice": 862900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2677.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2X2"
+"UnparsedAddress": "769 KARLSFELD Road, Waterloo, Ontario N2T2X2"
+"Coordinates": array:2 [
0 => -80.5765401
1 => 43.4553661
]
+"Latitude": 43.4553661
+"Longitude": -80.5765401
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "NO HOLDING OFFERS! Move right into this beautifully updated 3+1 bedroom, 3.5 bathroom family home with a walk-out basement, situated on an impressive 128 ft deep lot in the highly sought-after Clair Hills neighbourhood. The bright & spacious main floor features a large living room with hardwood flooring & an updated kitchen. The open concept formal dining area boasts soaring cathedral ceilings and oversized windows overlooking the expansive, fully fenced, pool-sized backyard. Step out from the dining area onto the newly painted deck—perfect for outdoor dining and entertaining. Upstairs, you'll find three generously sized bedrooms and two beautifully updated full bathrooms. The primary bedroom offers a walk-in closet and a private ensuite, creating a comfortable retreat. The walk-out basement adds exceptional living space with a large 4th bedroom that can also serve as a recreation room, home office, or gym, along with a 4th bathroom for added convenience. Extensive Recent Updates Include: Freshly painted 1st & 2nd floor walls (2026). New 2nd-floor flooring (2026). New hardwood staircase (2026). Newly renovated both 2nd-floor bathrooms (2026). Furnace (2025). AC (2022). Kitchen renovation (2021), including quartz countertops, cabinetry, waterproof vinyl flooring, and stainless steel appliances. All 1st & 2nd-floor triple-pane windows replaced (2019). Roof (2018). Additional attic insulation (2018). Owned hot water heater. The oversized, fully fenced backyard offers plenty of room to install an in-ground pool, making it an ideal space for summer entertaining & family gatherings. Conveniently located within walking distance to schools, parks, and public transit, and just minutes from shopping, The Boardwalk, Costco, the YMCA, both Universities, and situated within the top-ranked Laurel Heights Secondary School boundary. This home offers the perfect combination of modern updates, functional living space, and an unbeatable family-friendly location. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T18:07:27.027947+00:00"
+"Directions": "Keats way and Erbsville Road"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1970409"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T17:32:30Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-05T20:19:17Z"
+"Stories": "2.0"
+"StreetName": "KARLSFELD"
+"StreetNumber": "769"
+"StreetSuffix": "Road"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5096"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/769-KARLSFELD-Road"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29978834/769-karlsfeld-road-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 34.0
+"AboveGradeFinishedArea": 1819
+"BelowGradeFinishedArea": 858
+"OriginalEntryTimestamp": "2026-07-02T16:33:42.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1257707"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29978834')"
+"ID": "1584801"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25323
+post_id: "1582284"
+post_author: 1
+"ListingKey": "29974955"
+"ListingId": "40840178"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-05T20:25:16Z"
+"RFModificationTimestamp": "2026-07-05T20:31:51Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1929.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2W5"
+"UnparsedAddress": "980 CREEKSIDE Drive, Waterloo, Ontario N2V2W5"
+"Coordinates": array:2 [
0 => -80.5995972
1 => 43.4717177
]
+"Latitude": 43.4717177
+"Longitude": -80.5995972
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 980 Creekside Drive, a move-in-ready freehold townhome in Waterloo’s highly sought-after Laurelwood community — an ideal starter home for young families looking to settle near top-rated schools, parks, shopping, and everyday conveniences. This well-maintained 3-bedroom, 3.5-bathroom two-storey home offers a bright and functional open-concept main floor with a carpet-free layout, laminate flooring, and sliding doors leading to a private deck and fully fenced backyard — perfect for children, pets, and outdoor family time. The kitchen features ample cabinetry, stainless steel appliances, and a sleek glass backsplash, creating a practical and inviting space for busy family living. Upstairs, the spacious primary bedroom includes a walk-in closet with organizer and private ensuite, while the additional bedrooms are well-sized for children, guests, or a home office. The fully finished lower level provides valuable extra living space with a recreation room, 3-piece bathroom, laundry area, and storage room — ideal for a playroom, family movie nights, or a flexible work-from-home setup. Located within walking distance to schools, shopping, public transit, and close to the YMCA, universities, The Boardwalk, St. Jacobs Farmers’ Market, and the Waterloo Costco, this home offers the perfect blend of comfort, convenience, and community. A fantastic opportunity for first-time buyers and young families to own a move-in-ready home in one of Waterloo’s most desirable family-friendly neighbourhoods. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T14:51:04.303021+00:00"
+"Directions": "Laurelwood Drive Erbsville Road"
+"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": "2130071"
+"ListOfficeKey": "300812"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T16:40:42Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-05T20:19:40Z"
+"Stories": "2.0"
+"StreetName": "CREEKSIDE"
+"StreetNumber": "980"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "3521"
+"VirtualTourURLUnbranded": "https://realty.pixsouls.com/980-Creekside-Dr"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29974955/980-creekside-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR50"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 22.0
+"AboveGradeFinishedArea": 1408
+"BelowGradeFinishedArea": 521
+"OriginalEntryTimestamp": "2026-07-01T14:10:29.26Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1382995"
+"ListOfficeNationalAssociationId": "1493167"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29974955')"
+"ID": "1582284"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25318
+post_id: "1579538"
+post_author: 1
+"ListingKey": "29971250"
+"ListingId": "40842678"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T16:55:13Z"
+"RFModificationTimestamp": "2026-07-03T17:11:16Z"
+"ListPrice": 539900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1163.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A8"
+"UnparsedAddress": "776 LAURELWOOD Drive Unit# 716, Waterloo, Ontario N2V0A8"
+"Coordinates": array:2 [
0 => -80.5986515
1 => 43.4706239
]
+"Latitude": 43.4706239
+"Longitude": -80.5986515
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Fantastic opportunity to own this one-of-a-kind corner penthouse offering stunning southwest exposure in one of the area's most desirable neighbourhoods, surrounded by conservation lands and top-rated schools. This beautifully updated condo features a renovated kitchen, carpet free flooring, and numerous upgrades throughout. The impressive kitchen boasts an oversized island with white quartz countertops, a modern white subway tile backsplash, under-cabinet lighting, and a walkout to the private balcony, where you can enjoy unobstructed panoramic city views. One of only four units in the building with a cathedral ceiling, this penthouse offers an exceptionally bright, open, and airy living space, with natural light streaming in from windows on multiple sides. The spacious primary bedroom features large windows, a private walkout to the balcony, and an updated ensuite with a glass walk-in shower. The second bedroom is thoughtfully positioned on the opposite side of the unit for added privacy and is complemented by a full 4-piece bathroom. Additional highlights include upgraded interior doors, baseboards, lighting fixtures, two owned underground parking spaces, and an oversized storage locker. Simply move in and enjoy low-maintenance condo living in an exceptional location. Be sure to check out the 360-degree panoramas! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Microwave"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"AssociationFee": "477.11"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T18:23:23.421739+00:00"
+"Directions": "ERBSVILLE ROAD TO LAURELWOOD DRIVE"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2070594"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Balcony"
3 => "Paved driveway"
4 => "Skylight"
5 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-30T17:11:48Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T16:48:39Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "776"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4297"
+"View": "View (panoramic)"
+"VirtualTourURLUnbranded": "https://youriguide.com/716_776_laurelwood_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29971250/776-laurelwood-drive-unit-716-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1600658"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "290620"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "MR100"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1163
+"OriginalEntryTimestamp": "2026-06-30T17:11:48.13Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1345744"
+"ListOfficeNationalAssociationId": "1004387"
+"CoListAgentNationalAssociationId": "1153962"
+"CoListOfficeNationalAssociationId": "1389824"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29971250')"
+"ID": "1579538"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23458
+post_id: "1574246"
+post_author: 1
+"ListingKey": "29963571"
+"ListingId": "40840611"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T16:25:15Z"
+"RFModificationTimestamp": "2026-07-04T16:26:42Z"
+"ListPrice": 549000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1482.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2X1"
+"UnparsedAddress": "619 WILD GINGER Avenue Unit# H45, Waterloo, Ontario N2V2X1"
+"Coordinates": array:2 [
0 => -80.5941875
1 => 43.469623
]
+"Latitude": 43.469623
+"Longitude": -80.5941875
+"YearBuilt": 2006
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to easy living in this spacious four level townhome offering a thoughtful layout and plenty of flexible space. The main level features a bright kitchen and dining area with access to a front balcony, perfect for morning coffee or summer BBQs. A convenient two piece bathroom and inviting living room overlook the private backyard, creating a comfortable space for everyday living and entertaining. Upstairs, you'll find two generously sized bedrooms and a full bathroom. The lower level rec room provides additional living space and could easily serve as a third bedroom, home office, or family room. Step outside from this level onto the deck and enjoy the privacy of your own backyard retreat. Laundry is conveniently located just inside the attached garage, adjacent to the rec room. The fourth level offers plenty of storage in the utility room and includes a bathroom rough in, providing potential for future expansion. With an attached garage, multiple outdoor living spaces, and a versatile floor plan, this home is an excellent opportunity for first-time buyers, downsizers, or investors alike. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
]
+"AssociationFee": "258"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Property Management"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-28T04:35:40.657011+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1978914"
+"ListOfficeKey": "283168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-28T01:21:05Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T16:18:45Z"
+"Stories": "3.0"
+"StreetName": "WILD GINGER"
+"StreetNumber": "619"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3685"
+"VirtualTourURLUnbranded": "https://youriguide.com/h45_619_wild_ginger_ave_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/29963571/619-wild-ginger-avenue-unit-h45-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2161263"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "283168"
+"GeocodeManualYN": true
+"ZoningDescription": "70-RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1482
+"OriginalEntryTimestamp": "2026-06-28T01:21:04.9Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1264841"
+"ListOfficeNationalAssociationId": "1325206"
+"CoListAgentNationalAssociationId": "1412362"
+"CoListOfficeNationalAssociationId": "1325206"
+"Media": array:35 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29963571')"
+"ID": "1574246"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25326
+post_id: "1574187"
+post_author: 1
+"ListingKey": "29963570"
+"ListingId": "40841161"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-05T20:25:14Z"
+"RFModificationTimestamp": "2026-07-05T20:32:14Z"
+"ListPrice": 539900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1800.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2P7"
+"UnparsedAddress": "350 ERBSVILLE Road Unit# 3, Waterloo, Ontario N2T2P7"
+"Coordinates": array:2 [
0 => -80.5789343
1 => 43.4607288
]
+"Latitude": 43.4607288
+"Longitude": -80.5789343
+"YearBuilt": 1994
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "There’s a reason people hold onto these units for an average of 25 years. If you’ve been looking for that perfect middle ground, more space than a starter home, a backyard that’s actually private, and a neighbourhood where kids still ride their bikes to the park, this is it. The main floor is designed for how families actually live. Flowing naturally from a bright living room into the kitchen and dining area White shaker cabinetry, stainless steel appliances, and sliding doors out to the yard. Upstairs, you’ll find three genuinely spacious bedrooms. The primary bedroom easily fits a king-sized bed and offers ensuite privilege to a bright, updated 5-piece bathroom. Need a playroom, a home office, or just somewhere to send the kids when they’re being loud? The fully finished basement has you covered. It features a massive rec room with pot lights, and a convenient 3-piece bathroom, plus dedicated laundry and storage space. Now, let’s talk about the lifestyle. You’re steps from the Laurel Creek Conservation Area, meaning weekend hikes, canoeing, and trails are practically in your backyard. You’ve got the Stork Family YMCA and the John M. Harper Library just down the street. Need to run errands? The Boardwalk and Costco are minutes away for groceries, and restaurants. Plus, you’re in the catchment for some of the best schools in the region, including Laurel Heights Secondary School. And the best part? The condo fees are only $230 a month, and they’ve barely increased in years. It’s the peace of mind of a well-managed complex with the space and privacy of a freehold feel. If you’re outgrowing your condo or starter home, this is the exact upgrade you’ve been looking for. It’s the perfect blend of space, location, and neighbourhood. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "230"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"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-28T01:52:07.760475+00:00"
+"Directions": "Nearest Intersection: Erbsville Rd & Columbia St. W."
+"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": "2027560"
+"ListOfficeKey": "289848"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-28T01:20:59Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-05T20:19:28Z"
+"Stories": "2.0"
+"StreetName": "ERBSVILLE"
+"StreetNumber": "350"
+"StreetSuffix": "Road"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "3425"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/cjdyt_3_350_erbsville_rd_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/29963570/350-erbsville-road-unit-3-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD-3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1275
+"BelowGradeFinishedArea": 525
+"OriginalEntryTimestamp": "2026-06-28T01:20:58.81Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1306927"
+"ListOfficeNationalAssociationId": "1381908"
+"Media": array:35 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29963570')"
+"ID": "1574187"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25346
+post_id: "1574016"
+post_author: 1
+"ListingKey": "29963363"
+"ListingId": "X13498204"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T18:15:08Z"
+"RFModificationTimestamp": "2026-07-03T18:51:55Z"
+"ListPrice": 537888.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2K7"
+"UnparsedAddress": "3 - 601 COLUMBIA FOREST BOULEVARD, Waterloo, Ontario N2V2K7"
+"Coordinates": array:2 [
0 => -80.5844243
1 => 43.4647062
]
+"Latitude": 43.4647062
+"Longitude": -80.5844243
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this exclusive Columbia Forest Estates enclave of Waterloo! This premium, turn-key townhome offers the perfect blend of modern styling, functional space, & unbeatable location convenience. Step inside to discover a freshly updated, open-concept main level featuring brand-new luxury flooring, modern trim, and an abundance of natural light. The seamlessly connected kitchen/dining area, & inviting living room complete with a cozy gas fireplace creates the ultimate hub for entertaining or everyday family living. The kitchen comes fully equipped with a suite of appliances, including a brand-new refrigerator and over-the-range microwave along with the already existing stainless dishwasher and stove. Upstairs and down, an intelligently designed layout delivers a rare 4-bedroom setup that offers privacy & flexibility. It is perfectly configured with two full 4-piece bathrooms plus a convenient main-floor powder room. The lower level adds immense value, boasting a versatile recreation or home office space, or a separate guest room, and space for dedicated laundry. Step outside to your private backyard with a natural gas hookup for seamless summer BBQs, backing directly onto the scenic Geo-Time Trail network. On top of the premium interior finishes, you will enjoy complete peace of mind with a newer, fully owned furnace and A/C system installed in 2024. Location is everything: you are steps from the region's top-rated elementary and secondary schools, and only minutes from the University Corridor-offering incredible long-term value/appreciation and high-end student occupancy in a premium location. Enjoy rapid access to major highways, the Waterloo Memorial Recreation Complex, RIM Park, Costco, and the vibrant Boardwalk shopping district. Whether you are a growing family or an astute investor looking for a premium asset, this home truly embodies the epitome of convenient modern living. Don't let this rare opportunity pass you by-schedule your private viewing today! (id:62650)"
+"Appliances": array:8 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Range"
4 => "Microwave"
5 => "Window Coverings"
6 => "Garage door opener remote(s)"
7 => "Water Heater"
]
+"AssociationFee": "646"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-27T22:24:30.467157+00:00"
+"Directions": "Cross Streets: Columbia Forest Blvd & Erbsville Rd. ** Directions: Head north on Erbsville Road past Columbia Street West. The complex is located on the left-hand side, immediately at the corner intersection of Erbsville Road and Columbia Forest Boulevard."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Tile"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2209347"
+"ListOfficeKey": "280225"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-27T23:18:05Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:05:47Z"
+"Stories": "3.0"
+"StreetName": "Columbia Forest"
+"StreetNumber": "601"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "3699"
+"VirtualTourURLUnbranded": "https://youtu.be/pXbuepXb0Zc"
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29963363/3-601-columbia-forest-boulevard-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Sanderson Management Inc."
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-27T21:47:19.54Z"
+"ListAgentNationalAssociationId": "1456335"
+"ListOfficeNationalAssociationId": "1310773"
+"Media": array:33 [
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]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29963363')"
+"ID": "1574016"
}
]
+success: true
+page_size: 9
+page_count: 10
+count: 84
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
]