array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29859873 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23332
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23334
+post_id: "1498873"
+post_author: 1
+"ListingKey": "29859873"
+"ListingId": "40837053"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T15:26:00Z"
+"RFModificationTimestamp": "2026-06-05T17:04:20Z"
+"ListPrice": 1083900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3782.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2X9"
+"UnparsedAddress": "512 WOOD NETTLE Way, Waterloo, Ontario N2V2X9"
+"Coordinates": array:2 [
0 => -80.6039602
1 => 43.4724714
]
+"Latitude": 43.4724714
+"Longitude": -80.6039602
+"YearBuilt": 2007
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "NO HOLDING OFFERS. MOVE-IN READY! Beautiful family home in one of Waterloo’s most desirable neighborhoods in Laurelwood, steps to top-ranked schools and bus routes. Spacious 3,782 sq ft comfortable living space with 4+1 bedrooms and 3.5 baths. Main floor boasts 9' ceilings, gleaming hardwood and porcelain tiles, a grand foyer, formal dining room, and a great room with gas fireplace. Gourmet kitchen with stainless appliances and quartz countertops. The spacious breakfast area has a door that opens to a generously sized deck in fully fenced backyard. On the upper level, the large primary suite with walk-in closet and luxurious 5pc en-suite featuring a glass shower and custom whirlpool tub, all other 3 bedrooms are nicely sized, and the main bathroom features double sinks and a large bonus linen cabinet. The fully finished basement (2021) has a mirrored wall great for yoga practice, a large rec room ideal for home theater, and a home gym, and the 5th bedroom can be used as a home office. Recent Updates: Roof (2021), Owned Hot Water Heater (2025), Kitchen Cabinets and Fireplace Professionally Repainted (2026), Added Additional Insulation in Attic (2022), Multiple Modern Light Fixtures Installed (2026). Convenient to Costco, parks, trails, and transit to both universities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T17:04:10.429784+00:00"
+"Directions": "Wideman Rd to Laurelwood Dr To Wood Nettle Way"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1970409"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-05T15:19:24Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T15:19:24Z"
+"Stories": "2.0"
+"StreetName": "WOOD NETTLE"
+"StreetNumber": "512"
+"StreetSuffix": "Way"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "7357"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/512-WOOD-NETTLE-Way"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [
"RoomKey" => "1652392354"
"RoomType" => "Other"
"ListingId" => "40837053"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29859873"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 16'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:19:24.8Z"
]
1 => array:11 [
"RoomKey" => "1652392355"
"RoomType" => "3pc Bathroom"
"ListingId" => "40837053"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29859873"
"RoomLength" => null
"RoomDimensions" => "5'9'' x 6'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:19:24.8Z"
]
2 => array:11 [
"RoomKey" => "1652392356"
"RoomType" => "Family room"
"ListingId" => "40837053"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29859873"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 16'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:19:24.8Z"
]
3 => array:11 [
"RoomKey" => "1652392357"
"RoomType" => "Recreation room"
"ListingId" => "40837053"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29859873"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 22'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:19:24.81Z"
]
4 => array:11 [
"RoomKey" => "1652392358"
"RoomType" => "Bedroom"
"ListingId" => "40837053"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29859873"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:19:24.81Z"
]
5 => array:11 [
"RoomKey" => "1652392359"
"RoomType" => "Bedroom"
"ListingId" => "40837053"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29859873"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 12'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:19:24.81Z"
]
6 => array:11 [
"RoomKey" => "1652392360"
"RoomType" => "Bedroom"
"ListingId" => "40837053"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29859873"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:19:24.81Z"
]
7 => array:11 [
"RoomKey" => "1652392361"
"RoomType" => "Full bathroom"
"ListingId" => "40837053"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29859873"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 14'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:19:24.81Z"
]
8 => array:11 [
"RoomKey" => "1652392362"
"RoomType" => "Primary Bedroom"
"ListingId" => "40837053"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29859873"
"RoomLength" => null
"RoomDimensions" => "14'9'' x 19'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:19:24.81Z"
]
9 => array:11 [
"RoomKey" => "1652392363"
"RoomType" => "5pc Bathroom"
"ListingId" => "40837053"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29859873"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 12'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:19:24.81Z"
]
10 => array:11 [
"RoomKey" => "1652392364"
"RoomType" => "Bedroom"
"ListingId" => "40837053"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29859873"
"RoomLength" => null
"RoomDimensions" => "13'11'' x 12'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:19:24.81Z"
]
11 => array:11 [
"RoomKey" => "1652392365"
"RoomType" => "Foyer"
"ListingId" => "40837053"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859873"
"RoomLength" => null
"RoomDimensions" => "7'7'' x 13'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:19:24.81Z"
]
12 => array:11 [
"RoomKey" => "1652392366"
"RoomType" => "Laundry room"
"ListingId" => "40837053"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859873"
"RoomLength" => null
"RoomDimensions" => "6'4'' x 7'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:19:24.81Z"
]
13 => array:11 [
"RoomKey" => "1652392367"
"RoomType" => "2pc Bathroom"
"ListingId" => "40837053"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859873"
"RoomLength" => null
"RoomDimensions" => "2'11'' x 6'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:19:24.81Z"
]
14 => array:11 [
"RoomKey" => "1652392368"
"RoomType" => "Dining room"
"ListingId" => "40837053"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859873"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:19:24.81Z"
]
15 => array:11 [
"RoomKey" => "1652392369"
"RoomType" => "Living room"
"ListingId" => "40837053"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859873"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 14'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:19:24.81Z"
]
16 => array:11 [
"RoomKey" => "1652392370"
"RoomType" => "Kitchen"
"ListingId" => "40837053"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859873"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 16'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:19:24.81Z"
]
17 => array:11 [
"RoomKey" => "1652392371"
"RoomType" => "Dinette"
"ListingId" => "40837053"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859873"
"RoomLength" => null
"RoomDimensions" => "14'11'' x 16'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:19:24.81Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29859873/512-wood-nettle-way-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "50-R5"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2627
+"BelowGradeFinishedArea": 1155
+"OriginalEntryTimestamp": "2026-06-05T15:19:24.78Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1257707"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29859873_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/ef11371c2611c051a97afa4b5c0d6e4f.webp"
"MediaSize" => 128751
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-ef11371c2611c051a97afa4b5c0d6e4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front of home with driveway, brick siding, and roof with shingles"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29859873_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/64f8498a19e1d12fe8ea5b695ff6978f.webp"
"MediaSize" => 121340
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-64f8498a19e1d12fe8ea5b695ff6978f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front of house with asphalt driveway, an attached garage, a shingled roof, and brick siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29859873_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/98abb2bec5c6f53a1e8f24a3005f8ed5.webp"
"MediaSize" => 136600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-98abb2bec5c6f53a1e8f24a3005f8ed5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front of property with asphalt driveway, brick siding, a garage, and a front lawn"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29859873_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/dcf8f5185f79ccba9867504152dd0952.webp"
"MediaSize" => 125855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-dcf8f5185f79ccba9867504152dd0952.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of exterior entry featuring brick siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29859873_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/5b098295ab31c853d25b88677a7d3dff.webp"
"MediaSize" => 56383
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-5b098295ab31c853d25b88677a7d3dff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring baseboards and light tile patterned flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29859873_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/937ba30881e93c090e03e45a2209a33c.webp"
"MediaSize" => 65152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-937ba30881e93c090e03e45a2209a33c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stairs with tile patterned flooring, arched walkways, and a high ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29859873_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/30ba9034d28a463319901ed5d66b8144.webp"
"MediaSize" => 62543
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-30ba9034d28a463319901ed5d66b8144.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept kitchen and dining area featuring light-toned cabinetry, a central island with countertop seating, tiled flooring, and multiple windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29859873_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/0873ce41f660fffcde14ec0fae7ee213.webp"
"MediaSize" => 92894
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-0873ce41f660fffcde14ec0fae7ee213.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring stainless steel appliances, light cabinetry, a mosaic tile backsplash, a center island with countertop seating, and light-toned tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29859873_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/f889dd9a45d99d9d964842398ef04ec8.webp"
"MediaSize" => 68000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-f889dd9a45d99d9d964842398ef04ec8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring a central island with a light-toned countertop, light grey cabinetry, tile flooring, stainless steel appliances, and a mosaic tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29859873_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/72b73d5f44925bdfadb7734bb61d7a08.webp"
"MediaSize" => 89485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-72b73d5f44925bdfadb7734bb61d7a08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring light cabinetry, quartz countertops, a stone mosaic tile backsplash, stainless steel appliances, and an island with pendant lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29859873_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/454ad4f05f32292decc66b70cb6aed00.webp"
"MediaSize" => 61991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-454ad4f05f32292decc66b70cb6aed00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen island featuring a light-colored countertop and grey cabinetry with brass hardware"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29859873_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/2491bad67f792702877404115bc12acf.webp"
"MediaSize" => 49317
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-2491bad67f792702877404115bc12acf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen island featuring a light-toned countertop, integrated cabinetry, and contemporary pendant lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29859873_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/0f300f4be24c071467adf70eaa76dcc6.webp"
"MediaSize" => 66265
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-0f300f4be24c071467adf70eaa76dcc6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining room featuring recessed lighting and light tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29859873_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/f31953b24af888018e4d54686ca66cac.webp"
"MediaSize" => 67946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-f31953b24af888018e4d54686ca66cac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space with light-toned tile flooring, a kitchen featuring grey cabinetry and stainless steel appliances, a breakfast bar with seating, a dedicated dining area, and an arched entryw"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29859873_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/d4a1e75143a48956bf264a12bcbfdc98.webp"
"MediaSize" => 81080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-d4a1e75143a48956bf264a12bcbfdc98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring wood-finish flooring, a fireplace with a light-colored mantel, wall sconce lighting, white plantation shutters, and a modern ceiling fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29859873_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/c164902d9041490e980e882f843aaacc.webp"
"MediaSize" => 110266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-c164902d9041490e980e882f843aaacc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring hardwood flooring, a fireplace with a detailed mantelpiece, and neutral wall tones"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29859873_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/4a88aeb9c629f5492964297b348c6d2c.webp"
"MediaSize" => 96053
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-4a88aeb9c629f5492964297b348c6d2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright living area featuring a bay window with plantation shutters, recessed lighting, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29859873_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/6b953288626a40ce96be36704c136096.webp"
"MediaSize" => 64247
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-6b953288626a40ce96be36704c136096.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining space featuring hardwood / wood-style floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29859873_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/ae97d28d167ac08170a9baa74cad5a3e.webp"
"MediaSize" => 52742
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-ae97d28d167ac08170a9baa74cad5a3e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring vanity"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29859873_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/ae25870afd10f4ec8affdbf9cc8f9524.webp"
"MediaSize" => 42544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-ae25870afd10f4ec8affdbf9cc8f9524.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Laundry room with washing machine and clothes dryer and light tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29859873_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/0099b5515351c5acd70d0e8810c8fe72.webp"
"MediaSize" => 62369
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-0099b5515351c5acd70d0e8810c8fe72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Sitting room with hardwood / wood-style flooring, an upstairs landing, and suspended lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29859873_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/628c850b8834728632874206030ee944.webp"
"MediaSize" => 70156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-628c850b8834728632874206030ee944.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light wood-style flooring and an office area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29859873_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/1d60ab1876da5440cb8f8b17b5289a50.webp"
"MediaSize" => 58276
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-1d60ab1876da5440cb8f8b17b5289a50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light wood-style floors and a desk"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29859873_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/9dafd205590d5f92dae6745bb3258dd1.webp"
"MediaSize" => 64481
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-9dafd205590d5f92dae6745bb3258dd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with light wood finished floors and a desk"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29859873_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/cd75588f80c17c90a98b12d6580064a7.webp"
"MediaSize" => 61909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-cd75588f80c17c90a98b12d6580064a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with wood finished floors and an office area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29859873_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/15cb20bc4c8a3364b5049e81708133f4.webp"
"MediaSize" => 72164
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-15cb20bc4c8a3364b5049e81708133f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bath featuring double vanity, tub / shower combination, and light tile patterned flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29859873_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/a4540e7a7c4a837e1dee408a73a96506.webp"
"MediaSize" => 61911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-a4540e7a7c4a837e1dee408a73a96506.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with wood-type flooring and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29859873_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/8c3b73785f0f40b1b6fd16826c8d7dfe.webp"
"MediaSize" => 52931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-8c3b73785f0f40b1b6fd16826c8d7dfe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with wood finished floors and a closet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29859873_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/04bce3139ae0c0df7577b3ebde025b1c.webp"
"MediaSize" => 78887
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-04bce3139ae0c0df7577b3ebde025b1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with hardwood / wood-style floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29859873_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/62d543aa8e0185c3ed1bb2f997d27b2d.webp"
"MediaSize" => 66531
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-62d543aa8e0185c3ed1bb2f997d27b2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light wood-type flooring and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29859873_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/635cb6cd94657867065f9bcdfad953d3.webp"
"MediaSize" => 74681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-635cb6cd94657867065f9bcdfad953d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring hardwood / wood-style floors and hanging lights"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29859873_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/8738d45fcd97f0443aa6333f441c1421.webp"
"MediaSize" => 61030
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-8738d45fcd97f0443aa6333f441c1421.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with vanity and a whirlpool tub"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29859873_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/3538a8c492c993f406e1cb3294273dc6.webp"
"MediaSize" => 69913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-3538a8c492c993f406e1cb3294273dc6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a marble finish shower and vanity"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29859873_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/808d42154837b6fcd0df27a420455b4c.webp"
"MediaSize" => 56457
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-808d42154837b6fcd0df27a420455b4c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stairs with wood finished floors and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29859873_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/db8e0220330dd30d67c2e8ad9c735ac6.webp"
"MediaSize" => 64557
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-db8e0220330dd30d67c2e8ad9c735ac6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Below grade area with recessed lighting and light wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29859873_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/badbfedc6ca5f45c3b3724d9a2cbc0b3.webp"
"MediaSize" => 61410
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-badbfedc6ca5f45c3b3724d9a2cbc0b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exercise room featuring light wood-type flooring and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29859873_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/4244acf79344ca9928dc8ffdc2b91bde.webp"
"MediaSize" => 65983
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-4244acf79344ca9928dc8ffdc2b91bde.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room featuring light wood-style floors, recessed lighting, healthy amount of natural light, and beam ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29859873_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/e0ff412f648280538c009fd630ceb01d.webp"
"MediaSize" => 69717
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-e0ff412f648280538c009fd630ceb01d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Cinema with light wood-style flooring and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29859873_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/ed64489f8369c576ad3f7baa20d1b21e.webp"
"MediaSize" => 61366
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-ed64489f8369c576ad3f7baa20d1b21e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Cinema featuring light wood-style flooring and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29859873_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/e53e96978ac3f2e0073ce65a2962167e.webp"
"MediaSize" => 47233
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-e53e96978ac3f2e0073ce65a2962167e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring vanity and a stall shower"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29859873_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/40c4af57cc47ee4f6deecb699d91b114.webp"
"MediaSize" => 56634
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-40c4af57cc47ee4f6deecb699d91b114.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light wood-style flooring, a closet, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29859873_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/4bf151c0babbb1fbaf9383e778a852b7.webp"
"MediaSize" => 48335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-4bf151c0babbb1fbaf9383e778a852b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished room featuring light wood finished floors and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29859873_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/cfe1f9a8e729836127b3f94aad7de989.webp"
"MediaSize" => 144235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-cfe1f9a8e729836127b3f94aad7de989.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Deck with outdoor dining space and a residential view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29859873_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/4ed375364168a298098c6132a54018cd.webp"
"MediaSize" => 143033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-4ed375364168a298098c6132a54018cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Wooden deck featuring outdoor dining space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29859873_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/eed1115d97b9825ad70e6d513bb23759.webp"
"MediaSize" => 167646
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-eed1115d97b9825ad70e6d513bb23759.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of fenced backyard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29859873_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/b087fc1b62351136af2d97efbc798bad.webp"
"MediaSize" => 104120
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-b087fc1b62351136af2d97efbc798bad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of fenced backyard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29859873_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/72a5731242c6891730ac99282ef66145.webp"
"MediaSize" => 129899
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-72a5731242c6891730ac99282ef66145.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Back of property with a wooden deck, a fenced backyard, and brick siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29859873_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/a083b7ee4fd49b9af8f1954b6ba064d1.webp"
"MediaSize" => 156962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-a083b7ee4fd49b9af8f1954b6ba064d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Back of property with a fenced backyard, a wooden deck, brick siding, a gate, and a residential view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "29859873_4890_49"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/877ce0f00bfb90a03a2802c41d9fb2d5.webp"
"MediaSize" => 144520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-877ce0f00bfb90a03a2802c41d9fb2d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Back of property with brick siding, a wooden deck, and a fenced backyard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
49 => array:13 [
"Order" => 50
"MediaKey" => "29859873_4890_50"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859873/efd2ae6e885c9bb4135736dfdf5328ee.webp"
"MediaSize" => 156836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859873/thumbnail-efd2ae6e885c9bb4135736dfdf5328ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rear view of property with a fenced backyard, a deck, brick siding, and roof with shingles"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837053"
"ResourceRecordKey" => "29859873"
"ModificationTimestamp" => "2026-06-05T15:19:24.79Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29859873')"
+"ID": "1498873"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 295659" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24708
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 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 {#24793
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29859873'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25123
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29859873'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25199
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29859873' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.6039602 43.4724714)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25157
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25151
+post_id: "1502400"
+post_author: 1
+"ListingKey": "29863317"
+"ListingId": "40837217"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T20:26:00Z"
+"RFModificationTimestamp": "2026-06-06T20:34:31Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3125.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A3"
+"UnparsedAddress": "795 LAURELWOOD Drive Unit# C13, Waterloo, Ontario N2V0A3"
+"Coordinates": array:2 [
0 => -80.6003139
1 => 43.4707332
]
+"Latitude": 43.4707332
+"Longitude": -80.6003139
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully updated corner-unit townhouse in the highly sought-after Laurelwood community. Nestled on a quiet cul-de-sac and surrounded by mature trees, this maintenance-free home offers exceptional space, privacy, and abundant natural light. Featuring three separate living areas and a rare main-floor primary bedroom with a full ensuite, this home is designed for both comfort and convenience. The main floor boasts soaring ceilings, a versatile front living room, a dedicated office, a powder room, and a renovated kitchen (2023) complete with quartz countertops, an island, white cabinetry, stainless steel appliances, and an open-concept layout that flows seamlessly into the dining and living areas. Upstairs, you'll find two spacious bedrooms, a full bathroom, and a large family room with the potential to be converted into a fourth bedroom. Step outside through sliding doors to a private deck overlooking peaceful greenspace-perfect for relaxing or entertaining. The expansive unfinished basement offers endless possibilities for future living space and awaits your personal touch. Recent upgrades include a furnace, A/C, sump pump, flooring, smart lighting, and pot lights. Ideally located near Laurel Creek, top-rated Kitchener-Waterloo schools, the University of Waterloo, shopping, and everyday amenities. Enjoy worry-free living with lawn maintenance and snow removal included. A rare opportunity to own a spacious, move-in-ready home in one of Waterloo's most desirable neighbourhoods. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"AssociationFee": "314"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T21:33:03.183497+00:00"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2141441"
+"ListOfficeKey": "300100"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-05T20:50:57Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T20:20:13Z"
+"Stories": "2.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "795"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "4864"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1653462324"
"RoomType" => "4pc Bathroom"
"ListingId" => "40837217"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29863317"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:20:13.09Z"
]
1 => array:11 [
"RoomKey" => "1653462325"
"RoomType" => "2pc Bathroom"
"ListingId" => "40837217"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29863317"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:20:13.09Z"
]
2 => array:11 [
"RoomKey" => "1653462326"
"RoomType" => "4pc Bathroom"
"ListingId" => "40837217"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29863317"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:20:13.1Z"
]
3 => array:11 [
"RoomKey" => "1653462327"
"RoomType" => "Bedroom"
"ListingId" => "40837217"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29863317"
"RoomLength" => null
"RoomDimensions" => "3'5'' x 3'4''"
"RoomDescription" => null
…2
]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29863317/795-laurelwood-drive-unit-c13-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "Md-3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1992
+"BelowGradeFinishedArea": 1133
+"OriginalEntryTimestamp": "2026-06-05T20:50:57.35Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1393129"
+"ListOfficeNationalAssociationId": "1482864"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29863317')"
+"ID": "1502400"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25153
+post_id: "1497649"
+post_author: 1
+"ListingKey": "29857988"
+"ListingId": "X13245602"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T16:10:58Z"
+"RFModificationTimestamp": "2026-06-05T16:29:36Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A3"
+"UnparsedAddress": "13 - 795 LAURELWOOD DRIVE, Waterloo, Ontario N2V0A3"
+"Coordinates": array:2 [
0 => -80.600804
1 => 43.471001
]
+"Latitude": 43.471001
+"Longitude": -80.600804
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully updated corner-unit townhouse in the highly sought-after Laurelwood community. Nestled on a quiet cul-de-sac and surrounded by mature trees, this maintenance-free home offers exceptional space, privacy, and abundant natural light. Featuring three separate living areas and a rare main-floor primary bedroom with a full ensuite, this home is designed for both comfort and convenience.The main floor boasts soaring ceilings, a versatile front living room, a dedicated office, a powder room, and a renovated kitchen (2023) complete with quartz countertops, an island, white cabinetry, stainless steel appliances, and an open-concept layout that flows seamlessly into the dining and living areas. Upstairs, you'll find two spacious bedrooms, a full bathroom, and a large family room with the potential to be converted into a fourth bedroom.Step outside through sliding doors to a private deck overlooking peaceful greenspace-perfect for relaxing or entertaining. The expansive unfinished basement offers endless possibilities for future living space and awaits your personal touch.Recent upgrades include a furnace, A/C, sump pump, flooring, smart lighting, and pot lights. Ideally located near Laurel Creek, top-rated Kitchener-Waterloo schools, the University of Waterloo, shopping, and everyday amenities. Enjoy worry-free living with lawn maintenance and snow removal included.A rare opportunity to own a spacious, move-in-ready home in one of Waterloo's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
11 => "Water Heater"
]
+"AssociationFee": "314"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T01:32:13.756962+00:00"
+"Directions": "Erbsville Road / Laurelwood Drive"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2245275"
+"ListOfficeKey": "299835"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-05T04:12:16Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T16:01:12Z"
+"Stories": "2.0"
+"StreetName": "Laurelwood"
+"StreetNumber": "795"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4864"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29857988/13-795-laurelwood-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2088481"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Self-managed"
+"CoListOfficeKey": "299835"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1999
+"LivingAreaMinimum": 1800
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-05T01:13:47.01Z"
+"ListAgentNationalAssociationId": "1484041"
+"ListOfficeNationalAssociationId": "1477585"
+"CoListAgentNationalAssociationId": "1361768"
+"CoListOfficeNationalAssociationId": "1477585"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29857988')"
+"ID": "1497649"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25150
+post_id: "1495724"
+post_author: 1
+"ListingKey": "29856070"
+"ListingId": "40830420"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T16:26:09Z"
+"RFModificationTimestamp": "2026-06-05T16:30:15Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2667.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2M3"
+"UnparsedAddress": "743 BUTTERNUT Avenue, Waterloo, Ontario N2V2M3"
+"Coordinates": array:2 [
0 => -80.5881761
1 => 43.4661322
]
+"Latitude": 43.4661322
+"Longitude": -80.5881761
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Loaction! Loacation!! Location!!! Located in the desirable Clair Hills community, Vista Hill PS and Laurel Height SS. This beautifully maintained home offers a double-car garage and an extended front walkway, providing both enhanced curb appeal and everyday convenience. The welcoming main level features a versatile front room that can serve as a home office, living room, or dining area, while upgraded waterproof flooring extends throughout the above-grade living space. Enjoy the spacious family room with nearly 9-foot ceilings, creating an open and comfortable atmosphere. The modern kitchen is equipped with quartz countertops, a large centre island, stylish backsplash, and a bright breakfast area with walkout access to the backyard, where a generous two-tier deck offers exceptional outdoor living and entertaining space. Upstairs, you'll find four well-sized bedrooms, two full bathrooms, a convenient laundry room, and an L-shaped staircase designed for added comfort and safety. The expansive primary suite features a private ensuite with a separate shower and soaker tub, while the three additional bedrooms provide excellent space for family or guests. The professionally finished basement offers distinct living areas, including a dedicated home theatre and a large recreation room, providing flexible space for entertainment, fitness, or family activities. Move-in ready and thoughtfully designed throughout, this home combines comfort, functionality, and an outstanding location. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T20:42:44.351317+00:00"
+"Directions": "From Erbsville heading North out of town, turn left on Columbia Forest then right on Butternut"
+"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": "2073939"
+"ListOfficeKey": "253316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-04T20:11:34Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T16:11:54Z"
+"Stories": "2.0"
+"StreetName": "BUTTERNUT"
+"StreetNumber": "743"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5932"
+"VirtualTourURLUnbranded": "https://youtu.be/oYIjf4okJ_A"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29856070/743-butternut-avenue-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 2047
+"BelowGradeFinishedArea": 620
+"OriginalEntryTimestamp": "2026-06-04T20:11:34.21Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1349103"
+"ListOfficeNationalAssociationId": "1223329"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29856070')"
+"ID": "1495724"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25154
+post_id: "1494892"
+post_author: 1
+"ListingKey": "29854661"
+"ListingId": "X13241212"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T17:25:55Z"
+"RFModificationTimestamp": "2026-06-05T17:30:01Z"
+"ListPrice": 950000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N8"
+"UnparsedAddress": "670 SALZBURG DRIVE, Waterloo, Ontario N2V2N8"
+"Coordinates": array:2 [
0 => -80.586439
1 => 43.462061
]
+"Latitude": 43.462061
+"Longitude": -80.586439
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "The Holy Grail of Retirement Bungalows with a PRICELESS VIEW! Modern-built, freehold (no condo fees!), and backing onto the serene Rosewood Pond in Waterloo's coveted Clair Hills community - this rare walkout bungalow blends elegance, comfort, and true accessibility in one perfect package. Freshly painted and updated with new carpet, it's completely move-in ready. Featuring 2+1 bedrooms, 3 bathrooms, and nearly 2,000 sq. ft. of beautifully finished living space, this home offers both style and ease. The open-concept main floor showcases rich maple hardwood and ceramic tile, flowing naturally to a raised deck with glass railings - where you'll enjoy the definition of a million-dollar view. The spacious primary suite overlooks the water and includes a private 4-piece ensuite, while the second bedroom with built-in Murphy bed easily converts to a guest room or home office. The bright walkout basement features oversized windows, a cozy gas fireplace, and direct yard access - perfect for entertaining or quiet mornings by the water. A third bedroom with ensuite privileges and large storage area complete the lower level. Built with accessibility in mind, this home includes widened doorways, lowered switches, and modern mechanical systems. Add a double garage, quiet low-traffic street, and peaceful pond-side setting, and you have effortless living at its finest. Homes offering this combination of location, quality, and accessibility are seldom available. This is the perfect combination for those looking to downsize. Don't miss your chance to call Rosewood Estates home! (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T18:42:42.513496+00:00"
+"Directions": "Columbia to Salzburg Drive"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100955"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "45 x 118.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-04T17:59:37Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T16:57:37Z"
+"Stories": "1.0"
+"StreetName": "Salzburg"
+"StreetNumber": "670"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5864"
+"VirtualTourURLUnbranded": "https://youriguide.com/670_salzburg_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29854661/670-salzburg-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-04T17:59:37.17Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1370979"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29854661')"
+"ID": "1494892"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25152
+post_id: "1494914"
+post_author: 1
+"ListingKey": "29853961"
+"ListingId": "40826844"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T15:40:55Z"
+"RFModificationTimestamp": "2026-06-05T15:47:27Z"
+"ListPrice": 950000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.12
+"LivingArea": 1983.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N8"
+"UnparsedAddress": "670 SALZBURG Drive, Waterloo, Ontario N2V2N8"
+"Coordinates": array:2 [
0 => -80.5864412
1 => 43.4620439
]
+"Latitude": 43.4620439
+"Longitude": -80.5864412
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "The Holy Grail of Retirement Bungalows with PRICELESS VIEW! Modern-built, freehold (no condo fees!), and backing onto the serene Rosewood Pond in Waterloo’s coveted Clair Hills community — this rare walkout bungalow blends elegance, comfort, and true accessibility in one perfect package. Freshly painted and updated with new carpet, it’s completely move-in ready. Featuring 2+1 bedrooms, 3 bathrooms, and nearly 2,000 sq. ft. of beautifully finished living space, this home offers both style and ease. The open-concept main floor showcases rich maple hardwood and ceramic tile, flowing naturally to a raised deck with glass railings — where you’ll enjoy the definition of a million-dollar view. The spacious primary suite overlooks the water and includes a private 4-piece en-suite, while the second bedroom with built-in Murphy bed easily converts to a guest room or home office. The bright walkout basement features oversized windows, a cozy gas fireplace, and direct yard access — perfect for entertaining or quiet mornings by the water. A third bedroom with en-suite privileges and large storage area complete the lower level. Built with accessibility in mind, this home includes widened doorways, lowered switches, and modern mechanical systems. Add a double garage, quiet low-traffic street, and peaceful pond-side setting, and you have effortless living at its finest. Homes offering this combination of location, quality, and accessibility are seldom available. This is the perfect combination for those looking to downsize. Don’t miss your chance to call Rosewood Estates home! (id:62650)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T18:35:29.064556+00:00"
+"Directions": "Columbia to Salzburg Drive"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564479"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-04T16:52:02Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T15:34:26Z"
+"Stories": "1.0"
+"StreetName": "SALZBURG"
+"StreetNumber": "670"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5446"
+"VirtualTourURLUnbranded": "https://youriguide.com/670_salzburg_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29853961/670-salzburg-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1223
+"BelowGradeFinishedArea": 760
+"OriginalEntryTimestamp": "2026-06-04T16:52:02.49Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1125580"
+"ListOfficeNationalAssociationId": "1380559"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29853961')"
+"ID": "1494914"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25147
+post_id: "1490753"
+post_author: 1
+"ListingKey": "29847603"
+"ListingId": "40829482"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-03T22:20:52Z"
+"RFModificationTimestamp": "2026-06-03T22:22:04Z"
+"ListPrice": 829000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2337.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2T5"
+"UnparsedAddress": "435 SPECKLED ALDER Street, Waterloo, Ontario N2V2T5"
+"Coordinates": array:2 [
0 => -80.5941368
1 => 43.4689249
]
+"Latitude": 43.4689249
+"Longitude": -80.5941368
+"YearBuilt": 2004
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This elegant, carpet-free family home in the prestigious Laurel Creek neighborhood offers a perfect blend of modern comfort and unbeatable convenience, with Costco, the YMCA, and the local library all situated within a 5-minute drive. The bright, open-concept interior features three spacious bedrooms, a fully finished basement with a large recreation room, and a fresh coat of paint throughout. Ideally positioned for families and investors alike, the property is steps away from top-rated schools like Abraham Erb P.S. and Laurel Heights S.S., and just minutes from both UW and WLU. Boasting a double driveway and extensive recent upgrades—including a new furnace (2025), washer/dryer (2024), dishwasher (2023), fridge (2022), and roof (2021)—this stunning, move-in-ready home is designed for effortless contemporary living. (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-06-03T18:57:35.796318+00:00"
+"Directions": "Laurelwood Drive to Blue Beech Blvd"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2081146"
+"ListOfficeKey": "253316"
+"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-06-03T22:20:27Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-03T22:20:26Z"
+"Stories": "2.0"
+"StreetName": "SPECKLED ALDER"
+"StreetNumber": "435"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4769.43"
+"VirtualTourURLUnbranded": "https://youriguide.com/8tiga_435_speckled_alder_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29847603/435-speckled-alder-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "50-R5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1647
+"BelowGradeFinishedArea": 690
+"OriginalEntryTimestamp": "2026-06-03T17:51:38.89Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1355928"
+"ListOfficeNationalAssociationId": "1223329"
+"Media": array:29 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29847603')"
+"ID": "1490753"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23346
+post_id: "1489104"
+post_author: 1
+"ListingKey": "29844777"
+"ListingId": "40835157"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T20:30:49Z"
+"RFModificationTimestamp": "2026-06-06T20:47:39Z"
+"ListPrice": 899999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1817.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2M3"
+"UnparsedAddress": "784 BUTTERNUT Avenue, Waterloo, Ontario N2V2M3"
+"Coordinates": array:2 [
0 => -80.5893984
1 => 43.4655833
]
+"Latitude": 43.4655833
+"Longitude": -80.5893984
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful move-in-ready 2 storey home in Waterloo’s highly sought-after Columbia Forest neighbourhood. Ideally located just minutes from the city’s largest natural walking trails, the Boardwalk shopping district, top-rated public schools, and both of Waterloo’s renowned universities, this location is perfect for the growing family. This charming 3+1 bedroom, 4-bathroom home offers over 1,700 square feet of finished living space, providing plenty of room for families both inside and outside of the home. Step outside and create lasting memories in your private backyard oasis, featuring mature trees, lush gardens, a dedicated dining area and your very own hot tub. The finished basement adds versatile living space and is the perfect setting for family recreation, an additional bedroom, or a home office. Recent improvements over the last few years include a new roof, full window replacement, new furnace and kitchen renovation. Don’t miss this rare opportunity to own a well-maintained home in one of Waterloo’s most desirable communities. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Tudor"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-03T16:03:35.919356+00:00"
+"Directions": "COL.FT/STAR FLOWER"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2061846"
+"ListOfficeKey": "284641"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0"
+"PhotosChangeTimestamp": "2026-06-03T11:59:28Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T20:21:36Z"
+"Stories": "2.0"
+"StreetName": "BUTTERNUT"
+"StreetNumber": "784"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4943.2"
+"Utilities": array:1 [
0 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29844777/784-butternut-avenue-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2217406"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "54949"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 44.0
+"AboveGradeFinishedArea": 1238
+"BelowGradeFinishedArea": 579
+"OriginalEntryTimestamp": "2026-06-03T11:59:27.95Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1336875"
+"ListOfficeNationalAssociationId": "1344650"
+"CoListAgentNationalAssociationId": "1463083"
+"CoListOfficeNationalAssociationId": "1003557"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29844777')"
+"ID": "1489104"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25155
+post_id: "1489105"
+post_author: 1
+"ListingKey": "29846036"
+"ListingId": "40836230"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-03T15:31:15Z"
+"RFModificationTimestamp": "2026-06-03T15:53:35Z"
+"ListPrice": 85000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 667.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3Z4"
+"UnparsedAddress": "580 BEAVER CREEK Road Unit# 203, Waterloo, Ontario N2J3Z4"
+"Coordinates": array:2 [
0 => -80.5822901
1 => 43.471847
]
+"Latitude": 43.471847
+"Longitude": -80.5822901
+"YearBuilt": 1992
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome Unit 203 in one of Waterloo's most established and beautifully maintained land-lease communities Green Acres Park! This modular home offers open-concept living, Step outside to your spacious private decks, perfect for morning coffee or summer BBQs surrounded by friendly neighbors. Green Acre Park features a community swimming pool, a game room, a catch and release fishing pond for plenty of outdoor activities. Enjoy resort-style amenities, peaceful surroundings, and low yearly carrying costs. Annual Park fees approx. $9,800-$11,200 + HST includes water & taxes (park closed Jan & Feb). Park approval required for all purchases. Enjoy the comforts of 10-month seasonal living (park closed Jan & Feb) with a turnkey home, surrounded by nature, old growth trees and a spacious lot. Call and book your appointment today!! (id:62650)"
+"Appliances": array:2 [
0 => "Refrigerator"
1 => "Gas stove(s)"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-06-03T15:53:26.359142+00:00"
+"Directions": "FROM NORTHFIELD EXIT-WEST ON NORTHFIELD DR., NORTH ON WESTMOUNT RD N. WEST ON CONSERVATION DR.,"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "None"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1860816"
+"ListOfficeKey": "76831"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Recreational"
]
+"PhotosChangeTimestamp": "2026-06-03T15:20:35Z"
+"PhotosCount": 12
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-03T15:20:35Z"
+"Stories": "1.0"
+"StreetName": "BEAVER CREEK"
+"StreetNumber": "580"
+"StreetSuffix": "Road"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29846036/580-beaver-creek-road-unit-203-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Mobile Home"
]
+"CommonInterest": "Leasehold"
+"GeocodeManualYN": true
+"ZoningDescription": "Rec"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 667
+"OriginalEntryTimestamp": "2026-06-03T15:20:35.35Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1200804"
+"ListOfficeNationalAssociationId": "1004391"
+"Media": array:12 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29846036')"
+"ID": "1489105"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25156
+post_id: "1483982"
+post_author: 1
+"ListingKey": "29838331"
+"ListingId": "40835298"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T20:30:47Z"
+"RFModificationTimestamp": "2026-06-06T20:47:51Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1920.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2W8"
+"UnparsedAddress": "223 BUTTERCUP Court, Waterloo, Ontario N2V2W8"
+"Coordinates": array:2 [
0 => -80.5974451
1 => 43.4739836
]
+"Latitude": 43.4739836
+"Longitude": -80.5974451
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 223 Buttercup Court, nestled on a quiet court in Waterloo's highly sought-after Columbia Forest-Laurelwood area. Backing directly onto Creekside Park and walking trails, this beautifully updated detached home offers the perfect blend of privacy, greenspace, and convenience. Designed for comfortable everyday living, this well-maintained home features 3 bedrooms, 4 bathrooms, and a functional layout with plenty of space to gather, entertain, and grow. The spacious primary suite offers a beautifully remodelled ensuite, while the second-floor family room provides valuable additional living space, perfect for movie nights, a home office, children's play area, or a quiet retreat away from the main living areas. The fully finished walkout basement adds exceptional flexibility with a second kitchen, full bathroom, and in-law potential, making it ideal for multi-generational living, guests, or additional recreation space. Step outside to enjoy the expansive deck overlooking the fenced backyard and parkland beyond. Parking for 3 vehicles adds everyday convenience, while nearby parks, walking trails, shopping, restaurants, and amenities enhance the lifestyle this location offers. Families will appreciate access to highly regarded schools, including Abraham Erb Public School (JK-6), Laurelwood Public School (7-8), and Laurel Heights Secondary School. Recent updates include Roof Shingles (2021), Furnace and Air Conditioner (2017), remodelled Primary Ensuite (2026), updated Family Bathroom Vanity (2026), fresh paint on the main and upper levels (2026), new Flooring on the second floor and basement (2026), a new Refrigerator in the main floor kitchen (2026), and a new Cooktop in the basement kitchen (2026). Combining a prime location, top-rated schools, thoughtful updates, and an exceptional park-side setting, this is a home that truly stands out. Book your private showing today! (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Dishwasher"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Contemporary"
]
+"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-02T15:24:53.553888+00:00"
+"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": "2073668"
+"ListOfficeKey": "289890"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-02T12:50:40Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T20:21:32Z"
+"Stories": "2.0"
+"StreetName": "BUTTERCUP"
+"StreetNumber": "223"
+"StreetSuffix": "Court"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5740"
+"VirtualTourURLUnbranded": "https://youriguide.com/223_buttercup_court_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29838331/223-buttercup-court-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1920
+"OriginalEntryTimestamp": "2026-06-02T12:50:39.84Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1348841"
+"ListOfficeNationalAssociationId": "1382470"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29838331')"
+"ID": "1483982"
}
]
+success: true
+page_size: 9
+page_count: 9
+count: 79
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
]