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=154740&$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 {#24528 +items: array:12 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24657 +post_id: "1455838" +post_author: 1 +"ListingKey": "29775107" +"ListingId": "40831153" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-20T20:40:06Z" +"RFModificationTimestamp": "2026-06-20T20:46:42Z" +"ListPrice": 1299999.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 2 +"BedroomsTotal": 4.0 +"LotSizeArea": 1.46 +"LivingArea": 2640.0 +"BuildingAreaTotal": 0 +"City": "Grassie" +"PostalCode": "L0R1M0" +"UnparsedAddress": "3568 SOUTH GRIMSBY RD 12 Road, Grassie, Ontario L0R1M0" +"Coordinates": array:2 [ 0 => -79.6063714 1 => 43.1528563 ] +"Latitude": 43.1528563 +"Longitude": -79.6063714 +"YearBuilt": 1990 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to your own private country retreat! Nestled on approximately 1.5 acres, this custom Cape Cod-inspired home offers the perfect blend of space, comfort, and lifestyle. Featuring over 2,600 sq ft above grade, this well-maintained home boasts 4 spacious bedrooms, 4 bathrooms, and an ideal family-friendly layout. The main level offers a bright eat-in kitchen, formal dining room, oversized living room, cozy family room with fireplace, convenient main floor laundry, and inside access to the attached double car garage. Upstairs you’ll find generous bedrooms including a large primary suite, additional full bath, and a massive bonus bedroom/living space with another bathroom perfect for guests, a games room, home office, or teen retreat. The unfinished basement provides endless potential for future living space, storage, or an in-law setup. Step outside and enjoy the incredible grounds featuring a stunning stocked pond approximately 60 ft x 130 ft, expansive green space, mature landscaping, and endless room to entertain, relax, or enjoy the outdoors. A rare opportunity to own a beautifully maintained country property with executive home appeal and resort-style surroundings. Perfect for families, hobbyists, outdoor enthusiasts, or anyone seeking privacy and space just outside the city. Located close to churches, schools and just minutes from Grimsby this location can't be beat! (id:62650)" +"Appliances": array:8 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Hood Fan" 6 => "Window Coverings" 7 => "Garage door opener" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"BathroomsPartial": 2 +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-20T18:12:17.526558+00:00" +"Directions": "Mud St to South Grimsby Road 12" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2082579" +"ListOfficeKey": "275238" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Paved driveway" 1 => "Country residential" 2 => "Automatic Garage Door Opener" ] +"LotSizeDimensions": "1.46" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-20T13:01:44Z" +"PhotosCount": 50 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-20T20:34:32Z" +"Stories": "2.0" +"StreetName": "SOUTH GRIMSBY RD 12" +"StreetNumber": "3568" +"StreetSuffix": "Road" +"SubdivisionName": "056 - West Lincoln" +"TaxAnnualAmount": "6941.1" +"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/363676" +"WaterSource": array:1 [ 0 => "Cistern" ] +"Rooms": array:13 [ 0 => array:11 [ "RoomKey" => "1664151690" "RoomType" => "2pc Bathroom" "ListingId" => "40831153" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29775107" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T20:34:32.19Z" ] 1 => array:11 [ "RoomKey" => "1664151691" "RoomType" => "Bedroom" "ListingId" => "40831153" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29775107" "RoomLength" => null "RoomDimensions" => "22'0'' x 20'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T20:34:32.19Z" ] 2 => array:11 [ "RoomKey" => "1664151692" "RoomType" => "4pc Bathroom" "ListingId" => "40831153" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29775107" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T20:34:32.19Z" ] 3 => array:11 [ "RoomKey" => "1664151693" "RoomType" => "4pc Bathroom" "ListingId" => "40831153" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29775107" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T20:34:32.19Z" ] 4 => array:11 [ "RoomKey" => "1664151694" "RoomType" => "Bedroom" "ListingId" => "40831153" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29775107" "RoomLength" => null "RoomDimensions" => "17'0'' x 12'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T20:34:32.19Z" ] 5 => array:11 [ "RoomKey" => "1664151695" "RoomType" => "Bedroom" "ListingId" => "40831153" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29775107" "RoomLength" => null "RoomDimensions" => "11'5'' x 15'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T20:34:32.19Z" ] 6 => array:11 [ "RoomKey" => "1664151696" "RoomType" => "Primary Bedroom" "ListingId" => "40831153" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29775107" "RoomLength" => null "RoomDimensions" => "18'6'' x 12'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T20:34:32.19Z" ] 7 => array:11 [ "RoomKey" => "1664151697" "RoomType" => "2pc Bathroom" "ListingId" => "40831153" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29775107" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T20:34:32.19Z" ] 8 => array:11 [ "RoomKey" => "1664151698" "RoomType" => "Laundry room" "ListingId" => "40831153" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29775107" "RoomLength" => null "RoomDimensions" => "8'1'' x 8'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T20:34:32.2Z" ] 9 => array:11 [ "RoomKey" => "1664151699" "RoomType" => "Family room" "ListingId" => "40831153" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29775107" "RoomLength" => null "RoomDimensions" => "12'1'' x 19'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T20:34:32.2Z" ] 10 => array:11 [ "RoomKey" => "1664151700" "RoomType" => "Eat in kitchen" "ListingId" => "40831153" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29775107" "RoomLength" => null "RoomDimensions" => "13'5'' x 22'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T20:34:32.2Z" ] 11 => array:11 [ "RoomKey" => "1664151701" "RoomType" => "Dining room" "ListingId" => "40831153" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29775107" "RoomLength" => null "RoomDimensions" => "11'5'' x 12'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T20:34:32.2Z" ] 12 => array:11 [ "RoomKey" => "1664151702" "RoomType" => "Living room" "ListingId" => "40831153" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29775107" "RoomLength" => null "RoomDimensions" => "12'1'' x 21'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-20T20:34:32.2Z" ] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29775107/3568-south-grimsby-rd-12-road-grassie" +"ParkingTotal": 12 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 150.0 +"AboveGradeFinishedArea": 2640 +"OriginalEntryTimestamp": "2026-05-20T13:01:19.93Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1357288" +"ListOfficeNationalAssociationId": "1263001" +"Media": array:50 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "29775107_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/285c1c7e1ecb4c821cec1e32e8890e7c.webp" "MediaSize" => 116570 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-285c1c7e1ecb4c821cec1e32e8890e7c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Brick-front residence featuring multiple dormers, a covered front porch with white columns, and a two-car attached garage" "PreferredPhotoYN" => true "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:43.13Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "29775107_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/7d93a8074fabc0d6a72afb30a4f5df0c.webp" "MediaSize" => 95378 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-7d93a8074fabc0d6a72afb30a4f5df0c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Brick residence featuring a gabled roofline with dormer windows, attached two-car garage, and a covered porch" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:42.69Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "29775107_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/75b357e6a6cd4d740646fde7ae820765.webp" "MediaSize" => 108352 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-75b357e6a6cd4d740646fde7ae820765.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Brick exterior with a covered porch featuring white columns and a dark shingle roof with dormer windows" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:42.17Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "29775107_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/81c5835ed4c06166d4956101a4183fb2.webp" "MediaSize" => 156020 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-81c5835ed4c06166d4956101a4183fb2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Brick exterior featuring a covered front porch with multiple support columns" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:43.14Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "29775107_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/1356c4dc7e9c25819256b6abaf46341d.webp" "MediaSize" => 103310 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-1356c4dc7e9c25819256b6abaf46341d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Entryway featuring wood-finish staircase and dark tile flooring" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:42.71Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "29775107_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/5fe4d32d65cf347a59201cbb5bda5e55.webp" "MediaSize" => 112347 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-5fe4d32d65cf347a59201cbb5bda5e55.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Foyer featuring slate-look floor tiling and a natural wood staircase" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:43.74Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "29775107_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/7c5a15257c027393b3a40c6691c6f561.webp" "MediaSize" => 109092 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-7c5a15257c027393b3a40c6691c6f561.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Entryway featuring a white door with decorative glass inserts and two sidelights" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:44.1Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "29775107_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/f04176613a77f7e66def3eea4e151571.webp" "MediaSize" => 86364 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-f04176613a77f7e66def3eea4e151571.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Expansive living area with neutral carpeting and white wall finishes" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:42.69Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "29775107_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/83a15f5083b79b256d5c3a965e84c096.webp" "MediaSize" => 83764 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-83a15f5083b79b256d5c3a965e84c096.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Carpeted living space with light-toned walls and crown molding" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:43.14Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "29775107_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/1e18f8f8b76f680ebdd0e6fa723177e8.webp" "MediaSize" => 84907 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-1e18f8f8b76f680ebdd0e6fa723177e8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Spacious living area featuring light-toned carpeting and neutral wall tones" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:42.71Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "29775107_4890_11" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/852d0c72e444fdf88087510bcd6a2f91.webp" "MediaSize" => 79325 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-852d0c72e444fdf88087510bcd6a2f91.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Expansive living area with neutral carpeting and light-toned walls" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:42.71Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "29775107_4890_12" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/0ee99bb4b7fda8f81d0739c14aa3f7ab.webp" "MediaSize" => 104533 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-0ee99bb4b7fda8f81d0739c14aa3f7ab.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Formal dining area featuring parquet wood-finish flooring, light blue walls, and a decorative ceiling medallion with a chandelier" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:42.73Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "29775107_4890_13" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/7a9eb5f62c377255a78269c94e5b7e60.webp" "MediaSize" => 115653 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-7a9eb5f62c377255a78269c94e5b7e60.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Dining area featuring parquet wood-finish flooring, a crystal chandelier with ceiling medallion, and a large window with wood trim" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:42.69Z" ] 13 => array:13 [ "Order" => 14 "MediaKey" => "29775107_4890_14" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/de625358ff75b725cb6be5b69eff404e.webp" "MediaSize" => 111940 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-de625358ff75b725cb6be5b69eff404e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen featuring wood cabinetry, light countertops, and a subway tile backsplash" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:44.09Z" ] 14 => array:13 [ "Order" => 15 "MediaKey" => "29775107_4890_15" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/c3067b3257852b197c27e114f9888983.webp" "MediaSize" => 99142 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-c3067b3257852b197c27e114f9888983.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Wood-finish flooring throughout the kitchen and dining areas" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:43.13Z" ] 15 => array:13 [ "Order" => 16 "MediaKey" => "29775107_4890_16" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/5ea95f8abf0a3b2169233115ba35c4c4.webp" "MediaSize" => 108827 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-5ea95f8abf0a3b2169233115ba35c4c4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen featuring wood-finish cabinetry, stainless steel appliances, a tile backsplash, light-toned countertops, and wood-finish flooring" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:42.72Z" ] 16 => array:13 [ "Order" => 17 "MediaKey" => "29775107_4890_17" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/de272c4e5916e61ba52cbf47bb0f462f.webp" "MediaSize" => 92200 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-de272c4e5916e61ba52cbf47bb0f462f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Open-concept living space featuring wood-finish flooring, a built-in dining bench, a central kitchen island with seating, oak cabinetry, and stainless steel appliances" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:43.74Z" ] 17 => array:13 [ "Order" => 18 "MediaKey" => "29775107_4890_18" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/ea6a919979841e92a56820e0847549a6.webp" "MediaSize" => 94645 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-ea6a919979841e92a56820e0847549a6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen featuring wood-finish flooring, oak cabinetry, stainless steel appliances, and a tile backsplash" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:43.19Z" ] 18 => array:13 [ "Order" => 19 "MediaKey" => "29775107_4890_19" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/b7309f5cbd063165fb4f07cec2b526ae.webp" "MediaSize" => 93886 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-b7309f5cbd063165fb4f07cec2b526ae.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen featuring wood-finish cabinetry, light countertops, a tile backsplash, and dark wood-finish flooring" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:43.74Z" ] 19 => array:13 [ "Order" => 20 "MediaKey" => "29775107_4890_20" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/10c23b902226937db8ef36d30fc02d6b.webp" "MediaSize" => 97349 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-10c23b902226937db8ef36d30fc02d6b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen and dining area featuring wood-finish flooring, light grey walls, and a sliding glass door to an exterior patio" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:43.69Z" ] 20 => array:13 [ "Order" => 21 "MediaKey" => "29775107_4890_21" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/1950ef99e2da0480430a560d87165380.webp" "MediaSize" => 90262 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-1950ef99e2da0480430a560d87165380.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Living area featuring a prominent brick fireplace with a wood-burning stove, wood-finish flooring, light gray wall paint, and a ceiling fan" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:44.1Z" ] 21 => array:13 [ "Order" => 22 "MediaKey" => "29775107_4890_22" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/52a848d67cd2d3ecb4a33fac828c2252.webp" "MediaSize" => 106824 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-52a848d67cd2d3ecb4a33fac828c2252.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Living space featuring a prominent brick fireplace with a wood-burning stove, wood-finish flooring, a bay window, a ceiling fan, and light gray wall paint" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:42.69Z" ] 22 => array:13 [ "Order" => 23 "MediaKey" => "29775107_4890_23" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/97f7d0aa5cd3f901043594911c23246c.webp" "MediaSize" => 98511 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-97f7d0aa5cd3f901043594911c23246c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Spacious living area featuring wood-finish flooring, a brick-faced fireplace with a wood-burning stove, and a ceiling fan" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:42.69Z" ] 23 => array:13 [ "Order" => 24 "MediaKey" => "29775107_4890_24" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/19524ff9789ac20315227873178f3de6.webp" "MediaSize" => 93898 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-19524ff9789ac20315227873178f3de6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bathroom featuring a white vanity with a glass countertop, an ornamental mirror, and a wall-mounted cabinet" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:42.69Z" ] 24 => array:13 [ "Order" => 25 "MediaKey" => "29775107_4890_25" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/7a7b907f59514ffcf9fd092fb0073ea1.webp" "MediaSize" => 78542 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-7a7b907f59514ffcf9fd092fb0073ea1.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Utility room featuring wood-finish flooring, a white paneled door with an upper window, a laundry sink with a tiled backsplash, and open shelving" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:42.71Z" ] 25 => array:13 [ "Order" => 26 "MediaKey" => "29775107_4890_26" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/bf69ac1836220659671dd901985f1681.webp" "MediaSize" => 90828 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-bf69ac1836220659671dd901985f1681.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Hallway featuring wood-finish flooring, recessed lighting, and a washer and dryer" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:42.71Z" ] 26 => array:13 [ "Order" => 27 "MediaKey" => "29775107_4890_27" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/6a9f9aa196a7bbe322816699831764b7.webp" "MediaSize" => 93572 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-6a9f9aa196a7bbe322816699831764b7.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Spacious bonus room featuring wood-finish flooring, recessed lighting, and a built-in bar area with pendant lighting" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:42.71Z" ] 27 => array:13 [ "Order" => 28 "MediaKey" => "29775107_4890_28" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/ce26082e90657c71e65113cd2bbb9820.webp" "MediaSize" => 103472 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-ce26082e90657c71e65113cd2bbb9820.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:43.12Z" ] 28 => array:13 [ "Order" => 29 "MediaKey" => "29775107_4890_29" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/115e64e86de0af9d2103dc256311453a.webp" "MediaSize" => 103091 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-115e64e86de0af9d2103dc256311453a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Full-size bar featuring stacked stone detailing and a solid surface countertop" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:42.69Z" ] 29 => array:13 [ "Order" => 30 "MediaKey" => "29775107_4890_30" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/d6f7956e9d15ebda4d16011da91ba536.webp" "MediaSize" => 48064 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-d6f7956e9d15ebda4d16011da91ba536.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Powder room with wood-finish flooring, a contemporary corner vanity, and a traditional toilet" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:42.69Z" ] 30 => array:13 [ "Order" => 31 "MediaKey" => "29775107_4890_31" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/9fc5531fda6a49085c9cbace8058b39b.webp" "MediaSize" => 86922 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-9fc5531fda6a49085c9cbace8058b39b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Hallway featuring wood-finish flooring, warm-toned wall paint, and multiple doorways with wood trim" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:43.13Z" ] 31 => array:13 [ "Order" => 32 "MediaKey" => "29775107_4890_32" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/1ad392f55f0f768b9091e804da343993.webp" "MediaSize" => 102035 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-1ad392f55f0f768b9091e804da343993.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Wall-to-wall carpeting with a ceiling-mounted light fixture" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:43.78Z" ] 32 => array:13 [ "Order" => 33 "MediaKey" => "29775107_4890_33" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/5ec284cacb43e2e005a45e177868929d.webp" "MediaSize" => 109090 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-5ec284cacb43e2e005a45e177868929d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Carpeted room featuring a patterned accent wall, a central ceiling light fixture, and an arched window providing natural light" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:43.14Z" ] 33 => array:13 [ "Order" => 34 "MediaKey" => "29775107_4890_34" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/1daddeab7b1a5fab5e0f539f905e18b6.webp" "MediaSize" => 96117 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-1daddeab7b1a5fab5e0f539f905e18b6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Walk-in closet featuring wire shelving, hanging rods, carpet flooring, a window with a patterned blind, and a built-in corner shelf" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:43.12Z" ] 34 => array:13 [ "Order" => 35 "MediaKey" => "29775107_4890_35" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/b7122fc9ab2fb9b37be0bed050520027.webp" "MediaSize" => 95683 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-b7122fc9ab2fb9b37be0bed050520027.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Dual vanity with granite countertop and undermount sinks" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:43.69Z" ] 35 => array:13 [ "Order" => 36 "MediaKey" => "29775107_4890_36" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/214403b800850c107dcdb622cfb86942.webp" "MediaSize" => 107734 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-214403b800850c107dcdb622cfb86942.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Modern bathroom featuring a glass-enclosed shower with a multi-function shower panel and a freestanding soaking tub" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:43.69Z" ] 36 => array:13 [ "Order" => 37 "MediaKey" => "29775107_4890_37" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/856ea0b81818ececde77c69911d286ca.webp" "MediaSize" => 108745 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-856ea0b81818ececde77c69911d286ca.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Spacious bedroom featuring neutral wall finishes, plush carpeting, multiple closet doors, and a ceiling fan" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:43.52Z" ] 37 => array:13 [ "Order" => 38 "MediaKey" => "29775107_4890_38" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/0bf6c42c9116106d254b32f09b0934e4.webp" "MediaSize" => 100952 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-0bf6c42c9116106d254b32f09b0934e4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Carpeted room featuring a ceiling fan, window with curtains, and neutral wall paint" "PreferredPhotoYN" => false "ResourceRecordId" => "40831153" "ResourceRecordKey" => "29775107" "ModificationTimestamp" => "2026-05-20T13:01:43.74Z" ] 38 => array:13 [ "Order" => 39 "MediaKey" => "29775107_4890_39" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29775107/689213c10782aff4e0d4ae58b2485f08.webp" "MediaSize" => 84128 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29775107/thumbnail-689213c10782aff4e0d4ae58b2485f08.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" …5 ] 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": 42 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29775107')" +"ID": "1455838" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24501 +post_id: "1464351" +post_author: 1 +"ListingKey": "29811547" +"ListingId": "40831151" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-29T13:20:17Z" +"RFModificationTimestamp": "2026-06-29T13:45:20Z" +"ListPrice": 574900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1573.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8H2G3" +"UnparsedAddress": "196 CAMPBELL Avenue, Hamilton, Ontario L8H2G3" +"Coordinates": array:2 [ 0 => -79.8125096 1 => 43.2484303 ] +"Latitude": 43.2484303 +"Longitude": -79.8125096 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 196 Campbell Avenue, a thoughtfully updated home in Hamilton’s vibrant Crown Point neighbourhood. The main floor features an updated kitchen complete with quartz countertops, flowing seamlessly into the open-concept living and dining area, while main floor laundry adds everyday convenience. Recent improvements include newly completed exterior siding that gives the home fresh curb appeal, along with a replaced lead water service line for added peace of mind. The finished basement offers excellent flexibility with a spacious rec room, additional bedroom, and bathroom, while the separate side entrance and previous kitchen rough-ins leave open the potential for in-law or extended family living. Outside, enjoy a private backyard space perfect for relaxing, gardening, or summer evenings with friends and family. Whether you’re looking for your first home, additional space for a growing family, or a move-in ready property in one of Hamilton’s continually growing communities, this home checks all the right boxes. (id:62650)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Window Coverings" 6 => "Microwave Built-in" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-27T16:58:56.975818+00:00" +"Directions": "OTTAWA/CAMPBELL" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2064793" +"ListOfficeKey": "275238" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Ravine" ] +"PhotosChangeTimestamp": "2026-05-27T15:32:58Z" +"PhotosCount": 42 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-29T13:11:49Z" +"Stories": "2.0" +"StreetName": "CAMPBELL" +"StreetNumber": "196" +"StreetSuffix": "Avenue" +"SubdivisionName": "201 - Crown Point" +"TaxAnnualAmount": "3114" +"VirtualTourURLUnbranded": "https://northernmediagroup.hd.pics/196-Campbell-Ave" +"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/29811547/196-campbell-avenue-hamilton" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "D" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 25.0 +"AboveGradeFinishedArea": 1125 +"BelowGradeFinishedArea": 448 +"OriginalEntryTimestamp": "2026-05-27T15:32:58.38Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Assessor" +"BelowGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1339843" +"ListOfficeNationalAssociationId": "1263001" +"Media": array:42 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] ] +"DaysOnMarket": 35 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29811547')" +"ID": "1464351" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24645 +post_id: "1452795" +post_author: 1 +"ListingKey": "29795182" +"ListingId": "40831150" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-05T15:40:52Z" +"RFModificationTimestamp": "2026-06-05T15:48:39Z" +"ListPrice": 1779000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0.46 +"LivingArea": 4549.0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2J2C8" +"UnparsedAddress": "57 MARGARET Avenue S, Waterloo, Ontario N2J2C8" +"Coordinates": array:2 [ 0 => -80.5019551 1 => 43.4689745 ] +"Latitude": 43.4689745 +"Longitude": -80.5019551 +"YearBuilt": 1954 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Fantastic opportunity to live in one of the most sought-after neighbourhoods in all of Kitchener-Waterloo! Situated on a private lot just under half an acre in the heart of the city, this exceptional custom-built home showcases quality craftsmanship and thoughtful design throughout its more than 4,500 sq. ft. of finished living space. Featuring 6 bedrooms and 5 bathrooms, every detail has been carefully curated to offer both luxury and functionality. Completely renovated and redesigned in 2012, the home was extensively updated from top to bottom, including the addition of a triple-car garage and a fully self-contained 2-bedroom, 2-bathroom accessory apartment. Expansive living spaces include a stunning living room addition, a spacious primary retreat with a walk-in closet and luxurious 6-piece en-suite, as well as a fully finished basement offering additional living and entertaining space. Additional highlights include heated bathroom floors, huge games room with pool table above the garage, hardwood flooring throughout the main level, and parking for up to 11 vehicles. The mature, private, fully fenced backyard features an inground sprinkler system and provides the perfect setting for entertaining, relaxing, and enjoying the tranquility of nature — all while being centrally located close to every amenity. (id:62650)" +"Appliances": array:9 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Dishwasher" 4 => "Stove" 5 => "Central Vacuum - Roughed In" 6 => "Hood Fan" 7 => "Window Coverings" 8 => "Garage door opener" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Partial" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-23T04:48:58.549748+00:00" +"Directions": "Erb St E (one way going east) to Margaret Ave S" +"ExteriorFeatures": array:2 [ 0 => "Stucco" 1 => "Brick Veneer" ] +"Fencing": array:1 [ 0 => "Fence" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:3 [ 0 => "Forced air" 1 => "In Floor Heating" 2 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1563561" +"ListOfficeKey": "77518" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Paved driveway" 1 => "Sump Pump" 2 => "In-Law Suite" ] +"LotSizeDimensions": "0.46" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-29T15:01:29Z" +"PhotosCount": 39 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-05T15:33:43Z" +"Stories": "2.0" +"StreetDirSuffix": "South" +"StreetName": "MARGARET" +"StreetNumber": "57" +"StreetSuffix": "Avenue" +"SubdivisionName": "114 - Uptown Waterloo/North Ward" +"TaxAnnualAmount": "6179" +"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/57-Margaret-Ave-S" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:22 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] 15 => array:11 [ …11] 16 => array:11 [ …11] 17 => array:11 [ …11] 18 => array:11 [ …11] 19 => array:11 [ …11] 20 => array:11 [ …11] 21 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29795182/57-margaret-avenue-s-waterloo" +"ParkingTotal": 11 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "SR2" +"BedroomsAboveGrade": 5 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 75.0 +"AboveGradeFinishedArea": 3696 +"BelowGradeFinishedArea": 853 +"OriginalEntryTimestamp": "2026-05-23T01:39:28.8Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"BelowGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1123355" +"ListOfficeNationalAssociationId": "1186916" +"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": 39 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29795182')" +"ID": "1452795" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24519 +post_id: "1433994" +post_author: 1 +"ListingKey": "29767911" +"ListingId": "40831149" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-17T14:00:05Z" +"RFModificationTimestamp": "2026-06-17T14:04:59Z" +"ListPrice": 549800.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1703.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8H5T8" +"UnparsedAddress": "156 ADELINE Avenue, Hamilton, Ontario L8H5T8" +"Coordinates": array:2 [ 0 => -79.7918871 1 => 43.2411152 ] +"Latitude": 43.2411152 +"Longitude": -79.7918871 +"YearBuilt": 1947 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 156 Adeline Avenue! This three bedroom, two bathroom home has been recently updated with new flooring, new kitchen, fresh paint and trim!! Roof (2012), Furnace (2010), AC (2020). Move in ready property! The home is located in Hamilton East, excellent access to Red Hill and QEW! The home has lots of parking and a detached garage for hobbies, storage or car collector! Call me today to view the property! (id:62650)" +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-19T15:07:50.942445+00:00" +"Directions": "Parkdale Avenue to Roxborough Avenue to Adeline Ave" +"ExteriorFeatures": array:1 [ 0 => "Aluminum siding" ] +"FireplaceFeatures": array:2 [ 0 => "Wood" 1 => "Stove" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1917243" +"ListOfficeKey": "264845" +"LivingAreaUnits": "square feet" +"ParkingFeatures": array:1 [ 0 => "Detached Garage" ] +"PhotosChangeTimestamp": "2026-06-17T13:52:00Z" +"PhotosCount": 29 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-17T13:52:00Z" +"Stories": "1.5" +"StreetName": "ADELINE" +"StreetNumber": "156" +"StreetSuffix": "Avenue" +"SubdivisionName": "232 - Normanhurst" +"TaxAnnualAmount": "3419" +"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/29767911/156-adeline-avenue-hamilton" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "None" ] +"ZoningDescription": "R1" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 30.0 +"AboveGradeFinishedArea": 1303 +"BelowGradeFinishedArea": 400 +"OriginalEntryTimestamp": "2026-05-19T11:49:22.35Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Assessor" +"BelowGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1225588" +"ListOfficeNationalAssociationId": "1225289" +"Media": array:29 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] ] +"DaysOnMarket": 43 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29767911')" +"ID": "1433994" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24522 +post_id: "1437796" +post_author: 1 +"ListingKey": "29773891" +"ListingId": "40831145" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-10T20:00:07Z" +"RFModificationTimestamp": "2026-06-10T20:15:38Z" +"ListPrice": 2299900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 10.102 +"LivingArea": 4536.0 +"BuildingAreaTotal": 0 +"City": "Puslinch" +"PostalCode": "N0B2J0" +"UnparsedAddress": "2092 HIGHWAY 6, Puslinch, Ontario N0B2J0" +"Coordinates": array:2 [ 0 => -80.0593779 1 => 43.4165618 ] +"Latitude": 43.4165618 +"Longitude": -80.0593779 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Set on over 10 acres of ultra-private land in sought-after Flamborough, this exceptional country estate offers a rare blend of luxury, lifestyle, and functionality. Thoughtfully updated throughout, the 4-bedroom, 4-bathroom home delivers the kind of space, finish level, and versatility that is increasingly difficult to find. The main level is anchored by a dramatic family room with soaring cathedral ceilings, oversized windows, and a striking feature fireplace wall that creates an immediate sense of scale and warmth. Durable wood-look tile flooring runs throughout, while the chef-inspired kitchen features Cabico cabinetry, dovetail drawers, Cambria quartz countertops, and an oversized island designed for gathering and entertaining. A bright four-season sunroom with hot tub access overlooks the peaceful surrounding landscape and opens onto multiple outdoor seating areas and raised gardens. Upstairs, the open-to-below den with skylights adds to the home’s airy, connected feel. The spacious primary suite includes a custom walk-in closet and spa-inspired ensuite with oversized double shower and dual vanity, while three additional bedrooms and a full bathroom complete the upper level. The finished lower level was designed with entertaining in mind, offering an oversized rec room with wet bar and island seating, media room, wine cellar, and full bathroom. A true standout feature is the newly built 40’ x 54’ heated shop (2023) with hydro and high-speed internet — ideal for entrepreneurs, hobbyists, collectors, or recreational use. Additional highlights include a heated attached garage, furnace and heat pump(A/C) updates (2022), a 60-amp EV connection(at the shop), and participation in the CLTP program for valuable property tax savings. A truly spectacular offering combining privacy, modern comfort, and elevated country living — all within easy reach of the city. (id:62650)" +"Appliances": array:9 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Hot Tub" 3 => "Dishwasher" 4 => "Dryer" 5 => "Microwave" 6 => "Wet Bar" 7 => "Window Coverings" 8 => "Garage door opener" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-20T00:53:06.761981+00:00" +"Directions": "On HWY 6 between Mountsberg Rd & Campbellville Rd" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:2 [ 0 => "Heat Pump" 1 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2239450" +"ListOfficeKey": "299790" +"LivingAreaUnits": "square feet" +"LotFeatures": array:4 [ 0 => "Wet bar" 1 => "Country residential" 2 => "Automatic Garage Door Opener" 3 => "Private Yard" ] +"LotSizeDimensions": "10.102" +"NumberOfUnitsTotal": "1" +"ParkingFeatures": array:2 [ 0 => "Attached Garage" 1 => "Detached Garage" ] +"PhotosChangeTimestamp": "2026-05-20T15:33:50Z" +"PhotosCount": 50 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-10T19:51:44Z" +"Stories": "2.0" +"StreetName": "HIGHWAY 6" +"StreetNumber": "2092" +"SubdivisionName": "044 - Flamborough East" +"TaxAnnualAmount": "8164" +"VirtualTourURLUnbranded": "https://2092-hwy-6-flamborough.netlify.app/#top" +"WaterSource": array:1 [ 0 => "Drilled Well" ] +"Rooms": array:20 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] 15 => array:11 [ …11] 16 => array:11 [ …11] 17 => array:11 [ …11] 18 => array:11 [ …11] 19 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29773891/2092-highway-6-puslinch" +"ParkingTotal": 26 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "2050273" +"CommonInterest": "Freehold" +"CoListOfficeKey": "299790" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Security system" ] +"ZoningDescription": "P7, P8" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 0 +"AboveGradeFinishedArea": 3258 +"BelowGradeFinishedArea": 1278 +"OriginalEntryTimestamp": "2026-05-19T23:49:32.64Z" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"BelowGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1477386" +"ListOfficeNationalAssociationId": "1476846" +"CoListAgentNationalAssociationId": "1325722" +"CoListOfficeNationalAssociationId": "1476846" +"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": 42 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29773891')" +"ID": "1437796" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24641 +post_id: "1433754" +post_author: 1 +"ListingKey": "29768540" +"ListingId": "40831144" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-23T04:50:04Z" +"RFModificationTimestamp": "2026-06-23T04:53:25Z" +"ListPrice": 560000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1250.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8P4J6" +"UnparsedAddress": "47 NEW Street Unit# 2, Hamilton, Ontario L8P4J6" +"Coordinates": array:2 [ 0 => -79.8872812 1 => 43.2605712 ] +"Latitude": 43.2605712 +"Longitude": -79.8872812 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Beautifully renovated, quaint home in Hamilton’s sought-after West End blending modern functionality with warm, comfortable design. Ideally located just seconds from Highway 403 access and within walking distance to grocery shopping, Locke Street, Hess Village, and Downtown Hamilton, this move-in ready property offers the perfect balance of convenience and lifestyle. The bright open-concept main floor features a modern kitchen complete with oversized island seating, concrete countertops, stainless steel appliances and updated lighting that flows beautifully into the spacious living area and family room. Main level laundry adds everyday practicality, while functional basement storage areas maximize usability throughout the home. Upstairs, the home offers two large bedrooms and an updated bathroom with a cohesive aesthetic that feels elevated yet comfortable. Major building components including the roof, windows, A/C, electrical, and plumbing have all been updated within the last 10 years, providing peace of mind for future owners. Outside, the private maintenance-free backyard is a true urban retreat featuring multiple seating areas, covered shed space, string lighting, and rare driveway parking. This turnkey West Hamilton home offering style, function, and location in one complete package (id:62783)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water meter" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Partial" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-19T14:41:44.074325+00:00" +"ExteriorFeatures": array:1 [ 0 => "Vinyl siding" ] +"FoundationDetails": array:1 [ 0 => "Stone" ] +"Heating": array:3 [ 0 => "Hot water radiator heat" 1 => "Forced air" 2 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1524139" +"ListOfficeKey": "91227" +"LivingAreaUnits": "square feet" +"PhotosChangeTimestamp": "2026-06-23T04:23:03Z" +"PhotosCount": 23 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-23T04:33:12Z" +"Stories": "2.0" +"StreetName": "NEW" +"StreetNumber": "47" +"StreetSuffix": "Street" +"SubdivisionName": "103 - Strathcona South" +"TaxAnnualAmount": "4600" +"Utilities": array:2 [ 0 => "Natural Gas" 1 => "Electricity" ] +"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/29768540/47-new-street-hamilton" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "D" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 25.0 +"AboveGradeFinishedArea": 1250 +"OriginalEntryTimestamp": "2026-05-19T14:11:06.83Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Owner" +"ListAgentNationalAssociationId": "1063186" +"ListOfficeNationalAssociationId": "1155187" +"Media": array:23 [ 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] ] +"DaysOnMarket": 43 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29768540')" +"ID": "1433754" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24640 +post_id: "1440278" +post_author: 1 +"ListingKey": "29776951" +"ListingId": "40831136" +"PropertyType": "Residential Income" +"PropertySubType": "Multi-family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T16:30:28Z" +"RFModificationTimestamp": "2026-06-02T16:32:30Z" +"ListPrice": 1199000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 12.0 +"LotSizeArea": 0 +"LivingArea": 1047.0 +"BuildingAreaTotal": 0 +"City": "Listowel" +"PostalCode": "N4W1X2" +"UnparsedAddress": "180 UNION Street W, Listowel, Ontario N4W1X2" +"Coordinates": array:2 [ 0 => -80.9561993 1 => 43.7290717 ] +"Latitude": 43.7290717 +"Longitude": -80.9561993 +"YearBuilt": 2015 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Attention Investors and Multi-Family Buyers! Rare opportunity to own a modern 4-plex in the heart of Listowel featuring four spacious 3-bedroom, 1-bathroom units, each with in-suite laundry and separate hydro and gas meters. Built in 2015, this 11-year-old building has been exceptionally maintained and offers a strong gross annual income of $66,420 with potential for much more. . Perfect for investors or an owner-occupier seeking a multi-family residence, this property provides flexibility to live in one unit while housing extended family or generating steady rental income. Each unit features bright, open living spaces with laminate flooring throughout, modern kitchens equipped with a refrigerator, stove, dishwasher, and over-the-range microwave, as well as a mechanical/storage room for added convenience. The main floor units provide all one-level living and include a private terrace by the entrance—ideal for barbecues or relaxing outdoors. Each unit has its own dedicated parking space, and the property is pet-friendly, located in a quiet, family-oriented neighborhood close to downtown Listowel, Listowel Memorial Hospital, and nearby green space. With newer construction, separate utilities, and low maintenance costs, this property offers an exceptional blend of comfort, flexibility, and income potential—making it ideal for both investors and those seeking a multi-generational living opportunity in a thriving community. Don’t miss out on this solid investment with endless possibilities. (id:62650)" +"Basement": array:1 [ 0 => "None" ] +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-20T19:46:52.738924+00:00" +"Directions": "Take Elma St E and Wallace Ave S to Union St W" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2110923" +"ListOfficeKey": "86262" +"LivingAreaUnits": "square feet" +"ParkingFeatures": array:1 [ 0 => "Open" ] +"PhotosChangeTimestamp": "2026-05-20T16:41:08Z" +"PhotosCount": 25 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:22:00Z" +"Stories": "2.0" +"StreetDirSuffix": "West" +"StreetName": "UNION" +"StreetNumber": "180" +"StreetSuffix": "Street" +"SubdivisionName": "32 - Listowel" +"TaxAnnualAmount": "8092" +"VirtualTourURLUnbranded": "https://youriguide.com/d_180_union_st_w_listowel_on/" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29776951/180-union-street-w-listowel" +"ParkingTotal": 6 +"StructureType": array:1 [ 0 => "Fourplex" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R4" +"FrontageLengthNumeric": 82.0 +"AboveGradeFinishedArea": 1047 +"OriginalEntryTimestamp": "2026-05-20T16:41:08.88Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1379465" +"ListOfficeNationalAssociationId": "1004415" +"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": 42 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29776951')" +"ID": "1440278" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25062 +post_id: "1433534" +post_author: 1 +"ListingKey": "29767465" +"ListingId": "40831120" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-16T14:20:05Z" +"RFModificationTimestamp": "2026-06-16T14:24:22Z" +"ListPrice": 389900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0.968 +"LivingArea": 2585.0 +"BuildingAreaTotal": 0 +"City": "Dunnville" +"PostalCode": "N1A2W8" +"UnparsedAddress": "6219 RAINHAM Road, Dunnville, Ontario N1A2W8" +"Coordinates": array:2 [ 0 => -79.7235816 1 => 42.8727177 ] +"Latitude": 42.8727177 +"Longitude": -79.7235816 +"YearBuilt": 1860 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "OPPORTUNITY KNOCKS!!! Rural Hamlet property not far away from Dunnville Central and the Lake on the way to Selkirk and Port Dover on historic Regional Road #3/Rainham Rd. Original 1860 portion of home has at least triple brick walls. Main floor plan is over 2,000 sqft with 2 bedrooms, 1.5 bathes, 2 Family rooms, Dining Room and full Kitchen. 2nd level has 3 bedrooms and it seems there is development potential in the attic area to get a 2nd level bathroom with middle plan den existing already. Original house corners South Cayuga Rd. Check out the AI improved property pictures for what this home could become in the great neighbourhood of historic homes and modern builds. The immense side yard is the prize...you want that big side yard, great!!!....but the potential is in reach for the east portion of this property to be severed and a new lot is created with great value to an owner. Build your own new home on the new lot and rent the original home....perfect for income potential or future family 2nd residence home. Possibilities are endless for future prosperity. An amazing opportunity to obtain a property with extremely large financial upside. GREAT AREA, GREAT SCHOOLS, GREAT PEOPLE IN HALDIMAND AND CLOSE TO THAT COOL LAKE ERIE LAKE LIFE!!! AI photos used and attic space not in sqft. (id:62783)" +"Basement": array:2 [ 0 => "Unfinished" 1 => "Partial" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "School Bus" ] +"Cooling": array:1 [ 0 => "None" ] +"CreationDate": "2026-05-19T00:45:39.248260+00:00" +"Directions": "From Dunnville Main St., W on the bridge, becomes Rainham Rd." +"ExteriorFeatures": array:2 [ 0 => "Vinyl siding" 1 => "Brick Veneer" ] +"FoundationDetails": array:1 [ 0 => "Stone" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1559466" +"ListOfficeKey": "280713" +"LivingAreaUnits": "square feet" +"LotFeatures": array:6 [ 0 => "Southern exposure" 1 => "Corner Site" 2 => "Paved driveway" 3 => "Country residential" 4 => "Sump Pump" 5 => "Private Yard" ] +"LotSizeDimensions": "0.968" +"PhotosChangeTimestamp": "2026-06-16T14:12:04Z" +"PhotosCount": 47 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-16T14:12:04Z" +"Stories": "2.0" +"StreetName": "RAINHAM" +"StreetNumber": "6219" +"StreetSuffix": "Road" +"SubdivisionName": "603 - Sherbrooke" +"TaxAnnualAmount": "2651.47" +"Utilities": array:3 [ 0 => "Natural Gas" 1 => "Electricity" 2 => "Telephone" ] +"VirtualTourURLUnbranded": "https://roomvu.sfo2.digitaloceanspaces.com/video-listing/2026/5/270c4e115dba3fef409a6f842557c184y15nyjaq.mp4" +"WaterSource": array:1 [ 0 => "Cistern" ] +"Rooms": array:18 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] 15 => array:11 [ …11] 16 => array:11 [ …11] 17 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29767465/6219-rainham-road-dunnville" +"ParkingTotal": 5 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "RH" +"BedroomsAboveGrade": 5 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 208.0 +"AboveGradeFinishedArea": 2585 +"BelowGradeFinishedArea": 0 +"OriginalEntryTimestamp": "2026-05-18T23:01:23.85Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"BelowGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1146566" +"ListOfficeNationalAssociationId": "1318170" +"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": 43 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29767465')" +"ID": "1433534" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24529 +post_id: "1443974" +post_author: 1 +"ListingKey": "29783283" +"ListingId": "40831118" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-05T17:00:40Z" +"RFModificationTimestamp": "2026-06-05T17:04:33Z" +"ListPrice": 1178000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 2369.0 +"BuildingAreaTotal": 0 +"City": "Oakville" +"PostalCode": "L6H5K9" +"UnparsedAddress": "1115 AVONDALE Drive, Oakville, Ontario L6H5K9" +"Coordinates": array:2 [ 0 => -79.6968594 1 => 43.4878411 ] +"Latitude": 43.4878411 +"Longitude": -79.6968594 +"YearBuilt": 1988 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to this specious well maintained Freehold townhome located in sought after Wedgewood Creek Neighbourhood. This home features, specious foyer, Eat-In kitchen with loads of cupboards and plenty of counter space. Main level offers a bright living room, additional intended dining space with walkout to private backyard, powder room. Located on a half level above the garage is a large sunny family room with a fireplace, built in cabinets and desk space. Upstairs you will find 3 good size bedrooms and two full bathrooms. Primary bedroom with 4pc ensuite, has added insulation w. QuietRock Drywall on joining wall for improved sound isolation, Triple-glazed window with exceptional thermal insulation/outside sound reduction. The finished lower level with porcelain tiles has dual zone Nuheat radiant floor heating in rec area providing enjoyable atmosphere. Perfect recreation space, built in TV entertainment w. Sound dampened wall, extra Home-Office, built in cabinets with ample storage. Located on this level is laundry room, cold room, multiple storage spaces all with shelves for storing extra items. Parking for 3 cars, double wide driveway, 1.5 garage with insulated garage doors w. door opener and WITH ACCESS TO BACKYARD, custom shelves, plenty of storage space. Backyard is fully fenced with a patio, gazebo, garden lighting, mature plants and water fountain. Upgrades: Main floor hardwood floors, Kiesel’s self-leveling subfloor cement under tile on main level, stone entrance, custom cedar porch soffit with pot lights, smooth ceilings throughout, crown moldings, pot lights, upgraded electrical fixtures/plates/dimmers/timers, window blinds, central vacuum, backyard lighting with programmable timer, updated windows, roof 2018; furnace 2022; AC & water heater 2025. Walking distance to top-rated Iroquois Ridge High School, dog park, baseball diamonds & soccer fields, grocery stores, shops & restaurants; Easy access to Major Highways 403, 407 & QEW. A must see! (id:62650)" +"Appliances": array:10 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water meter" 3 => "Central Vacuum" 4 => "Dishwasher" 5 => "Stove" 6 => "Dryer" 7 => "Window Coverings" 8 => "Garage door opener" 9 => "Microwave Built-in" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-21T16:53:27.548839+00:00" +"ExteriorFeatures": array:2 [ 0 => "Concrete" 1 => "Brick" ] +"FireplaceFeatures": array:2 [ 0 => "Wood" 1 => "Other - See remarks" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1523666" +"ListOfficeKey": "103841" +"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-05-21T22:40:57Z" +"PhotosCount": 41 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-05T16:52:01Z" +"Stories": "2.0" +"StreetName": "AVONDALE" +"StreetNumber": "1115" +"StreetSuffix": "Drive" +"SubdivisionName": "1018 - WC Wedgewood Creek" +"TaxAnnualAmount": "4357" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:19 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] 15 => array:11 [ …11] 16 => array:11 [ …11] 17 => array:11 [ …11] 18 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29783283/1115-avondale-drive-oakville" +"ParkingTotal": 3 +"StructureType": array:1 [ 0 => "Row / Townhouse" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "RM1" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 23.0 +"AboveGradeFinishedArea": 1794 +"BelowGradeFinishedArea": 575 +"OriginalEntryTimestamp": "2026-05-21T15:32:08.6Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1132512" +"ListOfficeNationalAssociationId": "1165450" +"Media": array:41 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] ] +"DaysOnMarket": 41 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29783283')" +"ID": "1443974" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24530 +post_id: "1433475" +post_author: 1 +"ListingKey": "29767487" +"ListingId": "40831117" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T16:30:20Z" +"RFModificationTimestamp": "2026-06-02T16:33:23Z" +"ListPrice": 699900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 1044.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8S1Z3" +"UnparsedAddress": "139 DALEWOOD Avenue, Hamilton, Ontario L8S1Z3" +"Coordinates": array:2 [ 0 => -79.9146182 1 => 43.2556239 ] +"Latitude": 43.2556239 +"Longitude": -79.9146182 +"YearBuilt": 1946 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 139 Dalewood Avenue, a beautiful, meticulously maintained 1.5-storey home situated just an easy 10-minute walk to McMaster University. If you are a parent looking for the perfect, safe, and premium location for your son or daughter while they complete their studies—or a savvy investor looking to add a high-yield asset to your portfolio in Hamilton’s most resilient rental market—this is the property you have been waiting for. Inside, the home offers a bright and functional layout featuring classic wood flooring, updated vinyl windows that flood the rooms with natural light, and a roof that was fully replaced in July 2019 for years of maintenance-free living. The finished basement features durable laminate flooring and excellent ceiling height, highlighted by two spacious rooms equipped with proper egress windows—making it ideal, safe, and comfortable for tenant living or an extended family setup. Located in a pristine, high-demand neighborhood just steps from the McMaster campus, Westdale Village, transit, and amenities, this property offers unparalleled peace of mind for parents and a guaranteed draw for top-tier tenants. Don't miss this rare West End gem! (id:62650)" +"Appliances": array:3 [ 0 => "Refrigerator" 1 => "Dishwasher" 2 => "Stove" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CommunityFeatures": array:1 [ 0 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-19T00:43:53.325989+00:00" +"Directions": "WESTWOOD" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2151612" +"ListOfficeKey": "289618" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Shared Driveway" ] +"ParkingFeatures": array:1 [ 0 => "Open" ] +"PhotosChangeTimestamp": "2026-05-18T23:31:21Z" +"PhotosCount": 29 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:22:04Z" +"Stories": "1.5" +"StreetName": "DALEWOOD" +"StreetNumber": "139" +"StreetSuffix": "Avenue" +"SubdivisionName": "114 - Ainslie Wood East" +"TaxAnnualAmount": "6036" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:12 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29767487/139-dalewood-avenue-hamilton" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "C/S-1335" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 2 +"FrontageLengthNumeric": 46.0 +"AboveGradeFinishedArea": 1044 +"OriginalEntryTimestamp": "2026-05-18T23:31:21.5Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1403340" +"ListOfficeNationalAssociationId": "1379562" +"Media": array:29 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] ] +"DaysOnMarket": 43 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29767487')" +"ID": "1433475" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24524 +post_id: "1442944" +post_author: 1 +"ListingKey": "29781440" +"ListingId": "40831116" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T16:30:30Z" +"RFModificationTimestamp": "2026-06-02T16:32:14Z" +"ListPrice": 589900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.07 +"LivingArea": 1993.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8H5T8" +"UnparsedAddress": "186 ADELINE Avenue, Hamilton, Ontario L8H5T8" +"Coordinates": array:2 [ 0 => -79.7916814 1 => 43.2420285 ] +"Latitude": 43.2420285 +"Longitude": -79.7916814 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Charming all-brick bungalow offering timeless appeal and excellent potential, ideally located in a family-friendly neighbourhood. This well-maintained home features 3+1 bedrooms, 2 full bathrooms, and a bright, functional layout with large windows and inviting living spaces. A separate side entrance provides added flexibility—perfect for extended family or potential in-law suite. Situated on a spacious lot with a private driveway, mature landscaping, and a fully fenced yard for outdoor enjoyment. With great curb appeal and close proximity to schools, parks, and amenities, this is an ideal opportunity for first-time buyers, downsizers, or investors. (id:62650)" +"Appliances": array:4 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Stove" 3 => "Dryer" ] +"ArchitecturalStyle": array:1 [ 0 => "Raised bungalow" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"ConstructionMaterials": array:2 [ 0 => "Concrete block" 1 => "Concrete Walls" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-21T06:52:16.510751+00:00" +"ExteriorFeatures": array:3 [ 0 => "Concrete" 1 => "Brick" 2 => "Other" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2062926" +"ListOfficeKey": "284640" +"LivingAreaUnits": "square feet" +"LotSizeDimensions": "0.07" +"PhotosChangeTimestamp": "2026-05-21T04:00:08Z" +"PhotosCount": 50 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:22:05Z" +"Stories": "1.0" +"StreetName": "ADELINE" +"StreetNumber": "186" +"StreetSuffix": "Avenue" +"SubdivisionName": "232 - Normanhurst" +"TaxAnnualAmount": "4583.9" +"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/29781440/186-adeline-avenue-hamilton" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "C" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 30.0 +"AboveGradeFinishedArea": 1111 +"BelowGradeFinishedArea": 882 +"OriginalEntryTimestamp": "2026-05-21T04:00:08.06Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"BelowGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1337871" +"ListOfficeNationalAssociationId": "1344651" +"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": 41 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29781440')" +"ID": "1442944" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24527 +post_id: "1453928" +post_author: 1 +"ListingKey": "29776756" +"ListingId": "40831115" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T16:30:28Z" +"RFModificationTimestamp": "2026-06-02T16:32:30Z" +"ListPrice": 569900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 1090.0 +"BuildingAreaTotal": 0 +"City": "Lowbanks" +"PostalCode": "N0A1K0" +"UnparsedAddress": "21 VILLELLA Road, Lowbanks, Ontario N0A1K0" +"Coordinates": array:2 [ 0 => -79.5090407 1 => 42.8483933 ] +"Latitude": 42.8483933 +"Longitude": -79.5090407 +"YearBuilt": 1960 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Charming bungalow with stunning Lake Erie views. Sitting on a rare triple lot with 152 ft of frontage, this property offers endless possibilities. The expansive lot/backyard provides the perfect canvas to create an incredible outdoor oasis. Large lot allows for potential to expand the home, add a guest suite, or reimagine the lot entirely. Excellent opportunity for short-term rental or a private lakeside getaway. Attached garage for added convenience. Full of potential — customize with your personal touches and maximize its value. Amazing location near Hippos Marina, Byng Island Park, campgrounds, parks, and more. Newly completed shoreline breakwall built to a high standard, providing lasting shoreline protection and peace of mind — a significant value-add Engineering drawings available upon request. (id:62650)" +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Crawl space" ] +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"Cooling": array:1 [ 0 => "None" ] +"CreationDate": "2026-05-20T18:13:23.280716+00:00" +"Directions": "From Hwy 3, head South on Pyle Rd, continue onto Villella Rd. Property is on the South (water) side" +"ExteriorFeatures": array:1 [ 0 => "Vinyl siding" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:1 [ 0 => "No heat" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1755842" +"ListOfficeKey": "292150" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Country residential" ] +"ParkingFeatures": array:2 [ 0 => "Attached Garage" 1 => "Open" ] +"PhotosChangeTimestamp": "2026-05-20T16:21:15Z" +"PhotosCount": 19 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:22:05Z" +"Stories": "1.0" +"StreetName": "VILLELLA" +"StreetNumber": "21" +"StreetSuffix": "Road" +"SubdivisionName": "603 - Sherbrooke" +"TaxAnnualAmount": "4079" +"View": "Lake view" +"WaterBodyName": "Lake Erie" +"WaterSource": array:1 [ 0 => "Cistern" ] +"Rooms": array:2 [ 0 => array:11 [ …11] 1 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29776756/21-villella-road-lowbanks" +"ParkingTotal": 7 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "2001704" +"CommonInterest": "Freehold" +"CoListOfficeKey": "292003" +"GeocodeManualYN": true +"ZoningDescription": "D A9F1" +"BedroomsAboveGrade": 0 +"BedroomsBelowGrade": 0 +"WaterfrontFeatures": array:1 [ 0 => "Waterfront" ] +"FrontageLengthNumeric": 150.0 +"AboveGradeFinishedArea": 1090 +"OriginalEntryTimestamp": "2026-05-20T16:21:15.41Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1183246" +"ListOfficeNationalAssociationId": "1408460" +"CoListAgentNationalAssociationId": "1285806" +"CoListOfficeNationalAssociationId": "1407357" +"Media": array:19 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] ] +"DaysOnMarket": 42 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29776756')" +"ID": "1453928" } ] +success: true +page_size: 12 +page_count: 16641 +count: 199691 +after_key: "" } "RF Response Time" => "0.35 seconds" ] ]