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=154812&$filter=(PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24576 +items: array:12 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24657 +post_id: "1461525" +post_author: 1 +"ListingKey": "29805001" +"ListingId": "40831217" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-14T19:40:04Z" +"RFModificationTimestamp": "2026-06-14T19:43:15Z" +"ListPrice": 529900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1325.0 +"BuildingAreaTotal": 0 +"City": "St. Catharines" +"PostalCode": "L2N6N6" +"UnparsedAddress": "122 LAKESHORE Road Unit# 46, St. Catharines, Ontario L2N6N6" +"Coordinates": array:2 [ 0 => -79.2441556 1 => 43.2019776 ] +"Latitude": 43.2019776 +"Longitude": -79.2441556 +"YearBuilt": 1974 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to this spacious and well-maintained 3-bedroom townhouse condo in the desirable Lakeport neighbourhood of St. Catharines! Offering over 1,300 sq ft above grade, this home features a functional layout with a bright living room, separate dining area, and an updated kitchen with ample cabinet space. Upstairs, you’ll find three generously sized bedrooms, a 4-piece bath, and access to a private balcony off the upper level. The partially finished basement adds extra living space with a large family room, perfect for a rec room, home office, or gym. Enjoy the convenience of an attached garage, private driveway, central air, and low-maintenance condo living. Residents have access to great amenities including an outdoor pool and visitor parking. Ideally located close to parks, schools, shopping, highway access, and just minutes from the waterfront. A fantastic opportunity for first-time buyers, downsizers, or investors alike! (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Window Coverings" ] +"AssociationFee": "450" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:5 [ 0 => "Common Area Maintenance" 1 => "Cable TV" 2 => "Water" 3 => "Insurance" 4 => "Parking" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"BathroomsPartial": 1 +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-26T17:14:16.238462+00:00" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1989184" +"ListOfficeKey": "86262" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Balcony" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-26T14:33:00Z" +"PhotosCount": 26 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-14T19:32:56Z" +"Stories": "2.0" +"StreetName": "LAKESHORE" +"StreetNumber": "122" +"StreetSuffix": "Road" +"SubdivisionName": "443 - Lakeport" +"TaxAnnualAmount": "3409" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:12 [ 0 => array:11 [ "RoomKey" => "1659408234" "RoomType" => "Other" "ListingId" => "40831217" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29805001" "RoomLength" => null "RoomDimensions" => "17'8'' x 18'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-14T19:32:56.01Z" ] 1 => array:11 [ "RoomKey" => "1659408235" "RoomType" => "Family room" "ListingId" => "40831217" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29805001" "RoomLength" => null "RoomDimensions" => "11'9'' x 18'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-14T19:32:56.02Z" ] 2 => array:11 [ "RoomKey" => "1659408236" "RoomType" => "Bedroom" "ListingId" => "40831217" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29805001" "RoomLength" => null "RoomDimensions" => "8'11'' x 7'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-14T19:32:56.02Z" ] 3 => array:11 [ "RoomKey" => "1659408237" "RoomType" => "Bedroom" "ListingId" => "40831217" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29805001" "RoomLength" => null "RoomDimensions" => "14'6'' x 8'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-14T19:32:56.02Z" ] 4 => array:11 [ "RoomKey" => "1659408238" "RoomType" => "4pc Bathroom" "ListingId" => "40831217" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29805001" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-14T19:32:56.02Z" ] 5 => array:11 [ "RoomKey" => "1659408239" "RoomType" => "Primary Bedroom" "ListingId" => "40831217" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29805001" "RoomLength" => null "RoomDimensions" => "11'11'' x 10'11''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-14T19:32:56.02Z" ] 6 => array:11 [ "RoomKey" => "1659408240" "RoomType" => "Porch" "ListingId" => "40831217" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29805001" "RoomLength" => null "RoomDimensions" => "3'10'' x 11'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-14T19:32:56.02Z" ] 7 => array:11 [ "RoomKey" => "1659408241" "RoomType" => "2pc Bathroom" "ListingId" => "40831217" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29805001" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-14T19:32:56.02Z" ] 8 => array:11 [ "RoomKey" => "1659408242" "RoomType" => "Foyer" "ListingId" => "40831217" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29805001" "RoomLength" => null "RoomDimensions" => "9'7'' x 4'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-14T19:32:56.02Z" ] 9 => array:11 [ "RoomKey" => "1659408243" "RoomType" => "Kitchen" "ListingId" => "40831217" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29805001" "RoomLength" => null "RoomDimensions" => "9'3'' x 10'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-14T19:32:56.02Z" ] 10 => array:11 [ "RoomKey" => "1659408244" "RoomType" => "Dining room" "ListingId" => "40831217" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29805001" "RoomLength" => null "RoomDimensions" => "7'4'' x 14'10''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-14T19:32:56.02Z" ] 11 => array:11 [ "RoomKey" => "1659408245" "RoomType" => "Living room" "ListingId" => "40831217" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29805001" "RoomLength" => null "RoomDimensions" => "12'10'' x 18'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-14T19:32:56.03Z" ] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29805001/122-lakeshore-road-unit-46-st-catharines" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "Row / Townhouse" ] +"CoListAgentKey": "1876026" +"CommonInterest": "Condo/Strata" +"CoListOfficeKey": "86262" +"GeocodeManualYN": true +"ZoningDescription": "R3" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"AboveGradeFinishedArea": 1325 +"OriginalEntryTimestamp": "2026-05-26T14:33:00.51Z" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1273173" +"ListOfficeNationalAssociationId": "1004415" +"CoListAgentNationalAssociationId": "1204241" +"CoListOfficeNationalAssociationId": "1004415" +"Media": array:26 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "29805001_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/9082206a4f3a5232d81db61e8c4a0c7e.webp" "MediaSize" => 167023 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-9082206a4f3a5232d81db61e8c4a0c7e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "29805001_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/f5ea8cd6ec25967865bf73110e798fa1.webp" "MediaSize" => 98370 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-f5ea8cd6ec25967865bf73110e798fa1.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "29805001_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/2601da358542746c0e01ca6097dc20a6.webp" "MediaSize" => 136390 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-2601da358542746c0e01ca6097dc20a6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "29805001_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/cecc8b718162a9e83a3fa863544881a2.webp" "MediaSize" => 51831 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-cecc8b718162a9e83a3fa863544881a2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "29805001_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/7600598c8468766f73569c5527b8cfd1.webp" "MediaSize" => 46028 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-7600598c8468766f73569c5527b8cfd1.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "29805001_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/b8260e01139367b7b916d13edd17b16b.webp" "MediaSize" => 33730 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-b8260e01139367b7b916d13edd17b16b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "29805001_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/72740ec8ac991c19983f72c27aef49d6.webp" "MediaSize" => 45307 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-72740ec8ac991c19983f72c27aef49d6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "29805001_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/ac2ae72baab9ac6ec937a139d00aecd7.webp" "MediaSize" => 41204 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-ac2ae72baab9ac6ec937a139d00aecd7.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "29805001_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/d46be27cbe8e6a9121c8a5c46dd7c573.webp" "MediaSize" => 68582 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-d46be27cbe8e6a9121c8a5c46dd7c573.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "29805001_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/44f2dcc1819d22d0a72c39427ae5f4d9.webp" "MediaSize" => 61695 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-44f2dcc1819d22d0a72c39427ae5f4d9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "29805001_4890_11" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/648b1d42103470d1beb8699fd8efa126.webp" "MediaSize" => 67005 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-648b1d42103470d1beb8699fd8efa126.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "29805001_4890_12" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/11498cf719b7261256c73707d930378c.webp" "MediaSize" => 67206 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-11498cf719b7261256c73707d930378c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "29805001_4890_13" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/5d9c0e87670c2dd8581d69c632797d20.webp" "MediaSize" => 58546 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-5d9c0e87670c2dd8581d69c632797d20.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 13 => array:13 [ "Order" => 14 "MediaKey" => "29805001_4890_14" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/17b3da9c0f3c5bb2325fe6e52b85af7a.webp" "MediaSize" => 62148 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-17b3da9c0f3c5bb2325fe6e52b85af7a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 14 => array:13 [ "Order" => 15 "MediaKey" => "29805001_4890_15" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/46575be8b0e45fb7d0500d08fbf3ca00.webp" "MediaSize" => 65443 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-46575be8b0e45fb7d0500d08fbf3ca00.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 15 => array:13 [ "Order" => 16 "MediaKey" => "29805001_4890_16" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/69df92b4b2ab8a7fd0086d6764b36fb3.webp" "MediaSize" => 56232 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-69df92b4b2ab8a7fd0086d6764b36fb3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 16 => array:13 [ "Order" => 17 "MediaKey" => "29805001_4890_17" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/1550d3c7202bb76d316a1520740e9be6.webp" "MediaSize" => 56077 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-1550d3c7202bb76d316a1520740e9be6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 17 => array:13 [ "Order" => 18 "MediaKey" => "29805001_4890_18" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/16f110ab61103529ea148db3d4bef22d.webp" "MediaSize" => 56283 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-16f110ab61103529ea148db3d4bef22d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 18 => array:13 [ "Order" => 19 "MediaKey" => "29805001_4890_19" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/9a18dd7831f28b75fd648185369b5767.webp" "MediaSize" => 57590 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-9a18dd7831f28b75fd648185369b5767.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 19 => array:13 [ "Order" => 20 "MediaKey" => "29805001_4890_20" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/ea279d38584010a2ae6bed1dcde71215.webp" "MediaSize" => 116042 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-ea279d38584010a2ae6bed1dcde71215.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 20 => array:13 [ "Order" => 21 "MediaKey" => "29805001_4890_21" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/37b18b16ea804b4914ba1b19eb081b66.webp" "MediaSize" => 57129 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-37b18b16ea804b4914ba1b19eb081b66.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 21 => array:13 [ "Order" => 22 "MediaKey" => "29805001_4890_22" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/65597928cedf4e706e47afec54df5b79.webp" "MediaSize" => 140362 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-65597928cedf4e706e47afec54df5b79.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 22 => array:13 [ "Order" => 23 "MediaKey" => "29805001_4890_23" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/7dcc232e8d7ef6b479dd6a666547ffb8.webp" "MediaSize" => 148371 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-7dcc232e8d7ef6b479dd6a666547ffb8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 23 => array:13 [ "Order" => 24 "MediaKey" => "29805001_4890_24" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/95759764f1a0898e521e10826e07daa9.webp" "MediaSize" => 152401 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-95759764f1a0898e521e10826e07daa9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 24 => array:13 [ "Order" => 25 "MediaKey" => "29805001_4890_25" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/52100a7bed9fc200a1d32fc6fce10cbf.webp" "MediaSize" => 127159 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-52100a7bed9fc200a1d32fc6fce10cbf.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] 25 => array:13 [ "Order" => 26 "MediaKey" => "29805001_4890_26" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29805001/df7cffb61f83c7de9d127df7aa98a46d.webp" "MediaSize" => 47322 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29805001/thumbnail-df7cffb61f83c7de9d127df7aa98a46d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831217" "ResourceRecordKey" => "29805001" "ModificationTimestamp" => "2026-05-26T14:33:00.52Z" ] ] +"DaysOnMarket": 36 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29805001')" +"ID": "1461525" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24504 +post_id: "1480580" +post_author: 1 +"ListingKey": "29834786" +"ListingId": "40831214" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-20T16:10:07Z" +"RFModificationTimestamp": "2026-06-20T16:19:06Z" +"ListPrice": 1949000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 2283.0 +"BuildingAreaTotal": 0 +"City": "Burlington" +"PostalCode": "L7R1H8" +"UnparsedAddress": "2134 NEW Street Unit# 6, Burlington, Ontario L7R1H8" +"Coordinates": array:2 [ 0 => -79.7942906 1 => 43.3297541 ] +"Latitude": 43.3297541 +"Longitude": -79.7942906 +"YearBuilt": 2021 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "A beautifully built 3 bedroom, 3.5 bathroom detached freehold home in an exclusive downtown Burlington enclave! Welcome to Red Path Place! Just steps to the lake and all the downtown amenities including restaurants, shops, parks, schools, the YMCA, the Performing Arts Centre, the GO station and more! Custom 2 storey with 3,533 sq.ft. of living space and loaded with luxury features including a gorgeous kitchen with porcelain waterfall countertops, stainless steel appliances (including a 6-burner gas stove) and a walkout to a fully fenced, professionally landscaped private yard with deck, hot tub, irrigation and gas BBQ hookup! The main level also features an open concept living area, a gas fireplace with porcelain surround, an office, a powder room and a mudroom with inside entry from the double garage. The upper level has 3 bedrooms plus a laundry room and is highlighted by the oversized primary with walk-in closet and spa-inspired 4-piece ensuite with heated floor! The fully finished lower level has oversized windows, a rec/family room, a gas fireplace, a 3-piece bathroom, a home gym/theatre room and ample storage! High-end features and finishes include 9' ceilings on all three levels, engineered hardwood floors, pot lighting, a double-wide concrete driveway, a 200-amp electrical service and wiring for EV! (id:62650)" +"Appliances": array:8 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Hot Tub" 3 => "Gas stove(s)" 4 => "Dishwasher" 5 => "Dryer" 6 => "Window Coverings" 7 => "Garage door opener" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-01T19:49:15.068309+00:00" +"Directions": "New St/Martha St" +"ExteriorFeatures": array:3 [ 0 => "Stone" 1 => "Other" 2 => "Shingles" ] +"Fencing": array:1 [ 0 => "Fence" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1524825" +"ListOfficeKey": "284639" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Southern exposure" 1 => "Sump Pump" 2 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-06-20T15:51:52Z" +"PhotosCount": 50 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-20T16:03:34Z" +"Stories": "2.0" +"StreetName": "NEW" +"StreetNumber": "2134" +"StreetSuffix": "Street" +"SubdivisionName": "312 - Central" +"TaxAnnualAmount": "10041.13" +"VirtualTourURLUnbranded": "https://youtu.be/OXmmfhgCToo" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:18 [ 0 => array:11 [ "RoomKey" => "1663926962" "RoomType" => "Utility room" "ListingId" => "40831214" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29834786" "RoomLength" => null "RoomDimensions" => "6'11'' x 18'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T16:03:34.64Z" ] 1 => array:11 [ "RoomKey" => "1663926963" "RoomType" => "Recreation room" "ListingId" => "40831214" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29834786" "RoomLength" => null "RoomDimensions" => "32'10'' x 18'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T16:03:34.64Z" ] 2 => array:11 [ "RoomKey" => "1663926964" "RoomType" => "Gym" "ListingId" => "40831214" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29834786" "RoomLength" => null "RoomDimensions" => "18'3'' x 18'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T16:03:34.64Z" ] 3 => array:11 [ "RoomKey" => "1663926965" "RoomType" => "Cold room" "ListingId" => "40831214" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29834786" "RoomLength" => null "RoomDimensions" => "14'7'' x 15'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T16:03:34.64Z" ] 4 => array:11 [ "RoomKey" => "1663926966" "RoomType" => "3pc Bathroom" "ListingId" => "40831214" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29834786" "RoomLength" => null "RoomDimensions" => "8'2'' x 5'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T16:03:34.65Z" ] 5 => array:11 [ "RoomKey" => "1663926967" "RoomType" => "Primary Bedroom" "ListingId" => "40831214" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29834786" "RoomLength" => null "RoomDimensions" => "18'0'' x 18'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T16:03:34.65Z" ] 6 => array:11 [ "RoomKey" => "1663926968" "RoomType" => "Bedroom" "ListingId" => "40831214" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29834786" "RoomLength" => null "RoomDimensions" => "12'10'' x 11'11''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T16:03:34.65Z" ] 7 => array:11 [ "RoomKey" => "1663926969" "RoomType" => "Bedroom" "ListingId" => "40831214" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29834786" "RoomLength" => null "RoomDimensions" => "16'4'' x 11'9''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T16:03:34.65Z" ] 8 => array:11 [ "RoomKey" => "1663926970" "RoomType" => "Laundry room" "ListingId" => "40831214" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29834786" "RoomLength" => null "RoomDimensions" => "8'8'' x 5'7''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T16:03:34.65Z" ] 9 => array:11 [ "RoomKey" => "1663926971" "RoomType" => "5pc Bathroom" "ListingId" => "40831214" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29834786" "RoomLength" => null "RoomDimensions" => "6'7'' x 11'11''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T16:03:34.66Z" ] 10 => array:11 [ "RoomKey" => "1663926972" "RoomType" => "Full bathroom" "ListingId" => "40831214" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29834786" "RoomLength" => null "RoomDimensions" => "9'0'' x 10'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T16:03:34.66Z" ] 11 => array:11 [ "RoomKey" => "1663926973" "RoomType" => "Office" "ListingId" => "40831214" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29834786" "RoomLength" => null "RoomDimensions" => "7'8'' x 9'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T16:03:34.66Z" ] 12 => array:11 [ "RoomKey" => "1663926974" "RoomType" => "Mud room" "ListingId" => "40831214" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29834786" "RoomLength" => null "RoomDimensions" => "7'6'' x 12'7''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T16:03:34.66Z" ] 13 => array:11 [ "RoomKey" => "1663926975" "RoomType" => "Living room" "ListingId" => "40831214" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29834786" "RoomLength" => null "RoomDimensions" => "14'10'' x 15'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T16:03:34.66Z" ] 14 => array:11 [ "RoomKey" => "1663926976" "RoomType" => "Kitchen" "ListingId" => "40831214" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29834786" "RoomLength" => null "RoomDimensions" => "14'6'' x 10'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T16:03:34.67Z" ] 15 => array:11 [ "RoomKey" => "1663926977" "RoomType" => "Foyer" "ListingId" => "40831214" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29834786" "RoomLength" => null "RoomDimensions" => "5'3'' x 6'9''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T16:03:34.67Z" ] 16 => array:11 [ "RoomKey" => "1663926978" "RoomType" => "Dining room" "ListingId" => "40831214" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29834786" "RoomLength" => null "RoomDimensions" => "14'6'' x 8'11''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T16:03:34.67Z" ] 17 => array:11 [ "RoomKey" => "1663926979" "RoomType" => "2pc Bathroom" "ListingId" => "40831214" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29834786" "RoomLength" => null "RoomDimensions" => "7'6'' x 5'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T16:03:34.67Z" ] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29834786/2134-new-street-unit-6-burlington" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "1910152" +"CommonInterest": "Freehold" +"CoListOfficeKey": "279638" +"GeocodeManualYN": true +"ZoningDescription": "R3-3" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 58.0 +"AboveGradeFinishedArea": 2283 +"OriginalEntryTimestamp": "2026-06-01T18:52:02.57Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1064388" +"ListOfficeNationalAssociationId": "1344653" +"CoListAgentNationalAssociationId": "1222224" +"CoListOfficeNationalAssociationId": "1306586" +"Media": array:50 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "29834786_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29834786/984513849ac52e2c53991697ebbbaac5.webp" "MediaSize" => 164193 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29834786/thumbnail-984513849ac52e2c53991697ebbbaac5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "40831214" "ResourceRecordKey" => "29834786" "ModificationTimestamp" => "2026-06-01T18:52:48.59Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "29834786_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29834786/66184a80bf1310517e1211b7befc85eb.webp" "MediaSize" => 184344 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29834786/thumbnail-66184a80bf1310517e1211b7befc85eb.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831214" "ResourceRecordKey" => "29834786" "ModificationTimestamp" => "2026-06-01T18:52:48.63Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "29834786_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29834786/416f8a7c4661b016b45a6717573ed048.webp" "MediaSize" => 152896 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29834786/thumbnail-416f8a7c4661b016b45a6717573ed048.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false …3 ] 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": 30 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29834786')" +"ID": "1480580" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24645 +post_id: "1434056" +post_author: 1 +"ListingKey": "29768533" +"ListingId": "40831205" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-09T23:50:23Z" +"RFModificationTimestamp": "2026-06-09T23:53:46Z" +"ListPrice": 825000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1795.0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2T2T2" +"UnparsedAddress": "350 HAVENDALE Crescent, Waterloo, Ontario N2T2T2" +"Coordinates": array:2 [ 0 => -80.5809198 1 => 43.4713359 ] +"Latitude": 43.4713359 +"Longitude": -80.5809198 +"YearBuilt": 1999 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Bright and spacious three bedroom three bathroom double garage single family house in most desirable Laurelwood with one of best schools and amenities, walking distance for your kids from Kindergarten to high school, as well as to YMCA, library and shopping center, Laurel Creek conservation area , and on convenient bus route to both Universities. Main floor has open concept and full of sunshine in winter time, big kitchen has lots of maple cupboards and a big island, living room has a vaulted ceiling , a fireplace surrounded by huge windows. 3 spacious bedroom on second floor, master bedroom has ensuite .unspoiled basement for your personal touch. don't miss this one! (id:62650)" +"Appliances": array:8 [ 0 => "Washer" 1 => "Water softener" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Hood Fan" 6 => "Window Coverings" 7 => "Garage door opener" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-19T14:42:05.615280+00:00" +"Directions": "Laurelwood" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1564082" +"ListOfficeKey": "222711" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Conservation/green belt" 1 => "Paved driveway" 2 => "Automatic Garage Door Opener" ] +"LotSizeDimensions": "0" +"PhotosChangeTimestamp": "2026-05-19T14:13:42Z" +"PhotosCount": 14 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-09T23:42:36Z" +"Stories": "2.0" +"StreetName": "HAVENDALE" +"StreetNumber": "350" +"StreetSuffix": "Crescent" +"SubdivisionName": "441 - Erbsville/Laurelwood" +"TaxAnnualAmount": "5639.62" +"Utilities": array:1 [ 0 => "Cable" ] +"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/29768533/350-havendale-crescent-waterloo" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "SD" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 35.0 +"AboveGradeFinishedArea": 1795 +"OriginalEntryTimestamp": "2026-05-19T14:11:05.19Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Appraiser" +"ListAgentNationalAssociationId": "1130381" +"ListOfficeNationalAssociationId": "1197443" +"Media": array:14 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] ] +"DaysOnMarket": 43 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29768533')" +"ID": "1434056" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24530 +post_id: "1439322" +post_author: 1 +"ListingKey": "29775285" +"ListingId": "40831191" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-12T20:00:05Z" +"RFModificationTimestamp": "2026-06-12T20:05:31Z" +"ListPrice": 499900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.03 +"LivingArea": 1795.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8P3N6" +"UnparsedAddress": "128 HESS Street S, Hamilton, Ontario L8P3N6" +"Coordinates": array:2 [ 0 => -79.8792542 1 => 43.2550637 ] +"Latitude": 43.2550637 +"Longitude": -79.8792542 +"YearBuilt": 1912 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Step into the charm and character of this inviting century home, ready for your personal touches to make it truly your own. Ideally located with easy access to parks, schools, transit, shopping, and restaurants, this home offers convenience and lifestyle in one desirable package. Featuring 3 bedrooms and 3 bathrooms, there is plenty of space for families, guests, or a home office setup. The welcoming living room is highlighted by a gorgeous wood-burning fireplace — perfect for cozy winter evenings. Outside, the beautifully established gardens are filled with easy-care perennials, providing colourful blooms throughout the seasons with minimal maintenance. Full of warmth, potential, and timeless appeal, this home is ready and waiting for its next chapter with you. (id:62650)" +"Appliances": array:4 [ 0 => "Refrigerator" 1 => "Dishwasher" 2 => "Stove" 3 => "Microwave" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"BathroomsPartial": 1 +"Cooling": array:1 [ 0 => "None" ] +"CreationDate": "2026-05-20T18:10:22.749235+00:00" +"Directions": "North of Bold St on West side" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FoundationDetails": array:1 [ 0 => "Stone" ] +"Heating": array:1 [ 0 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1523942" +"ListOfficeKey": "55168" +"LivingAreaUnits": "square feet" +"LotSizeDimensions": "0.03" +"ParkingFeatures": array:1 [ 0 => "None" ] +"PhotosChangeTimestamp": "2026-05-20T13:39:47Z" +"PhotosCount": 42 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-12T19:53:08Z" +"Stories": "2.5" +"StreetDirSuffix": "South" +"StreetName": "HESS" +"StreetNumber": "128" +"StreetSuffix": "Street" +"SubdivisionName": "122 - Durand North" +"TaxAnnualAmount": "5339.14" +"VirtualTourURLUnbranded": "https://www.venturehomes.ca/virtualtour.asp?tourid=70163" +"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/29775285/128-hess-street-s-hamilton" +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "E-3" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 24.0 +"AboveGradeFinishedArea": 1795 +"OriginalEntryTimestamp": "2026-05-20T13:39:47.25Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1064796" +"ListOfficeNationalAssociationId": "1116022" +"Media": array:42 [ 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] ] +"DaysOnMarket": 42 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29775285')" +"ID": "1439322" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24525 +post_id: "1436652" +post_author: 1 +"ListingKey": "29770382" +"ListingId": "40831187" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-20T19:40:06Z" +"RFModificationTimestamp": "2026-06-20T19:46:11Z" +"ListPrice": 919000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.178 +"LivingArea": 2503.0 +"BuildingAreaTotal": 0 +"City": "Elmira" +"PostalCode": "N3B3L2" +"UnparsedAddress": "13 BURLWOOD Drive, Elmira, Ontario N3B3L2" +"Coordinates": array:2 [ 0 => -80.5671239 1 => 43.5823633 ] +"Latitude": 43.5823633 +"Longitude": -80.5671239 +"YearBuilt": 2000 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "A stunning residence nestled in the highly sought-after, quiet community of South Parkwood Estates in Elmira. This 4-bedroom, 2.5-bathroom home offers the perfect blend of small-town tranquility and modern convenience, with easy access to the charming village of St. Jacobs and the bustling Kitchener-Waterloo area. As you step inside, you are greeted by a sizable foyer that sets an inviting tone. The main level features a desirable open-concept layout, anchored by a warm gas fireplace—the perfect focal point for hosting guests or enjoying quiet evenings. The spacious kitchen is a chef’s delight, boasting ample counter and cabinet space. For ultimate accessibility, the primary bedroom is located on the main floor, featuring a large walk-in closet, alongside a dedicated main floor laundry room. The fully finished basement expands your living space significantly. Here, you will find three additional sizeable bedrooms, ideal for a growing family or a home office. The cozy rec room, complete with a woodstove, provides a rustic retreat for chilly Ontario winters. A standout feature is the walk-up access from the basement directly to the oversized 2-car garage, offering incredible functionality and potential for a secondary entrance. Step outside into a backyard that is truly a rare find. Professionally landscaped gardens surround a peaceful waterfall feature, creating a serene atmosphere. Backing onto a lush woodlot with no rear neighbors, you can enjoy ultimate privacy on the large deck or under the gazebo. The exterior is completed by a resurfaced driveway with plenty of parking for family and friends. Experience the best of Elmira living in this beautifully maintained and thoughtfully designed property. (id:62650)" +"Appliances": array:9 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" 6 => "Hood Fan" 7 => "Window Coverings" 8 => "Garage door opener" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:2 [ 0 => "School Bus" 1 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-19T19:26:09.327311+00:00" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FireplaceFeatures": array:2 [ 0 => "Wood" 1 => "Stove" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Stove" 1 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2099510" +"ListOfficeKey": "292918" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Paved driveway" 1 => "Automatic Garage Door Opener" ] +"LotSizeDimensions": "0.178" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-19T17:11:02Z" +"PhotosCount": 39 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-20T19:33:09Z" +"Stories": "1.0" +"StreetName": "BURLWOOD" +"StreetNumber": "13" +"StreetSuffix": "Drive" +"SubdivisionName": "550 - Elmira" +"TaxAnnualAmount": "5260" +"Utilities": array:1 [ 0 => "Natural Gas" ] +"VirtualTourURLUnbranded": "https://youriguide.com/ddmf9_13_burlwood_dr_elmira_on/" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:16 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] 15 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29770382/13-burlwood-drive-elmira" +"ParkingTotal": 6 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "1600677" +"CommonInterest": "Freehold" +"CoListOfficeKey": "294047" +"GeocodeManualYN": true +"ZoningDescription": "R1" +"BedroomsAboveGrade": 1 +"BedroomsBelowGrade": 3 +"FrontageLengthNumeric": 55.0 +"AboveGradeFinishedArea": 1270 +"BelowGradeFinishedArea": 1233 +"OriginalEntryTimestamp": "2026-05-19T17:11:01.87Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1369669" +"ListOfficeNationalAssociationId": "1419429" +"CoListAgentNationalAssociationId": "1148143" +"CoListOfficeNationalAssociationId": "1435346" +"Media": array:39 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] ] +"DaysOnMarket": 43 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29770382')" +"ID": "1436652" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24641 +post_id: "1449403" +post_author: 1 +"ListingKey": "29782385" +"ListingId": "40831184" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-06T01:01:15Z" +"RFModificationTimestamp": "2026-06-06T01:05:43Z" +"ListPrice": 849000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 1.58 +"LivingArea": 2699.0 +"BuildingAreaTotal": 0 +"City": "Eden" +"PostalCode": "N0J1H0" +"UnparsedAddress": "10475 PLANK Road, Eden, Ontario N0J1H0" +"Coordinates": array:2 [ 0 => -80.7615728 1 => 42.7725219 ] +"Latitude": 42.7725219 +"Longitude": -80.7615728 +"YearBuilt": 1991 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to this spacious and well-maintained 5-bedroom, 3-bathroom home set on approximately 1.5 acres in the quiet community of Eden-an ideal setting for growing families looking for space, comfort, and a peaceful rural lifestyle. Step inside to a welcoming, oversized foyer that leads to a bright living room on the left-perfect for relaxing or entertaining. Down the hall, you'll find a beautifully finished 3-piece bathroom featuring a glass shower. Continue into the heart of the home where a well-appointed kitchen awaits, complete with white cabinetry, stainless steel appliances, and a built-in oven. Just off the kitchen is a convenient mudroom/laundry room, perfect for busy family life. The kitchen opens into a spacious dining and family room area highlighted by a cozy gas fireplace, creating a warm gathering space for everyday living and entertaining. Sliding doors lead out to the back deck, making indoor-outdoor living easy. The main floor also features a private primary bedroom retreat with a walk-in closet and its own ensuite bathroom. Upstairs, you'll find four generously sized bedrooms-each with large closets-along with a 4-piece bathroom, providing plenty of room for children, guests, or a home office setup. The unfinished basement offers a large partially framed space, presenting an excellent opportunity to expand your living area and customize it to suit your needs. Outside, enjoy the privacy of a beautiful 1.5-acre lot surrounded by mature trees-perfect for kids to play, outdoor entertaining, or simply enjoying the peaceful setting. The property also features a commercial-grade driveway completed in 2025, providing exceptional durability and plenty of parking space for family and guests. Conveniently located just 15 minutes to Tillsonburg and 15 minutes to the beaches of Port Burwell, you'll enjoy the perfect balance of rural tranquility and nearby amenities. Move-in ready with room to grow-this is the perfect place to call home. (id:62650)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Central Vacuum" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" 6 => "Garage door opener" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-21T14:40:16.814260+00:00" +"Directions": "Property is on the West side of Plank Rd appox 2 km south of Eden" +"ExteriorFeatures": array:3 [ 0 => "Brick" 1 => "Aluminum siding" 2 => "Vinyl siding" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2208532" +"ListOfficeKey": "292003" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Country residential" ] +"LotSizeDimensions": "1.58" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-28T00:11:41Z" +"PhotosCount": 35 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-06T00:51:11Z" +"Stories": "2.0" +"StreetName": "PLANK" +"StreetNumber": "10475" +"StreetSuffix": "Road" +"SubdivisionName": "Eden" +"TaxAnnualAmount": "5391.32" +"Utilities": array:3 [ 0 => "Natural Gas" 1 => "Electricity" 2 => "Telephone" ] +"WaterSource": array:2 [ 0 => "Cistern" 1 => "Dug 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/29782385/10475-plank-road-eden" +"ParkingTotal": 10 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "1967495" +"CommonInterest": "Freehold" +"CoListOfficeKey": "292150" +"GeocodeManualYN": true +"ZoningDescription": "RR" +"BedroomsAboveGrade": 5 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 768.0 +"AboveGradeFinishedArea": 2699 +"OriginalEntryTimestamp": "2026-05-21T14:11:15.8Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1454979" +"ListOfficeNationalAssociationId": "1407357" +"CoListAgentNationalAssociationId": "1255506" +"CoListOfficeNationalAssociationId": "1408460" +"Media": array:35 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] ] +"DaysOnMarket": 41 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29782385')" +"ID": "1449403" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24640 +post_id: "1434290" +post_author: 1 +"ListingKey": "29769162" +"ListingId": "40831180" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-22T20:00:03Z" +"RFModificationTimestamp": "2026-06-22T20:03:12Z" +"ListPrice": 99900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 888.0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2J3Z4" +"UnparsedAddress": "580 BEAVER CREEK Road Unit# 243, Waterloo, Ontario N2J3Z4" +"Coordinates": array:2 [ 0 => -80.5898148 1 => 43.485394 ] +"Latitude": 43.485394 +"Longitude": -80.5898148 +"YearBuilt": 1986 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "We are excited to present this incredible opportunity! This sought-after 2-bedroom trailer offers 888 sq. ft. of comfortable indoor living space, complete with a spacious addition and several recent updates, including a new furnace and water heater (2024).Large windows fill the space with natural light, while the open-concept living, kitchen, and dining areas create the perfect setting for everyday living and easy entertaining. The oversized kitchen island/table provides ample prep and gathering space, adding to the home’s functional and welcoming layout.Step outside and enjoy peaceful outdoor living with room to garden or relax on the back patio beneath the 10' x 12' steel-top gazebo. A 7' x 7' shed offers convenient additional storage. The park itself is exceptionally well maintained and ideally located beside the beautiful Laurel Creek Conservation Area, offering easy access to hiking, biking, and nature trails. Enjoy peaceful sunsets over surrounding farmland while remaining just minutes from shopping, the St. Jacobs Farmers’ Market (5.1 km), and HWY 85 (5.5 km). Residents enjoy an impressive list of amenities, including a heated pool, two hot tubs, playground, mini golf, recreation hall, games room, fishing pond, seasonal tractor rides, and activities for all ages. Book your showing today! (id:62650)" +"Appliances": array:4 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Stove" 3 => "Dryer" ] +"ArchitecturalStyle": array:1 [ 0 => "Mobile Home" ] +"Basement": array:1 [ 0 => "None" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"Cooling": array:1 [ 0 => "Window air conditioner" ] +"CreationDate": "2026-05-19T17:13:23.763759+00:00" +"Directions": "At 580 Beaver Creek Rd, enter park & once through gated entrance, turn South, turn Left on first street on the Left (after parking area), pass Pond on Left & first roadway after pond, Turn Left. Unit is around the first bend on the Right Hand Side" +"ExteriorFeatures": array:2 [ 0 => "Aluminum siding" 1 => "Vinyl siding" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Propane" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2094304" +"ListOfficeKey": "297560" +"LivingAreaUnits": "square feet" +"ParkingFeatures": array:1 [ 0 => "Open" ] +"PhotosChangeTimestamp": "2026-05-19T15:14:31Z" +"PhotosCount": 36 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-22T19:52:39Z" +"Stories": "1.0" +"StreetName": "BEAVER CREEK" +"StreetNumber": "580" +"StreetSuffix": "Road" +"SubdivisionName": "441 - Erbsville/Laurelwood" +"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/29769162/580-beaver-creek-road-unit-243-waterloo" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "Mobile Home" ] +"CoListAgentKey": "2245088" +"CommonInterest": "Leasehold" +"CoListOfficeKey": "292918" +"GeocodeManualYN": true +"ZoningDescription": "FD1" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 0.0 +"AboveGradeFinishedArea": 888 +"OriginalEntryTimestamp": "2026-05-19T15:11:13.74Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Owner" +"ListAgentNationalAssociationId": "1366723" +"ListOfficeNationalAssociationId": "1467595" +"CoListAgentNationalAssociationId": "1483759" +"CoListOfficeNationalAssociationId": "1419429" +"Media": array:36 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] ] +"DaysOnMarket": 43 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29769162')" +"ID": "1434290" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25068 +post_id: "1447412" +post_author: 1 +"ListingKey": "29770233" +"ListingId": "40831178" +"PropertyType": "Other" +"PropertySubType": "Other" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T15:25:27Z" +"RFModificationTimestamp": "2026-06-02T15:32:55Z" +"ListPrice": 0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0.61 +"LivingArea": 1800.0 +"BuildingAreaTotal": 0 +"City": "Brantford" +"PostalCode": "N3R2J4" +"UnparsedAddress": "160 CHARING CROSS Street Unit# Lower, Brantford, Ontario N3R2J4" +"Coordinates": array:2 [ 0 => -80.2613196 1 => 43.1576124 ] +"Latitude": 43.1576124 +"Longitude": -80.2613196 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc" +"PublicRemarks": "Your business will thrive in this highly versatile commercial/retail space located on one of Brantford’s main arteries. Charing Cross Street offers excellent visibility and exposure, connecting the city’s downtown core with North Brantford and providing strong daily traffic counts. The municipality’s new IC zoning permits a wide range of commercial uses, making this an ideal opportunity for many types of businesses. This unit features approximately 1800 sq. ft. of wide-open space that can be utilized in many ways to suit your needs. Perfect for storage, distribution, or operational support. Currently a blank slate, this unit is ready to be customized and built out to create your ideal business environment. Could include fenced-in area at the rear of the property. This unit could accommodate plumbing and metered hydro. Ample on-site parking is available for both customers and staff. New pavement and facade are expected by end of July (id:62783)" +"AssociationFeeIncludes": array:4 [ 0 => "Common Area Maintenance" 1 => "Landscaping" 2 => "Property Management" 3 => "Insurance" ] +"Basement": array:1 [ 0 => "None" ] +"BuildingAreaUnits": "square feet" +"CommunityFeatures": array:1 [ 0 => "High Traffic Area" ] +"ConstructionMaterials": array:2 [ 0 => "Concrete block" 1 => "Concrete Walls" ] +"CreationDate": "2026-05-19T17:24:18.698058+00:00" +"ExteriorFeatures": array:1 [ 0 => "Concrete" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1398886" +"ListOfficeKey": "289711" +"LivingAreaUnits": "square feet" +"LotSizeDimensions": "0.61" +"PhotosChangeTimestamp": "2026-05-19T16:55:02Z" +"PhotosCount": 3 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T15:15:12Z" +"Stories": "1.0" +"StreetName": "CHARING CROSS" +"StreetNumber": "160" +"StreetSuffix": "Street" +"SubdivisionName": "2041 - Terrace Hill" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Brantford" +"ListAORKey": "41" +"ListingURL": "www.realtor.ca/real-estate/29770233/160-charing-cross-street-unit-lower-brantford" +"StructureType": array:1 [ 0 => "Residential Commercial Mix" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"TotalActualRent": 2400 +"ExistingLeaseType": array:1 [ 0 => "Gross" ] +"ZoningDescription": "IC" +"LeaseAmountFrequency": "Monthly" +"FrontageLengthNumeric": 210.0 +"OriginalEntryTimestamp": "2026-05-19T16:55:02.72Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1112998" +"ListOfficeNationalAssociationId": "1380321" +"Media": array:3 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] ] +"DaysOnMarket": 43 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29770233')" +"ID": "1447412" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24534 +post_id: "1439366" +post_author: 1 +"ListingKey": "29775106" +"ListingId": "40831168" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T16:30:26Z" +"RFModificationTimestamp": "2026-06-02T16:32:46Z" +"ListPrice": 549000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1171.0 +"BuildingAreaTotal": 0 +"City": "Mississauga" +"PostalCode": "L5A3X3" +"UnparsedAddress": "3590 KANEFF Crescent Unit# 2013, Mississauga, Ontario L5A3X3" +"Coordinates": array:2 [ 0 => -79.6310225 1 => 43.5916302 ] +"Latitude": 43.5916302 +"Longitude": -79.6310225 +"YearBuilt": 1980 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to urban living with maximum square footage at Obelisk I, located at 3590 Kaneff Crescent. Unit 2013 is a sprawling 3-bedroom, 1-bathroom condo offering an expansive 1,171 square foot layout that provides incredible value. Perfect for growing families, downsizers, or professionals seeking a dedicated home office, this high-floor unit provides the space of a townhouse with the convenience of condo living. The open-concept living and dining area serves as the heart of the home, featuring oversized windows that flood the entire space with natural light and lead out to a private balcony with elevated city views. The updated kitchen features modern finishes and plenty of counter space, making meal preparation a breeze. Each of the three bedrooms is generously proportioned with ample closet space, sharing a well-appointed central bathroom. For added convenience, the unit includes an oversized in-suite laundry room that doubles as excellent storage space, and the property comes complete with two highly coveted underground parking spots. Situated in the highly desirable Mississauga Valleys neighbourhood, Obelisk I is an established, well-managed building offering an all-inclusive maintenance fee that covers heat, hydro, and water. Residents enjoy access to premium building amenities including an indoor pool, a fully equipped gym, a sauna, tennis courts, and a party room. You are just steps away from Square One Shopping Centre, public transit, the upcoming Hurontario LRT, and major highways like the 403, offering an unbeatable combination of space and location. (id:62650)" +"Appliances": array:5 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" ] +"AssociationFee": "1364" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:7 [ 0 => "Landscaping" 1 => "Property Management" 2 => "Heat" 3 => "Electricity" 4 => "Water" 5 => "Insurance" 6 => "Parking" ] +"Basement": array:1 [ 0 => "None" ] +"ConstructionMaterials": array:2 [ 0 => "Concrete block" 1 => "Concrete Walls" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-20T18:23:05.785616+00:00" +"Directions": "Mississauga Valley Rd to Kaneff Cres" +"ExteriorFeatures": array:1 [ 0 => "Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1878585" +"ListOfficeKey": "274404" +"LivingAreaUnits": "square feet" +"ParkingFeatures": array:2 [ 0 => "Underground" 1 => "Visitor Parking" ] +"PhotosChangeTimestamp": "2026-05-20T13:01:19Z" +"PhotosCount": 45 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:21:52Z" +"Stories": "1.0" +"StreetName": "KANEFF" +"StreetNumber": "3590" +"StreetSuffix": "Crescent" +"SubdivisionName": "0230 - Mississauga Valley" +"TaxAnnualAmount": "2647" +"VirtualTourURLUnbranded": "https://youriguide.com/2013_3590_kaneff_crescent_mississauga_on/" +"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/29775106/3590-kaneff-crescent-unit-2013-mississauga" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "Apartment" ] +"CommonInterest": "Condo/Strata" +"GeocodeManualYN": true +"BuildingFeatures": array:2 [ 0 => "Exercise Centre" 1 => "Party Room" ] +"ZoningDescription": "RA5" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"AboveGradeFinishedArea": 1171 +"OriginalEntryTimestamp": "2026-05-20T13:01:19.51Z" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1205133" +"ListOfficeNationalAssociationId": "1254957" +"Media": array:45 [ 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] ] +"DaysOnMarket": 42 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29775106')" +"ID": "1439366" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24575 +post_id: "1448774" +post_author: 1 +"ListingKey": "29788865" +"ListingId": "40831159" +"PropertyType": "Residential Income" +"PropertySubType": "Multi-family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-03T12:46:20Z" +"RFModificationTimestamp": "2026-06-03T12:51:19Z" +"ListPrice": 724900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 1830.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8T2W9" +"UnparsedAddress": "46 BEACONSFIELD Drive, Hamilton, Ontario L8T2W9" +"Coordinates": array:2 [ 0 => -79.834952 1 => 43.2137206 ] +"Latitude": 43.2137206 +"Longitude": -79.834952 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to this exceptional income-generating property nestled in one of Hamilton's most sought-after East Mountain neighbourhoods. This fully tenanted duplex delivers $4,290/month in gross rental income from day one — no renovations, no vacancy headaches, just returns. Sitting on a 50 x 100 ft lot, this property offers a generous footprint in a high-demand rental corridor. Main Floor Unit features a spacious 3-bedroom, 1-bathroom layout with comfortable living spaces and a floor plan that tenants love. Lower Unit mirrors the main floor with its own self-contained 3-bedroom, 1-bathroom configuration — maximizing your rental income potential under one roof. Both units are leased at market rents to reliable tenants, and the property includes 2 private driveway parking spots — a premium feature renters in this area consistently look for. This is a true turnkey acquisition with all the heavy lifting already done. The East Mountain location offers easy access to major commuter routes, transit, schools, shopping, and amenities — a perennial favourite for renters and a proven area for long-term appreciation. (id:62650)" +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-22T15:45:15.725626+00:00" +"Directions": "MOHAWK/UPPER OTTAWA/BEACONSFIELD" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2046407" +"ListOfficeKey": "282362" +"LivingAreaUnits": "square feet" +"NumberOfUnitsTotal": "2" +"PhotosChangeTimestamp": "2026-05-22T11:51:40Z" +"PhotosCount": 35 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-03T11:50:53Z" +"Stories": "1.0" +"StreetName": "BEACONSFIELD" +"StreetNumber": "46" +"StreetSuffix": "Drive" +"SubdivisionName": "260 - Berrisfield" +"TaxAnnualAmount": "4835.75" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29788865/46-beaconsfield-drive-hamilton" +"ParkingTotal": 3 +"StructureType": array:1 [ 0 => "Duplex" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R1" +"FrontageLengthNumeric": 50.0 +"AboveGradeFinishedArea": 915 +"BelowGradeFinishedArea": 915 +"OriginalEntryTimestamp": "2026-05-22T11:51:40.4Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1321830" +"ListOfficeNationalAssociationId": "1320359" +"Media": array:35 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] ] +"DaysOnMarket": 40 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29788865')" +"ID": "1448774" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24526 +post_id: "1434038" +post_author: 1 +"ListingKey": "29768403" +"ListingId": "40831156" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T16:30:21Z" +"RFModificationTimestamp": "2026-06-02T16:33:22Z" +"ListPrice": 869900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 2700.0 +"BuildingAreaTotal": 0 +"City": "Waterford" +"PostalCode": "N0E1Y0" +"UnparsedAddress": "9 PURSEL Street, Waterford, Ontario N0E1Y0" +"Coordinates": array:2 [ 0 => -80.2961517 1 => 42.9421326 ] +"Latitude": 42.9421326 +"Longitude": -80.2961517 +"YearBuilt": 2022 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Modern comfort meets small-town charm in this 2022-built bungalow nestled in the family-friendly Villages of Waterford. At the heart of the home is a designer kitchen that will impress any home chef — crisp white shaker cabinetry, quartz countertops, full-height quartz backsplash, a generous island with seating for casual meals, corner pantry, gas range, and stainless steel appliances all illuminated by pot lights and under-cabinet lighting. The open-concept main floor flows effortlessly from kitchen to dining to living room, with patio doors leading to your private backyard retreat and storage shed. Retreat to the spacious primary suite featuring a walk-in closet and beautiful ensuite with his-and-hers sinks and a large walk-in shower — your own private oasis at the end of the day. A second main-floor bedroom rounds out one-floor living, while the fully finished lower level adds a self-contained in-law suite with kitchenette and three additional bedrooms. A double-car garage, all appliances included, and a prime location within walking distance of two elementary schools and the local high school make this the lifestyle home your family has been waiting for. (id:62650)" +"Appliances": array:9 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water meter" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" 6 => "Central Vacuum - Roughed In" 7 => "Window Coverings" 8 => "Garage door opener" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CommunityFeatures": array:1 [ 0 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-19T15:07:25.341973+00:00" +"Directions": "Main Street North to Gibbons, Left on Amber, Right on Pursel to #9" +"ExteriorFeatures": array:3 [ 0 => "Brick" 1 => "Stone" 2 => "Vinyl siding" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2173239" +"ListOfficeKey": "48558" +"LivingAreaUnits": "square feet" +"LotFeatures": array:4 [ 0 => "Crushed stone driveway" 1 => "Sump Pump" 2 => "Automatic Garage Door Opener" 3 => "In-Law Suite" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-19T13:50:27Z" +"PhotosCount": 37 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:21:54Z" +"Stories": "1.0" +"StreetName": "PURSEL" +"StreetNumber": "9" +"StreetSuffix": "Street" +"SubdivisionName": "Waterford" +"TaxAnnualAmount": "5068" +"Utilities": array:4 [ 0 => "Natural Gas" 1 => "Electricity" 2 => "Cable" 3 => "Telephone" ] +"VirtualTourURLUnbranded": "https://vimeo.com/1192349760?share=copy&fl=sv&fe=ci" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:15 [ 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] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29768403/9-pursel-street-waterford" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "1672163" +"CommonInterest": "Freehold" +"CoListOfficeKey": "48559" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "R1-B" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 3 +"FrontageLengthNumeric": 45.0 +"AboveGradeFinishedArea": 1435 +"BelowGradeFinishedArea": 1265 +"OriginalEntryTimestamp": "2026-05-19T13:50:27Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1423696" +"ListOfficeNationalAssociationId": "1004255" +"CoListAgentNationalAssociationId": "1170625" +"CoListOfficeNationalAssociationId": "1091951" +"Media": array:37 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] ] +"DaysOnMarket": 43 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29768403')" +"ID": "1434038" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24532 +post_id: "1459946" +post_author: 1 +"ListingKey": "29804683" +"ListingId": "40831155" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T16:30:36Z" +"RFModificationTimestamp": "2026-06-02T16:31:19Z" +"ListPrice": 989900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1612.0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L6N2" +"UnparsedAddress": "147 REIBER Court, Waterloo, Ontario N2L6N2" +"Coordinates": array:2 [ 0 => -80.5520868 1 => 43.4557802 ] +"Latitude": 43.4557802 +"Longitude": -80.5520868 +"YearBuilt": 2002 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Nestled on a quiet, private court in Waterloo's sought-after Beechwood neighbourhood, this beautifully maintained brick bungaloft offers the perfect blend of comfort, style, and everyday functionality. The meticulously landscaped front gardens — bursting with colour and mature plantings — and covered front porch create instant curb appeal that sets this home apart. Step inside to a thoughtfully designed main floor featuring soaring 9' ceilings across 1,612 square feet above grade, rich hardwood flooring and a gas fireplace in the great room, elegant crown moulding in the dining room, and California shutters throughout. The stunning renovated kitchen (2020) features crisp white cabinetry, granite countertops, a classic subway tile backsplash, stainless steel appliances, and a bright eat-in area with bay window — a true chef's delight..... Step inside the dining room perfect for hosting or a home office setup. The primary bedroom and a well appointed full bathroom complete the main level, while the loft provides a private second bedroom with its own full bathroom and hardwood flooring. The fully finished basement adds a spacious recreation room, flexible third bedroom or office/den, a third full bathroom, and generous storage. Outside, the fully fenced backyard is an absolute showstopper — lush perennial gardens, mature trees, and vibrant florals frame a composite deck topped with a stunning pergola, the perfect setting for outdoor entertaining or peaceful relaxation. The double car garage and beautifully maintained exterior complete with concrete driveway & entrance round out this exceptional package. Minutes from The Boardwalk shopping, transit, top-rated schools, both Universities, Westmount Golf & Country Club, and scenic walking trails — 147 Reiber Court is a rare Beechwood gem not to be missed. (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CommunityFeatures": array:3 [ 0 => "Quiet Area" 1 => "School Bus" 2 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-26T14:12:31.353317+00:00" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2016330" +"ListOfficeKey": "283168" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Cul-de-sac" 1 => "Corner Site" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-26T13:32:35Z" +"PhotosCount": 42 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:21:54Z" +"Stories": "1.5" +"StreetName": "REIBER" +"StreetNumber": "147" +"StreetSuffix": "Court" +"SubdivisionName": "417 - Beechwood/University" +"TaxAnnualAmount": "6199" +"VirtualTourURLUnbranded": "https://youriguide.com/147_reiber_ct_waterloo_on/" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:13 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29804683/147-reiber-court-waterloo" +"ParkingTotal": 6 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R2" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 54.0 +"AboveGradeFinishedArea": 1612 +"OriginalEntryTimestamp": "2026-05-26T13:31:35.63Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1297578" +"ListOfficeNationalAssociationId": "1325206" +"Media": array:42 [ 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] ] +"DaysOnMarket": 36 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29804683')" +"ID": "1459946" } ] +success: true +page_size: 12 +page_count: 16650 +count: 199793 +after_key: "" } "RF Response Time" => "0.19 seconds" ] ]