array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29875364 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1510602"
+post_author: 1
+"ListingKey": "29875364"
+"ListingId": "40838072"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T14:20:04Z"
+"RFModificationTimestamp": "2026-06-11T14:24:14Z"
+"ListPrice": 625000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.06
+"LivingArea": 1304.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3X7"
+"UnparsedAddress": "243 AUBURN Drive, Waterloo, Ontario N2K3X7"
+"Coordinates": array:2 [
0 => -80.4909041
1 => 43.4896522
]
+"Latitude": 43.4896522
+"Longitude": -80.4909041
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 243 Auburn Drive, a freehold townhome in the highly sought-after University Downs neighbourhood, offering an exceptional combination of location, privacy, and lifestyle. Attached only at the garage with direct access to rear yard and no shared interior walls, this home provides the feel of a detached property while remaining affordable with absolutely no condo fees. Situated on a beautifully landscaped lot, this home offers exceptional outdoor living with a welcoming covered front porch and a private backyard deck, creating the perfect setting for relaxing, entertaining and outdoor dining. The bright, open-concept main floor is designed for modern living, featuring a spacious kitchen with ample cabinetry and a seamless flow into the dining and living areas. Large windows and patio door fill the home with natural light while providing beautiful views of the backyard. A convenient main floor powder room adds to the home's functionality. Upstairs, you'll find three generously sized bedrooms, including a spacious primary retreat featuring a large walk-in closet and abundant natural light. The additional bedrooms offer flexibility for growing families, guests, or a home office. The unfinished basement with 3 pc rough in provides excellent potential for future living space. Location is truly what sets this property apart. University Downs is one of Waterloo's most desirable family-friendly communities, you'll enjoy convenient access to excellent schools, parks, trails, sports fields, libraries, shopping, restaurants, public transit, and every daily amenity imaginable. Commuters will appreciate being just minutes from highway access, Uptown Waterloo, Downtown Kitchener, RIM Park and both universities. Whether you're a first-time buyer, young family, professional, or investor, this is an outstanding opportunity to own a well-maintained freehold home in a prime Waterloo location where convenience, community, and lifestyle come together perfectly. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T17:22:23.243840+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563431"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0.06"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T14:39:58Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T14:10:31Z"
+"Stories": "2.0"
+"StreetName": "AUBURN"
+"StreetNumber": "243"
+"StreetSuffix": "Drive"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "3637.94"
+"VirtualTourURLUnbranded": "https://youriguide.com/243_auburn_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1657052450"
"RoomType" => "4pc Bathroom"
"ListingId" => "40838072"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29875364"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T14:10:31.35Z"
]
1 => array:11 [
"RoomKey" => "1657052451"
"RoomType" => "Bedroom"
"ListingId" => "40838072"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29875364"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T14:10:31.4Z"
]
2 => array:11 [
"RoomKey" => "1657052452"
"RoomType" => "Bedroom"
"ListingId" => "40838072"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29875364"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 14'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T14:10:31.44Z"
]
3 => array:11 [
"RoomKey" => "1657052453"
"RoomType" => "Primary Bedroom"
"ListingId" => "40838072"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29875364"
"RoomLength" => null
"RoomDimensions" => "12'3'' x 13'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T14:10:31.49Z"
]
4 => array:11 [
"RoomKey" => "1657052454"
"RoomType" => "2pc Bathroom"
"ListingId" => "40838072"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29875364"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T14:10:31.52Z"
]
5 => array:11 [
"RoomKey" => "1657052455"
"RoomType" => "Living room"
"ListingId" => "40838072"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29875364"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 21'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T14:10:31.57Z"
]
6 => array:11 [
"RoomKey" => "1657052456"
"RoomType" => "Dinette"
"ListingId" => "40838072"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29875364"
"RoomLength" => null
"RoomDimensions" => "8'7'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T14:10:31.61Z"
]
7 => array:11 [
"RoomKey" => "1657052457"
"RoomType" => "Kitchen"
"ListingId" => "40838072"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29875364"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T14:10:31.65Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29875364/243-auburn-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "MD3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 24.0
+"AboveGradeFinishedArea": 1304
+"OriginalEntryTimestamp": "2026-06-09T14:39:58.61Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"ListAgentNationalAssociationId": "1069710"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29875364_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/a76dc980a6076f4d52f971a4e3021e81.webp"
"MediaSize" => 126298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-a76dc980a6076f4d52f971a4e3021e81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29875364_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/cbdc7fe634627624b01b275da2a0ad5b.webp"
"MediaSize" => 133281
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-cbdc7fe634627624b01b275da2a0ad5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29875364_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/20ca6aa9237aec6c2654dff29ec0183f.webp"
"MediaSize" => 117646
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-20ca6aa9237aec6c2654dff29ec0183f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29875364_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/4551a18611b8bcb3334d455eecae4192.webp"
"MediaSize" => 70173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-4551a18611b8bcb3334d455eecae4192.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29875364_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/6bc5df5a92bdf213ce08e12ec1fff8cc.webp"
"MediaSize" => 77119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-6bc5df5a92bdf213ce08e12ec1fff8cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29875364_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/01b0e10bc56c703a46a0dcd21807fdef.webp"
"MediaSize" => 80296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-01b0e10bc56c703a46a0dcd21807fdef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29875364_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/0b63ef45feeaf733c2ae945660b5f8b4.webp"
"MediaSize" => 71893
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-0b63ef45feeaf733c2ae945660b5f8b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29875364_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/dc70dee8e805f69e79c3ba763b7427fa.webp"
"MediaSize" => 67185
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-dc70dee8e805f69e79c3ba763b7427fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29875364_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/44aad44e8ee5775c7815e53f86c35a7b.webp"
"MediaSize" => 78554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-44aad44e8ee5775c7815e53f86c35a7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29875364_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/9fe6f52ba1ecf0b73fdcf2f1024e93aa.webp"
"MediaSize" => 62001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-9fe6f52ba1ecf0b73fdcf2f1024e93aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29875364_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/1a09a25d52fd4bfef1a83d9c0d008a80.webp"
"MediaSize" => 60574
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-1a09a25d52fd4bfef1a83d9c0d008a80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29875364_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/b7a339f7ff2175cee84d6f22066e7609.webp"
"MediaSize" => 58581
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-b7a339f7ff2175cee84d6f22066e7609.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29875364_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/3b9eec07f9d97ae06005304cc6c1ff92.webp"
"MediaSize" => 49332
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-3b9eec07f9d97ae06005304cc6c1ff92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29875364_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/0205a0673d9e10d56040211cca1b6742.webp"
"MediaSize" => 58734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-0205a0673d9e10d56040211cca1b6742.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29875364_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/967d1a673996af348bfa12c4de87557c.webp"
"MediaSize" => 60411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-967d1a673996af348bfa12c4de87557c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29875364_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/c0503b237bbd9f94d0202c5055f9ed55.webp"
"MediaSize" => 52668
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-c0503b237bbd9f94d0202c5055f9ed55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29875364_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/6f039cc056f61426796d93d0c8d7199e.webp"
"MediaSize" => 81037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-6f039cc056f61426796d93d0c8d7199e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29875364_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/67599d8bbb14c642cd84f0dbe807cd15.webp"
"MediaSize" => 73715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-67599d8bbb14c642cd84f0dbe807cd15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29875364_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/70e043f810917d3a8e64513cc8c60a5e.webp"
"MediaSize" => 75009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-70e043f810917d3a8e64513cc8c60a5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29875364_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/4a2a29389e019782be1a6cce5f47885d.webp"
"MediaSize" => 71071
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-4a2a29389e019782be1a6cce5f47885d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29875364_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/e561638b68ecea68806b41867eaf828b.webp"
"MediaSize" => 55073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-e561638b68ecea68806b41867eaf828b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29875364_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/071320789c5310cb9ad33d504586b69d.webp"
"MediaSize" => 62601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-071320789c5310cb9ad33d504586b69d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29875364_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/f0857d149bda93b158e8fce6f40ce769.webp"
"MediaSize" => 149723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-f0857d149bda93b158e8fce6f40ce769.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29875364_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/56c5fa5828a4e9c721c731fdd3874bc3.webp"
"MediaSize" => 136892
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-56c5fa5828a4e9c721c731fdd3874bc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29875364_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/b6ef9b62157a6c150553f2f70ac24f88.webp"
"MediaSize" => 144974
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-b6ef9b62157a6c150553f2f70ac24f88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29875364_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/4e0ee3dd26d1249e82da687cc8684ce4.webp"
"MediaSize" => 151589
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-4e0ee3dd26d1249e82da687cc8684ce4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29875364_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/6c1dc5a2ea04cf96e3908042b13e25aa.webp"
"MediaSize" => 164935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-6c1dc5a2ea04cf96e3908042b13e25aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29875364_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/aa7df88518ad2bb9a4ebb5cf2de7ac3c.webp"
"MediaSize" => 161519
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-aa7df88518ad2bb9a4ebb5cf2de7ac3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29875364_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/6c82170dc9030f7ab308aee15f724695.webp"
"MediaSize" => 150252
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-6c82170dc9030f7ab308aee15f724695.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29875364_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/f5cb5548ef1660eec962c4dd7c385484.webp"
"MediaSize" => 48075
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-f5cb5548ef1660eec962c4dd7c385484.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29875364_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875364/83c2a7236bf1fb3b48b2a870b676e2bc.webp"
"MediaSize" => 64677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875364/thumbnail-83c2a7236bf1fb3b48b2a870b676e2bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838072"
"ResourceRecordKey" => "29875364"
"ModificationTimestamp" => "2026-06-09T14:39:58.61Z"
]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29875364')"
+"ID": "1510602"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 289722" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24786
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1563431" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24762
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29875364'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25094
+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 '29875364'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25109
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25110
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31425825"
+"ListingKey": "29875364"
+"ListingId": "40838072"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-13T03:04:57Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31425825')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25112
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31425826"
+"ListingKey": "29875364"
+"ListingId": "40838072"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-13"
+"OpenHouseStartTime": "2026-06-13T14:00:00Z"
+"OpenHouseEndTime": "2026-06-13T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-13T03:04:57Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31425826')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29875364' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.4909041 43.4896522)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25167
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25161
+post_id: "1527189"
+post_author: 1
+"ListingKey": "29899579"
+"ListingId": "40837417"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T02:15:16Z"
+"RFModificationTimestamp": "2026-06-13T02:43:25Z"
+"ListPrice": 1499000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3528.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2K1B5"
+"UnparsedAddress": "35 SCHWEITZER Street, Kitchener, Ontario N2K1B5"
+"Coordinates": array:2 [
0 => -80.4721342
1 => 43.4802966
]
+"Latitude": 43.4802966
+"Longitude": -80.4721342
+"YearBuilt": 1860
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Step into a piece of Waterloo Region history with this stunning pre-Confederation 1860s estate, offering timeless architectural character and unmatched charm in sought-after Bridgeport East. Set on a half-acre lot in the city, this one-of-a-kind home has been renovated while preserving what makes it unique. Historically significant, the home was built nearly 50 years after the area’s original settlement and sits on a street honouring the Schweitzer family lineage. From the covered front porch to the soaring ceilings and original farmhouse details, there is something special around every corner. The spacious layout offers 4 bedrooms, 4 bathrooms, a large eat-in kitchen, and generous living and dining spaces for family life and entertaining. The location is hard to beat, with quick access to the expressway, Kitchener, Waterloo and Guelph, while still close to great schools, the Grand River, trails, parks and everyday amenities. It is rare to find this much space and privacy without giving up convenience. The backyard is private, peaceful and something special. Surrounded by mature trees, it offers beautiful views, room to spread out, and an in-ground pool ready for long summer days. Host family and friends, relax poolside, dine outdoors, or gather around the fire pit for campfires under the stars. There is space for kids, pets, gardens, games and all the fun of a great backyard. And then there is the garage. It is huge. With room for up to four vehicles, it is a dream setup for car lovers, woodworking, hobbies, a workshop, storage or the ultimate man cave. The finished basement offers a full in-law setup, accessed by a fun spiral staircase and complete with a kitchen, living room, bedroom and bathroom. It is ideal for extended family, guests or anyone needing their own space. You simply do not find properties like this often. A rare opportunity to own a fully renovated historic estate with this much charm, privacy, space, backyard beauty and city convenience! (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Range - Gas"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T02:42:45.270121+00:00"
+"Directions": "Lancaster St W to Bridge St E to Schweitzer St"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1769740"
+"ListOfficeKey": "296447"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Gazebo"
1 => "In-Law Suite"
2 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-13T02:09:58Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T02:09:58Z"
+"Stories": "2.0"
+"StreetName": "SCHWEITZER"
+"StreetNumber": "35"
+"StreetSuffix": "Street"
+"SubdivisionName": "122 - Bridgeport"
+"TaxAnnualAmount": "7564.27"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [
"RoomKey" => "1658225343"
"RoomType" => "Bedroom"
"ListingId" => "40837417"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29899579"
"RoomLength" => null
"RoomDimensions" => "17'4'' x 19'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T02:09:58.15Z"
]
1 => array:11 [
"RoomKey" => "1658225344"
"RoomType" => "Kitchen"
"ListingId" => "40837417"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29899579"
"RoomLength" => null
"RoomDimensions" => "7'5'' x 16'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T02:09:58.16Z"
]
2 => array:11 [
"RoomKey" => "1658225345"
"RoomType" => "Recreation room"
"ListingId" => "40837417"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29899579"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 23'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T02:09:58.16Z"
]
3 => array:11 [
"RoomKey" => "1658225346"
"RoomType" => "4pc Bathroom"
"ListingId" => "40837417"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29899579"
"RoomLength" => null
"RoomDimensions" => "5'5'' x 7'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T02:09:58.16Z"
]
4 => array:11 [
"RoomKey" => "1658225347"
"RoomType" => "Bedroom"
"ListingId" => "40837417"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29899579"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T02:09:58.16Z"
]
5 => array:11 [
"RoomKey" => "1658225348"
"RoomType" => "Bedroom"
"ListingId" => "40837417"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29899579"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 12'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T02:09:58.16Z"
]
6 => array:11 [
"RoomKey" => "1658225349"
"RoomType" => "Bedroom"
"ListingId" => "40837417"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29899579"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 13'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T02:09:58.16Z"
]
7 => array:11 [
"RoomKey" => "1658225350"
"RoomType" => "Primary Bedroom"
"ListingId" => "40837417"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29899579"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T02:09:58.16Z"
]
8 => array:11 [
"RoomKey" => "1658225351"
"RoomType" => "Full bathroom"
"ListingId" => "40837417"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29899579"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T02:09:58.16Z"
]
9 => array:11 [
"RoomKey" => "1658225352"
"RoomType" => "4pc Bathroom"
"ListingId" => "40837417"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29899579"
"RoomLength" => null
"RoomDimensions" => "15'11'' x 8'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T02:09:58.16Z"
]
10 => array:11 [
"RoomKey" => "1658225353"
"RoomType" => "Mud room"
"ListingId" => "40837417"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29899579"
"RoomLength" => null
"RoomDimensions" => "17'7'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T02:09:58.16Z"
]
11 => array:11 [
"RoomKey" => "1658225354"
"RoomType" => "Living room"
"ListingId" => "40837417"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29899579"
"RoomLength" => null
"RoomDimensions" => "18'9'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T02:09:58.16Z"
]
12 => array:11 [
"RoomKey" => "1658225355"
"RoomType" => "Laundry room"
"ListingId" => "40837417"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29899579"
"RoomLength" => null
"RoomDimensions" => "5'4'' x 9'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T02:09:58.16Z"
]
13 => array:11 [
"RoomKey" => "1658225356"
"RoomType" => "Kitchen"
"ListingId" => "40837417"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29899579"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 16'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T02:09:58.16Z"
]
14 => array:11 [
"RoomKey" => "1658225357"
"RoomType" => "Dining room"
"ListingId" => "40837417"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29899579"
"RoomLength" => null
"RoomDimensions" => "18'5'' x 13'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T02:09:58.16Z"
]
15 => array:11 [
"RoomKey" => "1658225358"
"RoomType" => "Breakfast"
"ListingId" => "40837417"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29899579"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 18'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T02:09:58.16Z"
]
16 => array:11 [
"RoomKey" => "1658225359"
"RoomType" => "4pc Bathroom"
"ListingId" => "40837417"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29899579"
"RoomLength" => null
"RoomDimensions" => "8'5'' x 9'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T02:09:58.16Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29899579/35-schweitzer-street-kitchener"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1688209"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2099327"
+"CoListAgentKey3": "2203749"
+"CoListOfficeKey": "296447"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "283397"
+"CoListOfficeKey3": "283397"
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 135.0
+"AboveGradeFinishedArea": 2726
+"BelowGradeFinishedArea": 802
+"OriginalEntryTimestamp": "2026-06-13T02:09:58.1Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1186018"
+"ListOfficeNationalAssociationId": "1458684"
+"CoListAgentNationalAssociationId": "1173922"
+"CoListAgentNationalAssociationId2": "1369514"
+"CoListAgentNationalAssociationId3": "1452339"
+"CoListOfficeNationalAssociationId": "1458684"
+"CoListOfficeNationalAssociationId2": "1328541"
+"CoListOfficeNationalAssociationId3": "1328541"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29899579_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899579/9b1c58dfb1dd99a3986cc297b5f879d8.webp"
"MediaSize" => 122463
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899579/thumbnail-9b1c58dfb1dd99a3986cc297b5f879d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40837417"
"ResourceRecordKey" => "29899579"
"ModificationTimestamp" => "2026-06-13T02:09:58.11Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29899579_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899579/0a4682020dd0aeeb136c46d886efa78a.webp"
"MediaSize" => 171887
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899579/thumbnail-0a4682020dd0aeeb136c46d886efa78a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837417"
"ResourceRecordKey" => "29899579"
"ModificationTimestamp" => "2026-06-13T02:09:58.11Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29899579_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899579/b5bb79c61f395d1f9b280a21f7e12f88.webp"
"MediaSize" => 168212
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899579/thumbnail-b5bb79c61f395d1f9b280a21f7e12f88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837417"
"ResourceRecordKey" => "29899579"
"ModificationTimestamp" => "2026-06-13T02:09:58.11Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29899579_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899579/194b61b5c5482129d3c64301a188de1e.webp"
"MediaSize" => 139351
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899579/thumbnail-194b61b5c5482129d3c64301a188de1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837417"
"ResourceRecordKey" => "29899579"
"ModificationTimestamp" => "2026-06-13T02:09:58.11Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29899579_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899579/93e95b120ed4596347f25899036a0d10.webp"
"MediaSize" => 77743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899579/thumbnail-93e95b120ed4596347f25899036a0d10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837417"
"ResourceRecordKey" => "29899579"
"ModificationTimestamp" => "2026-06-13T02:09:58.11Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29899579_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899579/1c4bdd87edc3ccfb83ad816fca434699.webp"
"MediaSize" => 83714
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899579/thumbnail-1c4bdd87edc3ccfb83ad816fca434699.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837417"
"ResourceRecordKey" => "29899579"
"ModificationTimestamp" => "2026-06-13T02:09:58.11Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29899579_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899579/43e7cfd5ddcdd5fb3b23bfc14a286e77.webp"
"MediaSize" => 96566
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899579/thumbnail-43e7cfd5ddcdd5fb3b23bfc14a286e77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837417"
"ResourceRecordKey" => "29899579"
"ModificationTimestamp" => "2026-06-13T02:09:58.11Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29899579_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899579/c99b4b145066d5415b6e3e5520b9e08a.webp"
"MediaSize" => 102998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899579/thumbnail-c99b4b145066d5415b6e3e5520b9e08a.webp"
…7
]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29899579')"
+"ID": "1527189"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25163
+post_id: "1521904"
+post_author: 1
+"ListingKey": "29890891"
+"ListingId": "40835701"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T19:10:10Z"
+"RFModificationTimestamp": "2026-06-12T01:46:04Z"
+"ListPrice": 1349900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2787.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0C1"
+"UnparsedAddress": "518 PREAKNESS Street, Waterloo, Ontario N2K0C1"
+"Coordinates": array:2 [
0 => -80.4832054
1 => 43.4948702
]
+"Latitude": 43.4948702
+"Longitude": -80.4832054
+"YearBuilt": 2015
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located in Waterloo East’s exclusive Woolwich Estates, this spotless, high-end home sits in one of the area’s most desirable pockets, surrounded by beautiful homes, mature streetscapes, parks and trails. Walking distance to Kiwanis Park, Grand View Trails, excellent schools and amenities, with easy access to the expressway, Rim Park, Grey Silo Golf Course, St. Jacobs, Conestoga Mall and Guelph. Impressive curb appeal starts with the brick and stucco exterior, interlock driveway, meticulous landscaping and oversized rich espresso front door. Exterior lighting on timers and an app-enabled in-ground sprinkler system make the outdoor care feel thoughtful and polished. Inside, the grand foyer features a vaulted ceiling and tiled floor, opening to a beautifully maintained main level with engineered hardwood flooring throughout. The kitchen offers stainless appliances, extensive cabinetry, a large island with breakfast bar seating and a servery with glass-front cabinetry, pantry, wine fridge and extra prep space. The kitchen flows into the bright living room with stone-surround fireplace, while the formal dining area offers great space for entertaining. A statement staircase leads to the second floor, where the soaring open-to-below design adds impressive detail. A bonus family room provides valuable extra living space for family, work-from-home needs or a cozy lounge area. The spacious primary bedroom features coffered ceilings, custom window treatments, a walk-in closet and well-appointed ensuite with double sinks and large frameless glass shower. Two additional bedrooms and a full 4-piece bath complete this level. Sliding doors off the kitchen lead to the fully fenced backyard, set on a pie-shaped lot offering more outdoor space than many lots in the area. Beautifully landscaped and lined with trees for added privacy, the yard features a large composite deck, pergola and backyard shed. Added bonus...the garage is fully drywalled and painted with a custom epoxy floor! (id:62783)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Central Vacuum - Roughed In"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T01:45:53.425914+00:00"
+"Directions": "Woolwich Street to Carriage Way to Preakness"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Stucco"
2 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1769740"
+"ListOfficeKey": "296447"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T19:00:41Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T19:00:41Z"
+"Stories": "2.0"
+"StreetName": "PREAKNESS"
+"StreetNumber": "518"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "9209.43"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/518_preakness_st_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/29890891/518-preakness-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2203749"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283397"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2787
+"OriginalEntryTimestamp": "2026-06-11T18:52:41.33Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1186018"
+"ListOfficeNationalAssociationId": "1458684"
+"CoListAgentNationalAssociationId": "1452339"
+"CoListOfficeNationalAssociationId": "1328541"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29890891')"
+"ID": "1521904"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25160
+post_id: "1521275"
+post_author: 1
+"ListingKey": "29891441"
+"ListingId": "X13433564"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T20:00:09Z"
+"RFModificationTimestamp": "2026-06-11T21:48:57Z"
+"ListPrice": 1349900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0C1"
+"UnparsedAddress": "518 PREAKNESS STREET, Waterloo, Ontario N2K0C1"
+"Coordinates": array:2 [
0 => -80.483088
1 => 43.494859
]
+"Latitude": 43.494859
+"Longitude": -80.483088
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Located in Waterloo East's exclusive Woolwich Estates, this spotless, high-end home sits in one of the area's most desirable pockets, surrounded by beautiful homes, mature streetscapes, parks and trails. Walking distance to Kiwanis Park, Grand View Trails, excellent schools and amenities, with easy access to the expressway, Rim Park, Grey Silo Golf Course, St. Jacobs, Conestoga Mall and Guelph. Impressive curb appeal starts with the brick and stucco exterior, interlock driveway, meticulous landscaping and oversized rich espresso front door. Exterior lighting on timers and an app-enabled in-ground sprinkler system make the outdoor care feel thoughtful and polished. Inside, the grand foyer features a vaulted ceiling and tiled floor, opening to a beautifully maintained main level with engineered hardwood flooring throughout. The kitchen offers stainless appliances, extensive cabinetry, a large island with breakfast bar seating and a servery with glass-front cabinetry, pantry, wine fridge and extra prep space. The kitchen flows into the bright living room with stone-surround fireplace, while the formal dining area offers great space for entertaining. A statement staircase leads to the second floor, where the soaring open-to-below design adds impressive detail. A bonus family room provides valuable extra living space for family, work-from-home needs or a cozy lounge area. The spacious primary bedroom features coffered ceilings, custom window treatments, a walk-in closet and well-appointed ensuite with double sinks and large frameless glass shower. Two additional bedrooms and a full 4-piece bath complete this level. Sliding doors off the kitchen lead to the fully fenced backyard, set on a pie-shaped lot offering more outdoor space than many lots in the area. Beautifully landscaped and lined with trees for added privacy, the yard features a large composite deck, pergola and backyard shed. Added bonus...the garage is fully drywalled and painted with a custom epoxy floor! (id:62783)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Garage door opener remote(s)"
12 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-06-11T21:48:52.710792+00:00"
+"Directions": "Cross Streets: Woolwich Street. ** Directions: Woolwich Street to Carriage Way to Preakness."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2250801"
+"ListOfficeKey": "296481"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "Flat site"
2 => "Sump Pump"
]
+"LotSizeDimensions": "40.2 x 116.5 FT ; 40.17 x 109.12 x 71.30 x 116.53"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-11T19:54:53Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T19:54:53Z"
+"Stories": "2.0"
+"StreetName": "Preakness"
+"StreetNumber": "518"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "9209.43"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/518_preakness_st_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"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29891441/518-preakness-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 40.2
+"OriginalEntryTimestamp": "2026-06-11T19:54:53.22Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1489710"
+"ListOfficeNationalAssociationId": "1470796"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891441')"
+"ID": "1521275"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25164
+post_id: "1519775"
+post_author: 1
+"ListingKey": "29889315"
+"ListingId": "40838920"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T21:30:09Z"
+"RFModificationTimestamp": "2026-06-11T21:34:17Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1559.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3S4"
+"UnparsedAddress": "465 WOOLWICH Street, Waterloo, Ontario N2K3S4"
+"Coordinates": array:2 [
0 => -80.4927797
1 => 43.4997029
]
+"Latitude": 43.4997029
+"Longitude": -80.4927797
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "O.H. SUN JUN 14th (3-5). Welcome to 8-465 Woolwich St., an exceptional value condo-townhouse in Waterloo's desirable Kiwanis Park/Lexington neighbourhood. Move-in ready and welcoming, this home offers a smart, spacious layout with quality laminate and hardwood flooring throughout the main floor and clean carpet upstairs. The efficient galley kitchen connects to the dining area and offers ample counter and cupboard space. The living room opens to your private deck and green space, creating an easy indoor-outdoor flow for summer BBQs, morning coffee, or relaxed entertaining. Upstairs, you'll find two generously sized bedrooms, each with double closets. The finished basement adds versatility and can easily serve as a family room, home office, fitness area, hobby space, or guest retreat. An additional 4-piece bathroom adds convenience and flexibility. The location is a true lifestyle highlight. Just minutes from Kiwanis Park, you'll enjoy playgrounds, picnic areas, trails and one of Waterloo's favourite public pools. Nearby RIM Park offers year-round recreation with arenas, indoor sports fields, walking tracks, fitness facilities, community programs, and Grey Silo Golf Course. Nature lovers will appreciate the close proximity to the Grand River and the Walter Bean Grand River Trail, offering kilometres of scenic pathways through beautiful natural landscapes. Enjoy walking, cycling, birdwatching, and outdoor recreation right at your doorstep. Shopping, restaurants, groceries, schools, and everyday amenities are nearby, while quick access to Highway 85 and the Conestoga Parkway makes commuting throughout Waterloo Region easy. Set in a well-managed condominium community with updates including windows, exterior doors & deck, this home is an excellent opportunity for first-time buyers, downsizers, families, or investors seeking an affordable entry into one of Waterloo's most sought-after neighbourhoods. Call your REALTOR® today and come see for yourself. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"AssociationFee": "483.12"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T18:19:05.284312+00:00"
+"Directions": "University St. to Woolwich St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564736"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-11T20:04:26Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T21:20:57Z"
+"Stories": "2.0"
+"StreetName": "WOOLWICH"
+"StreetNumber": "465"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "3113.4"
+"VirtualTourURLUnbranded": "https://youriguide.com/465-_woolwich_st_waterloo_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/29889315/465-woolwich-street-unit-8-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1060
+"BelowGradeFinishedArea": 499
+"OriginalEntryTimestamp": "2026-06-11T16:32:56.11Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1126313"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889315')"
+"ID": "1519775"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25162
+post_id: "1519349"
+post_author: 1
+"ListingKey": "29889117"
+"ListingId": "40838881"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T16:20:12Z"
+"RFModificationTimestamp": "2026-06-11T16:57:15Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.23
+"LivingArea": 2169.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K1K8"
+"UnparsedAddress": "135 BRIDGE Street W, Waterloo, Ontario N2K1K8"
+"Coordinates": array:2 [
0 => -80.4900781
1 => 43.4863491
]
+"Latitude": 43.4863491
+"Longitude": -80.4900781
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Cottage Living in the City! Rare 66' x 153' Walk-Out Bungalow Backing onto Bechtel Park! Welcome to 135 Bridge Street West, a rare gem featuring a massive, ultra-private 66 ft by 153 ft lot that makes you feel like you're at the cottage while living right in Waterloo. Parking is a breeze with a large concrete driveway accommodating four cars. Inside, the main floor features a unique primary retreat encompassing two full rooms—the second seamlessly utilized as an expansive dream walk-in closet—complete with ensuite privilege. The fully finished lower level features a family room, 3pc bathroom, and an additional bedroom. Because it is a full walk-out with large above-grade windows, the space floods with natural light and offers incredible potential for an in-law suite with direct yard access. Step outside to your large raised deck overlooking a sprawling yard that backs DIRECTLY onto Bechtel Park, giving you instant access to hiking trails, forested wetlands, sports fields, and a dog park. Incredible convenience with a grocery plaza just down the street, quick transit access, and universities just minutes away. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T16:57:12.511408+00:00"
+"Directions": "University to Bridge St W"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1915409"
+"ListOfficeKey": "156381"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.23"
+"PhotosChangeTimestamp": "2026-06-11T16:11:00Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T16:11:00Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "BRIDGE"
+"StreetNumber": "135"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "4492.58"
+"VirtualTourURLUnbranded": "https://youriguide.com/55ebg_135_bridge_st_w_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/29889117/135-bridge-street-w-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 66.0
+"AboveGradeFinishedArea": 1152
+"BelowGradeFinishedArea": 1017
+"OriginalEntryTimestamp": "2026-06-11T16:11:00.39Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1224446"
+"ListOfficeNationalAssociationId": "1003914"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889117')"
+"ID": "1519349"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25157
+post_id: "1516367"
+post_author: 1
+"ListingKey": "29884556"
+"ListingId": "X13427330"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T19:45:05Z"
+"RFModificationTimestamp": "2026-06-10T21:20:27Z"
+"ListPrice": 1525000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0C5"
+"UnparsedAddress": "158 EAGLECREST STREET, Waterloo, Ontario N2K0C5"
+"Coordinates": array:2 [
0 => -80.473869
1 => 43.499215
]
+"Latitude": 43.499215
+"Longitude": -80.473869
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To This Exquisite Family Home In The Much Sought After Neighbourhood Of Kiwanis Park. Offering Over 3,500 Square Feet Of Luxurious Living Space, This Stunning Residence Combines Elegance With Functionality, Perfect For Growing Families Or Those Who Love To Entertain. Step Inside The Expansive Open-Concept Design Featuring High Ceilings And Abundant Natural Light That Pours Through Oversized Windows. The Gourmet Kitchen With Top-Of-The-Line Stainless Steel Appliances, A Huge Island With Stone Countertops, And Ample Cabinetry Overlook The Grand Living Room With Vaulted Ceilings And Natural Gas Fireplace. The Main Floor Also Includes A Beautiful Dining Room Perfect For Hosting Dinner Parties, A Private Office And A Large Mudroom Off The Two Car Garage With Epoxied Flooring. Retreat Up The Grand Staircase To Find Spacious Bedrooms Including An Opulent Master Suite Boasting A Spa-Like En-Suite Bath And Generous Walk-In Closet. Two Additional Large Bedrooms Share An Oversized Jack & Jill Bathroom. The Upper Level Also Features A Sizable Laundry Room. The Finished Basement Has High Ceilings, A Natural Gas Fireplace And Plenty Of Space For A Gym, Gaming And Whatever Else Your Family Has In Mind. This Level Is Also Roughed In For An Additional Bedroom And Boasts Another Full Bathroom. Outside, Enjoy Your Private Backyard Oasis Ideal For Summer Barbecues Or Quiet Evenings Under The Stars. Professionally Hardscaped And Landscaped And Backing Directly Onto Kiwanis Park, This Serene Setting Is Tough To Beat. Conveniently Located Near Great Schools, Parks, Shopping Centres, And Major Highways. Don't Miss The Chance To Make This Your Forever Home! (id:62783)"
+"Appliances": array:4 [
0 => "Hot Tub"
1 => "Wine Fridge"
2 => "Window Coverings"
3 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T21:20:25.764384+00:00"
+"Directions": "Falconridge Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1998221"
+"ListOfficeKey": "50441"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Sauna"
]
+"LotSizeDimensions": "45 x 98 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T19:32:36Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T19:32:36Z"
+"Stories": "2.0"
+"StreetName": "Eaglecrest"
+"StreetNumber": "158"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "8995"
+"View": "View"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/158_eaglecrest_street_kitchener_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/29884556/158-eaglecrest-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "Res"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-10T19:32:36.48Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1280647"
+"ListOfficeNationalAssociationId": "1112107"
+"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('29884556')"
+"ID": "1516367"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1514962"
+post_author: 1
+"ListingKey": "29880685"
+"ListingId": "40823911"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T18:00:10Z"
+"RFModificationTimestamp": "2026-06-10T18:01:18Z"
+"ListPrice": 545000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1210.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2G4"
+"UnparsedAddress": "435A LEE Avenue, Waterloo, Ontario N2K2G4"
+"Coordinates": array:2 [
0 => -80.5067851
1 => 43.4965407
]
+"Latitude": 43.4965407
+"Longitude": -80.5067851
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this charming, lovingly maintained semi-detached home, proudly offered by its second owner and located in the highly desirable Lincoln Village neighbourhood. The bright eat-in kitchen features an attractive accent wall, ample cabinetry, and plenty of space for everyday family meals. The spacious open-concept living room is filled with natural light from the large bay window and offers room for both comfortable living and dining. This thoughtfully designed home boasts three generously sized bedrooms, two full bathrooms, and a functional layout that has been lovingly cared for over the years. The basement offers excellent potential for additional living space and includes a full bathroom, laundry area, and abundant storage. Adding to the appeal are the often-overlooked benefits of wonderful neighbours, a large lot, and the only carport on the street. Step outside to the covered deck overlooking the fully fenced backyard, which backs directly onto lush, park greenspace—providing added privacy and a beautiful setting for relaxing, entertaining, or enjoying family time outdoors. Ideally located close to the expressway, schools, shopping, and all amenities, this exceptional property presents a fantastic opportunity for families, first-time buyers, and investors alike. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T16:48:04.415942+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908536"
+"ListOfficeKey": "274404"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-10T17:53:18Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T17:53:18Z"
+"Stories": "2.0"
+"StreetName": "LEE"
+"StreetNumber": "435"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3220"
+"VirtualTourURLUnbranded": "https://youriguide.com/a_435_lee_avenue_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29880685/435a-lee-avenue-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1210
+"OriginalEntryTimestamp": "2026-06-10T11:52:28.19Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1221358"
+"ListOfficeNationalAssociationId": "1254957"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29880685')"
+"ID": "1514962"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25165
+post_id: "1511560"
+post_author: 1
+"ListingKey": "29876857"
+"ListingId": "40837970"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T17:30:48Z"
+"RFModificationTimestamp": "2026-06-09T18:44:17Z"
+"ListPrice": 1149000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3341.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2K4J3"
+"UnparsedAddress": "210 HAWKSWOOD Drive, Kitchener, Ontario N2K4J3"
+"Coordinates": array:2 [
0 => -80.4765068
1 => 43.4979765
]
+"Latitude": 43.4979765
+"Longitude": -80.4765068
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Fully Renovated & Backing onto Parkland in Kiwanis Park! Welcome to 210 Hawkswood, a stunning modern residence beautifully positioned in the highly sought-after Kiwanis Park neighbourhood. From the moment you step through the private entrance, the grand foyer impresses with soaring two-storey ceilings and seamless access to a dedicated main-floor office. The heart of the home opens up into a bright family room anchored by a natural gas fireplace, offering views of your fully fenced yard with deck, hot tub and the lush parkland beyond. The gourmet kitchen is a chef’s dream, completely refreshed with a sleek premium cabinets and countertops, copious storage, and a sunlit dinette. Upstairs, discover four generous bedrooms, a beautifully updated main bath, and a luxurious primary ensuite complete with a jet tub. The fully finished lower level is an entertainer's paradise, boasting an open-concept theatre area with pre-wired AV connections, a dedicated home gym space, a full bathroom, and an additional bedroom. Best of all? You back directly onto River Ridge Community Park, with trails to Kiwanis Park and the Grand River just steps from your front door. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T18:44:10.844677+00:00"
+"Directions": "Woolwich St. to Hawkswood Dr."
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stucco"
2 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1914828"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T17:20:52Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T17:20:51Z"
+"Stories": "2.0"
+"StreetName": "HAWKSWOOD"
+"StreetNumber": "210"
+"StreetSuffix": "Drive"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "6756"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://propertyvision.ca/tour/17223"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29876857/210-hawkswood-drive-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "RES-3"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2284
+"BelowGradeFinishedArea": 1057
+"OriginalEntryTimestamp": "2026-06-09T17:20:51.04Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1224120"
+"ListOfficeNationalAssociationId": "1384313"
+"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('29876857')"
+"ID": "1511560"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25166
+post_id: "1510405"
+post_author: 1
+"ListingKey": "29876050"
+"ListingId": "X13419624"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T16:05:08Z"
+"RFModificationTimestamp": "2026-06-11T16:33:23Z"
+"ListPrice": 625000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3X7"
+"UnparsedAddress": "243 AUBURN DRIVE, Waterloo, Ontario N2K3X7"
+"Coordinates": array:2 [
0 => -80.491011
1 => 43.489598
]
+"Latitude": 43.489598
+"Longitude": -80.491011
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 243 Auburn Drive, a freehold townhome in the highly sought-after University Downs neighbourhood, offering an exceptional combination of location, privacy, and lifestyle. Attached only at the garage with direct access to rear yard and no shared interior walls, this home provides the feel of a detached property while remaining affordable with absolutely no condo fees. Situated on a beautifully landscaped lot, this home offers exceptional outdoor living with a welcoming covered front porch and a private backyard deck, creating the perfect setting for relaxing, entertaining and outdoor dining. The bright, open-concept main floor is designed for modern living, featuring a spacious kitchen with ample cabinetry and a seamless flow into the dining and living areas. Large windows and patio door fill the home with natural light while providing beautiful views of the backyard. A convenient main floor powder room adds to the home's functionality. Upstairs, you'll find three generously sized bedrooms, including a spacious primary retreat featuring a large walk-in closet and abundant natural light. The additional bedrooms offer flexibility for growing families, guests, or a home office. The unfinished basement with 3 pc rough in provides excellent potential for future living space. Location is truly what sets this property apart. University Downs is one of Waterloo's most desirable family-friendly communities, you'll enjoy convenient access to excellent schools, parks, trails, sports fields, libraries, shopping, restaurants, public transit, and every daily amenity imaginable. Commuters will appreciate being just minutes from highway access, Uptown Waterloo, Downtown Kitchener, RIM Park and both universities. Whether you're a first-time buyer, young family, professional, or investor, this is an outstanding opportunity to own a well-maintained freehold home in a prime Waterloo location where convenience, community, and lifestyle come together perfectly. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T16:23:24.076012+00:00"
+"Directions": "Cross Streets: University. ** Directions: University to Auburn."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2133582"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "24 x 105 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T15:54:04Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T15:58:56Z"
+"Stories": "2.0"
+"StreetName": "Auburn"
+"StreetNumber": "243"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3637.94"
+"VirtualTourURLUnbranded": "https://youriguide.com/243_auburn_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29876050/243-auburn-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 24.0
+"OriginalEntryTimestamp": "2026-06-09T15:54:04.67Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1386021"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29876050')"
+"ID": "1510405"
}
]
+success: true
+page_size: 9
+page_count: 10
+count: 87
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]