array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29235195/Property?$select=ALL&$top=20&$filter=ListingKey eq 29235195&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29235195/Property?$select=ALL&$top=20&$filter=ListingKey eq 29235195&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23484
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "523152"
+post_author: 1
+"ListingKey": "29235195"
+"ListingId": "40797466"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T18:01:06Z"
+"RFModificationTimestamp": "2026-01-14T18:05:46Z"
+"ListPrice": 499999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1435.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E4X3"
+"UnparsedAddress": "618 BARTON Street Unit# 4, Stoney Creek, Ontario L8E4X3"
+"Coordinates": array:2 [
0 => -79.7028697
1 => 43.221769
]
+"Latitude": 43.221769
+"Longitude": -79.7028697
+"YearBuilt": 1989
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Ideally located in a sought-after Stoney Creek community, this well-cared-for 3 bedroom, 3 bathroom condo townhouse offers a spacious and functional layout ideal for everyday living and entertaining—perfect for first-time buyers and empty nesters alike. The open-concept living and dining area creates a welcoming atmosphere, while the galley-style eat-in kitchen features a bay window in the dining nook, providing a comfortable space for casual meals. The primary bedroom offers a private ensuite and walk-in closet, complemented by two additional generously sized bedrooms suitable for family, guests, or a home office. Inside access from the garage leads to a practical mudroom-style landing and continues to the finished basement, offering flexible additional living space. Enjoy a comfortable backyard ideal for outdoor relaxation. Conveniently located close to shopping, restaurants, schools, transit, and highway access, this home presents an excellent opportunity in a desirable location. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFee": "569.07"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Water"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T21:02:05.589777+00:00"
+"Directions": "West of Fruitland Rd on Barton - South side"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1803927"
+"ListOfficeKey": "288925"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T20:19:14Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T17:49:40Z"
+"Stories": "2.0"
+"StreetName": "BARTON"
+"StreetNumber": "618"
+"StreetSuffix": "Street"
+"SubdivisionName": "512 - Guernsey/Westmeria/Industrial"
+"TaxAnnualAmount": "5446.04"
+"VirtualTourURLUnbranded": "https://view.doamedia.ca/order/ad4e2ddc-1b40-4d7c-74c5-08de4a31b71b"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1560311633"
"RoomType" => "3pc Bathroom"
"ListingId" => "40797466"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29235195"
"RoomLength" => null
"RoomDimensions" => "5' x 7'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T17:49:40.35Z"
]
1 => array:11 [
"RoomKey" => "1560311634"
"RoomType" => "Utility room"
"ListingId" => "40797466"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29235195"
"RoomLength" => null
"RoomDimensions" => "7'4'' x 19'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T17:49:40.35Z"
]
2 => array:11 [
"RoomKey" => "1560311635"
"RoomType" => "Family room"
"ListingId" => "40797466"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29235195"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 18'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T17:49:40.35Z"
]
3 => array:11 [
"RoomKey" => "1560311636"
"RoomType" => "4pc Bathroom"
"ListingId" => "40797466"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29235195"
"RoomLength" => null
"RoomDimensions" => "5' x 7'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T17:49:40.35Z"
]
4 => array:11 [
"RoomKey" => "1560311637"
"RoomType" => "Bedroom"
"ListingId" => "40797466"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29235195"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T17:49:40.35Z"
]
5 => array:11 [
"RoomKey" => "1560311638"
"RoomType" => "Bedroom"
"ListingId" => "40797466"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29235195"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T17:49:40.36Z"
]
6 => array:11 [
"RoomKey" => "1560311639"
"RoomType" => "Primary Bedroom"
"ListingId" => "40797466"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29235195"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 13'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T17:49:40.36Z"
]
7 => array:11 [
"RoomKey" => "1560311640"
"RoomType" => "2pc Bathroom"
"ListingId" => "40797466"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29235195"
"RoomLength" => null
"RoomDimensions" => "3'6'' x 7'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T17:49:40.36Z"
]
8 => array:11 [
"RoomKey" => "1560311641"
"RoomType" => "Living room"
"ListingId" => "40797466"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29235195"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 18'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T17:49:40.36Z"
]
9 => array:11 [
"RoomKey" => "1560311642"
"RoomType" => "Dining room"
"ListingId" => "40797466"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29235195"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 7'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T17:49:40.36Z"
]
10 => array:11 [
"RoomKey" => "1560311643"
"RoomType" => "Dinette"
"ListingId" => "40797466"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29235195"
"RoomLength" => null
"RoomDimensions" => "7'1'' x 7'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T17:49:40.36Z"
]
11 => array:11 [
"RoomKey" => "1560311644"
"RoomType" => "Eat in kitchen"
"ListingId" => "40797466"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29235195"
"RoomLength" => null
"RoomDimensions" => "7'4'' x 7'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T17:49:40.36Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29235195/618-barton-street-unit-4-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2040841"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "55005"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "RM3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1160
+"BelowGradeFinishedArea": 275
+"OriginalEntryTimestamp": "2026-01-09T20:19:14.47Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Assessor"
+"Media": array:37 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6398372283"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/b767f4ffdad9c3bab652677c4ec83edb.webp"
"MediaSize" => 131687
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-b767f4ffdad9c3bab652677c4ec83edb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6398372300"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/8c0448a05a63842b4450657b6d55bb2d.webp"
"MediaSize" => 129702
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-8c0448a05a63842b4450657b6d55bb2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6398372385"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/dbe043c61b63fc4431fb0cba73903941.webp"
"MediaSize" => 69125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-dbe043c61b63fc4431fb0cba73903941.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6398372478"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/c6e0ce97e764edf42fb52b58e861e3e2.webp"
"MediaSize" => 70290
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-c6e0ce97e764edf42fb52b58e861e3e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6398372563"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/7a6956719708e71413dfe5ced9c26e86.webp"
"MediaSize" => 62367
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-7a6956719708e71413dfe5ced9c26e86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6398372629"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/0d56e0c550e5e36654fb2c2ef1231c46.webp"
"MediaSize" => 90213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-0d56e0c550e5e36654fb2c2ef1231c46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6398372696"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/45bcbda2aa384703e2aa5e32dd10cb94.webp"
"MediaSize" => 78623
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-45bcbda2aa384703e2aa5e32dd10cb94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6398372776"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/20f63212790a54f1cfb4f71ac63b91d1.webp"
"MediaSize" => 75774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-20f63212790a54f1cfb4f71ac63b91d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6398372864"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/0843cd9e8ceee42acf02b696909fa438.webp"
"MediaSize" => 85343
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-0843cd9e8ceee42acf02b696909fa438.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6398372929"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/41976eaec6ee26c453b07a209cb7bcea.webp"
"MediaSize" => 83968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-41976eaec6ee26c453b07a209cb7bcea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6398372972"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/608f29a8f9b937e31bfad33e659a4e84.webp"
"MediaSize" => 74516
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-608f29a8f9b937e31bfad33e659a4e84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6398373042"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/8513b3fd6edde712989ffffb863f8f41.webp"
"MediaSize" => 61758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-8513b3fd6edde712989ffffb863f8f41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6398373096"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/3b7bb61f7cb1dd1de6c69e7e518fa6e6.webp"
"MediaSize" => 87944
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-3b7bb61f7cb1dd1de6c69e7e518fa6e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6398373213"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/7b8515783baac787dab99a7ab8e0465e.webp"
"MediaSize" => 79550
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-7b8515783baac787dab99a7ab8e0465e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6398373267"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/255ee61616900829029c426a3cf9eed6.webp"
"MediaSize" => 84619
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-255ee61616900829029c426a3cf9eed6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6398373298"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/72f49743b39324a35cb0b65d74f93b77.webp"
"MediaSize" => 91006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-72f49743b39324a35cb0b65d74f93b77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6398373350"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/726d1ac02dc643ecdf975879ac8b40ff.webp"
"MediaSize" => 80907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-726d1ac02dc643ecdf975879ac8b40ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6398373403"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/8ba229a06cf470e81750a60ce38b9031.webp"
"MediaSize" => 64216
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-8ba229a06cf470e81750a60ce38b9031.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6398373425"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/ed4aee7b91b7d2d80f91004ddd470062.webp"
"MediaSize" => 82922
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-ed4aee7b91b7d2d80f91004ddd470062.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6398373493"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/b694a35f94fb94196b65c10aa2c3e739.webp"
"MediaSize" => 52079
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-b694a35f94fb94196b65c10aa2c3e739.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6398373539"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/f7917b45049c7be191f6fabb3c971135.webp"
"MediaSize" => 78238
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-f7917b45049c7be191f6fabb3c971135.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6398373592"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/085195b9693668d909305f63a0524701.webp"
"MediaSize" => 71459
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-085195b9693668d909305f63a0524701.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6398373654"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/eec0218d9fb197731a977cc159559c1d.webp"
"MediaSize" => 73540
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-eec0218d9fb197731a977cc159559c1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6398373707"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/c7df440e32a4ab12ee2e391022943753.webp"
"MediaSize" => 52074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-c7df440e32a4ab12ee2e391022943753.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6398373719"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/823d36609dc7eabfd39f4d4abe49a059.webp"
"MediaSize" => 71221
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-823d36609dc7eabfd39f4d4abe49a059.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6398373728"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/f727df85c458f4f59af81b52d64e8953.webp"
"MediaSize" => 86243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-f727df85c458f4f59af81b52d64e8953.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6398373746"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/ab196970d4f06d157d91d56fa4400edc.webp"
"MediaSize" => 77161
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-ab196970d4f06d157d91d56fa4400edc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6398373756"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/02384e7f5777a084a91251917e13a305.webp"
"MediaSize" => 76238
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-02384e7f5777a084a91251917e13a305.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6398373761"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/c131af707c04b26331c8e628aed20315.webp"
"MediaSize" => 93569
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-c131af707c04b26331c8e628aed20315.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6398373765"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/078352067f956dfd0e4e0b40f848f225.webp"
"MediaSize" => 94433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-078352067f956dfd0e4e0b40f848f225.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6398373772"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/2b8e3cc2e0aeb3499f7190c4c0d05e83.webp"
"MediaSize" => 87247
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-2b8e3cc2e0aeb3499f7190c4c0d05e83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6398373776"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/4be69db8e7959581f24021a13229893e.webp"
"MediaSize" => 77781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-4be69db8e7959581f24021a13229893e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6398373779"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/553b885ad3d254acab0d89f6934dea03.webp"
"MediaSize" => 124925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-553b885ad3d254acab0d89f6934dea03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6398373786"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/2da98306948ad033da25e349652e39e6.webp"
"MediaSize" => 171725
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-2da98306948ad033da25e349652e39e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6398373788"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/637d7d840e5b580da963da34676236eb.webp"
"MediaSize" => 176457
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-637d7d840e5b580da963da34676236eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6398373790"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/a2b238bf8fec074a499d2bad9b32dc3a.webp"
"MediaSize" => 161691
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-a2b238bf8fec074a499d2bad9b32dc3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6398373792"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235195/b574f87eab7e3076714a7e27f39ca41f.webp"
"MediaSize" => 160910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235195/thumbnail-b574f87eab7e3076714a7e27f39ca41f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797466"
"ResourceRecordKey" => "29235195"
"ModificationTimestamp" => "2026-01-09T20:19:14.47Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "Naima Cothran"
"MemberFirstName" => "Naima"
"MemberLastName" => "Cothran"
"MemberMlsId" => "HBCOTHRNA"
"OriginatingSystemName" => 26
"MemberKey" => "1803927"
"ModificationTimestamp" => "2026-01-02T18:31:04Z"
"MemberStatus" => "Active"
"OfficeKey" => "288925"
"MemberAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"JobTitle" => "Broker"
"MemberCity" => "Ancaster"
"MemberType" => "Broker"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-648-4451"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2008-09-26T15:57:00Z"
"MemberNationalAssociationId" => "1190947"
"OfficeNationalAssociationId" => "1372539"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "Royal LePage State Realty Inc."
"OfficePhone" => "905-648-4451"
"OfficeMlsId" => "HBRLPSTATEA2"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "288925"
"ModificationTimestamp" => "2025-12-30T03:00:56Z"
"OfficeAddress1" => "1122 Wilson Street W Suite 200"
"OfficeCity" => "Ancaster"
"OfficePostalCode" => "L9G3K"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2020-11-03T19:13:00Z"
"OfficeNationalAssociationId" => "1372539"
"FranchiseNationalAssociationId" => "1230730"
"OfficeBrokerNationalAssociationId" => "1063185"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29235195')"
+"ID": "523152"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 288925/Office?$select=ALL&$top=10&$filter=OfficeKey eq 288925&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 288925/Office?$select=ALL&$top=10&$filter=OfficeKey eq 288925&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25324
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25326
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage State Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-648-4451"
+"OfficeMlsId": "HBRLPSTATEA2"
+"ModificationTimestamp": "2025-12-30T03:00:56Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "288925"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "1122 Wilson Street W Suite 200"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Ancaster"
+"OfficePostalCode": "L9G3K"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1372539"
+"OriginalEntryTimestamp": "2020-11-03T19:13:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439678"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "288925"
"SocialMediaUrlOrId" => "https://www.royallepagestate.ca/"
"ModificationTimestamp" => "2025-12-29T19:37:00Z"
]
]
+"FranchiseNationalAssociationId": "1230730"
+"OfficeBrokerNationalAssociationId": "1063185"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('288925')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1803927/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1803927&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1803927/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1803927&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25329
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29235195" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24944
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29235195/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29235195&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29235195/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29235195&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24925
+items: array:4 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24926
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29451220"
+"ListingKey": "29235195"
+"ListingId": "40797466"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-01-10"
+"OpenHouseStartTime": "2026-01-10T14:00:00Z"
+"OpenHouseEndTime": "2026-01-10T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-01-10T18:09:09Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29451220')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24924
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29451219"
+"ListingKey": "29235195"
+"ListingId": "40797466"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-01-11"
+"OpenHouseStartTime": "2026-01-11T14:00:00Z"
+"OpenHouseEndTime": "2026-01-11T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-01-10T18:09:09Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29451219')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24927
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29454953"
+"ListingKey": "29235195"
+"ListingId": "40797466"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-01-11"
+"OpenHouseStartTime": "2026-01-11T14:00:00Z"
+"OpenHouseEndTime": "2026-01-11T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-01-11T20:03:05Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29454953')"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24923
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29486264"
+"ListingKey": "29235195"
+"ListingId": "40797466"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-01-18"
+"OpenHouseStartTime": "2026-01-18T14:00:00Z"
+"OpenHouseEndTime": "2026-01-18T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-01-15T06:04:02Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29486264')"
}
]
+success: true
+page_size: 4
+page_count: 1
+count: 4
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29235195 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7028697 43.221769)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29235195 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7028697 43.221769)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29235195 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7028697 43.221769)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29235195 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7028697 43.221769)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24854
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24863
+post_id: "534850"
+post_author: 1
+"ListingKey": "29252026"
+"ListingId": "X12696964"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T21:55:43Z"
+"RFModificationTimestamp": "2026-01-14T22:52:09Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E5W8"
+"UnparsedAddress": "469 DEWITT ROAD, Hamilton (Stoney Creek), Ontario L8E5W8"
+"Coordinates": array:2 [
0 => -79.705193
1 => 43.234605
]
+"Latitude": 43.234605
+"Longitude": -79.705193
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this bright and cheerful freehold, end-unit 2 storey townhouse designed to feel like a semi-detached. Just steps away from the Lake, it offers amazing views from the deck, living room and master bedroom. The large lot boasts great curb appeal, and a spacious layout that includes direct access to the garage and a practical open concept floor plan. The large deck, off the kitchen, spans the back of the house, ideal for entertaining, bbqs and relaxation. The second floor open concept family room features gleaming hardwood floors, large windows that allow lots of sunshine; and it can potentially be converted into a 3rd bedroom. The finished basement has so much more potential, it contains abundant storage space, the laundry room, a cold cellar and a 2 piece bathroom. It is the location that makes this home so desirable! This home awaits your creative touch! Do not miss this great opportunity! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T22:51:51.592966+00:00"
+"Directions": "Cross Streets: North Service Road. ** Directions: QEW to Centennial, right on Service Rd, Left on Dewitt."
+"ExteriorFeatures": array:1 [
0 => "Brick Facing"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Tile"
1 => "Hardwood"
2 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1405690"
+"ListOfficeKey": "271789"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "32.2 x 101.7 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T21:45:59Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T21:45:59Z"
+"Stories": "2.0"
+"StreetName": "Dewitt"
+"StreetNumber": "469"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4952.39"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1560412635"
"RoomType" => "Foyer"
"ListingId" => "X12696964"
"RoomLevel" => "Main level"
"RoomWidth" => 1.95
"ListingKey" => "29252026"
"RoomLength" => 2.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.39Z"
]
1 => array:11 [
"RoomKey" => "1560412636"
"RoomType" => "Cold room"
"ListingId" => "X12696964"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29252026"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.39Z"
]
2 => array:11 [
"RoomKey" => "1560412637"
"RoomType" => "Living room"
"ListingId" => "X12696964"
"RoomLevel" => "Main level"
"RoomWidth" => 3.15
"ListingKey" => "29252026"
"RoomLength" => 6.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.39Z"
]
3 => array:11 [
"RoomKey" => "1560412638"
"RoomType" => "Dining room"
"ListingId" => "X12696964"
"RoomLevel" => "Main level"
"RoomWidth" => 3.15
"ListingKey" => "29252026"
"RoomLength" => 6.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.39Z"
]
4 => array:11 [
"RoomKey" => "1560412639"
"RoomType" => "Bathroom"
"ListingId" => "X12696964"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29252026"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.39Z"
]
5 => array:11 [
"RoomKey" => "1560412640"
"RoomType" => "Kitchen"
"ListingId" => "X12696964"
"RoomLevel" => "Main level"
"RoomWidth" => 2.8
"ListingKey" => "29252026"
"RoomLength" => 5.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.39Z"
]
6 => array:11 [
"RoomKey" => "1560412641"
"RoomType" => "Family room"
"ListingId" => "X12696964"
"RoomLevel" => "Second level"
"RoomWidth" => 3.0
"ListingKey" => "29252026"
"RoomLength" => 3.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.39Z"
]
7 => array:11 [
"RoomKey" => "1560412642"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12696964"
"RoomLevel" => "Second level"
"RoomWidth" => 3.2
"ListingKey" => "29252026"
"RoomLength" => 5.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.39Z"
]
8 => array:11 [
"RoomKey" => "1560412643"
"RoomType" => "Bedroom 2"
"ListingId" => "X12696964"
"RoomLevel" => "Second level"
"RoomWidth" => 2.87
"ListingKey" => "29252026"
"RoomLength" => 4.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.39Z"
]
9 => array:11 [
"RoomKey" => "1560412644"
"RoomType" => "Recreational, Games room"
"ListingId" => "X12696964"
"RoomLevel" => "Basement"
"RoomWidth" => 2.8
"ListingKey" => "29252026"
"RoomLength" => 9.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.39Z"
]
10 => array:11 [
"RoomKey" => "1560412645"
"RoomType" => "Laundry room"
"ListingId" => "X12696964"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29252026"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.39Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29252026/469-dewitt-road-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 32.2
+"OriginalEntryTimestamp": "2026-01-14T21:45:59.36Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:49 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6404775491"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252026/dd7403773f0d92709a5e4ace0a32dbe2.webp"
"MediaSize" => 393840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252026/thumbnail-dd7403773f0d92709a5e4ace0a32dbe2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "B/I Single car garage"
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12696964"
"ResourceRecordKey" => "29252026"
"ModificationTimestamp" => "2026-01-14T21:45:59.37Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6404775581"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252026/9dbaf861366c04a2c066bc7a77868277.webp"
"MediaSize" => 454602
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252026/thumbnail-9dbaf861366c04a2c066bc7a77868277.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "End unit on large lot"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696964"
"ResourceRecordKey" => "29252026"
"ModificationTimestamp" => "2026-01-14T21:45:59.37Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6404775611"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252026/8d644c98fa683ce1c78348407efb20a1.webp"
"MediaSize" => 319713
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252026/thumbnail-8d644c98fa683ce1c78348407efb20a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front Entrance"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696964"
"ResourceRecordKey" => "29252026"
"ModificationTimestamp" => "2026-01-14T21:45:59.37Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6404775671"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252026/81f7ae1668c86bff43f9a160c65d03a6.webp"
"MediaSize" => 331892
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252026/thumbnail-81f7ae1668c86bff43f9a160c65d03a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Covered porch"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696964"
"ResourceRecordKey" => "29252026"
"ModificationTimestamp" => "2026-01-14T21:45:59.37Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6404775694"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252026/9184aaaf132886866baebd4b48c5b536.webp"
"MediaSize" => 182108
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252026/thumbnail-9184aaaf132886866baebd4b48c5b536.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Foyer to liv/din rm"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696964"
"ResourceRecordKey" => "29252026"
"ModificationTimestamp" => "2026-01-14T21:45:59.37Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6404775726"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252026/6e7260854014952bca7ea7c3c50593d4.webp"
"MediaSize" => 216144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252026/thumbnail-6e7260854014952bca7ea7c3c50593d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Liv Rm with gas fireplace"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696964"
"ResourceRecordKey" => "29252026"
"ModificationTimestamp" => "2026-01-14T21:45:59.37Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6404775752"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252026/e31c370404d23f2bfa13144c84ac3b7e.webp"
"MediaSize" => 192178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252026/thumbnail-e31c370404d23f2bfa13144c84ac3b7e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of lake from this room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696964"
"ResourceRecordKey" => "29252026"
"ModificationTimestamp" => "2026-01-14T21:45:59.37Z"
]
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]
]
+"Member": []
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29252026')"
+"ID": "534850"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24857
+post_id: "533893"
+post_author: 1
+"ListingKey": "29249920"
+"ListingId": "X12694942"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T17:05:38Z"
+"RFModificationTimestamp": "2026-01-14T19:42:40Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0L2"
+"UnparsedAddress": "306 - 600 NORTH SERVICE ROAD, Hamilton (Stoney Creek), Ontario L8E0L2"
+"Coordinates": array:2 [
0 => -79.697532
1 => 43.234311
]
+"Latitude": 43.234311
+"Longitude": -79.697532
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This sophisticated 1-bedroom residence is situated on the third floor of a nearly new boutique condominium. A rare opportunity, it includes an owned parking space and a secure storage locker for exceptional convenience. Inside, you'll find soaring ceilings, abundant natural light, upgraded designer lighting, and a thoughtfully crafted open-concept layout tailored for contemporary living. The inviting entryway offers a full-sized closet for coats and additional storage. The bright, well-appointed kitchen features ample counter space, stainless steel appliances, and a generous peninsula ideal for meal preparation or casual dining. (id:62650)"
+"Appliances": array:3 [
0 => "All"
1 => "Central Vacuum"
2 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T19:42:23.816818+00:00"
+"Directions": "FRUITLAND RD & NORTH SERVICE RD"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Not known"
2 => "Electric"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2127500"
+"ListOfficeKey": "274354"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T16:56:17Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T16:56:17Z"
+"StreetName": "North Service"
+"StreetNumber": "600"
+"StreetSuffix": "Road"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29249920/306-600-north-service-road-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Shabri Properties Ltd"
+"GeocodeManualYN": false
+"TotalActualRent": 2000
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-14T16:56:17.07Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:21 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29249920')"
+"ID": "533893"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24864
+post_id: "533995"
+post_author: 1
+"ListingKey": "29250319"
+"ListingId": "40798505"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T17:55:10Z"
+"RFModificationTimestamp": "2026-01-14T18:50:38Z"
+"ListPrice": 599995.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1355.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E5H6"
+"UnparsedAddress": "288 GLOVER Road Unit# 21, Stoney Creek, Ontario L8E5H6"
+"Coordinates": array:2 [
0 => -79.6800639
1 => 43.2161908
]
+"Latitude": 43.2161908
+"Longitude": -79.6800639
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning Branthaven-Built 3-Storey Townhome in Sought-After Winona/Fruitland Neighbourhood. 10 mins to the New Go Train Station Opening at the end of October! Welcome to this beautifully upgraded townhome located in one of Hamilton’s fastest-growing communities. Ideally situated just minutes from the QEW and Red Hill Valley Parkway, you'll enjoy easy access to everything you need—including trendy new restaurants, shopping, Costco, and more. This home features a bright and airy open-concept layout, complete with wide plank vinyl flooring and stylish upgraded lighting throughout. The gourmet kitchen boasts sleek white cabinetry, stainless steel appliances, granite countertops, and a modern tile backsplash. The main floor also includes a spacious family room with a charming shiplap feature wall, separate dining area, and access to a private balcony—perfect for entertaining or relaxing. The powder room has been tastefully updated with new tile flooring and contemporary fixtures. Upstairs, you’ll find two generously sized bedrooms, a convenient laundry closet, and a spacious 4-piece bathroom with a relaxing soaker tub. The primary bedroom features a walk-in closet and its own private balcony. Lovingly maintained, this exceptional home is built by award-winning Branthaven and offers quality craftsmanship, thoughtful upgrades, and a truly move-in-ready experience. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"AssociationFee": "183.69"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T18:50:12.547536+00:00"
+"Directions": "South of QEW on Fruitland Rd. 4km/turn east on Barton St. 4km/turn left - Glover Rd."
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "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"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T17:51:30Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T17:51:30Z"
+"Stories": "3.0"
+"StreetName": "GLOVER"
+"StreetNumber": "288"
+"StreetSuffix": "Road"
+"SubdivisionName": "518 - Fruitland"
+"TaxAnnualAmount": "4150.79"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29250319/288-glover-road-unit-21-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "RM3-59b, RM3-59c, RM3-59a"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1355
+"OriginalEntryTimestamp": "2026-01-14T17:49:31.48Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"Media": array:28 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29250319')"
+"ID": "533995"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24855
+post_id: "533463"
+post_author: 1
+"ListingKey": "29249089"
+"ListingId": "40798135"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T14:55:25Z"
+"RFModificationTimestamp": "2026-01-14T17:25:07Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 653.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8E0L2"
+"UnparsedAddress": "600 NORTH SERVICE Road Unit# 419, Hamilton, Ontario L8E0L2"
+"Coordinates": array:2 [
0 => -79.697041
1 => 43.234195
]
+"Latitude": 43.234195
+"Longitude": -79.697041
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience the epitome of modern coastal living in the newly completed and vibrant CoMo Condos. This beautifully designed 1-bedroom, 1-washroom unit has stunning waterfront views that create a calming ambiance throughout. The spacious layout features a sleek kitchen with a breakfast bar, an enclosed balcony ideal for relaxation, and a generously sized washroom. For added convenience, the unit includes one parking space and one locker. CoMo Condos also has an exceptional amenities such as a pet spa, an off-leash pet area, a media and gaming room, a party room, automated package pick-up, and a rooftop patio perfect for entertaining or unwinding. Ideally located with easy access to highways, schools, shopping, and dining, this home is perfect for those seeking style, comfort, and convenience. Don’t miss your chance to enjoy breathtaking waterfront living every day. (id:62650)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Garage door opener"
5 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:1 [
0 => "Water"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T17:24:56.938712+00:00"
+"Directions": "Lakeview and Fruitland"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525060"
+"ListOfficeKey": "67816"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-01-14T14:49:02Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T14:49:02Z"
+"Stories": "1.0"
+"StreetName": "NORTH SERVICE"
+"StreetNumber": "600"
+"StreetSuffix": "Road"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29249089/600-north-service-road-unit-419-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2100
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RM3-64, C5"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 653
+"OriginalEntryTimestamp": "2026-01-14T14:49:02.17Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29249089')"
+"ID": "533463"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24856
+post_id: "532252"
+post_author: 1
+"ListingKey": "29247006"
+"ListingId": "40797950"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T20:55:46Z"
+"RFModificationTimestamp": "2026-01-13T23:23:11Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1064.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E5V2"
+"UnparsedAddress": "610 BARTON Street Unit# 46, Stoney Creek, Ontario L8E5V2"
+"Coordinates": array:2 [
0 => -79.703288
1 => 43.2221018
]
+"Latitude": 43.2221018
+"Longitude": -79.703288
+"YearBuilt": 1993
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Gorgeous end-unit townhouse in a fantastic Stoney Creek location! Just minutes to the QEW (Fruitland) and close to schools, parks, restaurants, and all amenities. This home is extremely well maintained, spotless, and loaded with updates. Stunning open-concept kitchen featuring white soft-close cabinetry, quartz countertops, backsplash, centre island, and wine fridge—perfect for everyday living and entertaining. Updated bathrooms, ceramic and hardwood flooring, pot lights, California shutters, and convenient inside entry from the garage. Major updates include furnace and A/C (August 2022) and a garage door opener (August 2022). Unspoiled unfinished basement offers endless potential. Enjoy a private rear yard surrounded by trees with patio, deck, and professional landscaping. Outstanding location, great complex—shows 10+! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFee": "324.96"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Water"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T23:22:55.259352+00:00"
+"Directions": "Fruitland Rd to Barton St"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524652"
+"ListOfficeKey": "294490"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-13T20:48:53Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T20:48:53Z"
+"Stories": "2.0"
+"StreetName": "BARTON"
+"StreetNumber": "610"
+"StreetSuffix": "Street"
+"SubdivisionName": "512 - Guernsey/Westmeria/Industrial"
+"TaxAnnualAmount": "3432.5"
+"VirtualTourURLUnbranded": "https://sites.nomorecowboys.media/610bartonstreetl8e5v2"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29247006/610-barton-street-unit-46-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1910452"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "294490"
+"GeocodeManualYN": true
+"ZoningDescription": "RM3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1064
+"OriginalEntryTimestamp": "2026-01-13T20:48:53.7Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29247006')"
+"ID": "532252"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24791
+post_id: "532460"
+post_author: 1
+"ListingKey": "29247190"
+"ListingId": "40798194"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T21:25:19Z"
+"RFModificationTimestamp": "2026-01-13T23:03:48Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 806.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E5A7"
+"UnparsedAddress": "600 NORTH SERVICE Road Unit# 309, Stoney Creek, Ontario L8E5A7"
+"Coordinates": array:2 [
0 => -79.697019
1 => 43.234159
]
+"Latitude": 43.234159
+"Longitude": -79.697019
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Fantastic 2 bedroom corner unit with large bright windows with lake view. Located on 3rd floor, unit comes with 2 parking spaces. Open style kitchen and living room, 2 baths, large balcony, numerous amenities. parking space under ground #42, parking space above ground #265. Looking for A+++ tenant. Rental application, pay stubs & photo ID, up-to-date Equifax credit report, employment letter, reference letter, bank statement. No smoking. Tenant pays all utilities. Tenants need tenant insurance. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Water"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T23:03:24.375923+00:00"
+"Directions": "Fruitland Rd and North Service Rd"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Other"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524358"
+"ListOfficeKey": "291472"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Corner Site"
1 => "Balcony"
2 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-13T21:21:08Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T21:21:08Z"
+"Stories": "1.0"
+"StreetName": "NORTH SERVICE"
+"StreetNumber": "600"
+"StreetSuffix": "Road"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"TaxAnnualAmount": "4135"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29247190/600-north-service-road-unit-309-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2495
+"ZoningDescription": "C5, RM3-64"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 806
+"OriginalEntryTimestamp": "2026-01-13T21:18:57.99Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:12 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29247190')"
+"ID": "532460"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23498
+post_id: "532253"
+post_author: 1
+"ListingKey": "29247330"
+"ListingId": "X12692886"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T21:50:37Z"
+"RFModificationTimestamp": "2026-01-13T22:51:08Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E5V2"
+"UnparsedAddress": "46 - 610 BARTON STREET, Hamilton (Stoney Creek), Ontario L8E5V2"
+"Coordinates": array:2 [
0 => -79.703296
1 => 43.222185
]
+"Latitude": 43.222185
+"Longitude": -79.703296
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Gorgeous end-unit townhouse in a fantastic Stoney Creek location! Just minutes to the QEW (Fruitland) and close to schools, parks, restaurants, and all amenities. This home is extremely well maintained, spotless, and loaded with updates. Stunning open-concept kitchen featuring white soft-close cabinetry, quartz countertops, backsplash, centre island, and wine fridge-perfect for everyday living and entertaining. Updated bathrooms, ceramic and hardwood flooring, pot lights, California shutters, and convenient inside entry from the garage. Major updates include furnace and A/C (August 2022) and a garage door opener (August 2022). Unspoiled unfinished basement offers endless potential. Enjoy a private rear yard surrounded by trees with patio, deck, and professional landscaping. Outstanding location, great complex-shows 10+! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "324.96"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "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-01-13T22:50:45.105628+00:00"
+"Directions": "Cross Streets: Fruitland Rd. ** Directions: Fruitland Rd to Barton St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2038160"
+"ListOfficeKey": "280315"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-13T21:40:39Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T21:40:39Z"
+"Stories": "2.0"
+"StreetName": "Barton"
+"StreetNumber": "610"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3432.5"
+"VirtualTourURLUnbranded": "https://sites.nomorecowboys.media/mls/227708841"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29247330/46-610-barton-street-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2106038"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Property Management Guild"
+"CoListOfficeKey": "280315"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"ZoningDescription": "RM3"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-01-13T21:40:39.2Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29247330')"
+"ID": "532253"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24852
+post_id: "531722"
+post_author: 1
+"ListingKey": "29247455"
+"ListingId": "X12693050"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T22:20:50Z"
+"RFModificationTimestamp": "2026-01-13T22:32:08Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E5A7"
+"UnparsedAddress": "309 - 600 NORTH SERVICE ROAD, Hamilton (Lakeshore), Ontario L8E5A7"
+"Coordinates": array:2 [
0 => -79.697532
1 => 43.234311
]
+"Latitude": 43.234311
+"Longitude": -79.697532
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Fantastic 2 bedroom corner unit with large bright windows with lake view. Located on 3rd floor, unit comes with 2 parking spaces. Open style kitchen and living room, 2 baths, large balcony, numerous amenities. parking space under ground #42, parking space above ground #265. Looking for A+++ tenant. Rental application, pay stubs & photo ID, up-to-date Equifax credit report, employment letter, reference letter, bank statement. No smoking. Tenant pays all utilities. Tenants need tenant insurance. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T22:31:50.312880+00:00"
+"Directions": "Cross Streets: Fruitland Road. ** Directions: Fruitland Rd and North Service Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Not known"
2 => "Electric"
3 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2163724"
+"ListOfficeKey": "291490"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-13T22:11:25Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T22:11:25Z"
+"StreetName": "North Service"
+"StreetNumber": "600"
+"StreetSuffix": "Road"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29247455/309-600-north-service-road-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Shabri Property Management"
+"GeocodeManualYN": false
+"TotalActualRent": 2495
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-13T22:11:25.42Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:12 [
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]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29247455')"
+"ID": "531722"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24853
+post_id: "531195"
+post_author: 1
+"ListingKey": "29246156"
+"ListingId": "X12691884"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T18:51:01Z"
+"RFModificationTimestamp": "2026-01-13T19:56:17Z"
+"ListPrice": 1499000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8K4Y4"
+"UnparsedAddress": "17 CLEARVIEW DRIVE, Hamilton (Stoney Creek), Ontario L8K4Y4"
+"Coordinates": array:2 [
0 => -79.7067875
1 => 43.2119541
]
+"Latitude": 43.2119541
+"Longitude": -79.7067875
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Nestled on a quiet, family-friendly street beneath the Escarpment, this exceptional custom renovated home impresses at every turn. Offering over 4,200 sq. ft. of luxurious living space, it showcases high-end finishes and impeccable design throughout. The thoughtfully designed layout includes 4+2 bedrooms, 4 bathrooms, and a private in-law suite with a separate entrance.From the moment you enter, the stunning foyer and illuminated staircase set the tone, serving as a striking architectural centerpiece. The chef's kitchen is truly a showstopper, featuring custom black cabinetry, leather-finished quartz countertops, an oversized island, and top-of-the-line appliances. The main level also offers an open-concept formal living and dining area, along with a spacious family room anchored by a custom fireplace.Upstairs, you'll find three generously sized bedrooms and two beautifully designed bathrooms, each complete with a freestanding tub and separate shower. The main floor also includes a fourth bedroom or home office, plus an oversized spa-inspired bathroom with conveniently located laundry.The finished basement spans approximately 1,600 sq. ft. and includes a private suite with its own kitchen, bedroom, and bathroom-ideal for in-laws, teenagers, or rental income. An additional area offers endless possibilities, including a home gym, office, or secondary living space.Step outside to a professionally landscaped backyard designed for year-round enjoyment. The 14-ft swim spa features four jacuzzi seats, a swim current, and temperature control-perfect for summer swimming and winter relaxation, with far less maintenance than a traditional pool. Enjoy a turn key home with all the major updates: Engineered hardwood flooring on the main and second levels, European front doors, gemstone stucco façade, new windows (2023), roof (2022), garage doors (2023), security cameras, and Google doorbell. A truly exceptional home-this is a must-see! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Oven"
5 => "Dryer"
6 => "Cooktop"
7 => "Blinds"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Apartment in basement"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
5 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T19:56:02.989504+00:00"
+"Directions": "Cross Streets: Regalview Dr & Hwy8. ** Directions: Hwy8 & Fruitland."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2142078"
+"ListOfficeKey": "51427"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "50.1 x 115.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-13T18:41:43Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T18:41:43Z"
+"StreetName": "Clearview"
+"StreetNumber": "17"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6066.99"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=DDJ1tzy4vak"
+"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": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29246156/17-clearview-drive-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 50.1
+"OriginalEntryTimestamp": "2026-01-13T18:41:43.09Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29246156')"
+"ID": "531195"
}
]
+success: true
+page_size: 9
+page_count: 12
+count: 105
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]