array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29014078/Property?$select=ALL&$top=20&$filter=ListingKey eq 29014078&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29014078/Property?$select=ALL&$top=20&$filter=ListingKey eq 29014078&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23512
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23514
+post_id: "341129"
+post_author: 1
+"ListingKey": "29014078"
+"ListingId": "40779922"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-21T16:25:38Z"
+"RFModificationTimestamp": "2025-10-22T09:30:28Z"
+"ListPrice": 2099999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1479.0
+"BuildingAreaTotal": 0
+"City": "Conestogo"
+"PostalCode": "N3B1Y3"
+"UnparsedAddress": "36 ELGIN E/S Street W, Conestogo, Ontario N3B1Y3"
+"Coordinates": array:2 [
0 => -80.50106888
1 => 43.54023931
]
+"Latitude": 43.54023931
+"Longitude": -80.50106888
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 36 Elgin Street a rare and exceptional land opportunity in the heart of Conestogo, where theGrand River meets the Conestogo River. Set on nearly 4 acres of mature, tree-lined land, this uniqueproperty offers scenic beauty, privacy, and outstanding redevelopment potential. Whether you're looking torestore the existing farmhouse or build your dream home, this site presents endless possibilities in one ofWaterloo Region's most picturesque settings.The existing 3-bedroom, 1-bathroom farmhouse spans over1,800 sq. ft. and is rich with rustic charm featuring original woodwork, wide plank floors, vintagefireplaces, and expansive windows that fill the home with natural light. The main floor includes two invitingliving areas and a spacious country-style kitchen with a walkout to the backyard. Upstairs are threecharacter-filled bedrooms that can be renovated or reimagined as part of a larger vision.Zoned residentialand surrounded by estate-style, multi-million-dollar homes, this property is ideally located close to trails,golf courses, St. Jacobs, Elmira, and the city of Waterloo. Whether you're a builder, investor, or a familydreaming of a countryside retreat close to urban conveniences this is a rare opportunity not to bemissed.roots in a peaceful, well-connected community. (id:62650)"
+"Appliances": array:3 [
0 => "Refrigerator"
1 => "Stove"
2 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2025-10-22T09:30:06.793104+00:00"
+"Directions": "Sawmill Road & Glasgow St S"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2106892"
+"ListOfficeKey": "294394"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Corner Site"
2 => "Ravine"
3 => "Conservation/green belt"
4 => "Country residential"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2025-10-21T16:19:25Z"
+"PhotosCount": 13
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-10-21T16:19:25Z"
+"Stories": "2.0"
+"StreetDirSuffix": "West"
+"StreetName": "ELGIN E/S"
+"StreetNumber": "36"
+"StreetSuffix": "Street"
+"SubdivisionName": "553 - St Jacobs/Floradale/W.Montrose"
+"TaxAnnualAmount": "4104"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1519230437"
"RoomType" => "5pc Bathroom"
"ListingId" => "40779922"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29014078"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-21T16:19:25.82Z"
]
1 => array:11 [
"RoomKey" => "1519230438"
"RoomType" => "Attic"
"ListingId" => "40779922"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29014078"
"RoomLength" => null
"RoomDimensions" => "19'1'' x 28'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-21T16:19:25.82Z"
]
2 => array:11 [
"RoomKey" => "1519230439"
"RoomType" => "Living room"
"ListingId" => "40779922"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29014078"
"RoomLength" => null
"RoomDimensions" => "15'9'' x 17'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-21T16:19:25.82Z"
]
3 => array:11 [
"RoomKey" => "1519230440"
"RoomType" => "Bedroom"
"ListingId" => "40779922"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29014078"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-21T16:19:25.83Z"
]
4 => array:11 [
"RoomKey" => "1519230441"
"RoomType" => "Bedroom"
"ListingId" => "40779922"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29014078"
"RoomLength" => null
"RoomDimensions" => "7'11'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-21T16:19:25.83Z"
]
5 => array:11 [
"RoomKey" => "1519230442"
"RoomType" => "Primary Bedroom"
"ListingId" => "40779922"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29014078"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-21T16:19:25.83Z"
]
6 => array:11 [
"RoomKey" => "1519230443"
"RoomType" => "Mud room"
"ListingId" => "40779922"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29014078"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 21'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-21T16:19:25.83Z"
]
7 => array:11 [
"RoomKey" => "1519230444"
"RoomType" => "Cold room"
"ListingId" => "40779922"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29014078"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 8'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-21T16:19:25.83Z"
]
8 => array:11 [
"RoomKey" => "1519230445"
"RoomType" => "Laundry room"
"ListingId" => "40779922"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29014078"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-21T16:19:25.83Z"
]
9 => array:11 [
"RoomKey" => "1519230446"
"RoomType" => "Family room"
"ListingId" => "40779922"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29014078"
"RoomLength" => null
"RoomDimensions" => "12'3'' x 13'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-21T16:19:25.83Z"
]
10 => array:11 [
"RoomKey" => "1519230447"
"RoomType" => "Dining room"
"ListingId" => "40779922"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29014078"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 13'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-21T16:19:25.84Z"
]
11 => array:11 [
"RoomKey" => "1519230448"
"RoomType" => "Kitchen"
"ListingId" => "40779922"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29014078"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 21'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-10-21T16:19:25.84Z"
]
]
+"ListAOR": "Cornerstone - Hamilton-Burlington"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29014078/36-elgin-es-street-w-conestogo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "V"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 685.0
+"AboveGradeFinishedArea": 1479
+"OriginalEntryTimestamp": "2025-10-21T16:19:25.78Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:13 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6259010834"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29014078/7b6093ed92151ce7c035e6132a362527.webp"
"MediaSize" => 109648
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29014078/thumbnail-7b6093ed92151ce7c035e6132a362527.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area with crown molding, a glass covered fireplace, and wood finished floors Virtual Staged"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40779922"
"ResourceRecordKey" => "29014078"
"ModificationTimestamp" => "2025-10-21T16:19:25.79Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6259010838"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29014078/29c65a96a3bbaea84b76e09202211311.webp"
"MediaSize" => 89081
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29014078/thumbnail-29c65a96a3bbaea84b76e09202211311.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area with crown molding and wood finished floors Virtual Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40779922"
"ResourceRecordKey" => "29014078"
"ModificationTimestamp" => "2025-10-21T16:19:25.79Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6259010843"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29014078/f5bcbc7c27363e46ea4ad5a748ff30c4.webp"
"MediaSize" => 94190
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29014078/thumbnail-f5bcbc7c27363e46ea4ad5a748ff30c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Empty Lower floor of the house Virtual Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40779922"
"ResourceRecordKey" => "29014078"
"ModificationTimestamp" => "2025-10-21T16:19:25.79Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6259010848"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29014078/2b7c2c2a22086ee41eb43ca94463bca4.webp"
"MediaSize" => 116940
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29014078/thumbnail-2b7c2c2a22086ee41eb43ca94463bca4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring wooden walls and wood finished floors Virtual Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40779922"
"ResourceRecordKey" => "29014078"
"ModificationTimestamp" => "2025-10-21T16:19:25.79Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6259010855"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29014078/31f288926ec1b5a2d4349f7e327e0d2d.webp"
"MediaSize" => 85015
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29014078/thumbnail-31f288926ec1b5a2d4349f7e327e0d2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring baseboards and light wood finished floors Virtual Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40779922"
"ResourceRecordKey" => "29014078"
"ModificationTimestamp" => "2025-10-21T16:19:25.79Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6259010860"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29014078/2aa59f962dd0be25422eb9fb20e28c6a.webp"
"MediaSize" => 103027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29014078/thumbnail-2aa59f962dd0be25422eb9fb20e28c6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with cooling unit and wood walls Virtual Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40779922"
"ResourceRecordKey" => "29014078"
"ModificationTimestamp" => "2025-10-21T16:19:25.79Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6259010868"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29014078/a3debc7eadd8cd75c5115dbadf52dc79.webp"
"MediaSize" => 156206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29014078/thumbnail-a3debc7eadd8cd75c5115dbadf52dc79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of side of property featuring a patio, roof with shingles, and stucco siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40779922"
"ResourceRecordKey" => "29014078"
"ModificationTimestamp" => "2025-10-21T16:19:25.79Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6259010875"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29014078/13cb88b848fc845e858a424353900d5d.webp"
"MediaSize" => 161955
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29014078/thumbnail-13cb88b848fc845e858a424353900d5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of side of home featuring a lawn, an outbuilding, a chimney, and brick siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40779922"
"ResourceRecordKey" => "29014078"
"ModificationTimestamp" => "2025-10-21T16:19:25.79Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6259010885"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29014078/22837307c21f027493608d69b1da1832.webp"
"MediaSize" => 192077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29014078/thumbnail-22837307c21f027493608d69b1da1832.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Back of house featuring a yard and a chimney"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40779922"
"ResourceRecordKey" => "29014078"
"ModificationTimestamp" => "2025-10-21T16:19:25.79Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6259010895"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29014078/5eb64432598abf21a782b5680bd7e431.webp"
"MediaSize" => 107964
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29014078/thumbnail-5eb64432598abf21a782b5680bd7e431.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial view of property Line and surrounding area with property boundaries highlighted"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40779922"
"ResourceRecordKey" => "29014078"
"ModificationTimestamp" => "2025-10-21T16:19:25.79Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6259010908"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29014078/35a24c985904221b82e49daafc75f8dc.webp"
"MediaSize" => 123879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29014078/thumbnail-35a24c985904221b82e49daafc75f8dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Birds eye view of property with a residential view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40779922"
"ResourceRecordKey" => "29014078"
"ModificationTimestamp" => "2025-10-21T16:19:25.79Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6259010922"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29014078/8111447b1ac592ab2ca53361b752b0a4.webp"
"MediaSize" => 120829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29014078/thumbnail-8111447b1ac592ab2ca53361b752b0a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Drone / aerial view featuring a water view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40779922"
"ResourceRecordKey" => "29014078"
"ModificationTimestamp" => "2025-10-21T16:19:25.79Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6259010933"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29014078/e4d774199a30e0dc89d20e47ba2393eb.webp"
"MediaSize" => 129987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29014078/thumbnail-e4d774199a30e0dc89d20e47ba2393eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Birds eye view of property with a water view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40779922"
"ResourceRecordKey" => "29014078"
"ModificationTimestamp" => "2025-10-21T16:19:25.79Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "MATHEW TOUSSAINT"
"MemberFirstName" => "MATHEW"
"MemberLastName" => "TOUSSAINT"
"MemberMlsId" => "CA7854"
"OriginatingSystemName" => 26
"MemberKey" => "2106892"
"ModificationTimestamp" => "2025-12-11T01:31:28Z"
"MemberStatus" => "Active"
"OfficeKey" => "294394"
"MemberAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberCity" => "Kitchener"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "289-983-0990"
"MemberSocialMedia" => array:5 [ …5]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2021-01-08T19:19:00Z"
"MemberNationalAssociationId" => "1375917"
"OfficeNationalAssociationId" => "1438749"
]
]
+"Office": array:1 [
0 => array:20 [
"OfficeName" => "eXp Realty, Brokerage"
"OfficePhone" => "866-530-7737"
"OfficeMlsId" => "WR50758"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "294394"
"ModificationTimestamp" => "2025-08-19T15:49:32Z"
"OfficeAddress1" => "7-871 Victoria St. N., Unit 355A"
"OfficeCity" => "Kitchener"
"OfficePostalCode" => "N2B3S"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2023-04-18T17:07:00Z"
"OfficeNationalAssociationId" => "1438749"
"OfficeBrokerNationalAssociationId" => "1430609"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29014078')"
+"ID": "341129"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Cache Key: ef0105ba09f054e938b588b1bf338d984045d59e8ee9c77a43ac364d58729c72" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25315
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25309
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "eXp Realty, Brokerage"
+"OfficeEmail": null
+"OfficePhone": "866-530-7737"
+"OfficeMlsId": "WR50758"
+"ModificationTimestamp": "2025-08-19T15:49:32Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "294394"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "7-871 Victoria St. N., Unit 355A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Kitchener"
+"OfficePostalCode": "N2B3S"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1438749"
+"OriginalEntryTimestamp": "2023-04-18T17:07:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "284377"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "294394"
"SocialMediaUrlOrId" => "http://www.exprealty.ca/"
"ModificationTimestamp" => "2025-08-19T15:26:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1430609"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('294394')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Cache Key: 008330ed753f5a42eb797dc227713b1818475875867026307a0e91d64c0c05f2" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25310
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29014078" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24953
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29014078/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29014078&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29014078/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29014078&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24933
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29014078 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.50106888 43.54023931)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29014078 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.50106888 43.54023931)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29014078 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.50106888 43.54023931)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29014078 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.50106888 43.54023931)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24788
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25147
+post_id: "473825"
+post_author: 1
+"ListingKey": "29177727"
+"ListingId": "40793297"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-19T05:40:46Z"
+"RFModificationTimestamp": "2025-12-19T05:42:36Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1836.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0E9"
+"UnparsedAddress": "271 GREY SILO Road Unit# 51, Waterloo, Ontario N2K0E9"
+"Coordinates": array:2 [
0 => -80.4951779
1 => 43.5235489
]
+"Latitude": 43.5235489
+"Longitude": -80.4951779
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this luxury Trailside Townhome located in the highly sought-after Carriage Crossing community in Waterloo! Enjoy a maintenance-free lifestyle with lawn care, landscaping, and snow removal included. This modern and elegant 4-bedroom, 4-bathroom home offers a double car garage and exceptional finishes throughout. The main floor provides a versatile office/bedroom complete with a stunning 3-piece ensuite featuring a quartz vanity and sleek tiled shower. The second level showcases an open-concept layout with a gourmet kitchen boasting an island, quartz countertops, stainless steel appliances, and a spacious walk-in pantry/storage. The adjoining great room and dining area feature warm hardwood flooring, along with a convenient 2-piece powder room and access to a balcony. On the third level, the primary bedroom offers a walk-in closet and a beautifully designed ensuite with tiled shower and quartz vanity. Two additional bedrooms share a stylish 4-piece bathroom. The upper-level laundry adds convenience, plus a second balcony for outdoor enjoyment. Situated just steps from the Walter Bean Trail, Grand River, RIM Park, Grey Silo Golf Course, and close to Conestoga Mall, Conestoga College, and University of Waterloo—this home provides an unbeatable lifestyle with easy access to premium amenities and top-rated schools. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-10T19:52:20.050381+00:00"
+"Directions": "Millennium to Crossgate"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2218013"
+"ListOfficeKey": "289539"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2025-12-10T19:31:02Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-19T05:29:47Z"
+"Stories": "3.0"
+"StreetName": "GREY SILO"
+"StreetNumber": "271"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "6247"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1551198948"
"RoomType" => "3pc Bathroom"
"ListingId" => "40793297"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T05:29:47.95Z"
]
1 => array:11 [
"RoomKey" => "1551198949"
"RoomType" => "Primary Bedroom"
"ListingId" => "40793297"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T05:29:47.95Z"
]
2 => array:11 [
"RoomKey" => "1551198950"
"RoomType" => "Bedroom"
"ListingId" => "40793297"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T05:29:47.95Z"
]
3 => array:11 [
"RoomKey" => "1551198951"
"RoomType" => "2pc Bathroom"
"ListingId" => "40793297"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T05:29:47.95Z"
]
4 => array:11 [
"RoomKey" => "1551198952"
"RoomType" => "Kitchen"
"ListingId" => "40793297"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T05:29:47.95Z"
]
5 => array:11 [
"RoomKey" => "1551198953"
"RoomType" => "Dining room"
"ListingId" => "40793297"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T05:29:47.95Z"
]
6 => array:11 [
"RoomKey" => "1551198954"
"RoomType" => "Great room"
"ListingId" => "40793297"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T05:29:47.95Z"
]
7 => array:11 [
"RoomKey" => "1551198955"
"RoomType" => "Bedroom"
"ListingId" => "40793297"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T05:29:47.95Z"
]
8 => array:11 [
"RoomKey" => "1551198956"
"RoomType" => "4pc Bathroom"
"ListingId" => "40793297"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T05:29:47.95Z"
]
9 => array:11 [
"RoomKey" => "1551198957"
"RoomType" => "3pc Bathroom"
"ListingId" => "40793297"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T05:29:47.95Z"
]
10 => array:11 [
"RoomKey" => "1551198958"
"RoomType" => "Bedroom"
"ListingId" => "40793297"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T05:29:47.96Z"
]
11 => array:11 [
"RoomKey" => "1551198959"
"RoomType" => "Foyer"
"ListingId" => "40793297"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29177727"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T05:29:47.96Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29177727/271-grey-silo-road-unit-51-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 3150
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "R9"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1836
+"OriginalEntryTimestamp": "2025-12-10T19:08:37.09Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:21 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6363556537"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/8e2dbb72f07135921fe4cc0519d1fe00.webp"
"MediaSize" => 89118
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-8e2dbb72f07135921fe4cc0519d1fe00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:01.23Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6363556542"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/e08933b212cbee268c47c86b498ec65e.webp"
"MediaSize" => 49647
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-e08933b212cbee268c47c86b498ec65e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:01.23Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6363556564"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/394617d99b8ceb295770ebf2ad08a20d.webp"
"MediaSize" => 77362
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-394617d99b8ceb295770ebf2ad08a20d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.61Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6363556579"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/284c05f736691f590761df07460b0e9f.webp"
"MediaSize" => 96486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-284c05f736691f590761df07460b0e9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.63Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6363556604"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/344768f7910af204eb68dad7e4ebd97c.webp"
"MediaSize" => 79193
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-344768f7910af204eb68dad7e4ebd97c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:01.23Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6363556634"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/5e0a8f654e05db5d38149db42e09fc84.webp"
"MediaSize" => 140594
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-5e0a8f654e05db5d38149db42e09fc84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main floor bedroom with ensuite"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.63Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6363556656"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/91cef1d5ca4f5690c4acf0c588d5b819.webp"
"MediaSize" => 67200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-91cef1d5ca4f5690c4acf0c588d5b819.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:01.23Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6363556678"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/48b659e75578bdefe0278680354d74d0.webp"
"MediaSize" => 68882
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-48b659e75578bdefe0278680354d74d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.61Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6363556706"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/63b674ef8c04743b4920f758158de1c9.webp"
"MediaSize" => 55162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-63b674ef8c04743b4920f758158de1c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:01.23Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6363556717"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/1be31454316e4c6ed39d64e6d467aa3f.webp"
"MediaSize" => 59433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-1be31454316e4c6ed39d64e6d467aa3f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:01.23Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6363556727"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/ca486c9266092f34c6b0ebba7ea42661.webp"
"MediaSize" => 69039
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-ca486c9266092f34c6b0ebba7ea42661.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:01.24Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6363556747"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/44ac32a9d9d36a63d172405222cab610.webp"
"MediaSize" => 37956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-44ac32a9d9d36a63d172405222cab610.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.64Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6363556767"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/429ccf8849c8fbd41b52e45ff9ab02a5.webp"
"MediaSize" => 25230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-429ccf8849c8fbd41b52e45ff9ab02a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Powder room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:01.23Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6363556828"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/fafc96d5736b16be76ba01f53fe9daaf.webp"
"MediaSize" => 101306
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-fafc96d5736b16be76ba01f53fe9daaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.64Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6363556843"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/0af85ec642bdf9066543889d7b0d68d9.webp"
"MediaSize" => 37377
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-0af85ec642bdf9066543889d7b0d68d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.64Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6363556861"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/fa35ccf8e18c1b1aa8564583eec97b54.webp"
"MediaSize" => 62330
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-fa35ccf8e18c1b1aa8564583eec97b54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.65Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6363556908"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/10556d0cdbb859d8b11ad478a6fc94be.webp"
"MediaSize" => 58919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-10556d0cdbb859d8b11ad478a6fc94be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.64Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6363556928"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/d91b1883c3fb619c31354102cb6df96c.webp"
"MediaSize" => 73306
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-d91b1883c3fb619c31354102cb6df96c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.64Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6363556944"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/b52d2893e658652cf10ad7a14823976d.webp"
"MediaSize" => 95645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-b52d2893e658652cf10ad7a14823976d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.63Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6363556956"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/180972759f75310f96913c39a1edcd0d.webp"
"MediaSize" => 81393
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-180972759f75310f96913c39a1edcd0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.64Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6363556974"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29177727/ceedc8559a3d0b6b0d867dcf414a4ee6.webp"
"MediaSize" => 45489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29177727/thumbnail-ceedc8559a3d0b6b0d867dcf414a4ee6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793297"
"ResourceRecordKey" => "29177727"
"ModificationTimestamp" => "2025-12-10T19:31:02.64Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "Gagan Battoo"
"MemberFirstName" => "Gagan"
"MemberLastName" => "Battoo"
"MemberMlsId" => "WR59840"
"OriginatingSystemName" => 26
"MemberKey" => "2218013"
"ModificationTimestamp" => "2025-12-11T01:31:05Z"
"MemberStatus" => "Active"
"OfficeKey" => "289539"
"MemberAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberFax" => "416-747-7135"
"MemberCity" => "CAMBRIDGE"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "204-951-4390"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2024-06-06T21:29:00Z"
"MemberNationalAssociationId" => "1463723"
"OfficeNationalAssociationId" => "1378643"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "HOMELIFE MIRACLE REALTY LTD."
"OfficePhone" => "416-747-9777"
"OfficeMlsId" => "CA721"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "289539"
"ModificationTimestamp" => "2025-08-19T15:49:32Z"
"OfficeAddress1" => "450 HESPELER ROAD, UNIT G/107-108"
"OfficeCity" => "CAMBRIDGE"
"OfficePostalCode" => "N1R0E"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"OfficeFax" => "416-747-7135"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OriginalEntryTimestamp" => "2021-02-10T19:07:00Z"
"OfficeNationalAssociationId" => "1378643"
"FranchiseNationalAssociationId" => "1230687"
"OfficeBrokerNationalAssociationId" => "1378645"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29177727')"
+"ID": "473825"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24834
+post_id: "466761"
+post_author: 1
+"ListingKey": "29166639"
+"ListingId": "40792630"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-05T18:50:28Z"
+"RFModificationTimestamp": "2025-12-05T19:18:31Z"
+"ListPrice": 650000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1120.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G8"
+"UnparsedAddress": "249 GREY SILO Road Unit# 202, Waterloo, Ontario N2K0G8"
+"Coordinates": array:2 [
0 => -80.4967199
1 => 43.5226913
]
+"Latitude": 43.5226913
+"Longitude": -80.4967199
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Prepare to fall in love with this rare corner condo where sophisticated design meets everyday indulgence with over 1100 sqft of living space. From the moment you step inside, you’re welcomed by wide hallways, 8.5 ft ceilings, and sunlight streaming through expansive windows. At the heart of the home, the chef’s kitchen commands attention with its dramatic quartzite island, custom drawers, soft-close cabinetry, and full suite of KitchenAid appliances. Subtle details—USB outlets, under-cabinet lighting, and dimmer switches—make the space as functional as it is beautiful. The living/dining area flows effortlessly to a spectacular 320 sq ft wrap-around balcony. Imagine sipping morning coffee with the sunrise, hosting dinner outdoors, or filling the space with lush container gardens—this balcony is a private oasis large enough for both lounging and entertaining. Retreat to the serene primary suite with double closets customized for style and storage, and a spa-inspired ensuite featuring a walk-in tiled shower with bench seating and sleek quartz vanity. The versatile second bedroom doubles perfectly as a guest room or home office, while the 4-piece main bath with a soaker tub offers a touch of everyday luxury. Added conveniences include in-suite laundry, engineered hardwood floors, built-in closet systems, and a smart thermostat. Life here extends far beyond your walls. Head to the rooftop terrace where panoramic views stretch over farmland and skyline. With fire tables glowing, BBQs sizzling, community gardens thriving, and stylish lounge spaces, it feels like a private resort in the heart of Waterloo. Add two parking spaces (one underground with locker, one at-grade near the entrance), plenty of visitor parking, and meticulous landscaping, and the package is complete. All this in the coveted Grey Silo community—steps to Rim Park, Grey Silo Golf Course, and endless trails, with shopping, dining, and universities just minutes away. This is condo living at its finest. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"AssociationFee": "555.81"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-05T19:18:07.773871+00:00"
+"Directions": "Old Park Drive to Grey Silo Road"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1565503"
+"ListOfficeKey": "283852"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2025-12-05T18:38:38Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-05T18:38:38Z"
+"Stories": "1.0"
+"StreetName": "GREY SILO"
+"StreetNumber": "249"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "4383.33"
+"VirtualTourURLUnbranded": "https://youriguide.com/202_249_grey_silo_rd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1545372898"
"RoomType" => "Laundry room"
"ListingId" => "40792630"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29166639"
"RoomLength" => null
"RoomDimensions" => "6'5'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-05T18:38:38.01Z"
]
1 => array:11 [
"RoomKey" => "1545372899"
"RoomType" => "Full bathroom"
"ListingId" => "40792630"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29166639"
"RoomLength" => null
"RoomDimensions" => "7'3'' x 7'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-05T18:38:38.01Z"
]
2 => array:11 [
"RoomKey" => "1545372900"
"RoomType" => "Primary Bedroom"
"ListingId" => "40792630"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29166639"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 15'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-05T18:38:38.01Z"
]
3 => array:11 [
"RoomKey" => "1545372901"
"RoomType" => "4pc Bathroom"
"ListingId" => "40792630"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29166639"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-05T18:38:38.01Z"
]
4 => array:11 [
"RoomKey" => "1545372902"
"RoomType" => "Bedroom"
"ListingId" => "40792630"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29166639"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-05T18:38:38.01Z"
]
5 => array:11 [
"RoomKey" => "1545372903"
"RoomType" => "Living room"
"ListingId" => "40792630"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29166639"
"RoomLength" => null
"RoomDimensions" => "7'3'' x 16'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-05T18:38:38.01Z"
]
6 => array:11 [
"RoomKey" => "1545372904"
"RoomType" => "Kitchen"
"ListingId" => "40792630"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29166639"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 16'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-05T18:38:38.01Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29166639/249-grey-silo-road-unit-202-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1565504"
+"CommonInterest": "Condo/Strata"
+"CoListAgentKey2": "1565502"
+"CoListOfficeKey": "86262"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "289848"
+"ZoningDescription": "R9"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1120
+"OriginalEntryTimestamp": "2025-12-05T18:38:37.78Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:27 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6357294660"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/2897a5e412ff6d116e8867413fdbb82f.webp"
"MediaSize" => 122302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-2897a5e412ff6d116e8867413fdbb82f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6357294661"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/130f940395c15b73285830153de2cc5a.webp"
"MediaSize" => 148009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-130f940395c15b73285830153de2cc5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6357294663"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/f2ad3023ff5383e0c77ea2952d45dfb3.webp"
"MediaSize" => 65260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-f2ad3023ff5383e0c77ea2952d45dfb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6357294664"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/68117b1d3ccdbfc74d06512f11f09128.webp"
"MediaSize" => 68533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-68117b1d3ccdbfc74d06512f11f09128.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6357294667"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/963f6d657e63585c899652345ec6ed73.webp"
"MediaSize" => 64253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-963f6d657e63585c899652345ec6ed73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6357294669"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/b4807bf186d7848978aef4a85625bed5.webp"
"MediaSize" => 65114
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-b4807bf186d7848978aef4a85625bed5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6357294673"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/88c5fdb1cb3868df666a2b7e0081755a.webp"
"MediaSize" => 57480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-88c5fdb1cb3868df666a2b7e0081755a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6357294676"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/1b44b1ef60fdab98aaefb35e8350933d.webp"
"MediaSize" => 64322
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-1b44b1ef60fdab98aaefb35e8350933d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6357294679"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/082ae0a4a757967f56dda09004aecedb.webp"
"MediaSize" => 67781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-082ae0a4a757967f56dda09004aecedb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6357294684"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/a2c245385362fd9f522225a40c4f24d4.webp"
"MediaSize" => 65304
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-a2c245385362fd9f522225a40c4f24d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6357294688"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/4655bcda766fdf7a720a3abafe98a21e.webp"
"MediaSize" => 57997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-4655bcda766fdf7a720a3abafe98a21e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6357294691"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/f0c2c3d792fe0cc54f426ddd3d95ce4d.webp"
"MediaSize" => 70879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-f0c2c3d792fe0cc54f426ddd3d95ce4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6357294695"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/f6994a845c00f2f97ec6085d88caffb0.webp"
"MediaSize" => 60438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-f6994a845c00f2f97ec6085d88caffb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6357294700"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/f3f03e483747f49c1d4342c893b2026d.webp"
"MediaSize" => 68970
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-f3f03e483747f49c1d4342c893b2026d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6357294703"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/583af262368be1bbd8f71ab39482f2e0.webp"
"MediaSize" => 81865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-583af262368be1bbd8f71ab39482f2e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6357294706"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/82629e67524b3999fbed496257e8e412.webp"
"MediaSize" => 85868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-82629e67524b3999fbed496257e8e412.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6357294710"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/7d1186fc2ef57d3c3eeef7a351ae5b6a.webp"
"MediaSize" => 104997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-7d1186fc2ef57d3c3eeef7a351ae5b6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792630"
"ResourceRecordKey" => "29166639"
"ModificationTimestamp" => "2025-12-05T18:38:37.79Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6357294714"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29166639/21659e0642260746dd3d4a85c355e4d4.webp"
"MediaSize" => 104398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29166639/thumbnail-21659e0642260746dd3d4a85c355e4d4.webp"
…7
]
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29166639')"
+"ID": "466761"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24763
+post_id: "467927"
+post_author: 1
+"ListingKey": "29100890"
+"ListingId": "40787685"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-13T20:45:18Z"
+"RFModificationTimestamp": "2025-11-17T10:40:02Z"
+"ListPrice": 6400000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 122.672
+"LivingArea": 2400.0
+"BuildingAreaTotal": 0
+"City": "West Montrose"
+"PostalCode": "N0B2V0"
+"UnparsedAddress": "1183 NORTHFIELD Drive E, West Montrose, Ontario N0B2V0"
+"Coordinates": array:2 [
0 => -80.5061459
1 => 43.5505618
]
+"Latitude": 43.5505618
+"Longitude": -80.5061459
+"YearBuilt": 1870
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover an extraordinary 122.4 acre farm estate nestled along the Grand River, offering a rare blend of agricultural opportunity, natural beauty, and limitless potential. Located just minutes from the City of Waterloo, this property provides the perfect balance: close to every amenity yet immersed in the peace, privacy, and serenity of the countryside. The land unfolds in breathtaking fashion, with approximately 118 workable acres of rich, productive soil currently used for a variety of crops including hay, corn, and produce. Rolling fields meet sweeping river vistas, with a pristine golf course across the river ensuring these one of a kind views remain protected for generations. Governed by the GRCA, the property’s natural character and scenic beauty are preserved and celebrated. Existing structures include a traditional two storey farmhouse with six bedrooms, multiple functional outbuildings, a barn with hayloft, machine shed with insulated shop, tie stalls, horse stalls and pens, and a chicken coop, all reflecting the charm and heritage of a true working farm. This exceptional offering invites endless possibilities. Whether you envision creating your dream estate or a multi family compound, the expansive landscape and location make it an ideal canvas. Its on farm diversified use zoning also opens the door to unique ventures such as ecotourism, agritourism, or a stunning event and wedding venue, all while maintaining the land’s agricultural purpose. A property of this scale and setting is a rare opportunity in Waterloo Region, a place where natural splendor, agricultural legacy, and future potential unite in perfect harmony. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2025-11-17T10:39:40.156423+00:00"
+"Directions": "Sawmill Rd to Northfield Dr E"
+"ExteriorFeatures": array:1 [
0 => "Other"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Natural gas"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2225830"
+"ListOfficeKey": "277572"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Country residential"
]
+"LotSizeDimensions": "122.672"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2025-11-13T20:39:11Z"
+"PhotosCount": 20
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-13T20:39:10Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "1183"
+"StreetSuffix": "Drive"
+"SubdivisionName": "553 - St Jacobs/Floradale/W.Montrose"
+"TaxAnnualAmount": "19075"
+"View": "River view"
+"WaterBodyName": "Grand River"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"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/29100890/1183-northfield-drive-e-west-montrose"
+"ParkingTotal": 12
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1750692"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "277572"
+"ZoningDescription": "A"
+"BedroomsAboveGrade": 6
+"BedroomsBelowGrade": 0
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"FrontageLengthNumeric": 2864.0
+"AboveGradeFinishedArea": 2400
+"OriginalEntryTimestamp": "2025-11-13T20:39:10.93Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29100890')"
+"ID": "467927"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24841
+post_id: "370086"
+post_author: 1
+"ListingKey": "29041881"
+"ListingId": "40782288"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-28T23:00:45Z"
+"RFModificationTimestamp": "2025-10-29T06:31:59Z"
+"ListPrice": 650000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1236.0
+"BuildingAreaTotal": 0
+"City": "Conestogo"
+"PostalCode": "N0B1N0"
+"UnparsedAddress": "999 NORTHFIELD Drive, Conestogo, Ontario N0B1N0"
+"Coordinates": array:2 [
0 => -80.51007683
1 => 43.54026216
]
+"Latitude": 43.54026216
+"Longitude": -80.51007683
+"YearBuilt": 1870
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Charming family home in the heart of Conestogo. Enjoy small-town living just 5 minutes from top city amenities. This updated character home features exposed beams on the main floor, a renovated bathroom, freshly painted main floor and an updated spacious kitchen with gas-stove and stainless steel appliances. The second floor offers two large bedrooms with ample natural light and room for the whole family. Situated on a spacious 86 x 200ft irregular lot, the property backs onto a community centre with tennis courts, ball diamond, playground and a ball hockey rink. The property offers ample parking, including a double driveway for 6+ cars and a detached workshop/garage with a drive-through door. An additional single driveway accommodates 2 more vehicles or allows for parking an RV/other machinery. Recent updates include a newer furnace and A/C (2018), an owned water softener (2019), gas line for a BBQ, gas stove (2022), fridge (2023), washer & dryer (2021). The fully fenced yard boasts a large deck with a gazebo, a large fire pit, 4 lilac trees, 2 cherry trees and a well established grape vine as well as beautifully landscaped gardens with plenty of room for a vegetable garden. Don’t miss out on this impressive home! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-10-29T06:31:51.894175+00:00"
+"Directions": "Sawmill Rd to Northfield Dr"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1930634"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2025-10-28T22:46:12Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-10-28T22:46:12Z"
+"Stories": "1.5"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "999"
+"StreetSuffix": "Drive"
+"SubdivisionName": "553 - St Jacobs/Floradale/W.Montrose"
+"TaxAnnualAmount": "4254"
+"VirtualTourURLUnbranded": "https://youriguide.com/fgmjd_999_northfield_dr_e_conestogo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
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]
]
+"ListAOR": "Cornerstone - Hamilton-Burlington"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29041881/999-northfield-drive-conestogo"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 86.0
+"AboveGradeFinishedArea": 1236
+"OriginalEntryTimestamp": "2025-10-28T22:46:12.1Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29041881')"
+"ID": "370086"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24727
+post_id: "369904"
+post_author: 1
+"ListingKey": "29042327"
+"ListingId": "X12486831"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-29T01:05:21Z"
+"RFModificationTimestamp": "2025-10-29T05:49:58Z"
+"ListPrice": 650000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Woolwich"
+"PostalCode": "N0B1N0"
+"UnparsedAddress": "999 NORTHFIELD DRIVE E, Woolwich, Ontario N0B1N0"
+"Coordinates": array:2 [
0 => -80.5102081
1 => 43.540226
]
+"Latitude": 43.540226
+"Longitude": -80.5102081
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Charming family home in the heart of Conestogo. Enjoy small-town living just 5 minutes from top city amenities. This updated character home features exposed beams on the main floor, a renovated bathroom, freshly painted main floor and an updated spacious kitchen with gas-stove and stainless steel appliances. The second floor offers two large bedrooms with ample natural light and room for the whole family. Situated on a spacious 86 x 200ft irregular lot, the property backs onto a community centre with tennis courts, ball diamond, playground and a ball hockey rink. The property offers ample parking, including a double driveway for 6+ cars and a detached workshop/garage with a drive-through door. An additional single driveway accommodates 2 more vehicles or allows for parking an RV/other machinery. Recent updates include a newer furnace and A/C (2018), an owned water softener (2019), gas line for a BBQ, gas stove (2022), fridge (2023), washer & dryer (2021). The fully fenced yard boasts a large deck with a gazebo, a large fire pit, 4 lilac trees, 2 cherry trees and a well established grape vine as well as beautifully landscaped gardens with plenty of room for a vegetable garden. Don't miss out on this impressive home! (id:62650)"
+"Appliances": array:1 [
0 => "Water softener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-10-29T05:49:43.644024+00:00"
+"Directions": "Cross Streets: Sawmill Road. ** Directions: Sawmill Rd to Northfield Dr."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2102918"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Flat site"
]
+"LotSizeDimensions": "86 x 204.8 FT ; 204.79 x 20.03 x 66.76 x 66.23 x 137.43"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-10-29T00:59:09Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-10-29T00:59:08Z"
+"Stories": "1.5"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "999"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4254"
+"VirtualTourURLUnbranded": "https://youriguide.com/fgmjd_999_northfield_dr_e_conestogo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29042327/999-northfield-drive-e-woolwich"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 86.0
+"OriginalEntryTimestamp": "2025-10-29T00:59:08.96Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29042327')"
+"ID": "369904"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24892
+post_id: "339417"
+post_author: 1
+"ListingKey": "29013805"
+"ListingId": "40779927"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-21T15:40:28Z"
+"RFModificationTimestamp": "2025-10-22T01:29:18Z"
+"ListPrice": 599999.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Woolwich"
+"PostalCode": "N0B1N0"
+"UnparsedAddress": "10 ELGIN Street E, Woolwich, Ontario N0B1N0"
+"Coordinates": array:2 [
0 => -80.502079
1 => 43.54020525
]
+"Latitude": 43.54020525
+"Longitude": -80.502079
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 10 Elgin Street, a rare opportunity to own vacant residential land in the heart of Conestogo Village. This approximately 0.5-acre lotoffers the perfect canvas to design and build the custom home you’ve always envisioned. Nestled in a peaceful, established neighbourhood andjust minutes to Waterloo, this property blends the tranquility of small-town living with the convenience of nearby city amenities. With maturetrees and a generous lot size, there's ample space for your ideal layout, garage, and even a backyard oasis. Half-acre lot, Build-ready residentialzoning, Minutes to Waterloo, St. Jacobs, and where the Grand River meets Conostogo River, Quiet street in a family-friendly community,overlooking the River Vally, Build your Dream Home Today! Don’t miss your chance to bring your vision to life in one of Waterloo Region’s mostdesirable communities. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2025-10-22T01:28:59.943595+00:00"
+"Directions": "Turn of of Sawmill onto glasgow of turn left on Elgin"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2106892"
+"ListOfficeKey": "294394"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Country residential"
]
+"PhotosChangeTimestamp": "2025-10-21T15:30:35Z"
+"PhotosCount": 4
+"Sewer": array:2 [
0 => "No sewage system"
1 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-10-21T15:30:35Z"
+"StreetDirSuffix": "East"
+"StreetName": "ELGIN"
+"StreetNumber": "10"
+"StreetSuffix": "Street"
+"SubdivisionName": "553 - St Jacobs/Floradale/W.Montrose"
+"TaxAnnualAmount": "2400"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone - Hamilton-Burlington"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29013805/10-elgin-street-e-woolwich"
+"CommonInterest": "Freehold"
+"ZoningDescription": "R1"
+"FrontageLengthNumeric": 107.0
+"OriginalEntryTimestamp": "2025-10-21T15:30:35.94Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"Media": array:4 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29013805')"
+"ID": "339417"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23526
+post_id: "339443"
+post_author: 1
+"ListingKey": "29015336"
+"ListingId": "X12474304"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-21T19:05:51Z"
+"RFModificationTimestamp": "2025-10-21T22:57:49Z"
+"ListPrice": 599999.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 16921.0
+"BuildingAreaTotal": 0
+"City": "Woolwich"
+"PostalCode": "N0B1N0"
+"UnparsedAddress": "10 ELGIN STREET, Woolwich, Ontario N0B1N0"
+"Coordinates": array:2 [
0 => -80.5016708
1 => 43.5402832
]
+"Latitude": 43.5402832
+"Longitude": -80.5016708
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": ". (id:62650)"
+"CreationDate": "2025-10-21T22:57:41.110796+00:00"
+"Directions": "Elgin St at end of street on Left"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2189767"
+"ListOfficeKey": "294429"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Irregular lot size"
]
+"LotSizeDimensions": "106.56 x 139.87 FT ; 135.53 x 106.56 x 139.87 x 143.51"
+"PhotosChangeTimestamp": "2025-10-21T18:58:52Z"
+"PhotosCount": 4
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-10-21T18:58:52Z"
+"StreetName": "Elgin"
+"StreetNumber": "10"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2400"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29015336/10-elgin-street-woolwich"
+"ZoningDescription": "R1"
+"FrontageLengthNumeric": 106.6
+"OriginalEntryTimestamp": "2025-10-21T18:58:52.32Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:4 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29015336')"
+"ID": "339443"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25160
+post_id: "283211"
+post_author: 1
+"ListingKey": "28951709"
+"ListingId": "X12444776"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-28T01:50:35Z"
+"RFModificationTimestamp": "2025-10-28T02:14:30Z"
+"ListPrice": 1559000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0E2"
+"UnparsedAddress": "537 MILLSTREAM DRIVE, Waterloo, Ontario N2K0E2"
+"Coordinates": array:2 [
0 => -80.4918671
1 => 43.5247993
]
+"Latitude": 43.5247993
+"Longitude": -80.4918671
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Carriage Crossing dream home! Prestigious neighborhoods, oversized corner lot w/ easy access to the park & walking trails, this stunning, custom-built luxury home is loaded w/ upgrades & designer finishes throughout. Offering over 4,500+ SF of beautifully finished living space & featuring 4+1 bdrms, & 4+1 baths, this home is truly one-of-a-kind. Main floor hrdwd & porcelain tile, designer lighting, pot lights, crown moulding & custom window treatments. Kitchen, is complete w/ large central island, premium appliances, quartz counters, & a generous breakfast area w/ walkout to the deck & backyard. A main-floor office with future potential to convert to a bedroom. Upstairs, the luxurious primary suite features custom millwork, two over-sized walk-in closets/dressing room w/ built-ins, & a spa-like ensuite w/ soaker tub, double vanity, & glass shower, another bedroom w/ 3pce ensuite, and 2 other bedrooms with a 5-pce Jack and Jill bath. The finished basement features a spacious rec rm, 1 bedroom w/ 3-pce bathroom. Covered deck, fenced back yard. Close to top-rated schools, area workplaces, universities, RIM Park, Grey Silo Golf Club, Walter Bean Trail, Farmers Market, & all popular amenities. Quick HWY access. You will fall in love w/ this spectacular home! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-10-04T07:40:33.460627+00:00"
+"Directions": "Cross Streets: Millennium Blvd. ** Directions: University Ave. E, Millennium Blvd."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1947988"
+"ListOfficeKey": "273707"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Sump Pump"
]
+"LotSizeDimensions": "23.5 x 186.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-10-04T04:46:11Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-10-28T01:46:37Z"
+"Stories": "2.0"
+"StreetName": "Millstream"
+"StreetNumber": "537"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "10487.24"
+"VirtualTourURLUnbranded": "https://www.winsold.com/tour/414959/branded/2234"
+"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/28951709/537-millstream-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 23.6
+"OriginalEntryTimestamp": "2025-10-04T04:46:11.61Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": []
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28951709')"
+"ID": "283211"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24822
+post_id: "281794"
+post_author: 1
+"ListingKey": "28951681"
+"ListingId": "40776409"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-04T04:26:01Z"
+"RFModificationTimestamp": "2025-10-04T05:21:55Z"
+"ListPrice": 1559000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.222
+"LivingArea": 2994.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0E2"
+"UnparsedAddress": "537 MILLSTREAM Drive, Waterloo, Ontario N2K0E2"
+"Coordinates": array:2 [
0 => -80.49181982
1 => 43.52484843
]
+"Latitude": 43.52484843
+"Longitude": -80.49181982
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Carriage Crossing dream home! Prestigious neighborhoods, oversized corner lot w/ easy access to the park & walking trails, this stunning, custom-built luxury home is loaded w/ upgrades & designer finishes throughout. Offering over 4,500+ SF of beautifully finished living space & featuring 4+1 bdrms, & 4+1 baths, this home is truly one-of-a-kind. Main floor hrdwd & porcelain tile, designer lighting, pot lights, crown moulding & custom window treatments. Kitchen, is complete w/ large central island, premium appliances, quartz counters, & a generous breakfast area w/ walkout to the deck & backyard. A main-floor office with future potential to convert to a bedroom. Upstairs, the luxurious primary suite features custom millwork, two over-sized walk-in closets/dressing room w/ built-ins, & a spa-like ensuite w/ soaker tub, double vanity, & glass shower, another bedroom w/ 3pce ensuite, and 2 other bedrooms with a 5-pce Jack and Jill bath. The finished basement features a spacious rec rm, 1 bedroom w/ 3-pce bathroom. Covered deck, fenced back yard. Close to top-rated schools, area workplaces, universities, RIM Park, Grey Silo Golf Club, Walter Bean Trail, Farmers Market, & all popular amenities. Quick HWY access. You will fall in love w/ this spectacular home! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "High Traffic Area"
2 => "Industrial Park"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-10-04T05:21:30.345344+00:00"
+"Directions": "University Ave. E to Millennium Blvd"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2169013"
+"ListOfficeKey": "292482"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Ravine"
1 => "Conservation/green belt"
2 => "Sump Pump"
]
+"LotSizeDimensions": "0.222"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-10-04T04:19:14Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-10-04T04:19:14Z"
+"Stories": "2.0"
+"StreetName": "MILLSTREAM"
+"StreetNumber": "537"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "10487.24"
+"VirtualTourURLUnbranded": "https://www.winsold.com/tour/414959/branded/2234"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone - Hamilton-Burlington"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/28951681/537-millstream-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 24.0
+"AboveGradeFinishedArea": 2994
+"OriginalEntryTimestamp": "2025-10-04T04:19:14.6Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28951681')"
+"ID": "281794"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 16
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
]