Spacious 6-bedroom, 4 full-bathroom home available for lease in a mixed-use property. The main floor offers 3 well-appointed bedrooms, including a primary bedroom with ensuite, a full main bathroom, and convenient main floor laundry. The bright kitchen opens to the dining and living areas, creating a functional layout for families or shared living. The second level features 3 additional bedrooms,
These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract.
I acknowledge I can only access these forms as a ComFree customer under contract.
These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract and in partnership with Zubic Law.
I acknowledge I can only access these forms as a ComFree customer under contract.
These forms are provided to ComFree’s Unrepresented Sellers as part of their Mere Posting ComFree Listing Contract and in partnership with Imperium LLP – Rocky Kim.
I acknowledge I can only access these forms as a ComFree customer under contract.
1. Purchase Your Package
2. We Ship Your ‘For Sale’ Sign
3. Book Your VR Tour
4. Complete Listing Input Forms
5. We Make Your Listing Live
6. Get Support 7 Days a Week
7. iSOLD!
array:6 [ "RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29500984 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411 +post_id: "1243901" +post_author: 1 +"ListingKey": "29500984" +"ListingId": "40813683" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T17:05:39Z" +"RFModificationTimestamp": "2026-06-02T17:20:30Z" +"ListPrice": 0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 8.03 +"LivingArea": 2288.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9H5E3" +"UnparsedAddress": "1817 REGIONAL ROAD 97 Road, Hamilton, Ontario L9H5E3" +"Coordinates": array:2 [ 0 => -80.1576027 1 => 43.3776123 ] +"Latitude": 43.3776123 +"Longitude": -80.1576027 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Spacious 6-bedroom, 4 full-bathroom home available for lease in a mixed-use property. The main floor offers 3 well-appointed bedrooms, including a primary bedroom with ensuite, a full main bathroom, and convenient main floor laundry. The bright kitchen opens to the dining and living areas, creating a functional layout for families or shared living. The second level features 3 additional bedrooms, including a generous primary suite complete with ensuite bath and a large walk-in closet, along with another full bathroom. Enjoy outdoor living with a rear deck overlooking green space. The property includes a garage and parking for up to 6 vehicles. Located just outside of town in a quiet setting, yet within close proximity to all essential amenities, this home offers both comfort and convenience. (id:62650)" +"Appliances": array:5 [ 0 => "Refrigerator" 1 => "Water softener" 2 => "Dishwasher" 3 => "Stove" 4 => "Hood Fan" ] +"AssociationFeeIncludes": array:1 [ 0 => "Insurance" ] +"Basement": array:1 [ 0 => "None" ] +"CreationDate": "2026-03-22T19:33:57.653281+00:00" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Propane" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1984576" +"ListOfficeKey": "291992" +"LivingAreaUnits": "square feet" +"LotSizeDimensions": "8.03" +"ParkingFeatures": array:1 [ 0 => "Detached Garage" ] +"PhotosChangeTimestamp": "2026-03-22T19:00:48Z" +"PhotosCount": 34 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:49:00Z" +"Stories": "1.5" +"StreetName": "REGIONAL ROAD 97" +"StreetNumber": "1817" +"SubdivisionName": "043 - Flamborough West" +"WaterSource": array:1 [ 0 => "Well" ] +"Rooms": array:13 [ 0 => array:11 [ "RoomKey" => "1649915687" "RoomType" => "Laundry room" "ListingId" => "40813683" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29500984" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:49:00.52Z" ] 1 => array:11 [ "RoomKey" => "1649915688" "RoomType" => "3pc Bathroom" "ListingId" => "40813683" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29500984" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:49:00.52Z" ] 2 => array:11 [ "RoomKey" => "1649915689" "RoomType" => "Full bathroom" "ListingId" => "40813683" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29500984" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:49:00.52Z" ] 3 => array:11 [ "RoomKey" => "1649915690" "RoomType" => "Primary Bedroom" "ListingId" => "40813683" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29500984" "RoomLength" => null "RoomDimensions" => "15'2'' x 19'7''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:49:00.52Z" ] 4 => array:11 [ "RoomKey" => "1649915691" "RoomType" => "Bedroom" "ListingId" => "40813683" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29500984" "RoomLength" => null "RoomDimensions" => "12'11'' x 11'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:49:00.52Z" ] 5 => array:11 [ "RoomKey" => "1649915692" "RoomType" => "Bedroom" "ListingId" => "40813683" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29500984" "RoomLength" => null "RoomDimensions" => "15'0'' x 15'11''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:49:00.52Z" ] 6 => array:11 [ "RoomKey" => "1649915693" "RoomType" => "Living room/Dining room" "ListingId" => "40813683" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29500984" "RoomLength" => null "RoomDimensions" => "15'5'' x 20'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:49:00.52Z" ] 7 => array:11 [ "RoomKey" => "1649915694" "RoomType" => "Kitchen" "ListingId" => "40813683" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29500984" "RoomLength" => null "RoomDimensions" => "11'10'' x 15'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:49:00.52Z" ] 8 => array:11 [ "RoomKey" => "1649915695" "RoomType" => "Bedroom" "ListingId" => "40813683" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29500984" "RoomLength" => null "RoomDimensions" => "18'9'' x 11'10''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:49:00.52Z" ] 9 => array:11 [ "RoomKey" => "1649915696" "RoomType" => "Full bathroom" "ListingId" => "40813683" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29500984" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:49:00.52Z" ] 10 => array:11 [ "RoomKey" => "1649915697" "RoomType" => "Primary Bedroom" "ListingId" => "40813683" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29500984" "RoomLength" => null "RoomDimensions" => "11'10'' x 13'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:49:00.53Z" ] 11 => array:11 [ "RoomKey" => "1649915698" "RoomType" => "4pc Bathroom" "ListingId" => "40813683" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29500984" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:49:00.53Z" ] 12 => array:11 [ "RoomKey" => "1649915699" "RoomType" => "Bedroom" "ListingId" => "40813683" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29500984" "RoomLength" => null "RoomDimensions" => "10'4'' x 10'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-02T16:49:00.53Z" ] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29500984/1817-regional-road-97-hamilton" +"ParkingTotal": 7 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "1937380" +"CommonInterest": "Freehold" +"CoListOfficeKey": "291992" +"GeocodeManualYN": true +"TotalActualRent": 3200 +"ZoningDescription": "E2,A1" +"BedroomsAboveGrade": 6 +"BedroomsBelowGrade": 0 +"LeaseAmountFrequency": "Monthly" +"FrontageLengthNumeric": 530.0 +"AboveGradeFinishedArea": 2288 +"OriginalEntryTimestamp": "2026-03-22T19:00:48.33Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1269306" +"ListOfficeNationalAssociationId": "1407252" +"CoListAgentNationalAssociationId": "1235794" +"CoListOfficeNationalAssociationId": "1407252" +"Media": array:34 [ 0 => array:13 [ "Order" => 0 "MediaKey" => "6535089351" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/f2b9a80328d26c10d398ebdbb2969827.webp" "MediaSize" => 178787 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-f2b9a80328d26c10d398ebdbb2969827.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "View of front of home featuring covered porch, a shingled roof, a garage, a storage shed, and brick siding" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 1 => array:13 [ "Order" => 1 "MediaKey" => "6535089365" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/4f95720db00949682357ad3fc236c4c2.webp" "MediaSize" => 95740 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-4f95720db00949682357ad3fc236c4c2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Corridor with wainscoting, stone finish floors, and wooden walls" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 2 => array:13 [ "Order" => 2 "MediaKey" => "6535089463" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/4be1e4875752201914e039f5e2c644b5.webp" "MediaSize" => 82737 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-4be1e4875752201914e039f5e2c644b5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Full bathroom featuring double vanity and baseboards" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 3 => array:13 [ "Order" => 3 "MediaKey" => "6535089542" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/e5adb31f935b4211e3e7a03720881750.webp" "MediaSize" => 117529 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-e5adb31f935b4211e3e7a03720881750.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen featuring white appliances, wood finish cabinets, glass fronted cabinets, decorative backsplash, and extractor fan" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 4 => array:13 [ "Order" => 4 "MediaKey" => "6535089623" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/ee61df74a2bf1a28fb1bbf69eb1f3433.webp" "MediaSize" => 84800 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-ee61df74a2bf1a28fb1bbf69eb1f3433.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Staircase with baseboards and stone finish flooring" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 5 => array:13 [ "Order" => 5 "MediaKey" => "6535089636" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/7dd7eae1c7d12afbfdd8ec27ec90b32f.webp" "MediaSize" => 87898 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-7dd7eae1c7d12afbfdd8ec27ec90b32f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Laundry area with stone tile floors and washing machine and clothes dryer" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 6 => array:13 [ "Order" => 6 "MediaKey" => "6535089673" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/529c56d263dbccfafdc7d76d7199a610.webp" "MediaSize" => 64871 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-529c56d263dbccfafdc7d76d7199a610.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Doorway to outside featuring stone finish floors and baseboards" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 7 => array:13 [ "Order" => 7 "MediaKey" => "6535089737" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/69e8b422c5196f91a93faaa27b09b72e.webp" "MediaSize" => 75001 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-69e8b422c5196f91a93faaa27b09b72e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Staircase with wood finished floors" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 8 => array:13 [ "Order" => 8 "MediaKey" => "6535089765" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/3549b01c3115bef4247a28a66f8d5319.webp" "MediaSize" => 69234 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-3549b01c3115bef4247a28a66f8d5319.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bathroom featuring vanity and healthy amount of natural light" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 9 => array:13 [ "Order" => 9 "MediaKey" => "6535089826" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/a7a0a50ee48bc68e7e727be00a9916e8.webp" "MediaSize" => 183046 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-a7a0a50ee48bc68e7e727be00a9916e8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "View of front of house featuring covered porch, an outbuilding, roof with shingles, and brick siding" "PreferredPhotoYN" => true "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 10 => array:13 [ "Order" => 10 "MediaKey" => "6535089850" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/411badfda3dedeb7a2b360272fd93d4a.webp" "MediaSize" => 74818 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-411badfda3dedeb7a2b360272fd93d4a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Unfurnished room featuring french doors, a ceiling fan, and light wood-style flooring" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 11 => array:13 [ "Order" => 11 "MediaKey" => "6535089929" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/e26bd6774a7b4b80bfbe21e9dd649562.webp" "MediaSize" => 197461 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-e26bd6774a7b4b80bfbe21e9dd649562.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "View of wooden deck" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 12 => array:13 [ "Order" => 12 "MediaKey" => "6535089978" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/05f2b3f2c92c5c2fc93d29dffd50152b.webp" "MediaSize" => 66504 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-05f2b3f2c92c5c2fc93d29dffd50152b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Full bathroom with a stall shower, vanity, and light tile patterned floors" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 13 => array:13 [ "Order" => 13 "MediaKey" => "6535090029" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/50b122dbf5ffff16a86b76c4cd6f81f2.webp" "MediaSize" => 58108 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-50b122dbf5ffff16a86b76c4cd6f81f2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Additional living space with baseboards and light wood-style floors" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 14 => array:13 [ "Order" => 14 "MediaKey" => "6535090076" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/f9e8a46a87a2ab2a8af8555d0d74bfdb.webp" "MediaSize" => 60149 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-f9e8a46a87a2ab2a8af8555d0d74bfdb.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Walk in closet with light wood-style flooring" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 15 => array:13 [ "Order" => 15 "MediaKey" => "6535090121" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/40a0b3426111c4d444f36cf30525d92a.webp" "MediaSize" => 54583 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-40a0b3426111c4d444f36cf30525d92a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Empty room featuring baseboards and dark wood-style floors" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 16 => array:13 [ "Order" => 16 "MediaKey" => "6535090145" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/d17049b0f8604fbb035937d5a579aa38.webp" "MediaSize" => 77924 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-d17049b0f8604fbb035937d5a579aa38.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Stairway with hardwood / wood-style flooring and a textured ceiling" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 17 => array:13 [ "Order" => 17 "MediaKey" => "6535090195" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/edfa4ad0558c0476a11ff2930045f75d.webp" "MediaSize" => 58737 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-edfa4ad0558c0476a11ff2930045f75d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Additional living space featuring light wood-style flooring and baseboards" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 18 => array:13 [ "Order" => 18 "MediaKey" => "6535090219" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/3465fa1140bde46e0382a8d1a562a32c.webp" "MediaSize" => 63007 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-3465fa1140bde46e0382a8d1a562a32c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Additional living space featuring light wood-type flooring and vaulted ceiling" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 19 => array:13 [ "Order" => 19 "MediaKey" => "6535090254" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/b939f86c7a0fe1f854aed9e106f14ef2.webp" "MediaSize" => 146330 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-b939f86c7a0fe1f854aed9e106f14ef2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "View of deck" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 20 => array:13 [ "Order" => 20 "MediaKey" => "6535090306" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/dcbd7241271a6ffe74c689abef803702.webp" "MediaSize" => 135177 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-dcbd7241271a6ffe74c689abef803702.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "View of wooden terrace" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 21 => array:13 [ "Order" => 21 "MediaKey" => "6535090346" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/0cb8d241a68da7cff2504cfe094aa7f6.webp" "MediaSize" => 158926 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-0cb8d241a68da7cff2504cfe094aa7f6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "View of front of property featuring a large porch, an outdoor structure, a shingled roof, brick siding, and gravel driveway" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 22 => array:13 [ "Order" => 22 "MediaKey" => "6535090378" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/b61ae1b14cc01a2db4e32103dd153853.webp" "MediaSize" => 87602 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-b61ae1b14cc01a2db4e32103dd153853.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Full bath featuring a shower stall, tile walls, wainscoting, and recessed lighting" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 23 => array:13 [ "Order" => 23 "MediaKey" => "6535090388" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/2690590481ae954a29c6176c46b00dd2.webp" "MediaSize" => 101028 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-2690590481ae954a29c6176c46b00dd2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen with a wainscoted wall, wood finish cabinets, dark countertops, glass fronted cabinets, and dishwasher" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 24 => array:13 [ "Order" => 24 "MediaKey" => "6535090416" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/7ec58aeb4337b8792d9b3363cb232fab.webp" "MediaSize" => 82196 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-7ec58aeb4337b8792d9b3363cb232fab.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Full bath with double vanity and a stall shower" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 25 => array:13 [ "Order" => 25 "MediaKey" => "6535090442" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/fb806e7ecd2a6bcd660749b798a06749.webp" "MediaSize" => 227007 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-fb806e7ecd2a6bcd660749b798a06749.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "View of front facade featuring covered porch and brick siding" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 26 => array:13 [ "Order" => 26 "MediaKey" => "6535090458" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/a33bfb98a92ba56637eae092c2c7637f.webp" "MediaSize" => 89993 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-a33bfb98a92ba56637eae092c2c7637f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 27 => array:13 [ "Order" => 27 "MediaKey" => "6535090486" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/edbe50bcac30241beb23f3a26ad18766.webp" "MediaSize" => 82347 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-edbe50bcac30241beb23f3a26ad18766.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Doorway featuring stone finish flooring" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 28 => array:13 [ "Order" => 28 "MediaKey" => "6535090523" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/3eb2cc2e6e711541ecb762ecf86e28e4.webp" "MediaSize" => 101901 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-3eb2cc2e6e711541ecb762ecf86e28e4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen featuring white appliances, glass fronted cabinets, wood finish cabinetry, and backsplash" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 29 => array:13 [ "Order" => 29 "MediaKey" => "6535090539" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/29668d38c1657b86a7dec7bd0e5ac0f2.webp" "MediaSize" => 105069 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-29668d38c1657b86a7dec7bd0e5ac0f2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Unfurnished living room featuring a ceiling fan, a wood stove, wood walls, and dark stone finish flooring" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 30 => array:13 [ "Order" => 30 "MediaKey" => "6535090570" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/2b9c13b83fbaa43c0413b5cd465d4b92.webp" "MediaSize" => 83871 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-2b9c13b83fbaa43c0413b5cd465d4b92.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Unfurnished living room featuring a skylight, healthy amount of natural light, and wood finished floors" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 31 => array:13 [ "Order" => 31 "MediaKey" => "6535090587" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/205d242012491d29573bf293004a49d8.webp" "MediaSize" => 168809 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-205d242012491d29573bf293004a49d8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Back of house with a fenced backyard, a wooden deck, a balcony, and an outbuilding" "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 32 => array:13 [ "Order" => 32 "MediaKey" => "6535090611" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/ce210f3d860bcbd4e988304ce515ddf3.webp" "MediaSize" => 104446 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-ce210f3d860bcbd4e988304ce515ddf3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] 33 => array:13 [ "Order" => 33 "MediaKey" => "6535090627" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29500984/a41c1c0fb99139e4ab482f7e374ad556.webp" "MediaSize" => 57206 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29500984/thumbnail-a41c1c0fb99139e4ab482f7e374ad556.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40813683" "ResourceRecordKey" => "29500984" "ModificationTimestamp" => "2026-03-22T19:00:48.33Z" ] ] +"DaysOnMarket": 92 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29500984')" +"ID": "1243901" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.27 seconds" ] "RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 291992" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24815 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.11 seconds" ] "RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1984576" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24814 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.11 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29500984'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25206 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.09 seconds" ] "RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29500984'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25222 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29500984' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Residential Lease' AND geo.distance(Coordinates, POINT(-80.1576027 43.3776123)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25269 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] ]