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=165852&$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 {#24527 +items: array:12 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24657 +post_id: "939465" +post_author: 1 +"ListingKey": "29074225" +"ListingId": "40785950" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-06T14:55:11Z" +"RFModificationTimestamp": "2025-11-06T15:01:57Z" +"ListPrice": 0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 650.0 +"BuildingAreaTotal": 0 +"City": "Brantford" +"PostalCode": "N3T3M8" +"UnparsedAddress": "153 ALBION Street Unit# 4, Brantford, Ontario N3T3M8" +"Coordinates": array:2 [ 0 => -80.27400346 1 => 43.14771565 ] +"Latitude": 43.14771565 +"Longitude": -80.27400346 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc" +"PublicRemarks": "This renovated and bright, one bedroom, main-floor unit is located close to the university and hospital. Conveniently located on the bus route, with street parking available, it's central location is ideal. All applicants must be prepared to sign up to Single Key as well as all other standard Rental Application requirements. (id:62650)" +"Appliances": array:2 [ 0 => "Refrigerator" 1 => "Stove" ] +"AssociationFeeIncludes": array:2 [ 0 => "Heat" 1 => "Water" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Partial" ] +"Cooling": array:1 [ 0 => "None" ] +"CreationDate": "2025-11-06T14:59:21.147368+00:00" +"Directions": "From Brant Ave, turn on to Henrietta and then left on to Albion Street." +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"FoundationDetails": array:1 [ 0 => "Stone" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1985288" +"ListOfficeKey": "291581" +"LivingAreaUnits": "square feet" +"ParkingFeatures": array:1 [ 0 => "None" ] +"PhotosChangeTimestamp": "2025-11-06T14:25:02Z" +"PhotosCount": 8 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2025-11-06T14:44:34Z" +"Stories": "1.0" +"StreetName": "ALBION" +"StreetNumber": "153" +"StreetSuffix": "Street" +"SubdivisionName": "2042 - North Ward" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:4 [ 0 => array:11 [ "RoomKey" => "1530282533" "RoomType" => "4pc Bathroom" "ListingId" => "40785950" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29074225" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-11-06T14:44:35Z" ] 1 => array:11 [ "RoomKey" => "1530282534" "RoomType" => "Bedroom" "ListingId" => "40785950" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29074225" "RoomLength" => null "RoomDimensions" => "11'0'' x 12'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-11-06T14:44:35Z" ] 2 => array:11 [ "RoomKey" => "1530282535" "RoomType" => "Kitchen" "ListingId" => "40785950" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29074225" "RoomLength" => null "RoomDimensions" => "11'6'' x 11'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-11-06T14:44:35Z" ] 3 => array:11 [ "RoomKey" => "1530282536" "RoomType" => "Living room" "ListingId" => "40785950" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29074225" "RoomLength" => null "RoomDimensions" => "11'6'' x 13'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-11-06T14:44:35.01Z" ] ] +"ListAOR": "Brantford" +"ListAORKey": "41" +"ListingURL": "www.realtor.ca/real-estate/29074225/153-albion-street-unit-4-brantford" +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "1534647" +"CommonInterest": "Freehold" +"CoListOfficeKey": "92520" +"TotalActualRent": 1550 +"ZoningDescription": "RC, RC-7" +"BedroomsAboveGrade": 1 +"BedroomsBelowGrade": 0 +"LeaseAmountFrequency": "Monthly" +"FrontageLengthNumeric": 36.0 +"AboveGradeFinishedArea": 650 +"OriginalEntryTimestamp": "2025-11-06T14:25:02.22Z" +"MapCoordinateVerifiedYN": true +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Owner" +"Media": array:8 [ 0 => array:13 [ "Order" => 0 "MediaKey" => "6298686194" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29074225/a4e3620eea63226193e8a9f4abbe102f.webp" "MediaSize" => 152617 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29074225/thumbnail-a4e3620eea63226193e8a9f4abbe102f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "View of front of house with brick siding, roof with shingles, and entry steps" "PreferredPhotoYN" => true "ResourceRecordId" => "40785950" "ResourceRecordKey" => "29074225" "ModificationTimestamp" => "2025-11-06T14:25:02.23Z" ] 1 => array:13 [ "Order" => 1 "MediaKey" => "6298686203" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29074225/39ebf484b6d298eeaa4afbfb90df2177.webp" "MediaSize" => 102124 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29074225/thumbnail-39ebf484b6d298eeaa4afbfb90df2177.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen with white appliances, dark brown cabinets, backsplash, light wood-type flooring, and recessed lighting" "PreferredPhotoYN" => false "ResourceRecordId" => "40785950" "ResourceRecordKey" => "29074225" "ModificationTimestamp" => "2025-11-06T14:25:02.23Z" ] 2 => array:13 [ "Order" => 2 "MediaKey" => "6298686216" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29074225/0b2bfb1ca74b9df5e210fe8616594e78.webp" "MediaSize" => 93821 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29074225/thumbnail-0b2bfb1ca74b9df5e210fe8616594e78.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Unfurnished dining area featuring dark wood-type flooring and recessed lighting" "PreferredPhotoYN" => false "ResourceRecordId" => "40785950" "ResourceRecordKey" => "29074225" "ModificationTimestamp" => "2025-11-06T14:25:02.23Z" ] 3 => array:13 [ "Order" => 3 "MediaKey" => "6298686223" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29074225/9b637c710ca0be40883e31b28ecccc42.webp" "MediaSize" => 64069 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29074225/thumbnail-9b637c710ca0be40883e31b28ecccc42.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Spare room featuring dark wood-style flooring and recessed lighting" "PreferredPhotoYN" => false "ResourceRecordId" => "40785950" "ResourceRecordKey" => "29074225" "ModificationTimestamp" => "2025-11-06T14:25:02.23Z" ] 4 => array:13 [ "Order" => 4 "MediaKey" => "6298686230" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29074225/80e83b87c3cbc8e935f8cf354810c587.webp" "MediaSize" => 42828 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29074225/thumbnail-80e83b87c3cbc8e935f8cf354810c587.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Unfurnished bedroom featuring dark wood-style flooring and recessed lighting" "PreferredPhotoYN" => false "ResourceRecordId" => "40785950" "ResourceRecordKey" => "29074225" "ModificationTimestamp" => "2025-11-06T14:25:02.23Z" ] 5 => array:13 [ "Order" => 5 "MediaKey" => "6298686237" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29074225/f69b30bc55b3d4b743e55da77adb2731.webp" "MediaSize" => 42862 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29074225/thumbnail-f69b30bc55b3d4b743e55da77adb2731.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bathroom featuring vanity and light marble finish flooring" "PreferredPhotoYN" => false "ResourceRecordId" => "40785950" "ResourceRecordKey" => "29074225" "ModificationTimestamp" => "2025-11-06T14:25:02.23Z" ] 6 => array:13 [ "Order" => 6 "MediaKey" => "6298686248" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29074225/5819749597161ee39d882377d1902877.webp" "MediaSize" => 67583 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29074225/thumbnail-5819749597161ee39d882377d1902877.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bathroom with bathing tub / shower combination and vanity" "PreferredPhotoYN" => false "ResourceRecordId" => "40785950" "ResourceRecordKey" => "29074225" "ModificationTimestamp" => "2025-11-06T14:25:02.23Z" ] 7 => array:13 [ "Order" => 7 "MediaKey" => "6298686250" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29074225/dc8adf46c91235ee2fb5946b41c63e1f.webp" "MediaSize" => 150250 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29074225/thumbnail-dc8adf46c91235ee2fb5946b41c63e1f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Deck featuring a fenced backyard and a storage unit" "PreferredPhotoYN" => false "ResourceRecordId" => "40785950" "ResourceRecordKey" => "29074225" "ModificationTimestamp" => "2025-11-06T14:25:02.23Z" ] ] +"DaysOnMarket": 232 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29074225')" +"ID": "939465" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24500 +post_id: "934709" +post_author: 1 +"ListingKey": "29070729" +"ListingId": "40785949" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-05T18:30:40Z" +"RFModificationTimestamp": "2025-11-05T23:49:05Z" +"ListPrice": 834900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1844.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L0R1P0" +"UnparsedAddress": "1890 RYMAL Road E Unit# 35, Hamilton, Ontario L0R1P0" +"Coordinates": array:2 [ 0 => -79.81356452 1 => 43.18158558 ] +"Latitude": 43.18158558 +"Longitude": -79.81356452 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to unit 35-1890 Rymal Rd E. by Branthaven. This Crave model is 1830sq ft above grade with a finished basement. Main floor is drenched with natural lights and lots of pot lights throughout with 9 ft ceilings, chefs style kitchen and large outdoor stone scaped patio with southwest exposure. On the upper floor there is 3 bed, 2 baths and a laundry room, large Primary has ensuite and 2 generously sized bedrooms with shared bathroom. The Lower level has been finished with a kitchenette and 3-piece bath, large rec room and lots of storage spaces and a cold cellar. Other features include wood stairs with iron pickets, fully fenced private backyard, parking, close to guest parking. Don’t wait!! (id:62650)" +"Appliances": array:5 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Central Vacuum" 3 => "Stove" 4 => "Dryer" ] +"ArchitecturalStyle": array:1 [ 0 => "2 Level" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2025-11-05T23:41:59.530579+00:00" +"Directions": "UPPER RED HILL VALLEY PARKWAY TO RYMAL RD E" +"ExteriorFeatures": array:3 [ 0 => "Brick" 1 => "Stone" 2 => "Stucco" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1524158" +"ListOfficeKey": "279441" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2025-11-05T18:20:10Z" +"PhotosCount": 26 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2025-11-05T18:20:10Z" +"Stories": "2.0" +"StreetDirSuffix": "East" +"StreetName": "RYMAL" +"StreetNumber": "1890" +"StreetSuffix": "Road" +"SubdivisionName": "052 - Stoney Creek Escarpment" +"TaxAnnualAmount": "4091.12" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:13 [ 0 => array:11 [ "RoomKey" => "1529731352" "RoomType" => "Kitchen" "ListingId" => "40785949" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29070729" "RoomLength" => null "RoomDimensions" => "7'5'' x 15'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-11-05T18:20:10.84Z" ] 1 => array:11 [ "RoomKey" => "1529731353" "RoomType" => "3pc Bathroom" "ListingId" => "40785949" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29070729" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-11-05T18:20:10.84Z" ] 2 => array:11 [ "RoomKey" => "1529731354" "RoomType" => "Family room" "ListingId" => "40785949" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29070729" "RoomLength" => null "RoomDimensions" => "10'0'' x 18'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-11-05T18:20:10.84Z" ] 3 => array:11 [ "RoomKey" => "1529731355" "RoomType" => "5pc Bathroom" "ListingId" => "40785949" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29070729" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-11-05T18:20:10.85Z" ] 4 => array:11 [ "RoomKey" => "1529731356" "RoomType" => "Laundry room" "ListingId" => "40785949" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29070729" "RoomLength" => null "RoomDimensions" => "5'5'' x 7'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-11-05T18:20:10.85Z" ] 5 => array:11 [ "RoomKey" => "1529731357" "RoomType" => "Bedroom" "ListingId" => "40785949" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29070729" "RoomLength" => null "RoomDimensions" => "12'8'' x 9'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-11-05T18:20:10.85Z" ] 6 => array:11 [ "RoomKey" => "1529731358" "RoomType" => "Bedroom" "ListingId" => "40785949" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29070729" "RoomLength" => null "RoomDimensions" => "12'2'' x 9'3''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-11-05T18:20:10.85Z" ] 7 => array:11 [ "RoomKey" => "1529731359" "RoomType" => "3pc Bathroom" "ListingId" => "40785949" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29070729" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-11-05T18:20:10.85Z" ] 8 => array:11 [ "RoomKey" => "1529731360" "RoomType" => "Bedroom" "ListingId" => "40785949" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29070729" "RoomLength" => null "RoomDimensions" => "14'11'' x 11'11''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-11-05T18:20:10.85Z" ] 9 => array:11 [ "RoomKey" => "1529731361" "RoomType" => "2pc Bathroom" "ListingId" => "40785949" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29070729" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-11-05T18:20:10.85Z" ] 10 => array:11 [ "RoomKey" => "1529731362" "RoomType" => "Dining room" "ListingId" => "40785949" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29070729" "RoomLength" => null "RoomDimensions" => "10'11'' x 8'11''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-11-05T18:20:10.85Z" ] 11 => array:11 [ "RoomKey" => "1529731363" "RoomType" => "Kitchen" "ListingId" => "40785949" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29070729" "RoomLength" => null "RoomDimensions" => "12'1'' x 9'11''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-11-05T18:20:10.85Z" ] 12 => array:11 [ "RoomKey" => "1529731364" "RoomType" => "Family room" "ListingId" => "40785949" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29070729" "RoomLength" => null "RoomDimensions" => "18'11'' x 12'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-11-05T18:20:10.85Z" ] ] +"ListAOR": "Cornerstone - Hamilton-Burlington" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29070729/1890-rymal-road-e-unit-35-hamilton" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "Row / Townhouse" ] +"CoListAgentKey": "1644333" +"CommonInterest": "Freehold" +"CoListOfficeKey": "279441" +"ZoningDescription": "C1-205" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 25.0 +"AboveGradeFinishedArea": 1844 +"OriginalEntryTimestamp": "2025-11-05T18:20:10.74Z" +"MapCoordinateVerifiedYN": true +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"Media": array:26 [ 0 => array:13 [ "Order" => 0 "MediaKey" => "6296838999" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/06f5e6dec5ac8e33fa200870dc2abad4.webp" "MediaSize" => 42780 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-06f5e6dec5ac8e33fa200870dc2abad4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 1 => array:13 [ "Order" => 1 "MediaKey" => "6296839041" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/8ad6a727b737fa047f981a43751941b9.webp" "MediaSize" => 75420 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-8ad6a727b737fa047f981a43751941b9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 2 => array:13 [ "Order" => 2 "MediaKey" => "6296839089" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/93af840e5555f71dfa13e1f22ead2464.webp" "MediaSize" => 99595 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-93af840e5555f71dfa13e1f22ead2464.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 3 => array:13 [ "Order" => 3 "MediaKey" => "6296839148" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/ff4c83dbe2f88ec3ad1cd09afd5071cc.webp" "MediaSize" => 48499 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-ff4c83dbe2f88ec3ad1cd09afd5071cc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 4 => array:13 [ "Order" => 4 "MediaKey" => "6296839149" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/674060634f21e4a1584d73f053a6b824.webp" "MediaSize" => 51024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-674060634f21e4a1584d73f053a6b824.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 5 => array:13 [ "Order" => 5 "MediaKey" => "6296839238" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/15d5722b53e93bc57907da12f34b1d43.webp" "MediaSize" => 114598 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-15d5722b53e93bc57907da12f34b1d43.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 6 => array:13 [ "Order" => 6 "MediaKey" => "6296839254" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/53fe997c4c0b1485727a94aa07290d18.webp" "MediaSize" => 93600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-53fe997c4c0b1485727a94aa07290d18.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 7 => array:13 [ "Order" => 7 "MediaKey" => "6296839306" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/537065cc10e8e4dabd6c73852195c7e3.webp" "MediaSize" => 44449 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-537065cc10e8e4dabd6c73852195c7e3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 8 => array:13 [ "Order" => 8 "MediaKey" => "6296839324" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/3d31a9a884e557feb1f259c5f5994a87.webp" "MediaSize" => 88204 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-3d31a9a884e557feb1f259c5f5994a87.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 9 => array:13 [ "Order" => 9 "MediaKey" => "6296839359" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/747bb4e33f0ce7beba508f264668413c.webp" "MediaSize" => 95325 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-747bb4e33f0ce7beba508f264668413c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 10 => array:13 [ "Order" => 10 "MediaKey" => "6296839371" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/41a416a118ccd9dd9a6f6c4a8b3d7943.webp" "MediaSize" => 36475 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-41a416a118ccd9dd9a6f6c4a8b3d7943.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 11 => array:13 [ "Order" => 11 "MediaKey" => "6296839375" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/8e38e93a6aa61bf4f29fb6a7f1a83526.webp" "MediaSize" => 82706 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-8e38e93a6aa61bf4f29fb6a7f1a83526.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 12 => array:13 [ "Order" => 12 "MediaKey" => "6296839470" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/d162e1f1b24af9265c976abcfcd05e7c.webp" "MediaSize" => 156952 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-d162e1f1b24af9265c976abcfcd05e7c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 13 => array:13 [ "Order" => 13 "MediaKey" => "6296839471" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/63f1b5fcd5446e8416c8e2082093e053.webp" "MediaSize" => 41041 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-63f1b5fcd5446e8416c8e2082093e053.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 14 => array:13 [ "Order" => 14 "MediaKey" => "6296839629" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/7fc6558438daba95e3e6f9c86b012028.webp" "MediaSize" => 76140 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-7fc6558438daba95e3e6f9c86b012028.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 15 => array:13 [ "Order" => 15 "MediaKey" => "6296839694" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/aa3613816926691f0abdce321bea3392.webp" "MediaSize" => 42570 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-aa3613816926691f0abdce321bea3392.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 16 => array:13 [ "Order" => 16 "MediaKey" => "6296839695" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/9615012a58bba4ec43de88af6d71a0d2.webp" "MediaSize" => 37449 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-9615012a58bba4ec43de88af6d71a0d2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 17 => array:13 [ "Order" => 17 "MediaKey" => "6296839776" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/464e2ac3cd7e980b994bcbe22e5dce8d.webp" "MediaSize" => 35092 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-464e2ac3cd7e980b994bcbe22e5dce8d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 18 => array:13 [ "Order" => 18 "MediaKey" => "6296839785" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/1b51aa7fc7b2948c68b8757bd2bf1ca8.webp" "MediaSize" => 36524 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-1b51aa7fc7b2948c68b8757bd2bf1ca8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 19 => array:13 [ "Order" => 19 "MediaKey" => "6296839800" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/f9e2a73e75ba8f6ee352c83a1d3f541b.webp" "MediaSize" => 30407 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-f9e2a73e75ba8f6ee352c83a1d3f541b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 20 => array:13 [ "Order" => 20 "MediaKey" => "6296839837" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/d7ee89b8d3108420083da3ee50c75efc.webp" "MediaSize" => 72903 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-d7ee89b8d3108420083da3ee50c75efc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 21 => array:13 [ "Order" => 21 "MediaKey" => "6296839848" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/1176f2f9b0a2b277921fcb5a3e09dedc.webp" "MediaSize" => 86173 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-1176f2f9b0a2b277921fcb5a3e09dedc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 22 => array:13 [ "Order" => 22 "MediaKey" => "6296839874" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/ef1f9a1fa6eb3c54df23547c87b59df0.webp" "MediaSize" => 35384 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-ef1f9a1fa6eb3c54df23547c87b59df0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 23 => array:13 [ "Order" => 23 "MediaKey" => "6296839881" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/024b06ae1c7a9727d21164a8832e6678.webp" "MediaSize" => 75487 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-024b06ae1c7a9727d21164a8832e6678.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 24 => array:13 [ "Order" => 24 "MediaKey" => "6296839904" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/f234ec3a561ba0770bcf9305efe6b711.webp" "MediaSize" => 34106 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-f234ec3a561ba0770bcf9305efe6b711.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] 25 => array:13 [ "Order" => 25 "MediaKey" => "6296839947" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070729/20480e207eed94965c733ef74d4e002a.webp" "MediaSize" => 76600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070729/thumbnail-20480e207eed94965c733ef74d4e002a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785949" "ResourceRecordKey" => "29070729" "ModificationTimestamp" => "2025-11-05T18:20:10.75Z" ] ] +"DaysOnMarket": 233 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29070729')" +"ID": "934709" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24645 +post_id: "934913" +post_author: 1 +"ListingKey": "29070732" +"ListingId": "40785910" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-07T21:40:50Z" +"RFModificationTimestamp": "2026-02-07T21:44:13Z" +"ListPrice": 799900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 2 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1985.0 +"BuildingAreaTotal": 0 +"City": "St. Catharines" +"PostalCode": "L2W0A3" +"UnparsedAddress": "56 VIDEL Crescent N, St. Catharines, Ontario L2W0A3" +"Coordinates": array:2 [ 0 => -79.27845106 1 => 43.15985735 ] +"Latitude": 43.15985735 +"Longitude": -79.27845106 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 56 Videl Crescent North, an immaculately maintained one-owner bungaloft tucked away in the prestigious Grapeview neighbourhood of St. Catharines. Offering almost 2,000 sq. ft. of beautifully finished living space, this residence radiates pride of ownership and timeless comfort from the moment you arrive. Step inside and feel the calm sophistication of the soaring vaulted ceilings and engineered hardwood floors, where natural light dances across the open-concept living and dining areas. The kitchen—complete with stainless-steel appliances and thoughtful finishes—invites you to gather, cook, and connect. Your main-floor primary retreat offers a peaceful escape, featuring a walk-in closet and private ensuite designed for comfort and ease. Upstairs, the loft provides a cozy vantage point overlooking the living space—perfect for reading, reflection, or quiet conversation—alongside two generous bedrooms and a full bath for family or guests. The fully finished basement extends your living experience with a warm, welcoming family room, a wet bar for entertaining, and a workshop ready for your next creative project. Nestled on a quiet dead-end street, surrounded by mature trees and moments from top schools, parks, shopping, and highway access, this home offers not just a place to live—but a place to belong. (id:62650)" +"Appliances": array:8 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Central Vacuum" 3 => "Stove" 4 => "Dryer" 5 => "Wet Bar" 6 => "Window Coverings" 7 => "Microwave Built-in" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 2 +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2025-11-05T23:42:22.072673+00:00" +"Directions": "Off First Street Louth, turn west on Videl Cres" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1524224" +"ListOfficeKey": "275989" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Cul-de-sac" 1 => "Conservation/green belt" 2 => "Wet bar" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2025-11-05T18:20:14Z" +"PhotosCount": 34 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-02-07T21:22:22Z" +"Stories": "1.5" +"StreetDirSuffix": "North" +"StreetName": "VIDEL" +"StreetNumber": "56" +"StreetSuffix": "Crescent" +"SubdivisionName": "453 - Grapeview" +"TaxAnnualAmount": "7365" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:13 [ 0 => array:11 [ "RoomKey" => "1570774096" "RoomType" => "2pc Bathroom" "ListingId" => "40785910" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29070732" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-02-07T21:22:22.58Z" ] 1 => array:11 [ "RoomKey" => "1570774097" "RoomType" => "Family room" "ListingId" => "40785910" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29070732" "RoomLength" => null "RoomDimensions" => "24'0'' x 26'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-02-07T21:22:22.58Z" ] 2 => array:11 [ "RoomKey" => "1570774098" "RoomType" => "3pc Bathroom" "ListingId" => "40785910" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29070732" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-02-07T21:22:22.59Z" ] 3 => array:11 [ "RoomKey" => "1570774099" "RoomType" => "Bedroom" "ListingId" => "40785910" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29070732" "RoomLength" => null "RoomDimensions" => "21'4'' x 9'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-02-07T21:22:22.59Z" ] 4 => array:11 [ "RoomKey" => "1570774100" "RoomType" => "Bedroom" "ListingId" => "40785910" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29070732" "RoomLength" => null "RoomDimensions" => "16'10'' x 12'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-02-07T21:22:22.6Z" ] 5 => array:11 [ "RoomKey" => "1570774101" "RoomType" => "Full bathroom" "ListingId" => "40785910" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29070732" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-02-07T21:22:22.6Z" ] 6 => array:11 [ "RoomKey" => "1570774102" "RoomType" => "Primary Bedroom" "ListingId" => "40785910" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29070732" "RoomLength" => null "RoomDimensions" => "12'0'' x 16'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-02-07T21:22:22.6Z" ] 7 => array:11 [ "RoomKey" => "1570774103" "RoomType" => "2pc Bathroom" "ListingId" => "40785910" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29070732" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-02-07T21:22:22.61Z" ] 8 => array:11 [ "RoomKey" => "1570774104" "RoomType" => "Foyer" "ListingId" => "40785910" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29070732" "RoomLength" => null "RoomDimensions" => "9'0'' x 11'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-02-07T21:22:22.61Z" ] 9 => array:11 [ "RoomKey" => "1570774105" "RoomType" => "Laundry room" "ListingId" => "40785910" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29070732" "RoomLength" => null "RoomDimensions" => "6'0'' x 8'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-02-07T21:22:22.62Z" ] 10 => array:11 [ "RoomKey" => "1570774106" "RoomType" => "Kitchen" "ListingId" => "40785910" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29070732" "RoomLength" => null "RoomDimensions" => "8'2'' x 10'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-02-07T21:22:22.62Z" ] 11 => array:11 [ "RoomKey" => "1570774107" "RoomType" => "Dining room" "ListingId" => "40785910" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29070732" "RoomLength" => null "RoomDimensions" => "9'0'' x 12'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-02-07T21:22:22.63Z" ] 12 => array:11 [ "RoomKey" => "1570774108" "RoomType" => "Great room" "ListingId" => "40785910" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29070732" "RoomLength" => null "RoomDimensions" => "12'6'' x 16'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-02-07T21:22:22.63Z" ] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29070732/56-videl-crescent-n-st-catharines" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "Row / Townhouse" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R1" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 34.0 +"AboveGradeFinishedArea": 1985 +"OriginalEntryTimestamp": "2025-11-05T18:20:14.27Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1064132" +"ListOfficeNationalAssociationId": "1269881" +"Media": array:34 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "6316654745" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070732/ad0f63cf52191cab6d75d3c0b8de3869.webp" "MediaSize" => 133262 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070732/thumbnail-ad0f63cf52191cab6d75d3c0b8de3869.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "40785910" "ResourceRecordKey" => "29070732" "ModificationTimestamp" => "2025-11-05T18:20:14.28Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "6316654747" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070732/6deefc489c964248b66ba6f3a1f8983f.webp" "MediaSize" => 92873 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070732/thumbnail-6deefc489c964248b66ba6f3a1f8983f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40785910" "ResourceRecordKey" => "29070732" "ModificationTimestamp" => "2025-11-05T18:20:14.28Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "6316654750" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070732/70a858e11fadfe94e8f5faa9ed70d16f.webp" "MediaSize" => 94791 "MediaType" => "webp" …8 ] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] ] +"DaysOnMarket": 233 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29070732')" +"ID": "934913" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24522 +post_id: "934766" +post_author: 1 +"ListingKey": "29070736" +"ListingId": "40785892" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-01-02T15:15:57Z" +"RFModificationTimestamp": "2026-01-02T15:16:55Z" +"ListPrice": 755000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2085.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9B0C6" +"UnparsedAddress": "6 ATESSA Drive, Hamilton, Ontario L9B0C6" +"Coordinates": array:2 [ 0 => -79.88624168 1 => 43.20178962 ] +"Latitude": 43.20178962 +"Longitude": -79.88624168 +"YearBuilt": 2010 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Location! Gorgeous corner lot townhouse in the desirable Mountain area. Featuring 9-ft ceilings on the main floor, ceramic tiles, hardwood flooring, and a solid oak staircase. The kitchen is equipped with stainless steel appliances and opens to a bright dining room with walkout to a fully fenced backyard perfect for outdoor entertaining. Upstairs boasts 3 spacious bedrooms and 2 full bathrooms. A primary bedroom with its own 4-piece ensuite and walk-in closet. Convenient second-floor laundry room. The lower level includes a rec room, bedroom and a 3-piece bathroom, Additional features include a double driveway and 1.5-car garage with inside entry. Located close to all amenities, schools, shopping, and with easy highway access. This home offers comfort, convenience, and excellent value. $134.34 monthly condo fee Includes Snow Removal, Common Ground Maintenance & Building Insurance. (id:62650)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Freezer" 6 => "Microwave Built-in" ] +"ArchitecturalStyle": array:1 [ 0 => "2 Level" ] +"AssociationFeeIncludes": array:2 [ 0 => "Landscaping" 1 => "Insurance" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CommunityFeatures": array:2 [ 0 => "School Bus" 1 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2025-11-05T23:42:26.182809+00:00" +"Directions": "Upper James to Rymal to Atessa" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Stone" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1773923" +"ListOfficeKey": "67816" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Southern exposure" 1 => "Balcony" 2 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2025-11-27T14:11:07Z" +"PhotosCount": 35 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-01-02T15:02:04Z" +"Stories": "2.0" +"StreetName": "ATESSA" +"StreetNumber": "6" +"StreetSuffix": "Drive" +"SubdivisionName": "184 - Jerome/Ryckman's Cors" +"TaxAnnualAmount": "5674" +"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/29070736/6-atessa-drive-unit-6-hamilton" +"ParkingTotal": 3 +"StructureType": array:1 [ 0 => "Row / Townhouse" ] +"CommonInterest": "Condo/Strata" +"GeocodeManualYN": true +"ZoningDescription": "RT-20" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 0.0 +"AboveGradeFinishedArea": 1465 +"BelowGradeFinishedArea": 620 +"OriginalEntryTimestamp": "2025-11-05T18:20:15.15Z" +"MapCoordinateVerifiedYN": true +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"BelowGradeFinishedAreaSource": "Plans" +"Media": array:35 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] ] +"DaysOnMarket": 233 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29070736')" +"ID": "934766" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24514 +post_id: "947350" +post_author: 1 +"ListingKey": "29074226" +"ListingId": "40785841" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-06T14:30:55Z" +"RFModificationTimestamp": "2025-11-07T01:06:13Z" +"ListPrice": 784919.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 850.0 +"BuildingAreaTotal": 0 +"City": "Turkey Point" +"PostalCode": "N0E1T0" +"UnparsedAddress": "7 PELLUM Street, Turkey Point, Ontario N0E1T0" +"Coordinates": array:2 [ 0 => -80.3329147 1 => 42.68129501 ] +"Latitude": 42.68129501 +"Longitude": -80.3329147 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc" +"PublicRemarks": "Welcome to 7 Pellum Street, a charming and beautifully appointed 2-bedroom, 1-bathroom all-season cottage nestled in the delightful community of Turkey Point, built in 2022. Located on a tranquil dead-end street, this home offers a serene and picturesque setting. Step inside to discover soaring vaulted ceilings, expansive bright windows that flood the home with natural light, and exquisite custom trim that adds a touch of elegance. Durable, easy-to-maintain vinyl plank flooring flows seamlessly throughout, enhancing the home's modern appeal. The open-concept kitchen, living, and dining area is anchored by a cozy electric fireplace with a rustic wood mantle, creating a warm and inviting atmosphere. The chef's kitchen is equipped with sleek stainless steel appliances, subway tile backsplash, and a large butcher block island offering both style and functionality. For year-round comfort, a heat pump and additional electric heaters in the bedrooms ensure a perfect climate, no matter the season. An efficient on-demand hot water heater further elevates convenience and eco-friendliness in daily living. Outside, the expansive yard invites you to relax or entertain in style, with a spacious deck and a charming fire-pit area, ideal for cozy evenings under the stars. A brand-new septic system provides added peace of mind, ensuring worry-free living. Most furnishings will remain, making this property completely move-in ready, whether you’re seeking a year-round home or a peaceful weekend retreat. Just a short 4-minute walk to the nearest beach access point, this home offers the best of both comfort and location. Don’t miss your chance to own your very own slice of Turkey Point paradise! Schedule your private showing toda (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Microwave" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:1 [ 0 => "None" ] +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"CreationDate": "2025-11-07T00:58:12.975017+00:00" +"Directions": "Travelling south on Cedar Street, turn right onto Pellum Street." +"ExteriorFeatures": array:1 [ 0 => "Vinyl siding" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Heat Pump" 1 => "Electric" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2013964" +"ListOfficeKey": "280719" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Southern exposure" 1 => "Country residential" ] +"PhotosChangeTimestamp": "2025-11-06T14:25:02Z" +"PhotosCount": 18 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2025-11-06T14:25:02Z" +"Stories": "1.0" +"StreetName": "PELLUM" +"StreetNumber": "7" +"StreetSuffix": "Street" +"SubdivisionName": "Turkey Point" +"TaxAnnualAmount": "3970" +"VirtualTourURLUnbranded": "https://youtu.be/AxIXewAkofc" +"WaterSource": array:1 [ 0 => "Well" ] +"Rooms": array:6 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] ] +"ListAOR": "Brantford" +"ListAORKey": "41" +"ListingURL": "www.realtor.ca/real-estate/29074226/7-pellum-street-turkey-point" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"ZoningDescription": "L" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 65.0 +"AboveGradeFinishedArea": 850 +"OriginalEntryTimestamp": "2025-11-06T14:25:02.57Z" +"MapCoordinateVerifiedYN": true +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Owner" +"Media": array:18 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] ] +"DaysOnMarket": 232 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29074226')" +"ID": "947350" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24641 +post_id: "952326" +post_author: 1 +"ListingKey": "29090589" +"ListingId": "40785837" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-16T22:15:37Z" +"RFModificationTimestamp": "2025-11-18T01:08:57Z" +"ListPrice": 1349900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 3809.0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2T1H6" +"UnparsedAddress": "455 WINCHESTER Drive, Waterloo, Ontario N2T1H6" +"Coordinates": array:2 [ 0 => -80.55956448 1 => 43.45544554 ] +"Latitude": 43.45544554 +"Longitude": -80.55956448 +"YearBuilt": 1983 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 455 Winchester Drive! A beautifully updated 4-bedroom home in Waterloo’s Beechwood West, offering nearly 2,500 sq. ft. of refined living plus a finished basement. With its mature lot, double garage, and stylish updates throughout, it’s the perfect blend of space, comfort, and sophistication. Check out our TOP 7 reasons why this home could be the one for you: #7: BEECHWOOD WEST: Located in one of Waterloo’s most desirable neighbourhoods, Beechwood West is known for its quiet streets, mature trees, and strong community atmosphere. You’re minutes from top-rated schools, scenic trails, community pool & tennis courts plus local parks. #6: CURB APPEAL & LOT: From the extended double driveway to the inviting covered porch, this home makes a beautiful first impression. #5: MAIN FLOOR LAYOUT: The bright, open main floor features luxury vinyl plank flooring and plenty of pot lights throughout. You’ll also find a cozy family room with a wood-burning fireplace and main-floor laundry. #4: STYLISH EAT-IN KITCHEN: The updated kitchen features quartz countertops, S/S appliances, under counter lighting and an elegant waterfall island. Just off the kitchen, enjoy a formal dining room while a bright dinette with a walkout to the deck provides effortless indoor-outdoor living. #3: FULLY-FENCED BACKYARD: Host summer BBQs on the deck, unwind in the hot tub, or enjoy a good book beneath mature trees. #2: BEDROOMS & BATHROOMS: The primary suite offers a walk-in closet with custom built-ins, and a private 5-piece ensuite with double sinks and dual shower heads. #1: FINISHED BASEMENT: The expansive, carpet-free basement adds impressive versatility, featuring two large rec rooms illuminated by abundant pot lights. One includes a stylish feature wall and fireplace, while the other boasts a sleek wet bar. A flexible bonus room makes an ideal home gym or office, and you’ll also find an oversized cold cellar plus an updated 3-piece bathroom with heated floors and a walk-in shower. (id:62650)" +"Appliances": array:11 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Hot Tub" 4 => "Central Vacuum" 5 => "Dishwasher" 6 => "Stove" 7 => "Dryer" 8 => "Wet Bar" 9 => "Hood Fan" 10 => "Garage door opener" ] +"ArchitecturalStyle": array:1 [ 0 => "2 Level" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2025-11-11T15:21:16.481463+00:00" +"Directions": "Fischer Hallman Drive N to Winchester Drive or Keats Way to Winchester" +"ExteriorFeatures": array:1 [ 0 => "Aluminum siding" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1970915" +"ListOfficeKey": "290168" +"LivingAreaUnits": "square feet" +"LotFeatures": array:5 [ 0 => "Wet bar" 1 => "Paved driveway" 2 => "Sump Pump" 3 => "Automatic Garage Door Opener" 4 => "Private Yard" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2025-11-11T14:38:25Z" +"PhotosCount": 50 +"PoolFeatures": array:1 [ 0 => "Pool" ] +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2025-11-16T22:00:20Z" +"Stories": "2.0" +"StreetName": "WINCHESTER" +"StreetNumber": "455" +"StreetSuffix": "Drive" +"SubdivisionName": "440 - Upper Beechwood/Beechwood W." +"TaxAnnualAmount": "8125" +"Utilities": array:4 [ 0 => "Natural Gas" 1 => "Electricity" 2 => "Cable" 3 => "Telephone" ] +"VirtualTourURLUnbranded": "https://youriguide.com/455_winchester_dr_waterloo_on/" +"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/29090589/455-winchester-drive-waterloo" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "R-1" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 86.0 +"AboveGradeFinishedArea": 2658 +"BelowGradeFinishedArea": 1151 +"OriginalEntryTimestamp": "2025-11-11T14:38:25.15Z" +"MapCoordinateVerifiedYN": true +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"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": 227 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29090589')" +"ID": "952326" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24640 +post_id: "936154" +post_author: 1 +"ListingKey": "29072465" +"ListingId": "40785834" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-14T20:50:00Z" +"RFModificationTimestamp": "2026-06-14T20:52:28Z" +"ListPrice": 698000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1449.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8M3G3" +"UnparsedAddress": "105 ROTHSAY Avenue, Hamilton, Ontario L8M3G3" +"Coordinates": array:2 [ 0 => -79.82622044 1 => 43.24012562 ] +"Latitude": 43.24012562 +"Longitude": -79.82622044 +"YearBuilt": 1926 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 105 Rothsay, a beautifully renovated 1-3/4 storey home in one of Hamilton's most family-friendly neighbourhoods! This stunning 3 bed, 3 full bath residence offers a perfect blend of modern comfort and timeless charm. Step inside to find a bright, open concept layout featuring a brand new kitchen with stylish finishes, all new flooring, and thoroughly updated electrical throughout. Enjoy peace of mind with a new furnace, central AC and hot water tank. Everything has been done so you can simply move in and enjoy. The spacious bedrooms and fully finished bathrooms make this home ideal for families of all sizes. Located in the heart of Gage Park, great schools, public transit and shopping. A perfect home for a growing family or first-time homebuyers looking for quality and convenience on a beautiful street where homes rarely become available. Please note this home includes a shared driveway and has ample street parking. (id:62650)" +"Appliances": array:5 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Gas stove(s)" 3 => "Dishwasher" 4 => "Dryer" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"CommunityFeatures": array:3 [ 0 => "Quiet Area" 1 => "School Bus" 2 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2025-11-06T07:42:31.418224+00:00" +"Directions": "Lawrence Road to Rothsay" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Aluminum siding" ] +"Fencing": array:1 [ 0 => "Fence" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1981716" +"ListOfficeKey": "299866" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Conservation/green belt" 1 => "Shared Driveway" 2 => "Private Yard" ] +"PhotosChangeTimestamp": "2026-05-22T19:22:12Z" +"PhotosCount": 41 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-14T20:41:31Z" +"Stories": "2.0" +"StreetName": "ROTHSAY" +"StreetNumber": "105" +"StreetSuffix": "Avenue" +"SubdivisionName": "221 - Gage Park" +"TaxAnnualAmount": "3702.17" +"Utilities": array:3 [ 0 => "Natural Gas" 1 => "Cable" 2 => "Telephone" ] +"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/29072465/105-rothsay-avenue-hamilton" +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "2151051" +"CommonInterest": "Freehold" +"CoListOfficeKey": "299867" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "D" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 22.0 +"AboveGradeFinishedArea": 1130 +"BelowGradeFinishedArea": 319 +"OriginalEntryTimestamp": "2025-11-05T22:00:46.96Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1267128" +"ListOfficeNationalAssociationId": "1477944" +"CoListAgentNationalAssociationId": "1402088" +"CoListOfficeNationalAssociationId": "1477945" +"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": 232 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29072465')" +"ID": "936154" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25059 +post_id: "935040" +post_author: 1 +"ListingKey": "29069490" +"ListingId": "40785817" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T17:35:42Z" +"RFModificationTimestamp": "2026-06-02T18:13:17Z" +"ListPrice": 799900.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0.195 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterdown" +"PostalCode": "L8B0E8" +"UnparsedAddress": "24 BERRY HILL Avenue, Waterdown, Ontario L8B0E8" +"Coordinates": array:2 [ 0 => -79.89674798 1 => 43.32712753 ] +"Latitude": 43.32712753 +"Longitude": -79.89674798 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Stunning Lot in Waterdown (61.5' X 137')* Located steps from Waterdown’s downtown, this prime lot offers a unique development opportunity, nestled on a quiet closed avenue (cul-de-sac). With services available at the road and a full plan/permit package included, it’s ready for your custom dream home. Just minutes from parks, schools, shops, trails, and easy access to highways, it’s a rare chance to buy and hold or build now, as property values rise in this flourishing area. *Original Design* Development charges are already paid, and permits are approved for a single detached home of up to 4,000 sq ft with a walk-out basement. Architectural drawings are ready. *New Design* The new plans include a main floor bedroom with a walk-in closet and ensuite, ideal as an in-law suite. A separate spice kitchen adds convenience. The second floor features two master bedrooms with ensuites, plus a loft that can be converted into a fifth bedroom, opening to a covered balcony. Each bedroom has a walk-in closet and ensuite, ensuring privacy and comfort. This lot offers flexibility and potential, whether you’re ready to build or looking for an investment opportunity in a flourishing area. (id:62650)" +"Basement": array:1 [ 0 => "None" ] +"CreationDate": "2025-11-06T01:17:50.129630+00:00" +"Directions": "403/Hwy 6/ Dundas/ Berryhill" +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2147155" +"ListOfficeKey": "67816" +"LotFeatures": array:1 [ 0 => "Visual exposure" ] +"LotSizeDimensions": "0.195" +"PhotosChangeTimestamp": "2025-11-05T15:49:19Z" +"PhotosCount": 25 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T17:01:44Z" +"StreetName": "BERRY HILL" +"StreetNumber": "24" +"StreetSuffix": "Avenue" +"SubdivisionName": "460 - Waterdown West" +"TaxAnnualAmount": "3466" +"Utilities": array:2 [ 0 => "Natural Gas" 1 => "Cable" ] +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29069490/24-berry-hill-avenue-waterdown" +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R1-2" +"FrontageLengthNumeric": 62.0 +"OriginalEntryTimestamp": "2025-11-05T15:49:19.29Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1398255" +"ListOfficeNationalAssociationId": "1132083" +"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": 233 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29069490')" +"ID": "935040" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24524 +post_id: "940575" +post_author: 1 +"ListingKey": "29074179" +"ListingId": "40785774" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-16T21:45:25Z" +"RFModificationTimestamp": "2025-11-18T01:28:17Z" +"ListPrice": 599900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1230.0 +"BuildingAreaTotal": 0 +"City": "Kitchener" +"PostalCode": "N2M1A7" +"UnparsedAddress": "860 QUEENS Boulevard, Kitchener, Ontario N2M1A7" +"Coordinates": array:2 [ 0 => -80.49977953 1 => 43.43973396 ] +"Latitude": 43.43973396 +"Longitude": -80.49977953 +"YearBuilt": 1935 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 860 Queen’s Boulevard, a home that perfectly balances classic character with modern comfort in one of Kitchener’s most desirable settings. Nestled along the prestigious, tree-lined Queen’s Boulevard, this charming 3 bedroom, 1 bathroom residence captures the timeless appeal of a bygone era with the conveniences today’s buyers love. Step inside to find leaded glass windows and doors, coffered ceilings, and wide trim, touches that add warmth and charm throughout the home. The renovated kitchen blends seamlessly with these traditional elements, featuring a large peninsula, stainless-steel appliances, undermount sink, and soft-close cabinetry and drawers that offer both style and function. Flowing effortlessly into the spacious dining room, this is the ideal space for hosting family gatherings or dinner parties. The updated bathroom feels like a spa retreat, showcasing a glass-walled walk-in shower and a stand-alone soaker tub, the perfect combination of luxury and relaxation. The private backyard with mature trees, flagstone patio and a gas line for the BBQ, make hosting summer gatherings a breeze. Beyond the home itself, the location is exceptional. Enjoy strolling or cycling the nearby Iron Horse Trail, spending afternoons at Victoria Park, or exploring the restaurants, shops, and culture of Downtown Kitchener, all just minutes from your front door. With its blend of historic charm, modern upgrades, and a prime central location, 860 Queen’s Boulevard offers a rare opportunity to own a piece of Kitchener’s classic character, refined for contemporary living. (id:62650)" +"Appliances": array:8 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" 6 => "Window Coverings" 7 => "Microwave Built-in" ] +"ArchitecturalStyle": array:1 [ 0 => "2 Level" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2025-11-07T01:00:36.338080+00:00" +"Directions": "Highland to Queens Blvd." +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:3 [ 0 => "Heat Pump" 1 => "Forced air" 2 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1915825" +"ListOfficeKey": "290392" +"LivingAreaUnits": "square feet" +"PhotosChangeTimestamp": "2025-11-06T13:59:56Z" +"PhotosCount": 40 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2025-11-16T21:32:03Z" +"Stories": "2.0" +"StreetName": "QUEENS" +"StreetNumber": "860" +"StreetSuffix": "Boulevard" +"SubdivisionName": "325 - Forest Hill" +"TaxAnnualAmount": "3730.81" +"VirtualTourURLUnbranded": "https://youriguide.com/860_queen_s_blvd_kitchener_on/" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:11 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29074179/860-queens-boulevard-kitchener" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"ZoningDescription": "RES-4" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 40.0 +"AboveGradeFinishedArea": 1230 +"OriginalEntryTimestamp": "2025-11-06T13:59:56.23Z" +"MapCoordinateVerifiedYN": true +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"Media": array:40 [ 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] ] +"DaysOnMarket": 232 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29074179')" +"ID": "940575" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24525 +post_id: "935596" +post_author: 1 +"ListingKey": "29072908" +"ListingId": "40785770" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-27T23:25:21Z" +"RFModificationTimestamp": "2025-11-27T23:30:31Z" +"ListPrice": 0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1341.0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L5S7" +"UnparsedAddress": "425 KEATS Way Unit# 4, Waterloo, Ontario N2L5S7" +"Coordinates": array:2 [ 0 => -80.55611724 1 => 43.45812598 ] +"Latitude": 43.45812598 +"Longitude": -80.55611724 +"YearBuilt": 1977 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to the best opportunity on Keats Way! This spacious condo townhome has been beautifully updated and now features a newly renovated kitchen complete with brand-new major appliances—the perfect blend of modern style and everyday functionality. Inside, you’ll find bright, open-concept living areas, generous bedrooms, and a smart, functional layout ideal for families or young professionals. The move-in ready space offers unbeatable value in one of Waterloo’s most convenient locations—just minutes from the University of Waterloo, Wilfrid Laurier University, shopping, transit, and Uptown Waterloo. Freshly updated, perfectly located, and ready to impress. This one checks all the boxes! (id:62650)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" 6 => "Microwave Built-in" ] +"ArchitecturalStyle": array:1 [ 0 => "3 Level" ] +"AssociationFee": "595" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:4 [ 0 => "Property Management" 1 => "Water" 2 => "Insurance" 3 => "Parking" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Partial" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2025-11-06T01:57:18.130897+00:00" +"Directions": "Fischer-Hallman to Keats Way." +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2012789" +"ListOfficeKey": "76836" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Paved driveway" 1 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:2 [ 0 => "Attached Garage" 1 => "None" ] +"PhotosChangeTimestamp": "2025-11-27T23:12:02Z" +"PhotosCount": 44 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2025-11-27T23:12:02Z" +"Stories": "3.0" +"StreetName": "KEATS" +"StreetNumber": "425" +"StreetSuffix": "Way" +"SubdivisionName": "417 - Beechwood/University" +"VirtualTourURLUnbranded": "https://youriguide.com/n13hd_4_425_keats_way_waterloo_on/" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:10 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29072908/425-keats-way-unit-4-waterloo" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "Row / Townhouse" ] +"CoListAgentKey": "1744879" +"CommonInterest": "Condo/Strata" +"CoListOfficeKey": "76836" +"GeocodeManualYN": true +"TotalActualRent": 2700 +"ZoningDescription": "MD" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"LeaseAmountFrequency": "Monthly" +"AboveGradeFinishedArea": 1341 +"OriginalEntryTimestamp": "2025-11-05T23:32:28.93Z" +"MapCoordinateVerifiedYN": true +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Measurement follows RMS" +"Media": array:44 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] ] +"DaysOnMarket": 232 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29072908')" +"ID": "935596" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24521 +post_id: "937488" +post_author: 1 +"ListingKey": "29074623" +"ListingId": "40785766" +"PropertyType": "Other" +"PropertySubType": "Hospitality" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T17:35:42Z" +"RFModificationTimestamp": "2026-06-02T18:13:17Z" +"ListPrice": 2999999.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 7140.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8N3Y6" +"UnparsedAddress": "33 BOWEN Street, Hamilton, Ontario L8N3Y6" +"Coordinates": array:2 [ 0 => -79.866158 1 => 43.253923 ] +"Latitude": 43.253923 +"Longitude": -79.866158 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 33 Bowen Street, a historic gem in downtown Hamilton's vibrant restaurant and nightlife scene for decades. Originally built as a carriage house in the 1800's and later converted into a hotel in the early 1900's, this property offers over 7,100 sqft. of prime commercial space. Recent updates include modernized washrooms, refreshed upholstery, and modernized interior decoration. The upstairs portion features an immaculate bar imported from Dublin, perfect for hosting events. Seize the opportunity to make your mark on this iconic building and continue its legacy. (id:62650)" +"AssociationFeeFrequency": "Monthly" +"Basement": array:1 [ 0 => "None" ] +"BuildingAreaUnits": "square feet" +"CommunityFeatures": array:1 [ 0 => "High Traffic Area" ] +"CreationDate": "2025-11-06T17:25:09.025769+00:00" +"Directions": "Main Street to Bowen" +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1525198" +"ListOfficeKey": "284641" +"LivingAreaUnits": "square feet" +"PhotosChangeTimestamp": "2025-11-06T15:51:50Z" +"PhotosCount": 13 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T17:01:44Z" +"Stories": "1.0" +"StreetName": "BOWEN" +"StreetNumber": "33" +"StreetSuffix": "Street" +"SubdivisionName": "142 - Corktown" +"TaxAnnualAmount": "26000" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29074623/33-bowen-street-hamilton" +"StructureType": array:1 [ 0 => "Recreational" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "D3" +"FrontageLengthNumeric": 34.0 +"OriginalEntryTimestamp": "2025-11-06T15:49:03.51Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1064336" +"ListOfficeNationalAssociationId": "1344650" +"Media": array:13 [ 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] ] +"DaysOnMarket": 232 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29074623')" +"ID": "937488" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24497 +post_id: "952177" +post_author: 1 +"ListingKey": "29088847" +"ListingId": "40785744" +"PropertyType": "Residential Income" +"PropertySubType": "Multi-family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-07T23:40:49Z" +"RFModificationTimestamp": "2026-06-07T23:56:12Z" +"ListPrice": 949000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 7.0 +"LotSizeArea": 0.204 +"LivingArea": 3393.0 +"BuildingAreaTotal": 0 +"City": "Brantford" +"PostalCode": "N3R1E9" +"UnparsedAddress": "26 TERRACE HILL Street, Brantford, Ontario N3R1E9" +"Coordinates": array:2 [ 0 => -80.26464703 1 => 43.14898338 ] +"Latitude": 43.14898338 +"Longitude": -80.26464703 +"YearBuilt": 1905 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 26 Terrace Hill Street! This property boasts 3 separate units, presenting an incredible opportunity for homeowners or investors alike. The main house features 3 bedrooms, 2 full baths, and over 2,000 sq ft of livable space, blending charm with modern conveniences. The property has been extremely well cared for and is ready for its new family. Parking is available for up to 6 vehicles depending on size of vehicle, providing ample space for residents and guests. Additionally, there are 2 bonus rental units detached from the main house. Each unit offers 2 bedrooms, 1 bathroom, separate entrances, separate laundry facilities, separate heating and cooling systems, and separate hydro meters. With a total of 3 rental units, this property is ideal for city investment or could serve as a primary residence with two mortgage helpers built-in. What an incredible opportunity for buyers looking to maximize their investment! Located minutes away from all amenities, schools, parks, and highway access, this property truly offers convenience and potential. (id:62783)" +"Appliances": array:2 [ 0 => "Water softener" 1 => "Microwave Built-in" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"Cooling": array:2 [ 0 => "Central air conditioning" 1 => "Wall unit" ] +"CreationDate": "2025-11-11T05:22:42.901574+00:00" +"Directions": "Brant Ave > West Street > Terrance Hill Street" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"Fencing": array:1 [ 0 => "Fence" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:3 [ 0 => "Baseboard heaters" 1 => "Forced air" 2 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2015022" +"ListOfficeKey": "289709" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Paved driveway" 1 => "Private Yard" ] +"LotSizeDimensions": "0.204" +"NumberOfUnitsTotal": "3" +"ParkingFeatures": array:1 [ 0 => "Detached Garage" ] +"PhotosChangeTimestamp": "2025-11-10T21:41:52Z" +"PhotosCount": 47 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-07T23:33:54Z" +"Stories": "2.0" +"StreetName": "TERRACE HILL" +"StreetNumber": "26" +"StreetSuffix": "Street" +"SubdivisionName": "2041 - Terrace Hill" +"TaxAnnualAmount": "4609" +"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=wDckI3qHXZQ" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29088847/26-terrace-hill-street-brantford" +"ParkingTotal": 6 +"StructureType": array:1 [ 0 => "Triplex" ] +"CoListAgentKey": "2030111" +"CommonInterest": "Freehold" +"CoListOfficeKey": "289709" +"GeocodeManualYN": true +"ZoningDescription": "RC" +"FrontageLengthNumeric": 60.0 +"AboveGradeFinishedArea": 3393 +"OriginalEntryTimestamp": "2025-11-10T21:38:52.98Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1296515" +"ListOfficeNationalAssociationId": "1380244" +"CoListAgentNationalAssociationId": "1307787" +"CoListOfficeNationalAssociationId": "1380244" +"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": 227 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29088847')" +"ID": "952177" } ] +success: true +page_size: 12 +page_count: 17280 +count: 207356 +after_key: "" } "RF Response Time" => "0.28 seconds" ] ]