array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29945456 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411
+post_id: "1560663"
+post_author: 1
+"ListingKey": "29945456"
+"ListingId": "40842425"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T17:40:55Z"
+"RFModificationTimestamp": "2026-06-26T02:00:31Z"
+"ListPrice": 2890000.0
+"BathroomsTotalInteger": 7.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0.81
+"LivingArea": 8733.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8J2Y3"
+"UnparsedAddress": "803 RIDGE Road, Hamilton, Ontario L8J2Y3"
+"Coordinates": array:2 [
0 => -79.6991263
1 => 43.203477
]
+"Latitude": 43.203477
+"Longitude": -79.6991263
+"YearBuilt": 2007
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 803 Ridge Road, an extraordinary custom-built estate set on a private 0.81 acre escarpment lot with breathtaking views of Lake Ontario, the city, and the Toronto skyline. A gated entrance opens to a long, light-lined driveway, setting the tone for nearly 9,000 sq ft of finished luxury living. The grand foyer with soaring ceilings introduces elegant principal rooms, rich hardwood, custom details, and exceptional scale throughout. The open-concept kitchen and family room are anchored by a dramatic double-sided fireplace. The chef’s kitchen offers extensive cabinetry, built-in desk area, premium appliances including a Capital 6-burner gas stove, Viking indoor barbecue, Miele deep fryer, Fisher Paykel dishwasher, Electrolux refrigerator, large Viking hood fan, and garden doors to the full-width rear patio. The family room showcases panoramic lake and skyline views, a second walkout, pot lights, and a built-in wet bar. The formal dining room, complete with fireplace, comfortably seats 18 and connects to a ventilated solarium, ideal as a cigar lounge or private retreat. A butler’s pantry, mud room, office area, and updated powder room complete the main level. Upstairs, the primary retreat is entered through double doors and features a fireplace, private balcony, hidden wet bar with reverse osmosis, walk-in closet, and spa-inspired 7-pc ensuite. Three additional bedrooms each enjoy private ensuites, with two offering balconies overlooking the yard, lake, and skyline. The fully finished lower level offers a theatre room with 8 seats, projector, 130 inch screen and AV room, gym with mirrored walls, wine cellar, cedar closet, rec room/man cave with custom finishes, additional bedrooms, bathrooms, double laundry, and walk-up access. A 3-bay garage with car lifts, built-in speakers on each level, dumbwaiter, multiple HVAC systems, drilled well, cisterns, irrigation, and extensive updates complete this rare luxury offering minutes to major highways. Luxury Certified. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Freezer"
7 => "Wet Bar"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-24T06:23:28.508732+00:00"
+"Directions": "Ridge Road between Fifth Road E and McNeilly Road"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Stucco"
2 => "Other"
]
+"FireplaceFeatures": array:2 [
0 => "Propane"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "6"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1663135"
+"ListOfficeKey": "284641"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Southern exposure"
1 => "Wet bar"
2 => "Paved driveway"
3 => "Country residential"
4 => "Sump Pump"
5 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.81"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T04:39:27Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T17:11:14Z"
+"Stories": "2.0"
+"StreetName": "RIDGE"
+"StreetNumber": "803"
+"StreetSuffix": "Road"
+"SubdivisionName": "052 - Stoney Creek Escarpment"
+"TaxAnnualAmount": "16792.92"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youriguide.com/803_ridge_rd_hamilton_on/"
+"WaterSource": array:2 [
0 => "Cistern"
1 => "Drilled Well"
]
+"Rooms": array:29 [
0 => array:11 [
"RoomKey" => "1666998234"
"RoomType" => "3pc Bathroom"
"ListingId" => "40842425"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 7'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.02Z"
]
1 => array:11 [
"RoomKey" => "1666998235"
"RoomType" => "3pc Bathroom"
"ListingId" => "40842425"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.03Z"
]
2 => array:11 [
"RoomKey" => "1666998236"
"RoomType" => "Wine Cellar"
"ListingId" => "40842425"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "14'11'' x 14'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.03Z"
]
3 => array:11 [
"RoomKey" => "1666998238"
"RoomType" => "Utility room"
"ListingId" => "40842425"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 8'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.03Z"
]
4 => array:11 [
"RoomKey" => "1666998240"
"RoomType" => "Utility room"
"ListingId" => "40842425"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 8'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.03Z"
]
5 => array:11 [
"RoomKey" => "1666998241"
"RoomType" => "Media"
"ListingId" => "40842425"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "18'10'' x 18'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.03Z"
]
6 => array:11 [
"RoomKey" => "1666998243"
"RoomType" => "Storage"
"ListingId" => "40842425"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 20'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.03Z"
]
7 => array:11 [
"RoomKey" => "1666998245"
"RoomType" => "Storage"
"ListingId" => "40842425"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 20'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.03Z"
]
8 => array:11 [
"RoomKey" => "1666998246"
"RoomType" => "Recreation room"
"ListingId" => "40842425"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "14'8'' x 30'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.03Z"
]
9 => array:11 [
"RoomKey" => "1666998248"
"RoomType" => "Bedroom"
"ListingId" => "40842425"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 16'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.03Z"
]
10 => array:11 [
"RoomKey" => "1666998250"
"RoomType" => "Bedroom"
"ListingId" => "40842425"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 16'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.03Z"
]
11 => array:11 [
"RoomKey" => "1666998251"
"RoomType" => "Gym"
"ListingId" => "40842425"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "22'1'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.03Z"
]
12 => array:11 [
"RoomKey" => "1666998253"
"RoomType" => "Full bathroom"
"ListingId" => "40842425"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "19'8'' x 13'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.03Z"
]
13 => array:11 [
"RoomKey" => "1666998255"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842425"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 9'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.03Z"
]
14 => array:11 [
"RoomKey" => "1666998257"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842425"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "7'7'' x 6'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.04Z"
]
15 => array:11 [
"RoomKey" => "1666998258"
"RoomType" => "3pc Bathroom"
"ListingId" => "40842425"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.04Z"
]
16 => array:11 [
"RoomKey" => "1666998260"
"RoomType" => "Bedroom"
"ListingId" => "40842425"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.04Z"
]
17 => array:11 [
"RoomKey" => "1666998262"
"RoomType" => "Bedroom"
"ListingId" => "40842425"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.04Z"
]
18 => array:11 [
"RoomKey" => "1666998263"
"RoomType" => "Bedroom"
"ListingId" => "40842425"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.04Z"
]
19 => array:11 [
"RoomKey" => "1666998264"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842425"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "15'8'' x 22'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.04Z"
]
20 => array:11 [
"RoomKey" => "1666998265"
"RoomType" => "Other"
"ListingId" => "40842425"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.04Z"
]
21 => array:11 [
"RoomKey" => "1666998266"
"RoomType" => "Mud room"
"ListingId" => "40842425"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 7'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.04Z"
]
22 => array:11 [
"RoomKey" => "1666998267"
"RoomType" => "Sunroom"
"ListingId" => "40842425"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "14'8'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.04Z"
]
23 => array:11 [
"RoomKey" => "1666998268"
"RoomType" => "2pc Bathroom"
"ListingId" => "40842425"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "6'9'' x 6'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.04Z"
]
24 => array:11 [
"RoomKey" => "1666998269"
"RoomType" => "Great room"
"ListingId" => "40842425"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "18'11'' x 17'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.04Z"
]
25 => array:11 [
"RoomKey" => "1666998270"
"RoomType" => "Dinette"
"ListingId" => "40842425"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "121'5'' x 22'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.04Z"
]
26 => array:11 [
"RoomKey" => "1666998271"
"RoomType" => "Kitchen"
"ListingId" => "40842425"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 18'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.04Z"
]
27 => array:11 [
"RoomKey" => "1666998272"
"RoomType" => "Dining room"
"ListingId" => "40842425"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "15'7'' x 32'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.04Z"
]
28 => array:11 [
"RoomKey" => "1666998273"
"RoomType" => "Foyer"
"ListingId" => "40842425"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945456"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 18'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T17:11:14.04Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29945456/803-ridge-road-hamilton"
+"ParkingTotal": 23
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1524865"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "262664"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "A1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 110.0
+"AboveGradeFinishedArea": 4975
+"BelowGradeFinishedArea": 3758
+"OriginalEntryTimestamp": "2026-06-24T04:39:26.92Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1168385"
+"ListOfficeNationalAssociationId": "1344650"
+"CoListAgentNationalAssociationId": "1063707"
+"CoListOfficeNationalAssociationId": "1223042"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29945456_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/4c6dc7eff38c859117210a14a5a97961.webp"
"MediaSize" => 110453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-4c6dc7eff38c859117210a14a5a97961.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29945456_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/40d44e47643f0dfd511246a32323595f.webp"
"MediaSize" => 188172
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-40d44e47643f0dfd511246a32323595f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29945456_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/1a80fcb3c0fff7bf00c10a09c1c312c3.webp"
"MediaSize" => 146790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-1a80fcb3c0fff7bf00c10a09c1c312c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29945456_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/9b2e8eacd084a2c71c9cf789c4e526cf.webp"
"MediaSize" => 138719
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-9b2e8eacd084a2c71c9cf789c4e526cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29945456_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/c785d699a0d9428621da3eaf789f73a3.webp"
"MediaSize" => 97052
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-c785d699a0d9428621da3eaf789f73a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29945456_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/0c9c49deecef33a99d4d741c1e3a9aff.webp"
"MediaSize" => 85618
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-0c9c49deecef33a99d4d741c1e3a9aff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29945456_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/1f9fefc8449520676bc929c8c38aa324.webp"
"MediaSize" => 69713
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-1f9fefc8449520676bc929c8c38aa324.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29945456_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/8a4f57892a9a0986684f311b82b3aec3.webp"
"MediaSize" => 72096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-8a4f57892a9a0986684f311b82b3aec3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29945456_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/4732243f664a4430b1d9df504cc27076.webp"
"MediaSize" => 78198
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-4732243f664a4430b1d9df504cc27076.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29945456_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/a7bddc039aa19cf3159feb3e28ebfaa4.webp"
"MediaSize" => 82686
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-a7bddc039aa19cf3159feb3e28ebfaa4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29945456_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/3a7378b645e865202dda5f7a2a44af32.webp"
"MediaSize" => 81123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-3a7378b645e865202dda5f7a2a44af32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29945456_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/2d005558c99e51ba07bbc5db1f0cc918.webp"
"MediaSize" => 103203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-2d005558c99e51ba07bbc5db1f0cc918.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29945456_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/3b9cb34525e9541545cc05eb56307c18.webp"
"MediaSize" => 102592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-3b9cb34525e9541545cc05eb56307c18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29945456_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/a894395d500ddb4b1264fa6b70151a5a.webp"
"MediaSize" => 103704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-a894395d500ddb4b1264fa6b70151a5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29945456_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/b4a65e8b85f1c86c4e2f7974777dca4d.webp"
"MediaSize" => 105112
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-b4a65e8b85f1c86c4e2f7974777dca4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29945456_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/7eff179c159b4d475f71ff5d65422203.webp"
"MediaSize" => 80146
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-7eff179c159b4d475f71ff5d65422203.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29945456_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/2fa200a01893fd45a45eb1a6920aaa40.webp"
"MediaSize" => 85629
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-2fa200a01893fd45a45eb1a6920aaa40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29945456_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/c15e51db665ef0f7920cbe8815cb5041.webp"
"MediaSize" => 83150
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-c15e51db665ef0f7920cbe8815cb5041.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29945456_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/89c7804b2c16d73e47372cb70d36201f.webp"
"MediaSize" => 80708
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-89c7804b2c16d73e47372cb70d36201f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29945456_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/c4c99a6456269bba1e31bd84d2643ba4.webp"
"MediaSize" => 79897
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-c4c99a6456269bba1e31bd84d2643ba4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29945456_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/435a90fb56de8632f7c3477e359fa4f2.webp"
"MediaSize" => 81307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-435a90fb56de8632f7c3477e359fa4f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29945456_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/0726317f8522e66edc91bd68bd576cbc.webp"
"MediaSize" => 71065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-0726317f8522e66edc91bd68bd576cbc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29945456_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/3f6053cad3a843c350a8eb6a56baf50a.webp"
"MediaSize" => 97448
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-3f6053cad3a843c350a8eb6a56baf50a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29945456_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/1cc29a789dc3e2b0ef15d7416ac35e82.webp"
"MediaSize" => 66726
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-1cc29a789dc3e2b0ef15d7416ac35e82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29945456_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/8542860a9400677c04a2802aa5dbdb5d.webp"
"MediaSize" => 66993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-8542860a9400677c04a2802aa5dbdb5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29945456_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/2bfaee02a1c046fa63724d0a602db37f.webp"
"MediaSize" => 74535
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-2bfaee02a1c046fa63724d0a602db37f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29945456_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/dea404af32b132a520bb8781b1ddfbc7.webp"
"MediaSize" => 70660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-dea404af32b132a520bb8781b1ddfbc7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29945456_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/cb3c914bd0e25afb2ecd13e6ea07ed36.webp"
"MediaSize" => 102927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-cb3c914bd0e25afb2ecd13e6ea07ed36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29945456_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/0d7a7fa0818904facc6baf888e5bcf45.webp"
"MediaSize" => 101170
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-0d7a7fa0818904facc6baf888e5bcf45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29945456_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/232b0aaefe88d585c44bf90348407bed.webp"
"MediaSize" => 94271
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-232b0aaefe88d585c44bf90348407bed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29945456_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/a4f67b9b6d80773040b982cfb17bb9bb.webp"
"MediaSize" => 89551
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-a4f67b9b6d80773040b982cfb17bb9bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29945456_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/7af0d3627bbc6be0b5c53ca3e1345926.webp"
"MediaSize" => 81986
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-7af0d3627bbc6be0b5c53ca3e1345926.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29945456_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/3bae4a2947d1b98229679108637076c4.webp"
"MediaSize" => 81830
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-3bae4a2947d1b98229679108637076c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29945456_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/7cfa97c4b260847d7f60f86885efe3f0.webp"
"MediaSize" => 69920
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-7cfa97c4b260847d7f60f86885efe3f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29945456_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/87cc9e551c2b6695de46fcc735d84246.webp"
"MediaSize" => 63710
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-87cc9e551c2b6695de46fcc735d84246.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29945456_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/8d15520cf1f1b5b9eb178e431bfdffcd.webp"
"MediaSize" => 80328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-8d15520cf1f1b5b9eb178e431bfdffcd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29945456_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/8d0d9ed5a2dc81c3404b505fa4b8f229.webp"
"MediaSize" => 88707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-8d0d9ed5a2dc81c3404b505fa4b8f229.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29945456_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/a9ca2c0c21baa0da75546d51cec3969a.webp"
"MediaSize" => 79824
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-a9ca2c0c21baa0da75546d51cec3969a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29945456_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/8460acc2990198835779c62e100729fa.webp"
"MediaSize" => 75623
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-8460acc2990198835779c62e100729fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29945456_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/38bdae6a35c4951ce38e281bb34d844f.webp"
"MediaSize" => 76473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-38bdae6a35c4951ce38e281bb34d844f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29945456_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/6ce93ebce577a7943da0db81ef5bce3c.webp"
"MediaSize" => 97721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-6ce93ebce577a7943da0db81ef5bce3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29945456_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/96dc1dd495b02a5c7e99047385f4a786.webp"
"MediaSize" => 105481
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-96dc1dd495b02a5c7e99047385f4a786.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29945456_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/692bbc7be50cbf78b52c8dd795aecd5e.webp"
"MediaSize" => 107633
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-692bbc7be50cbf78b52c8dd795aecd5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29945456_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/d9c0d98da390180a49a397a8a7c24530.webp"
"MediaSize" => 108675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945456/thumbnail-d9c0d98da390180a49a397a8a7c24530.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842425"
"ResourceRecordKey" => "29945456"
"ModificationTimestamp" => "2026-06-24T04:39:26.93Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29945456_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945456/675e5a49373bb66745b5a84e225604f1.webp"
…10
]
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('29945456')"
+"ID": "1560663"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 284641" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24851
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1663135" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24850
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29945456'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25258
+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 '29945456'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25274
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29945456' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.6991263 43.203477)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25347
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25341
+post_id: "1562901"
+post_author: 1
+"ListingKey": "29953636"
+"ListingId": "X13489180"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T19:05:24Z"
+"RFModificationTimestamp": "2026-06-25T20:31:19Z"
+"ListPrice": 2890000.0
+"BathroomsTotalInteger": 7.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8J2Y3"
+"UnparsedAddress": "803 RIDGE ROAD, Hamilton, Ontario L8J2Y3"
+"Coordinates": array:2 [
0 => -79.6990864
1 => 43.2034185
]
+"Latitude": 43.2034185
+"Longitude": -79.6990864
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 803 Ridge Road, an extraordinary custom-built estate set on a private 0.81 acre escarpment lot with breathtaking views of Lake Ontario, the city, and the Toronto skyline. A gated entrance opens to a long, light-lined driveway, setting the tone for nearly 9,000 sq ft of finished luxury living. The grand foyer with soaring ceilings introduces elegant principal rooms, rich hardwood, custom details, and exceptional scale throughout. The open-concept kitchen and family room are anchored by a dramatic double-sided fireplace. The chef's kitchen offers extensive cabinetry, built-in desk area, premium appliances including a Capital 6-burner gas stove, Viking indoor barbecue, Miele deep fryer, Fisher Paykel dishwasher, Electrolux refrigerator, large Viking hood fan, and garden doors to the full-width rear patio. The family room showcases panoramic lake and skyline views, a second walkout, pot lights, and a built-in wet bar. The formal dining room, complete with fireplace, comfortably seats 18 and connects to a ventilated solarium, ideal as a cigar lounge or private retreat. A butler's pantry, mud room, office area, and updated powder room complete the main level. Upstairs, the primary retreat is entered through double doors and features a fireplace, private balcony, hidden wet bar with reverse osmosis, walk-in closet, and spa-inspired 7-pc ensuite. Three additional bedrooms each enjoy private ensuites, with two offering balconies overlooking the yard, lake, and skyline. The fully finished lower level offers a theatre room with 8 seats, projector, 130 inch screen and AV room, gym with mirrored walls, wine cellar, cedar closet, rec room/man cave with custom finishes, additional bedrooms, bathrooms, double laundry, and walk-up access. A 3-bay garage with car lifts, built-in speakers on each level, dumbwaiter, multiple HVAC systems, drilled well, cisterns, irrigation, and extensive updates complete this rare luxury offering minutes to major highways. (id:62650)"
+"Appliances": array:15 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Dryer"
7 => "Freezer"
8 => "Oven - Built-In"
9 => "Water Treatment"
10 => "Hood Fan"
11 => "Window Coverings"
12 => "Garage door opener"
13 => "Garage door opener remote(s)"
14 => "Water Heater"
]
+"Basement": array:7 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "Walk-up"
4 => "N/A"
5 => "N/A"
6 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T20:28:57.800409+00:00"
+"Directions": "Cross Streets: Fifth Road East. ** Directions: Ridge Road between Fifth Road E and McNeilly Road."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "6"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2137896"
+"ListOfficeKey": "284787"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "110 x 326.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T18:36:44Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T18:58:47Z"
+"Stories": "2.0"
+"StreetName": "Ridge"
+"StreetNumber": "803"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "16792.92"
+"View": "City view,Lake view,View"
+"VirtualTourURLUnbranded": "https://youriguide.com/803_ridge_rd_hamilton_on/"
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Rural Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29953636/803-ridge-road-hamilton-rural-stoney-creek"
+"ParkingTotal": 23
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"ZoningDescription": "A1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 110.0
+"OriginalEntryTimestamp": "2026-06-25T18:36:44.55Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1389956"
+"ListOfficeNationalAssociationId": "1344854"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29953636')"
+"ID": "1562901"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25343
+post_id: "1542221"
+post_author: 1
+"ListingKey": "29920171"
+"ListingId": "X13459522"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T03:25:10Z"
+"RFModificationTimestamp": "2026-06-18T04:13:32Z"
+"ListPrice": 939000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G4V7"
+"UnparsedAddress": "56 BEN TIRRAN CRESCENT, Hamilton (Stoney Creek), Ontario L8G4V7"
+"Coordinates": array:2 [
0 => -79.715597
1 => 43.208883
]
+"Latitude": 43.208883
+"Longitude": -79.715597
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Offered For the first time in over 30 years, this meticulously maintained family home is nestled on one of Stoney Creek's most sought-after Crescents. Situated on an impressive 50 x 153 ft private lot, this property presents a rare opportunity to own in a highly desirable neighborhood. A spacious and thoughtfully designed floor plan features generous principal rooms awaiting your personal vision and updates. The welcoming foyer is filled with natural light from an overhead skylight, while the formal living and dining rooms provide the perfect setting for entertaining. The Family room showcases a gas fireplace and custom built-in cabinetry.The open-concept kitchen has been updated with stainless steel appliances and offers seamless functionality for everyday living. Upstairs, you'll find three generously sized bedrooms, including a primary retreat complete with a walk-in closet and 3-piece ensuite. A separate side entrance to the basement offers excellent potential for an in-law suite, multi-generational living, or future rental income. Outside, the beautifully landscaped backyard is a true oasis, featuring magazine-worthy tiered gardens that provide exceptional privacy. Ideally located in a premier neighborhood, close to highly rated schools, the Bruce Trail, shopping, dining, and all essential amenities, with convenient access to major highways for commuters. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Full"
1 => "Separate entrance"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T04:13:28.345770+00:00"
+"Directions": "Cross Streets: Dewitt & Maple Rd. ** Directions: Dewitt to Maple Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2052970"
+"ListOfficeKey": "93711"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "50 x 153.1 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T03:17:30Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T03:17:30Z"
+"Stories": "2.0"
+"StreetName": "Ben Tirran"
+"StreetNumber": "56"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6372.95"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29920171/56-ben-tirran-crescent-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-06-18T03:17:30.03Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1328282"
+"ListOfficeNationalAssociationId": "1158326"
+"Media": array:37 [
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]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29920171')"
+"ID": "1542221"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25340
+post_id: "1535050"
+post_author: 1
+"ListingKey": "29910104"
+"ListingId": "40840312"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:40:10Z"
+"RFModificationTimestamp": "2026-06-16T17:26:40Z"
+"ListPrice": 949000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2929.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G4L4"
+"UnparsedAddress": "13 SALINA Place, Stoney Creek, Ontario L8G4L4"
+"Coordinates": array:2 [
0 => -79.7145766
1 => 43.2148382
]
+"Latitude": 43.2148382
+"Longitude": -79.7145766
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully renovated home offering 2,299 square feet of thoughtfully designed living space, featuring 3 spacious bedrooms and 2 fully updated bathrooms with ample room for the whole family. This home has been meticulously renovated from top to bottom using high-quality materials and craftsmanship throughout. Every detail has been thoughtfully updated, including stunning new flooring, designer bathrooms, a modern kitchen, stainless steel appliances, complete electrical updates, fresh paint inside and out, a new laundry area, and a fully finished basement that's ready for movie nights, entertaining, or family hangouts. The main floor showcases beautiful arched wall openings that add character and architectural charm, while the inviting family room features a cozy wood-burning fireplace, creating the perfect gathering space for family and friends. Perfectly situated on a quiet street close to all amenities, excellent schools, parks, shopping, and everyday conveniences. Surrounded by amazing neighbors and a welcoming community, this is the ideal place to put down roots. Step outside and enjoy professionally refreshed landscaping in both the front and backyard, creating beautiful outdoor spaces to relax, play, and entertain. This is truly a turnkey property where all the hard work has been done for you. Simply move in, unpack, and start enjoying everything this exceptional home has to offer. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:26:30.308227+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2057231"
+"ListOfficeKey": "167847"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T16:33:17Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T16:33:16Z"
+"Stories": "2.0"
+"StreetName": "SALINA"
+"StreetNumber": "13"
+"StreetSuffix": "Place"
+"SubdivisionName": "517 - Highway Valley/Dewitt"
+"TaxAnnualAmount": "4846.55"
+"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/29910104/13-salina-place-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2299
+"BelowGradeFinishedArea": 630
+"OriginalEntryTimestamp": "2026-06-16T16:33:16.77Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1332479"
+"ListOfficeNationalAssociationId": "1185561"
+"DaysOnMarket": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29910104')"
+"ID": "1535050"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25344
+post_id: "1514345"
+post_author: 1
+"ListingKey": "29881370"
+"ListingId": "40838395"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T18:40:11Z"
+"RFModificationTimestamp": "2026-06-26T01:15:53Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1812.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8E4G6"
+"UnparsedAddress": "102 JUNIPER Drive, Hamilton, Ontario L8E4G6"
+"Coordinates": array:2 [
0 => -79.7128871
1 => 43.2165888
]
+"Latitude": 43.2165888
+"Longitude": -79.7128871
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "YOUR NEW HOME! Welcome to 102 Juniper Drive, a beautifully maintained detached backsplit on a massive premium corner lot in a desirable Stoney Creek neighbourhood. This spacious 4 bedroom, 2 bathroom home offers a smart and functional layout with multiple finished living areas, making it ideal for families, multi-generational living, or buyers looking for extra space and flexibility. Step inside to a bright and inviting main level featuring a comfortable living area, functional kitchen, and plenty of natural light throughout. The home has been thoughtfully updated, including a newly renovated second level that now offers an updated full bathroom along with a spacious rec room, perfect for family movie nights, entertaining guests, a kids’ play area, or a cozy lounge setup. The finished basement adds even more usable living space with new flooring and a clean, modern feel. Whether you need a home office, gym, guest area, recreation space, or additional storage, this lower level gives you plenty of options. Located in a family-friendly Stoney Creek neighbourhood close to schools, parks, shopping, amenities, transit, and highway access, 102 Juniper Drive is a fantastic opportunity for buyers looking for space, updates, and long-term value. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T14:53:48.699454+00:00"
+"Directions": "Dewitt Road To Juniper Drive"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2226340"
+"ListOfficeKey": "291669"
+"LivingAreaUnits": "square feet"
+"NumberOfUnitsTotal": "1"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T18:24:04Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T18:33:33Z"
+"StreetName": "JUNIPER"
+"StreetNumber": "102"
+"StreetSuffix": "Drive"
+"SubdivisionName": "512 - Guernsey/Westmeria/Industrial"
+"TaxAnnualAmount": "4628"
+"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/29881370/102-juniper-drive-hamilton"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 48.0
+"AboveGradeFinishedArea": 1812
+"OriginalEntryTimestamp": "2026-06-10T14:20:42.22Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1469738"
+"ListOfficeNationalAssociationId": "1401824"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 15
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29881370')"
+"ID": "1514345"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25342
+post_id: "1513189"
+post_author: 1
+"ListingKey": "29879810"
+"ListingId": "X13423258"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T23:56:26Z"
+"RFModificationTimestamp": "2026-06-10T00:50:16Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E4G6"
+"UnparsedAddress": "102 JUNIPER DRIVE, Hamilton (Stoney Creek), Ontario L8E4G6"
+"Coordinates": array:2 [
0 => -79.712668
1 => 43.217084
]
+"Latitude": 43.217084
+"Longitude": -79.712668
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "YOUR NEW HOME! Welcome to 102 Juniper Drive, a beautifully maintained detached backsplit on a massive premium corner lot in a desirable Stoney Creek neighbourhood. This spacious 4 bedroom, 2 bathroom home offers a smart and functional layout with multiple finished living areas, making it ideal for families, multi-generational living, or buyers looking for extra space and flexibility. Step inside to a bright and inviting main level featuring a comfortable living area, functional kitchen, and plenty of natural light throughout. The home has been thoughtfully updated, including a newly renovated second level that now offers an updated full bathroom along with a spacious rec room, perfect for family movie nights, entertaining guests, a kids' play area, or a cozy lounge setup. The finished basement adds even more usable living space with new flooring and a clean, modern feel. Whether you need a home office, gym, guest area, recreation space, or additional storage, this lower level gives you plenty of options. Located in a family-friendly Stoney Creek neighbourhood close to schools, parks, shopping, amenities, transit, and highway access, 102 Juniper Drive is a fantastic opportunity for buyers looking for space, updates, and long-term value. (id:62650)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T00:50:13.046822+00:00"
+"Directions": "Dewitt Road"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1993784"
+"ListOfficeKey": "294997"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "47.8 x 100.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T23:45:47Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T23:45:47Z"
+"StreetName": "Juniper"
+"StreetNumber": "102"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4628"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29879810/102-juniper-drive-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 47.9
+"OriginalEntryTimestamp": "2026-06-09T23:45:47.69Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1276930"
+"ListOfficeNationalAssociationId": "1451359"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29879810')"
+"ID": "1513189"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25337
+post_id: "1510279"
+post_author: 1
+"ListingKey": "29875804"
+"ListingId": "X13419948"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T16:35:06Z"
+"RFModificationTimestamp": "2026-06-26T02:27:54Z"
+"ListPrice": 2849000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G5C6"
+"UnparsedAddress": "76 ADRIATIC BOULEVARD, Hamilton (Stoney Creek), Ontario L8G5C6"
+"Coordinates": array:2 [
0 => -79.711032
1 => 43.207771
]
+"Latitude": 43.207771
+"Longitude": -79.711032
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "TURN-KEY (ALL FURNITURE AND APPLIANCES NEGOTIABLE) This stunning home is truly a magnificent work of art. Over 7,000 sq. ft. of finished luxurious living space done to the finest detail with finishes you would only expect in a home of this caliber. The moment you walk into this immaculate home you will be drawn into the gorgeous foyer leading you through the front den and living area. The gourmet kitchen is a chef's dream with an oversized island, private breakfast area and built-in high-end appliances. Completing this floor is a laundry room, office, outstanding sunroom, 2 piece bathroom and a private room with hot tub which leads you to your private rear yard oasis with inground heated pool (9 ft. depth), cabana with attached bathroom, storage shed, treehouse and putting green. Basement boasts a marvelous 2nd kitchen, exercise room, sauna, 2 piece bathroom, unbelievable Theater room with bar and meeting room. The upper floor boasts a huge primary bedroom with gas fire place, walk-in closet, superb ensuite bathroom with walkout balcony. The 2nd bedroom boasts a 4 piece ensuite while the 3rd & 4th bedroom share an ensuite privilege. Extremely easy to view and ready for your inspection. This magnificent home has a flexible closing and is open for Offers. All upper scale furniture and appliances are negotiable. Descriptive packages including floor plans as well as video and drone tour available (id:62650)"
+"Appliances": array:5 [
0 => "Water softener"
1 => "Central Vacuum"
2 => "Dishwasher"
3 => "Freezer"
4 => "Water Heater"
]
+"Basement": array:1 [
0 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T16:57:54.307101+00:00"
+"Directions": "Cross Streets: Macdui Dr. ** Directions: HWY #8 to Regalview Dr. left on Goldcrest then turns toAdriaticBlvd."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1501456"
+"ListOfficeKey": "277525"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sauna"
]
+"LotSizeDimensions": "55.8 x 233.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T15:29:12Z"
+"PhotosCount": 40
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T16:29:55Z"
+"Stories": "2.0"
+"StreetName": "Adriatic"
+"StreetNumber": "76"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "17469.99"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=SrX6n-guWrE"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:27 [
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]
25 => array:11 [ …11]
26 => array:11 [ …11]
]
+"ListAOR": "Niagara"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29875804/76-adriatic-boulevard-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2174643"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "277525"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 100000
+"LivingAreaMinimum": 5000
+"ZoningDescription": "R2-4"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 55.9
+"OriginalEntryTimestamp": "2026-06-09T15:29:12.62Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1066802"
+"ListOfficeNationalAssociationId": "1285348"
+"CoListAgentNationalAssociationId": "1425011"
+"CoListOfficeNationalAssociationId": "1285348"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29875804')"
+"ID": "1510279"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1507084"
+post_author: 1
+"ListingKey": "29870777"
+"ListingId": "X13415076"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T21:25:35Z"
+"RFModificationTimestamp": "2026-06-08T21:29:11Z"
+"ListPrice": 998000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G4H2"
+"UnparsedAddress": "51 PRESIDENT DRIVE, Hamilton (Stoney Creek), Ontario L8G4H2"
+"Coordinates": array:2 [
0 => -79.712273
1 => 43.211449
]
+"Latitude": 43.211449
+"Longitude": -79.712273
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Come and experience this exceptional 4-storey backsplit in one of Stoney Creek's most prestigious and sought-after neighbourhoods! Perfect for large or multi-generational families, this spacious home offers 4+2 bedrooms, 3 bathrooms, stunning finishes, and an incredible layout designed for both everyday living and entertaining. The bright open concept living and dining area flows seamlessly into a large kitchen featuring stainless steel appliances, ample cabinetry, and plenty of workspace for the home chef. Retreat to the spa-like ensuite with an exceptional reclaimed brick accent wall. Enjoy a separate family room for cozy nights in, plus a huge bonus room in the basement offering endless possibilities for a games room, home gym, office, or additional living space. 2 car garage with a driveway that holds an additional 6 cars! Situated on an enormous, ultra-private lot backing onto the beautiful escarpment, this property offers the perfect blend of luxury, privacy, and nature. A rare opportunity to own a truly special family home in an unbeatable Stoney Creek location! Seller willing to reinstall sliding door. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-08T18:53:50.672026+00:00"
+"Directions": "Cross Streets: Dewitt and Midway. ** Directions: Dewitt to Midway to President."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2151990"
+"ListOfficeKey": "284780"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "55 x 280.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-08T17:31:28Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T21:16:22Z"
+"StreetName": "President"
+"StreetNumber": "51"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7422"
+"VirtualTourURLUnbranded": "https://www.youtube.com/shorts/ukKnYDKBEZ4?feature=share"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29870777/51-president-drive-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 6
+"FrontageLengthNumeric": 55.0
+"OriginalEntryTimestamp": "2026-06-08T17:31:28.17Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1403689"
+"ListOfficeNationalAssociationId": "1344707"
+"Media": array:35 [
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]
]
+"DaysOnMarket": 17
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29870777')"
+"ID": "1507084"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25345
+post_id: "1506192"
+post_author: 1
+"ListingKey": "29869771"
+"ListingId": "40837212"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T16:30:34Z"
+"RFModificationTimestamp": "2026-06-09T16:44:37Z"
+"ListPrice": 998000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 2370.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G4H2"
+"UnparsedAddress": "51 PRESIDENT Drive, Stoney Creek, Ontario L8G4H2"
+"Coordinates": array:2 [
0 => -79.7123929
1 => 43.2112327
]
+"Latitude": 43.2112327
+"Longitude": -79.7123929
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Come and experience this exceptional 4-storey backsplit in one of Stoney Creek’s most prestigious and sought-after neighbourhoods! Perfect for large or multi-generational families, this spacious home offers 4+2 bedrooms, 3 bathrooms, stunning finishes, and an incredible layout designed for both everyday living and entertaining. The bright open concept living and dining area flows seamlessly into a large kitchen featuring stainless steel appliances, ample cabinetry, and plenty of workspace for the home chef. Retreat to the spa-like ensuite with an exceptional reclaimed brick accent wall. Enjoy a separate family room for cozy nights in, plus a huge bonus room in the basement offering endless possibilities for a games room, home gym, office, or additional living space. 2 car garage with a driveway that holds an additional 6 cars! Situated on an enormous, ultra-private lot backing onto the beautiful escarpment, this property offers the perfect blend of luxury, privacy, and nature. A rare opportunity to own a truly special family home in an unbeatable Stoney Creek location! Seller willing to reinstall sliding door. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-08T16:54:32.262721+00:00"
+"Directions": "Dewitt to Midway to President"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2049810"
+"ListOfficeKey": "284640"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-08T15:39:58Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T16:20:29Z"
+"Stories": "2.0"
+"StreetName": "PRESIDENT"
+"StreetNumber": "51"
+"StreetSuffix": "Drive"
+"SubdivisionName": "517 - Highway Valley/Dewitt"
+"TaxAnnualAmount": "7422"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/ukKnYDKBEZ4?feature=share"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29869771/51-president-drive-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 55.0
+"AboveGradeFinishedArea": 2370
+"OriginalEntryTimestamp": "2026-06-08T15:39:58.03Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1325188"
+"ListOfficeNationalAssociationId": "1344651"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"DaysOnMarket": 17
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29869771')"
+"ID": "1506192"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25346
+post_id: "1449078"
+post_author: 1
+"ListingKey": "29790511"
+"ListingId": "X13160960"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T19:25:08Z"
+"RFModificationTimestamp": "2026-06-15T19:41:52Z"
+"ListPrice": 1285000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G4R6"
+"UnparsedAddress": "10 SKYE COURT, Hamilton (Stoney Creek), Ontario L8G4R6"
+"Coordinates": array:2 [
0 => -79.715515
1 => 43.210575
]
+"Latitude": 43.210575
+"Longitude": -79.715515
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Custom Built, Prime Court Location on the Pleatue, Grand Foyer, Over 4800 S.F Living area (3071+1774) 4+2 Bedrooms, 2 Kitchens, 5 Bathrooms, Finished Basement set up as In-Law Suite with Separate Entrance, 8 car parking, View of Lake from Patio and Balcony off Master Bedroom, Circular Staircase, Carpet Free, Brick Exterior, Detached Smoking Room in the Backyard, 2 Electric Fireplaces, All Sizes Approx. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dryer"
4 => "Freezer"
5 => "Two stoves"
6 => "Garage door opener"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Separate entrance"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-22T16:48:20.482483+00:00"
+"Directions": "Cross Streets: DEWITT AND HWY 8. ** Directions: GO SOUTH ON DEWITT RD, WEST ON MAPLE, THEN TAKE SKYE CRT ON THE PLEATUE."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2259210"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Cul-de-sac"
1 => "Irregular lot size"
2 => "Paved yard"
3 => "Hilly"
4 => "Carpet Free"
5 => "In-Law Suite"
]
+"LotSizeDimensions": "58.8 x 144.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-22T15:58:33Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T19:20:08Z"
+"Stories": "2.0"
+"StreetName": "Skye"
+"StreetNumber": "10"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "7979.56"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/cvtnb/363862"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29790511/10-skye-court-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 58.9
+"OriginalEntryTimestamp": "2026-05-22T15:58:33.65Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1499122"
+"ListOfficeNationalAssociationId": "1274323"
+"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": 34
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29790511')"
+"ID": "1449078"
}
]
+success: true
+page_size: 9
+page_count: 5
+count: 41
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]