array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30038075 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23509
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23511
+post_id: "1637137"
+post_author: 1
+"ListingKey": "30038075"
+"ListingId": "40848574"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:10:10Z"
+"RFModificationTimestamp": "2026-07-17T21:11:03Z"
+"ListPrice": 749000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1898.0
+"BuildingAreaTotal": 0
+"City": "Caledonia"
+"PostalCode": "N3W0H5"
+"UnparsedAddress": "78 LILAC Circle, Caledonia, Ontario N3W0H5"
+"Coordinates": array:2 [
0 => -79.9230619
1 => 43.0686652
]
+"Latitude": 43.0686652
+"Longitude": -79.9230619
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
+"PublicRemarks": "This is your opportunity to invest in a newer detached 4 bedroom home in the new Avalon developments in the heart of Caledonia. Whether you're looking for your next investment or a growing family, you have to see this one. A beautiful open-concept layout, 4 generous sized bedrooms, a spacious basement ready for development and located right next to beautiful trails. Caledonia brings all kinds of charm and small town character. From the loved Caledonia Fair, the annual town wide garage sale, the chilli cook-off, Canada Day and Santa Claus Parades, the beautiful Grand River and so much more - this town has it all! Located just minutes from all major amenities, 15 minutes to Hamilton and major highways. Some photos have been virtually staged. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T21:10:48.611353+00:00"
+"Directions": "McClung Rd to Lilac Circle"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2095157"
+"ListOfficeKey": "294897"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T20:13:32Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:03:41Z"
+"Stories": "2.0"
+"StreetName": "LILAC"
+"StreetNumber": "78"
+"StreetSuffix": "Circle"
+"SubdivisionName": "064 - Seneca"
+"TaxAnnualAmount": "5398.11"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/zpF5274GkhY?feature=share"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1686988235"
"RoomType" => "4pc Bathroom"
"ListingId" => "40848574"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30038075"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:03:41.82Z"
]
1 => array:11 [
"RoomKey" => "1686988236"
"RoomType" => "Bedroom"
"ListingId" => "40848574"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30038075"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:03:41.82Z"
]
2 => array:11 [
"RoomKey" => "1686988237"
"RoomType" => "3pc Bathroom"
"ListingId" => "40848574"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30038075"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:03:41.82Z"
]
3 => array:11 [
"RoomKey" => "1686988238"
"RoomType" => "Primary Bedroom"
"ListingId" => "40848574"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30038075"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 14'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:03:41.82Z"
]
4 => array:11 [
"RoomKey" => "1686988239"
"RoomType" => "Bedroom"
"ListingId" => "40848574"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30038075"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:03:41.82Z"
]
5 => array:11 [
"RoomKey" => "1686988240"
"RoomType" => "Bedroom"
"ListingId" => "40848574"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30038075"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:03:41.82Z"
]
6 => array:11 [
"RoomKey" => "1686988241"
"RoomType" => "2pc Bathroom"
"ListingId" => "40848574"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30038075"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:03:41.82Z"
]
7 => array:11 [
"RoomKey" => "1686988242"
"RoomType" => "Living room"
"ListingId" => "40848574"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30038075"
"RoomLength" => null
"RoomDimensions" => "16'6'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:03:41.82Z"
]
8 => array:11 [
"RoomKey" => "1686988243"
"RoomType" => "Kitchen"
"ListingId" => "40848574"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30038075"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 12'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:03:41.82Z"
]
]
+"ListAOR": "Brantford"
+"ListAORKey": "41"
+"ListingURL": "www.realtor.ca/real-estate/30038075/78-lilac-circle-caledonia"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-B"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 33.0
+"AboveGradeFinishedArea": 1898
+"OriginalEntryTimestamp": "2026-07-15T19:53:47.31Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1367348"
+"ListOfficeNationalAssociationId": "1443398"
+"Media": array:30 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30038075_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/4df4230e4dbd69b1d0c3e000cbe9ff7f.webp"
"MediaSize" => 107941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-4df4230e4dbd69b1d0c3e000cbe9ff7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:43.5Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30038075_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/0e4958ad2a853f9f3d295d343bf6769d.webp"
"MediaSize" => 103333
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-0e4958ad2a853f9f3d295d343bf6769d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:44.38Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30038075_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/daa2858f5653bb82bf3b1ee27301786d.webp"
"MediaSize" => 151268
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-daa2858f5653bb82bf3b1ee27301786d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:45.19Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30038075_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/d8148901d1ebb543773a0a2724cbbb3c.webp"
"MediaSize" => 127942
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-d8148901d1ebb543773a0a2724cbbb3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:47.27Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30038075_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/1981dba164c886aabb451f136e15b6c0.webp"
"MediaSize" => 63771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-1981dba164c886aabb451f136e15b6c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:45.16Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30038075_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/036c6f7a3f9cc10478c9fbfa329ecf32.webp"
"MediaSize" => 64034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-036c6f7a3f9cc10478c9fbfa329ecf32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:44.42Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30038075_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/33d47650a2f0549daf5d3b562bef388a.webp"
"MediaSize" => 34421
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-33d47650a2f0549daf5d3b562bef388a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:44.4Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30038075_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/b514c36906b6b7ccb9070f2f7ef98f49.webp"
"MediaSize" => 56838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-b514c36906b6b7ccb9070f2f7ef98f49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:44.42Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30038075_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/593ebb99faf1b1c2485c187bffc5a936.webp"
"MediaSize" => 72187
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-593ebb99faf1b1c2485c187bffc5a936.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:44.39Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30038075_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/d980237057aa60e92686227e655fa307.webp"
"MediaSize" => 46172
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-d980237057aa60e92686227e655fa307.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:44.42Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30038075_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/9703d5f2aa2ab5063bd206da15ae5b03.webp"
"MediaSize" => 63615
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-9703d5f2aa2ab5063bd206da15ae5b03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:44.35Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30038075_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/9512d305cb13092b004aa73d8d664ded.webp"
"MediaSize" => 72038
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-9512d305cb13092b004aa73d8d664ded.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:44.35Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30038075_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/e5fb81dd81517a40e300a5196b54aad9.webp"
"MediaSize" => 56874
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-e5fb81dd81517a40e300a5196b54aad9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:44.38Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30038075_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/1092e4b4119893ebcf6ceeecd924b9c5.webp"
"MediaSize" => 62609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-1092e4b4119893ebcf6ceeecd924b9c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:44.73Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30038075_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/78213034e2e6e2dd952930d8b257d982.webp"
"MediaSize" => 57646
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-78213034e2e6e2dd952930d8b257d982.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:44.84Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30038075_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/a2eaae4cfd55e09ae2858ac012cc3bba.webp"
"MediaSize" => 62900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-a2eaae4cfd55e09ae2858ac012cc3bba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:45.67Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30038075_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/7906653cb51bd4659a4d7b587e251f8c.webp"
"MediaSize" => 44477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-7906653cb51bd4659a4d7b587e251f8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:44.43Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30038075_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/83d3d27b343209432d122784537eaed4.webp"
"MediaSize" => 49452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-83d3d27b343209432d122784537eaed4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:44.69Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30038075_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/1292b76adc07dd386c9a19f87cd9e28f.webp"
"MediaSize" => 49545
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-1292b76adc07dd386c9a19f87cd9e28f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:45.17Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30038075_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/e65ebf58c7fb5032440297ffac154d14.webp"
"MediaSize" => 47048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-e65ebf58c7fb5032440297ffac154d14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:44.84Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30038075_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/8a8c0c1479c7b0421ea72f9aa2bf1a9d.webp"
"MediaSize" => 50166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-8a8c0c1479c7b0421ea72f9aa2bf1a9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:44.65Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30038075_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/c70efab6f00f786b239185b522914d56.webp"
"MediaSize" => 29499
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-c70efab6f00f786b239185b522914d56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:44.38Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30038075_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/2589ea48fcb81fab846a4f34a1d85104.webp"
"MediaSize" => 65902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-2589ea48fcb81fab846a4f34a1d85104.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:45.15Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30038075_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/f216acd5130600846122bdbdf4455f04.webp"
"MediaSize" => 55091
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-f216acd5130600846122bdbdf4455f04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:44.85Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30038075_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/a94e40e6ed51508519f839c4ad36137d.webp"
"MediaSize" => 43964
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-a94e40e6ed51508519f839c4ad36137d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:44.84Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30038075_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/4ef622a097a4d58b7e2a4733b89c9d86.webp"
"MediaSize" => 40235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-4ef622a097a4d58b7e2a4733b89c9d86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:47.66Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30038075_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/852feb3e28fdfbc1ac613a9b1d67eb6f.webp"
"MediaSize" => 42616
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-852feb3e28fdfbc1ac613a9b1d67eb6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:44.83Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30038075_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/dbe2328e7ec0ce1d6c0e1b32c88b913c.webp"
"MediaSize" => 132869
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-dbe2328e7ec0ce1d6c0e1b32c88b913c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:51.31Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30038075_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/14c48be1356e8ea0169bf971aaffca25.webp"
"MediaSize" => 165294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-14c48be1356e8ea0169bf971aaffca25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:44.97Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30038075_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038075/015d5627b8e08ed8c5199cc6392f1bf7.webp"
"MediaSize" => 148925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038075/thumbnail-015d5627b8e08ed8c5199cc6392f1bf7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848574"
"ResourceRecordKey" => "30038075"
"ModificationTimestamp" => "2026-07-15T20:01:47.88Z"
]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30038075')"
+"ID": "1637137"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 294897" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25009
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24954
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Re/Max Escarpment Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-304-3303"
+"OfficeMlsId": "BR22000257"
+"ModificationTimestamp": "2026-06-16T17:41:24Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "294897"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "109 Portia Drive Unit 4A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Ancaster"
+"OfficePostalCode": "L9G3K"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Brantford"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1443398"
+"OriginalEntryTimestamp": "2023-06-30T12:36:00Z"
+"OfficeAORKey": "41"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "319960"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "294897"
"SocialMediaUrlOrId" => "http://www.remaxescarpment.com/"
"ModificationTimestamp" => "2026-06-16T17:24:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1442900"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('294897')"
}
]
+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 2095157" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24905
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.18 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30038075'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25305
+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 '30038075' AND OpenHouseDate ge '2026-07-20'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25321
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30038075' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9230619 43.0686652)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25374
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25368
+post_id: "1637033"
+post_author: 1
+"ListingKey": "30043667"
+"ListingId": "40848762"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-19T20:25:22Z"
+"RFModificationTimestamp": "2026-07-19T20:27:25Z"
+"ListPrice": 929000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2598.0
+"BuildingAreaTotal": 0
+"City": "Caledonia"
+"PostalCode": "N3W0B4"
+"UnparsedAddress": "31 LARRY Crescent, Caledonia, Ontario N3W0B4"
+"Coordinates": array:2 [
0 => -79.932238
1 => 43.0699971
]
+"Latitude": 43.0699971
+"Longitude": -79.932238
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Premium Lot Backing onto Green Space! Welcome to 31 Larry Crescent, where style, space, and function come together in one of the community's most sought-after floor plans! From the moment you arrive, you'll appreciate the outstanding curb appeal, featuring a beautiful paved and exposed aggregate driveway and front walkway. Step inside to a spacious foyer and discover a bright, airy main floor with impressive 9-foot ceilings and an abundance of natural light. Designed for modern living, the open-concept layout offers a separate dining room, a welcoming family room, and a stunning kitchen complete with a walk-in pantry, butler's/coffee bar, and a dedicated nook that's perfect for a home office or study space. A convenient 2-piece powder room and functional mudroom with direct access from the double garage complete the main level. Upstairs, you'll find four generously sized bedrooms, including a spacious primary retreat featuring a large walk-in closet and a luxurious 5-piece ensuite. A well-appointed 4-piece main bathroom provides plenty of space for family and guests. Throughout the home, you'll appreciate the added touch of custom window coverings. The bright, unfinished lower level offers oversized windows and high ceilings, providing endless possibilities to create the space you've always envisioned. Backing onto peaceful green space and offering one of the neighbourhood's most desirable layouts, this home truly checks all the boxes. All appliances are included—just move in and enjoy! Don't miss your opportunity to call 31 Larry Crescent home! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:53:19.466128+00:00"
+"Directions": "Arnold Marshall to Larry Crescent"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524280"
+"ListOfficeKey": "67816"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-16T20:53:48Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-19T20:18:22Z"
+"Stories": "2.0"
+"StreetName": "LARRY"
+"StreetNumber": "31"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "631 - Caledonia North East"
+"TaxAnnualAmount": "6837.36"
+"Utilities": array:1 [
0 => "Natural Gas"
]
+"VirtualTourURLUnbranded": "https://www.venturehomes.ca/virtualtour.asp?tourid=70423"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1688783780"
"RoomType" => "5pc Bathroom"
"ListingId" => "40848762"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30043667"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-19T20:18:22.51Z"
]
1 => array:11 [
"RoomKey" => "1688783781"
"RoomType" => "4pc Bathroom"
"ListingId" => "40848762"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30043667"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-19T20:18:22.51Z"
]
2 => array:11 [
"RoomKey" => "1688783782"
"RoomType" => "2pc Bathroom"
"ListingId" => "40848762"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30043667"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-19T20:18:22.51Z"
]
3 => array:11 [
"RoomKey" => "1688783783"
"RoomType" => "Bedroom"
"ListingId" => "40848762"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30043667"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-19T20:18:22.51Z"
]
4 => array:11 [
"RoomKey" => "1688783784"
"RoomType" => "Bedroom"
"ListingId" => "40848762"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30043667"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-19T20:18:22.51Z"
]
5 => array:11 [
"RoomKey" => "1688783785"
"RoomType" => "Bedroom"
"ListingId" => "40848762"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30043667"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-19T20:18:22.51Z"
]
6 => array:11 [
"RoomKey" => "1688783786"
"RoomType" => "Primary Bedroom"
"ListingId" => "40848762"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30043667"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 18'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-19T20:18:22.51Z"
]
7 => array:11 [
"RoomKey" => "1688783787"
"RoomType" => "Office"
"ListingId" => "40848762"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30043667"
"RoomLength" => null
"RoomDimensions" => "5'5'' x 6'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-19T20:18:22.51Z"
]
8 => array:11 [
"RoomKey" => "1688783788"
"RoomType" => "Family room"
"ListingId" => "40848762"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30043667"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 17'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-19T20:18:22.51Z"
]
9 => array:11 [
"RoomKey" => "1688783789"
"RoomType" => "Kitchen"
"ListingId" => "40848762"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30043667"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-19T20:18:22.52Z"
]
10 => array:11 [
"RoomKey" => "1688783790"
"RoomType" => "Dining room"
"ListingId" => "40848762"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30043667"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-19T20:18:22.52Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30043667/31-larry-crescent-caledonia"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-B"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 2598
+"OriginalEntryTimestamp": "2026-07-16T18:59:54.33Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1129172"
+"ListOfficeNationalAssociationId": "1132083"
+"Media": array:49 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30043667_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043667/a1863de7c78103fb42be19ee4b723037.webp"
"MediaSize" => 118953
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043667/thumbnail-a1863de7c78103fb42be19ee4b723037.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40848762"
"ResourceRecordKey" => "30043667"
"ModificationTimestamp" => "2026-07-16T20:53:48.22Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30043667_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043667/f49318b5708abd4fc22baec3c73839ed.webp"
"MediaSize" => 116029
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043667/thumbnail-f49318b5708abd4fc22baec3c73839ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848762"
"ResourceRecordKey" => "30043667"
"ModificationTimestamp" => "2026-07-16T20:53:47.82Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30043667_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043667/c51c95d06943b6311df8a8b9c10ddbbc.webp"
"MediaSize" => 136187
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043667/thumbnail-c51c95d06943b6311df8a8b9c10ddbbc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848762"
"ResourceRecordKey" => "30043667"
"ModificationTimestamp" => "2026-07-16T20:53:48.22Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30043667_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043667/3e37f88e5f0b36d169a7075f5be6d78d.webp"
"MediaSize" => 125056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043667/thumbnail-3e37f88e5f0b36d169a7075f5be6d78d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848762"
"ResourceRecordKey" => "30043667"
"ModificationTimestamp" => "2026-07-16T20:53:48.51Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30043667_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043667/643f4d47c59d2b660b7ccc97cb659973.webp"
"MediaSize" => 119625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043667/thumbnail-643f4d47c59d2b660b7ccc97cb659973.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848762"
"ResourceRecordKey" => "30043667"
"ModificationTimestamp" => "2026-07-16T20:53:47.82Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30043667_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043667/c45dbb5dc7c3bccb950280ec2feb2c01.webp"
"MediaSize" => 61226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043667/thumbnail-c45dbb5dc7c3bccb950280ec2feb2c01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848762"
"ResourceRecordKey" => "30043667"
"ModificationTimestamp" => "2026-07-16T20:53:47.84Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30043667_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043667/14d0a1aa6058f10f70e37ea758a92965.webp"
"MediaSize" => 44077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043667/thumbnail-14d0a1aa6058f10f70e37ea758a92965.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848762"
"ResourceRecordKey" => "30043667"
"ModificationTimestamp" => "2026-07-16T20:53:47.84Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30043667_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043667/1324d8f8e8b47fdbc079bd446c8e3d9b.webp"
"MediaSize" => 60129
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043667/thumbnail-1324d8f8e8b47fdbc079bd446c8e3d9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848762"
"ResourceRecordKey" => "30043667"
"ModificationTimestamp" => "2026-07-16T20:53:48.22Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30043667_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043667/f877d00980acf63fd6b2438b35aea035.webp"
"MediaSize" => 57094
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043667/thumbnail-f877d00980acf63fd6b2438b35aea035.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848762"
"ResourceRecordKey" => "30043667"
"ModificationTimestamp" => "2026-07-16T20:53:47.36Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30043667_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043667/00fbb1ea0c9b921fe1fac8fb4ca0f0f8.webp"
"MediaSize" => 69889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043667/thumbnail-00fbb1ea0c9b921fe1fac8fb4ca0f0f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848762"
"ResourceRecordKey" => "30043667"
"ModificationTimestamp" => "2026-07-16T20:53:47.94Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30043667_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043667/5fa144c57c84dd7404754a5e236cba59.webp"
"MediaSize" => 44221
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043667/thumbnail-5fa144c57c84dd7404754a5e236cba59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848762"
"ResourceRecordKey" => "30043667"
"ModificationTimestamp" => "2026-07-16T20:53:47.82Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30043667_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043667/078180621c43a76f439ee02602542e10.webp"
"MediaSize" => 63163
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043667/thumbnail-078180621c43a76f439ee02602542e10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848762"
"ResourceRecordKey" => "30043667"
"ModificationTimestamp" => "2026-07-16T20:53:47.36Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30043667_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043667/4fa4e1bc48844f46623948aea27e4143.webp"
"MediaSize" => 76836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043667/thumbnail-4fa4e1bc48844f46623948aea27e4143.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848762"
"ResourceRecordKey" => "30043667"
"ModificationTimestamp" => "2026-07-16T20:53:47.83Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30043667_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043667/c2f9c63fa863b1c19594cd215c87c183.webp"
"MediaSize" => 67774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043667/thumbnail-c2f9c63fa863b1c19594cd215c87c183.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848762"
"ResourceRecordKey" => "30043667"
"ModificationTimestamp" => "2026-07-16T20:53:48.22Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30043667_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043667/4d4f8c21d2d11e2152337dedc25b9976.webp"
"MediaSize" => 83456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043667/thumbnail-4d4f8c21d2d11e2152337dedc25b9976.webp"
"ResourceName" => "Property"
…6
]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30043667')"
+"ID": "1637033"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25370
+post_id: "1629521"
+post_author: 1
+"ListingKey": "30038020"
+"ListingId": "X13568042"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T12:20:13Z"
+"RFModificationTimestamp": "2026-07-20T12:23:27Z"
+"ListPrice": 759000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Haldimand"
+"PostalCode": "N3W0E9"
+"UnparsedAddress": "67 MALCOLM CRESCENT, Haldimand, Ontario N3W0E9"
+"Coordinates": array:2 [
0 => -79.928498
1 => 43.075652
]
+"Latitude": 43.075652
+"Longitude": -79.928498
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 67 Malcolm Crescent, a beautifully maintained family home offering 2,307 sq ft of bright, functional living space in a growing, family-friendly community. The open-concept main floor features pot lights throughout, a spacious great room, separate dining area, and a well appointed kitchen with upgraded cabinetry, granite countertops, a large island, and breakfast area. Upstairs offers four generous bedrooms, including a primary suite with two walk-in closets and a private ensuite, along with a second full bathroom and convenient upper-level laundry. The unfinished basement provides excellent potential for future living space or storage. Outside, enjoy a landscaped backyard with a concrete patio and upgraded exterior pot lighting. Ideally located just steps from parks, walking trails, the Grand River, and a new school currently under construction, this home is an excellent opportunity for families seeking comfort, space, and convenience. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T23:52:17.853065+00:00"
+"Directions": "Rainbow Drive"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2070769"
+"ListOfficeKey": "283291"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "33.1 x 91.9 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-07-15T19:39:25Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T12:11:21Z"
+"Stories": "2.0"
+"StreetName": "Malcolm"
+"StreetNumber": "67"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6023.59"
+"VirtualTourURLUnbranded": "http://hdvirtualtours.ca/67-malcolm-cres-caledonia/mls/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Haldimand"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30038020/67-malcolm-crescent-haldimand-haldimand"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1-B"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 33.1
+"OriginalEntryTimestamp": "2026-07-15T19:39:25.03Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1345936"
+"ListOfficeNationalAssociationId": "1326174"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30038020')"
+"ID": "1629521"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25367
+post_id: "1621968"
+post_author: 1
+"ListingKey": "30028713"
+"ListingId": "X13559334"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:15:05Z"
+"RFModificationTimestamp": "2026-07-17T21:04:09Z"
+"ListPrice": 1799900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Haldimand"
+"PostalCode": "N3W1C8"
+"UnparsedAddress": "397 CAITHNESS STREET E, Haldimand, Ontario N3W1C8"
+"Coordinates": array:2 [
0 => -79.939465
1 => 43.068172
]
+"Latitude": 43.068172
+"Longitude": -79.939465
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This stunning home backing onto the Grand River has been completely renovated from top to bottom! This beautiful home sits on a double lot with over 5000 sq ft of living space. Amazing curb appeal with a circular driveway big enough for 10 cars and an oversized double garage. A grand foyer welcomes you to the spacious main level with 10' ceilings. You will notice the amazing nature light from the front foyer window and a wall of windows along the back of the home. A cozy living room awaits you with a gas fireplace leading to a lovely dining room perfect for meals with family and friends and an amazingly large functional kitchen with cabinets galore and a 10' island. Patio doors from the kitchen open to an upper deck with stunning views of the Grand River, an expansive backyard with a firepit and a 30' dock, you'll will feel like you're on vacation everyday. The main level also includes an office/bedroom off the front foyer, a 2 piece bathroom, laundry room and automatic blinds on the front foyer window, living room and dining room windows. Moving up to the 2nd floor, you will find a gorgeous primary bedroom with a walk in closet, a spa like ensuite with a walk in shower and soaker tub, also 3 generous sized bedrooms and a 4 piece bathroom. All bedroom closets have closet organizers. The expansive lower level includes a large family room with pool table, a kitchenette allows for in-law suite potential, 2 more bedrooms and a bright 3 piece bathroom. The lower level family room leads you to a covered patio with an 8 person Beachcomber hot tub, enjoy peaceful evenings star gazing and river views. In addition to the oversized double garage, there is a utility garage at the back of the house which is perfect for your riding lawnmower and anything other landscaping equipment. Country feels with all the amenities near by! Don't miss out on this wonderful family home! Luxury Certified. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Stove"
4 => "Oven"
5 => "Dryer"
6 => "Microwave"
7 => "Blinds"
8 => "Window Coverings"
9 => "Garage door opener remote(s)"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "Walk out"
4 => "N/A"
5 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-14T01:36:29.928727+00:00"
+"Directions": "Cross Streets: Kincardine St. ** Directions: Argyle St. N to Caithness St. E."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2259210"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "159 x 284 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-14T00:39:14Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:10:01Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "Caithness"
+"StreetNumber": "397"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "9694.85"
+"View": "River view,View of water,Direct Water View"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/cvtnb/360647"
+"WaterBodyName": "Grand River"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Haldimand"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30028713/397-caithness-street-e-haldimand-haldimand"
+"ParkingTotal": 12
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on river"
]
+"FrontageLengthNumeric": 159.0
+"OriginalEntryTimestamp": "2026-07-14T00:39:14.4Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1499122"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30028713')"
+"ID": "1621968"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25371
+post_id: "1621703"
+post_author: 1
+"ListingKey": "30028207"
+"ListingId": "40847386"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-14T13:10:05Z"
+"RFModificationTimestamp": "2026-07-14T13:16:55Z"
+"ListPrice": 1799900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 5178.0
+"BuildingAreaTotal": 0
+"City": "Caledonia"
+"PostalCode": "N3W1C8"
+"UnparsedAddress": "397 CAITHNESS Street E, Caledonia, Ontario N3W1C8"
+"Coordinates": array:2 [
0 => -79.9391241
1 => 43.0685055
]
+"Latitude": 43.0685055
+"Longitude": -79.9391241
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This stunning home backing onto the Grand River has been completely renovated from top to bottom! This beautiful home sits on a double lot with over 5000 sq ft of living space. Amazing curb appeal with a circular driveway big enough for 10 cars and an oversized double garage. A grand foyer welcomes you to the spacious main level with 10' ceilings. You will notice the amazing nature light from the front foyer window and a wall of windows along the back of the home. A cozy living room awaits you with a gas fireplace leading to a lovely dining room perfect for meals with family and friends and an amazingly large functional kitchen with cabinets galore and a 10' island. Patio doors from the kitchen open to an upper deck with stunning views of the Grand River, an expansive backyard with a firepit and a 30' dock, you'll will feel like you're on vacation everyday. The main level also includes an office/bedroom off the front foyer, a 2 piece bathroom, laundry room and automatic blinds on the front foyer window, living room and dining room windows. Moving up to the 2nd floor, you will find a gorgeous primary bedroom with a walk in closet, a spa like ensuite with a walk in shower and soaker tub, also 3 generous sized bedrooms and a 4 piece bathroom. All bedroom closets have closet organizers. The expansive lower level includes a large family room with pool table, a kitchenette allows for in-law suite potential, 2 more bedrooms and a bright 3 piece bathroom. The lower level family room leads you to a covered patio with an 8 person Beachcomber hot tub, enjoy peaceful evenings star gazing and river views. In addition to the oversized double garage, there is a utility garage at the back of the house which is perfect for your riding lawnmower and anything other landscaping equipment. Country feels with all the amenities near by! Don't miss out on this wonderful family home! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-14T01:08:58.721855+00:00"
+"Directions": "Argyle St. N to Caithness St. E."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1896862"
+"ListOfficeKey": "54949"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-14T13:00:45Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-14T13:00:45Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "CAITHNESS"
+"StreetNumber": "397"
+"StreetSuffix": "Street"
+"SubdivisionName": "631 - Caledonia North East"
+"TaxAnnualAmount": "9694.86"
+"View": "Direct Water View"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/360647"
+"WaterBodyName": "Grand River"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30028207/397-caithness-street-e-caledonia"
+"ParkingTotal": 12
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-A"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on river"
]
+"FrontageLengthNumeric": 150.0
+"AboveGradeFinishedArea": 3645
+"BelowGradeFinishedArea": 1533
+"OriginalEntryTimestamp": "2026-07-13T22:58:51.76Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1214980"
+"ListOfficeNationalAssociationId": "1003557"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30028207')"
+"ID": "1621703"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25369
+post_id: "1618160"
+post_author: 1
+"ListingKey": "30023353"
+"ListingId": "X13554368"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T12:20:12Z"
+"RFModificationTimestamp": "2026-07-20T12:23:41Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Haldimand"
+"PostalCode": "N3W1C8"
+"UnparsedAddress": "23 ABERDEEN STREET, Haldimand, Ontario N3W1C8"
+"Coordinates": array:2 [
0 => -79.942917
1 => 43.070461
]
+"Latitude": 43.070461
+"Longitude": -79.942917
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 23 Aberdeen Street in the charming town of Caledonia. This fully renovated, move-in-ready home offers over 1,600 square feet of beautifully updated living space and is sure to impress. Featuring 4 bedrooms, 3 bathrooms, and a deep ravine-like lot, this property combines modern finishes with functional family living. The bright open-concept main floor features a spacious foyer, a modern kitchen complete with quartz countertops and a breakfast peninsula, separate dining and living areas, a main floor bedroom, and a stylish 3-piece bathroom with a glass shower. Upstairs, you'll find a skylight providing plenty of natural light, 3 generously sized bedrooms, and a large contemporary 4-piece bathroom. The fully finished walkout basement offers excellent additional living space with a spacious rec room, modern 3-piece bathroom with glass shower, and a wet bar/kitchenette. With a separate entrance from the parking area, the basement offers great potential for an in-law suite or multi-generational living arrangement. Enjoy walkout access from both the main floor and the basement to separate rear decks overlooking the private backyard and views of the Grand River - perfect for relaxing or entertaining on warm summer evenings. Recent updates include the furnace (2026), central air conditioning (2026), roof (2025), facia/soffits/eaves (2026), vinyl siding (2026), most windows (2026), doors (2026), owned water heater (2026), 100-amp breaker panel, convenient main floor laundry and more. Conveniently located close to downtown Caledonia, this home is within walking distance to restaurants, cafe's, shopping, schools, parks, grocery stores, the Caledonia Fairgrounds, and the Grand River, where you can enjoy boating, fishing, canoeing, kayaking, swimming, and scenic walking trails offering the ideal balance of charming small-town living and modern everyday convenience. Schedule your private viewing today! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Water Heater"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Separate entrance"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-12T19:19:13.551560+00:00"
+"Directions": "Hwy 54 ( St. Caithness St) and Aberdeen St."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2156606"
+"ListOfficeKey": "289810"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Ravine"
]
+"LotSizeDimensions": "63 x 130 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-12T19:09:09Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T12:11:03Z"
+"Stories": "2.0"
+"StreetName": "Aberdeen"
+"StreetNumber": "23"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3427"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Haldimand"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30023353/23-aberdeen-street-haldimand-haldimand"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "RI-A"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 63.0
+"OriginalEntryTimestamp": "2026-07-12T18:39:29.48Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1408040"
+"ListOfficeNationalAssociationId": "1381466"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30023353')"
+"ID": "1618160"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25364
+post_id: "1602875"
+post_author: 1
+"ListingKey": "30003095"
+"ListingId": "X13535596"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-12T16:50:00Z"
+"RFModificationTimestamp": "2026-07-12T16:52:05Z"
+"ListPrice": 779000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Haldimand"
+"PostalCode": "N3W0C9"
+"UnparsedAddress": "198 WHITHORN CRESCENT, Haldimand, Ontario N3W0C9"
+"Coordinates": array:2 [
0 => -79.932193
1 => 43.07394
]
+"Latitude": 43.07394
+"Longitude": -79.932193
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully designed detached home in the heart of Caledonia's sought-after Avalon community. This stunning 2,395 sq. ft. residence showcases a striking brick and upgraded stone elevation and is filled with natural light throughout. The main floor features soaring ceilings, a grand double-door entry, a dramatic double-height foyer, and a spacious walk-in closet. Enjoy open-concept layout with living room, family room, Kitchen and breakfast area. The upgraded kitchen is a chef's dream, complete with stainless steel appliances, and an expansive breakfast area. Modern oak hardwood flooring flows throughout both the main and second levels, adding warmth and elegance. Upstairs, you'll find four generously sized bedrooms, ideal for a growing family. The oversized primary suite offers two walk-in closets (his & hers) and a luxurious 5-piece ensuite. A convenient second-floor laundry room adds to the home's functionality. Perfectly positioned just opposite the new school, this home also offers quick access to major highways, just 15 minutes to Hamilton and within an hour of the GTA. Close to schools, public transit, shopping, and all amenities, this is a rare opportunity with exceptional potential. (id:62650)"
+"Appliances": array:3 [
0 => "All"
1 => "Blinds"
2 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-08T01:32:04.108053+00:00"
+"Directions": "Mcclaung Rd / Whithorn Cres"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Brick Facing"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2012345"
+"ListOfficeKey": "84654"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Ravine"
1 => "Carpet Free"
]
+"LotSizeDimensions": "33.2 x 92.1 FT ; Check CB bonus commission"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-08T00:39:01Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-12T16:40:50Z"
+"Stories": "2.0"
+"StreetName": "Whithorn"
+"StreetNumber": "198"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "5910.82"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Haldimand"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30003095/198-whithorn-crescent-haldimand-haldimand"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 33.2
+"OriginalEntryTimestamp": "2026-07-08T00:39:00.99Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1293886"
+"ListOfficeNationalAssociationId": "1145170"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 13
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30003095')"
+"ID": "1602875"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23523
+post_id: "1600992"
+post_author: 1
+"ListingKey": "29999483"
+"ListingId": "40845722"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-19T20:20:01Z"
+"RFModificationTimestamp": "2026-07-19T20:22:48Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1632.0
+"BuildingAreaTotal": 0
+"City": "Caledonia"
+"PostalCode": "N3W1C8"
+"UnparsedAddress": "23 ABERDEEN Street, Caledonia, Ontario N3W1C8"
+"Coordinates": array:2 [
0 => -79.9426974
1 => 43.0714938
]
+"Latitude": 43.0714938
+"Longitude": -79.9426974
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
+"PublicRemarks": "Welcome to 23 Aberdeen Street in the charming town of Caledonia. This fully renovated, move-in-ready home offers over 1,600 square feet of beautifully updated living space and is sure to impress. Featuring 4 bedrooms, 3 bathrooms, and a deep ravine-like lot, this property combines modern finishes with functional family living. The bright open-concept main floor features a spacious foyer, a modern kitchen complete with quartz countertops and a breakfast peninsula, separate dining and living areas, a main floor bedroom, and a stylish 3-piece bathroom with a glass shower. Upstairs, you’ll find a skylight providing plenty of natural light, 3 generously sized bedrooms, and a large contemporary 4-piece bathroom. The fully finished walkout basement offers excellent additional living space with a spacious rec room, modern 3-piece bathroom with glass shower, and a wet bar/kitchenette. With a separate entrance from the parking area, the basement offers great potential for an in-law suite or multi-generational living arrangement. Enjoy walkout access from both the main floor and the basement to separate rear decks overlooking the private backyard and views of the Grand River — perfect for relaxing or entertaining on warm summer evenings. Recent updates include the furnace (2026), central air conditioning (2026), roof (2025), facia/soffits/eaves (2026), vinyl siding (2026), most windows (2026), doors (2026), owned water heater (2026), 100-amp breaker panel, convenient main floor laundry and more. Conveniently located close to downtown Caledonia, this home is within walking distance to restaurants, cafe's, shopping, schools, parks, grocery stores, the Caledonia Fairgrounds, and the Grand River, where you can enjoy boating, fishing, canoeing, kayaking, swimming, and scenic walking trails offering the ideal balance of charming small-town living and modern everyday convenience. Schedule your private viewing today! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T19:40:54.158752+00:00"
+"Directions": "Hwy 54 ( St. Caithness St) and Aberdeen St."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2049035"
+"ListOfficeKey": "289711"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-07-12T18:24:05Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-19T20:13:35Z"
+"Stories": "2.0"
+"StreetName": "ABERDEEN"
+"StreetNumber": "23"
+"StreetSuffix": "Street"
+"SubdivisionName": "631 - Caledonia North East"
+"TaxAnnualAmount": "3427"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
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]
]
+"ListAOR": "Brantford"
+"ListAORKey": "41"
+"ListingURL": "www.realtor.ca/real-estate/29999483/23-aberdeen-street-caledonia"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-A"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 63.0
+"AboveGradeFinishedArea": 1046
+"BelowGradeFinishedArea": 586
+"OriginalEntryTimestamp": "2026-07-07T16:24:06.26Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1324496"
+"ListOfficeNationalAssociationId": "1380321"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 13
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29999483')"
+"ID": "1600992"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25372
+post_id: "1598678"
+post_author: 1
+"ListingKey": "29997179"
+"ListingId": "40845507"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-16T15:05:16Z"
+"RFModificationTimestamp": "2026-07-16T15:11:11Z"
+"ListPrice": 779900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2544.0
+"BuildingAreaTotal": 0
+"City": "Caledonia"
+"PostalCode": "N3W0C2"
+"UnparsedAddress": "41 SUMAC Drive, Caledonia, Ontario N3W0C2"
+"Coordinates": array:2 [
0 => -79.9346771
1 => 43.0725053
]
+"Latitude": 43.0725053
+"Longitude": -79.9346771
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautiful 2-storey detached home in the Empire Avalon Community in Caledonia! This spacious and modern property boasts an open-concept living space perfect for today’s lifestyle. The main floor offers a seamless flow between the kitchen, dining, and living areas, creating an ideal space for entertaining family and friends. Upstairs, you'll find a fantastic open-concept family room with large windows that flood the space with natural light. Step out onto your own private second-storey balcony – the perfect spot for relaxing or enjoying your morning coffee. The expansive basement features high ceilings, offering endless possibilities for additional living space, a home gym, or a playroom. The neighbourhood has new public elementary school and an elementary catholic school, alongside a childcare centre. This home is perfectly situated for convenience. Don’t miss out on this fantastic opportunity. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T01:37:20.438346+00:00"
+"Directions": "HIGHWAY 6 - HALDIMAND RD 66 - MCCLUNG RD - ARNOLD MARSHAL - SUMAC DRIVE"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1907019"
+"ListOfficeKey": "103841"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T00:59:07Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-16T15:00:01Z"
+"Stories": "2.0"
+"StreetName": "SUMAC"
+"StreetNumber": "41"
+"StreetSuffix": "Drive"
+"SubdivisionName": "631 - Caledonia North East"
+"TaxAnnualAmount": "5588"
+"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/29997179/41-sumac-drive-caledonia"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "H A7A"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 34.0
+"AboveGradeFinishedArea": 2544
+"OriginalEntryTimestamp": "2026-07-07T00:59:07.64Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1220466"
+"ListOfficeNationalAssociationId": "1165450"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"DaysOnMarket": 14
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29997179')"
+"ID": "1598678"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25373
+post_id: "1553311"
+post_author: 1
+"ListingKey": "29935114"
+"ListingId": "X13472796"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T12:30:18Z"
+"RFModificationTimestamp": "2026-06-28T12:39:22Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Haldimand"
+"PostalCode": "N3W1C3"
+"UnparsedAddress": "85 ABERDEEN STREET, Haldimand, Ontario N3W1C3"
+"Coordinates": array:2 [
0 => -79.942375
1 => 43.071594
]
+"Latitude": 43.071594
+"Longitude": -79.942375
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Client RemarksThis beautifully updated raised bungalow sits on a 50 foot lot in one of Caledonia's most sought after pockets, just steps from the scenic Grand River and the famous Caledonia Fairgrounds. Offering over 2,000 square feet of finished living space across two levels, this 3+1 home is ideal for multigenerational living, a growing family, or anyone needing that extra flexibility.The main floor features three bedrooms, a full bathroom, a spacious kitchen, a bright living room, and a dedicated dining area. The kitchen walks out to a stunning elevated back deck, perfect for entertaining. Completely renovated throughout with new flooring, custom crown moulding, pot lights, refinished cabinetry, new appliances, and a new backsplash. Both bathrooms have been fully renovated top to bottom. The home is quiet, car friendly, and surrounded by top rated elementary schools and daycares, with groceries and everyday amenities just minutes away.The lower level adds a generous fourth bedroom, a second full bathroom, and a large utility room, all with excellent ceiling height and natural light making it feel nothing like a typical basement.Caledonia is a charming community along the Grand River with a true small town feel. Parks, a library, recreation centre, and places of worship are all nearby. Highway 54 and Highway 6 keep you well connected to Hamilton, Brantford, and beyond. Attached garage, interlock driveway, and parking for three. (id:62650)"
+"Appliances": array:4 [
0 => "All"
1 => "Washer"
2 => "Dryer"
3 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T16:06:45.903713+00:00"
+"Directions": "Cross Streets: SUTHERLAND ST E & ABERDEEN ST. ** Directions: HWY 6 TO HWY 54 TO ABERDEEN ST."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2154976"
+"ListOfficeKey": "293485"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "50.7 x 100.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T23:05:56Z"
+"PhotosCount": 50
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T12:22:26Z"
+"Stories": "1.0"
+"StreetName": "Aberdeen"
+"StreetNumber": "85"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4202"
+"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": 2025
+"CityRegion": "Haldimand"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29935114/85-aberdeen-street-haldimand-haldimand"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.8
+"OriginalEntryTimestamp": "2026-06-22T12:25:17.87Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1406489"
+"ListOfficeNationalAssociationId": "1427673"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 28
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29935114')"
+"ID": "1553311"
}
]
+success: true
+page_size: 9
+page_count: 5
+count: 39
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]