array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29198075/Property?$select=ALL&$top=20&$filter=ListingKey eq 29198075&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29198075/Property?$select=ALL&$top=20&$filter=ListingKey eq 29198075&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23512
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23514
+post_id: "496581"
+post_author: 1
+"ListingKey": "29198075"
+"ListingId": "40794604"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-20T19:15:47Z"
+"RFModificationTimestamp": "2025-12-20T19:38:46Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0.154
+"LivingArea": 595.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E1L2"
+"UnparsedAddress": "41 LAKE Avenue Unit# Main, Stoney Creek, Ontario L8E1L2"
+"Coordinates": array:2 [
0 => -79.7550632
1 => 43.227281
]
+"Latitude": 43.227281
+"Longitude": -79.7550632
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this charming main floor unit at 41 Lake Avenue Drive in desirable Stoney Creek location! This 1-bedroom, 1-bath home features a bright living room with a bay window, an updated kitchen with modern finishes, and in-suite laundry for added convenience. Enjoy your own private deck and yard, perfect for relaxing outdoors or entertaining guests. The unit includes 2 parking spaces, a pantry closet, and a front foyer closet, providing plenty of storage. Located just minutes from downtown Stoney Creek, you’ll have easy access to shops, restaurants, parks, and transit. All utilities are included, making this a hassle-free and comfortable rental in a great location. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
]
+"AssociationFeeIncludes": array:4 [
0 => "Cable TV"
1 => "Heat"
2 => "Electricity"
3 => "Water"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Wall unit"
]
+"CreationDate": "2025-12-20T19:33:08.708185+00:00"
+"Directions": "Highway 8 to Lake Avenue Drive (BETWEEN KING & QUEENSTON), corner of Randall Drive & Lake"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Baseboard heaters"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524896"
+"ListOfficeKey": "55053"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Crushed stone driveway"
]
+"LotSizeDimensions": "0.154"
+"PhotosChangeTimestamp": "2025-12-20T19:08:40Z"
+"PhotosCount": 22
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-20T19:08:40Z"
+"Stories": "1.0"
+"StreetName": "LAKE"
+"StreetNumber": "41"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "515 - Battlefield"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1551845392"
"RoomType" => "Laundry room"
"ListingId" => "40794604"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29198075"
"RoomLength" => null
"RoomDimensions" => "4'0'' x 2'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-20T19:08:40.02Z"
]
1 => array:11 [
"RoomKey" => "1551845393"
"RoomType" => "Primary Bedroom"
"ListingId" => "40794604"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29198075"
"RoomLength" => null
"RoomDimensions" => "14'10'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-20T19:08:40.02Z"
]
2 => array:11 [
"RoomKey" => "1551845394"
"RoomType" => "3pc Bathroom"
"ListingId" => "40794604"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29198075"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 7'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-20T19:08:40.02Z"
]
3 => array:11 [
"RoomKey" => "1551845395"
"RoomType" => "Great room"
"ListingId" => "40794604"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29198075"
"RoomLength" => null
"RoomDimensions" => "14'11'' x 14'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-20T19:08:40.02Z"
]
4 => array:11 [
"RoomKey" => "1551845396"
"RoomType" => "Kitchen"
"ListingId" => "40794604"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29198075"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-20T19:08:40.02Z"
]
5 => array:11 [
"RoomKey" => "1551845397"
"RoomType" => "Foyer"
"ListingId" => "40794604"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29198075"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-20T19:08:40.02Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29198075/41-lake-avenue-unit-main-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1650
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 595
+"OriginalEntryTimestamp": "2025-12-20T19:08:39.94Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"Media": array:22 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6377589465"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198075/8cfdbfc7c7308b81530a6e24b5cf3486.webp"
"MediaSize" => 194372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198075/thumbnail-8cfdbfc7c7308b81530a6e24b5cf3486.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "1 bedroom main floor unit with 2 car front parking"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40794604"
"ResourceRecordKey" => "29198075"
"ModificationTimestamp" => "2025-12-20T19:08:39.95Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6377589474"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198075/0287df0e78a41c8b2d2d1e88cc07f680.webp"
"MediaSize" => 216575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198075/thumbnail-0287df0e78a41c8b2d2d1e88cc07f680.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious front & side deck, lovely for summer nites."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794604"
"ResourceRecordKey" => "29198075"
"ModificationTimestamp" => "2025-12-20T19:08:39.95Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6377589499"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198075/93cc9d530c35cca325c1a3730276363a.webp"
"MediaSize" => 70626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198075/thumbnail-93cc9d530c35cca325c1a3730276363a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen with glass backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794604"
"ResourceRecordKey" => "29198075"
"ModificationTimestamp" => "2025-12-20T19:08:39.95Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6377589538"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198075/4e83b039d3d7ced53c3f5cf9700d4997.webp"
"MediaSize" => 75034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198075/thumbnail-4e83b039d3d7ced53c3f5cf9700d4997.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Great room with bay window and heat pump to keep comfortable year round. Heat in Winter & air conditioning in summer."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794604"
"ResourceRecordKey" => "29198075"
"ModificationTimestamp" => "2025-12-20T19:08:39.95Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6377589565"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198075/4108db826c4dd132a2c646edc1f79039.webp"
"MediaSize" => 58051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198075/thumbnail-4108db826c4dd132a2c646edc1f79039.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "3 piece bathroom with large shower."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794604"
"ResourceRecordKey" => "29198075"
"ModificationTimestamp" => "2025-12-20T19:08:39.95Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6377589629"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198075/1bbfa04f02ebf891d2eedf9d557936ec.webp"
"MediaSize" => 147278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198075/thumbnail-1bbfa04f02ebf891d2eedf9d557936ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Side deck accesses main floor entry."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794604"
"ResourceRecordKey" => "29198075"
"ModificationTimestamp" => "2025-12-20T19:08:39.95Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6377589684"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198075/54cd7a39967e5c55c5dd4e118f2693b5.webp"
"MediaSize" => 58125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198075/thumbnail-54cd7a39967e5c55c5dd4e118f2693b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Foyer is bright with tile flooring for easy clean up."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794604"
"ResourceRecordKey" => "29198075"
"ModificationTimestamp" => "2025-12-20T19:08:39.95Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6377589735"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198075/1c40f486b3155c08699f3d4d7512c9fb.webp"
"MediaSize" => 71828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198075/thumbnail-1c40f486b3155c08699f3d4d7512c9fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Convenient entry closet helps keep you organized."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794604"
"ResourceRecordKey" => "29198075"
"ModificationTimestamp" => "2025-12-20T19:08:39.95Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6377589804"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198075/43f7513b2dca20596b4eb882049fe5b3.webp"
"MediaSize" => 66639
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198075/thumbnail-43f7513b2dca20596b4eb882049fe5b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious great room overlooks front deck."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794604"
"ResourceRecordKey" => "29198075"
"ModificationTimestamp" => "2025-12-20T19:08:39.95Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6377589861"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198075/d9fe0153b287523f77212f4acbe59844.webp"
"MediaSize" => 67156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198075/thumbnail-d9fe0153b287523f77212f4acbe59844.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Laminate flooring in great room are easy to keep clean."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794604"
"ResourceRecordKey" => "29198075"
"ModificationTimestamp" => "2025-12-20T19:08:39.95Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6377589909"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198075/e4df8e762e902fcdc5aacb84826d742b.webp"
"MediaSize" => 62649
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198075/thumbnail-e4df8e762e902fcdc5aacb84826d742b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Ceiling fan helps circulate fresh air."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794604"
"ResourceRecordKey" => "29198075"
"ModificationTimestamp" => "2025-12-20T19:08:39.95Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6377589994"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198075/bcb7318c8bc9b3370e6d244ccf49c4a7.webp"
"MediaSize" => 90490
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198075/thumbnail-bcb7318c8bc9b3370e6d244ccf49c4a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stainless stove & fridge included."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794604"
"ResourceRecordKey" => "29198075"
"ModificationTimestamp" => "2025-12-20T19:08:39.95Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6377590062"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198075/68ff7c8f2d21641b90f45ddfa6a2d731.webp"
"MediaSize" => 84180
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198075/thumbnail-68ff7c8f2d21641b90f45ddfa6a2d731.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Plenty of counter space of cooking."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794604"
"ResourceRecordKey" => "29198075"
"ModificationTimestamp" => "2025-12-20T19:08:39.95Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6377590136"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198075/751a3f4897b2f5c81a19120d5af11b32.webp"
"MediaSize" => 48109
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198075/thumbnail-751a3f4897b2f5c81a19120d5af11b32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Tile flooring in Kitchen & foyer."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794604"
"ResourceRecordKey" => "29198075"
"ModificationTimestamp" => "2025-12-20T19:08:39.95Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6377590186"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198075/32e1a95e44d59376efc9ae2d1bc969f1.webp"
"MediaSize" => 61004
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198075/thumbnail-32e1a95e44d59376efc9ae2d1bc969f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom is spacious with closet & window."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794604"
"ResourceRecordKey" => "29198075"
"ModificationTimestamp" => "2025-12-20T19:08:39.95Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6377590194"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198075/633b642d6dcc3f9657984ef9d9b7d070.webp"
"MediaSize" => 56428
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198075/thumbnail-633b642d6dcc3f9657984ef9d9b7d070.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794604"
"ResourceRecordKey" => "29198075"
"ModificationTimestamp" => "2025-12-20T19:08:39.95Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6377590248"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198075/cecd2a89f3ca90a45305e86b0060fc25.webp"
"MediaSize" => 69800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198075/thumbnail-cecd2a89f3ca90a45305e86b0060fc25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794604"
"ResourceRecordKey" => "29198075"
"ModificationTimestamp" => "2025-12-20T19:08:39.95Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6377590264"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198075/97c4854c3fb4196067f2e3a3a0a9c679.webp"
"MediaSize" => 80006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198075/thumbnail-97c4854c3fb4196067f2e3a3a0a9c679.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main floor laundry is conveniently located in the unit."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794604"
"ResourceRecordKey" => "29198075"
"ModificationTimestamp" => "2025-12-20T19:08:39.95Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6377590317"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198075/8579d3ab777d8df03f12dd92598bb4b7.webp"
"MediaSize" => 186227
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198075/thumbnail-8579d3ab777d8df03f12dd92598bb4b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lovely front deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794604"
"ResourceRecordKey" => "29198075"
"ModificationTimestamp" => "2025-12-20T19:08:39.95Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6377590357"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198075/c1c67baeb193fefd84762d44c08b4273.webp"
"MediaSize" => 131431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198075/thumbnail-c1c67baeb193fefd84762d44c08b4273.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Side entry to main floor unit."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794604"
"ResourceRecordKey" => "29198075"
"ModificationTimestamp" => "2025-12-20T19:08:39.95Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6377590380"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198075/99d56598dc712906e02b5c6ef4c22678.webp"
"MediaSize" => 152178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198075/thumbnail-99d56598dc712906e02b5c6ef4c22678.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794604"
"ResourceRecordKey" => "29198075"
"ModificationTimestamp" => "2025-12-20T19:08:39.95Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6377590434"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198075/f267667dd154fbe667e3bdaaf5ec33cf.webp"
"MediaSize" => 211118
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198075/thumbnail-f267667dd154fbe667e3bdaaf5ec33cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794604"
"ResourceRecordKey" => "29198075"
"ModificationTimestamp" => "2025-12-20T19:08:39.95Z"
]
]
+"Member": array:1 [
0 => array:24 [
"MemberFullName" => "Daniella Piccolotto"
"MemberFirstName" => "Daniella"
"MemberLastName" => "Piccolotto"
"MemberMlsId" => "HBPICCODA"
"OriginatingSystemName" => 26
"MemberKey" => "1524896"
"ModificationTimestamp" => "2025-10-28T23:11:37Z"
"MemberMiddleName" => "Cicchi"
"MemberStatus" => "Active"
"OfficeKey" => "55053"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberFax" => "905-662-2227"
"MemberCity" => "Stoney Creek"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-308-6811"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"MemberNationalAssociationId" => "1064309"
"OfficeNationalAssociationId" => "1003511"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "Royal LePage State Realty Inc."
"OfficePhone" => "905-662-6666"
"OfficeMlsId" => "HBROYSTATE"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "55053"
"ModificationTimestamp" => "2025-09-16T21:02:09Z"
"OfficeAddress1" => "115 HIGHWAY #8 Unit:100"
"OfficeCity" => "Stoney Creek"
"OfficePostalCode" => "L8G1C"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"OfficeFax" => "905-662-2227"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OfficeNationalAssociationId" => "1003511"
"FranchiseNationalAssociationId" => "1230730"
"OfficeBrokerNationalAssociationId" => "1063200"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29198075')"
+"ID": "496581"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 55053/Office?$select=ALL&$top=10&$filter=OfficeKey eq 55053&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 55053/Office?$select=ALL&$top=10&$filter=OfficeKey eq 55053&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25322
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25324
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage State Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-662-6666"
+"OfficeMlsId": "HBROYSTATE"
+"ModificationTimestamp": "2025-09-16T21:02:09Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "55053"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "115 HIGHWAY #8 Unit:100"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Stoney Creek"
+"OfficePostalCode": "L8G1C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1003511"
+"OriginalEntryTimestamp": null
+"OfficeFax": "905-662-2227"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439620"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "55053"
"SocialMediaUrlOrId" => "https://www.royallepagestate.ca/"
"ModificationTimestamp" => "2025-09-16T19:17:00Z"
]
]
+"FranchiseNationalAssociationId": "1230730"
+"OfficeBrokerNationalAssociationId": "1063200"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('55053')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1524896/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1524896&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1524896/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1524896&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25327
+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 29198075" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24961
+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 29198075/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29198075&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29198075/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29198075&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24941
+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 29198075 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7550632 43.227281)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29198075 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7550632 43.227281)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29198075 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7550632 43.227281)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29198075 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7550632 43.227281)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24770
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25173
+post_id: "500293"
+post_author: 1
+"ListingKey": "29202410"
+"ListingId": "X12648140"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-23T22:01:12Z"
+"RFModificationTimestamp": "2025-12-23T22:05:45Z"
+"ListPrice": 524900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G4A7"
+"UnparsedAddress": "15 - 150 GATESHEAD CRESCENT, Hamilton (Stoney Creek), Ontario L8G4A7"
+"Coordinates": array:2 [
0 => -79.740933
1 => 43.220106
]
+"Latitude": 43.220106
+"Longitude": -79.740933
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 15-150 Gateshead Cres, SC. This spectacular, immaculate townhome is situated in one of the most convenient and desire-able locations in Stoney Creek. Featuring 3 bedrooms, 1.5 bathrooms, with a partially finished basement, making it a perfect home for first time buyers and down-sizers alike. On the main floor, you'll find newer modern white kitchen cupboards, countertops, stylish appliances, a large window over the sink, spacious living room with lot of natural light, dining room with access to fully fenced back yard, and convenient powder room. Beautiful staircase leading you up to the second level is sure to impress. The second floor contains 3 good sized bedrooms with laminate flooring and full bathroom. Elegant recreation room gives you plenty of space for every day entertainment and enjoyment. Parking is conveniently located on the back of townhome for easy access/parking. Pride of ownership is evident in this meticulously cared for home. You'll fall in love, the moment you walk in. This beautiful home checks off all necessary features and is located near schools, shopping, public transit, hwy access and all necessary amenities. Shows 10++. RSA. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Microwave"
5 => "Window Coverings"
6 => "Water Heater"
]
+"AssociationFee": "420"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Cable TV"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-23T19:45:05.170341+00:00"
+"Directions": "Cross Streets: Highway 8. ** Directions: Highway 8 - South on Gateshead Crescent."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1413922"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-23T18:43:33Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-23T21:45:50Z"
+"Stories": "2.0"
+"StreetName": "Gateshead"
+"StreetNumber": "150"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "2827.41"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/cvtnb/361046#Maps"
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1553235303"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12648140"
"RoomLevel" => "Second level"
"RoomWidth" => 3.56
"ListingKey" => "29202410"
"RoomLength" => 4.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-23T21:45:50.63Z"
]
1 => array:11 [
"RoomKey" => "1553235304"
"RoomType" => "Bedroom 2"
"ListingId" => "X12648140"
"RoomLevel" => "Second level"
"RoomWidth" => 2.84
"ListingKey" => "29202410"
"RoomLength" => 3.94
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-23T21:45:50.64Z"
]
2 => array:11 [
"RoomKey" => "1553235305"
"RoomType" => "Bedroom 3"
"ListingId" => "X12648140"
"RoomLevel" => "Second level"
"RoomWidth" => 2.87
"ListingKey" => "29202410"
"RoomLength" => 2.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-23T21:45:50.64Z"
]
3 => array:11 [
"RoomKey" => "1553235306"
"RoomType" => "Living room"
"ListingId" => "X12648140"
"RoomLevel" => "Main level"
"RoomWidth" => 3.63
"ListingKey" => "29202410"
"RoomLength" => 4.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-23T21:45:50.64Z"
]
4 => array:11 [
"RoomKey" => "1553235307"
"RoomType" => "Dining room"
"ListingId" => "X12648140"
"RoomLevel" => "Main level"
"RoomWidth" => 2.77
"ListingKey" => "29202410"
"RoomLength" => 3.33
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-23T21:45:50.64Z"
]
5 => array:11 [
"RoomKey" => "1553235308"
"RoomType" => "Kitchen"
"ListingId" => "X12648140"
"RoomLevel" => "Main level"
"RoomWidth" => 2.9
"ListingKey" => "29202410"
"RoomLength" => 3.02
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-23T21:45:50.64Z"
]
6 => array:11 [
"RoomKey" => "1553235309"
"RoomType" => "Recreational, Games room"
"ListingId" => "X12648140"
"RoomLevel" => "Basement"
"RoomWidth" => 3.35
"ListingKey" => "29202410"
"RoomLength" => 5.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-23T21:45:50.64Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29202410/15-150-gateshead-crescent-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2025-12-23T18:43:33.68Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:50 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6381398465"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/53862564ca5ad8698b74b78ffdd9ee40.webp"
"MediaSize" => 156839
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-53862564ca5ad8698b74b78ffdd9ee40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6381398483"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/74d9a9f72d88c3fec59e9b745d513962.webp"
"MediaSize" => 168172
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-74d9a9f72d88c3fec59e9b745d513962.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6381398487"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/8d6d1f6a3338647bd699a26471e6a266.webp"
"MediaSize" => 233887
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-8d6d1f6a3338647bd699a26471e6a266.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6381398511"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/7a90aea80db90b19ddbbe39e1e00df31.webp"
"MediaSize" => 199921
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-7a90aea80db90b19ddbbe39e1e00df31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6381398534"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/967d59fa0fb2c9d84512183f354671b6.webp"
"MediaSize" => 228238
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-967d59fa0fb2c9d84512183f354671b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6381398598"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/58ac88e5b77b5ac78f0396a0e1958f22.webp"
"MediaSize" => 239597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-58ac88e5b77b5ac78f0396a0e1958f22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6381398634"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/ccbc0f0afe2ee79aae3a79f6f5e5351d.webp"
"MediaSize" => 93538
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-ccbc0f0afe2ee79aae3a79f6f5e5351d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6381398678"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/2606535d3e744f659f33fff76aeac6e4.webp"
"MediaSize" => 94708
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-2606535d3e744f659f33fff76aeac6e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6381398719"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/88191a866988e76751cb7002672417fe.webp"
"MediaSize" => 91368
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-88191a866988e76751cb7002672417fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6381398749"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/fd80d59c75fae10016be6daf0464a5ed.webp"
"MediaSize" => 88357
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-fd80d59c75fae10016be6daf0464a5ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6381398784"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/12808272349a8c49268560487142ea6c.webp"
"MediaSize" => 99798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-12808272349a8c49268560487142ea6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6381398820"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/3e7dd5c6ccceee719d6032dfe3a6047c.webp"
"MediaSize" => 70347
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-3e7dd5c6ccceee719d6032dfe3a6047c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6381398858"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/05a3ca6534b8f58252f4ea2455335a46.webp"
"MediaSize" => 110242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-05a3ca6534b8f58252f4ea2455335a46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6381398896"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/4c95bf651d9d58c3e0b11b21246f5d27.webp"
"MediaSize" => 98495
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-4c95bf651d9d58c3e0b11b21246f5d27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6381398927"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/2ac45a5906f92a80bc55ec50f9f9fda5.webp"
"MediaSize" => 105315
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-2ac45a5906f92a80bc55ec50f9f9fda5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6381398958"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/06f41d2ff827eee622fd6de9e20b5635.webp"
"MediaSize" => 105473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-06f41d2ff827eee622fd6de9e20b5635.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6381398991"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/8e342246283f4ffa1afea77f7199e06e.webp"
"MediaSize" => 108285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-8e342246283f4ffa1afea77f7199e06e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6381399012"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/a9acb3a7cdf4f657e68e1e9e9f0a6916.webp"
"MediaSize" => 112389
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-a9acb3a7cdf4f657e68e1e9e9f0a6916.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6381399044"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/f80ac85564b2a9941307022c52685373.webp"
"MediaSize" => 107985
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-f80ac85564b2a9941307022c52685373.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6381399074"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/5323fd406e3c194503d461220be1c04e.webp"
"MediaSize" => 104662
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-5323fd406e3c194503d461220be1c04e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6381399077"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/c9d6909fcfa58cad4b373faf8a77c067.webp"
"MediaSize" => 95737
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-c9d6909fcfa58cad4b373faf8a77c067.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6381399104"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/c8358fc9f58c13efe00a081665ca8f9c.webp"
"MediaSize" => 55531
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-c8358fc9f58c13efe00a081665ca8f9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6381399119"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/581f534b176be6bc2d36c1f814f24543.webp"
"MediaSize" => 62077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-581f534b176be6bc2d36c1f814f24543.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6381399137"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/a603b8ca2c123c9e7683d603bb7312ee.webp"
"MediaSize" => 108604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-a603b8ca2c123c9e7683d603bb7312ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6381399155"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/d53fd3ab0cee7f577579a78ef2f1c5ff.webp"
"MediaSize" => 74195
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-d53fd3ab0cee7f577579a78ef2f1c5ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6381399170"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/6c092604c189c82dc61bfbb3df061345.webp"
"MediaSize" => 82896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-6c092604c189c82dc61bfbb3df061345.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6381399185"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/4367f9be915e3f99193bbca621fe3d8a.webp"
"MediaSize" => 100145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-4367f9be915e3f99193bbca621fe3d8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6381399198"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/9588fface9700a355a0cd778e64d0ebe.webp"
"MediaSize" => 90865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-9588fface9700a355a0cd778e64d0ebe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6381399209"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/268af14e87b4b10563bf1c6dd3438627.webp"
"MediaSize" => 88851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-268af14e87b4b10563bf1c6dd3438627.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6381399234"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/2c4ca55202d83e0a18ce510e3e972acd.webp"
"MediaSize" => 94530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-2c4ca55202d83e0a18ce510e3e972acd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6381399250"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/b432092ba4e9294d9aa7d6b1a8a5a7fe.webp"
"MediaSize" => 77641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-b432092ba4e9294d9aa7d6b1a8a5a7fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6381399264"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/90711772e481a4923389c02ca1c5277a.webp"
"MediaSize" => 104182
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-90711772e481a4923389c02ca1c5277a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6381399277"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/e33aba82e3dd9363d2f8169a2c31e5a9.webp"
"MediaSize" => 96756
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-e33aba82e3dd9363d2f8169a2c31e5a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6381399291"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/7e56077c6216ce020d8ce09ba3eacb31.webp"
"MediaSize" => 60605
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-7e56077c6216ce020d8ce09ba3eacb31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6381399301"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/0bedf84a2fddc7646a4e7cc33f845204.webp"
"MediaSize" => 123046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-0bedf84a2fddc7646a4e7cc33f845204.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
"ResourceRecordKey" => "29202410"
"ModificationTimestamp" => "2025-12-23T18:43:33.69Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6381399316"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202410/3fc8011a402009586a5a9d3e8eef0d38.webp"
"MediaSize" => 100209
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202410/thumbnail-3fc8011a402009586a5a9d3e8eef0d38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12648140"
…2
]
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29202410')"
+"ID": "500293"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24797
+post_id: "500294"
+post_author: 1
+"ListingKey": "29202024"
+"ListingId": "40794910"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-23T16:35:27Z"
+"RFModificationTimestamp": "2025-12-23T19:18:30Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0.14
+"LivingArea": 1000.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E1P6"
+"UnparsedAddress": "249 FEDERAL Street Unit# LOWER, Stoney Creek, Ontario L8E1P6"
+"Coordinates": array:2 [
0 => -79.7350109
1 => 43.2230054
]
+"Latitude": 43.2230054
+"Longitude": -79.7350109
+"YearBuilt": 1964
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Amazing Stoney Creek location in a family friendly neighbourhood. Within close proximity to all amenities including parks, schools, shopping and bus routes. Spacious two bedroom basement apartment with a private side entrance. Large eat-in kitchen measuring 21' X 13'10. Spacious Living Room with gas fireplace and walk-up into the garage (used for storage but no access for parking). Large rear yard to be shared with the main floor tenant. Tenants are responsible for 50% of utilities (gas, electricity, water, water heater). Double driveway to be shared with the main floor Tenant (one parking spot included). All Tenants are to provide Full Equifax or Trans Union Credit Reports, rental application, Employment & reference letters, income verification, and bank statements if needed. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-23T19:18:22.995722+00:00"
+"Directions": "Federal Street between Norwich Road and Green Road"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1523812"
+"ListOfficeKey": "283099"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Corner Site"
]
+"LotSizeDimensions": "0.14"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-23T16:29:02Z"
+"PhotosCount": 27
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-23T16:29:02Z"
+"Stories": "1.0"
+"StreetName": "FEDERAL"
+"StreetNumber": "249"
+"StreetSuffix": "Street"
+"SubdivisionName": "511 - Eastdale/Poplar Park/Industrial"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"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/29202024/249-federal-street-unit-lower-stoney-creek"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1999
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 61.0
+"AboveGradeFinishedArea": 0
+"BelowGradeFinishedArea": 1000
+"OriginalEntryTimestamp": "2025-12-23T16:29:02.63Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"Media": array:27 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29202024')"
+"ID": "500294"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25174
+post_id: "498715"
+post_author: 1
+"ListingKey": "29200693"
+"ListingId": "40794756"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-23T01:40:33Z"
+"RFModificationTimestamp": "2025-12-23T01:43:51Z"
+"ListPrice": 524900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1558.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G4A7"
+"UnparsedAddress": "150 GATESHEAD Crescent Unit# 15, Stoney Creek, Ontario L8G4A7"
+"Coordinates": array:2 [
0 => -79.7414751
1 => 43.2213721
]
+"Latitude": 43.2213721
+"Longitude": -79.7414751
+"YearBuilt": 1976
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 15-150 Gateshead Cres, SC. This spectacular, immaculate townhome is situated in one of the most convenient and desire-able locations in Stoney Creek. Featuring 3 bedrooms, 1.5 bathrooms, with a partially finished basement, making it a perfect home for first time buyers and down-sizers alike. On the main floor, you’ll find newer modern white kitchen cupboards, countertops, stylish appliances, a large window over the sink, spacious living room with lot of natural light, dining room with access to fully fenced back yard, and convenient powder room. Beautiful staircase leading you up to the second level is sure to impress. The second floor contains 3 good sized bedrooms with laminate flooring and full bathroom. Elegant recreation room gives you plenty of space for every day entertainment and enjoyment. Parking is conveniently located on the back of townhome for easy access/parking. Pride of ownership is evident in this meticulously cared for home. You’ll fall in love, the moment you walk in. This beautiful home checks off all necessary features and is located near schools, shopping, public transit, hwy access and all necessary amenities. Book your apt today and be one of first to call this your home. Shows 10++. RSA. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFee": "420"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Cable TV"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-22T19:37:48.819021+00:00"
+"Directions": "Highway 8 - South on Gateshead Crescent"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Other"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563191"
+"ListOfficeKey": "262664"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2025-12-22T19:08:51Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-23T01:38:06Z"
+"Stories": "2.0"
+"StreetName": "GATESHEAD"
+"StreetNumber": "150"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "516 - Corman/South Meadow"
+"TaxAnnualAmount": "2827.41"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/cvt/361046"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29200693/150-gateshead-crescent-unit-15-stoney-creek"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "RM3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1244
+"BelowGradeFinishedArea": 314
+"OriginalEntryTimestamp": "2025-12-22T19:08:51Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Other"
+"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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29200693')"
+"ID": "498715"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24871
+post_id: "497312"
+post_author: 1
+"ListingKey": "28996297"
+"ListingId": "40777137"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-21T06:15:58Z"
+"RFModificationTimestamp": "2025-12-21T06:17:57Z"
+"ListPrice": 900000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1442.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G1X4"
+"UnparsedAddress": "7 AVALON Avenue, Stoney Creek, Ontario L8G1X4"
+"Coordinates": array:2 [
0 => -79.758639
1 => 43.224055
]
+"Latitude": 43.224055
+"Longitude": -79.758639
+"YearBuilt": 1950
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 7 Avalon Ave - where peace of mind meets polished design in the heart of Stoney Creek. Tucked at the end of a quiet, family-friendly cul-de-sac, this charming 3-bedroom, 2-bathroom bungalow sits on a generous lot with room to grow, play, or simply unwind. But what truly sets this home apart? It was professionally designed and renovated by the team from HGTV’s Holmes Family Rescue, with upgrades focused on safety, comfort, and long-term durability. Step inside and discover a bright, functional layout with thoughtful finishes and a lower level that’s been transformed into a stylish retreat - perfect for movie nights, remote work, or hosting guests. The 2022 renovation included a complete electrical overhaul with 200 amp service, advanced waterproofing using Schluter systems, a spa-inspired bathroom with heated floors and a brand-new laundry room featuring a steamer closet. Outside, the expansive backyard offers endless potential, while the dead-end street provides privacy and a true sense of community. Located in a sought-after neighbourhood close to parks, schools, and everyday amenities, with easy access to the QEW, Red Hill Parkway, and GO Transit. This is more than a home - it’s a professionally perfected haven ready for its next chapter. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
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": "2025-12-21T06:17:55.742613+00:00"
+"Directions": "Lake Avenue to Avalon Avenue"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2102891"
+"ListOfficeKey": "300660"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-10-22T23:21:59Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-21T06:00:43Z"
+"Stories": "1.0"
+"StreetName": "AVALON"
+"StreetNumber": "7"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "515 - Battlefield"
+"TaxAnnualAmount": "5020.22"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/7-Avalon-Ave"
+"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/28996297/7-avalon-avenue-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1829328"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "284371"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1235
+"BelowGradeFinishedArea": 207
+"OriginalEntryTimestamp": "2025-10-16T16:09:53.58Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"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]
]
+"Member": array:1 [
0 => array:4 [ …4]
]
+"Office": array:1 [
0 => array:5 [ …5]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28996297')"
+"ID": "497312"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25172
+post_id: "496598"
+post_author: 1
+"ListingKey": "29198328"
+"ListingId": "X12645042"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-21T00:10:59Z"
+"RFModificationTimestamp": "2025-12-21T00:12:22Z"
+"ListPrice": 314900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G3S4"
+"UnparsedAddress": "3 - 5 APPLEWOOD AVENUE, Hamilton (Stoney Creek), Ontario L8G3S4"
+"Coordinates": array:2 [
0 => -79.75238
1 => 43.217445
]
+"Latitude": 43.217445
+"Longitude": -79.75238
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Cheerful and Spacious Fully Renovated Condo In The Heart Of Old Stoney Creek. Fantastic Location in Close Proximity To 4 Parks, Recreation Facilities, Great Restaurants, Shopping, Public Transit, Stoney Creek Go, As Well As Lots Of Other Amenities. Many recent upgrades including new kitchen with marble design Backsplash, Quartz countertops, brand new stainless steel appliances and built in dishwasher, Luxury vinyl plank flooring, updated 4 piece bathroom, Freshly Painted throughout, New Windows, Double closets in the bright Bedroom, double wide hallway closet for storage, the list goes on! Nothing to do here but move in. With low condo fees and a very attractive price this home is perfect for first-time home buyers or those looking for an easy care-free lifestyle. Condo Fees Include Exterior Maintenance, Exterior Insurance, Heat, Water & your own Dedicated parking space! (id:62650)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Microwave"
4 => "Window Air Conditioner"
5 => "Window Coverings"
]
+"AssociationFee": "445.34"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2025-12-21T00:12:00.471617+00:00"
+"Directions": "Cross Streets: Gray Rd and King St E. ** Directions: Gray Rd to King St E to Applewood Ave."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Radiant heat"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1746450"
+"ListOfficeKey": "268318"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-20T23:52:35Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-20T23:56:55Z"
+"Stories": "3.0"
+"StreetName": "Applewood"
+"StreetNumber": "5"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "1079"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Niagara"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29198328/3-5-applewood-avenue-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2081731"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"CoListOfficeKey": "268318"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"ZoningDescription": "RM3"
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2025-12-20T22:56:53.53Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:32 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29198328')"
+"ID": "496598"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24842
+post_id: "491128"
+post_author: 1
+"ListingKey": "29196585"
+"ListingId": "X12643302"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-19T18:55:24Z"
+"RFModificationTimestamp": "2025-12-19T19:44:24Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G1T8"
+"UnparsedAddress": "23 BATTLEFIELD DRIVE, Hamilton (Stoney Creek), Ontario L8G1T8"
+"Coordinates": array:2 [
0 => -79.765534
1 => 43.2160889
]
+"Latitude": 43.2160889
+"Longitude": -79.765534
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Fixer-Upper Opportunity in Charming Old Stoney Creek. Located in a great neighbourhood, this 3+1 bedroom bungalow sits on a generous 60 x 100 ft lot, offering plenty of space and potential. This property provides both privacy and a rare opportunity to create your ideal home. The main level features hardwood flooring, classic shutters, living room with large beautiful bay window, dining room, eat-in kitchen and a walkout to a deck overlooking the spacious backyard. A separate entrance leads to the finished lower level, complete with an additional bedroom and large rec room - perfect for in-law potential, extended family, or a future income suite. With solid bones and a functional layout, this home is ready for your vision and updates. Whether you're an investor, first-time buyer, or someone looking to customize a home, this property has endless possibilities. Conveniently located close to parks, schools, shopping, and easy highway access, this bungalow blends potential with location. Don't miss your chance to make it your own in one of Stoney Creek's most established neighbourhoods. (id:62650)"
+"Appliances": array:2 [
0 => "All"
1 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-19T19:44:14.442402+00:00"
+"Directions": "Cross Streets: King Street West. ** Directions: Centennial Pkwy North- King St. W - Battlefield Drive."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2022178"
+"ListOfficeKey": "283372"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "60 x 100 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-19T18:48:21Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-19T18:48:21Z"
+"Stories": "1.0"
+"StreetName": "Battlefield"
+"StreetNumber": "23"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4942.8"
+"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": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29196585/23-battlefield-drive-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 60.0
+"OriginalEntryTimestamp": "2025-12-19T18:48:21.51Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:1 [
0 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29196585')"
+"ID": "491128"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23526
+post_id: "490751"
+post_author: 1
+"ListingKey": "29196345"
+"ListingId": "X12643016"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-20T20:30:19Z"
+"RFModificationTimestamp": "2025-12-20T20:31:29Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Riverdale)"
+"PostalCode": "L8E1E1"
+"UnparsedAddress": "64 GAINSBOROUGH ROAD, Hamilton (Riverdale), Ontario L8E1E1"
+"Coordinates": array:2 [
0 => -79.7601248
1 => 43.2312525
]
+"Latitude": 43.2312525
+"Longitude": -79.7601248
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Portion of Lease: Main Floor.This tastefully updated semi-detached bungalow showcases a modern, carpet-free layout designed for comfortable living. Stylish laminate flooring runs throughout the bright, open-concept living and dining spaces, enhanced by a large window and contemporary pot lighting. The well-appointed kitchen features quartz countertops, a tiled backsplash, stainless steel appliances, and plenty of cabinetry, making it both functional and inviting for everyday cooking or entertaining.The home offers three spacious bedrooms along with two beautifully renovated bathrooms, complete with modern finishes and elegant tile accents.Step outside to a fully fenced backyard, perfect for unwinding or enjoying outdoor gatherings during the warmer months.Additional conveniences include a large concrete driveway providing ample parking and a prime location close to shopping, major highways, parks, and schools. (id:62650)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Separate entrance"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-19T19:03:04.065337+00:00"
+"Directions": "Centennial Pkwy/Delawana Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2151987"
+"ListOfficeKey": "280225"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "30 x 118 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-20T20:19:46Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-20T20:19:46Z"
+"Stories": "1.0"
+"StreetName": "Gainsborough"
+"StreetNumber": "64"
+"StreetSuffix": "Road"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"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": "Riverdale"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29196345/64-gainsborough-road-hamilton-riverdale-riverdale"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2550
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 30.0
+"OriginalEntryTimestamp": "2025-12-19T17:48:53.6Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:4 [ …4]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29196345')"
+"ID": "490751"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24867
+post_id: "490755"
+post_author: 1
+"ListingKey": "29196387"
+"ListingId": "40794554"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-19T18:30:41Z"
+"RFModificationTimestamp": "2025-12-19T18:55:04Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1242.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G1T8"
+"UnparsedAddress": "23 BATTLEFIELD Drive, Stoney Creek, Ontario L8G1T8"
+"Coordinates": array:2 [
0 => -79.7652891
1 => 43.21589
]
+"Latitude": 43.21589
+"Longitude": -79.7652891
+"YearBuilt": 1956
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Fixer-Upper Opportunity in Charming Old Stoney Creek. Located in a great neighbourhood, this 3+1 bedroom bungalow sits on a generous 60 x 100 ft lot, offering plenty of space and potential. This property provides both privacy and a rare opportunity to create your ideal home. The main level features hardwood flooring, classic shutters, living room with large beautiful bay window, dining room, eat-in kitchen and a walkout to a deck overlooking the spacious backyard. A separate entrance leads to the finished lower level, complete with an additional bedroom and large rec room - perfect for in-law potential, extended family, or a future income suite. With solid bones and a functional layout, this home is ready for your vision and updates. Whether you're an investor, first-time buyer, or someone looking to customize a home, this property has endless possibilities. Conveniently located close to parks, schools, shopping, and easy highway access, this bungalow blends potential with location. Don't miss your chance to make it your own in one of Stoney Creek's most established neighbourhoods. (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-19T18:54:45.461749+00:00"
+"Directions": "Centennial Pkwy North- King St. W - Battlefield Drive"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2026433"
+"ListOfficeKey": "277682"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-19T18:10:28Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-19T18:10:28Z"
+"Stories": "1.0"
+"StreetName": "BATTLEFIELD"
+"StreetNumber": "23"
+"StreetSuffix": "Drive"
+"SubdivisionName": "515 - Battlefield"
+"TaxAnnualAmount": "4942.8"
+"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/29196387/23-battlefield-drive-stoney-creek"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 1242
+"OriginalEntryTimestamp": "2025-12-19T18:08:46.98Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:1 [
0 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29196387')"
+"ID": "490755"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24796
+post_id: "490406"
+post_author: 1
+"ListingKey": "29196069"
+"ListingId": "40791855"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-19T16:35:07Z"
+"RFModificationTimestamp": "2025-12-19T16:55:08Z"
+"ListPrice": 1499900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 4060.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G1E2"
+"UnparsedAddress": "231 8 Highway, Stoney Creek, Ontario L8G1E2"
+"Coordinates": array:2 [
0 => -79.737376
1 => 43.222173
]
+"Latitude": 43.222173
+"Longitude": -79.737376
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "NEWLY APPROVED MEDICAL USE - MINOR VARIANCE. A rare opportunity to own a commercial non-conforming office and residence in one, offering an exceptional range of permitted uses. Approved uses include medical offices, barber and beauty shops, estheticians, shoe repair, tailoring and dressmaking, dry-cleaning depots, laundromats, photographic studios, and optical shops. This unique property allows you to live and work in one place, with excellent visibility, ample parking, and flexibility for modern business owners. The 1.5-storey building blends professional functionality with comfortable, upgraded living. The commercial entrance opens to a welcoming reception area with slate flooring, 9' ceilings, track lighting, chair rail detailing, large windows facing Highway 8, and a convenient bathroom. A spacious waiting area leads to a large studio space with soaring ceilings-ideal for a medical office or clinic, with flexible options for treatment rooms or consultations. A large basement adds a private office and generous storage for records, equipment, or staff use. Outside, the property offers 10 parking spaces and two street-facing signs, providing outstanding exposure on a high-traffic corridor .The separate residential entrance reveals a beautifully updated home featuring an electric fireplace, stone feature wall, hardwood flooring, crown moulding, and California shutters throughout. The upgraded kitchen includes quartz countertops, stainless steel appliances, breakfast bar, backsplash, and under- and over-cabinet lighting. The primary bedroom offers a walk-out to a private balcony/deck. The fully finished basement adds a third bedroom with pot lights, built-in shelving, and a gas fireplace, plus a 3-piece bathroom and a large storage room. The expansive backyard completes the offering with a two-level deck, in-ground sprinklers, and a large shed with hydro-ideal for additional storage or workspace. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-19T16:54:58.700023+00:00"
+"Directions": "Highway 8/Warwick"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2146116"
+"ListOfficeKey": "289615"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2025-12-19T16:29:46Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-19T16:29:46Z"
+"Stories": "1.5"
+"StreetName": "8"
+"StreetNumber": "231"
+"StreetSuffix": "Highway"
+"SubdivisionName": "517 - Highway Valley/Dewitt"
+"TaxAnnualAmount": "10418.37"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=ZeZoKZsOCGk"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29196069/231-8-highway-stoney-creek"
+"ParkingTotal": 12
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2089963"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2051174"
+"CoListOfficeKey": "282362"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "289615"
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 70.0
+"AboveGradeFinishedArea": 2339
+"BelowGradeFinishedArea": 1721
+"OriginalEntryTimestamp": "2025-12-19T16:29:46.46Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"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:23 [ …23]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29196069')"
+"ID": "490406"
}
]
+success: true
+page_size: 9
+page_count: 18
+count: 154
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]