array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29225620/Property?$select=ALL&$top=20&$filter=ListingKey eq 29225620&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29225620/Property?$select=ALL&$top=20&$filter=ListingKey eq 29225620&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23481
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23483
+post_id: "516910"
+post_author: 1
+"ListingKey": "29225620"
+"ListingId": "40796642"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T20:10:38Z"
+"RFModificationTimestamp": "2026-01-14T20:15:51Z"
+"ListPrice": 624900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1430.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8J1A5"
+"UnparsedAddress": "83 RAND Street, Stoney Creek, Ontario L8J1A5"
+"Coordinates": array:2 [
0 => -79.7871728
1 => 43.1921042
]
+"Latitude": 43.1921042
+"Longitude": -79.7871728
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Loved by the same family since it was built, this beautiful home is nestled in a prestigious, family-friendly neighbourhood. Ideally located close to top-rated schools, daycares, parks, greenspace, and convenient highway access. The home is filled with natural light and features a beautiful kitchen perfect for everyday living and entertaining. Step outside to a large, fully fenced backyard—ideal for kids, pets, and summer gatherings. A truly special place to call home. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Partial"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-07T19:45:23.747013+00:00"
+"Directions": "Isaac Brock & Rand"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-01-07T20:02:06Z"
+"PhotosCount": 18
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T19:50:45Z"
+"StreetName": "RAND"
+"StreetNumber": "83"
+"StreetSuffix": "Street"
+"SubdivisionName": "501 - Valley Park"
+"TaxAnnualAmount": "3995"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1560363149"
"RoomType" => "Utility room"
"ListingId" => "40796642"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29225620"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:50:45.11Z"
]
1 => array:11 [
"RoomKey" => "1560363150"
"RoomType" => "Recreation room"
"ListingId" => "40796642"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29225620"
"RoomLength" => null
"RoomDimensions" => "22'4'' x 22'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:50:45.11Z"
]
2 => array:11 [
"RoomKey" => "1560363151"
"RoomType" => "4pc Bathroom"
"ListingId" => "40796642"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29225620"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:50:45.12Z"
]
3 => array:11 [
"RoomKey" => "1560363152"
"RoomType" => "Bedroom"
"ListingId" => "40796642"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29225620"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 12'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:50:45.12Z"
]
4 => array:11 [
"RoomKey" => "1560363153"
"RoomType" => "Bedroom"
"ListingId" => "40796642"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29225620"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:50:45.12Z"
]
5 => array:11 [
"RoomKey" => "1560363154"
"RoomType" => "Primary Bedroom"
"ListingId" => "40796642"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29225620"
"RoomLength" => null
"RoomDimensions" => "15'10'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:50:45.12Z"
]
6 => array:11 [
"RoomKey" => "1560363155"
"RoomType" => "Dining room"
"ListingId" => "40796642"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29225620"
"RoomLength" => null
"RoomDimensions" => "8'5'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:50:45.13Z"
]
7 => array:11 [
"RoomKey" => "1560363156"
"RoomType" => "Living room"
"ListingId" => "40796642"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29225620"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:50:45.13Z"
]
8 => array:11 [
"RoomKey" => "1560363157"
"RoomType" => "Kitchen"
"ListingId" => "40796642"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29225620"
"RoomLength" => null
"RoomDimensions" => "13'9'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:50:45.13Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29225620/83-rand-street-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 56.0
+"AboveGradeFinishedArea": 1072
+"BelowGradeFinishedArea": 358
+"OriginalEntryTimestamp": "2026-01-07T19:00:21.72Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"Media": array:18 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6395690667"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29225620/07764b496b1f9667dbfd09d2c084cabf.webp"
"MediaSize" => 161724
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29225620/thumbnail-07764b496b1f9667dbfd09d2c084cabf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40796642"
"ResourceRecordKey" => "29225620"
"ModificationTimestamp" => "2026-01-07T19:00:21.73Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6395858807"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29225620/b6bfe6bcec15330d553b98a81119f0e2.webp"
"MediaSize" => 152325
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29225620/thumbnail-b6bfe6bcec15330d553b98a81119f0e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796642"
"ResourceRecordKey" => "29225620"
"ModificationTimestamp" => "2026-01-07T20:02:06.01Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6395690816"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29225620/b342c1ad15ff76eb7339cbf0676174fd.webp"
"MediaSize" => 61453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29225620/thumbnail-b342c1ad15ff76eb7339cbf0676174fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796642"
"ResourceRecordKey" => "29225620"
"ModificationTimestamp" => "2026-01-07T19:00:21.73Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6395690877"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29225620/619c76252006df804a728d769248b5d9.webp"
"MediaSize" => 66929
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29225620/thumbnail-619c76252006df804a728d769248b5d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796642"
"ResourceRecordKey" => "29225620"
"ModificationTimestamp" => "2026-01-07T19:00:21.73Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6395690980"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29225620/153035166b5349413c31dc403e48cd2c.webp"
"MediaSize" => 72866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29225620/thumbnail-153035166b5349413c31dc403e48cd2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796642"
"ResourceRecordKey" => "29225620"
"ModificationTimestamp" => "2026-01-07T19:00:21.73Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6395691018"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29225620/1f2196e811ec527493ed37994428a5d5.webp"
"MediaSize" => 59681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29225620/thumbnail-1f2196e811ec527493ed37994428a5d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796642"
"ResourceRecordKey" => "29225620"
"ModificationTimestamp" => "2026-01-07T19:00:21.73Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6395691146"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29225620/c12f22b89a9e418aaa79635602c9a414.webp"
"MediaSize" => 110264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29225620/thumbnail-c12f22b89a9e418aaa79635602c9a414.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796642"
"ResourceRecordKey" => "29225620"
"ModificationTimestamp" => "2026-01-07T19:00:21.73Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6395691217"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29225620/f18f64e74cafa738b6fcabfb7f02ae0e.webp"
"MediaSize" => 62204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29225620/thumbnail-f18f64e74cafa738b6fcabfb7f02ae0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796642"
"ResourceRecordKey" => "29225620"
"ModificationTimestamp" => "2026-01-07T19:00:21.73Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6395691337"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29225620/2f01e070003ab7471ce08fb0b9de867d.webp"
"MediaSize" => 51849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29225620/thumbnail-2f01e070003ab7471ce08fb0b9de867d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796642"
"ResourceRecordKey" => "29225620"
"ModificationTimestamp" => "2026-01-07T19:00:21.73Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6395691343"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29225620/7b33fe04f378c8011fec1801600be270.webp"
"MediaSize" => 57547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29225620/thumbnail-7b33fe04f378c8011fec1801600be270.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796642"
"ResourceRecordKey" => "29225620"
"ModificationTimestamp" => "2026-01-07T19:00:21.73Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6395691465"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29225620/367754431413866546871570b7ea71ab.webp"
"MediaSize" => 58906
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29225620/thumbnail-367754431413866546871570b7ea71ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796642"
"ResourceRecordKey" => "29225620"
"ModificationTimestamp" => "2026-01-07T19:00:21.73Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6395691508"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29225620/19291b900c47981ae115530d567450b7.webp"
"MediaSize" => 69614
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29225620/thumbnail-19291b900c47981ae115530d567450b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796642"
"ResourceRecordKey" => "29225620"
"ModificationTimestamp" => "2026-01-07T19:00:21.73Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6395691585"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29225620/8eaad232eab11a66d82f8dce9977bc4d.webp"
"MediaSize" => 123223
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29225620/thumbnail-8eaad232eab11a66d82f8dce9977bc4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796642"
"ResourceRecordKey" => "29225620"
"ModificationTimestamp" => "2026-01-07T19:00:21.73Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6395691723"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29225620/e00f74fba355916c45793fef2abaa8dc.webp"
"MediaSize" => 111297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29225620/thumbnail-e00f74fba355916c45793fef2abaa8dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796642"
"ResourceRecordKey" => "29225620"
"ModificationTimestamp" => "2026-01-07T19:00:21.73Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6395691791"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29225620/82f11fc0be0868c01584fdc0c0f45e31.webp"
"MediaSize" => 144382
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29225620/thumbnail-82f11fc0be0868c01584fdc0c0f45e31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796642"
"ResourceRecordKey" => "29225620"
"ModificationTimestamp" => "2026-01-07T19:00:21.73Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6395691865"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29225620/5c286c4f85d1032b66b55f151ad4e176.webp"
"MediaSize" => 30161
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29225620/thumbnail-5c286c4f85d1032b66b55f151ad4e176.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796642"
"ResourceRecordKey" => "29225620"
"ModificationTimestamp" => "2026-01-07T19:00:21.73Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6395691965"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29225620/bbcdef9a411a30374e99f43770392c81.webp"
"MediaSize" => 39494
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29225620/thumbnail-bbcdef9a411a30374e99f43770392c81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796642"
"ResourceRecordKey" => "29225620"
"ModificationTimestamp" => "2026-01-07T19:00:21.73Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6395692036"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29225620/1d966ed2cc07ac63fcdb40a2e892ba8d.webp"
"MediaSize" => 44161
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29225620/thumbnail-1d966ed2cc07ac63fcdb40a2e892ba8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796642"
"ResourceRecordKey" => "29225620"
"ModificationTimestamp" => "2026-01-07T19:00:21.73Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "Rob Golfi"
"MemberFirstName" => "Rob"
"MemberLastName" => "Golfi"
"MemberMlsId" => "HBGOLFIRO"
"OriginatingSystemName" => 26
"MemberKey" => "1524224"
"ModificationTimestamp" => "2025-12-10T01:01:10Z"
"MemberStatus" => "Active"
"OfficeKey" => "275989"
"MemberAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberCity" => "Hamilton"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-575-7700"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"MemberNationalAssociationId" => "1064132"
"OfficeNationalAssociationId" => "1269881"
]
]
+"Office": array:1 [
0 => array:23 [
"OfficeName" => "RE/MAX Escarpment Golfi Realty Inc."
"OfficePhone" => "905-575-7700"
"OfficeMlsId" => "HBRMXGOLFI"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "275989"
"ModificationTimestamp" => "2025-12-09T20:27:02Z"
"OfficeAddress1" => "1 Markland Street"
"OfficeCity" => "Hamilton"
"OfficePostalCode" => "L8P2J"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"OfficeFax" => "905-575-1962"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2015-01-15T20:32:00Z"
"OfficeNationalAssociationId" => "1269881"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1244735"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29225620')"
+"ID": "516910"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 275989/Office?$select=ALL&$top=10&$filter=OfficeKey eq 275989&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 275989/Office?$select=ALL&$top=10&$filter=OfficeKey eq 275989&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25279
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25281
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX Escarpment Golfi Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-575-7700"
+"OfficeMlsId": "HBRMXGOLFI"
+"ModificationTimestamp": "2025-12-09T20:27:02Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "275989"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "1 Markland Street"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Hamilton"
+"OfficePostalCode": "L8P2J"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1269881"
+"OriginalEntryTimestamp": "2015-01-15T20:32:00Z"
+"OfficeFax": "905-575-1962"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439645"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "275989"
"SocialMediaUrlOrId" => "https://www.robgolfi.com/"
"ModificationTimestamp" => "2025-12-09T16:07:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1244735"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('275989')"
}
]
+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 1524224/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1524224&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1524224/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1524224&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25284
+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 29225620" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24921
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29225620/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29225620&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29225620/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29225620&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24901
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24903
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29487473"
+"ListingKey": "29225620"
+"ListingId": "40796642"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-01-17"
+"OpenHouseStartTime": "2026-01-17T12:00:00Z"
+"OpenHouseEndTime": "2026-01-17T14:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-01-15T14:43:19Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29487473')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29225620 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7871728 43.1921042)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29225620 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7871728 43.1921042)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29225620 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7871728 43.1921042)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29225620 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7871728 43.1921042)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25129
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25140
+post_id: "536652"
+post_author: 1
+"ListingKey": "29253830"
+"ListingId": "X12698566"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-15T18:35:43Z"
+"RFModificationTimestamp": "2026-01-15T18:40:35Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J0M5"
+"UnparsedAddress": "29 - 185 BEDROCK DRIVE, Hamilton (Stoney Creek Mountain), Ontario L8J0M5"
+"Coordinates": array:2 [
0 => -79.777729
1 => 43.204392
]
+"Latitude": 43.204392
+"Longitude": -79.777729
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome to your new home in one of Stoney Creek's most sought-after neighborhoods! This charming 3-bedroom townhouse at 185 Bedrock Dr offers a functional and spacious layout designed with family life in mind. The main floor's open-concept design ensures you never miss a moment, whether you're preparing a meal in the modern kitchen or relaxing in the sun-filled living area. Upstairs, the primary bedroom provides a peaceful sanctuary with a private ensuite, complemented by two additional well-sized bedrooms and a full 4-piece bathroom. Practicality meets comfort with an attached garage, additional driveway parking, and a unique walk-in storage area, located in the garage, that is perfect for seasonal gear or strollers. Located steps away from local schools and recreation, this move-in-ready property is the ideal setting for your family's next chapter. Available for lease as of April 1st, 2026. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Water Heater"
]
+"Basement": array:2 [
0 => "Other, See Remarks"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-15T17:09:23.993594+00:00"
+"Directions": "Cross Streets: First Rd W / Green Mountain Rd W. ** Directions: From Upper Centennial Parkway, head west on Rymal Road East, turn south onto Bedrock Drive, and continue to Unit 29."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2198401"
+"ListOfficeKey": "85457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-15T14:50:36Z"
+"PhotosCount": 25
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-15T18:19:27Z"
+"Stories": "3.0"
+"StreetName": "Bedrock"
+"StreetNumber": "185"
+"StreetSuffix": "Drive"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "OnePoint"
+"CityRegion": "Stoney Creek Mountain"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29253830/29-185-bedrock-drive-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2900
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-15T14:50:36.29Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:25 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6405445278"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/03704f69a1105a5958f84d912ca9fe9f.webp"
"MediaSize" => 222177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-03704f69a1105a5958f84d912ca9fe9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front door / Garage"
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6405445289"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/ebb749f3a8209efb0ad1244a11efc719.webp"
"MediaSize" => 217157
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-ebb749f3a8209efb0ad1244a11efc719.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front of the house"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6405445301"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/0e1b2bc854611d345a5767317aa33857.webp"
"MediaSize" => 215919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-0e1b2bc854611d345a5767317aa33857.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Corner lot"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6405445311"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/32665ee664a221c37d13a2fba2fad30f.webp"
"MediaSize" => 108978
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-32665ee664a221c37d13a2fba2fad30f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entrance"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6405445321"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/de592e9a288bd3b8aad0dd6f3e88234e.webp"
"MediaSize" => 94189
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-de592e9a288bd3b8aad0dd6f3e88234e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6405445329"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/43790251a427c78c4079d340bf0d65d3.webp"
"MediaSize" => 112468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-43790251a427c78c4079d340bf0d65d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6405445340"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/b4fcb15151f0fde238a6ada0ca081964.webp"
"MediaSize" => 123204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-b4fcb15151f0fde238a6ada0ca081964.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main floor"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6405445350"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/715e0a397f1ca077b5e5c4e653ec0a06.webp"
"MediaSize" => 112720
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-715e0a397f1ca077b5e5c4e653ec0a06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6405445359"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/631d11833bd46b53d717939d9e572cc4.webp"
"MediaSize" => 144845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-631d11833bd46b53d717939d9e572cc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6405445368"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/29b4f1baf8e97e7b2e4e5947720dd4f2.webp"
"MediaSize" => 153158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-29b4f1baf8e97e7b2e4e5947720dd4f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6405445378"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/f00930be7a6713e5ad5e73c8f1f2255c.webp"
"MediaSize" => 122531
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-f00930be7a6713e5ad5e73c8f1f2255c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Upper level stairs"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6405445386"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/9f7ed39096dcd79ebe400d3165bb0169.webp"
"MediaSize" => 86858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-9f7ed39096dcd79ebe400d3165bb0169.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Upper level hallway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6405445392"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/5822e288f955081cc5809516b877c06e.webp"
"MediaSize" => 107620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-5822e288f955081cc5809516b877c06e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom 2"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6405445400"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/41498101fe7b082c8a1dd1c0f1e0d866.webp"
"MediaSize" => 123599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-41498101fe7b082c8a1dd1c0f1e0d866.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom 3"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6405445407"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/02d8bdba8d32001d72b9962ee8432832.webp"
"MediaSize" => 79537
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-02d8bdba8d32001d72b9962ee8432832.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "4pc bathroom upper level"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6405445413"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/b3d3ce97934e35def04fbfdaf7d20651.webp"
"MediaSize" => 74263
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-b3d3ce97934e35def04fbfdaf7d20651.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "4pc bathroom upper level"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6405445419"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/ffe02558a1fdaa7db6e5cd6a47e87fad.webp"
"MediaSize" => 111169
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-ffe02558a1fdaa7db6e5cd6a47e87fad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6405445426"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/d5b977d5d97bd4271445c4da9bd703e5.webp"
"MediaSize" => 81535
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-d5b977d5d97bd4271445c4da9bd703e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6405445430"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/deced73f5009ca81fdb661bca32cfc84.webp"
"MediaSize" => 70871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-deced73f5009ca81fdb661bca32cfc84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary ensuite"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6405445436"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/1aa2c201847d99697f38a22f64061fe7.webp"
"MediaSize" => 107062
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-1aa2c201847d99697f38a22f64061fe7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lower level den"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6405445444"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/533102ca388fcef815b79d0616367393.webp"
"MediaSize" => 122705
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-533102ca388fcef815b79d0616367393.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lower level den"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6405445453"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/59882c96fd9a559c4503f69687e3a0b6.webp"
"MediaSize" => 97064
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-59882c96fd9a559c4503f69687e3a0b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Washer/Dryer in lower level den"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6405445462"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/b699ae29631995d41bab99695d7491ca.webp"
"MediaSize" => 268544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-b699ae29631995d41bab99695d7491ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Backyar"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6405445471"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/58f36cb24f2d5ef70c85ddd188a828db.webp"
"MediaSize" => 270361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-58f36cb24f2d5ef70c85ddd188a828db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Backyard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6405445482"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29253830/caf373f80716afa659c6dd2cb42440bc.webp"
"MediaSize" => 328093
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29253830/thumbnail-caf373f80716afa659c6dd2cb42440bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Backyard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698566"
"ResourceRecordKey" => "29253830"
"ModificationTimestamp" => "2026-01-15T14:50:36.29Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "ROBERT CASTANEDA"
"MemberFirstName" => "ROBERT"
"MemberLastName" => "CASTANEDA"
"MemberMlsId" => "9654051"
"OriginatingSystemName" => 26
"MemberKey" => "2198401"
"ModificationTimestamp" => "2025-09-05T23:28:30Z"
"MemberStatus" => "Active"
"OfficeKey" => "85457"
"MemberAOR" => "OnePoint"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberType" => "Salesperson"
"MemberAORKey" => "47"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:2 [ …2]
"MemberOfficePhone" => "519-824-9050"
"MemberSocialMedia" => array:4 [ …4]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2023-08-28T13:27:00Z"
"MemberNationalAssociationId" => "1446949"
"OfficeNationalAssociationId" => "1002051"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "Royal LePage Royal City Realty"
"OfficePhone" => "519-824-9050"
"OfficeMlsId" => "558500"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "85457"
"ModificationTimestamp" => "2025-12-02T06:02:37Z"
"OfficeAddress1" => "30 EDINBURGH ROAD NORTH"
"OfficeCity" => "GUELPH"
"OfficePostalCode" => "N1H7J"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "OnePoint"
"Media" => array:1 [ …1]
"OfficeFax" => "519-824-5183"
"OfficeType" => "Firm"
"OfficeAORKey" => "47"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OfficeNationalAssociationId" => "1002051"
"FranchiseNationalAssociationId" => "1146708"
"OfficeBrokerNationalAssociationId" => "1182838"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29253830')"
+"ID": "536652"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24762
+post_id: "536419"
+post_author: 1
+"ListingKey": "29254106"
+"ListingId": "X12698854"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-15T15:55:16Z"
+"RFModificationTimestamp": "2026-01-15T16:36:17Z"
+"ListPrice": 499999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J0M7"
+"UnparsedAddress": "5 - 19 PICARDY DRIVE, Hamilton (Stoney Creek Mountain), Ontario L8J0M7"
+"Coordinates": array:2 [
0 => -79.776303
1 => 43.182992
]
+"Latitude": 43.182992
+"Longitude": -79.776303
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "OFFERS WELCOME ANYTIME....Stylish Freehold Townhouse in Prime Stoney Creek Mountain Location. Welcome to this beautifully maintained freehold townhouse, where modern design meets everyday functionality in one of Stoney Creek Mountain's most desirable neighborhoods. This bright and spacious 2-bedroom, 2-bathroom home features a private backyard, an attached garage with convenient inside entry, and additional parking on the driveway-offering everything you need for comfortable, low-maintenance living. Step inside to a contemporary open-concept main floor, where a sleek modern kitchen seamlessly flows into the living and dining areas-perfect for entertaining or simply relaxing in style. Large windows fill the space with natural light, enhancing the warm, inviting atmosphere. Upstairs, the primary bedroom provides a peaceful retreat with a generous walk-in closet and a private 3-piece ensuite. A well-sized second bedroom and a beautifully finished 4-piece bathroom complete the upper level, offering space and comfort for family or guests. Ideally located directly across from Saltfleet High School, this home is just minutes from shopping, restaurants, parks, and transit, with quick and easy access to the Red Hill Valley Parkway and Lincoln Alexander Parkway-making your commute a breeze. Whether you're a first-time buyer, downsizer, or investor, this home offers unbeatable value in a prime location. Don't miss your chance to make it yours! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"AssociationFee": "109.29"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parcel of Tied Land"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-15T16:35:54.185760+00:00"
+"Directions": "Highland Rd to Picardy Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2065863"
+"ListOfficeKey": "284780"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "18 x 61.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-15T15:43:43Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-15T15:43:42Z"
+"Stories": "3.0"
+"StreetName": "Picardy"
+"StreetNumber": "19"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3800"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1560626417"
"RoomType" => "Kitchen"
"ListingId" => "X12698854"
"RoomLevel" => "Second level"
"RoomWidth" => 3.2
"ListingKey" => "29254106"
"RoomLength" => 2.64
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T15:43:42.62Z"
]
1 => array:11 [
"RoomKey" => "1560626418"
"RoomType" => "Dining room"
"ListingId" => "X12698854"
"RoomLevel" => "Second level"
"RoomWidth" => 3.2
"ListingKey" => "29254106"
"RoomLength" => 3.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T15:43:42.63Z"
]
2 => array:11 [
"RoomKey" => "1560626419"
"RoomType" => "Living room"
"ListingId" => "X12698854"
"RoomLevel" => "Second level"
"RoomWidth" => 3.38
"ListingKey" => "29254106"
"RoomLength" => 4.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T15:43:42.63Z"
]
3 => array:11 [
"RoomKey" => "1560626420"
"RoomType" => "Bedroom 2"
"ListingId" => "X12698854"
"RoomLevel" => "Third level"
"RoomWidth" => 3.38
"ListingKey" => "29254106"
"RoomLength" => 3.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T15:43:42.64Z"
]
4 => array:11 [
"RoomKey" => "1560626421"
"RoomType" => "Bedroom 2"
"ListingId" => "X12698854"
"RoomLevel" => "Third level"
"RoomWidth" => 3.02
"ListingKey" => "29254106"
"RoomLength" => 3.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T15:43:42.65Z"
]
5 => array:11 [
"RoomKey" => "1560626422"
"RoomType" => "Bathroom"
"ListingId" => "X12698854"
"RoomLevel" => "Third level"
"RoomWidth" => 2.34
"ListingKey" => "29254106"
"RoomLength" => 2.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T15:43:42.65Z"
]
6 => array:11 [
"RoomKey" => "1560626423"
"RoomType" => "Bathroom"
"ListingId" => "X12698854"
"RoomLevel" => "Third level"
"RoomWidth" => 2.49
"ListingKey" => "29254106"
"RoomLength" => 2.26
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T15:43:42.65Z"
]
7 => array:11 [
"RoomKey" => "1560626424"
"RoomType" => "Laundry room"
"ListingId" => "X12698854"
"RoomLevel" => "Third level"
"RoomWidth" => 1.3
"ListingKey" => "29254106"
"RoomLength" => 1.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T15:43:42.66Z"
]
8 => array:11 [
"RoomKey" => "1560626425"
"RoomType" => "Utility room"
"ListingId" => "X12698854"
"RoomLevel" => "Ground level"
"RoomWidth" => 0.0
"ListingKey" => "29254106"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T15:43:42.66Z"
]
9 => array:11 [
"RoomKey" => "1560626426"
"RoomType" => "Recreational, Games room"
"ListingId" => "X12698854"
"RoomLevel" => "Ground level"
"RoomWidth" => 0.0
"ListingKey" => "29254106"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T15:43:42.67Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek Mountain"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29254106/5-19-picardy-drive-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 18.0
+"OriginalEntryTimestamp": "2026-01-15T15:43:42.41Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:32 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6405496813"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29254106/1768623680720ba85004cda06b8d68d1.webp"
"MediaSize" => 72495
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29254106/thumbnail-1768623680720ba85004cda06b8d68d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12698854"
"ResourceRecordKey" => "29254106"
"ModificationTimestamp" => "2026-01-15T15:43:42.42Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6405496823"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29254106/dc04a8298038dcc373dc551e138b61e7.webp"
"MediaSize" => 71579
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29254106/thumbnail-dc04a8298038dcc373dc551e138b61e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698854"
"ResourceRecordKey" => "29254106"
"ModificationTimestamp" => "2026-01-15T15:43:42.42Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6405496832"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29254106/9033f576728d5261d5d38cec467852e2.webp"
"MediaSize" => 162480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29254106/thumbnail-9033f576728d5261d5d38cec467852e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698854"
"ResourceRecordKey" => "29254106"
"ModificationTimestamp" => "2026-01-15T15:43:42.42Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6405496852"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29254106/33974693307008ebacfe06fa03b83541.webp"
"MediaSize" => 164265
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29254106/thumbnail-33974693307008ebacfe06fa03b83541.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698854"
"ResourceRecordKey" => "29254106"
"ModificationTimestamp" => "2026-01-15T15:43:42.42Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6405496868"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29254106/f43c0873f58e0a7dd8fe3e283fe13f01.webp"
"MediaSize" => 163892
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29254106/thumbnail-f43c0873f58e0a7dd8fe3e283fe13f01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698854"
"ResourceRecordKey" => "29254106"
"ModificationTimestamp" => "2026-01-15T15:43:42.42Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6405496883"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29254106/8803b464faf708ed0a31ee7ab747e9ae.webp"
"MediaSize" => 172823
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29254106/thumbnail-8803b464faf708ed0a31ee7ab747e9ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698854"
"ResourceRecordKey" => "29254106"
"ModificationTimestamp" => "2026-01-15T15:43:42.42Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6405496897"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29254106/b7f7cf66a2d832cdefa15693ca964881.webp"
"MediaSize" => 37204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29254106/thumbnail-b7f7cf66a2d832cdefa15693ca964881.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698854"
"ResourceRecordKey" => "29254106"
"ModificationTimestamp" => "2026-01-15T15:43:42.42Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6405496904"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29254106/b3b3e6b3dbbc2a660e033f46a01cbf53.webp"
"MediaSize" => 69648
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29254106/thumbnail-b3b3e6b3dbbc2a660e033f46a01cbf53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698854"
"ResourceRecordKey" => "29254106"
"ModificationTimestamp" => "2026-01-15T15:43:42.42Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6405496914"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29254106/f257525138bfde5f64d2ca889d1fb742.webp"
"MediaSize" => 60285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29254106/thumbnail-f257525138bfde5f64d2ca889d1fb742.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698854"
"ResourceRecordKey" => "29254106"
"ModificationTimestamp" => "2026-01-15T15:43:42.42Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6405496922"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29254106/3e5ff7768423af461348b88a877be138.webp"
"MediaSize" => 65234
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29254106/thumbnail-3e5ff7768423af461348b88a877be138.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698854"
"ResourceRecordKey" => "29254106"
"ModificationTimestamp" => "2026-01-15T15:43:42.42Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6405496933"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29254106/1e6fd63170af304977ed5791d6832a9c.webp"
"MediaSize" => 63003
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29254106/thumbnail-1e6fd63170af304977ed5791d6832a9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698854"
"ResourceRecordKey" => "29254106"
"ModificationTimestamp" => "2026-01-15T15:43:42.42Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6405496938"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29254106/9bb6da80aef2f76fbe2764aa4a7c2c7b.webp"
"MediaSize" => 62252
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29254106/thumbnail-9bb6da80aef2f76fbe2764aa4a7c2c7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698854"
"ResourceRecordKey" => "29254106"
"ModificationTimestamp" => "2026-01-15T15:43:42.42Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6405496948"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29254106/66028eccce4b24f3c0401e74ba5c6015.webp"
"MediaSize" => 47062
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29254106/thumbnail-66028eccce4b24f3c0401e74ba5c6015.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698854"
"ResourceRecordKey" => "29254106"
"ModificationTimestamp" => "2026-01-15T15:43:42.42Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6405496959"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29254106/727150fd9cccbf3a60aba33639fc486d.webp"
"MediaSize" => 57455
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29254106/thumbnail-727150fd9cccbf3a60aba33639fc486d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12698854"
"ResourceRecordKey" => "29254106"
"ModificationTimestamp" => "2026-01-15T15:43:42.42Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6405496967"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29254106/b0ff9d757e90b7951bdb268a8f3f6260.webp"
"MediaSize" => 69760
…9
]
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]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29254106')"
+"ID": "536419"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24819
+post_id: "535911"
+post_author: 1
+"ListingKey": "29253388"
+"ListingId": "40798726"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-15T05:55:56Z"
+"RFModificationTimestamp": "2026-01-15T06:52:16Z"
+"ListPrice": 499999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1300.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8J0M7"
+"UnparsedAddress": "19 PICARDY Drive Unit# 5, Hamilton, Ontario L8J0M7"
+"Coordinates": array:2 [
0 => -79.7771337
1 => 43.1837747
]
+"Latitude": 43.1837747
+"Longitude": -79.7771337
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "OFFERS WELCOME ANYTIME....Stylish Freehold Townhouse in Prime Stoney Creek Mountain Location. Welcome to this beautifully maintained freehold townhouse, where modern design meets everyday functionality in one of Stoney Creek Mountain's most desirable neighborhoods. This bright and spacious 2-bedroom, 2-bathroom home features a private backyard, an attached garage with convenient inside entry, and additional parking on the driveway-offering everything you need for comfortable, low-maintenance living. Step inside to a contemporary open-concept main floor, where a sleek modern kitchen seamlessly flows into the living and dining areas—perfect for entertaining or simply relaxing in style. Large windows fill the space with natural light, enhancing the warm, inviting atmosphere. Upstairs, the primary bedroom provides a peaceful retreat with a generous walk-in closet and a private 3-piece ensuite. A well-sized second bedroom and a beautifully finished 4-piece bathroom complete the upper level, offering space and comfort for family or guests. Ideally located directly across from Saltfleet High School, this home is just minutes from shopping, restaurants, parks, and transit, with quick and easy access to the Red Hill Valley Parkway and Lincoln Alexander Parkway—making your commute a breeze. Whether you're a first-time buyer, downsizer, or investor, this home offers unbeatable value in a prime location. Don't miss your chance to make it yours! (id:62650)"
+"Appliances": array:2 [
0 => "Water meter"
1 => "Dishwasher"
]
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-15T06:51:59.774332+00:00"
+"Directions": "HIGHLAND RD TO PICARDY DRIVE"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1985836"
+"ListOfficeKey": "284640"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-15T05:48:36Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-15T05:48:36Z"
+"Stories": "3.0"
+"StreetName": "PICARDY"
+"StreetNumber": "19"
+"StreetSuffix": "Drive"
+"SubdivisionName": "502 - Felker"
+"TaxAnnualAmount": "3800"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29253388/19-picardy-drive-unit-5-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RM3-64"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 18.0
+"AboveGradeFinishedArea": 1300
+"OriginalEntryTimestamp": "2026-01-15T05:48:36.63Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29253388')"
+"ID": "535911"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25132
+post_id: "535080"
+post_author: 1
+"ListingKey": "29252517"
+"ListingId": "40798675"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T23:30:24Z"
+"RFModificationTimestamp": "2026-01-14T23:46:07Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1500.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8L0A1"
+"UnparsedAddress": "35 CORNERSTONE Drive, Stoney Creek, Ontario L8L0A1"
+"Coordinates": array:2 [
0 => -79.8094758
1 => 43.1979752
]
+"Latitude": 43.1979752
+"Longitude": -79.8094758
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "WELL MAINTAINED TWO STOREY THREE BEDROOM TWO AND HALF BATHROOM FINISHED RECERATION ROOM MAIN FLOOR HARWOOR FLOORS AND CERAMIC TILES EXCELLENT LOCATION CLOSE TO LINK MOVIE THEATRE CORNER UNIT, SINGLE ATTACHED GARAGE FRONT DRIVEWAY (id:62650)"
+"Appliances": array:1 [
0 => "Water meter"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T23:45:57.706332+00:00"
+"Directions": "Mud Street Left to Winterberry Left On Old Mud Street Then to Cornerstone"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524394"
+"ListOfficeKey": "289628"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "No Pet Home"
1 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T23:19:35Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T23:19:35Z"
+"Stories": "2.0"
+"StreetName": "CORNERSTONE"
+"StreetNumber": "35"
+"StreetSuffix": "Drive"
+"SubdivisionName": "502 - Felker"
+"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/29252517/35-cornerstone-drive-stoney-creek"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2699
+"ZoningDescription": "RM3-7"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 26.0
+"AboveGradeFinishedArea": 1500
+"OriginalEntryTimestamp": "2026-01-14T23:19:35.63Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:13 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29252517')"
+"ID": "535080"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24800
+post_id: "531332"
+post_author: 1
+"ListingKey": "29245330"
+"ListingId": "X12691056"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T16:50:36Z"
+"RFModificationTimestamp": "2026-01-13T19:27:13Z"
+"ListPrice": 825000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Vincent)"
+"PostalCode": "L8K5X6"
+"UnparsedAddress": "172 HANOVER PLACE, Hamilton (Vincent), Ontario L8K5X6"
+"Coordinates": array:2 [
0 => -79.7914268
1 => 43.2082006
]
+"Latitude": 43.2082006
+"Longitude": -79.7914268
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 172 Hanover Place, this legal duplex offers incredible flexibility for homeowners and investors alike. 172 Hanover Place is a rare and exciting opportunity in the desirable Gershome neighbourhood of Hamilton. Situated on a quiet cul-de-sac. Whether you're looking to live in one unit and rent the other, house extended family, or expand your real estate portfolio, this property delivers on all fronts.Each unit is self-contained with its own entrance, offering privacy and strong rental potential. What truly sets this property apart is the inclusion of approved permits and architectural drawings for a detached garden suite-giving you the ability to add a third income-generating unit on the same lot. With the heavy lifting already done, you're one step away from maximizing the full potential of this property.Set on a spacious lot with a fully fenced backyard and ample private parking, the home is just minutes from scenic trails, parks, schools, public transit, and easy access to the Red Hill Valley Parkway. Thoughtfully updated and move-in ready, this is the ideal blend of functionality, location, and long-term upside.Don't miss your chance to own a legal duplex with garden suite potential in one of Hamilton's most sought-after communities. Schedule your private showing today.This property has full drawings for a garden suite and permits. ** This is a linked property.** (id:62650)"
+"Appliances": array:2 [
0 => "All"
1 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Apartment in basement"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-01-13T19:26:49.547788+00:00"
+"Directions": "Cross Streets: Bunker Hill & Hanover Place. ** Directions: West."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2154241"
+"ListOfficeKey": "280225"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "50 x 115 Acre"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-13T16:42:19Z"
+"PhotosCount": 32
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T16:42:18Z"
+"Stories": "1.0"
+"StreetName": "Hanover"
+"StreetNumber": "172"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "4400"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Vincent"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29245330/172-hanover-place-hamilton-vincent-vincent"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Separate Electricity Meters"
1 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 4
+"OriginalEntryTimestamp": "2026-01-13T16:42:18.94Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:32 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29245330')"
+"ID": "531332"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25127
+post_id: "530131"
+post_author: 1
+"ListingKey": "29244160"
+"ListingId": "X12689922"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T04:50:17Z"
+"RFModificationTimestamp": "2026-01-13T06:55:06Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J0M9"
+"UnparsedAddress": "83 PICARDY DRIVE, Hamilton (Stoney Creek Mountain), Ontario L8J0M9"
+"Coordinates": array:2 [
0 => -79.776086
1 => 43.185394
]
+"Latitude": 43.185394
+"Longitude": -79.776086
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This exceptional home offers 3 generous bedrooms and 3 well-finished washrooms, highlighted by soaring 9 ft ceilings on the main level. The bright main floor showcases a seamless living and dining space with engineered hardwood flooring and hardwood staircases accented by iron pickets, creating a refined yet functional atmosphere. The primary bedroom impresses with a distinctive 9 ft coffered ceiling and a spa-inspired 4-piece ensuite featuring a freestanding tub. The modern kitchen is designed with a large centre island and direct access to the backyard, ideal for everyday living and hosting guests. Ideally situated near parks, schools, shopping, dining, transit, and other conveniences. Truly turnkey and ready for immediate occupancy. (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T06:53:54.737360+00:00"
+"Directions": "UPPER CENTENNIAL PKWY + HIGHLAND RD E"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1991122"
+"ListOfficeKey": "288527"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "26.4 x 98.6 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-13T04:40:33Z"
+"PhotosCount": 2
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T04:40:33Z"
+"Stories": "2.0"
+"StreetName": "Picardy"
+"StreetNumber": "83"
+"StreetSuffix": "Drive"
+"View": "View"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek Mountain"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29244160/83-picardy-drive-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3200
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 0
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 26.4
+"OriginalEntryTimestamp": "2026-01-13T04:40:33.17Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:2 [
0 => array:13 [ …13]
1 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29244160')"
+"ID": "530131"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23495
+post_id: "527916"
+post_author: 1
+"ListingKey": "29241723"
+"ListingId": "X12688118"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T20:00:17Z"
+"RFModificationTimestamp": "2026-01-14T20:04:51Z"
+"ListPrice": 679000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8J0K8"
+"UnparsedAddress": "121 SCARLETWOOD STREET, Hamilton (Stoney Creek), Ontario L8J0K8"
+"Coordinates": array:2 [
0 => -79.7719573
1 => 43.2013833
]
+"Latitude": 43.2013833
+"Longitude": -79.7719573
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Freehold townhouse living with no monthly fees, no extra costs, and a premium deep lot with a private backyard and no neighbors at the back-an excellent alternative to condo townhouses. This well-maintained Stoney Creek home offers immediate possession, thoughtful updates, and strong value for buyers seeking space, privacy, and ownership without ongoing fees.Ideally located close to schools, parks, dining, big-box and local shopping, walking distance to transit, and with easy highway access, this vacant home is truly move-in ready. Fresh paint, all-new carpet throughout, and a new garage door opener create a clean, welcoming first impression.The main entrance and kitchen feature durable tile flooring, bathrooms are tiled for easy maintenance, and a hardwood staircase adds warmth and character. The living room and upper level are finished with new carpet, offering a comfortable and cohesive layout well suited for first-time buyers, professionals, or downsizers seeking low-maintenance living without condo fees.The chef-inspired kitchen includes granite countertops, stainless steel appliances, a gas stove, above-range microwave, dishwasher, and undermount sink, opening to the dining and living areas for everyday living and entertaining.Upstairs offers three well-sized bedrooms, including a primary bedroom with ensuite, along with the convenience of second-floor laundry.A standout feature is the fully fenced private backyard with no neighbors behind, new fencing completed in 2025, and a rear backdoor entry providing easy access for lawn care, gardening, and outdoor storage.Located in a sought-after Stoney Creek neighbourhood, this freehold townhouse delivers privacy, space, and flexibility-without monthly condo fees or restrictions. Simply unpack and enjoy. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Oven"
3 => "Dryer"
4 => "Microwave"
5 => "Oven - Built-In"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-12T20:05:44.647646+00:00"
+"Directions": "Scarletwood And First St W"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1994173"
+"ListOfficeKey": "90198"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "20 x 91.9 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T19:46:13Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T19:46:13Z"
+"Stories": "2.0"
+"StreetName": "Scarletwood"
+"StreetNumber": "121"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4435.18"
+"VirtualTourURLUnbranded": "https://tours.sf-photography-photographer.com/cp/121-scarletwood-street-hamilton/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29241723/121-scarletwood-street-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 20.0
+"OriginalEntryTimestamp": "2026-01-12T19:42:51.75Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29241723')"
+"ID": "527916"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25131
+post_id: "525684"
+post_author: 1
+"ListingKey": "29237941"
+"ListingId": "X12684270"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-10T23:20:39Z"
+"RFModificationTimestamp": "2026-01-11T00:48:11Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8J0K7"
+"UnparsedAddress": "47 PAGEBROOK CRESCENT, Hamilton (Stoney Creek), Ontario L8J0K7"
+"Coordinates": array:2 [
0 => -79.7743015
1 => 43.2028927
]
+"Latitude": 43.2028927
+"Longitude": -79.7743015
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Tucked along the edge of the escarpment on a sun-filled corner lot in Empire Lush. 47 Pagebrook Crescent is bright and welcoming, with southwest light and an easy, natural flow throughout. The home has over 2,300 sq/ft of living space, with a main floor that will immediately impress guests. On your right, a dedicated office space with large windows. On your left, an open-concept living and dining area, gas fireplace and large entertaining kitchen. Upstairs, the primary suite is large & relaxing, complete with a walk-in closet and spacious ensuite. Three additional bedrooms, a full four-piece bath, and convenient upper-level laundry provide plenty of room for the whole family. A large unfinished basement adds ample room for storage. With a double car garage, and quick access to the QEW, LINC, golf course, schools, scenic views & trails, conservation land, shopping centre's, and everyday amenities, this home is designed to support real, everyday living. A++ tenants only. Tenant to provide credit check, employment letter, T4's and references. Tenant to pay for all utilities. (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-11T00:47:55.426336+00:00"
+"Directions": "Centennial Parkway/Green Mountain Road/1st Road West"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2145943"
+"ListOfficeKey": "293284"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "55.7 x 91.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-10T23:11:26Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-10T23:11:26Z"
+"Stories": "2.0"
+"StreetName": "Pagebrook"
+"StreetNumber": "47"
+"StreetSuffix": "Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29237941/47-pagebrook-crescent-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3800
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 55.8
+"OriginalEntryTimestamp": "2026-01-10T23:11:26.67Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:41 [
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]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29237941')"
+"ID": "525684"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25130
+post_id: "525592"
+post_author: 1
+"ListingKey": "29237847"
+"ListingId": "X12684180"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-10T22:50:42Z"
+"RFModificationTimestamp": "2026-01-10T22:52:51Z"
+"ListPrice": 998800.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J0K7"
+"UnparsedAddress": "47 PAGEBROOK CRESCENT, Hamilton (Stoney Creek Mountain), Ontario L8J0K7"
+"Coordinates": array:2 [
0 => -79.7743015
1 => 43.2028927
]
+"Latitude": 43.2028927
+"Longitude": -79.7743015
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Tucked along the edge of the escarpment on a sun-filled corner lot in Empire Lush.47 Pagebrook Crescent isbright and welcoming, with southwest light and an easy, natural flow throughout. The home has over 2,300sq/ft of living space, with a main floor that will immediately impress guests. On your right, a dedicatedoffice space with large windows. On your left, an open-concept living and dining area, gas fireplace andlarge entertaining kitchen. Upstairs, the primary suite is large & relaxing, complete with a walk-in closetand spacious ensuite. Three additional bedrooms, a full four-piece bath, and convenient upper-level laundryprovide plenty of room for the whole family. A large unfinished basement allows you to add your signaturetouch. With a double car garage, and quick access to the QEW, LINC, golf course, schools, scenic views & trails, conservation land, shopping centre's, and everyday amenities, this home is designed to support real, everyday living. (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-10T22:30:32.534467+00:00"
+"Directions": "Centennial Parkway/Green Mountain Road/1st Road West"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2145943"
+"ListOfficeKey": "293284"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "55.7 x 91.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-10T22:36:43Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-10T22:36:43Z"
+"Stories": "2.0"
+"StreetName": "Pagebrook"
+"StreetNumber": "47"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6879"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=0T-ev5yBGBc"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek Mountain"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29237847/47-pagebrook-crescent-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R4-31"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 55.8
+"OriginalEntryTimestamp": "2026-01-10T22:11:36.88Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:41 [
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]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29237847')"
+"ID": "525592"
}
]
+success: true
+page_size: 9
+page_count: 16
+count: 138
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]