array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29081596 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: "943624"
+post_author: 1
+"ListingKey": "29081596"
+"ListingId": "40786479"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-23T21:40:57Z"
+"RFModificationTimestamp": "2025-11-23T21:43:08Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1686.0
+"BuildingAreaTotal": 0
+"City": "Freelton"
+"PostalCode": "L0R1K0"
+"UnparsedAddress": "57 12TH Concession, Freelton, Ontario L0R1K0"
+"Coordinates": array:2 [
0 => -80.0436629
1 => 43.4123253
]
+"Latitude": 43.4123253
+"Longitude": -80.0436629
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
+"PublicRemarks": "Introducing your dream 4 season retreat in a charming resort community for 50+ homeowners. Nestled within the serene area of North Hamilton lies a delightful haven that is waiting to welcome you home. This immaculate residence has recently undergone a stunning transformation, ensuring that it's not just a house; it's a lifestyle upgrade! Low Monthly fees and an array of premium amenities, makes this offering both luxurious and affordable with an indoor/outdoor pool, fitness room, tiki bar, picturesque pond, and scenic walking trails. Every day feels like a vacation! This two-story gem boasts 3 generously sized bedrooms, 2 bathrooms, central vac and balconies off the second floor perfect for relaxation and rejuvenation. The upper sunroom/walk-in closet room is bathed in natural light, offering a tranquil space for reflection. Luxuriate in a washroom adorned with a new tub/shower and heated floors, creating a spa-like oasis. interior comfort with forced air gas and central AC. The home features all-new flooring, freshly painted walls and ceilings, and plush Berber stairs for ultimate comfort. Modern charm meets functionality with new kitchen appliances and updated lighting fixtures in the hall, dining room, and washrooms. Decorated in warm neutral tones, this home exudes an inviting and cozy ambiance, making you feel instantly at ease. The attached garage ensures hassle-free parking and additional storage space. A rear storage shed is at your disposal for gardening supplies and more. Stay connected all year round with cable, internet, and Wi-Fi services. Condo fees encompass water, water testing, road maintenance, pool upkeep, and more, streamlining your life. You'll be part of a welcoming and vibrant community, where making friends is effortless. Pets are permitted. Host bonfires and BBQs in your own yard, creating unforgettable moments with loved ones. Year round living. Property backs onto beautiful waterfront stream. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Central Vacuum - Roughed In"
5 => "Window Coverings"
]
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Crawl space"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"CreationDate": "2025-11-07T22:32:32.959487+00:00"
+"Directions": "12th concession off Highway 6"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1987928"
+"ListOfficeKey": "291581"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Country residential"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-07T19:55:32Z"
+"PhotosCount": 31
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"Sewer": array:1 [
0 => "Holding Tank"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-23T21:25:10Z"
+"Stories": "1.5"
+"StreetName": "12TH"
+"StreetNumber": "57"
+"StreetSuffix": "Concession"
+"SubdivisionName": "044 - Flamborough East"
+"View": "View of water"
+"WaterSource": array:1 [
0 => "Community Water System"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1538873743"
"RoomType" => "2pc Bathroom"
"ListingId" => "40786479"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29081596"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-23T21:25:10.15Z"
]
1 => array:11 [
"RoomKey" => "1538873744"
"RoomType" => "3pc Bathroom"
"ListingId" => "40786479"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29081596"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-23T21:25:10.15Z"
]
2 => array:11 [
"RoomKey" => "1538873745"
"RoomType" => "Sunroom"
"ListingId" => "40786479"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29081596"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 17'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-23T21:25:10.15Z"
]
3 => array:11 [
"RoomKey" => "1538873746"
"RoomType" => "Bedroom"
"ListingId" => "40786479"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29081596"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 16'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-23T21:25:10.15Z"
]
4 => array:11 [
"RoomKey" => "1538873747"
"RoomType" => "Bedroom"
"ListingId" => "40786479"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29081596"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-23T21:25:10.15Z"
]
5 => array:11 [
"RoomKey" => "1538873748"
"RoomType" => "Bedroom"
"ListingId" => "40786479"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29081596"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-23T21:25:10.15Z"
]
6 => array:11 [
"RoomKey" => "1538873749"
"RoomType" => "Kitchen"
"ListingId" => "40786479"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29081596"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-23T21:25:10.15Z"
]
7 => array:11 [
"RoomKey" => "1538873750"
"RoomType" => "Dining room"
"ListingId" => "40786479"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29081596"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-23T21:25:10.15Z"
]
8 => array:11 [
"RoomKey" => "1538873751"
"RoomType" => "Living room"
"ListingId" => "40786479"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29081596"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 20'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-23T21:25:10.16Z"
]
]
+"ListAOR": "Brantford"
+"ListAORKey": "41"
+"ListingURL": "www.realtor.ca/real-estate/29081596/57-12th-concession-freelton"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Leasehold"
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1686
+"OriginalEntryTimestamp": "2025-11-07T19:55:31.84Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6316965957"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/ae46ec0b6f9dd7d853269a928d43621c.webp"
"MediaSize" => 231268
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-ae46ec0b6f9dd7d853269a928d43621c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6316965962"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/402d22844e70cb2bc91fc704ad78dcdc.webp"
"MediaSize" => 216694
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-402d22844e70cb2bc91fc704ad78dcdc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6316965966"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/d56c5250014386027828d6f86049ac1d.webp"
"MediaSize" => 261379
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-d56c5250014386027828d6f86049ac1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6316965968"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/d9e18e38ee666c1a6a433a6caa5a37ec.webp"
"MediaSize" => 256685
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-d9e18e38ee666c1a6a433a6caa5a37ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6316965974"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/0c739856ce350484ef32566d9d958763.webp"
"MediaSize" => 160574
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-0c739856ce350484ef32566d9d958763.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6316965982"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/2f9d900a7db03972d73177c198f0b595.webp"
"MediaSize" => 151323
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-2f9d900a7db03972d73177c198f0b595.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6316965987"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/dcc9f1040fbe041a937d86ad143e3772.webp"
"MediaSize" => 166008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-dcc9f1040fbe041a937d86ad143e3772.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6316965991"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/0904986bc57d5d79047112e47b89cf9b.webp"
"MediaSize" => 84118
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-0904986bc57d5d79047112e47b89cf9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6316965993"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/7af9a4398570fc03d10cf5eed2aa8ab3.webp"
"MediaSize" => 99996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-7af9a4398570fc03d10cf5eed2aa8ab3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6316965996"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/f1e4593ffa6a1e60ea652ff1ccb338fb.webp"
"MediaSize" => 83346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-f1e4593ffa6a1e60ea652ff1ccb338fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6316966001"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/7b6b100dfe477ec79cc62d716092b748.webp"
"MediaSize" => 98900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-7b6b100dfe477ec79cc62d716092b748.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6316966003"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/8beefe7e64d6c3f25904ec19a852d084.webp"
"MediaSize" => 124424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-8beefe7e64d6c3f25904ec19a852d084.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6316966006"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/fe760b43d9e7c3e57d178b88e7d81b57.webp"
"MediaSize" => 109729
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-fe760b43d9e7c3e57d178b88e7d81b57.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "6316966009"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/d90999b61f95fcb5c34adf4e904fb454.webp"
"MediaSize" => 97961
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-d90999b61f95fcb5c34adf4e904fb454.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "6316966012"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/1f900399701b722362a5a38e91a3d4c4.webp"
"MediaSize" => 123173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-1f900399701b722362a5a38e91a3d4c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "6316966016"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/20314c0a2c72c5f771eb93565aaa0d4f.webp"
"MediaSize" => 86837
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-20314c0a2c72c5f771eb93565aaa0d4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "6316966019"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/9ef56661e51a795fc303cea12456c7e6.webp"
"MediaSize" => 76031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-9ef56661e51a795fc303cea12456c7e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "6316966021"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/3e236c52f1fbcfff91249c54d96d29d0.webp"
"MediaSize" => 83387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-3e236c52f1fbcfff91249c54d96d29d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "6316966023"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/3bb251d8f491e4900b4f543b7aaf4401.webp"
"MediaSize" => 119564
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-3bb251d8f491e4900b4f543b7aaf4401.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "6316966025"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/97f1770cd19cc15204c33896b306cc25.webp"
"MediaSize" => 93725
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-97f1770cd19cc15204c33896b306cc25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "6316966027"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/4c2f6ee4676f9dd54e619cbeae5b5707.webp"
"MediaSize" => 87578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-4c2f6ee4676f9dd54e619cbeae5b5707.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "6316966029"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/ce45452fa05e545a6b4eec540342a73d.webp"
"MediaSize" => 64735
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-ce45452fa05e545a6b4eec540342a73d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "6316966031"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/b5678d68e68be0a887a1ca68add32995.webp"
"MediaSize" => 116934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-b5678d68e68be0a887a1ca68add32995.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "6316966033"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/cfa8a55da7219ae6ad6c23b64fd6d2d5.webp"
"MediaSize" => 132426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-cfa8a55da7219ae6ad6c23b64fd6d2d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "6316966035"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/7b9ae047747435c62d23342d01a81dd5.webp"
"MediaSize" => 105905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-7b9ae047747435c62d23342d01a81dd5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "6316966037"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/94da16b12dc432cc25bd2e460b6a8731.webp"
"MediaSize" => 99867
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-94da16b12dc432cc25bd2e460b6a8731.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "6316966039"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/ccd4aa69b29e9b93a0e910cc9e5a1015.webp"
"MediaSize" => 93150
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-ccd4aa69b29e9b93a0e910cc9e5a1015.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "6316966042"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/78962193c5c9f31a9657246afdd907c6.webp"
"MediaSize" => 89238
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-78962193c5c9f31a9657246afdd907c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "6316966045"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/bb9b5a0b41080c380e8e34b36c41d46d.webp"
"MediaSize" => 131613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-bb9b5a0b41080c380e8e34b36c41d46d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "6316966048"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/982ff7c1ee1a1562f83c84d99d35cc1b.webp"
"MediaSize" => 112323
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-982ff7c1ee1a1562f83c84d99d35cc1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "6316966052"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29081596/ad1e258933f65f8e6c4a2ff65743f683.webp"
"MediaSize" => 105952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29081596/thumbnail-ad1e258933f65f8e6c4a2ff65743f683.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786479"
"ResourceRecordKey" => "29081596"
"ModificationTimestamp" => "2025-11-07T19:55:31.85Z"
]
]
+"DaysOnMarket": 260
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29081596')"
+"ID": "943624"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 291581" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25067
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25010
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage Brant Realty"
+"OfficeEmail": null
+"OfficePhone": "519-759-6800"
+"OfficeMlsId": "BR22000241"
+"ModificationTimestamp": "2026-03-03T12:05:49Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "291581"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "80 Brant Avenue, Suite 1001-UnitA"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Brantford"
+"OfficePostalCode": "N3T3H1"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Brantford"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1400487"
+"OriginalEntryTimestamp": "2021-10-29T15:14:00Z"
+"OfficeAORKey": "41"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "7532"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "291581"
"SocialMediaUrlOrId" => "http://royallepagebrantrealty.com/"
"ModificationTimestamp" => "2023-04-04T15:53:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1238374"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('291581')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1987928" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25090
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29081596'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25384
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29081596' AND OpenHouseDate ge '2026-07-25'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25505
+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 '29081596' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.0436629 43.4123253)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25418
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25412
+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
…9
]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30048666')"
+"ID": "1636044"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25414
+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": 18
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29999184')"
+"ID": "1601872"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25411
+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": 18
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29998783')"
+"ID": "1599249"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25415
+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": 44
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29888715')"
+"ID": "1527578"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25413
+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": 57
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29824354')"
+"ID": "1476426"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25408
+post_id: "1468075"
+post_author: 1
+"ListingKey": "29815854"
+"ListingId": "40834300"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T16:20:07Z"
+"RFModificationTimestamp": "2026-06-10T16:25:41Z"
+"ListPrice": 1529000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3832.0
+"BuildingAreaTotal": 0
+"City": "Flamborough"
+"PostalCode": "L8B0Z4"
+"UnparsedAddress": "4 PETER Street, Hamilton, Ontario L8B0Z4"
+"Coordinates": array:2 [
0 => -80.0379041
1 => 43.3971908
]
+"Latitude": 43.3971908
+"Longitude": -80.0379041
+"YearBuilt": 1967
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "*** For more information, please click Brochure button. *** You’ll fall in love with this beautifully renovated family forever home. Located in Freelton just 10 mins from 401/403 and 20 minutes to Burlington, Cambridge, Guelph, Milton. This two-storey home blends beautiful country charm with timeless modern updates. With over 3,800 sq ft of carpet-free living space this home features a bright open-concept main floor that seamlessly connects the kitchen, living, and dining areas, perfect for everyday living and entertaining. Rebuilt from the studs in 2010 and extensively upgraded in 2022 with over $200K in renos. The kitchen features professionally refinished cabinetry with elegant gold hardware and quartz countertops, which continue throughout all three bathrooms. Rich hardwood flooring adds warmth and timeless appeal throughout. Main level includes a 4th bedroom and convenient laundry, as well as a flexible bonus room with walkout to the back deck. Upstairs offers three spacious bedrooms and a five-piece luxury bathroom, as well as a primary 4 pc ensuite with walk-in closet. As a bonus, the convenient side entrance provides access to both the main floor and a fully finished basement with an additional bedroom, providing seamless in-law suite potential. The basement also features a rough-in for a bathroom, a large theater/recreation area, a gas fireplace, and a gym. The backyard features a private outdoor oasis with a pool, hot tub, and two large decks, and new fencing and landscaping. Includes 2 large powered storage sheds. 200AMP service. New Kitchen, Quartz Counters & appliances-2022 Wide plank Hardwood floors on 1st & 2nd levels-2022 -Fence and Landscaping-2022 Above-grnd Pool/Deck/Hot Tub-2022 Roof & Furnace 2010 Septic 2020. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Central Vacuum"
5 => "Gas stove(s)"
6 => "Range - Gas"
7 => "Dishwasher"
8 => "Dryer"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "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-28T04:33:08.962747+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2220194"
+"ListOfficeKey": "296937"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Corner Site"
1 => "Country residential"
2 => "Gazebo"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"NumberOfUnitsTotal": "2"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-05-28T02:01:17Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T16:10:56Z"
+"Stories": "2.0"
+"StreetName": "PETER"
+"StreetNumber": "4"
+"StreetSuffix": "Street"
+"SubdivisionName": "043 - Flamborough West"
+"TaxAnnualAmount": "6739"
+"Utilities": array:1 [
0 => "Cable"
]
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:15 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29815854/4-peter-street-flamborough"
+"ParkingTotal": 12
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "S1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 132.0
+"AboveGradeFinishedArea": 2509
+"BelowGradeFinishedArea": 1323
+"OriginalEntryTimestamp": "2026-05-28T02:01:17.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1464325"
+"ListOfficeNationalAssociationId": "1464303"
+"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": 59
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29815854')"
+"ID": "1468075"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23598
+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": 67
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29774048')"
+"ID": "1437889"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25416
+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": 67
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29773891')"
+"ID": "1437796"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25417
+post_id: "1385159"
+post_author: 1
+"ListingKey": "29699311"
+"ListingId": "X13081720"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T12:15:05Z"
+"RFModificationTimestamp": "2026-07-13T12:20:44Z"
+"ListPrice": 1839000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Freelton)"
+"PostalCode": "L8B0Z6"
+"UnparsedAddress": "26 WENEIL DRIVE, Hamilton (Freelton), Ontario L8B0Z6"
+"Coordinates": array:2 [
0 => -80.0448934
1 => 43.3966219
]
+"Latitude": 43.3966219
+"Longitude": -80.0448934
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 26 Weneil, Freelton: your turn-key, 4+1 bedroom private oasis situated in a sought-after family-friendly community. This completely renovated residence sits on a private 1+ acre lot, offering unparalleled tranquillity as it backs directly onto green space. Step inside the spectacular open-concept main level designed for effortless entertaining, featuring a beautiful kitchen with a central island and a great room that flows into an inviting sunroom. Practicality meets elegance with a main-floor laundry room offering deck access, a mudroom, and a 2-piece powder room. Ascend the open staircase with sleek glass rails to find three spacious bedrooms and a primary retreat defined by its serene, spa-like ensuite. The fully finished lower level is incredibly versatile, providing a large recreation space for family movie nights and a separate in-law suite, complete with a kitchenette, dining area, additional bedroom, and 3-piece bath. Completing this exceptional package is the detached two-car garage, featuring a finished loft space above, perfect for a private home gym or dedicated office. Outside, enjoy a beautifully landscaped yard with a covered seating area, a second deck, and a fire pit, providing year-round entertainment. Absolutely turn-key, this home is waiting for you! Let's get you home! (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
6 => "Blinds"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
10 => "Two Refrigerators"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-05T02:25:46.834523+00:00"
+"Directions": "Cross Streets: HWY 6 and Brock Rd. ** Directions: HWY 6 TO REG RD 97 TO BROCK RD TO WENEIL DR."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2025311"
+"ListOfficeKey": "292715"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Gazebo"
]
+"LotSizeDimensions": "174.7 x 311.7 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-05-05T01:15:27Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T12:07:43Z"
+"Stories": "2.0"
+"StreetName": "Weneil"
+"StreetNumber": "26"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "9174.78"
+"VirtualTourURLUnbranded": "https://listings.monstermediahouse.com/videos/019dea69-b173-7363-84ee-1244ee64a631"
+"Rooms": array:23 [
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]
20 => array:11 [ …11]
21 => array:11 [ …11]
22 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Freelton"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29699311/26-weneil-drive-hamilton-freelton-freelton"
+"ParkingTotal": 16
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "S1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 174.8
+"OriginalEntryTimestamp": "2026-05-05T01:15:27.26Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1304991"
+"ListOfficeNationalAssociationId": "1416399"
+"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": 82
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29699311')"
+"ID": "1385159"
}
]
+success: true
+page_size: 9
+page_count: 3
+count: 25
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]