array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29882612 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1515086"
+post_author: 1
+"ListingKey": "29882612"
+"ListingId": "40838499"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T18:00:11Z"
+"RFModificationTimestamp": "2026-06-10T18:00:30Z"
+"ListPrice": 729000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2267.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G2E1"
+"UnparsedAddress": "24 GRANDE Avenue, Stoney Creek, Ontario L8G2E1"
+"Coordinates": array:2 [
0 => -79.7681199
1 => 43.2213489
]
+"Latitude": 43.2213489
+"Longitude": -79.7681199
+"YearBuilt": 1957
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Fantastic property in the heart of Stoney Creek. Located minutes from the Stoney Creek GO Station and Niagara Escarpment trails. This home offers the perfect blend of community and convenience. Step inside the freshly painted main floor featuring a family friendly layout. The living room boasts a vaulted ceiling & cozy gas fireplace, bright kitchen with built in appliances, pot & pan drawers and ample cabinetry, convenient main floor primary bedroom, plus two additional spacious bedrooms upstairs also featuring vaulted ceilings and ample windows. Finished basement with a separate entrance. Outside the concrete double driveway & walkway lead to a private backyard retreat. Patio doors open to a spacious deck equipped with a fire table and gas BBQ perfect for hosting. The showstopping feature is the fenced inground pool at the back of the property, boasting a gazebo and a handy storage shed. Turn key living and your ultimate summer staycation await! (id:62650)"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T17:39:03.477522+00:00"
+"Directions": "Orlanda Rd to Grande"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1593819"
+"ListOfficeKey": "55005"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T17:09:51Z"
+"PhotosCount": 47
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T17:50:57Z"
+"Stories": "2.0"
+"StreetName": "GRANDE"
+"StreetNumber": "24"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "280 - Corman/Greenford"
+"TaxAnnualAmount": "5092"
+"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/sites/24-grande-ave-hamilton-on-l8g-2e1-25515903/branded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1656391587"
"RoomType" => "3pc Bathroom"
"ListingId" => "40838499"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29882612"
"RoomLength" => null
"RoomDimensions" => "5'9'' x 8'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T17:50:57.72Z"
]
1 => array:11 [
"RoomKey" => "1656391588"
"RoomType" => "Laundry room"
"ListingId" => "40838499"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29882612"
"RoomLength" => null
"RoomDimensions" => "8' x 8'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T17:50:57.72Z"
]
2 => array:11 [
"RoomKey" => "1656391589"
"RoomType" => "Office"
"ListingId" => "40838499"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29882612"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 18'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T17:50:57.72Z"
]
3 => array:11 [
"RoomKey" => "1656391590"
"RoomType" => "Family room"
"ListingId" => "40838499"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29882612"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 21'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T17:50:57.72Z"
]
4 => array:11 [
"RoomKey" => "1656391591"
"RoomType" => "Bedroom"
"ListingId" => "40838499"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29882612"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T17:50:57.72Z"
]
5 => array:11 [
"RoomKey" => "1656391592"
"RoomType" => "Bedroom"
"ListingId" => "40838499"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29882612"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T17:50:57.72Z"
]
6 => array:11 [
"RoomKey" => "1656391593"
"RoomType" => "4pc Bathroom"
"ListingId" => "40838499"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29882612"
"RoomLength" => null
"RoomDimensions" => "5'10'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T17:50:57.72Z"
]
7 => array:11 [
"RoomKey" => "1656391594"
"RoomType" => "Primary Bedroom"
"ListingId" => "40838499"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29882612"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T17:50:57.72Z"
]
8 => array:11 [
"RoomKey" => "1656391595"
"RoomType" => "Living room"
"ListingId" => "40838499"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29882612"
"RoomLength" => null
"RoomDimensions" => "13'8'' x 16'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T17:50:57.73Z"
]
9 => array:11 [
"RoomKey" => "1656391596"
"RoomType" => "Dining room"
"ListingId" => "40838499"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29882612"
"RoomLength" => null
"RoomDimensions" => "8'7'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T17:50:57.73Z"
]
10 => array:11 [
"RoomKey" => "1656391597"
"RoomType" => "Kitchen"
"ListingId" => "40838499"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29882612"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 14'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T17:50:57.73Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29882612/24-grande-avenue-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1999578"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "288925"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 56.0
+"AboveGradeFinishedArea": 1324
+"BelowGradeFinishedArea": 943
+"OriginalEntryTimestamp": "2026-06-10T16:32:40.18Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Appraiser"
+"BelowGradeFinishedAreaSource": "Appraiser"
+"ListAgentNationalAssociationId": "1125285"
+"ListOfficeNationalAssociationId": "1003711"
+"CoListAgentNationalAssociationId": "1281955"
+"CoListOfficeNationalAssociationId": "1372539"
+"Media": array:47 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29882612_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/c936ffa4e19612be155f2787c18b5824.webp"
"MediaSize" => 150014
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-c936ffa4e19612be155f2787c18b5824.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:45.27Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29882612_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/d59f6abecbd758debcc1a3ae2c2aca25.webp"
"MediaSize" => 126277
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-d59f6abecbd758debcc1a3ae2c2aca25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:49.03Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29882612_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/bbf0d068e14aed2a861520eadae27c01.webp"
"MediaSize" => 151383
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-bbf0d068e14aed2a861520eadae27c01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:44.98Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29882612_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/3088209e888ebe7e0ed49df56bda3e46.webp"
"MediaSize" => 77852
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-3088209e888ebe7e0ed49df56bda3e46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:43.31Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29882612_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/ffb8188110f4c2884bc5fe8b6abc85b0.webp"
"MediaSize" => 97142
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-ffb8188110f4c2884bc5fe8b6abc85b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:49.08Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29882612_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/dd2bf382e5fa981bf590d0c1bb9390d3.webp"
"MediaSize" => 83084
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-dd2bf382e5fa981bf590d0c1bb9390d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:49.05Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29882612_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/8a13f8cfab3065455a15443447973b16.webp"
"MediaSize" => 84419
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-8a13f8cfab3065455a15443447973b16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:49.03Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29882612_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/6d0377672111d86e5903474c0e7b5704.webp"
"MediaSize" => 41614
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-6d0377672111d86e5903474c0e7b5704.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:45.01Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29882612_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/124643b550a1906dd829435268ac2564.webp"
"MediaSize" => 53623
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-124643b550a1906dd829435268ac2564.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:45.46Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29882612_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/b4fa7c528ecd6066e02b0f142ebfa60f.webp"
"MediaSize" => 55879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-b4fa7c528ecd6066e02b0f142ebfa60f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:44.99Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29882612_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/8225e078bbdda112470a16a05428f7d4.webp"
"MediaSize" => 52730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-8225e078bbdda112470a16a05428f7d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:44.98Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29882612_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/792e4cf826c308d9fd496260e61d74e6.webp"
"MediaSize" => 49693
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-792e4cf826c308d9fd496260e61d74e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:43.32Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29882612_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/948032042432545157fb5345c8d9ab8c.webp"
"MediaSize" => 57987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-948032042432545157fb5345c8d9ab8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:43.32Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29882612_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/bd5b5cd98732b7dfb17baa231f8a89a3.webp"
"MediaSize" => 82009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-bd5b5cd98732b7dfb17baa231f8a89a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:44.99Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29882612_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/4366b5ed71f31d101a287f5380ccad9c.webp"
"MediaSize" => 78018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-4366b5ed71f31d101a287f5380ccad9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:45.25Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29882612_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/cddc5e577e796832fba0de311a95f35c.webp"
"MediaSize" => 80996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-cddc5e577e796832fba0de311a95f35c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:43.14Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29882612_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/e33f756b5ed20e3f5f20e4e8c526926b.webp"
"MediaSize" => 52925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-e33f756b5ed20e3f5f20e4e8c526926b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:43.3Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29882612_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/e3812a7e5ee35f2735a05bf7cb902fdd.webp"
"MediaSize" => 48420
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-e3812a7e5ee35f2735a05bf7cb902fdd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:49.02Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29882612_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/f3815fbb443e432ed95521cf6432d0ab.webp"
"MediaSize" => 49896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-f3815fbb443e432ed95521cf6432d0ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:45.25Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29882612_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/d08f867781ea0c084e4d1b82ad129034.webp"
"MediaSize" => 44875
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-d08f867781ea0c084e4d1b82ad129034.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:45Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29882612_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/cbcf66e2201f2872b7f6683654897031.webp"
"MediaSize" => 73433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-cbcf66e2201f2872b7f6683654897031.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:43.14Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29882612_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/3904cc775e2516e7f28743f2f5b22757.webp"
"MediaSize" => 75286
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-3904cc775e2516e7f28743f2f5b22757.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:45Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29882612_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/9f84dd4932a907f7d0078a28130e719f.webp"
"MediaSize" => 73991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-9f84dd4932a907f7d0078a28130e719f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:43.79Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29882612_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/93d74799a7be6bcdee8222afab9144ab.webp"
"MediaSize" => 77278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-93d74799a7be6bcdee8222afab9144ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:43.32Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29882612_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/b0e3c1680c008d91da79f0a3210ff2d2.webp"
"MediaSize" => 80136
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-b0e3c1680c008d91da79f0a3210ff2d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:49.02Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29882612_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/46bfb047b8d30cee75df3db8e757413e.webp"
"MediaSize" => 71524
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-46bfb047b8d30cee75df3db8e757413e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:48.86Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29882612_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/2557815b096b36965fc49039dee9af2b.webp"
"MediaSize" => 50333
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-2557815b096b36965fc49039dee9af2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:49.02Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29882612_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/c5eaf651589632f26f4eadb988413eb4.webp"
"MediaSize" => 58311
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-c5eaf651589632f26f4eadb988413eb4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:45.25Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29882612_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/4e8ea1d9633f7ebe52eed4d237c4380e.webp"
"MediaSize" => 74069
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-4e8ea1d9633f7ebe52eed4d237c4380e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:49.06Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29882612_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/5401089ce58a4994d66c2387c5c38806.webp"
"MediaSize" => 77653
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-5401089ce58a4994d66c2387c5c38806.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:45Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29882612_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/f59fd0c6952656038763d9bfe70640f4.webp"
"MediaSize" => 64333
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-f59fd0c6952656038763d9bfe70640f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:49.03Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29882612_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/2bdb235a41cf42a825699ab1479fff69.webp"
"MediaSize" => 107988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-2bdb235a41cf42a825699ab1479fff69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:44.99Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29882612_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/8c5c0757fdc1c298d9a4a18d0a4fa09a.webp"
"MediaSize" => 99048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-8c5c0757fdc1c298d9a4a18d0a4fa09a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:44.92Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29882612_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/f9a5b3d48154d92c015b5c652896775f.webp"
"MediaSize" => 119680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-f9a5b3d48154d92c015b5c652896775f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:45.26Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29882612_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/beea140b4cf8674cc9d7c60a64a61a36.webp"
"MediaSize" => 122680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-beea140b4cf8674cc9d7c60a64a61a36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:48.86Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29882612_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/b5948043df860d50f674c7853162fed8.webp"
"MediaSize" => 131464
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-b5948043df860d50f674c7853162fed8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:45.26Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29882612_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/5287044f4b875f2f936000c8701213c8.webp"
"MediaSize" => 114782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-5287044f4b875f2f936000c8701213c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:45.26Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29882612_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/ebc65556913d4ccfe4e81dc90821f8b8.webp"
"MediaSize" => 167385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-ebc65556913d4ccfe4e81dc90821f8b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:45.26Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29882612_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/b445170213b57e64130fafbe3ffd42f6.webp"
"MediaSize" => 146110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-b445170213b57e64130fafbe3ffd42f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:45.26Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29882612_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/deedbdeff4924064f29d8e5fbe486209.webp"
"MediaSize" => 131321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-deedbdeff4924064f29d8e5fbe486209.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:44.99Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29882612_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/607e220c5ed0ac12419a7763fd764ee6.webp"
"MediaSize" => 142478
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-607e220c5ed0ac12419a7763fd764ee6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:44.96Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29882612_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/2776f501335b124430ecf3d2ae958c98.webp"
"MediaSize" => 152640
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-2776f501335b124430ecf3d2ae958c98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:45.26Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29882612_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/78ab6ffac89a59d65dd1483a4597b801.webp"
"MediaSize" => 169553
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-78ab6ffac89a59d65dd1483a4597b801.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:45.26Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29882612_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/ad63f4ff2f6097762d3781e3dcb8a4c6.webp"
"MediaSize" => 151167
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-ad63f4ff2f6097762d3781e3dcb8a4c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:45.25Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29882612_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/21590da11a598d3f8563f0e725d81bde.webp"
"MediaSize" => 87486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-21590da11a598d3f8563f0e725d81bde.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:44.92Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29882612_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/e752ead229602a3dba2541c4ad4133d6.webp"
"MediaSize" => 65761
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-e752ead229602a3dba2541c4ad4133d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:49.03Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29882612_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29882612/3d36c6a0e33dca45e16beb3622d1533f.webp"
"MediaSize" => 56639
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29882612/thumbnail-3d36c6a0e33dca45e16beb3622d1533f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838499"
"ResourceRecordKey" => "29882612"
"ModificationTimestamp" => "2026-06-10T17:02:44.92Z"
]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29882612')"
+"ID": "1515086"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Cache Key: a793809e55dd8133a976975a127e96b19304d4cc7f0750980e8c3aa6b35b9f7a" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24559
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1593819" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24854
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29882612'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25197
+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 '29882612'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25213
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29882612' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7681199 43.2213489)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25286
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25280
+post_id: "1540738"
+post_author: 1
+"ListingKey": "29918492"
+"ListingId": "X13458290"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T21:00:17Z"
+"RFModificationTimestamp": "2026-06-17T21:35:59Z"
+"ListPrice": 724999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G1N9"
+"UnparsedAddress": "17 ALBA STREET, Hamilton (Stoney Creek), Ontario L8G1N9"
+"Coordinates": array:2 [
0 => -79.765014
1 => 43.212423
]
+"Latitude": 43.212423
+"Longitude": -79.765014
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully updated solid brick bungalow offering 3 bedrooms, 2 full bathrooms, and a versatile layout ideal for families, downsizers, or multi-generational living. Located in one of Stoney Creek's most sought-after neighbourhoods, directly below the Niagara Escarpment, you'll enjoy easy access to the Bruce Trail, Devil's Punch Bowl, Battlefield Park, countless parks, and outdoor recreation. Commuters will love the proximity to the Red Hill Valley Parkway, Lincoln Alexander Parkway, QEW, and the future Stoney Creek GO Station. Featuring a separate side entrance and finished lower level, this home offers excellent in-law suite potential. Extensively renovated since 2020, the home blends timeless charm with modern updates. The stunning 2021 kitchen renovation included new cabinetry, flooring, lighting, baseboards, outlets, dishwasher, and stylish finishes throughout. The main floor was further refreshed with updated flooring, lighting, paint, and repairs to windows and doors. The main bathroom was tastefully updated with a new vanity, toilet, flooring, lighting, and fixtures, while the lower-level bathroom was completely rebuilt with a new shower, vanity, toilet, flooring, lighting, and exterior-vented exhaust fan. The finished basement adds exceptional living space with new drywall, windows, carpeting, baseboards, lighting, paint, updated electrical, and a modern electric fireplace. The former wood stove and chimney were removed to create a clean, contemporary feel. The laundry room was also fully upgraded with new flooring, windows, lighting, cabinetry, and finished drywall. Outside, enjoy expanded front and rear decks, a raised and enlarged shed, partial new fencing, a refinished driveway, stone walkways, raised garden beds, and eight fruit trees creating a private backyard retreat. Move-in ready and loaded with value, this extensively updated home offers the perfect blend of comfort, functionality, location, and future potential. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "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-17T21:35:53.577115+00:00"
+"Directions": "King St. to Battlefield Dr. south to Alba turn left"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2104490"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Wooded area"
]
+"LotSizeDimensions": "53.7 x 110 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T20:53:46Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T20:53:46Z"
+"Stories": "1.0"
+"StreetName": "Alba"
+"StreetNumber": "17"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4068"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1661484598"
"RoomType" => "Living room"
"ListingId" => "X13458290"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29918492"
"RoomLength" => 4.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.31Z"
]
1 => array:11 [
"RoomKey" => "1661484599"
"RoomType" => "Kitchen"
"ListingId" => "X13458290"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29918492"
"RoomLength" => 5.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.31Z"
]
2 => array:11 [
"RoomKey" => "1661484600"
"RoomType" => "Bedroom"
"ListingId" => "X13458290"
"RoomLevel" => "Main level"
"RoomWidth" => 3.05
"ListingKey" => "29918492"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.31Z"
]
3 => array:11 [
"RoomKey" => "1661484601"
"RoomType" => "Bedroom"
"ListingId" => "X13458290"
"RoomLevel" => "Main level"
"RoomWidth" => 3.66
"ListingKey" => "29918492"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.31Z"
]
4 => array:11 [
"RoomKey" => "1661484602"
"RoomType" => "Bedroom"
"ListingId" => "X13458290"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29918492"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.31Z"
]
5 => array:11 [
"RoomKey" => "1661484603"
"RoomType" => "Bathroom"
"ListingId" => "X13458290"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29918492"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.31Z"
]
6 => array:11 [
"RoomKey" => "1661484604"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13458290"
"RoomLevel" => "Basement"
"RoomWidth" => 7.01
"ListingKey" => "29918492"
"RoomLength" => 7.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.31Z"
]
7 => array:11 [
"RoomKey" => "1661484605"
"RoomType" => "Playroom"
"ListingId" => "X13458290"
"RoomLevel" => "Basement"
"RoomWidth" => 1.22
"ListingKey" => "29918492"
"RoomLength" => 4.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.31Z"
]
8 => array:11 [
"RoomKey" => "1661484606"
"RoomType" => "Laundry room"
"ListingId" => "X13458290"
"RoomLevel" => "Basement"
"RoomWidth" => 1.83
"ListingKey" => "29918492"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.31Z"
]
9 => array:11 [
"RoomKey" => "1661484607"
"RoomType" => "Bathroom"
"ListingId" => "X13458290"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29918492"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.31Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29918492/17-alba-street-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 53.8
+"OriginalEntryTimestamp": "2026-06-17T20:53:46.26Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1373980"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:48 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29918492_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918492/b13b2a6f339ce786abeea69384ac7e51.webp"
"MediaSize" => 125990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918492/thumbnail-b13b2a6f339ce786abeea69384ac7e51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13458290"
"ResourceRecordKey" => "29918492"
"ModificationTimestamp" => "2026-06-17T20:53:46.27Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29918492_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918492/ab3970f7c10b969c18609c75393f9e66.webp"
"MediaSize" => 143521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918492/thumbnail-ab3970f7c10b969c18609c75393f9e66.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458290"
"ResourceRecordKey" => "29918492"
"ModificationTimestamp" => "2026-06-17T20:53:46.27Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29918492_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918492/82239ab1efd101de1b5fa44ef03890c2.webp"
"MediaSize" => 157677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918492/thumbnail-82239ab1efd101de1b5fa44ef03890c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458290"
"ResourceRecordKey" => "29918492"
"ModificationTimestamp" => "2026-06-17T20:53:46.27Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29918492_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918492/177462dad3d919947a0020b059a8fd40.webp"
"MediaSize" => 174527
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918492/thumbnail-177462dad3d919947a0020b059a8fd40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458290"
"ResourceRecordKey" => "29918492"
"ModificationTimestamp" => "2026-06-17T20:53:46.27Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29918492_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918492/ed84aa2b9fd60e46a632bd1a7381f271.webp"
"MediaSize" => 209508
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918492/thumbnail-ed84aa2b9fd60e46a632bd1a7381f271.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458290"
"ResourceRecordKey" => "29918492"
"ModificationTimestamp" => "2026-06-17T20:53:46.27Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29918492_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918492/ad9986c35dd5132db20cb187000ac71e.webp"
"MediaSize" => 190210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918492/thumbnail-ad9986c35dd5132db20cb187000ac71e.webp"
…7
]
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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918492')"
+"ID": "1540738"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25282
+post_id: "1539162"
+post_author: 1
+"ListingKey": "29914609"
+"ListingId": "40840183"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T13:20:04Z"
+"RFModificationTimestamp": "2026-06-17T17:17:52Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2441.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8J0K9"
+"UnparsedAddress": "35 MIDHURST Heights Unit# 1, Hamilton, Ontario L8J0K9"
+"Coordinates": array:2 [
0 => -79.7653957
1 => 43.2049018
]
+"Latitude": 43.2049018
+"Longitude": -79.7653957
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beyond a home, Fallingwater is a statement of arrival and a masterpiece of the esteemed Losani Collection. This is not merely Unit #1; it is the vision that set the standard, the original model home that showcased the full potential of contemporary luxury living in Stoney Creek. Commanding the most expansive, pie-shaped lot, this end-unit sanctuary offers unrivaled privacy and a breathtaking, direct view over a tranquil outdoor pond—a serene vista enjoyed from your principal rooms. With only three units in the complex, exclusivity is paramount, and this residence represents the undisputed pinnacle. Step inside to discover over 2,441 square feet of impeccably designed, living space, artfully enhanced by high ceilings that amplifies the sense of light and volume. The home unfolds with the grace of a gallery, leading you to a sprawling 164 sq. ft. elevated terrace, your private stage for outdoor entertaining. Ascend further to the 241 sq. ft. rooftop terrace—a crowning glory offering panoramic views and an unparalleled space for sunset soirees or peaceful contemplation. While other, more modestly scaled units are available in the complex, Fallingwater stands apart. It is the largest, the first, and by every measure, the finest. This is the home for those who seek not just square footage, but significance; not just a view, but a vista; not just a unit, but a legacy property. Presented with professional photography that captures its exquisite d architectural brilliance, Fallingwater awaits its final curator. This is your chance to acquire the cornerstone residence of Stone Creek's most distinguished address. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Central Vacuum - Roughed In"
]
+"AssociationFee": "446.64"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T17:17:25.256814+00:00"
+"Directions": "Green Mountain and Upper Centennial"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Brick Veneer"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525060"
+"ListOfficeKey": "67816"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T13:10:49Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T13:10:48Z"
+"Stories": "2.0"
+"StreetName": "MIDHURST"
+"StreetNumber": "35"
+"StreetSuffix": "Heights"
+"SubdivisionName": "500 - Heritage Green"
+"TaxAnnualAmount": "6995.42"
+"View": "View of water"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29914609/35-midhurst-heights-unit-1-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "P5, RM3-50, RM3-51"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 2441
+"OriginalEntryTimestamp": "2026-06-17T13:10:48.91Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1135225"
+"ListOfficeNationalAssociationId": "1132083"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914609')"
+"ID": "1539162"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25279
+post_id: "1539084"
+post_author: 1
+"ListingKey": "29915889"
+"ListingId": "X13455638"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T16:05:15Z"
+"RFModificationTimestamp": "2026-06-17T16:37:02Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Kentley)"
+"PostalCode": "L8E1B6"
+"UnparsedAddress": "192 OAKLAND DRIVE, Hamilton (Kentley), Ontario L8E1B6"
+"Coordinates": array:2 [
0 => -79.76845
1 => 43.234846
]
+"Latitude": 43.234846
+"Longitude": -79.76845
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "You'll find great value in this well built and maintained 4 Bdrm Semi Backsplit in a family friendly neighborhood. This carpet free home features excellent condition hardwood floors in the living and dining area as well as three bedrooms (Hardwood under Linoleum in 2nd Bdrm), a spacious, bright and freshly painted eat-in kitchen w/pantry cupboard, and a second kitchen in the Basement including a 2nd fridge and an upright freezer. For peace of mind, the basement also includes a back flow prevention valve. Newer updates include Furnace (2025), A/C (2023), Hot Water Tank (2025) and Roof (2024). This home provides plenty of storage space in the basement crawlspace. Outside the large garage offers additional storage space, and the extra large concrete poured driveway fits up to 10 vehicles! This home is in a great location, minutes from Eastgate Mall and Fortinos, the Red Hill Valley Pkwy, Sam Manson Park/Playground and Confederation GO station. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Water Heater"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Crawl space"
2 => "None"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T16:36:49.859756+00:00"
+"Directions": "Cross Streets: Centennial Pkwy N/ Queenston Rd. ** Directions: Centennial Pkwy N to Delawana Dr to Kenora Ave to Kentley Dr to Oakland Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Ceramic"
2 => "Linoleum"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2048291"
+"ListOfficeKey": "284791"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "39.6 x 98 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T15:57:52Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T15:57:52Z"
+"StreetName": "Oakland"
+"StreetNumber": "192"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4126.67"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Kentley"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29915889/192-oakland-drive-hamilton-kentley-kentley"
+"ParkingTotal": 12
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 39.7
+"OriginalEntryTimestamp": "2026-06-17T15:57:52.57Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1323630"
+"ListOfficeNationalAssociationId": "1344890"
+"Media": array:26 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915889')"
+"ID": "1539084"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25283
+post_id: "1538887"
+post_author: 1
+"ListingKey": "29915902"
+"ListingId": "X13455912"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T16:05:15Z"
+"RFModificationTimestamp": "2026-06-17T16:34:34Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Vincent)"
+"PostalCode": "L8K6G8"
+"UnparsedAddress": "11 PINARD STREET, Hamilton (Vincent), Ontario L8K6G8"
+"Coordinates": array:2 [
0 => -79.782303
1 => 43.220531
]
+"Latitude": 43.220531
+"Longitude": -79.782303
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Pride in ownership resides in this well-maintained, all-brick raised bungalow that offers a beautiful harmony of character, charm, and practical living, all while being located in a highly sought after and quiet family friendly desirable location! Upon entering the front door, you are greeted by a spacious foyer, leading to the open-concept main level, that boasts natural light throughout the well sized living and dining area. Following along into the open eat-in kitchen, appreciate the ease of ample cabinetry, workable space, and the pleasant view through the generous sized window, as well as the convenience of walk-out access to the rear patio and fully fenced in yard with minimal rear neighbours, being near a quiet treed area. Offering hardwood flooring across the main floor, down the hallway you are welcomed into 3 bedrooms each of a considerable size and with their own closets, in addition to a full updated 4 piece bathroom and several large storage closets. Stepping down into the fully finished lower level, this area accommodates for all with having additional living space featuring a charming open recreation room, complete with large windows and an impressive brick mantel surrounding the wood burning fireplace. The remaining lower level offers a full 3 piece bathroom, the 4th bedroom, a mud room/den area, a large cold storage room, a full laundry and utility room providing a wall of built in cabinetry, and is completed by indoor access to the attached garage. With its attractive spacious layout, attention to detail, and recent updates including, new furnace 2026 and electrical panel within recent years, this home is ideal for all, and is in move-in-ready condition. Being situated along the edge of the escarpment and in close proximity to many parks, hiking trails and forestry, schools, shopping, public transit, and 2 minute drive to the Red Hill Valley Parkway, Lincoln Alexander Parkway, and QEW, this property truly combines many items that are wished for! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
5 => "Garage door opener remote(s)"
6 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T16:34:24.943052+00:00"
+"Directions": "Cross Streets: KING STREET / QUIGLEY RD. ** Directions: From QEW, Exit Red Hill Valley Parkway, South on Red Hill Valley Pkwy, Exit King St E, Left onto King St E, Right on Quigley Rd, Left on Pinard St OR Exit from Red Hill Valley Parkway at Greenhill Avenue, Left on Quigley Road, Right on Pinard St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:1 [
0 => "Woodstove"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235694"
+"ListOfficeKey": "280549"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Wooded area"
1 => "Conservation/green belt"
]
+"LotSizeDimensions": "57.5 x 80 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T15:57:54Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T15:57:54Z"
+"Stories": "1.0"
+"StreetName": "PINARD"
+"StreetNumber": "11"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5135.18"
+"VirtualTourURLUnbranded": "https://youtu.be/t_3eOuTGtX4"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Vincent"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29915902/11-pinard-street-hamilton-vincent-vincent"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 57.6
+"OriginalEntryTimestamp": "2026-06-17T15:57:54.45Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1473608"
+"ListOfficeNationalAssociationId": "1315282"
+"Media": array:35 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915902')"
+"ID": "1538887"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25281
+post_id: "1539085"
+post_author: 1
+"ListingKey": "29915319"
+"ListingId": "40839343"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T15:00:14Z"
+"RFModificationTimestamp": "2026-06-17T16:24:46Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1996.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8E1B6"
+"UnparsedAddress": "192 OAKLAND Drive, Hamilton, Ontario L8E1B6"
+"Coordinates": array:2 [
0 => -79.7684696
1 => 43.2348719
]
+"Latitude": 43.2348719
+"Longitude": -79.7684696
+"YearBuilt": 1969
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "You'll find great value in this well built and maintained 4 Bdrm Semi Backsplit in a family friendly neighborhood. This carpet free home features excellent condition hardwood floors in the living and dining area as well as three bedrooms (hardwood under linoleum in 4th Bdrm), a spacious, bright and freshly painted eat-in kitchen w/pantry cupboard, and a second kitchen in the Basement including a 2nd fridge and an upright freezer. For peace of mind, the basement also includes a back flow prevention valve. Newer updates include Furnace (2O25), A/C(2O23), Hot Water Tank(2O25) and Roof(2O24). This home provides plenty of storage space in the basement crawlspace. Outside the large garage offers additional storage space, and the extra large concrete poured driveway fits up to IO vehicles! This great location is minutes from Eastgate Mall and Fortinos, the Red Hill Valley Pkwy, Sam Manson Park/Playground and Confederation GO station. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Partial"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T16:24:36.538847+00:00"
+"Directions": "Centennial Pkwy N to Delawana Dr to Kenora Ave to Kentley Dr to Oakland Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2051511"
+"ListOfficeKey": "284622"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T14:50:55Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T14:50:55Z"
+"Stories": "2.0"
+"StreetName": "OAKLAND"
+"StreetNumber": "192"
+"StreetSuffix": "Drive"
+"SubdivisionName": "272 - Kentley"
+"TaxAnnualAmount": "4126.67"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Cable"
2 => "Telephone"
]
+"View": "No Water View"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29915319/192-oakland-drive-hamilton"
+"ParkingTotal": 12
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 1442
+"BelowGradeFinishedArea": 554
+"OriginalEntryTimestamp": "2026-06-17T14:50:55.46Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1326881"
+"ListOfficeNationalAssociationId": "1343471"
+"Media": array:26 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915319')"
+"ID": "1539085"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25275
+post_id: "1538547"
+post_author: 1
+"ListingKey": "29915502"
+"ListingId": "40840567"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T15:20:43Z"
+"RFModificationTimestamp": "2026-06-17T15:43:56Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2260.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8K6G8"
+"UnparsedAddress": "11 PINARD Street, Hamilton, Ontario L8K6G8"
+"Coordinates": array:2 [
0 => -79.7823132
1 => 43.2204854
]
+"Latitude": 43.2204854
+"Longitude": -79.7823132
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Pride in ownership resides in this well-maintained, all-brick raised bungalow that offers beautiful harmony of character, charm, and practical living, all while being located in a highly sought after and quiet family friendly desirable location! Upon entering the front door, you are greeted by a spacious foyer, leading to the open-concept main level, that boasts natural light throughout the well sized living and dining area. Following along into the open eat-in kitchen, appreciate the ease of ample cabinetry, workable space, and the pleasant view through the generous sized window, as well as the convenience of walk-out access to the rear patio and fully fenced in yard with minimal rear neighbours, being near a quiet treed area. Offering hardwood flooring across the main floor, down the hallway you are welcomed into 3 bedrooms each of a considerable size and with their own closets, in addition to a full updated 4 piece bathroom and several large storage closets. Stepping down into the fully finished lower level, this area accommodates for all with having additional living space featuring a charming open recreation room, complete with large windows and an impressive brick mantel surrounding the wood burning fireplace. The remaining lower level offers a full 3 piece bathroom, the 4th bedroom, a mud room/den area, a large cold storage room, a full laundry and utility room providing a wall of built in cabinetry, and is completed by indoor access to the attached garage. With its attractive spacious layout, attention to detail, and recent updates including, new furnace 2026 and electrical panel within the last 5 years, this home is ideal for all, and is in move-in-ready condition. Being situated along the edge of the escarpment and in close proximity to many parks, hiking trails and forestry, schools, shopping, public transit, and 2 minute drive to the Red Hill Valley Parkway, Lincoln Alexander Parkway, and QEW, this property truly combines many items that are wished for! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T15:43:43.054703+00:00"
+"Directions": "From QEW, Exit Red Hill Valley Parkway, South on Red Hill Valley Pkwy, Exit King St E, Left onto King St E, Right on Quigley Rd, Left on Pinard St OR Exit from Red Hill Valley Parkway at Greenhill Avenue, Left on Quigley Road, Right on Pinard St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2040749"
+"ListOfficeKey": "55078"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T15:11:37Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T15:11:37Z"
+"Stories": "1.0"
+"StreetName": "PINARD"
+"StreetNumber": "11"
+"StreetSuffix": "Street"
+"SubdivisionName": "282 - Vincent"
+"TaxAnnualAmount": "5135.18"
+"VirtualTourURLUnbranded": "https://youtu.be/t_3eOuTGtX4"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29915502/11-pinard-street-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C/S-120"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 58.0
+"AboveGradeFinishedArea": 1259
+"BelowGradeFinishedArea": 1001
+"OriginalEntryTimestamp": "2026-06-17T15:11:37.64Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1316729"
+"ListOfficeNationalAssociationId": "1003665"
+"Media": array:35 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915502')"
+"ID": "1538547"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1536555"
+post_author: 1
+"ListingKey": "29912938"
+"ListingId": "X13453330"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T22:10:11Z"
+"RFModificationTimestamp": "2026-06-16T22:32:53Z"
+"ListPrice": 345000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Vincent)"
+"PostalCode": "L8K5J2"
+"UnparsedAddress": "17 - 15 ALBRIGHT ROAD N, Hamilton (Vincent), Ontario L8K5J2"
+"Coordinates": array:2 [
0 => -79.785641
1 => 43.215921
]
+"Latitude": 43.215921
+"Longitude": -79.785641
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Affordable 3-Bedroom Condo in a Prime Hamilton Location! Welcome to this 3-bedroom, 1.5-bathroom condo offering comfort, convenience, and a unique layout .Upon entry, you'll find a good-sized primary bedroom on the main floor, along with the living room and kitchen. The second floor features two bedrooms, a 4-piece bathroom, and a walk-out terrace, perfect for relaxing outdoors. Enjoy the convenience of two separate entrances front and back access to the home. Location Highlights: Close to schools, recreation centers, public transit, and the Red Hill Parkway Surrounded by all amenities including restaurants, shopping malls, and more Nearby swimming pools, playgrounds, basketball courts, soccer fields, and hockey facilities Minutes to parks and outdoor activities This condo combines affordability with lifestyle ideal for families, first-time buyers, or investors! (id:59439)"
+"Appliances": array:3 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
]
+"AssociationFee": "1000.5"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-16T22:31:27.360180+00:00"
+"Directions": "Red Hill Valley Pkwy/King St E/Quigley Rd"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"Flooring": array:3 [
0 => "Laminate"
1 => "Carpeted"
2 => "Ceramic"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1998990"
+"ListOfficeKey": "85454"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Laundry- Coin operated"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T22:03:08Z"
+"PhotosCount": 6
+"PoolFeatures": array:1 [
0 => "Outdoor pool"
]
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T22:03:08Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "Albright"
+"StreetNumber": "15"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "1821"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "OnePoint"
+"TaxYear": 2025
+"CityRegion": "Vincent"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29912938/17-15-albright-road-n-hamilton-vincent-vincent"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Larilyn Property Management, 905-672-3355"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Party Room"
1 => "Visitor Parking"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-16T22:03:08.46Z"
+"ListAgentNationalAssociationId": "1281357"
+"ListOfficeNationalAssociationId": "1187906"
+"Media": array:6 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912938')"
+"ID": "1536555"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25284
+post_id: "1531349"
+post_author: 1
+"ListingKey": "29906319"
+"ListingId": "X13447332"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T20:30:18Z"
+"RFModificationTimestamp": "2026-06-15T20:52:02Z"
+"ListPrice": 965000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Kentley)"
+"PostalCode": "L6E4X8"
+"UnparsedAddress": "15 TALIA COURT, Hamilton (Kentley), Ontario L6E4X8"
+"Coordinates": array:2 [
0 => -79.764997
1 => 43.235784
]
+"Latitude": 43.235784
+"Longitude": -79.764997
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this spectacular home tucked away on a quiet, private court - where space, comfort, and lifestyle come together from the moment you arrive! Step through the front door and be immediately greeted by stunning 24x24 porcelain tile floors that set the tone for everything this home has to offer. The main floor is designed for both everyday living and elegant entertaining, featuring hardwood floors flowing through the family room, a bright eat-in kitchen, and a formal dining room perfect for hosting family and friends. Upstairs you'll find 4 generously sized bedrooms including a stunning primary retreat complete with a walk-in closet and a private ensuite - your own personal sanctuary at the end of the day. The fully finished basement is a true showstopper - complete with its own kitchen, bedroom, recreation room, and potential for a 5th bedroom, making it the perfect in-law suite or multi-generational living space. The flexibility this lower level offers is incredibly hard to find. Step outside to your very own backyard retreat featuring an above ground pool and an impressive outdoor kitchen equipped with running water - perfect for summer entertaining and backyard gatherings all season long. Perfectly located just minutes to the QEW and Lincoln M. Alexander Parkway and close to all amenities - this home truly has it all. Nestled on a peaceful private court, this one is not to be missed! (id:62650)"
+"Appliances": array:3 [
0 => "All"
1 => "Garage door opener remote(s)"
2 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T20:52:00.434732+00:00"
+"Directions": "Cross Streets: JANET COURT. ** Directions: KENORA AVE TO JANET COURT TO TALIA COURT."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2234778"
+"ListOfficeKey": "292146"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Flat site"
1 => "Carpet Free"
2 => "Sump Pump"
3 => "In-Law Suite"
]
+"LotSizeDimensions": "26.9 x 114.3 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T20:23:04Z"
+"PhotosCount": 34
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T20:23:04Z"
+"Stories": "2.0"
+"StreetName": "Talia"
+"StreetNumber": "15"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "7650"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"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": "Toronto"
+"CityRegion": "Kentley"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29906319/15-talia-court-hamilton-kentley-kentley"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 26.1
+"OriginalEntryTimestamp": "2026-06-15T20:23:04.58Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1472623"
+"ListOfficeNationalAssociationId": "1417330"
+"Media": array:34 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29906319')"
+"ID": "1531349"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25285
+post_id: "1530533"
+post_author: 1
+"ListingKey": "29904847"
+"ListingId": "40839758"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T15:40:13Z"
+"RFModificationTimestamp": "2026-06-17T16:03:53Z"
+"ListPrice": 603000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.08
+"LivingArea": 2236.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8K6C7"
+"UnparsedAddress": "68 TINDALE Court, Hamilton, Ontario L8K6C7"
+"Coordinates": array:2 [
0 => -79.78466
1 => 43.2138847
]
+"Latitude": 43.2138847
+"Longitude": -79.78466
+"YearBuilt": 1973
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This dynamic move-in ready 4-level backsplit presents as a possible 1 or 2 family home with multi-vehicle driveway, in the vibrant Vincent/Red Hill neighbourhood. Key feature is the separate side entrance, making it ideal for extended family, future in-law suite or revenue generating potential. Renovated areas and modern upgraded blend with its traditional solid structural integrity, ready to customize according to your needs. Perfect balance of open concept and private spaces. Boasts a large main floor living/dining room, bright eat-in kitchen. The upper level, 3 good sized bedrooms and main bath. The expansive lower 2 split levels maximizes space throughout, with a 3pc bath and versatile sizable spaces with potential for additional bedrooms, a kitchen, perhaps a gym, studio, or home office for the entrepreneur. Upgrades in (2025/2026) include fresh paint throughout, main bath glass shower, 3 pc bath and laminate flooring on the lower levels. Fully fenced backyard is ideal for children's playtime, large summer gatherings or quiet relaxation. Excellent connectivity to amenities, schools, parks, trails, SWL Rec Centre, public transit, quick Red-Hill and Hwy access. Excellent for commuters. Looking for a large 1 or 2 family home or investment opportunity, this is the one for you. Now is the time. Imagine the possibilities. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Central Vacuum"
2 => "Dishwasher"
3 => "Dryer"
4 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T18:10:55.012537+00:00"
+"Directions": "King St, E to Quigley Rd, Turn East ont to Tindale Crt."
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Brick"
2 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2055037"
+"ListOfficeKey": "55026"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0.08"
+"PhotosChangeTimestamp": "2026-06-15T17:32:27Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T15:32:17Z"
+"Stories": "1.0"
+"StreetName": "TINDALE"
+"StreetNumber": "68"
+"StreetSuffix": "Court"
+"SubdivisionName": "282 - Vincent"
+"TaxAnnualAmount": "4236.9"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29904847/68-tindale-court-hamilton"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "D/S-221"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1085
+"BelowGradeFinishedArea": 1151
+"OriginalEntryTimestamp": "2026-06-15T17:32:27.05Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1330313"
+"ListOfficeNationalAssociationId": "1003694"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29904847')"
+"ID": "1530533"
}
]
+success: true
+page_size: 9
+page_count: 24
+count: 215
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]