array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29884738 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1516027"
+post_author: 1
+"ListingKey": "29884738"
+"ListingId": "40838460"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T20:45:05Z"
+"RFModificationTimestamp": "2026-06-13T20:48:51Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.17
+"LivingArea": 2511.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G3V5"
+"UnparsedAddress": "28 RAMSGATE Drive, Stoney Creek, Ontario L8G3V5"
+"Coordinates": array:2 [
0 => -79.7450786
1 => 43.2182873
]
+"Latitude": 43.2182873
+"Longitude": -79.7450786
+"YearBuilt": 1966
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 28 Ramsgate, a beautifully maintained family home located in one of Stoney Creek's oldest and most sought-after neighbourhoods. Set on an impressive pie-shaped lot of nearly 6,000 sq. ft., this home offers a rare combination of privacy, space, comfort, and style. From the moment you arrive, the attractive curb appeal stands out with its landscaped front garden and double driveway that comfortably accommodates up to four vehicles. Originally converted from the garage, the home provides additional living space that enhances its family-friendly layout. Inside, you'll find bright and welcoming principal rooms, including a spacious living room, dining area, and kitchen designed for everyday living and entertaining. The thoughtfully renovated family room is a standout feature, offering direct access to the backyard along with year-round comfort thanks to its dedicated split unit for heat and AC and cozy gas fireplace. The upper level features four generously sized bedrooms with beautifully maintained flooring throughout. The finished basement extends the living space even further, (with its own fireplace) providing a stylish retreat perfect for relaxing, entertaining, a quiet office, or enjoying family time. Step outside to a private backyard oasis where summer memories are waiting to be made. Surrounded by mature trees and ample outdoor space, the impressive 22' x 39' in-ground pool, with an approximate depth of 12 feet, becomes the centrepiece of a backyard designed for entertaining, relaxation, and enjoying time with family, friends and staples of the neighbourhood that you'll get along with. Lovingly cared for and move-in ready, 28 Ramsgate is the perfect family home. Don't believe me, see for yourself! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Ductless"
]
+"CreationDate": "2026-06-10T20:25:49.377955+00:00"
+"Directions": "King St E to Stoney Brook Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235792"
+"ListOfficeKey": "55167"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Sump Pump"
]
+"LotSizeDimensions": "0.17"
+"PhotosChangeTimestamp": "2026-06-10T19:50:23Z"
+"PhotosCount": 48
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T20:39:49Z"
+"Stories": "2.0"
+"StreetName": "RAMSGATE"
+"StreetNumber": "28"
+"StreetSuffix": "Drive"
+"SubdivisionName": "516 - Cherry Heights"
+"TaxAnnualAmount": "5453.13"
+"VirtualTourURLUnbranded": "https://sites.nomorecowboys.media/mls/250663776"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1658731566"
"RoomType" => "Laundry room"
"ListingId" => "40838460"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29884738"
"RoomLength" => null
"RoomDimensions" => "20'7'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:39:49.47Z"
]
1 => array:11 [
"RoomKey" => "1658731567"
"RoomType" => "Recreation room"
"ListingId" => "40838460"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29884738"
"RoomLength" => null
"RoomDimensions" => "24'2'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:39:49.48Z"
]
2 => array:11 [
"RoomKey" => "1658731568"
"RoomType" => "4pc Bathroom"
"ListingId" => "40838460"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29884738"
"RoomLength" => null
"RoomDimensions" => "7'3'' x 7'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:39:49.49Z"
]
3 => array:11 [
"RoomKey" => "1658731569"
"RoomType" => "Bedroom"
"ListingId" => "40838460"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29884738"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:39:49.49Z"
]
4 => array:11 [
"RoomKey" => "1658731570"
"RoomType" => "Bedroom"
"ListingId" => "40838460"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29884738"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 8'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:39:49.5Z"
]
5 => array:11 [
"RoomKey" => "1658731571"
"RoomType" => "Bedroom"
"ListingId" => "40838460"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29884738"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:39:49.51Z"
]
6 => array:11 [
"RoomKey" => "1658731572"
"RoomType" => "Primary Bedroom"
"ListingId" => "40838460"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29884738"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:39:49.51Z"
]
7 => array:11 [
"RoomKey" => "1658731573"
"RoomType" => "2pc Bathroom"
"ListingId" => "40838460"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29884738"
"RoomLength" => null
"RoomDimensions" => "4'4'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:39:49.52Z"
]
8 => array:11 [
"RoomKey" => "1658731574"
"RoomType" => "Kitchen"
"ListingId" => "40838460"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29884738"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:39:49.52Z"
]
9 => array:11 [
"RoomKey" => "1658731575"
"RoomType" => "Family room"
"ListingId" => "40838460"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29884738"
"RoomLength" => null
"RoomDimensions" => "23'0'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:39:49.52Z"
]
10 => array:11 [
"RoomKey" => "1658731576"
"RoomType" => "Dining room"
"ListingId" => "40838460"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29884738"
"RoomLength" => null
"RoomDimensions" => "1'6'' x 12'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:39:49.53Z"
]
11 => array:11 [
"RoomKey" => "1658731577"
"RoomType" => "Living room"
"ListingId" => "40838460"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29884738"
"RoomLength" => null
"RoomDimensions" => "15'9'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:39:49.53Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29884738/28-ramsgate-drive-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1949680"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "287174"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1803
+"BelowGradeFinishedArea": 708
+"OriginalEntryTimestamp": "2026-06-10T19:50:22.95Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1473714"
+"ListOfficeNationalAssociationId": "1003582"
+"CoListAgentNationalAssociationId": "1243994"
+"CoListOfficeNationalAssociationId": "1373445"
+"Media": array:48 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29884738_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/d520ff08d55914cbff626eb6b9a6753b.webp"
"MediaSize" => 176278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-d520ff08d55914cbff626eb6b9a6753b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring a combination of brick and siding, an asphalt driveway, mature trees, a fenced yard, and a front entry with sidelights"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29884738_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/c3f68d41263b7c0a848a928dfb563ed9.webp"
"MediaSize" => 194792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-c3f68d41263b7c0a848a928dfb563ed9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick and siding exterior featuring a prominent bay window, stone walkway, mature tree with ivy, and established landscaping"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29884738_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/765fe47688530007e8d92d247004d75e.webp"
"MediaSize" => 122049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-765fe47688530007e8d92d247004d75e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick and stone facade featuring a recessed entry with a dark-framed glass paneled door and sidelights"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29884738_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/97675ef79411f81bf7b451bf93810bda.webp"
"MediaSize" => 94310
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-97675ef79411f81bf7b451bf93810bda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a white door with decorative glass inserts and sidelights"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29884738_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/5f95de0e82fa35ebedf717fa6775e92f.webp"
"MediaSize" => 72458
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-5f95de0e82fa35ebedf717fa6775e92f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29884738_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/10ae3b589a1c84ba4cbb8e1eb2058818.webp"
"MediaSize" => 115157
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-10ae3b589a1c84ba4cbb8e1eb2058818.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring wood-finish flooring, a broad area rug, and a red accent wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29884738_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/a2b44882da1ab7a3fc335c654c35a33e.webp"
"MediaSize" => 104658
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-a2b44882da1ab7a3fc335c654c35a33e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Wood-finish flooring throughout, complemented by crown molding and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29884738_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/d1c6cd8862badc9b1f1d2e99a5935f4c.webp"
"MediaSize" => 96070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-d1c6cd8862badc9b1f1d2e99a5935f4c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hardwood flooring throughout the main living areas"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29884738_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/4eff100bad7fa5b88eefd6ccb0b53a89.webp"
"MediaSize" => 61201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-4eff100bad7fa5b88eefd6ccb0b53a89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a white door with decorative glass panels, wood-finish flooring, and crown molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29884738_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/0ca47ec7f2fde93666dcd0a45b41d022.webp"
"MediaSize" => 101999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-0ca47ec7f2fde93666dcd0a45b41d022.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Warm wood-finish flooring extends through the living area and dining room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29884738_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/9fc4e4503d08b8f87e8c8957b2f93917.webp"
"MediaSize" => 87764
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-9fc4e4503d08b8f87e8c8957b2f93917.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open doorway leading to a staircase with wood treads and a wood handrail"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29884738_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/ed4c35a643344e52c8de111a3e93cd5e.webp"
"MediaSize" => 80941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-ed4c35a643344e52c8de111a3e93cd5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29884738_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/f913959a6641d15213381219d948e2ed.webp"
"MediaSize" => 42205
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-f913959a6641d15213381219d948e2ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29884738_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/8b3362d8edb5e5dc3fe05a5488ff53b3.webp"
"MediaSize" => 92856
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-8b3362d8edb5e5dc3fe05a5488ff53b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring wood-finish flooring, two-tone wall paint, and multiple drum pendant lights"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29884738_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/5e86cfa73d9009e3bd199cda13d783fa.webp"
"MediaSize" => 102976
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-5e86cfa73d9009e3bd199cda13d783fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area with natural light, featuring a large window with black trim, crown molding, and two-tone wall treatment"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29884738_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/2b5d06f5612a51652e411cad76e75c34.webp"
"MediaSize" => 85442
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-2b5d06f5612a51652e411cad76e75c34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring wood-finish cabinetry, a white subway tile backsplash, and a corner sink with a window above"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29884738_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/3a41c6dd00594021c7f9864dae83ee90.webp"
"MediaSize" => 87139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-3a41c6dd00594021c7f9864dae83ee90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29884738_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/d2493aac68121749cae213edac2e77db.webp"
"MediaSize" => 86654
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-d2493aac68121749cae213edac2e77db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring wood cabinetry, a subway tile backsplash, and a stainless steel over-the-range microwave"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29884738_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/68920a1d0083d3ebabca36c8bb567652.webp"
"MediaSize" => 69349
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-68920a1d0083d3ebabca36c8bb567652.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29884738_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/d4b6484317368fc923e33989fc81c13b.webp"
"MediaSize" => 99655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-d4b6484317368fc923e33989fc81c13b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring light gray walls and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29884738_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/257dee422c80cecbf4cb8e9e5f4b3a86.webp"
"MediaSize" => 90711
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-257dee422c80cecbf4cb8e9e5f4b3a86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted living area featuring recessed lighting, crown molding, and a large window with sheer and blackout drapes"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29884738_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/73be99d1e56dff13093b9fa96740cbc4.webp"
"MediaSize" => 105457
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-73be99d1e56dff13093b9fa96740cbc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring a stacked stone fireplace with a wood mantle, sliding glass doors to the exterior, recessed lighting, and crown molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29884738_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/29264b5112f3fb693973ea6abf17b940.webp"
"MediaSize" => 94396
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-29264b5112f3fb693973ea6abf17b940.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Powder room featuring patterned wallpaper, beadboard wainscoting, and a light wood vanity with a white basin"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29884738_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/16bc31be6c45af672732057cc750b3a9.webp"
"MediaSize" => 97438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-16bc31be6c45af672732057cc750b3a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring bold patterned wallpaper, wainscoting, a wall-mounted sink, and a dark-toned door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29884738_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/114c0696e7326d6907b7995db1e7b005.webp"
"MediaSize" => 74110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-114c0696e7326d6907b7995db1e7b005.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29884738_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/0ec867d3e8eafde18b95c50e1d4041c3.webp"
"MediaSize" => 75521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-0ec867d3e8eafde18b95c50e1d4041c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29884738_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/7eccb8fd72fe5925ffcaa7bd338e13b6.webp"
"MediaSize" => 100521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-7eccb8fd72fe5925ffcaa7bd338e13b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring a window with sheer and blackout curtains, a tufted headboard, two distinct ceiling light fixtures, and a wall-mounted shelf"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29884738_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/66d928a48ee8da6bbc245fd836357f24.webp"
"MediaSize" => 79530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-66d928a48ee8da6bbc245fd836357f24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Recessed window with exterior foliage, featuring white blinds and dark drapery"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29884738_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/d7743207fb17597ca8206fe9dc186d71.webp"
"MediaSize" => 91215
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-d7743207fb17597ca8206fe9dc186d71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light gray painted walls and light brown carpet flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29884738_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/cb9d9c33e31d03bff9ec64b87821e8a2.webp"
"MediaSize" => 84426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-cb9d9c33e31d03bff9ec64b87821e8a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright interior space featuring a window with exterior tree views, wood-finish flooring, a built-in bookshelf, and light-colored walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29884738_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/6d06ee2a62650f640e96602bb6029441.webp"
"MediaSize" => 78416
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-6d06ee2a62650f640e96602bb6029441.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light-toned walls with a large sliding window, two tall built-in shelving units, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29884738_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/9a691b9a86e6577141da1095a6315e70.webp"
"MediaSize" => 63408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-9a691b9a86e6577141da1095a6315e70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29884738_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/f861b6abc42e6e939c2bf4190f66ed0d.webp"
"MediaSize" => 82221
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-f861b6abc42e6e939c2bf4190f66ed0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29884738_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/791bc2f8b497b862d3d6e616f50ad063.webp"
"MediaSize" => 77760
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-791bc2f8b497b862d3d6e616f50ad063.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom vanity featuring a speckled countertop, a white drop-in sink, and a single-handle faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29884738_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/fe54b0fcecbd9d48ff3b5f3084588105.webp"
"MediaSize" => 99305
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-fe54b0fcecbd9d48ff3b5f3084588105.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring light gray walls, a window with exterior tree foliage, white built-in shelving, and a closet with bifold doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29884738_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/93318a3c284efa754469e012d5c15940.webp"
"MediaSize" => 95520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-93318a3c284efa754469e012d5c15940.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light green walls and a dark paneled interior door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29884738_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/70c5cc0dbeb6f12e893da0d9550b5f37.webp"
"MediaSize" => 92135
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-70c5cc0dbeb6f12e893da0d9550b5f37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lower-level living area featuring a free-standing fireplace, recessed lighting, wall paneling, built-in shelving with cabinetry, and light gray carpeting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29884738_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/531c8420df73fd77aaec47053cb35f3a.webp"
"MediaSize" => 86796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-531c8420df73fd77aaec47053cb35f3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Recessed lighting illuminates a versatile finished space featuring white paneled walls and a grid-paneled ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29884738_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/5a48741ab30ae33e6792fbe937b8fa5c.webp"
"MediaSize" => 100127
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-5a48741ab30ae33e6792fbe937b8fa5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29884738_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/a9e29cf815ac2be34ff2ac6d7ea23349.webp"
"MediaSize" => 140590
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-a9e29cf815ac2be34ff2ac6d7ea23349.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "In-ground swimming pool featuring a curved design and concrete surround"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29884738_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/10fe070626e122818b6501e18c05cc56.webp"
"MediaSize" => 157269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-10fe070626e122818b6501e18c05cc56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Backyard oasis featuring an in-ground swimming pool with stone coping, a concrete patio area, and mature perimeter trees providing privacy"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29884738_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/50d632fb1eaaa2c9b463a50357c41e76.webp"
"MediaSize" => 197629
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-50d632fb1eaaa2c9b463a50357c41e76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive outdoor living area featuring a wooden deck, stone patio, mature trees, privacy fencing, and lush foliage"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29884738_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/c7f6b3b29c5a2e61d4d48011b85ba6b5.webp"
"MediaSize" => 195977
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-c7f6b3b29c5a2e61d4d48011b85ba6b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29884738_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/f147685a5a9281994a28809cec70228d.webp"
"MediaSize" => 159065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-f147685a5a9281994a28809cec70228d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Backyard featuring a kidney-shaped in-ground pool with concrete coping, surrounded by a manicured lawn"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29884738_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/d15c414985650b0d40de74613dd71d60.webp"
"MediaSize" => 116173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-d15c414985650b0d40de74613dd71d60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive outdoor living area featuring a mature tree with dense foliage, a wooden deck, stone patio, and privacy fencing covered with climbing greenery"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29884738_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/4586eb9e34abb301b999e4b08cb1d3fe.webp"
"MediaSize" => 192685
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-4586eb9e34abb301b999e4b08cb1d3fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29884738_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/37108002bd64566d74f396af14eb1b65.webp"
"MediaSize" => 142370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-37108002bd64566d74f396af14eb1b65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Backyard featuring an in-ground swimming pool with stone coping and a diving board"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29884738_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884738/0a2726cd9113082e12ff118ee7c67045.webp"
"MediaSize" => 161141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884738/thumbnail-0a2726cd9113082e12ff118ee7c67045.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838460"
"ResourceRecordKey" => "29884738"
"ModificationTimestamp" => "2026-06-10T19:50:22.96Z"
]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29884738')"
+"ID": "1516027"
}
]
+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 55167" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24821
+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 2235792" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24794
+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 '29884738'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25143
+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 '29884738'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25161
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25159
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31416157"
+"ListingKey": "29884738"
+"ListingId": "40838460"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-13"
+"OpenHouseStartTime": "2026-06-13T14:00:00Z"
+"OpenHouseEndTime": "2026-06-13T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-13T16:39:11Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31416157')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29884738' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7450786 43.2182873)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25278
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25272
+post_id: "1532343"
+post_author: 1
+"ListingKey": "29905622"
+"ListingId": "40839384"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T19:00:16Z"
+"RFModificationTimestamp": "2026-06-15T21:50:10Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1544.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8E2C6"
+"UnparsedAddress": "420 RED OAK Avenue, Hamilton, Ontario L8E2C6"
+"Coordinates": array:2 [
0 => -79.7207866
1 => 43.2214046
]
+"Latitude": 43.2214046
+"Longitude": -79.7207866
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "*Pre-construction opportunity* Closing summer/fall of 2027. A beautiful open concept, modern style, townhouse family home located in Stoney Creek. Quality finishes throughout the home, three beds and three baths make for comfortable living. Take advantage of the temporary HST exemption on new homes and maximize your savings. Price shown is exclusive of HST and assumes HST rebate eligibility. Contact listing agent at 905-929-6758 for more details on the project. (id:62783)"
+"Appliances": array:1 [
0 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T21:50:00.881734+00:00"
+"Directions": "North on Highway 8, East on Red Oak Avenue"
+"ExteriorFeatures": array:4 [
0 => "Concrete"
1 => "Stone"
2 => "Vinyl siding"
3 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524103"
+"ListOfficeKey": "282362"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T18:50:26Z"
+"PhotosCount": 5
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T18:50:26Z"
+"Stories": "2.0"
+"StreetName": "RED OAK"
+"StreetNumber": "420"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "511 - Eastdale/Poplar Park/Industrial"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1660027887"
"RoomType" => "Primary Bedroom"
"ListingId" => "40839384"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29905622"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 17'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:50:26.18Z"
]
1 => array:11 [
"RoomKey" => "1660027888"
"RoomType" => "3pc Bathroom"
"ListingId" => "40839384"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29905622"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:50:26.19Z"
]
2 => array:11 [
"RoomKey" => "1660027889"
"RoomType" => "Laundry room"
"ListingId" => "40839384"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29905622"
"RoomLength" => null
"RoomDimensions" => "6' x 6'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:50:26.19Z"
]
3 => array:11 [
"RoomKey" => "1660027890"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839384"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29905622"
"RoomLength" => null
"RoomDimensions" => "5'9'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:50:26.19Z"
]
4 => array:11 [
"RoomKey" => "1660027891"
"RoomType" => "Bedroom"
"ListingId" => "40839384"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29905622"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:50:26.19Z"
]
5 => array:11 [
"RoomKey" => "1660027892"
"RoomType" => "Bedroom"
"ListingId" => "40839384"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29905622"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:50:26.19Z"
]
6 => array:11 [
"RoomKey" => "1660027893"
"RoomType" => "Family room"
"ListingId" => "40839384"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905622"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 15'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:50:26.19Z"
]
7 => array:11 [
"RoomKey" => "1660027894"
"RoomType" => "Kitchen"
"ListingId" => "40839384"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905622"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:50:26.2Z"
]
8 => array:11 [
"RoomKey" => "1660027895"
"RoomType" => "Dining room"
"ListingId" => "40839384"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905622"
"RoomLength" => null
"RoomDimensions" => "4'6'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:50:26.2Z"
]
9 => array:11 [
"RoomKey" => "1660027896"
"RoomType" => "2pc Bathroom"
"ListingId" => "40839384"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905622"
"RoomLength" => null
"RoomDimensions" => "4'9'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:50:26.2Z"
]
10 => array:11 [
"RoomKey" => "1660027897"
"RoomType" => "Foyer"
"ListingId" => "40839384"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905622"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 4'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:50:26.2Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29905622/420-red-oak-avenue-hamilton"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2211225"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "282362"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 23.0
+"AboveGradeFinishedArea": 1544
+"OriginalEntryTimestamp": "2026-06-15T18:50:26.13Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1064289"
+"ListOfficeNationalAssociationId": "1320359"
+"CoListAgentNationalAssociationId": "1457105"
+"CoListOfficeNationalAssociationId": "1320359"
+"Media": array:5 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29905622_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905622/0c7ff403afa4a763e09d2c08d3609538.webp"
"MediaSize" => 142823
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905622/thumbnail-0c7ff403afa4a763e09d2c08d3609538.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839384"
"ResourceRecordKey" => "29905622"
"ModificationTimestamp" => "2026-06-15T18:50:26.14Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29905622_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905622/a8925fe2655a3fc03195c990c223a5a9.webp"
"MediaSize" => 56526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905622/thumbnail-a8925fe2655a3fc03195c990c223a5a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839384"
"ResourceRecordKey" => "29905622"
"ModificationTimestamp" => "2026-06-15T18:50:26.14Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29905622_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905622/5ec15108a1c456ca4415f5ac59c89ed1.webp"
"MediaSize" => 63262
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905622/thumbnail-5ec15108a1c456ca4415f5ac59c89ed1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839384"
"ResourceRecordKey" => "29905622"
"ModificationTimestamp" => "2026-06-15T18:50:26.14Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29905622_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905622/aafd17341d1e1b2c34ae0bd10786aff9.webp"
"MediaSize" => 61694
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905622/thumbnail-aafd17341d1e1b2c34ae0bd10786aff9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839384"
"ResourceRecordKey" => "29905622"
"ModificationTimestamp" => "2026-06-15T18:50:26.14Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29905622_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905622/5017e1221aff25e6db14cd922b6d2cad.webp"
"MediaSize" => 121622
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905622/thumbnail-5017e1221aff25e6db14cd922b6d2cad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839384"
"ResourceRecordKey" => "29905622"
"ModificationTimestamp" => "2026-06-15T18:50:26.14Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905622')"
+"ID": "1532343"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25274
+post_id: "1530269"
+post_author: 1
+"ListingKey": "29903950"
+"ListingId": "2128555"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T16:10:07Z"
+"RFModificationTimestamp": "2026-06-15T16:48:55Z"
+"ListPrice": 349000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8G1B4"
+"UnparsedAddress": "851 Queenston Road Unit# 601, Hamilton, Ontario L8G1B4"
+"Coordinates": array:2 [
0 => -79.760902
1 => 43.227837
]
+"Latitude": 43.227837
+"Longitude": -79.760902
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Sudbury Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully upgraded 2 bedroom plus den condo offering the perfect belnd of comofrt, style and convenience. This condo features upgraded kitchen cabinets, newer appliances, and modern lighting. Every detail has been attended to - from the fully redone baseboards to the elegant double door entry. The open concept layout is ideal for both everyday living and entertaining, while the balcony positioned away from Queenston Road - offers a peaceful retreat with no traffic noise. This unit is unique as it has in-suite laundry. You will enjoy the secuirty of a controlled building entrance and two coveted underground parking spaces and a storage locker. Whether you're an investor or sometone to call Unit 601 home, this well maintained unit checks all the boxes. (id:62650)"
+"AssociationFee": "763.63"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-15T16:48:49.612288+00:00"
+"Flooring": array:2 [
0 => "Tile"
1 => "Laminate"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1523314"
+"ListOfficeKey": "79955"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-15T16:04:31Z"
+"PhotosCount": 17
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T16:04:31Z"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1659916942"
"RoomType" => "Bathroom"
"ListingId" => "2128555"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29903950"
"RoomLength" => null
"RoomDimensions" => "4PIECE"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T16:04:31.96Z"
]
1 => array:11 [
"RoomKey" => "1659916943"
"RoomType" => "Den"
"ListingId" => "2128555"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29903950"
"RoomLength" => null
"RoomDimensions" => "13'4 x 7'10"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T16:04:31.96Z"
]
2 => array:11 [
"RoomKey" => "1659916944"
"RoomType" => "Bedroom"
"ListingId" => "2128555"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29903950"
"RoomLength" => null
"RoomDimensions" => "10'8 x 9'6"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T16:04:31.96Z"
]
3 => array:11 [
"RoomKey" => "1659916945"
"RoomType" => "Bedroom"
"ListingId" => "2128555"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29903950"
"RoomLength" => null
"RoomDimensions" => "11'8 x 10'10"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T16:04:31.96Z"
]
4 => array:11 [
"RoomKey" => "1659916946"
"RoomType" => "Living room"
"ListingId" => "2128555"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29903950"
"RoomLength" => null
"RoomDimensions" => "18'6 x 11'10"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T16:04:31.96Z"
]
5 => array:11 [
"RoomKey" => "1659916947"
"RoomType" => "Kitchen"
"ListingId" => "2128555"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29903950"
"RoomLength" => null
"RoomDimensions" => "5'10 x 7'4"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
…1
]
]
+"ListAOR": "Sudbury"
+"ListAORKey": "35"
+"ListingURL": "www.realtor.ca/real-estate/29903950/851-queenston-road-unit-601-hamilton"
+"StructureType": array:1 [
0 => "Other"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": false
+"ZoningDescription": "C, RM5"
+"OriginalEntryTimestamp": "2026-06-15T16:04:31.94Z"
+"ListAgentNationalAssociationId": "1038262"
+"ListOfficeNationalAssociationId": "1001285"
+"Media": array:17 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29903950')"
+"ID": "1530269"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25271
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29902817')"
+"ID": "1530085"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25275
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29902965')"
+"ID": "1530106"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25273
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29902988')"
+"ID": "1530107"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25268
+post_id: "1529190"
+post_author: 1
+"ListingKey": "29901626"
+"ListingId": "X13442704"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T15:25:10Z"
+"RFModificationTimestamp": "2026-06-14T21:12:40Z"
+"ListPrice": 3998000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J2Y5"
+"UnparsedAddress": "420 RIDGE ROAD, Hamilton (Stoney Creek Mountain), Ontario L8J2Y5"
+"Coordinates": array:2 [
0 => -79.734014
1 => 43.209478
]
+"Latitude": 43.209478
+"Longitude": -79.734014
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "420 Ridge Road where the fortunes of the past meet the opportunity of the future on this idyllic 77+1- acre farm. Set atop the edge of the escarpment which offers panoramic views of the region this property offers a rare opportunity to own a large piece of property on one of Ontario's estately streets. It is conveniently located 5 minutes from downtown Stoney Creek, close in proximity to both city amenities and all major transportation routes. Step back in time as you explore the original red brick homestead full of character and awaiting a new owner. Complete with slate roof, five bedrooms and large verandas, this gem exudes warmth and charm. The thick beam hip roof barn is sturdy in construction with ample space and provides endless opportunities for a hobby farmer or agri-tourism venture. A steel insulated and heated outbuilding awaits, offering the perfect workshop with concrete floors, wood paneled horse stalls, hot and cold water, electric door entrance. Whether you're a crafts person, an artist, or horse enthusiast, this space is sure to inspire creativity and productivity. Outside large fenced in paddocks and well maintained pastures for grazing are ready to welcome your animals. Whether you're starting a small hobby farm or expanding your agricultural endeavors, this property has everything you need to make your vision a reality. Don't miss your opportunity to own a piece of this paradise at 420 Ridge Road, Stoney Creek Ontario (id:62783)"
+"Appliances": array:1 [
0 => "Refrigerator"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-14T21:12:37.243525+00:00"
+"Directions": "Upper Centennial Parkway"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Oil"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2055870"
+"ListOfficeKey": "284780"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Level lot"
1 => "Wooded area"
2 => "Irregular lot size"
3 => "Conservation/green belt"
]
+"LotSizeDimensions": "286 x 2901 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-14T15:17:35Z"
+"PhotosCount": 35
+"PossibleUse": "Pasture"
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-14T15:17:35Z"
+"Stories": "2.0"
+"StreetName": "Ridge"
+"StreetNumber": "420"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "2768"
+"Utilities": array:1 [
0 => "Electricity"
]
+"View": "City view,Lake view"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek Mountain"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29901626/420-ridge-road-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 20
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "NEC/ Agr"
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 286.0
+"OriginalEntryTimestamp": "2026-06-14T15:17:35.79Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1331169"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29901626')"
+"ID": "1529190"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29901832')"
+"ID": "1529191"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25276
+post_id: "1526103"
+post_author: 1
+"ListingKey": "29896775"
+"ListingId": "X13438498"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T18:35:12Z"
+"RFModificationTimestamp": "2026-06-13T00:30:26Z"
+"ListPrice": 379000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G0B1"
+"UnparsedAddress": "304 - 319 HIGHWAY 8, Hamilton (Stoney Creek), Ontario L8G0B1"
+"Coordinates": array:2 [
0 => -79.730005
1 => 43.220408
]
+"Latitude": 43.220408
+"Longitude": -79.730005
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "One bedroom plus den condo in a sought-after building in the heart of Stoney Creek. Thoughtfully designed and exceptionally well maintained, this welcoming unit offers a spacious layout and comfortable living throughout. Upon entering, you're greeted by a foyer with a convenient front hall closet before stepping into the open-concept kitchen featuring granite countertops, stainless steel appliances, tile backsplash and breakfast bar seating. The living room is generous in size and filled with natural light from the large window, with access to a private balcony overlooking the grounds below. The primary bedroom offers excellent space and a full walk-in closet. The four-piece bathroom features granite countertops and an accessible shower. A great bonus is the den, perfect for a home office, reading room or additional flexible space. This well-maintained building offers underground parking, a fitness room and banquet hall. Conveniently located close to schools, churches, restaurants, grocery stores and everyday amenities, making day-to-day living incredibly convenient. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "667"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T00:30:16.563675+00:00"
+"Directions": "Cross Streets: King St E & Hwy 8. ** Directions: King St E to Hwy 8."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2032323"
+"ListOfficeKey": "283968"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-12T18:26:58Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T18:26:58Z"
+"StreetName": "Highway 8"
+"StreetNumber": "319"
+"TaxAnnualAmount": "3657"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Niagara"
+"TaxYear": 2026
+"CityRegion": "Stoney Creek"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29896775/304-319-highway-8-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Butler Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"ZoningDescription": "RM4-6"
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-12T18:26:58.54Z"
+"ListAgentNationalAssociationId": "1309530"
+"ListOfficeNationalAssociationId": "1337412"
+"Media": array:26 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896775')"
+"ID": "1526103"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25277
+post_id: "1525220"
+post_author: 1
+"ListingKey": "29896511"
+"ListingId": "40838979"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T20:45:14Z"
+"RFModificationTimestamp": "2026-06-12T20:50:57Z"
+"ListPrice": 899990.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2232.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8E4J7"
+"UnparsedAddress": "34 CAPRI Crescent, Hamilton, Ontario L8E4J7"
+"Coordinates": array:2 [
0 => -79.7486481
1 => 43.2271183
]
+"Latitude": 43.2271183
+"Longitude": -79.7486481
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this spacious detached home located in a highly desirable family-friendly neighbourhood. The main level features a bright living room, formal dining room, eat-in kitchen, family room, den/home office, full bathroom, and a convenient laundry room with direct access to the garage. The second floor offers three generously sized bedrooms and a full bathroom. The fully finished basement provides excellent in-law suite potential with a separate entrance, eat-in kitchen, large recreation room, den, and a 4-piece bathroom. Recent updates include a new furnace (2021), pot lights, sump pump, and renovated basement. Conveniently located close to schools, parks, shopping, and all amenities. Move-in ready and ideal for growing families or multi-generational living. Fully finished basement with separate entrance and in-law suite potential. New furnace installed in 2021. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T20:50:41.003662+00:00"
+"Directions": "Donn Avenue to Highridge"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2208378"
+"ListOfficeKey": "284587"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T20:33:23Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T20:33:23Z"
+"Stories": "2.0"
+"StreetName": "CAPRI"
+"StreetNumber": "34"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "273 - Riverdale"
+"TaxAnnualAmount": "7086"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/cvtnb/364296"
+"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/29896511/34-capri-crescent-hamilton"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 37.0
+"AboveGradeFinishedArea": 2232
+"OriginalEntryTimestamp": "2026-06-12T17:51:22.13Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1454865"
+"ListOfficeNationalAssociationId": "1343174"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896511')"
+"ID": "1525220"
}
]
+success: true
+page_size: 9
+page_count: 21
+count: 184
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]