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:1 [ "RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=12&$skip=175788&$filter=InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24619 +items: array:12 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24753 +post_id: "1637374" +post_author: 1 +"ListingKey": "30050286" +"ListingId": "40849296" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-17T21:40:07Z" +"RFModificationTimestamp": "2026-07-17T21:45:49Z" +"ListPrice": 699900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1894.0 +"BuildingAreaTotal": 0 +"City": "Beamsville" +"PostalCode": "L3J0R2" +"UnparsedAddress": "4297 EAST Avenue Unit# 10, Beamsville, Ontario L3J0R2" +"Coordinates": array:2 [ 0 => -79.4707111 1 => 43.1665842 ] +"Latitude": 43.1665842 +"Longitude": -79.4707111 +"YearBuilt": 2019 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to this beautifully maintained 2-storey semi-detached home offering 1,895 sq ft of stylish living space in the heart of Beamsville! Perfectly situated with no rear neighbours, this home backs onto a sports field, providing peaceful views and added privacy. Step inside to a bright, open concept main floor designed for both everyday living and entertaining. The inviting living room flows seamlessly into the spacious eat-in kitchen is sure to impress with quartz countertops, stainless steel appliances, built-in double ovens, countertop range, tiled backsplash, ample cabinetry, and an island with breakfast bar. A convenient 2-piece powder room, separate dining room and walk-out to the fully fenced backyard complete the main level. Upstairs, the spacious primary bedroom features a walk-in closet and a private 3-piece ensuite with a walk-in shower. Two additional good sized bedrooms, a 4-piece main bathroom, and the convenience of bedroom-level laundry make this upper level ideal for families. Enjoy outdoor living in the fully fenced backyard with no homes behind, offering direct views of the adjoining sports field—an ideal setting for relaxing, entertaining, or watching the kids play. Located in one of Beamsville's most desirable family-friendly neighbourhoods, this home is just minutes from schools, parks, shopping, restaurants, wineries, highway access, and all major amenities. Combining modern finishes, a functional layout, and an unbeatable location, this move-in ready home is one you won't want to miss! (id:62650)" +"Appliances": array:6 [ 0 => "Refrigerator" 1 => "Water meter" 2 => "Dishwasher" 3 => "Dryer" 4 => "Hood Fan" 5 => "Window Coverings" ] +"AssociationFeeIncludes": array:2 [ 0 => "Landscaping" 1 => "Parking" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-17T21:45:38.985766+00:00" +"ExteriorFeatures": array:4 [ 0 => "Brick" 1 => "Stone" 2 => "Stucco" 3 => "Vinyl siding" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1879566" +"ListOfficeKey": "294054" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Cul-de-sac" 1 => "Paved driveway" 2 => "Sump Pump" ] +"ParkingFeatures": array:2 [ 0 => "Attached Garage" 1 => "Visitor Parking" ] +"PhotosChangeTimestamp": "2026-07-17T21:32:06Z" +"PhotosCount": 38 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-17T21:32:06Z" +"Stories": "2.0" +"StreetName": "EAST" +"StreetNumber": "4297" +"StreetSuffix": "Avenue" +"SubdivisionName": "056 - West Lincoln" +"TaxAnnualAmount": "5743.64" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:10 [ 0 => array:11 [ "RoomKey" => "1687061655" "RoomType" => "4pc Bathroom" "ListingId" => "40849296" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "30050286" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T21:18:39.77Z" ] 1 => array:11 [ "RoomKey" => "1687061656" "RoomType" => "Bedroom" "ListingId" => "40849296" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "30050286" "RoomLength" => null "RoomDimensions" => "9'1'' x 10'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T21:18:39.77Z" ] 2 => array:11 [ "RoomKey" => "1687061657" "RoomType" => "Bedroom" "ListingId" => "40849296" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "30050286" "RoomLength" => null "RoomDimensions" => "10'2'' x 10'9''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T21:18:39.77Z" ] 3 => array:11 [ "RoomKey" => "1687061658" "RoomType" => "Full bathroom" "ListingId" => "40849296" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "30050286" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T21:18:39.77Z" ] 4 => array:11 [ "RoomKey" => "1687061659" "RoomType" => "Primary Bedroom" "ListingId" => "40849296" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "30050286" "RoomLength" => null "RoomDimensions" => "13'7'' x 14'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T21:18:39.77Z" ] 5 => array:11 [ "RoomKey" => "1687061660" "RoomType" => "2pc Bathroom" "ListingId" => "40849296" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30050286" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T21:18:39.77Z" ] 6 => array:11 [ "RoomKey" => "1687061661" "RoomType" => "Dining room" "ListingId" => "40849296" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30050286" "RoomLength" => null "RoomDimensions" => "8'7'' x 10'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T21:18:39.77Z" ] 7 => array:11 [ "RoomKey" => "1687061662" "RoomType" => "Breakfast" "ListingId" => "40849296" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30050286" "RoomLength" => null "RoomDimensions" => "6'1'' x 10'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T21:18:39.77Z" ] 8 => array:11 [ "RoomKey" => "1687061663" "RoomType" => "Kitchen" "ListingId" => "40849296" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30050286" "RoomLength" => null "RoomDimensions" => "8'4'' x 10'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T21:18:39.77Z" ] 9 => array:11 [ "RoomKey" => "1687061664" "RoomType" => "Living room" "ListingId" => "40849296" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30050286" "RoomLength" => null "RoomDimensions" => "15'3'' x 20'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T21:18:39.77Z" ] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30050286/4297-east-avenue-unit-10-beamsville" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "R2-29" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 25.0 +"AboveGradeFinishedArea": 1894 +"OriginalEntryTimestamp": "2026-07-17T21:18:39.71Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Builder" +"ListAgentNationalAssociationId": "1205653" +"ListOfficeNationalAssociationId": "1434831" +"Media": array:38 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "30050286_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/e0718cf64996a0c1899d4ce6b437e0bf.webp" "MediaSize" => 165380 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-e0718cf64996a0c1899d4ce6b437e0bf.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Contemporary townhome facade featuring a brick and stucco exterior" "PreferredPhotoYN" => true "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:06.46Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "30050286_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/7e67942e92606100f361c3749b6b4425.webp" "MediaSize" => 165531 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-7e67942e92606100f361c3749b6b4425.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Brick and stone facade townhome featuring a covered entry, an arched accent window, a paved driveway, and an attached garage with panel-style doors" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:06.46Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "30050286_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/841f48d7d74f3ed0207346a034558255.webp" "MediaSize" => 178166 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-841f48d7d74f3ed0207346a034558255.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Brick and stone facade townhome featuring a covered front porch, an arched dormer window, and a gabled roofline" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:02.13Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "30050286_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/00f1a13201031c863a84849b2eb61013.webp" "MediaSize" => 203359 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-00f1a13201031c863a84849b2eb61013.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Private backyard patio featuring a sliding glass door entry" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:02.13Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "30050286_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/34febca8d77b6ded14046776872aa2a8.webp" "MediaSize" => 197708 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-34febca8d77b6ded14046776872aa2a8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Stone patio featuring a decorative outdoor rug and planted greenery" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:05.72Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "30050286_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/b704c1ff627bc76443b919c2a3d9e479.webp" "MediaSize" => 203515 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-b704c1ff627bc76443b919c2a3d9e479.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Backyard featuring a patio area with a privacy fence, bordered by mature trees and a black metal fence" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:02.15Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "30050286_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/e91b3ea11579d828c145827df0081067.webp" "MediaSize" => 195003 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-e91b3ea11579d828c145827df0081067.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Expansive green lawn with mature trees and established shrubbery providing natural screening" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:01.63Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "30050286_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/a276f733ee649e38f238519495656b32.webp" "MediaSize" => 147122 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-a276f733ee649e38f238519495656b32.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:04.45Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "30050286_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/b95713fab94933e59875692863908632.webp" "MediaSize" => 176221 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-b95713fab94933e59875692863908632.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Brick and stone facade entry with a dark-paneled door featuring a translucent side panel and white louvered blinds" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:01.63Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "30050286_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/57c51a47e02ae03d96c18ea8ff3925d3.webp" "MediaSize" => 67292 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-57c51a47e02ae03d96c18ea8ff3925d3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Entryway featuring white panel doors, a frosted glass sidelight, and an overhead transom window" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:02.13Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "30050286_4890_11" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/f338b28863f01daadbe1e2b08378aaf0.webp" "MediaSize" => 64471 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-f338b28863f01daadbe1e2b08378aaf0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:02.13Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "30050286_4890_12" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/b3350af0194187e9c7afc684c3dad639.webp" "MediaSize" => 103212 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-b3350af0194187e9c7afc684c3dad639.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Living area featuring a dark accent wall, white window shutters, and rich wood-finish flooring" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:02.15Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "30050286_4890_13" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/ec129112835972259fe5862801db250d.webp" "MediaSize" => 104250 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-ec129112835972259fe5862801db250d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Living area featuring dark wood-finish flooring, a textured accent wall, and a wall-mounted television" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:05.92Z" ] 13 => array:13 [ "Order" => 14 "MediaKey" => "30050286_4890_14" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/61ae72240f584e4175a98d33f293166d.webp" "MediaSize" => 100826 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-61ae72240f584e4175a98d33f293166d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Open-concept living space featuring dark wood-finish flooring, white plantation shutters, and recessed lighting" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:05.72Z" ] 14 => array:13 [ "Order" => 15 "MediaKey" => "30050286_4890_15" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/0cc645d3d1a9d1dd40829fdd8e616ded.webp" "MediaSize" => 81836 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-0cc645d3d1a9d1dd40829fdd8e616ded.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Open concept living space featuring a modern kitchen with white cabinetry, subway tile backsplash, and stainless steel appliances" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:02.13Z" ] 15 => array:13 [ "Order" => 16 "MediaKey" => "30050286_4890_16" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/b2248c9d6f53e96c2e76cc0f225e71e3.webp" "MediaSize" => 79161 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-b2248c9d6f53e96c2e76cc0f225e71e3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Contemporary kitchen featuring white cabinetry, stainless steel appliances, a white subway tile backsplash, a center island with countertop seating, and dark wood-finish flooring" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:02.13Z" ] 16 => array:13 [ "Order" => 17 "MediaKey" => "30050286_4890_17" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/5afd388cfddfc0d8ed921ca32b58f0e8.webp" "MediaSize" => 74380 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-5afd388cfddfc0d8ed921ca32b58f0e8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Contemporary kitchen featuring a large central island with an integrated stainless steel dishwasher, white cabinetry, dark wood-finish flooring, built-in stainless steel double ovens, and a subway til" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:02.13Z" ] 17 => array:13 [ "Order" => 18 "MediaKey" => "30050286_4890_18" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/2c5219243ce53bfb56926572b48eb5c7.webp" "MediaSize" => 85159 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-2c5219243ce53bfb56926572b48eb5c7.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "White cabinetry with sleek hardware, integrated stainless steel double ovens, and a contemporary cooktop" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:02.13Z" ] 18 => array:13 [ "Order" => 19 "MediaKey" => "30050286_4890_19" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/b030975ca7f8fa7b06b543dbf30a0f63.webp" "MediaSize" => 83837 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-b030975ca7f8fa7b06b543dbf30a0f63.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Modern kitchen featuring white shaker cabinetry with polished chrome hardware, a built-in stainless steel double oven, a smooth-top electric cooktop, and white subway tile backsplash" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:05.72Z" ] 19 => array:13 [ "Order" => 20 "MediaKey" => "30050286_4890_20" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/54394a608da67e43b6b56659211985b8.webp" "MediaSize" => 68257 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-54394a608da67e43b6b56659211985b8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "White shaker cabinetry with chrome hardware, subway tile backsplash, and integrated cooktop" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:05.72Z" ] 20 => array:13 [ "Order" => 21 "MediaKey" => "30050286_4890_21" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/d6ac1e075b381b7f015771dda7730561.webp" "MediaSize" => 108870 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-d6ac1e075b381b7f015771dda7730561.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen island featuring a double basin stainless steel sink with an integrated dishwasher, white cabinetry, and a white countertop" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:02.13Z" ] 21 => array:13 [ "Order" => 22 "MediaKey" => "30050286_4890_22" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/64c2c099799843465116d5a7d9c5cbe2.webp" "MediaSize" => 69830 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-64c2c099799843465116d5a7d9c5cbe2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Spacious dining area featuring dark wood-finish flooring, white baseboards, and a contemporary light wood-tone table" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:02.15Z" ] 22 => array:13 [ "Order" => 23 "MediaKey" => "30050286_4890_23" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/03470246ca6cdcdfd57d8531a5b9ecc3.webp" "MediaSize" => 63549 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-03470246ca6cdcdfd57d8531a5b9ecc3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Dining area featuring dark wood-finish flooring, white baseboards, and bright white walls" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:02.13Z" ] 23 => array:13 [ "Order" => 24 "MediaKey" => "30050286_4890_24" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/0ee1d73fa2bfd264860e6e3c0b809b85.webp" "MediaSize" => 59688 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-0ee1d73fa2bfd264860e6e3c0b809b85.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Powder room featuring a wood-finish vanity with a white countertop and integrated sink, a dark-framed wall mirror, and modern lighting fixtures" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:05.72Z" ] 24 => array:13 [ "Order" => 25 "MediaKey" => "30050286_4890_25" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/37a60961c26faefc8bc33823c2edcda7.webp" "MediaSize" => 70963 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-37a60961c26faefc8bc33823c2edcda7.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Dark wood-finish staircase with matching banister and handrail" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:05.29Z" ] 25 => array:13 [ "Order" => 26 "MediaKey" => "30050286_4890_26" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/78361a6c53b726c1beb2f6103e0c420b.webp" "MediaSize" => 43184 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-78361a6c53b726c1beb2f6103e0c420b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:05.73Z" ] 26 => array:13 [ "Order" => 27 "MediaKey" => "30050286_4890_27" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/855df0e36dfe364ffe635d2843e0c839.webp" "MediaSize" => 99925 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-855df0e36dfe364ffe635d2843e0c839.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Spacious room featuring dark wood-finish flooring and a single window with white plantation shutters" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:05.72Z" ] 27 => array:13 [ "Order" => 28 "MediaKey" => "30050286_4890_28" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/3a22d903782867ecbac45b64707cd5b5.webp" "MediaSize" => 97846 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-3a22d903782867ecbac45b64707cd5b5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bedroom featuring deep blue walls, dark wood-finish flooring, a ceiling-mounted light fixture, and a walk-in closet with built-in shelving" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:05.72Z" ] 28 => array:13 [ "Order" => 29 "MediaKey" => "30050286_4890_29" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/ad75ff7e5d26db9e7fe4a84e68ac3108.webp" "MediaSize" => 102069 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-ad75ff7e5d26db9e7fe4a84e68ac3108.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bedroom featuring rich blue walls, dark wood-finish flooring, and a window with white louvered shutters" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:05.92Z" ] 29 => array:13 [ "Order" => 30 "MediaKey" => "30050286_4890_30" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/08fce14a02d40c858bd4e44d60cb8584.webp" "MediaSize" => 58135 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-08fce14a02d40c858bd4e44d60cb8584.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Contemporary bathroom featuring a frameless glass shower enclosure with tiled walls" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:06.46Z" ] 30 => array:13 [ "Order" => 31 "MediaKey" => "30050286_4890_31" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/20dec05412c8dc08697fb6eb6fb60a23.webp" "MediaSize" => 48624 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-20dec05412c8dc08697fb6eb6fb60a23.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Hallway with dark wood-finish flooring, white paneled doors, and light gray walls" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:05.72Z" ] 31 => array:13 [ "Order" => 32 "MediaKey" => "30050286_4890_32" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/2d70c8777bdfc0a58fbe62c585961053.webp" "MediaSize" => 102315 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-2d70c8777bdfc0a58fbe62c585961053.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bright bedroom with a window featuring white plantation shutters, dark wood-finish flooring, and crisp white walls" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:02.13Z" ] 32 => array:13 [ "Order" => 33 "MediaKey" => "30050286_4890_33" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/fe96d207776a18ca760b0afefd53f160.webp" "MediaSize" => 112492 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-fe96d207776a18ca760b0afefd53f160.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "White walls and dark wood-finish flooring provide a neutral backdrop for any decor" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:05.72Z" ] 33 => array:13 [ "Order" => 34 "MediaKey" => "30050286_4890_34" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/5e62e85f26cd27ff13e55eae6288e927.webp" "MediaSize" => 115690 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-5e62e85f26cd27ff13e55eae6288e927.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Wood-finish flooring present in this room with blue painted walls" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:05.72Z" ] 34 => array:13 [ "Order" => 35 "MediaKey" => "30050286_4890_35" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/4f0d7554002a083bb0f4703265e01cde.webp" "MediaSize" => 63544 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-4f0d7554002a083bb0f4703265e01cde.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bathroom featuring a rectangular mirror, a white countertop vanity with a single basin sink, wood-finish cabinetry, and tiled flooring" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:05.93Z" ] 35 => array:13 [ "Order" => 36 "MediaKey" => "30050286_4890_36" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/a9ea962ae245ec1f6ce5bbdd3ea59f2e.webp" "MediaSize" => 49894 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-a9ea962ae245ec1f6ce5bbdd3ea59f2e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Dedicated laundry space featuring a utility sink with a chrome faucet" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:05.72Z" ] 36 => array:13 [ "Order" => 37 "MediaKey" => "30050286_4890_37" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/2973c1a4b699bc1557a2c4a8dc03811a.webp" "MediaSize" => 63186 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-2973c1a4b699bc1557a2c4a8dc03811a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "White soaking tub with chrome fixtures and grab bars, set against a backdrop of light-toned tile walls" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:05.72Z" ] 37 => array:13 [ "Order" => 38 "MediaKey" => "30050286_4890_38" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050286/38031735fe5417c1c1d39fd6de15907b.webp" "MediaSize" => 44199 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050286/thumbnail-38031735fe5417c1c1d39fd6de15907b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Spacious garage featuring a sectional overhead door with upper window panels, painted concrete flooring, track lighting, and exposed ceiling joists" "PreferredPhotoYN" => false "ResourceRecordId" => "40849296" "ResourceRecordKey" => "30050286" "ModificationTimestamp" => "2026-07-17T21:32:06.46Z" ] ] +"DaysOnMarket": 4 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30050286')" +"ID": "1637374" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24755 +post_id: "1637600" +post_author: 1 +"ListingKey": "30050682" +"ListingId": "40849295" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-17T22:35:25Z" +"RFModificationTimestamp": "2026-07-17T22:52:46Z" +"ListPrice": 0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1700.0 +"BuildingAreaTotal": 0 +"City": "Stoney Creek" +"PostalCode": "L8J0M2" +"UnparsedAddress": "12 TOFFEE Trail, Stoney Creek, Ontario L8J0M2" +"Coordinates": array:2 [ 0 => -79.7771442 1 => 43.2053816 ] +"Latitude": 43.2053816 +"Longitude": -79.7771442 +"YearBuilt": 2021 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 12 Toffee Trail, a stunning, fully detached home offering the perfect blend of modern luxury and thoughtful design. From the moment you step through the grand double-door entry, you are greeted by a bright and spacious main level featuring soaring 9-foot ceilings, upgraded hardwood flooring, and a cozy gas fireplace in the expansive great room. The open-concept chef's kitchen is an entertainer's dream, complete with premium granite countertops, a large center island, and stainless steel appliances, flowing seamlessly into a generous dining area. Large, sun-drenched windows flood the entire home with natural light and lead out to a raised wooden deck—the ideal spot for your morning coffee or evening glass of wine while enjoying serene, unobstructed views of the pond. Upstairs, the functional layout offers three spacious bedrooms, including a primary retreat featuring a massive walk-in closet and a private 4-piece ensuite, alongside a conveniently located separate laundry room. Complete with an expansive, unfinished lookout basement with large windows providing ample storage space, this immaculate, whole-house rental truly has everything a family could desire. (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-17T22:52:38.515177+00:00" +"Directions": "Bedrock Dr and First Rd W" +"ExteriorFeatures": array:1 [ 0 => "Brick Veneer" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2197911" +"ListOfficeKey": "294490" +"LivingAreaUnits": "square feet" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-07-17T22:30:50Z" +"PhotosCount": 12 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-17T22:30:50Z" +"Stories": "2.0" +"StreetName": "TOFFEE" +"StreetNumber": "12" +"StreetSuffix": "Trail" +"SubdivisionName": "500 - Heritage Green" +"View": "City view" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:9 [ 0 => array:11 [ "RoomKey" => "1687129425" "RoomType" => "3pc Bathroom" "ListingId" => "40849295" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "30050682" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T22:29:03.01Z" ] 1 => array:11 [ "RoomKey" => "1687129426" "RoomType" => "4pc Bathroom" "ListingId" => "40849295" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "30050682" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T22:29:03.01Z" ] 2 => array:11 [ "RoomKey" => "1687129427" "RoomType" => "2pc Bathroom" "ListingId" => "40849295" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30050682" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T22:29:03.02Z" ] 3 => array:11 [ "RoomKey" => "1687129428" "RoomType" => "Bedroom" "ListingId" => "40849295" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "30050682" "RoomLength" => null "RoomDimensions" => "12'6'' x 9'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T22:29:03.02Z" ] 4 => array:11 [ "RoomKey" => "1687129429" "RoomType" => "Bedroom" "ListingId" => "40849295" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "30050682" "RoomLength" => null "RoomDimensions" => "11'9'' x 9'9''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T22:29:03.02Z" ] 5 => array:11 [ "RoomKey" => "1687129430" "RoomType" => "Primary Bedroom" "ListingId" => "40849295" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "30050682" "RoomLength" => null "RoomDimensions" => "10'9'' x 13'9''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T22:29:03.02Z" ] 6 => array:11 [ "RoomKey" => "1687129431" "RoomType" => "Kitchen" "ListingId" => "40849295" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30050682" "RoomLength" => null "RoomDimensions" => "10'9'' x 8'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T22:29:03.02Z" ] 7 => array:11 [ "RoomKey" => "1687129432" "RoomType" => "Dining room" "ListingId" => "40849295" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30050682" "RoomLength" => null "RoomDimensions" => "9'5'' x 13'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T22:29:03.02Z" ] 8 => array:11 [ "RoomKey" => "1687129433" "RoomType" => "Living room" "ListingId" => "40849295" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30050682" "RoomLength" => null "RoomDimensions" => "11'5'' x 22'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T22:29:03.02Z" ] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30050682/12-toffee-trail-stoney-creek" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"TotalActualRent": 3100 +"ZoningDescription": "R4-32" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"LeaseAmountFrequency": "Monthly" +"FrontageLengthNumeric": 31.0 +"AboveGradeFinishedArea": 1700 +"OriginalEntryTimestamp": "2026-07-17T22:29:02.96Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Owner" +"ListAgentNationalAssociationId": "1446283" +"ListOfficeNationalAssociationId": "1439453" +"Media": array:12 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "30050682_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050682/6537bbd448c96627b263f9faaf459b90.webp" "MediaSize" => 110804 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050682/thumbnail-6537bbd448c96627b263f9faaf459b90.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "40849295" "ResourceRecordKey" => "30050682" "ModificationTimestamp" => "2026-07-17T22:30:50.52Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "30050682_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050682/a20ce13cc402de2178acdd4c7aaaa0d2.webp" "MediaSize" => 102354 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050682/thumbnail-a20ce13cc402de2178acdd4c7aaaa0d2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849295" "ResourceRecordKey" => "30050682" "ModificationTimestamp" => "2026-07-17T22:30:50.53Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "30050682_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050682/ad5487f222b7f7c19ab5ce20d5aa8110.webp" "MediaSize" => 76604 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050682/thumbnail-ad5487f222b7f7c19ab5ce20d5aa8110.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849295" "ResourceRecordKey" => "30050682" "ModificationTimestamp" => "2026-07-17T22:30:46Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "30050682_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050682/f5a21e264017661b5b66c6626a2ad52d.webp" "MediaSize" => 65250 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050682/thumbnail-f5a21e264017661b5b66c6626a2ad52d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849295" "ResourceRecordKey" => "30050682" "ModificationTimestamp" => "2026-07-17T22:30:50.51Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "30050682_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050682/4827c7bb9b7e51164e90241953c43b2a.webp" "MediaSize" => 85078 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050682/thumbnail-4827c7bb9b7e51164e90241953c43b2a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849295" "ResourceRecordKey" => "30050682" "ModificationTimestamp" => "2026-07-17T22:30:50.5Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "30050682_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050682/6e0aa6b0871d0648e591e54b41ec0998.webp" "MediaSize" => 61088 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050682/thumbnail-6e0aa6b0871d0648e591e54b41ec0998.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849295" "ResourceRecordKey" => "30050682" "ModificationTimestamp" => "2026-07-17T22:30:50.5Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "30050682_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050682/57eb55ab3472fce5c183ea0df5f8d10e.webp" "MediaSize" => 40926 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050682/thumbnail-57eb55ab3472fce5c183ea0df5f8d10e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849295" "ResourceRecordKey" => "30050682" "ModificationTimestamp" => "2026-07-17T22:30:50.5Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "30050682_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050682/9f840c37a408761ce95a9b2f4000c0ef.webp" "MediaSize" => 65378 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050682/thumbnail-9f840c37a408761ce95a9b2f4000c0ef.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849295" "ResourceRecordKey" => "30050682" "ModificationTimestamp" => "2026-07-17T22:30:50.45Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "30050682_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050682/231e26fcc0562e477f22475532458ac0.webp" "MediaSize" => 63610 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050682/thumbnail-231e26fcc0562e477f22475532458ac0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849295" "ResourceRecordKey" => "30050682" "ModificationTimestamp" => "2026-07-17T22:30:50.45Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "30050682_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30050682/90fea6f5654dbd7623fa25c3351ec046.webp" "MediaSize" => 73780 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30050682/thumbnail-90fea6f5654dbd7623fa25c3351ec046.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false …3 ] 10 => array:13 [ …13] 11 => array:13 [ …13] ] +"DaysOnMarket": 4 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30050682')" +"ID": "1637600" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24719 +post_id: "1638751" +post_author: 1 +"ListingKey": "30050889" +"ListingId": "40849290" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-17T23:05:25Z" +"RFModificationTimestamp": "2026-07-18T01:04:05Z" +"ListPrice": 0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 2013.0 +"BuildingAreaTotal": 0 +"City": "Burlington" +"PostalCode": "L7T3S9" +"UnparsedAddress": "675 INVERNESS Avenue, Burlington, Ontario L7T3S9" +"Coordinates": array:2 [ 0 => -79.8318883 1 => 43.3244168 ] +"Latitude": 43.3244168 +"Longitude": -79.8318883 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to this beautiful bungalow situated on an impressive 60 ft x 137 ft lot, offering over 2,000 sq ft of living space. This well maintained home features four spacious bedrooms, two bathrooms, and an updated kitchen complete with large cabinets and granite countertops. The finished basement includes a separate entrance, one bedroom, a 3-piece bathroom, and a second living area. Ideal for extended family, an in-law suite, or additional recreational space. Enjoy a generous backyard, ample parking, and a family-friendly neighbourhood surrounded by schools, parks, and everyday amenities. Conveniently located just minutes from the QEW, Highway 403, Oakville, and Hamilton. Extras: Inclusions: Includes: S/S Dishwasher, Fridge, All Elf's, All Window Coverings, Custom Kitchen Cabinets, Granite Countertops, Pet Friendly, Shed, 4 Car Driveway! (id:62650)" +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-18T01:04:02.295634+00:00" +"Directions": "King Rd & Inverness Ave" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Aluminum siding" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2188624" +"ListOfficeKey": "283528" +"LivingAreaUnits": "square feet" +"PhotosChangeTimestamp": "2026-07-17T23:00:25Z" +"PhotosCount": 23 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-17T23:00:25Z" +"Stories": "1.0" +"StreetName": "INVERNESS" +"StreetNumber": "675" +"StreetSuffix": "Avenue" +"SubdivisionName": "302 - Aldershot Central" +"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/30050889/675-inverness-avenue-burlington" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"TotalActualRent": 3475 +"ZoningDescription": "R2.4" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"LeaseAmountFrequency": "Monthly" +"FrontageLengthNumeric": 60.0 +"AboveGradeFinishedArea": 1068 +"BelowGradeFinishedArea": 945 +"OriginalEntryTimestamp": "2026-07-17T22:59:06.88Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1437623" +"ListOfficeNationalAssociationId": "1332140" +"Media": array:23 [ 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] ] +"DaysOnMarket": 4 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30050889')" +"ID": "1638751" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24614 +post_id: "1637113" +post_author: 1 +"ListingKey": "30050153" +"ListingId": "40849286" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-21T19:10:06Z" +"RFModificationTimestamp": "2026-07-21T19:18:35Z" +"ListPrice": 635000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1217.0 +"BuildingAreaTotal": 0 +"City": "Kitchener" +"PostalCode": "N2H6H5" +"UnparsedAddress": "784 ELIZABETH Street, Kitchener, Ontario N2H6H5" +"Coordinates": array:2 [ 0 => -80.4859694 1 => 43.4686664 ] +"Latitude": 43.4686664 +"Longitude": -80.4859694 +"YearBuilt": 1950 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "From the moment you arrive, you'll appreciate the welcoming feel and undeniable charm this home has to offer. Filled with natural light and thoughtfully updated over the years, this delightful 3-bedroom, 1.5-bathroom home strikes the perfect balance between character and modern comfort. The bright, inviting living room is a wonderful place to relax, while the stunning 2023 kitchen is designed for everyday living, offering stylish finishes, generous prep space, and a cozy dining nook that's equally suited to busy mornings or lingering dinners with family and friends. Step outside through the sliding doors to a covered patio that extends your living space outdoors. The generous backyard offers multiple seating areas, established perennial gardens, and endless possibilities, whether you're dreaming of a pool, additional outdoor entertaining space, or even an ARU (Accessory Residential Unit)—please check with the City as permits are required and to see what available grant programs you may qualify for. Convenient main-floor living includes a spacious primary bedroom and an updated bathroom (2021) featuring heated floors for an added touch of luxury. Upstairs are two additional bedrooms, a handy 2-piece bathroom, and excellent storage space. The partially finished basement provides valuable extra living space today, with room to expand or customize as your family's needs evolve. Notable updates include a 125-amp electrical panel, plumbing improvements (2021 & 2023), furnace with humidifier & central air conditioning (2019), custom window shades on most windows, and more. Ideally situated in a desirable neighbourhood close to parks, the community centre, shopping, restaurants, transit, and everyday conveniences, this is a home that offers comfort, flexibility, and lasting appeal both inside and out. (id:62650)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Water softener" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Hood Fan" 6 => "Window Coverings" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-17T21:21:22.985128+00:00" +"Directions": "Lancaster St W to Elizabeth" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Aluminum siding" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1830254" +"ListOfficeKey": "289541" +"LivingAreaUnits": "square feet" +"PhotosChangeTimestamp": "2026-07-21T19:04:42Z" +"PhotosCount": 44 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-21T19:04:42Z" +"Stories": "1.5" +"StreetName": "ELIZABETH" +"StreetNumber": "784" +"StreetSuffix": "Street" +"SubdivisionName": "114 - Uptown Waterloo/North Ward" +"TaxAnnualAmount": "4021.16" +"VirtualTourURLUnbranded": "https://youriguide.com/g9vfx_784_elizabeth_st_kitchener_on/" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:9 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30050153/784-elizabeth-street-kitchener" +"ParkingTotal": 3 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "R4" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 46.0 +"AboveGradeFinishedArea": 1217 +"OriginalEntryTimestamp": "2026-07-17T20:59:39.33Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1195645" +"ListOfficeNationalAssociationId": "1378680" +"Media": array:44 [ 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] ] +"DaysOnMarket": 4 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30050153')" +"ID": "1637113" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24666 +post_id: "1639670" +post_author: 1 +"ListingKey": "30052310" +"ListingId": "40849285" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-18T18:35:26Z" +"RFModificationTimestamp": "2026-07-18T19:40:51Z" +"ListPrice": 0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Mississauga" +"PostalCode": "L5M0Z1" +"UnparsedAddress": "4655 GLEN ERIN Drive Unit# 1008, Mississauga, Ontario L5M0Z1" +"Coordinates": array:2 [ 0 => -79.7128258 1 => 43.555033 ] +"Latitude": 43.555033 +"Longitude": -79.7128258 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome home to Downtown Erin Mills! Relax and unwind in this spacious open concept corner suite, featuring 9 ft.smooth ceilings, wide plank flooring, stainless steel appliances, kitchen island, quartz countertops, loads of storage,with tons of natural light and complete with 2 balconies, one of which is a stunning wrap around balcony! (id:62650)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Microwave" 6 => "Window Coverings" ] +"AssociationFeeIncludes": array:2 [ 0 => "Heat" 1 => "Water" ] +"Basement": array:1 [ 0 => "None" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-18T19:40:45.646146+00:00" +"ExteriorFeatures": array:1 [ 0 => "Concrete" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2051061" +"ListOfficeKey": "283251" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Balcony" ] +"ParkingFeatures": array:2 [ 0 => "Underground" 1 => "Visitor Parking" ] +"PhotosChangeTimestamp": "2026-07-18T18:33:09Z" +"PhotosCount": 14 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-18T18:33:09Z" +"StreetName": "GLEN ERIN" +"StreetNumber": "4655" +"StreetSuffix": "Drive" +"SubdivisionName": "0070 - Central Erin Mills" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:6 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30052310/4655-glen-erin-drive-unit-1008-mississauga" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "Apartment" ] +"CommonInterest": "Leasehold" +"GeocodeManualYN": true +"TotalActualRent": 3300 +"ZoningDescription": "RM7D5" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"LeaseAmountFrequency": "Monthly" +"FrontageLengthNumeric": 0.0 +"OriginalEntryTimestamp": "2026-07-18T18:29:45.77Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1326431" +"ListOfficeNationalAssociationId": "1326231" +"Media": array:14 [ 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] ] +"DaysOnMarket": 3 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30052310')" +"ID": "1639670" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24757 +post_id: "1643667" +post_author: 1 +"ListingKey": "30056831" +"ListingId": "40849281" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-21T17:05:18Z" +"RFModificationTimestamp": "2026-07-21T17:17:52Z" +"ListPrice": 0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 2034.0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L4W9" +"UnparsedAddress": "176 WOODVILLE Place, Waterloo, Ontario N2L4W9" +"Coordinates": array:2 [ 0 => -80.5473952 1 => 43.4910191 ] +"Latitude": 43.4910191 +"Longitude": -80.5473952 +"YearBuilt": 1968 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Cul-de-sac living! Welcome to 176 Woodville Place, a beautifully maintained raised bungalow situated on a quiet cul-de-sac in a prime location. This spacious 5-bedroom, 2-bathroom home is perfect for families looking for a move-in-ready property with great potential. Freshly painted throughout, the functional layout features a fully finished walk-out basement with a separate entrance, offering excellent flexibility.The swimming pool is not available for use. (id:62650)" +"Appliances": array:9 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Central Vacuum" 4 => "Dishwasher" 5 => "Stove" 6 => "Window Coverings" 7 => "Garage door opener" 8 => "Microwave Built-in" ] +"ArchitecturalStyle": array:1 [ 0 => "Raised bungalow" ] +"AssociationFeeFrequency": "Monthly" +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-20T23:31:57.473832+00:00" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Aluminum siding" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2053490" +"ListOfficeKey": "76840" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Paved driveway" 1 => "Automatic Garage Door Opener" ] +"LotSizeDimensions": "0" +"PhotosChangeTimestamp": "2026-07-21T16:59:34Z" +"PhotosCount": 39 +"PoolFeatures": array:1 [ 0 => "Inground pool" ] +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-21T16:59:34Z" +"Stories": "1.0" +"StreetName": "WOODVILLE" +"StreetNumber": "176" +"StreetSuffix": "Place" +"SubdivisionName": "421 - Lakeshore/Parkdale" +"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/30056831/176-woodville-place-waterloo" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "2102262" +"CommonInterest": "Freehold" +"CoListOfficeKey": "76840" +"GeocodeManualYN": true +"TotalActualRent": 3350 +"ZoningDescription": "r1" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 2 +"LeaseAmountFrequency": "Monthly" +"FrontageLengthNumeric": 45.0 +"AboveGradeFinishedArea": 1198 +"BelowGradeFinishedArea": 836 +"OriginalEntryTimestamp": "2026-07-20T19:30:10.64Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"BelowGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1328779" +"ListOfficeNationalAssociationId": "1004363" +"CoListAgentNationalAssociationId": "1372011" +"CoListOfficeNationalAssociationId": "1004363" +"Media": array:39 [ 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] ] +"DaysOnMarket": 1 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30056831')" +"ID": "1643667" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24752 +post_id: "1637404" +post_author: 1 +"ListingKey": "30049949" +"ListingId": "40849277" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-21T18:35:18Z" +"RFModificationTimestamp": "2026-07-21T18:36:54Z" +"ListPrice": 0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1569.0 +"BuildingAreaTotal": 0 +"City": "St. Catharines" +"PostalCode": "L2P0G8" +"UnparsedAddress": "146 EVERETT Common, St. Catharines, Ontario L2P0G8" +"Coordinates": array:2 [ 0 => -79.2052314 1 => 43.151103 ] +"Latitude": 43.151103 +"Longitude": -79.2052314 +"YearBuilt": 2026 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Skip the condo and upgrade to a BRAND NEW, 2 LEVEL, 2 BEDROOM, 3 BATHROOM STACKED TOWNHOUSE with almost 1600 SQ FT of luxury with a PRIVATE ATTACHED GARAGE(no elevators, no waiting) and 3 HUGE TERRACES offering over 300 SQ FT of outdoor living space. The stunning OPEN CONCEPT main level is highlighted by a SLEEK MODERN GLASS WALL and walkout from dining room to terrace with glass railing overlooking GREENSPACE. The upper level boasts 2 FULLY APPOINTED BEDROOMS each with a FULL ENSUITE BATH, WALK IN CLOSET and it's own large terrace. Bright sun filled living with extra tall windows throughout. The larger primary bedroom features a huge walk in closet and a spa like ensuite with double sink, floating vanity and shower with glass wall. Tankless water heater means endless showers. Upgraded finishes throughout including durable VINYL PLANK FLOORING, 8 ft doors with sleek black hardware, upgraded trim, IN SUITE LAUNDRY(with full size stackable washer/dryer), easy to clean large upgraded porcelain tiles, STAINLESS STEEL APPLIANCES, gorgeous solid European style front entry door with multi locking system for ADDED SECURITY. Steps to parks and minutes to GO STATION, PEN SHOPPING CENTER, BROCK UNIVERSITY, HOSPITAL, TRANSIT and many desired amenities. 15 min. to Niagara Falls. BRAND NEW PREMIUM LUXURY RENTAL SUITE with all the conveniences you want in a prime location. LOW MAINTENANCE LIVING, PRIVACY and an ABUNDANCE OF INDOOR AND OUTDOOR LIVING SPACE to work, relax and entertain-a rare to find in a rental home. BONUS All Window Coverings have been installed and a Garage door opener as well.. MOVE IN READY (id:62650)" +"AssociationFeeIncludes": array:1 [ 0 => "Insurance" ] +"Basement": array:1 [ 0 => "None" ] +"BathroomsPartial": 1 +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-17T21:29:34.374718+00:00" +"Directions": "Oakdale Ave to Smythe St to Ellis Ave to Everett Common" +"ExteriorFeatures": array:1 [ 0 => "Brick Veneer" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1524047" +"ListOfficeKey": "295206" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Balcony" 1 => "No Pet Home" ] +"ParkingFeatures": array:2 [ 0 => "Attached Garage" 1 => "Visitor Parking" ] +"PhotosChangeTimestamp": "2026-07-17T20:29:10Z" +"PhotosCount": 30 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-21T18:29:37Z" +"Stories": "2.0" +"StreetName": "EVERETT" +"StreetNumber": "146" +"StreetSuffix": "Common" +"SubdivisionName": "456 - Oakdale" +"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/30049949/146-everett-common-st-catharines" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "Row / Townhouse" ] +"CoListAgentKey": "1526952" +"CommonInterest": "Condo/Strata" +"CoListOfficeKey": "295206" +"GeocodeManualYN": true +"TotalActualRent": 2600 +"ZoningDescription": "0" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 0 +"LeaseAmountFrequency": "Monthly" +"AboveGradeFinishedArea": 1569 +"OriginalEntryTimestamp": "2026-07-17T20:29:10.08Z" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Builder" +"ListAgentNationalAssociationId": "1063237" +"ListOfficeNationalAssociationId": "1447908" +"CoListAgentNationalAssociationId": "1139331" +"CoListOfficeNationalAssociationId": "1447908" +"Media": array:30 [ 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] ] +"DaysOnMarket": 4 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30049949')" +"ID": "1637404" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24615 +post_id: "1637704" +post_author: 1 +"ListingKey": "30050105" +"ListingId": "40849274" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-17T20:55:19Z" +"RFModificationTimestamp": "2026-07-17T23:00:42Z" +"ListPrice": 0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 650.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8R2K7" +"UnparsedAddress": "154 JAMES Street N Unit# 4, Hamilton, Ontario L8R2K7" +"Coordinates": array:2 [ 0 => -79.8671709 1 => 43.2605916 ] +"Latitude": 43.2605916 +"Longitude": -79.8671709 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "LOCATION, LOCATION, LOCATION…Available Immediately! Newly renovated Studio style apartment located directly on James St. North (right on James and Cannon St intersection). This amazing unit features an open concept with a modern kitchen complete with stainless steel appliances, full bath and in-suite laundry. Conveniently located in the trending James Street neighbourhood, this unit is close to all the amenities such as local restaurants, arts, culture and a 10 minute walk to the West Harbour Go Station. There is no parking offered or available within the building. There are city and private lots available nearby for overnight parking. (id:62650)" +"Appliances": array:5 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Stove" 3 => "Dryer" 4 => "Hood Fan" ] +"AssociationFeeIncludes": array:1 [ 0 => "Insurance" ] +"Basement": array:1 [ 0 => "None" ] +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"Cooling": array:1 [ 0 => "Wall unit" ] +"CreationDate": "2026-07-17T23:00:31.683950+00:00" +"Directions": "At the intersection of James St N and Cannon St" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:3 [ 0 => "Heat Pump" 1 => "Baseboard heaters" 2 => "Electric" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2235792" +"ListOfficeKey": "55167" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "No Pet Home" ] +"ParkingFeatures": array:1 [ 0 => "None" ] +"PhotosChangeTimestamp": "2026-07-17T20:48:12Z" +"PhotosCount": 12 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-17T20:48:12Z" +"Stories": "1.0" +"StreetDirSuffix": "North" +"StreetName": "JAMES" +"StreetNumber": "154" +"StreetSuffix": "Street" +"SubdivisionName": "101 - Strathcona Central North" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:3 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30050105/154-james-street-n-unit-4-hamilton" +"StructureType": array:1 [ 0 => "Apartment" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"TotalActualRent": 1400 +"ZoningDescription": "D2" +"BedroomsAboveGrade": 0 +"BedroomsBelowGrade": 0 +"LeaseAmountFrequency": "Monthly" +"FrontageLengthNumeric": 26.0 +"AboveGradeFinishedArea": 650 +"OriginalEntryTimestamp": "2026-07-17T20:48:12.87Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Owner" +"ListAgentNationalAssociationId": "1473714" +"ListOfficeNationalAssociationId": "1003582" +"Media": array:12 [ 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] ] +"DaysOnMarket": 4 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30050105')" +"ID": "1637704" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24597 +post_id: "1639490" +post_author: 1 +"ListingKey": "30049916" +"ListingId": "40849271" +"PropertyType": "Other" +"PropertySubType": "Other" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-20T16:15:08Z" +"RFModificationTimestamp": "2026-07-20T16:25:04Z" +"ListPrice": 0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 1.08 +"LivingArea": 1554.0 +"BuildingAreaTotal": 0 +"City": "Cambridge" +"PostalCode": "N1R5S7" +"UnparsedAddress": "75 ROBINSON Road Unit# B, Cambridge, Ontario N1R5S7" +"Coordinates": array:2 [ 0 => -80.2622359 1 => 43.3621559 ] +"Latitude": 43.3621559 +"Longitude": -80.2622359 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "This unique leasing opportunity at 75 Robinson Road offers a quaint and cozy home with an expansive, professional-grade workshop, providing a perfect opportunity for hobbyists whether you are looking for a dedicated space for a home-based business or a serious workshop setup. The 28' x 26' workshop offers a vast workspace with high ceilings, durable flooring, and ample natural light. Wide entry points allow for the easy movement of large-scale projects, materials, or equipment, making it as practical as it is versatile. This exceptional structure significantly enhances the property's overall functionality, offering peaceful country living with wide-open space while remaining minutes from local amenities and attractions. (id:62650)" +"AssociationFeeIncludes": array:2 [ 0 => "Heat" 1 => "Water" ] +"Basement": array:1 [ 0 => "Full" ] +"BuildingAreaUnits": "square feet" +"CreationDate": "2026-07-17T23:11:28.362259+00:00" +"Directions": "Main Street to Robinson Road" +"ExteriorFeatures": array:1 [ 0 => "Stone" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1750685" +"ListOfficeKey": "286753" +"LivingAreaUnits": "square feet" +"LotSizeDimensions": "1.08" +"ParkingFeatures": array:1 [ 0 => "Detached Garage" ] +"PhotosChangeTimestamp": "2026-07-20T16:13:42Z" +"PhotosCount": 27 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-20T16:13:42Z" +"Stories": "1.0" +"StreetName": "ROBINSON" +"StreetNumber": "75" +"StreetSuffix": "Road" +"SubdivisionName": "70 - Branchton/Littles Corners/Maple Manor Subdivision/Ranchlands" +"Utilities": array:2 [ 0 => "Natural Gas" 1 => "Electricity" ] +"WaterSource": array:1 [ 0 => "Well" ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30049916/75-robinson-road-unit-b-cambridge" +"ParkingTotal": 3 +"StructureType": array:1 [ 0 => "Residential Commercial Mix" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"TotalActualRent": 3400 +"ExistingLeaseType": array:1 [ 0 => "Gross" ] +"ZoningDescription": "R1" +"LeaseAmountFrequency": "Monthly" +"FrontageLengthNumeric": 119.0 +"OriginalEntryTimestamp": "2026-07-17T20:18:21.89Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1131083" +"ListOfficeNationalAssociationId": "1363559" +"Media": array:27 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] ] +"DaysOnMarket": 4 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30049916')" +"ID": "1639490" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24749 +post_id: "1641369" +post_author: 1 +"ListingKey": "30054983" +"ListingId": "40849269" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-20T17:05:22Z" +"RFModificationTimestamp": "2026-07-20T17:08:43Z" +"ListPrice": 700000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 2204.0 +"BuildingAreaTotal": 0 +"City": "Kitchener" +"PostalCode": "N2H1Y3" +"UnparsedAddress": "111 FILBERT Street, Kitchener, Ontario N2H1Y3" +"Coordinates": array:2 [ 0 => -80.4768503 1 => 43.4569362 ] +"Latitude": 43.4569362 +"Longitude": -80.4768503 +"YearBuilt": 1935 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Stop the car! The street appeal of this timeless East Ward home will take your breath away! Are you a fan of Century homes on large lots with incredible woodwork frozen in time? Then this home has to be #1 on your viewing list. This home offers 3 generous sized bedrooms on the upper level PLUS a staircase up to a finished attic space. Here you will find a quiet retreat (17' x 14') that can be expanded into the unfinished storage area. The upper level also offers a large 4 piece bathroom with a tub/shower combo with attractive ceramic tile finish. The Primary bedroom gives you a cheater ensuite door into this bathroom and a walkout to an unfinished elevated room that could make a fantastic walk-in closet! Let's wander around the main floor. The exposed original oak hardwood floors, the gumwood trims, baseboard and doors are original and stunning. Are you a fan of etched glass pocket French doors? We have 3 of them in pristine condition. Personally, I'm in love with the swinging Butler's Pantry door giving access between the kitchen and the spacious formal dining room. Your kitchen features wooden cabinetry, a unique 1 piece L-shaped stainless steel countertop and a double sink with a Pantry faucet! Do you work from home? You will immediately see the benefit of the 12' x 6' den at the rear of the home. It has a separate side entry door making it perfect if you have a need for clients to visit your office. There is a full basement where you will find a recreation room, a 2 piece bathroom, a large utility/boiler room and great storage space. Here are just some of the updates and extras that you will enjoy. All windows (except for the basement) have been replaced with era appropriate vinyl windows finished with muntins. The Viessmann hot water boiler was replaced in 2017, garage door (2018), roof shingles (2018), electric meter and 100 amp breaker panel (2009) and an extra long, concrete driveway with an oversized single car garage with opener! (id:62650)" +"Appliances": array:3 [ 0 => "Water softener" 1 => "Window Coverings" 2 => "Garage door opener" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "School Bus" ] +"Cooling": array:1 [ 0 => "None" ] +"CreationDate": "2026-07-20T15:52:17.329772+00:00" +"Directions": "Edna St to Frederick St to Filbert Street" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Aluminum siding" ] +"Fencing": array:1 [ 0 => "Fence" ] +"Heating": array:1 [ 0 => "Hot water radiator heat" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1563599" +"ListOfficeKey": "76831" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:1 [ 0 => "Detached Garage" ] +"PhotosChangeTimestamp": "2026-07-20T15:33:07Z" +"PhotosCount": 50 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-20T16:59:27Z" +"Stories": "2.0" +"StreetName": "FILBERT" +"StreetNumber": "111" +"StreetSuffix": "Street" +"SubdivisionName": "212 - Downtown Kitchener/East Ward" +"TaxAnnualAmount": "4991" +"VirtualTourURLUnbranded": "https://paulreibelphotography.hd.pics/111-Filbert-St" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:12 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30054983/111-filbert-street-kitchener" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "R-5 129U" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 48.0 +"AboveGradeFinishedArea": 2204 +"OriginalEntryTimestamp": "2026-07-20T15:29:39.98Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1069893" +"ListOfficeNationalAssociationId": "1004391" +"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": 1 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30054983')" +"ID": "1641369" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24616 +post_id: "1637123" +post_author: 1 +"ListingKey": "30050154" +"ListingId": "40849267" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-20T22:40:03Z" +"RFModificationTimestamp": "2026-07-20T22:45:24Z" +"ListPrice": 899900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 2160.0 +"BuildingAreaTotal": 0 +"City": "Orangeville" +"PostalCode": "L9W3B3" +"UnparsedAddress": "9 FAIRVIEW Place, Orangeville, Ontario L9W3B3" +"Coordinates": array:2 [ 0 => -80.1104115 1 => 43.9209634 ] +"Latitude": 43.9209634 +"Longitude": -80.1104115 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 9 Fairview Place—a beautifully renovated and meticulously upgraded home offering exceptional style, comfort, and income potential. Thoughtfully updated throughout, this impressive property features exterior stucco (2022), a stunning new kitchen (2019), new windows, upgraded lighting including interior and exterior pot lights, attic insulation, a regraded backyard with an upgraded patio and new shed, a new front door (2025) with a 25-year warranty, upgraded lighting including interior and exterior pot lights, new eavestroughs with leaf guards and a newer refrigerator with an extended warranty until 2030. The spacious lower level offers an incredible two-bedroom basement apartment with a separate entrance, full kitchen, laundry room, and permits applied for—making it ideal for extended family or future rental income. Additional highlights include two gas fireplaces, a newer furnace with an integrated smoke detector system, and central air conditioning. Situated on a quiet cul-de-sac, this home features a private, fully fenced backyard that's perfect for entertaining, family gatherings, or simply relaxing. Every renovation has been completed with exceptional attention to detail. The beautifully appointed kitchen showcases stainless steel appliances, including a gas stove and built-in microwave/range hood, and is conveniently plumbed and vented for a second laundry area. Ideally located within walking distance of schools and parks, and just minutes from shopping and everyday amenities, this outstanding home truly checks every box. Move-in ready and sure to impress—this is one you won't want to miss! (id:62650)" +"Appliances": array:9 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Gas stove(s)" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" 6 => "Window Coverings" 7 => "Garage door opener" 8 => "Microwave Built-in" ] +"ArchitecturalStyle": array:1 [ 0 => "Raised bungalow" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-17T21:21:01.361434+00:00" +"Directions": "BLIND LINE TO COLLEGE AVE. TO BIRCH ST. TO FAIRVIEW PLACE" +"ExteriorFeatures": array:1 [ 0 => "Stone" ] +"Fencing": array:1 [ 0 => "Fence" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1618283" +"ListOfficeKey": "284622" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Automatic Garage Door Opener" 1 => "In-Law Suite" 2 => "Private Yard" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-07-20T22:31:35Z" +"PhotosCount": 33 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-20T22:31:35Z" +"Stories": "1.0" +"StreetName": "FAIRVIEW" +"StreetNumber": "9" +"StreetSuffix": "Place" +"SubdivisionName": "Orangeville" +"TaxAnnualAmount": "6544.93" +"Utilities": array:4 [ 0 => "Natural Gas" 1 => "Electricity" 2 => "Cable" 3 => "Telephone" ] +"VirtualTourURLUnbranded": "https://player.vimeo.com/video/1210868442" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:12 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30050154/9-fairview-place-orangeville" +"ParkingTotal": 8 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "R2" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 2 +"FrontageLengthNumeric": 59.0 +"AboveGradeFinishedArea": 1212 +"BelowGradeFinishedArea": 948 +"OriginalEntryTimestamp": "2026-07-17T20:59:39.73Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Assessor" +"BelowGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1272645" +"ListOfficeNationalAssociationId": "1343471" +"Media": array:33 [ 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] ] +"DaysOnMarket": 4 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30050154')" +"ID": "1637123" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24621 +post_id: "1637124" +post_author: 1 +"ListingKey": "30050155" +"ListingId": "40849266" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-17T21:05:17Z" +"RFModificationTimestamp": "2026-07-17T21:20:36Z" +"ListPrice": 0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 450.0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L0K2" +"UnparsedAddress": "257 HEMLOCK Street Unit# 417, Waterloo, Ontario N2L0K2" +"Coordinates": array:2 [ 0 => -80.5318621 1 => 43.4755393 ] +"Latitude": 43.4755393 +"Longitude": -80.5318621 +"YearBuilt": 2019 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Sage condos in Waterloo's student district offers a prime location just minutes away from the University of Waterloo, Wilfrid Laurier University, and Conestoga College Waterloo campuses. This fully furnished unit includes a double bed, desk/workspace with chair, sofa, TV, dining table with chairs, and window blinds. In-suite laundry, stainless steel appliances, and granite countertops are included. Rent covers all utilities except internet. Building amenities include a fitness center, social lounge, meeting tables, study room, and rooftop patio. Close to parks, restaurants, and shopping. 1 Parking space available for rent via property management. (id:62650)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Window Coverings" 6 => "Microwave Built-in" ] +"AssociationFeeIncludes": array:5 [ 0 => "Heat" 1 => "Electricity" 2 => "Water" 3 => "Insurance" 4 => "Other, See Remarks" ] +"Basement": array:1 [ 0 => "None" ] +"CommunityFeatures": array:1 [ 0 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-17T21:20:34.464134+00:00" +"Directions": "University Ave S to Hemlock St" +"ExteriorFeatures": array:1 [ 0 => "Concrete" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2204824" +"ListOfficeKey": "277572" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Balcony" 1 => "Gazebo" ] +"ParkingFeatures": array:2 [ 0 => "Open" 1 => "Visitor Parking" ] +"PhotosChangeTimestamp": "2026-07-17T20:59:39Z" +"PhotosCount": 21 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-17T20:59:39Z" +"Stories": "1.0" +"StreetName": "HEMLOCK" +"StreetNumber": "257" +"StreetSuffix": "Street" +"SubdivisionName": "114 - Uptown Waterloo/North Ward" +"TaxAnnualAmount": "2699" +"View": "City view" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:4 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30050155/257-hemlock-street-unit-417-waterloo" +"StructureType": array:1 [ 0 => "Apartment" ] +"CoListAgentKey": "1750692" +"CommonInterest": "Condo/Strata" +"CoListOfficeKey": "277572" +"GeocodeManualYN": true +"TotalActualRent": 1850 +"BuildingFeatures": array:1 [ 0 => "Exercise Centre" ] +"ZoningDescription": "NMU6" +"BedroomsAboveGrade": 1 +"BedroomsBelowGrade": 0 +"LeaseAmountFrequency": "Monthly" +"AboveGradeFinishedArea": 450 +"OriginalEntryTimestamp": "2026-07-17T20:59:39.87Z" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1453437" +"ListOfficeNationalAssociationId": "1285375" +"CoListAgentNationalAssociationId": "1117625" +"CoListOfficeNationalAssociationId": "1285375" +"Media": array:21 [ 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] ] +"DaysOnMarket": 4 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30050155')" +"ID": "1637124" } ] +success: true +page_size: 12 +page_count: 19190 +count: 230270 +after_key: "" } "RF Response Time" => "0.28 seconds" ] ]