array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29135760/Property?$select=ALL&$top=20&$filter=ListingKey eq 29135760&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29135760/Property?$select=ALL&$top=20&$filter=ListingKey eq 29135760&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23274
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23276
+post_id: "444707"
+post_author: 1
+"ListingKey": "29135760"
+"ListingId": "X12575540"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-25T19:05:11Z"
+"RFModificationTimestamp": "2025-11-26T01:45:49Z"
+"ListPrice": 429000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stipley)"
+"PostalCode": "L8L6X5"
+"UnparsedAddress": "125 MELROSE AVENUE N, Hamilton (Stipley), Ontario L8L6X5"
+"Coordinates": array:2 [
0 => -79.831191
1 => 43.253909
]
+"Latitude": 43.253909
+"Longitude": -79.831191
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 125 Melrose Ave, a classic two story century home featuring 3 bedrooms and 2 full bathrooms. Ideally situated for convenience, this property is structurally sound and presents an excellent opportunity for first-time home buyers seeking both potential and peace of mind, thanks to its exceptional care and maintenance. The well-designed floor plan retains all its classic charm, while major updates including a new furnace (2021) roof (2018) and a fully updated electrical system (2015, new panel 2025) ensure modern functionality. This home also features a spacious garage, perfect for secure parking or as an ideal area for hobbies and a workshop. This beautifully preserved home is ready to be cherished for generations to come. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T01:45:39.199229+00:00"
+"Directions": "Cross Streets: Beechwood and Melrose. ** Directions: Intersection of Beechwood Avenue and Melrose Ave."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235642"
+"ListOfficeKey": "285286"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "20 x 103.3 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-25T18:57:08Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-25T18:57:07Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "Melrose"
+"StreetNumber": "125"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3015.12"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/125_melrose_avenue_north_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1540012730"
"RoomType" => "Dining room"
"ListingId" => "X12575540"
"RoomLevel" => "Main level"
"RoomWidth" => 3.66
"ListingKey" => "29135760"
"RoomLength" => 3.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-25T18:57:07.94Z"
]
1 => array:11 [
"RoomKey" => "1540012731"
"RoomType" => "Kitchen"
"ListingId" => "X12575540"
"RoomLevel" => "Main level"
"RoomWidth" => 3.25
"ListingKey" => "29135760"
"RoomLength" => 4.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-25T18:57:07.94Z"
]
2 => array:11 [
"RoomKey" => "1540012732"
"RoomType" => "Living room"
"ListingId" => "X12575540"
"RoomLevel" => "Main level"
"RoomWidth" => 3.63
"ListingKey" => "29135760"
"RoomLength" => 3.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-25T18:57:07.94Z"
]
3 => array:11 [
"RoomKey" => "1540012733"
"RoomType" => "Bathroom"
"ListingId" => "X12575540"
"RoomLevel" => "Second level"
"RoomWidth" => 3.33
"ListingKey" => "29135760"
"RoomLength" => 1.12
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-25T18:57:07.94Z"
]
4 => array:11 [
"RoomKey" => "1540012734"
"RoomType" => "Bedroom"
"ListingId" => "X12575540"
"RoomLevel" => "Second level"
"RoomWidth" => 2.79
"ListingKey" => "29135760"
"RoomLength" => 2.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-25T18:57:07.95Z"
]
5 => array:11 [
"RoomKey" => "1540012735"
"RoomType" => "Bedroom"
"ListingId" => "X12575540"
"RoomLevel" => "Second level"
"RoomWidth" => 2.84
"ListingKey" => "29135760"
"RoomLength" => 2.82
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-25T18:57:07.95Z"
]
6 => array:11 [
"RoomKey" => "1540012736"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12575540"
"RoomLevel" => "Second level"
"RoomWidth" => 1.65
"ListingKey" => "29135760"
"RoomLength" => 2.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-25T18:57:07.95Z"
]
7 => array:11 [
"RoomKey" => "1540012737"
"RoomType" => "Bathroom"
"ListingId" => "X12575540"
"RoomLevel" => "Basement"
"RoomWidth" => 1.65
"ListingKey" => "29135760"
"RoomLength" => 2.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-25T18:57:07.95Z"
]
8 => array:11 [
"RoomKey" => "1540012738"
"RoomType" => "Other"
"ListingId" => "X12575540"
"RoomLevel" => "Basement"
"RoomWidth" => 8.81
"ListingKey" => "29135760"
"RoomLength" => 4.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-25T18:57:07.95Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stipley"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29135760/125-melrose-avenue-n-hamilton-stipley-stipley"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 20.0
+"OriginalEntryTimestamp": "2025-11-25T18:57:07.9Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:44 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6339538602"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/ee5bf206088604181e8b6a427978a69b.webp"
"MediaSize" => 367998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-ee5bf206088604181e8b6a427978a69b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6339538633"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/318a66d14e2c311a01720351aed39c2e.webp"
"MediaSize" => 130897
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-318a66d14e2c311a01720351aed39c2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6339538686"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/3b6fe050948850a11e756511c5f64db2.webp"
"MediaSize" => 109612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-3b6fe050948850a11e756511c5f64db2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6339538741"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/229b072d5e37f449acaab62776081580.webp"
"MediaSize" => 145193
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-229b072d5e37f449acaab62776081580.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6339538771"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/5e7b58ca124ff254d111b2a3a02da4c0.webp"
"MediaSize" => 119134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-5e7b58ca124ff254d111b2a3a02da4c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6339538828"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/ef6d4d8ca178f8d943100989c30932f6.webp"
"MediaSize" => 142033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-ef6d4d8ca178f8d943100989c30932f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6339538859"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/ff4642f4fac4bc4b8f89c46e1474fe92.webp"
"MediaSize" => 121383
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-ff4642f4fac4bc4b8f89c46e1474fe92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6339538907"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/75d68bf0bbdd15f5daa719440930dc4e.webp"
"MediaSize" => 162160
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-75d68bf0bbdd15f5daa719440930dc4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6339538954"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/387843986a35421534b5423e0e354d3f.webp"
"MediaSize" => 152662
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-387843986a35421534b5423e0e354d3f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6339538984"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/cdd1ec2256333d519f6d5746838cb578.webp"
"MediaSize" => 384008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-cdd1ec2256333d519f6d5746838cb578.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6339539013"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/2d98ed1eeffdbe3a59c5d9bfbde19492.webp"
"MediaSize" => 127240
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-2d98ed1eeffdbe3a59c5d9bfbde19492.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6339539086"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/bd6907614e2e4aeb754d22903295a844.webp"
"MediaSize" => 315939
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-bd6907614e2e4aeb754d22903295a844.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6339539108"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/1b4431c77f12f59d06a7133e192d5413.webp"
"MediaSize" => 277536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-1b4431c77f12f59d06a7133e192d5413.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6339539122"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/a2b1a8963a2789605851518d4ef57155.webp"
"MediaSize" => 103656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-a2b1a8963a2789605851518d4ef57155.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6339539173"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/26d339322162f0aa693cd7ac02ae787e.webp"
"MediaSize" => 326888
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-26d339322162f0aa693cd7ac02ae787e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6339539182"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/493d90570c593a04aaca6297e192aa02.webp"
"MediaSize" => 51519
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-493d90570c593a04aaca6297e192aa02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6339539223"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/05dd8def9ebae8e540a9c231f2c85e0c.webp"
"MediaSize" => 133594
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-05dd8def9ebae8e540a9c231f2c85e0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6339539252"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/ab183cc83dca24e4876565bd75c2e193.webp"
"MediaSize" => 262234
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-ab183cc83dca24e4876565bd75c2e193.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6339539289"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/50c3c2d6ac2cbae1a9caf97a3eb88183.webp"
"MediaSize" => 144600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-50c3c2d6ac2cbae1a9caf97a3eb88183.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6339539306"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/70303e5b73c94e1fc836bdad9d6e6202.webp"
"MediaSize" => 334431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-70303e5b73c94e1fc836bdad9d6e6202.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6339539332"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/bbaae58fceb0b33009e730016de25c88.webp"
"MediaSize" => 150120
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-bbaae58fceb0b33009e730016de25c88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6339539343"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/291acc96fbc778a1acb3477bdea175dc.webp"
"MediaSize" => 93516
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-291acc96fbc778a1acb3477bdea175dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6339539411"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/ae5412c6b207a7c9de3023ecfa44b894.webp"
"MediaSize" => 386398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-ae5412c6b207a7c9de3023ecfa44b894.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6339539453"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/33c5e6b7829fa5dda48fc67a39621255.webp"
"MediaSize" => 70491
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-33c5e6b7829fa5dda48fc67a39621255.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6339539493"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/b5cba882be81fbddf54d733f31479d73.webp"
"MediaSize" => 185718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-b5cba882be81fbddf54d733f31479d73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6339539502"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/29157dfdf18082fba9969949039e7d74.webp"
"MediaSize" => 333226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-29157dfdf18082fba9969949039e7d74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6339539559"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/de0c6c99d198fcc1e7787fb5eadd8ac6.webp"
"MediaSize" => 127921
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-de0c6c99d198fcc1e7787fb5eadd8ac6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6339539602"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/852f8a6eec519632ce643a0808dff7ed.webp"
"MediaSize" => 86652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-852f8a6eec519632ce643a0808dff7ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6339539646"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/0da55da0ae946d295b709462908a04e2.webp"
"MediaSize" => 220898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-0da55da0ae946d295b709462908a04e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6339539694"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/65af7b630643b8716c76defa9f4395fc.webp"
"MediaSize" => 299597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-65af7b630643b8716c76defa9f4395fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6339539739"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/e3fcc2179400f9e8b279f1a1d7ba5637.webp"
"MediaSize" => 293524
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-e3fcc2179400f9e8b279f1a1d7ba5637.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6339539777"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/a45b006441396a8663b505693147c125.webp"
"MediaSize" => 214103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-a45b006441396a8663b505693147c125.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6339539796"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/047f01347adc6d53951c7edbf6397b28.webp"
"MediaSize" => 58203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-047f01347adc6d53951c7edbf6397b28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6339539807"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/c029037a4750722c4609bb1bc65d0a73.webp"
"MediaSize" => 137937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-c029037a4750722c4609bb1bc65d0a73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6339539818"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/c46a7569038c12b05d48227ad87fcb34.webp"
"MediaSize" => 294356
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-c46a7569038c12b05d48227ad87fcb34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6339539841"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/54ad7cb67407b2e508ed3d5848ec306c.webp"
"MediaSize" => 336914
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-54ad7cb67407b2e508ed3d5848ec306c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6339539848"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/cb505b354a7eaf1531680915798e561d.webp"
"MediaSize" => 338043
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-cb505b354a7eaf1531680915798e561d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6339539862"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/a941fc207a930acebdbe5159f5ffc4c7.webp"
"MediaSize" => 179549
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-a941fc207a930acebdbe5159f5ffc4c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6339539875"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/1f8c6559fb2482a52bda56bfcefc26f0.webp"
"MediaSize" => 136454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-1f8c6559fb2482a52bda56bfcefc26f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6339539894"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/6e09ba59472696178d6afefa2f8bf352.webp"
"MediaSize" => 134899
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-6e09ba59472696178d6afefa2f8bf352.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6339539901"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/f93080980c007b562ba378aeea6ea436.webp"
"MediaSize" => 93619
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-f93080980c007b562ba378aeea6ea436.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6339539907"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/c543c1b3d4879a9e23f42f71205a865a.webp"
"MediaSize" => 117443
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-c543c1b3d4879a9e23f42f71205a865a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
42 => array:13 [
"Order" => 42
"MediaKey" => "6339539917"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/0bd68b2b9953fc32173a66dfe84ef062.webp"
"MediaSize" => 174685
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-0bd68b2b9953fc32173a66dfe84ef062.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
43 => array:13 [
"Order" => 43
"MediaKey" => "6339539928"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29135760/0655740c4f752c3a93fee232f6a4e4e0.webp"
"MediaSize" => 142159
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29135760/thumbnail-0655740c4f752c3a93fee232f6a4e4e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12575540"
"ResourceRecordKey" => "29135760"
"ModificationTimestamp" => "2025-11-25T18:57:07.91Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29135760')"
+"ID": "444707"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 285286/Office?$select=ALL&$top=10&$filter=OfficeKey eq 285286&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 285286/Office?$select=ALL&$top=10&$filter=OfficeKey eq 285286&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25111
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25113
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "SHAW REALTY GROUP INC."
+"OfficeEmail": null
+"OfficePhone": "800-764-8138"
+"OfficeMlsId": "335400"
+"ModificationTimestamp": "2025-01-12T13:44:18Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "285286"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "135 GEORGE ST N UNIT 201B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "CAMBRIDGE"
+"OfficePostalCode": "N1S5C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1349912"
+"OriginalEntryTimestamp": "2019-06-04T18:08:00Z"
+"OfficeAORKey": "82"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "318552"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "285286"
"SocialMediaUrlOrId" => "http://www.shawrealtygroup.com/"
"ModificationTimestamp" => "2025-01-09T18:49:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1349913"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('285286')"
+"Media": []
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2235642/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2235642&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2235642/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2235642&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25116
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29135760" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24722
+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 29135760/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29135760&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29135760/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29135760&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24591
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29135760 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.831191 43.253909)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29135760 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.831191 43.253909)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29135760 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.831191 43.253909)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29135760 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.831191 43.253909)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25000
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24979
+post_id: "447708"
+post_author: 1
+"ListingKey": "29141278"
+"ListingId": "X12580684"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T03:55:10Z"
+"RFModificationTimestamp": "2025-11-27T04:32:45Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Landsdale)"
+"PostalCode": "L8L5K3"
+"UnparsedAddress": "40 EMERALD STREET N, Hamilton (Landsdale), Ontario L8L5K3"
+"Coordinates": array:2 [
0 => -79.85364
1 => 43.253905
]
+"Latitude": 43.253905
+"Longitude": -79.85364
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "From the moment you step through the front door of 40 Emerald Street North, you're greeted by timeless elegance and modern comfort in perfect harmony. The spacious foyer welcomes you with a full closet, solid wood Victorian doors adorned with vintage hardware, and recently refinished original pine floors that flow throughout the home. High ceilings crowned with ornate medallions, lofty baseboards, and exposed brick create a warm, historic backdrop. The kitchen is a showpiece. Bright white cabinetry, stainless steel appliances, polished wood island, farmer's sink, herringbone backsplash, wainscoting, and a striking exposed brick wall blend beautifully with the home's century-old soul. Spacious principal rooms and tall windows fill the main level with light. Convenient powder room finishes the main floor. Wood stairs lead you up to three bedrooms, each with original doors, trim, hardware, and floors, along with a modern, sparkling bath. Everywhere you look, the best of old-world craftsmanship and thoughtful updates unite in style. The fully finished basement offers incredible flexibility. A private in-law suite, teenage retreat, or guest space featuring a living area that can double as a bedroom, a sleek 3-piece bath, kitchenette, and direct laundry access. Step outside to a fully fenced backyard, perfect for relaxing or entertaining, and a rare detached garage for parking or storage. Updates incl. all wiring and plumbing (2019), 50 year shingles on main roof (2020), all new windows and limestone sills (2019), furnace (2019), water heater (2020). All of this in a walkable downtown location, just steps to shops, restaurants, parks, and transit. 40 Emerald Street North delivers heritage charm, modern updates, and unbeatable convenience. It's a real gem in the heart of the city. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T04:32:25.327782+00:00"
+"Directions": "Cross Streets: King William Street. ** Directions: King William St or Wilson St E to Emerald St N."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:2 [
0 => "Stone"
1 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2040128"
+"ListOfficeKey": "280718"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "20.6 x 126 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-27T03:49:21Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T03:49:21Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "Emerald"
+"StreetNumber": "40"
+"StreetSuffix": "Street"
+"VirtualTourURLUnbranded": "https://iframe.videodelivery.net/1062e3ee8bd60eacd4935afe1b02c953"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1540721285"
"RoomType" => "Foyer"
"ListingId" => "X12580684"
"RoomLevel" => "Main level"
"RoomWidth" => 1.22
"ListingKey" => "29141278"
"RoomLength" => 2.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.24Z"
]
1 => array:11 [
"RoomKey" => "1540721286"
"RoomType" => "Kitchen"
"ListingId" => "X12580684"
"RoomLevel" => "Basement"
"RoomWidth" => 2.24
"ListingKey" => "29141278"
"RoomLength" => 2.92
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.24Z"
]
2 => array:11 [
"RoomKey" => "1540721287"
"RoomType" => "Bathroom"
"ListingId" => "X12580684"
"RoomLevel" => "Basement"
"RoomWidth" => 2.24
"ListingKey" => "29141278"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.24Z"
]
3 => array:11 [
"RoomKey" => "1540721288"
"RoomType" => "Recreational, Games room"
"ListingId" => "X12580684"
"RoomLevel" => "Basement"
"RoomWidth" => 3.07
"ListingKey" => "29141278"
"RoomLength" => 5.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.24Z"
]
4 => array:11 [
"RoomKey" => "1540721289"
"RoomType" => "Office"
"ListingId" => "X12580684"
"RoomLevel" => "Basement"
"RoomWidth" => 1.45
"ListingKey" => "29141278"
"RoomLength" => 1.91
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.24Z"
]
5 => array:11 [
"RoomKey" => "1540721290"
"RoomType" => "Laundry room"
"ListingId" => "X12580684"
"RoomLevel" => "Basement"
"RoomWidth" => 1.7
"ListingKey" => "29141278"
"RoomLength" => 2.41
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.24Z"
]
6 => array:11 [
"RoomKey" => "1540721291"
"RoomType" => "Living room"
"ListingId" => "X12580684"
"RoomLevel" => "Main level"
"RoomWidth" => 3.71
"ListingKey" => "29141278"
"RoomLength" => 4.19
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.24Z"
]
7 => array:11 [
"RoomKey" => "1540721292"
"RoomType" => "Dining room"
"ListingId" => "X12580684"
"RoomLevel" => "Main level"
"RoomWidth" => 3.86
"ListingKey" => "29141278"
"RoomLength" => 3.99
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.24Z"
]
8 => array:11 [
"RoomKey" => "1540721293"
"RoomType" => "Kitchen"
"ListingId" => "X12580684"
"RoomLevel" => "Main level"
"RoomWidth" => 3.33
"ListingKey" => "29141278"
"RoomLength" => 4.37
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.25Z"
]
9 => array:11 [
"RoomKey" => "1540721294"
"RoomType" => "Bathroom"
"ListingId" => "X12580684"
"RoomLevel" => "Main level"
"RoomWidth" => 0.94
"ListingKey" => "29141278"
"RoomLength" => 1.55
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.25Z"
]
10 => array:11 [
"RoomKey" => "1540721295"
"RoomType" => "Mud room"
"ListingId" => "X12580684"
"RoomLevel" => "Main level"
"RoomWidth" => 2.18
"ListingKey" => "29141278"
"RoomLength" => 3.53
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.25Z"
]
11 => array:11 [
"RoomKey" => "1540721296"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12580684"
"RoomLevel" => "Second level"
"RoomWidth" => 3.76
"ListingKey" => "29141278"
"RoomLength" => 5.03
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.25Z"
]
12 => array:11 [
"RoomKey" => "1540721297"
"RoomType" => "Bedroom"
"ListingId" => "X12580684"
"RoomLevel" => "Second level"
"RoomWidth" => 2.79
"ListingKey" => "29141278"
"RoomLength" => 3.15
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.25Z"
]
13 => array:11 [
"RoomKey" => "1540721298"
"RoomType" => "Bedroom"
"ListingId" => "X12580684"
"RoomLevel" => "Second level"
"RoomWidth" => 2.08
"ListingKey" => "29141278"
"RoomLength" => 3.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.25Z"
]
14 => array:11 [
"RoomKey" => "1540721299"
"RoomType" => "Bathroom"
"ListingId" => "X12580684"
"RoomLevel" => "Second level"
"RoomWidth" => 1.85
"ListingKey" => "29141278"
"RoomLength" => 5.41
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-27T03:49:21.25Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Landsdale"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29141278/40-emerald-street-n-hamilton-landsdale-landsdale"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2700
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 20.7
+"OriginalEntryTimestamp": "2025-11-27T03:49:21.21Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:50 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6342024352"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/65774644ae95d8ae67b5f5543a9683c0.webp"
"MediaSize" => 141524
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-65774644ae95d8ae67b5f5543a9683c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6342024356"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/283d98421f3eb553107abc031038060c.webp"
"MediaSize" => 140777
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-283d98421f3eb553107abc031038060c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6342024394"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/2781064f8d783f2315f92aa930ebfd87.webp"
"MediaSize" => 155096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-2781064f8d783f2315f92aa930ebfd87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6342024409"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/809379e5a6a40c54880d44e96fe67cd0.webp"
"MediaSize" => 118716
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-809379e5a6a40c54880d44e96fe67cd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6342024417"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/21441951a517b33056d50c89e93417b9.webp"
"MediaSize" => 150307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-21441951a517b33056d50c89e93417b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6342024470"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/4bf317307eb06ffb08a2bffef55ea590.webp"
"MediaSize" => 114870
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-4bf317307eb06ffb08a2bffef55ea590.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6342024482"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/8b862ce14b5e1c5f6b4e307e3735832d.webp"
"MediaSize" => 138993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-8b862ce14b5e1c5f6b4e307e3735832d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6342024490"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/b0f372a268687fb02b347d5ecd445f56.webp"
"MediaSize" => 128209
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-b0f372a268687fb02b347d5ecd445f56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6342024493"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/9ee95251b9478c449343813b3b9b87d4.webp"
"MediaSize" => 96358
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-9ee95251b9478c449343813b3b9b87d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6342024496"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/418b67c94c5e9796e6e5ca3fd7d0430b.webp"
"MediaSize" => 136923
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-418b67c94c5e9796e6e5ca3fd7d0430b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6342024502"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141278/afa4f721005da19fa01606bb66ba02ca.webp"
"MediaSize" => 137292
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141278/thumbnail-afa4f721005da19fa01606bb66ba02ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580684"
"ResourceRecordKey" => "29141278"
"ModificationTimestamp" => "2025-11-27T03:49:21.21Z"
]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29141278')"
+"ID": "447708"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24982
+post_id: "447571"
+post_author: 1
+"ListingKey": "29141194"
+"ListingId": "X12580596"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T02:35:28Z"
+"RFModificationTimestamp": "2025-11-27T03:25:50Z"
+"ListPrice": 569900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stipley)"
+"PostalCode": "L8L2M3"
+"UnparsedAddress": "38 ROSEMONT AVENUE, Hamilton (Stipley), Ontario L8L2M3"
+"Coordinates": array:2 [
0 => -79.8351838
1 => 43.2537797
]
+"Latitude": 43.2537797
+"Longitude": -79.8351838
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning 1,427 sq. ft. semi-detached century home just steps from Hamilton Stadium! This beautifully updated home blends historic charm with modern finishes. Soaring ceilings and an open-concept layout create a comfortable, airy feel. The custom kitchen is a showstopper - featuring oversized tile, quartz island and counters, sleek backsplash, and custom cabinetry perfect for entertaining. New hardwood flooring throughout the main floor adds warmth and style. Upstairs offers spacious bedrooms and updated bathrooms. The primary bedroom includes newer hardwood and a rare, beautifully finished ensuite bathroom a unique feature in homes of this era. The finished attic adds a versatile 4th bedroom or ideal office space, complete with recent spray foam insulation for year-round comfort. Newer Central A/C. Enjoy both front driveway parking and private rear parking via the laneway. Live just steps from Tim Hortons Field and experience the vibrant community spirit, nearby parks, shopping at Centre Mall, easy QEW access, and more. A truly exceptional opportunity in a fantastic location! (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Stove"
2 => "Dryer"
3 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Full"
1 => "Separate entrance"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T03:25:33.423835+00:00"
+"Directions": "SHERMAN AVE/CANNON ST"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:3 [
0 => "Tile"
1 => "Hardwood"
2 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1935802"
+"ListOfficeKey": "282886"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "19 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-27T02:26:18Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T02:26:18Z"
+"Stories": "2.5"
+"StreetName": "Rosemont"
+"StreetNumber": "38"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "2405"
+"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"
+"CityRegion": "Stipley"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29141194/38-rosemont-avenue-hamilton-stipley-stipley"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1943435"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "282886"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 19.0
+"OriginalEntryTimestamp": "2025-11-27T02:26:18.49Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:30 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29141194')"
+"ID": "447571"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24978
+post_id: "447517"
+post_author: 1
+"ListingKey": "29141197"
+"ListingId": "40790853"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T03:06:03Z"
+"RFModificationTimestamp": "2025-11-27T03:10:17Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1746.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L5K3"
+"UnparsedAddress": "40 EMERALD Street N, Hamilton, Ontario L8L5K3"
+"Coordinates": array:2 [
0 => -79.8536711
1 => 43.2539122
]
+"Latitude": 43.2539122
+"Longitude": -79.8536711
+"YearBuilt": 1890
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "From the moment you step through the front door of 40 Emerald Street North, you’re greeted by timeless elegance and modern comfort in perfect harmony. The spacious foyer welcomes you with a full closet, solid wood Victorian doors adorned with vintage hardware, and recently refinished original pine floors that flow throughout the home. High ceilings crowned with ornate medallions, lofty baseboards, and exposed brick create a warm, historic backdrop. The kitchen is a showpiece. Bright white cabinetry, stainless steel appliances, polished wood island, farmer’s sink, herringbone backsplash, wainscoting, and a striking exposed brick wall blend beautifully with the home’s century-old soul. Spacious principal rooms and tall windows fill the main level with light. Convenient powder room finishes the main floor. Wood stairs lead you up to three bedrooms, each with original doors, trim, hardware, and floors, along with a modern, sparkling bath. Everywhere you look, the best of old-world craftsmanship and thoughtful updates unite in style. The fully finished basement offers incredible flexibility. A private in-law suite, teenage retreat, or guest space featuring a living area that can double as a bedroom, a sleek 3-piece bath, kitchenette, and direct laundry access. Step outside to a fully fenced backyard, perfect for relaxing or entertaining, and a rare detached garage for parking or storage. Updates incl. all wiring and plumbing (2019), 50 year shingles on main roof (2020), all new windows and limestone sills (2019), furnace (2019), water heater (2020). All of this in a walkable downtown location, just steps to shops, restaurants, parks, and transit. 40 Emerald Street North delivers heritage charm, modern updates, and unbeatable convenience. It’s a real gem in the heart of the city. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T03:10:14.108344+00:00"
+"Directions": "Wilson St. E. or King William St. to Emerald St. N."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1533669"
+"ListOfficeKey": "229734"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2025-11-27T02:50:44Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T02:50:44Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "EMERALD"
+"StreetNumber": "40"
+"StreetSuffix": "Street"
+"SubdivisionName": "141 - Lansdale"
+"VirtualTourURLUnbranded": "https://iframe.videodelivery.net/1062e3ee8bd60eacd4935afe1b02c953"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29141197/40-emerald-street-n-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2700
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 21.0
+"AboveGradeFinishedArea": 1183
+"BelowGradeFinishedArea": 563
+"OriginalEntryTimestamp": "2025-11-27T02:30:16.14Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29141197')"
+"ID": "447517"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24983
+post_id: "447224"
+post_author: 1
+"ListingKey": "29140910"
+"ListingId": "X12580420"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T01:05:05Z"
+"RFModificationTimestamp": "2025-11-27T01:35:04Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Industrial Sector)"
+"PostalCode": "L8L3P4"
+"UnparsedAddress": "89 SHAW STREET, Hamilton (Industrial Sector), Ontario L8L3P4"
+"Coordinates": array:2 [
0 => -79.8482938
1 => 43.2634685
]
+"Latitude": 43.2634685
+"Longitude": -79.8482938
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright and spacious detached 2-storey home with basement included, offering comfort and convenience in a desirable location. This charming property features 3 generously sized bedrooms, 1.5 bathrooms, a private backyard - perfect for relaxing or entertaining, basement included for extra living space or storage. Located close to transit, shopping, schools, walking distance to the Hamilton General Hospital, and other amenities, this home provides easy access to everything you need. (id:62650)"
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T01:34:53.812494+00:00"
+"Directions": "Cross Streets: Victoria Ave. ** Directions: Victoria Ave to Shaw Street."
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2136563"
+"ListOfficeKey": "284780"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Lane"
1 => "Carpet Free"
]
+"LotSizeDimensions": "25.1 x 100.3 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-27T00:53:29Z"
+"PhotosCount": 18
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T00:53:29Z"
+"Stories": "2.0"
+"StreetName": "SHAW"
+"StreetNumber": "89"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Industrial Sector"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29140910/89-shaw-street-hamilton-industrial-sector-industrial-sector"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2500
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 25.1
+"OriginalEntryTimestamp": "2025-11-27T00:53:29.29Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:18 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29140910')"
+"ID": "447224"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24981
+post_id: "447152"
+post_author: 1
+"ListingKey": "29140446"
+"ListingId": "X12580032"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T22:35:51Z"
+"RFModificationTimestamp": "2025-11-27T01:24:24Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (St. Clair)"
+"PostalCode": "L8M2K6"
+"UnparsedAddress": "203 FAIRLEIGH AVENUE S, Hamilton (St. Clair), Ontario L8M2K6"
+"Coordinates": array:2 [
0 => -79.845511
1 => 43.245626
]
+"Latitude": 43.245626
+"Longitude": -79.845511
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "ENTIRE HOME | RARE PRIVATE 3-CAR PARKING | NO STREET PARKING NEEDED. Welcome to this stunning all-brick character 4 bedroom home that seamlessly blends timeless charm with modern updates. Thoughtfully renovated from top to bottom, this spacious property offers the perfect balance of classic detail and contemporary comfort. Step inside to find a beautifully refreshed interior featuring restored original hardwood and brand-new vinyl flooring-completely carpet-free and freshly painted throughout. The main floor features a renovated kitchen with sleek stainless steel appliances, an updated powder room, backyard access, and a bright, versatile office/bedroom, in addition to open concept Living/Dining rooms with stained glass accents. Upstairs features a bright primary bedroom with a walk-in closet, a renovated main bathroom, and two additional bedrooms. A finished third-floor attic provides even more flexibility and the 4th bedroom/office space. Outside, enjoy a private, fenced-in backyard and the massive convenience of a private 3-car driveway, a rare find that keeps your vehicles off the street. Full basement is unfinished with laundry and extra storage space. Professional property management in place and all utilities are extra. Some pictures have been virtually staged. (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T01:24:22.070855+00:00"
+"Directions": "Cross Streets: Deleware/Fairleigh Av S. ** Directions: Deleware to Fairleigh Av S."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1760884"
+"ListOfficeKey": "194325"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "33.3 x 63 Acre"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T22:32:07Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T22:32:07Z"
+"Stories": "3.0"
+"StreetDirSuffix": "South"
+"StreetName": "Fairleigh"
+"StreetNumber": "203"
+"StreetSuffix": "Avenue"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=9nTwqX3IE8o"
+"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"
+"CityRegion": "St. Clair"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29140446/203-fairleigh-avenue-s-hamilton-st-clair-st-clair"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2790
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-26T22:28:56.48Z"
+"MapCoordinateVerifiedYN": false
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29140446')"
+"ID": "447152"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24975
+post_id: "447100"
+post_author: 1
+"ListingKey": "29140761"
+"ListingId": "40790828"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T23:45:17Z"
+"RFModificationTimestamp": "2025-11-27T00:54:58Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2000.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L3P4"
+"UnparsedAddress": "89 SHAW Street, Hamilton, Ontario L8L3P4"
+"Coordinates": array:2 [
0 => -79.8483441
1 => 43.2634956
]
+"Latitude": 43.2634956
+"Longitude": -79.8483441
+"YearBuilt": 1915
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright and spacious detached 2-storey home with basement included, offering comfort and convenience in a desirable location. This charming property features 3 generously sized bedrooms, 1.5 bathrooms, a private backyard — perfect for relaxing or entertaining, basement included for extra living space or storage. Around the corner from the Hamilton General Hospital! Located close to transit, shopping, schools, and other amenities, this home provides easy access to everything you need. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T00:54:41.589217+00:00"
+"Directions": "Victoria Ave to Shaw Street"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2050883"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2025-11-26T23:38:47Z"
+"PhotosCount": 18
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T23:38:47Z"
+"Stories": "2.0"
+"StreetName": "SHAW"
+"StreetNumber": "89"
+"StreetSuffix": "Street"
+"SubdivisionName": "133 - Keith"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29140761/89-shaw-street-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2500
+"ZoningDescription": "M6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1500
+"BelowGradeFinishedArea": 500
+"OriginalEntryTimestamp": "2025-11-26T23:38:47.25Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"Media": array:18 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29140761')"
+"ID": "447100"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23288
+post_id: "446872"
+post_author: 1
+"ListingKey": "29140019"
+"ListingId": "40790588"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T02:20:08Z"
+"RFModificationTimestamp": "2025-11-27T02:24:52Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1915.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L7C3"
+"UnparsedAddress": "196 AVONDALE Street, Hamilton, Ontario L8L7C3"
+"Coordinates": array:2 [
0 => -79.8247247
1 => 43.2539305
]
+"Latitude": 43.2539305
+"Longitude": -79.8247247
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully updated 1.5-storey home featuring 4 bedrooms and 3 bathrooms, offering modern comfort and incredible versatility. Enjoy a newly renovated kitchen, updated roof, and new windows throughout. The finished third floor adds an additional bedroom plus a cozy den—perfect for an office or creative space. The home also includes an in-law suite with a private separate entrance, ideal for multi-generational living or rental potential. An enclosed rear addition provides the ultimate entertaining area, complete with its own entrance, authentic pizza oven, heat, plumbing, and a convenient half bathroom. With plenty of room for lounging or storage, this unique property is designed to meet a variety of lifestyle needs. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Water meter"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Microwave"
6 => "Freezer"
7 => "Hood Fan"
8 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T23:22:01.297745+00:00"
+"Directions": "Barton St E & Avondale"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1623259"
+"ListOfficeKey": "275165"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Shared Driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-27T02:09:56Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T02:09:55Z"
+"Stories": "2.5"
+"StreetName": "AVONDALE"
+"StreetNumber": "196"
+"StreetSuffix": "Street"
+"SubdivisionName": "211 - Crown Point North"
+"TaxAnnualAmount": "2347.97"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29140019/196-avondale-street-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C5"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1515
+"BelowGradeFinishedArea": 400
+"OriginalEntryTimestamp": "2025-11-26T20:38:56.28Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29140019')"
+"ID": "446872"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24984
+post_id: "446493"
+post_author: 1
+"ListingKey": "29140240"
+"ListingId": "X12579824"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T23:10:44Z"
+"RFModificationTimestamp": "2025-11-26T23:13:40Z"
+"ListPrice": 594900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Gibson)"
+"PostalCode": "L8L6H7"
+"UnparsedAddress": "98 BIRCH AVENUE, Hamilton (Gibson), Ontario L8L6H7"
+"Coordinates": array:2 [
0 => -79.8401748
1 => 43.2558597
]
+"Latitude": 43.2558597
+"Longitude": -79.8401748
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A remarkable opportunity to own a fully redesigned, home in the heart of Gibson. Never lived in since its recent top-to-bottom renovation, this property features a brand-new Top of the Line modern kitchen, fully rebuilt bathrooms, 4 Generously sized & beautiful bedrooms, Stunning brand new 7" Panelled hardwood Flooring throughout the main second and third floors. Smooth ceilings adorned with beautiful new modern crown mouldings, pot lighting, and other new light fixtures.The finished lower level offers a separate entrance, full 4-piece bathroom, and versatile living space, presenting excellent potential for an in-law suite, home office, or future rental conversion - just a few cabinets away from becoming a complete bsmnt suite (buyer to verify use).Enjoy a private rear yard with direct laneway access for secure parking and a new fence that completes this rare urban package. Close to transit, shops, parks, and schools. A pristine, move-in-ready showcase home.Enjoy a bright, open living space, a well-designed kitchen, a fully finished lower level, and an outdoor yard that functions as both a private retreat and practical parking. With separate side access, a bonus flex room for office, gym, playroom, or nanny suite, and generous room sizes, this home adapts beautifully to modern living.Located steps to transit, parks, cafes, schools, and shopping. Nothing to do but move in. This is the one you've been waiting for.Offers gratefully reviewed by the Sellers December 8th at 7PM. (id:62650)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Water meter"
2 => "Dishwasher"
3 => "Stove"
4 => "Hood Fan"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "Walk out"
4 => "N/A"
5 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T21:51:57.468458+00:00"
+"Directions": "Barton St E & Sherman Ave N"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1905815"
+"ListOfficeKey": "278195"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "23 x 104 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T22:00:27Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T22:58:51Z"
+"Stories": "2.5"
+"StreetName": "Birch"
+"StreetNumber": "98"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3023.94"
+"VirtualTourURLUnbranded": "https://unbranded.mediatours.ca/property/98-birch-avenue-hamilton/"
+"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": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Gibson"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29140240/98-birch-avenue-hamilton-gibson-gibson"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1936531"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "275784"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 23.0
+"OriginalEntryTimestamp": "2025-11-26T21:28:34.39Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29140240')"
+"ID": "446493"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24986
+post_id: "446473"
+post_author: 1
+"ListingKey": "29139591"
+"ListingId": "40790720"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T21:25:40Z"
+"RFModificationTimestamp": "2025-11-26T21:30:58Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0.07
+"LivingArea": 1200.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L5G1"
+"UnparsedAddress": "202 VICTORIA Avenue N Unit# Main, Hamilton, Ontario L8L5G1"
+"Coordinates": array:2 [
0 => -79.8540272
1 => 43.2589928
]
+"Latitude": 43.2589928
+"Longitude": -79.8540272
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Check out this awesome main floor two-bedroom apartment! Recently renovated, carpet-free and ready to move in. Located near the heart of downtown Hamilton, there is tons to discover in the neighbourhood - parks, the famous Comma Cafe, popular restaurants, and convenient grocery stores. The kitchen has stainless steel appliances and beautiful stone countertops. The large four-piece bathroom is tastefully updated. Two spacious bedrooms, a great family space, and a separate laundry area round out this awesome unit. Did I mention there is a TON of storage space in the unfinished basement? Steps from public transit with street parking, this unit is ideal for commuters. Walking distance to Hamilton General Hospital, Ron Joyce Children's Health Centre, Theatre Aquarius, Hamilton GO Centre, and vibrant Central Hamilton. Welcome home! Don’t be TOO LATE*! *REG TM. RSA. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T21:30:44.635611+00:00"
+"Directions": "Victoria Ave N between Cannon St E and Barton St E"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.07"
+"PhotosChangeTimestamp": "2025-11-26T21:12:24Z"
+"PhotosCount": 21
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T21:12:24Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "VICTORIA"
+"StreetNumber": "202"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "141 - Lansdale"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29139591/202-victoria-avenue-n-unit-main-hamilton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1800
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1200
+"OriginalEntryTimestamp": "2025-11-26T19:30:29.03Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:21 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139591')"
+"ID": "446473"
}
]
+success: true
+page_size: 9
+page_count: 52
+count: 466
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]