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=150720&$filter=(PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24577 +items: array:12 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24658 +post_id: "1564153" +post_author: 1 +"ListingKey": "29949074" +"ListingId": "40842809" +"PropertyType": "Commercial Sale" +"PropertySubType": "Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-24T21:20:13Z" +"RFModificationTimestamp": "2026-06-25T23:48:21Z" +"ListPrice": 4999500.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 16000.0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2V2N3" +"UnparsedAddress": "617 KING Street N, Waterloo, Ontario N2V2N3" +"Coordinates": array:2 [ 0 => -80.5365104 1 => 43.5033778 ] +"Latitude": 43.5033778 +"Longitude": -80.5365104 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "VTB possible. Beautiful Banquet Hall approx. 15,500 sf building sitting on Approx. 1.50 acres with 4 halls (no kitchen/restaurant, but space available to add). Banquet Hall fully renovated last year. 75+ parking spaces. Banquet hall rooms renting on daily base and upcoming bookings already reserved. Site an also be looked at as a redevelopment as it’s located in one of the most vibrant nodes of the region. Prime location with very large frontage on the main road and 3 entrances from main road. Large residential unit on second floor with separate entrance (can easily become 3 res units), 5 rooms, 2.5 bathrooms and kitchen with large dinning/lounge area. 1KM from highway 85. Located 500m down the street form Conestoga Mall and surrounded by all major retailers, hotels and big-box stores. VTB available up to 65% with flexible open terms. C5-81 Zoning allows most all retail uses if the current use is not of use to you. Current owner is retiring. MANY USES ARE POSSIBLE HERE. EVERYTHING FROM HOTEL TO COMMERCIAL SCHOOL AND FUNERAL HOME (AND MANY IN-BETWEEN) (id:62650)" +"Basement": array:1 [ 0 => "None" ] +"BuildingAreaUnits": "square feet" +"CommunityFeatures": array:1 [ 0 => "High Traffic Area" ] +"CreationDate": "2026-06-25T23:47:29.654497+00:00" +"Directions": "CONESTOGA PARKWAY" +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1750682" +"ListOfficeKey": "289792" +"LivingAreaUnits": "square feet" +"PhotosChangeTimestamp": "2026-06-24T21:11:16Z" +"PhotosCount": 24 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-24T21:11:16Z" +"Stories": "1.0" +"StreetDirSuffix": "North" +"StreetName": "KING" +"StreetNumber": "617" +"StreetSuffix": "Street" +"SubdivisionName": "118 - Colonial Acres/East Bridge" +"TaxAnnualAmount": "79000" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29949074/617-king-street-n-waterloo" +"StructureType": array:1 [ 0 => "Retail" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "C5-81" +"FrontageLengthNumeric": 224.0 +"OriginalEntryTimestamp": "2026-06-24T21:11:16.09Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1164848" +"ListOfficeNationalAssociationId": "1381240" +"Media": array:24 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "29949074_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/db5b5d1651dc53c3762e2d0b4dcca24e.webp" "MediaSize" => 86930 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-db5b5d1651dc53c3762e2d0b4dcca24e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "29949074_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/8ef488cd43d203d5639df4b73b63fe3c.webp" "MediaSize" => 92392 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-8ef488cd43d203d5639df4b73b63fe3c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "29949074_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/0c0023e75c1f31a75f30aec8d5805845.webp" "MediaSize" => 90242 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-0c0023e75c1f31a75f30aec8d5805845.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "29949074_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/47cc7628b329d22afbae72bf524a65d5.webp" "MediaSize" => 89130 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-47cc7628b329d22afbae72bf524a65d5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "29949074_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/2d09742b08c781faa674dfc6a37b2e72.webp" "MediaSize" => 118989 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-2d09742b08c781faa674dfc6a37b2e72.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "29949074_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/7c12272777f7eb07d63c0aa264c4f446.webp" "MediaSize" => 130009 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-7c12272777f7eb07d63c0aa264c4f446.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "29949074_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/f2f6289c534b384566c4d9264547c9e3.webp" "MediaSize" => 91325 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-f2f6289c534b384566c4d9264547c9e3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "29949074_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/ae0e02e9b377d6ecff7b97f1010c0451.webp" "MediaSize" => 85363 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-ae0e02e9b377d6ecff7b97f1010c0451.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "29949074_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/156d0afdc43dea40558f54aab986f4a4.webp" "MediaSize" => 95785 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-156d0afdc43dea40558f54aab986f4a4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "29949074_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/a57cb711182bfef00b0ad41941bb59e3.webp" "MediaSize" => 88981 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-a57cb711182bfef00b0ad41941bb59e3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "29949074_4890_11" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/0e477038ee5318590ee39eb8318b3283.webp" "MediaSize" => 87761 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-0e477038ee5318590ee39eb8318b3283.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "29949074_4890_12" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/3219135a2616313ac23f5bb67e0dc0ab.webp" "MediaSize" => 87095 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-3219135a2616313ac23f5bb67e0dc0ab.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "29949074_4890_13" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/1e722472cc7e14f8e92cabf12fded47d.webp" "MediaSize" => 82170 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-1e722472cc7e14f8e92cabf12fded47d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 13 => array:13 [ "Order" => 14 "MediaKey" => "29949074_4890_14" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/0411fc26fa17e6ddeb5e1dac9198fde2.webp" "MediaSize" => 71369 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-0411fc26fa17e6ddeb5e1dac9198fde2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 14 => array:13 [ "Order" => 15 "MediaKey" => "29949074_4890_15" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/e424ad710ca370f486f1671384289540.webp" "MediaSize" => 99978 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-e424ad710ca370f486f1671384289540.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 15 => array:13 [ "Order" => 16 "MediaKey" => "29949074_4890_16" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/1500951948d3b8b41432f847073ad070.webp" "MediaSize" => 92035 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-1500951948d3b8b41432f847073ad070.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 16 => array:13 [ "Order" => 17 "MediaKey" => "29949074_4890_17" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/626046315fc49af3ee77c2e26eca04d3.webp" "MediaSize" => 71535 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-626046315fc49af3ee77c2e26eca04d3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 17 => array:13 [ "Order" => 18 "MediaKey" => "29949074_4890_18" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/32c08d600c050e333d068b9afb11fc8d.webp" "MediaSize" => 100857 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-32c08d600c050e333d068b9afb11fc8d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 18 => array:13 [ "Order" => 19 "MediaKey" => "29949074_4890_19" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/c85382b72c905500916dc87bb334936c.webp" "MediaSize" => 96778 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-c85382b72c905500916dc87bb334936c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 19 => array:13 [ "Order" => 20 "MediaKey" => "29949074_4890_20" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/10820ae01d01dac90356f7ca3f6cf9e5.webp" "MediaSize" => 95667 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-10820ae01d01dac90356f7ca3f6cf9e5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 20 => array:13 [ "Order" => 21 "MediaKey" => "29949074_4890_21" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/9059490544a46a7ab7e9d74b86dfa5a5.webp" "MediaSize" => 96659 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-9059490544a46a7ab7e9d74b86dfa5a5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 21 => array:13 [ "Order" => 22 "MediaKey" => "29949074_4890_22" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/2e52104fbcc364aeb9b87d07d04ce4e6.webp" "MediaSize" => 88432 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-2e52104fbcc364aeb9b87d07d04ce4e6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 22 => array:13 [ "Order" => 23 "MediaKey" => "29949074_4890_23" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/fe928e3d4be91234ff919faa2d202cdc.webp" "MediaSize" => 75228 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-fe928e3d4be91234ff919faa2d202cdc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] 23 => array:13 [ "Order" => 24 "MediaKey" => "29949074_4890_24" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949074/3169b537bd65a9a3664db40f39532d77.webp" "MediaSize" => 83681 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949074/thumbnail-3169b537bd65a9a3664db40f39532d77.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842809" "ResourceRecordKey" => "29949074" "ModificationTimestamp" => "2026-06-24T21:11:16.11Z" ] ] +"DaysOnMarket": 7 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29949074')" +"ID": "1564153" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24505 +post_id: "1569402" +post_author: 1 +"ListingKey": "29957379" +"ListingId": "40842808" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-26T20:40:04Z" +"RFModificationTimestamp": "2026-06-26T20:41:14Z" +"ListPrice": 889900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 4060.0 +"BuildingAreaTotal": 0 +"City": "Shelburne" +"PostalCode": "L9V3S2" +"UnparsedAddress": "639 HAMMOND Street, Shelburne, Ontario L9V3S2" +"Coordinates": array:2 [ 0 => -80.1929545 1 => 44.0879454 ] +"Latitude": 44.0879454 +"Longitude": -80.1929545 +"YearBuilt": 2015 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to this spacious 4-bedroom, 3.5-bathroom family home, ideally located in one of Shelburne's growing communities. Offering a functional floor plan and endless potential, this home is the perfect canvas to make your own. The main level features a bright eat-in kitchen, formal dining room, dedicated home office, and a sun-filled living room designed for everyday living and entertaining. Upstairs, you'll find four generously sized bedrooms, three full bathrooms, and a versatile bonus family room—ideal as a playroom, media space, or additional lounge for growing families. Step outside to enjoy the fully fenced backyard, offering plenty of space for kids and pets to play, summer barbecues, or simply relaxing outdoors. With an abundance of living space both inside and out, this home offers an incredible opportunity to settle into a welcoming neighbourhood and create lasting memories for years to come. (id:62650)" +"Appliances": array:4 [ 0 => "Refrigerator" 1 => "Dishwasher" 2 => "Stove" 3 => "Microwave" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"BathroomsPartial": 1 +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-26T17:08:16.551591+00:00" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"Fencing": array:1 [ 0 => "Fence" ] +"FireplaceFeatures": array:2 [ 0 => "Electric" 1 => "Other - See remarks" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2030361" +"ListOfficeKey": "86262" +"LivingAreaUnits": "square feet" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-06-26T14:40:48Z" +"PhotosCount": 48 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-26T20:32:05Z" +"Stories": "2.0" +"StreetName": "HAMMOND" +"StreetNumber": "639" +"StreetSuffix": "Street" +"SubdivisionName": "Shelburne" +"TaxAnnualAmount": "6733" +"VirtualTourURLUnbranded": "https://youtube.com/shorts/PrjzHuLaXSE" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:17 [ 0 => array:11 [ "RoomKey" => "1668830041" "RoomType" => "5pc Bathroom" "ListingId" => "40842808" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29957379" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T20:32:05.96Z" ] 1 => array:11 [ "RoomKey" => "1668830042" "RoomType" => "Bedroom" "ListingId" => "40842808" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29957379" "RoomLength" => null "RoomDimensions" => "13'11'' x 12'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T20:32:05.96Z" ] 2 => array:11 [ "RoomKey" => "1668830043" "RoomType" => "4pc Bathroom" "ListingId" => "40842808" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29957379" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T20:32:05.97Z" ] 3 => array:11 [ "RoomKey" => "1668830044" "RoomType" => "Bedroom" "ListingId" => "40842808" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29957379" "RoomLength" => null "RoomDimensions" => "10'4'' x 12'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T20:32:05.97Z" ] 4 => array:11 [ "RoomKey" => "1668830045" "RoomType" => "Laundry room" "ListingId" => "40842808" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29957379" "RoomLength" => null "RoomDimensions" => "12'4'' x 5'3''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T20:32:05.97Z" ] 5 => array:11 [ "RoomKey" => "1668830046" "RoomType" => "Bonus Room" "ListingId" => "40842808" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29957379" "RoomLength" => null "RoomDimensions" => "10'7'' x 11'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T20:32:05.97Z" ] 6 => array:11 [ "RoomKey" => "1668830047" "RoomType" => "Bedroom" "ListingId" => "40842808" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29957379" "RoomLength" => null "RoomDimensions" => "11'11'' x 13'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T20:32:05.97Z" ] 7 => array:11 [ "RoomKey" => "1668830048" "RoomType" => "Full bathroom" "ListingId" => "40842808" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29957379" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T20:32:05.97Z" ] 8 => array:11 [ "RoomKey" => "1668830049" "RoomType" => "Primary Bedroom" "ListingId" => "40842808" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29957379" "RoomLength" => null "RoomDimensions" => "17'7'' x 16'11''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T20:32:05.97Z" ] 9 => array:11 [ "RoomKey" => "1668830050" "RoomType" => "Office" "ListingId" => "40842808" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29957379" "RoomLength" => null "RoomDimensions" => "11'7'' x 12'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T20:32:05.97Z" ] 10 => array:11 [ "RoomKey" => "1668830051" "RoomType" => "2pc Bathroom" "ListingId" => "40842808" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29957379" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T20:32:05.97Z" ] 11 => array:11 [ "RoomKey" => "1668830052" "RoomType" => "Dining room" "ListingId" => "40842808" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29957379" "RoomLength" => null "RoomDimensions" => "13'7'' x 12'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T20:32:05.97Z" ] 12 => array:11 [ "RoomKey" => "1668830053" "RoomType" => "Kitchen" "ListingId" => "40842808" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29957379" "RoomLength" => null "RoomDimensions" => "9'4'' x 12'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T20:32:05.97Z" ] 13 => array:11 [ "RoomKey" => "1668830054" "RoomType" => "Breakfast" "ListingId" => "40842808" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29957379" "RoomLength" => null "RoomDimensions" => "9'1'' x 12'7''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T20:32:05.97Z" ] 14 => array:11 [ "RoomKey" => "1668830055" "RoomType" => "Living room" "ListingId" => "40842808" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29957379" "RoomLength" => null "RoomDimensions" => "14'8'' x 17'3''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T20:32:05.98Z" ] 15 => array:11 [ "RoomKey" => "1668830056" "RoomType" => "Storage" "ListingId" => "40842808" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29957379" "RoomLength" => null "RoomDimensions" => "15'11'' x 11'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T20:32:05.98Z" ] 16 => array:11 [ "RoomKey" => "1668830057" "RoomType" => "Other" "ListingId" => "40842808" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29957379" "RoomLength" => null "RoomDimensions" => "36'10'' x 29'11''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-26T20:32:05.98Z" ] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29957379/639-hammond-street-shelburne" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "1876026" +"CommonInterest": "Freehold" +"CoListOfficeKey": "86262" +"GeocodeManualYN": true +"ZoningDescription": "R3" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 40.0 +"AboveGradeFinishedArea": 2940 +"BelowGradeFinishedArea": 1120 +"OriginalEntryTimestamp": "2026-06-26T14:40:47.39Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"BelowGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1307977" +"ListOfficeNationalAssociationId": "1004415" +"CoListAgentNationalAssociationId": "1204241" +"CoListOfficeNationalAssociationId": "1004415" +"Media": array:48 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "29957379_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957379/679ac0b45f9129ca4b9ba7fb6544536e.webp" "MediaSize" => 103955 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957379/thumbnail-679ac0b45f9129ca4b9ba7fb6544536e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "40842808" "ResourceRecordKey" => "29957379" "ModificationTimestamp" => "2026-06-26T14:40:47.41Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "29957379_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957379/988c84f9140808ed6c5979a939800843.webp" "MediaSize" => 130912 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957379/thumbnail-988c84f9140808ed6c5979a939800843.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842808" "ResourceRecordKey" => "29957379" "ModificationTimestamp" => "2026-06-26T14:40:47.41Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "29957379_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957379/b5428fa10080cf2c291c27a1acebdf2f.webp" "MediaSize" => 119839 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957379/thumbnail-b5428fa10080cf2c291c27a1acebdf2f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842808" "ResourceRecordKey" => "29957379" "ModificationTimestamp" => "2026-06-26T14:40:47.41Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "29957379_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957379/dd9b2af66f658cc36003956c8383f3b2.webp" "MediaSize" => 116118 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957379/thumbnail-dd9b2af66f658cc36003956c8383f3b2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842808" "ResourceRecordKey" => "29957379" "ModificationTimestamp" => "2026-06-26T14:40:47.41Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "29957379_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957379/eb895fd4a8ea4223e9592e98088ea3fe.webp" "MediaSize" => 123046 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957379/thumbnail-eb895fd4a8ea4223e9592e98088ea3fe.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842808" "ResourceRecordKey" => "29957379" "ModificationTimestamp" => "2026-06-26T14:40:47.41Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "29957379_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957379/859d1b5724c86b1afe87236d1871a5f7.webp" "MediaSize" => 61323 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957379/thumbnail-859d1b5724c86b1afe87236d1871a5f7.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842808" "ResourceRecordKey" => "29957379" "ModificationTimestamp" => "2026-06-26T14:40:47.41Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "29957379_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957379/e0723d4da6dfbbf215231380ab139f3b.webp" "MediaSize" => 42626 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957379/thumbnail-e0723d4da6dfbbf215231380ab139f3b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842808" "ResourceRecordKey" => "29957379" "ModificationTimestamp" => "2026-06-26T14:40:47.41Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "29957379_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957379/26705abc4b75c2f7af0a739f3e163567.webp" "MediaSize" => 59003 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957379/thumbnail-26705abc4b75c2f7af0a739f3e163567.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842808" "ResourceRecordKey" => "29957379" "ModificationTimestamp" => "2026-06-26T14:40:47.41Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "29957379_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957379/030a250873b9b4c698867a40aca4eb71.webp" "MediaSize" => 60570 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957379/thumbnail-030a250873b9b4c698867a40aca4eb71.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842808" "ResourceRecordKey" => "29957379" "ModificationTimestamp" => "2026-06-26T14:40:47.41Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "29957379_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957379/e0e676d892a3ef538be0fef5283d1e3c.webp" "MediaSize" => 63985 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957379/thumbnail-e0e676d892a3ef538be0fef5283d1e3c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842808" "ResourceRecordKey" => "29957379" "ModificationTimestamp" => "2026-06-26T14:40:47.41Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "29957379_4890_11" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957379/6982a16f5aa39e5609b2b54e493cc0b5.webp" "MediaSize" => 56176 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957379/thumbnail-6982a16f5aa39e5609b2b54e493cc0b5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842808" "ResourceRecordKey" => "29957379" "ModificationTimestamp" => "2026-06-26T14:40:47.41Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "29957379_4890_12" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957379/2c8fb34b6084afdfc7900fb6aa41ea98.webp" "MediaSize" => 53972 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957379/thumbnail-2c8fb34b6084afdfc7900fb6aa41ea98.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40842808" "ResourceRecordKey" => "29957379" "ModificationTimestamp" => "2026-06-26T14:40:47.41Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "29957379_4890_13" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957379/875550489e2c9262cafb428260153bd2.webp" "MediaSize" => 66960 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957379/thumbnail-875550489e2c9262cafb428260153bd2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false …3 ] 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] ] +"DaysOnMarket": 5 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29957379')" +"ID": "1569402" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24646 +post_id: "1562006" +post_author: 1 +"ListingKey": "29951783" +"ListingId": "40842806" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-28T20:20:24Z" +"RFModificationTimestamp": "2026-06-28T20:24:54Z" +"ListPrice": 825000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1890.0 +"BuildingAreaTotal": 0 +"City": "Beamsville" +"PostalCode": "L3J0B2" +"UnparsedAddress": "4512 CEDARBROOK Lane, Beamsville, Ontario L3J0B2" +"Coordinates": array:2 [ 0 => -79.4798592 1 => 43.1764019 ] +"Latitude": 43.1764019 +"Longitude": -79.4798592 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 4512 Cedarbrook Lane, a beautifully updated home situated on a peaceful, mature tree lined street in one of Beamsville's most charming neighbourhoods. The kind of street where you feel at ease the moment you turn onto it. Inside, thoughtful updates are evident throughout, including stunning hickory engineered hardwood floors and soaring vaulted ceilings that add a real sense of warmth and grandeur to the living spaces. A bonus additional room has been cleverly transformed into a welcoming living space, giving you that extra flexibility that so many buyers are looking for. Whether it becomes a home office, playroom or cozy retreat, the possibilities are yours to make. Step outside onto your brand new deck and into a large, fully fenced west facing yard that bathes in beautiful afternoon sun, perfect for entertaining, relaxing or simply unwinding at the end of the day. A detached shed adds even more practicality, offering plenty of extra storage or workspace to suit your needs. The finished basement rounds out the package beautifully, providing additional living space that the whole family can enjoy year round. As for location, you truly could not ask for more. Parks, amenities and a nearby plaza are all within easy reach, and the newly revitalized Downtown Beamsville is just moments away, bringing wonderful dining, shopping and community energy right to your doorstep. 4512 Cedarbrook Lane is a home that offers comfort, space and a lifestyle that is hard to beat. Come and experience it for yourself. (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Microwave Built-in" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-25T19:43:55.104587+00:00" +"Directions": "Greenlane to Cedarbrook" +"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": "1981716" +"ListOfficeKey": "299866" +"LivingAreaUnits": "square feet" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-06-25T15:50:46Z" +"PhotosCount": 44 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-28T20:10:43Z" +"Stories": "2.0" +"StreetName": "CEDARBROOK" +"StreetNumber": "4512" +"StreetSuffix": "Lane" +"SubdivisionName": "982 - Beamsville" +"TaxAnnualAmount": "4889.92" +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=LzGSU8QcY2a" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:13 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29951783/4512-cedarbrook-lane-beamsville" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "2227788" +"CommonInterest": "Freehold" +"CoListOfficeKey": "299866" +"GeocodeManualYN": true +"ZoningDescription": "R3-3" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 47.0 +"AboveGradeFinishedArea": 1430 +"BelowGradeFinishedArea": 460 +"OriginalEntryTimestamp": "2026-06-25T15:50:45.84Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1267128" +"ListOfficeNationalAssociationId": "1477944" +"CoListAgentNationalAssociationId": "1470633" +"CoListOfficeNationalAssociationId": "1477944" +"Media": array:44 [ 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] ] +"DaysOnMarket": 6 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29951783')" +"ID": "1562006" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24531 +post_id: "1562458" +post_author: 1 +"ListingKey": "29952772" +"ListingId": "40842803" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-29T17:00:10Z" +"RFModificationTimestamp": "2026-06-29T17:03:44Z" +"ListPrice": 529900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1848.0 +"BuildingAreaTotal": 0 +"City": "Brantford" +"PostalCode": "N3S1B7" +"UnparsedAddress": "101 SEVENTH Avenue, Brantford, Ontario N3S1B7" +"Coordinates": array:2 [ 0 => -80.2473086 1 => 43.1220329 ] +"Latitude": 43.1220329 +"Longitude": -80.2473086 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc" +"PublicRemarks": "A quiet street in Eagle Place, amongst lovingly maintained homes, is this property you don't want to miss! Updated throughout this home is truly move in ready. Too many updates to list them all but short of possibly making an in-law suite in the basement, this home has family living written all over it. Large living room that could hold both the living room furniture and a kitchen table or the current set up of an eat-in kitchen also works. Good size bedrooms plus a 4 pc bath complete the main floor. The basement has another bathroom, laundry, mechanical room, large rec room with fireplace, storage and a bedroom. The open yard is the perfect grassy playground for kids and pets. Pick a closing date and move in...its just that simple with this one. (id:62650)" +"Appliances": array:5 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Stove" 3 => "Dryer" 4 => "Microwave Built-in" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-25T20:17:57.947447+00:00" +"Directions": "Erie Ave to Ninth Ave, right on Whitehead and left on Seventh Ave, property will be on your left." +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"Fencing": array:1 [ 0 => "Fence" ] +"FireplaceFeatures": array:1 [ 0 => "Roughed in" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1812552" +"ListOfficeKey": "48880" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Southern exposure" ] +"PhotosChangeTimestamp": "2026-06-26T13:24:54Z" +"PhotosCount": 37 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-29T16:55:10Z" +"Stories": "1.0" +"StreetName": "SEVENTH" +"StreetNumber": "101" +"StreetSuffix": "Avenue" +"SubdivisionName": "2086 - Eagle Place East" +"TaxAnnualAmount": "3269.97" +"VirtualTourURLUnbranded": "https://youriguide.com/101_seventh_ave_brantford_on/" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:10 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] ] +"ListAOR": "Brantford" +"ListAORKey": "41" +"ListingURL": "www.realtor.ca/real-estate/29952772/101-seventh-avenue-brantford" +"ParkingTotal": 3 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "F-R1C" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 47.0 +"AboveGradeFinishedArea": 951 +"BelowGradeFinishedArea": 897 +"OriginalEntryTimestamp": "2026-06-25T17:55:44.59Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1192128" +"ListOfficeNationalAssociationId": "1001342" +"Media": array:37 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] ] +"DaysOnMarket": 6 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29952772')" +"ID": "1562458" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24526 +post_id: "1561024" +post_author: 1 +"ListingKey": "29948728" +"ListingId": "40842800" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-26T18:20:06Z" +"RFModificationTimestamp": "2026-06-26T18:22:31Z" +"ListPrice": 859900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 1850.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9A1A7" +"UnparsedAddress": "135 ALPINE Avenue, Hamilton, Ontario L9A1A7" +"Coordinates": array:2 [ 0 => -79.854072 1 => 43.2424866 ] +"Latitude": 43.2424866 +"Longitude": -79.854072 +"YearBuilt": 1910 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Home Sweet Home, this is an exceptional 2.5 story brick Century home located in a premium mountain brow neighborhood and offering character and charm with a contemporary style and many modern updates and features such as 5 bedrooms, 2.5 baths and a double concrete front drive. From the large front porch with underneath storage to the rear fenced gardens this property has so much to offer. The main floor features an open concept floor plan, engineered hardwood flooring, a large living room with a gas fireplace, separate dining area, a spacious functional kitchen a convenient 2-piece bath and a separate master bedroom with a walk-in closet and ensuite. The second floor offers 3 good sized bedrooms a separate laundry room a cozy den and a 3-piece bath. The third-floor bonus room is bright and airy and ideal for a bedroom or office use with wrap around eaves storage a skylight and separate heating and cooling with a heat pump. The basement offers a workshop/utility room and studio or craft room plus more storage. The backyard is a private fenced oasis in the city, with space to entertain and offering various private sitting areas, a calming pond, upper and lower decks a separate patio area with a hot tub, fruit trees, grapes and assorted berry plants and plus the unique bonus storage under the master bedroom addition that is heated and cooled. Most major services have been updated, and all the appliances are included. Located only minutes to many local amenities, the vibrant concession street village with its assortment of shops, cafes and retail opportunities, local trails, Wentworth stairs, parks, schools, the Linc and the City center. Don’t miss the opportunity to own this well maintained and updated move in ready home with exceptional curb appeal. (id:62650)" +"Appliances": array:8 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water meter" 3 => "Hot Tub" 4 => "Gas stove(s)" 5 => "Dishwasher" 6 => "Dryer" 7 => "Microwave Built-in" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-25T18:07:40.828930+00:00" +"Directions": "North of Concession between Belwood Avenue and Upper Wentworth" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Stone" ] +"Heating": array:3 [ 0 => "Heat Pump" 1 => "Forced air" 2 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1523839" +"ListOfficeKey": "54949" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Skylight" 1 => "In-Law Suite" ] +"ParkingFeatures": array:1 [ 0 => "Carport" ] +"PhotosChangeTimestamp": "2026-06-24T19:51:08Z" +"PhotosCount": 39 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-26T18:11:15Z" +"Stories": "2.5" +"StreetName": "ALPINE" +"StreetNumber": "135" +"StreetSuffix": "Avenue" +"SubdivisionName": "170 - Concession" +"TaxAnnualAmount": "5574.91" +"VirtualTourURLUnbranded": "https://www.venturehomes.ca/virtualtour.asp?tourid=70329" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:16 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] 15 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29948728/135-alpine-avenue-hamilton" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "C" +"BedroomsAboveGrade": 5 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 50.0 +"AboveGradeFinishedArea": 1850 +"OriginalEntryTimestamp": "2026-06-24T19:51:08.72Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1063677" +"ListOfficeNationalAssociationId": "1003557" +"Media": array:39 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] ] +"DaysOnMarket": 7 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29948728')" +"ID": "1561024" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24642 +post_id: "1562425" +post_author: 1 +"ListingKey": "29948589" +"ListingId": "40842795" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-28T20:20:24Z" +"RFModificationTimestamp": "2026-06-28T20:25:08Z" +"ListPrice": 879000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1946.0 +"BuildingAreaTotal": 0 +"City": "Kitchener" +"PostalCode": "N2R1T8" +"UnparsedAddress": "83 FRANKFURT Street, Kitchener, Ontario N2R1T8" +"Coordinates": array:2 [ 0 => -80.4862121 1 => 43.385216 ] +"Latitude": 43.385216 +"Longitude": -80.4862121 +"YearBuilt": 2012 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Award-Winning Capital Homes Quality on a Premium Corner Lot in Huron Park. Welcome to 83 Frankfurt St, a stunning 2-storey detached home on a premium wide corner lot in one of Kitchener West's most sought-after family neighbourhoods. This home impresses from the moment you step into the spacious foyer, finished with modern large-format tile and soaring 9' ceilings. The gourmet kitchen is a showstopper: granite countertops, custom soft-close cabinetry, walk-in pantry, and a large counter-height island with seating, all open to the great room and a dining area crowned by a dramatic cathedral ceiling. Brand-new hardwood floors run through the main living areas. Oversized windows flood every room with natural light. Upstairs you'll find 3 generous bedrooms including a primary with private ensuite, a second full bath, and convenient upper-floor laundry. Outside: concrete walkway and patio, with an extra-wide side yard on the corner lot that's prime for a future walkup and in-law suite in the unspoiled basement. Steps from Longo's, RBJ Schlegel Park, the Huron Community Centre, and direct access to the Huron Natural Area trail system. Shows AAA+. In-law potential!!! (id:62650)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Microwave" 6 => "Window Coverings" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-25T21:04:56.184804+00:00" +"Directions": "SIENNA CR TO FRANKFURT ST" +"ExteriorFeatures": array:3 [ 0 => "Brick" 1 => "Stone" 2 => "Vinyl siding" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2192196" +"ListOfficeKey": "55165" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Corner Site" 1 => "Sump Pump" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-06-25T14:11:09Z" +"PhotosCount": 45 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-28T20:10:43Z" +"Stories": "2.0" +"StreetName": "FRANKFURT" +"StreetNumber": "83" +"StreetSuffix": "Street" +"SubdivisionName": "334 - Huron Park" +"TaxAnnualAmount": "5792.72" +"VirtualTourURLUnbranded": "https://realsee.ai/ReZZg2XV" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:9 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29948589/83-frankfurt-street-kitchener" +"ParkingTotal": 5 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R4" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 51.0 +"AboveGradeFinishedArea": 1946 +"OriginalEntryTimestamp": "2026-06-24T19:31:33.56Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1449894" +"ListOfficeNationalAssociationId": "1114492" +"Media": array:45 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] 44 => array:13 [ …13] ] +"DaysOnMarket": 7 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29948589')" +"ID": "1562425" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24641 +post_id: "1563887" +post_author: 1 +"ListingKey": "29948729" +"ListingId": "40842794" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-28T20:20:24Z" +"RFModificationTimestamp": "2026-06-28T20:25:09Z" +"ListPrice": 799000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1338.0 +"BuildingAreaTotal": 0 +"City": "Burlington" +"PostalCode": "L7L2Z4" +"UnparsedAddress": "5275 BANTING Court, Burlington, Ontario L7L2Z4" +"Coordinates": array:2 [ 0 => -79.735057 1 => 43.3677106 ] +"Latitude": 43.3677106 +"Longitude": -79.735057 +"YearBuilt": 1980 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to this beautifully renovated 3-Bedroom, 1.5 -Bath end-unit townhome in a quiet, family-friendly enclave in highly sought-after Elizabeth Gardens, just step from the lake. Thoughtfully redesigned from top to bottom, this move-in-ready home offers a perfect blend of modern style, comfort, & functionality. Step inside to discover a bright and inviting open-concept main floor, new laminate throughout, designer lighting, and a stunning custom kitchen that serves as the heart of the home. The kitchen showcases bamboo countertops, herringbone wood inlay, stainless steel appliances a custom range hood, stylish backsplash and contemporary finishes that create warm yet sophisticated atmosphere. Large windows throughout flood the home with natural light and enhance the spacious feel of the main living areas. The dining area overlooks the private backyard and offers convenient access to outdoor living. Enjoy your own fully fenced yard backing onto common green space, providing a peaceful setting for entertaining, relaxing, gardening or family gatherings. New fuse panel. The 2nd. level features three generously sized bedrooms with large windows and ample closet space, with an updated full bathroom finished in a timeless modern design. The finished basement adds valuable additional living space and can easily function as a rec. room, fam. room, home office, gym, playroom, or media room to suit your lifestyle. Numerous upgrades throughout the home include renovated baths, light fixtures, interior. doors and hardware, custom millwork, a stylish powder room, newer front door insert, and seamless interior garage access. Pride of ownership is evident in every detail. Close to parks, schools, shopping, restaurants, public transit, and major commuter routes, this exceptional home offers the convenience of every day amenities while being just moments from Burlington's beautiful waterfront. A rare opportunity in one of Burlington's most established and desirable neighbourhoods. (id:62650)" +"Appliances": array:8 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water meter" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" 6 => "Window Coverings" 7 => "Garage door opener" ] +"AssociationFee": "454.35" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:2 [ 0 => "Water" 1 => "Insurance" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"BathroomsPartial": 1 +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-25T23:27:56.850403+00:00" +"Directions": "Lakeshore Rd. North on Kenwood to Banting Court" +"ExteriorFeatures": array:3 [ 0 => "Brick" 1 => "Vinyl siding" 2 => "Other" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:1 [ 0 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1524113" +"ListOfficeKey": "283457" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Paved driveway" 1 => "Automatic Garage Door Opener" 2 => "Private Yard" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-06-24T19:51:09Z" +"PhotosCount": 50 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-28T20:10:44Z" +"Stories": "2.0" +"StreetName": "BANTING" +"StreetNumber": "5275" +"StreetSuffix": "Court" +"SubdivisionName": "332 - Elizabeth Gardens" +"TaxAnnualAmount": "4590" +"VirtualTourURLUnbranded": "https://youriguide.com/dlkim_5275_banting_ct_burlington_on/" +"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/29948729/5275-banting-court-burlington" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "Row / Townhouse" ] +"CommonInterest": "Condo/Strata" +"GeocodeManualYN": true +"ZoningDescription": "R1" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"AboveGradeFinishedArea": 1275 +"BelowGradeFinishedArea": 63 +"OriginalEntryTimestamp": "2026-06-24T19:51:08.96Z" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1123005" +"ListOfficeNationalAssociationId": "1330157" +"Media": array:50 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] 44 => array:13 [ …13] 45 => array:13 [ …13] 46 => array:13 [ …13] 47 => array:13 [ …13] 48 => array:13 [ …13] 49 => array:13 [ …13] ] +"DaysOnMarket": 7 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29948729')" +"ID": "1563887" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25069 +post_id: 1583623 +post_author: 1 +"ListingKey": "29976612" +"ListingId": "40842793" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-02T03:40:07Z" +"RFModificationTimestamp": "2026-07-02T03:42:52Z" +"ListPrice": 399900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1244.0 +"BuildingAreaTotal": 0 +"City": "Vittoria" +"PostalCode": "N0E1W0" +"UnparsedAddress": "6 HEWITT Street, Vittoria, Ontario N0E1W0" +"Coordinates": array:2 [ 0 => -80.3218943 1 => 42.7623422 ] +"Latitude": 42.7623422 +"Longitude": -80.3218943 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 6 Hewitt Street, located in the heart of Vittoria, Ontario. This cute and cozy storey-and-a-half home is the perfect opportunity for first-time buyers, retirees, or investors. Completely renovated from the ground up in 2019, the home received extensive updates including flooring, wiring, drywall, lighting, and more, leaving virtually nothing left to do. For added peace of mind, the gas furnace was replaced in 2025. Step inside and you'll be greeted by a bright, open-concept layout featuring a spacious kitchen, dining area, and living room. Toward the rear of the home, you'll find two additional bedrooms, including one with patio door access to the rear deck. This level also offers the convenience of main-floor laundry/ updated four-piece bathroom as well as an additional walkout to the rear covered deck.. The upper level features a large primary bedroom along with a smaller bedroom that would make an ideal nursery, home office, or hobby room. Outside, you'll appreciate the abundance of covered outdoor living space, including a welcoming front porch and a large covered rear deck overlooking the fully fenced backyard. Whether you're entertaining family and friends or simply enjoying a quiet afternoon, this outdoor space is sure to impress. Move-in ready and full of charm, this is a wonderful place to call home. (id:62650)" +"Appliances": array:2 [ 0 => "Water softener" 1 => "Window Coverings" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Partial" ] +"CommunityFeatures": array:2 [ 0 => "School Bus" 1 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-07-02T03:33:33.244794+00:00" +"Directions": "HWY 24 to Vittoria Road- West on Vittoria Rd into the village and Hewitt St is ont he South Side." +"ExteriorFeatures": array:1 [ 0 => "Vinyl siding" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2257405" +"ListOfficeKey": "289745" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Crushed stone driveway" ] +"PhotosChangeTimestamp": "2026-07-02T03:22:00Z" +"PhotosCount": 25 +"Sewer": array:1 [ 0 => "Holding Tank" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-02T03:31:57Z" +"Stories": "1.0" +"StreetName": "HEWITT" +"StreetNumber": "6" +"StreetSuffix": "Street" +"SubdivisionName": "Vittoria" +"TaxAnnualAmount": "1926.4" +"Utilities": array:1 [ 0 => "Natural Gas" ] +"WaterSource": array:1 [ 0 => "Drilled Well" ] +"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/29976612/6-hewitt-street-vittoria" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "RH" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 37.0 +"AboveGradeFinishedArea": 1244 +"OriginalEntryTimestamp": "2026-07-02T02:11:00.82Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1496236" +"ListOfficeNationalAssociationId": "1380671" +"Media": array:25 [ 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] ] +"DaysOnMarket": 0 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29976612')" +"ID": 1583623 } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24535 +post_id: "1565003" +post_author: 1 +"ListingKey": "29948730" +"ListingId": "40842788" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-01T15:55:08Z" +"RFModificationTimestamp": "2026-07-01T15:57:19Z" +"ListPrice": 1139000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 3143.0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2V2P1" +"UnparsedAddress": "723 BROOKMILL Place, Waterloo, Ontario N2V2P1" +"Coordinates": array:2 [ 0 => -80.5842507 1 => 43.4746813 ] +"Latitude": 43.4746813 +"Longitude": -80.5842507 +"YearBuilt": 2001 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 723 Brookmill Place in the desirable neighbourhood of Laurelwood in Waterloo. Just steps from the Laurel Creek Conservation area, this expansive 4 bedroom 4 bathroom family home offers over 3,000 square feet of updated living space you can move right into and immediately enjoy. Step inside through the double door entry way and appreciate the bright, open concept layout with hardwood & porcelain floors, 9 ft ceiling heights and updated finishes throughout. The chef’s kitchen has been carefully designed to cater to a passion for cooking and hosting, featuring a 10 ft quartz island, gas stove, wine bar with wine fridge, and two stainless steel dishwashers. Host a dinner party in the formal dining area with friends and family, or curl up by the gas fireplace in the family room on a cold night. Upstairs, the spacious primary suite serves as a luxurious retreat, complete with a beautifully appointed double sink ensuite bathroom with a glass shower and a functional walk-in closet. Three more generously sized bedrooms with hardwood floors and a 4 pc bathroom complete the upper level. The basement features a bright, expansive layout with brand new custom-ordered carpet, a 4th bathroom, and plenty of storage space. Outside, your backyard oasis awaits! Landscaped with both privacy and functionality in mind, this peaceful outdoor space with new sodding, solar lighting and a 12 ft gazebo makes you feel like you’ve escaped the busy city. Steps away from conservation trails, public and Catholic schools, the YMCA, shopping, dining, universities, golf courses and so much more. New furnace with air hydration system, new kitchen appliances, new hot Water heater tank. With an array of luxurious features and thoughtful touches inside & out, this distinguished residence offers a lifestyle of unparalleled comfort and convenience thats perfect for your family’s next chapter. (id:62650)" +"Appliances": array:10 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water meter" 3 => "Water softener" 4 => "Gas stove(s)" 5 => "Dishwasher" 6 => "Wine Fridge" 7 => "Dryer" 8 => "Microwave" 9 => "Hood Fan" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-26T00:27:20.571658+00:00" +"Directions": "Laurelwood Dr/ Brookmill Ct" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"Fencing": array:1 [ 0 => "Fence" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2088817" +"ListOfficeKey": "76789" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Cul-de-sac" 1 => "Conservation/green belt" 2 => "Sump Pump" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-06-24T19:51:09Z" +"PhotosCount": 47 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-01T15:50:00Z" +"Stories": "2.0" +"StreetName": "BROOKMILL" +"StreetNumber": "723" +"StreetSuffix": "Place" +"SubdivisionName": "441 - Erbsville/Laurelwood" +"TaxAnnualAmount": "6960.78" +"Utilities": array:2 [ 0 => "Natural Gas" 1 => "Electricity" ] +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:15 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29948730/723-brookmill-place-waterloo" +"ParkingTotal": 6 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "R 5" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 36.0 +"AboveGradeFinishedArea": 2459 +"BelowGradeFinishedArea": 684 +"OriginalEntryTimestamp": "2026-06-24T19:51:09.22Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1362124" +"ListOfficeNationalAssociationId": "1004357" +"Media": array:47 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] 44 => array:13 [ …13] 45 => array:13 [ …13] 46 => array:13 [ …13] ] +"DaysOnMarket": 7 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29948730')" +"ID": "1565003" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24576 +post_id: "1568292" +post_author: 1 +"ListingKey": "29956204" +"ListingId": "40842786" +"PropertyType": "Other" +"PropertySubType": "Other" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-26T01:45:02Z" +"RFModificationTimestamp": "2026-06-26T04:48:51Z" +"ListPrice": 1100000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 1646.0 +"BuildingAreaTotal": 0 +"City": "Burlington" +"PostalCode": "L7L0B4" +"UnparsedAddress": "5034 FAIRVIEW Street, Burlington, Ontario L7L0B4" +"Coordinates": array:2 [ 0 => -79.7603684 1 => 43.3748786 ] +"Latitude": 43.3748786 +"Longitude": -79.7603684 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Incredible opportunity to own a unique multi-use live/work property in Burlington. Built by Branthaven Homes, this three-storey townhome offers the perfect blend of commercial and residential space. The ground-level storefront and finished basement are designated for commercial use, while the second and third levels provide a bright and spacious residential living area above. Featuring two separate entrances, two municipal addresses, and two independent HVAC systems, the property allows for complete separation between the commercial and residential components. An ideal setup for entrepreneurs, small business owners, investors, or those seeking the convenience of living and working in one exceptional location. Rare flexibility in a highly desirable Burlington community right across from the Appleby GO station. (id:62783)" +"Basement": array:1 [ 0 => "Full" ] +"BuildingAreaUnits": "square feet" +"CreationDate": "2026-06-26T04:48:15.778203+00:00" +"Directions": "Appleby Line to Fairview St" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Stucco" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2213643" +"ListOfficeKey": "283187" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Visual exposure" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-06-26T01:39:31Z" +"PhotosCount": 30 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-26T01:39:31Z" +"Stories": "3.0" +"StreetName": "FAIRVIEW" +"StreetNumber": "5034" +"StreetSuffix": "Street" +"SubdivisionName": "322 - Pinedale" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29956204/5034-fairview-street-burlington" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "Residential Commercial Mix" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "MXG-345" +"FrontageLengthNumeric": 18.0 +"OriginalEntryTimestamp": "2026-06-26T01:39:31.75Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1459434" +"ListOfficeNationalAssociationId": "1325425" +"Media": array:30 [ 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] ] +"DaysOnMarket": 6 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29956204')" +"ID": "1568292" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24527 +post_id: "1573024" +post_author: 1 +"ListingKey": "29948731" +"ListingId": "40842785" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-25T19:20:07Z" +"RFModificationTimestamp": "2026-06-25T19:49:55Z" +"ListPrice": 1899999.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 5.56 +"LivingArea": 2544.0 +"BuildingAreaTotal": 0 +"City": "Puslinch" +"PostalCode": "N0B2J0" +"UnparsedAddress": "1048 REGIONAL ROAD 97, Puslinch, Ontario N0B2J0" +"Coordinates": array:2 [ 0 => -80.0637621 1 => 43.3918666 ] +"Latitude": 43.3918666 +"Longitude": -80.0637621 +"YearBuilt": 1860 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Step into history at 1048 Regional Road 97 — an 1860 rare blonde brick home in the Puslinch area, part of the region's early settlement and older than Canada itself, set on over 5.5 picturesque acres. A long driveway leads to a gracious front porch, refurbished in 2021, welcoming you into 2,544 square feet of living space. Inside, four bedrooms and two full bathrooms pair original character with everyday comfort. A large living room showcases an original fireplace mantle and decorative cove moldings, while a gracious dining room opens to a private outdoor patio. The bright, spacious main floor family room offers easy access and connection to the outdoors, and a kitchen addition brings a wood burning stove for added warmth. Modern amenities include main floor laundry, and the primary bedroom includes an adjoining room ideal as a dressing room, nursery or office. Beyond the front door, the property unfolds into a true four-season lifestyle. A barn and paddock await those dreaming of horses or hobby farming, while a sugar shack and network of cut trails invite maple syrup tradition and quiet walks through your own woods. Cool off in the in-ground pool, unwind in the hot tub and enjoy beautifully landscaped grounds that make every season feel like a retreat. Rarely does a property combine this much heritage with this much lifestyle. 1048 Regional Road 97 is 5.5 acres of history, comfort and possibility, all your own. Don’t be TOO LATE*! *REG TM. RSA. (id:62650)" +"Appliances": array:10 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Hot Tub" 4 => "Dishwasher" 5 => "Stove" 6 => "Dryer" 7 => "Freezer" 8 => "Window Coverings" 9 => "Microwave Built-in" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Partial" ] +"Cooling": array:1 [ 0 => "None" ] +"CreationDate": "2026-06-25T19:49:42.820203+00:00" +"Directions": "Hwy 6 to Regional Rd 97" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FireplaceYN": true +"FireplacesTotal": "3" +"FoundationDetails": array:1 [ 0 => "Block" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1525426" +"ListOfficeKey": "293261" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Country residential" ] +"LotSizeDimensions": "5.56" +"ParkingFeatures": array:1 [ 0 => "Open" ] +"PhotosChangeTimestamp": "2026-06-24T19:51:09Z" +"PhotosCount": 50 +"PoolFeatures": array:1 [ 0 => "Indoor pool" ] +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-25T19:10:57Z" +"Stories": "1.5" +"StreetName": "REGIONAL ROAD 97" +"StreetNumber": "1048" +"SubdivisionName": "045 - Beverly" +"TaxAnnualAmount": "3014.3" +"Utilities": array:2 [ 0 => "Electricity" 1 => "Telephone" ] +"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/019eff47-9289-700a-b6c6-61abf2b7bd99" +"WaterSource": array:1 [ 0 => "Drilled Well" ] +"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/29948731/1048-regional-road-97-puslinch" +"ParkingTotal": 10 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "A1" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 561.0 +"AboveGradeFinishedArea": 2544 +"OriginalEntryTimestamp": "2026-06-24T19:51:09.42Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1063673" +"ListOfficeNationalAssociationId": "1424570" +"Media": array:50 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] 44 => array:13 [ …13] 45 => array:13 [ …13] 46 => array:13 [ …13] 47 => array:13 [ …13] 48 => array:13 [ …13] 49 => array:13 [ …13] ] +"DaysOnMarket": 7 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29948731')" +"ID": "1573024" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24533 +post_id: "1564389" +post_author: 1 +"ListingKey": "29953842" +"ListingId": "40842783" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-25T19:00:06Z" +"RFModificationTimestamp": "2026-06-25T20:41:08Z" +"ListPrice": 799900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1713.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L0R1C0" +"UnparsedAddress": "150 VOYAGER Pass, Hamilton, Ontario L0R1C0" +"Coordinates": array:2 [ 0 => -79.8141322 1 => 43.1161802 ] +"Latitude": 43.1161802 +"Longitude": -79.8141322 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 150 Voyager Pass, a beautifully maintained 3+1 bedroom, 4 bathroom home located in one of Glanbrook's most sought-after family neighbourhoods. This spacious property offers a double car garage, warm wood floors throughout, and a smart, functional layout perfect for families of all sizes. The upper level features three generous bedrooms, including a primary suite with a private ensuite. On the main floor, enjoy a bright, open-concept living and dining area that flows into a stylish kitchen - ideal for everyday living and entertaining. The finished basement offers even more living space, complete with a full kitchen, an additional bedroom, and a full bathroom - perfect for in-laws, or guests. Step outside to your expansive backyard retreat, featuring a large, fully fenced yard and a charming gazebo - perfect for summer barbecues, relaxing evenings, or entertaining friends and family. Located just minutes from top-rated schools, a gym, grocery stores, and popular fast food spots, this home combines comfort, space, and convenience in one fantastic package. Don't miss out - this move-in-ready home is everything you've been looking for! (id:62650)" +"Appliances": array:8 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Central Vacuum" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" 6 => "Hood Fan" 7 => "Garage door opener" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Partial" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-25T20:40:59.459885+00:00" +"Directions": "Hwy 56 - Right onto Windwood Dr, Left onto Voyager Pass" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2085537" +"ListOfficeKey": "294391" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Southern exposure" 1 => "Country residential" 2 => "In-Law Suite" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-06-25T18:51:27Z" +"PhotosCount": 50 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-25T18:51:27Z" +"Stories": "2.0" +"StreetName": "VOYAGER" +"StreetNumber": "150" +"StreetSuffix": "Pass" +"SubdivisionName": "532 - Binbrook Municipal" +"TaxAnnualAmount": "5064.48" +"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/29953842/150-voyager-pass-hamilton" +"ParkingTotal": 6 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "1979876" +"CommonInterest": "Freehold" +"CoListOfficeKey": "294391" +"GeocodeManualYN": true +"ZoningDescription": "R4-192" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 36.0 +"AboveGradeFinishedArea": 1713 +"OriginalEntryTimestamp": "2026-06-25T18:51:27.58Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Builder" +"ListAgentNationalAssociationId": "1358930" +"ListOfficeNationalAssociationId": "1438340" +"CoListAgentNationalAssociationId": "1265663" +"CoListOfficeNationalAssociationId": "1438340" +"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": 6 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29953842')" +"ID": "1564389" } ] +success: true +page_size: 12 +page_count: 16654 +count: 199845 +after_key: "" } "RF Response Time" => "0.2 seconds" ] ]