array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29871836 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: "1508532"
+post_author: 1
+"ListingKey": "29871836"
+"ListingId": "40837314"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T02:25:48Z"
+"RFModificationTimestamp": "2026-06-09T02:32:31Z"
+"ListPrice": 1595000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.61
+"LivingArea": 4389.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2P2C8"
+"UnparsedAddress": "355 EDGEHILL Drive, Kitchener, Ontario N2P2C8"
+"Coordinates": array:2 [
0 => -80.3999946
1 => 43.4045066
]
+"Latitude": 43.4045066
+"Longitude": -80.3999946
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This one-of-a-kind property is a rare offering in the highly sought-after neighborhood backing onto Riveredge Golf Course with easy access to the 401 for commuting. Seating on beautifully landscaped 0.61 acre lot with a heated in-ground pool. Boasting over 4600 Sq Ft of living space, 4+1 bedrooms, 5 baths, 2 fireplaces, and a 3-car garage with circular drive-way that fits 10+ cars . The interior showcases a blend of transitional and contemporary design featuring unique architectural details. The main floor greets with large bright spaces which include a formal living/dining room, family room. The star of the main level is the totally redone kitchen facing family room which is ideal for entertaining family and friends . 2nd level showcases 4 bedrooms and another family room , primary bedroom with walk-in closet, 5pc ensuite. This home also offers a 1400+sqft finished walk-out basement with its own entrance- Larger brought windows ,one bedroom,full bath and kitchenette providing a great opportunity for a multi-generational living or a nanny suite. New circular driveway, exterior, third garage and stairs to backyard are other features of this house.. The backyard have been stylishly landscaped w/ terraced paths(new), lush gardens, gazebo and good size pool. Over 180000 spent in the last two years. This is a truly magnificent and unique offering that allows for resort-style living .A perfect forever home! Call for a private viewing (id:62783)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Range - Gas"
5 => "Dishwasher"
6 => "Dryer"
7 => "Oven - Built-In"
8 => "Hood Fan"
9 => "Garage door opener"
10 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-08T20:34:53.241645+00:00"
+"Directions": "King St. E/ Baxter/ Edgehill"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564018"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Ravine"
1 => "Skylight"
2 => "Automatic Garage Door Opener"
3 => "In-Law Suite"
]
+"LotSizeDimensions": "0.61"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T02:22:19Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T02:22:19Z"
+"Stories": "2.0"
+"StreetName": "EDGEHILL"
+"StreetNumber": "355"
+"StreetSuffix": "Drive"
+"SubdivisionName": "329 - Hidden Valley/Pioneer Tower"
+"TaxAnnualAmount": "5331"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:19 [
0 => array:11 [
"RoomKey" => "1655429222"
"RoomType" => "5pc Bathroom"
"ListingId" => "40837314"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29871836"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T02:20:12.79Z"
]
1 => array:11 [
"RoomKey" => "1655429223"
"RoomType" => "Kitchen"
"ListingId" => "40837314"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29871836"
"RoomLength" => null
"RoomDimensions" => "15'5'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T02:20:12.79Z"
]
2 => array:11 [
"RoomKey" => "1655429224"
"RoomType" => "5pc Bathroom"
"ListingId" => "40837314"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29871836"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T02:20:12.79Z"
]
3 => array:11 [
"RoomKey" => "1655429225"
"RoomType" => "Bedroom"
"ListingId" => "40837314"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29871836"
"RoomLength" => null
"RoomDimensions" => "16'2'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T02:20:12.79Z"
]
4 => array:11 [
"RoomKey" => "1655429226"
"RoomType" => "Recreation room"
"ListingId" => "40837314"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29871836"
"RoomLength" => null
"RoomDimensions" => "38'1'' x 25'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T02:20:12.8Z"
]
5 => array:11 [
"RoomKey" => "1655429227"
"RoomType" => "Loft"
"ListingId" => "40837314"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29871836"
"RoomLength" => null
"RoomDimensions" => "16'2'' x 21'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T02:20:12.8Z"
]
6 => array:11 [
"RoomKey" => "1655429228"
"RoomType" => "5pc Bathroom"
"ListingId" => "40837314"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29871836"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T02:20:12.8Z"
]
7 => array:11 [
"RoomKey" => "1655429229"
"RoomType" => "Bedroom"
"ListingId" => "40837314"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29871836"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T02:20:12.8Z"
]
8 => array:11 [
"RoomKey" => "1655429230"
"RoomType" => "Bedroom"
"ListingId" => "40837314"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29871836"
"RoomLength" => null
"RoomDimensions" => "13'1'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T02:20:12.8Z"
]
9 => array:11 [
"RoomKey" => "1655429231"
"RoomType" => "Bedroom"
"ListingId" => "40837314"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29871836"
"RoomLength" => null
"RoomDimensions" => "13'1'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T02:20:12.8Z"
]
10 => array:11 [
"RoomKey" => "1655429232"
"RoomType" => "Primary Bedroom"
"ListingId" => "40837314"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29871836"
"RoomLength" => null
"RoomDimensions" => "20'1'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T02:20:12.8Z"
]
11 => array:11 [
"RoomKey" => "1655429233"
"RoomType" => "Mud room"
"ListingId" => "40837314"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29871836"
"RoomLength" => null
"RoomDimensions" => "7'5'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T02:20:12.8Z"
]
12 => array:11 [
"RoomKey" => "1655429234"
"RoomType" => "Living room"
"ListingId" => "40837314"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29871836"
"RoomLength" => null
"RoomDimensions" => "19'11'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T02:20:12.8Z"
]
13 => array:11 [
"RoomKey" => "1655429235"
"RoomType" => "Laundry room"
"ListingId" => "40837314"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29871836"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 6'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T02:20:12.8Z"
]
14 => array:11 [
"RoomKey" => "1655429236"
"RoomType" => "Kitchen"
"ListingId" => "40837314"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29871836"
"RoomLength" => null
"RoomDimensions" => "19'11'' x 13'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T02:20:12.81Z"
]
15 => array:11 [
"RoomKey" => "1655429237"
"RoomType" => "Foyer"
"ListingId" => "40837314"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29871836"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 5'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T02:20:12.81Z"
]
16 => array:11 [
"RoomKey" => "1655429238"
"RoomType" => "Family room"
"ListingId" => "40837314"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29871836"
"RoomLength" => null
"RoomDimensions" => "20'1'' x 15'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T02:20:12.81Z"
]
17 => array:11 [
"RoomKey" => "1655429239"
"RoomType" => "Dining room"
"ListingId" => "40837314"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29871836"
"RoomLength" => null
"RoomDimensions" => "14'11'' x 13'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T02:20:12.81Z"
]
18 => array:11 [
"RoomKey" => "1655429240"
"RoomType" => "2pc Bathroom"
"ListingId" => "40837314"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29871836"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T02:20:12.81Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29871836/355-edgehill-drive-kitchener"
+"ParkingTotal": 13
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 134.0
+"AboveGradeFinishedArea": 3075
+"BelowGradeFinishedArea": 1314
+"OriginalEntryTimestamp": "2026-06-08T19:19:42.31Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1107224"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:40 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29871836_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/ddeb8853c148023c313579865c01c2f2.webp"
"MediaSize" => 212988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-ddeb8853c148023c313579865c01c2f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story brick exterior featuring a covered entryway with columns, a prominent Japanese Maple, and a manicured lawn"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:25.69Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29871836_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/89c56cf8e93880fda623060fe833a87b.webp"
"MediaSize" => 197671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-89c56cf8e93880fda623060fe833a87b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:25.82Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29871836_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/d0834141f7677808063f8b809161ce31.webp"
"MediaSize" => 151526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-d0834141f7677808063f8b809161ce31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior residence with a covered entryway, a wide asphalt driveway with paver stone edging, a three-car garage, mature trees, and established landscaping"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:26.74Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29871836_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/1d9621f2f298148173971d50f0cd28cc.webp"
"MediaSize" => 149845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-1d9621f2f298148173971d50f0cd28cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Extensive property featuring a large swimming pool, paver patio, a separate garden area with terraced steps, an attached main residence with a gabled roof, and a paved driveway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:25.51Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29871836_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/5ce104331fd70df55f4d672d632639b7.webp"
"MediaSize" => 153795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-5ce104331fd70df55f4d672d632639b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial perspective showcasing two residential properties with expansive green spaces"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:25.66Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29871836_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/e56fb7f5c2c7cfe036e8d00e512a91b4.webp"
"MediaSize" => 127747
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-e56fb7f5c2c7cfe036e8d00e512a91b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial view showcasing a property with a verdant lawn, mature trees, and an asphalt driveway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:25.53Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29871836_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/76edf91be41009304efe7c6c8ddc769b.webp"
"MediaSize" => 56150
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-76edf91be41009304efe7c6c8ddc769b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Double entry doors in a rich dark finish, featuring full-length vertical hardware"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:25.53Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29871836_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/b22693ea163c5c1fe636e98db965d93f.webp"
"MediaSize" => 96310
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-b22693ea163c5c1fe636e98db965d93f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:25.32Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29871836_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/aec0d124ef72e80b57d312bf34e55d08.webp"
"MediaSize" => 102976
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-aec0d124ef72e80b57d312bf34e55d08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright living area featuring expansive windows, dark wood-finish flooring, white walls, recessed lighting, and a multi-level floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:25.32Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29871836_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/b4db4706e6d4a11b83eb4effd5ccfb90.webp"
"MediaSize" => 11200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-b4db4706e6d4a11b83eb4effd5ccfb90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring dark wood-finish flooring, a large bay window, and a skylight"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:23.47Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29871836_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/0fccfbe3ead3f6c4872e4d10b214ca36.webp"
"MediaSize" => 97449
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-0fccfbe3ead3f6c4872e4d10b214ca36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring rich wood-finish flooring, a contemporary bay window, and a skylight"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:25.46Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29871836_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/e27cc88ac290ecd52cbed8ddb14ee0d7.webp"
"MediaSize" => 63592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-e27cc88ac290ecd52cbed8ddb14ee0d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring dark wood-finish flooring and white walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:23.72Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29871836_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/4dddc1a877e3e77dc284c279efcef1e9.webp"
"MediaSize" => 82832
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-4dddc1a877e3e77dc284c279efcef1e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring wood-finish flooring, a contemporary fireplace with a white tile surround, and built-in shelving units"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:25.46Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29871836_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/3adef4ff049674376dcf2164a6f2ac91.webp"
"MediaSize" => 78034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-3adef4ff049674376dcf2164a6f2ac91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring a gas cooktop on a substantial island with dark stone countertops"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:27.24Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29871836_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/56e47d927607e793994d7e11c2d98f7a.webp"
"MediaSize" => 80030
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-56e47d927607e793994d7e11c2d98f7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring a gas cooktop on a central island with a stone-finish side panel, under-cabinet lighting, a stainless steel range hood, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:25.46Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29871836_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/c00b80940990b573d4a05ce2c19f8c87.webp"
"MediaSize" => 76570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-c00b80940990b573d4a05ce2c19f8c87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Gourmet kitchen featuring a large waterfall island with integrated cooktop, white cabinetry with gold-tone hardware, wood-finish flooring, recessed lighting, and a sliding glass door to exterior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:25.83Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29871836_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/98a73a9928b68a13e01ee75b98d9f021.webp"
"MediaSize" => 68781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-98a73a9928b68a13e01ee75b98d9f021.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white cabinetry with gold-tone hardware, white quartz countertops, under-cabinet lighting, a built-in refrigerator, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:25.83Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29871836_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/048727f50981328e49188342e36c9e31.webp"
"MediaSize" => 59093
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-048727f50981328e49188342e36c9e31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:25.83Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29871836_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/ca2f773f9b859515b0cad0c7e8d9ff74.webp"
"MediaSize" => 88419
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-ca2f773f9b859515b0cad0c7e8d9ff74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom vanity featuring a white countertop, black cabinetry, and a chrome-framed mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:26.76Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29871836_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/da4dbb5bd39291b7efaeddf2dcb55512.webp"
"MediaSize" => 74108
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-da4dbb5bd39291b7efaeddf2dcb55512.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Interior room featuring dark wood-finish flooring, light grey painted walls, and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:24.84Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29871836_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/b63446b5fec9657ec0d701c415f66620.webp"
"MediaSize" => 80255
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-b63446b5fec9657ec0d701c415f66620.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Vaulted ceiling living space featuring dark wood-finish flooring, a multi-pane window, and a decorative chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:25.48Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29871836_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/1ac8e042b21db25db6a14b8620c58f22.webp"
"MediaSize" => 79397
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-1ac8e042b21db25db6a14b8620c58f22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, a contemporary ceiling fixture, white baseboards, and crown molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:24.89Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29871836_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/cfa493379d7a0de659a7d026328bf0be.webp"
"MediaSize" => 66892
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-cfa493379d7a0de659a7d026328bf0be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bathroom featuring a dual-sink vanity with white cabinetry and chrome hardware, a glass-enclosed shower with a multi-function panel, and a toilet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:25.48Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29871836_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/e18de475a4bf2e82b711bb536db3a2c3.webp"
"MediaSize" => 92382
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-e18de475a4bf2e82b711bb536db3a2c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with patterned accent wall, dark wood-finish flooring, and a large window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:25.48Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29871836_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/b4d3e2bc1b5fb291e7c7929f8076304e.webp"
"MediaSize" => 70016
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-b4d3e2bc1b5fb291e7c7929f8076304e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, two large bifold door closets, a multi-pane window with white trim, and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-08T19:22:25.97Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29871836_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/fb84b228153e97aee4d3acf88c26d79f.webp"
"MediaSize" => 107657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-fb84b228153e97aee4d3acf88c26d79f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-09T02:22:17.41Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29871836_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/40afdd55786349920e7716add8b7f425.webp"
"MediaSize" => 115668
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-40afdd55786349920e7716add8b7f425.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-09T02:22:17.41Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29871836_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/cfd6b3b79052da7d580ca3aae5c03dfd.webp"
"MediaSize" => 88804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-cfd6b3b79052da7d580ca3aae5c03dfd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring a detailed fireplace with a stone mantel, dark wood-finish flooring, recessed lighting, and multiple windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-09T02:22:18.13Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29871836_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/022c82569480b1e05a0e9e6344e41cd4.webp"
"MediaSize" => 99668
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-022c82569480b1e05a0e9e6344e41cd4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, a white paneled ceiling, and light gray painted walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-09T02:22:18.52Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29871836_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/f4e89316a6ee3290b6f2c1ce5ab7d561.webp"
"MediaSize" => 222644
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-f4e89316a6ee3290b6f2c1ce5ab7d561.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive paver patio with a gazebo, offering dedicated outdoor living spaces"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-09T02:22:18.27Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29871836_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/dfa26f28013429b9fc5fd4c9fcc3101e.webp"
"MediaSize" => 89737
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-dfa26f28013429b9fc5fd4c9fcc3101e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Patio featuring a metal gazebo structure, paver stone hardscaping, and lush perimeter landscaping"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-09T02:22:18.52Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29871836_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/e26a7eb3abc999bd84d8f35e7903315e.webp"
"MediaSize" => 223671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-e26a7eb3abc999bd84d8f35e7903315e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "In-ground swimming pool with a liner, surrounded by a concrete patio"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-09T02:22:18.41Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29871836_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/472938eab34db3fe3b965a90c5e9a55d.webp"
"MediaSize" => 209361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-472938eab34db3fe3b965a90c5e9a55d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "In-ground swimming pool with integrated steps, surrounded by stone patio decking"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-09T02:22:18.39Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29871836_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/2f3af4cd867267eeb037fe3b2bc86fa4.webp"
"MediaSize" => 202761
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-2f3af4cd867267eeb037fe3b2bc86fa4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Pool"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-09T02:22:18.54Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29871836_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/0d01934602abbd2b71201c4b574309f9.webp"
"MediaSize" => 253120
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-0d01934602abbd2b71201c4b574309f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Mature tree canopy framing an expanse of natural vegetation"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-09T02:22:18.79Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29871836_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/b115d5bf914e43fab0169940d19cee16.webp"
"MediaSize" => 88088
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-b115d5bf914e43fab0169940d19cee16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-09T02:22:18.38Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29871836_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/1845aae7f9f673fd833ac846f2d8a1e5.webp"
"MediaSize" => 90361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-1845aae7f9f673fd833ac846f2d8a1e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Planter box featuring a vibrant display of mixed annuals, including white, purple, and pink blooms"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-09T02:22:18.4Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29871836_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/4021ac03133372aa2c7f194fee745195.webp"
"MediaSize" => 253120
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-4021ac03133372aa2c7f194fee745195.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Mature tree canopy framing an expanse of natural vegetation"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-09T02:22:18.43Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29871836_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/549885ee3ad49db227d28d00890c155e.webp"
"MediaSize" => 99860
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-549885ee3ad49db227d28d00890c155e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-09T02:22:18.37Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29871836_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29871836/18a4476e3077424342bd2cdaba82ebc4.webp"
"MediaSize" => 218389
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29871836/thumbnail-18a4476e3077424342bd2cdaba82ebc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior with prominent dual black entry doors beneath a covered portico"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837314"
"ResourceRecordKey" => "29871836"
"ModificationTimestamp" => "2026-06-09T02:22:18.4Z"
]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29871836')"
+"ID": "1508532"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 289541" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24726
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1564018" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24735
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29871836'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25227
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29871836'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25263
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29871836' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.3999946 43.4045066)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24820
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25275
+post_id: "1537351"
+post_author: 1
+"ListingKey": "29913216"
+"ListingId": "40840374"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T23:00:12Z"
+"RFModificationTimestamp": "2026-06-17T00:31:22Z"
+"ListPrice": 549900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2067.0
+"BuildingAreaTotal": 0
+"City": "Cambridge"
+"PostalCode": "N3H0C6"
+"UnparsedAddress": "420 LINDEN Drive Unit# 67, Cambridge, Ontario N3H0C6"
+"Coordinates": array:2 [
0 => -80.3822146
1 => 43.397999
]
+"Latitude": 43.397999
+"Longitude": -80.3822146
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "THE TOWNHOME THAT BROKE THE MOLD: 2,000+ SQFT OF SUN-DRENCHED, ABOVE-GRADE LIVING. From the street, the brick facade and elevated porch of 420 Linden Drive catch your eye. Step through the front door, and the design immediately breaks away from standard townhome expectations. There is no dark basement here. Instead, the ground level opens into a massive, sun-filled recreation room. Full-sized sliding glass doors look out onto the backyard, pulling the outdoors in and making it the perfect setting for an expansive media room, a home fitness studio, or a quiet office tucked away from the rest of the house. Moving up to the main level, the home transitions into a space built for connection. At the center of it all is a functional kitchen featuring dark cabinetry and a central island. It flows seamlessly into an open-concept living area bathed in natural light. Across the hall, a distinct formal dining room offers a dedicated setting for hosting dinner parties and long weekend brunches. The top floor is reserved entirely for rest. 3 bright bedrooms sit on this level, highlighted by a primary suite that serves as a quiet retreat, complete with its own private ensuite bathroom and walk-in closet. With over 2,000sqft of bright, above-grade living space, this home provides the layout flexibility and breathing room typically found in a detached property, all within a highly accessible Cambridge location. Walking distance to schools, bus stop, park, and a short drive to HWY 401, plus a minutes drive to Conestoga College. Virtually Staged. (id:62783)"
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T00:31:10.758823+00:00"
+"Directions": "PRESTON PARKWAY"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750694"
+"ListOfficeKey": "285293"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T22:51:19Z"
+"PhotosCount": 16
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T22:51:19Z"
+"Stories": "3.0"
+"StreetName": "LINDEN"
+"StreetNumber": "420"
+"StreetSuffix": "Drive"
+"SubdivisionName": "54 - Preston Heights"
+"TaxAnnualAmount": "4994"
+"VirtualTourURLUnbranded": "https://youriguide.com/67_420_linden_dr_cambridge_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1660807815"
"RoomType" => "Recreation room"
"ListingId" => "40840374"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29913216"
"RoomLength" => null
"RoomDimensions" => "14'8'' x 20'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:51:19.11Z"
]
1 => array:11 [
"RoomKey" => "1660807816"
"RoomType" => "Bedroom"
"ListingId" => "40840374"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29913216"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:51:19.11Z"
]
2 => array:11 [
"RoomKey" => "1660807817"
"RoomType" => "Bedroom"
"ListingId" => "40840374"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29913216"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:51:19.11Z"
]
3 => array:11 [
"RoomKey" => "1660807818"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840374"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29913216"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:51:19.11Z"
]
4 => array:11 [
"RoomKey" => "1660807819"
"RoomType" => "Full bathroom"
"ListingId" => "40840374"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29913216"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:51:19.11Z"
]
5 => array:11 [
"RoomKey" => "1660807820"
"RoomType" => "Primary Bedroom"
"ListingId" => "40840374"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29913216"
"RoomLength" => null
"RoomDimensions" => "19'3'' x 17'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:51:19.11Z"
]
6 => array:11 [
"RoomKey" => "1660807821"
"RoomType" => "Dining room"
"ListingId" => "40840374"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29913216"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 14'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:51:19.12Z"
]
7 => array:11 [
"RoomKey" => "1660807822"
"RoomType" => "2pc Bathroom"
"ListingId" => "40840374"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29913216"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:51:19.12Z"
]
8 => array:11 [
"RoomKey" => "1660807823"
"RoomType" => "Living room"
"ListingId" => "40840374"
…8
]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29913216/420-linden-drive-unit-67-cambridge"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RM3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 27.0
+"AboveGradeFinishedArea": 2067
+"OriginalEntryTimestamp": "2026-06-16T22:51:19.01Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1066261"
+"ListOfficeNationalAssociationId": "1349925"
+"Media": array:16 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29913216')"
+"ID": "1537351"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25277
+post_id: "1531895"
+post_author: 1
+"ListingKey": "29904193"
+"ListingId": "40838448"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T16:40:09Z"
+"RFModificationTimestamp": "2026-06-15T20:16:59Z"
+"ListPrice": 1425000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 5626.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2P2V2"
+"UnparsedAddress": "75 WAGON Street, Kitchener, Ontario N2P2V2"
+"Coordinates": array:2 [
0 => -80.4022472
1 => 43.4109727
]
+"Latitude": 43.4109727
+"Longitude": -80.4022472
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 75 Wagon Street, an impressive executive home located in the prestigious Deer Ridge community of Kitchener. Offering over 5,000 sq. ft. of beautifully finished living space, this stunning residence combines luxury, comfort, and timeless design. The main floor features a spacious layout with soaring ceilings, large windows, a dramatic two-storey great room with fireplace, and a beautifully designed kitchen with granite countertops, oversized island, built-in appliances, and walk-in pantry. The entire home is wired with a built-in sound system, adding comfort and convenience throughout. The main-floor primary bedroom offers a private retreat with two walk-in closets and a spa-inspired ensuite. Upstairs, you’ll find generously sized bedrooms and a versatile loft space perfect for a home office or family lounge. The fully finished basement is ideal for entertaining, complete with a custom bar, recreation area, wine cellar, fireplace, and plenty of space for gatherings. Step outside to your private backyard oasis featuring a covered porch, large deck, waterfall feature, and hot tub. Located close to Highway 401, Deer Ridge Golf Club, scenic trails, shopping, and top amenities, this exceptional home offers luxury living in one of Waterloo Region’s most sought-after neighbourhoods. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T20:16:56.073880+00:00"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1897040"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T16:32:23Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T16:32:23Z"
+"Stories": "2.0"
+"StreetName": "WAGON"
+"StreetNumber": "75"
+"StreetSuffix": "Street"
+"SubdivisionName": "329 - Hidden Valley/Pioneer Tower"
+"TaxAnnualAmount": "10976"
+"VirtualTourURLUnbranded": "https://youriguide.com/75_wagon_street_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:22 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29904193/75-wagon-street-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 85.0
+"AboveGradeFinishedArea": 3485
+"BelowGradeFinishedArea": 2141
+"OriginalEntryTimestamp": "2026-06-15T16:32:23.46Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1215043"
+"ListOfficeNationalAssociationId": "1004370"
+"Media": array:39 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29904193')"
+"ID": "1531895"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25274
+post_id: "1525268"
+post_author: 1
+"ListingKey": "29898013"
+"ListingId": "40839379"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T14:20:03Z"
+"RFModificationTimestamp": "2026-06-15T14:26:17Z"
+"ListPrice": 1569000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3797.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2P2K6"
+"UnparsedAddress": "333 DEER RIDGE Drive, Kitchener, Ontario N2P2K6"
+"Coordinates": array:2 [
0 => -80.4184865
1 => 43.4047917
]
+"Latitude": 43.4047917
+"Longitude": -80.4184865
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Refined, reimagined and quietly luxurious, this former Heisler Homes model bungalow offers exceptional main-floor living in Deer Ridge Estates. Redesigned by Bankside Design Studio and renovated by Slotegraaf in 2023, the home reflects a warm modern-organic design and respected local craftsmanship. Wire-brushed white oak hardwood floors, 10 ft ceilings and a bright, connected layout create a beautiful setting for comfort and effortless entertaining. The heart of the home is the renovated kitchen and living area, where wide sightlines, oversized windows and a custom built-in fireplace anchor the inviting gathering space. Designed for serious cooking and easy hosting, the custom kitchen features all-wood cabinetry, quartz counters, island seating for five, a dedicated pastry counter and integrated Monogram appliances: refrigerator and freezer, wine reserve, dishwasher, 36 inch dual-fuel range, convection oven and 5-in-1 Advantium speed oven. A defined dining room with coffered ceiling detail provides an elegant setting for family dinners or formal occasions. The main floor offers two spacious bedrooms and two full bathrooms, including a serene primary suite with vaulted ceiling, custom built-in closets and a well-appointed ensuite. The finished walk-up lower level adds exceptional flexibility, with a large recreation room, additional bedroom, full bathroom, generous storage and space for guests, media, fitness, hobbies or extended family needs. Outdoors, the covered rear terrace and patio extend the living space into a private garden setting, with mature perennial plantings, peaceful views and direct gated access to the walking path beyond. Offering approximately 1,923 sq. ft. above grade and more than 3,700 sq. ft. of finished interior living space across two levels, this thoughtfully updated bungalow combines the ease of main-floor living with the space and function buyers want. Close to Deer Ridge Golf Club, Grand River trails, highway access and amenities. (id:62783)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Range - Gas"
5 => "Dishwasher"
6 => "Wine Fridge"
7 => "Dryer"
8 => "Oven - Built-In"
9 => "Hood Fan"
10 => "Garage door opener"
11 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"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:28:00.922528+00:00"
+"Directions": "King St to Deer Ridge"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2002389"
+"ListOfficeKey": "55005"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-13T00:52:25Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T14:10:59Z"
+"Stories": "1.0"
+"StreetName": "DEER RIDGE"
+"StreetNumber": "333"
+"StreetSuffix": "Drive"
+"SubdivisionName": "329 - Hidden Valley/Pioneer Tower"
+"TaxAnnualAmount": "9968.52"
+"VirtualTourURLUnbranded": "https://youriguide.com/9m829_333_deer_ridge_dr_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29898013/333-deer-ridge-drive-kitchener"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 62.0
+"AboveGradeFinishedArea": 1923
+"BelowGradeFinishedArea": 1874
+"OriginalEntryTimestamp": "2026-06-12T20:51:29.48Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1285365"
+"ListOfficeNationalAssociationId": "1003711"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898013')"
+"ID": "1525268"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24784
+post_id: "1523451"
+post_author: 1
+"ListingKey": "29893926"
+"ListingId": "40839159"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T11:55:09Z"
+"RFModificationTimestamp": "2026-06-12T14:16:05Z"
+"ListPrice": 2850000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 8.0
+"LotSizeArea": 0.322
+"LivingArea": 4718.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2P2L3"
+"UnparsedAddress": "38 DEER RIDGE Crescent, Kitchener, Ontario N2P2L3"
+"Coordinates": array:2 [
0 => -80.420601
1 => 43.4059963
]
+"Latitude": 43.4059963
+"Longitude": -80.420601
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "In Deer Ridge Estates, location is everything; but when your backyard opens directly onto the award-winning Deer Ridge Golf Course, it becomes something extraordinary. Set on a quiet crescent, this executive all-brick residence with over 4700 sq ft of living space, offers uninterrupted green space views and the rare luxury of true walkability to the clubhouse and first tee. Morning coffee with mist rising over the fairway. Evenings framed by open skies and rolling greens. No rear neighbours, just a peaceful, ever-changing landscape. Inside, the scale of the home mirrors its setting. A dramatic 2-storey living room with towering windows floods the space with natural light. Rich hardwood floors, elegant columns, and refined architectural details create a sense of sophistication without sacrificing warmth. The kitchen is designed for gathering. The oversized island anchors the room - ideal for casual mornings before a round or entertaining after a day on the course. The sun-filled breakfast area overlooks the greens, seamlessly blending indoor comfort with outdoor beauty. Upstairs, 5 bedrooms, a full bath, and a convenient laundry room are ideal for a growing family, dedicated home offices, or guests who can stay comfortably. The primary suite stands out with a huge walk-in closet and attached nursery/sitting room, a thoughtful layout that adapts beautifully to a secluded reading room or the dream of expanded closet space). Downstairs, the fully finished walk-out basement adds an entirely separate layer of living with a large rec area, 3 more bedrooms, a full bath, and generous storage. With its own outdoor access, it’s perfectly suited for multi-generational living, extended family, or the potential to create an independent in-law-style setup. Set among estate homes and mature landscaping, this quiet crescent offers privacy without isolation — close to amenities, yet worlds away from the ordinary. This is a rare opportunity to secure golf course living in Deer Ridge. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T14:15:53.042568+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Brick Veneer"
]
+"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": "1565504"
+"ListOfficeKey": "86262"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.322"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T11:49:32Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T11:49:32Z"
+"Stories": "2.0"
+"StreetName": "DEER RIDGE"
+"StreetNumber": "38"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "329 - Hidden Valley/Pioneer Tower"
+"TaxAnnualAmount": "14394.14"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:23 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
22 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29893926/38-deer-ridge-crescent-kitchener"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1565503"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1565502"
+"CoListOfficeKey": "283852"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "289848"
+"ZoningDescription": "RES-2; OSR-2 (80)"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 85.0
+"AboveGradeFinishedArea": 3222
+"BelowGradeFinishedArea": 1496
+"OriginalEntryTimestamp": "2026-06-12T11:49:32.74Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1070271"
+"ListOfficeNationalAssociationId": "1004415"
+"CoListAgentNationalAssociationId": "1093094"
+"CoListAgentNationalAssociationId2": "1070272"
+"CoListOfficeNationalAssociationId": "1335957"
+"CoListOfficeNationalAssociationId2": "1381908"
+"Media": array:31 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29893926')"
+"ID": "1523451"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25276
+post_id: "1519330"
+post_author: 1
+"ListingKey": "29888472"
+"ListingId": "X13430642"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T15:10:02Z"
+"RFModificationTimestamp": "2026-06-11T16:46:32Z"
+"ListPrice": 2499889.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2P2M2"
+"UnparsedAddress": "908 FALL HARVEST COURT, Kitchener, Ontario N2P2M2"
+"Coordinates": array:2 [
0 => -80.410355
1 => 43.403539
]
+"Latitude": 43.403539
+"Longitude": -80.410355
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Over 5,700 sq ft of finished living space and located on a large 0.25-acre lot in the sought-after Deer Ridge neighbourhood. Tucked away on a quiet court, this custom-built home offers a comfortable layout with carefully selected finishes throughout. The main entry opens into a bright two-storey foyer, with a formal dining room nearby that connects to the kitchen through a practical servery and pantry. The kitchen features white cabinetry, quartz countertops, a waterfall island, tiled backsplash, a built-in refrigerator, and a dual-fuel range with an oversized hood. The breakfast area includes French doors that open to a covered back porch, making it easy to enjoy the large outdoor space. The family room sits just off the kitchen and includes high coffered ceilings, a large picture window, and a gas fireplace with a floor-to-ceiling mantel. A powder room, mudroom with access to the triple car garage, and a spacious home office complete the main level. The upper floor offers four generously sized bedrooms. Two share a five-piece Jack and Jill bathroom, one includes its own ensuite and walk-in closet, and the primary bedroom features a large walk-in closet and an ensuite with a soaker tub and walk-in shower with rain head. Laundry is also conveniently located on the upper level, and all bathrooms are equipped with heated floors for added comfort. The basement benefits from very high ceilings and large above-grade windows filling the space with natural light. It is currently used as a recreation room, an additional bedroom, and a three-piece bathroom. Additional highlights include smart lighting throughout the home and automatic window coverings, offering added convenience and efficiency. Outside, the home is finished with a stone façade and includes an exterior air and weather barrier system, in-ground irrigation, a security system, and a water conditioning system. This is a great opportunity to settle into one of the most sought-after areas in Kitchener. (id:62783)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water purifier"
4 => "Water softener"
5 => "Gas stove(s)"
6 => "Dishwasher"
7 => "Dryer"
8 => "Microwave"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:3 [
0 => "Central air conditioning"
1 => "Air exchanger"
2 => "Ventilation system"
]
+"CreationDate": "2026-06-11T16:44:32.131376+00:00"
+"Directions": "Cross Streets: Deer Ridge Dr. ** Directions: Deer Ridge Dr to Fall Harvest Dr."
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1932995"
+"ListOfficeKey": "277695"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Flat site"
2 => "Carpet Free"
]
+"LotSizeDimensions": "68.4 x 145.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T15:02:30Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T15:02:30Z"
+"Stories": "2.0"
+"StreetName": "Fall Harvest"
+"StreetNumber": "908"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "16701"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29888472/908-fall-harvest-court-kitchener"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 68.4
+"OriginalEntryTimestamp": "2026-06-11T15:02:30.48Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1233168"
+"ListOfficeNationalAssociationId": "1286818"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29888472')"
+"ID": "1519330"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25271
+post_id: "1518891"
+post_author: 1
+"ListingKey": "29889029"
+"ListingId": "X13431624"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T12:25:12Z"
+"RFModificationTimestamp": "2026-06-17T12:28:58Z"
+"ListPrice": 979000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Cambridge"
+"PostalCode": "N3H0C4"
+"UnparsedAddress": "28 WEATHERALL AVENUE, Cambridge, Ontario N3H0C4"
+"Coordinates": array:2 [
0 => -80.382884
1 => 43.396146
]
+"Latitude": 43.396146
+"Longitude": -80.382884
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Wow! Location! Location! Location! Welcome To This Beautifully Maintained 5 Bedroom Detached Home In The Highly Sought-After Preston Heights Community In Cambridge! Features A Double Door Entry, Bright Open Concept Layout, Separate Living Room, And Combined Family/Dining Room. Spacious Primary Bedroom Featuring A 5-Piece Ensuite And Walk-In Closet. Loaded With Upgrades Including A Modern Kitchen With Quartz Countertops & Backsplash, Gas Stove, Pot Lights, Upgraded Bathrooms & A Stylish Kitchen Island With Custom Slat Panel Detailing. Elegant Designer Feature Wall Adds A Modern Touch To The Family Room. Unfinished Basement with Existing Partial Framing. Enjoy A Well-Maintained Backyard & No Sidewalk Providing Extra Parking Convenience. Conveniently Located Close To Hwy 401, Costco, Shopping, Public Transit, Conestoga College, Nearby School, And Easy Access To Kitchener-Waterloo. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T16:23:54.831659+00:00"
+"Directions": "Preston Parkway & Shantz Hill Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Carpeted"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2021576"
+"ListOfficeKey": "289187"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "35 x 98.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T15:59:16Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T12:16:25Z"
+"Stories": "2.0"
+"StreetName": "Weatherall"
+"StreetNumber": "28"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "6834.62"
+"VirtualTourURLUnbranded": "https://tours.parasphotography.ca/public/vtour/display/2388282?idx=1#!/video"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29889029/28-weatherall-avenue-cambridge"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "RESIDENTIAL"
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 35.0
+"OriginalEntryTimestamp": "2026-06-11T15:59:16.41Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1301492"
+"ListOfficeNationalAssociationId": "1375388"
+"Media": array:29 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889029')"
+"ID": "1518891"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1519331"
+post_author: 1
+"ListingKey": "29887908"
+"ListingId": "40838736"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T14:20:05Z"
+"RFModificationTimestamp": "2026-06-11T15:37:47Z"
+"ListPrice": 2449889.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.25
+"LivingArea": 5749.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2P0G6"
+"UnparsedAddress": "908 FALL HARVEST Court, Kitchener, Ontario N2P0G6"
+"Coordinates": array:2 [
0 => -80.410361
1 => 43.4035222
]
+"Latitude": 43.4035222
+"Longitude": -80.410361
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Over 5,700 sq ft of finished living space and located on a large 0.25-acre lot in the sought-after Deer Ridge neighbourhood. Tucked away on a quiet court, this custom-built home offers a comfortable layout with carefully selected finishes throughout. The main entry opens into a bright two-storey foyer, with a formal dining room nearby that connects to the kitchen through a practical servery and pantry. The kitchen features white cabinetry, quartz countertops, a waterfall island, tiled backsplash, a built-in refrigerator, and a dual-fuel range with an oversized hood. The breakfast area includes French doors that open to a covered back porch, making it easy to enjoy the large outdoor space. The family room sits just off the kitchen and includes high coffered ceilings, a large picture window, and a gas fireplace with a floor-to-ceiling mantel. A powder room, mudroom with access to the triple car garage, and a spacious home office complete the main level. The upper floor offers four generously sized bedrooms. Two share a five-piece Jack and Jill bathroom, one includes its own ensuite and walk-in closet, and the primary bedroom features a large walk-in closet and an ensuite with a soaker tub and walk-in shower with rain head. Laundry is also conveniently located on the upper level, and all bathrooms are equipped with heated floors for added comfort. The basement benefits from very high ceilings and large above-grade windows filling the space with natural light. It is currently used as a recreation room, an additional bedroom, and a three-piece bathroom. Additional highlights include smart lighting throughout the home and automatic window coverings, offering added convenience and efficiency. Outside, the home is finished with a stone façade and includes an exterior air and weather barrier system, in-ground irrigation, a security system, and a water conditioning system. This is a great opportunity to settle into one of the most sought-after areas in Kitchener. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Microwave Built-in"
]
+"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-11T15:37:43.990938+00:00"
+"Directions": "Deer Ridge Dr to Fall Harvest Dr"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "In Floor Heating"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1996018"
+"ListOfficeKey": "277572"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Cul-de-sac"
]
+"LotSizeDimensions": "0.25"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T14:10:18Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T14:10:18Z"
+"Stories": "2.0"
+"StreetName": "FALL HARVEST"
+"StreetNumber": "908"
+"StreetSuffix": "Court"
+"SubdivisionName": "329 - Hidden Valley/Pioneer Tower"
+"TaxAnnualAmount": "16701"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/908_fall_harvest_ct_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29887908/908-fall-harvest-court-kitchener"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1750692"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "277572"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 68.0
+"AboveGradeFinishedArea": 3855
+"BelowGradeFinishedArea": 1894
+"OriginalEntryTimestamp": "2026-06-11T14:10:18.17Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1278796"
+"ListOfficeNationalAssociationId": "1285375"
+"CoListAgentNationalAssociationId": "1117625"
+"CoListOfficeNationalAssociationId": "1285375"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29887908')"
+"ID": "1519331"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24782
+post_id: "1517793"
+post_author: 1
+"ListingKey": "29885680"
+"ListingId": "X13428412"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T22:00:07Z"
+"RFModificationTimestamp": "2026-06-11T02:21:27Z"
+"ListPrice": 1899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2P2X9"
+"UnparsedAddress": "15 LANGTON DRIVE, Kitchener, Ontario N2P2X9"
+"Coordinates": array:2 [
0 => -80.412969
1 => 43.401142
]
+"Latitude": 43.401142
+"Longitude": -80.412969
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Some homes are built to impress. This one was built to be lived in. Tucked into Deer Ridge Estates, this Grason-built bungalow carries a strong reputation, and it shows the moment you enter. Everything here feels intentional, with an elevated sense of luxury throughout. The main floor offers three bedrooms, including two with their own ensuites, along with a powder room finished with clean, refined details. The primary suite features double vanities, glass shower finishes, and modern lines that create a calm, retreat-like atmosphere. Hardwood floors, tray ceilings, and natural light enhance the space without sacrificing comfort. The kitchen is designed exactly how it should be, with two-tone cabinetry, an elegant, uniquely laid subway tile backsplash, quartz countertops, and custom lighting, all opening seamlessly into the main living area. With over 3,400 sq ft of finished living space across two levels, plus an additional 1,000 sq ft of storage, there is ample room for a growing family. The lower level continues with 9-foot ceilings, a fourth bedroom with walk-in closet, a full bathroom, and a spacious living area that feels like a true extension of the home. Outside, a covered porch leads to a private deck with pot lights, complemented by a new shed for added storage. Located steps from the Walter Bean Grand River Trail and minutes to the prestigious Deer Ridge Golf Club, this home is surrounded by nature, mature trees, and a highly sought-after neighbourhood known for its quiet streets and lasting appeal. (id:62783)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
11 => "Water Heater - Tankless"
12 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:3 [
0 => "Central air conditioning"
1 => "Air exchanger"
2 => "Ventilation system"
]
+"CreationDate": "2026-06-11T02:21:18.150965+00:00"
+"Directions": "Cross Streets: Pioneer Tower Rd & King St E. ** Directions: Continue on Wellington Rd 124. Take Waterloo Regional Rd 24 and ON-401 W to Deer Ridge Dr in Kitchener. Continue on Deer Ridge Dr. Drive to Langton Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2093834"
+"ListOfficeKey": "294392"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "69.7 x 126 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T21:53:45Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T21:53:44Z"
+"Stories": "1.0"
+"StreetName": "LANGTON"
+"StreetNumber": "15"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "11273.83"
+"VirtualTourURLUnbranded": "https://youriguide.com/15_langton_dr_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29885680/15-langton-drive-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:3 [
0 => "Alarm system"
1 => "Smoke Detectors"
2 => "Monitored Alarm"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "253R, 280R, R-3"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 69.8
+"OriginalEntryTimestamp": "2026-06-10T21:53:44.85Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1366291"
+"ListOfficeNationalAssociationId": "1438599"
+"Media": array:44 [
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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29885680')"
+"ID": "1517793"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24776
+post_id: "1516049"
+post_author: 1
+"ListingKey": "29884265"
+"ListingId": "X13426980"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T12:35:12Z"
+"RFModificationTimestamp": "2026-06-15T12:38:44Z"
+"ListPrice": 1699999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2P2S6"
+"UnparsedAddress": "114 PENNSYLVANIA CRESCENT, Kitchener, Ontario N2P2S6"
+"Coordinates": array:2 [
0 => -80.417083
1 => 43.402723
]
+"Latitude": 43.402723
+"Longitude": -80.417083
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Set on a beautifully maintained corner lot in Deer Ridge Estates, this custom-built home offers over 4,500 square feet of living space, a rare three-car garage, and a thoughtfully designed main floor featuring two bedrooms and two full bathrooms. An exposed aggregate driveway, mature trees, and a covered front entrance create exceptional curb appeal. Step inside through full-height double French front doors to discover 9-foot ceilings, California shutters, crown moulding, and coffered ceiling details that showcase the quality of construction throughout the home.The formal dining room provides an elegant space for entertaining, while the custom Barzotti cherry kitchen features granite countertops, stone backsplash, breakfast bar, wine storage, integrated microwave, and stainless steel appliances. The adjoining cathedral great room is filled with natural light and provides a welcoming gathering space overlooking the backyard. The finished lower level extends the living space with two additional bedrooms, a full bathroom, wine cellar, custom bar, and a sprawling recreation room that offers exceptional flexibility for entertaining, hobbies, fitness, or extended family living. Outside, the stamped concrete patio offers a private outdoor retreat, while the oversized three-car garage and expansive driveway provide exceptional parking and storage. Located just minutes from Deer Ridge Golf Club, walking trails, Highway 401, and everyday amenities, this is a rare offering in one of Kitchener's most established executive communities. (id:62783)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Range"
5 => "Oven"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
11 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-06-10T19:22:35.254749+00:00"
+"Directions": "Cross Streets: King St E and Deer Ridge Dr. ** Directions: toward ON-401 W/London.Merge onto King St E. Follow Deer Ridge Dr to Pennsylvania Crescent."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Shingles"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2093834"
+"ListOfficeKey": "294392"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Sump Pump"
]
+"LotSizeDimensions": "67 x 101.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T18:57:41Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T12:27:54Z"
+"Stories": "1.0"
+"StreetName": "Pennsylvania"
+"StreetNumber": "114"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "11824.44"
+"VirtualTourURLUnbranded": "https://youriguide.com/114_pennsylvania_crescent_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29884265/114-pennsylvania-crescent-kitchener"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:3 [
0 => "Alarm system"
1 => "Security system"
2 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 67.0
+"OriginalEntryTimestamp": "2026-06-10T18:57:41.07Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1366291"
+"ListOfficeNationalAssociationId": "1438599"
+"Media": array:35 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29884265')"
+"ID": "1516049"
}
]
+success: true
+page_size: 9
+page_count: 6
+count: 47
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]