array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29090589 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23584
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23586
+post_id: "952326"
+post_author: 1
+"ListingKey": "29090589"
+"ListingId": "40785837"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-16T22:15:37Z"
+"RFModificationTimestamp": "2025-11-18T01:08:57Z"
+"ListPrice": 1349900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3809.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1H6"
+"UnparsedAddress": "455 WINCHESTER Drive, Waterloo, Ontario N2T1H6"
+"Coordinates": array:2 [
0 => -80.55956448
1 => 43.45544554
]
+"Latitude": 43.45544554
+"Longitude": -80.55956448
+"YearBuilt": 1983
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 455 Winchester Drive! A beautifully updated 4-bedroom home in Waterloo’s Beechwood West, offering nearly 2,500 sq. ft. of refined living plus a finished basement. With its mature lot, double garage, and stylish updates throughout, it’s the perfect blend of space, comfort, and sophistication. Check out our TOP 7 reasons why this home could be the one for you: #7: BEECHWOOD WEST: Located in one of Waterloo’s most desirable neighbourhoods, Beechwood West is known for its quiet streets, mature trees, and strong community atmosphere. You’re minutes from top-rated schools, scenic trails, community pool & tennis courts plus local parks. #6: CURB APPEAL & LOT: From the extended double driveway to the inviting covered porch, this home makes a beautiful first impression. #5: MAIN FLOOR LAYOUT: The bright, open main floor features luxury vinyl plank flooring and plenty of pot lights throughout. You’ll also find a cozy family room with a wood-burning fireplace and main-floor laundry. #4: STYLISH EAT-IN KITCHEN: The updated kitchen features quartz countertops, S/S appliances, under counter lighting and an elegant waterfall island. Just off the kitchen, enjoy a formal dining room while a bright dinette with a walkout to the deck provides effortless indoor-outdoor living. #3: FULLY-FENCED BACKYARD: Host summer BBQs on the deck, unwind in the hot tub, or enjoy a good book beneath mature trees. #2: BEDROOMS & BATHROOMS: The primary suite offers a walk-in closet with custom built-ins, and a private 5-piece ensuite with double sinks and dual shower heads. #1: FINISHED BASEMENT: The expansive, carpet-free basement adds impressive versatility, featuring two large rec rooms illuminated by abundant pot lights. One includes a stylish feature wall and fireplace, while the other boasts a sleek wet bar. A flexible bonus room makes an ideal home gym or office, and you’ll also find an oversized cold cellar plus an updated 3-piece bathroom with heated floors and a walk-in shower. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Wet Bar"
9 => "Hood Fan"
10 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"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": "2025-11-11T15:21:16.481463+00:00"
+"Directions": "Fischer Hallman Drive N to Winchester Drive or Keats Way to Winchester"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1970915"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Wet bar"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
4 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-11T14:38:25Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-16T22:00:20Z"
+"Stories": "2.0"
+"StreetName": "WINCHESTER"
+"StreetNumber": "455"
+"StreetSuffix": "Drive"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "8125"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/455_winchester_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:22 [
0 => array:11 [
"RoomKey" => "1536095114"
"RoomType" => "Utility room"
"ListingId" => "40785837"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29090589"
"RoomLength" => null
"RoomDimensions" => "6'7'' x 20'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-16T22:00:20.88Z"
]
1 => array:11 [
"RoomKey" => "1536095115"
"RoomType" => "Recreation room"
"ListingId" => "40785837"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29090589"
"RoomLength" => null
"RoomDimensions" => "18'5'' x 29'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-16T22:00:20.88Z"
]
2 => array:11 [
"RoomKey" => "1536095116"
"RoomType" => "Recreation room"
"ListingId" => "40785837"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29090589"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 23'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-16T22:00:20.88Z"
]
3 => array:11 [
"RoomKey" => "1536095117"
"RoomType" => "Gym"
"ListingId" => "40785837"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29090589"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 15'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-16T22:00:20.88Z"
]
4 => array:11 [
"RoomKey" => "1536095118"
"RoomType" => "Cold room"
"ListingId" => "40785837"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29090589"
"RoomLength" => null
"RoomDimensions" => "5'3'' x 23'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-16T22:00:20.88Z"
]
5 => array:11 [
"RoomKey" => "1536095119"
"RoomType" => "3pc Bathroom"
"ListingId" => "40785837"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29090589"
"RoomLength" => null
"RoomDimensions" => "5'11'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-16T22:00:20.88Z"
]
6 => array:11 [
"RoomKey" => "1536095120"
"RoomType" => "Other"
"ListingId" => "40785837"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29090589"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 6'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-16T22:00:20.88Z"
]
7 => array:11 [
"RoomKey" => "1536095121"
"RoomType" => "Primary Bedroom"
"ListingId" => "40785837"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29090589"
"RoomLength" => null
"RoomDimensions" => "20'9'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-16T22:00:20.88Z"
]
8 => array:11 [
"RoomKey" => "1536095122"
"RoomType" => "Loft"
"ListingId" => "40785837"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29090589"
"RoomLength" => null
"RoomDimensions" => "5'9'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-16T22:00:20.88Z"
]
9 => array:11 [
"RoomKey" => "1536095123"
"RoomType" => "Bedroom"
"ListingId" => "40785837"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29090589"
"RoomLength" => null
"RoomDimensions" => "13'7'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-16T22:00:20.88Z"
]
10 => array:11 [
"RoomKey" => "1536095124"
"RoomType" => "Bedroom"
"ListingId" => "40785837"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29090589"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-16T22:00:20.88Z"
]
11 => array:11 [
"RoomKey" => "1536095125"
"RoomType" => "Bedroom"
"ListingId" => "40785837"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29090589"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-16T22:00:20.88Z"
]
12 => array:11 [
"RoomKey" => "1536095126"
"RoomType" => "5pc Bathroom"
"ListingId" => "40785837"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29090589"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 7'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-16T22:00:20.89Z"
]
13 => array:11 [
"RoomKey" => "1536095127"
"RoomType" => "4pc Bathroom"
"ListingId" => "40785837"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29090589"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 8'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-16T22:00:20.89Z"
]
14 => array:11 [
"RoomKey" => "1536095128"
"RoomType" => "Living room"
"ListingId" => "40785837"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29090589"
"RoomLength" => null
"RoomDimensions" => "19'8'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-16T22:00:20.89Z"
]
15 => array:11 [
"RoomKey" => "1536095129"
"RoomType" => "Laundry room"
"ListingId" => "40785837"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29090589"
"RoomLength" => null
"RoomDimensions" => "7'4'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-16T22:00:20.89Z"
]
16 => array:11 [
"RoomKey" => "1536095130"
"RoomType" => "Kitchen"
"ListingId" => "40785837"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29090589"
"RoomLength" => null
"RoomDimensions" => "16'1'' x 12'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-16T22:00:20.89Z"
]
17 => array:11 [
"RoomKey" => "1536095131"
"RoomType" => "Foyer"
"ListingId" => "40785837"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29090589"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-16T22:00:20.89Z"
]
18 => array:11 [
"RoomKey" => "1536095132"
"RoomType" => "Family room"
"ListingId" => "40785837"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29090589"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 21'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-16T22:00:20.89Z"
]
19 => array:11 [
"RoomKey" => "1536095133"
"RoomType" => "Dining room"
"ListingId" => "40785837"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29090589"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-16T22:00:20.89Z"
]
20 => array:11 [
"RoomKey" => "1536095134"
"RoomType" => "Breakfast"
"ListingId" => "40785837"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29090589"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 12'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-16T22:00:20.89Z"
]
21 => array:11 [
"RoomKey" => "1536095135"
"RoomType" => "2pc Bathroom"
"ListingId" => "40785837"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29090589"
"RoomLength" => null
"RoomDimensions" => "3'6'' x 7'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-16T22:00:20.89Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29090589/455-winchester-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R-1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 86.0
+"AboveGradeFinishedArea": 2658
+"BelowGradeFinishedArea": 1151
+"OriginalEntryTimestamp": "2025-11-11T14:38:25.15Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:50 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6323604251"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/18e60f114b3331dd182811db9ed484ce.webp"
"MediaSize" => 232710
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-18e60f114b3331dd182811db9ed484ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6323604308"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/0807a33edf38b70e3a0dcb9ef2df39c5.webp"
"MediaSize" => 94648
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-0807a33edf38b70e3a0dcb9ef2df39c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6323604359"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/7d01e8263489f1a9146ed846697fdd32.webp"
"MediaSize" => 57895
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-7d01e8263489f1a9146ed846697fdd32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6323604437"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/77932e460dcdf084a9679b11fa58cebf.webp"
"MediaSize" => 96073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-77932e460dcdf084a9679b11fa58cebf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6323604570"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/7ec6157ef8d68e256895c9fc87dcfe7b.webp"
"MediaSize" => 81590
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-7ec6157ef8d68e256895c9fc87dcfe7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6323604597"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/4c34e718d625c0d216a758efb6831c56.webp"
"MediaSize" => 146254
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-4c34e718d625c0d216a758efb6831c56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6323604619"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/2406195cce9a94ee79640f9c83740320.webp"
"MediaSize" => 54481
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-2406195cce9a94ee79640f9c83740320.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6323604657"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/4fd14b8a41c7b54775c955d223fd11e2.webp"
"MediaSize" => 148788
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-4fd14b8a41c7b54775c955d223fd11e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6323604726"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/2d427f3b07ef209d7000c7f1daf47468.webp"
"MediaSize" => 151037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-2d427f3b07ef209d7000c7f1daf47468.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6323604789"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/9a0058509de7ec5d9359cb109c4598d9.webp"
"MediaSize" => 175160
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-9a0058509de7ec5d9359cb109c4598d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6323604859"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/7a5ae5d97f64ba5406b67b0e4058964c.webp"
"MediaSize" => 79847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-7a5ae5d97f64ba5406b67b0e4058964c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6323604918"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/13a8706553c84efdcc4c81999358d932.webp"
"MediaSize" => 85815
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-13a8706553c84efdcc4c81999358d932.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6323605003"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/a9832ad8c72909944376916876baad6c.webp"
"MediaSize" => 67312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-a9832ad8c72909944376916876baad6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6323605045"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/396234728fb3b835dda5528d3ad9761d.webp"
"MediaSize" => 68776
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-396234728fb3b835dda5528d3ad9761d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6323605138"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/da1a751a058a3a0c11142b20ca0a94f4.webp"
"MediaSize" => 61625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-da1a751a058a3a0c11142b20ca0a94f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6323605156"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/433c025183c58a169cf6c46a5ef2b6ff.webp"
"MediaSize" => 213995
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-433c025183c58a169cf6c46a5ef2b6ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6323605215"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/b42bab6d2c703c010aa092ccd3179195.webp"
"MediaSize" => 176332
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-b42bab6d2c703c010aa092ccd3179195.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6323605244"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/808bb9b8a7136ebe4834b5898b521e02.webp"
"MediaSize" => 99497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-808bb9b8a7136ebe4834b5898b521e02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6323605402"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/7aa9478a42440ebe7673b7e15be91f60.webp"
"MediaSize" => 244006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-7aa9478a42440ebe7673b7e15be91f60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6323605420"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/dbe23679aa0f5c107c66010fa47a1fc2.webp"
"MediaSize" => 233038
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-dbe23679aa0f5c107c66010fa47a1fc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6323605484"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/81bf363e6de8c85af8bf62d26b75f0d6.webp"
"MediaSize" => 241812
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-81bf363e6de8c85af8bf62d26b75f0d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6323605517"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/f6ffdb961f995b7edcd0f4d37d42ea5d.webp"
"MediaSize" => 68279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-f6ffdb961f995b7edcd0f4d37d42ea5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6323605565"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/a7e0002c55d49d01d814947edfae938f.webp"
"MediaSize" => 41302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-a7e0002c55d49d01d814947edfae938f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6323605665"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/8073d2aa545b25290ab76b53e82a1bd3.webp"
"MediaSize" => 63124
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-8073d2aa545b25290ab76b53e82a1bd3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6323605679"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/6f7cfc06d1e2e5169d5e2308daee1a2a.webp"
"MediaSize" => 76880
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-6f7cfc06d1e2e5169d5e2308daee1a2a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6323605719"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/36786aa07c8df84225b50fa1af8c43c6.webp"
"MediaSize" => 67599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-36786aa07c8df84225b50fa1af8c43c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6323605742"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/4be7bac2ab9ba64da45adb4b0b20103b.webp"
"MediaSize" => 78019
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-4be7bac2ab9ba64da45adb4b0b20103b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6323605745"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/2158111cb6b78e4e49fe94da411b30ea.webp"
"MediaSize" => 136470
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-2158111cb6b78e4e49fe94da411b30ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6323605820"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/56227435e77a6cbba597df1677f25d24.webp"
"MediaSize" => 107559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-56227435e77a6cbba597df1677f25d24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6323605883"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/a5acc404152be4236b684290ac17f53c.webp"
"MediaSize" => 209195
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-a5acc404152be4236b684290ac17f53c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6323605897"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/fe71da6dc1e3628f3ae768a5bd3d446c.webp"
"MediaSize" => 61514
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-fe71da6dc1e3628f3ae768a5bd3d446c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6323605922"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/e44c3c6fdb3af0a6181d4fecbfc2ca2b.webp"
"MediaSize" => 66247
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-e44c3c6fdb3af0a6181d4fecbfc2ca2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6323605969"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/b880f4323fb19a18d4060e18fa0585e3.webp"
"MediaSize" => 71484
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-b880f4323fb19a18d4060e18fa0585e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6323605995"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/cc678b010f459ebe601ccad59b44d7d9.webp"
"MediaSize" => 50395
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-cc678b010f459ebe601ccad59b44d7d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6323606024"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/4b214fd8bdd09a9ed359319f3c3739cd.webp"
"MediaSize" => 63577
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-4b214fd8bdd09a9ed359319f3c3739cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6323606120"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/f305873207563b7bc819522d43e73600.webp"
"MediaSize" => 27521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-f305873207563b7bc819522d43e73600.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
"ResourceRecordKey" => "29090589"
"ModificationTimestamp" => "2025-11-11T14:38:25.16Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6323606150"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29090589/be4f69e5d9b9ef4033996bb0c217570c.webp"
"MediaSize" => 74689
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29090589/thumbnail-be4f69e5d9b9ef4033996bb0c217570c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785837"
…2
]
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": 258
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29090589')"
+"ID": "952326"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Cache Key: 5f16ebf559575c98d72ccfd66c6d6fff0568216e85966ab2af0696e367a13930" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24796
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25126
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "519-885-0200"
+"OfficeMlsId": "KW357"
+"ModificationTimestamp": "2026-03-24T17:19:30Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "290168"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "83 ERB STREET W, SUITE B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "WATERLOO"
+"OfficePostalCode": "N2L6C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1384313"
+"OriginalEntryTimestamp": "2021-04-15T13:36:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [ …6]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1069905"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('290168')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1970915" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25042
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29090589'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25442
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29090589' AND OpenHouseDate ge '2026-07-27'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25458
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29090589' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.55956448 43.45544554)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25531
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25525
+post_id: "1661770"
+post_author: 1
+"ListingKey": "30082431"
+"ListingId": "40850847"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-27T22:45:03Z"
+"RFModificationTimestamp": "2026-07-27T22:46:48Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1200.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5S7"
+"UnparsedAddress": "431 KEATS Way Unit# 3, Waterloo, Ontario N2L5S7"
+"Coordinates": array:2 [
0 => -80.556749
1 => 43.4581737
]
+"Latitude": 43.4581737
+"Longitude": -80.556749
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Conveniently located. condo townhouse. Move in ready, including all appliances and extras. Three bedrooms upstairs and a 4 Pc bathroom and freshly painted. The main floor has a beautiful clean kitchen with lots of cupboard space and easy access to the dining room. The front living room is a comfortable place to entertain. Off the dining room, you have a new sliding patio door onto a private back patio. The basement has a large rec room, with a place to work or study. There is also room for a 4th bedroom. plus a legal egress window. The basement also has a 3 pc bathroom, a large laundry room, a good sized storage room and a utility room. Grand River Transit has a stop just steps away, that takes you to UW, Laurier and Conestoga College. GRT has another stop close by that will take you to the Super Centre for your grocery shopping. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Freezer"
6 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "Other"
]
+"AssociationFee": "607"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-27T18:06:17.780870+00:00"
+"Directions": "Candlewood"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1742232"
+"ListOfficeKey": "279372"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-07-27T22:43:27Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-27T22:43:27Z"
+"Stories": "2.0"
+"StreetName": "KEATS"
+"StreetNumber": "431"
+"StreetSuffix": "Way"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3322.84"
+"Utilities": array:1 [
0 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30082431/431-keats-way-unit-3-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1200
+"OriginalEntryTimestamp": "2026-07-27T16:38:32.71Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1179397"
+"ListOfficeNationalAssociationId": "1303708"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30082431')"
+"ID": "1661770"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25527
+post_id: "1661741"
+post_author: 1
+"ListingKey": "30081476"
+"ListingId": "40851151"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-27T14:15:13Z"
+"RFModificationTimestamp": "2026-07-27T17:27:48Z"
+"ListPrice": 949900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2680.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2M9"
+"UnparsedAddress": "530 RHEINLAND Place, Waterloo, Ontario N2V2M9"
+"Coordinates": array:2 [
0 => -80.5819163
1 => 43.4600792
]
+"Latitude": 43.4600792
+"Longitude": -80.5819163
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 530 Rhineland Place, a truly custom-designed bungalow tucked away on a quiet crescent in Waterloo’s desirable Columbia Forest neighbourhood. From the moment you enter, the quality of the home is immediately apparent. Bright, thoughtfully designed living spaces are complemented by hardwood and porcelain flooring throughout the main level, custom built-in cabinetry, striking architectural details and carefully selected lighting that gives the home a refined, gallery-like feel. The spacious primary suite offers a comfortable private retreat with dual closets, and a beautifully finished ensuite. Every closet throughout the home has been designed with function and organization in mind, while built-in cabinetry on the main floor provides additional storage without compromising the clean, elegant design. The kitchen and bathrooms showcase stone countertops and quality finishes, with remarkable attention paid to every surface and detail. Natural light fills the home, creating a warm and inviting atmosphere throughout the principal rooms. The fully finished lower level offers exceptional additional living space, including a large recreation room, guest bedroom, office area, full bathroom, extensive closet storage and a generous laundry room (2025 washer/dryer). Whether hosting family, working from home or creating a private space for overnight guests, the lower level provides impressive versatility. (Furnace/AC 2020) Outside, the fully landscaped backyard has been designed for low-maintenance enjoyment. A covered porch and deck create a comfortable outdoor living area, while the mature landscaping provides privacy and a beautiful setting throughout the seasons. Additional features include a double garage, close to trails, parks, schools and the amenities of west Waterloo, roof and fascia 2020. 530 Rhineland Place is a rare opportunity to own a bungalow where thoughtful design, craftsmanship and everyday functionality come together beautifully. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-27T17:27:43.219166+00:00"
+"ExteriorFeatures": array:2 [
0 => "Steel"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2068773"
+"ListOfficeKey": "259258"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-27T14:09:27Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-27T14:09:26Z"
+"Stories": "1.0"
+"StreetName": "RHEINLAND"
+"StreetNumber": "530"
+"StreetSuffix": "Place"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5110"
+"VirtualTourURLUnbranded": "https://youriguide.com/530_rheinland_place_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30081476/530-rheinland-place-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 39.0
+"AboveGradeFinishedArea": 1356
+"BelowGradeFinishedArea": 1324
+"OriginalEntryTimestamp": "2026-07-27T14:09:26.96Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1343939"
+"ListOfficeNationalAssociationId": "1217708"
+"Media": array:42 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30081476')"
+"ID": "1661741"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25524
+post_id: "1659878"
+post_author: 1
+"ListingKey": "30079841"
+"ListingId": "40839997"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-25T20:20:10Z"
+"RFModificationTimestamp": "2026-07-25T22:42:55Z"
+"ListPrice": 272500.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1205.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5G6"
+"UnparsedAddress": "65 WESTMOUNT Road N Unit# 304, Waterloo, Ontario N2L5G6"
+"Coordinates": array:2 [
0 => -80.5394699
1 => 43.4616849
]
+"Latitude": 43.4616849
+"Longitude": -80.5394699
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Westmount Towers II-Here is your opporunity to own a bright and spacious 2 bedroom condo unit in an ideal location and at an exceptional value! Located in one of Waterloo's most desirable areas within walking distance to University's, Uptown Waterloo, numerous shops and restaurants, Waterloo Park and so much more. This unit offers low maintenance, care free living with your condo fees including ALL utilities. Unit 304 is a bright and spacious 2 bedroom, 2 bathroom unit and includes an underground parking space and storgage locker. The kitchen includes newer stainless steel appliances. The large primary bedroom includes a spacious walk in closet and a 2-piece ensuite bath. Here is your chance to get into affordable home ownership in the heart of Waterloo. (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Hood Fan"
]
+"AssociationFee": "1090"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:9 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Heat"
4 => "Electricity"
5 => "Water"
6 => "Insurance"
7 => "Parking"
8 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-07-25T22:42:43.043324+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Hot water radiator heat"
1 => "Baseboard heaters"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1935309"
+"ListOfficeKey": "292076"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Laundry- Coin operated"
2 => "No Pet Home"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-25T20:11:28Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-25T20:11:28Z"
+"Stories": "9.0"
+"StreetDirSuffix": "North"
+"StreetName": "WESTMOUNT"
+"StreetNumber": "65"
+"StreetSuffix": "Road"
+"SubdivisionName": "417 - Beechwood/University"
+"VirtualTourURLUnbranded": "https://youriguide.com/65_westmount_rd_n_304_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30079841/65-westmount-road-n-unit-304-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1904174"
+"CoListOfficeKey": "292076"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 500.0
+"AboveGradeFinishedArea": 1205
+"OriginalEntryTimestamp": "2026-07-25T20:10:13.31Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1234734"
+"ListOfficeNationalAssociationId": "1408082"
+"CoListAgentNationalAssociationId": "1219174"
+"CoListOfficeNationalAssociationId": "1408082"
+"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('30079841')"
+"ID": "1659878"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25528
+post_id: "1657935"
+post_author: 1
+"ListingKey": "30077561"
+"ListingId": "40850571"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-28T01:30:10Z"
+"RFModificationTimestamp": "2026-07-28T01:45:36Z"
+"ListPrice": 750000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2083.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2V8"
+"UnparsedAddress": "356 COLERIDGE Place, Waterloo, Ontario N2L2V8"
+"Coordinates": array:2 [
0 => -80.5517678
1 => 43.4601521
]
+"Latitude": 43.4601521
+"Longitude": -80.5517678
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Some streets you drive down. Coleridge Place, you fall for. Welcome to Old Beechwood, one of Waterloo's most desired neighbourhoods, where mature trees arch over quiet streets and homes rarely come up for sale, because once families arrive, they stay. At the heart of it sits 356 Coleridge Place, tucked into a peaceful tree-lined cul-de-sac where kids still ride bikes until the streetlights come on and neighbours actually know your name. There's even a beloved street tradition of Christmas Day ball hockey. This is the location families wait years for. From the moment you arrive, the covered front porch and original brick welcome you home. Step inside and the big bay window pours sunlight across brand new flooring, fresh paint, and updated lighting throughout. This home has been lovingly refreshed and it shows. You'll find not one, not two, but three finished living spaces, a bright living room, a warm family room, and a finished lower level, giving everyone in the family a place to gather, places to play and places to get away. The kitchen is timeless, butcher block counters, a peninsula with bar seating made for morning conversations, updated light fixtures, and brand new stainless steel appliances. Pocket doors, three comfortable bedrooms, and two full bathrooms, including a five-piece with double sinks, complete the picture. Even some of the big stuff is done, with a brand new furnace installed in 2025. Out back, giant mature trees stand over the deck and gardens like they've been waiting for you. Jump the back fence and you're at Centennial Public School. Walk ten minutes and you're at the Beechwood community pool. Wander a little further and you'll find the duck pond the neighbourhood kids adore. Old Beechwood is the neighbourhood. Coleridge Place is the street. And 356 is your invitation. Come fall in love with the home, the cul-de-sac, and the life waiting for you here. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T23:04:56.335154+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1915823"
+"ListOfficeKey": "294394"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-28T01:23:29Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-28T01:23:29Z"
+"Stories": "2.0"
+"StreetName": "COLERIDGE"
+"StreetNumber": "356"
+"StreetSuffix": "Place"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "5042"
+"VirtualTourURLUnbranded": "https://youriguide.com/356_coleridge_pl_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/30077561/356-coleridge-place-waterloo"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 56.0
+"AboveGradeFinishedArea": 1554
+"BelowGradeFinishedArea": 529
+"OriginalEntryTimestamp": "2026-07-24T20:38:21.44Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1224612"
+"ListOfficeNationalAssociationId": "1438749"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30077561')"
+"ID": "1657935"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25526
+post_id: "1655297"
+post_author: 1
+"ListingKey": "30074384"
+"ListingId": "40850568"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-27T14:30:09Z"
+"RFModificationTimestamp": "2026-07-27T14:43:42Z"
+"ListPrice": 564900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1349.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6E4"
+"UnparsedAddress": "265 WESTCOURT Place Unit# PH04, Waterloo, Ontario N2L6E4"
+"Coordinates": array:2 [
0 => -80.5405568
1 => 43.4605745
]
+"Latitude": 43.4605745
+"Longitude": -80.5405568
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Beechmont, where comfort, convenience, and an exceptional location come together. This desirable penthouse suite is ideally situated just steps from Uptown Waterloo, the YMCA, shopping, grocery stores, restaurants, parks, and walking trails, with the expressway only five minutes away for easy commuting. Inside, you'll find a bright and spacious two-bedroom layout featuring an open concept living and dining area designed for both everyday living and entertaining. The modern kitchen offers a stylish and functional space, while the enclosed solarium provides the perfect spot to enjoy your morning coffee, unwind with a book, or take in the views year-round. The primary bedroom includes its own private ensuite, complemented by a second full bathroom for guests or family. Beechmont is a beautifully maintained condominium community offering an impressive selection of amenities, including a fitness centre, games room, library, guest suite, and meticulously landscaped grounds that create a welcoming atmosphere. Whether you're downsizing, seeking a low maintenance lifestyle, or looking for a premium Uptown Waterloo location, this penthouse is an outstanding opportunity. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "831"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T13:35:22.998871+00:00"
+"Directions": "Westmount/Father David Bauer"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563569"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "No Pet Home"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-27T14:22:18Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-27T14:22:18Z"
+"Stories": "1.0"
+"StreetName": "WESTCOURT"
+"StreetNumber": "265"
+"StreetSuffix": "Place"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "4123.36"
+"VirtualTourURLUnbranded": "https://youriguide.com/265_westcourt_pl_ph04_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30074384/265-westcourt-place-unit-ph04-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1600603"
+"CommonInterest": "Condo/Strata"
+"CoListAgentKey2": "2246706"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Guest Suite"
2 => "Party Room"
]
+"CoListOfficeKey2": "76826"
+"ZoningDescription": "MR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1349
+"OriginalEntryTimestamp": "2026-07-24T12:59:01.79Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1109914"
+"ListOfficeNationalAssociationId": "1389824"
+"CoListAgentNationalAssociationId": "1145016"
+"CoListAgentNationalAssociationId2": "1485557"
+"CoListOfficeNationalAssociationId": "1004387"
+"CoListOfficeNationalAssociationId2": "1004387"
+"Media": array:49 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30074384')"
+"ID": "1655297"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25521
+post_id: "1654553"
+post_author: 1
+"ListingKey": "30073974"
+"ListingId": "X13600694"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T03:40:01Z"
+"RFModificationTimestamp": "2026-07-24T04:37:45Z"
+"ListPrice": 990000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2W4"
+"UnparsedAddress": "735 KARLSFELD ROAD, Waterloo, Ontario N2T2W4"
+"Coordinates": array:2 [
0 => -80.57791
1 => 43.456617
]
+"Latitude": 43.456617
+"Longitude": -80.57791
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Nestled in the heart of Clair Hills, this bright and spacious home offers the perfect blend ofcomfort, nature, and community. Located just steps from scenic walking trails and a charmingneighbourhood park, the area is known for a very friendly, respectful atmosphere and top-ratedschools.This well-designed two-story home features an open-concept layout with 4 bedrooms, 3 bathrooms,and a 2-car garage plus a double driveway accommodating up to 4 vehicles.The main floor is ideal for both everyday living and entertaining. A generous living and diningarea flows seamlessly into a warm and inviting family room with large windows and a cozy gasfireplace. The kitchen offers ample cabinetry, an open connection to the family room, and apleasant view right from the kitchen sink window.Step outside to enjoy a southwest-facing deck overlooking the open area - perfect for relaxingevenings and sunsets.Upstairs, you'll find four spacious bedrooms, each with a good size closets. The primary suite features abundant natural light, a walk-in closet, and a private ensuite bathroom complete with a tub, separate shower, and oversized vanity.Unfinished basement has big windows and walk-in backyard entry, good for storage or as a fitness equipment room.Conveniently located just minutes from major amenities including Costco and T&T Supermarket, as well as top institutions such as University of Waterloo and Wilfrid Laurier University.This home is ideal for families seeking space, comfort, and a peaceful, nature-connected lifestyle. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"Basement": array:4 [
0 => "Unfinished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T04:37:35.038256+00:00"
+"Directions": "Cross Streets: Keats Way and Erbsville Rd. ** Directions: Erbsville Rd to Keats Way to Karlsfeld Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Tile"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1623242"
+"ListOfficeKey": "300429"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "34 x 128 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T03:32:27Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T03:32:27Z"
+"Stories": "2.0"
+"StreetName": "Karlsfeld"
+"StreetNumber": "735"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6359.23"
+"VirtualTourURLUnbranded": "https://view.tours4listings.com/cp/735-karlsfeld-road-waterloo/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30073974/735-karlsfeld-road-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 34.0
+"OriginalEntryTimestamp": "2026-07-24T03:32:27.72Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1160967"
+"ListOfficeNationalAssociationId": "1487853"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30073974')"
+"ID": "1654553"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23598
+post_id: "1652990"
+post_author: 1
+"ListingKey": "30070839"
+"ListingId": "40850520"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T16:45:06Z"
+"RFModificationTimestamp": "2026-07-23T19:32:17Z"
+"ListPrice": 829900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2266.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2N3R7"
+"UnparsedAddress": "59 IRON GATE Street, Kitchener, Ontario N2N3R7"
+"Coordinates": array:2 [
0 => -80.5561378
1 => 43.4380116
]
+"Latitude": 43.4380116
+"Longitude": -80.5561378
+"YearBuilt": 2008
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "ABSOLUTELY STUNNING & FULLY RENOVATED FROM TOP TO BOTTOM! Welcome to this superb freehold home, offered for the first time in a highly desirable, family-oriented Waterloo neighbourhood with NO REAR NEIGHBOURS! Perfectly carpet free and freshly painted, this residence blends modern luxury with ultimate convenience. The main level boasts a bright, open layout featuring a newly updated kitchen complete with gorgeous quartz countertops, a stylish new backsplash, and stainless steel appliances. Walk up the beautifully updated staircase to find 3 generous bedrooms and updated bathrooms. In total, this home features 3 spacious bedrooms and 4 completely renovated, well-appointed bathrooms! The fully finished basement features large windows that flood the space with natural light, offering the perfect setup for your recreational space. Every detail has been taken care of: new flooring throughout, updated modern light fixtures, and a brand-new water softener. Unbeatable location just minutes from The Boardwalk Shopping Centre, excellent schools, and top-tier institutions including the University of Waterloo and Wilfred Laurier University. Move-in ready with zero renovation hassle just turn the key and settle into this wonderful community. Schedule your private viewing today before it’s gone! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "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-23T19:32:05.590879+00:00"
+"Directions": "University Ave West to Countrystone Drive to Iron Gate Street."
+"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": "1981149"
+"ListOfficeKey": "135429"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T16:38:10Z"
+"PhotosCount": 39
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T16:38:10Z"
+"Stories": "2.0"
+"StreetName": "IRON GATE"
+"StreetNumber": "59"
+"StreetSuffix": "Street"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "4569"
+"VirtualTourURLUnbranded": "https://youriguide.com/59_iron_gate_st_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30070839/59-iron-gate-street-kitchener"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 26.0
+"AboveGradeFinishedArea": 1622
+"BelowGradeFinishedArea": 644
+"OriginalEntryTimestamp": "2026-07-23T16:38:10.57Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1266646"
+"ListOfficeNationalAssociationId": "1195809"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30070839')"
+"ID": "1652990"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25529
+post_id: "1652383"
+post_author: 1
+"ListingKey": "30071331"
+"ListingId": "X13598432"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-27T12:20:07Z"
+"RFModificationTimestamp": "2026-07-27T12:21:46Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V1"
+"UnparsedAddress": "519 YORKSHIRE DRIVE, Waterloo, Ontario N2T2V1"
+"Coordinates": array:2 [
0 => -80.572799
1 => 43.457509
]
+"Latitude": 43.457509
+"Longitude": -80.572799
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "RemarksPublic Remarks: Welcome to 519 Yorkshire Drive, Waterloo: Luxury Living in Prestigious Upper Beechwood! A beautifully updated detached 2-storey home, Nestled on a mature, tree-lined street in Upper Beechwood offers outstanding curb appeal with lush landscaping and parking for 4 vehicles (2 in oversized 13.5 ft high garage, 2 on concrete driveway. Step inside through a Grand porch to welcoming foyer leading to a thoughtfully renovated interior featuring updated flooring and pot lights throughout. The spacious living room is warm, airy and very bright. A rare main-floor bedroom offers incredible flexibility. The inviting family room creates the perfect setting for relaxing evenings, game nights or movie nights. The beautifully updated kitchen is fully equipped with stainless steel appliances, granite countertops, a chic tile backsplash and ample cabinetry. Adjacent is the spacious dining area, perfect for hosting dinner parties or creating lasting memories. A spacious Laundry room with ample storage and a convenient 2pc powder room completes the main level. Upstairs there are 4 generous bedrooms and 2 full bathrooms. The primary suite includes a walk-in closet and a luxurious ensuite with a Jacuzzi tub. Most windows in this house have been replaced. The fully finished basement adds exceptional living space with 2 additional bedrooms, 3pc bathroom and huge Rec area with kitchenette setup. Step outside to fully fenced backyard, featuring a spacious patio and charming gazebo, perfect for summer BBQs, entertaining or simply relaxing. Additional updates: Furnace and AC (2025) and a new water heater (2026). Located minutes from top-rated schools, University of Waterloo and Wilfrid Laurier, The Boardwalk Plaza, Costco, parks, Trails, public transit, restaurants and healthcare facilities, this location has it all. Offering 7 bedrooms, 4 bathrooms, this beautifully upgraded home is a rare opportunity, Book your private showing today and make it your forever home. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Freezer"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
11 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T19:02:42.717889+00:00"
+"Directions": "Cross Streets: Erbsville Rd/ Keatsway. ** Directions: Erbsville Road to Keatsway."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "47.9 x 102 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T17:39:27Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-27T12:10:38Z"
+"Stories": "2.0"
+"StreetName": "Yorkshire"
+"StreetNumber": "519"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6960"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/6d9ag_519_yorkshire_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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30071331/519-yorkshire-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 47.1
+"OriginalEntryTimestamp": "2026-07-23T17:39:27.54Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:49 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30071331')"
+"ID": "1652383"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25530
+post_id: "1652258"
+post_author: 1
+"ListingKey": "30070302"
+"ListingId": "40849801"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-26T20:35:22Z"
+"RFModificationTimestamp": "2026-07-26T20:38:33Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 3733.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V1"
+"UnparsedAddress": "519 YORKSHIRE Drive, Waterloo, Ontario N2T2V1"
+"Coordinates": array:2 [
0 => -80.5727819
1 => 43.4575227
]
+"Latitude": 43.4575227
+"Longitude": -80.5727819
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 519 Yorkshire Drive, Waterloo: Luxury Living in Prestigious Upper Beechwood! A beautifully updated detached 2-storey home, Nestled on a mature, tree-lined street in Upper Beechwood offers outstanding curb appeal with lush landscaping and parking for 4 vehicles (2 in oversized 13.5 ft high garage, 2 on concrete driveway. Step inside through a Grand porch to welcoming foyer leading to a thoughtfully renovated interior featuring updated flooring and pot lights throughout. The spacious living room is warm, airy and very bright. A rare main-floor bedroom offers incredible flexibility. The inviting family room creates the perfect setting for relaxing evenings, game nights or movie nights. The beautifully updated kitchen is fully equipped with stainless steel appliances, granite countertops, a chic tile backsplash and ample cabinetry. Adjacent is the spacious dining area, perfect for hosting dinner parties or creating lasting memories. A spacious Laundry room with ample storage and a convenient 2pc powder room completes the main level. Upstairs there are 4 generous bedrooms and 2 full bathrooms. The primary suite includes a walk-in closet and a luxurious ensuite with a Jacuzzi tub. Most windows in this house have been replaced. The fully finished basement adds exceptional living space with 2 additional bedrooms, 3pc bathroom and huge Rec area with kitchenette setup. Step outside to fully fenced backyard, featuring a spacious patio and charming gazebo, perfect for summer BBQs, entertaining or simply relaxing. Additional updates: Furnace and AC (2025) and a new water heater (2026). Located minutes from top-rated schools, University of Waterloo and Wilfrid Laurier, The Boardwalk Plaza, Costco, parks, Trails, public transit, restaurants and healthcare facilities, this location has it all. Offering 7 bedrooms, 4 bathrooms, this beautifully upgraded home is a rare opportunity, Book your private showing today and make it your forever home. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Freezer"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T16:58:13.051179+00:00"
+"Directions": "Erbsville Road to Keatsway"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564507"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T15:38:28Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-26T20:29:31Z"
+"Stories": "2.0"
+"StreetName": "YORKSHIRE"
+"StreetNumber": "519"
+"StreetSuffix": "Drive"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "6960"
+"VirtualTourURLUnbranded": "https://youriguide.com/6d9ag_519_yorkshire_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30070302/519-yorkshire-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 48.0
+"AboveGradeFinishedArea": 2447
+"BelowGradeFinishedArea": 1286
+"OriginalEntryTimestamp": "2026-07-23T15:38:28.07Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1123254"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30070302')"
+"ID": "1652258"
}
]
+success: true
+page_size: 9
+page_count: 15
+count: 134
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
]
