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=150648&$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 {#24531 +items: array:12 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24660 +post_id: "1561660" +post_author: 1 +"ListingKey": "29946673" +"ListingId": "40842645" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-25T19:20:07Z" +"RFModificationTimestamp": "2026-06-25T19:50:46Z" +"ListPrice": 1379999.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 3309.0 +"BuildingAreaTotal": 0 +"City": "Waterdown" +"PostalCode": "L8B0N9" +"UnparsedAddress": "5 SHETLAND Drive, Waterdown, Ontario L8B0N9" +"Coordinates": array:2 [ 0 => -79.9140968 1 => 43.3249347 ] +"Latitude": 43.3249347 +"Longitude": -79.9140968 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 5 Shetland Dr in the heart of Waterdown, a fully updated home that blends timeless design with high end, executive finishes throughout. Every detail has been thoughtfully curated, offering a true turnkey experience for today’s modern buyer. The main level showcases stunning updates completed in 2021, including a custom kitchen with a large island, updated hardwood flooring, a striking new main staircase, and elegant coffered and California knockdown ceilings. Natural light pours in through updated windows, while a custom fiberglass front door with a Euro locking system adds both style and security. Upstairs, all bathrooms have been beautifully renovated, highlighted by a luxurious ensuite featuring in floor heating and a towel warmer, creating a spa like retreat right at home. The fully finished basement, completed in 2022, adds incredible versatility with a kitchenette and bar setup, offering excellent in law potential or the perfect space for entertaining. Step outside to enjoy a professionally finished 20 x 20 stamped concrete patio, ideal for relaxing or hosting summer gatherings. Additional updates include the roof in 2016, garage doors and openers in 2018, and California shutters installed in 2022. Located in one of Waterdown’s most desirable neighbourhoods, this home offers refined living with nothing left to do but move in and enjoy. (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Garage door opener" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-25T19:50:34.028703+00:00" +"Directions": "Hoilybush to Arnhem Crt to Shetland Drive" +"ExteriorFeatures": array:2 [ 0 => "Vinyl siding" 1 => "Brick Veneer" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1981716" +"ListOfficeKey": "299866" +"LivingAreaUnits": "square feet" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-06-24T15:32:08Z" +"PhotosCount": 50 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-25T19:10:58Z" +"Stories": "2.0" +"StreetName": "SHETLAND" +"StreetNumber": "5" +"StreetSuffix": "Drive" +"SubdivisionName": "460 - Waterdown West" +"TaxAnnualAmount": "7602.72" +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=XL7yVjgL3Px" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:21 [ 0 => array:11 [ "RoomKey" => "1667945756" "RoomType" => "Storage" "ListingId" => "40842645" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29946673" "RoomLength" => null "RoomDimensions" => "11'3'' x 11'10''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-25T19:10:58.97Z" ] 1 => array:11 [ "RoomKey" => "1667945757" "RoomType" => "3pc Bathroom" "ListingId" => "40842645" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29946673" "RoomLength" => null "RoomDimensions" => "8'4'' x 11'3''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-25T19:10:58.97Z" ] 2 => array:11 [ "RoomKey" => "1667945758" "RoomType" => "Other" "ListingId" => "40842645" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29946673" "RoomLength" => null "RoomDimensions" => "9'4'' x 10'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-25T19:10:58.97Z" ] 3 => array:11 [ "RoomKey" => "1667945759" "RoomType" => "Other" "ListingId" => "40842645" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29946673" "RoomLength" => null "RoomDimensions" => "3'4'' x 11'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-25T19:10:58.97Z" ] 4 => array:11 [ "RoomKey" => "1667945760" "RoomType" => "Dinette" "ListingId" => "40842645" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29946673" "RoomLength" => null "RoomDimensions" => "10'5'' x 13'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-25T19:10:58.98Z" ] 5 => array:11 [ "RoomKey" => "1667945761" "RoomType" => "Recreation room" "ListingId" => "40842645" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29946673" "RoomLength" => null "RoomDimensions" => "30'2'' x 10'3''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-25T19:10:58.98Z" ] 6 => array:11 [ "RoomKey" => "1667945762" "RoomType" => "3pc Bathroom" "ListingId" => "40842645" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29946673" "RoomLength" => null "RoomDimensions" => "6'2'' x 11'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-25T19:10:58.99Z" ] 7 => array:11 [ "RoomKey" => "1667945763" "RoomType" => "Bedroom" "ListingId" => "40842645" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29946673" "RoomLength" => null "RoomDimensions" => "13'0'' x 10'11''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-25T19:10:58.99Z" ] 8 => array:11 [ "RoomKey" => "1667945764" "RoomType" => "Bedroom" "ListingId" => "40842645" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29946673" "RoomLength" => null "RoomDimensions" => "9'8'' x 10'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-25T19:10:58.99Z" ] 9 => array:11 [ "RoomKey" => "1667945765" "RoomType" => "Bedroom" "ListingId" => "40842645" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29946673" "RoomLength" => null "RoomDimensions" => "10'2'' x 12'9''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-25T19:10:58.99Z" ] 10 => array:11 [ "RoomKey" => "1667945766" "RoomType" => "Full bathroom" "ListingId" => "40842645" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29946673" "RoomLength" => null "RoomDimensions" => "10'10'' x 11'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-25T19:10:58.99Z" ] 11 => array:11 [ "RoomKey" => "1667945767" "RoomType" => "Primary Bedroom" "ListingId" => "40842645" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29946673" "RoomLength" => null "RoomDimensions" => "14'1'' x 24'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-25T19:10:58.99Z" ] 12 => array:11 [ "RoomKey" => "1667945768" "RoomType" => "Mud room" "ListingId" => "40842645" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29946673" "RoomLength" => null "RoomDimensions" => "7'9'' x 8'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-25T19:10:58.99Z" ] 13 => array:11 [ "RoomKey" => "1667945769" "RoomType" => "Laundry room" "ListingId" => "40842645" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29946673" "RoomLength" => null "RoomDimensions" => "9'3'' x 6'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-25T19:10:58.99Z" ] 14 => array:11 [ "RoomKey" => "1667945770" "RoomType" => "2pc Bathroom" "ListingId" => "40842645" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29946673" "RoomLength" => null "RoomDimensions" => "3'2'' x 6'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-25T19:10:58.99Z" ] 15 => array:11 [ "RoomKey" => "1667945771" "RoomType" => "Family room" "ListingId" => "40842645" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29946673" "RoomLength" => null "RoomDimensions" => "16'2'' x 11'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-25T19:10:58.99Z" ] 16 => array:11 [ "RoomKey" => "1667945772" "RoomType" => "Breakfast" "ListingId" => "40842645" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29946673" "RoomLength" => null "RoomDimensions" => "17'0'' x 12'3''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-25T19:10:59Z" ] 17 => array:11 [ "RoomKey" => "1667945773" "RoomType" => "Kitchen" "ListingId" => "40842645" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29946673" "RoomLength" => null "RoomDimensions" => "10'11'' x 10'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-25T19:10:59Z" ] 18 => array:11 [ "RoomKey" => "1667945774" "RoomType" => "Dining room" "ListingId" => "40842645" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29946673" "RoomLength" => null "RoomDimensions" => "9'9'' x 13'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-25T19:10:59Z" ] 19 => array:11 [ "RoomKey" => "1667945775" "RoomType" => "Great room" "ListingId" => "40842645" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29946673" "RoomLength" => null "RoomDimensions" => "13'5'' x 14'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-25T19:10:59Z" ] 20 => array:11 [ "RoomKey" => "1667945776" "RoomType" => "Foyer" "ListingId" => "40842645" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29946673" "RoomLength" => null "RoomDimensions" => "6'11'' x 5'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-25T19:10:59Z" ] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29946673/5-shetland-drive-waterdown" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "2147849" +"CommonInterest": "Freehold" +"CoListOfficeKey": "299867" +"GeocodeManualYN": true +"ZoningDescription": "R1-2" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 50.0 +"AboveGradeFinishedArea": 2340 +"BelowGradeFinishedArea": 969 +"OriginalEntryTimestamp": "2026-06-24T15:32:08.62Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1267128" +"ListOfficeNationalAssociationId": "1477944" +"CoListAgentNationalAssociationId": "1398898" +"CoListOfficeNationalAssociationId": "1477945" +"Media": array:50 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "29946673_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/78588930c20d48e5a367533aeda97fad.webp" "MediaSize" => 170059 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-78588930c20d48e5a367533aeda97fad.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Brick facade residence featuring a double-door garage and a paved driveway" "PreferredPhotoYN" => true "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "29946673_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/30455f8c078981daad1b30030a6871e6.webp" "MediaSize" => 192415 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-30455f8c078981daad1b30030a6871e6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Brick exterior home featuring a two-car garage, arched windows, and a landscaped front yard with mature trees" "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "29946673_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/3ec8c948df9c0b8748c4f575ad7e3cde.webp" "MediaSize" => 133575 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-3ec8c948df9c0b8748c4f575ad7e3cde.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "29946673_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/5b46d9796027da8c6b8f904e1b516011.webp" "MediaSize" => 125996 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-5b46d9796027da8c6b8f904e1b516011.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "29946673_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/9d33c940b9ee68db323a3870029a36c6.webp" "MediaSize" => 123999 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-9d33c940b9ee68db323a3870029a36c6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "29946673_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/2963d9fcfa9d1d49acb2f4b700207e69.webp" "MediaSize" => 96353 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-2963d9fcfa9d1d49acb2f4b700207e69.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "29946673_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/f5ccbb419f25c0271eb51fb6d3bd46ad.webp" "MediaSize" => 82260 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-f5ccbb419f25c0271eb51fb6d3bd46ad.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "29946673_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/e0d181f875f09442bb435ad9e363741b.webp" "MediaSize" => 96283 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-e0d181f875f09442bb435ad9e363741b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "29946673_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/180a06dc5b898f7640096b6b7dcf743f.webp" "MediaSize" => 114853 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-180a06dc5b898f7640096b6b7dcf743f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "29946673_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/67999fbe02f6f6757a3c3450c7f86cbf.webp" "MediaSize" => 99811 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-67999fbe02f6f6757a3c3450c7f86cbf.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "29946673_4890_11" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/b3202f3e63331fe8ee4642bfb71819cc.webp" "MediaSize" => 103231 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-b3202f3e63331fe8ee4642bfb71819cc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "29946673_4890_12" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/ada5a8a3513979de067360c125dc688b.webp" "MediaSize" => 112642 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-ada5a8a3513979de067360c125dc688b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "29946673_4890_13" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/7d83d52898f7d7fc4326c77695334fd6.webp" "MediaSize" => 90764 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-7d83d52898f7d7fc4326c77695334fd6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 13 => array:13 [ "Order" => 14 "MediaKey" => "29946673_4890_14" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/b6c8b03f4052f90a24f7f9aadf0549b0.webp" "MediaSize" => 110421 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-b6c8b03f4052f90a24f7f9aadf0549b0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 14 => array:13 [ "Order" => 15 "MediaKey" => "29946673_4890_15" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/f414205460c9fbfb7998bc70e64a72a4.webp" "MediaSize" => 112566 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-f414205460c9fbfb7998bc70e64a72a4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 15 => array:13 [ "Order" => 16 "MediaKey" => "29946673_4890_16" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/45200c9348f117eb5de3d2408023fa02.webp" "MediaSize" => 104538 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-45200c9348f117eb5de3d2408023fa02.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 16 => array:13 [ "Order" => 17 "MediaKey" => "29946673_4890_17" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/7b62261a4b6669359ff85272fe4d4118.webp" "MediaSize" => 104937 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-7b62261a4b6669359ff85272fe4d4118.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 17 => array:13 [ "Order" => 18 "MediaKey" => "29946673_4890_18" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/0b6d1c1e124272120b0de11a21b184ee.webp" "MediaSize" => 113340 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-0b6d1c1e124272120b0de11a21b184ee.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 18 => array:13 [ "Order" => 19 "MediaKey" => "29946673_4890_19" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/5a6c006884e333b620a9e0adcde34a87.webp" "MediaSize" => 51239 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-5a6c006884e333b620a9e0adcde34a87.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 19 => array:13 [ "Order" => 20 "MediaKey" => "29946673_4890_20" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/83c6cd3286fe8fd44da84f1f964a7e3b.webp" "MediaSize" => 56702 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-83c6cd3286fe8fd44da84f1f964a7e3b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 20 => array:13 [ "Order" => 21 "MediaKey" => "29946673_4890_21" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/89d593d07301d248d06b799de0eaf16f.webp" "MediaSize" => 142057 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-89d593d07301d248d06b799de0eaf16f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 21 => array:13 [ "Order" => 22 "MediaKey" => "29946673_4890_22" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/bcc2e22939fdf33432efc2e9acfe356b.webp" "MediaSize" => 97218 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-bcc2e22939fdf33432efc2e9acfe356b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 22 => array:13 [ "Order" => 23 "MediaKey" => "29946673_4890_23" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/0f40f1ed6d0c3727268597d547f7f4b8.webp" "MediaSize" => 84927 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-0f40f1ed6d0c3727268597d547f7f4b8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 23 => array:13 [ "Order" => 24 "MediaKey" => "29946673_4890_24" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/7b523a11b8ea2729bd141e56a2ce9291.webp" "MediaSize" => 107031 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-7b523a11b8ea2729bd141e56a2ce9291.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 24 => array:13 [ "Order" => 25 "MediaKey" => "29946673_4890_25" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/3bd3e3de6c321cf3c9a92903499c37c0.webp" "MediaSize" => 87366 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-3bd3e3de6c321cf3c9a92903499c37c0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 25 => array:13 [ "Order" => 26 "MediaKey" => "29946673_4890_26" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/b5569badca1129037a3243dc5730e233.webp" "MediaSize" => 89516 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-b5569badca1129037a3243dc5730e233.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 26 => array:13 [ "Order" => 27 "MediaKey" => "29946673_4890_27" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/92825c3cc51ff09b35d9f0102dd61bc4.webp" "MediaSize" => 72602 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-92825c3cc51ff09b35d9f0102dd61bc4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 27 => array:13 [ "Order" => 28 "MediaKey" => "29946673_4890_28" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/e33e71643c7ed6507378b801a56a3c0f.webp" "MediaSize" => 104759 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-e33e71643c7ed6507378b801a56a3c0f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 28 => array:13 [ "Order" => 29 "MediaKey" => "29946673_4890_29" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/c6986335f98a129cfb101365e8bd5af6.webp" "MediaSize" => 82303 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-c6986335f98a129cfb101365e8bd5af6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 29 => array:13 [ "Order" => 30 "MediaKey" => "29946673_4890_30" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/a26508ecd7bafe6e30b323ee47fcb657.webp" "MediaSize" => 128505 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946673/thumbnail-a26508ecd7bafe6e30b323ee47fcb657.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842645" "ResourceRecordKey" => "29946673" "ModificationTimestamp" => "2026-06-24T15:32:08.63Z" ] 30 => array:13 [ "Order" => 31 "MediaKey" => "29946673_4890_31" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946673/4315103156fcfdce802a26128b680020.webp" "MediaSize" => 64364 …9 ] 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": 8 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946673')" +"ID": "1561660" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24504 +post_id: "1561857" +post_author: 1 +"ListingKey": "29946407" +"ListingId": "40842642" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-28T20:20:23Z" +"RFModificationTimestamp": "2026-06-28T20:25:12Z" +"ListPrice": 495000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 881.0 +"BuildingAreaTotal": 0 +"City": "Kitchener" +"PostalCode": "N2G0C9" +"UnparsedAddress": "60 CHARLES Street Unit# 2705, Kitchener, Ontario N2G0C9" +"Coordinates": array:2 [ 0 => -80.4932775 1 => 43.4504496 ] +"Latitude": 43.4504496 +"Longitude": -80.4932775 +"YearBuilt": 2021 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to Charlie West! Views have no bounds with this UPGRADED 2 bedroom, 2 washroom + 1 Underground parking unit located in an excellent cared for condominium on the 27th floor, right in the heart of downtown Kitchener. With a scenic cityscape view from the window walls, sprawling from the living room to the bedroom - there is an abundance of natural light. Get ready to bask in the evening and enjoy stunning views from the comfort of your home. Or step out onto the large balcony to soak up the spring/summer/fall breeze and take in the beauty of the seasons. With high ceilings, all new stainless steel appliances, beautiful backsplash and countertops, hosting and entertaining will be an absolute joy in this home. With no shortage of storage either, there is plenty of cupboard space and closets throughout the unit, as well ensuite laundry which is tucked away perfectly to keep your home neat and tidy looking. Close to many amenities and attractions including; The Museum, The Aud, Victoria Park, Conestoga College, Iron Horse Trail, Grand River Hospital, and tons of restaurants and entertainment. (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Microwave Built-in" ] +"AssociationFee": "695.54" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:5 [ 0 => "Landscaping" 1 => "Property Management" 2 => "Heat" 3 => "Water" 4 => "Parking" ] +"Basement": array:1 [ 0 => "None" ] +"ConstructionMaterials": array:2 [ 0 => "Concrete block" 1 => "Concrete Walls" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-25T20:10:25.275659+00:00" +"Directions": "Charles and Gaukel" +"ExteriorFeatures": array:1 [ 0 => "Concrete" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2152269" +"ListOfficeKey": "290168" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Southern exposure" 1 => "Balcony" ] +"ParkingFeatures": array:2 [ 0 => "Underground" 1 => "Visitor Parking" ] +"PhotosChangeTimestamp": "2026-06-24T14:51:19Z" +"PhotosCount": 19 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-28T20:10:49Z" +"Stories": "1.0" +"StreetName": "CHARLES" +"StreetNumber": "60" +"StreetSuffix": "Street" +"SubdivisionName": "313 - Downtown Kitchener/W. Ward" +"TaxAnnualAmount": "4029.28" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:6 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29946407/60-charles-street-unit-2705-kitchener" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "Apartment" ] +"CommonInterest": "Condo/Strata" +"GeocodeManualYN": true +"BuildingFeatures": array:3 [ 0 => "Exercise Centre" 1 => "Guest Suite" 2 => "Party Room" ] +"ZoningDescription": "D1" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 0 +"AboveGradeFinishedArea": 881 +"OriginalEntryTimestamp": "2026-06-24T14:51:18.95Z" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1403932" +"ListOfficeNationalAssociationId": "1384313" +"Media": array:19 [ 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] ] +"DaysOnMarket": 8 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946407')" +"ID": "1561857" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24648 +post_id: "1566185" +post_author: 1 +"ListingKey": "29947546" +"ListingId": "40842640" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-28T20:20:24Z" +"RFModificationTimestamp": "2026-06-28T20:25:10Z" +"ListPrice": 389000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1173.0 +"BuildingAreaTotal": 0 +"City": "Nanticoke" +"PostalCode": "N0A1P0" +"UnparsedAddress": "4 HICKORY Hollow, Nanticoke, Ontario N0A1P0" +"Coordinates": array:2 [ 0 => -79.9666911 1 => 42.81153 ] +"Latitude": 42.81153 +"Longitude": -79.9666911 +"YearBuilt": 2013 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "A warm and welcoming waterfront haven! This charming 2-bedroom plus den, 2-bathroom open-concept bungalow offers the perfect blend of comfort and tranquility. The versatile den can easily serve as a home office, guest space, or even a third bedroom to suit your needs. Located in the quiet community of Sandusk Creek Properties Ltd., this year-round land lease home boasts one of the most desirable locations in the park, with direct waterfront views of Sandusk Creek. Imagine starting your day with a coffee on the back deck and ending it watching the gentle waves wash your worries away. Residents enjoy a wonderful lifestyle with access to an outdoor pool, walking trails, a dog park, organized social events, as well as lawn care and snow removal. Whether you're looking to relax, stay active, or connect with neighbours, you'll love being part of this vibrant waterfront community. RSA. (id:62650)" +"Appliances": array:8 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Hood Fan" 6 => "Window Coverings" 7 => "Microwave Built-in" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:1 [ 0 => "None" ] +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-26T01:56:00.607199+00:00" +"Directions": "South on Cheapside Road, Left turn at gated Community onto Murphys Lane" +"ExteriorFeatures": array:1 [ 0 => "Vinyl siding" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2168231" +"ListOfficeKey": "284635" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Country residential" ] +"PhotosChangeTimestamp": "2026-06-24T17:11:13Z" +"PhotosCount": 38 +"PoolFeatures": array:1 [ 0 => "Inground pool" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-28T20:10:49Z" +"Stories": "1.0" +"StreetName": "HICKORY" +"StreetNumber": "4" +"StreetSuffix": "Hollow" +"SubdivisionName": "876 - Nanticoke" +"TaxAnnualAmount": "1978" +"View": "Lake view" +"VirtualTourURLUnbranded": "https://showcase.wakefieldmediahouse.com/order/67621c9c-bc4d-448a-ab58-08dec87aae15" +"WaterBodyName": "SANDUSK CREEK" +"WaterSource": array:1 [ 0 => "Cistern" ] +"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/29947546/4-hickory-hollow-nanticoke" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "Modular" ] +"CommonInterest": "Leasehold" +"GeocodeManualYN": true +"ZoningDescription": "N A2, N A2F" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 0 +"WaterfrontFeatures": array:1 [ 0 => "Waterfront" ] +"FrontageLengthNumeric": 0.0 +"AboveGradeFinishedArea": 1173 +"OriginalEntryTimestamp": "2026-06-24T17:11:05.36Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Builder" +"ListAgentNationalAssociationId": "1418928" +"ListOfficeNationalAssociationId": "1344652" +"Media": array:38 [ 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] ] +"DaysOnMarket": 8 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947546')" +"ID": "1566185" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24522 +post_id: "1565084" +post_author: 1 +"ListingKey": "29950238" +"ListingId": "40842639" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-25T01:00:12Z" +"RFModificationTimestamp": "2026-06-25T22:31:18Z" +"ListPrice": 629900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1390.0 +"BuildingAreaTotal": 0 +"City": "Fergus" +"PostalCode": "N1M3P7" +"UnparsedAddress": "256 TAIT Crescent, Fergus, Ontario N1M3P7" +"Coordinates": array:2 [ 0 => -80.3588891 1 => 43.701835 ] +"Latitude": 43.701835 +"Longitude": -80.3588891 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "GORGEOUS FREEHOLD LINK HOME (end unit only attached at garage!). This turnkey 3-bedroom home offers carefree living in a highly desirable family-friendly location. Natural light pours through California shutters filling this bright open-concept home and illuminating the exceptional finishes throughout. Stunning floors set the stage a phenomenal kitchen with gleaming stainless appliances, backsplash & stone counters, flowing seamlessly to the living and dining areas, creating a warm and inviting atmosphere (perfect for both everyday living & entertaining!). Upstairs finds 3 generous bedrooms (including a massive primary) and beautifully renovated full bathroom. The upper levels have been adorned by premium fixtures and thoughtful design details, leaving an unspoiled basement to be tailored to whatever you desire! Now step outside to your private, professionally landscaped backyard featuring a beautiful patio—ideal for relaxing, dining, or hosting family and friends (summertime BBQ season is officially here!) Enjoy the convenience of being directly beside a park and playground, as well as a school with sports fields (it doesn’t get much better than that!) Plenty of parking accommodates family and guests with ease (ample street parking & with no sidewalk you can stack numerous cars in the driveway!) And the attached garage has been wonderfully finished should you want a getaway/work area (or a very cushy place to park your car!) Located just minutes from shopping, restaurants, and everyday amenities, this home combines comfort, style, and an unbeatable location. Simply move in and enjoy the perfect blend of modern living, outdoor space, and exceptional convenience. Don’t delay - make it yours today! (id:62783)" +"Appliances": array:8 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" 6 => "Hood Fan" 7 => "Garage door opener" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-25T22:30:16.474596+00:00" +"Directions": "Scotland to Millburn to Tait" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"Fencing": array:1 [ 0 => "Fence" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1947106" +"ListOfficeKey": "282964" +"LivingAreaUnits": "square feet" +"LotFeatures": array:4 [ 0 => "Southern exposure" 1 => "Sump Pump" 2 => "Automatic Garage Door Opener" 3 => "Private Yard" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-06-25T00:50:20Z" +"PhotosCount": 38 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-25T00:50:19Z" +"Stories": "2.0" +"StreetName": "TAIT" +"StreetNumber": "256" +"StreetSuffix": "Crescent" +"SubdivisionName": "53 - Fergus" +"TaxAnnualAmount": "3240" +"VirtualTourURLUnbranded": "https://tours.vastvue.ca/256-Tait-Crescent" +"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/29950238/256-tait-crescent-fergus" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "Row / Townhouse" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R3" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 32.0 +"AboveGradeFinishedArea": 1390 +"OriginalEntryTimestamp": "2026-06-25T00:50:19.56Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1241954" +"ListOfficeNationalAssociationId": "1323108" +"Media": array:38 [ 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] ] +"DaysOnMarket": 7 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29950238')" +"ID": "1565084" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24525 +post_id: "1566120" +post_author: 1 +"ListingKey": "29947366" +"ListingId": "40842638" +"PropertyType": "Other" +"PropertySubType": "Other" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-29T15:45:03Z" +"RFModificationTimestamp": "2026-06-29T15:49:11Z" +"ListPrice": 2449000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 11000.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9A3P9" +"UnparsedAddress": "600 UPPER WELLINGTON Street, Hamilton, Ontario L9A3P9" +"Coordinates": array:2 [ 0 => -79.867264 1 => 43.2377383 ] +"Latitude": 43.2377383 +"Longitude": -79.867264 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "This purpose-built, 3-storey brick building provides a strong investment opportunity on Hamilton Mountain. The property features 10 2-bedroom residential units and 4 commercial suites on the lower level. Key operational features include separately metered hydro, individual heating controls, and 10 on-site parking spaces. Situated steps from HSR transit routes, the location provides consistent tenant demand due to its close proximity to Juravinski Hospital and the Concession Street retail district. (id:62783)" +"Basement": array:1 [ 0 => "Full" ] +"BuildingAreaUnits": "square feet" +"CreationDate": "2026-06-26T02:10:25.076690+00:00" +"Directions": "Northwest from Fennell Ave and Upper Wellington St" +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1525010" +"ListOfficeKey": "291472" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Paved driveway" ] +"PhotosChangeTimestamp": "2026-06-29T15:40:04Z" +"PhotosCount": 18 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-29T15:40:04Z" +"Stories": "3.0" +"StreetName": "UPPER WELLINGTON" +"StreetNumber": "600" +"StreetSuffix": "Street" +"SubdivisionName": "171 - Centremount" +"TaxAnnualAmount": "39686" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29947366/600-upper-wellington-street-hamilton" +"ParkingTotal": 10 +"StructureType": array:1 [ 0 => "Residential Commercial Mix" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "C5" +"FrontageLengthNumeric": 75.0 +"OriginalEntryTimestamp": "2026-06-24T16:51:11.66Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1130682" +"ListOfficeNationalAssociationId": "1398404" +"Media": array:18 [ 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] ] +"DaysOnMarket": 8 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947366')" +"ID": "1566120" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24644 +post_id: "1563617" +post_author: 1 +"ListingKey": "29948002" +"ListingId": "40842634" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-30T13:30:22Z" +"RFModificationTimestamp": "2026-06-30T13:43:44Z" +"ListPrice": 599000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.21 +"LivingArea": 1979.0 +"BuildingAreaTotal": 0 +"City": "Brantford" +"PostalCode": "N3R3P6" +"UnparsedAddress": "6 TREELAWN Terrace, Brantford, Ontario N3R3P6" +"Coordinates": array:2 [ 0 => -80.253164 1 => 43.1765043 ] +"Latitude": 43.1765043 +"Longitude": -80.253164 +"YearBuilt": 1969 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Nestled on a quiet cul-de-sac in a desirable family-friendly neighbourhood, this spacious 4-bedroom, 2-bathroom side-split features exceptional potential for families, multi-generational living, or investors. Built in 1969, the home features a welcoming enclosed front porch, two kitchens, and a versatile lower level with a separate walkout to the backyard—ideal for a potential in-law suite. The main level features convenient access from the kitchen to the beautifully landscaped, fully fenced backyard, creating the perfect setting for outdoor entertaining, gardening, or family gatherings. The generous lot provides plenty of space for children and pets to play. While the home retains its original character and is ready for updating, it presents an excellent opportunity to renovate and add value while customizing the space to suit your needs. Enjoy the convenience of nearby schools, places of worship, shopping, parks, hiking trails, hospital services, and a wide range of everyday amenities. A rare opportunity to own a well-located property with flexible living options and outstanding potential in a sought-after community. (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Microwave" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Crawl space" ] +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-25T22:47:01.303595+00:00" +"Directions": "Wayne Gretzky Pkwy- Lynden Rd- Fairview Dr- Brier Park Rd- Treelawn Terrece" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"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": "1955749" +"ListOfficeKey": "54949" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Cul-de-sac" 1 => "Paved driveway" 2 => "Automatic Garage Door Opener" ] +"LotSizeDimensions": "0.21" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-06-30T13:01:58Z" +"PhotosCount": 35 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-30T13:21:24Z" +"Stories": "1.0" +"StreetName": "TREELAWN" +"StreetNumber": "6" +"StreetSuffix": "Terrace" +"SubdivisionName": "2013 - Brier Park" +"TaxAnnualAmount": "5120.3" +"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/videos/019ef8f9-c0f0-70a7-8c2e-55544b4a8b73" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"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/29948002/6-treelawn-terrace-brantford" +"ParkingTotal": 3 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "2209447" +"CommonInterest": "Freehold" +"CoListOfficeKey": "54949" +"GeocodeManualYN": true +"ZoningDescription": "R1B" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 43.0 +"AboveGradeFinishedArea": 1374 +"BelowGradeFinishedArea": 605 +"OriginalEntryTimestamp": "2026-06-24T18:11:27.33Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"BelowGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1247464" +"ListOfficeNationalAssociationId": "1003557" +"CoListAgentNationalAssociationId": "1455896" +"CoListOfficeNationalAssociationId": "1003557" +"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": 8 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29948002')" +"ID": "1563617" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24643 +post_id: "1562190" +post_author: 1 +"ListingKey": "29951485" +"ListingId": "40842632" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-25T14:55:14Z" +"RFModificationTimestamp": "2026-06-25T20:39:31Z" +"ListPrice": 729000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 928.0 +"BuildingAreaTotal": 0 +"City": "Burlington" +"PostalCode": "L7R0G9" +"UnparsedAddress": "370 MARTHA Street Unit# 309, Burlington, Ontario L7R0G9" +"Coordinates": array:2 [ 0 => -79.7926621 1 => 43.3266522 ] +"Latitude": 43.3266522 +"Longitude": -79.7926621 +"YearBuilt": 2024 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "928 sq ft of bright living space with direct Lake Ontario views, floor-to-ceiling windows and a Juliette balcony. This beautifully upgraded 2-bedroom, 2-bath condo features over $40,000 in upgrades, including a modern kitchen with Whirlpool appliances, porcelain countertops, backsplash and a large kitchen island. The primary bedroom offers stunning lake views, double closets and a private 4-piece ensuite. The second bedroom also features double closets and access to a separate 4-piece bathroom. Includes one underground parking space and one locker. Building amenities include a gym, party room, rooftop patio, outdoor pool and 24-hour concierge. Ideally located within walking distance to the lake, restaurants and shops. Move in and enjoy! (id:62650)" +"Appliances": array:5 [ 0 => "Washer" 1 => "Dishwasher" 2 => "Stove" 3 => "Dryer" 4 => "Microwave Built-in" ] +"AssociationFee": "928.21" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:2 [ 0 => "Insurance" 1 => "Parking" ] +"Basement": array:1 [ 0 => "None" ] +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-25T20:39:20.480642+00:00" +"Directions": "Lakeshore Road to Martha Street" +"ExteriorFeatures": array:1 [ 0 => "Aluminum siding" ] +"Heating": array:2 [ 0 => "Radiant heat" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1571506" +"ListOfficeKey": "284639" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Balcony" ] +"ParkingFeatures": array:2 [ 0 => "Underground" 1 => "None" ] +"PhotosChangeTimestamp": "2026-06-25T14:50:04Z" +"PhotosCount": 34 +"PoolFeatures": array:1 [ 0 => "Inground pool" ] +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-25T14:50:03Z" +"Stories": "1.0" +"StreetName": "MARTHA" +"StreetNumber": "370" +"StreetSuffix": "Street" +"SubdivisionName": "312 - Central" +"TaxAnnualAmount": "478.94" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:4 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29951485/370-martha-street-unit-309-burlington" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "Apartment" ] +"CoListAgentKey": "1907948" +"CommonInterest": "Condo/Strata" +"CoListOfficeKey": "279638" +"GeocodeManualYN": true +"BuildingFeatures": array:2 [ 0 => "Exercise Centre" 1 => "Party Room" ] +"ZoningDescription": "DC-479" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 0 +"AboveGradeFinishedArea": 928 +"OriginalEntryTimestamp": "2026-06-25T14:50:03.85Z" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Builder" +"ListAgentNationalAssociationId": "1151688" +"ListOfficeNationalAssociationId": "1344653" +"CoListAgentNationalAssociationId": "1220971" +"CoListOfficeNationalAssociationId": "1306586" +"Media": array:34 [ 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] ] +"DaysOnMarket": 7 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29951485')" +"ID": "1562190" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25065 +post_id: "1566980" +post_author: 1 +"ListingKey": "29946674" +"ListingId": "40842631" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-24T15:40:15Z" +"RFModificationTimestamp": "2026-06-26T02:58:15Z" +"ListPrice": 1149000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 3200.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8L4R3" +"UnparsedAddress": "414 JOHN Street, Hamilton, Ontario L8L4R3" +"Coordinates": array:2 [ 0 => -79.8609361 1 => 43.2685538 ] +"Latitude": 43.2685538 +"Longitude": -79.8609361 +"YearBuilt": 2016 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Exceptional custom-built (2016) industrial-modern detached home in Hamilton’s premier North End. This architectural standout transitions seamlessly from a dedicated main-floor professional gym into an expansive living space defined by soaring ceilings, exposed structural ductwork, and floating open-tread stairs. A chef-inspired kitchen features a massive butcher-block island and designer lighting, perfect for entertaining. The primary retreat offers a private sanctuary with its own walk-out balcony and a luxurious 5-piece stone-clad ensuite with a soaking tub. Rare for the area, the property includes a double-wide driveway and a commercial-grade glass garage door with extra height for oversized vehicles and adventure rigs. Step outside to a low-maintenance turf yard or walk minutes to West Harbour GO, Bayfront Park, and the vibrant James St N district. High-efficiency modern construction throughout. RSA. (id:62783)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water meter" 3 => "Gas stove(s)" 4 => "Dishwasher" 5 => "Dryer" 6 => "Garage door opener" ] +"Basement": array:1 [ 0 => "None" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-26T02:57:56.622055+00:00" +"Directions": "JOHN ST N, BETWEEN FERRIE & PICTON" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Metal" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1738902" +"ListOfficeKey": "284635" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-06-24T15:32:09Z" +"PhotosCount": 50 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-24T15:32:08Z" +"Stories": "3.0" +"StreetName": "JOHN" +"StreetNumber": "414" +"StreetSuffix": "Street" +"SubdivisionName": "132 - North End" +"TaxAnnualAmount": "9087" +"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/019d0c95-e7ed-735e-a0bc-49538dbe3656" +"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/29946674/414-john-street-hamilton" +"ParkingTotal": 3 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:2 [ 0 => "Alarm system" 1 => "Smoke Detectors" ] +"ZoningDescription": "D" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 28.0 +"AboveGradeFinishedArea": 3200 +"OriginalEntryTimestamp": "2026-06-24T15:32:08.86Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1179053" +"ListOfficeNationalAssociationId": "1344652" +"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": 8 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946674')" +"ID": "1566980" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24532 +post_id: "1562192" +post_author: 1 +"ListingKey": "29951575" +"ListingId": "40842630" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-02T15:40:10Z" +"RFModificationTimestamp": "2026-07-02T16:07:17Z" +"ListPrice": 2249000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 2778.0 +"BuildingAreaTotal": 0 +"City": "Burlington" +"PostalCode": "L7R1R7" +"UnparsedAddress": "2113 COURTLAND Drive, Burlington, Ontario L7R1R7" +"Coordinates": array:2 [ 0 => -79.8012804 1 => 43.333342 ] +"Latitude": 43.333342 +"Longitude": -79.8012804 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Luxury One-Floor Living Without Compromise! Nestled in one of Burlington's most coveted mature neighborhoods, this exceptional Bungalow offers the perfect blend of sophistication, comfort, and effortless one-floor living. Thoughtfully designed for those seeking an easier lifestyle without sacrificing space or luxury, this beautifully appointed residence delivers an outstanding indoor-outdoor living experience with immaculate attention to detail throughout. The elegant open-concept layout is filled with natural light and features spacious principal rooms, quality finishes, and seamless flow for everyday living and entertaining. The gourmet kitchen serves as the heart of the home, opening to inviting living and dining spaces ideal for hosting family and friends. Retreat to the private Backyard Oasis, where a sparkling saltwater pool with an elegant fountain feature is surrounded by professionally landscaped grounds designed for relaxation and privacy. Whether enjoying quiet mornings by the pool or entertaining on a grand scale, this outdoor sanctuary offers exceptional privacy and enjoyment. A private home office with a striking glass wall provides the perfect space for remote work, creative pursuits or managing daily affairs while maintaining a bright & connected atmosphere. A spacious double garage with premium epoxy floor and generous storage loft provide practicality, while the sought-after location places you moments from Burlington's vibrant downtown, waterfront parks, restaurants, shopping, and everyday conveniences. Every detail has been thoughtfully considered to support a refined, low-maintenance lifestyle. Superior infrastructure upgrades throughout reflect the meticulous care of a highly detail-focused homeowner. Rarely does a home combine the convenience of bungalow living with the lifestyle, privacy, & prestige today's discerning buyers demand. An exceptional opportunity to embrace your next chapter in one of Burlington's most desirable neighborhoods. (id:62650)" +"Appliances": array:11 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Wine Fridge" 4 => "Stove" 5 => "Dryer" 6 => "Oven - Built-In" 7 => "Hood Fan" 8 => "Window Coverings" 9 => "Garage door opener" 10 => "Microwave Built-in" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-25T20:20:00.310916+00:00" +"Directions": "Brant St., Blairholm Avenue" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"Fencing": array:1 [ 0 => "Fence" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1960190" +"ListOfficeKey": "289630" +"LivingAreaUnits": "square feet" +"LotFeatures": array:5 [ 0 => "Southern exposure" 1 => "Conservation/green belt" 2 => "Paved driveway" 3 => "Gazebo" 4 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:1 [ 0 => "Detached Garage" ] +"PhotosChangeTimestamp": "2026-06-25T15:11:24Z" +"PhotosCount": 50 +"PoolFeatures": array:1 [ 0 => "Inground pool" ] +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-02T15:32:31Z" +"Stories": "1.0" +"StreetName": "COURTLAND" +"StreetNumber": "2113" +"StreetSuffix": "Drive" +"SubdivisionName": "312 - Central" +"TaxAnnualAmount": "8173" +"VirtualTourURLUnbranded": "https://track.pstmrk.it/3s/listings.monstermediahouse.com%2Fsites%2F2113-courtland-dr-burlington-on-l7r-1r7-26109902%2Fbranded/cUpU/hj7GAQ/Ag/5a2d5acc-7df7-46d9-969d-99791e6ae34d/7/EQ64NJDDuQ" +"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/29951575/2113-courtland-drive-burlington" +"ParkingTotal": 8 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Alarm system" ] +"ZoningDescription": "R3.2" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 60.0 +"AboveGradeFinishedArea": 1420 +"BelowGradeFinishedArea": 1358 +"OriginalEntryTimestamp": "2026-06-25T15:11:24.41Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"BelowGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1250393" +"ListOfficeNationalAssociationId": "1379683" +"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": 7 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29951575')" +"ID": "1562192" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24533 +post_id: "1562136" +post_author: 1 +"ListingKey": "29951910" +"ListingId": "40842626" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-28T20:20:24Z" +"RFModificationTimestamp": "2026-06-28T20:24:53Z" +"ListPrice": 644900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1358.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8P4Z4" +"UnparsedAddress": "120 BEDDOE Drive Unit# 6, Hamilton, Ontario L8P4Z4" +"Coordinates": array:2 [ 0 => -79.9054885 1 => 43.2492529 ] +"Latitude": 43.2492529 +"Longitude": -79.9054885 +"YearBuilt": 2001 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc" +"PublicRemarks": "BACKING ONTO CHEDOKE GOLF COURSE is this wonderfully appointed townhouse. Private location for this spacious two storey town with 3 bedrooms and 2 1/2 bathrooms. Entering into the foyer you are greeted with high ceilings a 2 pc powder rm and secondary garage door entry. The Great room is bright and spacious with an open concept kitchen boasting large center island with breakfast bar seating, maple cabinetry, b-in dishwasher and ss appliances. The living room offers a gas fireplace and patio door walk out to private yard & patio with view of a forest and golf course! On the second level you with find 3 bedrooms with a large principle bedroom offering his and hers closets and a 4 pc ensuite. Modern and updated 3 pc main bath w/stylish vanity and tiled walk in shower. The lower level is the perfect get away as with an expansive recreation room. Updated F/air gas furnace and C/air (2017). This Townhome complex is nestled in the heart of the Chedoke Golf Course's Kirkindale neighborhood blending nature with convenient residential living. Close to Hamilton's vibrant downtown, McMaster University and Mohawk college and access to Hwy 403 , public transportation, schools, parks and shopping! (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Garage door opener" ] +"AssociationFee": "524.96" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:2 [ 0 => "Common Area Maintenance" 1 => "Water" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-25T20:09:18.464661+00:00" +"Directions": "From 403, Aberdeen Rd turn right onto Studholme Rd. West and make a Left on Beddoe" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Aluminum siding" ] +"Fencing": array:1 [ 0 => "Partially fenced" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1398748" +"ListOfficeKey": "289711" +"LivingAreaUnits": "square feet" +"LotFeatures": array:4 [ 0 => "Cul-de-sac" 1 => "Ravine" 2 => "Paved driveway" 3 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-06-25T16:24:44Z" +"PhotosCount": 45 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-28T20:14:50Z" +"Stories": "2.0" +"StreetName": "BEDDOE" +"StreetNumber": "120" +"StreetSuffix": "Drive" +"SubdivisionName": "123 - Kirkendall South" +"TaxAnnualAmount": "5544" +"VirtualTourURLUnbranded": "https://vimeo.com/1189430517" +"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": "Brantford" +"ListAORKey": "41" +"ListingURL": "www.realtor.ca/real-estate/29951910/120-beddoe-drive-unit-6-hamilton" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "Row / Townhouse" ] +"CommonInterest": "Condo/Strata" +"GeocodeManualYN": true +"ZoningDescription": "K" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 0.0 +"AboveGradeFinishedArea": 1358 +"OriginalEntryTimestamp": "2026-06-25T16:24:44.07Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Assessor" +"ListAgentNationalAssociationId": "1038492" +"ListOfficeNationalAssociationId": "1380321" +"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": 7 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29951910')" +"ID": "1562136" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24527 +post_id: "1561822" +post_author: 1 +"ListingKey": "29952190" +"ListingId": "40842622" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-26T19:20:06Z" +"RFModificationTimestamp": "2026-06-26T19:22:10Z" +"ListPrice": 819000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1388.0 +"BuildingAreaTotal": 0 +"City": "Guelph" +"PostalCode": "N1H2Z6" +"UnparsedAddress": "160 MACDONELL Street Unit# 607, Guelph, Ontario N1H2Z6" +"Coordinates": array:2 [ 0 => -80.244724 1 => 43.5468959 ] +"Latitude": 43.5468959 +"Longitude": -80.244724 +"YearBuilt": 2014 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Experience elevated urban living in the heart of downtown Guelph. This spacious corner suite offers an impressive 1,388 square feet of thoughtfully designed living space, featuring two bedrooms plus a versatile den, and an expansive balcony with sweeping city and river valley views. Natural light pours through floor-to-ceiling windows, enhancing the open-concept layout and creating an inviting atmosphere throughout. The kitchen is designed for both everyday living and entertaining, complete with granite countertops, stainless steel appliances, and seamless flow into the principal living and dining areas. A custom fireplace with built-in cabinetry serves as a striking focal point, adding warmth and character to the space. The primary suite provides a comfortable retreat with a walk-in closet and private ensuite bath, while the second bedroom offers ample space for family, guests, or additional workspace. The den adds flexibility to suit your lifestyle—ideal as a home office, reading room, or hobby space. In-suite laundry further enhances everyday convenience. Adding exceptional value, the condominium fees include virtually all utilities, with only hydro billed separately, offering simplified budgeting and worry-free living. Perfectly positioned across from the GO Station and just steps from downtown restaurants, cafés, shopping, entertainment, and scenic walking trails, this location offers exceptional connectivity and convenience. Residents of the highly sought-after River House enjoy access to an impressive collection of amenities, including a rooftop terrace, fitness centre, guest suites, library, media and games rooms, and an elegant party room. A rare opportunity to enjoy generous living space, outstanding amenities, exceptional value, and one of Guelph's most desirable downtown locations. (id:62650)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" 6 => "Microwave" ] +"AssociationFee": "802.52" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:7 [ 0 => "Landscaping" 1 => "Heat" 2 => "Water" 3 => "Insurance" 4 => "Other, See Remarks" 5 => "Parking" 6 => "Residential Manager" ] +"Basement": array:1 [ 0 => "None" ] +"ConstructionMaterials": array:2 [ 0 => "Concrete block" 1 => "Concrete Walls" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-25T19:26:30.708279+00:00" +"Directions": "Woolwich St. N. Located in the RiverHouse Condominiums - Guelph downtown luxury Condo building located at the corner of Macdonell and Woolwich Streets." +"ExteriorFeatures": array:1 [ 0 => "Concrete" ] +"FireplaceFeatures": array:2 [ 0 => "Electric" 1 => "Other - See remarks" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Other" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2080806" +"ListOfficeKey": "76789" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Southern exposure" 1 => "Balcony" 2 => "Shared Driveway" ] +"ParkingFeatures": array:2 [ 0 => "Underground" 1 => "Visitor Parking" ] +"PhotosChangeTimestamp": "2026-06-25T16:50:27Z" +"PhotosCount": 39 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-26T19:10:49Z" +"Stories": "1.0" +"StreetName": "MACDONELL" +"StreetNumber": "160" +"StreetSuffix": "Street" +"SubdivisionName": "1 - Downtown" +"TaxAnnualAmount": "5199" +"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/29952190/160-macdonell-street-unit-607-guelph" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "Apartment" ] +"CommonInterest": "Condo/Strata" +"GeocodeManualYN": true +"BuildingFeatures": array:3 [ 0 => "Exercise Centre" 1 => "Guest Suite" 2 => "Party Room" ] +"SecurityFeatures": array:1 [ 0 => "Security system" ] +"ZoningDescription": "D1-21" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 1 +"AboveGradeFinishedArea": 1388 +"OriginalEntryTimestamp": "2026-06-25T16:50:26.83Z" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1355621" +"ListOfficeNationalAssociationId": "1004357" +"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": 7 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29952190')" +"ID": "1561822" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24530 +post_id: "1582703" +post_author: 1 +"ListingKey": "29974835" +"ListingId": "40842618" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-01T21:20:01Z" +"RFModificationTimestamp": "2026-07-01T21:24:01Z" +"ListPrice": 489900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.21 +"LivingArea": 1935.0 +"BuildingAreaTotal": 0 +"City": "Simcoe" +"PostalCode": "N3Y2H2" +"UnparsedAddress": "23 TYRELL Street, Simcoe, Ontario N3Y2H2" +"Coordinates": array:2 [ 0 => -80.3168752 1 => 42.83945 ] +"Latitude": 42.83945 +"Longitude": -80.3168752 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc" +"PublicRemarks": "Well-maintained Brick Bungalow situated on an impressive, nearly ¼-acre lot in town, offering a rare combination of privacy and convenience. Originally a 3-bedroom home, it has been reconfigured to a spacious 2-bedroom layout and features hardwood flooring on the main floor. The backyard is a true private retreat, surrounded by large mature trees that create a peaceful, park-like setting. Enjoy the Family Room addition (2001) featuring a Gas Fireplace and patio doors leading to a large deck overlooking the beautifully landscaped yard. Outdoor features include a unique 16' x 32' octagon-shaped on-ground pool with liner replaced in 2024, a 4-person Soft Tub (2021), Patio with wooden Pergola, Pond, and plenty of space for entertaining, gardening, or simply relaxing in complete privacy. Notable updates include: Main Floor Windows (2024), 100-amp Breaker Panel (2025), Furnace & Central Air (2013), and Shingles (approx. 2019). The partially finished basement offers additional living space with a 3-pc. bath, Office, Rec Room, and a Bedroom (window is not an Egress). Enjoy the tranquility of this exceptional property while being just minutes from shopping, schools, parks, and other everyday amenities. (id:62650)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" 6 => "Window Coverings" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"ConstructionMaterials": array:1 [ 0 => "Wood frame" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-01T17:07:28.372486+00:00" +"ExteriorFeatures": array:2 [ 0 => "Wood" 1 => "Brick" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1398837" +"ListOfficeKey": "92544" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Paved driveway" ] +"LotSizeDimensions": "0.21" +"PhotosChangeTimestamp": "2026-07-01T13:14:42Z" +"PhotosCount": 43 +"PoolFeatures": array:1 [ 0 => "On Ground Pool" ] +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-01T21:14:38Z" +"Stories": "1.0" +"StreetName": "TYRELL" +"StreetNumber": "23" +"StreetSuffix": "Street" +"SubdivisionName": "Town of Simcoe" +"TaxAnnualAmount": "3257" +"VirtualTourURLUnbranded": "https://vimeo.com/1206247724?share=copy&fl=sv&fe=ci" +"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": "Brantford" +"ListAORKey": "41" +"ListingURL": "www.realtor.ca/real-estate/29974835/23-tyrell-street-simcoe" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R1-A" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 51.0 +"AboveGradeFinishedArea": 1272 +"BelowGradeFinishedArea": 663 +"OriginalEntryTimestamp": "2026-07-01T13:14:42.64Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1038361" +"ListOfficeNationalAssociationId": "1183612" +"Media": array:43 [ 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] ] +"DaysOnMarket": 1 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29974835')" +"ID": "1582703" } ] +success: true +page_size: 12 +page_count: 16632 +count: 199575 +after_key: "" } "RF Response Time" => "0.19 seconds" ] ]