array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29881916 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23338
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23340
+post_id: "1516814"
+post_author: 1
+"ListingKey": "29881916"
+"ListingId": "40838361"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T15:25:10Z"
+"RFModificationTimestamp": "2026-06-10T22:26:17Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1316.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L9B2S7"
+"UnparsedAddress": "1000 UPPER PARADISE Road Unit# 16, Hamilton, Ontario L9B2S7"
+"Coordinates": array:2 [
0 => -79.9205611
1 => 43.2155144
]
+"Latitude": 43.2155144
+"Longitude": -79.9205611
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this bright and recently updated 3-bedroom townhouse, ideally situated in the highly sought-after Gurnett neighbourhood on Hamilton Mountain. This inviting home offers the perfect blend of comfort, convenience, and low-maintenance living — ideal for first-time buyers, young families, downsizers, or savvy investors alike. Step inside to discover a sun-filled open-concept main floor thoughtfully designed for everyday living, with space to entertain. Freshly painted, new engineered hardwood and ceramic tile flooring and updated staircase. Large windows flood the living and dining areas with natural light, while the well-appointed kitchen features ample cabinetry, generous prep space, a well-appointed island and seamless flow. A convenient main floor powder room and access to single car garage further enhance the functionality of the space. Upstairs, are three generously sized bedrooms, including a welcoming Primary bedroom with spacious walk-in closet. A beautifully updated 4-piece bathroom completes the upper level. The lower level offers fantastic additional space with endless possibilities — ideal for a future recreation room, home office, gym, or play area — and includes laundry and storage. Enjoy outdoor space with private fully fenced yard, perfect for summer BBQs, morning coffee and relaxing. Ideally located just minutes from parks, schools, trails, shopping, public transit, highway access, and excellent restaurants, this home delivers an outstanding lifestyle in one of Hamilton Mountain's most desirable communities. Room sizes approximate. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "168"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T22:26:09.189619+00:00"
+"Directions": "STONE CHURCH TO UPPER PARADISE"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1922781"
+"ListOfficeKey": "55061"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T15:19:52Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T15:19:51Z"
+"Stories": "2.0"
+"StreetName": "UPPER PARADISE"
+"StreetNumber": "1000"
+"StreetSuffix": "Road"
+"SubdivisionName": "163 - Gurnett"
+"TaxAnnualAmount": "4601"
+"VirtualTourURLUnbranded": "https://www.thefostergroup.ca/1000-upper-paradise-rd-16-1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1656287605"
"RoomType" => "Utility room"
"ListingId" => "40838361"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29881916"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T15:19:51.97Z"
]
1 => array:11 [
"RoomKey" => "1656287606"
"RoomType" => "Laundry room"
"ListingId" => "40838361"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29881916"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T15:19:51.97Z"
]
2 => array:11 [
"RoomKey" => "1656287607"
"RoomType" => "Bedroom"
"ListingId" => "40838361"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29881916"
"RoomLength" => null
"RoomDimensions" => "8'5'' x 15'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T15:19:51.97Z"
]
3 => array:11 [
"RoomKey" => "1656287608"
"RoomType" => "Bedroom"
"ListingId" => "40838361"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29881916"
"RoomLength" => null
"RoomDimensions" => "8'7'' x 15'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T15:19:51.97Z"
]
4 => array:11 [
"RoomKey" => "1656287609"
"RoomType" => "5pc Bathroom"
"ListingId" => "40838361"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29881916"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T15:19:51.97Z"
]
5 => array:11 [
"RoomKey" => "1656287610"
"RoomType" => "Primary Bedroom"
"ListingId" => "40838361"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29881916"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 16'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T15:19:51.97Z"
]
6 => array:11 [
"RoomKey" => "1656287611"
"RoomType" => "Living room"
"ListingId" => "40838361"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29881916"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 21'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T15:19:51.97Z"
]
7 => array:11 [
"RoomKey" => "1656287612"
"RoomType" => "Dining room"
"ListingId" => "40838361"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29881916"
"RoomLength" => null
"RoomDimensions" => "8'7'' x 9'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T15:19:51.98Z"
]
8 => array:11 [
"RoomKey" => "1656287613"
"RoomType" => "Eat in kitchen"
"ListingId" => "40838361"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29881916"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T15:19:51.98Z"
]
9 => array:11 [
"RoomKey" => "1656287614"
"RoomType" => "2pc Bathroom"
"ListingId" => "40838361"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29881916"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T15:19:51.98Z"
]
10 => array:11 [
"RoomKey" => "1656287615"
"RoomType" => "Foyer"
"ListingId" => "40838361"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29881916"
"RoomLength" => null
"RoomDimensions" => "6'11'' x 18'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T15:19:51.98Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29881916/1000-upper-paradise-road-unit-16-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1524154"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "55061"
+"GeocodeManualYN": true
+"ZoningDescription": "RT-20/S-1370"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1316
+"OriginalEntryTimestamp": "2026-06-10T15:19:51.91Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1227686"
+"ListOfficeNationalAssociationId": "1003659"
+"CoListAgentNationalAssociationId": "1110863"
+"CoListOfficeNationalAssociationId": "1003659"
+"Media": array:44 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29881916_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/82b27c6efe52c0d7673c317447a08bf4.webp"
"MediaSize" => 157465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-82b27c6efe52c0d7673c317447a08bf4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29881916_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/35372c5cbd5c766711e4c023d8a252b6.webp"
"MediaSize" => 173947
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-35372c5cbd5c766711e4c023d8a252b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29881916_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/2d862648ab0c7219e75ad68120087462.webp"
"MediaSize" => 170298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-2d862648ab0c7219e75ad68120087462.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29881916_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/3f5a32a6d12c3412fe858a407ff95058.webp"
"MediaSize" => 34359
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-3f5a32a6d12c3412fe858a407ff95058.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29881916_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/6399097ee48dfe0faf89005d77fc57b5.webp"
"MediaSize" => 58524
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-6399097ee48dfe0faf89005d77fc57b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29881916_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/b756d3724ccc03f474ad7c889212517b.webp"
"MediaSize" => 85566
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-b756d3724ccc03f474ad7c889212517b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29881916_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/d113357f77360f0bd66ad9b906292e61.webp"
"MediaSize" => 83523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-d113357f77360f0bd66ad9b906292e61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29881916_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/25315a3206f024af1c32870a759cad00.webp"
"MediaSize" => 71935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-25315a3206f024af1c32870a759cad00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29881916_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/0ae0d593e4345df43f4202920f2589fa.webp"
"MediaSize" => 99470
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-0ae0d593e4345df43f4202920f2589fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29881916_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/cd7b3732a1e35a2d6eaf3a3fc2403c1d.webp"
"MediaSize" => 77578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-cd7b3732a1e35a2d6eaf3a3fc2403c1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29881916_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/c8e31584eb399a8c3a3d6a53d923e325.webp"
"MediaSize" => 73579
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-c8e31584eb399a8c3a3d6a53d923e325.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29881916_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/301a8e8f3eb1dbd77bac0ef5261db465.webp"
"MediaSize" => 65512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-301a8e8f3eb1dbd77bac0ef5261db465.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29881916_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/657b9234361418f24dd78da85a77b016.webp"
"MediaSize" => 70042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-657b9234361418f24dd78da85a77b016.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29881916_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/557df821dc2d90e1f26151087e4ac40d.webp"
"MediaSize" => 93570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-557df821dc2d90e1f26151087e4ac40d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29881916_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/c286dc81ca6f5d8e87ecb9c24098e255.webp"
"MediaSize" => 83291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-c286dc81ca6f5d8e87ecb9c24098e255.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29881916_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/ccfac2c56f27f7e8000365ccb44d1976.webp"
"MediaSize" => 70844
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-ccfac2c56f27f7e8000365ccb44d1976.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29881916_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/43475494c9a19caf834825476e6cde02.webp"
"MediaSize" => 35400
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-43475494c9a19caf834825476e6cde02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29881916_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/013f6a4e6167f5a857c98551612fd9e4.webp"
"MediaSize" => 67100
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-013f6a4e6167f5a857c98551612fd9e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29881916_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/702be725474ba99810db4a6509dff119.webp"
"MediaSize" => 52693
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-702be725474ba99810db4a6509dff119.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29881916_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/8f85b40024e21f1bbad685905ee715e4.webp"
"MediaSize" => 78720
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-8f85b40024e21f1bbad685905ee715e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29881916_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/b85315903bfe7d56695c172f7fb2bced.webp"
"MediaSize" => 69911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-b85315903bfe7d56695c172f7fb2bced.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29881916_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/20d46635c436ef8d353ecc8dd21e2859.webp"
"MediaSize" => 62735
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-20d46635c436ef8d353ecc8dd21e2859.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29881916_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/924428d4afd4d3639032268f2085f885.webp"
"MediaSize" => 65484
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-924428d4afd4d3639032268f2085f885.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29881916_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/f00173f3ec55e6b30f513b5cebb7b42e.webp"
"MediaSize" => 63211
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-f00173f3ec55e6b30f513b5cebb7b42e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29881916_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/e1f2160756c87fa17b3e7cde3264da7f.webp"
"MediaSize" => 54104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-e1f2160756c87fa17b3e7cde3264da7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29881916_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/7f89500b6275ab8d9e1c35d146990e97.webp"
"MediaSize" => 77682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-7f89500b6275ab8d9e1c35d146990e97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29881916_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/10586493f74ac4539320570f31ce7ec0.webp"
"MediaSize" => 66736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-10586493f74ac4539320570f31ce7ec0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29881916_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/be8492dee04fc8385fc029cd43ab9d20.webp"
"MediaSize" => 58730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-be8492dee04fc8385fc029cd43ab9d20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually staged converting office to bdrm"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29881916_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/0b70c00d31c400fb5138ff39ffbb5d95.webp"
"MediaSize" => 188340
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-0b70c00d31c400fb5138ff39ffbb5d95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29881916_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/fd9bb7292423d9fda5478b1d172886f2.webp"
"MediaSize" => 202298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-fd9bb7292423d9fda5478b1d172886f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29881916_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/9db9a61575dabe7f10251d8f80552850.webp"
"MediaSize" => 162502
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-9db9a61575dabe7f10251d8f80552850.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29881916_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/7038169c187923ae58d020572e97f4de.webp"
"MediaSize" => 152717
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-7038169c187923ae58d020572e97f4de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29881916_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/e96a7e78108f93d4c0a1ed55ae180a95.webp"
"MediaSize" => 201569
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-e96a7e78108f93d4c0a1ed55ae180a95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29881916_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/458edd999abb4c81dd8de19c9f2a64b5.webp"
"MediaSize" => 208924
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-458edd999abb4c81dd8de19c9f2a64b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29881916_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/6451071c74a2231390e34dd1234a37c0.webp"
"MediaSize" => 210377
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-6451071c74a2231390e34dd1234a37c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29881916_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/7cb7f6d45696c4753dcdfb3dce4c6274.webp"
"MediaSize" => 180551
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-7cb7f6d45696c4753dcdfb3dce4c6274.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29881916_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/30fa0ef1d7ec1662fa129773e8530d28.webp"
"MediaSize" => 201380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-30fa0ef1d7ec1662fa129773e8530d28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29881916_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/de8b2aa31273d6f9cd8c6a873b68977a.webp"
"MediaSize" => 178000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-de8b2aa31273d6f9cd8c6a873b68977a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29881916_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/91075ceb502b5c5f8f7f4f2630dab39e.webp"
"MediaSize" => 178669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-91075ceb502b5c5f8f7f4f2630dab39e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29881916_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/b47ffc28e1df784dfccba71dc01d4027.webp"
"MediaSize" => 184942
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-b47ffc28e1df784dfccba71dc01d4027.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29881916_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/744873b114e6d1f4af6c5f61b3f3378b.webp"
"MediaSize" => 172436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-744873b114e6d1f4af6c5f61b3f3378b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29881916_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/2a5626336b9babf8869e5f533594f270.webp"
"MediaSize" => 196387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-2a5626336b9babf8869e5f533594f270.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29881916_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/b016333a3b68d0120871ad2d81ff2b08.webp"
"MediaSize" => 182619
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-b016333a3b68d0120871ad2d81ff2b08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29881916_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29881916/cd2aaf1adbd3b4b2acc236640a7ac109.webp"
"MediaSize" => 165903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29881916/thumbnail-cd2aaf1adbd3b4b2acc236640a7ac109.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838361"
"ResourceRecordKey" => "29881916"
"ModificationTimestamp" => "2026-06-10T15:19:51.92Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29881916')"
+"ID": "1516814"
}
]
+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=OfficeMlsId eq 55061" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24712
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1922781" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24705
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29881916'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25117
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29881916'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25133
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29881916' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.9205611 43.2155144)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25206
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25200
+post_id: "1517727"
+post_author: 1
+"ListingKey": "29885027"
+"ListingId": "40838771"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T20:40:15Z"
+"RFModificationTimestamp": "2026-06-11T02:35:15Z"
+"ListPrice": 939900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.11
+"LivingArea": 2960.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L9B2R5"
+"UnparsedAddress": "51 REDTAIL Crescent, Hamilton, Ontario L9B2R5"
+"Coordinates": array:2 [
0 => -79.924602
1 => 43.2058995
]
+"Latitude": 43.2058995
+"Longitude": -79.924602
+"YearBuilt": 1997
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 51 Redtail Crescent, a beautifully maintained all-brick home tucked away on a quiet street in the highly sought-after Carpenter neighbourhood on Hamilton Mountain. Offering space, versatility, and comfort, this 4-bedroom, 2.5-bathroom home features a double car garage and a fully finished walk-out basement with separate entrance — ideal for multigenerational living or an in-law suite. The lower level includes a full kitchen with butcher block countertops and white appliances, two bedrooms, a bathroom, and a spacious rec room with an electric fireplace, creating a comfortable and private living area. The bright and inviting main floor features a vaulted ceiling in the living room, a cozy gas fireplace, and new custom sliding doors leading to a raised deck — perfect for relaxing or entertaining. Luxury vinyl flooring flows throughout the home, including new flooring in the main floor bedrooms, which also feature upgraded triple-pane windows for enhanced soundproofing and energy efficiency. Large windows throughout the home fill the space with natural light, creating a warm and welcoming atmosphere. Recent mechanical updates include furnace, central air conditioner, and hot water tank (approximately 3 years old). Additional features include central vacuum, security system, and abundant storage throughout. The exterior offers excellent curb appeal with a concrete driveway, wraparound concrete walkway, and concrete stairs leading to the backyard and lower level entrance. Conveniently located close to parks, schools, shopping, and commuter routes, with quick access to the Lincoln M. Alexander Parkway and Highway 403. A fantastic opportunity to own a versatile and well-cared-for home in one of Hamilton Mountain’s most desirable neighbourhoods. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T02:35:13.060293+00:00"
+"Directions": "Upper Paradise Rd., West on Eagleglen Way, South on Redtail Cres. House on Left"
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Brick"
2 => "Shingles"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2191889"
+"ListOfficeKey": "275238"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Recreational"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
3 => "In-Law Suite"
]
+"LotSizeDimensions": "0.11"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T20:31:54Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T20:31:53Z"
+"Stories": "1.0"
+"StreetName": "REDTAIL"
+"StreetNumber": "51"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "168 - Carpenter"
+"TaxAnnualAmount": "6198.15"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1656505076"
"RoomType" => "Storage"
"ListingId" => "40838771"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29885027"
"RoomLength" => null
"RoomDimensions" => "5'2'' x 6'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T20:31:53.92Z"
]
1 => array:11 [
"RoomKey" => "1656505077"
"RoomType" => "Utility room"
"ListingId" => "40838771"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29885027"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T20:31:53.92Z"
]
2 => array:11 [
"RoomKey" => "1656505078"
"RoomType" => "Recreation room"
"ListingId" => "40838771"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29885027"
"RoomLength" => null
"RoomDimensions" => "15'4'' x 27'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T20:31:53.92Z"
]
3 => array:11 [
"RoomKey" => "1656505079"
"RoomType" => "Eat in kitchen"
"ListingId" => "40838771"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29885027"
"RoomLength" => null
"RoomDimensions" => "14'3'' x 17'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T20:31:53.92Z"
]
4 => array:11 [
"RoomKey" => "1656505080"
"RoomType" => "3pc Bathroom"
"ListingId" => "40838771"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29885027"
"RoomLength" => null
"RoomDimensions" => "7'1'' x 12'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T20:31:53.92Z"
]
5 => array:11 [
"RoomKey" => "1656505081"
"RoomType" => "Bedroom"
"ListingId" => "40838771"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29885027"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 13'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T20:31:53.92Z"
]
6 => array:11 [
"RoomKey" => "1656505082"
"RoomType" => "Bedroom"
"ListingId" => "40838771"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29885027"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T20:31:53.93Z"
]
7 => array:11 [
"RoomKey" => "1656505083"
"RoomType" => "Laundry room"
"ListingId" => "40838771"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29885027"
"RoomLength" => null
"RoomDimensions" => "6'6'' x 8'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T20:31:53.93Z"
]
8 => array:11 [
"RoomKey" => "1656505084"
"RoomType" => "2pc Bathroom"
"ListingId" => "40838771"
"RoomLevel" => "Main level"
"RoomWidth" => null
…6
]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29885027/51-redtail-crescent-hamilton"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "R1A"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 43.0
+"AboveGradeFinishedArea": 1475
+"BelowGradeFinishedArea": 1485
+"OriginalEntryTimestamp": "2026-06-10T20:31:53.83Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1440857"
+"ListOfficeNationalAssociationId": "1263001"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29885027')"
+"ID": "1517727"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25202
+post_id: "1516815"
+post_author: 1
+"ListingKey": "29882360"
+"ListingId": "X13425606"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T16:10:14Z"
+"RFModificationTimestamp": "2026-06-10T22:02:16Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Gurnett)"
+"PostalCode": "L9B2S7"
+"UnparsedAddress": "16 - 1000 UPPER PARADISE ROAD, Hamilton (Gurnett), Ontario L9B2S7"
+"Coordinates": array:2 [
0 => -79.920359
1 => 43.215454
]
+"Latitude": 43.215454
+"Longitude": -79.920359
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this bright and recently updated 3-bedroom townhouse, ideally situated in the highly sought-after Gurnett neighbourhood on Hamilton Mountain. This inviting home offers the perfect blend of comfort, convenience, and low-maintenance living - ideal for first-time buyers, young families, downsizers, or savvy investors alike. Step inside to discover a sun-filled open-concept main floor thoughtfully designed for everyday living, with space to entertain. Freshly painted, new engineered hardwood and ceramic tile flooring and updated staircase. Large windows flood the living and dining areas with natural light, while the well-appointed kitchen features ample cabinetry, generous prep space, a well-appointed island and seamless flow. A convenient main floor powder room and access to single car garage further enhance the functionality of the space. Upstairs, are three generously sized bedrooms, including a welcoming Primary bedroom with spacious walk-in closet. A beautifully updated 4-piece bathroom completes the upper level. The lower level offers fantastic additional space with endless possibilities - ideal for a future recreation room, home office, gym, or play area - and includes laundry and storage. Enjoy outdoor space with private fully fenced yard, perfect for summer BBQs, morning coffee and relaxing. Ideally located just minutes from parks, schools, trails, shopping, public transit, highway access, and excellent restaurants, this home delivers an outstanding lifestyle in one of Hamilton Mountain's most desirable communities. Room sizes approximate. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Microwave"
6 => "Garage door opener remote(s)"
]
+"AssociationFee": "168"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T22:02:05.142087+00:00"
+"Directions": "Stone Church"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1413922"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T16:02:01Z"
+"PhotosCount": 44
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T16:02:01Z"
+"Stories": "2.0"
+"StreetName": "Upper Paradise"
+"StreetNumber": "1000"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4601"
+"VirtualTourURLUnbranded": "https://www.thefostergroup.ca/1000-upper-paradise-rd-16-1"
+"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": "Gurnett"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29882360/16-1000-upper-paradise-road-hamilton-gurnett-gurnett"
+"ParkingTotal": 2
+"CommonInterest": "Condo/Strata"
+"AssociationName": "PROPERTY MANAGEMENT COMPANY"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-10T16:02:01.14Z"
+"ListAgentNationalAssociationId": "1243509"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:44 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29882360')"
+"ID": "1516815"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25199
+post_id: "1515213"
+post_author: 1
+"ListingKey": "29882051"
+"ListingId": "X13424928"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T17:45:13Z"
+"RFModificationTimestamp": "2026-06-10T18:16:30Z"
+"ListPrice": 889888.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Gilkson)"
+"PostalCode": "L9B1A5"
+"UnparsedAddress": "565 STONE CHURCH ROAD W, Hamilton (Gilkson), Ontario L9B1A5"
+"Coordinates": array:2 [
0 => -79.914395
1 => 43.217174
]
+"Latitude": 43.217174
+"Longitude": -79.914395
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 565 Stone Church Road West, a beautifully maintained 3+1 bedroom, 3 bathroom home offering exceptional space, versatility, and in-law suite potential in one of Hamilton Mountain's most convenient family-friendly communities.This move-in-ready home features a private separate entrance, making it ideal for multi-generational living, or extended family The main level offers bright and spacious living and dining rooms accented by hardwood flooring (2019), while the updated kitchen showcases refaced cabinetry and countertops (2023), providing a fresh, modern feel. The inviting family room features a walkout to the rear yard, creating the perfect space for entertaining or relaxing outdoors.Numerous updates provide peace of mind, including most windows replaced, shingles (2025), and spray foam insulation in the crawl space (2026) for improved energy efficiency.Located in the heart of Hamilton Mountain, you'll enjoy easy access to excellent schools, parks, recreation centres, shopping, restaurants, and everyday amenities. Just minutes from Limeridge Mall, the Lincoln M. Alexander Parkway, Highway 403 access, public transit, and scenic walking trails, this location offers the perfect balance of convenience and community.Whether you're a growing family, downsizer seeking flexibility, or investor looking for future potential, this well-cared-for home offers outstanding value in a sought-after neighbourhood. Don't miss your opportunity to make this Hamilton Mountain gem your next home. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"Basement": array:1 [
0 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T18:16:26.162471+00:00"
+"Directions": "Cross Streets: UPPER PARADISE. ** Directions: GARTH, WEST ON STONE CHURCH."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Wood"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2095037"
+"ListOfficeKey": "283302"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "42.4 x 120 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T15:33:23Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T17:32:26Z"
+"StreetDirSuffix": "West"
+"StreetName": "Stone Church"
+"StreetNumber": "565"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6392.76"
+"VirtualTourURLUnbranded": "https://viralrealestate.media/565-stone-church-rd-w"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Gilkson"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29882051/565-stone-church-road-w-hamilton-gilkson-gilkson"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 42.4
+"OriginalEntryTimestamp": "2026-06-10T15:33:23.3Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1367257"
+"ListOfficeNationalAssociationId": "1327324"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29882051')"
+"ID": "1515213"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25203
+post_id: "1514344"
+post_author: 1
+"ListingKey": "29881371"
+"ListingId": "40838373"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T18:00:10Z"
+"RFModificationTimestamp": "2026-06-10T18:00:41Z"
+"ListPrice": 889888.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2793.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L9B1A5"
+"UnparsedAddress": "565 STONE CHURCH Road E, Hamilton, Ontario L9B1A5"
+"Coordinates": array:2 [
0 => -79.9137838
1 => 43.2173946
]
+"Latitude": 43.2173946
+"Longitude": -79.9137838
+"YearBuilt": 1987
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 565 Stone Church Road W, a beautifully maintained 3+1 bedroom, 3 bathroom home offering exceptional space, versatility, and in-law suite potential in one of Hamilton Mountain's most convenient family-friendly communities. This move-in-ready home features a private separate entrance, making it ideal for multi-generational living, or extended family The main level offers bright and spacious living and dining rooms accented by hardwood flooring (2019), while the updated kitchen showcases refaced cabinetry and countertops (2023), providing a fresh, modern feel. The inviting family room features a walkout to the rear yard, creating the perfect space for entertaining or relaxing outdoors. Numerous updates provide peace of mind, including most windows replaced, shingles (2025), and spray foam insulation in the crawl space (2026) for improved energy efficiency. Located in the heart of Hamilton Mountain, you'll enjoy easy access to excellent schools, parks, recreation centres, shopping, restaurants, and everyday amenities. Just minutes from Limeridge Mall, the Lincoln M. Alexander Parkway, Highway 403 access, public transit, and scenic walking trails, this location offers the perfect balance of convenience and community. Whether you're a growing family, downsizer seeking flexibility, or investor looking for future potential, this well-cared-for home offers outstanding value in a sought-after neighbourhood. Don't miss your opportunity to make this Hamilton Mountain gem your next home. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T14:53:50.116181+00:00"
+"Directions": "GARTH, WEST ON STONE CHURCH RD"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1523583"
+"ListOfficeKey": "289276"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T14:20:43Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T17:50:59Z"
+"Stories": "3.0"
+"StreetDirSuffix": "West"
+"StreetName": "STONE CHURCH"
+"StreetNumber": "565"
+"StreetSuffix": "Road"
+"SubdivisionName": "164 - Gilkson"
+"TaxAnnualAmount": "6392.76"
+"VirtualTourURLUnbranded": "https://viralrealestate.media/565-stone-church-rd-w"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29881371/565-stone-church-road-w-hamilton"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1524351"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "67816"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 2139
+"BelowGradeFinishedArea": 654
+"OriginalEntryTimestamp": "2026-06-10T14:20:42.75Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1121317"
+"ListOfficeNationalAssociationId": "1376254"
+"CoListAgentNationalAssociationId": "1064626"
+"CoListOfficeNationalAssociationId": "1132083"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29881371')"
+"ID": "1514344"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25201
+post_id: "1514245"
+post_author: 1
+"ListingKey": "29881222"
+"ListingId": "40838480"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T14:05:07Z"
+"RFModificationTimestamp": "2026-06-10T14:32:13Z"
+"ListPrice": 829900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1970.0
+"BuildingAreaTotal": 0
+"City": "Ancaster"
+"PostalCode": "L9K0J8"
+"UnparsedAddress": "30 HEMING Trail, Ancaster, Ontario L9K0J8"
+"Coordinates": array:2 [
0 => -79.9332515
1 => 43.2105265
]
+"Latitude": 43.2105265
+"Longitude": -79.9332515
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "1,970 sq ft of turnkey luxury in one of Ancaster’s most sought-after communities. This impeccably upgraded 3-bed, 2.5-bath townhome delivers the finishes buyers expect at this price point — and then some. The main floor opens with marble entry and gleaming wide-plank engineered hardwood flowing through sun-filled principal rooms. A custom oak staircase with wrought iron pickets anchors the space. The great room features a gas fireplace and views to a private finished patio — your outdoor retreat, ready to enjoy. The kitchen is the centerpiece: KitchenAid stainless appliances, quartz countertops, solid maple cabinetry with glass-front uppers, a statement decorative range hood, gas range, and an oversized undermount sink in the island. A genuine chef’s kitchen, not just a label. Upstairs, three generous bedrooms including a primary suite with walk-in closet and a luxurious 5-piece ensuite — soaker tub, glass-enclosed shower, his-and-hers sinks, private water closet. Laundry room on the same level. Central whole-home vacuum throughout. Over $30K in builder upgrades. Steps to top-rated schools and parks. Minutes to Costco, Home Depot, Golf, restaurants, and Hwy 403. Meticulously maintained by AAA tenants who kept the home in immaculate condition — and are moving on July 15th. Move in with confidence. (id:62650)"
+"Appliances": array:1 [
0 => "Central Vacuum"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T14:31:59.666412+00:00"
+"Directions": "Rymal to Raymond"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Stucco"
2 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1917243"
+"ListOfficeKey": "264845"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T14:00:10Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T14:00:10Z"
+"Stories": "2.0"
+"StreetName": "HEMING"
+"StreetNumber": "30"
+"StreetSuffix": "Trail"
+"SubdivisionName": "423 - Meadowlands"
+"TaxAnnualAmount": "6918"
+"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/29881222/30-heming-trail-ancaster"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "RM2-615"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1970
+"BelowGradeFinishedArea": 0
+"OriginalEntryTimestamp": "2026-06-10T14:00:10.29Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1225588"
+"ListOfficeNationalAssociationId": "1225289"
+"Media": array:27 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29881222')"
+"ID": "1514245"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25195
+post_id: "1513918"
+post_author: 1
+"ListingKey": "29880459"
+"ListingId": "X13423678"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T03:55:35Z"
+"RFModificationTimestamp": "2026-06-10T04:30:59Z"
+"ListPrice": 689999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Villages of Glancaster)"
+"PostalCode": "L9G3K9"
+"UnparsedAddress": "13 - 345 GLANCASTER ROAD, Hamilton (Villages of Glancaster), Ontario L9G3K9"
+"Coordinates": array:2 [
0 => -79.930484
1 => 43.200701
]
+"Latitude": 43.200701
+"Longitude": -79.930484
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to the impeccable executive townhome in an exquisite private neighbourhood. This stunning 3-bedroom townhome nestled in a quiet and highly desirable Ancaster community comes fully renovated with highly modern finishes. The entire main and second floor has been renovated with brand new hardwood flooring. This property is perfectly located just minutes from Glancaster Golf & Country Club, Highway 403, schools, shopping, Hamilton International Airport and Amazons Massive Fulfilment Centre. The bright, open-concept main floor features elegant hardwood and porcelain flooring, a spacious living and dining area, and a modern kitchen with stainless steel appliances, modern countertops, a double sink, and ample cabinetry with a breakfast-bar. Step through the sliding doors to a private deck and fully fenced backyard backing unto a reserved ravine, ideal for BBQs, entertaining, or relaxing with your morning coffee. Upstairs offers 3 generous bedrooms, including a large primary suite with a walk-in closet and a luxurious 5-piece ensuite featuring a double vanity. A versatile loft area provides the perfect space for working from home or a cozy reading nook. The unspoiled basement adds approximately 700+ sq. ft. of potential living space. Move-in ready with extremely low maintenance fees of just $188, this home perfectly combines comfort, functionality, and an unbeatable location. (id:62650)"
+"AssociationFee": "188"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T04:30:56.323794+00:00"
+"Directions": "Glancaster Rd and Kopperfield Lane"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1945162"
+"ListOfficeKey": "279429"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-10T03:45:39Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T03:45:39Z"
+"Stories": "2.0"
+"StreetName": "GLANCASTER"
+"StreetNumber": "345"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3844"
+"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"
+"TaxYear": 2025
+"CityRegion": "Villages of Glancaster"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29880459/13-345-glancaster-road-hamilton-villages-of-glancaster-villages-of-glancaster"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2128446"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"CoListOfficeKey": "279429"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Storage - Locker"
1 => "Visitor Parking"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-10T03:45:39.88Z"
+"ListAgentNationalAssociationId": "1240641"
+"ListOfficeNationalAssociationId": "1304440"
+"CoListAgentNationalAssociationId": "1381587"
+"CoListOfficeNationalAssociationId": "1304440"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29880459')"
+"ID": "1513918"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23352
+post_id: "1513423"
+post_author: 1
+"ListingKey": "29880049"
+"ListingId": "40838428"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T00:45:08Z"
+"RFModificationTimestamp": "2026-06-10T01:38:22Z"
+"ListPrice": 779900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1579.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L9C6B5"
+"UnparsedAddress": "73 APPLEFORD Road, Hamilton, Ontario L9C6B5"
+"Coordinates": array:2 [
0 => -79.9198846
1 => 43.229849
]
+"Latitude": 43.229849
+"Longitude": -79.9198846
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Why spend your summers at someone else's cottage when you can have your own backyard resort? Welcome to 73 Appleford Road, a beautifully maintained 4-level backsplit backing onto the park-like grounds of Sir Allan MacNab Secondary School with no rear neighbours. The standout feature inside is the open-concept main level, created by opening up the original floor plan years ago to deliver the spacious kitchen, dining and living area today's buyers are searching for. Upstairs offers 3 bedrooms and a full bathroom, while the lower level features a cozy family room with gas fireplace, wet bar, 4th bedroom currently used as a home office, 3-piece bathroom with walk-in shower, and walkout to the backyard. Outside, summer awaits with a crystal-clear 16' x 32' heated saltwater pool, gazebo with swing, expansive patio, mature landscaping, and plenty of room for entertaining family and friends. Freshly painted throughout and move-in ready, with major updates including furnace and central air (2024), roof (2022), windows, lawn sprinkler system, newer laundry appliances, and most pool equipment replaced within the last 2-5 years. Parking for 3 vehicles. A rare opportunity to enjoy open-concept living, a backyard oasis, and one of Hamilton Mountain's most desirable family-friendly neighbourhoods. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Dryer"
5 => "Wet Bar"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T01:38:19.094527+00:00"
+"Directions": "Mohawk Rd W & Magnolia Dr"
+"ExteriorFeatures": array:3 [
0 => "Aluminum siding"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525324"
+"ListOfficeKey": "284640"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Wet bar"
2 => "Skylight"
3 => "Gazebo"
]
+"PhotosChangeTimestamp": "2026-06-10T00:39:16Z"
+"PhotosCount": 46
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T00:39:15Z"
+"Stories": "2.0"
+"StreetName": "APPLEFORD"
+"StreetNumber": "73"
+"StreetSuffix": "Road"
+"SubdivisionName": "160 - Fessenden"
+"TaxAnnualAmount": "5060.33"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=bHavwdrKNpY"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29880049/73-appleford-road-hamilton"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1617329"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "262629"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1137
+"BelowGradeFinishedArea": 442
+"OriginalEntryTimestamp": "2026-06-10T00:39:15.85Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1136826"
+"ListOfficeNationalAssociationId": "1344651"
+"CoListAgentNationalAssociationId": "1159924"
+"CoListOfficeNationalAssociationId": "1223032"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29880049')"
+"ID": "1513423"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25204
+post_id: "1512095"
+post_author: 1
+"ListingKey": "29878252"
+"ListingId": "X13421826"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T19:05:11Z"
+"RFModificationTimestamp": "2026-06-10T19:24:16Z"
+"ListPrice": 1599000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Meadowlands)"
+"PostalCode": "L9K0H4"
+"UnparsedAddress": "31 DORR COURT, Hamilton (Meadowlands), Ontario L9K0H4"
+"Coordinates": array:2 [
0 => -79.9319
1 => 43.217869
]
+"Latitude": 43.217869
+"Longitude": -79.9319
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 31 Dorr Court, a prestigious Meadowlands estate address. Situated at the end of a private court, this stunning executive home occupies a massive pie shaped ravine lot and offers exceptional curb appeal. Fully landscaped and featuring a cobblestone driveway and walkway, stone and stucco exterior, oversized double car garage, custom front entrance, Juliette balcony and tasteful softscaping, this home makes a remarkable first impression. The interior does not disappoint. Completely upgraded and customized on all three levels with the guidance of an interior decorator and a generous budget, quality and attention to detail are evident throughout. Highlights include soaring ceilings, spacious principal rooms, a chef-inspired custom kitchen with solid surface countertops, Padova fireplace, custom lighting and an oversized elevated Trex deck overlooking the expansive pie shaped lot and lush ravine setting. The second floor features a massive primary suite with ravine views, a luxurious spa-like ensuite, a custom laundry room, fitted walk-in closets and generously sized secondary bedrooms with semi-ensuite privileges. The professionally finished lower level offers a large recreation room with a wet bar/servery, a custom 4-piece bathroom, tasteful décor, a striking gas fireplace, and a fully equipped home gym with a walkout that could easily be converted into an additional bedroom. Step outside to the walkout rear yard, where the pie-shaped ravine lot showcases an oversized interlock patio, contemporary outbuilding, full fencing, complete privacy, tranquility, and an abundance of spectacular wildlife. This exceptional home backs onto conservation land that will never be developed! Don't miss this opportunity - it truly checks all the boxes. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Range"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T21:34:41.946769+00:00"
+"Directions": "Cross Streets: Garner Rd. / Raymond Rd. ** Directions: Garner Rd. / Raymond Rd. / Sutherland Cres. to Woodhouse St. to Dorr Crt."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Flooring": array:3 [
0 => "Tile"
1 => "Hardwood"
2 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235996"
+"ListOfficeKey": "283410"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Wooded area"
1 => "Ravine"
]
+"LotSizeDimensions": "35.9 x 122.6 FT ; 35.90 x 122.64 x 102.19 x 91.46"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T19:48:24Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T18:57:35Z"
+"Stories": "2.0"
+"StreetName": "Dorr"
+"StreetNumber": "31"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "10138"
+"VirtualTourURLUnbranded": "https://houses-by-hilary.aryeo.com/videos/019eb213-1d1e-7112-84b8-16ab7da38428"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Meadowlands"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29878252/31-dorr-court-hamilton-meadowlands-meadowlands"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1567465"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283410"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R4-612"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 35.1
+"OriginalEntryTimestamp": "2026-06-09T19:48:24.4Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1473947"
+"ListOfficeNationalAssociationId": "1328651"
+"CoListAgentNationalAssociationId": "1293072"
+"CoListOfficeNationalAssociationId": "1328651"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29878252')"
+"ID": "1512095"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25205
+post_id: "1511731"
+post_author: 1
+"ListingKey": "29877400"
+"ListingId": "40838103"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T18:30:25Z"
+"RFModificationTimestamp": "2026-06-09T19:54:30Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2085.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L9C2P6"
+"UnparsedAddress": "146 CLIFTON DOWNS Road, Hamilton, Ontario L9C2P6"
+"Coordinates": array:2 [
0 => -79.9108521
1 => 43.2301627
]
+"Latitude": 43.2301627
+"Longitude": -79.9108521
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A charming raised bungalow nestled on a generous 55 x 125 ft lot in a desirable Hamilton mountain neighbourhood. This thoughtfully maintainedhome offers 3+2 bedrooms and 2 full bathrooms across 1,104 sq ft of functional living space, perfect for families, professionals, or downsizers.The main floor features a bright, spacious living room and a well-appointed galley kitchen with modern cabinetry and clean finishes. The layoutflows effortlessly to three generous bedrooms, offering privacy and comfort. The fully finished lower level, bathed in natural light from largeabove-grade windows, includes two additional bedrooms, a full bathroom, and a separate entrance — ideal for a guest suite, home office, orpotential in-law setup. Enjoy the private, fully fenced backyard with mature cedar hedging, lush gardens, and a cozy patio — an outdoor retreatfor summer evenings and entertaining. Complete with an attached garage, double driveway, and proximity to parks, schools, shopping, andtransit. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T19:54:24.583545+00:00"
+"Directions": "Upper Paradise to Mohawk to Darlington"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T18:21:29Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T18:21:29Z"
+"Stories": "1.0"
+"StreetName": "CLIFTON DOWNS"
+"StreetNumber": "146"
+"StreetSuffix": "Road"
+"SubdivisionName": "161 - Gilbert"
+"TaxAnnualAmount": "5279"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29877400/146-clifton-downs-road-hamilton"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 55.0
+"AboveGradeFinishedArea": 1104
+"BelowGradeFinishedArea": 981
+"OriginalEntryTimestamp": "2026-06-09T18:20:32.29Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1064132"
+"ListOfficeNationalAssociationId": "1269881"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29877400')"
+"ID": "1511731"
}
]
+success: true
+page_size: 9
+page_count: 28
+count: 248
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
]