array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29699073 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23524
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23526
+post_id: "1384911"
+post_author: 1
+"ListingKey": "29699073"
+"ListingId": "40826954"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-12T20:30:01Z"
+"RFModificationTimestamp": "2026-07-12T20:46:25Z"
+"ListPrice": 1839000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 1.25
+"LivingArea": 4170.0
+"BuildingAreaTotal": 0
+"City": "Freelton"
+"PostalCode": "L8B0Z6"
+"UnparsedAddress": "26 WENEIL Drive, Freelton, Ontario L8B0Z6"
+"Coordinates": array:2 [
0 => -80.0452952
1 => 43.3966118
]
+"Latitude": 43.3966118
+"Longitude": -80.0452952
+"YearBuilt": 1987
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"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:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-05T00:41:41.666341+00:00"
+"Directions": "HWY 6 TO REG RD 97 TO BROCK RD TO WENEIL DRIVE"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1523936"
+"ListOfficeKey": "292695"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Country residential"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "1.25"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-05-05T00:11:04Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-12T20:21:21Z"
+"Stories": "2.0"
+"StreetName": "WENEIL"
+"StreetNumber": "26"
+"StreetSuffix": "Drive"
+"SubdivisionName": "043 - Flamborough West"
+"TaxAnnualAmount": "9174.78"
+"VirtualTourURLUnbranded": "https://listings.monstermediahouse.com/videos/019dea69-b173-7363-84ee-1244ee64a631"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:24 [
0 => array:11 [
"RoomKey" => "1682354067"
"RoomType" => "Loft"
"ListingId" => "40826954"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => "20'7'' x 22'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.82Z"
]
1 => array:11 [
"RoomKey" => "1682354068"
"RoomType" => "Bedroom"
"ListingId" => "40826954"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 12'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.82Z"
]
2 => array:11 [
"RoomKey" => "1682354069"
"RoomType" => "3pc Bathroom"
"ListingId" => "40826954"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.82Z"
]
3 => array:11 [
"RoomKey" => "1682354070"
"RoomType" => "5pc Bathroom"
"ListingId" => "40826954"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.83Z"
]
4 => array:11 [
"RoomKey" => "1682354071"
"RoomType" => "4pc Bathroom"
"ListingId" => "40826954"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.83Z"
]
5 => array:11 [
"RoomKey" => "1682354072"
"RoomType" => "2pc Bathroom"
"ListingId" => "40826954"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.83Z"
]
6 => array:11 [
"RoomKey" => "1682354073"
"RoomType" => "Utility room"
"ListingId" => "40826954"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => "5'4'' x 4'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.83Z"
]
7 => array:11 [
"RoomKey" => "1682354074"
"RoomType" => "Storage"
"ListingId" => "40826954"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => "3'7'' x 21'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.83Z"
]
8 => array:11 [
"RoomKey" => "1682354075"
"RoomType" => "Kitchen"
"ListingId" => "40826954"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 17'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.83Z"
]
9 => array:11 [
"RoomKey" => "1682354076"
"RoomType" => "Bedroom"
"ListingId" => "40826954"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.83Z"
]
10 => array:11 [
"RoomKey" => "1682354077"
"RoomType" => "Storage"
"ListingId" => "40826954"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => "6'7'' x 8'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.83Z"
]
11 => array:11 [
"RoomKey" => "1682354078"
"RoomType" => "Dining room"
"ListingId" => "40826954"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 17'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.83Z"
]
12 => array:11 [
"RoomKey" => "1682354079"
"RoomType" => "Recreation room"
"ListingId" => "40826954"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => "25'8'' x 15'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.83Z"
]
13 => array:11 [
"RoomKey" => "1682354080"
"RoomType" => "Bedroom"
"ListingId" => "40826954"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.83Z"
]
14 => array:11 [
"RoomKey" => "1682354081"
"RoomType" => "Bedroom"
"ListingId" => "40826954"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 15'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.83Z"
]
15 => array:11 [
"RoomKey" => "1682354082"
"RoomType" => "Primary Bedroom"
"ListingId" => "40826954"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => "16'0'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.83Z"
]
16 => array:11 [
"RoomKey" => "1682354083"
"RoomType" => "Pantry"
"ListingId" => "40826954"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => "7'1'' x 3'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.83Z"
]
17 => array:11 [
"RoomKey" => "1682354084"
"RoomType" => "Sunroom"
"ListingId" => "40826954"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => "6'6'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.83Z"
]
18 => array:11 [
"RoomKey" => "1682354085"
"RoomType" => "Office"
"ListingId" => "40826954"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.83Z"
]
19 => array:11 [
"RoomKey" => "1682354086"
"RoomType" => "Foyer"
"ListingId" => "40826954"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.84Z"
]
20 => array:11 [
"RoomKey" => "1682354087"
"RoomType" => "Living room"
"ListingId" => "40826954"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 18'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.84Z"
]
21 => array:11 [
"RoomKey" => "1682354088"
"RoomType" => "Dining room"
"ListingId" => "40826954"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 18'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.84Z"
]
22 => array:11 [
"RoomKey" => "1682354089"
"RoomType" => "Kitchen"
"ListingId" => "40826954"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 15'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.84Z"
]
23 => array:11 [
"RoomKey" => "1682354090"
"RoomType" => "Laundry room"
"ListingId" => "40826954"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29699073"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-12T20:21:21.84Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29699073/26-weneil-drive-freelton"
+"ParkingTotal": 16
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "S1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 175.0
+"AboveGradeFinishedArea": 2675
+"BelowGradeFinishedArea": 1495
+"OriginalEntryTimestamp": "2026-05-05T00:09:24.81Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1117863"
+"ListOfficeNationalAssociationId": "1416139"
+"Media": array:40 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6652764175"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/351f78161f08c5d8239b403b086d865c.webp"
"MediaSize" => 103820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-351f78161f08c5d8239b403b086d865c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:04.58Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6652764264"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/8eddb9d3954146e070d90223c9ab090b.webp"
"MediaSize" => 151608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-8eddb9d3954146e070d90223c9ab090b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:01.85Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6652764376"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/2cdbdb973d3dd45b9aa10d2d1fcb50a3.webp"
"MediaSize" => 128905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-2cdbdb973d3dd45b9aa10d2d1fcb50a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:04.58Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6652764445"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/6d78d0b41524c0e82615952415735921.webp"
"MediaSize" => 132261
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-6d78d0b41524c0e82615952415735921.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:03.42Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6652764519"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/612962fa3d02bc29dcae79c5b89ada7d.webp"
"MediaSize" => 81288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-612962fa3d02bc29dcae79c5b89ada7d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:04.58Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6652764632"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/2a804cda38e6149cb39b23a5660b16bb.webp"
"MediaSize" => 100579
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-2a804cda38e6149cb39b23a5660b16bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:01.86Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6652764737"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/2b4d3e22174fa56fe74d8d2460c88102.webp"
"MediaSize" => 91191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-2b4d3e22174fa56fe74d8d2460c88102.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:01.85Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6652764822"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/7172616ac83e949b99d6c8959554b7be.webp"
"MediaSize" => 63885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-7172616ac83e949b99d6c8959554b7be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:04.58Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6652764914"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/303e3b141efa0060958c34467f2366ae.webp"
"MediaSize" => 92630
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-303e3b141efa0060958c34467f2366ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:01.86Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6652764992"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/2350e9f848015f2abc4295fc3b481de0.webp"
"MediaSize" => 82799
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-2350e9f848015f2abc4295fc3b481de0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:01.02Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6652765080"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/53bec87139f4fa0a0f71676412f6f252.webp"
"MediaSize" => 83965
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-53bec87139f4fa0a0f71676412f6f252.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:04.58Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6652765135"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/59fbe918c30c4973089bcab13b20dccb.webp"
"MediaSize" => 71736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-59fbe918c30c4973089bcab13b20dccb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:03.43Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6652765173"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/b4f38949d0cbf709261db8226849c489.webp"
"MediaSize" => 86706
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-b4f38949d0cbf709261db8226849c489.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:04.59Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "6652765227"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/bad4e9e97fbb2fe5d0d81d0f613e5bdf.webp"
"MediaSize" => 78656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-bad4e9e97fbb2fe5d0d81d0f613e5bdf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:02.62Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "6652765275"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/eca83bcbd18466db7ef3c933abb63d64.webp"
"MediaSize" => 71906
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-eca83bcbd18466db7ef3c933abb63d64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:04.58Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "6652765322"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/2540dd832e709863f9a711719fa1dbf2.webp"
"MediaSize" => 116741
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-2540dd832e709863f9a711719fa1dbf2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:03.43Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "6652765359"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/d0a7dc681b4217bbb712c7b427a3ac20.webp"
"MediaSize" => 92082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-d0a7dc681b4217bbb712c7b427a3ac20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:01.02Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "6652765389"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/d92e4c692641a61111cc4b84045db939.webp"
"MediaSize" => 60247
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-d92e4c692641a61111cc4b84045db939.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:01.03Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "6652765431"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/f821fb2891252453b5168e9a2bada691.webp"
"MediaSize" => 74758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-f821fb2891252453b5168e9a2bada691.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:01.03Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "6652765447"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/a262af685fc242efefd3b4606336ffd3.webp"
"MediaSize" => 66331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-a262af685fc242efefd3b4606336ffd3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:01.85Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "6652765457"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/012908b9a176da34032c36a12826c09b.webp"
"MediaSize" => 55073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-012908b9a176da34032c36a12826c09b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:03.42Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "6652765470"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/6346bd109e562654989587248535fe2b.webp"
"MediaSize" => 65232
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-6346bd109e562654989587248535fe2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:03.43Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "6652765482"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/d20bd3f30514c41fdb878961bfa2b566.webp"
"MediaSize" => 94193
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-d20bd3f30514c41fdb878961bfa2b566.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:01.03Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "6652765485"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/15be370fb9d6f72e8903bbe561a6151b.webp"
"MediaSize" => 82798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-15be370fb9d6f72e8903bbe561a6151b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:01.03Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "6652765499"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/8cfad06079dc205a6ec9a8e11350f08d.webp"
"MediaSize" => 60557
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-8cfad06079dc205a6ec9a8e11350f08d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:01.02Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "6652765507"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/83104190cf4609f304eca6f4dc87f13b.webp"
"MediaSize" => 71253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-83104190cf4609f304eca6f4dc87f13b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:01.85Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "6652765511"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/9382e1545d38168277b736a4116ab971.webp"
"MediaSize" => 50072
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-9382e1545d38168277b736a4116ab971.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:03.42Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "6652765519"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/47aa8adb653db73f3633cbcd45d4cb68.webp"
"MediaSize" => 60377
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-47aa8adb653db73f3633cbcd45d4cb68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:01.03Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "6652765537"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/6437d63eb3a1c6596bdb5843c4bca9af.webp"
"MediaSize" => 50923
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-6437d63eb3a1c6596bdb5843c4bca9af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:01.03Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "6652765545"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/345833cb0eed88d41e52d13dbeffe67d.webp"
"MediaSize" => 65144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-345833cb0eed88d41e52d13dbeffe67d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:01.85Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "6652765551"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/afb977fde331ed2f7372bf2fb4fd0c14.webp"
"MediaSize" => 103800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-afb977fde331ed2f7372bf2fb4fd0c14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:01.02Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "6652765556"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/c64a4bbb594d471f6cc0d8f60b902543.webp"
"MediaSize" => 116388
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-c64a4bbb594d471f6cc0d8f60b902543.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:01.85Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "6652765558"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/87c1a83dcacc0c4266a08a9d99269bc9.webp"
"MediaSize" => 176010
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-87c1a83dcacc0c4266a08a9d99269bc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:01.85Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "6652765560"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/16936d8b45193380b1e7232b498671d7.webp"
"MediaSize" => 205601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-16936d8b45193380b1e7232b498671d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:01.86Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "6652765561"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/0979940ef8611537966474ba39d412a2.webp"
"MediaSize" => 183836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-0979940ef8611537966474ba39d412a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:01.02Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "6652765562"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/4e0faea45690966f32354483f750aaed.webp"
"MediaSize" => 161857
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-4e0faea45690966f32354483f750aaed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826954"
"ResourceRecordKey" => "29699073"
"ModificationTimestamp" => "2026-05-05T00:11:01.85Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "6652765563"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29699073/e7af6cc85c641c2a127dd63005c44dc1.webp"
"MediaSize" => 176178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29699073/thumbnail-e7af6cc85c641c2a127dd63005c44dc1.webp"
…7
]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 79
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29699073')"
+"ID": "1384911"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 292695" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25022
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24966
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX Escarpment Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-631-8118"
+"OfficeMlsId": "HBRMXESCCAR2"
+"ModificationTimestamp": "2026-06-18T15:38:17Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "292695"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "1470 Centre Road #2A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Carlisle"
+"OfficePostalCode": "L0R1H"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1416139"
+"OriginalEntryTimestamp": "2022-05-11T15:43:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [ …6]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1064286"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('292695')"
}
]
+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 1523936" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24960
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29699073'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25354
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29699073' AND OpenHouseDate ge '2026-07-22'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25370
+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 '29699073' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.0452952 43.3966118)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25443
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25437
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"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 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30048666')"
+"ID": "1636044"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25439
+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": 15
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29999184')"
+"ID": "1601872"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25436
+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": 15
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29998783')"
+"ID": "1599249"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25440
+post_id: "1586168"
+post_author: 1
+"ListingKey": "29978820"
+"ListingId": "40844429"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T16:10:05Z"
+"RFModificationTimestamp": "2026-07-21T16:23:07Z"
+"ListPrice": 1289999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2622.0
+"BuildingAreaTotal": 0
+"City": "Flamborough"
+"PostalCode": "L8N2Z7"
+"UnparsedAddress": "18 FIRESIDE Drive, Flamborough, Ontario L8N2Z7"
+"Coordinates": array:2 [
0 => -80.0292408
1 => 43.3954001
]
+"Latitude": 43.3954001
+"Longitude": -80.0292408
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this exceptional executive bungalow in the highly sought-after Wildan Estates, one of Flamborough's most prestigious communities. Situated on a beautifully landscaped half-acre lot with an impressive 100-foot frontage, this extensively renovated home has a rare combination of luxury, space, and functionality. The stunning curb appeal is matched by an equally impressive interior, featuring elegant finishes, thoughtfully updated living spaces, and a fully finished basement that provides exceptional versatility for family living and entertaining. Completing this remarkable property is the highly coveted 3-car garage-an increasingly rare feature that sets this home apart. Surrounded by executive homes and just minutes from shopping, dining, schools, and major commuter routes, this is a rare opportunity to own a turnkey bungalow in one of Flamborough's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T19:33:02.860403+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130428"
+"ListOfficeKey": "284622"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-21T16:01:58Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T16:09:19Z"
+"Stories": "1.0"
+"StreetName": "FIRESIDE"
+"StreetNumber": "18"
+"StreetSuffix": "Drive"
+"SubdivisionName": "044 - Flamborough East"
+"TaxAnnualAmount": "6447.81"
+"VirtualTourURLUnbranded": "https://youriguide.com/18_fireside_dr_hamilton_on"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29978820/18-fireside-drive-flamborough"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1524741"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "284622"
+"GeocodeManualYN": true
+"ZoningDescription": "S1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 101.0
+"AboveGradeFinishedArea": 1367
+"BelowGradeFinishedArea": 1255
+"OriginalEntryTimestamp": "2026-07-02T16:33:09.35Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1383308"
+"ListOfficeNationalAssociationId": "1343471"
+"CoListAgentNationalAssociationId": "1063765"
+"CoListOfficeNationalAssociationId": "1343471"
+"Media": array:47 [
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]
]
+"DaysOnMarket": 20
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29978820')"
+"ID": "1586168"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25438
+post_id: "1583894"
+post_author: 1
+"ListingKey": "29978525"
+"ListingId": "X13512366"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T12:15:19Z"
+"RFModificationTimestamp": "2026-07-13T12:19:51Z"
+"ListPrice": 1289999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Freelton)"
+"PostalCode": "L8N2Z7"
+"UnparsedAddress": "18 FIRESIDE DRIVE, Hamilton (Freelton), Ontario L8N2Z7"
+"Coordinates": array:2 [
0 => -80.0292814
1 => 43.3953988
]
+"Latitude": 43.3953988
+"Longitude": -80.0292814
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this exceptional executive bungalow in the highly sought-after Wildan Estates, one of Flamborough's most prestigious communities. Situated on a beautifully landscaped half-acre lot with an impressive 100-foot frontage, this extensively renovated home offers a rare combination of luxury, space, and functionality. The stunning curb appeal is matched by an equally impressive interior, featuring elegant finishes, thoughtfully updated living spaces, and a fully finished basement that provides exceptional versatility for family living and entertaining. Completing this remarkable property is the highly coveted 3-car garage-an increasingly rare feature that sets this home apart. Surrounded by executive homes and just minutes from shopping, dining, schools, and major commuter routes, this is a rare opportunity to own a turnkey bungalow in one of Flamborough's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T16:42:08.945198+00:00"
+"Directions": "Cross Streets: Huntsman Gate. ** Directions: Highway 6 to Huntsman Gate to Fireside Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2024554"
+"ListOfficeKey": "284791"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "Guest Suite"
]
+"LotSizeDimensions": "100.5 x 222 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T19:46:20Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T12:09:40Z"
+"Stories": "1.0"
+"StreetName": "Fireside"
+"StreetNumber": "18"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6447.81"
+"Utilities": array:1 [
0 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/18_fireside_dr_hamilton_on"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Freelton"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29978525/18-fireside-drive-hamilton-freelton-freelton"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1989469"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "284791"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 100.6
+"OriginalEntryTimestamp": "2026-07-02T15:58:06.63Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1304294"
+"ListOfficeNationalAssociationId": "1344890"
+"CoListAgentNationalAssociationId": "1273410"
+"CoListOfficeNationalAssociationId": "1344890"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 20
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29978525')"
+"ID": "1583894"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25413
+post_id: "1573024"
+post_author: 1
+"ListingKey": "29948731"
+"ListingId": "40842785"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T20:45:03Z"
+"RFModificationTimestamp": "2026-07-21T20:49:04Z"
+"ListPrice": 1775000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 5.56
+"LivingArea": 2544.0
+"BuildingAreaTotal": 0
+"City": "Puslinch"
+"PostalCode": "N0B2J0"
+"UnparsedAddress": "1048 REGIONAL ROAD 97, Puslinch, Ontario N0B2J0"
+"Coordinates": array:2 [
0 => -80.0637621
1 => 43.3918666
]
+"Latitude": 43.3918666
+"Longitude": -80.0637621
+"YearBuilt": 1860
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Step into history at 1048 Regional Road 97 — an 1860 rare blonde brick home in the Puslinch area, part of the region's early settlement and older than Canada itself, set on over 5.5 picturesque acres. A long driveway leads to a gracious front porch, refurbished in 2021, welcoming you into 2,544 square feet of living space. Inside, four bedrooms and two full bathrooms pair original character with everyday comfort. A large living room showcases an original fireplace mantle and decorative cove moldings, while a gracious dining room opens to a private outdoor patio. The bright, spacious main floor family room offers easy access and connection to the outdoors, and a kitchen addition brings a wood burning stove for added warmth. Modern amenities include main floor laundry, and the primary bedroom includes an adjoining room ideal as a dressing room, nursery or office. Beyond the front door, the property unfolds into a true four-season lifestyle. A barn and pasture awaits those dreaming of a hobby farm, while a sugar shack and network of cut trails invite maple syrup tradition and quiet walks through your own woods. Cool off in the in-ground pool, unwind in the hot tub and enjoy beautifully landscaped grounds that make every season feel like a retreat. Rarely does a property combine this much heritage with this much lifestyle. 1048 Regional Road 97 is 5.5 acres of history, comfort and possibility, all your own. Don’t be TOO LATE*! *REG TM. RSA. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Freezer"
8 => "Window Coverings"
9 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-25T19:49:42.820203+00:00"
+"Directions": "Hwy 6 to Regional Rd 97"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Country residential"
]
+"LotSizeDimensions": "5.56"
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-21T20:43:02Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T20:43:02Z"
+"Stories": "1.5"
+"StreetName": "REGIONAL ROAD 97"
+"StreetNumber": "1048"
+"SubdivisionName": "045 - Beverly"
+"TaxAnnualAmount": "3014.3"
+"Utilities": array:2 [
0 => "Electricity"
1 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/019eff47-9289-700a-b6c6-61abf2b7bd99"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29948731/1048-regional-road-97-puslinch"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "A1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 561.0
+"AboveGradeFinishedArea": 2544
+"OriginalEntryTimestamp": "2026-06-24T19:51:09.42Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063673"
+"ListOfficeNationalAssociationId": "1424570"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 28
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29948731')"
+"ID": "1573024"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23538
+post_id: "1561152"
+post_author: 1
+"ListingKey": "29949611"
+"ListingId": "X13486006"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-14T01:15:03Z"
+"RFModificationTimestamp": "2026-07-14T01:16:28Z"
+"ListPrice": 1775000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "N0B2J0"
+"UnparsedAddress": "1048 REGIONAL ROAD 97, Hamilton, Ontario N0B2J0"
+"Coordinates": array:2 [
0 => -80.063932
1 => 43.391704
]
+"Latitude": 43.391704
+"Longitude": -80.063932
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Step into history at 1048 Regional Road 97 - an 1860 rare blonde brick home in the Puslinch area, part of the region's early settlement and older than Canada itself, set on over 5.5 picturesque acres. A long driveway leads to a gracious front porch, refurbished in 2021, welcoming you into 2,544 square feet of living space. Inside, four bedrooms and two full bathrooms pair original character with everyday comfort. A large living room showcases an original fireplace mantle and decorative cove moldings, while a gracious dining room opens to a private outdoor patio. The bright, spacious main floor family room offers easy access and connection to the outdoors, and a kitchen addition brings a wood burning stove for added warmth. Modern amenities include main floor laundry, and the primary bedroom includes an adjoining room ideal as a dressing room, nursery or office. Beyond the front door, the property unfolds into a true four-season lifestyle. A barn and pasture awaits those dreaming of a hobby farm, while a sugar shack and network of cut trails invite maple syrup tradition and quiet walks through your own woods. Cool off in the in-ground pool, unwind in the hot tub and enjoy beautifully landscaped grounds that make every season feel like a retreat. Rarely does a property combine this much heritage with this much lifestyle. 1048 Regional Road 97 is 5.5 acres of history, comfort and possibility, all your own. RSA. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Range"
6 => "Dryer"
7 => "Microwave"
8 => "Freezer"
9 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-25T18:58:52.778066+00:00"
+"Directions": "HWY 6 TO REGIONAL RD 97"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Pellet"
1 => "Stove"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:2 [
0 => "Stone"
1 => "Concrete"
]
+"Heating": array:1 [
0 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1979013"
+"ListOfficeKey": "293273"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Wooded area"
1 => "Irregular lot size"
2 => "Solar Equipment"
]
+"LotSizeDimensions": "561 x 435 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T22:17:44Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-14T01:07:50Z"
+"Stories": "1.5"
+"StreetName": "REGIONAL ROAD 97"
+"StreetNumber": "1048"
+"TaxAnnualAmount": "3014.3"
+"Utilities": array:3 [
0 => "Electricity"
1 => "Telephone"
2 => "Electricity Connected"
]
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/019eff47-9289-700a-b6c6-61abf2b7bd99"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"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/29949611/1048-regional-road-97-hamilton-rural-flamborough"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"PropertyCondition": array:1 [
0 => "Insulation upgraded"
]
+"ZoningDescription": "A1"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 561.0
+"OriginalEntryTimestamp": "2026-06-24T22:17:44.02Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1264940"
+"ListOfficeNationalAssociationId": "1424812"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 28
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29949611')"
+"ID": "1561152"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25441
+post_id: "1518874"
+post_author: 1
+"ListingKey": "29887661"
+"ListingId": "X13430244"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-22T17:00:01Z"
+"RFModificationTimestamp": "2026-07-22T17:07:15Z"
+"ListPrice": 1099900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Freelton)"
+"PostalCode": "L8N2Z7"
+"UnparsedAddress": "12 HUNTSMAN GATE, Hamilton (Freelton), Ontario L8N2Z7"
+"Coordinates": array:2 [
0 => -80.027284
1 => 43.395783
]
+"Latitude": 43.395783
+"Longitude": -80.027284
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to this lovely raised bungalow set on a beautiful half acre lot with mature landscaping, perennial gardens, armour stone accents, and plenty of outdoor space to enjoy. The main level offers 3 bedrooms and a bright and functional layout, including a recently updated large eat-in kitchen with a skylight that fills the space with natural light and tons of storage. The front living room adds incredible everyday living space and the spacious family room addition at the back of the home features a vaulted ceiling, cozy gas fireplace, and two walk-outs to the expansive backyard. With room for a pool, gardens, play space, or outdoor entertaining, the yard offers the kind of space that is becoming harder to find. The lower level provides in-law potential with a separate entrance at grade level, two bedrooms, a living room, large eat-in kitchen, full bathroom, and separate laundry. Outside, the large detached 2 car garage includes a workshop, pellet stove, hydro, seasonal water, a separate office area, and loft space adding extra space and value to this home. Whether you need room for hobbies, storage, a home-based workspace, or a serious workshop setup, this property offers options that go well beyond the typical home. A rare opportunity to enjoy space, flexibility, and country-style living while still having the convenience of a functional family home. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
5 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T15:56:31.408440+00:00"
+"Directions": "Hwy 6/Huntsman Gate"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Flooring": array:1 [
0 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Radiant heat"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1878733"
+"ListOfficeKey": "205333"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In-Law Suite"
]
+"LotSizeDimensions": "106 x 200 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T13:25:54Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-22T16:54:49Z"
+"Stories": "1.0"
+"StreetName": "Huntsman"
+"StreetNumber": "12"
+"StreetSuffix": "Gate"
+"TaxAnnualAmount": "7295.87"
+"Utilities": array:1 [
0 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://drive.google.com/file/d/1a9oJoIBmUj-6_EcsnzD1SrM-xdnqD6c2/view?usp=share_link"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"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": "Oakville-Milton"
+"TaxYear": 2025
+"CityRegion": "Freelton"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29887661/12-huntsman-gate-hamilton-freelton-freelton"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 106.0
+"OriginalEntryTimestamp": "2026-06-11T13:25:53.96Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1205228"
+"ListOfficeNationalAssociationId": "1114796"
+"Media": array:47 [
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]
]
+"DaysOnMarket": 41
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29887661')"
+"ID": "1518874"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25442
+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": 54
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29824354')"
+"ID": "1476426"
}
]
+success: true
+page_size: 9
+page_count: 3
+count: 26
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]