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=175860&$filter=InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24612 +items: array:12 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24638 +post_id: "1639482" +post_author: 1 +"ListingKey": "30052193" +"ListingId": "40849092" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-18T21:25:14Z" +"RFModificationTimestamp": "2026-07-18T21:28:57Z" +"ListPrice": 820000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2528.0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2V1B2" +"UnparsedAddress": "109 WHITE OAK Place, Waterloo, Ontario N2V1B2" +"Coordinates": array:2 [ 0 => -80.5558691 1 => 43.4950613 ] +"Latitude": 43.4950613 +"Longitude": -80.5558691 +"YearBuilt": 1978 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Gorgeous oversized raised bungalow on a quiet dead end street with no traffic. No sidewalk to shovel either! This home has over 2500 square feet of finished living space offering 3+1 beds and 2 full baths. The upstairs is nicely updated with hardwood floors and a custom kitchen with stone counter-tops. The stainless appliances includes a gas stove for the resident chef. The family room has 3 skylights bathing the space in beautiful natural light. There's a walkout to the back from this room leading to a spacious and quiet backyard. Downstairs features a huge family room with tons of light and a real wood fireplace. There's an addition bedroom and 3 pc bath on this level as well as easy access to the 2 car garage. The Lakeshore North location is great for expressway and LRT access. You've got a daycare very close by, local schools and shopping like Conestoga Mall, Sobeys and the Farmers Market. Laurel Creek Conversation Area is right up the road so getting to nature is very easy. Additional improvements include fresh paint, new rear stairs (summer 2025), spray foamed garage ceiling (2023), new heat pump (2023), new roof (2026), epoxy cold room crack repair (2026), and new front stairs (2026). (id:62650)" +"Appliances": array:9 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Range - Gas" 4 => "Dishwasher" 5 => "Dryer" 6 => "Microwave" 7 => "Window Coverings" 8 => "Garage door opener" ] +"ArchitecturalStyle": array:1 [ 0 => "Raised bungalow" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"CreationDate": "2026-07-18T17:46:35.956141+00:00" +"Directions": "Northlake to Black Oak to White Oak" +"ExteriorFeatures": array:2 [ 0 => "Aluminum siding" 1 => "Brick Veneer" ] +"FireplaceFeatures": array:2 [ 0 => "Wood" 1 => "Other - See remarks" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1985202" +"ListOfficeKey": "289541" +"LivingAreaUnits": "square feet" +"LotFeatures": array:5 [ 0 => "Cul-de-sac" 1 => "Conservation/green belt" 2 => "Skylight" 3 => "Sump Pump" 4 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-07-18T21:18:17Z" +"PhotosCount": 40 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-18T21:18:17Z" +"Stories": "1.0" +"StreetName": "WHITE OAK" +"StreetNumber": "109" +"StreetSuffix": "Place" +"SubdivisionName": "442 - Lakeshore North" +"TaxAnnualAmount": "5843.62" +"Utilities": array:4 [ 0 => "Natural Gas" 1 => "Electricity" 2 => "Cable" 3 => "Telephone" ] +"View": "City view" +"VirtualTourURLUnbranded": "https://youriguide.com/109_white_oak_place_waterloo_on/" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:11 [ 0 => array:11 [ "RoomKey" => "1688028267" "RoomType" => "Bedroom" "ListingId" => "40849092" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30052193" "RoomLength" => null "RoomDimensions" => "10'1'' x 10'10''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-18T21:18:17.44Z" ] 1 => array:11 [ "RoomKey" => "1688028268" "RoomType" => "Bedroom" "ListingId" => "40849092" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30052193" "RoomLength" => null "RoomDimensions" => "14'4'' x 20'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-18T21:18:17.44Z" ] 2 => array:11 [ "RoomKey" => "1688028269" "RoomType" => "Primary Bedroom" "ListingId" => "40849092" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30052193" "RoomLength" => null "RoomDimensions" => "12'10'' x 14'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-18T21:18:17.44Z" ] 3 => array:11 [ "RoomKey" => "1688028270" "RoomType" => "4pc Bathroom" "ListingId" => "40849092" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30052193" "RoomLength" => null "RoomDimensions" => "8'0'' x 12'9''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-18T21:18:17.44Z" ] 4 => array:11 [ "RoomKey" => "1688028271" "RoomType" => "Family room" "ListingId" => "40849092" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30052193" "RoomLength" => null "RoomDimensions" => "11'7'' x 18'10''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-18T21:18:17.44Z" ] 5 => array:11 [ "RoomKey" => "1688028272" "RoomType" => "Living room" "ListingId" => "40849092" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30052193" "RoomLength" => null "RoomDimensions" => "12'1'' x 19'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-18T21:18:17.44Z" ] 6 => array:11 [ "RoomKey" => "1688028273" "RoomType" => "Kitchen/Dining room" "ListingId" => "40849092" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "30052193" "RoomLength" => null "RoomDimensions" => "12'4'' x 23'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-18T21:18:17.44Z" ] 7 => array:11 [ "RoomKey" => "1688028274" "RoomType" => "Utility room" "ListingId" => "40849092" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "30052193" "RoomLength" => null "RoomDimensions" => "12'4'' x 11'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-18T21:18:17.44Z" ] 8 => array:11 [ "RoomKey" => "1688028275" "RoomType" => "3pc Bathroom" "ListingId" => "40849092" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "30052193" "RoomLength" => null "RoomDimensions" => "7'11'' x 4'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-18T21:18:17.44Z" ] 9 => array:11 [ "RoomKey" => "1688028276" "RoomType" => "Bedroom" "ListingId" => "40849092" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "30052193" "RoomLength" => null "RoomDimensions" => "12'7'' x 11'3''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-18T21:18:17.44Z" ] 10 => array:11 [ "RoomKey" => "1688028277" "RoomType" => "Recreation room" "ListingId" => "40849092" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "30052193" "RoomLength" => null "RoomDimensions" => "11'6'' x 31'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-18T21:18:17.44Z" ] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30052193/109-white-oak-place-waterloo" +"ParkingTotal": 6 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "R1" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 48.0 +"AboveGradeFinishedArea": 1618 +"BelowGradeFinishedArea": 910 +"OriginalEntryTimestamp": "2026-07-18T17:18:11.42Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1269822" +"ListOfficeNationalAssociationId": "1378680" +"Media": array:40 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "30052193_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/a2575d448edcf381876cac8870ee47ca.webp" "MediaSize" => 176487 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-a2575d448edcf381876cac8870ee47ca.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Residence featuring a stone and siding exterior, an elevated front entrance with wood railing, a two-car attached garage with dark wood-look doors, and a paved driveway" "PreferredPhotoYN" => true "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T17:18:11.43Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "30052193_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/def994de89ec4391c72a72968d9541f2.webp" "MediaSize" => 209937 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-def994de89ec4391c72a72968d9541f2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Stone facade residence featuring a covered front entrance with wood railings, a two-car garage, and mature landscaping" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T17:18:11.43Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "30052193_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/09ca0e4d5c12547f27d058f9faa28645.webp" "MediaSize" => 213195 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-09ca0e4d5c12547f27d058f9faa28645.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Raised bungalow featuring a light-colored brick facade and contrasting dark shutters" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T17:18:11.43Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "30052193_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/ce774808ea91bdc7a1453c8d3838c415.webp" "MediaSize" => 163219 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-ce774808ea91bdc7a1453c8d3838c415.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Stone veneer exterior with a storm door featuring decorative glass inserts and a full-length sidelight" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T17:18:11.43Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "30052193_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/c14a178d970b92730a51150be41694aa.webp" "MediaSize" => 85622 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-c14a178d970b92730a51150be41694aa.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:36.56Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "30052193_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/968cd7caddd6ff595b057d769d847aaa.webp" "MediaSize" => 111514 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-968cd7caddd6ff595b057d769d847aaa.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:36.55Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "30052193_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/e8c9873141f4b9c555beb5f2249840ee.webp" "MediaSize" => 71718 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-e8c9873141f4b9c555beb5f2249840ee.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:36.55Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "30052193_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/f959296673189879b39f36852d791916.webp" "MediaSize" => 95431 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-f959296673189879b39f36852d791916.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.56Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "30052193_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/52ebb1ce2af7334e9627a1fb1c6dce3f.webp" "MediaSize" => 77449 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-52ebb1ce2af7334e9627a1fb1c6dce3f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:36.55Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "30052193_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/a0f713b527ddfc1731aa1bf32af4df82.webp" "MediaSize" => 97466 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-a0f713b527ddfc1731aa1bf32af4df82.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen featuring a center island with a light-toned countertop and green paneled cabinetry" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.55Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "30052193_4890_11" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/ac9e7d5c8902678b232c4c223ed89efd.webp" "MediaSize" => 124315 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-ac9e7d5c8902678b232c4c223ed89efd.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen featuring a central island with an integrated sink, stainless steel appliances, dark wood cabinetry, and recessed lighting" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.55Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "30052193_4890_12" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/3b018881c984abdf35abea40355f1363.webp" "MediaSize" => 111037 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-3b018881c984abdf35abea40355f1363.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen featuring wood cabinetry, stainless steel appliances, a white solid surface countertop, and a black double basin sink" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:36.55Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "30052193_4890_13" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/44977da3aac8f1f01a67be7c06808646.webp" "MediaSize" => 56922 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-44977da3aac8f1f01a67be7c06808646.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen featuring rich wood cabinetry, dark speckled countertops, stainless steel range with overhead vent, and a textured tile backsplash" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.3Z" ] 13 => array:13 [ "Order" => 14 "MediaKey" => "30052193_4890_14" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/96de814caf05614120dc4c9d721def5c.webp" "MediaSize" => 73668 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-96de814caf05614120dc4c9d721def5c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen island featuring a double basin sink with a matte black faucet, light-toned countertop, and integrated dishwasher" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.55Z" ] 14 => array:13 [ "Order" => 15 "MediaKey" => "30052193_4890_15" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/ea5a8466a7f0e04b31c539d5e5588a65.webp" "MediaSize" => 101539 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-ea5a8466a7f0e04b31c539d5e5588a65.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen featuring dark wood cabinetry, a built-in stainless steel refrigerator, black speckled countertops, and a stacked stone backsplash" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.71Z" ] 15 => array:13 [ "Order" => 16 "MediaKey" => "30052193_4890_16" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/67efa8ad1f5bc35c98b0078834475b42.webp" "MediaSize" => 74517 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-67efa8ad1f5bc35c98b0078834475b42.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.69Z" ] 16 => array:13 [ "Order" => 17 "MediaKey" => "30052193_4890_17" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/199330f227845c3a7efaed4928379b25.webp" "MediaSize" => 73236 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-199330f227845c3a7efaed4928379b25.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.55Z" ] 17 => array:13 [ "Order" => 18 "MediaKey" => "30052193_4890_18" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/7ad33932032fe5cc599baa460b88fccc.webp" "MediaSize" => 85019 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-7ad33932032fe5cc599baa460b88fccc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.55Z" ] 18 => array:13 [ "Order" => 19 "MediaKey" => "30052193_4890_19" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/d7cf32d6a03dc192e6656c21ce474994.webp" "MediaSize" => 80916 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-d7cf32d6a03dc192e6656c21ce474994.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Room with wood-finish flooring, two skylights, a large bay window, and white baseboards" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.3Z" ] 19 => array:13 [ "Order" => 20 "MediaKey" => "30052193_4890_20" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/211e4d14f4ad095673baeb313b2e5545.webp" "MediaSize" => 53512 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-211e4d14f4ad095673baeb313b2e5545.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.55Z" ] 20 => array:13 [ "Order" => 21 "MediaKey" => "30052193_4890_21" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/d6ca6771cf297ae8287ec89b23357599.webp" "MediaSize" => 71606 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-d6ca6771cf297ae8287ec89b23357599.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Hardwood-style flooring throughout this space with multiple skylights and large windows" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:38.49Z" ] 21 => array:13 [ "Order" => 22 "MediaKey" => "30052193_4890_22" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/81e610cd72a8aea55969d1dade237c76.webp" "MediaSize" => 69210 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-81e610cd72a8aea55969d1dade237c76.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Hallway featuring wood-finish flooring and white baseboards" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.56Z" ] 22 => array:13 [ "Order" => 23 "MediaKey" => "30052193_4890_23" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/a1887c4e5452118d30b639eb7c45dd40.webp" "MediaSize" => 95058 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-a1887c4e5452118d30b639eb7c45dd40.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Spacious room featuring wood-finish flooring, white walls, and a modern drum chandelier" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.56Z" ] 23 => array:13 [ "Order" => 24 "MediaKey" => "30052193_4890_24" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/e7d3a938e9ea674aab94d1f5d3de4a68.webp" "MediaSize" => 96265 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-e7d3a938e9ea674aab94d1f5d3de4a68.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Room featuring dark wood-finish flooring, a contemporary drum chandelier, and light-toned walls" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.55Z" ] 24 => array:13 [ "Order" => 25 "MediaKey" => "30052193_4890_25" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/91a2a00b12cec3255e2dcd4ba74cd8be.webp" "MediaSize" => 90900 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-91a2a00b12cec3255e2dcd4ba74cd8be.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.56Z" ] 25 => array:13 [ "Order" => 26 "MediaKey" => "30052193_4890_26" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/5967b3a4e6bd8e3cac29e75eb77b8144.webp" "MediaSize" => 137052 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-5967b3a4e6bd8e3cac29e75eb77b8144.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bathroom featuring a double vanity with stone-look countertops, integrated sinks, white cabinetry, and wood-finish flooring" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.56Z" ] 26 => array:13 [ "Order" => 27 "MediaKey" => "30052193_4890_27" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/a5e2875d397ed1f6f76ee0a02d0aea6a.webp" "MediaSize" => 52527 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-a5e2875d397ed1f6f76ee0a02d0aea6a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Room featuring rich wood-finish flooring, a contemporary ceiling light fixture, a window with natural light, and a mirrored sliding closet door" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.55Z" ] 27 => array:13 [ "Order" => 28 "MediaKey" => "30052193_4890_28" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/c3c5c0d8a96bb3ff641d459335be7277.webp" "MediaSize" => 93325 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-c3c5c0d8a96bb3ff641d459335be7277.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.55Z" ] 28 => array:13 [ "Order" => 29 "MediaKey" => "30052193_4890_29" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/9d7165a2e2be9d4d82d9aaa2a4534c01.webp" "MediaSize" => 90329 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-9d7165a2e2be9d4d82d9aaa2a4534c01.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Room featuring dark wood-finish flooring, a white ceiling with a flush-mount light fixture, and a window with white trim" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.69Z" ] 29 => array:13 [ "Order" => 30 "MediaKey" => "30052193_4890_30" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/55421d3fcbb1d7d9b88d824e506d1c64.webp" "MediaSize" => 102187 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-55421d3fcbb1d7d9b88d824e506d1c64.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Room featuring rich wood-finish flooring, white baseboards, a bi-fold closet, and a hallway entry" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.55Z" ] 30 => array:13 [ "Order" => 31 "MediaKey" => "30052193_4890_31" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/bcd8080f254f65e363da459ce926a205.webp" "MediaSize" => 75401 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-bcd8080f254f65e363da459ce926a205.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Staircase featuring wood steps with carpet treads, a white decorative metal railing, and a wood handrail" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:36.55Z" ] 31 => array:13 [ "Order" => 32 "MediaKey" => "30052193_4890_32" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/b247b8a73bb542523e29946519fecbb1.webp" "MediaSize" => 127139 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-b247b8a73bb542523e29946519fecbb1.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Spacious room featuring wood-finish flooring, light green wainscoting, and a natural wood-panel accent wall" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:36.55Z" ] 32 => array:13 [ "Order" => 33 "MediaKey" => "30052193_4890_33" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/490c3466333cea1cac9e9447e051992e.webp" "MediaSize" => 139558 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-490c3466333cea1cac9e9447e051992e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.55Z" ] 33 => array:13 [ "Order" => 34 "MediaKey" => "30052193_4890_34" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/d79e1ac380523434a4bbe831877f2d62.webp" "MediaSize" => 247605 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-d79e1ac380523434a4bbe831877f2d62.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Hallway featuring wood-finish flooring, neutral wall tones, and white trim" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.69Z" ] 34 => array:13 [ "Order" => 35 "MediaKey" => "30052193_4890_35" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/ec8dc4ea01c396676487686dbe553882.webp" "MediaSize" => 227897 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-ec8dc4ea01c396676487686dbe553882.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bathroom featuring a walk-in shower with mosaic tile, custom wood shelving, a contemporary vanity with an integrated sink, a rectangular mirror, and a copper tile backsplash" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:44.68Z" ] 35 => array:13 [ "Order" => 36 "MediaKey" => "30052193_4890_36" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/2bf19ca1aa6e98e010e77d7fa600b3ad.webp" "MediaSize" => 223577 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-2bf19ca1aa6e98e010e77d7fa600b3ad.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bathroom vanity featuring a rectangular vessel sink, brushed nickel faucet, and a copper-toned mosaic tile backsplash" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.55Z" ] 36 => array:13 [ "Order" => 37 "MediaKey" => "30052193_4890_37" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/9cc863804ace59fff6becbe986987503.webp" "MediaSize" => 217461 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-9cc863804ace59fff6becbe986987503.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:39.55Z" ] 37 => array:13 [ "Order" => 38 "MediaKey" => "30052193_4890_38" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/27ee6844da4b9402eb84f637dd938689.webp" "MediaSize" => 226536 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-27ee6844da4b9402eb84f637dd938689.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Dedicated laundry area with a utility sink and upper cabinetry" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:44.73Z" ] 38 => array:13 [ "Order" => 39 "MediaKey" => "30052193_4890_39" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/3468004b51739fae3ccfa4f9d736d4d3.webp" "MediaSize" => 242090 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-3468004b51739fae3ccfa4f9d736d4d3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:44.7Z" ] 39 => array:13 [ "Order" => 40 "MediaKey" => "30052193_4890_40" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052193/0a11434ae11d577624de544afd720c6f.webp" "MediaSize" => 227219 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052193/thumbnail-0a11434ae11d577624de544afd720c6f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Spacious interior room featuring wood-finish flooring, a stone-clad fireplace with a dark hearth, a ceiling fan with integrated lighting, and multiple windows" "PreferredPhotoYN" => false "ResourceRecordId" => "40849092" "ResourceRecordKey" => "30052193" "ModificationTimestamp" => "2026-07-18T21:01:44.68Z" ] ] +"DaysOnMarket": 0 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30052193')" +"ID": "1639482" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24540 +post_id: "1636717" +post_author: 1 +"ListingKey": "30047518" +"ListingId": "40849086" +"PropertyType": "Commercial Lease" +"PropertySubType": "Industrial" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-17T15:35:20Z" +"RFModificationTimestamp": "2026-07-17T16:56:55Z" +"ListPrice": 0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0.5005 +"LivingArea": 5000.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8L6N6" +"UnparsedAddress": "350 SHERMAN Avenue N, Hamilton, Ontario L8L6N6" +"Coordinates": array:2 [ 0 => -79.8329348 1 => 43.263112 ] +"Latitude": 43.263112 +"Longitude": -79.8329348 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Excellent opportunity to own a versatile 5,000 sq. ft. light industrial/commercial building in Hamilton's established industrial district. Situated on a 0.05-acre lot with frontage on two separate streets, this M5-zoned property offers excellent accessibility and functionality for a wide range of industrial and commercial uses . The building features approximately 1,050 sq. ft. of finished office space, with the balance configured for warehouse and industrial operations. Two large drive-in bay doors, 13'8 x 11'3 & 9'10 x 9'9 provide efficient access for shipping, receiving, equipment, and storage. Ideal for manufacturing, warehousing, trades, distribution, fabrication, or owner-occupiers seeking flexible industrial space. Conveniently located with quick access to major transportation routes, including the Red Hill Valley Parkway, QEW, and downtown Hamilton (id:62650)" +"AssociationFeeIncludes": array:1 [ 0 => "Insurance" ] +"Basement": array:1 [ 0 => "Partial" ] +"BuildingAreaUnits": "square feet" +"CreationDate": "2026-07-17T16:56:50.375231+00:00" +"ExteriorFeatures": array:1 [ 0 => "Brick Veneer" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1982345" +"ListOfficeKey": "284641" +"LivingAreaUnits": "square feet" +"LotSizeDimensions": "0.5005" +"PhotosChangeTimestamp": "2026-07-17T15:29:25Z" +"PhotosCount": 19 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-17T15:29:25Z" +"Stories": "1.0" +"StreetDirSuffix": "North" +"StreetName": "SHERMAN" +"StreetNumber": "350" +"StreetSuffix": "Avenue" +"SubdivisionName": "210 - North Sherman" +"TaxAnnualAmount": "21998" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30047518/350-sherman-avenue-n-hamilton" +"StructureType": array:1 [ 0 => "Other" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"TotalActualRent": 12500 +"ExistingLeaseType": array:1 [ 0 => "Net" ] +"ZoningDescription": "M5" +"LeaseAmountFrequency": "Monthly" +"FrontageLengthNumeric": 76.0 +"OriginalEntryTimestamp": "2026-07-17T15:29:25.07Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1267464" +"ListOfficeNationalAssociationId": "1344650" +"Media": array:19 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "30047518_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047518/ac4de4cbb4587784b917cc4bc69d6812.webp" "MediaSize" => 159724 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047518/thumbnail-ac4de4cbb4587784b917cc4bc69d6812.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Image quality insufficient for description" "PreferredPhotoYN" => true "ResourceRecordId" => "40849086" "ResourceRecordKey" => "30047518" "ModificationTimestamp" => "2026-07-17T15:29:25.07Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "30047518_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047518/3f1b2452fe05d7fac3be07286eccd540.webp" "MediaSize" => 137124 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047518/thumbnail-3f1b2452fe05d7fac3be07286eccd540.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Commercial building with a grey brick facade and red trim, featuring a prominent red awning and a large sign" "PreferredPhotoYN" => false "ResourceRecordId" => "40849086" "ResourceRecordKey" => "30047518" "ModificationTimestamp" => "2026-07-17T15:29:25.07Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "30047518_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047518/300a297ab61485de224b1e01a684b292.webp" "MediaSize" => 135710 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047518/thumbnail-300a297ab61485de224b1e01a684b292.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Commercial building featuring a dark gray facade with red trim and a prominent business sign" "PreferredPhotoYN" => false "ResourceRecordId" => "40849086" …2 ] 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": 1 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30047518')" +"ID": "1636717" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24681 +post_id: "1639904" +post_author: 1 +"ListingKey": "30052419" +"ListingId": "40849080" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-18T19:25:25Z" +"RFModificationTimestamp": "2026-07-18T22:51:07Z" +"ListPrice": 729900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1353.0 +"BuildingAreaTotal": 0 +"City": "Milton" +"PostalCode": "L9T0P8" +"UnparsedAddress": "656 FRANK Place, Milton, Ontario L9T0P8" +"Coordinates": array:2 [ 0 => -79.8736971 1 => 43.4925904 ] +"Latitude": 43.4925904 +"Longitude": -79.8736971 +"YearBuilt": 2008 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to this beautiful 1353 square foot freehold end-unit townhome, perfectly positioned in the highly sought-after Hawthorne Village by the Escarpment. Fronting directly onto Speyer Park, this premium location offers picturesque views, exceptional privacy, and a true community feel.Featuring 2 spacious bedrooms, a versatile den (ideal as a home office or potential 3rd bedroom), and 3 bathrooms, this home delivers a functional, stylish layout suited for modern living.The upgraded kitchen boasts granite countertops, undermount sink, mosaic backsplash, and a breakfast bar, all flowing seamlessly into the open-concept living and dining areas-an inviting space perfect for everyday living and entertaining. Step out onto your private balcony with gas BBQ hookup and enjoy serene park views year-round.Upstairs, the generous primary bedroom offers a walk-in closet and a 3-piece ensuite with a glass shower enclosure. Additional features include a bright tile-floored foyer, oak staircase, inside garage access, and abundant natural light throughout.Recent updates provide added peace of mind: Roof (2024), A/C (2019), Hot Water Heater & Water Softener-both owned (2025), and Water Filter-owned (2025).Situated within walking distance to parks, schools, shopping, and recreation, this townhome offers the perfect blend of comfort, style, and convenience. A truly move-in-ready home waiting to welcome you home. (id:62650)" +"Appliances": array:9 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" 6 => "Microwave" 7 => "Window Coverings" 8 => "Microwave Built-in" ] +"Basement": array:1 [ 0 => "None" ] +"BathroomsPartial": 1 +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-18T22:50:59.845358+00:00" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2068321" +"ListOfficeKey": "284639" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Paved driveway" 1 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-07-18T19:18:00Z" +"PhotosCount": 49 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-18T19:18:00Z" +"Stories": "3.0" +"StreetName": "FRANK" +"StreetNumber": "656" +"StreetSuffix": "Place" +"SubdivisionName": "1033 - HA Harrison" +"TaxAnnualAmount": "3329.35" +"VirtualTourURLUnbranded": "https://tourwizard.net/1baeaf66/" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:10 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30052419/656-frank-place-milton" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "Row / Townhouse" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "N/A" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 29.0 +"AboveGradeFinishedArea": 1353 +"OriginalEntryTimestamp": "2026-07-18T19:18:00.32Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Builder" +"ListAgentNationalAssociationId": "1343375" +"ListOfficeNationalAssociationId": "1344653" +"Media": array:49 [ 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] ] +"DaysOnMarket": 0 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30052419')" +"ID": "1639904" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24566 +post_id: "1634983" +post_author: 1 +"ListingKey": "30047721" +"ListingId": "40849079" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-17T19:20:04Z" +"RFModificationTimestamp": "2026-07-17T19:36:24Z" +"ListPrice": 0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2162.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L0R1P0" +"UnparsedAddress": "35 MCKIBBON Avenue, Hamilton, Ontario L0R1P0" +"Coordinates": array:2 [ 0 => -79.8117845 1 => 43.1772543 ] +"Latitude": 43.1772543 +"Longitude": -79.8117845 +"YearBuilt": 2007 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to this massive 4-level backsplit offering nearly 3,000 square feet of beautifully deisnged total living space in one of the areas most highly sought-after neighbourhoods! This impressive home boasts 4 spacious above-grade bedrooms, 3 full bathrooms, and separate large living and family rooms, making it the perfect blend of size, modern comfort, and premier location. You will fall in love with the soaring high ceilings and the seamless open-concept flow that floods the home with natural light. Step outside to a large private patio, absolutely ideal for hosting summer BBQs and entertaining family and friends. Perfectly situated in a quiet, family-friendly community, you are surrounded by great neighbours, shopping, parks, and dining, with quick highway access nearby for an effortless commute. Show with absolute confidence! (id:62650)" +"Appliances": array:5 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Dryer" 4 => "Window Coverings" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"Cooling": array:1 [ 0 => "Ductless" ] +"CreationDate": "2026-07-17T16:32:28.626350+00:00" +"Directions": "Rymal & Fletcher" +"ExteriorFeatures": array:1 [ 0 => "Brick Veneer" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2197911" +"ListOfficeKey": "294490" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Conservation/green belt" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-07-17T19:12:25Z" +"PhotosCount": 19 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-17T19:12:25Z" +"Stories": "3.0" +"StreetName": "MCKIBBON" +"StreetNumber": "35" +"StreetSuffix": "Avenue" +"SubdivisionName": "503 - Trinity" +"View": "City view" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:10 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30047721/35-mckibbon-avenue-hamilton" +"ParkingTotal": 3 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"TotalActualRent": 3500 +"ZoningDescription": "R4-173(A)" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 0 +"LeaseAmountFrequency": "Monthly" +"FrontageLengthNumeric": 33.0 +"AboveGradeFinishedArea": 2162 +"OriginalEntryTimestamp": "2026-07-17T15:48:17.26Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1446283" +"ListOfficeNationalAssociationId": "1439453" +"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": 1 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30047721')" +"ID": "1634983" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24561 +post_id: "1635544" +post_author: 1 +"ListingKey": "30048335" +"ListingId": "40849078" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-17T17:30:05Z" +"RFModificationTimestamp": "2026-07-17T17:35:34Z" +"ListPrice": 879900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1068.0 +"BuildingAreaTotal": 0 +"City": "Dundas" +"PostalCode": "L9H1P6" +"UnparsedAddress": "31 CAMERON Avenue, Dundas, Ontario L9H1P6" +"Coordinates": array:2 [ 0 => -79.9455602 1 => 43.2704814 ] +"Latitude": 43.2704814 +"Longitude": -79.9455602 +"YearBuilt": 1947 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "WELCOME TO 31 CAMERON AVENUE - a beautifully renovated bungalow on a quiet street in highly sought-after Cootes Paradise, nestled in the charming valley town of Dundas. Renovated from top to bottom, this exceptional 3-bedroom, 2-bathroom home is the definition of move-in ready. The stunning kitchen was updated in 2019 and features stainless steel appliances (2019), a new dishwasher (2025), and elegant quartz countertops. Both bathrooms were stylishly renovated in 2026, while gleaming hardwood floors were refinished in 2019. Major updates include a high-efficiency furnace (2019), washer and dryer (2019), upgraded lighting, and a renovated lower-level family room with updated electrical (2019 & 2026). Additional improvements include the main sewer line to the city (2019), waterproofing (2019), backwater valve (2019), sump pump (2019), and owned hot water tank (2021). All windows and exterior doors were replaced in 2019, with new window coverings and light fixtures added in 2026, Freshly painted throughout(2026). Step outside to enjoy the large fenced yard with deck (2019), a gorgeous shed (2019), and a new carport roof (2019). This quaint and beautifully maintained home is just steps to the Niagara Escarpment and Dundas Driving Park, with an easy walk to downtown Dundas shops, schools, and parks. Minutes to McMaster University, McMaster Hospital, conservation areas, and scenic walking trails, bus route and shopping nearby. A truly special property you'll be proud to call home - absolutely no disappointments! (id:62650)" +"Appliances": array:8 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Wine Fridge" 4 => "Stove" 5 => "Dryer" 6 => "Hood Fan" 7 => "Window Coverings" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-17T17:35:19.048501+00:00" +"Directions": "York to Cameron" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"Fencing": array:1 [ 0 => "Fence" ] +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1618283" +"ListOfficeKey": "284622" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Southern exposure" 1 => "Paved driveway" 2 => "Private Yard" ] +"PhotosChangeTimestamp": "2026-07-17T17:21:54Z" +"PhotosCount": 28 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-17T17:29:29Z" +"Stories": "1.0" +"StreetName": "CAMERON" +"StreetNumber": "31" +"StreetSuffix": "Avenue" +"SubdivisionName": "411 - Coote’s Paradise" +"TaxAnnualAmount": "4437" +"Utilities": array:4 [ 0 => "Natural Gas" 1 => "Electricity" 2 => "Cable" 3 => "Telephone" ] +"VirtualTourURLUnbranded": "https://player.vimeo.com/video/1187505658" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:10 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30048335/31-cameron-avenue-dundas" +"ParkingTotal": 5 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "R2" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 50.0 +"AboveGradeFinishedArea": 1068 +"OriginalEntryTimestamp": "2026-07-17T16:59:35Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Assessor" +"ListAgentNationalAssociationId": "1272645" +"ListOfficeNationalAssociationId": "1343471" +"Media": array:28 [ 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] ] +"DaysOnMarket": 1 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30048335')" +"ID": "1635544" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24677 +post_id: "1636234" +post_author: 1 +"ListingKey": "30048459" +"ListingId": "40849077" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-17T19:20:04Z" +"RFModificationTimestamp": "2026-07-17T19:37:21Z" +"ListPrice": 719900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.145 +"LivingArea": 1042.0 +"BuildingAreaTotal": 0 +"City": "St. George" +"PostalCode": "N0E1N0" +"UnparsedAddress": "24 EDWARD Avenue, St. George, Ontario N0E1N0" +"Coordinates": array:2 [ 0 => -80.2600075 1 => 43.2450487 ] +"Latitude": 43.2450487 +"Longitude": -80.2600075 +"YearBuilt": 1991 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 24 Edward Avenue in the charming community of St. George! This well-maintained 2+1 bedroom, 2 bathroom home offers a spacious and functional layout that's perfect for families. The bright interior features generous-sized rooms, plenty of storage throughout, and a versatile lower level with a bedroom and living area. Enjoy the convenience of an attached garage and the peace of mind that comes with a new furnace and air conditioner, both replaced in 2024. Situated in a quiet, family-friendly neighbourhood close to parks, schools, and local amenities, this is a wonderful opportunity to call St. George home. (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Water softener" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Microwave" ] +"ArchitecturalStyle": array:1 [ 0 => "Raised bungalow" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-17T19:18:19.877239+00:00" +"Directions": "Left off of Beverly Street onto Scott Street then Right onto Edward Avenue" +"ExteriorFeatures": array:1 [ 0 => "Brick Veneer" ] +"Heating": array:1 [ 0 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1525286" +"ListOfficeKey": "288925" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Paved driveway" ] +"LotSizeDimensions": "0.145" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-07-17T19:18:27Z" +"PhotosCount": 42 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-17T19:18:27Z" +"Stories": "1.0" +"StreetName": "EDWARD" +"StreetNumber": "24" +"StreetSuffix": "Avenue" +"SubdivisionName": "2110 - St. George" +"TaxAnnualAmount": "4600.88" +"Utilities": array:1 [ 0 => "Telephone" ] +"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/videos/019f6f13-8561-7258-9091-35518838a3f0?v=404" +"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/30048459/24-edward-avenue-st-george" +"ParkingTotal": 5 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R1" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 60.0 +"AboveGradeFinishedArea": 1042 +"OriginalEntryTimestamp": "2026-07-17T17:18:21.68Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1113659" +"ListOfficeNationalAssociationId": "1372539" +"Media": array:42 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] ] +"DaysOnMarket": 1 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30048459')" +"ID": "1636234" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24676 +post_id: "1637399" +post_author: 1 +"ListingKey": "30049919" +"ListingId": "40849075" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-17T20:30:03Z" +"RFModificationTimestamp": "2026-07-17T21:32:04Z" +"ListPrice": 299999.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 927.0 +"BuildingAreaTotal": 0 +"City": "Flamborough" +"PostalCode": "L0R1V0" +"UnparsedAddress": "1294 8TH CONCESSION Road W Unit# 22, Flamborough, Ontario L0R1V0" +"Coordinates": array:2 [ 0 => -80.0881304 1 => 43.3661065 ] +"Latitude": 43.3661065 +"Longitude": -80.0881304 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to Beverly Hills Estates, a sought-after community where peaceful country living meets everyday convenience! This updated & well-maintained 3-bedroom, 1-bath home offers affordable, low-maintenance living in a friendly neighbourhood surrounded by scenic rural views. Inside, you'll find a bright eat-in kitchen featuring a charming bay window that flows seamlessly into the spacious living room, creating a warm and inviting space for everyday living and entertaining. Three generously sized bedrooms and the convenience of in-suite laundry complete the functional layout. Step outside to enjoy your morning coffee on the welcoming front porch or spend summer evenings relaxing under the covered patio, an ideal space for barbecues and outdoor gatherings. With parking for two vehicles and a location that combines tranquility with accessibility, this home is an excellent choice for first-time buyers, downsizers, or anyone looking to simplify their lifestyle. Residents of Beverly Hills Estates enjoy scenic walking trails, a community recreation centre just steps away, and a welcoming atmosphere, all while being just minutes from shopping, restaurants, healthcare, and convenient access to Cambridge, Waterdown, Hamilton, Burlington, and major highways. (id:62650)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" 6 => "Window Coverings" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"AssociationFee": "850" +"AssociationFeeFrequency": "Monthly" +"Basement": array:1 [ 0 => "None" ] +"BathroomsPartial": 1 +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-17T21:31:56.219446+00:00" +"Directions": "8th Concession to Park Ln, right onto Macpherson" +"ExteriorFeatures": array:1 [ 0 => "Vinyl siding" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1524224" +"ListOfficeKey": "275989" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Conservation/green belt" 1 => "Country residential" ] +"ParkingFeatures": array:1 [ 0 => "Open" ] +"PhotosChangeTimestamp": "2026-07-17T20:29:12Z" +"PhotosCount": 26 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-17T20:29:12Z" +"Stories": "1.0" +"StreetDirSuffix": "West" +"StreetName": "8TH CONCESSION" +"StreetNumber": "1294" +"StreetSuffix": "Road" +"SubdivisionName": "045 - Beverly" +"WaterSource": array:1 [ 0 => "Community Water System" ] +"Rooms": array:8 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30049919/1294-8th-concession-road-w-unit-22-flamborough" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "Modular" ] +"CommonInterest": "Leasehold" +"GeocodeManualYN": true +"ZoningDescription": "A2, P6, P8" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 44.0 +"AboveGradeFinishedArea": 927 +"OriginalEntryTimestamp": "2026-07-17T20:18:23.38Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1064132" +"ListOfficeNationalAssociationId": "1269881" +"Media": array:26 [ 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] ] +"DaysOnMarket": 1 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30049919')" +"ID": "1637399" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24684 +post_id: "1636517" +post_author: 1 +"ListingKey": "30047975" +"ListingId": "40849074" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-17T16:35:17Z" +"RFModificationTimestamp": "2026-07-17T19:54:11Z" +"ListPrice": 0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 500.0 +"BuildingAreaTotal": 0 +"City": "Kitchener" +"PostalCode": "N2H0C7" +"UnparsedAddress": "60 FREDERICK Street Unit# 2505, Kitchener, Ontario N2H0C7" +"Coordinates": array:2 [ 0 => -80.4870316 1 => 43.4506832 ] +"Latitude": 43.4506832 +"Longitude": -80.4870316 +"YearBuilt": 2022 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to DTK Condos in the heart of downtown Kitchener. This bright and modern 1 Bedroom suite offers an excellent opportunity for first-time buyers, investors, or anyone seeking a low-maintenance urban lifestyle. Located on the 25th floor, the unit features a functional open-concept layout, floor-to-ceiling windows, contemporary finishes, quartz countertops, stainless steel appliances, and in-suite laundry. Condo fees include most utilities, including internet. Residents enjoy premium amenities such as a 24-hour concierge, fitness centre, yoga studio, party room, and rooftop terrace with BBQs. Conveniently located near transit, restaurants, shopping, and entertainment. A fantastic opportunity to own in one of downtown Kitchener’s most desirable condo communities. Book your private viewing today (id:62650)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Hood Fan" 6 => "Window Coverings" ] +"AssociationFee": "412.58" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:2 [ 0 => "Heat" 1 => "Water" ] +"Basement": array:1 [ 0 => "None" ] +"CommunityFeatures": array:1 [ 0 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-17T19:54:02.968088+00:00" +"Directions": "King Street East or Weber Street East to Frederick Street" +"ExteriorFeatures": array:1 [ 0 => "Metal" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2104178" +"ListOfficeKey": "294394" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Southern exposure" 1 => "Balcony" ] +"ParkingFeatures": array:2 [ 0 => "Underground" 1 => "None" ] +"PhotosChangeTimestamp": "2026-07-17T16:32:05Z" +"PhotosCount": 49 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-17T16:32:05Z" +"Stories": "1.0" +"StreetName": "FREDERICK" +"StreetNumber": "60" +"StreetSuffix": "Street" +"SubdivisionName": "313 - Downtown Kitchener/W. Ward" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:4 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30047975/60-frederick-street-unit-2505-kitchener" +"StructureType": array:1 [ 0 => "Apartment" ] +"CommonInterest": "Condo/Strata" +"GeocodeManualYN": true +"TotalActualRent": 1600 +"BuildingFeatures": array:2 [ 0 => "Exercise Centre" 1 => "Party Room" ] +"ZoningDescription": "D4" +"BedroomsAboveGrade": 1 +"BedroomsBelowGrade": 0 +"LeaseAmountFrequency": "Monthly" +"AboveGradeFinishedArea": 500 +"OriginalEntryTimestamp": "2026-07-17T16:29:08.23Z" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1373627" +"ListOfficeNationalAssociationId": "1438749" +"Media": array:49 [ 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] ] +"DaysOnMarket": 1 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30047975')" +"ID": "1636517" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24570 +post_id: "1635644" +post_author: 1 +"ListingKey": "30047262" +"ListingId": "40849067" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-17T14:55:22Z" +"RFModificationTimestamp": "2026-07-17T17:13:28Z" +"ListPrice": 399999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1160.0 +"BuildingAreaTotal": 0 +"City": "Kitchener" +"PostalCode": "N2M5B5" +"UnparsedAddress": "423 WESTWOOD Drive Unit# 43, Kitchener, Ontario N2M5B5" +"Coordinates": array:2 [ 0 => -80.5405456 1 => 43.4427505 ] +"Latitude": 43.4427505 +"Longitude": -80.5405456 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to this beautifully maintained condo townhouse located in Kitchener’s desirable Westwood neighbourhood. Surrounded by mature trees and quiet streets, this home offers a wonderful blend of space, comfort, and low-maintenance living. Step inside to a bright and inviting main floor featuring a spacious living area that’s perfect for both everyday living and entertaining. The eat-in kitchen offers ample cabinetry and workspace, creating a practical and welcoming hub for family meals and gatherings. A convenient 2pc powder room completes the main level. Upstairs, you’ll find well-sized bedrooms and a full bathroom. The finished lower level adds valuable flexibility with additional living space ideal for a family room, home office, or recreation area. This level also features a three-piece bathroom, laundry area, and extra storage. Enjoy the benefits of easy condo living, where exterior maintenance is taken care of, while still having your own private outdoor space to relax and unwind. Residents also enjoy access to an in-ground pool and playground, making this a great community for families and those who appreciate outdoor amenities. The location is exceptional — just minutes to The Boardwalk shopping district, parks, schools, public transit, and both universities. Commuters and investors alike will appreciate the convenience and strong rental appeal of this area. Whether you’re a first-time buyer, downsizer, or investor, Unit #43 offers outstanding value and an opportunity to own in a well-established community. Recent Updates include: Central Air (2024), Basement Finished (2023), Kitchen and Bathroom updates (2021). Condo fees include: water, 1 parking spot, pool maintenance, landscaping, snow removal, and general insurance (owners need to get their own content insurance). Pool is open May-October. 2nd parking spot is by waitlist with a monthly rental of approximately $40/month. (id:62650)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water purifier" 3 => "Water softener" 4 => "Dishwasher" 5 => "Stove" 6 => "Dryer" ] +"AssociationFee": "611.98" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:3 [ 0 => "Landscaping" 1 => "Water" 2 => "Parking" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-17T17:13:21.383471+00:00" +"Directions": "Glasgow St. to Westwood Dr." +"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": "2067711" +"ListOfficeKey": "286933" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Southern exposure" ] +"ParkingFeatures": array:2 [ 0 => "Open" 1 => "Visitor Parking" ] +"PhotosChangeTimestamp": "2026-07-17T14:48:25Z" +"PhotosCount": 41 +"PoolFeatures": array:1 [ 0 => "Inground pool" ] +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-17T14:48:25Z" +"Stories": "2.0" +"StreetName": "WESTWOOD" +"StreetNumber": "423" +"StreetSuffix": "Drive" +"SubdivisionName": "415 - Uptown Waterloo/Westmount" +"TaxAnnualAmount": "2333.95" +"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/30047262/423-westwood-drive-unit-43-kitchener" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "Row / Townhouse" ] +"CoListAgentKey": "1564408" +"CommonInterest": "Condo/Strata" +"CoListOfficeKey": "286933" +"GeocodeManualYN": true +"ZoningDescription": "R2B" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"AboveGradeFinishedArea": 1160 +"OriginalEntryTimestamp": "2026-07-17T14:48:25.12Z" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1342782" +"ListOfficeNationalAssociationId": "1364894" +"CoListAgentNationalAssociationId": "1129302" +"CoListOfficeNationalAssociationId": "1364894" +"Media": array:41 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] ] +"DaysOnMarket": 1 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30047262')" +"ID": "1635644" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24611 +post_id: "1639202" +post_author: 1 +"ListingKey": "30051043" +"ListingId": "40849066" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-18T01:00:00Z" +"RFModificationTimestamp": "2026-07-18T01:05:08Z" +"ListPrice": 1149900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 1.0 +"LivingArea": 2922.0 +"BuildingAreaTotal": 0 +"City": "Brantford" +"PostalCode": "N3R0C1" +"UnparsedAddress": "70 RIVER Road, Brantford, Ontario N3R0C1" +"Coordinates": array:2 [ 0 => -80.2395717 1 => 43.091155 ] +"Latitude": 43.091155 +"Longitude": -80.2395717 +"YearBuilt": 1964 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc" +"PublicRemarks": "Welcome home to 70 River Road, Brantford. Towards the end of a quiet road enjoy farm fields across from you and stunning views out back! Nearly 200 ft of frontage on a mature 1 acre lot find a sprawling brick ranch. With many upgrades in the last few years this home is perfect for a family offering 4+1 beds and 3 full baths. Entertain friends and family with many sitting areas out back to enjoy the views, stay cozy by the gas fire table or wood burning fire pit, and there’s parking for 8+ vehicles in your driveway. Recent upgrades include all new ductwork, gas forced air furnace and AC (2022), new septic (2023), windows on main level and doors (2017/18) concrete poured in backyard (2023-2026), refinished basement with all new windows and doors and floors (2026), main level bathroom, basement bath, and ensuite to primary (2026), outdoor bar (2025), new 100 amp hydro (2026), new kitchen floors, counters, backsplash and cabinets (2026). Hike on down to the Grand River, less than 1 km away to enjoy the outdoor nature and don't forget your fishing pole! Don't miss your opportunity to live in the country, just move in and enjoy! (id:62650)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Window Coverings" 6 => "Garage door opener" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-18T00:54:41.178260+00:00" +"Directions": "Cockshutt Road to Newport Road" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"Fencing": array:1 [ 0 => "Fence" ] +"FireplaceFeatures": array:2 [ 0 => "Wood" 1 => "Other - See remarks" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1964570" +"ListOfficeKey": "289711" +"LivingAreaUnits": "square feet" +"LotFeatures": array:4 [ 0 => "Backs on greenbelt" 1 => "Paved driveway" 2 => "Country residential" 3 => "Sump Pump" ] +"LotSizeDimensions": "1" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-07-18T00:51:18Z" +"PhotosCount": 38 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-18T00:51:18Z" +"Stories": "1.0" +"StreetName": "RIVER" +"StreetNumber": "70" +"StreetSuffix": "Road" +"SubdivisionName": "2121 - SW Rural" +"TaxAnnualAmount": "4597.62" +"Utilities": array:3 [ 0 => "Electricity" 1 => "Cable" 2 => "Telephone" ] +"WaterSource": array:1 [ 0 => "Dug Well" ] +"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": "Brantford" +"ListAORKey": "41" +"ListingURL": "www.realtor.ca/real-estate/30051043/70-river-road-brantford" +"ParkingTotal": 10 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "RU" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 193.0 +"AboveGradeFinishedArea": 1462 +"BelowGradeFinishedArea": 1460 +"OriginalEntryTimestamp": "2026-07-17T23:43:27.83Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1253211" +"ListOfficeNationalAssociationId": "1380321" +"Media": array:38 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] ] +"DaysOnMarket": 1 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30051043')" +"ID": "1639202" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24562 +post_id: "1635314" +post_author: 1 +"ListingKey": "30047723" +"ListingId": "40849060" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-17T15:55:26Z" +"RFModificationTimestamp": "2026-07-17T16:46:32Z" +"ListPrice": 725000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1210.0 +"BuildingAreaTotal": 0 +"City": "Halton" +"PostalCode": "L7M3Z7" +"UnparsedAddress": "2935 HEADON FOREST Drive Unit# 17, Halton, Ontario L7M3Z7" +"Coordinates": array:2 [ 0 => -79.8228063 1 => 43.387883 ] +"Latitude": 43.387883 +"Longitude": -79.8228063 +"YearBuilt": 1992 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to this beautifully maintained all-brick, two-storey townhouse in the desirable Ashburn complex in Burlington's sought-after Headon Forest community. Offering approximately 1,210 sq.ft. plus a finished basement, this move-in ready home is perfect for first-time buyers, families, or downsizers seeking low-maintenance living. The bright eat-in kitchen overlooks the front yard and offers ample cabinetry. The open-concept living and dining room features a cozy gas fireplace and a walk-out to a spacious two-tier deck overlooking a fully fenced, gated backyard backing onto a playground. Upstairs offers a full 4 piece bathroom, 3 generously sized bedrooms, including a primary bedroom with a walk-in closet and 3 piece ensuite. The finished basement features a bright recreation room with above-grade windows, plus a laundry and utility area. Additional features include 2.5 bathrooms, a single-car garage with private driveway, and excellent natural light throughout. Ideally located just a short walk to Longo's, LCBO, restaurants, medical facilities, parks, schools, and everyday amenities. An exceptional opportunity to own a well-maintained home in one of Burlington's most desirable communities. (id:62650)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Hood Fan" 6 => "Window Coverings" ] +"AssociationFee": "458.6" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:3 [ 0 => "Landscaping" 1 => "Property Management" 2 => "Insurance" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"BathroomsPartial": 1 +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-17T16:46:14.803450+00:00" +"Directions": "Walkers Line and Dundas" +"ExteriorFeatures": array:1 [ 0 => "Brick Veneer" ] +"FireplaceFeatures": array:1 [ 0 => "Insert" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:1 [ 0 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1952091" +"ListOfficeKey": "78242" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Paved driveway" 1 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-07-17T15:48:17Z" +"PhotosCount": 43 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-17T15:48:17Z" +"Stories": "2.0" +"StreetName": "HEADON FOREST" +"StreetNumber": "2935" +"StreetSuffix": "Drive" +"SubdivisionName": "350 - Headon Forest" +"TaxAnnualAmount": "3624.55" +"VirtualTourURLUnbranded": "https://mediatours.ca/property/17-2935-headon-forest-drive-burlington/" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:10 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/30047723/2935-headon-forest-drive-unit-17-halton" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "Row / Townhouse" ] +"CommonInterest": "Condo/Strata" +"GeocodeManualYN": true +"ZoningDescription": "RM2" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"AboveGradeFinishedArea": 1210 +"OriginalEntryTimestamp": "2026-07-17T15:48:17.41Z" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1303142" +"ListOfficeNationalAssociationId": "1137129" +"Media": array:43 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] ] +"DaysOnMarket": 1 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30047723')" +"ID": "1635314" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24568 +post_id: "1635873" +post_author: 1 +"ListingKey": "30048998" +"ListingId": "40849058" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-17T18:35:12Z" +"RFModificationTimestamp": "2026-07-17T18:45:05Z" +"ListPrice": 479000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 842.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8L2S4" +"UnparsedAddress": "66 BEECHWOOD Avenue, Hamilton, Ontario L8L2S4" +"Coordinates": array:2 [ 0 => -79.8343571 1 => 43.2542798 ] +"Latitude": 43.2542798 +"Longitude": -79.8343571 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "The Beechwood Bungalow - where cozy charm meets unforgettable outdoor living! Welcome to 66 Beechwood Ave - a thoughtfully updated 3-bedroom bungalow that's warm, welcoming, and move-in ready. Tastefully renovated over the years with modern finishes, including an updated kitchen, a newly renovated bathroom, and updated flooring throughout - this home offers comfortable, easy living that's ready to enjoy from day one. The real hidden gem of this property though – the backyard! Set on a fully fenced 100-foot deep lot, this outdoor space is ready to become your favourite place to spend time. Whether you're hosting family and friends, firing up the BBQ, watching the game on the mounted outdoor TV, gathering for dinner under the covered patio, looking for space to let kids or pets run around, or simply enjoying a quiet evening outdoors, this backyard offers the perfect setting to relax, entertain, and make lasting memories all season long. Located in Hamilton's Stipley neighbourhood, you'll enjoy easy access to schools, parks, shopping, transit, and everyday amenities, with quick connections to the Red Hill Valley Parkway and the QEW. You're also just minutes from Centre on Barton, Confederation Park, and Hamilton's waterfront, giving you plenty of opportunities to shop, explore, and enjoy the outdoors. Whether you're searching for your first home, looking to simplify with one-floor living, needing more outdoor space, or seeking an investment opportunity, this home offers exceptional value and versatility. Along with its thoughtful updates and incredible backyard, the property presents exciting potential for future basement development, including the possibility of creating a full-height lower level with a separate entrance. It's a home you can enjoy today while exploring the possibilities for tomorrow. (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Gas stove(s)" 3 => "Dryer" 4 => "Microwave" 5 => "Hood Fan" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-17T18:44:55.667146+00:00" +"Directions": "Sherman Ave N to Beechwood Ave" +"ExteriorFeatures": array:2 [ 0 => "Aluminum siding" 1 => "Vinyl siding" ] +"Fencing": array:1 [ 0 => "Fence" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2083025" +"ListOfficeKey": "288925" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Sump Pump" ] +"ParkingFeatures": array:1 [ 0 => "None" ] +"PhotosChangeTimestamp": "2026-07-17T18:29:18Z" +"PhotosCount": 50 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-17T18:29:18Z" +"Stories": "1.0" +"StreetName": "BEECHWOOD" +"StreetNumber": "66" +"StreetSuffix": "Avenue" +"SubdivisionName": "200 - Gibson/Stipley" +"TaxAnnualAmount": "2803.03" +"VirtualTourURLUnbranded": "https://sites.nomorecowboys.media/66beechwoodavenue" +"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/30048998/66-beechwood-avenue-hamilton" +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "C" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 30.0 +"AboveGradeFinishedArea": 842 +"OriginalEntryTimestamp": "2026-07-17T18:29:18.35Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1358356" +"ListOfficeNationalAssociationId": "1372539" +"Media": array:50 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] 44 => array:13 [ …13] 45 => array:13 [ …13] 46 => array:13 [ …13] 47 => array:13 [ …13] 48 => array:13 [ …13] 49 => array:13 [ …13] ] +"DaysOnMarket": 1 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30048998')" +"ID": "1635873" } ] +success: true +page_size: 12 +page_count: 19206 +count: 230466 +after_key: "" } "RF Response Time" => "0.24 seconds" ] ]