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=175992&$filter=InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24605 +items: array:12 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24730 +post_id: "1638384" +post_author: 1 +"ListingKey": "30049316" +"ListingId": "40848859" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-20T14:50:10Z" +"RFModificationTimestamp": "2026-07-20T14:52:11Z" +"ListPrice": 649000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1341.0 +"BuildingAreaTotal": 0 +"City": "Stoney Creek" +"PostalCode": "L8E0C3" +"UnparsedAddress": "128 PALACEBEACH Trail, Stoney Creek, Ontario L8E0C3" +"Coordinates": array:2 [ 0 => -79.6772597 1 => 43.2279711 ] +"Latitude": 43.2279711 +"Longitude": -79.6772597 +"YearBuilt": 2012 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to lakeside living, just steps from Lake Ontario in Stoney Creek! This immaculate freehold townhome is the perfect home, boasting excellent layout with 3 spacious bedrooms, upstairs laundry, and inside access to the garage. The bright living spaces flow effortlessly to a large, private backyard ideal for entertaining. Loaded with premium updates, the home features brand-new designer light fixtures, a newer roof (2023), and newer stainless steel appliances (2024). Located in a quieter, premium neighbourhood just minutes from Fifty Point, Costco, major retail, and the QEW for an easy commute to Toronto or Niagara - This is the ideal home for a family wanting to live in a peaceful lakeside community. (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Window Coverings" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"BathroomsPartial": 1 +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-17T23:15:11.539402+00:00" +"Directions": "Fruitland - North Service Rd - Dartmouth" +"ExteriorFeatures": array:1 [ 0 => "Brick Veneer" ] +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2197911" +"ListOfficeKey": "294490" +"LivingAreaUnits": "square feet" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-07-20T14:41:21Z" +"PhotosCount": 34 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-20T14:41:21Z" +"Stories": "2.0" +"StreetName": "PALACEBEACH" +"StreetNumber": "128" +"StreetSuffix": "Trail" +"SubdivisionName": "510 - Community Beach/Fifty Point" +"TaxAnnualAmount": "4552.1" +"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=Xx3Xujnnc6A" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:9 [ 0 => array:11 [ "RoomKey" => "1686990828" "RoomType" => "4pc Bathroom" "ListingId" => "40848859" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "30049316" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T20:08:33.59Z" ] 1 => array:11 [ "RoomKey" => "1686990829" "RoomType" => "3pc Bathroom" "ListingId" => "40848859" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "30049316" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T20:08:33.59Z" ] 2 => array:11 [ "RoomKey" => "1686990830" "RoomType" => "2pc Bathroom" "ListingId" => "40848859" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30049316" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T20:08:33.59Z" ] 3 => array:11 [ "RoomKey" => "1686990831" "RoomType" => "Bedroom" "ListingId" => "40848859" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "30049316" "RoomLength" => null "RoomDimensions" => "10'3'' x 12'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T20:08:33.59Z" ] 4 => array:11 [ "RoomKey" => "1686990832" "RoomType" => "Bedroom" "ListingId" => "40848859" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "30049316" "RoomLength" => null "RoomDimensions" => "9'6'' x 10'7''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T20:08:33.59Z" ] 5 => array:11 [ "RoomKey" => "1686990833" "RoomType" => "Primary Bedroom" "ListingId" => "40848859" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "30049316" "RoomLength" => null "RoomDimensions" => "13'9'' x 13'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T20:08:33.59Z" ] 6 => array:11 [ "RoomKey" => "1686990834" "RoomType" => "Dining room" "ListingId" => "40848859" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30049316" "RoomLength" => null "RoomDimensions" => "8'3'' x 8'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T20:08:33.59Z" ] 7 => array:11 [ "RoomKey" => "1686990835" "RoomType" => "Kitchen" "ListingId" => "40848859" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30049316" "RoomLength" => null "RoomDimensions" => "8'3'' x 11'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T20:08:33.6Z" ] 8 => array:11 [ "RoomKey" => "1686990836" "RoomType" => "Living room" "ListingId" => "40848859" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30049316" "RoomLength" => null "RoomDimensions" => "11'3'' x 20'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T20:08:33.6Z" ] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30049316/128-palacebeach-trail-stoney-creek" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "Row / Townhouse" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "RM2-27" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 21.0 +"AboveGradeFinishedArea": 1341 +"OriginalEntryTimestamp": "2026-07-17T18:48:17.15Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1446283" +"ListOfficeNationalAssociationId": "1439453" +"Media": array:34 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "30049316_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/d5e3239550096d8a2952d0e3aaf21146.webp" "MediaSize" => 98926 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-d5e3239550096d8a2952d0e3aaf21146.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "30049316_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/3f34ab2801c7eac99a3295b4ee94b4ec.webp" "MediaSize" => 99761 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-3f34ab2801c7eac99a3295b4ee94b4ec.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "30049316_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/3b15f5f7f5b4ad8818a01073ae696fc8.webp" "MediaSize" => 40865 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-3b15f5f7f5b4ad8818a01073ae696fc8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "30049316_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/83e757cb3f243730e32b045d0d2e93f0.webp" "MediaSize" => 45197 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-83e757cb3f243730e32b045d0d2e93f0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "30049316_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/977ec5b182c32e248aaca894d1241415.webp" "MediaSize" => 89269 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-977ec5b182c32e248aaca894d1241415.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "30049316_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/c80740f05c4f2dc08034a8b2ff925427.webp" "MediaSize" => 80240 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-c80740f05c4f2dc08034a8b2ff925427.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "30049316_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/e777e783b5ed66930a9306069bc02590.webp" "MediaSize" => 72898 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-e777e783b5ed66930a9306069bc02590.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "30049316_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/c305ed1f2acd55dc8c885aed035669b8.webp" "MediaSize" => 78526 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-c305ed1f2acd55dc8c885aed035669b8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "30049316_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/1c2310e520210b9261bda81ba662cf9b.webp" "MediaSize" => 90733 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-1c2310e520210b9261bda81ba662cf9b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "30049316_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/49d5fb346ae66c36a784c6e251897616.webp" "MediaSize" => 85237 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-49d5fb346ae66c36a784c6e251897616.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "30049316_4890_11" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/d7ebc16c9572375dbbb892a34ee9a964.webp" "MediaSize" => 49264 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-d7ebc16c9572375dbbb892a34ee9a964.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "30049316_4890_12" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/731f336fe4e6f011edddcc1200b54106.webp" "MediaSize" => 82237 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-731f336fe4e6f011edddcc1200b54106.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "30049316_4890_13" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/411444f84a1fe151cf68e7832e15dead.webp" "MediaSize" => 44143 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-411444f84a1fe151cf68e7832e15dead.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 13 => array:13 [ "Order" => 14 "MediaKey" => "30049316_4890_14" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/53def323d8beead57a71540bbad2856a.webp" "MediaSize" => 58127 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-53def323d8beead57a71540bbad2856a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 14 => array:13 [ "Order" => 15 "MediaKey" => "30049316_4890_15" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/ccc021ccf72852042bafae3b72c39b33.webp" "MediaSize" => 48254 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-ccc021ccf72852042bafae3b72c39b33.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 15 => array:13 [ "Order" => 16 "MediaKey" => "30049316_4890_16" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/40702f09ed95bcce18f2448115c4a4e5.webp" "MediaSize" => 31364 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-40702f09ed95bcce18f2448115c4a4e5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 16 => array:13 [ "Order" => 17 "MediaKey" => "30049316_4890_17" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/0686ac1463b92aa37e076894f4d48900.webp" "MediaSize" => 66591 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-0686ac1463b92aa37e076894f4d48900.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 17 => array:13 [ "Order" => 18 "MediaKey" => "30049316_4890_18" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/2edff255e93d27425248fbddf530ea65.webp" "MediaSize" => 52066 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-2edff255e93d27425248fbddf530ea65.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 18 => array:13 [ "Order" => 19 "MediaKey" => "30049316_4890_19" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/76bac64bd5cfa849dfb7c790a8a61180.webp" "MediaSize" => 57736 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-76bac64bd5cfa849dfb7c790a8a61180.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 19 => array:13 [ "Order" => 20 "MediaKey" => "30049316_4890_20" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/6587c92fcd9fc3e16b1d6832c13b7437.webp" "MediaSize" => 54131 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-6587c92fcd9fc3e16b1d6832c13b7437.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 20 => array:13 [ "Order" => 21 "MediaKey" => "30049316_4890_21" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/b6e6978e20ede7d76c94e1ee2d025731.webp" "MediaSize" => 52194 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-b6e6978e20ede7d76c94e1ee2d025731.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 21 => array:13 [ "Order" => 22 "MediaKey" => "30049316_4890_22" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/7c3586530bcd5fec6cdcffd42eee0e1b.webp" "MediaSize" => 58921 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-7c3586530bcd5fec6cdcffd42eee0e1b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 22 => array:13 [ "Order" => 23 "MediaKey" => "30049316_4890_23" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/47b2761909f56616e90b116b0aaf13fe.webp" "MediaSize" => 57539 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-47b2761909f56616e90b116b0aaf13fe.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 23 => array:13 [ "Order" => 24 "MediaKey" => "30049316_4890_24" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/82db5488900fcc906b082cd0a9b09c6a.webp" "MediaSize" => 55144 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-82db5488900fcc906b082cd0a9b09c6a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 24 => array:13 [ "Order" => 25 "MediaKey" => "30049316_4890_25" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/25ba1f3f9e77de4b4d052828f153a093.webp" "MediaSize" => 57205 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-25ba1f3f9e77de4b4d052828f153a093.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 25 => array:13 [ "Order" => 26 "MediaKey" => "30049316_4890_26" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/b4923303b812bdfef2cf5b1f0ba7dbb8.webp" "MediaSize" => 78980 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-b4923303b812bdfef2cf5b1f0ba7dbb8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 26 => array:13 [ "Order" => 27 "MediaKey" => "30049316_4890_27" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/42d5d576230175ee60570ebe5172bcfb.webp" "MediaSize" => 74707 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-42d5d576230175ee60570ebe5172bcfb.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 27 => array:13 [ "Order" => 28 "MediaKey" => "30049316_4890_28" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/c3d674449bed841e7fea218a4cf516e7.webp" "MediaSize" => 118927 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-c3d674449bed841e7fea218a4cf516e7.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 28 => array:13 [ "Order" => 29 "MediaKey" => "30049316_4890_29" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/df99ce2a27b6c20e4825f8d04efca501.webp" "MediaSize" => 141851 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-df99ce2a27b6c20e4825f8d04efca501.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 29 => array:13 [ "Order" => 30 "MediaKey" => "30049316_4890_30" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/d85f95d53c761da464f6dfe44bb4e144.webp" "MediaSize" => 137101 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-d85f95d53c761da464f6dfe44bb4e144.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 30 => array:13 [ "Order" => 31 "MediaKey" => "30049316_4890_31" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/725c93a9ebaa2ca1f60334ed397be107.webp" "MediaSize" => 94567 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-725c93a9ebaa2ca1f60334ed397be107.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 31 => array:13 [ "Order" => 32 "MediaKey" => "30049316_4890_32" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/221912f3c39f85be01c2a56be8691a2c.webp" "MediaSize" => 132868 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-221912f3c39f85be01c2a56be8691a2c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 32 => array:13 [ "Order" => 33 "MediaKey" => "30049316_4890_33" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/fc3d011e57d1074f01d5fe861c351767.webp" "MediaSize" => 133367 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-fc3d011e57d1074f01d5fe861c351767.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] 33 => array:13 [ "Order" => 34 "MediaKey" => "30049316_4890_34" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30049316/f3051c408fc1d1d3c56fcd46f45fa12f.webp" "MediaSize" => 119330 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30049316/thumbnail-f3051c408fc1d1d3c56fcd46f45fa12f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848859" "ResourceRecordKey" => "30049316" "ModificationTimestamp" => "2026-07-17T18:48:17.16Z" ] ] +"DaysOnMarket": 3 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30049316')" +"ID": "1638384" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24580 +post_id: "1637810" +post_author: 1 +"ListingKey": "30043665" +"ListingId": "40848858" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-17T20:20:09Z" +"RFModificationTimestamp": "2026-07-17T23:18:51Z" +"ListPrice": 720000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1882.0 +"BuildingAreaTotal": 0 +"City": "Kitchener" +"PostalCode": "N2E3S4" +"UnparsedAddress": "425 ERINBROOK Drive, Kitchener, Ontario N2E3S4" +"Coordinates": array:2 [ 0 => -80.4958811 1 => 43.4074537 ] +"Latitude": 43.4074537 +"Longitude": -80.4958811 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 425 Erinbrook Drive, a beautifully maintained detached 2-storey home in the highly desirable Erinbrook/Country Hillsneighbourhood, offering a perfect blend of comfort, style, and outdoor living. This move-in ready family home features a bright open-conceptmain floor with laminate flooring, pot lights (installed 2024), spacious principal rooms, and a well-appointed kitchen complete with modernfinishes, ample cabinetry, and a functional layout ideal for everyday living and entertaining. Upstairs offers generous bedrooms including aspacious primary retreat and well-sized family bedrooms, ideal for growing families, first-time buyers, or investors alike. Pride of ownership isevident throughout with tasteful décor and thoughtful care. Step outside and enjoy the incredible private backyard oasis featuring a custommulti-level deck, pergola lounge, and built-in entertaining areas. This beautifully designed outdoor space is perfect for summer gatherings, quietevenings, and creating lasting family memories, truly a standout feature at this price point. Located in a sought-after, family-friendly communityclose to top-rated schools, parks, playgrounds, walking trails, and recreation. Enjoy proximity to shopping plazas, grocery stores, restaurants, CFFairview Park Mall, public transit, and Conestoga College, with quick access to Highway 8 and Highway 401 for easy commuting. Recent Updates& Inclusions: Pot lights (kitchen & hall) – 2024 Dishwasher – 2024 Washer & Dryer – 2025 Microwave – 2026 Air Conditioner & Furnace – 2012Rental Items: Water Heater – installed 2024 (rental) Water Softener – installed 2021 (rental) This exceptional home offers the complete packageof location, lifestyle, and value in one of Kitchener’s most convenient neighbourhoods. Opportunities like this don’t come often. Move in andenjoy everything 425 Erinbrook Drive has to offer! (id:62650)" +"Appliances": array:8 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" 6 => "Microwave" 7 => "Hood Fan" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-17T23:18:42.600619+00:00" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2166403" +"ListOfficeKey": "291669" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Paved driveway" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-07-16T18:59:53Z" +"PhotosCount": 34 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-17T20:08:33Z" +"Stories": "2.0" +"StreetName": "ERINBROOK" +"StreetNumber": "425" +"StreetSuffix": "Drive" +"SubdivisionName": "333 - Laurentian Hills/Country Hills W" +"TaxAnnualAmount": "3867" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:10 [ 0 => array:11 [ "RoomKey" => "1686990837" "RoomType" => "4pc Bathroom" "ListingId" => "40848858" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "30043665" "RoomLength" => null "RoomDimensions" => "4'0'' x 9'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T20:08:33.73Z" ] 1 => array:11 [ "RoomKey" => "1686990838" "RoomType" => "Bedroom" "ListingId" => "40848858" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "30043665" "RoomLength" => null "RoomDimensions" => "8'0'' x 10'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T20:08:33.73Z" ] 2 => array:11 [ "RoomKey" => "1686990839" "RoomType" => "Family room" "ListingId" => "40848858" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "30043665" "RoomLength" => null "RoomDimensions" => "16'0'' x 20'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T20:08:33.73Z" ] 3 => array:11 [ "RoomKey" => "1686990840" "RoomType" => "4pc Bathroom" "ListingId" => "40848858" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "30043665" "RoomLength" => null "RoomDimensions" => "5' x 9'" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T20:08:33.73Z" ] 4 => array:11 [ "RoomKey" => "1686990841" "RoomType" => "Bedroom" "ListingId" => "40848858" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "30043665" "RoomLength" => null "RoomDimensions" => "9'0'' x 11'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T20:08:33.73Z" ] 5 => array:11 [ "RoomKey" => "1686990842" "RoomType" => "Bedroom" "ListingId" => "40848858" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "30043665" "RoomLength" => null "RoomDimensions" => "9'0'' x 13'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T20:08:33.73Z" ] 6 => array:11 [ "RoomKey" => "1686990843" "RoomType" => "Primary Bedroom" "ListingId" => "40848858" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "30043665" "RoomLength" => null "RoomDimensions" => "12'0'' x 15'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T20:08:33.73Z" ] 7 => array:11 [ "RoomKey" => "1686990844" "RoomType" => "2pc Bathroom" "ListingId" => "40848858" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30043665" "RoomLength" => null "RoomDimensions" => "3' x 6'" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T20:08:33.73Z" ] 8 => array:11 [ "RoomKey" => "1686990845" "RoomType" => "Kitchen" "ListingId" => "40848858" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30043665" "RoomLength" => null "RoomDimensions" => "14'0'' x 16'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T20:08:33.74Z" ] 9 => array:11 [ "RoomKey" => "1686990846" "RoomType" => "Family room" "ListingId" => "40848858" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30043665" "RoomLength" => null "RoomDimensions" => "13'0'' x 18'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-17T20:08:33.74Z" ] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30043665/425-erinbrook-drive-kitchener" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R6" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 25.0 +"AboveGradeFinishedArea": 1282 +"BelowGradeFinishedArea": 600 +"OriginalEntryTimestamp": "2026-07-16T18:59:53.39Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Owner" +"BelowGradeFinishedAreaSource": "Owner" +"ListAgentNationalAssociationId": "1417310" +"ListOfficeNationalAssociationId": "1401824" +"Media": array:34 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "30043665_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043665/9e536e7bff1a886dc780453afdebc7a2.webp" "MediaSize" => 118873 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043665/thumbnail-9e536e7bff1a886dc780453afdebc7a2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Two-story residence featuring a combination siding and stucco facade, an attached single-car garage, a covered front porch with white railing, a concrete driveway, and a paved walkway" "PreferredPhotoYN" => true "ResourceRecordId" => "40848858" "ResourceRecordKey" => "30043665" "ModificationTimestamp" => "2026-07-16T18:59:53.39Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "30043665_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043665/70f99038f40268ffe44ebd3e00b4fb18.webp" "MediaSize" => 118903 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043665/thumbnail-70f99038f40268ffe44ebd3e00b4fb18.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Two-story residence featuring a brick facade with light gray siding, an attached garage, and a covered front porch with white railings" "PreferredPhotoYN" => false "ResourceRecordId" => "40848858" "ResourceRecordKey" => "30043665" "ModificationTimestamp" => "2026-07-16T18:59:53.39Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "30043665_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043665/52478cd1b1f0308a65594a9b150cf91d.webp" "MediaSize" => 53446 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043665/thumbnail-52478cd1b1f0308a65594a9b150cf91d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Entryway featuring wood-finish flooring, a white paneled door with integrated blinds, and two additional white doors" "PreferredPhotoYN" => false "ResourceRecordId" => "40848858" "ResourceRecordKey" => "30043665" "ModificationTimestamp" => "2026-07-16T18:59:53.39Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "30043665_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043665/5b1b79d06a37a226cb96bc832322386b.webp" "MediaSize" => 52151 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043665/thumbnail-5b1b79d06a37a226cb96bc832322386b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Hallway featuring light-toned flooring, white baseboards, and a recessed ceiling light" "PreferredPhotoYN" => false "ResourceRecordId" => "40848858" "ResourceRecordKey" => "30043665" "ModificationTimestamp" => "2026-07-16T18:59:53.39Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "30043665_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043665/466cc49aa46e4f9eaa385e698ddb0422.webp" "MediaSize" => 52233 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043665/thumbnail-466cc49aa46e4f9eaa385e698ddb0422.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bathroom featuring a white toilet, wood-finish flooring, a dark wood-finish vanity with a white countertop, and an oval sink with a chrome faucet" "PreferredPhotoYN" => false "ResourceRecordId" => "40848858" "ResourceRecordKey" => "30043665" "ModificationTimestamp" => "2026-07-16T18:59:53.39Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "30043665_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043665/221423af21b843b7dab70afbb8eec612.webp" "MediaSize" => 52982 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043665/thumbnail-221423af21b843b7dab70afbb8eec612.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40848858" "ResourceRecordKey" => "30043665" "ModificationTimestamp" => "2026-07-16T18:59:53.39Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "30043665_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043665/ed032c2772db3c308935dbb8d62b0e3d.webp" "MediaSize" => 103692 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043665/thumbnail-ed032c2772db3c308935dbb8d62b0e3d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Living area with wood-finish flooring, recessed lighting, and white walls" "PreferredPhotoYN" => false "ResourceRecordId" => "40848858" "ResourceRecordKey" => "30043665" "ModificationTimestamp" => "2026-07-16T18:59:53.39Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "30043665_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043665/75e4c1ea5ff2f93072d517980886ca0b.webp" "MediaSize" => 87486 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30043665/thumbnail-75e4c1ea5ff2f93072d517980886ca0b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Spacious living area featuring recessed lighting, dark wood-finish flooring, and light-colored walls" "PreferredPhotoYN" => false "ResourceRecordId" => "40848858" "ResourceRecordKey" => "30043665" "ModificationTimestamp" => "2026-07-16T18:59:53.39Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "30043665_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30043665/00f6ec99df88e3ecdc72dcfbb83dfb37.webp" "MediaSize" => 86925 "MediaType" => "webp" …8 ] 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] ] +"DaysOnMarket": 4 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30043665')" +"ID": "1637810" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24718 +post_id: "1643220" +post_author: 1 +"ListingKey": "30057338" +"ListingId": "40848855" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-20T20:45:03Z" +"RFModificationTimestamp": "2026-07-20T23:02:48Z" +"ListPrice": 550000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1435.0 +"BuildingAreaTotal": 0 +"City": "Kitchener" +"PostalCode": "N2R1W7" +"UnparsedAddress": "520 BANFFSHIRE Crescent, Kitchener, Ontario N2R1W7" +"Coordinates": array:2 [ 0 => -80.4727066 1 => 43.3852403 ] +"Latitude": 43.3852403 +"Longitude": -80.4727066 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Located in Huron Park this well laid out 3 bedroom 4 bathroom FREEHOLD townhouse is a great starter home or investment property. Open concept main level boasts a kitchen, living/dining room combo with patio doors leading out to a fenced backyard. The upper level comprises of 3 nice size bedrooms with master large enough for king size bed, walk-in closet and spacious en-suite. The lower level is all complete with 3pc bathroom. (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-20T23:02:42.723235+00:00" +"Directions": "Banffshire St." +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1768640" +"ListOfficeKey": "76807" +"LivingAreaUnits": "square feet" +"LotSizeDimensions": "0" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-07-20T20:38:19Z" +"PhotosCount": 1 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-20T20:38:19Z" +"Stories": "2.0" +"StreetName": "BANFFSHIRE" +"StreetNumber": "520" +"StreetSuffix": "Crescent" +"SubdivisionName": "335 - Pioneer Park/Doon/Wyldwoods" +"TaxAnnualAmount": "4152" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:11 [ 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] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30057338/520-banffshire-crescent-kitchener" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "Row / Townhouse" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R6" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 18.0 +"AboveGradeFinishedArea": 1435 +"OriginalEntryTimestamp": "2026-07-20T20:38:19.34Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1185878" +"ListOfficeNationalAssociationId": "1004370" +"Media": array:1 [ 0 => array:13 [ …13] ] +"DaysOnMarket": 0 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30057338')" +"ID": "1643220" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24598 +post_id: "1639287" +post_author: 1 +"ListingKey": "30049920" +"ListingId": "40848853" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-17T20:25:20Z" +"RFModificationTimestamp": "2026-07-17T23:11:34Z" +"ListPrice": 0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1147.0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2V0G9" +"UnparsedAddress": "142 FOAMFLOWER Place Unit# 36, Waterloo, Ontario N2V0G9" +"Coordinates": array:2 [ 0 => -80.5883282 1 => 43.449943 ] +"Latitude": 43.449943 +"Longitude": -80.5883282 +"YearBuilt": 2024 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to luxury living in the highly sought-after Vista Hills community of West Waterloo. This stunning executive stacked townhouse offers the perfect blend of modern design, comfort, and convenience. Featuring 3 spacious bedrooms and 2.5 bathrooms, this beautifully maintained home boasts an open-concept layout designed for today's lifestyle. The bright and inviting main floor is carpet-free and showcases a stylish kitchen complete with elegant quartz countertops, abundant cabinetry, a large center island with breakfast bar seating, and plenty of workspace for entertaining or everyday living. The spacious living and dining areas flow seamlessly to private outdoor spaces, with two balconies providing the perfect setting to enjoy your morning coffee or unwind after a long day. Upstairs, the primary retreat offers a luxurious ensuite bathroom featuring a sleek glass-enclosed shower, creating a spa-like experience in the comfort of your own home. Located in one of Waterloo's most desirable neighborhoods, Vista Hills is known for its top-rated schools, scenic walking trails, parks, and close proximity to shopping, dining, universities, and major commuter routes. xWhether you're a professional, growing family, or savvy investor, this exceptional home delivers the perfect combination of style, functionality, and an unbeatable location. Don't miss your opportunity to own in one of West Waterloo's premier communities. (id:62650)" +"Appliances": array:5 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" ] +"AssociationFee": "346.55" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:1 [ 0 => "Insurance" ] +"Basement": array:1 [ 0 => "None" ] +"BathroomsPartial": 1 +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-17T23:11:16.005412+00:00" +"Directions": "Columbia St W to Ladyslipper Dr, Ladyslipper Dr to Foamflower" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"Heating": array:1 [ 0 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1878382" +"ListOfficeKey": "283125" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Balcony" ] +"ParkingFeatures": array:1 [ 0 => "Open" ] +"PhotosChangeTimestamp": "2026-07-17T20:18:24Z" +"PhotosCount": 23 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-17T20:18:24Z" +"Stories": "3.0" +"StreetName": "FOAMFLOWER" +"StreetNumber": "142" +"StreetSuffix": "Place" +"SubdivisionName": "443 - Columbia Forest/Clair Hills" +"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/30049920/142-foamflower-place-unit-36-waterloo" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "Row / Townhouse" ] +"CommonInterest": "Condo/Strata" +"GeocodeManualYN": true +"TotalActualRent": 2450 +"ZoningDescription": "R9 R6-FT" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 0 +"LeaseAmountFrequency": "Monthly" +"AboveGradeFinishedArea": 1147 +"OriginalEntryTimestamp": "2026-07-17T20:18:24.74Z" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Builder" +"ListAgentNationalAssociationId": "1205009" +"ListOfficeNationalAssociationId": "1324759" +"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": 3 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30049920')" +"ID": "1639287" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24592 +post_id: "1637951" +post_author: 1 +"ListingKey": "30046637" +"ListingId": "40848851" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-20T21:00:06Z" +"RFModificationTimestamp": "2026-07-20T21:13:28Z" +"ListPrice": 249900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1618.0 +"BuildingAreaTotal": 0 +"City": "St. Catharines" +"PostalCode": "L2R4A6" +"UnparsedAddress": "37 PAGE Street, St. Catharines, Ontario L2R4A6" +"Coordinates": array:2 [ 0 => -79.2342099 1 => 43.1659275 ] +"Latitude": 43.1659275 +"Longitude": -79.2342099 +"YearBuilt": 1870 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Great lot. Even better price. This detached bungalow sits on a deep 38.7 x 107.35 ft lot in central St. Catharines and offers 3 bedrooms, 1 bathroom, and original character throughout. A striped awning shades the covered front porch, and inside, original wood-panel ceilings, hardwood flooring, and a period tile-accented kitchen backsplash showcase the home's long history. The eat-in kitchen offers painted cabinetry, a gas range, and room to gather, while a screened porch off the front adds a sunny spot to unwind. Three bedrooms and a full bathroom round out the main floor, along with a dedicated laundry area. Out back, a private yard is framed by mature trees and fencing, with a detached garage at the rear offering extra storage or workshop space. The home is serviced by municipal water and sewer and a natural gas furnace. This is a home with room to make it your own, at a price point that leaves budget for updates. (id:62650)" +"Appliances": array:5 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Stove" 3 => "Dryer" 4 => "Window Coverings" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Partial" ] +"CommunityFeatures": array:2 [ 0 => "School Bus" 1 => "Community Centre" ] +"Cooling": array:1 [ 0 => "None" ] +"CreationDate": "2026-07-17T23:16:10.904689+00:00" +"ExteriorFeatures": array:2 [ 0 => "Stucco" 1 => "Brick Veneer" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1525086" +"ListOfficeKey": "284641" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Paved driveway" ] +"ParkingFeatures": array:1 [ 0 => "Detached Garage" ] +"PhotosChangeTimestamp": "2026-07-20T20:51:44Z" +"PhotosCount": 23 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-20T20:51:44Z" +"Stories": "1.0" +"StreetName": "PAGE" +"StreetNumber": "37" +"StreetSuffix": "Street" +"SubdivisionName": "450 - E. Chester" +"TaxAnnualAmount": "2486.96" +"VirtualTourURLUnbranded": "https://book.allisonmediaco.com/sites/37-page-st-st-catharines-on-l2r-4a6-26789301/branded" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:7 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30046637/37-page-street-st-catharines" +"ParkingTotal": 5 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "2049222" +"CommonInterest": "Freehold" +"CoListOfficeKey": "284641" +"GeocodeManualYN": true +"ZoningDescription": "R3" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 39.0 +"AboveGradeFinishedArea": 809 +"BelowGradeFinishedArea": 809 +"OriginalEntryTimestamp": "2026-07-17T13:18:14.01Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Measurement follows RMS" +"BelowGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1063152" +"ListOfficeNationalAssociationId": "1344650" +"CoListAgentNationalAssociationId": "1324637" +"CoListOfficeNationalAssociationId": "1344650" +"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('30046637')" +"ID": "1637951" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24714 +post_id: "1638478" +post_author: 1 +"ListingKey": "30043330" +"ListingId": "40848849" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-18T19:25:24Z" +"RFModificationTimestamp": "2026-07-18T19:28:04Z" +"ListPrice": 839900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 2316.0 +"BuildingAreaTotal": 0 +"City": "Simcoe" +"PostalCode": "N3Y0B5" +"UnparsedAddress": "14 STONEBRIDGE Place, Simcoe, Ontario N3Y0B5" +"Coordinates": array:2 [ 0 => -80.3134549 1 => 42.8197621 ] +"Latitude": 42.8197621 +"Longitude": -80.3134549 +"YearBuilt": 2021 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 14 Stonebridge Place — a beautifully maintained 5-year-old bungalow backing onto peaceful farm fields in one of Simcoe’s desirable neighbourhoods. Offering 2+1 bedrooms and 3 full bathrooms, this home combines modern comfort with thoughtful design and exceptional outdoor privacy. The bright open-concept main floor is perfect for everyday living and entertaining, featuring granite countertops, stylish backsplash, walk-in pantry, and a spacious dining area. Sliding doors lead to the covered porch and beautifully landscaped backyard, creating the perfect space to relax and enjoy the quiet country views. The primary bedroom retreat offers a walk-in closet and private ensuite, while convenient main floor laundry adds to the home’s functionality. Downstairs, the fully finished basement provides a large rec room, additional bedroom, full bathroom, and potential for a fourth bedroom, office, or gym. Complete with a double car garage, excellent curb appeal, and meticulous upkeep throughout, this move-in ready home offers the perfect blend of modern living and peaceful surroundings. (id:62650)" +"Appliances": array:8 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Central Vacuum" 4 => "Dishwasher" 5 => "Stove" 6 => "Dryer" 7 => "Window Coverings" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-17T23:18:59.650824+00:00" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Stone" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1965936" +"ListOfficeKey": "48558" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Cul-de-sac" 1 => "Paved driveway" 2 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-07-16T18:30:00Z" +"PhotosCount": 41 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-18T19:18:01Z" +"Stories": "1.0" +"StreetName": "STONEBRIDGE" +"StreetNumber": "14" +"StreetSuffix": "Place" +"SubdivisionName": "Town of Simcoe" +"TaxAnnualAmount": "5917" +"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/30043330/14-stonebridge-place-simcoe" +"ParkingTotal": 6 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R1-B" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 51.0 +"AboveGradeFinishedArea": 1421 +"BelowGradeFinishedArea": 895 +"OriginalEntryTimestamp": "2026-07-16T18:30:00.39Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1254154" +"ListOfficeNationalAssociationId": "1004255" +"Media": array:41 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] ] +"DaysOnMarket": 4 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30043330')" +"ID": "1638478" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24713 +post_id: "1642609" +post_author: 1 +"ListingKey": "30056319" +"ListingId": "40848847" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-20T18:36:17Z" +"RFModificationTimestamp": "2026-07-20T20:06:39Z" +"ListPrice": 624900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 1081.0 +"BuildingAreaTotal": 0 +"City": "Puslinch" +"PostalCode": "N3C2V4" +"UnparsedAddress": "15 POPLAR Trail, Puslinch, Ontario N3C2V4" +"Coordinates": array:2 [ 0 => -80.2769395 1 => 43.4194607 ] +"Latitude": 43.4194607 +"Longitude": -80.2769395 +"YearBuilt": 1950 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Just place your furniture and Relax! This fully renovated home on Puslinch lake awaits! You will love the lifestyle provide by this 1.5 story home with many modern updates including kitchen, with island for entertaining! Note the custom Terrazo counter! Newer mechanicals including creature comforts like Gas F/Air heat, C/Air & updated bathroom with walk-in shower! This home is built to entertain with the Kitchen flowing out to a gazebo, hot tub and even tiki bar! There is a sunken firepit area to enjoy the stars! Note: There is a deeded right of way to water front. (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Microwave Built-in" ] +"ArchitecturalStyle": array:1 [ 0 => "Cape Cod" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Crawl space" ] +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-20T20:06:29.555532+00:00" +"Directions": "Lake Road, Right on Travelled Road, Right on Holly, Right on Elm, Left on Poplar. Property on the right" +"ExteriorFeatures": array:1 [ 0 => "Stucco" ] +"Fencing": array:1 [ 0 => "Fence" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1564463" +"ListOfficeKey": "76804" +"LivingAreaUnits": "square feet" +"LotFeatures": array:5 [ 0 => "Cul-de-sac" 1 => "Backs on greenbelt" 2 => "Lot with lake" 3 => "Country residential" 4 => "Gazebo" ] +"LotSizeDimensions": "0" +"ParkingFeatures": array:1 [ 0 => "Open" ] +"PhotosChangeTimestamp": "2026-07-20T18:29:21Z" +"PhotosCount": 50 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-20T18:29:21Z" +"Stories": "1.5" +"StreetName": "POPLAR" +"StreetNumber": "15" +"StreetSuffix": "Trail" +"SubdivisionName": "73 - Puslinch Lake Settlement Areas" +"TaxAnnualAmount": "2942.77" +"View": "No Water View" +"VirtualTourURLUnbranded": "https://youriguide.com/jf05z_15_poplar_trl_cambridge_on/" +"WaterBodyName": "Puslinch Lake" +"WaterSource": array:2 [ 0 => "Drilled Well" 1 => "Well" ] +"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/30056319/15-poplar-trail-puslinch" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R" +"BedroomsAboveGrade": 1 +"BedroomsBelowGrade": 0 +"WaterfrontFeatures": array:1 [ 0 => "Waterfront" ] +"FrontageLengthNumeric": 40.0 +"AboveGradeFinishedArea": 1081 +"OriginalEntryTimestamp": "2026-07-20T18:29:21.35Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1069857" +"ListOfficeNationalAssociationId": "1004367" +"Media": array:50 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] 44 => array:13 [ …13] 45 => array:13 [ …13] 46 => array:13 [ …13] 47 => array:13 [ …13] 48 => array:13 [ …13] 49 => array:13 [ …13] ] +"DaysOnMarket": 0 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30056319')" +"ID": "1642609" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25138 +post_id: "1638173" +post_author: 1 +"ListingKey": "30047468" +"ListingId": "40848840" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-17T20:15:17Z" +"RFModificationTimestamp": "2026-07-17T23:24:26Z" +"ListPrice": 1679000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 3843.0 +"BuildingAreaTotal": 0 +"City": "Oakville" +"PostalCode": "L6M4V2" +"UnparsedAddress": "2201 LAPSLEY Crescent, Oakville, Ontario L6M4V2" +"Coordinates": array:2 [ 0 => -79.7621329 1 => 43.4308435 ] +"Latitude": 43.4308435 +"Longitude": -79.7621329 +"YearBuilt": 2002 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Lovely and bright Ballantry-built family home on a quiet crescent in highly sought-after Westmount. Offering approximately 3,843 sq.ft. of finished living space, this spacious 4 bed, 5 bath home features an exceptional layout designed for growing families. The inviting main floor showcases hardwood flooring and stairs, a stunning turret-style formal living room filled with natural light from numerous windows, a formal dining room, convenient main floor laundry and an open concept kitchen overlooking the spacious family room with gas fireplace. Double patio doors lead to an oversized composite deck, custom arbour, professionally landscaped fenced yard and custom shed, creating the perfect outdoor space for entertaining and family gatherings. The upper level offers four generous bedrooms and three full bathrooms, including an impressive turret-style primary retreat featuring a large walk-in closet and spacious 5-piece ensuite. Two bedrooms share a convenient Jack & Jill bathroom while the fourth bedroom enjoys access to its own adjacent bathroom, providing privacy and functionality for larger families. All bedrooms feature walk-in or oversized closets and excellent natural light throughout.The finished lower level provides outstanding additional living space with a large recreation room, games room, gym area, full bathroom and ample storage space, ideal for entertaining, teenagers, a home office or multi-generational living. Numerous updates include new stainless steel fridge and stove (2024), under sink water filtration system (2025), furnace and air conditioner (2019), roof (2018), attic insulation (2018), composite deck (2017), custom shed (2017), insulated garage door (2017), and pest proofing with roof drip edge installation (2023). Add. features include central vacuum, lawn sprinkler system and double garage.Ideally located within walking distance to four excellent schools, parks, trails, shopping, restaurants, Oakville Hospital and convenient highway access. (id:62650)" +"Appliances": array:8 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Central Vacuum" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" 6 => "Hood Fan" 7 => "Garage door opener" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-17T23:24:17.903456+00:00" +"Directions": "Westoak Trail Blvd to Calloway Drive and onto Lapsley Cres." +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"Fencing": array:1 [ 0 => "Fence" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1603272" +"ListOfficeKey": "294000" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Paved driveway" 1 => "Automatic Garage Door Opener" 2 => "Private Yard" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-07-17T16:01:26Z" +"PhotosCount": 46 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-17T20:08:34Z" +"Stories": "2.0" +"StreetName": "LAPSLEY" +"StreetNumber": "2201" +"StreetSuffix": "Crescent" +"SubdivisionName": "1019 - WM Westmount" +"TaxAnnualAmount": "6660.36" +"VirtualTourURLUnbranded": "https://youtu.be/JNAv9b0qzlU" +"WaterSource": array:2 [ 0 => "Municipal water" 1 => "Unknown" ] +"Rooms": array:17 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] 15 => array:11 [ …11] 16 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30047468/2201-lapsley-crescent-oakville" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "RL6" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 58.0 +"AboveGradeFinishedArea": 2597 +"BelowGradeFinishedArea": 1246 +"OriginalEntryTimestamp": "2026-07-17T15:18:21.41Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"BelowGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1303913" +"ListOfficeNationalAssociationId": "1434122" +"Media": array:46 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] 44 => array:13 [ …13] 45 => array:13 [ …13] ] +"DaysOnMarket": 3 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30047468')" +"ID": "1638173" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24599 +post_id: "1636938" +post_author: 1 +"ListingKey": "30043332" +"ListingId": "40848839" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-17T20:15:15Z" +"RFModificationTimestamp": "2026-07-17T20:52:40Z" +"ListPrice": 399000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1315.0 +"BuildingAreaTotal": 0 +"City": "Kitchener" +"PostalCode": "N2M1Y7" +"UnparsedAddress": "391 LAWRENCE Avenue, Kitchener, Ontario N2M1Y7" +"Coordinates": array:2 [ 0 => -80.5160455 1 => 43.44324 ] +"Latitude": 43.44324 +"Longitude": -80.5160455 +"YearBuilt": 1948 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Opportunity knocks! This 1.5 storey home is the perfect project for investors or handy buyers looking to create something special. Set on a great lot on a quiet street, the potential here is undeniable. Featuring 3 bedrooms and 1 bathroom, this home offers a solid starting point but will require significant updates and renovations. Whether you’re looking to restore and renovate, this property is full of possibilities. The exterior includes a detached single-car garage and a driveway with parking for up to three vehicles—an added bonus for future plans. Bring your vision and transform this diamond in the rough into something truly remarkable. Being sold as-is. (id:62650)" +"Appliances": array:2 [ 0 => "Refrigerator" 1 => "Stove" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"Cooling": array:1 [ 0 => "None" ] +"CreationDate": "2026-07-17T20:52:30.733636+00:00" +"Directions": "Victoria St to Lawrence Ave or Karn St to Lawrence Ave" +"ExteriorFeatures": array:1 [ 0 => "Aluminum siding" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:3 [ 0 => "Baseboard heaters" 1 => "Forced air" 2 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1564743" +"ListOfficeKey": "290392" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Paved driveway" ] +"ParkingFeatures": array:1 [ 0 => "Detached Garage" ] +"PhotosChangeTimestamp": "2026-07-16T18:33:00Z" +"PhotosCount": 6 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-17T20:08:34Z" +"Stories": "1.5" +"StreetName": "LAWRENCE" +"StreetNumber": "391" +"StreetSuffix": "Avenue" +"SubdivisionName": "323 - Victoria Hills" +"TaxAnnualAmount": "4097" +"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/30043332/391-lawrence-avenue-kitchener" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R2B" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 50.0 +"AboveGradeFinishedArea": 1315 +"OriginalEntryTimestamp": "2026-07-16T18:30:00.84Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1135413" +"ListOfficeNationalAssociationId": "1386847" +"Media": array:6 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] ] +"DaysOnMarket": 4 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30043332')" +"ID": "1636938" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24604 +post_id: "1636988" +post_author: 1 +"ListingKey": "30043593" +"ListingId": "40848837" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-17T20:15:15Z" +"RFModificationTimestamp": "2026-07-17T20:52:40Z" +"ListPrice": 0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 1534.0 +"BuildingAreaTotal": 0 +"City": "Brampton" +"PostalCode": "L6Z3V5" +"UnparsedAddress": "40 JAY Street, Brampton, Ontario L6Z3V5" +"Coordinates": array:2 [ 0 => -79.7864798 1 => 43.7195998 ] +"Latitude": 43.7195998 +"Longitude": -79.7864798 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 40 Jay St in Brampton's desirable Heart Lake Community. This spacious home offers 3+2 bedrooms and full bathrooms, making it ideal for growing families or those seeking extra space. Step inside to a large open concept living and dining area, perfect for entertaining or everyday living. The bright kitchen is filled with natural light and offers a functional layout for cooking and gathering. With additional bedrooms in the lower level, there's plenty of room for guests, a home office, or extended family. Located in a quiet, family-friendly neighbourhood close to parks, school, shopping, and major highways, this home combines comfort, space and convenience. (id:62650)" +"Appliances": array:5 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-17T20:52:29.535069+00:00" +"Directions": "Conestoga Dr to Jay St" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FoundationDetails": array:1 [ 0 => "Unknown" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2085498" +"ListOfficeKey": "284837" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Conservation/green belt" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-07-16T19:32:06Z" +"PhotosCount": 15 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-17T20:08:34Z" +"Stories": "2.0" +"StreetName": "JAY" +"StreetNumber": "40" +"StreetSuffix": "Street" +"SubdivisionName": "BRHW - Heart Lake West" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:11 [ 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] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30043593/40-jay-street-brampton" +"ParkingTotal": 3 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"TotalActualRent": 3200 +"ZoningDescription": "RM1" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 2 +"LeaseAmountFrequency": "Monthly" +"FrontageLengthNumeric": 22.0 +"AboveGradeFinishedArea": 1534 +"OriginalEntryTimestamp": "2026-07-16T18:48:13.08Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1358991" +"ListOfficeNationalAssociationId": "1349007" +"Media": array:15 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] ] +"DaysOnMarket": 4 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30043593')" +"ID": "1636988" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24602 +post_id: "1637062" +post_author: 1 +"ListingKey": "30043594" +"ListingId": "40848835" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-17T20:15:15Z" +"RFModificationTimestamp": "2026-07-17T20:53:42Z" +"ListPrice": 449900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1508.0 +"BuildingAreaTotal": 0 +"City": "Crystal Beach" +"PostalCode": "L0S1B0" +"UnparsedAddress": "3824 ROXBOROUGH Avenue, Crystal Beach, Ontario L0S1B0" +"Coordinates": array:2 [ 0 => -79.0571781 1 => 42.8683687 ] +"Latitude": 42.8683687 +"Longitude": -79.0571781 +"YearBuilt": 1947 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Discover an exceptional investment or multi-generational living opportunity at this unique, meticulously maintained one-storey duplex in the highly sought-after community of Crystal Beach. This versatile property offers two distinct, beautifully updated separate units. The front unit features a bright living room, dining room, kitchen, a four-piece bath, and a large bedroom, having previously generated $1,500 per month in rental income. The rear unit provides a comfortable living space with its own kitchen, a living room, a two-piece bath, a main floor bedroom, and a second-level loft that boasts a spacious primary bedroom and a private three-piece bathroom. Flexibility is key here, as a centrally located bedroom can easily be integrated into either unit depending on your tenant's needs, while both units enjoy access to a shared laundry room. The entire home has been lovingly updated with high-quality engineered hardwood flooring throughout, completely eliminating carpet. It boasts two modernized kitchens, two and a half refreshed bathrooms, and abundant closet space. Mechanically, the property is in peak condition with a natural gas forced air furnace and central air conditioning that are both only three years old. The low-maintenance vinyl windows were replaced approximately seven years ago, and the asphalt roof shingles were updated in 2017. Connected to municipal water and sewer services, the exterior shines with updated vinyl siding that creates fantastic curb appeal, a completely fenced private backyard perfect for outdoor relaxation, and four front parking spots. Located just moments away from the famous beach, a quaint downtown area, boutique shopping, and excellent restaurants, this property is perfect for an owner to live in one side while renting out the other, hosting an airbnb, or creating an ideal in-law suite (id:62650)" +"Appliances": array:5 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Stove" 3 => "Dryer" 4 => "Window Coverings" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Crawl space" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-17T20:53:30.034315+00:00" +"Directions": "Ridgeway Rd to Brunswick to Roxborough Avenue" +"ExteriorFeatures": array:1 [ 0 => "Vinyl siding" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1559268" +"ListOfficeKey": "284635" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "In-Law Suite" ] +"PhotosChangeTimestamp": "2026-07-16T18:48:13Z" +"PhotosCount": 47 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-17T20:08:35Z" +"Stories": "1.5" +"StreetName": "ROXBOROUGH" +"StreetNumber": "3824" +"StreetSuffix": "Avenue" +"SubdivisionName": "337 - Crystal Beach" +"TaxAnnualAmount": "2655" +"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/30043594/3824-roxborough-avenue-crystal-beach" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R3" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 30.0 +"AboveGradeFinishedArea": 1508 +"OriginalEntryTimestamp": "2026-07-16T18:48:13.19Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1146405" +"ListOfficeNationalAssociationId": "1344652" +"Media": array:47 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] 44 => array:13 [ …13] 45 => array:13 [ …13] 46 => array:13 [ …13] ] +"DaysOnMarket": 4 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30043594')" +"ID": "1637062" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24601 +post_id: "1637219" +post_author: 1 +"ListingKey": "30043333" +"ListingId": "40848834" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-17T20:15:15Z" +"RFModificationTimestamp": "2026-07-17T20:54:14Z" +"ListPrice": 1200000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 2466.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L0R1T0" +"UnparsedAddress": "108 HIGHWAY 52, Hamilton, Ontario L0R1T0" +"Coordinates": array:2 [ 0 => -80.0584339 1 => 43.2516302 ] +"Latitude": 43.2516302 +"Longitude": -80.0584339 +"YearBuilt": 1986 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Location, Location, Location! This stunning 2-storey fully renovated 4+1 bedroom, 3.5-bathroom home offers over 3,600 square feet of bright and spacious living space on a beautiful 1/2-acre lot. Just down the street from Flamborough Hills Golf Course and with many other golf courses nearby, this home is ideally situated only 15 minutes from Dundas, Ancaster, and Brantford, and 20 minutes to Aldershot GO station. The moment you enter, you’ll notice the home is filled with natural light. Recent updates include a custom kitchen (2020) with premium Caesarstone countertops and a large island, a main-floor family room with a cozy Valor gas fireplace, and convenient main-floor laundry. Upstairs you’ll find four generously sized bedrooms, including a primary suite with a fully renovated ensuite featuring an oversized walk-in shower. The additional full bathroom has also been tastefully updated. The finished lower level features a fifth bedroom with an electric fireplace, plus additional family room space and an updated three-piece bathroom. Outside, enjoy a private backyard oasis with a spacious deck that includes a covered section perfect for cool evenings. A separate pergola creates an ideal space for dining and entertaining, complemented by plenty of seating and a custom built-in area that has been reinforced and wired for a hot tub — perfect for cozy nights with friends and a TV. Spectacular sunrises make this backyard truly special. A 20’ x 23’ shop with 40-amp service offers excellent workspace or storage. This move-in ready home truly has it all. Don’t be TOO LATE*! *REG TM. RSA. (id:62650)" +"Appliances": array:5 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-17T20:54:04.312112+00:00" +"Directions": "Governors Rd to Highway 52" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1525426" +"ListOfficeKey": "293261" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Crushed stone driveway" 1 => "Country residential" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-07-16T19:44:10Z" +"PhotosCount": 50 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-17T20:08:35Z" +"Stories": "2.0" +"StreetName": "HIGHWAY 52" +"StreetNumber": "108" +"SubdivisionName": "045 - Beverly" +"TaxAnnualAmount": "9034" +"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/019e4135-e307-73ac-8cb5-dc334d90f2c5" +"WaterSource": array:2 [ 0 => "Drilled Well" 1 => "Well" ] +"Rooms": array:16 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] 15 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30043333/108-highway-52-hamilton" +"ParkingTotal": 8 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "S1" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 100.0 +"AboveGradeFinishedArea": 2466 +"OriginalEntryTimestamp": "2026-07-16T18:30:01.05Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1063673" +"ListOfficeNationalAssociationId": "1424570" +"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": 4 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30043333')" +"ID": "1637219" } ] +success: true +page_size: 12 +page_count: 19190 +count: 230270 +after_key: "" } "RF Response Time" => "0.27 seconds" ] ]