array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29920234 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1542297"
+post_author: 1
+"ListingKey": "29920234"
+"ListingId": "40840985"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T04:25:09Z"
+"RFModificationTimestamp": "2026-06-18T05:21:34Z"
+"ListPrice": 1499000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3965.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T0B3"
+"UnparsedAddress": "505 ST MORITZ Avenue, Waterloo, Ontario N2T0B3"
+"Coordinates": array:2 [
0 => -80.5797441
1 => 43.4507512
]
+"Latitude": 43.4507512
+"Longitude": -80.5797441
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this exceptional custom-built two-storey residence nestled in the highly sought-after Clair Hills community. This stunning home offers over three levels of beautifully finished living space, featuring 3+2 bedrooms and 3.5 bathrooms. Meticulously maintained and extensively upgraded over the last three years, the home showcases a beautifully renovated chef-inspired kitchen and a luxurious primary ensuite, along with numerous high-quality improvements throughout. The sophisticated open-concept layout is ideal for both everyday living and entertaining, while the expansive walk-in pantry provides exceptional storage and convenience. The inviting family room is anchored by a striking custom stone fireplace and enhanced by a premium built-in audio system throughout the home. Sliding doors lead to a spacious deck overlooking a private, resort-style backyard oasis complete with a sparkling inground pool, creating the perfect setting for summer enjoyment and outdoor entertaining. Fronting onto St. Moritz Park, the property enjoys exceptional privacy with no rear neighbours, offering a serene, countryside-like setting rarely found within the city. Surrounded by mature greenery and tranquil views, the backyard provides a peaceful retreat that feels miles away from urban living. A functional mudroom with direct garage access adds practicality, while the professionally finished lower level offers additional living space, two bedrooms, full bathroom, and a walk-up to the backyard, providing excellent flexibility for guests, extended family, or recreation. Ideally situated within walking distance to top-rated schools, parks, scenic trails, and everyday amenities, and just minutes from Highways 7 / 8, this remarkable property seamlessly blends luxury, comfort, and convenience in one of Waterloo's most desirable neighbourhoods. (id:62783)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Gas stove(s)"
5 => "Range - Gas"
6 => "Dishwasher"
7 => "Wine Fridge"
8 => "Dryer"
9 => "Central Vacuum - Roughed In"
10 => "Hood Fan"
11 => "Window Coverings"
12 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T05:21:24.245183+00:00"
+"Directions": "Columbia Road/St.Moritz Avenue"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1905477"
+"ListOfficeKey": "296136"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
2 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T04:19:37Z"
+"PhotosCount": 43
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T04:19:37Z"
+"Stories": "2.0"
+"StreetName": "ST MORITZ"
+"StreetNumber": "505"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "8727"
+"VirtualTourURLUnbranded": "https://youriguide.com/505_st_moritz_ave_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1661839723"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840985"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29920234"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T04:19:37.09Z"
]
1 => array:11 [
"RoomKey" => "1661839724"
"RoomType" => "5pc Bathroom"
"ListingId" => "40840985"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29920234"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T04:19:37.09Z"
]
2 => array:11 [
"RoomKey" => "1661839725"
"RoomType" => "Bedroom"
"ListingId" => "40840985"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29920234"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 12'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T04:19:37.1Z"
]
3 => array:11 [
"RoomKey" => "1661839726"
"RoomType" => "Bedroom"
"ListingId" => "40840985"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29920234"
"RoomLength" => null
"RoomDimensions" => "12'11'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T04:19:37.1Z"
]
4 => array:11 [
"RoomKey" => "1661839727"
"RoomType" => "Bedroom"
"ListingId" => "40840985"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29920234"
"RoomLength" => null
"RoomDimensions" => "12'3'' x 19'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T04:19:37.1Z"
]
5 => array:11 [
"RoomKey" => "1661839728"
"RoomType" => "Bonus Room"
"ListingId" => "40840985"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29920234"
"RoomLength" => null
"RoomDimensions" => "7'3'' x 4'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T04:19:37.1Z"
]
6 => array:11 [
"RoomKey" => "1661839729"
"RoomType" => "2pc Bathroom"
"ListingId" => "40840985"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29920234"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T04:19:37.1Z"
]
7 => array:11 [
"RoomKey" => "1661839730"
"RoomType" => "Living room"
"ListingId" => "40840985"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29920234"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 14'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T04:19:37.1Z"
]
8 => array:11 [
"RoomKey" => "1661839731"
"RoomType" => "Family room"
"ListingId" => "40840985"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29920234"
"RoomLength" => null
"RoomDimensions" => "14'8'' x 13'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T04:19:37.1Z"
]
9 => array:11 [
"RoomKey" => "1661839732"
"RoomType" => "Kitchen"
"ListingId" => "40840985"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29920234"
"RoomLength" => null
"RoomDimensions" => "14'9'' x 20'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T04:19:37.1Z"
]
10 => array:11 [
"RoomKey" => "1661839733"
"RoomType" => "Recreation room"
"ListingId" => "40840985"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29920234"
"RoomLength" => null
"RoomDimensions" => "19'2'' x 17'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T04:19:37.1Z"
]
11 => array:11 [
"RoomKey" => "1661839734"
"RoomType" => "Bedroom"
"ListingId" => "40840985"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29920234"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T04:19:37.1Z"
]
12 => array:11 [
"RoomKey" => "1661839735"
"RoomType" => "Laundry room"
"ListingId" => "40840985"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29920234"
"RoomLength" => null
"RoomDimensions" => "5'10'' x 6'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T04:19:37.1Z"
]
13 => array:11 [
"RoomKey" => "1661839736"
"RoomType" => "Bedroom"
"ListingId" => "40840985"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29920234"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T04:19:37.11Z"
]
14 => array:11 [
"RoomKey" => "1661839737"
"RoomType" => "3pc Bathroom"
"ListingId" => "40840985"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29920234"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T04:19:37.11Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29920234/505-st-moritz-avenue-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2039305"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "296136"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "FR G2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 31.0
+"AboveGradeFinishedArea": 2787
+"BelowGradeFinishedArea": 1178
+"OriginalEntryTimestamp": "2026-06-18T04:19:36.99Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1219577"
+"ListOfficeNationalAssociationId": "1454937"
+"CoListAgentNationalAssociationId": "1315396"
+"CoListOfficeNationalAssociationId": "1454937"
+"Media": array:43 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29920234_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/84444bf02a9c3935051fef464b5ced8e.webp"
"MediaSize" => 168122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-84444bf02a9c3935051fef464b5ced8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring a brick facade with complementary brown siding and a dual-car garage"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29920234_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/fa80de6238cd345ea042dd85f8d5f79d.webp"
"MediaSize" => 129647
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-fa80de6238cd345ea042dd85f8d5f79d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring a brick and siding exterior, an attached two-car garage, and a paved driveway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29920234_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/b5f765928210c4e3df458b5e5e6a7d19.webp"
"MediaSize" => 112665
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-b5f765928210c4e3df458b5e5e6a7d19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Outdoor spa with illuminated water, accompanied by a kidney-shaped swimming pool"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29920234_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/fbef329fe267a4515b5550f9e0b1d439.webp"
"MediaSize" => 187438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-fbef329fe267a4515b5550f9e0b1d439.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious wood-finish deck with an open pergola, glass panel railing, and an inground pool with surrounding pavers"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29920234_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/e00a9c8d1724e1a4e939bd212dcac6f8.webp"
"MediaSize" => 95187
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-e00a9c8d1724e1a4e939bd212dcac6f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Grand staircase with wood-finish treads, white risers, and black iron balusters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29920234_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/335ce1f041a5beecc68e4bbc8cb4ad89.webp"
"MediaSize" => 91846
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-335ce1f041a5beecc68e4bbc8cb4ad89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring wood-finish flooring, a contemporary chandelier, recessed lighting, and plantation shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29920234_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/ac654945f87a883c4d36cc6dac1a7114.webp"
"MediaSize" => 84226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-ac654945f87a883c4d36cc6dac1a7114.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring wood-finish flooring, a decorative chandelier, and plantation shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29920234_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/e0375e136eb8f5a5afd9f6eb17808a69.webp"
"MediaSize" => 112808
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-e0375e136eb8f5a5afd9f6eb17808a69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Vaulted living space featuring a floor-to-ceiling stone fireplace with a wood mantel"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29920234_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/5be372856b7d015d41bd94707df00e2c.webp"
"MediaSize" => 108591
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-5be372856b7d015d41bd94707df00e2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story living area featuring a stone fireplace, wood mantle, recessed fireplace, and high ceilings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29920234_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/002f78e58173da187e48bbee50e79c4b.webp"
"MediaSize" => 101852
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-002f78e58173da187e48bbee50e79c4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Vaulted living room with wood-finish flooring, a stone-clad fireplace, and a wood ceiling fan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29920234_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/81f978cf4f8e59f61bd647a0ead15232.webp"
"MediaSize" => 108174
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-81f978cf4f8e59f61bd647a0ead15232.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious open-concept living area featuring a floor-to-ceiling stone fireplace, rich wood-finish flooring, a contemporary kitchen with a large island, recessed lighting, and a visible upper-level land"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29920234_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/370c25ce519eeb9a9c6a7c0414d5eff7.webp"
"MediaSize" => 93753
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-370c25ce519eeb9a9c6a7c0414d5eff7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen island featuring integrated stainless steel appliances, a built-in beverage cooler, and pendant lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29920234_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/915168f638ea1f35a0098edd174d7de3.webp"
"MediaSize" => 100479
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-915168f638ea1f35a0098edd174d7de3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring wood-finish flooring, a chandelier, and direct access to an outdoor patio with a pergola"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29920234_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/efbf15db80e11ee88f9eaff80bcc5f98.webp"
"MediaSize" => 73608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-efbf15db80e11ee88f9eaff80bcc5f98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Gourmet kitchen featuring a large island with sink, professional-grade stainless steel range with hood, double-door refrigerator, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29920234_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/e33f20a795da5c90942e88c2ac3e20d8.webp"
"MediaSize" => 72020
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-e33f20a795da5c90942e88c2ac3e20d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Gourmet kitchen featuring a professional-grade stainless steel range with a matching vent hood, white shaker-style cabinetry, marble-style backsplash, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29920234_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/b759dc37c87e1befaf9c0c497de581a5.webp"
"MediaSize" => 69021
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-b759dc37c87e1befaf9c0c497de581a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white cabinetry, stainless steel appliances, a white subway tile backsplash, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29920234_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/cd8a2eca8a7c3279bfa495f9e6ca9cbc.webp"
"MediaSize" => 56153
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-cd8a2eca8a7c3279bfa495f9e6ca9cbc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29920234_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/f4ae4e10ee4c987a2a821fada0da6e47.webp"
"MediaSize" => 83784
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-f4ae4e10ee4c987a2a821fada0da6e47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted bedroom with a ceiling fan, recessed lighting, and a window featuring white plantation shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29920234_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/fcc9eb435f674df01701011dcb3b4627.webp"
"MediaSize" => 70987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-fcc9eb435f674df01701011dcb3b4627.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted bedroom featuring a ceiling fan with integrated lighting, recessed ceiling speaker, and a wall-mounted television"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29920234_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/83b960f1b3d727cbc1edceb6aea2cac3.webp"
"MediaSize" => 75613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-83b960f1b3d727cbc1edceb6aea2cac3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a freestanding tub, hexagonal floor tile, dual vanity with blue cabinetry, white countertops, and black-framed mirrors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29920234_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/58b2e16a7d3ef6cb58f06ef58c30bca2.webp"
"MediaSize" => 77453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-58b2e16a7d3ef6cb58f06ef58c30bca2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a freestanding soaking tub, dual vanity with white countertops, hexagon tile flooring, and white plantation shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29920234_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/edfaca8e83f6c5740472575b9ce00861.webp"
"MediaSize" => 74342
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-edfaca8e83f6c5740472575b9ce00861.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Upper-level hallway featuring hardwood flooring, crown molding, recessed lighting, and a stone accent wall visible from the railing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29920234_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/554dda5b77616f6967991fb157981091.webp"
"MediaSize" => 69059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-554dda5b77616f6967991fb157981091.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring a prominent accent wall, soft carpet flooring, and a window with plantation shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29920234_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/19095508ccf7379f0465c436723f38f1.webp"
"MediaSize" => 80967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-19095508ccf7379f0465c436723f38f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light-filled bedroom featuring a double door exterior entry, wall-to-wall carpeting, recessed lighting, and a white baseboard trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29920234_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/e444b0f6098e7b54fb8d43257a6998bb.webp"
"MediaSize" => 59347
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-e444b0f6098e7b54fb8d43257a6998bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a vessel sink, wood-finish vanity with open shelving, subway tile, and a window with plantation shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29920234_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/1154de81f2aeb17076e8a3ed3ac9cadc.webp"
"MediaSize" => 75259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-1154de81f2aeb17076e8a3ed3ac9cadc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious recreation room featuring light gray carpeting, white trim, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29920234_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/a8776339cb0fa5b286e908e3460eee28.webp"
"MediaSize" => 90584
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-a8776339cb0fa5b286e908e3460eee28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious interior room featuring light gray walls, neutral carpet flooring, and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29920234_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/2b8f1d935e400ade4c30889cd0995409.webp"
"MediaSize" => 57514
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-2b8f1d935e400ade4c30889cd0995409.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry area featuring a stacked washer and dryer, white shaker-style cabinetry, and a utility sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29920234_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/f178ad490e04afa18ce7ab71198bd025.webp"
"MediaSize" => 81865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-f178ad490e04afa18ce7ab71198bd025.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring light-colored patterned carpeting, a large window with white plantation shutters, a multi-panel bifold door, a dark accent wall, and recessed ceiling lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29920234_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/9aaa9eb4c151ca3272b019ec6f78f653.webp"
"MediaSize" => 75395
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-9aaa9eb4c151ca3272b019ec6f78f653.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive carpeted area featuring light gray walls, white trim, recessed lighting, and window shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29920234_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/2e261b48aa5a2ec28a90ab0cf9373ffd.webp"
"MediaSize" => 63936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-2e261b48aa5a2ec28a90ab0cf9373ffd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brightly painted interior room featuring textured carpet flooring, white baseboards, and a single window with white plantation shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29920234_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/3426e00a06c3d260be7ed23a99cf0a69.webp"
"MediaSize" => 187119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-3426e00a06c3d260be7ed23a99cf0a69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29920234_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/58c2b9d945e41705428d75772e8b3add.webp"
"MediaSize" => 166897
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-58c2b9d945e41705428d75772e8b3add.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Curved inground pool surrounded by paver patio"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29920234_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/6bbe7d614ca11b0139d33e2e6a01eed3.webp"
"MediaSize" => 121478
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-6bbe7d614ca11b0139d33e2e6a01eed3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Curved swimming pool with a diving board, surrounded by paver stone decking"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29920234_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/3800449b7eced6a132855f74e38f6e6f.webp"
"MediaSize" => 147310
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-3800449b7eced6a132855f74e38f6e6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Outdoor living area featuring a swimming pool with integrated spa, paver patio, multi-level wood deck, and a wood pergola"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29920234_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/25725f5aaa99a0b1a03bd42cc48b2dfa.webp"
"MediaSize" => 112676
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-25725f5aaa99a0b1a03bd42cc48b2dfa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Curved swimming pool with a diving board, surrounded by extensive paver patio"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29920234_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/d84a3b435ce74dc4fc3f0decc25b1864.webp"
"MediaSize" => 223077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-d84a3b435ce74dc4fc3f0decc25b1864.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Outdoor oasis featuring a freeform pool with integrated spa, paver patio, pergola, and an additional freestanding hot tub"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29920234_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/4388112c9800d56478147115b0140b79.webp"
"MediaSize" => 242420
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-4388112c9800d56478147115b0140b79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29920234_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/49280dd67aa870011353a43f5f42eee8.webp"
"MediaSize" => 174727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-49280dd67aa870011353a43f5f42eee8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Concrete patio featuring a dark metal railing, brown vertical siding, and a partial pergola structure"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29920234_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/bd1db63aed0f5260c59e634f800394d7.webp"
"MediaSize" => 181682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-bd1db63aed0f5260c59e634f800394d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Covered front porch featuring a prominent wood-finish column, a concrete floor, and black metal railings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29920234_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/302b81a9b9ea353ade0d4b4b8b8cf5be.webp"
"MediaSize" => 48237
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-302b81a9b9ea353ade0d4b4b8b8cf5be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29920234_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/59c074550051ac94453af6e879b92280.webp"
"MediaSize" => 52780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-59c074550051ac94453af6e879b92280.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29920234_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920234/e9a129a8be8f37ee48dd3af0061d7271.webp"
"MediaSize" => 47409
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920234/thumbnail-e9a129a8be8f37ee48dd3af0061d7271.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840985"
"ResourceRecordKey" => "29920234"
"ModificationTimestamp" => "2026-06-18T04:19:37Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29920234')"
+"ID": "1542297"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 296136" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24868
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1905477" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24841
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29920234'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25185
+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 '29920234'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25203
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25201
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31526231"
+"ListingKey": "29920234"
+"ListingId": "40840985"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-20"
+"OpenHouseStartTime": "2026-06-20T14:00:00Z"
+"OpenHouseEndTime": "2026-06-20T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-18T15:47:17Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31526231')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29920234' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5797441 43.4507512)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25276
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25250
+post_id: "1542528"
+post_author: 1
+"ListingKey": "29920639"
+"ListingId": "40839251"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T14:25:12Z"
+"RFModificationTimestamp": "2026-06-18T14:26:32Z"
+"ListPrice": 1270000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3505.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0H9"
+"UnparsedAddress": "350 CANADA PLUM Street, Waterloo, Ontario N2V0H9"
+"Coordinates": array:2 [
0 => -80.5983757
1 => 43.4579421
]
+"Latitude": 43.4579421
+"Longitude": -80.5983757
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Better Than New – 2025 Built Home in Prestigious Vista Hills! Nestled in one of Waterloo’s most desirable communities and located within the highly acclaimed Laurel Heights Secondary School boundary, this stunning 4-bedroom family home offers over 3,500 sq. ft. of beautifully finished living space. Enjoy exceptional convenience with easy access to Costco, The Boardwalk, restaurants, parks, and transit. The thoughtfully designed main floor features 9-foot ceilings, engineered hardwood flooring in the great room, elegant pot lighting throughout, and a spacious open-concept layout perfect for modern living. The upgraded chef’s kitchen showcases quartz countertops, a large centre island with breakfast bar, premium cabinetry, and stainless steel appliances. A convenient main-floor laundry and mudroom adds everyday functionality. Upstairs, you’ll find four generously sized bedrooms, including a luxurious primary retreat complete with a walk-in closet and a versatile sitting area ideal for a home office, reading nook, or entertainment space. The professionally finished walk-out basement, completed by the builder, includes a full bathroom and offers outstanding potential for a future legal secondary suite or in-law setup, subject to municipal approvals—an excellent opportunity for additional rental income. Step outside and enjoy direct access to the scenic Vista Hills trail system, perfect for walking, cycling, and year-round outdoor enjoyment. Surrounded by playgrounds, greenspace, and the city’s largest forest park, this family-friendly neighbourhood offers the perfect blend of nature and convenience. As an added bonus, the builder will complete the rear deck featuring elegant glass railings, creating the perfect outdoor space for relaxing or entertaining. A rare opportunity to own a move-in-ready, better-than-new home in one of Waterloo’s most sought-after communities. Don't miss it! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CreationDate": "2026-06-18T14:25:22.085552+00:00"
+"Directions": "Sundew Drive and Mayapple Street"
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Brick"
2 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2050676"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T12:51:04Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T14:11:35Z"
+"Stories": "2.0"
+"StreetName": "CANADA PLUM"
+"StreetNumber": "350"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "7782"
+"VirtualTourURLUnbranded": "https://youriguide.com/350_canada_plum_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [
"RoomKey" => "1662064009"
"RoomType" => "Bedroom"
"ListingId" => "40839251"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29920639"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T14:11:35.17Z"
]
1 => array:11 [
"RoomKey" => "1662064010"
"RoomType" => "3pc Bathroom"
"ListingId" => "40839251"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29920639"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T14:11:35.17Z"
]
2 => array:11 [
"RoomKey" => "1662064011"
"RoomType" => "Other"
"ListingId" => "40839251"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29920639"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T14:11:35.17Z"
]
3 => array:11 [
"RoomKey" => "1662064012"
"RoomType" => "Other"
"ListingId" => "40839251"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29920639"
"RoomLength" => null
"RoomDimensions" => "17'11'' x 14'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T14:11:35.17Z"
]
4 => array:11 [
"RoomKey" => "1662064013"
"RoomType" => "Family room"
"ListingId" => "40839251"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29920639"
"RoomLength" => null
"RoomDimensions" => "16'7'' x 16'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T14:11:35.17Z"
]
5 => array:11 [
"RoomKey" => "1662064014"
"RoomType" => "4pc Bathroom"
…9
]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29920639/350-canada-plum-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2475
+"BelowGradeFinishedArea": 1030
+"OriginalEntryTimestamp": "2026-06-18T12:51:03.89Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1325963"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29920639')"
+"ID": "1542528"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25272
+post_id: "1538007"
+post_author: 1
+"ListingKey": "29914132"
+"ListingId": "40838042"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T16:25:14Z"
+"RFModificationTimestamp": "2026-06-17T16:34:14Z"
+"ListPrice": 1200000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2655.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0E3"
+"UnparsedAddress": "626 WILD RYE Street, Waterloo, Ontario N2V0E3"
+"Coordinates": array:2 [
0 => -80.6008015
1 => 43.4593743
]
+"Latitude": 43.4593743
+"Longitude": -80.6008015
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 626 Wild Rye Street, a quintessential 4-bedroom, 3.5-bathroom home located in Waterloo's highly sought-after Vista Hills community. This exceptional property seamlessly blends comfort, functionality, and modern luxury. Pride of ownership is evident the moment you arrive and take in the home's outstanding curb appeal. This is far from your typical builder-basic home. Extensive upgrades and high-quality finishes can be found throughout. The thoughtfully designed mudroom entry from the garage has been meticulously planned with custom storage, benches, and hooks to keep everyday essentials organized and easily accessible. The main floor is the definition of open-concept living, anchored by a show-stopping kitchen featuring top-of-the-line appliances, premium finishes, and a dedicated bar area complete with an additional wine fridge. The built-in Sonos sound system throughout the home is a feature you'll quickly learn not to live without, setting the perfect atmosphere whether hosting guests or enjoying a quiet evening at home. Step outside to a professionally designed backyard retreat complete with outdoor dining, comfortable seating around a gas fire pit and a gas BBQ. For golf enthusiasts, a private putting green provides the perfect opportunity to work on those three-foot putts between rounds. The second floor offers four generously sized bedrooms, abundant storage, and three full bathrooms. The impressive primary suite features separate his-and-her walk-in closets and a private spa-inspired ensuite. Laundry day becomes effortless with the convenience of a dedicated second-floor laundry room. Located close to top-rated schools, scenic walking trails, parks, and all the amenities Waterloo has to offer. All furnishings are negotiable, creating a rare opportunity for buyers seeking a move-in-ready lifestyle. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Wine Fridge"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T06:44:18.154147+00:00"
+"Directions": "COLUMBIA ST W TOSUNDEW DR TO MAYAPPLE ST TO WOOD LILY ST TO WILD RYE ST"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1878141"
+"ListOfficeKey": "156288"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T04:31:52Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T16:11:47Z"
+"Stories": "2.0"
+"StreetName": "WILD RYE"
+"StreetNumber": "626"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "7480"
+"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/29914132/626-wild-rye-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "NR"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2655
+"OriginalEntryTimestamp": "2026-06-17T04:31:52.3Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1204909"
+"ListOfficeNationalAssociationId": "1112493"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914132')"
+"ID": "1538007"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25249
+post_id: "1534852"
+post_author: 1
+"ListingKey": "29908777"
+"ListingId": "40839715"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T22:15:05Z"
+"RFModificationTimestamp": "2026-06-16T22:16:00Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1487.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2V2"
+"UnparsedAddress": "600 WHITE ELM Boulevard Unit# 9, Waterloo, Ontario N2V2V2"
+"Coordinates": array:2 [
0 => -80.5870471
1 => 43.4667674
]
+"Latitude": 43.4667674
+"Longitude": -80.5870471
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained carpet-free 3-bedroom, 2-bathroom townhome in the highly sought-after Laurelwood/Columbia Forest community of Waterloo. Featuring elegant oak hardwood flooring throughout the living area and the entire second floor, this home offers both timeless style and easy maintenance. The bright and functional open-concept main floor boasts spacious living and dining areas with large windows and sliding doors that flood the space with natural light and lead to a private deck and backyard—perfect for entertaining or relaxing outdoors. The well-appointed kitchen provides ample cabinetry and workspace, while the upper level offers three generous bedrooms, including a spacious primary bedroom with a walk-in closet and convenient access to a full bathroom. The basement includes a bathroom rough-in, presenting an excellent opportunity to add a future washroom and customize additional living space to meet your needs. Complete with an attached garage and driveway parking, this home is ideally located steps to parks, trails, public transit, and top-rated schools, and just minutes from the Boardwalk Shopping Centre, YMCA, both universities, and all major amenities. The condo fees provide exceptional value by covering major exterior components, including roof, windows, and exterior doors repair and replacement, offering added peace of mind and reduced long-term maintenance costs. An outstanding opportunity for families, first-time buyers, or investors to own in one of Waterloo’s most desirable neighbourhoods. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Garage door opener"
]
+"AssociationFee": "713.32"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:53:42.414855+00:00"
+"Directions": "Erbsville Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2055634"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "0"
+"PhotosChangeTimestamp": "2026-06-16T13:30:50Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T22:09:47Z"
+"Stories": "2.0"
+"StreetName": "WHITE ELM"
+"StreetNumber": "600"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3308.52"
+"Utilities": array:1 [
0 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/9_600_white_elm_blvd_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/29908777/600-white-elm-boulevard-unit-9-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R7"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1367
+"BelowGradeFinishedArea": 120
+"OriginalEntryTimestamp": "2026-06-16T13:30:49.96Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1330898"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:27 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908777')"
+"ID": "1534852"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25273
+post_id: "1531332"
+post_author: 1
+"ListingKey": "29906172"
+"ListingId": "X13447102"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T20:30:18Z"
+"RFModificationTimestamp": "2026-06-15T20:55:52Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2K6"
+"UnparsedAddress": "629B SETTLERSFIELD COURT, Waterloo, Ontario N2T2K6"
+"Coordinates": array:2 [
0 => -80.569765
1 => 43.449035
]
+"Latitude": 43.449035
+"Longitude": -80.569765
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Prepare to fall in love with this beautifully updated back-split with separate side entrance. Located in a quiet family friendly neighbourhood close to the Boardwalk Costco and more. This 2 plus bedroom boasts 3 full bathrooms, open concept floor plan featuring Stainless steel appliance, quartz countertops, upgraded kitchen cabinets and lighting package plus an attractive staircase. Upstairs you will find 2 bedrooms plus built in laundry and 4 piece bath. You'll love the family-room with large windows for tons of natural light. Full 4 piece bath is within easy reach, there is a side entrance leading to a great deck and a fully fenced pie shaped back yard with mature trees. Looking for extra space then basement level features a brand new inlaw with 2nd kitchen with appliances, good size 3rd bedroom or rec-room plus another 3 piece bathroom for the teens. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
6 => "Water Heater"
]
+"Basement": array:7 [
0 => "Finished"
1 => "Full"
2 => "Apartment in basement"
3 => "Separate entrance"
4 => "N/A"
5 => "N/A"
6 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T20:55:42.913447+00:00"
+"Directions": "Cross Streets: Pinerow. ** Directions: ERBSVILLE ROAD TO RUMMERLHARDT DR TO PINEROW CRES."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2152762"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "24 x 121.7 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T20:02:49Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T20:23:02Z"
+"StreetName": "Settlersfield"
+"StreetNumber": "629B"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "3850"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/629_b_settlersfield_ct_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29906172/629b-settlersfield-court-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 24.0
+"OriginalEntryTimestamp": "2026-06-15T20:02:49.07Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1404760"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29906172')"
+"ID": "1531332"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25270
+post_id: "1525564"
+post_author: 1
+"ListingKey": "29898161"
+"ListingId": "40839319"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T19:45:02Z"
+"RFModificationTimestamp": "2026-06-13T19:46:04Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1322.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2K6"
+"UnparsedAddress": "629 SETTLERSFIELD Court Unit# B, Waterloo, Ontario N2T2K6"
+"Coordinates": array:2 [
0 => -80.569755
1 => 43.4490121
]
+"Latitude": 43.4490121
+"Longitude": -80.569755
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Prepare to fall in love with this beautifully updated backsplit with separate side entrance. Located in a quiet family friendly neighbourhood close to the Boardwalk Costco and more. This 2 plus bedroom boasts 3 full bathrooms, open concept floor plan featuring Stainless steel appliance, quartz countertops, upgraded kitchen cabinets and lighting package plus an attractive staircase. Upstairs you will find 2 bedrooms plus built in laundry and 4 piece bath. You'll love the familyroom with large windows for tons of natural light. Full 4 piece bath is within easy reach, there is a side entrance leading to a great deck and a fully fenced pie shaped back yard with mature trees. Looking for extra space then basement level features a brand new inlaw with 2nd kitchen with appliances, good size 3rd bedroom or recroom plus another 3 piece bathroom for the teens. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T21:37:11.360335+00:00"
+"Directions": "ERBSVILLE ROAD TO RUMMERLHARDT DR TO PINEROW CRES"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1948781"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-06-12T21:10:21Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T19:39:15Z"
+"Stories": "3.0"
+"StreetName": "SETTLERSFIELD"
+"StreetNumber": "629"
+"StreetSuffix": "Court"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "4025"
+"Utilities": array:1 [
0 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/629_b_settlersfield_ct_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29898161/629-settlersfield-court-unit-b-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1563914"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76807"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 24.0
+"AboveGradeFinishedArea": 829
+"BelowGradeFinishedArea": 493
+"OriginalEntryTimestamp": "2026-06-12T21:10:19.47Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1243289"
+"ListOfficeNationalAssociationId": "1380559"
+"CoListAgentNationalAssociationId": "1069671"
+"CoListOfficeNationalAssociationId": "1004370"
+"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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898161')"
+"ID": "1525564"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25246
+post_id: "1524682"
+post_author: 1
+"ListingKey": "29895200"
+"ListingId": "40838845"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T00:40:13Z"
+"RFModificationTimestamp": "2026-06-13T00:41:23Z"
+"ListPrice": 1179000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3112.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2V4"
+"UnparsedAddress": "725 ZURICH Drive, Waterloo, Ontario N2V2V4"
+"Coordinates": array:2 [
0 => -80.58337
1 => 43.4566032
]
+"Latitude": 43.4566032
+"Longitude": -80.58337
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located in the highly desirable neighbourhood of Clair Hills in West Waterloo, 725 Zurich Drive is a rare opportunity for growing families seeking space, functionality, and an unbeatable location! Boasting over 3000 sq/ft of finished living space, this impressive 5 Bed/3 Bath home offers a thoughtfully designed open concept layout with incredible versatility throughout. The bright and welcoming main floor serves as the heart of the home, featuring spacious principal rooms ideal for everyday living and entertaining. Large windows provide an abundance of natural light while creating a warm and inviting atmosphere. Recent major updates including a new roof with solar panels (~5k/Yr ROI), new windows, new furnace, and new on-demand water heater provide exceptional value and peace of mind for years to come. Upstairs, the spacious primary bedroom offers a comfortable retreat with a large en-suite, while an additional bedroom and full bathroom complete the upper level with functionality and convenience. A true standout feature of this home is the fully finished basement, offering exceptional additional living space with *3 generously sized bedrooms, making it ideal for larger families, multi-generational living, overnight guests, or flexible work-from-home options. Complete with a full bathroom and ample space for recreation or additional family living, the lower level adds tremendous versatility and value rarely found in homes within this neighbourhood. Step outside to enjoy the fully fenced backyard featuring a private patio area and storage shed, the perfect setting for relaxing evenings, entertaining guests, or safe outdoor play for children and pets alike. Ideally located near top-rated schools including Vista Hills and Laurel Heights Secondary School, as well as the scenic GeoTime trails and surrounding forest, this family-friendly location offers the perfect balance of convenience and nature. Pride of ownership is evident throughout this beautifully maintained home! (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Satellite Dish"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:48:03.419047+00:00"
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Brick"
2 => "Stone"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2052274"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Corner Site"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T15:31:43Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T00:31:49Z"
+"Stories": "1.0"
+"StreetName": "ZURICH"
+"StreetNumber": "725"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "6877"
+"VirtualTourURLUnbranded": "https://youriguide.com/725_zurich_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/29895200/725-zurich-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1587
+"BelowGradeFinishedArea": 1525
+"OriginalEntryTimestamp": "2026-06-12T15:31:43.37Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1327496"
+"ListOfficeNationalAssociationId": "1004387"
+"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": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895200')"
+"ID": "1524682"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1524092"
+post_author: 1
+"ListingKey": "29896571"
+"ListingId": "X13438200"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T22:55:09Z"
+"RFModificationTimestamp": "2026-06-12T22:58:47Z"
+"ListPrice": 719000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P6"
+"UnparsedAddress": "635 ROYAL FERN STREET, Waterloo, Ontario N2V2P6"
+"Coordinates": array:2 [
0 => -80.589798
1 => 43.464848
]
+"Latitude": 43.464848
+"Longitude": -80.589798
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "RARE FIND! Prime location with amazing privacy and forest views! This fully finished detached 3 bedroom, 3 bathroom home offers an exceptional layout and an excellent finished basement. As you pull up to the home, you'll immediately notice its charming curb appeal. Step inside and you'll find a bright, welcoming space that feels just right. The care and updates throughout the home are evident at every turn. The main floor features an open-concept kitchen, dining, and living area with a vaulted ceiling and beautiful patio doors leading to your backyard paradise. The yard includes a new deck (2024) and a fenced yard, creating a beautiful, peaceful retreat that is still low maintenance. Upstairs, the spacious primary bedroom overlooks the backyard and offers plenty of room to relax. The stunning, spa-like primary ensuite, updated in 2023, is truly impressive. Two additional bedrooms complete the upper level. The basement features another full bathroom, plenty of storage space, a home office, and a large recreation room. The location is fantastic, close to top rated schools, beautiful walking trails, shopping, and more! Don't miss this rare opportunity to own a private, move-in-ready home in an outstanding location. ** SEE VIDEO FOR FULL TOUR!! ** WOW! (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T18:21:27.298705+00:00"
+"Directions": "Cross Streets: Erbville Rd and Columbia Forst Blvd. ** Directions: Erbsville Rd, West on Columbia Forest Blvd, right on Royal Fern St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2246631"
+"ListOfficeKey": "286835"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "27.8 x 106.1 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-12T22:49:11Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T22:49:11Z"
+"Stories": "2.0"
+"StreetName": "ROYAL FERN"
+"StreetNumber": "635"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4225.17"
+"VirtualTourURLUnbranded": "https://youtu.be/6ORw7Bao_3A"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29896571/635-royal-fern-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 27.9
+"OriginalEntryTimestamp": "2026-06-12T17:56:38.8Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1485484"
+"ListOfficeNationalAssociationId": "1364242"
+"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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896571')"
+"ID": "1524092"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25274
+post_id: "1521301"
+post_author: 1
+"ListingKey": "29891893"
+"ListingId": "X13433902"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T12:30:33Z"
+"RFModificationTimestamp": "2026-06-14T12:39:20Z"
+"ListPrice": 1049000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2R2"
+"UnparsedAddress": "450 WESTHAVEN STREET, Waterloo, Ontario N2T2R2"
+"Coordinates": array:2 [
0 => -80.566908
1 => 43.445283
]
+"Latitude": 43.445283
+"Longitude": -80.566908
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 450 Westhaven Street, a beautifully upgraded Ritz Homes residence in one of Waterloo's most sought after family neighbourhoods. Less than one year old, this stunning home offers approximately 2,320 sq ft above grade plus a finished basement, featuring quartz countertops throughout, a designer kitchen with a custom coffee bar, engineered hardwood flooring, oak staircases with black metal pickets, and no carpet throughout. The finished lower level adds exceptional versatility with a spacious recreation room, additional bedroom, full bathroom, and a convenient kitchenette complete with a sink, making it ideal for extended family, guests, or multi generational living. Complete with 200 amp service, central air conditioning, gas lines for the stove and BBQ, and numerous builder upgrades, this move in ready home offers the perfect blend of style, comfort, and functionality.Ideally situated in the highly desirable Westvale area of Waterloo, this home is surrounded by excellent schools, beautiful parks, walking trails, playgrounds, and family friendly amenities. Enjoy convenient access to shopping, restaurants, Costco, The Boardwalk, universities, public transit, and major commuter routes including Highway 7/8. Whether you're raising a family, working from home, or simply looking for a newer home in a thriving community, 450 Westhaven Street delivers exceptional value in one of Waterloo's most convenient and connected locations. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
]
+"Basement": array:7 [
0 => "Finished"
1 => "Full"
2 => "Apartment in basement"
3 => "Separate entrance"
4 => "N/A"
5 => "N/A"
6 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T21:22:24.773387+00:00"
+"Directions": "Cross Streets: Erb Street W to Westhaven Street. ** Directions: Erb Street W."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2071055"
+"ListOfficeKey": "148048"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "Guest Suite"
2 => "In-Law Suite"
]
+"LotSizeDimensions": "31.5 x 113.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T20:54:15Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-14T12:24:35Z"
+"Stories": "2.0"
+"StreetName": "Westhaven"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3794.36"
+"VirtualTourURLUnbranded": "https://youriguide.com/450_westhaven_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29891893/450-westhaven-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "SR-1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 31.6
+"OriginalEntryTimestamp": "2026-06-11T20:54:14.99Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1346258"
+"ListOfficeNationalAssociationId": "1177786"
+"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": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891893')"
+"ID": "1521301"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25275
+post_id: "1520602"
+post_author: 1
+"ListingKey": "29889823"
+"ListingId": "40838151"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T18:50:08Z"
+"RFModificationTimestamp": "2026-06-13T18:53:44Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2301.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V4"
+"UnparsedAddress": "729 BRANDENBURG Boulevard, Waterloo, Ontario N2T2V4"
+"Coordinates": array:2 [
0 => -80.5790115
1 => 43.4569573
]
+"Latitude": 43.4569573
+"Longitude": -80.5790115
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 729 Brandenburg Boulevard, a beautifully maintained and thoughtfully updated 3-bedroom, 3-bathroom detached home in one of Waterloo’s most sought-after family-friendly neighbourhoods. Offering the perfect blend of comfort, functionality, and convenience, this move-in-ready home is ideal for growing families and busy professionals alike. The main floor features a bright and inviting layout, where a central staircase creates distinct living spaces while maintaining an open and connected feel. Spacious principal rooms provide plenty of room for everyday living and entertaining, while direct access to the backyard seamlessly extends your living space outdoors. Upstairs, you'll find three generously sized bedrooms and a well-appointed main bathroom designed for everyday family living. The finished basement adds valuable additional space with a large rec room, versatile den, full bathroom, cold cellar, and utility room—perfect for a home office, guest space, or recreation area. A rare detached double-car garage accessed from the rear laneway, along with direct gated access to the backyard, offers exceptional convenience, privacy, and flexibility. Ideally located just minutes from shopping, restaurants, The Boardwalk, Costco, Laurel Creek Conservation Area, parks, and excellent schools, this home offers an outstanding lifestyle in a highly desirable Waterloo community. Meticulously cared for and perfectly situated, this is a home you won't want to miss. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T20:31:02.889440+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2011048"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T17:10:34Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T18:39:40Z"
+"Stories": "2.0"
+"StreetName": "BRANDENBURG"
+"StreetNumber": "729"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4644"
+"VirtualTourURLUnbranded": "https://youriguide.com/729_brandenburg_blvd_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/29889823/729-brandenburg-boulevard-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1549
+"BelowGradeFinishedArea": 752
+"OriginalEntryTimestamp": "2026-06-11T17:10:33.94Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1292484"
+"ListOfficeNationalAssociationId": "1004357"
+"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": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889823')"
+"ID": "1520602"
}
]
+success: true
+page_size: 9
+page_count: 12
+count: 105
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]