array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30005985 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23447
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23449
+post_id: "1604640"
+post_author: 1
+"ListingKey": "30005985"
+"ListingId": "40845987"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-08T17:30:40Z"
+"RFModificationTimestamp": "2026-07-08T17:51:10Z"
+"ListPrice": 869900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2478.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G3W9"
+"UnparsedAddress": "115 GREEN Road, Stoney Creek, Ontario L8G3W9"
+"Coordinates": array:2 [
0 => -79.7354506
1 => 43.2178923
]
+"Latitude": 43.2178923
+"Longitude": -79.7354506
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this spacious and recently upgraded side-split in Stoney Creek, offering approximately over 2,000 sq. ft. of finished living space and a flexible layout ideal for families, multi-generational living, or buyers looking for added income potential. Featuring 2+2 bedrooms, 2 full bathrooms, and two kitchens, this home provides excellent functionality across multiple levels, with the lower level offering great potential for extended family use or a future income setup. The separate double garage adds even more value, with plenty of room for parking, storage, or use as a workshop. Ideally located close to schools, parks, public transit, and everyday amenities, this property also offers beautiful views of the escarpment, combining space, convenience, and long-term potential in a desirable Stoney Creek location. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"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-07-08T17:51:00.270425+00:00"
+"Directions": "KING ST E, NORTH ON GREEN ROAD"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2039467"
+"ListOfficeKey": "292150"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-07-08T17:18:22Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-08T17:18:22Z"
+"Stories": "1.0"
+"StreetName": "GREEN"
+"StreetNumber": "115"
+"StreetSuffix": "Road"
+"SubdivisionName": "511 - Eastdale/Poplar Park/Industrial"
+"TaxAnnualAmount": "5436"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1678286068"
"RoomType" => "Bedroom"
"ListingId" => "40845987"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30005985"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T17:18:22.65Z"
]
1 => array:11 [
"RoomKey" => "1678286069"
"RoomType" => "3pc Bathroom"
"ListingId" => "40845987"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30005985"
"RoomLength" => null
"RoomDimensions" => "6'7'' x 4'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T17:18:22.65Z"
]
2 => array:11 [
"RoomKey" => "1678286070"
"RoomType" => "Laundry room"
"ListingId" => "40845987"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30005985"
"RoomLength" => null
"RoomDimensions" => "3'1'' x 3'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T17:18:22.65Z"
]
3 => array:11 [
"RoomKey" => "1678286071"
"RoomType" => "3pc Bathroom"
"ListingId" => "40845987"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30005985"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 4'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T17:18:22.65Z"
]
4 => array:11 [
"RoomKey" => "1678286072"
"RoomType" => "Bedroom"
"ListingId" => "40845987"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30005985"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T17:18:22.65Z"
]
5 => array:11 [
"RoomKey" => "1678286073"
"RoomType" => "Primary Bedroom"
"ListingId" => "40845987"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30005985"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T17:18:22.65Z"
]
6 => array:11 [
"RoomKey" => "1678286074"
"RoomType" => "Laundry room"
"ListingId" => "40845987"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30005985"
"RoomLength" => null
"RoomDimensions" => "5'6'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T17:18:22.66Z"
]
7 => array:11 [
"RoomKey" => "1678286075"
"RoomType" => "Utility room"
"ListingId" => "40845987"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30005985"
"RoomLength" => null
"RoomDimensions" => "17'2'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T17:18:22.66Z"
]
8 => array:11 [
"RoomKey" => "1678286076"
"RoomType" => "Dining room"
"ListingId" => "40845987"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30005985"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 7'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T17:18:22.66Z"
]
9 => array:11 [
"RoomKey" => "1678286077"
"RoomType" => "Family room"
"ListingId" => "40845987"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30005985"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T17:18:22.66Z"
]
10 => array:11 [
"RoomKey" => "1678286078"
"RoomType" => "Kitchen"
"ListingId" => "40845987"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30005985"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T17:18:22.66Z"
]
11 => array:11 [
"RoomKey" => "1678286079"
"RoomType" => "Bedroom"
"ListingId" => "40845987"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30005985"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T17:18:22.66Z"
]
12 => array:11 [
"RoomKey" => "1678286080"
"RoomType" => "Living room"
"ListingId" => "40845987"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30005985"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 20'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T17:18:22.66Z"
]
13 => array:11 [
"RoomKey" => "1678286081"
"RoomType" => "Breakfast"
"ListingId" => "40845987"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30005985"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T17:18:22.66Z"
]
14 => array:11 [
"RoomKey" => "1678286082"
"RoomType" => "Kitchen"
"ListingId" => "40845987"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30005985"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T17:18:22.66Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30005985/115-green-road-stoney-creek"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 63.0
+"AboveGradeFinishedArea": 1440
+"BelowGradeFinishedArea": 1038
+"OriginalEntryTimestamp": "2026-07-08T17:18:22.63Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1324971"
+"ListOfficeNationalAssociationId": "1408460"
+"Media": array:42 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30005985_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/b92448e301073d0bda881ee64adac90e.webp"
"MediaSize" => 134814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-b92448e301073d0bda881ee64adac90e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30005985_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/79c223a518a925777dc9be794aaf5015.webp"
"MediaSize" => 139486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-79c223a518a925777dc9be794aaf5015.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30005985_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/e90c25cf0016c05f1abba72639582aa3.webp"
"MediaSize" => 157001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-e90c25cf0016c05f1abba72639582aa3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30005985_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/25685f869268bb74c2918ebc163a1cbd.webp"
"MediaSize" => 56453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-25685f869268bb74c2918ebc163a1cbd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30005985_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/728ee3d649e8b6cf06d061a76283c338.webp"
"MediaSize" => 66204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-728ee3d649e8b6cf06d061a76283c338.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30005985_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/8560c879e594ad2a55ff143340bb1550.webp"
"MediaSize" => 72475
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-8560c879e594ad2a55ff143340bb1550.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30005985_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/4c656e690238ebce3a1786556f332f10.webp"
"MediaSize" => 65219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-4c656e690238ebce3a1786556f332f10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30005985_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/feed7741b6acc71bc9b63e45b8a62ac0.webp"
"MediaSize" => 64411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-feed7741b6acc71bc9b63e45b8a62ac0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30005985_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/a7ece055282c9d6551d11be51a00c8d1.webp"
"MediaSize" => 62712
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-a7ece055282c9d6551d11be51a00c8d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30005985_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/f468ead68b0fccc3d3a9f0d32f23cea0.webp"
"MediaSize" => 52316
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-f468ead68b0fccc3d3a9f0d32f23cea0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30005985_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/616b25f1f6a5354cbf1d814b2120ea4c.webp"
"MediaSize" => 73217
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-616b25f1f6a5354cbf1d814b2120ea4c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30005985_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/02b00d651f41321911311c5d50e4510a.webp"
"MediaSize" => 63220
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-02b00d651f41321911311c5d50e4510a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30005985_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/ffcd582c512453eb6311862d562726a0.webp"
"MediaSize" => 57413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-ffcd582c512453eb6311862d562726a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30005985_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/1c88448674ab67966bf82e1d46a01547.webp"
"MediaSize" => 52601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-1c88448674ab67966bf82e1d46a01547.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30005985_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/22deecbe7922367dc16ca94be2268e4d.webp"
"MediaSize" => 63467
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-22deecbe7922367dc16ca94be2268e4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30005985_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/faf4ccd65077f85c52e278f67d802744.webp"
"MediaSize" => 55775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-faf4ccd65077f85c52e278f67d802744.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30005985_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/c57d9e258d28ef34a36ee3d128e3cd25.webp"
"MediaSize" => 59277
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-c57d9e258d28ef34a36ee3d128e3cd25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30005985_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/95a00e4dd5f6cf7c3d82e7fb1d1f590f.webp"
"MediaSize" => 48421
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-95a00e4dd5f6cf7c3d82e7fb1d1f590f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30005985_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/4467d9bd7ed83922bfc6bfe0a22069a3.webp"
"MediaSize" => 64281
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-4467d9bd7ed83922bfc6bfe0a22069a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30005985_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/5d19dabb62a51acefa5899dbc90fadb9.webp"
"MediaSize" => 58814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-5d19dabb62a51acefa5899dbc90fadb9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30005985_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/f87f40f5a4d9ce778d20259040dcc919.webp"
"MediaSize" => 59574
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-f87f40f5a4d9ce778d20259040dcc919.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30005985_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/17144080c1a35a8869ed2a30bc08c3b9.webp"
"MediaSize" => 47897
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-17144080c1a35a8869ed2a30bc08c3b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30005985_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/b0829e1879bcf2967c7fdccf91361f9d.webp"
"MediaSize" => 57860
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-b0829e1879bcf2967c7fdccf91361f9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30005985_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/da68e1eb892befeaf908206373ec8450.webp"
"MediaSize" => 70115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-da68e1eb892befeaf908206373ec8450.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30005985_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/d76144b518033400eca952e3ab4fb425.webp"
"MediaSize" => 56647
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-d76144b518033400eca952e3ab4fb425.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30005985_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/b44a0f128f5d2cab3d8aa6fbd4b6ec78.webp"
"MediaSize" => 68814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-b44a0f128f5d2cab3d8aa6fbd4b6ec78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30005985_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/eb82aab430fe7e2d0a4ee6d21b7e9962.webp"
"MediaSize" => 79727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-eb82aab430fe7e2d0a4ee6d21b7e9962.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30005985_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/4386e47e856df6e4398b294bb0406e8d.webp"
"MediaSize" => 83039
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-4386e47e856df6e4398b294bb0406e8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30005985_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/bc1b6997d9a2728dbaf035a3464da4ad.webp"
"MediaSize" => 61548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-bc1b6997d9a2728dbaf035a3464da4ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30005985_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/768707762c2925dd8653a5e8722a21bf.webp"
"MediaSize" => 79249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-768707762c2925dd8653a5e8722a21bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30005985_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/9c7db372f36dfa1dad85afcc1a17110c.webp"
"MediaSize" => 82402
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-9c7db372f36dfa1dad85afcc1a17110c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30005985_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/ae0e1df61b6c33f19a34f5f4c380ab56.webp"
"MediaSize" => 64174
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-ae0e1df61b6c33f19a34f5f4c380ab56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30005985_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/374d2496d76fabf7dcbf684e6473d61f.webp"
"MediaSize" => 57033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-374d2496d76fabf7dcbf684e6473d61f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30005985_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/8a4d1e034abb14ffb2b472f6bb3d1d86.webp"
"MediaSize" => 83668
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-8a4d1e034abb14ffb2b472f6bb3d1d86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30005985_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/fdb83d0e4de9cf719a1f07c4f8fa0b67.webp"
"MediaSize" => 78460
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-fdb83d0e4de9cf719a1f07c4f8fa0b67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "30005985_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/e19fd7a5a0fb51771dd8787900219e15.webp"
"MediaSize" => 166573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-e19fd7a5a0fb51771dd8787900219e15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "30005985_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/2e197daa451fb521cfe0b42b7ba134d4.webp"
"MediaSize" => 137946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-2e197daa451fb521cfe0b42b7ba134d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "30005985_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/53fc29592c5aa75798617b38aeb2e5e9.webp"
"MediaSize" => 150039
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-53fc29592c5aa75798617b38aeb2e5e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "30005985_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/361a979f33943e31b575fb58dd5ed135.webp"
"MediaSize" => 174800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-361a979f33943e31b575fb58dd5ed135.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "30005985_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/6eded0f2f2d970937d98de09628d54aa.webp"
"MediaSize" => 174783
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-6eded0f2f2d970937d98de09628d54aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "30005985_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/dee26125932a5a186667298e06245a19.webp"
"MediaSize" => 193284
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-dee26125932a5a186667298e06245a19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "30005985_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30005985/2698ee060a727435f081bae1736940a7.webp"
"MediaSize" => 188144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30005985/thumbnail-2698ee060a727435f081bae1736940a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845987"
"ResourceRecordKey" => "30005985"
"ModificationTimestamp" => "2026-07-08T17:18:22.63Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30005985')"
+"ID": "1604640"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 292150" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24967
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24875
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Real Broker Ontario Ltd."
+"OfficeEmail": null
+"OfficePhone": "888-311-1172"
+"OfficeMlsId": "HBREALBRKRD"
+"ModificationTimestamp": "2026-03-04T19:08:30Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "292150"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "130 King St. W. Suite 1900D"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Toronto"
+"OfficePostalCode": "M5X1E"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1408460"
+"OriginalEntryTimestamp": "2022-02-07T20:43:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "452446"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "292150"
"SocialMediaUrlOrId" => "https://www.onereal.ca/"
"ModificationTimestamp" => "2026-03-04T16:57:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1461830"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('292150')"
}
]
+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 2039467" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24948
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30005985'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25272
+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 '30005985' AND OpenHouseDate ge '2026-07-09'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25288
+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 '30005985' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7354506 43.2178923)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25361
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25355
+post_id: "1609598"
+post_author: 1
+"ListingKey": "30012056"
+"ListingId": "40846231"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T17:25:16Z"
+"RFModificationTimestamp": "2026-07-09T19:29:19Z"
+"ListPrice": 1099000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.1
+"LivingArea": 2736.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E4P5"
+"UnparsedAddress": "46 DARROW Drive, Stoney Creek, Ontario L8E4P5"
+"Coordinates": array:2 [
0 => -79.7304998
1 => 43.2227768
]
+"Latitude": 43.2227768
+"Longitude": -79.7304998
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 46 Darrow Drive in Stoney Creek—a beautifully upgraded, solid brick detached home that's completely move-in ready. Offering approximately 2,900 square feet of thoughtfully designed living space, this stunning home was extensively updated and customized in 2018 with modern finishes and quality craftsmanship throughout. Inside, you'll find three spacious bedrooms and four bathrooms, including a primary ensuite with 3 pc bathroom and oversized walk-in closet. A second full bathroom, two convenient powder rooms, finished basement with convenient wet bar, providing plenty of space and functionality for families and guests alike. The bright, inviting layout is perfect for both everyday living and entertaining, with stylish updates that create a warm, contemporary feel from the moment you walk through the door. Every detail has been carefully considered, allowing you to simply unpack and start enjoying your new home, especially the beautiful kitchen with oversized island overlooking into the private backyard deck and greenery through stunning, four panel sliding glass doors. The granite countertops, SS appliances, extended solid maple cabinetry and customized appliance garage are what makes this kitchen stand out from the rest! The statements continue to the outdoors with elegant landscaping, concrete double wide driveway and attached two car garage. Located in one of Stoney Creek's desirable neighbourhoods, you'll appreciate being close to parks, schools, shopping, restaurants, and commuter routes while enjoying the comfort and privacy of this beautifully maintained property. If you've been searching for an upgraded, turnkey detached home that combines timeless curb appeal with modern living, 46 Darrow Drive is one you won't want to miss. Book your private showing today! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T19:29:08.506085+00:00"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2062926"
+"ListOfficeKey": "284640"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.1"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T17:18:27Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T17:18:27Z"
+"Stories": "2.0"
+"StreetName": "DARROW"
+"StreetNumber": "46"
+"StreetSuffix": "Drive"
+"SubdivisionName": "517 - Highway Valley/Dewitt"
+"TaxAnnualAmount": "5288.6"
+"VirtualTourURLUnbranded": "https://youtu.be/CRBxHpFt8uI"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1679256611"
"RoomType" => "Other"
"ListingId" => "40846231"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30012056"
"RoomLength" => null
"RoomDimensions" => "4'7'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T17:18:27.85Z"
]
1 => array:11 [
"RoomKey" => "1679256612"
"RoomType" => "Dining room"
"ListingId" => "40846231"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30012056"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 17'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T17:18:27.85Z"
]
2 => array:11 [
"RoomKey" => "1679256613"
"RoomType" => "Storage"
"ListingId" => "40846231"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30012056"
"RoomLength" => null
"RoomDimensions" => "12'11'' x 14'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T17:18:27.85Z"
]
3 => array:11 [
"RoomKey" => "1679256614"
"RoomType" => "Laundry room"
"ListingId" => "40846231"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30012056"
"RoomLength" => null
"RoomDimensions" => "6'11'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T17:18:27.85Z"
]
4 => array:11 [
"RoomKey" => "1679256615"
"RoomType" => "2pc Bathroom"
"ListingId" => "40846231"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30012056"
"RoomLength" => null
"RoomDimensions" => "4'10'' x 5'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T17:18:27.85Z"
]
5 => array:11 [
"RoomKey" => "1679256616"
"RoomType" => "Recreation room"
"ListingId" => "40846231"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30012056"
…5
]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30012056/46-darrow-drive-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1811
+"BelowGradeFinishedArea": 925
+"OriginalEntryTimestamp": "2026-07-09T17:18:27.82Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1337871"
+"ListOfficeNationalAssociationId": "1344651"
+"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('30012056')"
+"ID": "1609598"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25357
+post_id: "1608448"
+post_author: 1
+"ListingKey": "30011453"
+"ListingId": "40844986"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T16:35:25Z"
+"RFModificationTimestamp": "2026-07-09T16:46:06Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3396.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E1P7"
+"UnparsedAddress": "268 FEDERAL Street, Stoney Creek, Ontario L8E1P7"
+"Coordinates": array:2 [
0 => -79.7336614
1 => 43.2224476
]
+"Latitude": 43.2224476
+"Longitude": -79.7336614
+"YearBuilt": 1971
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 268 Federal Street, this lovingly maintained by its original owners for over 55 years. Filled with warmth, character, and pride of ownership, this spacious 5 level sidesplit is ready for its next family to create memories that will last a lifetime. Featuring over 1,800 sq. ft. of versatile living space, this home features 3 beds, 3 baths, 2 kitchens, a formal living room and dining room, 2 family rooms, a rec room, and a large foyer showcasing beautiful stone inspired mosaic tile flooring. The bright living and dining areas are enhanced by an original 1970’s decorative wrought iron divider with elegant floral scrollwork, adding timeless charm and character. Original hardwood floors, no carpeting, spacious rooms, and large windows fill the home with natural light. Perfect for first-time buyers, growing families, looking for multi-generational living, a potential in-law setup, or an investment opportunity, this property offers exceptional versatility and functionality to suit a variety of lifestyles with endless possibilities. With solid construction, great bones and spacious rooms throughout. An impressive 54'x175' landscaped lot, the backyard provides endless space for entertaining, gardening, or simply enjoying the outdoors. A double-wide concrete driveway provides ample parking, while the quiet, mature neighbourhood is one you'll be proud to call home. Conveniently located near highways, shopping, schools, parks, public transit, and everyday amenities, this is a rare opportunity to own a truly special home in one of Stoney Creek's most desirable neighbourhoods. This is more than just a house, it's a home where decades of wonderful memories were made, and it's ready for new owners to begin creating memories of their own. You can truly feel the warmth the moment you walk through the door. You won't be disappointed. (id:62650)"
+"Appliances": array:2 [
0 => "Sauna"
1 => "Central Vacuum"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T16:45:59.651863+00:00"
+"Directions": "South on Green Road toward Highway 8, turn left on Federal Street"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2153657"
+"ListOfficeKey": "55168"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T16:29:38Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T16:29:38Z"
+"Stories": "3.0"
+"StreetName": "FEDERAL"
+"StreetNumber": "268"
+"StreetSuffix": "Street"
+"SubdivisionName": "511 - Eastdale/Poplar Park/Industrial"
+"TaxAnnualAmount": "6063.77"
+"VirtualTourURLUnbranded": "https://sites.nomorecowboys.media/268federalstreet"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:20 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30011453/268-federal-street-stoney-creek"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 54.0
+"AboveGradeFinishedArea": 1880
+"BelowGradeFinishedArea": 1516
+"OriginalEntryTimestamp": "2026-07-09T16:29:38.51Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1405225"
+"ListOfficeNationalAssociationId": "1116022"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30011453')"
+"ID": "1608448"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25353
+post_id: "1608377"
+post_author: 1
+"ListingKey": "30011326"
+"ListingId": "X13543400"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T18:20:07Z"
+"RFModificationTimestamp": "2026-07-09T18:32:12Z"
+"ListPrice": 869900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G2W9"
+"UnparsedAddress": "27 BRENTWOOD DRIVE, Hamilton (Stoney Creek), Ontario L8G2W9"
+"Coordinates": array:2 [
0 => -79.748456
1 => 43.213721
]
+"Latitude": 43.213721
+"Longitude": -79.748456
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 27 Brentwood Drive, a well-loved bungalow in the sought-after Cherry Heights neighbourhood of Stoney Creek, nestled beneath the Escarpment. Offering 3+1 bedrooms and 2 full bathrooms, this home has the space and flexibility to work for a variety of lifestyles. Enter through the beautiful solid front door into a spacious bungalow with a layout that flows effortlessly from room to room. The sunken family room is bright and inviting, featuring a huge front window that fills the space with natural light and offers plenty of room to gather, relax, and unwind. From there, the main floor continues seamlessly into the separate dining room and oversized eat-in kitchen, creating a layout that feels both open and functional while still giving each space its own purpose. One of the standout features is the oversized eat-in kitchen, with plenty of room for a large table where family and friends can gather. High ceilings and an abundance of windows fill the space with natural light, while the separate dining room gives you even more room for hosting holidays, dinners, and special occasions. Outside, the beautifully landscaped and fully fenced backyard feels like its own private retreat. Enjoy views of the Escarpment, a generous grass area, established cherry and pear trees, and a dedicated space ready for a patio where you can sit back, entertain, or simply enjoy the surroundings. Located in a mature, family-friendly neighbourhood close to schools, parks, walking trails, shopping, and highway access, 27 Brentwood Drive offers a rare combination of space, natural light, beautiful outdoor living, and an incredible location under the Escarpment. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T16:38:57.711323+00:00"
+"Directions": "Brentwood and Gray Road"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2093102"
+"ListOfficeKey": "284780"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "75 x 100 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T16:10:17Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T18:10:30Z"
+"Stories": "1.0"
+"StreetName": "Brentwood"
+"StreetNumber": "27"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5311.13"
+"VirtualTourURLUnbranded": "https://youtu.be/hp7Bq5aYl-w"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30011326/27-brentwood-drive-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 75.0
+"OriginalEntryTimestamp": "2026-07-09T16:10:17Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1365580"
+"ListOfficeNationalAssociationId": "1344707"
+"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('30011326')"
+"ID": "1608377"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25358
+post_id: "1608297"
+post_author: 1
+"ListingKey": "30010368"
+"ListingId": "40843051"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T15:35:22Z"
+"RFModificationTimestamp": "2026-07-09T15:59:48Z"
+"ListPrice": 869900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.17
+"LivingArea": 1504.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G2W9"
+"UnparsedAddress": "27 BRENTWOOD Drive, Stoney Creek, Ontario L8G2W9"
+"Coordinates": array:2 [
0 => -79.7491215
1 => 43.2154538
]
+"Latitude": 43.2154538
+"Longitude": -79.7491215
+"YearBuilt": 1957
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 27 Brentwood Drive, a well-loved bungalow in the sought-after Cherry Heights neighbourhood of Stoney Creek, nestled beneath the Escarpment. Offering 3+1 bedrooms and 2 full bathrooms, this home has the space and flexibility to work for a variety of lifestyles. Enter through the beautiful solid front door into a spacious bungalow with a layout that flows effortlessly from room to room. The sunken family room is bright and inviting, featuring a huge front window that fills the space with natural light and offers plenty of room to gather, relax, and unwind. From there, the main floor continues seamlessly into the separate dining room and oversized eat-in kitchen, creating a layout that feels both open and functional while still giving each space its own purpose. One of the standout features is the oversized eat-in kitchen, with plenty of room for a large table where family and friends can gather. High ceilings and an abundance of windows fill the space with natural light, while the separate dining room gives you even more room for hosting holidays, dinners, and special occasions. Outside, the beautifully landscaped and fully fenced backyard feels like its own private retreat. Enjoy views of the Escarpment, a generous grass area, established cherry and pear trees, and a dedicated space ready for a patio where you can sit back, entertain, or simply enjoy the surroundings. Located in a mature, family-friendly neighbourhood close to schools, parks, walking trails, shopping, and highway access, 27 Brentwood Drive offers a rare combination of space, natural light, beautiful outdoor living, and an incredible location under the Escarpment. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T15:59:39.287099+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Other"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Boiler"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1980366"
+"ListOfficeKey": "262629"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.17"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T14:30:32Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T15:29:44Z"
+"Stories": "1.0"
+"StreetName": "BRENTWOOD"
+"StreetNumber": "27"
+"StreetSuffix": "Drive"
+"SubdivisionName": "516 - Cherry Heights"
+"TaxAnnualAmount": "5311.13"
+"VirtualTourURLUnbranded": "https://youtu.be/hp7Bq5aYl-w"
+"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/30010368/27-brentwood-drive-stoney-creek"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1733707"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "284640"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 75.0
+"AboveGradeFinishedArea": 1504
+"OriginalEntryTimestamp": "2026-07-09T14:30:32.39Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1266082"
+"ListOfficeNationalAssociationId": "1223032"
+"CoListAgentNationalAssociationId": "1177332"
+"CoListOfficeNationalAssociationId": "1344651"
+"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('30010368')"
+"ID": "1608297"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25356
+post_id: "1604639"
+post_author: 1
+"ListingKey": "30006438"
+"ListingId": "X13538808"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-08T18:15:10Z"
+"RFModificationTimestamp": "2026-07-08T18:37:48Z"
+"ListPrice": 869900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G3W9"
+"UnparsedAddress": "115 GREEN ROAD, Hamilton (Stoney Creek), Ontario L8G3W9"
+"Coordinates": array:2 [
0 => -79.735437
1 => 43.2178911
]
+"Latitude": 43.2178911
+"Longitude": -79.735437
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this spacious and recently upgraded side-split in Stoney Creek, offering approximately over 2,000 sq. ft. of finished living space and a flexible layout ideal for families, multi-generational living, or buyers looking for added income potential. Featuring 2+2 bedrooms, 2 full bathrooms, and two kitchens, this home provides excellent functionality across multiple levels, with the lower level offering great potential for extended family use or a future income setup. The separate double garage adds even more value, with plenty of room for parking, storage, or use as a workshop. Ideally located close to schools, parks, public transit, and everyday amenities, this property also offers beautiful views of the escarpment, combining space, convenience, and long-term potential in a desirable Stoney Creek location. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Apartment in basement"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-08T18:37:34.378191+00:00"
+"Directions": "Cross Streets: King St E. ** Directions: KING ST E, NORTH ON GREEN ROAD."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2108302"
+"ListOfficeKey": "290358"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "63.4 x 109.8 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-08T18:09:54Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-08T18:09:54Z"
+"StreetName": "Green"
+"StreetNumber": "115"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5436"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30006438/115-green-road-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 63.4
+"OriginalEntryTimestamp": "2026-07-08T18:09:53.99Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1377252"
+"ListOfficeNationalAssociationId": "1386142"
+"Media": array:42 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30006438')"
+"ID": "1604639"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25331
+post_id: "1593559"
+post_author: 1
+"ListingKey": "29989752"
+"ListingId": "X13523052"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T16:20:05Z"
+"RFModificationTimestamp": "2026-07-09T16:21:48Z"
+"ListPrice": 439900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G1B7"
+"UnparsedAddress": "204 - 966 QUEENSTON ROAD, Hamilton (Stoney Creek), Ontario L8G1B7"
+"Coordinates": array:2 [
0 => -79.7507725
1 => 43.2246906
]
+"Latitude": 43.2246906
+"Longitude": -79.7507725
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A bright and inviting 2-bed, 1.5-bath condo with convenient ensuite laundry in the heart of Stoney Creek, this warm and stylish home blends comfort with modern ease. The open-concept layout creates a natural flow for everyday living, with spacious living and dining areas enhanced by fresh, contemporary flooring. A new furnace and A/C provide year-round peace of mind, while the private in-suite laundry adds everyday practicality. Whether you're enjoying a quiet morning coffee or hosting friends for dinner, the space feels effortless, uplifting, and ready for your next chapter. Perfect for first-time buyers, downsizers, or anyone seeking a move-in-ready home in a vibrant, convenient community. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Intercom"
3 => "Dishwasher"
4 => "Dryer"
5 => "Freezer"
]
+"AssociationFee": "823.61"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-04T18:47:57.474928+00:00"
+"Directions": "Cross Streets: Queenston & Donn. ** Directions: North on Centennial Pkwy E onto Queenston."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2259210"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Ravine"
1 => "Balcony"
2 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-04T17:39:50Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T16:10:05Z"
+"StreetName": "Queenston"
+"StreetNumber": "966"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "2783.38"
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29989752/204-966-queenston-road-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Property Management Guild"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Storage - Locker"
1 => "Party Room"
2 => "Visitor Parking"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-04T17:39:49.94Z"
+"ListAgentNationalAssociationId": "1499122"
+"ListOfficeNationalAssociationId": "1274323"
+"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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29989752')"
+"ID": "1593559"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23461
+post_id: "1593560"
+post_author: 1
+"ListingKey": "29989642"
+"ListingId": "40845240"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-05T14:35:11Z"
+"RFModificationTimestamp": "2026-07-05T14:57:15Z"
+"ListPrice": 439900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1014.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G1B7"
+"UnparsedAddress": "966 QUEENSTON Road Unit# 204, Stoney Creek, Ontario L8G1B7"
+"Coordinates": array:2 [
0 => -79.7508151
1 => 43.224536
]
+"Latitude": 43.224536
+"Longitude": -79.7508151
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A bright and inviting 2-bed, 1.5-bath condo with convenient ensuite laundry in the heart of Stoney Creek, this warm and stylish home blends comfort with modern ease. The open-concept layout creates a natural flow for everyday living, with spacious living and dining areas enhanced by fresh, contemporary flooring. A new furnace and A/C provide year-round peace of mind, while the private in-suite laundry adds everyday practicality. Whether you're enjoying a quiet morning coffee or hosting friends for dinner, the space feels effortless, uplifting, and ready for your next chapter. Perfect for first-time buyers, downsizers, or anyone seeking a move-in-ready home in a vibrant, convenient community. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Freezer"
]
+"AssociationFee": "823.61"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-04T18:41:54.425625+00:00"
+"Directions": "NORTH ON CENTENNIAL PARKWAY EAST ONTO QUEENSTON"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2086842"
+"ListOfficeKey": "54949"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-04T23:20:52Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-05T14:29:23Z"
+"Stories": "1.0"
+"StreetName": "QUEENSTON"
+"StreetNumber": "966"
+"StreetSuffix": "Road"
+"SubdivisionName": "515 - Battlefield"
+"TaxAnnualAmount": "2783.38"
+"VirtualTourURLUnbranded": "https://youriguide.com/204_966_queenston_rd_hamilton_on"
+"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/29989642/966-queenston-road-unit-204-stoney-creek"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "RM5"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1014
+"OriginalEntryTimestamp": "2026-07-04T16:48:14.52Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1360150"
+"ListOfficeNationalAssociationId": "1003557"
+"Media": array:42 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29989642')"
+"ID": "1593560"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25359
+post_id: "1591438"
+post_author: 1
+"ListingKey": "29986849"
+"ListingId": "X13520276"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T19:50:05Z"
+"RFModificationTimestamp": "2026-07-03T23:37:10Z"
+"ListPrice": 855000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G3W4"
+"UnparsedAddress": "124 CORMAN AVENUE, Hamilton (Stoney Creek), Ontario L8G3W4"
+"Coordinates": array:2 [
0 => -79.739158
1 => 43.22
]
+"Latitude": 43.22
+"Longitude": -79.739158
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Fully renovated with all Building permits and ESA certificate. NEW double wide asphalt driveway. NEW 6x6 post fencing. NEW concrete wrap-around. Surrounded by custom million dollar homes! Almost 2,000 square feet of living space. Spacious 3+2bedrooms and 2 full bathrooms. Everything new within last few months. 1 inch city water line. New electrical, plumbing, custom kitchen with quartz counter tops and backsplash, led pot lights, 2 full bathrooms, all windows and doors, custom trim work, all baseboards and casing, New S.S appliance package included (Gas stove hookup), high efficiency Gas furnace, AC unit, Water heater (all owned with warranty), list goes on! Updated sump pump for piece of mind, fully fenced, 141.50 feet deep corner lot. Enjoy the wood burning fireplace (chimney swept/cleaned), nothing else to do but to enjoy the bright and warm home! Enjoy trails, parks, and schools just steps away, with public transit and everyday essentials within walking distance.Minutes to QEW, Red Hill, and Costco, this location offers the perfect blend of lifestyle, convenience, and opportunity! OPEN HOUSE SUNDAY 2-4 PM! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T23:37:03.589638+00:00"
+"Directions": "Cross Streets: KING ST. EAST. ** Directions: KING ST. E TO CORMAN AVE., AT THE CORNER OF CORMAN AND CARLA AVE."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2211668"
+"ListOfficeKey": "286948"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "Sump Pump"
]
+"LotSizeDimensions": "65 x 141 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T19:40:26Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T19:40:26Z"
+"Stories": "1.0"
+"StreetName": "Corman"
+"StreetNumber": "124"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4600"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/364689"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29986849/124-corman-avenue-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 65.0
+"OriginalEntryTimestamp": "2026-07-03T19:40:26.26Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1457625"
+"ListOfficeNationalAssociationId": "1365211"
+"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": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986849')"
+"ID": "1591438"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25360
+post_id: "1590213"
+post_author: 1
+"ListingKey": "29985571"
+"ListingId": "40845048"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T14:45:03Z"
+"RFModificationTimestamp": "2026-07-09T15:11:28Z"
+"ListPrice": 855000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.21
+"LivingArea": 1964.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G3W4"
+"UnparsedAddress": "124 CORMAN Avenue, Stoney Creek, Ontario L8G3W4"
+"Coordinates": array:2 [
0 => -79.7398287
1 => 43.2192534
]
+"Latitude": 43.2192534
+"Longitude": -79.7398287
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Fully renovated with all Building permits and ESA certificate. NEW double wide asphalt driveway. NEW 6x6 post fencing. NEW concrete wrap-around. Surrounded by custom million dollar homes! Almost 2,000 square feet of living space. Spacious 3+2 bedrooms and 2 full bathrooms. Everything new within last few months. 1 inch city water line. New electrical, plumbing, custom kitchen with quartz counter tops and backsplash, led pot lights, 2 full bathrooms, all windows and doors, custom trim work, all baseboards and casing, New S.S appliance package included (Gas stove hook up), high efficiency Gas furnace, AC unit, Water heater (all owned with warranty), list goes on! Updated sump pump for piece of mind, fully fenced, 141.50 feet deep corner lot. Enjoy the wood burning fireplace (chimney swept/cleaned), nothing else to do but to enjoy the bright and warm home! Enjoy trails, parks, and schools just steps away, with public transit and everyday essentials within walking distance. Minutes to QEW, Red Hill, and Costco, this location offers the perfect blend of lifestyle, convenience! Book your tour.. (id:62650)"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T18:58:58.797263+00:00"
+"Directions": "KING STREET EAST TO CORMAN AVE., AT THE CORNER OF CORMAN AND CARLA AVE."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2020660"
+"ListOfficeKey": "289605"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
2 => "In-Law Suite"
]
+"LotSizeDimensions": "0.21"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T14:31:18Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T14:31:18Z"
+"Stories": "1.0"
+"StreetName": "CORMAN"
+"StreetNumber": "124"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "516 - Cherry Heights"
+"TaxAnnualAmount": "4600"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/364689"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29985571/124-corman-avenue-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1921958"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "54876"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 65.0
+"AboveGradeFinishedArea": 1044
+"BelowGradeFinishedArea": 920
+"OriginalEntryTimestamp": "2026-07-03T17:18:49.05Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1300535"
+"ListOfficeNationalAssociationId": "1379433"
+"CoListAgentNationalAssociationId": "1227299"
+"CoListOfficeNationalAssociationId": "1003493"
+"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": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29985571')"
+"ID": "1590213"
}
]
+success: true
+page_size: 9
+page_count: 17
+count: 152
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]