array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30036867 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23472
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23474
+post_id: "1638181"
+post_author: 1
+"ListingKey": "30036867"
+"ListingId": "40848079"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:15:09Z"
+"RFModificationTimestamp": "2026-07-17T23:33:24Z"
+"ListPrice": 825000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2519.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2N3R5"
+"UnparsedAddress": "44 LEMON GRASS Street, Kitchener, Ontario N2N3R5"
+"Coordinates": array:2 [
0 => -80.5553321
1 => 43.4366215
]
+"Latitude": 43.4366215
+"Longitude": -80.5553321
+"YearBuilt": 2008
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Fabulous Modern custom-built Bungalow finished top to bottom. This immaculate 2+2 bedroom bungalow, offers over 2500 sq ft of elegant living space on both levels. Open concept living room/dinette/kitchen flooded with lots of natural light. The kitchen with granite countertops, tons of counter space, stainless steel appliances. Exotic hardwood flooring throughout the main floor. The master bedroom has walk in closets and a modern ensuite bathroom. The second bedroom on the main level is a good size with the large window. Finished basement with 2 more bedrooms, walk in closets, full bath, huge family room and some storage space. The Large yard space has the nice size multi level deck, great for entertaining with family and friends. 1.5 car garage with extra space, additional 2 car parking in front of the garage. Close to The Boardwalk Mall, University of Waterloo/Wilfred Laurier University, top rated public schools, bike trails, groceries, bus stops and transit center. Book your viewing today as it won't last long! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T23:33:15.666202+00:00"
+"Directions": "University Ave W/Contrystone Dr/Lemon Grass St"
+"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": "2220500"
+"ListOfficeKey": "76775"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-16T16:52:40Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:09:55Z"
+"Stories": "1.0"
+"StreetName": "LEMON GRASS"
+"StreetNumber": "44"
+"StreetSuffix": "Street"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "4857"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1686995092"
"RoomType" => "4pc Bathroom"
"ListingId" => "40848079"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "30036867"
"RoomLength" => null
"RoomDimensions" => "5' x 8'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:55.18Z"
]
1 => array:11 [
"RoomKey" => "1686995093"
"RoomType" => "Bedroom"
"ListingId" => "40848079"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "30036867"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:55.18Z"
]
2 => array:11 [
"RoomKey" => "1686995094"
"RoomType" => "Family room"
"ListingId" => "40848079"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "30036867"
"RoomLength" => null
"RoomDimensions" => "18'0'' x 22'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:55.18Z"
]
3 => array:11 [
"RoomKey" => "1686995095"
"RoomType" => "Bedroom"
"ListingId" => "40848079"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "30036867"
"RoomLength" => null
"RoomDimensions" => "16'0'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:55.18Z"
]
4 => array:11 [
"RoomKey" => "1686995096"
"RoomType" => "3pc Bathroom"
"ListingId" => "40848079"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30036867"
"RoomLength" => null
"RoomDimensions" => "5' x 8'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:55.19Z"
]
5 => array:11 [
"RoomKey" => "1686995097"
"RoomType" => "4pc Bathroom"
"ListingId" => "40848079"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30036867"
"RoomLength" => null
"RoomDimensions" => "5' x 8'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:55.19Z"
]
6 => array:11 [
"RoomKey" => "1686995098"
"RoomType" => "Bedroom"
"ListingId" => "40848079"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30036867"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:55.19Z"
]
7 => array:11 [
"RoomKey" => "1686995099"
"RoomType" => "Primary Bedroom"
"ListingId" => "40848079"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30036867"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 15'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:55.19Z"
]
8 => array:11 [
"RoomKey" => "1686995100"
"RoomType" => "Dining room"
"ListingId" => "40848079"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30036867"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:55.19Z"
]
9 => array:11 [
"RoomKey" => "1686995101"
"RoomType" => "Kitchen"
"ListingId" => "40848079"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30036867"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 10'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:55.19Z"
]
10 => array:11 [
"RoomKey" => "1686995102"
"RoomType" => "Living room"
"ListingId" => "40848079"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30036867"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 19'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:55.19Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30036867/44-lemon-grass-street-kitchener"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "Res-4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1269
+"BelowGradeFinishedArea": 1250
+"OriginalEntryTimestamp": "2026-07-15T17:28:53.13Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1464693"
+"ListOfficeNationalAssociationId": "1004341"
+"Media": array:40 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30036867_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/6017063ca4f4d34f285d3ac79c8b3308.webp"
"MediaSize" => 132917
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-6017063ca4f4d34f285d3ac79c8b3308.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior featuring a gabled roofline, an integrated single-car garage, and a paved driveway"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.83Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30036867_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/c8f58dca741280bde2ab39ebb079610d.webp"
"MediaSize" => 125010
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-c8f58dca741280bde2ab39ebb079610d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front house"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.83Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30036867_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/f6cde1dd00383a970cd23c6c3de436c5.webp"
"MediaSize" => 126857
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-f6cde1dd00383a970cd23c6c3de436c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick facade residence featuring an arched entry with a decorative glass front door, concrete steps, and a white paneled garage door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.9Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30036867_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/c221042bf1740e330d72f95ce71166cd.webp"
"MediaSize" => 63812
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-c221042bf1740e330d72f95ce71166cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a white door with decorative glass inserts, an arched transom window, and a tiled floor"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.51Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30036867_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/77bbf77e8e185098df56dd912692204a.webp"
"MediaSize" => 65370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-77bbf77e8e185098df56dd912692204a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Staircase featuring dark wood-finish treads, white risers, and a dark wood newel post with black metal balusters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.83Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30036867_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/d01a7f1bb1d53b01e8f4597bb2c7f734.webp"
"MediaSize" => 101848
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-d01a7f1bb1d53b01e8f4597bb2c7f734.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring dark wood-finish cabinetry, stainless steel appliances, a tile backsplash, and a breakfast bar with seating"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:40.52Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30036867_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/f63a2741fc7623de72f1fbfb874703d4.webp"
"MediaSize" => 88487
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-f63a2741fc7623de72f1fbfb874703d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring dark wood-finish cabinetry, stainless steel appliances, a tiled backsplash, wood-finish flooring, and a central island with bar seating"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.86Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30036867_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/3695183c2d7e530e88611b7ab021c661.webp"
"MediaSize" => 97703
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-3695183c2d7e530e88611b7ab021c661.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring dark wood-finish cabinetry, stainless steel appliances, a center island with bar seating, and a mosaic tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.83Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30036867_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/18fe54d02b09d2ae3a4a4cb371706904.webp"
"MediaSize" => 83790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-18fe54d02b09d2ae3a4a4cb371706904.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen island featuring a dark countertop, integrated storage, and bar seating"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.51Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30036867_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/d7cc130d28e6208f7397b636eccb2db7.webp"
"MediaSize" => 92941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-d7cc130d28e6208f7397b636eccb2db7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring dark wood cabinetry with brushed nickel hardware, a dark speckled countertop, and a mosaic tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.86Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30036867_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/b30a9d400a9a6a28151964c31746bd63.webp"
"MediaSize" => 83401
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-b30a9d400a9a6a28151964c31746bd63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring dark wood-finish cabinetry, stainless steel appliances, a mosaic tile backsplash, and a central island with an integrated breakfast bar"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.56Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30036867_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/392733eee2ad5f337dc9d527b6f34b39.webp"
"MediaSize" => 80998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-392733eee2ad5f337dc9d527b6f34b39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring rich wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.83Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30036867_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/d1ce2440c552c908a3bb26af314160c0.webp"
"MediaSize" => 82332
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-d1ce2440c552c908a3bb26af314160c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring rich wood-finish flooring, a white mantel fireplace, and multiple windows with white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.86Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30036867_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/b235a8a536f9df1c4f7454279b329e9e.webp"
"MediaSize" => 77321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-b235a8a536f9df1c4f7454279b329e9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Warm wood-finish flooring extends through this open-concept living space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:40.52Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30036867_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/819cea2219e1b6bcc039366df303712f.webp"
"MediaSize" => 90213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-819cea2219e1b6bcc039366df303712f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive living area featuring rich wood-finish flooring, multiple windows with roller shades, and a structural column"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.86Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30036867_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/7e4def27e8cae2013857ae2d57455224.webp"
"MediaSize" => 97204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-7e4def27e8cae2013857ae2d57455224.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring rich wood-finish flooring, light gray wall tones, a corner fireplace with a white mantel, and multiple windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.51Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30036867_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/436edd4492ca20208e8a1a871d77240c.webp"
"MediaSize" => 61597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-436edd4492ca20208e8a1a871d77240c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hardwood flooring complemented by light gray walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.51Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30036867_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/a8d239c04c858b24aad75461139a804d.webp"
"MediaSize" => 57245
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-a8d239c04c858b24aad75461139a804d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Warm wood-finish flooring complements light gray wall tones"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.51Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30036867_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/43619721deefa5fde9f7a656ba1426b4.webp"
"MediaSize" => 93457
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-43619721deefa5fde9f7a656ba1426b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Vanity featuring a dark countertop, undermount sink, and brushed nickel faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.9Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30036867_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/1d7ea90ad4576d7db1a29a6e0045b950.webp"
"MediaSize" => 76103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-1d7ea90ad4576d7db1a29a6e0045b950.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring rich wood-finish flooring, light grey painted walls, and a white six-panel door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:40.62Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30036867_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/7812803639a20470c75b757dcbdd711b.webp"
"MediaSize" => 71669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-7812803639a20470c75b757dcbdd711b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hardwood flooring complements light gray walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.51Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30036867_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/cc4e4c87b149efbdae71802f85cd4505.webp"
"MediaSize" => 72843
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-cc4e4c87b149efbdae71802f85cd4505.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Warm wood-finish flooring complements the neutral wall color"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.83Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30036867_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/3a73642b022658c0a2b51a625c27a57f.webp"
"MediaSize" => 71905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-3a73642b022658c0a2b51a625c27a57f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bathroom featuring a dark wood-finish vanity with a light-toned countertop, a glass tile backsplash, and a large wall-mounted mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.51Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30036867_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/ff39a809c5f6a6df7458234fd130b950.webp"
"MediaSize" => 60261
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-ff39a809c5f6a6df7458234fd130b950.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entry foyer featuring dark wood-finish flooring, a staircase with neutral-toned treads, white trim, and a paneled door with dark hardware"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.51Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30036867_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/aad35552f2ce5fb3d6307667c1dabc86.webp"
"MediaSize" => 87738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-aad35552f2ce5fb3d6307667c1dabc86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.51Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30036867_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/b0be39a6b4e0f4860e966dae98d4f269.webp"
"MediaSize" => 66866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-b0be39a6b4e0f4860e966dae98d4f269.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.83Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30036867_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/ab82ef791af7693c8aa48d7fc45fb35a.webp"
"MediaSize" => 58568
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-ab82ef791af7693c8aa48d7fc45fb35a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white bathtub with shower, wood-finish vanity with two drawers, and a white integrated sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.87Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30036867_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/b202f937a41fe68ad9ba5caff492e618.webp"
"MediaSize" => 90728
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-b202f937a41fe68ad9ba5caff492e618.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious finished room featuring rich wood-finish flooring, recessed lighting, and an inset fireplace"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.51Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30036867_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/9275ded2ebfea61ed21039d3c714179f.webp"
"MediaSize" => 84549
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-9275ded2ebfea61ed21039d3c714179f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Recessed fireplace with a dark surround, wood-finish flooring, and recessed ceiling lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.83Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30036867_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/733c232bbf6bcc56c20b03d78324d598.webp"
"MediaSize" => 79217
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-733c232bbf6bcc56c20b03d78324d598.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Recreation room featuring recessed lighting, wood-finish flooring, a built-in electric fireplace, and two windows with blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.88Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30036867_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/e653988eaac2637fbf47f64e58602c2b.webp"
"MediaSize" => 85678
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-e653988eaac2637fbf47f64e58602c2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring rich wood-finish flooring, recessed lighting, and a modern wall-mounted fireplace"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.86Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30036867_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/88b0a67efac3a5aa9cfe9f0ec2d1f770.webp"
"MediaSize" => 83942
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-88b0a67efac3a5aa9cfe9f0ec2d1f770.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious entertainment area featuring wood-finish flooring and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.88Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30036867_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/325466bfa17e149746d6302fc3f023f8.webp"
"MediaSize" => 100469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-325466bfa17e149746d6302fc3f023f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring wood-finish flooring, recessed ceiling with a central light fixture, a window with a roller shade, and light-toned walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.86Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30036867_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/c36846f576118b799310bd7f187680d8.webp"
"MediaSize" => 78049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-c36846f576118b799310bd7f187680d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with wood-finish flooring, recessed lighting, and a neutral color palette"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.84Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30036867_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/4ff322df0859bba08389c23b19996eef.webp"
"MediaSize" => 82269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-4ff322df0859bba08389c23b19996eef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring dark wood-finish flooring, light-toned walls, and a visible window with blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.86Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "30036867_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/7af1dc1faa668b3ef70634ae15cacb5c.webp"
"MediaSize" => 141162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-7af1dc1faa668b3ef70634ae15cacb5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious wood-finish deck with a pergola featuring integrated string lights"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.83Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "30036867_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/210109a62e1915f655f4be96dadf4186.webp"
"MediaSize" => 146542
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-210109a62e1915f655f4be96dadf4186.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious outdoor deck featuring wood-finish flooring, a full-height wood railing, and a pergola with a retractable shade canopy"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:40.36Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "30036867_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/d9a601eb7656e099dd405f97dbdf5158.webp"
"MediaSize" => 199264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-d9a601eb7656e099dd405f97dbdf5158.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a lush lawn, established tree, and a built-in fire pit on a stone base"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.83Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "30036867_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/0f4dadf094f373fec35f85b3209645c8.webp"
"MediaSize" => 142730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-0f4dadf094f373fec35f85b3209645c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a lush lawn, perimeter wood fencing, and established garden beds with floral plantings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.83Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "30036867_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30036867/dc0938344ada786013f3bb70ea07e833.webp"
"MediaSize" => 167223
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30036867/thumbnail-dc0938344ada786013f3bb70ea07e833.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive rear yard featuring a wooden deck with railing, a pergola with a retractable canopy, and a concrete patio"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848079"
"ResourceRecordKey" => "30036867"
"ModificationTimestamp" => "2026-07-16T16:52:39.83Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30036867')"
+"ID": "1638181"
}
]
+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=OfficeKey eq 76775" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24992
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24936
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX REAL ESTATE CENTRE INC."
+"OfficeEmail": null
+"OfficePhone": "519-741-0950"
+"OfficeMlsId": "KW153"
+"ModificationTimestamp": "2026-06-09T16:24:08Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "76775"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "720 WESTMOUNT RD."
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "KITCHENER"
+"OfficePostalCode": "N2E2M"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1004341"
+"OriginalEntryTimestamp": null
+"OfficeFax": "519-741-0957"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1419927"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('76775')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2220500" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24946
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.19 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30036867'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25292
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30036867' AND OpenHouseDate ge '2026-07-17'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25308
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30036867' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5553321 43.4366215)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25425
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25419
+post_id: "1637953"
+post_author: 1
+"ListingKey": "30035551"
+"ListingId": "40848363"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T01:25:19Z"
+"RFModificationTimestamp": "2026-07-18T01:26:24Z"
+"ListPrice": 1149900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 4014.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2N2P5"
+"UnparsedAddress": "48 LENNOX Crescent, Kitchener, Ontario N2N2P5"
+"Coordinates": array:2 [
0 => -80.5379175
1 => 43.439713
]
+"Latitude": 43.439713
+"Longitude": -80.5379175
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 48 Lennox Crescent—where family memories begin. This beautifully maintained executive home offers over 4,000 sq. ft. of finished living space with 5 bedrooms, 4 bathrooms, and a spectacular backyard retreat. Thoughtfully designed for family living, it blends elegance, comfort, and functionality. Step inside to a grand two-storey foyer featuring a stunning staircase, Brazilian cherry hardwood flooring, California ceilings, and crown mouldings. A private office or den off the foyer can also serve as a main floor bedroom. The formal dining room flows into the spacious living room with a cozy gas fireplace and custom wall unit. The bright kitchen features granite countertops, stainless steel appliances, abundant cabinetry, and a sunny dining area overlooking the backyard. Main floor laundry with a separate side entrance and a 2-piece powder room add everyday convenience. Upstairs you'll find four generous bedrooms, including a spacious primary suite with an updated walk-in closet and beautifully renovated spa-inspired ensuite. An updated 4-piece bathroom completes the upper level. The finished basement expands the living space with a large rec room, custom bar, fifth bedroom, and full bathroom—ideal for guests, entertaining, or multi-generational living. Outside, enjoy your private backyard oasis featuring a heated inground pool, expansive deck, brick shed, mature landscaping, and a fully fenced yard with no rear neighbours. Updated exterior brick designed to resemble natural stone, an exposed aggregate driveway, double garage, and extensive updates (see supplements) complete the home. Located in prestigious Beechwood Forest, close to top-rated schools, scenic walking trails, parks, shopping, and all amenities, this exceptional home offers a rare combination of space, quality, privacy, and resort-style outdoor living. A truly special place you'll be proud to call home. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T23:37:35.712387+00:00"
+"Directions": "Fischer Hallman Rd to Stoke Dr to Lennox Cres"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"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": "1908292"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T21:12:46Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T01:18:13Z"
+"Stories": "2.0"
+"StreetName": "LENNOX"
+"StreetNumber": "48"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "338 - Beechwood Forest/Highland W."
+"TaxAnnualAmount": "7128.41"
+"VirtualTourURLUnbranded": "https://youriguide.com/48_lennox_crescent_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:21 [
0 => array:11 [
"RoomKey" => "1687268863"
"RoomType" => "Utility room"
"ListingId" => "40848363"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T01:18:13.23Z"
]
1 => array:11 [
"RoomKey" => "1687268864"
"RoomType" => "Storage"
"ListingId" => "40848363"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "19'5'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T01:18:13.23Z"
]
2 => array:11 [
"RoomKey" => "1687268865"
"RoomType" => "Recreation room"
"ListingId" => "40848363"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "17'2'' x 34'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T01:18:13.24Z"
]
3 => array:11 [
"RoomKey" => "1687268866"
"RoomType" => "Bedroom"
"ListingId" => "40848363"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T01:18:13.24Z"
]
4 => array:11 [
"RoomKey" => "1687268867"
"RoomType" => "Other"
"ListingId" => "40848363"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T01:18:13.24Z"
]
5 => array:11 [
"RoomKey" => "1687268868"
"RoomType" => "3pc Bathroom"
"ListingId" => "40848363"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T01:18:13.24Z"
]
6 => array:11 [
"RoomKey" => "1687268869"
"RoomType" => "Other"
"ListingId" => "40848363"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 5'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T01:18:13.24Z"
]
7 => array:11 [
"RoomKey" => "1687268870"
"RoomType" => "Primary Bedroom"
"ListingId" => "40848363"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "14'6'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T01:18:13.24Z"
]
8 => array:11 [
"RoomKey" => "1687268871"
"RoomType" => "Sitting room"
"ListingId" => "40848363"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T01:18:13.24Z"
]
9 => array:11 [
"RoomKey" => "1687268872"
"RoomType" => "Bedroom"
"ListingId" => "40848363"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "15'2'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T01:18:13.24Z"
]
10 => array:11 [
"RoomKey" => "1687268873"
"RoomType" => "Bedroom"
"ListingId" => "40848363"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T01:18:13.24Z"
]
11 => array:11 [
"RoomKey" => "1687268874"
"RoomType" => "Bedroom"
"ListingId" => "40848363"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T01:18:13.24Z"
]
12 => array:11 [
"RoomKey" => "1687268875"
"RoomType" => "Full bathroom"
"ListingId" => "40848363"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
…4
]
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30035551/48-lennox-crescent-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RES-2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 2641
+"BelowGradeFinishedArea": 1373
+"OriginalEntryTimestamp": "2026-07-15T14:48:27.1Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1221205"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30035551')"
+"ID": "1637953"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25421
+post_id: "1637100"
+post_author: 1
+"ListingKey": "30039981"
+"ListingId": "40848617"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T21:20:02Z"
+"RFModificationTimestamp": "2026-07-17T21:40:08Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1435.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1K2"
+"UnparsedAddress": "584 WESTVALE Drive, Waterloo, Ontario N2T1K2"
+"Coordinates": array:2 [
0 => -80.5500108
1 => 43.446597
]
+"Latitude": 43.446597
+"Longitude": -80.5500108
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully updated raised bungalow in family-friendly Westvale, one of the area's most popular neighbourhoods. Step inside to a bright, modern open-concept main floor designed for everyday living, offering three bedrooms and two full bathrooms. The spacious kitchen features a generous island that flows seamlessly into the dining and living areas, creating the perfect gathering space for family and friends. Sliding doors off the dining area lead to a large private deck, complete with a hot tub (2022) and plenty of room for outdoor dining, relaxing, and entertaining. The lower level offers a bright, spacious rec room with a cozy gas stove, second full bath plus a huge bonus space, perfect for your home gym, crafts or even another bedroom or two. The backyard is a private retreat, featuring mature trees, a fully fenced yard with a large shed and a side gate providing convenient access for your trailer or maintenance. Thoughtfully maintained and move-in ready, this home has seen numerous recent updates, including windows (2022), shingles (2021) and furnace (2021), offering peace of mind for years to come. Located in a highly sought-after neighbourhood, you'll be just minutes from parks, schools, scenic walking trails, public transit, The Boardwalk shopping, Costco, and a wide variety of amenities. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:38:01.536897+00:00"
+"Directions": "Fischer Hallman to Thorndale Drive, to Westvale Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2049459"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T21:11:25Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T21:11:25Z"
+"Stories": "1.0"
+"StreetName": "WESTVALE"
+"StreetNumber": "584"
+"StreetSuffix": "Drive"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "4468.65"
+"VirtualTourURLUnbranded": "https://youriguide.com/584_westvale_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30039981/584-westvale-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 62.0
+"AboveGradeFinishedArea": 1134
+"BelowGradeFinishedArea": 301
+"OriginalEntryTimestamp": "2026-07-16T01:48:15.45Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1324839"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30039981')"
+"ID": "1637100"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25418
+post_id: "1635644"
+post_author: 1
+"ListingKey": "30047262"
+"ListingId": "40849067"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T14:55:22Z"
+"RFModificationTimestamp": "2026-07-17T17:13:28Z"
+"ListPrice": 399999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1160.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2M5B5"
+"UnparsedAddress": "423 WESTWOOD Drive Unit# 43, Kitchener, Ontario N2M5B5"
+"Coordinates": array:2 [
0 => -80.5405456
1 => 43.4427505
]
+"Latitude": 43.4427505
+"Longitude": -80.5405456
+"YearBuilt": 1973
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained condo townhouse located in Kitchener’s desirable Westwood neighbourhood. Surrounded by mature trees and quiet streets, this home offers a wonderful blend of space, comfort, and low-maintenance living. Step inside to a bright and inviting main floor featuring a spacious living area that’s perfect for both everyday living and entertaining. The eat-in kitchen offers ample cabinetry and workspace, creating a practical and welcoming hub for family meals and gatherings. A convenient 2pc powder room completes the main level. Upstairs, you’ll find well-sized bedrooms and a full bathroom. The finished lower level adds valuable flexibility with additional living space ideal for a family room, home office, or recreation area. This level also features a three-piece bathroom, laundry area, and extra storage. Enjoy the benefits of easy condo living, where exterior maintenance is taken care of, while still having your own private outdoor space to relax and unwind. Residents also enjoy access to an in-ground pool and playground, making this a great community for families and those who appreciate outdoor amenities. The location is exceptional — just minutes to The Boardwalk shopping district, parks, schools, public transit, and both universities. Commuters and investors alike will appreciate the convenience and strong rental appeal of this area. Whether you’re a first-time buyer, downsizer, or investor, Unit #43 offers outstanding value and an opportunity to own in a well-established community. Recent Updates include: Central Air (2024), Basement Finished (2023), Kitchen and Bathroom updates (2021). Condo fees include: water, 1 parking spot, pool maintenance, landscaping, snow removal, and general insurance (owners need to get their own content insurance). Pool is open May-October. 2nd parking spot is by waitlist with a monthly rental of approximately $40/month. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
]
+"AssociationFee": "611.98"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Water"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T17:13:21.383471+00:00"
+"Directions": "Glasgow St. to Westwood Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2067711"
+"ListOfficeKey": "286933"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Southern exposure"
]
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-17T14:48:25Z"
+"PhotosCount": 41
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T14:48:25Z"
+"Stories": "2.0"
+"StreetName": "WESTWOOD"
+"StreetNumber": "423"
+"StreetSuffix": "Drive"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "2333.95"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30047262/423-westwood-drive-unit-43-kitchener"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1564408"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "286933"
+"GeocodeManualYN": true
+"ZoningDescription": "R2B"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1160
+"OriginalEntryTimestamp": "2026-07-17T14:48:25.12Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1342782"
+"ListOfficeNationalAssociationId": "1364894"
+"CoListAgentNationalAssociationId": "1129302"
+"CoListOfficeNationalAssociationId": "1364894"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30047262')"
+"ID": "1635644"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25422
+post_id: "1634495"
+post_author: 1
+"ListingKey": "30046352"
+"ListingId": "40849006"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T15:20:06Z"
+"RFModificationTimestamp": "2026-07-17T15:22:50Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1358.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1G3"
+"UnparsedAddress": "543 DRUMMERHILL Crescent, Waterloo, Ontario N2T1G3"
+"Coordinates": array:2 [
0 => -80.553139
1 => 43.4461149
]
+"Latitude": 43.4461149
+"Longitude": -80.553139
+"YearBuilt": 1985
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Great Location! Welcome to this beautiful detached home in the highly sought-after Westvale neighbourhood. Situated on a quiet, family-friendly crescent, this carpet-free home is conveniently located near top-rated schools, shopping, parks, trails, transit, and just minutes from Uptown Waterloo, the University of Waterloo, Costco, Walmart, medical centres, restaurants, and highway access. This well-maintained single-family home features 3 bedrooms, 2 bathrooms, a single-car garage, parking for three vehicles, and a finished recreation room. The bright main floor offers hardwood flooring, a 2-piece powder room, direct garage access, and sliding doors leading to a fully fenced backyard with a spacious deck—perfect for family gatherings and outdoor entertaining. Upstairs, you'll find three generous bedrooms and a beautifully renovated bathroom. The basement is nearly complete, featuring a finished rec room and a framed 3-piece bathroom rough-in, offering excellent potential for additional living space. Move-in ready and located in one of Waterloo's most desirable family communities, this is a fantastic opportunity you won't want to miss! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T13:55:25.143676+00:00"
+"Directions": "Fischer-Hallman to Thorndale, left onto Westvale, right onto Drummerhill Crescent"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955745"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T15:13:22Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T15:18:20Z"
+"Stories": "2.0"
+"StreetName": "DRUMMERHILL"
+"StreetNumber": "543"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "3852.78"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30046352/543-drummerhill-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SD-1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1108
+"BelowGradeFinishedArea": 250
+"OriginalEntryTimestamp": "2026-07-17T11:49:29.53Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1247419"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:34 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30046352')"
+"ID": "1634495"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25420
+post_id: "1629482"
+post_author: 1
+"ListingKey": "30039604"
+"ListingId": "X13569310"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-16T17:50:05Z"
+"RFModificationTimestamp": "2026-07-16T19:05:50Z"
+"ListPrice": 825000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2N3R5"
+"UnparsedAddress": "44 LEMON GRASS STREET, Kitchener, Ontario N2N3R5"
+"Coordinates": array:2 [
0 => -80.5553256
1 => 43.4366207
]
+"Latitude": 43.4366207
+"Longitude": -80.5553256
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Fabulous Modern custom-built Bungalow finished top to bottom. This immaculate 2+2 bedroom bungalow, offers over 2500 sq ft of elegant living space on both levels. Open concept living room/dinette/kitchen flooded with lots of natural light. The kitchen with granite countertops, tons of counter space, stainless steel appliances. Exotic hardwood flooring throughout the main floor. The master bedroom has walk in closets and a modern ensuite bathroom. The second bedroom on the main level is a good size with the large window. Finished basement with 2 more bedrooms, walk in closets, full bath, huge family room and some storage space. The Large yard space has the nice size multi level deck, great for entertaining with family and friends. 1.5 car garage with extra space, additional 2 car parking in front of the garage. Close to The Boardwalk Mall, University of Waterloo/Wilfred Laurier University, top rated public schools, bike trails, groceries, bus stops and transit center. Book your viewing today as it won't last long! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Walk-up"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-07-16T00:55:44.279087+00:00"
+"Directions": "Cross Streets: Countrystone Drive. ** Directions: University Ave W/Contrystone Dr/Lemon Grass St."
+"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": "2197773"
+"ListOfficeKey": "280835"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "Carpet Free"
2 => "Sump Pump"
]
+"LotSizeDimensions": "50 x 133 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T23:38:37Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-16T17:40:43Z"
+"Stories": "1.0"
+"StreetName": "Lemon Grass"
+"StreetNumber": "44"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4857"
+"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": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30039604/44-lemon-grass-street-kitchener"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-07-15T23:38:37.19Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1446159"
+"ListOfficeNationalAssociationId": "1317749"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30039604')"
+"ID": "1629482"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25392
+post_id: "1626734"
+post_author: 1
+"ListingKey": "30036193"
+"ListingId": "X13566416"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-16T17:50:05Z"
+"RFModificationTimestamp": "2026-07-16T19:05:53Z"
+"ListPrice": 748800.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2N3A3"
+"UnparsedAddress": "331 NEWBURY DRIVE, Kitchener, Ontario N2N3A3"
+"Coordinates": array:2 [
0 => -80.546123
1 => 43.422439
]
+"Latitude": 43.422439
+"Longitude": -80.546123
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 331 Newbury Dr located in the desireable neighbourhood of Forest Heights. This clean well maintained 3+1 bedroom, four level backsplit is on a quiet street with plenty of mature trees. Situated on a beautiful sized lot the backyard is full of potential for any type of owner. Inside you will find a bright spacious sized living and dining room along with a great layout to the rest of the home. The lower levels can be used for anything from additional family room, office, gym and more.This home is conveniently located to schools, shopping, parks, trails and hwy access mins away. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Stove"
2 => "Dryer"
3 => "Two Refrigerators"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T16:39:00.479111+00:00"
+"Directions": "Newbury Dr/Rolling Meadows dr"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2078401"
+"ListOfficeKey": "290743"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "38.9 x 99.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-16T01:09:31Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-16T17:40:40Z"
+"StreetName": "Newbury"
+"StreetNumber": "331"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4738.21"
+"VirtualTourURLUnbranded": "https://real.vision/331-newbury-drive?o=u"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30036193/331-newbury-drive-kitchener"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 38.1
+"OriginalEntryTimestamp": "2026-07-15T16:10:06.27Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1353251"
+"ListOfficeNationalAssociationId": "1390645"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30036193')"
+"ID": "1626734"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "1626349"
+post_author: 1
+"ListingKey": "30034713"
+"ListingId": "40846939"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T21:10:07Z"
+"RFModificationTimestamp": "2026-07-15T21:11:53Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1702.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1Y7"
+"UnparsedAddress": "450 BEECHWOOD Place Unit# 6, Waterloo, Ontario N2T1Y7"
+"Coordinates": array:2 [
0 => -80.5573776
1 => 43.4527206
]
+"Latitude": 43.4527206
+"Longitude": -80.5573776
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare opportunity in sought-after Beechwood! This exceptionally spacious townhome condo is one of the largest units in the complex and comes with an almost unheard of double car garage. Nestled in the desirable Beechwood West community backing onto the naturalized Clair Creek greenbelt, this home offers a bright, functional layout features a main floor primary bedroom with large ensuite, as well as an additional bedroom and loft space on the upper floor. The main level features spacious living and dining areas, and dual sliders to a private balcony perfect for morning coffee. The full basement offers a large rec room area, office, laundry, and abundant storage with built-in shelving. Enjoy carefree condo living with the community pool, visitor parking, and condo fees that include water, building maintenance, roof, windows and snow removal. Steps to Beechwood Plaza, minutes to The Boardwalk, top-rated schools, both universities, and ION transit. This unit is a blank canvas awaiting your personal touch, so bring your design ideas and get ready to build instant equity and make this home your own! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener"
]
+"AssociationFee": "775"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Water"
4 => "Insurance"
5 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T13:55:49.362342+00:00"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1926813"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T21:03:27Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T21:03:27Z"
+"Stories": "2.0"
+"StreetName": "BEECHWOOD"
+"StreetNumber": "450"
+"StreetSuffix": "Place"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "4067"
+"VirtualTourURLUnbranded": "https://youriguide.com/6_450_beechwood_place_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30034713/450-beechwood-place-unit-6-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1600707"
+"CommonInterest": "Condo/Strata"
+"CoListAgentKey2": "1563792"
+"CoListOfficeKey": "299554"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "76831"
+"ZoningDescription": "MR150"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1702
+"OriginalEntryTimestamp": "2026-07-15T12:18:43.07Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1229829"
+"ListOfficeNationalAssociationId": "1473831"
+"CoListAgentNationalAssociationId": "1149297"
+"CoListAgentNationalAssociationId2": "1070179"
+"CoListOfficeNationalAssociationId": "1473831"
+"CoListOfficeNationalAssociationId2": "1004391"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30034713')"
+"ID": "1626349"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25423
+post_id: "1621265"
+post_author: 1
+"ListingKey": "30025667"
+"ListingId": "X13556632"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T16:50:07Z"
+"RFModificationTimestamp": "2026-07-13T19:36:27Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2N0B6"
+"UnparsedAddress": "5B - 931 GLASGOW STREET, Kitchener, Ontario N2N0B6"
+"Coordinates": array:2 [
0 => -80.543908
1 => 43.440286
]
+"Latitude": 43.440286
+"Longitude": -80.543908
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 931 Glasgow Street, Unit 5B, Kitchener: beautifully maintained 3-bedrooms townhouse located in one of the most convenient and sought-after neighborhoods. This home is the perfect opportunity for first-time buyers, growing families, working professionals or savvy investors seeking a low-maintenance property in a prime location. Step inside and be welcomed by a sun-filled main floor featuring an airy open-concept design that feels both spacious and inviting. The kitchen offers ample cabinetry, generous prep space and a seamless flow into the oversized dining area. The comfortable living room is the perfect place to relax while enjoying peaceful views of the adjacent greenspace, with the kitchen and dining areas also overlooking the scenic North Trail / Northforest Park setting, creating a rare sense of privacy and tranquility. The main floor also offers exceptional functionality with a convenient office, 2pc bathroom, laundry/utility room and additional storage space. Whether you need a guest room, home office or main-floor bedroom option, this layout provides endless possibilities. Upstairs, there are 3 bright and generously sized bedrooms along with a well-appointed 4pc bathroom, creating comfortable accommodations for the whole family. Enjoy outdoor living with your own private fenced patio, a charming space perfect for morning coffee, evening relaxation, container gardening, or summer BBQs. This highly desirable location offers unbeatable convenience with quick access to Uptown Waterloo, both Universities, shopping at Ira Needles Boulevard, schools, parks, walking trails, transit and major routes. With plenty of visitor parking, convenience is built right in. Tastefully designed and offering low condo fees with minimal maintenance, this townhouse is truly turnkey living at its best. Whether you are looking for your next home or a smart investment opportunity, this is a property you do not want to miss. Book your private showing today! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"AssociationFee": "347"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T19:36:18.128433+00:00"
+"Directions": "Cross Streets: University Ave West. ** Directions: University Ave West To Glasgow street."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T16:40:09Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T16:40:09Z"
+"Stories": "2.0"
+"StreetName": "Glasgow"
+"StreetNumber": "931"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3324"
+"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/30025667/5b-931-glasgow-street-kitchener"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "MILLCREEK MANAGEMENT"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"ZoningDescription": "R-6"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-07-13T16:40:09Z"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30025667')"
+"ID": "1621265"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25424
+post_id: "1621028"
+post_author: 1
+"ListingKey": "30025702"
+"ListingId": "40847335"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T17:25:21Z"
+"RFModificationTimestamp": "2026-07-17T17:37:24Z"
+"ListPrice": 2699900.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 6113.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2M2N7"
+"UnparsedAddress": "709 GLASGOW Street, Kitchener, Ontario N2M2N7"
+"Coordinates": array:2 [
0 => -80.5351584
1 => 43.4453615
]
+"Latitude": 43.4453615
+"Longitude": -80.5351584
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "An extraordinary estate situated on a RARE 1-ACRE treed property, this once-in-a-generation residence offers over 4,000 square feet of beautifully appointed living space, a triple-car garage, elegant interiors, and exceptional outdoor amenities. The thoughtfully designed main floor blends sophistication and comfort with a formal dining room featuring custom built-ins, a sunken living room with a gas fireplace and family room overlooking the spectacular grounds. The adjoining morning room is the perfect place to enjoy peaceful forest views. At the heart of the home, the kitchen with soaring 13-foot cathedral ceilings and walls of windows that fill the space with natural light. Three sets of French doors open to the covered porch and outdoor living areas. Step outside to your private 1-acre retreat surrounded by towering mature trees. Designed for entertaining, the backyard features a custom pergola, outdoor BBQ area, fire table and a spectacular 34-foot swimming pool, creating an unmatched setting for relaxation and gatherings. Upstairs, the luxurious primary suite offers two sets of French doors leading to a private balcony overlooking the pool and treed property. Four additional spacious bedrooms and two beautifully appointed family bathrooms provide exceptional space for a growing family. The finished lower level includes a fitness room, rec room, oversized games room with a built-in beverage centre, and a thoughtfully designed change room with custom built-ins and a Suitmate drying system—ideal after a day by the pool. Perfectly positioned in one of Kitchener's most sought-after neighbourhoods, this exceptional home is minutes from Westmount Golf & Country Club, Belmont Village, Uptown Waterloo, top-rated schools, universities, parks and walking trails. A truly distinguished family estate where timeless architecture, exceptional craftsmanship, and breathtaking grounds combine to create one of Waterloo Region's premier residences. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Garburator"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T19:32:46.024447+00:00"
+"Directions": "Westmount Rd W to Glasgow St"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1600661"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:8 [
0 => "Southern exposure"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Crushed stone driveway"
4 => "Skylight"
5 => "Gazebo"
6 => "Sump Pump"
7 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-14T19:13:06Z"
+"PhotosCount": 43
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T17:18:33Z"
+"Stories": "2.0"
+"StreetName": "GLASGOW"
+"StreetNumber": "709"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "18031"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30025702/709-glasgow-street-kitchener"
+"ParkingTotal": 11
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 84.0
+"AboveGradeFinishedArea": 4062
+"BelowGradeFinishedArea": 2051
+"OriginalEntryTimestamp": "2026-07-13T16:48:13.53Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1155649"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30025702')"
+"ID": "1621028"
}
]
+success: true
+page_size: 9
+page_count: 9
+count: 79
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]