array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29163532/Property?$select=ALL&$top=20&$filter=ListingKey eq 29163532&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29163532/Property?$select=ALL&$top=20&$filter=ListingKey eq 29163532&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23606
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23608
+post_id: "462828"
+post_author: 1
+"ListingKey": "29163532"
+"ListingId": "X12601942"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-04T20:30:53Z"
+"RFModificationTimestamp": "2025-12-04T20:32:25Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8J0K9"
+"UnparsedAddress": "19 - 35 MIDHURST HEIGHTS, Hamilton (Stoney Creek), Ontario L8J0K9"
+"Coordinates": array:2 [
0 => -79.766094
1 => 43.205614
]
+"Latitude": 43.205614
+"Longitude": -79.766094
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful 3-bedrooms townhouse in Prime location! This stunning home offers 3 spacious bedrooms and 3 Modern washrooms with approximately 1900 sq ft of living space. Featuring an open-concept layout, upgraded hardwood floors and a bright, inviting atmosphere throughout. The master bedroom includes a private balcony and rooftop terrace, perfect for relaxing or entertaining. Move-in ready and ideal for families seeking style, comfort and convenience! (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-04T20:21:26.124302+00:00"
+"Directions": "Cross Streets: Green Mountain/ Centennial. ** Directions: Head North on Bradshaw Dr toward Midhurst Heights and turn right onto Midhurst Heights Cross St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1889683"
+"ListOfficeKey": "269129"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-04T20:19:17Z"
+"PhotosCount": 19
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-04T20:19:17Z"
+"Stories": "2.0"
+"StreetName": "Midhurst"
+"StreetNumber": "35"
+"StreetSuffix": "Heights"
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29163532/19-35-midhurst-heights-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Tag Management"
+"GeocodeManualYN": false
+"TotalActualRent": 2800
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-12-04T19:57:20.01Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:19 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6355702774"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29163532/dd3a4cf32958669daf7cfc90201f9f54.webp"
"MediaSize" => 163335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29163532/thumbnail-dd3a4cf32958669daf7cfc90201f9f54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12601942"
"ResourceRecordKey" => "29163532"
"ModificationTimestamp" => "2025-12-04T19:57:20.01Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6355702789"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29163532/1923ba6e2b2b585a55e03abb8d059695.webp"
"MediaSize" => 133261
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29163532/thumbnail-1923ba6e2b2b585a55e03abb8d059695.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12601942"
"ResourceRecordKey" => "29163532"
"ModificationTimestamp" => "2025-12-04T19:57:20.01Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6355702793"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29163532/13d5da7b3a0cb81b13c65d114fc48fa4.webp"
"MediaSize" => 169523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29163532/thumbnail-13d5da7b3a0cb81b13c65d114fc48fa4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12601942"
"ResourceRecordKey" => "29163532"
"ModificationTimestamp" => "2025-12-04T19:57:20.01Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6355702819"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29163532/bcb6b9bb1bf6758d0732e2afe49e07c5.webp"
"MediaSize" => 66993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29163532/thumbnail-bcb6b9bb1bf6758d0732e2afe49e07c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12601942"
"ResourceRecordKey" => "29163532"
"ModificationTimestamp" => "2025-12-04T19:57:20.01Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6355702826"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29163532/2bf8b1bfbe3c773603ca493969b3c5a8.webp"
"MediaSize" => 50109
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29163532/thumbnail-2bf8b1bfbe3c773603ca493969b3c5a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12601942"
"ResourceRecordKey" => "29163532"
"ModificationTimestamp" => "2025-12-04T19:57:20.01Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6355702856"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29163532/55e46b376e125b28a1fb58e4cd4bc42e.webp"
"MediaSize" => 64419
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29163532/thumbnail-55e46b376e125b28a1fb58e4cd4bc42e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12601942"
"ResourceRecordKey" => "29163532"
"ModificationTimestamp" => "2025-12-04T19:57:20.01Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6355702880"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29163532/91070e36374aaf7bf9c5bcf662fba60a.webp"
"MediaSize" => 72572
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29163532/thumbnail-91070e36374aaf7bf9c5bcf662fba60a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12601942"
"ResourceRecordKey" => "29163532"
"ModificationTimestamp" => "2025-12-04T19:57:20.01Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6355702901"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29163532/54c1ee5c863ba187c67d5f8a4efc3ba8.webp"
"MediaSize" => 92762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29163532/thumbnail-54c1ee5c863ba187c67d5f8a4efc3ba8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12601942"
"ResourceRecordKey" => "29163532"
"ModificationTimestamp" => "2025-12-04T19:57:20.01Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6355702931"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29163532/dbd9017b9e9e784c2e87d62056bf4264.webp"
"MediaSize" => 103283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29163532/thumbnail-dbd9017b9e9e784c2e87d62056bf4264.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12601942"
"ResourceRecordKey" => "29163532"
"ModificationTimestamp" => "2025-12-04T19:57:20.01Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6355702992"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29163532/1c75cb1cdb1d9e777e99b4b3844e851f.webp"
"MediaSize" => 149821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29163532/thumbnail-1c75cb1cdb1d9e777e99b4b3844e851f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12601942"
"ResourceRecordKey" => "29163532"
"ModificationTimestamp" => "2025-12-04T19:57:20.01Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6355703018"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29163532/dc315bcfc1bf098cc4718d3dcb9b2be2.webp"
"MediaSize" => 141135
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29163532/thumbnail-dc315bcfc1bf098cc4718d3dcb9b2be2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12601942"
"ResourceRecordKey" => "29163532"
"ModificationTimestamp" => "2025-12-04T19:57:20.01Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6355703073"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29163532/f0db3ca2e86a3e83328619878c4b1811.webp"
"MediaSize" => 145940
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29163532/thumbnail-f0db3ca2e86a3e83328619878c4b1811.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12601942"
"ResourceRecordKey" => "29163532"
"ModificationTimestamp" => "2025-12-04T19:57:20.01Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6355703100"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29163532/8767a32e89fbfa7f7c0bdf92d27a9312.webp"
"MediaSize" => 60530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29163532/thumbnail-8767a32e89fbfa7f7c0bdf92d27a9312.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12601942"
"ResourceRecordKey" => "29163532"
"ModificationTimestamp" => "2025-12-04T19:57:20.01Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6355703146"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29163532/64b4a995426423a0b0fb82c81373b5f5.webp"
"MediaSize" => 48154
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29163532/thumbnail-64b4a995426423a0b0fb82c81373b5f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12601942"
"ResourceRecordKey" => "29163532"
"ModificationTimestamp" => "2025-12-04T19:57:20.01Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6355703166"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29163532/976b8a7db6aef80a137ad3f203e1ec03.webp"
"MediaSize" => 60493
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29163532/thumbnail-976b8a7db6aef80a137ad3f203e1ec03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12601942"
"ResourceRecordKey" => "29163532"
"ModificationTimestamp" => "2025-12-04T19:57:20.01Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6355703250"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29163532/cea1a2e184ff293e2577b7b7bcad219c.webp"
"MediaSize" => 55017
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29163532/thumbnail-cea1a2e184ff293e2577b7b7bcad219c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12601942"
"ResourceRecordKey" => "29163532"
"ModificationTimestamp" => "2025-12-04T19:57:20.01Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6355703335"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29163532/87d7d4d999feba30c89e852523b49183.webp"
"MediaSize" => 116818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29163532/thumbnail-87d7d4d999feba30c89e852523b49183.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12601942"
"ResourceRecordKey" => "29163532"
"ModificationTimestamp" => "2025-12-04T19:57:20.01Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6355703408"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29163532/c5b8cfe52e5fcd0e2d64ad6df1af5438.webp"
"MediaSize" => 53861
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29163532/thumbnail-c5b8cfe52e5fcd0e2d64ad6df1af5438.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12601942"
"ResourceRecordKey" => "29163532"
"ModificationTimestamp" => "2025-12-04T19:57:20.01Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6355703484"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29163532/ba5e773905d8f71b63a4fae4fd0d180d.webp"
"MediaSize" => 126778
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29163532/thumbnail-ba5e773905d8f71b63a4fae4fd0d180d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12601942"
"ResourceRecordKey" => "29163532"
"ModificationTimestamp" => "2025-12-04T19:57:20.01Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29163532')"
+"ID": "462828"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 269129/Office?$select=ALL&$top=10&$filter=OfficeKey eq 269129&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 269129/Office?$select=ALL&$top=10&$filter=OfficeKey eq 269129&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25418
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25420
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "HOMELIFE/MIRACLE REALTY LTD"
+"OfficeEmail": null
+"OfficePhone": "905-624-5678"
+"OfficeMlsId": "406003"
+"ModificationTimestamp": "2024-09-26T21:27:47Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "269129"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "1339 MATHESON BLVD E."
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "MISSISSAUGA"
+"OfficePostalCode": "L4W1R1"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1231804"
+"OriginalEntryTimestamp": "2012-02-04T03:04:00Z"
+"Media": array:1 [
0 => array:10 [
"Order" => 1
"MediaKey" => "5778669390"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/26/office-269129/a4e264090bbf81846333e9c64e775224.webp"
"ResourceName" => "Office"
"MediaCategory" => "Office Logo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "406003"
"ResourceRecordKey" => "269129"
"ModificationTimestamp" => "2024-09-26T19:43:00Z"
]
]
+"OfficeFax": "905-624-5677"
+"OfficeAORKey": "82"
+"FranchiseNationalAssociationId": "1230687"
+"OfficeBrokerNationalAssociationId": "1051469"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('269129')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1889683/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1889683&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1889683/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1889683&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25423
+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 29163532" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25039
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29163532/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29163532&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29163532/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29163532&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25019
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29163532 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.766094 43.205614)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29163532 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.766094 43.205614)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29163532 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.766094 43.205614)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29163532 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.766094 43.205614)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24890
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25285
+post_id: "458643"
+post_author: 1
+"ListingKey": "29155926"
+"ListingId": "X12594896"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-02T20:05:55Z"
+"RFModificationTimestamp": "2025-12-02T23:54:43Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J0M2"
+"UnparsedAddress": "107 CUESTA HEIGHTS, Hamilton (Stoney Creek Mountain), Ontario L8J0M2"
+"Coordinates": array:2 [
0 => -79.7804596
1 => 43.2075908
]
+"Latitude": 43.2075908
+"Longitude": -79.7804596
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "INCREDIBLE UPGRADED HOME WITH STUNNING STONEY CREEK ESCARPMENT VIEWS, Premium Lot, WALKOUT BASEMENT, Stunning pond view from House front AND Lake view from back bedroom TRANQUIL SETTING. Welcome to 107 Cuesta Heights, a magnificent 4 bedroom 3 full washrooms, home boasting a walk-out basement This beautiful residence is nestled in a serene community that overlooks Stoney Creek, providing breathtaking vistas of Lake Ontario and Toronto. With builder upgrades and an additional $70,000 in owner enhancements, this sought-after neighbourhood offers a peaceful lifestyle on an escarpment trail, surrounded by parks, and enjoys easy access to the QEW, Red Hill, and Lincoln Alexander Parkway. This property offers nearly 2,900 square feet of above-ground living space, along with an additional 1,000 square feet unfinished basement. The main floor features 9' ceilings, 8' doors, engineered hardwood flooring, a living area with exceptional views. The kitchen is a chef's dream, showcasing exquisite finishes, S/S Appliances, leading to a beautiful dining room, top-notch appliances, and thick granite countertops with a stylish backsplash, oak stairs and wooden spindles The second floor includes a primary bedroom with W/I closets and an ensuite that has to be seen to be believed, complete with upgrades and stunning views. The finished lower level boasts a coveted builder walkout with a separate entrance, some upgrade includes upgraded kitchen cabinets, smooth & California ceilings on the main floor, & Custom Zebra blinds in entire ouse This home offers a rare combination of space, breathtaking views, and luxurious upgrades. Don't miss the chance to make it yours. Book your showing today! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener remote(s)"
]
+"Basement": array:4 [
0 => "Unfinished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-02T23:54:35.775362+00:00"
+"Directions": "Cactus Cres/Glover Mountain Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1758157"
+"ListOfficeKey": "285001"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "69 x 120 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-02T19:52:33Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-02T19:52:33Z"
+"Stories": "2.0"
+"StreetName": "Cuesta"
+"StreetNumber": "107"
+"StreetSuffix": "Heights"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1543812815"
"RoomType" => "Living room"
"ListingId" => "X12594896"
"RoomLevel" => "Main level"
"RoomWidth" => 3.66
"ListingKey" => "29155926"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-02T19:52:33.58Z"
]
1 => array:11 [
"RoomKey" => "1543812816"
"RoomType" => "Family room"
"ListingId" => "X12594896"
"RoomLevel" => "Main level"
"RoomWidth" => 4.11
"ListingKey" => "29155926"
"RoomLength" => 5.03
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-02T19:52:33.58Z"
]
2 => array:11 [
"RoomKey" => "1543812817"
"RoomType" => "Eating area"
"ListingId" => "X12594896"
"RoomLevel" => "Main level"
"RoomWidth" => 3.55
"ListingKey" => "29155926"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-02T19:52:33.58Z"
]
3 => array:11 [
"RoomKey" => "1543812818"
"RoomType" => "Kitchen"
"ListingId" => "X12594896"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29155926"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-02T19:52:33.58Z"
]
4 => array:11 [
"RoomKey" => "1543812819"
"RoomType" => "Laundry room"
"ListingId" => "X12594896"
"RoomLevel" => "Main level"
"RoomWidth" => 2.13
"ListingKey" => "29155926"
"RoomLength" => 2.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-02T19:52:33.59Z"
]
5 => array:11 [
"RoomKey" => "1543812820"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12594896"
"RoomLevel" => "Second level"
"RoomWidth" => 4.77
"ListingKey" => "29155926"
"RoomLength" => 6.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-02T19:52:33.59Z"
]
6 => array:11 [
"RoomKey" => "1543812821"
"RoomType" => "Bedroom 2"
"ListingId" => "X12594896"
"RoomLevel" => "Second level"
"RoomWidth" => 3.81
"ListingKey" => "29155926"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-02T19:52:33.59Z"
]
7 => array:11 [
"RoomKey" => "1543812822"
"RoomType" => "Bedroom 3"
"ListingId" => "X12594896"
"RoomLevel" => "Second level"
"RoomWidth" => 4.27
"ListingKey" => "29155926"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-02T19:52:33.59Z"
]
8 => array:11 [
"RoomKey" => "1543812823"
"RoomType" => "Bedroom 4"
"ListingId" => "X12594896"
"RoomLevel" => "Second level"
"RoomWidth" => 4.11
"ListingKey" => "29155926"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-02T19:52:33.59Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek Mountain"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29155926/107-cuesta-heights-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1933392"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "285001"
+"GeocodeManualYN": false
+"TotalActualRent": 3695
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 69.0
+"OriginalEntryTimestamp": "2025-12-02T19:52:33.54Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:41 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6352178958"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/4abfdbd82f42878aee592565a61e92f6.webp"
"MediaSize" => 101259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-4abfdbd82f42878aee592565a61e92f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6352178996"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/c640fc7f11bac78a8389151eb3a50a70.webp"
"MediaSize" => 124561
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-c640fc7f11bac78a8389151eb3a50a70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6352179050"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/5dd94f0673acc0d2197a3bfcd7b82555.webp"
"MediaSize" => 109101
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-5dd94f0673acc0d2197a3bfcd7b82555.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6352179132"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/321fe1ea5ae1676479b5032d66a27d65.webp"
"MediaSize" => 75600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-321fe1ea5ae1676479b5032d66a27d65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6352179216"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/7fba31d990fa537f262e88efe24263e0.webp"
"MediaSize" => 81373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-7fba31d990fa537f262e88efe24263e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6352179310"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/42c899f85ca9812eb43010e4f65a4aab.webp"
"MediaSize" => 94949
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-42c899f85ca9812eb43010e4f65a4aab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6352179376"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/5e9fbf8ab67810faf05f0a32ee17078b.webp"
"MediaSize" => 85589
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-5e9fbf8ab67810faf05f0a32ee17078b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6352179457"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/508c09cc92475bb2fd3bed8741f7bbf6.webp"
"MediaSize" => 52627
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-508c09cc92475bb2fd3bed8741f7bbf6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6352179547"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/68b31bfb79e364998f8c840c0e8e378c.webp"
"MediaSize" => 74177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-68b31bfb79e364998f8c840c0e8e378c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6352179609"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/20ac32c5989842da90b0a8c19e3a1f6e.webp"
"MediaSize" => 81997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-20ac32c5989842da90b0a8c19e3a1f6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6352179682"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/ebfc862301372cfdb839d1b1b58a83cb.webp"
"MediaSize" => 96483
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-ebfc862301372cfdb839d1b1b58a83cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6352179717"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/3e25731195bab074821ab5e609778db1.webp"
"MediaSize" => 77291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-3e25731195bab074821ab5e609778db1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6352179814"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/c1900de4c410a58f7d5b27268344da25.webp"
"MediaSize" => 93478
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-c1900de4c410a58f7d5b27268344da25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6352179880"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/6c239f737d172db37e9ab87a81da3e2c.webp"
"MediaSize" => 86006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-6c239f737d172db37e9ab87a81da3e2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6352179893"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/701007319234b34536a03997df65271b.webp"
"MediaSize" => 90298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-701007319234b34536a03997df65271b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6352179949"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/ff2ecf25aaed0545637102fce94e02aa.webp"
"MediaSize" => 44575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-ff2ecf25aaed0545637102fce94e02aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6352179980"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/d815d48ed47071b5d69fde13ef31507a.webp"
"MediaSize" => 73264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-d815d48ed47071b5d69fde13ef31507a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6352180033"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/9b9f1910fcf62077046426666a180370.webp"
"MediaSize" => 71656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-9b9f1910fcf62077046426666a180370.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6352180080"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/a356aa6b2bcf923c88f5d80f04ffe5b5.webp"
"MediaSize" => 66587
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-a356aa6b2bcf923c88f5d80f04ffe5b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6352180122"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/19a0e052868483acb31417b8ac480e09.webp"
"MediaSize" => 53499
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-19a0e052868483acb31417b8ac480e09.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6352180152"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/f8d4f512bf60ebf1a2ffc0a1b8563c5d.webp"
"MediaSize" => 77895
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-f8d4f512bf60ebf1a2ffc0a1b8563c5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6352180186"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/ef60e399964d7375f624dd2dd66ee7d7.webp"
"MediaSize" => 53730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-ef60e399964d7375f624dd2dd66ee7d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6352180216"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/bbe8f96ebdea58f272b51a0fbd70cfa7.webp"
"MediaSize" => 59516
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-bbe8f96ebdea58f272b51a0fbd70cfa7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6352180251"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/184845700bfe36cc3e908cbfdc0c6852.webp"
"MediaSize" => 74296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-184845700bfe36cc3e908cbfdc0c6852.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6352180284"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/0bbefd9845d634bc91eb186fbf8859e8.webp"
"MediaSize" => 60347
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-0bbefd9845d634bc91eb186fbf8859e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6352180302"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/631ae020aae0bd8ae698d655f80132c3.webp"
"MediaSize" => 60800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-631ae020aae0bd8ae698d655f80132c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6352180323"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/c957ec2d39bac45dcd3ddb0dc8211d05.webp"
"MediaSize" => 80846
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-c957ec2d39bac45dcd3ddb0dc8211d05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6352180345"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/a4d301e9548d7448874aaca0336a6f88.webp"
"MediaSize" => 96961
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-a4d301e9548d7448874aaca0336a6f88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6352180352"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/080c58a10bd4829f8a7ecf37d20a6001.webp"
"MediaSize" => 44402
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-080c58a10bd4829f8a7ecf37d20a6001.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6352180360"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/7360e26f56f5a01e3e52c6ae297b1600.webp"
"MediaSize" => 63857
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-7360e26f56f5a01e3e52c6ae297b1600.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6352180369"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/c7a6054146dff6e1aba2f7de6ef0f784.webp"
"MediaSize" => 78572
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-c7a6054146dff6e1aba2f7de6ef0f784.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6352180382"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/fefcc86cbe39d08188be8a4e03cc83fb.webp"
"MediaSize" => 103798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-fefcc86cbe39d08188be8a4e03cc83fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6352180387"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/d92f89551f0bf838809f0974b2ea0c74.webp"
"MediaSize" => 129239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-d92f89551f0bf838809f0974b2ea0c74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6352180390"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/ddd22c01e8e8ff6a6c3d91042dfc0220.webp"
"MediaSize" => 128656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-ddd22c01e8e8ff6a6c3d91042dfc0220.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6352180393"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/2b95ecfa782ead7a49f9ceb232d396ea.webp"
"MediaSize" => 109759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-2b95ecfa782ead7a49f9ceb232d396ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6352180396"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/a1c84bd5fe242a2f43a73a27a289f335.webp"
"MediaSize" => 128394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-a1c84bd5fe242a2f43a73a27a289f335.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6352180399"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/8dcc8bb6b8770dd3242132b1207be37c.webp"
"MediaSize" => 102873
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-8dcc8bb6b8770dd3242132b1207be37c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6352180402"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/25a14fa6af9ac0697ff904dbf65536be.webp"
"MediaSize" => 122005
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-25a14fa6af9ac0697ff904dbf65536be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6352180406"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/dee3e5924d635dfd22028c984e347184.webp"
"MediaSize" => 135737
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-dee3e5924d635dfd22028c984e347184.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6352180409"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/e521cff5b49a95d8311e7151ded823ec.webp"
"MediaSize" => 150652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-e521cff5b49a95d8311e7151ded823ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6352180413"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155926/e4753ec9434257e3e57f807a13d4aa32.webp"
"MediaSize" => 130597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155926/thumbnail-e4753ec9434257e3e57f807a13d4aa32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594896"
"ResourceRecordKey" => "29155926"
"ModificationTimestamp" => "2025-12-02T19:52:33.55Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29155926')"
+"ID": "458643"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25277
+post_id: "458276"
+post_author: 1
+"ListingKey": "29155208"
+"ListingId": "X12594226"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-02T18:30:47Z"
+"RFModificationTimestamp": "2025-12-02T18:59:00Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Vincent)"
+"PostalCode": "L8K5R7"
+"UnparsedAddress": "BASEMENT - 15 JOY COURT, Hamilton (Vincent), Ontario L8K5R7"
+"Coordinates": array:2 [
0 => -79.7866977
1 => 43.2081479
]
+"Latitude": 43.2081479
+"Longitude": -79.7866977
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful Detached Raised Bungalow in quiet East Hamilton location, close to the Escarpment. Bachelor Unit with walk out to huge backyard. Suitable for Single Person or Couple. Easy access to Red Hill Parkway and QEW. Separate Laundry, and 1 Parking spot included. AAA Tenants Only Please!!Rental Application with 2 References, Current Credit Report, Employment Letter and 2 Recent Paystubs. Tenants pay 30% Utilities. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Separate entrance"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-02T18:58:54.176775+00:00"
+"Directions": "King St.E/Quigley Rd/Joy Crt."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:3 [
0 => "Tile"
1 => "Laminate"
2 => "Vinyl"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1762766"
+"ListOfficeKey": "276069"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "35.8 x 133.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-02T17:53:58Z"
+"PhotosCount": 12
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-02T17:53:58Z"
+"Stories": "1.0"
+"StreetName": "Joy"
+"StreetNumber": "15"
+"StreetSuffix": "Court"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1543743694"
"RoomType" => "Bedroom"
"ListingId" => "X12594226"
"RoomLevel" => "Basement"
"RoomWidth" => 3.65
"ListingKey" => "29155208"
"RoomLength" => 3.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-02T17:53:58.84Z"
]
1 => array:11 [
"RoomKey" => "1543743695"
"RoomType" => "Living room"
"ListingId" => "X12594226"
"RoomLevel" => "Basement"
"RoomWidth" => 5.3
"ListingKey" => "29155208"
"RoomLength" => 3.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-02T17:53:58.85Z"
]
2 => array:11 [
"RoomKey" => "1543743696"
"RoomType" => "Kitchen"
"ListingId" => "X12594226"
"RoomLevel" => "Basement"
"RoomWidth" => 2.32
"ListingKey" => "29155208"
"RoomLength" => 3.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-02T17:53:58.85Z"
]
3 => array:11 [
"RoomKey" => "1543743697"
"RoomType" => "Laundry room"
"ListingId" => "X12594226"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29155208"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-02T17:53:58.85Z"
]
4 => array:11 [
"RoomKey" => "1543743698"
"RoomType" => "Bathroom"
"ListingId" => "X12594226"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29155208"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-02T17:53:58.85Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Vincent"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29155208/basement-15-joy-court-hamilton-vincent-vincent"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 1550
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 35.9
+"OriginalEntryTimestamp": "2025-12-02T17:53:58.8Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:12 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6351975483"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155208/852aa0cb8bdd621a84229feffa4444ce.webp"
"MediaSize" => 375331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155208/thumbnail-852aa0cb8bdd621a84229feffa4444ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12594226"
"ResourceRecordKey" => "29155208"
"ModificationTimestamp" => "2025-12-02T17:53:58.82Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6351975496"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155208/2ba67b4559414074627707f4133aea9e.webp"
"MediaSize" => 483560
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155208/thumbnail-2ba67b4559414074627707f4133aea9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594226"
"ResourceRecordKey" => "29155208"
"ModificationTimestamp" => "2025-12-02T17:53:58.82Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6351975517"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155208/7b263c5a38a46ab11c12f1d80a85fba4.webp"
"MediaSize" => 489215
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155208/thumbnail-7b263c5a38a46ab11c12f1d80a85fba4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594226"
"ResourceRecordKey" => "29155208"
"ModificationTimestamp" => "2025-12-02T17:53:58.82Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6351975539"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155208/81cdff070be4a4acb2a1b64c2040a122.webp"
"MediaSize" => 269543
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155208/thumbnail-81cdff070be4a4acb2a1b64c2040a122.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594226"
"ResourceRecordKey" => "29155208"
"ModificationTimestamp" => "2025-12-02T17:53:58.82Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6351975575"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155208/e936d1a5b9ac8b0b9eb4066cd05c6d9f.webp"
"MediaSize" => 237222
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155208/thumbnail-e936d1a5b9ac8b0b9eb4066cd05c6d9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594226"
"ResourceRecordKey" => "29155208"
"ModificationTimestamp" => "2025-12-02T17:53:58.82Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6351975608"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155208/c57f629a6b640bdfab803f02ddf26930.webp"
"MediaSize" => 117125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155208/thumbnail-c57f629a6b640bdfab803f02ddf26930.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594226"
"ResourceRecordKey" => "29155208"
"ModificationTimestamp" => "2025-12-02T17:53:58.82Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6351975626"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29155208/96119a0acc728cc03d9ea316a55daf87.webp"
"MediaSize" => 104667
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29155208/thumbnail-96119a0acc728cc03d9ea316a55daf87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12594226"
"ResourceRecordKey" => "29155208"
…1
]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29155208')"
+"ID": "458276"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25286
+post_id: "457259"
+post_author: 1
+"ListingKey": "29154689"
+"ListingId": "40791806"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-02T16:35:45Z"
+"RFModificationTimestamp": "2025-12-02T16:49:11Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2829.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8J0M2"
+"UnparsedAddress": "107 CUESTA Heights, Hamilton, Ontario L8J0M2"
+"Coordinates": array:2 [
0 => -79.7809374
1 => 43.2075512
]
+"Latitude": 43.2075512
+"Longitude": -79.7809374
+"YearBuilt": 2022
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "INCREDIBLE UPGRADED HOME WITH STUNNING STONEY CREEK ESCARPMENT VIEWS, Premium Lot, WALKOUT BASEMENT, Stunning pond view from House front AND Lake view from back bedroom TRANQUIL SETTING. Welcome to 107 Cuesta Heights, a magnificent 4 bedroom 3 full washrooms, home boasting a walk-out basement This beautiful residence is nestled in a serene community that overlooks Stoney Creek, providing breathtaking vistas of Lake Ontario and Toronto. With builder upgrades and an additional owner enhancements, this sought-after neighbourhood offers a peaceful lifestyle on an escarpment trail, surrounded by parks, and enjoys easy access to the QEW, Red Hill, and Lincoln Alexander Parkway. This property offers nearly 2,900 square feet of above-ground living space, along with an additional 1,000 square feet unfinished basement. The main floor features 9' ceilings, 8' doors, engineered hardwood flooring, a living area with exceptional views. The kitchen is a chef's dream, showcasing exquisite finishes, leading to a beautiful dining room, S/S top-notch appliances, and thick granite countertops with a stylish backsplash, oak stairs and wooden spindles The second floor includes a primary bedroom with W/I closets, POT Lights, and an ensuite that has to be seen to be believed, complete with upgrades and stunning views. The finished lower level boasts a coveted builder walkout with a separate entrance, some upgrade includes upgraded kitchen cabinets, smooth & California ceilings on the main floor, & Custom Zebra blinds in entire ouse This home offers a rare combination of space, breathtaking views, and luxurious upgrades. Don't miss the chance to make it yours. Book your showing today! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-02T16:48:47.650851+00:00"
+"Directions": "Cactus Cres/Glover Mountain Rd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1924768"
+"ListOfficeKey": "283896"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-02T16:30:12Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-02T16:30:12Z"
+"Stories": "2.0"
+"StreetName": "CUESTA"
+"StreetNumber": "107"
+"StreetSuffix": "Heights"
+"SubdivisionName": "052 - Stoney Creek Escarpment"
+"Utilities": array:2 [
0 => "Cable"
1 => "Telephone"
]
+"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/29154689/107-cuesta-heights-hamilton"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2106938"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283896"
+"GeocodeManualYN": true
+"TotalActualRent": 3695
+"ZoningDescription": "R4-32"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 69.0
+"AboveGradeFinishedArea": 2829
+"OriginalEntryTimestamp": "2025-12-02T16:30:11.99Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29154689')"
+"ID": "457259"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24901
+post_id: "455584"
+post_author: 1
+"ListingKey": "29059174"
+"ListingId": "X12501620"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-01T20:25:52Z"
+"RFModificationTimestamp": "2025-12-01T21:09:35Z"
+"ListPrice": 579000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Greenford)"
+"PostalCode": "L8G5H1"
+"UnparsedAddress": "45 - 2737 KING STREET E, Hamilton (Greenford), Ontario L8G5H1"
+"Coordinates": array:2 [
0 => -79.775962
1 => 43.221222
]
+"Latitude": 43.221222
+"Longitude": -79.775962
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautiful bungalow/stacked townhouse end unit at Jackson's Landing with over 2000 sqft of finished living space. Located in a private & peaceful complex, this unit is perfect for anyone looking for maintenance-free living. The main level offers a bright open-concept living and dining area, an eat-in kitchen with stainless steel appliances and 2 spacious bedrooms - including a primary room with his & hers closets and a 4-piece ensuite. A second 4-piece bathroom & laundry room completes the main floor. The finished basement expands your living space with a large recreation room, a wet bar, an additional bedroom, and a 4-piece bathroom with a jacuzzi tub. Along with plenty of storage, this basement is perfect for extended family or guests. Conveniently located close to shopping, public transit, and major highways. Book your showing today - this rare unit won't last. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
]
+"AssociationFee": "406"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-01T20:12:52.106089+00:00"
+"Directions": "Cross Streets: King and Nash. ** Directions: On North side of King St, just East of Nash Rd."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2236294"
+"ListOfficeKey": "50984"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-03T17:46:59Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-01T20:12:08Z"
+"StreetDirSuffix": "East"
+"StreetName": "King"
+"StreetNumber": "2737"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4178"
+"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": "Greenford"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29059174/45-2737-king-street-e-hamilton-greenford-greenford"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2025-11-03T14:53:39.14Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29059174')"
+"ID": "455584"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25284
+post_id: "453974"
+post_author: 1
+"ListingKey": "29149424"
+"ListingId": "X12588494"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-30T17:55:51Z"
+"RFModificationTimestamp": "2025-11-30T18:48:35Z"
+"ListPrice": 859000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 3
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J0K8"
+"UnparsedAddress": "40 HEDGES CRESCENT, Hamilton (Stoney Creek Mountain), Ontario L8J0K8"
+"Coordinates": array:2 [
0 => -79.774872
1 => 43.2015764
]
+"Latitude": 43.2015764
+"Longitude": -79.774872
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Resting on a corner lot at the end of a private cul-de-sac, 40 Hedges Crescent in Stoney Creek, is your haven of modern elegance and family warmth. This stunning home greets you with a sleek blend of warm brick and contemporary black accents, setting the stage for an inviting lifestyle. Inside, the open layout is graced with wide-plank floors, expansive windows, and soft, calming tones that fill every room with natural light and an air of tranquility. The gourmet kitchen with granite countertops and stainless steel appliances is perfect for creating memorable meals, flowing effortlessly into a bright dining space. Upstairs, your peaceful primary suite offers a luxurious ensuite with a deep soaking tub for everyday indulgence. The fully fenced backyard with a raised deck is an ideal retreat for family fun and summer gatherings.Located in Stoney Creek, this community offers the best of suburban living-excellent schools, beautiful parks including Heritage Green and Devil's Punch Bowl, easy access to highways, vibrant local shops, and proximity to Lake Ontario for year-round outdoor activities. Here, you're not just buying a home, you're embracing a lifestyle filled with comfort, convenience, and connection to nature and community. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Blinds"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 3
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-30T18:48:33.204060+00:00"
+"Directions": "Cross Streets: First rd and green mountain. ** Directions: SW."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Carpeted"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2045469"
+"ListOfficeKey": "90198"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "9.4 x 27.4 M"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-30T17:46:52Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-30T17:46:52Z"
+"Stories": "2.0"
+"StreetName": "Hedges"
+"StreetNumber": "40"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "5310.13"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=45vo_3CN5L8"
+"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"
+"TaxYear": 2024
+"CityRegion": "Stoney Creek Mountain"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29149424/40-hedges-crescent-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 9.4
+"OriginalEntryTimestamp": "2025-11-30T17:46:52.01Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "meters"
+"Media": array:33 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29149424')"
+"ID": "453974"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24935
+post_id: "451298"
+post_author: 1
+"ListingKey": "29145612"
+"ListingId": "X12584892"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-01T13:31:25Z"
+"RFModificationTimestamp": "2025-12-01T13:34:06Z"
+"ListPrice": 1049000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J0M4"
+"UnparsedAddress": "93 CACTUS CRESCENT, Hamilton (Stoney Creek Mountain), Ontario L8J0M4"
+"Coordinates": array:2 [
0 => -79.7816366
1 => 43.2040788
]
+"Latitude": 43.2040788
+"Longitude": -79.7816366
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Woodstock Ingersoll Tillsonburg and Area Association of REALTORS® (WITAAR)"
+"PublicRemarks": "Welcome to this stunning 5-year-old, 4-bedroom, 3-bathroom family home on sought-after Cactus Crescent in Stoney Creek. Backing onto peaceful green space on a quiet, family-friendly street, this property offers the perfect blend of comfort, style, and convenience! Plus, enjoy the added benefit of solar panels on the roof, providing energy efficiency and long-term savings.The main floor features a bright home office, ideal for remote work, and a beautiful open-concept kitchen with modern finishes, overlooking the backyard. Step outside to your private outdoor retreat-complete with a deck, patio, fully fenced yard, and a large storage shed.Upstairs, you'll find four spacious bedrooms, each filled with natural light. The primary suite boasts a generous walk-in closet and a luxurious 5-piece ensuite. The additional three bedrooms are all well-sized and share access to a stylish, well-appointed bathroom.The mostly finished basement offers even more living space, including a dedicated kids' play area, a cozy movie-watching zone, and a roughed-in bathroom ready for your finishing touches.With a 2-car garage, solar energy benefits, and close proximity to parks, trails, and amenities, this home is perfect for families looking for room to grow in a prime location.Don't miss your chance to make this exceptional property yours! (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-28T19:57:16.485353+00:00"
+"Directions": "Cross Streets: Bedrosck. ** Directions: Left on Cactus from Bedrock, house will be on left."
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2084731"
+"ListOfficeKey": "49415"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "11.1 x 37.4 M"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-28T16:26:46Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-01T13:11:25Z"
+"Stories": "2.0"
+"StreetName": "Cactus"
+"StreetNumber": "93"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6930"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Woodstock-Ingersoll-Tillsonburg"
+"TaxYear": 2025
+"CityRegion": "Stoney Creek Mountain"
+"ListAORKey": "33"
+"ListingURL": "www.realtor.ca/real-estate/29145612/93-cactus-crescent-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 11.1
+"OriginalEntryTimestamp": "2025-11-28T16:26:45.91Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "meters"
+"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('29145612')"
+"ID": "451298"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23620
+post_id: "448351"
+post_author: 1
+"ListingKey": "29141631"
+"ListingId": "40790882"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T14:35:04Z"
+"RFModificationTimestamp": "2025-11-27T17:25:29Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1800.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8J0K6"
+"UnparsedAddress": "55 PRESTWICK Street, Stoney Creek, Ontario L8J0K6"
+"Coordinates": array:2 [
0 => -79.7714421
1 => 43.2028483
]
+"Latitude": 43.2028483
+"Longitude": -79.7714421
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Gorgeous, newer 3 Bedroom 3 Bathroom Townhouse located in desirable Stoney Creek Mountain location just moments from the RedHill and Linc. This home features a large soaker tub in the private ensuite bathroom just off the master, along with walk in closets and two other spacious bedrooms perfect for a small family. The attached garage offers plenty of comfort in the winter months to access your car without going into the snow or to use asa workshop / storage area! The home features premium appliances and a lovely backyard space. Perfect for families, a couple or roommates. Plenty of parking in the driveway aswell. This home is Available as of December 1st. Utilities are extra. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Freezer"
7 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T17:25:13.206119+00:00"
+"Directions": "Mud St & Centennial"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2206042"
+"ListOfficeKey": "292301"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-27T14:30:11Z"
+"PhotosCount": 8
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T14:30:11Z"
+"Stories": "2.0"
+"StreetName": "PRESTWICK"
+"StreetNumber": "55"
+"StreetSuffix": "Street"
+"SubdivisionName": "052 - Stoney Creek Escarpment"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29141631/55-prestwick-street-stoney-creek"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2850
+"ZoningDescription": "RM2-40"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1800
+"OriginalEntryTimestamp": "2025-11-27T14:30:11.33Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:8 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29141631')"
+"ID": "448351"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24889
+post_id: "447300"
+post_author: 1
+"ListingKey": "29140352"
+"ListingId": "X12579928"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-02T23:40:22Z"
+"RFModificationTimestamp": "2025-12-02T23:42:31Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G3R7"
+"UnparsedAddress": "LOWER - 37 DONN AVENUE, Hamilton (Stoney Creek), Ontario L8G3R7"
+"Coordinates": array:2 [
0 => -79.7527011
1 => 43.2194592
]
+"Latitude": 43.2194592
+"Longitude": -79.7527011
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Available January 1, 2026, this spacious 1-bedroom, 1,000 sq ft basement in-law suite is located in the heart of Old Stoney Creek, at the end of a quiet court in a mature and peaceful neighbourhood. The suite features a brand new, full-size kitchen with all new appliances, a large 3-piece bathroom, a generous laundry room, and plenty of storage with two large closets and additional storage areas. Bright and welcoming, the unit includes two oversized legal egress windows that allow for plenty of natural light. It also offers a private, separate entrance and front outdoor parking. Situated within walking distance to bus routes, schools, shopping plazas, parks, and more, this suite offers both comfort and accessibility in one of Stoney Creek's most charming areas. Landlord is willing to semi-furnish the unit upon request. (id:62650)"
+"Appliances": array:2 [
0 => "Range"
1 => "Oven - Built-In"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Separate entrance"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T01:35:29.430353+00:00"
+"Directions": "Lake Ave Dr. & King St. E."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1997480"
+"ListOfficeKey": "290440"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Lighting"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"LotSizeDimensions": "45 x 165.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T22:00:20Z"
+"PhotosCount": 16
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-02T23:28:47Z"
+"Stories": "1.0"
+"StreetName": "Donn"
+"StreetNumber": "37"
+"StreetSuffix": "Avenue"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29140352/lower-37-donn-avenue-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 1800
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2025-11-26T22:00:20.53Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:16 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29140352')"
+"ID": "447300"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25276
+post_id: "446978"
+post_author: 1
+"ListingKey": "29139758"
+"ListingId": "X12579274"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T20:06:03Z"
+"RFModificationTimestamp": "2025-11-26T23:42:09Z"
+"ListPrice": 879000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G2S7"
+"UnparsedAddress": "18 JASPER DRIVE, Hamilton (Stoney Creek), Ontario L8G2S7"
+"Coordinates": array:2 [
0 => -79.7476437
1 => 43.2164298
]
+"Latitude": 43.2164298
+"Longitude": -79.7476437
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Located in Olde Towne Stoney Creek, 18 Jasper is a 4-bedroom home situated on a sun-filled corner lot with convenient access to schools, shopping, and transit. The interior includes a large kitchen with a center island, wall oven, and ample cupboard space, along with 1.5 bathrooms, including a 3-piece with a walk-in shower. The fully finished basement offers additional living space suitable for a media room, gym, or play area. Outside, the property features a private, pool-sized backyard, a concrete driveway with parking for up to four vehicles, and an attached garage. Recent updates include a roof and shingle replacement in 2020 and the addition of gutter guards. The location is within walking distance of St. Martin of Tours, Collegiate Elementary, St. John Henry Newman, and Orchard Park Secondary, and just minutes from F. Mall, Eastgate Square, the QEW, and the Centennial GO station. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T23:42:02.966707+00:00"
+"Directions": "Cross Streets: Bonita Drive. ** Directions: Bonita Drive and Jasper Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1963790"
+"ListOfficeKey": "284787"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Flat site"
]
+"LotSizeDimensions": "101.3 x 108 FT ; 101.51 x 60.07 x 89.39 x 108.18 ft"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T19:58:55Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T19:58:55Z"
+"Stories": "2.0"
+"StreetName": "Jasper"
+"StreetNumber": "18"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4968.55"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"View": "City view"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=jzZURrka9sY"
+"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"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29139758/18-jasper-drive-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 101.3
+"OriginalEntryTimestamp": "2025-11-26T19:58:55.16Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139758')"
+"ID": "446978"
}
]
+success: true
+page_size: 9
+page_count: 16
+count: 138
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]