array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29914609 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1539162"
+post_author: 1
+"ListingKey": "29914609"
+"ListingId": "40840183"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T13:20:04Z"
+"RFModificationTimestamp": "2026-06-17T17:17:52Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2441.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8J0K9"
+"UnparsedAddress": "35 MIDHURST Heights Unit# 1, Hamilton, Ontario L8J0K9"
+"Coordinates": array:2 [
0 => -79.7653957
1 => 43.2049018
]
+"Latitude": 43.2049018
+"Longitude": -79.7653957
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beyond a home, Fallingwater is a statement of arrival and a masterpiece of the esteemed Losani Collection. This is not merely Unit #1; it is the vision that set the standard, the original model home that showcased the full potential of contemporary luxury living in Stoney Creek. Commanding the most expansive, pie-shaped lot, this end-unit sanctuary offers unrivaled privacy and a breathtaking, direct view over a tranquil outdoor pond—a serene vista enjoyed from your principal rooms. With only three units in the complex, exclusivity is paramount, and this residence represents the undisputed pinnacle. Step inside to discover over 2,441 square feet of impeccably designed, living space, artfully enhanced by high ceilings that amplifies the sense of light and volume. The home unfolds with the grace of a gallery, leading you to a sprawling 164 sq. ft. elevated terrace, your private stage for outdoor entertaining. Ascend further to the 241 sq. ft. rooftop terrace—a crowning glory offering panoramic views and an unparalleled space for sunset soirees or peaceful contemplation. While other, more modestly scaled units are available in the complex, Fallingwater stands apart. It is the largest, the first, and by every measure, the finest. This is the home for those who seek not just square footage, but significance; not just a view, but a vista; not just a unit, but a legacy property. Presented with professional photography that captures its exquisite d architectural brilliance, Fallingwater awaits its final curator. This is your chance to acquire the cornerstone residence of Stone Creek's most distinguished address. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Central Vacuum - Roughed In"
]
+"AssociationFee": "446.64"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T17:17:25.256814+00:00"
+"Directions": "Green Mountain and Upper Centennial"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Brick Veneer"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525060"
+"ListOfficeKey": "67816"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T13:10:49Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T13:10:48Z"
+"Stories": "2.0"
+"StreetName": "MIDHURST"
+"StreetNumber": "35"
+"StreetSuffix": "Heights"
+"SubdivisionName": "500 - Heritage Green"
+"TaxAnnualAmount": "6995.42"
+"View": "View of water"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [
"RoomKey" => "1661084841"
"RoomType" => "Storage"
"ListingId" => "40840183"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "7'1'' x 20'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.96Z"
]
1 => array:11 [
"RoomKey" => "1661084842"
"RoomType" => "Eat in kitchen"
"ListingId" => "40840183"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.96Z"
]
2 => array:11 [
"RoomKey" => "1661084843"
"RoomType" => "Sitting room"
"ListingId" => "40840183"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 15'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.96Z"
]
3 => array:11 [
"RoomKey" => "1661084844"
"RoomType" => "Bedroom"
"ListingId" => "40840183"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 15'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.97Z"
]
4 => array:11 [
"RoomKey" => "1661084845"
"RoomType" => "3pc Bathroom"
"ListingId" => "40840183"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.97Z"
]
5 => array:11 [
"RoomKey" => "1661084846"
"RoomType" => "Dining room"
"ListingId" => "40840183"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 16'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.97Z"
]
6 => array:11 [
"RoomKey" => "1661084847"
"RoomType" => "Bedroom"
"ListingId" => "40840183"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.97Z"
]
7 => array:11 [
"RoomKey" => "1661084848"
"RoomType" => "Bedroom"
"ListingId" => "40840183"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.97Z"
]
8 => array:11 [
"RoomKey" => "1661084849"
"RoomType" => "Bedroom"
"ListingId" => "40840183"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.98Z"
]
9 => array:11 [
"RoomKey" => "1661084850"
"RoomType" => "Primary Bedroom"
"ListingId" => "40840183"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "15'0'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.98Z"
]
10 => array:11 [
"RoomKey" => "1661084851"
"RoomType" => "Laundry room"
"ListingId" => "40840183"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.98Z"
]
11 => array:11 [
"RoomKey" => "1661084852"
"RoomType" => "Loft"
"ListingId" => "40840183"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.98Z"
]
12 => array:11 [
"RoomKey" => "1661084853"
"RoomType" => "3pc Bathroom"
"ListingId" => "40840183"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.98Z"
]
13 => array:11 [
"RoomKey" => "1661084854"
"RoomType" => "2pc Bathroom"
"ListingId" => "40840183"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.98Z"
]
14 => array:11 [
"RoomKey" => "1661084855"
"RoomType" => "Great room"
"ListingId" => "40840183"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 19'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.98Z"
]
15 => array:11 [
"RoomKey" => "1661084856"
"RoomType" => "Kitchen"
"ListingId" => "40840183"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.98Z"
]
16 => array:11 [
"RoomKey" => "1661084857"
"RoomType" => "Den"
"ListingId" => "40840183"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.98Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29914609/35-midhurst-heights-unit-1-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "P5, RM3-50, RM3-51"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 2441
+"OriginalEntryTimestamp": "2026-06-17T13:10:48.91Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1135225"
+"ListOfficeNationalAssociationId": "1132083"
+"Media": array:42 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29914609_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/a8f8b7266614a03c61a7387a29e89864.webp"
"MediaSize" => 113263
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-a8f8b7266614a03c61a7387a29e89864.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29914609_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/d8ba72ef1054b9db8096b2cf30f8f2fd.webp"
"MediaSize" => 123044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-d8ba72ef1054b9db8096b2cf30f8f2fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29914609_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/baf6ae96e5dcc598d13a346856846719.webp"
"MediaSize" => 185547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-baf6ae96e5dcc598d13a346856846719.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29914609_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/fd4d534d39cfc0369254a921f49c28da.webp"
"MediaSize" => 66662
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-fd4d534d39cfc0369254a921f49c28da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29914609_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/b05b1020c036dfb634e54d910cdbf433.webp"
"MediaSize" => 69434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-b05b1020c036dfb634e54d910cdbf433.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29914609_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/9cdee34c63930d934c8e300c135133a1.webp"
"MediaSize" => 57166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-9cdee34c63930d934c8e300c135133a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29914609_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/3a13603e01660839bebbb150b478c7c2.webp"
"MediaSize" => 57850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-3a13603e01660839bebbb150b478c7c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29914609_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/68e35b3def9c61e4459148b0453ce08c.webp"
"MediaSize" => 56380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-68e35b3def9c61e4459148b0453ce08c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29914609_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/330d6812c3830014f1256f8aba0b7898.webp"
"MediaSize" => 67175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-330d6812c3830014f1256f8aba0b7898.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29914609_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/89541516e4d380593d3e2fe61b6e6121.webp"
"MediaSize" => 84231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-89541516e4d380593d3e2fe61b6e6121.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29914609_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/519ada1eb8027218a1ab85d0ea3b6e59.webp"
"MediaSize" => 76381
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-519ada1eb8027218a1ab85d0ea3b6e59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29914609_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/07c0256e7b03c63caeb52a606f242ba8.webp"
"MediaSize" => 78150
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-07c0256e7b03c63caeb52a606f242ba8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29914609_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/1825d966b29cbac6bd9969d2defd8cda.webp"
"MediaSize" => 95461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-1825d966b29cbac6bd9969d2defd8cda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29914609_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/eb71792cdd0a8a7e7c0374ad4af7044e.webp"
"MediaSize" => 80559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-eb71792cdd0a8a7e7c0374ad4af7044e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29914609_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/f257372fb6edd6c8b02548c52c29116d.webp"
"MediaSize" => 74774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-f257372fb6edd6c8b02548c52c29116d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29914609_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/615bd5ef147b90ac7b7f49e0aca38727.webp"
"MediaSize" => 82884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-615bd5ef147b90ac7b7f49e0aca38727.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29914609_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/02b1b038e8ccd7a96426774949dbfdb5.webp"
"MediaSize" => 73169
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-02b1b038e8ccd7a96426774949dbfdb5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29914609_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/7ea20e5d1ee5186711331655a0cde5c6.webp"
"MediaSize" => 43555
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-7ea20e5d1ee5186711331655a0cde5c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29914609_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/554d4408519aa178860773569f073e4f.webp"
"MediaSize" => 75384
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-554d4408519aa178860773569f073e4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29914609_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/c4f489b49ef08c8a9287284877c62c9c.webp"
"MediaSize" => 69627
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-c4f489b49ef08c8a9287284877c62c9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29914609_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/5e99b744342ebb4c9dd393aae750ba98.webp"
"MediaSize" => 80313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-5e99b744342ebb4c9dd393aae750ba98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29914609_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/c3fd2addbe4123220449c60bbf7a5c83.webp"
"MediaSize" => 77794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-c3fd2addbe4123220449c60bbf7a5c83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29914609_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/d5b63a1ce53cb5dc0cdc9afa32327229.webp"
"MediaSize" => 80822
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-d5b63a1ce53cb5dc0cdc9afa32327229.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29914609_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/fa36af54450e92f0409a3680fbe347a5.webp"
"MediaSize" => 38625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-fa36af54450e92f0409a3680fbe347a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29914609_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/618c2deb69840c689a4070d6623c751b.webp"
"MediaSize" => 62438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-618c2deb69840c689a4070d6623c751b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29914609_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/86516f2b494b95296badbd725da84359.webp"
"MediaSize" => 59199
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-86516f2b494b95296badbd725da84359.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29914609_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/037ec18ed628348ca0b0480ea6f0094a.webp"
"MediaSize" => 40497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-037ec18ed628348ca0b0480ea6f0094a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29914609_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/84cad6f2b98a1460161bd7268ecad1fb.webp"
"MediaSize" => 70394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-84cad6f2b98a1460161bd7268ecad1fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29914609_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/9b8870192a9cef3d20b4e84fad5494cf.webp"
"MediaSize" => 97396
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-9b8870192a9cef3d20b4e84fad5494cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29914609_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/70bf7b489f6a037ef3946bc661747ace.webp"
"MediaSize" => 50690
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-70bf7b489f6a037ef3946bc661747ace.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29914609_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/28a7348228fc950eedba42aa74f736ce.webp"
"MediaSize" => 55812
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-28a7348228fc950eedba42aa74f736ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29914609_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/89f4c6997b59cefe9a623d1879c79873.webp"
"MediaSize" => 58823
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-89f4c6997b59cefe9a623d1879c79873.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29914609_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/f891153eec6288a11a5ec7b94f4793a5.webp"
"MediaSize" => 49784
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-f891153eec6288a11a5ec7b94f4793a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29914609_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/3ad10afae493245e8c7d6073290dd9c9.webp"
"MediaSize" => 99569
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-3ad10afae493245e8c7d6073290dd9c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29914609_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/d7abb5f732ae3325f3951b4a8aa8f2e4.webp"
"MediaSize" => 96188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-d7abb5f732ae3325f3951b4a8aa8f2e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29914609_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/4c986f061ec22e535a6260dbd14ec081.webp"
"MediaSize" => 117859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-4c986f061ec22e535a6260dbd14ec081.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29914609_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/6a6e930dbf6a7e8fa77a0a44ed41396f.webp"
"MediaSize" => 155154
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-6a6e930dbf6a7e8fa77a0a44ed41396f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29914609_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/cf7426898c0fa32e3e6a4ce3d6e76475.webp"
"MediaSize" => 143909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-cf7426898c0fa32e3e6a4ce3d6e76475.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29914609_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/18444569c69a044e4348aca67057cbdf.webp"
"MediaSize" => 118775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-18444569c69a044e4348aca67057cbdf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29914609_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/0cd2f6a5c1254a872526c5e3eb755a5f.webp"
"MediaSize" => 131862
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-0cd2f6a5c1254a872526c5e3eb755a5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29914609_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/0183e3037d0a29eed669a1a84c77e202.webp"
"MediaSize" => 121570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-0183e3037d0a29eed669a1a84c77e202.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29914609_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/de5f966dc8cfd501bfa9d0ef5b9d56ed.webp"
"MediaSize" => 102628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-de5f966dc8cfd501bfa9d0ef5b9d56ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914609')"
+"ID": "1539162"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 67816" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24783
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1525060" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24868
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29914609'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25187
+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 '29914609'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25271
+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 '29914609' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7653957 43.2049018)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25221
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25215
+post_id: "1540738"
+post_author: 1
+"ListingKey": "29918492"
+"ListingId": "X13458290"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T21:00:17Z"
+"RFModificationTimestamp": "2026-06-17T21:35:59Z"
+"ListPrice": 724999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G1N9"
+"UnparsedAddress": "17 ALBA STREET, Hamilton (Stoney Creek), Ontario L8G1N9"
+"Coordinates": array:2 [
0 => -79.765014
1 => 43.212423
]
+"Latitude": 43.212423
+"Longitude": -79.765014
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully updated solid brick bungalow offering 3 bedrooms, 2 full bathrooms, and a versatile layout ideal for families, downsizers, or multi-generational living. Located in one of Stoney Creek's most sought-after neighbourhoods, directly below the Niagara Escarpment, you'll enjoy easy access to the Bruce Trail, Devil's Punch Bowl, Battlefield Park, countless parks, and outdoor recreation. Commuters will love the proximity to the Red Hill Valley Parkway, Lincoln Alexander Parkway, QEW, and the future Stoney Creek GO Station. Featuring a separate side entrance and finished lower level, this home offers excellent in-law suite potential. Extensively renovated since 2020, the home blends timeless charm with modern updates. The stunning 2021 kitchen renovation included new cabinetry, flooring, lighting, baseboards, outlets, dishwasher, and stylish finishes throughout. The main floor was further refreshed with updated flooring, lighting, paint, and repairs to windows and doors. The main bathroom was tastefully updated with a new vanity, toilet, flooring, lighting, and fixtures, while the lower-level bathroom was completely rebuilt with a new shower, vanity, toilet, flooring, lighting, and exterior-vented exhaust fan. The finished basement adds exceptional living space with new drywall, windows, carpeting, baseboards, lighting, paint, updated electrical, and a modern electric fireplace. The former wood stove and chimney were removed to create a clean, contemporary feel. The laundry room was also fully upgraded with new flooring, windows, lighting, cabinetry, and finished drywall. Outside, enjoy expanded front and rear decks, a raised and enlarged shed, partial new fencing, a refinished driveway, stone walkways, raised garden beds, and eight fruit trees creating a private backyard retreat. Move-in ready and loaded with value, this extensively updated home offers the perfect blend of comfort, functionality, location, and future potential. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "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": "2026-06-17T21:35:53.577115+00:00"
+"Directions": "King St. to Battlefield Dr. south to Alba turn left"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2104490"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Wooded area"
]
+"LotSizeDimensions": "53.7 x 110 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T20:53:46Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T20:53:46Z"
+"Stories": "1.0"
+"StreetName": "Alba"
+"StreetNumber": "17"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4068"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1661484598"
"RoomType" => "Living room"
"ListingId" => "X13458290"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29918492"
"RoomLength" => 4.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.31Z"
]
1 => array:11 [
"RoomKey" => "1661484599"
"RoomType" => "Kitchen"
"ListingId" => "X13458290"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29918492"
"RoomLength" => 5.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.31Z"
]
2 => array:11 [
"RoomKey" => "1661484600"
"RoomType" => "Bedroom"
"ListingId" => "X13458290"
"RoomLevel" => "Main level"
"RoomWidth" => 3.05
"ListingKey" => "29918492"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.31Z"
]
3 => array:11 [
"RoomKey" => "1661484601"
"RoomType" => "Bedroom"
"ListingId" => "X13458290"
"RoomLevel" => "Main level"
"RoomWidth" => 3.66
"ListingKey" => "29918492"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.31Z"
]
4 => array:11 [
"RoomKey" => "1661484602"
"RoomType" => "Bedroom"
"ListingId" => "X13458290"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29918492"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.31Z"
]
5 => array:11 [
"RoomKey" => "1661484603"
"RoomType" => "Bathroom"
"ListingId" => "X13458290"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29918492"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.31Z"
]
6 => array:11 [
"RoomKey" => "1661484604"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13458290"
"RoomLevel" => "Basement"
"RoomWidth" => 7.01
"ListingKey" => "29918492"
"RoomLength" => 7.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.31Z"
]
7 => array:11 [
"RoomKey" => "1661484605"
"RoomType" => "Playroom"
"ListingId" => "X13458290"
"RoomLevel" => "Basement"
"RoomWidth" => 1.22
"ListingKey" => "29918492"
"RoomLength" => 4.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.31Z"
]
8 => array:11 [
"RoomKey" => "1661484606"
"RoomType" => "Laundry room"
"ListingId" => "X13458290"
"RoomLevel" => "Basement"
"RoomWidth" => 1.83
"ListingKey" => "29918492"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.31Z"
]
9 => array:11 [
"RoomKey" => "1661484607"
"RoomType" => "Bathroom"
"ListingId" => "X13458290"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29918492"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:53:46.31Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29918492/17-alba-street-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 53.8
+"OriginalEntryTimestamp": "2026-06-17T20:53:46.26Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1373980"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:48 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29918492_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918492/b13b2a6f339ce786abeea69384ac7e51.webp"
"MediaSize" => 125990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918492/thumbnail-b13b2a6f339ce786abeea69384ac7e51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13458290"
"ResourceRecordKey" => "29918492"
"ModificationTimestamp" => "2026-06-17T20:53:46.27Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29918492_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918492/ab3970f7c10b969c18609c75393f9e66.webp"
"MediaSize" => 143521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918492/thumbnail-ab3970f7c10b969c18609c75393f9e66.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458290"
"ResourceRecordKey" => "29918492"
"ModificationTimestamp" => "2026-06-17T20:53:46.27Z"
]
2 => array:13 [
"Order" => 3
…12
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918492')"
+"ID": "1540738"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25217
+post_id: "1530533"
+post_author: 1
+"ListingKey": "29904847"
+"ListingId": "40839758"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T15:40:13Z"
+"RFModificationTimestamp": "2026-06-17T16:03:53Z"
+"ListPrice": 603000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.08
+"LivingArea": 2236.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8K6C7"
+"UnparsedAddress": "68 TINDALE Court, Hamilton, Ontario L8K6C7"
+"Coordinates": array:2 [
0 => -79.78466
1 => 43.2138847
]
+"Latitude": 43.2138847
+"Longitude": -79.78466
+"YearBuilt": 1973
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This dynamic move-in ready 4-level backsplit presents as a possible 1 or 2 family home with multi-vehicle driveway, in the vibrant Vincent/Red Hill neighbourhood. Key feature is the separate side entrance, making it ideal for extended family, future in-law suite or revenue generating potential. Renovated areas and modern upgraded blend with its traditional solid structural integrity, ready to customize according to your needs. Perfect balance of open concept and private spaces. Boasts a large main floor living/dining room, bright eat-in kitchen. The upper level, 3 good sized bedrooms and main bath. The expansive lower 2 split levels maximizes space throughout, with a 3pc bath and versatile sizable spaces with potential for additional bedrooms, a kitchen, perhaps a gym, studio, or home office for the entrepreneur. Upgrades in (2025/2026) include fresh paint throughout, main bath glass shower, 3 pc bath and laminate flooring on the lower levels. Fully fenced backyard is ideal for children's playtime, large summer gatherings or quiet relaxation. Excellent connectivity to amenities, schools, parks, trails, SWL Rec Centre, public transit, quick Red-Hill and Hwy access. Excellent for commuters. Looking for a large 1 or 2 family home or investment opportunity, this is the one for you. Now is the time. Imagine the possibilities. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Central Vacuum"
2 => "Dishwasher"
3 => "Dryer"
4 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T18:10:55.012537+00:00"
+"Directions": "King St, E to Quigley Rd, Turn East ont to Tindale Crt."
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Brick"
2 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2055037"
+"ListOfficeKey": "55026"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0.08"
+"PhotosChangeTimestamp": "2026-06-15T17:32:27Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T15:32:17Z"
+"Stories": "1.0"
+"StreetName": "TINDALE"
+"StreetNumber": "68"
+"StreetSuffix": "Court"
+"SubdivisionName": "282 - Vincent"
+"TaxAnnualAmount": "4236.9"
+"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/29904847/68-tindale-court-hamilton"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "D/S-221"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1085
+"BelowGradeFinishedArea": 1151
+"OriginalEntryTimestamp": "2026-06-15T17:32:27.05Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1330313"
+"ListOfficeNationalAssociationId": "1003694"
+"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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29904847')"
+"ID": "1530533"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25214
+post_id: "1530085"
+post_author: 1
+"ListingKey": "29902817"
+"ListingId": "40839577"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T13:15:03Z"
+"RFModificationTimestamp": "2026-06-15T15:32:06Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1313.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G1R7"
+"UnparsedAddress": "22 MARION Place, Stoney Creek, Ontario L8G1R7"
+"Coordinates": array:2 [
0 => -79.7619961
1 => 43.2134775
]
+"Latitude": 43.2134775
+"Longitude": -79.7619961
+"YearBuilt": 1955
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this charming 1.5-storey detached home tucked away on a quiet dead-end street in a fantastic neighborhood! Featuring 3 bedrooms, including a main floor bedroom for added convenience, this home features a versatile layout perfect for families or downsizers. Bright and inviting main floor with a 3-piece bathroom. Enjoy your morning coffee or unwind in the sunroom overlooking the backyard. Detached single-car garage adds extra storage and functionality. Unfinished basement provides endless possibilities to make it your own. A great opportunity in a peaceful, family-friendly location! (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T15:32:02.201918+00:00"
+"Directions": "wardrope ave to trevor"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524566"
+"ListOfficeKey": "291472"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Cul-de-sac"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T13:11:46Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T13:11:46Z"
+"Stories": "1.5"
+"StreetName": "MARION"
+"StreetNumber": "22"
+"StreetSuffix": "Place"
+"SubdivisionName": "515 - Battlefield"
+"TaxAnnualAmount": "4340.33"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/362684"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29902817/22-marion-place-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1313
+"OriginalEntryTimestamp": "2026-06-15T13:10:02.29Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1102136"
+"ListOfficeNationalAssociationId": "1398404"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29902817')"
+"ID": "1530085"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25218
+post_id: "1530106"
+post_author: 1
+"ListingKey": "29902965"
+"ListingId": "X13443952"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T13:55:19Z"
+"RFModificationTimestamp": "2026-06-15T15:26:43Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G1R7"
+"UnparsedAddress": "22 MARION PLACE, Hamilton (Stoney Creek), Ontario L8G1R7"
+"Coordinates": array:2 [
0 => -79.762082
1 => 43.213464
]
+"Latitude": 43.213464
+"Longitude": -79.762082
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this charming 1.5-storey detached home tucked away on a quiet dead-end street in a fantastic neighborhood! Featuring 3 bedrooms, including a main floor bedroom for added convenience, this home features a versatile layout perfect for families or downsizers. Bright and inviting main floor with a 3-piece bathroom. Enjoy your morning coffee or unwind in the sunroom overlooking the backyard. Detached single-car garage adds extra storage and functionality. Unfinished basement provides endless possibilities to make it your own. A great opportunity in a peaceful, family-friendly location! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T15:26:29.420984+00:00"
+"Directions": "Cross Streets: TREVOR DR. ** Directions: wardrope ave to trevor."
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2146668"
+"ListOfficeKey": "291490"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "50 x 110.2 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T13:45:16Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T13:45:16Z"
+"Stories": "1.5"
+"StreetName": "Marion"
+"StreetNumber": "22"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "4340.33"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29902965/22-marion-place-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-06-15T13:45:16.52Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1397862"
+"ListOfficeNationalAssociationId": "1398828"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29902965')"
+"ID": "1530106"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25216
+post_id: "1530107"
+post_author: 1
+"ListingKey": "29902988"
+"ListingId": "40829987"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T14:00:08Z"
+"RFModificationTimestamp": "2026-06-15T15:25:32Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1172.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G1S2"
+"UnparsedAddress": "20 WARDROPE Avenue, Stoney Creek, Ontario L8G1S2"
+"Coordinates": array:2 [
0 => -79.7619651
1 => 43.2161206
]
+"Latitude": 43.2161206
+"Longitude": -79.7619651
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to your dream farmhouse in the city, perfectly situated just steps from downtown Stoney Creek & Historic Battlefield Park! This stunning property combines modern amenities with rustic charm, offering a unique lifestyle for discerning buyers. Imagine unwinding in your expansive outdoor detached sunroom, complete with power, or hosting summer barbecues in the covered area just off the newly updated kitchen. This culinary haven features elegant stone countertops, newer appliances—including a gas range—and stylish cabinetry, making meal prep a joy. The large island with breakfast bar and stools invites casual dining, while the marble backsplash adds a touch of sophistication. As you enter, you’re greeted by a charming foyer with new flooring that flows seamlessly into a spacious dining room, where two large windows bathe the space in natural light. The inviting family room boasts hardwood flooring and fresh paint, creating an ideal setting for relaxation and entertaining. Head upstairs to discover a large primary bedroom with ensuite privileges, ensuring privacy and comfort. The room features two windows and a generous closet, perfect for your wardrobe. Two additional bedrooms, each with closets, provide ample space for family or guests. The beautifully updated bathroom is a true retreat, showcasing a walk-in shower, a classic clawfoot tub, and a window that invites the outdoors in. With a large lot and detached garage, this property offers abundant outdoor space for gardening, play, or simply enjoying the serene surroundings. Don’t miss the chance to own this exceptional farmhouse where modern living meets classic elegance. Walk to restaurants and shopping, Make it yours today! Updates include: Furnace and AC - 24, Basement Waterproofing & Sump Pump- 21, Fridge/Dishwasher/Gas Stove/Gas Dryer/Deep Freezer- 21, Steel Roof - 14, Siding/Windows -16. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T15:25:29.502196+00:00"
+"Directions": "King St E to Wardrope Ave"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524250"
+"ListOfficeKey": "54923"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Gazebo"
2 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T13:52:08Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T13:52:08Z"
+"Stories": "2.0"
+"StreetName": "WARDROPE"
+"StreetNumber": "20"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "515 - Battlefield"
+"TaxAnnualAmount": "4268.56"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29902988/20-wardrope-avenue-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1533175"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "54923"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 70.0
+"AboveGradeFinishedArea": 1172
+"OriginalEntryTimestamp": "2026-06-15T13:52:08.15Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1127411"
+"ListOfficeNationalAssociationId": "1003529"
+"CoListAgentNationalAssociationId": "1143027"
+"CoListOfficeNationalAssociationId": "1003529"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29902988')"
+"ID": "1530107"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25211
+post_id: "1529191"
+post_author: 1
+"ListingKey": "29901832"
+"ListingId": "40839639"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T22:40:09Z"
+"RFModificationTimestamp": "2026-06-15T22:44:13Z"
+"ListPrice": 499700.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1507.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G1L5"
+"UnparsedAddress": "136 KING Street E, Stoney Creek, Ontario L8G1L5"
+"Coordinates": array:2 [
0 => -79.7488505
1 => 43.2173475
]
+"Latitude": 43.2173475
+"Longitude": -79.7488505
+"YearBuilt": 1949
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 136 King St E in Stoney Creek. A solid brick 1.5-storey home set on a generous, mature 50’x 150’lot with great curb appeal and plenty of long-term potential. This well-loved home offers a spacious living room with a large front window, gas fireplace in living room, and a bright, comfortable layout ready for your personal touch. The eat-in kitchen provides ample cabinetry, good counter space, tile flooring, and everyday functionality. Four bedrooms offer flexibility for family, guests, or a home office, while the finished lower level adds valuable bonus space with a rec room/games area, laundry, storage, and room to reimagine. Outside, the large yard is framed by mature trees and hedging, creating a private feel in a convenient central Stoney Creek location. Close to shops, restaurants, schools, parks, transit, and major routes, this is an excellent opportunity for buyers looking for a residential home with space, character, and value-add potential. With imagination and some tender loving care this home can be a real pride of ownership. Update over time, or renovate to suit your style, the bones, lot, and location are all here. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Central Vacuum"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-14T21:09:11.743386+00:00"
+"Directions": "King St. E. just west of Gray Rd."
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1615971"
+"ListOfficeKey": "55078"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Corner Site"
2 => "Country residential"
]
+"PhotosChangeTimestamp": "2026-06-14T17:51:04Z"
+"PhotosCount": 15
+"Sewer": array:2 [
0 => "Sanitary sewer"
1 => "Storm sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T22:31:44Z"
+"Stories": "1.5"
+"StreetDirSuffix": "East"
+"StreetName": "KING"
+"StreetNumber": "136"
+"StreetSuffix": "Street"
+"SubdivisionName": "515 - Battlefield"
+"TaxAnnualAmount": "4683"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
]
+"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/29901832/136-king-street-e-stoney-creek"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1150
+"BelowGradeFinishedArea": 357
+"OriginalEntryTimestamp": "2026-06-14T17:50:11.98Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1064141"
+"ListOfficeNationalAssociationId": "1003665"
+"Media": array:15 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29901832')"
+"ID": "1529191"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1524648"
+post_author: 1
+"ListingKey": "29894919"
+"ListingId": "X13436360"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T15:00:16Z"
+"RFModificationTimestamp": "2026-06-12T20:01:31Z"
+"ListPrice": 729000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Vincent)"
+"PostalCode": "L8K0A1"
+"UnparsedAddress": "32 ROLLING LANE, Hamilton (Vincent), Ontario L8K0A1"
+"Coordinates": array:2 [
0 => -79.784399
1 => 43.210057
]
+"Latitude": 43.210057
+"Longitude": -79.784399
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful semi-detached home in the desirable Gershome community. Offering 1,428 sq. ft. of well-designed living space, the main floor features 9-ft ceilings and an upgraded kitchen with extended cabinetry, quartz countertops, undermount sink, and tile backsplash. Exterior improvements include an asphalt driveway, covered concrete porch, two wooden decks, a retaining wall, and wood and metal fencing. The second level offers a spacious primary bedroom with a 4-piece ensuite and walk-in closet, plus two additional bedrooms and a full bath. Ideally located close to parks, schools, shopping, and highway access. Home is being sold as-is. (id:62783)"
+"AssociationFee": "149.85"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parcel of Tied Land"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T20:01:24.007344+00:00"
+"Directions": "Ambrose Ave and Greenhill Ave"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2158711"
+"ListOfficeKey": "68202"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "33.6 x 82.9 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T14:51:49Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T14:51:49Z"
+"Stories": "2.0"
+"StreetName": "Rolling"
+"StreetNumber": "32"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "5314.84"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=jaHubHJ2MBH"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Vincent"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29894919/32-rolling-lane-hamilton-vincent-vincent"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 33.7
+"OriginalEntryTimestamp": "2026-06-12T14:51:49.51Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1410044"
+"ListOfficeNationalAssociationId": "1132238"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29894919')"
+"ID": "1524648"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25219
+post_id: "1524562"
+post_author: 1
+"ListingKey": "29896093"
+"ListingId": "X13437678"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T17:30:20Z"
+"RFModificationTimestamp": "2026-06-12T19:26:10Z"
+"ListPrice": 769999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J0K9"
+"UnparsedAddress": "23 - 35 MIDHURST HEIGHTS, Hamilton (Stoney Creek Mountain), Ontario L8J0K9"
+"Coordinates": array:2 [
0 => -79.766094
1 => 43.205614
]
+"Latitude": 43.205614
+"Longitude": -79.766094
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained end-unit 3+1 bedroom, 4 bathroom townhome with a private rooftop terrace in the highly desirable Stoney Creek Mountain community.The main floor offers a bright open-concept living and dining area filled with natural light, ideal for everyday living and entertaining.Upstairs features three generously sized bedrooms and a versatile loft space currently styled as a cozy library, easily adaptable as a home office or lounge area. The primary bedroom includes a custom closet installed in 2021 and direct walk-out access to a private patio that leads to the rooftop terrace above.The finished basement adds valuable living space with a fourth bedroom and full bathroom, currently set up as a home gym and easily adaptable as a guest suite, playroom, or media room.Enjoy the private rooftop terrace - a perfect space for relaxing or entertaining.Additional updates include custom window coverings, a privacy fence, and a remote garage opener installed in 2021. Parking for two vehicles with a private garage and driveway.Ideally located minutes from the new Confederation GO Station with quick access to the QEW, Red Hill Valley Parkway, and Lincoln Alexander Parkway.Move-in ready and offering exceptional value in today's market. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
]
+"AssociationFee": "434.11"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:26:02.230031+00:00"
+"Directions": "Cross Streets: Upper Centennial/Green Mountain. ** Directions: Upper Centennial Green Mountain."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"Flooring": array:1 [
0 => "Hardwood"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1969961"
+"ListOfficeKey": "292212"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Carpet Free"
3 => "Guest Suite"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T17:01:37Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T17:01:37Z"
+"Stories": "2.0"
+"StreetName": "Midhurst"
+"StreetNumber": "35"
+"StreetSuffix": "Heights"
+"TaxAnnualAmount": "6103.23"
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Stoney Creek Mountain"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29896093/23-35-midhurst-heights-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "TAG Management"
+"GeocodeManualYN": false
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1999
+"LivingAreaMinimum": 1800
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-12T17:01:37.3Z"
+"ListAgentNationalAssociationId": "1257383"
+"ListOfficeNationalAssociationId": "1409372"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896093')"
+"ID": "1524562"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25220
+post_id: "1524563"
+post_author: 1
+"ListingKey": "29896337"
+"ListingId": "40839263"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T23:00:11Z"
+"RFModificationTimestamp": "2026-06-16T23:07:29Z"
+"ListPrice": 3998000.0
+"BathroomsTotalInteger": 7.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 7400.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8J2V9"
+"UnparsedAddress": "75 RIDGE Road, Stoney Creek, Ontario L8J2V9"
+"Coordinates": array:2 [
0 => -79.7634857
1 => 43.2104152
]
+"Latitude": 43.2104152
+"Longitude": -79.7634857
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Perched atop the Stoney Creek Escarpment and situated on a 16 pristine acres with over 1000ft of escarpment frontage, this stunning Georgian style modern estate offers over 7,000 square feet of above-grade living space with sweeping views of Hamilton, Stoney Creek, Lake Ontario and even the Toronto skyline on clear days. Upon entering through the private gates and driving along the scenic driveway, you'll pass formal gardens before arriving at the impressive Porte Cochère. Stepping through the front doors, you're greeted by dual staircases and soaring 28-foot ceilings, creating an immediate sense of grandeur. The open, flowing floor plan seamlessly connects all formal rooms to the foyer. For professional needs, the oak-paneled office is conveniently located just off the foyer. The modern kitchen is equipped with high-end Thermador and SubZero appliances, perfect for both everyday meals and entertaining. At the rear of the home, the family area features expansive windows that offer breathtaking city views year-round. The luxurious primary suite includes a spa-like ensuite designed to indulge the homeowner, and a large balcony provides an uninterrupted view of the city. In addition to the Primary Suite, the second floor offers three additional spacious bedrooms, each with its own ensuite bathroom. Above the garage, the bonus room offers an ideal space for a teen retreat or in-law suite. This self-contained area includes a 3-piece ensuite and a kitchenette. The lower level features a gym and sauna, providing the perfect space to meet your fitness and relaxation needs. There's also a vast unfinished area providing an open canvas for your personal preferences. A rare combination of privacy, scale and panoramic beauty, this property is the ultimate retreat for those seeking both serenity and sophistication. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Sauna"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Freezer"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:15:35.276488+00:00"
+"Directions": "Upper Centennial to Ridge Rd. East on Ridge Rd tothe last Driveway on the West side before the bend."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "4"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524899"
+"ListOfficeKey": "167847"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Ravine"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Paved driveway"
4 => "Country residential"
5 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T22:51:30Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T22:51:30Z"
+"Stories": "2.0"
+"StreetName": "RIDGE"
+"StreetNumber": "75"
+"StreetSuffix": "Road"
+"SubdivisionName": "052 - Stoney Creek Escarpment"
+"TaxAnnualAmount": "28116"
+"Utilities": array:1 [
0 => "Telephone"
]
+"View": "City view"
+"WaterSource": array:2 [
0 => "Cistern"
1 => "Drilled Well"
]
+"Rooms": array:25 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
22 => array:11 [ …11]
23 => array:11 [ …11]
24 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29896337/75-ridge-road-stoney-creek"
+"ParkingTotal": 30
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "A1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 966.0
+"AboveGradeFinishedArea": 7400
+"OriginalEntryTimestamp": "2026-06-12T17:32:09.19Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1064297"
+"ListOfficeNationalAssociationId": "1185561"
+"Media": array:47 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896337')"
+"ID": "1524563"
}
]
+success: true
+page_size: 9
+page_count: 14
+count: 122
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]