array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29978834 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
+post_id: "1584801"
+post_author: 1
+"ListingKey": "29978834"
+"ListingId": "40842119"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T17:40:53Z"
+"RFModificationTimestamp": "2026-07-02T18:12:27Z"
+"ListPrice": 862900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2677.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2X2"
+"UnparsedAddress": "769 KARLSFELD Road, Waterloo, Ontario N2T2X2"
+"Coordinates": array:2 [
0 => -80.5765401
1 => 43.4553661
]
+"Latitude": 43.4553661
+"Longitude": -80.5765401
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "NO HOLDING OFFERS! Move right into this beautifully updated 3+1 bedroom, 3.5 bathroom family home with a walk-out basement, situated on an impressive 128 ft deep lot in the highly sought-after Clair Hills neighbourhood. The bright & spacious main floor features a large living room with hardwood flooring & an updated kitchen. The open concept formal dining area boasts soaring cathedral ceilings and oversized windows overlooking the expansive, fully fenced, pool-sized backyard. Step out from the dining area onto the newly painted deck—perfect for outdoor dining and entertaining. Upstairs, you'll find three generously sized bedrooms and two beautifully updated full bathrooms. The primary bedroom offers a walk-in closet and a private ensuite, creating a comfortable retreat. The walk-out basement adds exceptional living space with a large 4th bedroom that can also serve as a recreation room, home office, or gym, along with a 4th bathroom for added convenience. Extensive Recent Updates Include: Freshly painted 1st & 2nd floor walls (2026). New 2nd-floor flooring (2026). New hardwood staircase (2026). Newly renovated both 2nd-floor bathrooms (2026). Furnace (2025). AC (2022). Kitchen renovation (2021), including quartz countertops, cabinetry, waterproof vinyl flooring, and stainless steel appliances. All 1st & 2nd-floor triple-pane windows replaced (2019). Roof (2018). Additional attic insulation (2018). Owned hot water heater. The oversized, fully fenced backyard offers plenty of room to install an in-ground pool, making it an ideal space for summer entertaining & family gatherings. Conveniently located within walking distance to schools, parks, and public transit, and just minutes from shopping, The Boardwalk, Costco, the YMCA, both Universities, and situated within the top-ranked Laurel Heights Secondary School boundary. This home offers the perfect combination of modern updates, functional living space, and an unbeatable family-friendly location. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T18:07:27.027947+00:00"
+"Directions": "Keats way and Erbsville Road"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1970409"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T17:32:30Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T17:32:30Z"
+"Stories": "2.0"
+"StreetName": "KARLSFELD"
+"StreetNumber": "769"
+"StreetSuffix": "Road"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5096"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/769-KARLSFELD-Road"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1673437262"
"RoomType" => "3pc Bathroom"
"ListingId" => "40842119"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29978834"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T17:32:30.02Z"
]
1 => array:11 [
"RoomKey" => "1673437263"
"RoomType" => "Bedroom"
"ListingId" => "40842119"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29978834"
"RoomLength" => null
"RoomDimensions" => "15'0'' x 23'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T17:32:30.03Z"
]
2 => array:11 [
"RoomKey" => "1673437264"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842119"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29978834"
"RoomLength" => null
"RoomDimensions" => "15'0'' x 23'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T17:32:30.03Z"
]
3 => array:11 [
"RoomKey" => "1673437265"
"RoomType" => "Full bathroom"
"ListingId" => "40842119"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29978834"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T17:32:30.04Z"
]
4 => array:11 [
"RoomKey" => "1673437266"
"RoomType" => "Bedroom"
"ListingId" => "40842119"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29978834"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T17:32:30.04Z"
]
5 => array:11 [
"RoomKey" => "1673437267"
"RoomType" => "Bedroom"
"ListingId" => "40842119"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29978834"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 13'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T17:32:30.05Z"
]
6 => array:11 [
"RoomKey" => "1673437268"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842119"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29978834"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 21'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T17:32:30.05Z"
]
7 => array:11 [
"RoomKey" => "1673437269"
"RoomType" => "2pc Bathroom"
"ListingId" => "40842119"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29978834"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T17:32:30.06Z"
]
8 => array:11 [
"RoomKey" => "1673437270"
"RoomType" => "Dinette"
"ListingId" => "40842119"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29978834"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 15'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T17:32:30.06Z"
]
9 => array:11 [
"RoomKey" => "1673437271"
"RoomType" => "Kitchen"
"ListingId" => "40842119"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29978834"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T17:32:30.06Z"
]
10 => array:11 [
"RoomKey" => "1673437272"
"RoomType" => "Great room"
"ListingId" => "40842119"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29978834"
"RoomLength" => null
"RoomDimensions" => "12'11'' x 18'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T17:32:30.07Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29978834/769-karlsfeld-road-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 34.0
+"AboveGradeFinishedArea": 1819
+"BelowGradeFinishedArea": 858
+"OriginalEntryTimestamp": "2026-07-02T16:33:42.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1257707"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29978834_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/f0979018c46bc26e51c4e89e41eeaa1d.webp"
"MediaSize" => 112521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-f0979018c46bc26e51c4e89e41eeaa1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring light-toned siding and brick accents"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.59Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29978834_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/80be2169f36b4bdd6059078df6f404ca.webp"
"MediaSize" => 114707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-80be2169f36b4bdd6059078df6f404ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story exterior with light-colored siding and brick accents"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.42Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29978834_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/cd6f5fb28909b72ff20b770c9fc4bc13.webp"
"MediaSize" => 129766
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-cd6f5fb28909b72ff20b770c9fc4bc13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring light-colored siding and a covered front porch"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.42Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29978834_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/89f7cbec99e2510a1a87dcec94b86fcc.webp"
"MediaSize" => 91374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-89f7cbec99e2510a1a87dcec94b86fcc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Covered concrete front porch featuring a brown panel entry door with side lites, sconce lighting, and brick detailing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.42Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29978834_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/e314847ec3d442f0680c62d0460ea8cb.webp"
"MediaSize" => 57007
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-e314847ec3d442f0680c62d0460ea8cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring wood-finish flooring, a white paneled entry door with sidelights, a flush-mount ceiling light, and access to a powder room with light blue walls and a window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.41Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29978834_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/43e462f80f65c99220d12f85d6dba0c5.webp"
"MediaSize" => 48946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-43e462f80f65c99220d12f85d6dba0c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring wood-finish flooring, white paneled doors with brass hardware, and light neutral wall colors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:00.81Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29978834_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/b5f604c2d7831cae1964ade6da10fcbe.webp"
"MediaSize" => 58035
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-b5f604c2d7831cae1964ade6da10fcbe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.43Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29978834_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/21630e067bfb35b63ee984d500ed6345.webp"
"MediaSize" => 79768
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-21630e067bfb35b63ee984d500ed6345.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring polished wood flooring, light-colored walls, and a large window with drapes"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.56Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29978834_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/994bbd30fb2f9e9dec90db9748a0af81.webp"
"MediaSize" => 59544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-994bbd30fb2f9e9dec90db9748a0af81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive room featuring rich wood-finish flooring, light-toned walls, and a large window with sheers and drapery"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.97Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29978834_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/f99e3fd3d33a7b39bdc128a3672e775c.webp"
"MediaSize" => 65141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-f99e3fd3d33a7b39bdc128a3672e775c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:02.3Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29978834_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/749daa3ff5fbc12e5a1e8884eadec525.webp"
"MediaSize" => 60055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-749daa3ff5fbc12e5a1e8884eadec525.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive interior space featuring wood-finish flooring, light-colored walls, and white baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.41Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29978834_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/55ae46892bbc3b397284a16e146ac429.webp"
"MediaSize" => 66662
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-55ae46892bbc3b397284a16e146ac429.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white cabinetry, stainless steel appliances, stone-finish countertops, wood-finish flooring, and a tiled backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.41Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29978834_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/127a80feab2753d02fa8cfc9508a230b.webp"
"MediaSize" => 64020
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-127a80feab2753d02fa8cfc9508a230b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:00.83Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29978834_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/389d4e0b8fba86601b3a5b32f2b58288.webp"
"MediaSize" => 61674
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-389d4e0b8fba86601b3a5b32f2b58288.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, stainless steel appliances, a double basin sink with a high-arc faucet, light-colored countertops, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:02.31Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29978834_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/5dc3a1bfd3a2288d7b5eb636f1b9871d.webp"
"MediaSize" => 65828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-5dc3a1bfd3a2288d7b5eb636f1b9871d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring wood-finish flooring, white cabinetry with silver hardware, stainless steel refrigerator, and a light-colored countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.41Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29978834_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/f748ca3b7ecf000a642a7b0564f6b242.webp"
"MediaSize" => 65951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-f748ca3b7ecf000a642a7b0564f6b242.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white cabinetry, light countertops, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.42Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29978834_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/bd0c4f0b11696371934c4e0548cdfff1.webp"
"MediaSize" => 86188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-bd0c4f0b11696371934c4e0548cdfff1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept dining area featuring wood-finish flooring, a contemporary chandelier, and a large window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:00.82Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29978834_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/a75ca86b67fcd530845a306d36f487ec.webp"
"MediaSize" => 74651
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-a75ca86b67fcd530845a306d36f487ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.41Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29978834_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/a3d16a2f613357fabdcfa658048248cf.webp"
"MediaSize" => 74501
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-a3d16a2f613357fabdcfa658048248cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room with vaulted ceilings and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:00.81Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29978834_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/90d6418b44bd3fa368236930b7d35b1a.webp"
"MediaSize" => 37953
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-90d6418b44bd3fa368236930b7d35b1a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom vanity featuring a white curved basin, chrome faucet, and gray two-door cabinet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:00.82Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29978834_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/55ad6ddf9257d18e9865fd9797e699ac.webp"
"MediaSize" => 69971
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-55ad6ddf9257d18e9865fd9797e699ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, light neutral wall paint, and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.97Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29978834_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/991916c3e15555dc7a79ed60ecfd4ee0.webp"
"MediaSize" => 41605
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-991916c3e15555dc7a79ed60ecfd4ee0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, white baseboards, light gray wall paint, and an open doorway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:02.3Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29978834_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/d3b944380d75eea39cc51384d3a81636.webp"
"MediaSize" => 56968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-d3b944380d75eea39cc51384d3a81636.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring light wood-finish flooring, white baseboards, and light-toned walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.25Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29978834_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/c7509e19fddbfa226bacfec4945bd7ff.webp"
"MediaSize" => 60341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-c7509e19fddbfa226bacfec4945bd7ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring an integrated bathtub and shower with tiled surround, a contemporary white vanity with substantial countertop, and a large wall-mounted mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:00.83Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29978834_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/cf8c4fa7734bed93ca898b77e95fafe1.webp"
"MediaSize" => 67974
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-cf8c4fa7734bed93ca898b77e95fafe1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light wood-finish flooring, white baseboards, and light wall paint"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:00.81Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29978834_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/842530d65ea1cafb346dfa89ee35d3c4.webp"
"MediaSize" => 45085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-842530d65ea1cafb346dfa89ee35d3c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Empty room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:00.82Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29978834_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/55b93b3eeea776139a1a9c04704f12fb.webp"
"MediaSize" => 50056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-55b93b3eeea776139a1a9c04704f12fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring light wood-finish flooring, white baseboards, and neutral wall tones"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:02.3Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29978834_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/821f42285331aa6341659e14db194a6e.webp"
"MediaSize" => 74620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-821f42285331aa6341659e14db194a6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with light wood-finish flooring, light blue painted walls, and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:00.84Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29978834_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/0f031acf17cc31c064609fee60630871.webp"
"MediaSize" => 46518
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-0f031acf17cc31c064609fee60630871.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, light blue walls, white baseboards, and a flush mount ceiling light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.98Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29978834_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/211ce1a5eac4ac41e09f22cbbd060c95.webp"
"MediaSize" => 55790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-211ce1a5eac4ac41e09f22cbbd060c95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.82Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29978834_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/3f78ee378d7c94fb80a23d36beb59b9a.webp"
"MediaSize" => 53002
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-3f78ee378d7c94fb80a23d36beb59b9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom vanity featuring a single basin, white countertop, and brushed nickel faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.41Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29978834_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/8beb444888436b93eb98c126bbfe9388.webp"
"MediaSize" => 90566
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-8beb444888436b93eb98c126bbfe9388.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfinished basement space featuring exposed wood joists and structural beams, concrete flooring, and two separate doorways leading to additional rooms"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.56Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29978834_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/5a88841ca1137b5cd20896b98aad960a.webp"
"MediaSize" => 97817
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-5a88841ca1137b5cd20896b98aad960a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Finished lower level featuring recessed lighting, a drop ceiling with accent panels, wood-finish flooring, a broad window, and a wall-mounted shelving unit"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:00.82Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29978834_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/ca323872eb5d28e584829809da7928a0.webp"
"MediaSize" => 75286
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-ca323872eb5d28e584829809da7928a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, white walls, and a drop ceiling with integrated lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.97Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29978834_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/d19b7635fade352defd35400c2be7e74.webp"
"MediaSize" => 72409
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-d19b7635fade352defd35400c2be7e74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, white walls, and a multi-toned blue and white acoustic panel ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.97Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29978834_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/969a68051e43b4b75d872224386c4540.webp"
"MediaSize" => 49432
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-969a68051e43b4b75d872224386c4540.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with integrated sink, chrome faucet, and expansive wall mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:02.3Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29978834_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/9d9f64b11dfa30e9d9be59543a3eb534.webp"
"MediaSize" => 120780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-9d9f64b11dfa30e9d9be59543a3eb534.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement area featuring a sliding glass door, a furnace, a hot water heater, additional tank, and built-in shelving"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.56Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29978834_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/1df44180b8ff74e8fb1f94d270757ada.webp"
"MediaSize" => 103269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-1df44180b8ff74e8fb1f94d270757ada.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfinished basement space featuring exposed wood joists and ductwork, white walls, built-in shelving, and concrete flooring with partial carpeting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.96Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29978834_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/cc8da618d795fe517362c9bae89778c4.webp"
"MediaSize" => 125712
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-cc8da618d795fe517362c9bae89778c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive outdoor deck featuring wood-finish flooring, a full-height wood railing, and direct access to interior spaces via a sliding glass door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:02.26Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29978834_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/36442e82c506b338d1940944550e4c3d.webp"
"MediaSize" => 119085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-36442e82c506b338d1940944550e4c3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive wood deck with wood railings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:02.53Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29978834_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/e9454dfb85ed7fa40ead25a10dd0b585.webp"
"MediaSize" => 126980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-e9454dfb85ed7fa40ead25a10dd0b585.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive wood-finish deck with a wood-spindle railing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:02.3Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29978834_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/25e587b43de0b4d71cfee71818b7936b.webp"
"MediaSize" => 140509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-25e587b43de0b4d71cfee71818b7936b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a green lawn, wood fence perimeter, mature trees, and raised garden beds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:02.3Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29978834_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/91fd2d190a326b5e3e400e8058f869bf.webp"
"MediaSize" => 144279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-91fd2d190a326b5e3e400e8058f869bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive grassy yard area featuring a full privacy fence, mature trees, and a multi-level wood deck structure"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:04.42Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29978834_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/bf9d878742a05ff9f7a1bd652f226449.webp"
"MediaSize" => 139742
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-bf9d878742a05ff9f7a1bd652f226449.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a manicured lawn, full perimeter privacy fencing, established garden beds, and a multi-level wood deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:05.81Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29978834_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/269e64233b78f17a16e9f534caecaa0f.webp"
"MediaSize" => 142601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-269e64233b78f17a16e9f534caecaa0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a manicured lawn, established garden beds, and a perimeter wood fence"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:01.95Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29978834_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/83a7625a2efb8909e9415711fadea2b9.webp"
"MediaSize" => 148796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-83a7625a2efb8909e9415711fadea2b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:02.56Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29978834_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/3d2ff738474437eb756d7b56dd977bea.webp"
"MediaSize" => 138216
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978834/thumbnail-3d2ff738474437eb756d7b56dd977bea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rear exterior featuring light-colored siding, a second-story wooden deck with railings, and a ground-level patio door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842119"
"ResourceRecordKey" => "29978834"
"ModificationTimestamp" => "2026-07-02T17:22:04.34Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29978834_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978834/730560ae381bad2a8c744f849b77760e.webp"
"MediaSize" => 22623
…9
]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29978834')"
+"ID": "1584801"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Cache Key: 999363dc0cb1fc7e9b82873736d915cb846a75558310020076f3a66a958a6c60" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24647
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1970409" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24978
+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 '29978834'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25287
+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 '29978834'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25302
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25303
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31759221"
+"ListingKey": "29978834"
+"ListingId": "40842119"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-05"
+"OpenHouseStartTime": "2026-07-05T14:00:00Z"
+"OpenHouseEndTime": "2026-07-05T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-04T04:14:53Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31759221')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25305
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31759222"
+"ListingKey": "29978834"
+"ListingId": "40842119"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-04"
+"OpenHouseStartTime": "2026-07-04T14:00:00Z"
+"OpenHouseEndTime": "2026-07-04T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-04T04:14:53Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31759222')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29978834' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5765401 43.4553661)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25380
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25374
+post_id: "1591176"
+post_author: 1
+"ListingKey": "29987087"
+"ListingId": "40844492"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T04:30:36Z"
+"RFModificationTimestamp": "2026-07-04T04:46:01Z"
+"ListPrice": 390000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 982.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N8"
+"UnparsedAddress": "459 BEECHWOOD Place Unit# 21, Waterloo, Ontario N2T2N8"
+"Coordinates": array:2 [
0 => -80.5590418
1 => 43.4510561
]
+"Latitude": 43.4510561
+"Longitude": -80.5590418
+"YearBuilt": 1993
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beechwood has long been one of Waterloo's most sought-after neighbourhoods, loved for its mature tree-lined streets, established community, and unbeatable everyday convenience. Nestled within a quiet condo complex, this home feels welcoming and peaceful, located just minutes from shopping, restaurants, parks, trails, transit, and both globally renowned universities. Inside, you will find an inviting, functional layout designed for comfortable living. The main floor features the kitchen, dining, and living areas. Upstairs, the two bedrooms are complemented by a full bathroom, while the primary bedroom enjoys the added luxury of its own private two-piece ensuite. The finished basement extends your living space even further, complete with a third bathroom and endless flexibility for a family room, home office, workout area, or guest retreat. Interior access to the attached garage, along with a second driveway parking space, adds convenience to your daily routine. In 2025, the furnace was upgraded to include a humidifier, and a new laundry machine set was added around 2023. The condominium corporation handles exterior maintenance, landscaping, and snow removal, allowing you to spend less time on upkeep and more time enjoying everything this exceptional neighbourhood has to offer. Whether you are searching for your first home or a smart investment in one of Waterloo's most consistently desirable communities, this is an opportunity you will not want to miss. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener"
6 => "Microwave Built-in"
]
+"AssociationFee": "464.42"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Other, See Remarks"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Partial"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T23:23:32.715919+00:00"
+"Directions": "Erb st to Beechwood pl"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2249661"
+"ListOfficeKey": "300896"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Balcony"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-03T20:18:20Z"
+"PhotosCount": 25
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T04:18:18Z"
+"Stories": "2.0"
+"StreetName": "BEECHWOOD"
+"StreetNumber": "459"
+"StreetSuffix": "Place"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "2512.57"
+"Utilities": array:1 [
0 => "Natural Gas"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/459_beechwood_pl_unit_21_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29987087/459-beechwood-place-unit-21-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "CPPS-MUR1-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 838
+"BelowGradeFinishedArea": 144
+"OriginalEntryTimestamp": "2026-07-03T20:18:20.66Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1488485"
+"ListOfficeNationalAssociationId": "1494469"
+"Media": array:25 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29987087')"
+"ID": "1591176"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25376
+post_id: "1590956"
+post_author: 1
+"ListingKey": "29987378"
+"ListingId": "X13520800"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T04:35:10Z"
+"RFModificationTimestamp": "2026-07-04T04:46:35Z"
+"ListPrice": 390000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N8"
+"UnparsedAddress": "21 - 459 BEECHWOOD PLACE, Waterloo, Ontario N2T2N8"
+"Coordinates": array:2 [
0 => -80.557278
1 => 43.451718
]
+"Latitude": 43.451718
+"Longitude": -80.557278
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Beechwood has long been one of Waterloo's most sought-after neighbourhoods, loved for its mature tree-lined streets, established community, and unbeatable everyday convenience. Nestled within a quiet condo complex, this home feels welcoming and peaceful, located just minutes from shopping, restaurants, parks, trails, transit, and both globally renowned universities. Inside, you will find an inviting, functional layout designed for comfortable living. The main floor features the kitchen, dining, and living areas. Upstairs, the two bedrooms are complemented by a full bathroom, while the primary bedroom enjoys the added luxury of its own private two-piece ensuite. The finished basement extends your living space even further, complete with a third bathroom and endless flexibility for a family room, home office, workout area, or guest retreat. Interior access to the attached garage, along with a second driveway parking space, adds convenience to your daily routine. In 2025, the furnace was upgraded to include a humidifier, and a new laundry machine set was added around 2023. The condominium corporation handles exterior maintenance, landscaping, and snow removal, allowing you to spend less time on upkeep and more time enjoying everything this exceptional neighbourhood has to offer. Whether you are searching for your first home or a smart investment in one of Waterloo's most consistently desirable communities, this is an opportunity you will not want to miss. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Blinds"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"AssociationFee": "464.42"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Water"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Partial"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T21:19:17.843583+00:00"
+"Directions": "Cross Streets: Erb St to Beechwood Pl. ** Directions: Erb S."
+"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": "2253532"
+"ListOfficeKey": "300496"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Balcony"
2 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T20:59:56Z"
+"PhotosCount": 25
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T04:29:17Z"
+"Stories": "2.0"
+"StreetName": "Beechwood"
+"StreetNumber": "459"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "2521"
+"VirtualTourURLUnbranded": "https://youriguide.com/459_beechwood_pl_unit_21_waterloo_on/"
+"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": "OnePoint"
+"TaxYear": 2025
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29987378/21-459-beechwood-place-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-03T20:59:56Z"
+"ListAgentNationalAssociationId": "1492517"
+"ListOfficeNationalAssociationId": "1489080"
+"Media": array:25 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29987378')"
+"ID": "1590956"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25373
+post_id: "1590429"
+post_author: 1
+"ListingKey": "29986610"
+"ListingId": "40844919"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T19:25:11Z"
+"RFModificationTimestamp": "2026-07-03T20:06:53Z"
+"ListPrice": 927500.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2692.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V6"
+"UnparsedAddress": "439 WOODROW Drive, Waterloo, Ontario N2T2V6"
+"Coordinates": array:2 [
0 => -80.5847827
1 => 43.4697703
]
+"Latitude": 43.4697703
+"Longitude": -80.5847827
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled in Waterloo's highly sought after Laurelwood neighbourhood, this beautifully renovated backsplit offers the perfect balance of modern updates, functional living space, and an incredible outdoor retreat. Every level of this home has been thoughtfully updated, making it truly move in ready. The beautifully designed kitchen (2016) serves as the heart of the home, showcasing quartz countertops, a spacious centre island, and abundant cabinetry. Whether you're preparing family meals or hosting friends, the open layout seamlessly connects the kitchen to the bright living and dining areas, creating an ideal space for everyday living and entertaining. A few steps down, the inviting family room is the perfect place to unwind, featuring a stylish gas fireplace with a custom mantel (2021) and patio doors that open to your own private backyard sanctuary. Enjoy beautifully landscaped perennial gardens, a charming gazebo, and an outdoor BBQ with prep station all included creating an exceptional setting for summer gatherings or peaceful evenings outdoors. The lower level features a flexible fourth bedroom or home office, a beautifully updated 3 piece bathroom (2018), a convenient laundry room, and direct access to the side entrance. The fully finished basement provides more living space with a generous recreation room, utility area, and extensive storage options to meet the needs of a growing family. Upstairs, you'll find three spacious bedrooms, including a relaxing primary retreat, along with a tastefully renovated 4npiece bathroom (2020). Additional features include a double car garage with EV charger rough in, a concrete driveway accommodating 4 vehicles, and quality finishes throughout. Ideally situated close to excellent schools, parks, scenic walking trails, shopping, universities, and all the amenities Waterloo has to offer, this exceptional Laurelwood home delivers the perfect combination of comfort, style, and location. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T20:06:47.479378+00:00"
+"Directions": "Laurelwood to Old Oak Dr to Woodrow Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1958320"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Gazebo"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T19:18:19Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T19:18:19Z"
+"Stories": "3.0"
+"StreetName": "WOODROW"
+"StreetNumber": "439"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5946"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/439_woodrow_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …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/29986610/439-woodrow-drive-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1564580"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2037
+"BelowGradeFinishedArea": 655
+"OriginalEntryTimestamp": "2026-07-03T19:18:19.14Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1249173"
+"ListOfficeNationalAssociationId": "1389824"
+"CoListAgentNationalAssociationId": "1069941"
+"CoListOfficeNationalAssociationId": "1004387"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986610')"
+"ID": "1590429"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25377
+post_id: "1589820"
+post_author: 1
+"ListingKey": "29983725"
+"ListingId": "X13517266"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T13:10:02Z"
+"RFModificationTimestamp": "2026-07-03T18:10:00Z"
+"ListPrice": 689000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1A7"
+"UnparsedAddress": "92 PINEMEADOW CRESCENT, Waterloo, Ontario N2T1A7"
+"Coordinates": array:2 [
0 => -80.553692
1 => 43.449029
]
+"Latitude": 43.449029
+"Longitude": -80.553692
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "The bright and inviting main level features spacious principal rooms, premium laminate flooring, fresh professional paint, updated interior doors and railings, and beautifully renovated bathrooms. At the heart of the home is the modern kitchen, showcasing refreshed cabinetry, sleek countertops, and stainless steel appliances-an ideal space for both everyday living and entertaining. The fully finished lower level adds exceptional flexibility with a spacious recreation room, a fourth bedroom, and a full bathroom, making it ideal for growing families, multi-generational living, overnight guests, a home office, or future income potential. Step outside to enjoy a fully fenced backyard offering privacy and plenty of space for children, pets, gardening, or summer BBQs. An attached garage and double driveway provide parking for up to three vehicles. Located on a quiet crescent in the desirable Westvale community, you'll appreciate the convenience of being just minutes from highly regarded schools, beautiful parks and trails, shopping, restaurants, public transit, and easy access to the University of Waterloo, Wilfrid Laurier University, and major commuter routes. Recent updates include premium laminate flooring (2023), stainless steel kitchen appliances, including the fridge and stove (2023), fresh professional paint (2024), roof shingles (2016), and a furnace (2018). This is an exceptional opportunity to own a beautifully maintained home in one of Waterloo's most established and family-friendly communities. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T18:09:54.238532+00:00"
+"Directions": "Cross Streets: Fischer-Hallman Road & Erb Street. ** Directions: Westvale Drive to Pinemeadow Crescent."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Concrete Block"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2188755"
+"ListOfficeKey": "291409"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40 x 108.5 FT ; 40.35ft. x 113.0ft. x 40.09ft x 108.45ft"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Tandem"
]
+"PhotosChangeTimestamp": "2026-07-03T13:04:24Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T13:04:24Z"
+"Stories": "1.0"
+"StreetName": "Pinemeadow"
+"StreetNumber": "92"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4096"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29983725/92-pinemeadow-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1418255"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "90198"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2026-07-03T13:04:24.39Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1437820"
+"ListOfficeNationalAssociationId": "1397659"
+"CoListAgentNationalAssociationId": "1105101"
+"CoListOfficeNationalAssociationId": "1153615"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983725')"
+"ID": "1589820"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25375
+post_id: "1588834"
+post_author: 1
+"ListingKey": "29983590"
+"ListingId": "40844806"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T12:40:07Z"
+"RFModificationTimestamp": "2026-07-03T13:44:45Z"
+"ListPrice": 689000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.102
+"LivingArea": 1572.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1A7"
+"UnparsedAddress": "92 PINEMEADOW Crescent, Waterloo, Ontario N2T1A7"
+"Coordinates": array:2 [
0 => -80.5538293
1 => 43.4490161
]
+"Latitude": 43.4490161
+"Longitude": -80.5538293
+"YearBuilt": 1980
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "The bright and inviting main level features spacious principal rooms, premium laminate flooring, fresh professional paint, updated interior doors and railings, and beautifully renovated bathrooms. At the heart of the home is the modern kitchen, showcasing refreshed cabinetry, sleek countertops, and stainless steel appliances—an ideal space for both everyday living and entertaining. The fully finished lower level adds exceptional flexibility with a spacious recreation room, a fourth bedroom, and a full bathroom, making it ideal for growing families, multi-generational living, overnight guests, a home office, or future income potential. Step outside to enjoy a fully fenced backyard offering privacy and plenty of space for children, pets, gardening, or summer BBQs. An attached garage and double driveway provide parking for up to three vehicles. Located on a quiet crescent in the desirable Westvale community, you'll appreciate the convenience of being just minutes from highly regarded schools, beautiful parks and trails, shopping, restaurants, public transit, and easy access to the University of Waterloo, Wilfrid Laurier University, and major commuter routes. Recent updates include premium laminate flooring (2023), stainless steel kitchen appliances including the fridge and stove (2023), fresh professional paint (2024), roof shingles (2016), and furnace (2018). This is an exceptional opportunity to own a beautifully maintained home in one of Waterloo's most established and family-friendly communities. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T13:44:33.076117+00:00"
+"Directions": "Westvale Drive to Pinemeadow Crescent"
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Brick"
2 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2180828"
+"ListOfficeKey": "290853"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.102"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T12:28:38Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T12:28:38Z"
+"Stories": "1.0"
+"StreetName": "PINEMEADOW"
+"StreetNumber": "92"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "4096"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29983590/92-pinemeadow-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 1066
+"BelowGradeFinishedArea": 506
+"OriginalEntryTimestamp": "2026-07-03T12:28:37.91Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1430684"
+"ListOfficeNationalAssociationId": "1394395"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983590')"
+"ID": "1588834"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25370
+post_id: "1584208"
+post_author: 1
+"ListingKey": "29977963"
+"ListingId": "40841754"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T15:00:17Z"
+"RFModificationTimestamp": "2026-07-02T17:24:31Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2384.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1X7"
+"UnparsedAddress": "482 FOXHILL Place, Waterloo, Ontario N2T1X7"
+"Coordinates": array:2 [
0 => -80.560245
1 => 43.4482842
]
+"Latitude": 43.4482842
+"Longitude": -80.560245
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled on a quiet court and backing onto mature woodland & walking trails, this exceptional setting offers nature at your doorstep including an easy walk to Westvale Park, complete with play structures, a pond, sledding hills & scenic trails. This lovingly maintained family home is being offered for sale the first time in over 30 years. The beautiful winding staircase welcomes you into the spacious foyer. Formal living and dining rooms feature oak hardwood flooring, creating warm and inviting spaces for entertaining. The kitchen offers newer stainless steel appliances (2020), neutral vinyl flooring and a bright breakfast nook with w/o to the back deck, perfect for summer BBQs. The adjacent family room is highlighted by a cozy wood-burning fireplace & a second w/o overlooking the treed backyard. Outside, the tiered private rear yard offers multiple usable spaces that have hosted everything from a sandbox and playhouse to hammocks and winter sledding. Convenience is built into everyday living with a main floor laundry room featuring access to both the side yard and double garage. Parking for 6 cars total including garage and no sidewalk to shovel! A 2-piece powder room completes the main level. Upstairs you'll find 4 generous bedrooms, including a spacious primary retreat with double door entry, walk-in closet and a 4pc ensuite. The 4pc main bathroom serves the additional bedrooms. The partially finished basement already has finished walls and ceilings, allowing you to simply choose your flooring and create additional living space. A rec room, gym or play area, abundant storage and a framed 3pc bathroom r/i provide endless possibilities. Recent updates include a furnace (2022), AC (2019), toilets, sinks, faucets, lighting, switches, newly installed carpet throughout and freshly painted. Ideally located just minutes from The Boardwalk, excellent schools, parks and convenient highway access, this well-loved home offers the perfect blend of space, privacy and location. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T17:24:28.405491+00:00"
+"Directions": "Take Erb Street West to Gateview Drive. Turn right onto Westvale Drive and follow until Foxhill Place"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564283"
+"ListOfficeKey": "296447"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Paved driveway"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T14:51:47Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T14:51:47Z"
+"Stories": "2.0"
+"StreetName": "FOXHILL"
+"StreetNumber": "482"
+"StreetSuffix": "Place"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "6058.5"
+"VirtualTourURLUnbranded": "https://youriguide.com/482_foxhill_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29977963/482-foxhill-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 46.0
+"AboveGradeFinishedArea": 2053
+"BelowGradeFinishedArea": 331
+"OriginalEntryTimestamp": "2026-07-02T14:51:47.56Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1129912"
+"ListOfficeNationalAssociationId": "1458684"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977963')"
+"ID": "1584208"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1584209"
+post_author: 1
+"ListingKey": "29978533"
+"ListingId": "X13512444"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T16:05:05Z"
+"RFModificationTimestamp": "2026-07-02T16:41:50Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1X7"
+"UnparsedAddress": "482 FOXHILL PLACE, Waterloo, Ontario N2T1X7"
+"Coordinates": array:2 [
0 => -80.560114
1 => 43.448279
]
+"Latitude": 43.448279
+"Longitude": -80.560114
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "TBD (id:62650)"
+"Appliances": array:1 [
0 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T16:41:39.382696+00:00"
+"Directions": "Cross Streets: Westvale Drive. ** Directions: Take Westvale Drive to Foxhill Place."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2256203"
+"ListOfficeKey": "296481"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Wooded area"
2 => "Backs on greenbelt"
3 => "Conservation/green belt"
]
+"LotSizeDimensions": "45.9 x 114.8 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-07-02T15:58:07Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T15:58:07Z"
+"Stories": "2.0"
+"StreetName": "Foxhill"
+"StreetNumber": "482"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "6058.5"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/482_foxhill_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29978533/482-foxhill-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 45.1
+"OriginalEntryTimestamp": "2026-07-02T15:58:07.63Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1495311"
+"ListOfficeNationalAssociationId": "1470796"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29978533')"
+"ID": "1584209"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25378
+post_id: "1583692"
+post_author: 1
+"ListingKey": "29977237"
+"ListingId": "40844510"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T14:00:17Z"
+"RFModificationTimestamp": "2026-07-02T14:07:55Z"
+"ListPrice": 549000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1898.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1Z2"
+"UnparsedAddress": "464 BEECHWOOD Place Unit# 3, Waterloo, Ontario N2T1Z2"
+"Coordinates": array:2 [
0 => -80.5579777
1 => 43.4525513
]
+"Latitude": 43.4525513
+"Longitude": -80.5579777
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover this beautifully updated two storey condo townhouse where modern finishes and functional design come together effortlessly. At the centre of the home is a stunning renovated kitchen featuring sleek quartz countertops, an oversized island perfect for gathering with family and friends, and plenty of workspace for everyday living. The bright and inviting main floor offers a spacious living room with a cozy gas fireplace, patio doors leading to a private balcony, a convenient two-piece powder room, and a flexible bedroom that's ideal for guests, a home office, or hobby space. Upstairs, the open loft style den overlooks the main level, adding character and an abundance of natural light. The generous primary suite provides a peaceful retreat with a beautifully updated ensuite bathroom. The finished lower level extends your living space with a comfortable rec room highlighted by a second gas fireplace, an additional powder room, laundry area, and a mudroom with direct access to the attached garage. Residents enjoy a meticulously maintained condo community complete with an outdoor swimming pool and plenty of visitor parking. Ideally situated close to grocery stores, restaurants, schools, public transit, The Boardwalk shopping district, and only minutes from Uptown Waterloo, this move-in ready home offers the perfect combination of style, comfort, and convenience. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"AssociationFee": "775"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T14:07:43.796922+00:00"
+"Directions": "Fisher Hallman to Erb to Beechwood Pl"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564580"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T13:31:51Z"
+"PhotosCount": 35
+"PoolFeatures": array:1 [
0 => "Pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T13:50:38Z"
+"Stories": "2.0"
+"StreetName": "BEECHWOOD"
+"StreetNumber": "464"
+"StreetSuffix": "Place"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "3630"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/3_464_beechwood_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29977237/464-beechwood-place-unit-3-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1958320"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "290620"
+"GeocodeManualYN": true
+"ZoningDescription": "MR150"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 1.0
+"AboveGradeFinishedArea": 1375
+"BelowGradeFinishedArea": 523
+"OriginalEntryTimestamp": "2026-07-02T13:31:51Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1069941"
+"ListOfficeNationalAssociationId": "1004387"
+"CoListAgentNationalAssociationId": "1249173"
+"CoListOfficeNationalAssociationId": "1389824"
+"Media": array:35 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977237')"
+"ID": "1583692"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25379
+post_id: "1575466"
+post_author: 1
+"ListingKey": "29964973"
+"ListingId": "40843611"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T13:55:11Z"
+"RFModificationTimestamp": "2026-06-29T17:23:56Z"
+"ListPrice": 519900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 2092.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N3"
+"UnparsedAddress": "465 COLUMBIA Street W Unit# 4, Waterloo, Ontario N2T2N3"
+"Coordinates": array:2 [
0 => -80.5699679
1 => 43.4659574
]
+"Latitude": 43.4659574
+"Longitude": -80.5699679
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Move-in Ready. Prestigious Upper Beechwood bungalow end-unit condo nestled among the beautiful treed surroundings of Roxton Park. Offering carefree living style for the busy professional, young executive & active empty nesters. An intimate complex with 8 owners. Filled with natural light, this elegant bungalow features large windows, transoms, soaring 9’ ceilings, 3 full bathrooms, and 2 walkouts. The spacious kitchen with a dinette showcases an impressive 12’ ceiling, while the open-concept dining area and great room create an inviting atmosphere complete with oversized windows and a cozy gas fireplace. The primary bedroom retreat offers a beautifully updated 3pc ensuite featuring quartz countertops and a glass shower. Step outside from the 2nd bedroom to the oversized deck and enjoy peaceful views in a serene setting. The finished lower level adds exceptional living space with a large recreation room and an additional full bathroom. Recent Updates: Kitchen sink faucet (2026), Range Hood (2021), newly painted most walls (2026), all 3 bathroom vanities, faucets and toilets (2024, 2026). Master bedroom ensuite shower (2024). Dining room sliding door (2020). Gas Fireplace (2021). Dryer (2018). Washer (2020). Outstanding location within walking distance to Shopping, Roxton Park, Conservation area, transit, University of Waterloo, Library, YMCA. A short drive to Costco, the Boardwalk, and all other amenities. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"AssociationFee": "911.75"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T17:23:46.447783+00:00"
+"Directions": "Fischer-Hallman Rd N to Columbia St W"
+"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": "1970409"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T13:50:03Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T13:50:03Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "COLUMBIA"
+"StreetNumber": "465"
+"StreetSuffix": "Street"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "4795"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/465-Columbia-St-W-unit-4"
+"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/29964973/465-columbia-street-w-unit-4-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1301
+"BelowGradeFinishedArea": 791
+"OriginalEntryTimestamp": "2026-06-29T13:50:03.77Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1257707"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964973')"
+"ID": "1575466"
}
]
+success: true
+page_size: 9
+page_count: 12
+count: 105
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]