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=154704&$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 {#24561 +items: array:12 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24657 +post_id: "1539375" +post_author: 1 +"ListingKey": "29914694" +"ListingId": "40840419" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-26T15:10:23Z" +"RFModificationTimestamp": "2026-06-26T15:43:36Z" +"ListPrice": 322999.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 637.0 +"BuildingAreaTotal": 0 +"City": "Burlington" +"PostalCode": "L7M4M2" +"UnparsedAddress": "4005 KILMER Drive Unit# 406, Burlington, Ontario L7M4M2" +"Coordinates": array:2 [ 0 => -79.8028437 1 => 43.3778099 ] +"Latitude": 43.3778099 +"Longitude": -79.8028437 +"YearBuilt": 1998 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to this stunning 1+1 bedroom plus den top floor suite located in Kilmer Estates. Upon entering, you'll be captivated by the soaring vaulted ceilings and the open-concept floor plan that enhances the sense of space. The living room features elegant laminate flooring, complemented by a ceiling fan and garden doors leading to a spacious covered balcony. The kitchen boasts fresh white cabinetry, a suite of four appliances, a double sink, and a stylish stone backsplash, along with a convenient breakfast bar perfect for entertaining and eating. The generously sized master bedroom includes a window with blinds and a double closet for ample storage. The den serves as a versatile space, suitable for use as either a bedroom or a home office. The four-piece bathroom is well-appointed with ceramic tile flooring, a tub/shower combination, a single vanity with a sink, and upgraded lighting and mirror fixtures. Step outside to the large balcony, which also features a storage locker. Additional highlights of this well-maintained unit include in-suite laundry and one parking space. Close to shopping, restaurants, schools and transit...Convenient easy living at its finest! (id:62783)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Hood Fan" 6 => "Window Coverings" ] +"AssociationFee": "727.77" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:4 [ 0 => "Landscaping" 1 => "Water" 2 => "Insurance" 3 => "Parking" ] +"Basement": array:1 [ 0 => "None" ] +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-17T17:16:47.411085+00:00" +"Directions": "WALKER'S & UPPER MIDDLE" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1524250" +"ListOfficeKey": "54923" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Balcony" 1 => "Paved driveway" ] +"ParkingFeatures": array:1 [ 0 => "Open" ] +"PhotosChangeTimestamp": "2026-06-17T13:31:11Z" +"PhotosCount": 15 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-26T15:01:57Z" +"Stories": "1.0" +"StreetName": "KILMER" +"StreetNumber": "4005" +"StreetSuffix": "Drive" +"SubdivisionName": "354 - Tansley" +"TaxAnnualAmount": "2099" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:6 [ 0 => array:11 [ "RoomKey" => "1668567408" "RoomType" => "4pc Bathroom" "ListingId" => "40840419" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29914694" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T15:01:57.32Z" ] 1 => array:11 [ "RoomKey" => "1668567409" "RoomType" => "Laundry room" "ListingId" => "40840419" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29914694" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T15:01:57.32Z" ] 2 => array:11 [ "RoomKey" => "1668567410" "RoomType" => "Bedroom" "ListingId" => "40840419" "RoomLevel" => "Lower level" "RoomWidth" => null "ListingKey" => "29914694" "RoomLength" => null "RoomDimensions" => "8'2'' x 8'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T15:01:57.32Z" ] 3 => array:11 [ "RoomKey" => "1668567411" "RoomType" => "Primary Bedroom" "ListingId" => "40840419" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29914694" "RoomLength" => null "RoomDimensions" => "10'8'' x 12'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T15:01:57.32Z" ] 4 => array:11 [ "RoomKey" => "1668567412" "RoomType" => "Living room/Dining room" "ListingId" => "40840419" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29914694" "RoomLength" => null "RoomDimensions" => "15'7'' x 18'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T15:01:57.32Z" ] 5 => array:11 [ "RoomKey" => "1668567413" "RoomType" => "Eat in kitchen" "ListingId" => "40840419" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29914694" "RoomLength" => null "RoomDimensions" => "8'6'' x 8'11''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T15:01:57.32Z" ] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29914694/4005-kilmer-drive-unit-406-burlington" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "Apartment" ] +"CoListAgentKey": "1533175" +"CommonInterest": "Condo/Strata" +"CoListOfficeKey": "54923" +"GeocodeManualYN": true +"ZoningDescription": "RH4" +"BedroomsAboveGrade": 1 +"BedroomsBelowGrade": 1 +"AboveGradeFinishedArea": 637 +"OriginalEntryTimestamp": "2026-06-17T13:31:10.74Z" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1127411" +"ListOfficeNationalAssociationId": "1003529" +"CoListAgentNationalAssociationId": "1143027" +"CoListOfficeNationalAssociationId": "1003529" +"Media": array:15 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "29914694_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914694/ecd7e39811eb16ff5efb589f76c3574c.webp" "MediaSize" => 150769 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914694/thumbnail-ecd7e39811eb16ff5efb589f76c3574c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "40840419" "ResourceRecordKey" => "29914694" "ModificationTimestamp" => "2026-06-17T13:31:10.75Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "29914694_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914694/9a4f715908b28ca037cc8146d21d19c9.webp" "MediaSize" => 69289 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914694/thumbnail-9a4f715908b28ca037cc8146d21d19c9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840419" "ResourceRecordKey" => "29914694" "ModificationTimestamp" => "2026-06-17T13:31:10.75Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "29914694_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914694/e64f937d98eafaa315a42ea49b26d507.webp" "MediaSize" => 83103 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914694/thumbnail-e64f937d98eafaa315a42ea49b26d507.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840419" "ResourceRecordKey" => "29914694" "ModificationTimestamp" => "2026-06-17T13:31:10.75Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "29914694_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914694/fc345bc1c3d61bb116d80b667cd6f870.webp" "MediaSize" => 81672 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914694/thumbnail-fc345bc1c3d61bb116d80b667cd6f870.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840419" "ResourceRecordKey" => "29914694" "ModificationTimestamp" => "2026-06-17T13:31:10.75Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "29914694_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914694/c6c531b7369dd007e2816282e4584ed1.webp" "MediaSize" => 78419 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914694/thumbnail-c6c531b7369dd007e2816282e4584ed1.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840419" "ResourceRecordKey" => "29914694" "ModificationTimestamp" => "2026-06-17T13:31:10.75Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "29914694_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914694/f713f7bb1c3d03083a1d94798ce5d002.webp" "MediaSize" => 78784 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914694/thumbnail-f713f7bb1c3d03083a1d94798ce5d002.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840419" "ResourceRecordKey" => "29914694" "ModificationTimestamp" => "2026-06-17T13:31:10.75Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "29914694_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914694/7f21e03009046e92712e290ba3efe612.webp" "MediaSize" => 80433 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914694/thumbnail-7f21e03009046e92712e290ba3efe612.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840419" "ResourceRecordKey" => "29914694" "ModificationTimestamp" => "2026-06-17T13:31:10.75Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "29914694_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914694/3f5af309f245ce5ac2ed94dd8590d760.webp" "MediaSize" => 78732 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914694/thumbnail-3f5af309f245ce5ac2ed94dd8590d760.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840419" "ResourceRecordKey" => "29914694" "ModificationTimestamp" => "2026-06-17T13:31:10.75Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "29914694_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914694/7800d57b87429a16ff12667f8470ed65.webp" "MediaSize" => 76000 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914694/thumbnail-7800d57b87429a16ff12667f8470ed65.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840419" "ResourceRecordKey" => "29914694" "ModificationTimestamp" => "2026-06-17T13:31:10.75Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "29914694_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914694/7b8aa0cb272ac6902da1415a13e40001.webp" "MediaSize" => 84095 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914694/thumbnail-7b8aa0cb272ac6902da1415a13e40001.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840419" "ResourceRecordKey" => "29914694" "ModificationTimestamp" => "2026-06-17T13:31:10.75Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "29914694_4890_11" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914694/ece1ff3ac52cc25ddb12c6dc99b8280a.webp" "MediaSize" => 105430 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914694/thumbnail-ece1ff3ac52cc25ddb12c6dc99b8280a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840419" "ResourceRecordKey" => "29914694" "ModificationTimestamp" => "2026-06-17T13:31:10.75Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "29914694_4890_12" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914694/a880885bd5f21be9b0d460b3852247f8.webp" "MediaSize" => 69528 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914694/thumbnail-a880885bd5f21be9b0d460b3852247f8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840419" "ResourceRecordKey" => "29914694" "ModificationTimestamp" => "2026-06-17T13:31:10.75Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "29914694_4890_13" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914694/e4e7619313349f2684063d0b73627084.webp" "MediaSize" => 96258 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914694/thumbnail-e4e7619313349f2684063d0b73627084.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840419" "ResourceRecordKey" => "29914694" "ModificationTimestamp" => "2026-06-17T13:31:10.75Z" ] 13 => array:13 [ "Order" => 14 "MediaKey" => "29914694_4890_14" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914694/6521c3671729eb7e93a667f4c24b5e67.webp" "MediaSize" => 53713 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914694/thumbnail-6521c3671729eb7e93a667f4c24b5e67.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840419" "ResourceRecordKey" => "29914694" "ModificationTimestamp" => "2026-06-17T13:31:10.75Z" ] 14 => array:13 [ "Order" => 15 "MediaKey" => "29914694_4890_15" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914694/362c0e07babc1c1f9f10975826b17fbb.webp" "MediaSize" => 53944 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914694/thumbnail-362c0e07babc1c1f9f10975826b17fbb.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840419" "ResourceRecordKey" => "29914694" "ModificationTimestamp" => "2026-06-17T13:31:10.75Z" ] ] +"DaysOnMarket": 13 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914694')" +"ID": "1539375" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24513 +post_id: "1540814" +post_author: 1 +"ListingKey": "29917853" +"ListingId": "40840415" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-17T20:45:07Z" +"RFModificationTimestamp": "2026-06-17T21:52:26Z" +"ListPrice": 559900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1240.0 +"BuildingAreaTotal": 0 +"City": "Burlington" +"PostalCode": "L7S1Z6" +"UnparsedAddress": "1225 NORTH SHORE Boulevard E Unit# 710, Burlington, Ontario L7S1Z6" +"Coordinates": array:2 [ 0 => -79.804424 1 => 43.3179076 ] +"Latitude": 43.3179076 +"Longitude": -79.804424 +"YearBuilt": 1987 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Experience the best of Burlington's waterfront lifestyle from this bright, spacious suite in The Sands, perfectly positioned steps from the lake, Spencer Smith Park, the Waterfront Trail, restaurants, boutiques & all the amenities of Downtown Burlington. With over 1,240 sq ft of thoughtfully designed living space, this west facing residence enjoys lake and escarpment views from the private balcony, creating the perfect setting to unwind with evening sunsets. A double door entry opens to a welcoming foyer with a double closet, leading to expansive living & dining areas ideal for everyday comfort or hosting guests. The functional layout includes 2 generous bedrooms, 2 bathrooms, an in suite storage closet & abundant space rarely found in condominium living. The primary retreat features a walk in closet & private ensuite, while large windows throughout fill the home with natural light. Residents enjoy updated building hallways, underground parking, a storage locker & an impressive collection of amenities including a fitness centre, sauna, party room, billiards room & visitor parking. Whether enjoying a morning walk along the lake, meeting friends downtown for dinner or taking advantage of nearby parks, shops & cultural attractions, this address delivers a truly walkable lifestyle in one of Burlington's most desirable waterfront communities. A wonderful opportunity to enjoy carefree living in an exceptional location. (id:62783)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Window Coverings" ] +"AssociationFee": "870.46" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:6 [ 0 => "Landscaping" 1 => "Property Management" 2 => "Cable TV" 3 => "Water" 4 => "Insurance" 5 => "Parking" ] +"Basement": array:1 [ 0 => "None" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-17T21:52:16.768811+00:00" +"Directions": "North Shore east of Maple Ave" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2068329" +"ListOfficeKey": "283187" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Southern exposure" 1 => "Balcony" 2 => "No Pet Home" ] +"ParkingFeatures": array:2 [ 0 => "Underground" 1 => "None" ] +"PhotosChangeTimestamp": "2026-06-17T19:22:46Z" +"PhotosCount": 40 +"PoolFeatures": array:1 [ 0 => "Inground pool" ] +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-17T20:39:47Z" +"Stories": "1.0" +"StreetDirSuffix": "East" +"StreetName": "NORTH SHORE" +"StreetNumber": "1225" +"StreetSuffix": "Boulevard" +"SubdivisionName": "311 - Maple" +"TaxAnnualAmount": "3361" +"Utilities": array:4 [ 0 => "Natural Gas" 1 => "Electricity" 2 => "Cable" 3 => "Telephone" ] +"View": "Lake view" +"VirtualTourURLUnbranded": "https://sites.tylerdavies.ca/vd/251735141" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:7 [ 0 => array:11 [ "RoomKey" => "1661470241" "RoomType" => "4pc Bathroom" "ListingId" => "40840415" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29917853" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-17T20:39:47.62Z" ] 1 => array:11 [ "RoomKey" => "1661470242" "RoomType" => "Bedroom" "ListingId" => "40840415" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29917853" "RoomLength" => null "RoomDimensions" => "9'5'' x 18'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-17T20:39:47.62Z" ] 2 => array:11 [ "RoomKey" => "1661470243" "RoomType" => "Full bathroom" "ListingId" => "40840415" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29917853" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-17T20:39:47.63Z" ] 3 => array:11 [ "RoomKey" => "1661470244" "RoomType" => "Primary Bedroom" "ListingId" => "40840415" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29917853" "RoomLength" => null "RoomDimensions" => "13'7'' x 15'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-17T20:39:47.63Z" ] 4 => array:11 [ "RoomKey" => "1661470245" "RoomType" => "Kitchen" "ListingId" => "40840415" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29917853" "RoomLength" => null "RoomDimensions" => "9'5'' x 12'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-17T20:39:47.63Z" ] 5 => array:11 [ "RoomKey" => "1661470246" "RoomType" => "Dining room" "ListingId" => "40840415" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29917853" "RoomLength" => null "RoomDimensions" => "9'9'' x 11'10''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-17T20:39:47.63Z" ] 6 => array:11 [ "RoomKey" => "1661470247" "RoomType" => "Living room" "ListingId" => "40840415" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29917853" "RoomLength" => null "RoomDimensions" => "15'9'' x 12'11''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-17T20:39:47.63Z" ] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29917853/1225-north-shore-boulevard-e-unit-710-burlington" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "Apartment" ] +"CoListAgentKey": "1595062" +"CommonInterest": "Condo/Strata" +"CoListOfficeKey": "283187" +"GeocodeManualYN": true +"BuildingFeatures": array:3 [ 0 => "Car Wash" 1 => "Exercise Centre" 2 => "Party Room" ] +"SecurityFeatures": array:1 [ 0 => "None" ] +"ZoningDescription": "RM4-231" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 0 +"AboveGradeFinishedArea": 1240 +"OriginalEntryTimestamp": "2026-06-17T19:21:01.76Z" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1343390" +"ListOfficeNationalAssociationId": "1325425" +"CoListAgentNationalAssociationId": "1155710" +"CoListOfficeNationalAssociationId": "1325425" +"Media": array:40 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "29917853_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/84c664f85987aa97904241219a6ef761.webp" "MediaSize" => 157794 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-84c664f85987aa97904241219a6ef761.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:45.43Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "29917853_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/08fa42ec06d9a5b787f200a0705bb264.webp" "MediaSize" => 198964 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-08fa42ec06d9a5b787f200a0705bb264.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:46.32Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "29917853_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/8d5991f5fcedafa498b19c87554b24d4.webp" "MediaSize" => 112802 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-8d5991f5fcedafa498b19c87554b24d4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:46.39Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "29917853_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/802a804ef8b0c2ce9a65ccfd9d6f77fe.webp" "MediaSize" => 112064 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-802a804ef8b0c2ce9a65ccfd9d6f77fe.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:45.61Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "29917853_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/ad7034a073bf4248ed3b8fe06e3bcb09.webp" "MediaSize" => 105070 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-ad7034a073bf4248ed3b8fe06e3bcb09.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:45.43Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "29917853_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/52b218a13c31934de9d097e08e6578fd.webp" "MediaSize" => 57444 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-52b218a13c31934de9d097e08e6578fd.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:45.61Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "29917853_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/9b0d4068fcc505c83ee367add0709c58.webp" "MediaSize" => 67487 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-9b0d4068fcc505c83ee367add0709c58.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:45.23Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "29917853_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/579ccbeb798154f17a22cb09ade4c636.webp" "MediaSize" => 105927 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-579ccbeb798154f17a22cb09ade4c636.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:45.24Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "29917853_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/ed07ab3ddc2daf953d02a2c24f091bb5.webp" "MediaSize" => 87986 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-ed07ab3ddc2daf953d02a2c24f091bb5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:46.47Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "29917853_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/92ecea9927345731a2a4ee5d2034a3b8.webp" "MediaSize" => 92853 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-92ecea9927345731a2a4ee5d2034a3b8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:45.61Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "29917853_4890_11" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/a0387dc4e1443b738d8a7f1d35c12db6.webp" "MediaSize" => 74049 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-a0387dc4e1443b738d8a7f1d35c12db6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:45.43Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "29917853_4890_12" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/04f0df85e1c98e4a4ea75bb2a94dc3f4.webp" "MediaSize" => 78616 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-04f0df85e1c98e4a4ea75bb2a94dc3f4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:45.43Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "29917853_4890_13" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/a5b9abd7d6bfd7e7ce3ef5d5a7d4533b.webp" "MediaSize" => 61751 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-a5b9abd7d6bfd7e7ce3ef5d5a7d4533b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:46.48Z" ] 13 => array:13 [ "Order" => 14 "MediaKey" => "29917853_4890_14" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/f0afc2ff2aea27131e498bba51aede66.webp" "MediaSize" => 60123 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-f0afc2ff2aea27131e498bba51aede66.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:45.61Z" ] 14 => array:13 [ "Order" => 15 "MediaKey" => "29917853_4890_15" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/d781992fbf9773d7758a629250868db2.webp" "MediaSize" => 92148 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-d781992fbf9773d7758a629250868db2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:45.43Z" ] 15 => array:13 [ "Order" => 16 "MediaKey" => "29917853_4890_16" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/b7f85135e741ab120b4bb626b89bf05c.webp" "MediaSize" => 105618 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-b7f85135e741ab120b4bb626b89bf05c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:45.62Z" ] 16 => array:13 [ "Order" => 17 "MediaKey" => "29917853_4890_17" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/06875c009635b59c04ecdbebbc1bbe0f.webp" "MediaSize" => 62372 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-06875c009635b59c04ecdbebbc1bbe0f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:46.24Z" ] 17 => array:13 [ "Order" => 18 "MediaKey" => "29917853_4890_18" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/5d8d75ca660a225016d5248eb018fecb.webp" "MediaSize" => 57154 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-5d8d75ca660a225016d5248eb018fecb.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:45.43Z" ] 18 => array:13 [ "Order" => 19 "MediaKey" => "29917853_4890_19" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/5a7ecc1d4af55ba22e0b4153d9b29d87.webp" "MediaSize" => 63167 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-5a7ecc1d4af55ba22e0b4153d9b29d87.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:45.85Z" ] 19 => array:13 [ "Order" => 20 "MediaKey" => "29917853_4890_20" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/43209ca439373463030505d526d5c8f0.webp" "MediaSize" => 74771 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-43209ca439373463030505d526d5c8f0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:46.47Z" ] 20 => array:13 [ "Order" => 21 "MediaKey" => "29917853_4890_21" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/2395e9248e82869f1c35bd8b460634c3.webp" "MediaSize" => 56583 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-2395e9248e82869f1c35bd8b460634c3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:46.47Z" ] 21 => array:13 [ "Order" => 22 "MediaKey" => "29917853_4890_22" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/4e5fe27ae1adbd4492ce988839a7c2c4.webp" "MediaSize" => 59151 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-4e5fe27ae1adbd4492ce988839a7c2c4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:45.61Z" ] 22 => array:13 [ "Order" => 23 "MediaKey" => "29917853_4890_23" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/07ce24ad7fc3b3cb2e3c65800e1b5d85.webp" "MediaSize" => 146532 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-07ce24ad7fc3b3cb2e3c65800e1b5d85.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:46.47Z" ] 23 => array:13 [ "Order" => 24 "MediaKey" => "29917853_4890_24" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/23d630565d1a76b44f89bb66bb56d01f.webp" "MediaSize" => 123677 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-23d630565d1a76b44f89bb66bb56d01f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:45.43Z" ] 24 => array:13 [ "Order" => 25 "MediaKey" => "29917853_4890_25" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/97fbf9d0cc107919fc9b9c71c0e6c254.webp" "MediaSize" => 147857 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-97fbf9d0cc107919fc9b9c71c0e6c254.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:46.47Z" ] 25 => array:13 [ "Order" => 26 "MediaKey" => "29917853_4890_26" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/d10e976b5a6c812b88d7956b963ed98a.webp" "MediaSize" => 54436 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-d10e976b5a6c812b88d7956b963ed98a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:45.43Z" ] 26 => array:13 [ "Order" => 27 "MediaKey" => "29917853_4890_27" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/6cc5da9a0a871035b7cfffb0c5caf08b.webp" "MediaSize" => 88713 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-6cc5da9a0a871035b7cfffb0c5caf08b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:46.48Z" ] 27 => array:13 [ "Order" => 28 "MediaKey" => "29917853_4890_28" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/6d1f581b845dba16dd8295d1243e5cfe.webp" "MediaSize" => 71127 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-6d1f581b845dba16dd8295d1243e5cfe.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:46.48Z" ] 28 => array:13 [ "Order" => 29 "MediaKey" => "29917853_4890_29" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/0c2746a4eb232db92e70b4bf00d121ce.webp" "MediaSize" => 75869 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29917853/thumbnail-0c2746a4eb232db92e70b4bf00d121ce.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40840415" "ResourceRecordKey" => "29917853" "ModificationTimestamp" => "2026-06-17T19:22:46.47Z" ] 29 => array:13 [ "Order" => 30 "MediaKey" => "29917853_4890_30" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29917853/5176d6c819983812fb54c57d5e5fbb60.webp" "MediaSize" => 87960 "MediaType" => "webp" …8 ] 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] ] +"DaysOnMarket": 13 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29917853')" +"ID": "1540814" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24645 +post_id: "1538263" +post_author: 1 +"ListingKey": "29914285" +"ListingId": "40840409" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-27T18:55:14Z" +"RFModificationTimestamp": "2026-06-27T19:00:05Z" +"ListPrice": 800000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 2 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1826.0 +"BuildingAreaTotal": 0 +"City": "Waterdown" +"PostalCode": "L8B0L3" +"UnparsedAddress": "29 SUNNYCROFT Court, Waterdown, Ontario L8B0L3" +"Coordinates": array:2 [ 0 => -79.8987212 1 => 43.3270654 ] +"Latitude": 43.3270654 +"Longitude": -79.8987212 +"YearBuilt": 2005 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 29 Sunnycroft Court, a beautifully maintained freehold semi-detached home nestled on a quiet court in one of Waterdown's most sought-after neighbourhoods. Backing onto greenspace with no rear neighbours, this home offers the perfect blend of privacy, convenience, and low-maintenance living—with no condo or road fees. Built in 2005 and thoughtfully designed with timeless finishes, the main floor features 9-foot ceilings, abundant natural light, hardwood flooring, and an inviting open-concept layout ideal for everyday living and entertaining. The upgraded kitchen is equipped with tall cabinetry, crown moulding, granite countertops, stainless steel appliances, a gas stove, and a breakfast bar overlooking the spacious great room with gas fireplace and backyard views. Step outside to a large elevated deck surrounded by mature landscaping, creating the perfect setting to enjoy your morning coffee or unwind while overlooking the peaceful greenspace beyond while soaking in the hot tub. Upstairs, the spacious primary retreat features a 4-piece ensuite and dual closets, while two additional bedrooms are served by a convenient Jack-and-Jill style full bathroom. The finished lower level adds valuable living space with a versatile bright rec room, 2-piece bathroom, laundry area, and plenty of storage. Additional highlights include inside garage access, a private two-car driveway, covered front porch entrance with transom windows, and a freshly painted interior throughout. Upgrades include brand new furnace and light fixtures April 2026, and roof shingles replaced in 2018. Ideally located just steps to downtown Waterdown's shops, restaurants, library, public transit, and scenic escarpment trails, this is an exceptional opportunity to enjoy executive-style living in a mature, family-friendly community. (id:62650)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Hot Tub" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" 6 => "Hood Fan" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"BathroomsPartial": 2 +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-17T13:57:23.234946+00:00" +"Directions": "Take Dundas St E. to Sunnycroft Court and head East. Property will be on your left hand side." +"ExteriorFeatures": array:3 [ 0 => "Stone" 1 => "Vinyl siding" 2 => "Brick Veneer" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2072395" +"ListOfficeKey": "292150" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Paved driveway" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-06-27T18:31:16Z" +"PhotosCount": 50 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-27T18:50:04Z" +"Stories": "2.0" +"StreetName": "SUNNYCROFT" +"StreetNumber": "29" +"StreetSuffix": "Court" +"SubdivisionName": "460 - Waterdown West" +"TaxAnnualAmount": "5412.52" +"VirtualTourURLUnbranded": "https://youriguide.com/29_sunnycroft_ct_hamilton_on" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:11 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29914285/29-sunnycroft-court-waterdown" +"ParkingTotal": 3 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R4-2" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 20.0 +"AboveGradeFinishedArea": 1289 +"BelowGradeFinishedArea": 537 +"OriginalEntryTimestamp": "2026-06-17T11:50:12.24Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"BelowGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1347564" +"ListOfficeNationalAssociationId": "1408460" +"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": 13 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914285')" +"ID": "1538263" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24531 +post_id: "1542130" +post_author: 1 +"ListingKey": "29919964" +"ListingId": "40840403" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-22T22:20:06Z" +"RFModificationTimestamp": "2026-06-22T22:25:07Z" +"ListPrice": 3499000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2367.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9G2N6" +"UnparsedAddress": "311 GOLF LINKS Road, Hamilton, Ontario L9G2N6" +"Coordinates": array:2 [ 0 => -79.9741772 1 => 43.2242735 ] +"Latitude": 43.2242735 +"Longitude": -79.9741772 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Nestled in one of Ancaster's most sought after locations, this charming (yet dated) home has been lovingly held by the same family for over 59 years. Set on a rare and expansive 1.8 plus acre lot, the property offers exceptional privacy and potential. Tucked away at the end of a private laneway and directly across from the Hamilton Golf and Country Club, this beautifully mature, treed setting is truly unique. The lot features full frontage onto Ancaster Park and the Radial Line walking and biking trail, offering a seamless connection to nature. Enjoy a walkable lifestyle just steps from the Village Green Park, Ancaster Tennis Club, Ancaster Lawn Bowling Club, library, local restaurants and the Farmer's Market. This is a unique property. Buyer's are encouraged to consult directly with the Municipality and relevant professionals to fully understand potential uses. A rare opportunity to own a premium piece of land in a prime, secluded location. Room measurements taken at widest locations. Listing realtor has the Basic Zoning Report and will attend all viewings. All offers must be conditional upon review by the Vendor's lawyer. (id:62650)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" 6 => "Hood Fan" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"Cooling": array:1 [ 0 => "None" ] +"CreationDate": "2026-06-18T05:25:42.646373+00:00" +"Directions": "Wilson St to Halson St to Golf Links Road to private lane to the end." +"ExteriorFeatures": array:1 [ 0 => "Stucco" ] +"FireplaceFeatures": array:2 [ 0 => "Wood" 1 => "Other - See remarks" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:1 [ 0 => "Hot water radiator heat" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1524321" +"ListOfficeKey": "55005" +"LivingAreaUnits": "square feet" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-06-18T21:01:47Z" +"PhotosCount": 19 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-22T22:12:23Z" +"Stories": "1.5" +"StreetName": "GOLF LINKS" +"StreetNumber": "311" +"StreetSuffix": "Road" +"SubdivisionName": "422 - Ancaster Heights/Mohawk Meadows/Maywood" +"TaxAnnualAmount": "7358.38" +"VirtualTourURLUnbranded": "https://youtu.be/KLZnbUU_BtY" +"WaterSource": array:1 [ 0 => "Drilled Well" ] +"Rooms": array:14 [ 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] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29919964/311-golf-links-road-hamilton" +"ParkingTotal": 7 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "R2" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 431.0 +"AboveGradeFinishedArea": 2367 +"OriginalEntryTimestamp": "2026-06-18T02:02:00.4Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1129763" +"ListOfficeNationalAssociationId": "1003711" +"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": 13 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919964')" +"ID": "1542130" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24530 +post_id: "1535744" +post_author: 1 +"ListingKey": "29911978" +"ListingId": "40840401" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-29T15:35:04Z" +"RFModificationTimestamp": "2026-06-29T15:37:12Z" +"ListPrice": 449999.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.07 +"LivingArea": 1306.0 +"BuildingAreaTotal": 0 +"City": "Brantford" +"PostalCode": "N3R4J2" +"UnparsedAddress": "20 WELLS Avenue, Brantford, Ontario N3R4J2" +"Coordinates": array:2 [ 0 => -80.2728189 1 => 43.1525702 ] +"Latitude": 43.1525702 +"Longitude": -80.2728189 +"YearBuilt": 1910 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc" +"PublicRemarks": "Move-in ready and fully updated two-storey home in the sought-after Terrace Hill neighbourhood. Ideally located close to parks, schools, and everyday amenities. This charming home offers 3 spacious bedrooms upstairs, 2 bathrooms, and convenient main floor laundry. The bright and inviting interior has been tastefully updated throughout, making it perfect for families or first-time buyers for a turnkey property. The unfinished basement provides endless possibilities for additional living space, a home gym, workshop, or extra storage. Step outside to enjoy the fenced backyard featuring a deck that's perfect for entertaining, relaxing, or summer BBQs. Although this property does not have a driveway, there is easy access to street parking. A time-exempt parking pass can be purchased from the City for $32.74 annually. A fantastic opportunity to own a beautifully updated home in a family-friendly neighbourhood! (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Microwave" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-16T20:29:29.228426+00:00" +"Directions": "St. Paul Avenue to Terrace Hill Street to Wells Avenue" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FoundationDetails": array:1 [ 0 => "Stone" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2167618" +"ListOfficeKey": "48868" +"LivingAreaUnits": "square feet" +"LotSizeDimensions": "0.07" +"ParkingFeatures": array:1 [ 0 => "None" ] +"PhotosChangeTimestamp": "2026-06-18T02:31:25Z" +"PhotosCount": 32 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-29T15:25:15Z" +"Stories": "2.0" +"StreetName": "WELLS" +"StreetNumber": "20" +"StreetSuffix": "Avenue" +"SubdivisionName": "2041 - Terrace Hill" +"TaxAnnualAmount": "3270" +"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": "Brantford" +"ListAORKey": "41" +"ListingURL": "www.realtor.ca/real-estate/29911978/20-wells-avenue-brantford" +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "NLR (F9 A270 C40)" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 25.0 +"AboveGradeFinishedArea": 1306 +"OriginalEntryTimestamp": "2026-06-16T19:55:11.41Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1418373" +"ListOfficeNationalAssociationId": "1001357" +"Media": array:32 [ 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] ] +"DaysOnMarket": 14 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29911978')" +"ID": "1535744" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24641 +post_id: "1535454" +post_author: 1 +"ListingKey": "29911050" +"ListingId": "40840396" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-16T22:00:08Z" +"RFModificationTimestamp": "2026-06-16T22:01:44Z" +"ListPrice": 1259000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 2158.0 +"BuildingAreaTotal": 0 +"City": "Milton" +"PostalCode": "L9T8A7" +"UnparsedAddress": "476 NAIRN Circle, Milton, Ontario L9T8A7" +"Coordinates": array:2 [ 0 => -79.8836593 1 => 43.4883468 ] +"Latitude": 43.4883468 +"Longitude": -79.8836593 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "476 Nairn Circle Is A Rare Opportunity To Own A Beautifully Upgraded Home On A Premium Ravine Lot In Milton's Sought-After Scott Neighbourhood. Close To Top-Rated Schools, Parks, Scenic Trails, Milton GO, Highway 401 And 407. No Sidewalks And Parking For Up To 6 Vehicles. The Bright Open-Concept Main Floor Features Hardwood Flooring And 9 Ft Ceilings. The Layout Is Designed For Modern Family Living. The Kitchen Sits At The Heart Of The Home And Connects The Living And Family Rooms. Built-In Stainless Steel Appliances, Custom Cabinetry, Matching Countertops And Backsplash, Plus A Charming Coffee Nook Complete The Space. Walk Out To An Elevated Deck Overlooking The Peaceful Ravine. Upstairs Features Immaculate New Satin-Finish Hardwood Flooring Throughout. Spacious Bedrooms Offer Comfort For The Whole Family. The Primary Retreat Includes Walk-In Closets And A Spa-Inspired Ensuite. With 5 Bathrooms In Total, Convenience Is Built Into Every Level. The Fully Finished Walkout Basement Offers Incredible Flexibility. Above-Grade Windows, 2 Additional Bathrooms And A Separate Dwelling Setup Make It Ideal For Multigenerational Living Or Income Potential. Possibility To Create 2 Self-Contained Units. One Of The Home's Standout Features Is The Outdoor Living Experience. Enjoy Entertaining On The Upper Deck With Ravine Views. The Lower Level Opens To A Private Backyard Below, Creating The Feel Of Two Distinct Outdoor Spaces Backing Onto Nature. Beautifully Landscaped Front And Rear Gardens Feature Lush Perennial Flowers Including Peonies And Hydrangeas. A Rare Offering In One Of Milton's Most Desirable Family Communities. (id:62650)" +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-16T18:57:14.268809+00:00" +"Directions": "DERRY RD W & TREMAINE RD" +"ExteriorFeatures": array:1 [ 0 => "Brick Veneer" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Unknown" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2188249" +"ListOfficeKey": "283262" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Private Yard" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-06-16T21:52:37Z" +"PhotosCount": 46 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-16T21:52:37Z" +"Stories": "2.0" +"StreetName": "NAIRN" +"StreetNumber": "476" +"StreetSuffix": "Circle" +"SubdivisionName": "1036 - SC Scott" +"TaxAnnualAmount": "5848.08" +"View": "View of water" +"VirtualTourURLUnbranded": "https://tours.vision360tours.ca/476-nairn-circle-milton/nb/" +"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/29911050/476-nairn-circle-milton" +"ParkingTotal": 6 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "NECAB" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 2 +"FrontageLengthNumeric": 38.0 +"AboveGradeFinishedArea": 2158 +"OriginalEntryTimestamp": "2026-06-16T18:11:11.7Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Owner" +"ListAgentNationalAssociationId": "1437150" +"ListOfficeNationalAssociationId": "1326249" +"Media": array:46 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] 44 => array:13 [ …13] 45 => array:13 [ …13] ] +"DaysOnMarket": 14 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29911050')" +"ID": "1535454" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24640 +post_id: "1535950" +post_author: 1 +"ListingKey": "29911947" +"ListingId": "40840394" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-26T15:10:23Z" +"RFModificationTimestamp": "2026-06-26T15:43:36Z" +"ListPrice": 524900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1656.0 +"BuildingAreaTotal": 0 +"City": "Welland" +"PostalCode": "L3C0G8" +"UnparsedAddress": "584 JULIA Drive, Welland, Ontario L3C0G8" +"Coordinates": array:2 [ 0 => -79.2885833 1 => 42.987728 ] +"Latitude": 42.987728 +"Longitude": -79.2885833 +"YearBuilt": 2020 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 584 Julia Drive, this Freehold townhome is located in one of Wellands most sought-after neighbourhoods. Built just 6 years ago, this spacious 1,656 sq. ft. home sits on an impressive 103-ft deep lot and offers 3 bedrooms plus a versatile loft/office space. The bright, sun-filled open-concept main floor is perfect for both everyday living and entertaining, featuring a spacious great room, modern kitchen with centre island, stainless steel appliances, and a dining area with sliding doors leading to the backyard and deck. Upstairs, you'll find three generously sized bedrooms, a convenient second-floor laundry room, and ample storage throughout. The primary bedroom features a private ensuite and“His & Hers” closets. The unfinished basement offers endless potential for additional living space, a recreation room, or home gym. Enjoy parking for up to 3 vehicles with an extended driveway and attached garage with inside entry. Ideally located close to schools, shopping, restaurants, parks, and all major amenities. Just minutes to Highway 406, Highway 20, Niagara College (Welland Campus), and a short drive or transit ride to Brock University. Currently tenant occupied ($1920/month), tenant has occupied the property since 2020 and would like to stay if the new owner is looking for an investment property. A fantastic opportunity for families, first-time buyers, or investors in a thriving and family-friendly community. (id:62783)" +"Appliances": array:6 [ 0 => "Refrigerator" 1 => "Central Vacuum" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Microwave Built-in" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-16T20:34:14.553717+00:00" +"Directions": "Webber Rd to S Pelham Rd" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1524224" +"ListOfficeKey": "275989" +"LivingAreaUnits": "square feet" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-06-16T19:50:55Z" +"PhotosCount": 29 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-26T15:01:57Z" +"Stories": "2.0" +"StreetName": "JULIA" +"StreetNumber": "584" +"StreetSuffix": "Drive" +"SubdivisionName": "771 - Coyle Creek" +"TaxAnnualAmount": "5305" +"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/29911947/584-julia-drive-welland" +"ParkingTotal": 3 +"StructureType": array:1 [ 0 => "Row / Townhouse" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "RM-37" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 20.0 +"AboveGradeFinishedArea": 1656 +"OriginalEntryTimestamp": "2026-06-16T19:50:55.45Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1064132" +"ListOfficeNationalAssociationId": "1269881" +"Media": array:29 [ 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] ] +"DaysOnMarket": 14 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29911947')" +"ID": "1535950" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25071 +post_id: "1539959" +post_author: 1 +"ListingKey": "29917205" +"ListingId": "40840393" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-17T18:20:17Z" +"RFModificationTimestamp": "2026-06-17T18:45:34Z" +"ListPrice": 599000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1700.0 +"BuildingAreaTotal": 0 +"City": "Brantford" +"PostalCode": "N3T4X7" +"UnparsedAddress": "175 GRAND RIVER Avenue, Brantford, Ontario N3T4X7" +"Coordinates": array:2 [ 0 => -80.2827598 1 => 43.1417659 ] +"Latitude": 43.1417659 +"Longitude": -80.2827598 +"YearBuilt": 1947 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc" +"PublicRemarks": "There are certain streets in Brantford where the location does a lot of the talking, and Grand River Avenue in Holmedale is definitely one of them. Welcome to 175 Grand River Avenue, a beautifully updated home just steps from the Grand River, walking trails, mature trees, and one of the city’s most scenic neighbourhood settings. This home has the character you want in Holmedale, but with the updates buyers are hoping for. The main floor features a bright living room with hardwood flooring, an updated kitchen with white cabinetry, stainless steel appliances, a large centre island, and a comfortable dining area that keeps the space feeling open and connected. At the back of the home, the sunroom gives you that bonus space everyone seems to need, whether it becomes a mudroom, pet area, plant room, or quiet little retreat. Upstairs offers three bedrooms and a full bathroom, while the finished basement gives you even more room to spread out with a large rec room, seating area, and two-piece bath. The outdoor space is a real standout. The fenced front yard, landscaping, and covered patio/gazebo area create a private spot to relax, entertain, or enjoy summer nights without needing a huge property to maintain. If you’ve been waiting for a Holmedale home that combines location, updates, character, and usable living space, 175 Grand River Avenue deserves a serious look. (id:62783)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Microwave" 6 => "Hood Fan" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-17T18:45:20.747070+00:00" +"Directions": "Brant Avenue to Waterloo Street, right on Grand River Avenue." +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Stucco" ] +"Fencing": array:1 [ 0 => "Fence" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2060764" +"ListOfficeKey": "293165" +"LivingAreaUnits": "square feet" +"PhotosChangeTimestamp": "2026-06-17T18:14:36Z" +"PhotosCount": 35 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-17T18:14:36Z" +"Stories": "2.0" +"StreetName": "GRAND RIVER" +"StreetNumber": "175" +"StreetSuffix": "Avenue" +"SubdivisionName": "2038 - Holmedale" +"TaxAnnualAmount": "3779.66" +"Utilities": array:1 [ 0 => "Cable" ] +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:11 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] ] +"ListAOR": "Brantford" +"ListAORKey": "41" +"ListingURL": "www.realtor.ca/real-estate/29917205/175-grand-river-avenue-brantford" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "2238484" +"CommonInterest": "Freehold" +"CoListOfficeKey": "292003" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "NLR (F9 A270 C40)" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 26.0 +"AboveGradeFinishedArea": 1700 +"OriginalEntryTimestamp": "2026-06-17T18:14:36.67Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1335904" +"ListOfficeNationalAssociationId": "1423396" +"CoListAgentNationalAssociationId": "1476314" +"CoListOfficeNationalAssociationId": "1407357" +"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": 13 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29917205')" +"ID": "1539959" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24567 +post_id: "1536917" +post_author: 1 +"ListingKey": "29912510" +"ListingId": "40840390" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-30T20:00:10Z" +"RFModificationTimestamp": "2026-06-30T20:03:26Z" +"ListPrice": 699999.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1784.0 +"BuildingAreaTotal": 0 +"City": "Brampton" +"PostalCode": "L6Y2T5" +"UnparsedAddress": "15 CRESSWELL Drive, Brampton, Ontario L6Y2T5" +"Coordinates": array:2 [ 0 => -79.7556041 1 => 43.6590733 ] +"Latitude": 43.6590733 +"Longitude": -79.7556041 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 15 Cresswell a well maintained and spacious home in the highly sought-after Fletcher's west community. The family-sized kitchen and generous breakfast area walk out to a large deck, creating the perfect space for outdoor entertaining and family gatherings. Beautiful, well maintained home featuring 3 bedrooms and a partially finished basement. This carpet free property is clean and well cared for, offering generously sized rooms throughout. The living and dining areas boast high ceilings, creating a bright, open, and spacious feel. The basement offers great potential for conversion, including the possibility of an in-suite Conveniently located close to schools, parks, transit, and other amenities. (id:62650)" +"Appliances": array:1 [ 0 => "Washer" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:2 [ 0 => "School Bus" 1 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-16T22:46:48.042797+00:00" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2155129" +"ListOfficeKey": "294083" +"LivingAreaUnits": "square feet" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-06-30T19:52:33Z" +"PhotosCount": 34 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-30T19:52:33Z" +"Stories": "2.0" +"StreetName": "CRESSWELL" +"StreetNumber": "15" +"StreetSuffix": "Drive" +"SubdivisionName": "BRFW - Fletcher's West" +"TaxAnnualAmount": "5067.56" +"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/29912510/15-cresswell-drive-brampton" +"ParkingTotal": 3 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R2B" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 31.0 +"AboveGradeFinishedArea": 1248 +"BelowGradeFinishedArea": 536 +"OriginalEntryTimestamp": "2026-06-16T21:10:51.02Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1406566" +"ListOfficeNationalAssociationId": "1435203" +"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": 14 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912510')" +"ID": "1536917" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24600 +post_id: "1536105" +post_author: 1 +"ListingKey": "29911948" +"ListingId": "40840389" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-28T20:20:16Z" +"RFModificationTimestamp": "2026-06-28T20:26:12Z" +"ListPrice": 689900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 2137.0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L4J3" +"UnparsedAddress": "543 GLEN FORREST Boulevard, Waterloo, Ontario N2L4J3" +"Coordinates": array:2 [ 0 => -80.5539256 1 => 43.4861133 ] +"Latitude": 43.4861133 +"Longitude": -80.5539256 +"YearBuilt": 1967 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to this detached bungalow in a desirable and tucked-away Waterloo location, offering over 1,800 sq. ft. of finished living space, a huge lot, and incredible potential inside and out. Perfect for first-time buyers, investors, or multi-generational families, this home features a bright main level with 3 bedrooms, 1 full bathroom, and comfortable living and dining areas. The separate entrance to the basement adds excellent flexibility, with 4 additional bedrooms and 2 full bathrooms, making it ideal for extended family use or potential mortgage-helper income. Set on a generous lot with 60 ft. frontage, this property offers parking for up to 4 vehicles in the driveway plus 1 in the garage. The backyard is a major highlight, offering so much potential to create a private outdoor retreat, garden space, patio area, or future entertaining setup. Located in a secluded area of Waterloo while still being close to everyday amenities, shopping, schools, public transportation, Conestoga College, and the University of Waterloo, this home provides both convenience and opportunity. Whether you are looking to move in, invest, or add value over time, this property is full of possibilities. Book your private showing today! * Some photos have been virtually staged. (id:62650)" +"Appliances": array:3 [ 0 => "Washer" 1 => "Stove" 2 => "Dryer" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-16T20:34:13.849462+00:00" +"Directions": "BEARINGER RD TO GLEN FORREST BLVD" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1750682" +"ListOfficeKey": "289792" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "In-Law Suite" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-06-16T19:50:57Z" +"PhotosCount": 31 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-28T20:12:10Z" +"Stories": "1.0" +"StreetName": "GLEN FORREST" +"StreetNumber": "543" +"StreetSuffix": "Boulevard" +"SubdivisionName": "421 - Lakeshore/Parkdale" +"TaxAnnualAmount": "4425" +"VirtualTourURLUnbranded": "https://youriguide.com/0frvu_543_glen_forrest_blvd_waterloo_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/29911948/543-glen-forrest-boulevard-waterloo" +"ParkingTotal": 5 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "2172787" +"CommonInterest": "Freehold" +"CoListOfficeKey": "156376" +"GeocodeManualYN": true +"ZoningDescription": "SR1" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 3 +"FrontageLengthNumeric": 60.0 +"AboveGradeFinishedArea": 1108 +"BelowGradeFinishedArea": 1029 +"OriginalEntryTimestamp": "2026-06-16T19:50:55.86Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1164848" +"ListOfficeNationalAssociationId": "1381240" +"CoListAgentNationalAssociationId": "1423270" +"CoListOfficeNationalAssociationId": "1003925" +"Media": array:31 [ 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] ] +"DaysOnMarket": 14 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29911948')" +"ID": "1536105" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24534 +post_id: "1544624" +post_author: 1 +"ListingKey": "29924271" +"ListingId": "40840386" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-29T14:50:04Z" +"RFModificationTimestamp": "2026-06-29T14:54:22Z" +"ListPrice": 899000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 3690.0 +"BuildingAreaTotal": 0 +"City": "Woodstock" +"PostalCode": "N4T1T5" +"UnparsedAddress": "796 SPRINGBANK Avenue N, Woodstock, Ontario N4T1T5" +"Coordinates": array:2 [ 0 => -80.7287809 1 => 43.1551726 ] +"Latitude": 43.1551726 +"Longitude": -80.7287809 +"YearBuilt": 2002 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 796 Springbank Ave N! This rock-solid, well-built bungalow in highly desirable North Woodstock offers an incredible layout and fantastic bones. The main floor features a functional design with 2 spacious bedrooms and 2 full bathrooms, including a private primary ensuite. Downstairs, the fully finished basement provides excellent additional living space with 2 more bedrooms, a 3rd full bathroom, and a large recreation room. A standout feature for hobbyists, contractors, or car enthusiasts is the dedicated basement workshop, featuring a highly convenient walk-up directly into the attached garage. Outside, the property boasts great curb appeal and an integrated lawn sprinkler system to keep your yard looking pristine all summer long. Located in a mature, sought-after neighbourhood close to schools, shopping, parks, and Pittock Lake trails, this home is a rare find that combines practical functionality with endless potential! (id:62650)" +"AccessibilityFeatures": array:1 [ 0 => "Accessible Full Bath" ] +"Appliances": array:9 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Dishwasher" 4 => "Wine Fridge" 5 => "Stove" 6 => "Dryer" 7 => "Microwave" 8 => "Window Coverings" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CommunityFeatures": array:2 [ 0 => "School Bus" 1 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-18T20:30:55.492926+00:00" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"Fencing": array:1 [ 0 => "Fence" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2254722" +"ListOfficeKey": "280721" +"LivingAreaUnits": "square feet" +"LotFeatures": array:6 [ 0 => "Corner Site" 1 => "Conservation/green belt" 2 => "Gazebo" 3 => "Sump Pump" 4 => "Automatic Garage Door Opener" 5 => "Private Yard" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-06-18T19:31:21Z" +"PhotosCount": 29 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-29T14:42:11Z" +"Stories": "1.0" +"StreetDirSuffix": "North" +"StreetName": "SPRINGBANK" +"StreetNumber": "796" +"StreetSuffix": "Avenue" +"SubdivisionName": "Woodstock - North" +"TaxAnnualAmount": "7200" +"Utilities": array:2 [ 0 => "Electricity" 1 => "Cable" ] +"VirtualTourURLUnbranded": "https://youriguide.com/796_springbank_ave_n_woodstock_on/" +"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/29924271/796-springbank-avenue-n-woodstock" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "2129938" +"CommonInterest": "Freehold" +"CoListAgentKey2": "1941951" +"CoListOfficeKey": "292877" +"GeocodeManualYN": true +"CoListOfficeKey2": "292877" +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "R1" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 2 +"FrontageLengthNumeric": 41.0 +"AboveGradeFinishedArea": 1880 +"BelowGradeFinishedArea": 1810 +"OriginalEntryTimestamp": "2026-06-18T19:31:21.8Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1493660" +"ListOfficeNationalAssociationId": "1316887" +"CoListAgentNationalAssociationId": "1382907" +"CoListAgentNationalAssociationId2": "1238606" +"CoListOfficeNationalAssociationId": "1418791" +"CoListOfficeNationalAssociationId2": "1418791" +"Media": array:29 [ 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] ] +"DaysOnMarket": 12 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924271')" +"ID": "1544624" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24576 +post_id: "1540436" +post_author: 1 +"ListingKey": "29916668" +"ListingId": "40840385" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-17T17:30:30Z" +"RFModificationTimestamp": "2026-06-17T19:02:03Z" +"ListPrice": 819900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1680.0 +"BuildingAreaTotal": 0 +"City": "Simcoe" +"PostalCode": "N3Y0B2" +"UnparsedAddress": "54 JUDD Drive, Simcoe, Ontario N3Y0B2" +"Coordinates": array:2 [ 0 => -80.28661 1 => 42.8460597 ] +"Latitude": 42.8460597 +"Longitude": -80.28661 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Discover Your Dream Home at 54 Judd Drive, Simcoe. Step into style and comfort with this to-be-built 1,680 sq. ft. modern bungalow in a sought-after Simcoe neighbourhood. Perfectly positioned close to schools, shopping, dining, and all the amenities the town has to offer, this home combines convenience with contemporary design. From the oversized double garage with 16' Doors, enter through a practical mud/laundry room that opens into a welcoming foyer. Inside, 9-foot ceilings throughout — and a striking 10-foot tray ceiling in the Great Room. The open concept main floor includes a bright living area and a beautifully laid-out kitchen, ideal for entertaining. With three generous bedrooms, this home is designed for modern living. As a pre-construction opportunity, buyers can enjoy the exciting chance to personalize their new home with quality allowances for cabinetry, countertops, flooring, ensuite tile, plumbing and light fixtures, paint colours, and even the front door design. Enjoy the outdoors from both the covered front porch and rear patio and appreciate the lasting curb appeal of the brick and stone exterior. Don't miss this opportunity to create the home you've always wanted — call today to begin your journey! (id:62783)" +"Appliances": array:1 [ 0 => "Central Vacuum - Roughed In" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-17T19:01:56.899422+00:00" +"Directions": "Highway 3 to Ireland Road to Judd Drive" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2073916" +"ListOfficeKey": "284635" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Sump Pump" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-06-17T17:12:52Z" +"PhotosCount": 4 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-17T17:12:52Z" +"Stories": "1.0" +"StreetName": "JUDD" +"StreetNumber": "54" +"StreetSuffix": "Drive" +"SubdivisionName": "Town of Simcoe" +"Utilities": array:2 [ 0 => "Natural Gas" 1 => "Electricity" ] +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:11 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29916668/54-judd-drive-simcoe" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R1-A (H)" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 50.0 +"AboveGradeFinishedArea": 1680 +"OriginalEntryTimestamp": "2026-06-17T17:11:31.84Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Builder" +"ListAgentNationalAssociationId": "1349084" +"ListOfficeNationalAssociationId": "1344652" +"Media": array:4 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] ] +"DaysOnMarket": 13 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29916668')" +"ID": "1540436" } ] +success: true +page_size: 12 +page_count: 16933 +count: 203190 +after_key: "" } "RF Response Time" => "0.21 seconds" ] ]