array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29178557/Property?$select=ALL&$top=20&$filter=ListingKey eq 29178557&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29178557/Property?$select=ALL&$top=20&$filter=ListingKey eq 29178557&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23596
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23598
+post_id: "474651"
+post_author: 1
+"ListingKey": "29178557"
+"ListingId": "40793205"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-11T17:10:31Z"
+"RFModificationTimestamp": "2025-12-11T17:12:05Z"
+"ListPrice": 880000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2079.0
+"BuildingAreaTotal": 0
+"City": "Haldimand County"
+"PostalCode": "N3W1E2"
+"UnparsedAddress": "369 HALLER Place, Haldimand County, Ontario N3W1E2"
+"Coordinates": array:2 [
0 => -79.939189
1 => 43.069569
]
+"Latitude": 43.069569
+"Longitude": -79.939189
+"YearBuilt": 1989
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located on a quiet court, this home offers excellent access to Hamilton, the International Airport, and the Amazon distribution centre. It is situated in a well-established, family-friendly community with over 2,000 homes developed in the past decade. The main floor features a spacious layout and a private backyard with no direct sightlines to neighbouring properties. Enjoy peaceful natural views from the sunroom. The finished basement offers brand-new carpet, a 3-piece bathroom, an exercise room, two additional bedrooms, and ample storage. This well-maintained property includes a 35-year roof, a high-efficiency furnace and air conditioner, and a central vacuum system. Additional features include four bay windows and four ceiling fans, enhancing comfort and energy efficiency year-round. Located on the north side of the Grand River, this home avoids traffic from the Argyle Bridge while providing convenient access to Hamilton and major highways. An excellent option for families seeking the local high school, McKinnon Park Secondary School. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-10T23:14:19.570806+00:00"
+"Directions": "From Hwy 54 (Cathness St. E) turn to Robert Gordon Dr., then turn to Haller Place"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1998909"
+"ListOfficeKey": "292968"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Skylight"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
4 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-10T22:59:44Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-11T17:08:57Z"
+"Stories": "2.0"
+"StreetName": "HALLER"
+"StreetNumber": "369"
+"StreetSuffix": "Place"
+"SubdivisionName": "631 - Caledonia North East"
+"TaxAnnualAmount": "5724.45"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:20 [
0 => array:11 [
"RoomKey" => "1547435743"
"RoomType" => "Utility room"
"ListingId" => "40793205"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29178557"
"RoomLength" => null
"RoomDimensions" => "12' x 12'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T17:08:57.39Z"
]
1 => array:11 [
"RoomKey" => "1547435744"
"RoomType" => "Recreation room"
"ListingId" => "40793205"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29178557"
"RoomLength" => null
"RoomDimensions" => "14' x 25'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T17:08:57.39Z"
]
2 => array:11 [
"RoomKey" => "1547435745"
"RoomType" => "Exercise room"
"ListingId" => "40793205"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29178557"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T17:08:57.39Z"
]
3 => array:11 [
"RoomKey" => "1547435746"
"RoomType" => "Bedroom"
"ListingId" => "40793205"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29178557"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T17:08:57.39Z"
]
4 => array:11 [
"RoomKey" => "1547435747"
"RoomType" => "3pc Bathroom"
"ListingId" => "40793205"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29178557"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 6'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T17:08:57.39Z"
]
5 => array:11 [
"RoomKey" => "1547435748"
"RoomType" => "Cold room"
"ListingId" => "40793205"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29178557"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 5'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T17:08:57.39Z"
]
6 => array:11 [
"RoomKey" => "1547435749"
"RoomType" => "Bedroom"
"ListingId" => "40793205"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29178557"
"RoomLength" => null
"RoomDimensions" => "7'1'' x 14'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T17:08:57.39Z"
]
7 => array:11 [
"RoomKey" => "1547435750"
"RoomType" => "4pc Bathroom"
"ListingId" => "40793205"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29178557"
"RoomLength" => null
"RoomDimensions" => "6' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T17:08:57.4Z"
]
8 => array:11 [
"RoomKey" => "1547435751"
"RoomType" => "Bedroom"
"ListingId" => "40793205"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29178557"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T17:08:57.4Z"
]
9 => array:11 [
"RoomKey" => "1547435752"
"RoomType" => "Bedroom"
"ListingId" => "40793205"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29178557"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T17:08:57.4Z"
]
10 => array:11 [
"RoomKey" => "1547435753"
"RoomType" => "3pc Bathroom"
"ListingId" => "40793205"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29178557"
"RoomLength" => null
"RoomDimensions" => "6'5'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T17:08:57.4Z"
]
11 => array:11 [
"RoomKey" => "1547435754"
"RoomType" => "Primary Bedroom"
"ListingId" => "40793205"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29178557"
"RoomLength" => null
"RoomDimensions" => "16'4'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T17:08:57.4Z"
]
12 => array:11 [
"RoomKey" => "1547435755"
"RoomType" => "2pc Bathroom"
"ListingId" => "40793205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29178557"
"RoomLength" => null
"RoomDimensions" => "6' x 4'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T17:08:57.4Z"
]
13 => array:11 [
"RoomKey" => "1547435756"
"RoomType" => "Laundry room"
"ListingId" => "40793205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29178557"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 8'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T17:08:57.4Z"
]
14 => array:11 [
"RoomKey" => "1547435757"
"RoomType" => "Family room"
"ListingId" => "40793205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29178557"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 19'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T17:08:57.4Z"
]
15 => array:11 [
"RoomKey" => "1547435758"
"RoomType" => "Sunroom"
"ListingId" => "40793205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29178557"
"RoomLength" => null
"RoomDimensions" => "12' x 16'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T17:08:57.4Z"
]
16 => array:11 [
"RoomKey" => "1547435759"
"RoomType" => "Kitchen"
"ListingId" => "40793205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29178557"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 19'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T17:08:57.4Z"
]
17 => array:11 [
"RoomKey" => "1547435760"
"RoomType" => "Dining room"
"ListingId" => "40793205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29178557"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T17:08:57.4Z"
]
18 => array:11 [
"RoomKey" => "1547435761"
"RoomType" => "Living room"
"ListingId" => "40793205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29178557"
"RoomLength" => null
"RoomDimensions" => "16'0'' x 16'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T17:08:57.4Z"
]
19 => array:11 [
"RoomKey" => "1547435762"
"RoomType" => "Foyer"
"ListingId" => "40793205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29178557"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T17:08:57.4Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29178557/369-haller-place-haldimand-county"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "H A7A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 79.0
+"AboveGradeFinishedArea": 2079
+"OriginalEntryTimestamp": "2025-12-10T22:38:16.73Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:36 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6363686435"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/889ae84699dcb79fe0850c8cd0273b07.webp"
"MediaSize" => 72686
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-889ae84699dcb79fe0850c8cd0273b07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:10.57Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6363686449"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/8b60e364c5e444eddb239cd26fb0c770.webp"
"MediaSize" => 166678
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-8b60e364c5e444eddb239cd26fb0c770.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:09.68Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6363686470"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/5d44b4b3f759222536cab0858142d3c8.webp"
"MediaSize" => 52953
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-5d44b4b3f759222536cab0858142d3c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:09.74Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6363686508"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/8ec97eaf72d3735f6c6522df089b6ba0.webp"
"MediaSize" => 66252
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-8ec97eaf72d3735f6c6522df089b6ba0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:09.65Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6363686533"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/196adabf20d37a6421654ed5f089fd4a.webp"
"MediaSize" => 64638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-196adabf20d37a6421654ed5f089fd4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:09.76Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6363686587"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/0392d81e4912647e171f32b56d2f2fa7.webp"
"MediaSize" => 58419
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-0392d81e4912647e171f32b56d2f2fa7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:09.77Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6363686607"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/b514765f7f942bb7c3370a62ac68c874.webp"
"MediaSize" => 67279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-b514765f7f942bb7c3370a62ac68c874.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:10.5Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6363686674"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/821383b9e286d3a83556db9c6b21aee5.webp"
"MediaSize" => 57046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-821383b9e286d3a83556db9c6b21aee5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:10.5Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6363686738"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/0f7d74d6b003c43f5a1b772624ed5d61.webp"
"MediaSize" => 60270
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-0f7d74d6b003c43f5a1b772624ed5d61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:10.5Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6363686793"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/f4400d721b0cec46cbb849707651b317.webp"
"MediaSize" => 58017
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-f4400d721b0cec46cbb849707651b317.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:10.5Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6363686876"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/e2f50d1eb6e9b5d0f35e90bd0c9d97f1.webp"
"MediaSize" => 59060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-e2f50d1eb6e9b5d0f35e90bd0c9d97f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:10.5Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6363686907"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/7715250faef03be4d49255341bf283f2.webp"
"MediaSize" => 52002
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-7715250faef03be4d49255341bf283f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:11.24Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6363686982"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/7f24ad87160c0f186cd7255582f24b77.webp"
"MediaSize" => 43312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-7f24ad87160c0f186cd7255582f24b77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:11.25Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6363687023"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/9b7fcbbd0b4efa550b1b90ffb43f8315.webp"
"MediaSize" => 35464
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-9b7fcbbd0b4efa550b1b90ffb43f8315.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:11.23Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6363687081"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/d510587a48bbbe315f1acb783ba82aaf.webp"
"MediaSize" => 34772
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-d510587a48bbbe315f1acb783ba82aaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:11.23Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6363687136"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/62f573304640c8bd4a5e516f3f0ba174.webp"
"MediaSize" => 47185
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-62f573304640c8bd4a5e516f3f0ba174.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:11.26Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6363687177"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/5fc2fc9c43980f8a58a29ebc6215aa1b.webp"
"MediaSize" => 56938
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-5fc2fc9c43980f8a58a29ebc6215aa1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:11.24Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6363687231"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/6bbb5511443fe330f78af9a47b4414b7.webp"
"MediaSize" => 46288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-6bbb5511443fe330f78af9a47b4414b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:11.23Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6363687286"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/531490d228e2ab33bcfd3303b735746d.webp"
"MediaSize" => 47295
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-531490d228e2ab33bcfd3303b735746d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:11.24Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6363687347"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/1ac3777f2641105c10ae1485b0291a30.webp"
"MediaSize" => 129948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-1ac3777f2641105c10ae1485b0291a30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:12.93Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6363687364"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/767cef9599e455897dd9054f6287047b.webp"
"MediaSize" => 62351
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-767cef9599e455897dd9054f6287047b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:11.23Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6363687380"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/a32ac6e49a47261e501c4090624a6c34.webp"
"MediaSize" => 53979
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-a32ac6e49a47261e501c4090624a6c34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:11.23Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6363687430"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/70e5ee9ff883bdd32a05be5cc7ba4fb3.webp"
"MediaSize" => 28429
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-70e5ee9ff883bdd32a05be5cc7ba4fb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:12.93Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6363687490"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/2c1888adbc3ba9e00d4154b13e5a638b.webp"
"MediaSize" => 48692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-2c1888adbc3ba9e00d4154b13e5a638b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:12.93Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6363687515"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/371223b1476d4eb509b1be623d9e6b20.webp"
"MediaSize" => 68980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-371223b1476d4eb509b1be623d9e6b20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:12.93Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6363687538"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/6675125940e469758d81ad97b38c8375.webp"
"MediaSize" => 40091
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-6675125940e469758d81ad97b38c8375.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:12.83Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6363687597"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/55e364a11d1d30489c37370c94e07b3b.webp"
"MediaSize" => 67968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-55e364a11d1d30489c37370c94e07b3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:12.83Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6363687636"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/b239598d636a18c74f9287c97905fe87.webp"
"MediaSize" => 114388
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-b239598d636a18c74f9287c97905fe87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:12.97Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6363687650"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/ec07ff4f6d4c2da46253a0e4862d9e0f.webp"
"MediaSize" => 122876
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-ec07ff4f6d4c2da46253a0e4862d9e0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:12.83Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6363687680"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/82b9c18c39bcc841f4dc9152fa8f1d33.webp"
"MediaSize" => 134637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-82b9c18c39bcc841f4dc9152fa8f1d33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:12.96Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6363687700"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/9a9bd86556abf5e046a946b574cf32b9.webp"
"MediaSize" => 55577
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-9a9bd86556abf5e046a946b574cf32b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:12.82Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6363687748"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/8df38c303c6401494431d908c02b2fce.webp"
"MediaSize" => 89745
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-8df38c303c6401494431d908c02b2fce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:12.84Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6363687773"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/22fb47cd7a50a0ece8f88bbee40812c3.webp"
"MediaSize" => 82924
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-22fb47cd7a50a0ece8f88bbee40812c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:12.84Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6363687786"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/71939504bea00250d4ebe0d73eda225c.webp"
"MediaSize" => 109700
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-71939504bea00250d4ebe0d73eda225c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:12.83Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6363687809"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/509e089fdd55066fc87089acfbf0b133.webp"
"MediaSize" => 73375
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-509e089fdd55066fc87089acfbf0b133.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:12.96Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6363687825"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29178557/a1316114a666731e71be4e0a68c1cb16.webp"
"MediaSize" => 76157
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29178557/thumbnail-a1316114a666731e71be4e0a68c1cb16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793205"
"ResourceRecordKey" => "29178557"
"ModificationTimestamp" => "2025-12-10T22:51:12.81Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "Shenli Bao"
"MemberFirstName" => "Shenli"
"MemberLastName" => "Bao"
"MemberMlsId" => "HBBAOSH"
"OriginatingSystemName" => 26
"MemberKey" => "1998909"
"ModificationTimestamp" => "2024-09-17T17:53:56Z"
"MemberStatus" => "Active"
"OfficeKey" => "292968"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberAOR" => "Hamilton-Burlington"
"MemberCity" => "Hamilton"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "647-867-5320"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2015-10-19T15:28:00Z"
"MemberNationalAssociationId" => "1303105"
"OfficeNationalAssociationId" => "1420220"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "1st Sunshine Realty Inc."
"OfficePhone" => "905-769-1039"
"OfficeMlsId" => "HB1STSUNSHIN"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "292968"
"ModificationTimestamp" => "2025-12-03T21:23:16Z"
"OfficeAddress1" => "914 Upper James St.Unit A"
"OfficeCity" => "Hamilton"
"OfficePostalCode" => "L9C3A"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2022-07-06T17:39:00Z"
"OfficeNationalAssociationId" => "1420220"
"OfficeBrokerNationalAssociationId" => "1420887"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29178557')"
+"ID": "474651"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 292968/Office?$select=ALL&$top=10&$filter=OfficeKey eq 292968&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 292968/Office?$select=ALL&$top=10&$filter=OfficeKey eq 292968&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25440
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25442
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "1st Sunshine Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-769-1039"
+"OfficeMlsId": "HB1STSUNSHIN"
+"ModificationTimestamp": "2025-12-03T21:23:16Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "292968"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "914 Upper James St.Unit A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Hamilton"
+"OfficePostalCode": "L9C3A"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1420220"
+"OriginalEntryTimestamp": "2022-07-06T17:39:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "452200"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "292968"
"SocialMediaUrlOrId" => "https://www.1stsunshinerealty.com/"
"ModificationTimestamp" => "2025-12-03T19:27:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1420887"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('292968')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1998909/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1998909&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1998909/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1998909&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25445
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29178557" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25033
+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 29178557/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29178557&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29178557/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29178557&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24902
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29178557 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.939189 43.069569)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29178557 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.939189 43.069569)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29178557 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.939189 43.069569)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29178557 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.939189 43.069569)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25294
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25285
+post_id: "471955"
+post_author: 1
+"ListingKey": "29175204"
+"ListingId": "X12613566"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-10T21:50:05Z"
+"RFModificationTimestamp": "2025-12-10T21:54:16Z"
+"ListPrice": 878000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Haldimand"
+"PostalCode": "N3W0E9"
+"UnparsedAddress": "72 MALCOLM CRESCENT, Haldimand, Ontario N3W0E9"
+"Coordinates": array:2 [
0 => -79.9282279
1 => 43.0753263
]
+"Latitude": 43.0753263
+"Longitude": -79.9282279
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Spacious detached home in Caledonia, nestled in a friendly, safe, and growing community. Offering approximately 2,800 Sqft of living space with 4 bedrooms and 3.5 bathrooms, this property features over $20,000 in upgrades! Highlights include hardwood floors throughout the main level, LED pot lights, 200-amp service, side entrance, electric vehicle rough-in, and a 3-piece rough-in in the basement. The open-concept layout is introduced by a double-door entry, leading to a large primary bedroom with a walk-in closet and a luxurious 5-piece ensuite. Built by Empire Homes, this residence also boasts a spacious family-sized backyard and is conveniently located near scenic trails, bike paths, top-rated schools, and major highways. (id:62650)"
+"Appliances": array:1 [
0 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Other, See Remarks"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-09T23:02:55.776708+00:00"
+"Directions": "Mcclung & Maclachlan Ave"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2038684"
+"ListOfficeKey": "290743"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "39.4 x 91.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-10T21:38:46Z"
+"PhotosCount": 11
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-10T21:38:46Z"
+"Stories": "2.0"
+"StreetName": "Malcolm"
+"StreetNumber": "72"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4100"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Haldimand"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29175204/72-malcolm-crescent-haldimand-haldimand"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 39.4
+"OriginalEntryTimestamp": "2025-12-09T20:45:49.08Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:11 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6363643919"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29175204/719bd4d4870f018797118837605e6f3c.webp"
"MediaSize" => 210158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29175204/thumbnail-719bd4d4870f018797118837605e6f3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12613566"
"ResourceRecordKey" => "29175204"
"ModificationTimestamp" => "2025-12-10T21:38:30.62Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6363643922"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29175204/432811b8a47f3d5eb9bfe5441da59d02.webp"
"MediaSize" => 112252
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29175204/thumbnail-432811b8a47f3d5eb9bfe5441da59d02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12613566"
"ResourceRecordKey" => "29175204"
"ModificationTimestamp" => "2025-12-10T21:38:44.46Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6363643927"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29175204/8823ca5c61aa4e854071ac21d4d52fd6.webp"
"MediaSize" => 102921
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29175204/thumbnail-8823ca5c61aa4e854071ac21d4d52fd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12613566"
"ResourceRecordKey" => "29175204"
"ModificationTimestamp" => "2025-12-10T21:38:45.64Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6363643934"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29175204/fc307fb2966b39b17e4791e8733dd6ac.webp"
"MediaSize" => 93476
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29175204/thumbnail-fc307fb2966b39b17e4791e8733dd6ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12613566"
"ResourceRecordKey" => "29175204"
"ModificationTimestamp" => "2025-12-10T21:38:46.36Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6363643939"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29175204/1468f390b3d210473339022b23afb0b0.webp"
"MediaSize" => 95428
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29175204/thumbnail-1468f390b3d210473339022b23afb0b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12613566"
"ResourceRecordKey" => "29175204"
"ModificationTimestamp" => "2025-12-10T21:38:21.38Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6363643947"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29175204/fd3d6a4ce65867b1179f261d57bb55e1.webp"
"MediaSize" => 104893
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29175204/thumbnail-fd3d6a4ce65867b1179f261d57bb55e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12613566"
"ResourceRecordKey" => "29175204"
"ModificationTimestamp" => "2025-12-10T21:38:25.68Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6363643951"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29175204/a1e511699e27de04e5d2fca66df97c18.webp"
"MediaSize" => 75911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29175204/thumbnail-a1e511699e27de04e5d2fca66df97c18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12613566"
"ResourceRecordKey" => "29175204"
"ModificationTimestamp" => "2025-12-10T21:38:30.66Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6363643956"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29175204/fd2b80b8d63ced6f0457c574df4a8dea.webp"
"MediaSize" => 99639
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29175204/thumbnail-fd2b80b8d63ced6f0457c574df4a8dea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12613566"
"ResourceRecordKey" => "29175204"
"ModificationTimestamp" => "2025-12-10T21:38:38.11Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6363643961"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29175204/36bb74e49eaad8486278268b7002b929.webp"
"MediaSize" => 92415
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29175204/thumbnail-36bb74e49eaad8486278268b7002b929.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12613566"
"ResourceRecordKey" => "29175204"
"ModificationTimestamp" => "2025-12-10T21:38:40.85Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6363643965"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29175204/b06af6a949f7e6c319650adbce2b2c60.webp"
"MediaSize" => 107579
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29175204/thumbnail-b06af6a949f7e6c319650adbce2b2c60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12613566"
"ResourceRecordKey" => "29175204"
"ModificationTimestamp" => "2025-12-10T21:38:37.56Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6363643969"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29175204/6cb8d6b6463c864d3377943a9b586762.webp"
"MediaSize" => 103157
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29175204/thumbnail-6cb8d6b6463c864d3377943a9b586762.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12613566"
"ResourceRecordKey" => "29175204"
"ModificationTimestamp" => "2025-12-10T21:38:42.51Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "FRANCESCO DE DOMINICIS"
"MemberFirstName" => "FRANCESCO"
"MemberLastName" => "DE DOMINICIS"
"MemberMlsId" => "9582097"
"OriginatingSystemName" => 26
"MemberKey" => "2038684"
"ModificationTimestamp" => "2025-08-13T17:59:32Z"
"MemberStatus" => "Active"
"OfficeKey" => "290743"
"MemberAOR" => "Toronto"
"Media" => array:1 [ …1]
"JobTitle" => "Broker"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-499-8800"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2017-08-02T00:24:00Z"
"MemberNationalAssociationId" => "1314861"
"OfficeNationalAssociationId" => "1390645"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "RE/MAX EXPERTS"
"OfficePhone" => "905-499-8800"
"OfficeMlsId" => "390100"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "290743"
"ModificationTimestamp" => "2025-10-15T22:01:34Z"
"OfficeAddress1" => "277 CITYVIEW BLVD UNIT 16"
"OfficeCity" => "VAUGHAN"
"OfficePostalCode" => "L4H5A"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Toronto"
"Media" => array:1 [ …1]
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2021-07-02T21:48:00Z"
"OfficeNationalAssociationId" => "1390645"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1056026"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29175204')"
+"ID": "471955"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25290
+post_id: "471071"
+post_author: 1
+"ListingKey": "29174158"
+"ListingId": "X12612614"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-10T01:30:24Z"
+"RFModificationTimestamp": "2025-12-10T01:32:55Z"
+"ListPrice": 779900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Haldimand"
+"PostalCode": "N3W0G6"
+"UnparsedAddress": "23 HAWICK CRESCENT, Haldimand, Ontario N3W0G6"
+"Coordinates": array:2 [
0 => -79.9317412
1 => 43.0778162
]
+"Latitude": 43.0778162
+"Longitude": -79.9317412
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this Beautiful Completely Upgraded 4 Bedroom Detach Home with Full Brick & Stone Finish Exterior Sitting on a Premium Lot With Depth of 127 ft Deep and located in the Quiet, Upcoming & Fast Growing Family Oriented Neighborhood of Caledonia. Nestled on a Quiet Street this Family Home displays Picture Perfect Living at Every Corner. As you Step Inside through the Front Double Door you will be Welcomed with the Beautiful Open concept Layout with 9ft Ceiling, Hardwood Floors and Abundant Natural Light. The Main Level Hardwood Floors Guide you through a Beautifully Designed Main Floor, with a Convenient 2 Piece Powder Room, a Separate Dining space, Large Living room. Further Ahead You will be Pleasantly Surprised with the an Expansive Eat-in Kitchen offering Tall Cabinetry with Abundant Counter Space and Huge Pantry. Sliding Glass Doors will lead you out to your Huge Backyard, Perfect for Outdoor gatherings, BBQ Parties. Coming Back Inside and Taking the Beautiful Hardwood Staircase Takes You to the Upper Level Where Beautiful Architectural Design With Functionality Continues. Starting With the Huge Primary Bedroom With Large Walk In Closet and Ensuite Washroom. And Down the Hall, You will Find the Other 3 Oversized Bedrooms and One More Full Bathroom. A Bonus Laundry Room for Added Functionality. The expansive unfinished basement, Offers Endless Potential for Customization or Future Income Opportunities. Beyond this Property Lines, This Home is minutes away from the Beautiful Grand River, Riverwalk Trails, Restaurants.15 Min Drive To Amazon Fulfilment Centre In Hamilton, 10 Minutes To Hamilton International Airport & Mohawk College For Aviation. 5 Minutes To Downtown Caledonia W/ Many Restaurants, Walmart, Shops, Gas, Groceries, & The Beautiful Grand River. 45 Min Drive To Oakville. Close To Highway !!!! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-09T19:05:14.215583+00:00"
+"Directions": "Whithorn Cres / Maclachlan Ave"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Brick Veneer"
]
+"FoundationDetails": array:2 [
0 => "Concrete"
1 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2067904"
+"ListOfficeKey": "285001"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "38.3 x 127 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-09T17:17:28Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-10T01:16:10Z"
+"Stories": "2.0"
+"StreetName": "Hawick"
+"StreetNumber": "23"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6298"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Haldimand"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29174158/23-hawick-crescent-haldimand-haldimand"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2020090"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "285001"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 38.3
+"OriginalEntryTimestamp": "2025-12-09T17:17:28.65Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:39 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6362865759"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174158/26dd4b1cac37076cc04c9918fae4b912.webp"
"MediaSize" => 136314
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174158/thumbnail-26dd4b1cac37076cc04c9918fae4b912.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12612614"
"ResourceRecordKey" => "29174158"
"ModificationTimestamp" => "2025-12-09T17:17:28.66Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6362865763"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174158/a1b240782b066c33f40e91384b5e37c0.webp"
"MediaSize" => 110663
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174158/thumbnail-a1b240782b066c33f40e91384b5e37c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612614"
"ResourceRecordKey" => "29174158"
"ModificationTimestamp" => "2025-12-09T17:17:28.66Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6362865766"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174158/22b410b5b3312c91183f34f246cbfcde.webp"
"MediaSize" => 86271
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174158/thumbnail-22b410b5b3312c91183f34f246cbfcde.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612614"
"ResourceRecordKey" => "29174158"
"ModificationTimestamp" => "2025-12-09T17:17:28.66Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6362865769"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174158/94b38584834c7666bcf445b2d8e69d30.webp"
"MediaSize" => 66111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174158/thumbnail-94b38584834c7666bcf445b2d8e69d30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612614"
"ResourceRecordKey" => "29174158"
"ModificationTimestamp" => "2025-12-09T17:17:28.66Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6362865772"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174158/12101663b47940c02091197581ed52af.webp"
"MediaSize" => 103321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174158/thumbnail-12101663b47940c02091197581ed52af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612614"
"ResourceRecordKey" => "29174158"
"ModificationTimestamp" => "2025-12-09T17:17:28.66Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6362865774"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174158/741265a88b37496b2b4038c726ec0664.webp"
"MediaSize" => 77500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174158/thumbnail-741265a88b37496b2b4038c726ec0664.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612614"
"ResourceRecordKey" => "29174158"
"ModificationTimestamp" => "2025-12-09T17:17:28.66Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6362865776"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174158/e5470c799a2516996094b78823f8f595.webp"
"MediaSize" => 98519
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174158/thumbnail-e5470c799a2516996094b78823f8f595.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612614"
"ResourceRecordKey" => "29174158"
"ModificationTimestamp" => "2025-12-09T17:17:28.66Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6362865778"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174158/694f7dcb24d2f86b9d907245672c16aa.webp"
"MediaSize" => 102417
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174158/thumbnail-694f7dcb24d2f86b9d907245672c16aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612614"
"ResourceRecordKey" => "29174158"
"ModificationTimestamp" => "2025-12-09T17:17:28.66Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6362865780"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174158/abb5d83db7aef78094c66d227aeb1e78.webp"
"MediaSize" => 61755
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174158/thumbnail-abb5d83db7aef78094c66d227aeb1e78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612614"
"ResourceRecordKey" => "29174158"
"ModificationTimestamp" => "2025-12-09T17:17:28.66Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6362865782"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174158/ee44a06b219913313aa634a6568dce5f.webp"
"MediaSize" => 74625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174158/thumbnail-ee44a06b219913313aa634a6568dce5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12612614"
"ResourceRecordKey" => "29174158"
"ModificationTimestamp" => "2025-12-09T17:17:28.66Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6362865784"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174158/fa502e24e72125dcfc108615be7b4a7b.webp"
"MediaSize" => 58763
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174158/thumbnail-fa502e24e72125dcfc108615be7b4a7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
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]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29174158')"
+"ID": "471071"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24925
+post_id: "466400"
+post_author: 1
+"ListingKey": "29103315"
+"ListingId": "X12544382"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-05T22:55:36Z"
+"RFModificationTimestamp": "2025-12-06T01:14:21Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Haldimand"
+"PostalCode": "N3W1B7"
+"UnparsedAddress": "5 - 6 CAITHNESS STREET E, Haldimand, Ontario N3W1B7"
+"Coordinates": array:2 [
0 => -79.951496
1 => 43.073653
]
+"Latitude": 43.073653
+"Longitude": -79.951496
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Step into modern living in this brand-new, never-lived-in 1-bedroom apartment located at 6 Caithness St., Unit 5, Caledonia. Thoughtfully designed with approximately 600 sq. ft. of bright, contemporary space, this suite features 9-10 ft ceilings with recessed lighting, soundproof insulation, and oversized windows that fill the home with natural light. The spacious bedroom includes a walk-in closet, while the stylish bathroom offers quartz counters, a walk-in tiled shower with glass sliding door, and a built-in niche. Enjoy an open-concept kitchen complete with quartz countertops, a large tile backsplash, and a full suite of brand-new stainless steel appliances, plus the convenience of an in-suite washer and dryer. Finished with modern vinyl flooring throughout and 1 included parking spot, this private and quiet unit is perfect for professionals or couples seeking upscale living. Utilities are a flat-rate of $120/month, offering excellent value and predictable expenses-just move in and enjoy. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-06T01:14:14.353441+00:00"
+"Directions": "Cross Streets: Argyle St N. ** Directions: In between Argyle St N and Edinburgh Sq."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2108302"
+"ListOfficeKey": "290358"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"LotSizeDimensions": "31 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-05T22:44:50Z"
+"PhotosCount": 6
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-05T22:51:00Z"
+"StreetDirSuffix": "East"
+"StreetName": "Caithness"
+"StreetNumber": "6"
+"StreetSuffix": "Street"
+"ListAOR": "Toronto"
+"CityRegion": "Haldimand"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29103315/5-6-caithness-street-e-haldimand-haldimand"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Other"
]
+"GeocodeManualYN": false
+"TotalActualRent": 1799
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 0
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 31.0
+"OriginalEntryTimestamp": "2025-11-14T16:04:05.77Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:6 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:4 [ …4]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29103315')"
+"ID": "466400"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25291
+post_id: "466562"
+post_author: 1
+"ListingKey": "29166758"
+"ListingId": "40792635"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-05T19:30:22Z"
+"RFModificationTimestamp": "2025-12-06T00:12:20Z"
+"ListPrice": 659900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1102.0
+"BuildingAreaTotal": 0
+"City": "Caledonia"
+"PostalCode": "N3W1K1"
+"UnparsedAddress": "120 KINROSS Street, Caledonia, Ontario N3W1K1"
+"Coordinates": array:2 [
0 => -79.960725
1 => 43.0663658
]
+"Latitude": 43.0663658
+"Longitude": -79.960725
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome home to this impeccably cared-for elevated bungalow, where comfort and thoughtful updates come together beautifully. The renovated kitchen boasts plenty of cabinetry, a functional island for meal prep or gathering, and polished granite countertops. It opens seamlessly to a bright, airy living room featuring hardwood floors and updated main-floor windows that fill the space with natural light. The main level offers three spacious bedrooms, all with hardwood flooring, and a modern, well-designed 4-piece bathroom. Downstairs, you’ll find a welcoming family room with a cozy gas fireplace—perfect for relaxing evenings. A versatile bonus area provides options for a playroom, craft space, or home gym, alongside a fourth bedroom and a convenient laundry room. Outside, enjoy a fully fenced, private backyard complete with a patio and storage shed—ideal for outdoor dining or weekend unwinding. Move-in ready and full of charm, this home delivers the space, style, and ease you’ve been looking for—perfect for first-time buyers, families, or those looking to downsize comfortably. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-06T00:12:10.114050+00:00"
+"Directions": "FROM HWY 6, TURN EAST ONTO ARGYLE STREET SOUTH, WEST ONTO KINROSS STREET"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524924"
+"ListOfficeKey": "54969"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Southern exposure"
]
+"PhotosChangeTimestamp": "2025-12-05T19:01:21Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-05T19:20:10Z"
+"Stories": "1.0"
+"StreetName": "KINROSS"
+"StreetNumber": "120"
+"StreetSuffix": "Street"
+"SubdivisionName": "632 - Caledonia South West"
+"TaxAnnualAmount": "3793.64"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/360134"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29166758/120-kinross-street-caledonia"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2013295"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "54969"
+"GeocodeManualYN": true
+"ZoningDescription": "H A7B"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 47.0
+"AboveGradeFinishedArea": 1102
+"OriginalEntryTimestamp": "2025-12-05T19:01:21.52Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:33 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29166758')"
+"ID": "466562"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25289
+post_id: "466563"
+post_author: 1
+"ListingKey": "29166970"
+"ListingId": "X12605506"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-05T20:05:24Z"
+"RFModificationTimestamp": "2025-12-05T23:52:59Z"
+"ListPrice": 659900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Haldimand"
+"PostalCode": "N3W1K1"
+"UnparsedAddress": "120 KINROSS STREET, Haldimand, Ontario N3W1K1"
+"Coordinates": array:2 [
0 => -79.9625168
1 => 43.0666847
]
+"Latitude": 43.0666847
+"Longitude": -79.9625168
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome home to this impeccably cared-for elevated bungalow, where comfort and thoughtful updates come together beautifully. The renovated kitchen boasts plenty of cabinetry, a functional island for meal prep or gathering, and polished granite countertops. It opens seamlessly to a bright, airy living room featuring hardwood floors and updated main-floor windows that fill the space with natural light.The main level offers three spacious bedrooms, all with hardwood flooring, and a modern, well-designed 4-piece bathroom. Downstairs, you'll find a welcoming family room with a cozy gas fireplace-perfect for relaxing evenings. A versatile bonus area provides options for a playroom, craft space, or home gym, alongside a fourth bedroom and a convenient laundry room.Outside, enjoy a fully fenced, private backyard complete with a patio and storage shed-ideal for outdoor dining or weekend unwinding.Move-in ready and full of charm, this home delivers the space, style, and ease you've been looking for-perfect for first-time buyers, families, or those looking to downsize comfortably. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-05T23:52:02.011418+00:00"
+"Directions": "Cross Streets: Argyle Street South. ** Directions: FROM HWY 6, TURN EAST ONTO ARGYLE STREET SOUTH, WEST ONTO KINROSS STREET."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2059982"
+"ListOfficeKey": "62725"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Irregular lot size"
]
+"LotSizeDimensions": "47.2 x 173 FT ; SW corner truncated E lotline shorter W"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-05T19:51:00Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-05T19:50:59Z"
+"Stories": "1.0"
+"StreetName": "Kinross"
+"StreetNumber": "120"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3793.64"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/360134"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2024
+"CityRegion": "Haldimand"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29166970/120-kinross-street-haldimand-haldimand"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "H A7B"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 47.2
+"OriginalEntryTimestamp": "2025-12-05T19:50:59.62Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:33 [
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]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": []
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29166970')"
+"ID": "466563"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25304
+post_id: "466401"
+post_author: 1
+"ListingKey": "29166641"
+"ListingId": "40792615"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-11T18:26:17Z"
+"RFModificationTimestamp": "2025-12-11T18:28:44Z"
+"ListPrice": 750000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1115.0
+"BuildingAreaTotal": 0
+"City": "Caledonia"
+"PostalCode": "N3W1B2"
+"UnparsedAddress": "80 CAITHNESS Street W Unit# 404, Caledonia, Ontario N3W1B2"
+"Coordinates": array:2 [
0 => -79.9547967
1 => 43.0746157
]
+"Latitude": 43.0746157
+"Longitude": -79.9547967
+"YearBuilt": 2026
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience luxury living at The Grandview, Caledonia’s newest upscale residence. The Caithness model boasts 1,115 square feet and exceptional views of the Grand River. This expansive unit features two bedrooms and two bathrooms, offering high-end finishes such as a custom Winger kitchen with quartz countertops and backsplash, quartz surrounds in both the tub and shower, six appliances, premium window treatments, nine-foot ceilings, six-inch baseboards, a dedicated parking spot with an option for an additional space, and elegant 7.5-inch luxury vinyl plank flooring. Condo fees cover heat, water, sewer, building and grounds upkeep, and insurance. Ideally located, The Grandview is within walking distance of parks, shops, restaurants, and churches. Situated on the southern bank of the river, this location offers convenient access to major highways. Call today to secure your choice of unit. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Microwave"
5 => "Microwave Built-in"
]
+"AssociationFee": "1"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Heat"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-05T19:17:44.266466+00:00"
+"Directions": "Argyle St n to West on Caithness St"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Other"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525299"
+"ListOfficeKey": "54949"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2025-12-11T17:59:50Z"
+"PhotosCount": 4
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-11T17:59:50Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "CAITHNESS"
+"StreetNumber": "80"
+"StreetSuffix": "Street"
+"SubdivisionName": "630 - Caledonia North West"
+"TaxAnnualAmount": "1"
+"View": "River view"
+"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"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29166641/80-caithness-street-w-unit-404-caledonia"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1829489"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "55026"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1115
+"OriginalEntryTimestamp": "2025-12-05T18:38:38.44Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"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:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29166641')"
+"ID": "466401"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23610
+post_id: "465709"
+post_author: 1
+"ListingKey": "29166562"
+"ListingId": "X12604996"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-05T19:10:22Z"
+"RFModificationTimestamp": "2025-12-05T19:25:06Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Haldimand"
+"PostalCode": "N3W0C2"
+"UnparsedAddress": "27 SUMAC DRIVE, Haldimand, Ontario N3W0C2"
+"Coordinates": array:2 [
0 => -79.9344585
1 => 43.0728022
]
+"Latitude": 43.0728022
+"Longitude": -79.9344585
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning 4 Br, 2.5 Bath Home In Empire's Master Planned Community - Avalon. Double Door Entry Leads To A Spacious, freshly painted, and professionally cleaned. This Home Is 1890 Sq Ft As Per MPAC. 9 Ft Ceilings, On Main, Garage Man Door, Glass Shower In Master, Water & Gas Line For Fridge & Stove In Kitchen . Close To Schools, Shopping, & Steps to the Grand River & trails, SIDE WALK. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-05T18:50:24.285998+00:00"
+"Directions": "Cross Streets: Mcclung Rd/Arnold Marshall. ** Directions: Caledonia."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:3 [
0 => "Carpeted"
1 => "Vinyl"
2 => "Porcelain Tile"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1876486"
+"ListOfficeKey": "300336"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Sump Pump"
]
+"LotSizeDimensions": "26.9 x 91.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-05T18:24:07Z"
+"PhotosCount": 2
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-05T18:50:54Z"
+"Stories": "2.0"
+"StreetName": "Sumac"
+"StreetNumber": "27"
+"StreetSuffix": "Drive"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"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"
+"CityRegion": "Haldimand"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29166562/27-sumac-drive-haldimand-haldimand"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2700
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 26.1
+"OriginalEntryTimestamp": "2025-12-05T18:24:07.08Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:2 [
0 => array:13 [ …13]
1 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:19 [ …19]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29166562')"
+"ID": "465709"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25292
+post_id: "463411"
+post_author: 1
+"ListingKey": "29161621"
+"ListingId": "40792183"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-04T16:15:48Z"
+"RFModificationTimestamp": "2025-12-04T20:37:36Z"
+"ListPrice": 629900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.04
+"LivingArea": 1580.0
+"BuildingAreaTotal": 0
+"City": "Caledonia"
+"PostalCode": "N3W0B8"
+"UnparsedAddress": "105 THOMPSON Road, Caledonia, Ontario N3W0B8"
+"Coordinates": array:2 [
0 => -79.9308846
1 => 43.0725461
]
+"Latitude": 43.0725461
+"Longitude": -79.9308846
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this fabulous open concept freehold townhome nestled in the highly desirable and family-friendly Avalon community of Caledonia! This home is bright and spacious and perfect for modern living and entertaining! Enjoy cooking and gathering in the fabulous kitchen, complete with large island and cozy dining area that flows seamlessly into the generous family room, ideal for families with small children, hosting friends or family gatherings. Step outside to a fully fenced backyard, perfect for kids, pets, or summer BBQs. The upper level offers 3 good-sized bedrooms, including a lovely primary suite with a private 3-piece ensuite and convenient upper-level laundry! Lower level has been partially finished, additional 2-piece bath and lots of storage! Additional features include a private driveway, single car garage, easy inside entry and extra street parking across the road. All conveniently located in an incredible, family-friendly community close to schools, parks, and all amenities! Easy commute to Hamilton and 403. Call today to experience all that Caledonia living has to offer! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-04T20:37:18.695796+00:00"
+"Directions": "McClung Road To Thompson Road"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1523905"
+"ListOfficeKey": "277164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.04"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-04T14:29:26Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-04T16:00:34Z"
+"Stories": "2.0"
+"StreetName": "THOMPSON"
+"StreetNumber": "105"
+"StreetSuffix": "Road"
+"SubdivisionName": "631 - Caledonia North East"
+"TaxAnnualAmount": "4242.35"
+"VirtualTourURLUnbranded": "https://youriguide.com/105_thompson_rd_caledonia_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29161621/105-thompson-road-caledonia"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1580
+"OriginalEntryTimestamp": "2025-12-04T14:29:26Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"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:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29161621')"
+"ID": "463411"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25293
+post_id: "461741"
+post_author: 1
+"ListingKey": "29159639"
+"ListingId": "40791983"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-08T20:41:01Z"
+"RFModificationTimestamp": "2025-12-08T20:43:37Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 800.0
+"BuildingAreaTotal": 0
+"City": "Caledonia"
+"PostalCode": "N3W1B7"
+"UnparsedAddress": "6 CAITHNESS Street E Unit# 2, Caledonia, Ontario N3W1B7"
+"Coordinates": array:2 [
0 => -79.9515821
1 => 43.0739787
]
+"Latitude": 43.0739787
+"Longitude": -79.9515821
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright & spacious, beautifully refreshed 2-bedroom, 1-bath apartment for lease in the heart of Caledonia! Welcome to 6 Caithness St E, Unit 2—an approx. 800 sq ft updated unit featuring brand new flooring, fresh paint throughout, new lighting, and new appliances, all complemented by a functional open-concept layout and a private balcony for everyday enjoyment. Enjoy plenty of natural light, a practical kitchen, and well-sized bedrooms in a quiet, well-kept, family-friendly neighbourhood just minutes to Caledonia’s charming downtown core, the Grand River, scenic trails, parks, schools, grocery stores, restaurants, and daily amenities, with convenient access to Hwy 6 for easy commuting to Hamilton, Brantford, and beyond. Rent is $1,899/month + hydro; parking available for $50/month. Available now. SingleKey application required—apply today! (id:62650)"
+"Appliances": array:2 [
0 => "Refrigerator"
1 => "Stove"
]
+"AssociationFeeIncludes": array:1 [
0 => "Property Management"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-03T23:41:03.041077+00:00"
+"Directions": "In between Argyle St N and Edinburgh Sq."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2155281"
+"ListOfficeKey": "292003"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2025-12-03T19:29:20Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-08T20:30:07Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "CAITHNESS"
+"StreetNumber": "6"
+"StreetSuffix": "Street"
+"SubdivisionName": "631 - Caledonia North East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29159639/6-caithness-street-e-unit-2-caledonia"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1899
+"ZoningDescription": "H A7A"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 31.0
+"AboveGradeFinishedArea": 800
+"OriginalEntryTimestamp": "2025-12-03T19:29:20.33Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"Media": array:22 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29159639')"
+"ID": "461741"
}
]
+success: true
+page_size: 9
+page_count: 11
+count: 96
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
]