array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 28943138 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23584
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23586
+post_id: "816842"
+post_author: 1
+"ListingKey": "28943138"
+"ListingId": "40775588"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T21:10:00Z"
+"RFModificationTimestamp": "2026-07-24T21:22:28Z"
+"ListPrice": 275900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1211.0
+"BuildingAreaTotal": 0
+"City": "Flamborough"
+"PostalCode": "L0R1K0"
+"UnparsedAddress": "57 12TH CONC Road E Unit# 430, Flamborough, Ontario L0R1K0"
+"Coordinates": array:2 [
0 => -80.04488358
1 => 43.41464706
]
+"Latitude": 43.41464706
+"Longitude": -80.04488358
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to the serene setting at Fernbrook Resort, a 50+ lifestyle cottage atmosphere w/clubhouse amenities including an indoor & outdoor pool. This rarely offered 2 story home features 3 bedrooms, 1.5 bathrooms. The kitchen is open to the dining room and family room - great for entertaining. Main floor laundry plus 4-piece bathroom, and mud room. Upstairs master features 2pc ensuite + 2 additional bedrooms. Large front deck for enjoying your morning coffee. The clubhouse includes indoor pool, gym, outdoor pool, hot tub and suntan deck. Centrally located for quick access to QEW and 401, Waterdown, Hamilton, Guelph, Cambridge. Units cannot be financed or used as collateral for a loan. Lot fees are approx. $647/Month to be verified with park management which includes lot, taxes, water, water testing, and use of the resort amenities. Hydro, propane extra. Buyer must be approved by the Park. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2025-10-02T20:42:00.752431+00:00"
+"Directions": "N on Hwy#6, right on 12th Conc Rd E. End of road, turn left into Park, go past clubhouse, over bridge, 2nd right onto Sunset (Large metal cone around pole, turn right), on right you will see a large tent, turn right pass tent, House facing front 430"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1897418"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Crushed stone driveway"
2 => "Country residential"
]
+"PhotosChangeTimestamp": "2026-07-24T20:42:25Z"
+"PhotosCount": 35
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T21:01:40Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "12TH CONC"
+"StreetNumber": "57"
+"StreetSuffix": "Road"
+"SubdivisionName": "044 - Flamborough East"
+"TaxAnnualAmount": "0.01"
+"WaterSource": array:2 [
0 => "Well"
1 => "Community Water System"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1692713159"
"RoomType" => "Bedroom"
"ListingId" => "40775588"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "28943138"
"RoomLength" => null
"RoomDimensions" => "7'7'' x 8'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T21:01:40.73Z"
]
1 => array:11 [
"RoomKey" => "1692713160"
"RoomType" => "Bedroom"
"ListingId" => "40775588"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "28943138"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T21:01:40.73Z"
]
2 => array:11 [
"RoomKey" => "1692713161"
"RoomType" => "Primary Bedroom"
"ListingId" => "40775588"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "28943138"
"RoomLength" => null
"RoomDimensions" => "14'6'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T21:01:40.74Z"
]
3 => array:11 [
"RoomKey" => "1692713162"
"RoomType" => "4pc Bathroom"
"ListingId" => "40775588"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28943138"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 6'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T21:01:40.74Z"
]
4 => array:11 [
"RoomKey" => "1692713163"
"RoomType" => "Family room"
"ListingId" => "40775588"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28943138"
"RoomLength" => null
"RoomDimensions" => "15'0'' x 15'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T21:01:40.74Z"
]
5 => array:11 [
"RoomKey" => "1692713164"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "40775588"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28943138"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 15'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T21:01:40.74Z"
]
6 => array:11 [
"RoomKey" => "1692713165"
"RoomType" => "Laundry room"
"ListingId" => "40775588"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28943138"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T21:01:40.74Z"
]
7 => array:11 [
"RoomKey" => "1692713166"
"RoomType" => "Foyer"
"ListingId" => "40775588"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28943138"
"RoomLength" => null
"RoomDimensions" => "6'5'' x 7'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T21:01:40.74Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/28943138/57-12th-conc-road-e-unit-430-flamborough"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Modular"
]
+"CommonInterest": "Leasehold"
+"GeocodeManualYN": true
+"ZoningDescription": "A2, P8"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1211
+"OriginalEntryTimestamp": "2025-10-02T19:30:16.71Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1215329"
+"ListOfficeNationalAssociationId": "1330157"
+"Media": array:35 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6215729066"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/558757dc51a59eda0acabfc65e6157a5.webp"
"MediaSize" => 186815
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-558757dc51a59eda0acabfc65e6157a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of side of home"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:45.85Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "28943138_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/b26178eda179c7e3a45cd7cd69ec656b.webp"
"MediaSize" => 157460
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-b26178eda179c7e3a45cd7cd69ec656b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of side of home"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2026-05-28T17:31:05.39Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "28943138_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/259be3176edaad7a1664b3e9f618b027.webp"
"MediaSize" => 139930
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-259be3176edaad7a1664b3e9f618b027.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Outdoor wooden deck with privacy fencing, featuring post cap lighting and white vinyl siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2026-05-28T17:31:05.36Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "28943138_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/3b225e745a8f051cbaa51cca9a0d6f24.webp"
"MediaSize" => 86844
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-3b225e745a8f051cbaa51cca9a0d6f24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Foyer/mudroom entrance"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2026-05-28T17:31:05.39Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "28943138_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/e716cb3c1fadb416cceaca679c843a04.webp"
"MediaSize" => 94738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-e716cb3c1fadb416cceaca679c843a04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Laundry area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2026-05-28T17:31:05.34Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "28943138_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/8ef094a9dfc620e13465ed6b186117d8.webp"
"MediaSize" => 89907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-8ef094a9dfc620e13465ed6b186117d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Mudroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2026-05-28T17:31:05.39Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "28943138_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/17d441dc8e7896cf732ebc7a926c8923.webp"
"MediaSize" => 88147
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-17d441dc8e7896cf732ebc7a926c8923.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bathroom with shower / bath combo"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2026-05-28T17:31:05.41Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "28943138_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/765f7561baa0606d4c5b9521c4a0c631.webp"
"MediaSize" => 104365
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-765f7561baa0606d4c5b9521c4a0c631.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2026-07-24T20:42:23.45Z"
]
8 => array:13 [
"Order" => 10
"MediaKey" => "6215729468"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/018710600e1dffbe20fedf123c5b287a.webp"
"MediaSize" => 101291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-018710600e1dffbe20fedf123c5b287a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:45.77Z"
]
9 => array:13 [
"Order" => 11
"MediaKey" => "6215729500"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/9b672d92c1bde2844bedb0a3918e7350.webp"
"MediaSize" => 113692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-9b672d92c1bde2844bedb0a3918e7350.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:46.91Z"
]
10 => array:13 [
"Order" => 12
"MediaKey" => "6215729535"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/794477a85e70d514a5a42cdcad3c3667.webp"
"MediaSize" => 115982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-794477a85e70d514a5a42cdcad3c3667.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:46.86Z"
]
11 => array:13 [
"Order" => 13
"MediaKey" => "6215729577"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/1f0e6fc95d82a2ccbb9cdfa15d56f41b.webp"
"MediaSize" => 118939
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-1f0e6fc95d82a2ccbb9cdfa15d56f41b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:46.85Z"
]
12 => array:13 [
"Order" => 14
"MediaKey" => "6215729619"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/780d7ff9edfd5473548c940b2c537ccf.webp"
"MediaSize" => 102904
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-780d7ff9edfd5473548c940b2c537ccf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "3rd Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:46.88Z"
]
13 => array:13 [
"Order" => 15
"MediaKey" => "6215729702"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/57d908fddade1f74624a9fff0f24c631.webp"
"MediaSize" => 75734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-57d908fddade1f74624a9fff0f24c631.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "2nd Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:46.89Z"
]
14 => array:13 [
"Order" => 16
"MediaKey" => "6215729766"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/df8693a4cac5da4e38be10447750a809.webp"
"MediaSize" => 96321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-df8693a4cac5da4e38be10447750a809.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "2nd Bedroo"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:44.65Z"
]
15 => array:13 [
"Order" => 17
"MediaKey" => "6215729853"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/4453826ba241d06de643e969d529be59.webp"
"MediaSize" => 90328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-4453826ba241d06de643e969d529be59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "2nd bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:46.89Z"
]
16 => array:13 [
"Order" => 18
"MediaKey" => "6215729929"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/33b4465dbd86b7345bdc4b45b927d6a9.webp"
"MediaSize" => 101327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-33b4465dbd86b7345bdc4b45b927d6a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Master bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:46.88Z"
]
17 => array:13 [
"Order" => 19
"MediaKey" => "6215730015"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/d1c41837c6bcc8f4417704dba891ba70.webp"
"MediaSize" => 98448
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-d1c41837c6bcc8f4417704dba891ba70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:46.86Z"
]
18 => array:13 [
"Order" => 20
"MediaKey" => "6215730094"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/3caa3623ca5b439234e553253f3eed4e.webp"
"MediaSize" => 91017
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-3caa3623ca5b439234e553253f3eed4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Master 2pc Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:46.87Z"
]
19 => array:13 [
"Order" => 21
"MediaKey" => "6215730132"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/adbedc937c6d75f98f4f6c105bb0147a.webp"
"MediaSize" => 38894
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-adbedc937c6d75f98f4f6c105bb0147a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:46.91Z"
]
20 => array:13 [
"Order" => 22
"MediaKey" => "6215730159"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/47993638cfdbd2cb197b2b788f6419a6.webp"
"MediaSize" => 95528
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-47993638cfdbd2cb197b2b788f6419a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of wooden deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:46.88Z"
]
21 => array:13 [
"Order" => 23
"MediaKey" => "6215730206"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/f3d565978a5afd2f696ae48ae8711415.webp"
"MediaSize" => 170785
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-f3d565978a5afd2f696ae48ae8711415.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of shed"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:47.94Z"
]
22 => array:13 [
"Order" => 24
"MediaKey" => "6215730232"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/763f7230fb4eef956716f732c3800330.webp"
"MediaSize" => 176072
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-763f7230fb4eef956716f732c3800330.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Wooden deck with area for grilling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:45.77Z"
]
23 => array:13 [
"Order" => 25
"MediaKey" => "6215730253"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/6baa469d24d8902624e14f12f5ed20f4.webp"
"MediaSize" => 150028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-6baa469d24d8902624e14f12f5ed20f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of side of property featuring a shingled roof, mansard roof, and a deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:45.77Z"
]
24 => array:13 [
"Order" => 26
"MediaKey" => "6215730332"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/43292a7b12031076dd55608fb9f47e73.webp"
"MediaSize" => 179273
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-43292a7b12031076dd55608fb9f47e73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of property floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:47.96Z"
]
25 => array:13 [
"Order" => 27
"MediaKey" => "6215730361"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/104bb4d6d3a22e757744046b95c04eea.webp"
"MediaSize" => 62071
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-104bb4d6d3a22e757744046b95c04eea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of property floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:45.76Z"
]
26 => array:13 [
"Order" => 28
"MediaKey" => "6215730391"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/35e5466f49916c97b26442f4d3a622c9.webp"
"MediaSize" => 50867
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-35e5466f49916c97b26442f4d3a622c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of floor plan / room layout"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:45.77Z"
]
27 => array:13 [
"Order" => 29
"MediaKey" => "6215730405"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/b94cf541dbdadc5be4b33d45f224fa87.webp"
"MediaSize" => 62918
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-b94cf541dbdadc5be4b33d45f224fa87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial view of a pool area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:46.91Z"
]
28 => array:13 [
"Order" => 30
"MediaKey" => "6215730461"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/c3e67dd1cf05ad63f01596f3f424e303.webp"
"MediaSize" => 148482
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-c3e67dd1cf05ad63f01596f3f424e303.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dock area with a water view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:47.94Z"
]
29 => array:13 [
"Order" => 31
"MediaKey" => "6215730489"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/2399b85ba456ae03b7c25bdc0b59b84f.webp"
"MediaSize" => 126926
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-2399b85ba456ae03b7c25bdc0b59b84f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Community pool with a patio area, outdoor dining area, and view of scattered trees"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:45.77Z"
]
30 => array:13 [
"Order" => 32
"MediaKey" => "6215730519"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/946c40641155aa23a1e6e34f17924584.webp"
"MediaSize" => 142476
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-946c40641155aa23a1e6e34f17924584.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Indoor pool with a patio and a pergola"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:47.95Z"
]
31 => array:13 [
"Order" => 33
"MediaKey" => "6215730558"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/9f349bf2d9ae4420e4ea24f5f1d1af01.webp"
"MediaSize" => 128527
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-9f349bf2d9ae4420e4ea24f5f1d1af01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Indoor community pool with a patio"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:47.94Z"
]
32 => array:13 [
"Order" => 34
"MediaKey" => "6215803254"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/00c3d71c65ccb924ba51eb92f4667bfa.webp"
"MediaSize" => 139046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-00c3d71c65ccb924ba51eb92f4667bfa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Indoor community pool with a patio"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2025-10-02T22:02:47.97Z"
]
33 => array:13 [
"Order" => 9
"MediaKey" => "28943138_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/a0afa59df27e1097dec721945cc68648.webp"
"MediaSize" => 107356
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-a0afa59df27e1097dec721945cc68648.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2026-07-24T20:42:23.47Z"
]
34 => array:13 [
"Order" => 10
"MediaKey" => "28943138_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28943138/8c7d1eb003d894ba8d44419360cf63c3.webp"
"MediaSize" => 89287
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28943138/thumbnail-8c7d1eb003d894ba8d44419360cf63c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40775588"
"ResourceRecordKey" => "28943138"
"ModificationTimestamp" => "2026-07-24T20:42:18.68Z"
]
]
+"DaysOnMarket": 295
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('28943138')"
+"ID": "816842"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Cache Key: 512e7118279cc666de6017988ee905cd85d410e4b637984c0645c57c60530e6c" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24763
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25093
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Keller Williams Edge Realty"
+"OfficeEmail": null
+"OfficePhone": "905-335-8808"
+"OfficeMlsId": "HBKWEDGE301"
+"ModificationTimestamp": "2026-02-04T22:59:50Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "283457"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "3185 Harvester Rd., Unit #1A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "BURLINGTON"
+"OfficePostalCode": "L7N3N"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1330157"
+"OriginalEntryTimestamp": "2018-05-08T14:22:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "452483"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "283457"
"SocialMediaUrlOrId" => "https://www.kellerwilliamsedge.kw.com/"
"ModificationTimestamp" => "2026-02-04T20:08:00Z"
]
]
+"FranchiseNationalAssociationId": "1230713"
+"OfficeBrokerNationalAssociationId": "1063384"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('283457')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Cache Key: ce5d217604f39a76efb2897facd3a48dae2a6b5165606796db963f364ed52e68" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25013
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '28943138'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25394
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '28943138' AND OpenHouseDate ge '2026-07-24'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25410
+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 '28943138' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.04488358 43.41464706)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25463
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25457
+post_id: "1636044"
+post_author: 1
+"ListingKey": "30048666"
+"ListingId": "X13577438"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T17:45:04Z"
+"RFModificationTimestamp": "2026-07-17T19:04:07Z"
+"ListPrice": 1595000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Freelton)"
+"PostalCode": "L8B0Z6"
+"UnparsedAddress": "27 KARENDALE CRESCENT, Hamilton (Freelton), Ontario L8B0Z6"
+"Coordinates": array:2 [
0 => -80.047108
1 => 43.401385
]
+"Latitude": 43.401385
+"Longitude": -80.047108
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Resort-Style Living. Absolute Privacy.Welcome to 27 Karendale Crescent-an impeccably maintained, large detached bungalow on a premium 0.54-acre lot in peaceful Freelton. Retaining its historic "old Ontario" character while remaining just 15 minutes from urban centers (Milton), this home offers country living with city convenience. Encircled by a professionally curated border of mature trees, it delivers the perfect blend of small-town charm and total privacy.Offering 2,124 sq ft of above-grade space, the layout is built for entertaining and comfort. A double driveway and attached two-car garage lead to a main-floor laundry room with interior garage access. The bright eat-in kitchen features patio doors and was beautifully updated in 2023 with quartz counters, a matching backsplash, and premium new appliances including a microwave, stove, and fridge. The living room features custom built-ins, a cozy fireplace, and an energy-efficient triple-pane window. The main floor hosts three bedrooms, including a secondary room with ensuite privileges to a renovated 3-piece bath (2023), and a primary suite with a walk-in closet and private 3-piece ensuite.Downstairs, the full basement serves as a massive extension of your living space with a large rec room, kitchenette, one bedroom, one den, and an additional 3-piece bath-ideal for extended family or guests. A new A/C system (2024) adds complete peace of mind. Step outside to a spectacular, resort-style backyard retreat featuring a partially covered stone patio, exquisite landscaping, and a heated, inground salt-water pool with a new liner (2023) offering an unobstructed view of nature.Whether you want room for dogs, proximity to conservation areas, or a seamless commute to Hamilton, Burlington, Guelph, or the GTA, this property checks every box. Space, premium modern upgrades, and a true community setting-this is Freelton living at its best. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Wine Fridge"
7 => "Stove"
8 => "Oven"
9 => "Dryer"
10 => "Microwave"
11 => "Window Coverings"
12 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T19:04:01.180539+00:00"
+"Directions": "FREELTON RD & BRIDLE ST"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2181963"
+"ListOfficeKey": "50068"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Wooded area"
1 => "Ravine"
]
+"LotSizeDimensions": "154.4 x 153.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T17:39:45Z"
+"PhotosCount": 42
+"PoolFeatures": array:1 [
0 => "Outdoor pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T17:39:44Z"
+"Stories": "1.0"
+"StreetName": "Karendale"
+"StreetNumber": "27"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "8206.3"
+"Utilities": array:3 [
0 => "Electricity"
1 => "Cable"
2 => "Natural Gas Available"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/27_karendale_crescent_hamilton_on"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1686844939"
"RoomType" => "Living room"
"ListingId" => "X13577438"
"RoomLevel" => "Main level"
"RoomWidth" => 8.41
"ListingKey" => "30048666"
"RoomLength" => 6.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T17:39:44.97Z"
]
1 => array:11 [
"RoomKey" => "1686844940"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13577438"
"RoomLevel" => "Basement"
"RoomWidth" => 9.12
"ListingKey" => "30048666"
"RoomLength" => 9.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T17:39:44.97Z"
]
2 => array:11 [
"RoomKey" => "1686844941"
"RoomType" => "Kitchen"
"ListingId" => "X13577438"
"RoomLevel" => "Main level"
"RoomWidth" => 5.36
"ListingKey" => "30048666"
"RoomLength" => 4.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T17:39:44.97Z"
]
3 => array:11 [
"RoomKey" => "1686844942"
"RoomType" => "Dining room"
"ListingId" => "X13577438"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "30048666"
"RoomLength" => 3.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T17:39:44.97Z"
]
4 => array:11 [
"RoomKey" => "1686844943"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13577438"
"RoomLevel" => "Main level"
"RoomWidth" => 4.7
"ListingKey" => "30048666"
"RoomLength" => 5.54
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T17:39:44.97Z"
]
5 => array:11 [
"RoomKey" => "1686844944"
"RoomType" => "Bedroom 2"
"ListingId" => "X13577438"
"RoomLevel" => "Main level"
"RoomWidth" => 3.4
"ListingKey" => "30048666"
"RoomLength" => 4.55
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T17:39:44.97Z"
]
6 => array:11 [
"RoomKey" => "1686844945"
"RoomType" => "Bedroom 3"
"ListingId" => "X13577438"
"RoomLevel" => "Main level"
"RoomWidth" => 3.3
"ListingKey" => "30048666"
"RoomLength" => 3.33
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T17:39:44.97Z"
]
7 => array:11 [
"RoomKey" => "1686844946"
"RoomType" => "Laundry room"
"ListingId" => "X13577438"
"RoomLevel" => "Main level"
"RoomWidth" => 2.44
"ListingKey" => "30048666"
"RoomLength" => 2.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T17:39:44.97Z"
]
8 => array:11 [
"RoomKey" => "1686844947"
"RoomType" => "Bedroom"
"ListingId" => "X13577438"
"RoomLevel" => "Basement"
"RoomWidth" => 3.05
"ListingKey" => "30048666"
"RoomLength" => 4.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T17:39:44.97Z"
]
9 => array:11 [
"RoomKey" => "1686844948"
"RoomType" => "Other"
"ListingId" => "X13577438"
"RoomLevel" => "Basement"
"RoomWidth" => 9.63
"ListingKey" => "30048666"
"RoomLength" => 7.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T17:39:44.97Z"
]
10 => array:11 [
"RoomKey" => "1686844949"
"RoomType" => "Office"
"ListingId" => "X13577438"
"RoomLevel" => "Basement"
"RoomWidth" => 3.73
"ListingKey" => "30048666"
"RoomLength" => 5.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T17:39:44.97Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Freelton"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30048666/27-karendale-crescent-hamilton-freelton-freelton"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1411652"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "50068"
+"GeocodeManualYN": false
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 154.4
+"OriginalEntryTimestamp": "2026-07-17T17:39:44.95Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1431744"
+"ListOfficeNationalAssociationId": "1002251"
+"CoListAgentNationalAssociationId": "1046017"
+"CoListOfficeNationalAssociationId": "1002251"
+"Media": array:42 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30048666_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048666/831e8edcb486423c2aa8c9b8ef141f68.webp"
"MediaSize" => 317365
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048666/thumbnail-831e8edcb486423c2aa8c9b8ef141f68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13577438"
"ResourceRecordKey" => "30048666"
"ModificationTimestamp" => "2026-07-17T17:39:44.95Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30048666_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048666/eef7b6be6e0799186e9cebe231f3b974.webp"
"MediaSize" => 371887
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048666/thumbnail-eef7b6be6e0799186e9cebe231f3b974.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13577438"
"ResourceRecordKey" => "30048666"
"ModificationTimestamp" => "2026-07-17T17:39:44.95Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30048666_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048666/51a8ea8e60b8a1ce090a2b6f1f0f77ff.webp"
"MediaSize" => 329354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048666/thumbnail-51a8ea8e60b8a1ce090a2b6f1f0f77ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13577438"
"ResourceRecordKey" => "30048666"
"ModificationTimestamp" => "2026-07-17T17:39:44.95Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30048666_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048666/de4f124b41af62644bb02c34663df6e1.webp"
"MediaSize" => 329575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048666/thumbnail-de4f124b41af62644bb02c34663df6e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13577438"
"ResourceRecordKey" => "30048666"
"ModificationTimestamp" => "2026-07-17T17:39:44.95Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30048666_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048666/eeb70b90dc63d297fde012b5caa96b6d.webp"
"MediaSize" => 347541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048666/thumbnail-eeb70b90dc63d297fde012b5caa96b6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13577438"
"ResourceRecordKey" => "30048666"
"ModificationTimestamp" => "2026-07-17T17:39:44.95Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30048666_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048666/12371aa116d84970ff61a261147b7e27.webp"
"MediaSize" => 240554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048666/thumbnail-12371aa116d84970ff61a261147b7e27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13577438"
"ResourceRecordKey" => "30048666"
"ModificationTimestamp" => "2026-07-17T17:39:44.95Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30048666_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048666/9ccd2346f7384fedb49446079222b6f2.webp"
"MediaSize" => 154264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048666/thumbnail-9ccd2346f7384fedb49446079222b6f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13577438"
"ResourceRecordKey" => "30048666"
"ModificationTimestamp" => "2026-07-17T17:39:44.95Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30048666_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048666/430815e0780a4d40e26bca83d81ff01d.webp"
"MediaSize" => 169267
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048666/thumbnail-430815e0780a4d40e26bca83d81ff01d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13577438"
"ResourceRecordKey" => "30048666"
"ModificationTimestamp" => "2026-07-17T17:39:44.95Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30048666_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048666/9713e744f55a7ec35eaa20c34428931d.webp"
"MediaSize" => 150666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048666/thumbnail-9713e744f55a7ec35eaa20c34428931d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13577438"
"ResourceRecordKey" => "30048666"
"ModificationTimestamp" => "2026-07-17T17:39:44.95Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30048666_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048666/803938b9dadf3dbaa48029b7df3108fa.webp"
"MediaSize" => 147991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048666/thumbnail-803938b9dadf3dbaa48029b7df3108fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13577438"
"ResourceRecordKey" => "30048666"
"ModificationTimestamp" => "2026-07-17T17:39:44.95Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30048666_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048666/9a6152be174bc0b46d22ed32eded2400.webp"
"MediaSize" => 181935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048666/thumbnail-9a6152be174bc0b46d22ed32eded2400.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13577438"
"ResourceRecordKey" => "30048666"
"ModificationTimestamp" => "2026-07-17T17:39:44.95Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30048666_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048666/5f1bac143ba9556201e1524a32bc2675.webp"
"MediaSize" => 165602
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048666/thumbnail-5f1bac143ba9556201e1524a32bc2675.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13577438"
"ResourceRecordKey" => "30048666"
"ModificationTimestamp" => "2026-07-17T17:39:44.95Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30048666_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048666/2f89cbed2ee5a49aee90863f27edda25.webp"
"MediaSize" => 151485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048666/thumbnail-2f89cbed2ee5a49aee90863f27edda25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13577438"
"ResourceRecordKey" => "30048666"
"ModificationTimestamp" => "2026-07-17T17:39:44.95Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30048666_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048666/df07d5c25d5f5628d49cb17f64cfdc38.webp"
"MediaSize" => 195570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048666/thumbnail-df07d5c25d5f5628d49cb17f64cfdc38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13577438"
"ResourceRecordKey" => "30048666"
"ModificationTimestamp" => "2026-07-17T17:39:44.95Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30048666_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048666/3b361515b7abc30d672113320a5dfba2.webp"
"MediaSize" => 193790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048666/thumbnail-3b361515b7abc30d672113320a5dfba2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13577438"
"ResourceRecordKey" => "30048666"
"ModificationTimestamp" => "2026-07-17T17:39:44.95Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30048666_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048666/4ef9be0483f5fc0b88925733b7863fe7.webp"
"MediaSize" => 190552
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048666/thumbnail-4ef9be0483f5fc0b88925733b7863fe7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13577438"
"ResourceRecordKey" => "30048666"
"ModificationTimestamp" => "2026-07-17T17:39:44.95Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30048666_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048666/433655e0b04050c031d6e05d42d2df8e.webp"
"MediaSize" => 210963
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048666/thumbnail-433655e0b04050c031d6e05d42d2df8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13577438"
"ResourceRecordKey" => "30048666"
"ModificationTimestamp" => "2026-07-17T17:39:44.95Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30048666_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048666/f878c033517e1d1c892383bc5cc9a318.webp"
…10
]
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": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30048666')"
+"ID": "1636044"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25459
+post_id: "1601872"
+post_author: 1
+"ListingKey": "29999184"
+"ListingId": "X13532100"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T23:15:03Z"
+"RFModificationTimestamp": "2026-07-20T23:16:44Z"
+"ListPrice": 974000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Freelton)"
+"PostalCode": "N0B2J0"
+"UnparsedAddress": "318 FREELTON ROAD, Hamilton (Freelton), Ontario N0B2J0"
+"Coordinates": array:2 [
0 => -80.0475
1 => 43.406392
]
+"Latitude": 43.406392
+"Longitude": -80.0475
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "House and a Shop! Tucked on an expansive 100' x 375' lot in the charming community of Freelton, this 1,400 square foot bungalow with a shop delivers the space, flexibility and lifestyle that are nearly impossible to find at this price point. The main floor offers a partially open-concept kitchen, three bedrooms, one and a half bathrooms and a walkout to the deck - perfect for enjoying the privacy of your beautiful surroundings. The lower level, with two separate walkouts, is ready to finish to your own taste - the hard work is already done! Electrical, plumbing, drains, ductwork and framing are all in place for a one-bedroom in-law suite: the bathroom has a working toilet and roughed-in stand-up shower, with a new soaker tub and sink included, the bedroom features pot lights, and the kitchen is plumbed and ready for your choice of cabinets, appliances, counters and flooring - a natural fit for multi-generational living or in-law possibility. Drive right back to your detached shop, which is a rare find: solid all-block construction measuring 22' x 37' with approximately 15' ceilings, a concrete pad floor, oversized rollup door, and separate man door, separate septic and toilet flange. Whether you're a hobbyist, tradesperson, car enthusiast, or entrepreneur, this space will not disappoint. Add a double attached garage, room to breathe on a deep private lot, and just 15-20 minutes to most amenities in Cambridge, Waterdown and Guelph - and you have a property that truly checks every box. Opportunities like this don't come along often. RSA. Detached shop is setup for a connection to 3 phase electrical (not currently connected). (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Full"
1 => "Walk out"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T16:08:15.642729+00:00"
+"Directions": "Hwy 6 to Freelton Rd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1979013"
+"ListOfficeKey": "293273"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "124.5 x 446.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T15:41:46Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T23:08:03Z"
+"Stories": "1.0"
+"StreetName": "Freelton"
+"StreetNumber": "318"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6767"
+"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": "Freelton"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29999184/318-freelton-road-hamilton-freelton-freelton"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "P8, S1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 124.6
+"OriginalEntryTimestamp": "2026-07-07T15:41:46.74Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1264940"
+"ListOfficeNationalAssociationId": "1424812"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 17
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29999184')"
+"ID": "1601872"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25456
+post_id: "1599249"
+post_author: 1
+"ListingKey": "29998783"
+"ListingId": "40845117"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T23:00:01Z"
+"RFModificationTimestamp": "2026-07-20T23:08:43Z"
+"ListPrice": 974000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 1.27
+"LivingArea": 1441.0
+"BuildingAreaTotal": 0
+"City": "Puslinch"
+"PostalCode": "N0B2J0"
+"UnparsedAddress": "318 FREELTON Road, Puslinch, Ontario N0B2J0"
+"Coordinates": array:2 [
0 => -80.047477
1 => 43.4064517
]
+"Latitude": 43.4064517
+"Longitude": -80.047477
+"YearBuilt": 1976
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "House and a Shop! Tucked on an expansive 100' x 375' lot in the charming community of Freelton, this 1,400 square foot bungalow with a shop delivers the space, flexibility and lifestyle that are nearly impossible to find at this price point. The main floor offers a partially open-concept kitchen, three bedrooms, one and a half bathrooms and a walkout to the deck — perfect for enjoying the privacy of your beautiful surroundings. The lower level, with two separate walkouts, is ready to finish to your own taste — the hard work is already done! Electrical, plumbing, drains, ductwork and framing are all in place for a one-bedroom in-law suite: the bathroom has a working toilet and roughed-in stand-up shower, with a new soaker tub and sink included, the bedroom features pot lights, and the kitchen is plumbed and ready for your choice of cabinets, appliances, counters and flooring — a natural fit for multi-generational living or in-law possibility. Drive right back to your detached shop, which is a rare find: solid all-block construction measuring 22' x 37' with approximately 15' ceilings, a concrete pad floor, oversized rollup door, and separate man door, separate septic and toilet flange. Whether you're a hobbyist, tradesperson, car enthusiast, or entrepreneur, this space will not disappoint. Add a double attached garage, room to breathe on a deep private lot, and just 15-20 minutes to most amenities in Cambridge, Waterdown and Guelph — and you have a property that truly checks every box. Opportunities like this don't come along often. Don’t be TOO LATE*! *REG TM. RSA. Detached\u{A0}shop\u{A0}is setup for a connection to 3 phase electrical (not currently connected). (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T15:23:43.798571+00:00"
+"Directions": "HWY 6 TO FREELTON RD"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Country residential"
]
+"LotSizeDimensions": "1.27"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-20T22:50:46Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T22:59:27Z"
+"Stories": "1.0"
+"StreetName": "FREELTON"
+"StreetNumber": "318"
+"StreetSuffix": "Road"
+"SubdivisionName": "043 - Flamborough West"
+"TaxAnnualAmount": "6767"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"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/29998783/318-freelton-road-puslinch"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "P8, S1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 124.0
+"AboveGradeFinishedArea": 1441
+"OriginalEntryTimestamp": "2026-07-07T14:59:35.02Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063673"
+"ListOfficeNationalAssociationId": "1424570"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 17
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29998783')"
+"ID": "1599249"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25460
+post_id: "1527578"
+post_author: 1
+"ListingKey": "29888715"
+"ListingId": "40838459"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T15:40:13Z"
+"RFModificationTimestamp": "2026-06-11T16:17:54Z"
+"ListPrice": 400000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L0P1B0"
+"UnparsedAddress": "216 MOUNTSBERG Road, Hamilton, Ontario L0P1B0"
+"Coordinates": array:2 [
0 => -80.0387621
1 => 43.4266299
]
+"Latitude": 43.4266299
+"Longitude": -80.0387621
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "One Acre building lot located North of Carlisle, in North East Hamilton close to Milton, Great access to Highway 401 and Milton. Lot backs onto Agricultural land and a portion to the rear is within the 100 year flood plain. Lot is wooded and fronts onto a rural paved road. Approximetly2/3rds of the lot is buildable. Ideal for a family looking for an affordable setting to build their dream country home. Buyer will be responsible for development fees, building permits, cost of servicing , well cost, septic costs, etc., at buyers expense. HST in addition to Purchase price if applicable. Buyer to rely on their own due diligence and verification of their plans with appropriate authorities and respective costs. (id:62783)"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-11T16:16:15.876365+00:00"
+"Directions": "Hwy 6 N to mountsberg Rd turn East and is on South side approx 300 Mtr W of Centre Rd."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1870300"
+"ListOfficeKey": "103841"
+"LotFeatures": array:2 [
0 => "Country residential"
1 => "Recreational"
]
+"PhotosChangeTimestamp": "2026-06-11T15:32:03Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "No sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T15:32:03Z"
+"StreetName": "MOUNTSBERG"
+"StreetNumber": "216"
+"StreetSuffix": "Road"
+"SubdivisionName": "044 - Flamborough East"
+"TaxAnnualAmount": "193.32"
+"Utilities": array:1 [
0 => "Cable"
]
+"WaterSource": array:1 [
0 => "None"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29888715/216-mountsberg-road-hamilton"
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "A2"
+"FrontageLengthNumeric": 200.0
+"OriginalEntryTimestamp": "2026-06-11T15:32:03.72Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1207373"
+"ListOfficeNationalAssociationId": "1165450"
+"Media": array:1 [
0 => array:13 [ …13]
]
+"DaysOnMarket": 43
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29888715')"
+"ID": "1527578"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25458
+post_id: "1476426"
+post_author: 1
+"ListingKey": "29824354"
+"ListingId": "X13213590"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-29T16:06:12Z"
+"RFModificationTimestamp": "2026-05-29T16:33:43Z"
+"ListPrice": 3998000.0
+"BathroomsTotalInteger": 7.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B1H8"
+"UnparsedAddress": "102 CONCESSION 11 E, Hamilton, Ontario L8B1H8"
+"Coordinates": array:2 [
0 => -80.025775
1 => 43.406699
]
+"Latitude": 43.406699
+"Longitude": -80.025775
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Renovated Bungalow W/ Walk-Out Basement Features 4+1 Beds & 7 Baths & Parking for 12+ Cars. TheGrandEntry Greets You W/ Vaulted 11ftCeilings, Premium Vinyl Flooring, & Pot Lights Throughout The MainLevel.The Open-Concept Dining Room & Chefs Kitchen Boast An OversizedSit-Up Island, Quartz Countertops, Top-Tier B/I S/S Appliances, A W/I Pantry, & A Coffee Bar. The Formal Living Room, Create A Cozy SpaceForFamily Gatherings. The Family Room Features Vaulted Ceilings, Floor-To-Ceiling Windows &A Gas Fireplace.The Primary Suite Offers A W/I Closet & A 5-Piece Ensuite, Dbl Vanity, & Glass Shower. 3 Well-Appointed Beds W/Their Own Ensuites. A Main Level Mudroom W/Laundry Area &Garage Access,Completes The Main Level. The Lower Level Featuring 8ft Ceilings, Above-Grade Windows, Pot Lights, & B/I Speakers. The Rec Room Provides Ample Space For Entertaining Friends & Family W/ A Wet Bar. AnAdditional Bedroom & Office Make A Great Space For Guests OrTh. An Oversized Flex Space Offers A GreatPlayroom W/ Ample Storage & A 4pc Bathroom. Head Outside To The Custom-Built Pergola W/ Wired-InHeaters, Pot Lights, B/I Speakers, &A Ceiling Fan, Perfect For Summer Dinners Overlooking The Resort-Style Backyard. It Is A TrueEntertainers Dream, Featuring An Inground Saltwater Pool W/ A Waterslide, A Putting Green, & A Custom-Built Cabana W/Outdoor Kitchen &Wood-Burning Fireplace. The Expansive2500 Sqft Detached Garage/Shop Features A Man Cave, 3-pc Bathroom, & Ample Storage. Ideal ForThoseWho Cherish Tranquility & A Slower Pace Of Life, ThisProperty Is Protected By Partial Conservation Land,Providing A Serene Setting AndUnparalleled Privacy. With Trails, Farms, And Conservation Areas, It's A Haven For Nature Lovers And Outdoor Enthusiasts. With Easy Access ToMajor Highways, This Is A TrueDream Home Within Close Proximity To All Necessities And Amenities A like. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Water purifier"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dryer"
5 => "Blinds"
6 => "Play structure"
7 => "Window Coverings"
8 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-29T16:33:09.988292+00:00"
+"Directions": "Hwy 6 & Concession 11 E"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"Flooring": array:2 [
0 => "Laminate"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1666360"
+"ListOfficeKey": "300621"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Wooded area"
1 => "Conservation/green belt"
2 => "Sump Pump"
]
+"LotSizeDimensions": "279 x 624.3 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-29T15:56:14Z"
+"PhotosCount": 42
+"PoolFeatures": array:2 [
0 => "Inground pool"
1 => "Salt Water Pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-29T15:56:14Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "Concession 11"
+"StreetNumber": "102"
+"TaxAnnualAmount": "11730"
+"VirtualTourURLUnbranded": "https://fresh-approach-listings.webflow.io/listing/102-concession-11-e-2-unbranded"
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Rural Flamborough"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29824354/102-concession-11-e-hamilton-rural-flamborough"
+"ParkingTotal": 14
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1592887"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "300621"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"ZoningDescription": "P6,P7"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 279.0
+"OriginalEntryTimestamp": "2026-05-29T15:56:14.38Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1169191"
+"ListOfficeNationalAssociationId": "1491000"
+"CoListAgentNationalAssociationId": "1154700"
+"CoListOfficeNationalAssociationId": "1491000"
+"Media": array:40 [
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]
]
+"DaysOnMarket": 56
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29824354')"
+"ID": "1476426"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25453
+post_id: "1437889"
+post_author: 1
+"ListingKey": "29774048"
+"ListingId": "X13146860"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T20:05:07Z"
+"RFModificationTimestamp": "2026-06-10T20:13:11Z"
+"ListPrice": 2299900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "N0B2J0"
+"UnparsedAddress": "2092 HIGHWAY 6, Hamilton, Ontario N0B2J0"
+"Coordinates": array:2 [
0 => -80.05974
1 => 43.41613
]
+"Latitude": 43.41613
+"Longitude": -80.05974
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Set on over 10 acres of ultra-private land in sought-after Flamborough, this exceptional country estate offers a rare blend of luxury, lifestyle, and functionality. Thoughtfully updated throughout, the 4-bedroom, 4-bathroom home delivers the kind of space, finish level, and versatility that is increasingly difficult to find. The main level is anchored by a dramatic family room with soaring cathedral ceilings, oversized windows, and a striking feature fireplace wall that creates an immediate sense of scale and warmth. Durable wood-look tile flooring runs throughout, while the chef-inspired kitchen features Cabico cabinetry, dovetail drawers, Cambria quartz countertops, and an oversized island designed for gathering and entertaining. A bright four-season sunroom with hot tub access overlooks the peaceful surrounding landscape and opens onto multiple outdoor seating areas and raised gardens. Upstairs, the open-to-below den with skylights adds to the home's airy, connected feel. The spacious primary suite includes a custom walk-in closet and spa-inspired ensuite with oversized double shower and dual vanity, while three additional bedrooms and a full bathroom complete the upper level. The finished lower level was designed with entertaining in mind, offering an oversized rec room with wet bar and island seating, media room, wine cellar, and full bathroom. A true standout feature is the newly built 40' x 54' heated shop (2023) with hydro and high-speed internet - ideal for entrepreneurs, hobbyists, collectors, or recreational use. Additional highlights include a heated attached garage, furnace and heat pump(A/C) updates (2022), a 60-amp EV connection(at the shop), and participation in the CLTP program for valuable property tax savings. A truly spectacular offering combining privacy, modern comfort, and elevated country living - all within easy reach of the city. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Wine Fridge"
4 => "Oven"
5 => "Dryer"
6 => "Microwave"
7 => "Cooktop"
8 => "Freezer"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Garage door opener remote(s)"
12 => "Water Heater"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-20T01:37:05.749679+00:00"
+"Directions": "Cross Streets: HWY 6 & Mountsberg Rd. ** Directions: On HWY 6 between Mountsberg Rd & Campbellville Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1952102"
+"ListOfficeKey": "285151"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Wooded area"
]
+"LotSizeDimensions": "1045.1 x 507.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-20T15:32:41Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T19:56:30Z"
+"Stories": "2.0"
+"StreetName": "Highway 6"
+"StreetNumber": "2092"
+"TaxAnnualAmount": "8164"
+"VirtualTourURLUnbranded": "https://2092-hwy-6-flamborough.netlify.app/#top"
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Rural Flamborough"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29774048/2092-highway-6-hamilton-rural-flamborough"
+"ParkingTotal": 26
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2050273"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "285151"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"ZoningDescription": "P7, P8"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 1045.1
+"OriginalEntryTimestamp": "2026-05-20T00:26:28.13Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1245775"
+"ListOfficeNationalAssociationId": "1347969"
+"CoListAgentNationalAssociationId": "1325722"
+"CoListOfficeNationalAssociationId": "1347969"
+"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": 66
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29774048')"
+"ID": "1437889"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23598
+post_id: "1437796"
+post_author: 1
+"ListingKey": "29773891"
+"ListingId": "40831145"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T20:00:07Z"
+"RFModificationTimestamp": "2026-06-10T20:15:38Z"
+"ListPrice": 2299900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 10.102
+"LivingArea": 4536.0
+"BuildingAreaTotal": 0
+"City": "Puslinch"
+"PostalCode": "N0B2J0"
+"UnparsedAddress": "2092 HIGHWAY 6, Puslinch, Ontario N0B2J0"
+"Coordinates": array:2 [
0 => -80.0593779
1 => 43.4165618
]
+"Latitude": 43.4165618
+"Longitude": -80.0593779
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Set on over 10 acres of ultra-private land in sought-after Flamborough, this exceptional country estate offers a rare blend of luxury, lifestyle, and functionality. Thoughtfully updated throughout, the 4-bedroom, 4-bathroom home delivers the kind of space, finish level, and versatility that is increasingly difficult to find. The main level is anchored by a dramatic family room with soaring cathedral ceilings, oversized windows, and a striking feature fireplace wall that creates an immediate sense of scale and warmth. Durable wood-look tile flooring runs throughout, while the chef-inspired kitchen features Cabico cabinetry, dovetail drawers, Cambria quartz countertops, and an oversized island designed for gathering and entertaining. A bright four-season sunroom with hot tub access overlooks the peaceful surrounding landscape and opens onto multiple outdoor seating areas and raised gardens. Upstairs, the open-to-below den with skylights adds to the home’s airy, connected feel. The spacious primary suite includes a custom walk-in closet and spa-inspired ensuite with oversized double shower and dual vanity, while three additional bedrooms and a full bathroom complete the upper level. The finished lower level was designed with entertaining in mind, offering an oversized rec room with wet bar and island seating, media room, wine cellar, and full bathroom. A true standout feature is the newly built 40’ x 54’ heated shop (2023) with hydro and high-speed internet — ideal for entrepreneurs, hobbyists, collectors, or recreational use. Additional highlights include a heated attached garage, furnace and heat pump(A/C) updates (2022), a 60-amp EV connection(at the shop), and participation in the CLTP program for valuable property tax savings. A truly spectacular offering combining privacy, modern comfort, and elevated country living — all within easy reach of the city. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Dryer"
5 => "Microwave"
6 => "Wet Bar"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-20T00:53:06.761981+00:00"
+"Directions": "On HWY 6 between Mountsberg Rd & Campbellville Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2239450"
+"ListOfficeKey": "299790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Wet bar"
1 => "Country residential"
2 => "Automatic Garage Door Opener"
3 => "Private Yard"
]
+"LotSizeDimensions": "10.102"
+"NumberOfUnitsTotal": "1"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-05-20T15:33:50Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T19:51:44Z"
+"Stories": "2.0"
+"StreetName": "HIGHWAY 6"
+"StreetNumber": "2092"
+"SubdivisionName": "044 - Flamborough East"
+"TaxAnnualAmount": "8164"
+"VirtualTourURLUnbranded": "https://2092-hwy-6-flamborough.netlify.app/#top"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:20 [
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]
19 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29773891/2092-highway-6-puslinch"
+"ParkingTotal": 26
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2050273"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299790"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"ZoningDescription": "P7, P8"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 3258
+"BelowGradeFinishedArea": 1278
+"OriginalEntryTimestamp": "2026-05-19T23:49:32.64Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1477386"
+"ListOfficeNationalAssociationId": "1476846"
+"CoListAgentNationalAssociationId": "1325722"
+"CoListOfficeNationalAssociationId": "1476846"
+"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": 66
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29773891')"
+"ID": "1437796"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25461
+post_id: "1376307"
+post_author: 1
+"ListingKey": "29687429"
+"ListingId": "X13071194"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T13:05:44Z"
+"RFModificationTimestamp": "2026-06-02T13:29:52Z"
+"ListPrice": 750000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Freelton)"
+"PostalCode": "L0R1K0"
+"UnparsedAddress": "74 FREELTON ROAD, Hamilton (Freelton), Ontario L0R1K0"
+"Coordinates": array:2 [
0 => -80.0355601
1 => 43.3994787
]
+"Latitude": 43.3994787
+"Longitude": -80.0355601
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Welcome home to this beautifully updated 4-bedroom, 2 full-bath property that perfectly blends comfort, style, and convenience. Step inside to discover brand-new flooring throughout, enhanced by modern lighting and a fresh, neutral paint palette that creates a bright and inviting atmosphere. The updated kitchen is a true highlight, featuring contemporary finishes and ample space for cooking and gathering. With four generously sized bedrooms and two full bathrooms, there's plenty of room for family, guests, or a home office setup. The finished basement offers versatile additional living space-perfect for a recreation room, home gym, media room, or play area. Nestled on a quiet dead-end road, this home provides added privacy and minimal traffic while still being ideally located close to parks, shopping, dining, and major highways for an easy commute. Move-in ready and thoughtfully updated, this home is ready for you to make it your own. (id:62783)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Stove"
2 => "Microwave"
3 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-01T20:03:24.713045+00:00"
+"Directions": "Cross Streets: Concession 11 E. ** Directions: Hwy 6 to Concession 11 E."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Concrete Block"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2252573"
+"ListOfficeKey": "299665"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Cul-de-sac"
]
+"LotSizeDimensions": "72.1 x 113.2 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-05-01T19:27:36Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T12:56:24Z"
+"Stories": "2.0"
+"StreetName": "Freelton"
+"StreetNumber": "74"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6991.81"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Niagara"
+"CityRegion": "Freelton"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29687429/74-freelton-road-hamilton-freelton-freelton"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "S1"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 72.1
+"OriginalEntryTimestamp": "2026-05-01T19:27:36.17Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1491507"
+"ListOfficeNationalAssociationId": "1475073"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 84
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29687429')"
+"ID": "1376307"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25462
+post_id: "1376308"
+post_author: 1
+"ListingKey": "29687209"
+"ListingId": "40826225"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T20:30:00Z"
+"RFModificationTimestamp": "2026-07-18T20:45:41Z"
+"ListPrice": 750000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.2
+"LivingArea": 1304.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B0Z3"
+"UnparsedAddress": "74 FREELTON Road, Hamilton, Ontario L8B0Z3"
+"Coordinates": array:2 [
0 => -80.0355911
1 => 43.3994793
]
+"Latitude": 43.3994793
+"Longitude": -80.0355911
+"YearBuilt": 1950
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome home to this beautifully updated 4-bedroom, 2 full-bath property that perfectly blends comfort, style, and convenience. Step inside to discover brand-new flooring throughout, enhanced by modern lighting and a fresh, neutral paint palette that creates a bright and inviting atmosphere. The updated kitchen is a true highlight, featuring contemporary finishes and ample space for cooking and gathering. With four generously sized bedrooms and two full bathrooms, there’s plenty of room for family, guests, or a home office setup. The finished basement offers versatile additional living space—perfect for a recreation room, home gym, media room, or play area. Nestled on a quiet dead-end road, this home provides added privacy and minimal traffic while still being ideally located close to parks, shopping, dining, and major highways for an easy commute. Move-in ready and thoughtfully updated, this home is ready for you to make it your own. (id:62650)"
+"Appliances": array:3 [
0 => "Refrigerator"
1 => "Stove"
2 => "Microwave"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-01T19:44:58.013035+00:00"
+"Directions": "Hwy 6 to Concession 11"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2041052"
+"ListOfficeKey": "55168"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.2"
+"PhotosChangeTimestamp": "2026-06-26T15:30:47Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T20:20:31Z"
+"Stories": "2.0"
+"StreetName": "FREELTON"
+"StreetNumber": "74"
+"StreetSuffix": "Road"
+"SubdivisionName": "043 - Flamborough West"
+"TaxAnnualAmount": "6991.81"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29687209/74-freelton-road-hamilton"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1980090"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55167"
+"GeocodeManualYN": true
+"ZoningDescription": "S1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 72.0
+"AboveGradeFinishedArea": 1304
+"OriginalEntryTimestamp": "2026-05-01T19:01:40.88Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1317017"
+"ListOfficeNationalAssociationId": "1116022"
+"CoListAgentNationalAssociationId": "1265844"
+"CoListOfficeNationalAssociationId": "1003582"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 84
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29687209')"
+"ID": "1376308"
}
]
+success: true
+page_size: 9
+page_count: 3
+count: 20
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]